Home » RDBMS Server » Networking and Gateways » Cconnection problem from XP Clients
- Cconnection problem from XP Clients [message #170932] Sat, 06 May 2006 08:17 Go to next message
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

Report message to a moderator

- icon6.gif  Re: Cconnection problem from XP Clients [message #171161 is a reply to message #170932] Mon, 08 May 2006 15:51 Go to previous message
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.

Report message to a moderator

Previous Topic: How to configure listener.ora
Next Topic: MS SQL-Server not working
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 03 05:16:19 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.