DBACOCKPIT - DB Connection to remote DB gives ORA-12154

[pr_srinivas]

Dear Experts

In Our Landscape we have 2 installations.

P30 - Netweaver 2004s (ABAP) with SP12

P45 - Netweaver 2004s (Java-Usage Type EP) with SP12

P30 and P45 both databases are of Oracle version 10.2.0.2.0

In Txn : DBACOCKPIT" of P30 system we want to monitor P45 System also.

The Steps we followed as follows.

01)On P30 System - we updated tnanames.ora file with P45 database entries.

02)from P30 system, tnsping P45 is successfull as follows

==========================================================================================

sempcs2c:orap30> tnsping P45

TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.2.0 -

Production on 30-JAN-2008 21:14:07

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/oracle/P30/102_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =

(COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = epspcs2c) (PORT

= P45) (GLOBAL_NAME = P45.WORLD)))

OK (0 msec)

sempcs2c:orap30>

==========================================================================================

3) From P30 system theu SQL i could able to login into P45 system..it

works. as follows

==========================================================================================

sempcs2c:orap30>

sempcs2c:orap30> sqlplus /nolog;

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Jan 30 21:18:11 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> connect SYSTEM/<PASSWORD>@P45

Connected.

SQL>

SQL> select instance_name from v$instance;

INSTANCE_NAME

-

---

P45

SQL>

SQL>

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release

10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

sempcs2c:orap30>

==========================================================================================

Here we concluded that all oracle connections and tnanames.ora are in

place to connect to remote database.

04) We logged into P30 ABAP System using SAPGUI

Txn : DBACOCKPIT

Clicked - DB Connections TAB

In right pane of the entry - Clicked " Add DBCON Entry

In Database Connection Screean

-

---

Connection Name : P45DB

Database System : Oracle

Connection Maximum : 5

Connection Optimum : 5

Selected Check Box Permanent Connection

User Name : SYSTEM

Password : <password>

Confirm : <password>

In Connection Parameter Box

-

---

TNS Name : P45.WORLD

Character Set : <empty - left blank>

National Character Set : <empty - left blank>

Saved Entry

==========================================================================================

After saving entry - when i test in the same screen - it gives error.

as below

==========================================================================================

-- ERROR Database connection P45DB: SQL error 12154 ORA-12154: TNS:couldnot resolve the

connect identifier specified

==========================================================================================

what else i have to do ??

Thanks in Advance

Regards

[pr_srinivas · Accepted solution]

Make entries in

/sapmnt/<SID>/profile/oracle/tnsnames.ora

/oracle/<SID>102_64/network/admin/tnsnames.ora

The tnsnames.ora under Oracle directory used by ora<SID> user

and

The tnsnames.ora under /sapmnt will be used by <SID>adm when you are try to configure

DBACOCKPUIT from SAPGUI

tnsnames entries lookm like

===========

UNNATI.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = unnati2)

(PORT = 1521)

)

)

(CONNECT_DATA =

(SID = UNNATI)

(SERVICE = UNNATI)

(GLOBAL_NAME = UNNATI.WORLD)

)

)

=================================

best copy the entries from target database tnsnames.ora file to system where you are cofiguring.

Hope it may helps you out

Rgds

[Former Member · Accepted solution]

Thank You!!

That worked. I was able to set up the DB connection.

[Former Member]

What was your resolution to this? I am getting the same error from SAP. although I can connect to the DB from SQL.

I tried the above suggestions, but I still get the same error in SAP.

[Thomas_Berger]

Hey,

change in the dbacockit the entry

Connection Name : P45DB

Database System : Oracle

Connection Maximum : 5

Connection Optimum : 5

to

Connection Name : P45

Database System : Oracle

Connection Maximum : 5

Connection Optimum : 5

Your error message says : ERROR Database connection P45DB

in your tnsnames.ora the Database Name is PORT= P45

thomas