SQL - DB LINK AND DBCA

Oracle Database Configuration Assistant (DBCA) is a tool for creating and configuring an Oracle database. In manual method of DB creation we need to specify the path and create directories whereas using DBCA we only need to specify the requirements.

Step 1: Set the DISPLAY environment variable

Step 2: Initiate DBCA

Step 3: select “create a database” and choose next

Step 4: Choose “ advance configuration” and click on next

Step 5: choose “Oracle single instance database” and click next

Step 6: Untick the container database selection and specify the database name that we want to create

Step 7: choose next

Step 8: Enable both options and click on next

Step 9: click on next

Stp 10: click on next

Step 11: choose the below option and click on next

Step 12: untick the “configure enterprise manager” and click on next

Step 13: choose the below option and enter password for the admin user

Step 14: click on next

Step 15: Click on finish

Step 16:

Step 17: Click on finish once progress is complete. We can see hat the new database has been created

Step 18: now to configure TNS and listener

Step 19: Configure listener file as follows

Step 20: Configure TNS file as follows

Step 21: Start the listener “lsnrctl start”

Step 22: Try to ping the databases using tnsping

Step 23: connect to the database to which DB LINK is to created

Step 24: connect to the user and create a sample table

Step 25: connect to the secondary database as sys user and create a user

Step 26: grant the user permission to create dblink

Step 27: conn to the user and create the DBLINK to the primary database

Step 28: to find the list of DBLINKS created

Step 29:now we can view the contents of a table in the primary databse using the DBLINK “db1”

Step 30: to drop a dBLINK

☛ Join to Learn from Experts: Oracle SQL Training in Chennai by TesDBAcademy

« Previous Next Topic » (SQL - SQL Loader & External Tables)