Database Administration (MOSC)

MOSC Banner

ORA-12523 when doing startup after shutdown

edited Jul 28, 2012 9:14AM in Database Administration (MOSC) 12 commentsAnswered
Hi,

when I needed to change an initialization parameter not changable using ALTER SYSTEM (like utl_file_dir), I always did the following:

connect sys/...@alias as sysdba

create pfile='.....\init.ora' from spfile;

<modify init.ora, add the parameter>

shutdown immediate

create spfile from pfile='.....\init.ora'

startup

Now (11.2.0.1) I observe that I get "ORA-12523: TNS:listener could not find instance appropriate for the client connection"  when issuing startup.

The instance is registered with the listener, but is in the state UNKNOWN at the moment.

If I exit, set ORACLE_SID and do the folowing (I'm using the bequeath protocol in this case, aren't I)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center