Remote access to the oracle database

Remoteaccesstotheoracledatabase first we have installed the Oracle software in linux, created a database, and configured the listener server: You need to enable the listener (lsnrctlstart [listenername]); open the database (setoracle_sidjuan; sqlplusassys; startup); client (linux): Account:

Remote access to the oracle database first we installed the Oracle software in linux, and created a database, and configured the listening server: listener needs to be enabled (lsnrctl start [listener name]); open the database (set oracle_sid = juan; sqlplus/as sys; startup); client (linux): Account:

Remote access to the oracle database

First, we installed Oracle software in linux, created a database, and configured a listener.
Server:

You need to enable the listener (lsnrctl start [listener name]);

Open the database (set oracle_sid = juan; sqlplus "/as sys"; startup );

Client (linux ):
Account: salley password: salley_123
1. Install the linux client;
A. connection string configuration file/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames. ora;

The file configuration is as follows:

Song_tasks =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.139.20.) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = song)
)
)

Then use sqlplus "salley/salley_123 @ song_slave as sysdba" to connect to the database.

B. You can also use netca to select the Local Net Service Name configuration graphical interface to configure the connection string;

(Note that you must use an ordinary account with no dba permission to test the connection, otherwise the error ORA-01017: invalid username/password; logon denied will be reported)
C. You can also directly connect to sqlplus salley/salley_123@192.168.139.135/song

Original article address: remote access to the oracle database, thanks to the original author for sharing.