Install Oracle 12cR1 Client on Redhat

Make sure global domain is set:

SELECT * FROM GLOBAL_NAME;
ALTER DATABASE RENAME GLOBAL_NAME TO <New Name>;


To Show DB Links:

COL OWNER FORMAT a10
COL USERNAME FORMAT A8 HEADING "USER"
COL DB_LINK FORMAT A30
COL HOST FORMAT A7 HEADING "SERVICE"
SELECT * FROM DBA_DB_LINKS
/


Test DB Link:

select sysdate from dual@<DB NAME>

CREATE PUBLIC DATABASE LINK SDB01NEXTGENFANTOM CONNECT TO GENERICREADONLY IDENTIFIED BY "generic=readonly" USING 'dg4msql-sdb-01-NextgenFantom';
CREATE PUBLIC DATABASE LINK SDB01NEXTGENSERVICES CONNECT TO tracetools IDENTIFIED BY "trace=tools" USING 'dg4msql-sdb-01';
CREATE PUBLIC DATABASE LINK SDB02INVENTORYMANAGER CONNECT TO ordersync IDENTIFIED BY "order=sync" USING 'dg4msql-sdb-02-im';
CREATE PUBLIC DATABASE LINK SDB02PANDADB CONNECT TO GENERICREADONLY IDENTIFIED BY "generic=readonly" USING 'dg4msql-sdb-02-PandaDB';
CREATE PUBLIC DATABASE LINK SDB02SERVICES CONNECT TO ordersync IDENTIFIED BY "order=sync" USING 'dg4msql-sdb-02-services';
CREATE PUBLIC DATABASE LINK XCOM CONNECT TO system IDENTIFIED BY manager USING 'XCOM';
CREATE PUBLIC DATABASE LINK DEV03NEXTGENFANTOMRO CONNECT TO GENERICREADONLY IDENTIFIED BY "generic=readonly" USING 'dg4msql-dev-03-NextgenFANTOM';
CREATE PUBLIC DATABASE LINK DEV03NEXTGENFANTOMRW CONNECT TO remedywriteaccess IDENTIFIED BY "remedy=writeaccess" USING 'dg4msql-dev-03-NextgenFANTOMRW';


CREATE PUBLIC DATABASE LINK DEV03test CONNECT TO tracetools IDENTIFIED BY "trace=tools" USING 'dg4msql-dev-03-NextgenFANTOMTEST';

Drop Database Link:

DROP PUBLIC DATABASE LINK <db name>;


Show how many links can be open:

SQL> sho parameter links;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_links integer 100
open_links_per_instance integer 100
SQL>

Alter this:

alter system set open_links=100 scope=spfile;
alter system set open_links_per_instance=100 scope=spfile;
dbshut / dbstart

 

S5 Box

Login