按照一般流程配置完成了,我先在1号终端启动监听lsnrctl start,再打开另一个终端,sqlplus /nolog打开服务器,再输入 conn sys@orcl001 as sysdba,想连接,但是出现提示:
TNS:listener does not currently know of service requested in connect
descriptor(侦听器目前不知道连接中请求的服务描述符)!!
于是我又 alter system register;(实例注册),又提示 Not connected(没有连接)!!
我又到1号终端,查看监听状态,提示The listener supports no services(侦听器不支持服务)!!!,我又重启监听和服务器,还是不行,还是以上提示!!!!
求大神~!帮助~!!
一下是配置文件:
listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC=
(GLOBAL_DBNAME =ORCL)
(ORACLE_HOME =:/data/oracle/product/11.2.0/db_1)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
tnsnames.ora
ORCL001 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl11g)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)