ORA-12154：無法連接到Windows10上的默認OracleXE21c資料庫

我有過。我只是無法讓這個作業。我在 Windows 10 桌面上安裝了 Oracle XE 21c。一旦我以管理員身份運行安裝檔案，安裝就成功了。我基本上選擇了所有默認值。

所以現在它正在運行，并且有一個為我創建的默認資料庫 XE。但是當我嘗試使用 SQLPlus 以 SYSTEM 身份連接時，我得到了這個：

SQL*Plus: Release 21.0.0.0.0 - Production on Mon Nov 1 19:08:25 2021
Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Enter user-name: SYSTEM
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

我看了看，沒有 tnsnames.ora 或 listern.ora 檔案，所以我嘗試創建它們，盡管我不確定它們是否正確。

C:\app\sysde\product\21c\dbhomeXE\network\admin\listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

C:\app\sysde\product\21c\dbhomeXE\network\admin\tnsnames.ora

LISTENER = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

XE = (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

然后我停止了監聽器如下 lsnrctl stop

這產生了：

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 61: Unknown error

偵聽器 OracleOraDB21Home1TNSListener 不再在 services.msc 中運行。嘗試重新啟動它時，我得到了這個...

Error 2: The system cannot find the file specified.

我的環境變數是：

  ORACLE_HOME=C:\app\sysde\product\21c\dbhomeXE\
  TNS_ADMIN=C:\app\sysde\product\21c\dbhomeXE\network\admin

I know there are numerous "Can't connect to Oracle" posts. I've tried bits and pieces of them, but none are really suited to my situation and the parts I've tried simply haven't helped. Any suggestions you have to allow me to use the default XE database and connect to it through a GUI such as SQL Developer would be tremendously helpful.

uj5u.com熱心網友回復：

根據檔案，從 21c 開始，默認軟體安裝是只讀主頁布局，自 18c 以來一直可用

https://docs.oracle.com/en/database/oracle/oracle-database/21/nfcon/read-only-oracle-home-default-366970591.html

所以默認情況下，sqlnet 組態檔不會在 ORACLE_HOME/network/admin 下。

C:\oracle\product\21c\dbhomeXE\network\admin>dir
 Volume in drive C is System
 Volume Serial Number is EEB1-910D

 Directory of C:\oracle\product\21c\dbhomeXE\network\admin

13/10/2021  10:53 AM    <DIR>          .
13/10/2021  10:53 AM    <DIR>          ..
13/10/2021  10:51 AM    <DIR>          sample
13/10/2021  10:52 AM               263 sqlnet.ora.rooh
               1 File(s)            263 bytes
               3 Dir(s)  78,346,031,104 bytes free

C:\oracle\product\21c\dbhomeXE\network\admin>cd ..\..\..\homes\OraDB21Home1\network\admin

C:\oracle\product\21c\homes\OraDB21Home1\network\admin>dir
 Volume in drive C is System
 Volume Serial Number is EEB1-910D

 Directory of C:\oracle\product\21c\homes\OraDB21Home1\network\admin

13/10/2021  10:54 AM    <DIR>          .
13/10/2021  10:54 AM    <DIR>          ..
13/10/2021  10:53 AM               656 listener.ora
13/10/2021  10:53 AM               465 sqlnet.ora
13/10/2021  10:53 AM               263 sqlnet21101310AM5351.bak
13/10/2021  02:51 PM               852 tnsnames.ora
               4 File(s)          2,236 bytes
               2 Dir(s)  78,345,871,360 bytes free

您不需要設定 ORACLE_HOME 或 TNS_ADMIN。您只需要編輯“家”區域中的檔案就可以了。

Windows 團隊在此處提供完整的從上到下的安裝視頻

https://youtu.be/DYleroLay5E

標籤：oracle connection listener tnsnames

上一篇：在Oracle中使用MODEL子句并回傳以前的值

下一篇：當所有行都正常時從表中檢索記錄