首先10g客户端,能连接11g服务器么?
我用windows客户端访问虚拟机11g服务器,这样做的
(1)server设置listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle11g)(PORT = 1521))
)
)ADR_BASE_LISTENER = /u01
(2)Client端:
wq_test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT =1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oradb)
)
)
(3)server端:启动监听:lsnrctl start
启动数据库 startup
(4)client端sqlplus user/password@wq_test提示我 TNS:没有监听程序 咋回事呢?
我用windows客户端访问虚拟机11g服务器,这样做的
(1)server设置listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle11g)(PORT = 1521))
)
)ADR_BASE_LISTENER = /u01
(2)Client端:
wq_test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT =1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oradb)
)
)
(3)server端:启动监听:lsnrctl start
启动数据库 startup
(4)client端sqlplus user/password@wq_test提示我 TNS:没有监听程序 咋回事呢?
2、可是我在虚拟机上安装了oracle以后,然后图形化界面也被关我掉了,就不能用root用户登录了,请问怎么才能用root登录呢?
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle11g)(PORT = 1521))
)
)更改为如下试试.另外,tnsping wq_test 结果贴出来看看.
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521))
)
)