Forms not connecting to Database [message #84177] |
Tue, 10 February 2004 08:45 |
Brinda
Messages: 3 Registered: February 2004
|
Junior Member |
|
|
I recently loaded the oracle9i and forms6i. My SQL is getting connected to database but forms could not be connected. Getting ORA-12154 error.
Here is my sqlnet.log,
Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleoracle9i)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=oracle9i)(CID=(PROGRAM=d:oracleorapersonalbinORACLE.EXE)(HOST=SPARAMAS-W2K02)(USER=SYSTEM))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 09-FEB-2004 20:03:44
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12638
TNS-12638: Credential retrieval failed
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
This is TNSNAMES.ORA,
# TNSNAMES.ORA Network Configuration File: D:Oracleorapersonalnetworkadmintnsnames.ora
# Generated by Oracle configuration tools.
ORACLE9I.AMER.CISCO.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sparamas-w2k02)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle9i)
)
)
EXTPROC_CONNECTION_DATA.AMER.CISCO.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
This is SQLNET.ORA,
# SQLNET.ORA Network Configuration File: D:Oracleorapersonalnetworkadminsqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = amer.cisco.com
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
Pls help me to solve this problem.I have got exam so pls help me asap.
|
|
|
|