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，没办法，否则每次都是无法连接到实例，但是改配置文件只要一次！
成功了！撒花