OraFAQ Forum: Networking and Gateways » FAILOVER_MODE causes ORA-01012 and ORA-24313

Home » RDBMS Server » Networking and Gateways » FAILOVER_MODE causes ORA-01012 and ORA-24313

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FAILOVER_MODE causes ORA-01012 and ORA-24313 [message #254254]

Thu, 26 July 2007 05:29

joao.prates
Messages: 2
Registered: July 2007
Location: Portugal

Junior Member

Hi all.

I'm getting nuts with this issue, please see if you can help me:

We've added the FAILOVER_MODE clause to TNSNAMES.ORA (and also to LISTENER.ORA just in case...) to achieve auto re-connect like this

xpto =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xxx.xx)(PORT = 1529))
)
(CONNECT_DATA =
(SID = abc)
(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(RETRIES=2)(DELAY=2))
)
)

Now if I shutdown the database and try to start it up again, I get the ORA-01012 and ORA-24313 like in this demo example:

SQL> conn sys/blabla@xpto as sysdba
Connected.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORA-01012: not logged on

SQL> conn sys/blabla@xpto as sysdba
ERROR:
ORA-01012: not logged on
ERROR:
ORA-24313: user already authenticated
Warning: You are no longer connected to ORACLE.

SQL> conn sys/blabla@xpto as sysdba
ERROR:
ORA-24313: user already authenticated

SQL> exit
D:\>sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jul 25 14:55:32 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

SQL> conn sys/blabla@xpto as sysdba
ERROR:
ORA-01012: not logged on

SQL> conn sys/blabla@xpto as sysdba
ERROR:
ORA-24313: user already authenticated

I should add that we have 2 instances for 2 different databases on this host, so we don't use ORACLE_SID environment variable and we don't want to use it.

However, if I set the ORACLE_SID just to see what happens, I find that it works:

D:\>set ORACLE_SID=xpto

D:\>sqlplus sys as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jul 25 15:39:11 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter password:
Connected to an idle instance.

So, it seems the problem is listener related, since AFAIK the ORACLE_SID is used for local connections bypassing the listener.

The question is, what must I do to make it work using the listener???

Thanks,

Jo�o Prates

[Updated on: Thu, 26 July 2007 05:30]

Report message to a moderator