Configure oracle remote database connection in linux

The following describes how to remotely connect to a database in oracle: Configuring listener in linux to remotely connect to a database in oracle, we hope that you will have a better understanding of oracle remote database connection.

Server:

1. Add a listener: run the terminal: $ ORACLE_HOME/bin/netca must be in the graphic interface Environment). Add a listener as prompted.

2. added services supported by listener: terminal run: $ ORACLE_HOME/bin/netmgr graphical interface), in: oracle Net Configuration-> Local-> Listeners-> xxxx (the listener you just added), select "Database services", and add the database to be served. Note that the Global Database Name is your external service Name. Save and exit.

3. Restart your listener: terminal run:
$ ORACLE_HOME/bin/lsnrctl stop
$ ORACLE_HOME/bin/lsnrctl start
Last tip:
Service "XXXX" has 1 instance (s ).
The command completed successfully.

Now, the listener Configuration on the server is pressed.

Client:

1. configure a "Local Service Name Configuration": run $ ORACLE_HOME/bin/netca on the terminal, select Local Service Name Configuration, and follow the prompts. Here, the "Global Database Name" added when the Service Name is written and configured on the server side; if the Host name is written to the server IP address in the LAN, the server Name can also be used ); finally, give the local service a name such as LSN ). Save and exit.

2. Connect to the database on the server through sqlplus:
Format: sqlplus username/password @ name of the Local Service
Example: sqlplus user/password @ LSN

Oracle RMAN backup Optimization

Learn about Oracle OS backup

Importance of Oracle Database Backup

How to Implement ORACLE backup

Oracle backup using RMAN