Home » RDBMS Server » Networking and Gateways » FAILOVER_MODE causes ORA-01012 and ORA-24313
FAILOVER_MODE causes ORA-01012 and ORA-24313 [message #254254] Thu, 26 July 2007 05:29 Go to next message
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

Re: FAILOVER_MODE causes ORA-01012 and ORA-24313 [message #254395 is a reply to message #254254] Thu, 26 July 2007 11:52 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Check this for TAF.

http://www.akadia.com/services/ora_net8_taf.html
Re: FAILOVER_MODE causes ORA-01012 and ORA-24313 [message #254623 is a reply to message #254395] Fri, 27 July 2007 05:14 Go to previous message
joao.prates
Messages: 2
Registered: July 2007
Location: Portugal
Junior Member

Thanks, but that link does not address stand-alone configurations.

I'm only using this for auto-reconnect.

Any other ideas?
Previous Topic: start listener from two different oracle homes
Next Topic: lsnrctl status Gives TNS-01150 and NL-00303
Goto Forum:
  


Current Time: Fri Dec 09 17:07:20 CST 2016

Total time taken to generate the page: 0.13405 seconds