DBACOCKPIT - DB Connection to remote DB gives ORA-12154
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