Database Networking (MOSC)

MOSC Banner

10g Clinet on (WIn2k8R2) bot able to connect to database.

edited Jun 3, 2011 3:11AM in Database Networking (MOSC) 5 commentsAnswered
 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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center