程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> oracle11gOEM無法連接到數據庫實例解決辦法

oracle11gOEM無法連接到數據庫實例解決辦法

編輯:Oracle教程

oracle11gOEM無法連接到數據庫實例解決辦法


我的電腦是32位的win7家庭版系統,那麼這樣的系統能不能裝上oracle呢?能的!就是可能會出錯,在裝oracle時,每個人遇到的問題都不同,有的人裝了雙系統,有的人重做了系統,真心酸,先讓電腦斷網(不論是無線還是有線)再裝oracle(據說是因為oracle會記住當時的網絡配置,下次再開機環境變了,就連不上了,但我覺得關系不大,我裝了兩次,一次連網,一次斷網,結果都一樣,無法連接到數據庫實例),我按照教程裝好了後,立刻打開OEM能打開,但是下次開機就是無法連接到數據庫實例,真的!!!剛開始好用,下次不好用!!而打不開OEM,SQLDeveloper也別想打開!我弄了一周,就在下決心裝雙系統的前一天,被我解決了,現在整理解決辦法如下,希望有更多同胞能順利裝上oracle,邁出第一步微笑奮斗

就是這個問題 Enterprise Manager無法連接到數據庫實例 !!

\

<喎?http://www.Bkjia.com/kf/ware/vc/" target="_blank" class="keylink">vcD4KPGgyPk9SQS0xMjUwNTpUTlM6CrzgzP2zzNDytbHHsM7et6jKtrHwway908Poyva3+9bQy/m4+LP2tcRTSUS1yLTtzvO94r72t723qDwvaDI+CjxwPjwvcD4KPHA+PHN0cm9uZz4xLrzssunK/b7dv+K/zbuntstGaWxlOiA8L3N0cm9uZz48L3A+Ci9hcHAvb3JhY2xlL29yYWNsZS9wcm9kdWN0LzExLjIuMC9kYmhvbWVfMS9uZXR3b3JrL2FkbWluL2xpc3RlbmVyLm9yYSC+zcrHxOO1xG9yYWNsZbCy17DEv8K8CjxwPs7StcRsaXN0ZW5lci5vcmHI58/Cy/nKvjxicj4KIyBsaXN0ZW5lci5vcmEgTmV0d29yayBDb25maWd1cmF0aW9uIEZpbGU6IEM6XG15b3JhY2xlXHRoaW5rXHByb2R1Y3RcMTEuMi4wXGRiaG9tZV8yXG5ldHdvcmtcYWRtaW5cbGlzdGVuZXIub3JhPGJyPgojIEdlbmVyYXRlZCBieSBPcmFjbGUgY29uZmlndXJhdGlvbiB0b29scy48YnI+Cjxicj4KPGJyPgpTSURfTElTVF9MSVNURU5FUiA9PGJyPgogIChTSURfTElTVCA9PGJyPgogICAgKFNJRF9ERVNDID08YnI+CiAgICAgIChTSURfTkFNRSA9IENMUkV4dFByb2MpPGJyPgogICAgICAoT1JBQ0xFX0hPTUUgPSBDOlxteW9yYWNsZVx0aGlua1xwcm9kdWN0XDExLjIuMFxkYmhvbWVfMik8YnI+CiAgICAgIChQUk9HUkFNID0gZXh0cHJvYyk8YnI+CiAgICAgIChFTlZTID0gJnF1b3Q7RVhUUFJPQ19ETExTPU9OTFk6QzpcbXlvcmFjbGVcdGhpbmtccHJvZHVjdFwxMS4yLjBcZGJob21lXzJcYmluXG9yYWNscjExLmRsbCZxdW90Oyk8YnI+CiAgICApPGJyPgogICk8YnI+Cjxicj4KPGJyPgpMSVNURU5FUiA9PGJyPgogIChERVNDUklQVElPTl9MSVNUID08YnI+CiAgICAoREVTQ1JJUFRJT04gPTxicj4KICAgICAgKEFERFJFU1MgPSAoUFJPVE9DT0wgPSBJUEMpKEtFWSA9IEVYVFBST0MxNTIxKSk8YnI+CiAgICAgIChBRERSRVNTID0gKFBST1RPQ09MID0gVENQKTxzdHJvbmc+KEhPU1QgPSBsb2NhbGhvc3Q8L3N0cm9uZz4pKFBPUlQgPSAxNTIxKSk8YnI+CiAgICApPGJyPgogICk8YnI+Cjxicj4KPGJyPgpBRFJfQkFTRV9MSVNURU5FUiA9IEM6XG15b3JhY2xlXHRoaW5rPGJyPgo8L3A+CjxwPjxzdHJvbmc+xuTW0Lrsyaux6rzHtcRIT1NUysfM2LHw0qrXotLitcS12Le9o6zKx8TjtcS8xsvju/rD+7PGo6yyu8TcvPK1pbXE0LSzyWxvY2FsaG9zdKOsyOe5+7K7yLe2qLzGy+O7+sP7s8bU8r/Jzai5/WRiYbXHwrxzcWxwbHVzwPvTwyA8YnI+CnNlbGVjdCBIT1NUX05BTUUgZnJvbSB2JGluc3RhbmNl0+++5LLp0a/W97v6w/uhozwvc3Ryb25nPjwvcD4K16LS4rXHwrxzcWxwbHVzyrHTwwo8cD5zcWxwbHVzICB1c2VybmFtZS9wYXNzd29yZCA8c3Ryb25nPrK70OjSqmxpc3RlbmVyvfizzKOstcfCvLG+u/rK/b7dv+KjrMr9vt2/4sq1wP3G9LavvLS/yaGj1eK49sP8we6jrM/C0ru49sP8we7S8s6qb21lzt63qLTyv6rKx7K7usPTw7XEPGJyPgo8L3N0cm9uZz5zcWxwbHVzIHVzZXJuYW1lL3Bhc3N3b3JkQHRuc25hbWU8c3Ryb25nPtDo0qpsaXN0ZW5lcr34s8yjrNfus6O8+7XE1LazzLXHwrzEo8q9o6zQ6NKqxvS2r8r9vt2/4sq1wP26zWxpc3RlbmVyvfizzKGjsru6w9PDPC9zdHJvbmc+PC9wPgo8cD48c3Ryb25nPjxpbWcgc3JjPQ=="http://www.2cto.com/uploadfile/Collfiles/20150204/2015020409562652.png" alt="\">

就如圖中所示把localhost改成THINK-THINK,其它不動,如果在修改時沒有權限,無法保存,就先把它復制到D盤修改,再復制回去就好了

2修改./app/oracle/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

我的tnsnames.ora 如下:

# tnsnames.ora Network Configuration File: C:\myoracle\think\product\11.2.0\dbhome_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.


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


ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

也改成主機名即可,其它不動,newdb是我的數據庫SID名

3.重啟監聽器

以管理員的身份運行 cmd,就是在開始菜單輸入cmd搜索,出結果後,右鍵以管理員身份運行cmd

先輸入

lsnrctl stop

再輸入

lsnrctl start

\

重啟完監聽器後,剛才的配置就生效了,注意以後每次開機都要運行這兩個命令,lsnrctl stop lsnrctl start 才能打開OEM和SQLDevloper,沒辦法,否則每次都是無法連接到實例,但是改配置文件只要一次!


成功了!撒花

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved