Monday 12 December 2011

HOW WE CAN USE DBLINK BETWEEN TWO ORACLE APPS INSTANCE

How we can get data from another oracle apps database/instance using DBLINK?

1) First we need to connect in TEST instance(192.168.1.2) as SYSTEM/password
2) select name from v$database;  Note the result, It will display TEST database Name
3) Run this command to connect the production instance where PROD is Production instance:-
CREATE PUBLIC DATABASE LINK "PROD" CONNECT TO apps IDENTIFIED BY apps
USING '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))(CONNECT_DATA = (SID = PROD)))';
3) Now run command for testing and check the result :- select name from v$database@PROD ;
It will display PROD database Name
Now you will get the data from Production Server.

No comments:

Post a Comment