10g Clinet on (WIn2k8R2) bot able to connect to database.
We installed 10g(10.2.0.4) Clinet on (WIn2k8R2) by updating oraparam.ini (Both 64 bit) Which got installed successfully.
Configured tnsnames and sqlnet.
Getting error like below.
ORA-12154: TNS:could not resolve the connect identifier specified
The connect works without alias without any problem cmd > sqlplus system/****@(Descprition.......)))
The entries are below
TNSNAMES.ORA
=================================
SID.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = SERVERNAME)
(PORT = 1531)
)
)
(CONNECT_DATA =
(SID = SID)
(GLOBAL_NAME = SID.WORLD)
)
)
=====================================
SQLNET.ORA
SQLNET.AUTHENTICATION_SERVICES = (ALL)
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
NAMES.DEFAULT_DOMAIN = ****
NAME.DEFAULT_ZONE = ****
NAMES.DIRECTORY_PATH=(TNSNAMES, LDAP, EZCONNECT, ONAMES, HOSTNAME)
Getting error like below.
ORA-12154: TNS:could not resolve the connect identifier specified
The connect works without alias without any problem cmd > sqlplus system/****@(Descprition.......)))
The entries are below
TNSNAMES.ORA
=================================
SID.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = SERVERNAME)
(PORT = 1531)
)
)
(CONNECT_DATA =
(SID = SID)
(GLOBAL_NAME = SID.WORLD)
)
)
=====================================
SQLNET.ORA
SQLNET.AUTHENTICATION_SERVICES = (ALL)
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
NAMES.DEFAULT_DOMAIN = ****
NAME.DEFAULT_ZONE = ****
NAMES.DIRECTORY_PATH=(TNSNAMES, LDAP, EZCONNECT, ONAMES, HOSTNAME)
0