Oracle Database Discussions

Hi All,

This is very urgent. Kindly look into this issue.

My Oracle Database 11g RAC running on Linux-64 OS.

I have created one services for both the node. Through srvctl utility i can
be able to connect through configured services. But when i connect using third party tool
such as Toad or Any other application, i got following error:

Error during database initialization process, Io exception: The Network Adapter could not establish the connection
*[ ERROR ][ 22 Apr 2010 14:59:37,832] [ Server Manager ] : Server Initialization Error: Database Initialization Failed for Crestel Mediation Server.*

Can you please let me know why i'm not able to connect using that services ?

My TNSNAMES.ora file configuration in both the node is as follows:

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

LISTENERS_ARTSCCP =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db2-vip)(PORT = 1521))
)

ARTSCCP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ARTSCCP.WORLD)
)
)

ARTSCCP2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ARTSCCP.WORLD)
(INSTANCE_NAME = ARTSCCP2)
)
)

ARTSCCP1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db1-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ARTSCCP.WORLD)
(INSTANCE_NAME = ARTSCCP1)
)
)

AIRTELSERVICE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = AIRTELSERVICE.WORLD)
)
)




Listener File:

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

LISTENER_DB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db1-vip)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.30.45.20)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)


LISTENER_DB2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db2-vip)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.30.45.21)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)


Thanks in Advance.
-Yuvrajsinh Chauhan
onlyuvraj@yahoo.com

Edited by: Yuvraj on Apr 22, 2010 4:37 PM