ORA-12514: could not resolve service name
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