How to Create Database Link Between Two Oracle Instances/databases | Oracle 11g скачать в хорошем качестве

How to Create Database Link Between Two Oracle Instances/databases | Oracle 11g

How to create a database link between two Oracle instances. || Comment créer un lien de base de données entre deux instances Oracle. link from instance_name1 to instance_name2 and link from instance_name2 to instance_name2 for exemple : link from orclto dbchafik and link from dbchafik to orcl create database link from oracle instance to another instance and the inverse link files that was used : https://drive.google.com/open?id=1flJ... ********************************************************************* ********I have two instances : the first called 'orcl' second called 'dbchafik'***** *********dbchafik ==== orcl -- link from dbchafik instance to oracle instance ******first step****** *********open prompt command set oracle_sid=orcl --initializing the oracle_sid variable with the name of the instance to which you want to connect sqlplus / as sysdba select name, open_mode from v$database; connecte sys as sysdba create user admin identified by admin; grant connect, resource to admin; grant create database link to admin; --give the create privilege to the admin user to create a link conn admin/admin create database link dbchafik_link using 'dbchafik_service'; --create a link called 'dbchafik_link' using service called 'dbchafik_service' --- create public database link dbchafik_link connect to admin identified by admin using 'dbchafik_service' conn admin@dbchafik_service/admin select * from global_name@dbchafik_link; *********************************************************** ******second step****** **********I have two instances : the first called 'orcl' second called 'dbchafik' **********dbchafik ==== orcl -- link from dbchafik instance to oracle instance **********open prompt command set oracle_sid=dbchafik -- initializing the oracle_sid variable with the name of the instance to which you want to connect sqlplus / as sysdba conn sys as sysdba create user admin identified by admin; grant connect, resource to admin; grant create database link to admin; conn admin/admin create database link orcl_link using 'orcl'; --this request allows to create link named orcl link that uses the orcl service -- note that oracle is not an instance name but a name of a service select * from global_name@orcl_link; GLOBAL_NAME ----------- ORCL *****if the last query is executed without error. that is mean your link is work correctly conn admin@orcl/admin --se connecter à un utilisateur admin dans l'instance orcl select * from global_name; GLOBAL_NAME ------------ ORCL connect sys as sysdba -- to connect to the current instance. se connecter à un utilisateur sys dans l'instance dbchafik exactly, sign in to a current instance select * from global_name;