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.
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