Database link with SSL SQL*Net encryption


SQL> connect anar/password 
Connected. 
SQL> select instance_name from v$instance;
INSTANCE_NAME 
---------------- 
KBAZER2
SQL> create database link KBAZER1 connect to anar identified by password using 'KBAZER1_tcps';
Database link created.
SQL> select instance_name from v$instance@KBAZER1;
INSTANCE_NAME 
---------------- 
KBAZER1
From listener.log:
2015-03-15 18:30:47.2801020 +10:00 
2015-03-15 18:30:47 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=KBAZER1)(CID=(PROGRAM=oracle)(HOST=SONUNW)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcps)(HOST=x.x.9.27)(PORT=2854)) * establish * KBAZER1 * 0

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: