首页 > 数据库 > Oracle >

oracle11gOEM无法连接到数据库实例解决办法

2015-02-04

我的电脑是32位的win7家庭版系统,那么这样的系统能不能装上oracle呢?能的!就是可能会出错,在装oracle时,每个人遇到的问题都不同,有的人装了双系统,有的人重做了系统,真心酸,先让电脑断网(不论是无线还

我的电脑是32位的win7家庭版系统,那么这样的系统能不能装上oracle呢?能的!就是可能会出错,在装oracle时,每个人遇到的问题都不同,有的人装了双系统,有的人重做了系统,真心酸,先让电脑断网(不论是无线还是有线)再装oracle(据说是因为oracle会记住当时的网络配置,下次再开机环境变了,就连不上了,但我觉得关系不大,我装了两次,一次连网,一次断网,结果都一样,无法连接到数据库实例),我按照教程装好了后,立刻打开OEM能打开,但是下次开机就是无法连接到数据库实例,真的!!!刚开始好用,下次不好用!!而打不开OEM,SQLDeveloper也别想打开!我弄了一周,就在下决心装双系统的前一天,被我解决了,现在整理解决办法如下,希望有更多同胞能顺利装上oracle,迈出第一步微笑奋斗

就是这个问题 Enterprise Manager无法连接到数据库实例 !!

\

<喎"http://www.2cto.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,没办法,否则每次都是无法连接到实例,但是改配置文件只要一次!


成功了!撒花

相关文章
最新文章
热点推荐