{"id":399,"date":"2015-11-16T13:23:31","date_gmt":"2015-11-16T13:23:31","guid":{"rendered":"http:\/\/onlinelab.info\/?p=399"},"modified":"2015-11-16T13:23:31","modified_gmt":"2015-11-16T13:23:31","slug":"xu-ly-loi-the-listener-supports-no-services-tren-oracle-database-lsnrctl-status","status":"publish","type":"post","link":"https:\/\/www.asianux.org.vn\/index.php\/2015\/11\/16\/xu-ly-loi-the-listener-supports-no-services-tren-oracle-database-lsnrctl-status\/","title":{"rendered":"X\u1eed l\u00fd l\u1ed7i The listener supports no services tr\u00ean Oracle Database (lsnrctl status)"},"content":{"rendered":"

X\u1eed l\u00fd l\u1ed7i The listener supports no services tr\u00ean Oracle\u00a0Database (lsnrctl status)<\/h2>\n

T\u00ecnh hu\u1ed1ng<\/h3>\n

Khi th\u1ef1c hi\u1ec7n login root v\u00e0o server DB b\u00ecnh th\u01b0\u1eddng, telnet t\u1eeb client \u0111\u1ebfn c\u1ed5ng 1521 c\u1ee7a server database \u0111\u01b0\u1ee3c nh\u01b0ng khi k\u1ebft n\u1ed1i b\u1eb1ng client (sqlplus) b\u00e1o l\u1ed7i<\/p>\n

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor<\/p><\/blockquote>\n

Gi\u1ea3i ph\u00e1p<\/h3>\n

L\u00ean server v\u00e0 chuy\u1ec3n sang user oracle v\u1edbi c\u00e1c c\u00e2u l\u1ec7nh sau:<\/p>\n

su \u2013 oracle<\/p><\/blockquote>\n

Ki\u1ec3m tra listener<\/p>\n

lsnrctl status<\/p><\/blockquote>\n

Nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n

[oracle@DB19 ~]$ lsnrctl status<\/p>\n

\u2026<\/p>\n

Alias\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LISTENER<\/p>\n

Version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TNSLSNR for Linux: Version 11.1.0.6.0 \u2013 Production<\/p>\n

Start Date\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a006-NOV-2015 18:04:00<\/p>\n

Uptime\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 days 0 hr. 10 min. 28 sec<\/p>\n

Trace Level\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 off<\/p>\n

Security\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ON: Local OS Authentication<\/p>\n

SNMP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OFF<\/p>\n

Listener Parameter File\u00a0\u00a0 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/listener.ora<\/p>\n

Listener Log File\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/app\/oracle\/diag\/tnslsnr\/DB19\/listener\/alert\/log.xml<\/p>\n

Listening Endpoints Summary\u2026<\/p>\n

The listener supports no services<\/p>\n

The command completed successfully<\/p><\/blockquote>\n

Ta nh\u1eadn th\u1ea5y Oracle Listener b\u00e1o l\u1ea1i cho ch\u00fang ta message: The listener supports no services<\/strong> \u0111i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a database instance ch\u01b0a \u0111\u01b0\u1ee3c startup. H\u00e3y th\u1ef1c hi\u1ec7n l\u1ec7nh sau:<\/p>\n

[oracle@DB19 ~]$ sqlplus \/ as sysdba<\/p>\n

Connected to an idle instance.<\/p>\n

SQL> startup<\/p><\/blockquote>\n

Khi n\u00e0y db instance b\u1eaft \u0111\u1ea7u kh\u1edfi \u0111\u1ed9ng k\u1ebft qu\u1ea3 s\u1ebd c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n

ORACLE instance started.<\/p>\n

Total System Global Area\u00a0 839282688 bytes<\/p>\n

Fixed Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2149040 bytes<\/p>\n

Variable Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 608175440 bytes<\/p>\n

Database Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 222298112 bytes<\/p>\n

Redo Buffers\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a06660096 bytes<\/p>\n

Database mounted.<\/p>\n

Database opened.<\/p><\/blockquote>\n

V\u00e0 nh\u01b0 v\u1eady ta c\u00f3 th\u1ec3 k\u1ebft n\u1ed1i l\u1ea1i v\u1edbi client \u0111\u1ec3 h\u01b0\u1edfng th\u00e0nh qu\u1ea3.<\/p>\n","protected":false},"excerpt":{"rendered":"

X\u1eed l\u00fd l\u1ed7i The listener supports no services tr\u00ean Oracle\u00a0Database (lsnrctl status) T\u00ecnh hu\u1ed1ng Khi th\u1ef1c hi\u1ec7n login root v\u00e0o server DB b\u00ecnh th\u01b0\u1eddng, telnet t\u1eeb client \u0111\u1ebfn c\u1ed5ng 1521 c\u1ee7a server database \u0111\u01b0\u1ee3c nh\u01b0ng…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-399","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/posts\/399","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/comments?post=399"}],"version-history":[{"count":0,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/posts\/399\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/media?parent=399"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/categories?post=399"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/tags?post=399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}