問題登場：
[oracle@my-e450 ~]$ lsnrctl status
……
The listener supports no services
The command completed successfully
SQL> conn sys/[email protected]:1521/orcl as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
解決程序：
SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.133)(PORT=1521))';
System altered.
驗證：
[oracle@my-e450 ~]$ lsnrctl status
……
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclpdb" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
SQL> conn sys/[email protected]:1521/orcl as sysdba
Connected.
嗯，問題解決了！
注： oracle 版本為 12.2.0.1.0
寫于 Oct.30, 2019
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/36957.html
標籤：Oracle