ITRemote

#!/bin/ksh

sqlplus -s "/ as sysdba" <<EOF

-- create a public link for all to use

-- drop public database link sybase;


-- CREATE PUBLIC DATABASE LINK sybase CONNECT TO "automation" IDENTIFIED BY "password" USING 'db4sybase';

drop public database link testora;

CREATE PUBLIC DATABASE LINK testora CONNECT TO "automation" IDENTIFIED BY "password" USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname.commitdba.com)(PORT=49129))(CONNECT_DATA=(SID=dg4sybase))(HS=OK))';

-- select host from dba_db_links;

select * from dual@TESTORA;
-- select * from dual@db4sybase;

-- select * from dual@sybase;

EOF