OraFAQ Forum: Networking and Gateways » Configuring instance failover on Oracle 8i

Home » RDBMS Server » Networking and Gateways » Configuring instance failover on Oracle 8i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	Microsoft ODBC for Oracle -- Porblem
Next Topic:	connecting database through internet

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 21:42:09 CDT 2025