Skip to Content
0
Former Member
Nov 16, 2009 at 01:25 PM

Connect to External DB failed

376 Views

Hi,

While trying to connect BI system on windows/oracle to external oracle DB, we are getting following errors,

After entering Details and on saving in DBCON,

Error: Password invalid (choose another password)

Executing Program ADBC_TEST_CONNECTION gives,

Testing a Database Connection Defined in DBCON

Could not open connection PMOORACLNT .

sql error 12.154 occured:

ORA-12154: TNS:could not resolve the connect identifier specified

dev_w1 trace:

Mon Nov 16 18:04:40 2009

B Connect to PMOORACLNT as PMOUSER with PMOUAT

C Client NLS settings:

C Connecting as PMOUSER/<pwd>@PMOUAT on connection 1 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 05CCF118 05CD46B4 05CD3F3C

C Detaching from DB Server (con_hdl=1,svchp=1FC964A8,srvhp=217D2484)

C Attaching to DB Server PMOUAT (con_hdl=1,svchp=1FC964A8,srvhp=217D2484)

C *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12154

[dboci.c 4313]

C *** ERROR => CONNECT failed with sql error '12154'

[dbsloci.c 11044]

B ***LOG BY2=> sql error 12154 performing CON [dbds#1 @ 1044] [dbds 1044 ]

B ***LOG BY0=> ORA-12154: TNS:could not resolve the connect identifier specified [dbds#1 @ 1044] [dbds 1044 ]

---

TNSNAMES.ORA Content

TD1.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = sapcpg01)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = TD1)

(GLOBAL_NAME = TD1.WORLD)

)

)

PMOUAT=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = INCHNSIRRETPMO)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = PMOUAT)

)

)

-


SQLNET.ORA file

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

SQLNET.EXPIRE_TIME = 10

DEFAULT_SDU_SIZE=32768

NAMES.DIRECTORY_PATH = (TNSNAMES)

-


I was able to ping and connect using following commands at os level,

tnsping PMOUAT

sqlplus pmouser/<pwd>@PMOUAT

Please suggest what can be done further to avoid error

Regards,

Ramesh R