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