| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
