2013年8月6日火曜日

Oracle:This listener supports no services

#lsnrctl start
The listener supports no services
The command completed successfully

Error:
oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor

Possible solution1:
$sqlplus / as sysdba
SQL>show parameter service_names
SQL>alter system register;
$lsnrctl status

Possible solution2:
listener.ora
Add following:
SID_LIST_LISTENER =
(SID_LIST =
  (SID_DESC =
  (GLOBAL_DBNAME = globe)
  (SID_NAME = globe)
  )
)

Possible solution3:
Oracle Net Manager
Listeners->Database Services configure SID,ORACLE_HOME

[root@localhost oracle]# xhost +
[root@localhost oracle]# su - oracle
[oracle@localhost ~]$ netmgr
==================================================================
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
   Linux Error: 110: Connection timed out
LSNRCTL>

0 件のコメント :

コメントを投稿