Scenario:
System A wants to have the database information of System B added in DBACOCKPIT (System A).System A – DS1
System B – QE1
Steps:
1. Update the tnsnames.ora file at the below locations,
Application Server of System A:
/usr/sap/DS1/SYS/profile/oracle
&
Database Server of System A:
/oracle/DS1/112_64/network/admin
QE1,QE1.WORLD=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = <hostname>)
(PORT = <listener_port>)
)
)
(CONNECT_DATA =
(SID = QE1)
(GLOBAL_NAME = QE1.WORLD)
)
)
2. Make sure tnsping QE1 is working fine from the database server & application server (if full oracle client is installed - if only instant client is installed then tnsping would not be available),
orads1> tnsping QE1
TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 08-AUG-2011 20:52:28
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
/oracle/DS1/112_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 = <hostname>) (PORT = <listener_port>))) (CONNECT_DATA = (SID = QE1) (GLOBAL_NAME = QE1.WORLD)))
OK (10 msec)
orads1>
3. Goto transaction DBACOCKPIT in System A (DS1), Click the DB Connection on the left.
Enter System ID
Select Database Connection
Enter a name for the Database Connection
Enter the description for Administration Data
Click the Create Button next to Database Connection Name.
4. Enter the below details,
Connection Name - Should auto populate from previous screen
Database system - Oracle (Select from drop down)
Connection Maximum - 0
Connection Optimum - 0
User Name - SYSTEM
Password - <SYSTEM User Password>
Confirm - <Same as above>
Enter TNS NAME - SID or the connection string.
Click Save.
5. Connection to remote database is complete.
No comments:
Post a Comment