oracle11g rac ora-12514,電腦重啟后 oracle ORA-12514: TNS: 監聽進程不能解析在連接描述符的問題...

本人裝了oracle11G后，用PL/SQL連接  沒問題，  但是重啟下電腦后發下無法連接，網上找了找發現

lintener.ora文件上  要加上一段   原本是

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = Oracle8)

(SID_NAME = ORCL)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

(DESCRIPTION =

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

)

要改成

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = Oracle8)

(SID_NAME = ORCL)

)

(SID_DESC =

(GLOBAL_DBNAME = orcl)

(ORACLE_HOME = D:\app\xwt\product\11.1.0)

(SID_NAME = orcl)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

(DESCRIPTION =

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

)

在改的過程中 ，有碰到頭疼的問題，因為我裝的是win7，沒法修改listener.ora文件，所以沒辦法  改了后拷到  桌面上，再刪除掉原本的，最后  在復制進去

重啟電腦  鏈接  沒問題，問題解決

另外碰到一個問題是，之前一個同事把pl/sql安裝進c盤下面的program下面，這樣也會提示出無法連接，只要把pl/sql安裝到別的盤就行了