Find the Location of Oracle SPFILE



Share this article :

Login to the SQL*PLUS and execute below query command,

SQL> show parameter spfile

NAME         TYPE        VALUE
------------ ----------- ------------------------------
spfile       string      /oracle/SID/112_64/dbs/spfileSID.ora

Related posts

Change User Password in Oracle
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
Where to Find Oracle Listener Port & How to Change It
ORA-12518: TNS:listener could not hand off client connection
© 2017 ITsiti. All Rights Reserved
Powered by KEEM