ORA-12514: could not resolve service name

From: Gurmukh <sidhu_gurmukh_at_yahoo.com>
Date: 24 Jan 2003 02:48:03 -0800
Message-ID: <acfeeab8.0301240248.7ba6bf9e_at_posting.google.com>


hi,

working with windows 2000 professional,9ias release2. 1. we installed 9ias infrastructure first,which installed database as well.
2. then we installed 9ias,which again installed database(same machine).
3. when we try to connect to sql prompt via scott/tiger(local machine) or system/manager of infrastructure database we are able to connect. 4. BUT when we try to connect to sql prompt via scott/tiger or system/manager of

   9ias database we are not able to connect.it is then that we get the error

   ORA-12560 :TNS protocol adapter error. 5. oracle home is set to 9ias directory,but even if we change it to infrastructure directory ,doesn't make a difference. 6. when i try to load a psp file(usind loadpsp utility) i get same error ora-12560 at dos prompt.
7. in the registry there are two homes home0/home1.home0 has oracle_sid set to iasdb but home1(9ias_portal) doesn;t have a oracle_sid entry.
8. oracle_sid in registry is set to iasdb.i again set it to iasdb from dos prompt then it connects but to infrastructure database.due to which i'm not able to load and execute pl/sql forms.

one more thing there are three differnt errors 1. if i don't give service name

   then ORA-12560:tns protocol adapter error 2. if i put service name as iasdb(it is iasdb.sgm ,sgm is domain,correctly specified in sqlnet.ora)

   then ORA-12514:could not resolve service name 3. if i put service as sgm.gurmukh:1521:iasdb

   then ORA-06401 : NETCMN:invalid driver designator

and only infrastructure directory has
tnsnames.ora,listener.ora,sqlnet.ora,9ias_portal directory it only has sqlnet.ora.i have been working on this for some time now,but not able to resolve it some how.can u tell us where we are going wrong.



tnsnames.ora looks like:
IASDB.SGM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gurmukh)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = iasdb.sgm.gurmukh)
    )
  )

listener.ora looks like:
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\ora9ias)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = iasdb.sgm.gurmukh)
(ORACLE_HOME = F:\ora9ias)
(SID_NAME = iasdb)

    )
  )

sqlnet.ora(in both infrastructure & 9ias portal) NAMES.DEFAULT_DOMAIN = sgm

SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)



i hope this helps.

thanks
regards
Gurmukh. Received on Fri Jan 24 2003 - 11:48:03 CET

Original text of this message