| 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!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
