Oracle-Sql-Developer

Oracle 11g:SQLDeveloper |狀態:失敗測試失敗:IO 錯誤。連接重置|

  • December 15, 2015

第 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

引用自:https://dba.stackexchange.com/questions/123216