1 ???????????sid ??db_name

????sid='hsj'

????db_name='hsj'

????2?????????????env

ORACLE_BASE=/u01/app
ORACLE_HOME=$ORACLE_BASE/oracle
ORACLE_SID=hsj
PATH=$ORACLE_HOEM/bin:$PATH;
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export ORACLE_BASE  ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH

????3????????????????ò?????????????????

????????????????????????dba????oracle???

????sqlplus /nolog

????conn as sysdba;

????4?????????????pfile???

vi inithsj.ora
hsj.__db_cache_size=385875968
hsj.__java_pool_size=4194304
hsj.__large_pool_size=4194304
hsj.__shared_pool_size=163577856
hsj.__streams_pool_size=0
audit_file_dest='/u01/app/admin/hsj/adump'
background_dump_dest='/u01/app/admin/hsj/bdump'
compatible='10.2.0.1.0'
control_files='/u01/app/oradata/hsj/control01.ctl'??'/u01/app/oradata/hsj/control02.ctl'??'/u01/app/oradata/hsj/control03.ctl'
core_dump_dest='/u01/app/admin/hsj/cdump'
db_block_size=8192
db_domain=''
db_file_multiblock_read_count=16
db_name='hsj'
db_recovery_file_dest='/u01/app/flash_recovery_area'
db_recovery_file_dest_size=2147483648
dispatchers='(PROTOCOL=TCP) (SERVICE=hsjXDB)'
job_queue_processes=10
log_archive_format='%t_%s_%r.dbf'
open_cursors=300
pga_aggregate_target=187695104
processes=150
remote_login_passwordfile='EXCLUSIVE'
sga_target=563085312
undo_management='AUTO'
undo_tablespace='UNDOTBS1'
user_dump_dest='/u01/app/admin/hsj/udump'

5??????pfile???????????????

?????????$ORACLE_BASE/admin ?′???????? hsj????????????

????$ORACLE_BASE/oradate ????????????? hsj ???????? archivelog

????6??????pfile???????spfile

????startup nomount;

????create spfile from pfile;

????shutdown immediate;

????