Home » RDBMS Server » Networking and Gateways » Oracle Net during data guard swithover (Oracle 10g, Windows)
Oracle Net during data guard swithover [message #362513] Tue, 02 December 2008 09:25
fcosaucedo
Messages: 1
Registered: December 2008
Location: Algeciras (Cadiz, Spain)
Junior Member
I'm testing Oracle 10g data guard procedures and I've a doubt that I can't solve with official manuals. Can I use TAF (Transparent Application Failover) in a switchover?
During a failover my tnsnames configuration works properly and a client can connect to the standby db (working as primary), but for the duration of a switchover Oracle gets me an “ORA-01033 : ORACLE initialization or shutdown in progress” error. I think is because the instance (primary working as standby) is mounted and the listener is working, I can’t stop the listener because I need it to apply the logs.
This is my tnsnames configuration:

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

DES =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))
(FAILOVER = TRUE)
)
(CONNECT_DATA =
(SERVICE_NAME = des)
)
)

Thanks in advance!
Previous Topic: How can we change the Oracle Port
Next Topic: Unable Connect Linux Db using WinOracle Client
Goto Forum:
  


Current Time: Fri Dec 09 04:22:20 CST 2016

Total time taken to generate the page: 0.06457 seconds