#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>
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 件のコメント :
コメントを投稿