EASY fix.
Instead of spfile, start your database from pfile, and if the database starts then create a new spfile from it.
Otherwise remove the local_listener parameter from the pfile and spfile and try starting it.
$ cd $ORACLE_HOME/dbs
$ ls -rt
$ vi initdb11g.ora
and remove
*.local_listener='db11g'
$ vi spfiledb11g.ora
and remove
*.local_listener='db11g'
$ sqlplus / as sysdba
SQL> startup;
ORACLE instance started.
Total System Global Area 830930944 bytes
Fixed Size 2217912 bytes
Variable Size 641730632 bytes
Database Buffers 180355072 bytes
Redo Buffers 6627328 bytes
Database mounted.
Database opened.
SQL> select name from v$database;
NAME
---------
DB11G
Wonders!!!!!
Thanks for update.
ReplyDeleteit works !!
ReplyDeleteThanks for your suggestion.. Its really works and helpful to us
ReplyDelete