Create The DB Link between SOURCE to TARGET instances FSG

DB Link Creation

1. Create The DB Link between SOURCE to TARGET instances in FSG


Query :

* All the FSG work that we have developed in FINSIT (Source) are needs to be transferred to SAND and UAT (next week).


Solution :
Source Database / Instance = SSEFINST
Target Database / Instance = SSESAND



Step 1 : Add the TNS entry’s between two instances. ( the tns names are
ssefinst, ssesand)

From Source Side: Add the TNS entry of TARGET
From Target side : Add the TNS entry of SOURCE

** Example :

Open Database side tnsnames.ora file :

Vi tnsnames.ora

ssefinst =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=porud440.uk.ssegroup.net)(PORT=1529))
(CONNECT_DATA=
(SERVICE_NAME=ssefinst)
(INSTANCE_NAME=ssefinst)
)
)

ssesand=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=porud440.uk.ssegroup.net)(PORT=1524))
(CONNECT_DATA=
(SERVICE_NAME=ssesand)
(INSTANCE_NAME=ssesand)
)
)






Step 2 : Check the TNS connectivity between two instances.

· From TARGET side
Ø tnsping < source tns name >
· From SOURCE side
Ø tnsping < target tns name >


Step 3: Create the DB Link on the TARGET Database side , Metalink doc id: 1034013.6

Login Front end, as sysadmin /

àselect the “General Ledger Super User” Responsibility

à Setup à System à Database Links.
àClick on “ New Database Link “

Enter the parameters.

Database Name : < Target Database >
Description :
Connect String : < Target TNS name >
Domain name : < Target server Domain Name >
Apps user name : APPS
Apps pwd : < Target DB Apps pwd>









Step 4 : Submit the “FSO Transfer” concurrent request From TARGET side


This can only be run from the ‘target’ environment.

à Login as “ General Ledger Super User “ Responsibility à View Request à Submit New
Request




















====================== 2 ===================




1. In ssefinst .. the user is already existing. For creating db link for user.

CREATE DATABASE LINK BOSS_RO_SSEFINST
CONNECT TO EIMS_RO
IDENTIFIED BY EIMS_RO123456789
USING 'SSEFINST';



à Check the Db Link created

View
Purpose
DBA_DB_LINKS
Lists all database links in the database.
ALL_DB_LINKS
Lists all database links accessible to the connected user.
USER_DB_LINKS
Lists all database links owned by the connected user.

COL HOST FORMAT A7 HEADING "SERVICE"
SELECT * FROM DBA_DB_LINKS


à For test the db link

* Connect the eims_ro user and try to sql query’s

SQL> Select * from tab@SSEFINST

---à drop the DB link

DROP DATABASE LINK sales.us.oracle.com;
DROP PUBLIC DATABASE LINK sales.us.oracle.com;


SQL > GRANT CREATE SESSION TO EIMS_RO