Oracle-Sql-Developer
Oracle 11g:SQLDeveloper |狀態:失敗測試失敗:IO 錯誤。連接重置|
第 1 部分 新建/選擇數據庫連接
資訊
connection name: ziv username:oracle password: xxxxxxx connection type: basic role: sysdba host name : localhost.localdomain port: 1158 sid: orcl
任務是建立新的連接怎麼辦?
我試圖從 sqldeveloper 連接數據庫
但我得到以下錯誤
錯誤:
status: failure-test failed: IO error. connection reset
第2部分
我將埠更改為 1521 並收到其他錯誤
status failure test failed IO錯誤,嵌套適配器無法 建立連接
[oracle@localhost Desktop]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-DEC-2015 09:16:27 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=localhost.localdomain)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused
第 3 部分
[oracle@localhost Desktop]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-DEC-2015 09:39:16 Copyright (c) 1991, 2009, Oracle. All rights reserved. Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.1.0 - Production System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost) (PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 08-DEC-2015 09:39:18 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))) The listener supports no services The command completed successfully [oracle@localhost Desktop]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-DEC-2015 09:39:40 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 08-DEC-2015 09:39:18 Uptime 0 days 0 hr. 0 min. 22 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))) Services Summary... Service "orcl.localdomain" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "orclXDB.localdomain" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully
第 4 部分
好的,所以我再試一次,其他錯誤^^這次
狀態:失敗-測試失敗:ora-01031 權限不足
好的,所以現在它在最後一步之後工作
**before** connection name: ziv username: sys password: xxxxxxx connection type: basic role: sysdba host name : localhost.localdomain port: 1521 sid: orcl
將使用者名從 oracle 更改為 sys 並且它工作…
**after** connection name: ziv username: oracle password: xxxxxxx connection type: basic role: sysdba host name : localhost.localdomain port: 1521 sid: orcl
tnx 為所有人提供幫助
1158 是企業管理器數據庫控制台的預設埠,而不是數據庫偵聽器,您無法使用 SQL*Net 或 JDBC 登錄。
數據庫偵聽器的預設埠是 1521,嘗試使用該埠進行連接。您可以通過以下方式檢查偵聽器埠:
lsnrctl status