Connect time failover question(non-rac)

  • From: TESTAJ3@xxxxxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 27 Jul 2009 12:07:43 -0400

Ok so I'm finishing up with the experimentation for 11g Data guard, on solaris right now, not RAC.

Here is what I want to do but can't seem to get to work:

using tnsnames.ora, I want to put both the standby and primary database in 
a single entry to do so connect time failover, try testdg1 (its normally 
the primary), if it fails(let's assume we had to do a switchover), then 
try testdg2 on different host. 

Sounds straightforward right?  So I thought, what appears to be happening 
is since the standby is mounted, sqlnet won't return back a failure so i 
just end up with this error:

ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

Why because its trying to connect to what is now the standby but its FIRST 
in the entries for addresses, here is my tnsnames entries

     (ADDRESS = (PROTOCOL = TCP)(HOST = unixtest06)(PORT = 1526))
     (ADDRESS = (PROTOCOL = TCP)(HOST = unixtest02)(PORT = 1526))
      (SERVICE_NAME = testdg1)

primary is on unixtest02 and standby is on unixtest06,   so I put 06 first 
on purpose for testing.  But it appears sqlnet is NOT returning a failure 
just what you see above.

I got to be missing something simple here but I just don't see it.

The whole reason for this exercise is during a switchover/failover I don't 
want to have to make changes to OID/tnsnames.ora for app server to 
reconnect, if they always connect to testdg, we'd be good.

Someone please enlighten me in the error of my ways.

thanks, joe

Joe Testa, Oracle Certified Professional 
(Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.

Other related posts: