Home » Server Options » RAC & Failsafe » takes time to connect if one of node is completely shutdown
- takes time to connect if one of node is completely shutdown [message #250771] Wed, 11 July 2007 04:38 Go to next message
nihil.somani
Messages: 3
Registered: July 2007
Junior Member
I have one sample JDBC program which connects to RAC.
If all the participating node of cluster are up then I m able to connect in some few seconds(say 2 second).
Even if instance is not running on any one of the nodes of cluster, it takes few seconds to connect.

But if single node of cluster is completely shutdown(i.e switched off) then it takes some 150 second to 250 second to connect.


Can someone assist me how to reduce this connect time.?


I guess it takes more in later case, bcoz it needs to know the status of nodes.

Report message to a moderator

- Re: takes time to connect if one of node is completely shutdown [message #250856 is a reply to message #250771] Wed, 11 July 2007 11:00 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Your Application bind to which Node?

Post the content of your tsnnames.ora and listener.ora.

Report message to a moderator

- Re: takes time to connect if one of node is completely shutdown [message #250946 is a reply to message #250856] Wed, 11 July 2007 23:30 Go to previous message
nihil.somani
Messages: 3
Registered: July 2007
Junior Member
Thanks for the reply.
I have two RAC nodes namely "centos1" and "centos2".
Pls, find tnsnames.ora and listner.ora file of both the nodes.

# listener.ora.centos2 Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora.centos2
# Generated by Oracle configuration tools.

SID_LIST_LISTENER_CENTOS2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)

LISTENER_CENTOS2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = centos2-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.238)(PORT = 1521)(IP = FIRST))
)
)

# listener.ora.centos1 Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora.centos1
# Generated by Oracle configuration tools.

SID_LIST_LISTENER_CENTOS1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)

LISTENER_CENTOS1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = centos1-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.239)(PORT = 1521)(IP = FIRST))
)
)

# tnsnames.ora.centos2 Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora.centos2
# Generated by Oracle configuration tools.

LISTENERS_ORCL =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = centos1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = centos2-vip)(PORT = 1521))
)

ORCL2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = centos2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.proactivenet.co.in)
(INSTANCE_NAME = orcl2)
)
)

ORCL1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = centos1-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.proactivenet.co.in)
(INSTANCE_NAME = orcl1)
)
)

ORCLTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = centos1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = centos2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcltest.proactivenet.co.in)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = centos1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = centos2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.proactivenet.co.in)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/n
etwork/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LISTENERS_ORCL =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = centos1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = centos2-vip)(PORT = 1521))
)

ORCL2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = centos2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.proactivenet.co.in)
(INSTANCE_NAME = orcl2)
)
)

ORCL1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = centos1-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.proactivenet.co.in)
(INSTANCE_NAME = orcl1)
)
)

ORCLTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = centos1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = centos2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcltest.proactivenet.co.in)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = centos1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = centos2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.proactivenet.co.in)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


Following is url which I m using to connect

String dbURL="jdbc:oracle:thin:@"
+"(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)" +
"(ADDRESS=(PROTOCOL=TCP)" +
"(HOST=centos1)(PORT=1521))" +
"(ADDRESS=(PROTOCOL=TCP)" +
"(HOST=centos2)(PORT=1521)))" +
"(CONNECT_DATA=(SERVICE_NAME=test)))";

Report message to a moderator

Previous Topic: Rolling upgrade ASM
Next Topic: What are instances
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 02 19:02:26 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.