Oracle12154解決辦法

LawsonJin發表於2017-07-23
1、已管理員身份執行plsql developer
2、
到oracle 的安裝目錄下面如C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN中找到listner.ora檔案,
改成如下內容,重啟OracleOraDb10g_home1TNSListener服務
#修改虛擬機器中的檔案
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  (SID_DESC =
      (GLOBAL_DBANAME = orcl)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (SID_NAME = orcl)
    )


  )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = ITCAST-7DE0D8D1)(PORT = 1521))
    )
  )




3、
重灌oracle!!!

相關文章