How to reconfigure Oracle DBConsole
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.
