| failover configuration [message #67666] |
Sun, 19 December 2004 19:59 |
Koushik Chandra
Messages: 3
Registered: December 2004
|
Junior Member |
|
|
For failover configuration with Oracle 9i I have used
two database in same m/c. and the listner.ora is as following :-
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC3))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tcs052640)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:oracleora_home)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = D:oracleora_home)
(SID_NAME = SPACE)
)
(SID_DESC =
(ORACLE_HOME = D:oracleora_home)
(SID_NAME = UIIVS2)
)
)
And TNS Entry which i have used in a m/c. which has only oracle client is like the following :-
PROD.WORLD =
(DESCRIPTION_LIST =
(FAILOVER = TRUE)
(LOAD_BALANCE = FALSE)
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = TCS052640)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = SPACE.WORLD)
(SERVER = DEDICATED)
)
)
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = TCS052640)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = UIIVS2.WORLD)
(SERVER = DEDICATED)
)
)
)
Now i am connected to SPACE from that m/c. which has only Oracle 9i client and then shutdown the database SPACE, but
after shutting down client is not dynamically connecting to the database UIIVS2,though I have written "FAILOVER = TRUE" in tnsnames.ora.
It is giving error like :-
ORA-12571: TNS:packet writer failure
ORA-03114: not connected to ORACLE
& when I am attempting test connection it is giving error
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
What more I have to do for connecting dynamically UIIVS2 when SPACE is down.
If the database located in separated m/c. is there anything more need to do.
Thanks in advance.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
