在oracle10g上创建spfile

在oracle10g上创建spfile

 

SQL> startup pfile='/oracle/product/10.2.0/db_1/dbs/initorcl.ora'

ORACLE instance started.

 

Total System Global Area  100663296 bytes

Fixed Size                  1217908 bytes

Variable Size              92277388 bytes

Database Buffers            4194304 bytes

Redo Buffers                2973696 bytes

Database mounted.

Database opened.

 

SQL> create spfile from pfile='/oracle/product/10.2.0/db_1/dbs/initorcl.ora'

  2  /

 

File created.

 

[oracle@MDT dbs]$ pwd

/oracle/product/10.2.0/db_1/dbs

[oracle@MDT dbs]$ ls

hc_orcl.dat  initdw.ora  init.ora  initorcl.ora  lkORCL  orapworcl  snapcf_orcl.f  spfileorcl.ora