Hello All,
OS : Linux 7
DB : 12c
I created a 12c Database, starting the DB with pfile. When i connected with the DB i want to verify the DB started with pfile but it showing empty value.
Where i need to do the setting to make the value reflect ? I already make the change in oratab file.
SQL> startup pfile='/app/oracle/12.1.0.2/dbs/initPMC.ora';
ORACLE instance started.
Total System Global Area 1048576000 bytes
Fixed Size 2932336 bytes
Variable Size 910164368 bytes
Database Buffers 130023424 bytes
Redo Buffers 5455872 bytes
Database mounted.
Database opened.
SQL> show parameter pfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL>