Oracle11gOEM unable to connect to the database instance Solution

Oracle11gOEM unable to connect to the database instance Solution

My computer is 32-bitWin7 family EditionSystem, can such a system be installed with oracle? Yes! An error may occur. When installing oracle, everyone encounters different problems. Some people have dual systems, and some others have redone the system,First let the computer disconnect the network (wireless or wired) and then install oracle (it is said that oracle will remember the network configuration at that time, and the next time the boot environment has changed, it will not be able to connect, but I don't think it is very relevant, I installed it twice, connected to the network once, and disconnected once, and the results were the same, so I could not connect to the database instance)After I have installed it according to the tutorial,You can enable OEM immediately, but cannot connect to the database instance the next time you start the system !!! It's easy to use at the beginning. It's not easy to use next time !! But cannot open the OEM, SQLDeveloper do not want to open it!After a week, I solved the problem one day before I made up my mind to install the dual system. Now, I want to solve the problem as follows. I hope more Chinese people can install oracle smoothly and take the first step.

Enterprise Manager cannot connect to the database instance !!

<喎?http: www.bkjia.com kf ware vc " target="_blank" class="keylink"> Kernel + 9bQy/m4 + kernel + cjxwpw.vcd4kpha + kernel/b7dv + K/kernel + kernel/Cy/kernel + CiAgICApPGJyPgogICk8YnI + kernel + development + development/rD + Development + 7K7yLe2qLzGy + O7 + sP7s8bU8r/Jzai5/Development + Development ++ 5LLp0a/W97v6w/release + u/rK/ b7dv + KjrMr9vt2/4sq1wP3G9LavvLS/yaGj1eK49sP8we6jrM/expires + expires/expires + PC9wPgo8cD48c3Ryb25nPjxpbWcgc3JjPQ =" http://www.2cto.com/uploadfile/Collfiles/20150204/2015020409562652.png "Alt =" \ ">

Change localhost to THINK-THINK as shown in. If you do not have the modification permission and cannot save it, copy it to disk D and modify it. Then copy it back.

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

My tnsnames. ora is as follows:

# 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)
)
)


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

You can also change it to the host name. newdb is the SID Name of my database.

3. Restart the listener.

Run cmd as the administrator. Enter cmd search in the Start Menu. Right-click the result and run cmd as the administrator.

Enter

Lsnrctl stop

Enter

Lsnrctl start

After the listener is restarted, the configuration just now takes effect,Note that you need to run these two commands each time you start the system,Lsnrctl stop lsnrctl start can enable OEM and SQLDevloper. No way, otherwise, you cannot connect to the instance every time, but you only need to change the configuration file once!

Successful! Sahua