SQL> connect donghua/password
Connected.
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
orcl2
SQL> create database link orcl1 connect to donghua identified by password using 'orcl1_tcps';
Database link created.
SQL> select instance_name from v$instance@orcl1;
INSTANCE_NAME
----------------
orcl1
From listener.log:
2014-12-15 19:31:46.280000 +08:00
15-DEC-2014 19:31:46 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl1)(CID=(PROGRAM=oracle)(HOST=solaris112)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcps)(HOST=192.168.6.101)(PORT=63856)) * establish * orcl1 * 0
No comments:
Post a Comment