on 01-30-2008 4:18 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.