Home » RDBMS Server » Networking and Gateways » configuring tnsnames.ora (Oracle server in Linux fedora version oracle 10g R2 Oracle 11g client in win xp)
configuring tnsnames.ora [message #352224] Mon, 06 October 2008 12:41
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member


Here below is the listener.ora on database server which is on linux fedora

listener.ora
------------


solar_server=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=227.127.38.61)(PORT=1616))
))

SID_LIST_solar_server=
(SID_LIST=
(SID_DESC=
(ORACLE_HOME=/opt/oracle/10gR2)
(SID_NAME=solar)
)
)

Listener started with below command

lsnrctl start solar_server


LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-OCT-2008 14:09:34

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /opt/oracle/10gR2/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /opt/oracle/10gR2/network/admin/listener.ora
Log messages written to /opt/oracle/10gR2/network/log/solar_server.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=227.127.38.61)(PORT=1616)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=227.127.38.61)(PORT=1616)))
STATUS of the LISTENER
------------------------
Alias solar_server
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 06-OCT-2008 14:09:34
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/10gR2/network/admin/listener.ora
Listener Log File /opt/oracle/10gR2/network/log/solar_server.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=227.127.38.61)(PORT=1616)))
Services Summary...
Service "solar" has 1 instance(s).
Instance "solar", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


Tnsnames.ora
------------

Here are the tnsnames.ora in oracle server and client server. but able to connect server with same tns entries but not the client.

Able to tnsping the alias name in server machine.
Not able to tnsping the alias name in client machine.



solar_Dev =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(HOST = 227.127.38.61)(PORT = 1616)
)
)
(CONNECT_DATA =
(SERVICE_NAME= solar)
(SERVER = DEDICATED)
)
)

When tried to tnsping with aliasname in client machine. i encountered with below error.

tnsping solar_dev



TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 06-OCT-2
008 09:45:29

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:
C:\app\product\11.1.0\client_1\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

Sqlnet.ora in client machine
----------------------------



SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

NAMES.DEFAULT_DOMAIN = inhyd.net


Request to let me know where i am wrong.


Thanks in advance
Previous Topic: Oracle Internet Directory and ODBC connections....
Next Topic: TNS-03505: Failed to resolve name
Goto Forum:
  


Current Time: Thu Mar 28 16:04:45 CDT 2024