Oracle Audio Technologies 12.2 manual Creating the Database Links

Creating the Database Links

Creating the Database Links

If you plan to install the Place application across two database instances, you must create the instances in the following manner, and then set up the database links between the two instances:

■Set up the ELM schema (historical data) on a database instance (for example, INSTANCE1).

■Set up the remaining database schemas (PLACE, AUDIT, OAK, and PINE schema) as a single BASE schema, on the other database instance

(for example, INSTANCE2).

To create the database links:

1.At the SQL prompt, connect to the ELM schema on INSTANCE1, and then run the following command:

create database link <dblink_name_elm2base> connect to ELM identified by BASE using 'INSTANCE1';

2.At the SQL prompt, connect to the BASE schema on INSTANCE2, and then run the following command:

create database link <dblink_name_base2elm> connect to BASE identified by ELM using 'INSTANCE2';

Note: The dblink_name_elm2base and dblink_name_base2elm indicate the name of a database links you create between the instances.

Setting Up the Database 3-3