cancel
Showing results for 
Search instead for 
Did you mean: 

DBACOCKPIT - DB Connection to remote DB gives ORA-12154

pr_srinivas
Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

stefan_koehler
Active Contributor
0 Kudos

Hello,

as i can see you have tested the tnsping and sqlplus command as ora<SID>.

The work processes are running under <SID>adm... and this user can have a different <TNS_ADMIN> location.

Please check this at your system

> shell> env | grep -i tns

Regards

Stefan

Answers (3)

Answers (3)

pr_srinivas
Contributor
0 Kudos

Hi.. Sukrut.

Which ever database you want to add.

log into that target server and copy the entries of tnsnames.ora

and copy it in source tnsnames.ora ( from where you want to monitor)

you have to copy these entries in 2 places

in location 1 : /oracle/<SID>102_64/network/admin/tnsnames.ora and

in location 2 : /usr/sap/<SID>/SYS/profile/oracle/tnanames.ora.

DBACOCKPIT Txn to add the database.

Rgds

Former Member
0 Kudos

Hi all

I made the configuration as it is written this thread.

In the TA DBACOCKPIT I test my DB connection.

At least I reseve this error:

-- ERROR Datenbankverbindung CBTDB: SQL-Fehler 12638 ORA-12638: Credential retrieval failed

Where I must make some additional configurations?

Reagards

Former Member
0 Kudos

Hi Srinivas

Please could you tell me what needs to be updated in tnsnames.ora file because we are having same setup at our end and we also would like to monitor from one system.

Thanks in advance.

Sukrut S

pr_srinivas
Contributor
0 Kudos

Dear Stefan

Gr8...............

Thanks

My problem is solved

i edited tnsnames.ora file in location

/usr/sap/P30/SYS/profile/oracle/tnsnames.ora

it works

may i know your mail id if you are intrested

Rgds