-
HI,
We have recently installed Oracle817 on VMS. When I try to connect to the database using sqlplus or oracle forms, I get 'ORA-12545:TNS:name lookup failure' error. Entries in tnsnames.ora and listener.ora are ok. ping and tnsping work fine. However, if I include an entry for this server with the IP address in the /etc/hosts file on the local client machine, it works fine. But there are no entries in this hosts file for other servers (we have 3 servers) which work fine. I would appreciate your help.
These are the listener.ora and tnsnames.ora file entries:
listener.ora
========
LISTENER=
(ADDRESS_LIST=
(ADDRESS=(COMMUNITY=TCP.WORLD)(PROTOCOL=tcp)(HOST= ... )(PORT=1526))
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=NEWFLT)
(PROGRAM = ORACLE$DISK:[ORACLE8.ORACLE817.network.admin]orasrv_netv2_NEWFLT.com)
(prespawn_max=20)
(prespawn_list=
(prespawn_desc=
(protocol=tcp)
(pool_size=15)
(TIMEOUT = 5)
)
)
)
)
tnsnames.ora
=========
RF1.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(HOST = ... )(PORT = 1526))
)
(CONNECT_DATA = (SID = NEWFLT))
)
==
Since the sql connection was slow, I have included prespawn settings in the listener.ora file.
SPN
NOTE: Edited out the IP address for security reasons.
Sam
[Edited by sambavan on 12-25-2001 at 09:37 PM]
-
What is the service name of your instance. In the tnsnames.ora file, you might want to consider specifying the service_name instead of the SID_NAME. Can you make a client connection to the server using sqlplus
Code:
sqlplus username/password@rf1.world
Regarding the hostname recognetion. consult with your system adminstrator(s) about the DNS looks up configureation and etc.
How did you come to a conclusion that the sqlnet is slow?
To make the regular connection try
Code:
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=NEWFLT)
(PROGRAM = ORACLE$DISK:[ORACLE8.ORACLE817.network.admin]orasrv_netv2_NEWFLT.com)
(prespawn_max=20)
(prespawn_list=
(prespawn_desc=
(protocol=tcp)
(pool_size=15)
(TIMEOUT = 5)
)
)
)
(SID_DESC=
(GLOBAL_DBNAME = ... )
(ORACLE_HOME = ...)
(SID_NAME=NEWFLT)
)
)
tnsname.ora
RF1.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(HOST = ... )(PORT = 1526))
)
(CONNECT_DATA = (SERVICE_NAME = NEWFLT))
)
RF2.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ... )(PORT = 1526))
)
(CONNECT_DATA = (SERVICE_NAME = NEWFLT))
)
Also Could you post the sqlnet.ora file also.
Thanx
Sam
Life is a journey, not a destination!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|