SQL> create pfile='test.ora' from spfile;
File created.
[oracle@test dbs]$ ls -ltr
합계 28
-rw-r--r-- 1 oracle oinstall 3079 5월 14 2015 init.ora
-rw-r----- 1 oracle oinstall 24 11월 11 01:00 lkORCL
-rw-r----- 1 oracle oinstall 2048 11월 14 16:58 orapworcl
-rw-r--r-- 1 oracle oinstall 1035 11월 22 11:37 initorcl.ora
-rw-r----- 1 oracle oinstall 3584 11월 22 12:19 spfileorcl.ora
-rw-rw---- 1 oracle oinstall 1544 11월 22 12:27 hc_orcl.dat
-rw-r--r-- 1 oracle oinstall 1035 11월 22 13:10 test.ora <<<< created
[oracle@test dbs]$ vi test.ora
add..
*.undo_tablespace='UNDOTBS1'
*.max_idle_time=10 <<<< add new line at the end of the file
[oracle@test dbs]$
SQL> show parameter max_idle_time
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_idle_time integer 0
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup pfile='test.ora'
LRM-00109: could not open parameter file 'test.ora'
ORA-01078: failure in processing system parameters
SQL> startup pfile=/u01/app/oracle/product/19/db_1/dbs/test.ora
ORACLE instance started.
Total System Global Area 1526723608 bytes
Fixed Size 9135128 bytes
Variable Size 939524096 bytes
Database Buffers 570425344 bytes
Redo Buffers 7639040 bytes
Database mounted.
Database opened.
SQL> show parameter max_idle_time
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_idle_time integer 10
SQL>
- Starting DB with a new file, the database has been modified, and the value is changed to 10 minutes.
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
- Starting DB without any special file
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup;
ORACLE instance started.
Total System Global Area 1526723608 bytes
Fixed Size 9135128 bytes
Variable Size 939524096 bytes
Database Buffers 570425344 bytes
Redo Buffers 7639040 bytes
Database mounted.
Database opened.
SQL>
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/product/19/db_
1/dbs/spfileorcl.ora
SQL> show parameter max_idle_time
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_idle_time integer 0
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/product/19/db_
1/dbs/spfileorcl.ora
SQL>
