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

posted @ 2019-02-27 18:16  orcl  阅读(1823)  评论(0)  编辑  收藏  举报