Many time we face the issue while starting the Oracle Instance and to troubleshoot the issue, its always better to know the “pfiles” path, in Oracle 9G all the characteristics of the Instance are established by parameters specified in the spfiles but in 10G,11G the parameters defined in the pfiles, to check the pfile location, refer to the following steps.
Login into the server as a Oracle super user or as a root user and then switch to Oracle super user.
root@192.168.100.101
or
oracle@192.168.100.101
Once you logged into the server use the command to enter into the Oracle command line.
sqlplus / as sysdba
Run the following command
show parameter pfile;
As per above command the pfile path is as follows
/u01/app/oracle/product/11.2.0/xe/dbs/spfileXE.ora
For more updates and troubleshooting guide, you can subscribe our mailing list and purchase our Database Management Service
