Listener/listener.ora
LISTENER=
(DESCRIPTION_LIST =
(DESCRIPTION=
(ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0151)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=exampledb)
(ORACLE_HOME=/oraeng/application/oracle/product/10.2.0)
)
)
Tnsnames/tnsnames.ora
LSNRALIAS=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.151)(PORT = 1521))
)
(CONNECT_DATA =
(SID = exampledb)
)
)
creation of dblink in oracle
DB links are two types one is private(default) and second one is Public.
Before creating DB link first we have to check weather that particular user having "create database link" privilege or not.
and
global_names (required to be TRUE for replication. If the value of the GLOBAL_NAMES initialization parameter is TRUE, then the database link must have the same name as the database to which it connects.
creation of Private db link :
SQL> CREATE DATABASE LINK Link_name CONNECT TO username IDENTIFIED BY user_passwd
USING 'to_alias';
creation of Public db link :
SQL> CREATE PUBLIC DATABASE LINK Link_name CONNECT TO username IDENTIFIED BY user_passwd
USING 'to_alias';
HTML Comment Box is loading comments...