ORA-12154 error?
395851Jun 7 2003 — edited Jun 15 2003Hi,
I can open the db under username=system and pwd=right.
However, I got ORA-12154 error when I try to connect to db from 9i report builder.
Following is those files.
1). entry in tnsnames.ora
ORACLEDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = work-a3yo0i81mk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OracleDB)
)
)
2). sqlnet.ora
# SQLNET.ORA Network Configuration File: D:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
3). sqlnet.log
Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleoracledb)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=oracledb)(CID=(PROGRAM=d:\oracle\ora92\bin\ORACLE.EXE)(HOST=WORK-A3YO0I81MK)(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: 07-JUN-2003 00:20:16
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
Thanks very much in advance for any help.
Charles