create pfile or spfile from memory

读取内存中参数，生成spfile或者pfile。

SQL>
SQL> create pfile = '/home/oracle/initorcl.ora' from memory;

File created.

SQL>
SQL>
SQL> host ls -l /home/oracle/initorcl.ora
-rw-r--r-- 1 oracle oinstall 5729 Jan 21 02:05 /home/oracle/initorcl.ora

SQL>
SQL>
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup pfile = '/home/oracle/initorcl.ora'
ORACLE instance started.

Total System Global Area 1707446272 bytes
Fixed Size                  1336988 bytes
Variable Size             973080932 bytes
Database Buffers          721420288 bytes
Redo Buffers               11608064 bytes
Database mounted.
Database opened.
SQL>
SQL> create spfile from memory;

File created.

SQL>