oracle远程连接

tnsnames.ora文件内容：

PROD1 =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=gzrip1.oracle.com)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=PROD1.us.oracle.com)
(SERVER=dedicated)
)
)

连接方法：

sqlplus sys/oracle@gzrip1.oracle.com（长主机名）:1521/PROD1.us.oracle.com as sysdba

sqlplus sys/oracle@gzrip1（短主机名）:1521/PROD1.us.oracle.com as sysdba

sqlplus sys/oracle@IP地址:1521/PROD1.us.oracle.com as sysdba

sqlplus sys/oracle@PROD1（网络服务名） as sysdba

转载于:https://www.cnblogs.com/orcl-2018/p/10445622.html