| Configuring instance failover on Oracle 8i [message #66802] |
Sat, 18 January 2003 01:23  |
Nester
Messages: 2
Registered: January 2003
|
Junior Member |
|
|
Hi,
I am trying to configure Oracle database instance failover .
THe scenario is as follows :
I have 2 databases running on 2 Solaris machines ,I.P Address being
xx.xx.xx.187 and xx.xx.xx.80 and running a database instance called training.User nester Pasword Nester
At the client side (xx.xx.xxx.121), I have configured
the tnsnames.ora file using netasst
The output of the tnsnames.ora file was as follows
FAILOVER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.187)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.80)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = training)
)
)
--------
I have also tried configuring it in this manner
FAILOVER =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE= OFF)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.187)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xxx.80)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = training)
(SRVR = DEDICATED)
(FAILOVER_MODE =
(TYPE = SESSION)
(METHOD = BASIC)
(RETRIES = 15)
(DELAY = 1)
)
)
)
Also I have deleted the global_dbname parameter in listenr.ora of both machines ...the listener file looks like this :
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bttest)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /export/home/oracle/OraHome)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = /export/home/oracle/OraHome)
(SID_NAME = training)
)
)
THe problem:
In both cases when I try to connect via the application/sqlprompt using sqlplus nester@failover/nester
I successfully connect to the first database
However when i try bringing the first database down: I get a error like this:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
i can however connect to the second database through my client using a different connect descriptor.
Similarly if i try changing the order of the database ...i.e put xx.80 on top .I connect to xx.80 but cannot connect to xx.187 .
The error changes to
ORA-01034: ORACLE not available
Any solution?
Regards
Nester
|
|
|
|
| Re: Configuring instance failover on Oracle 8i [message #66827 is a reply to message #66802] |
Thu, 23 January 2003 07:13  |
Rajendra
Messages: 23
Registered: September 2000
|
Junior Member |
|
|
Your Tnsnames.ora must look like this.
Testing =
(DESCRIPTION =
(FAILOVER=ON)
(LOAD_BALANCE=ON)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Testing)
(FAILOVER_MODE=
(type=select)
(method=basic))
)
)
listeners_testing =
(description=
(address_list=
(address=(protocol=tcp)(host=db1)(port=1521))
(address=(protocol=tcp)(host=db2)(port=1521))))
There is no need of listener.ora file if u are using default listener.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
