1、远程桌面访问oracle
cmd
set ORACLE_SID=orcl
sqlplus / as sysdba
ora-12560 协议适配器错误
排除
1) ORACLE_SID设置不正确
2)监听没启动
3)数据库没启动
2 、解决方法:
创建本地网络服务名:tnsnames
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.112)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(SRVR = DEDICATED)
)
)
sqlplus sys/111@orcl as sysdba