Establish Connection with sqlplus and then create pfile from spfile.
[oracle@primary ~]$ sqlplus / as sysdba
SQL> create spfile from pfile='/home/oracle/pfile.ora';
Edit pfile.
[oracle@primary ~]$ vim /home/oracle/pfile.ora
Delete LISTENER entry from pfile.
*.local_listener
and re-create spfile from pfile and start database.
[oracle@primary ~]$ sqlplus / as sysdba
SQL> create spfile from pfile='/home/oracle/pfile.ora';
Edit pfile.
[oracle@primary ~]$ vim /home/oracle/pfile.ora
Delete LISTENER entry from pfile.
*.local_listener
and re-create spfile from pfile and start database.
No comments:
Post a Comment