Solution for Oracle em can't log on after computer IP changes (pro-test)

Source: Internet
Author: User

The following methods for my pro-test

Scenario: Assume that the first time the computer installed Oracle IP is 192.168.133.110

Then the address to the EM is Http://192.168.133.110:1158/em/console/logon/logon.

Suppose the computer's IP is changed to 192.168.88.66

Then the address into EM should be http://192.168.88.66:1158/em/console/logon/logon.

But after the test, enter the above address can not enter EM, because the computer IP has changed, Oracle needs to modify the configuration file can be accessed, after the general modification of the configuration file, there will be ORACLEDBCONSOLEORCL can not start the problem.

Method One, not successful, or not into the EM

Reach the D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN directory below

Modify Listener and TNSNames

Change host to the IP address of your local computer

Method Two, unsuccessful, or display oracledbconsole is not running

Command line input emctl start dbconsole
Displays environment variable ORACLE_SID not defined. Please define it.
Then set the ORACLE_SID according to its instructions
Enter set ORACLE_SID=ORCL on the command line (if your SID is not ORCL, please replace it yourself)
Re-typing emctl start dbconsole
Displays the oc4j Configuration issue. D:\ORACLE\PRODUCT\10.2.0\DB_1/OC4J/J2EE/OC4J_DBCONSOLE_192.168.1.101_ORCL not found.
So I went to the directory where I found a directory of my "Oc4j_dbconsole_" + machine name + "_ORCL"
Online people say if you have changed the name of the machine, then you are here to replace your new machine name with the original machine name
Turn "Oc4j_dbconsole_" + New machine name + "_ORCL"
If you are like me, it is because of environmental changes that this problem occurs, I recommend you copy a directory, make changes.
Copy "Oc4j_dbconsole_" + machine name + "_ORCL" renamed to "Oc4j_dbconsole_ 192.168.1.101_ORCL
Re-typing emctl start dbconsole
There are display em Configuration issue. d:\oracle\product\10.2.0\db_1/192.168.1.101 _ORCL not found
I think you know how to do it.
Copy to the appropriate directory, duplicate a rename
Re-typing emctl start dbconsole

Method Three, the simplest way is to rebuild EM, success, pro-Test

CMD into command line

C:\Documents and Settings\administrator>set ORACLE_SID=ORCL

C:\Documents and Settings\administrator>emctl status Dbconsole

Tip Oracle Enterprise Manager 10g is not running

Well, it looks like Dbconsole's not up, go ahead.

Emctl Start Dbconsole

Found that ORACLEDBCONSLEORCL could not be started.

It's really not going to get up.

Go to the service for an interview. Run->services.msc, start the ORACLEDBCONSLEORCL service, and the results prompt the ORACLEDBCONSLEORCL service to start and close. It seems that still can not get up, do not know which classmate in the database server has done something, may be changed IP? Changed the machine name? Or what? I don't care anymore, solve the problem. Think about it, re-create EM.

Back to Windows command line execution

1.

C:\Documents and Settings\administrator>emca-repos recreate

EMCA started on 2012-5-8 11:18:06
EM Configuration Assistant 10.2.0.1.0 official version
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID:ORCL

Listener Port number: 1521
SYS User's password:
Sysman User's password:

Do you want to continue? [Yes (Y)/no (N)]: Y

2012-5-8 11:18:25 Oracle.sysman.emcp.EMConfigperform
Info: Logging This action to D:\soft\Oracle\cfgtoollogs\emca\orcl\emca_2012-05-08_11
8-06-morning. Log.
2012-5-8 11:18:28 Oracle.sysman.emcp.EMReposConfigdropRepository
Info: Removing the EM Data archive (this may take some time) ...
2012-5-8 11:19:27 Oracle.sysman.emcp.EMReposConfig Invoke
Info: The repository was deleted successfully
2012-5-8 11:19:28 Oracle.sysman.emcp.EMReposConfigcreateRepository
Info: Creating an EM Data archive (this operation may take a while) ...
2012-5-8 11:21:29 Oracle.sysman.emcp.EMReposConfig Invoke
Info: The repository was created successfully
Configuration of Enterprise Manager completed successfully
EMCA ended on 2012-5-8 11:21:29

-------------------------------------------------

The above action is to re-create the EM repository

------------------------------------------------

2. Then configure the console:

C:\Documents Andsettings\administrator>emca-config Dbcontroldb

EMCA started on 2012-5-8 11:23:42
EM Configuration Assistant 10.2.0.1.0 official version
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID:ORCL
Database Control has been configured for ORCL
You have chosen to configure database control to manage databases ORCL
This action removes the existing configuration and default settings and re-executes the configuration
Do you want to continue? [Yes (Y)/no (N)]: Y
Listener Port number: 1521
SYS User's password:
DBSNMP User's password:
Sysman User's password:
e-mail address of the notification (optional):
Outgoing (SMTP) server for notifications (optional):

-----------------------------------------------------------------

The following settings have been specified

The database is oracle_home ..... ..... D:\soft\Oracle

The database host name ......... Name-15df19df

Listener port number ...... ....... 1521
Database SID ..... ORCL-----

The e-mail address of the notification .....
Notification of the outgoing (SMTP) server ..... .....

-----------------------------------------------------------------
Do you want to continue? [Yes (Y)/no (N)]: Y

.................................

.................................

.................................

Info: >>>>>>>>>>>database Control URL is http://name-15df19df£ 1158/em <<<<<<<
<<<<
Configuration of Enterprise Manager completed successfully
EMCA ended on 2012-5-8 11:27:43

C:\Documents Andsettings\administrator>emctl Startdbconsole

Okay, the console service is up,

OEMs can also log in normally.

Note: The password for the dbsnmp user appears during the period: I did not set the user's password when I installed Oracle

However, you can use the SYS user to modify the user's password to the password you want to set.

Methods are as follows

Sql> Conn sys/a as Sysdba

sql> alter user DBSNMP identified by your password.

Modify your new password

Solution for Oracle em can't log on after computer IP changes (pro-test)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.