| ORA-12541:TNS: no listener When connecting to Server in another city [message #137116] |
Tue, 13 September 2005 06:21  |
genialsenthil
Messages: 26
Registered: June 2005
Location: Chennai
|
Junior Member |
|
|
Hi,
I have configured Oracle 9i service in static Ip. My oracle server is in one city and static Ip is activated for that system. I have configured sucessfully local IP Net configuration. I need to configure it in Some other city thru internet. I have installed Oracle 9i in those machine. I have configured the Net Configuration and also Listener Configuration. I can able to ping the sid from dos prompt using "tnsping Databasename". I am not able to connect with database using Net configuration and as well as sqlplus. When i am attempting to connect to the database the "ORA-12541:TNS: no listener" error occurs in 'Net Configuration' as well as in 'SqlPlus'. My listener configuration and Net configuration is as follows....
# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
UDIDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 202.11.74.74)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Extremedb)
)
)
# LISTENER.ORA Network Configuration File: d:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = system7)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = Extremedb)
(ORACLE_HOME = d:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = Extremedb)
(SID_NAME = Extremedb)
)
)
Pls help me how to resolve this . I thank you in advance. Let me know solution as quick as possible...
Regards
Senthil Kumar
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
