| Cconnection problem from XP Clients [message #170932] |
Sat, 06 May 2006 08:17  |
buffolo
Messages: 2
Registered: May 2006
|
Junior Member |
|
|
I am running 8.0.5 server on win 2003 server. The database is running and I can connect on the server macjoine itself through the listner configuration. However I canot connect from xp clients which runs 8.0.5 clients. i get the error
Connecting....
The test did not succeed.
ORA-12224: TNS:no listener
There may be an error in the fields entered
or the server may not be ready for a connection.
You can check the server and retry, or continue.
All yhese worked for the last o1 year till someone installed an ADSL modem on the server.
Can someone help me on this.
Thanks
Buffolo
|
|
|
|
 Re: Cconnection problem from XP Clients [message #171161 is a reply to message #170932] |
Mon, 08 May 2006 15:51  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Do you have Oracle client software installed on the xp? If so, your tnsnames.ora file on the client (C:\oracle\product\8.05 (or version number)\client\NETWORK\ADMIN\tnsnames.ora))
should look similar to:
# tnsnames.ora Network Configuration File:
#C:\oracle\product\10.2.0\client_2\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
<your service name> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <your host.your domain>)(PORT = <your listener port, default is 1521>))
(CONNECT_DATA =
(SID = <your sid>)
)
)
Your listener.ora should look like:
# listener.ora Network Configuration File:
# C:\Oracle\product\10.1.0\Client_2\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_<your sid> =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = <your sid>)
(ORACLE_HOME = <directory of $ORACLE_HOME on host>)
(SID_NAME = <your sid>)
)
Then do a lsnrctl reload on host.
Hope this helps.
Neil.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
