Shulou(Shulou.com)06/01 Report--

In this issue, Xiaobian will bring you about how to reconfigure Oracle DBConsole. The article is rich in content and analyzes and narrates from a professional perspective. After reading this article, I hope you can gain something.

1. Delete EM database

You can delete it using Oracle tools or you can execute it using command-line tools.

In the command line state: enter emca -decipher dbcontrol db -repos drop

Execute this command. At this time, you are required to enter the sys password (it seems that you also need to enter the listening port number and database SID. I can't remember it. The listening port number is the listening port number of the database. The default is 1521. The database SID is the database SID created when you install it.)

When asked whether to continue, say Y

2. Edit emca.bat

In the BIN directory under Oracle 10g installation directory, there is emca.bat file, modify the set JRE_JAVA parameter, point to JAVA.EXE in your external JRE

This step is not necessary, but I don't believe in 1.4.2. It is also possible not to modify it. It is more direct to replace the JDK in the Oracle installation directory with the external JDK. Anyway, it is

To replace, I replaced all in the JDK directory in the Oracle installation directory with all in the JDK 1.6.0_10 directory on my machine

3. Reconstruction of EM database

Command line status input: emca -config dbcontrol db -repos create

Executing this command asks you to enter a bunch of user passwords. I use the sys password I used when I created the database. All my users use the same password (because it is development).

status), and again, let you enter the listening port number or the database listening port number

When asked if you want to continue, say Y.

Later, it was prompted that the creation was successful. When you look at the Windows service list, the DBConsole service has started normally.

Log in to EM through IE, the connection is normal, and you can enter, indicating that DBConsole is indeed normal.

The above is how to reconfigure Oracle DBConsole shared by Xiaobian. If you happen to have similar doubts, you may wish to refer to the above analysis for understanding. If you want to know more about it, please pay attention to the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.