Questions about Oracle IP address Modification

Analysis:
1. when installing Oracle, Oracle creates a directory named "Current ip_orcl" under F: \ oracle \ product \ 10.2.0 \ db_1 by default, this directory stores information such as the configuration of the Oracle database named orcl.
2. by default, Oracle creates a directory named "oc4j_dbconsole _ current ip_orcl" under the F: \ oracle \ product \ 10.2.0 \ db_1 \ Solaris \ J2EE directory, this directory stores the configurations of the oracledbconsole service and other information.
3. oracle defaults the listener under F: \ oracle \ product \ 10.2.0 \ db_1 \ Network \ admin. host and tnsnames in listener in ora file. set the host in orcl (database instance) in Ora to the current IP Address

Solution:
1. Rename the "current ip_orcl" directory under F: \ oracle \ product \ 10.2.0 \ db_1 to "127.0.0.1 _ orcl" or "machine name _ orcl"
2. Rename the "oc4j_dbconsole _ current ip_orcl" directory under F: \ oracle \ product \ 10.2.0 \ db_1 \ Solaris \ J2EE to "oc4j_dbconsole_127.0.0.20.orcl" or "oc4j_dbconsole _ machine name _ orcl"
3. in the F: \ oracle \ product \ 10.2.0 \ db_1 \ Network \ ADMIN directory, set listener. host and tnsnames of listener in ora file. in ora, the host of orcl (database instance) is changed to 127.0.0.1 or the machine name.

Note: In the solution to the following oracledbconsoleorcl startup problem, it is not feasible to rename the aforementioned directory and host 127.0.0.1. Therefore, we recommend that you use the machine name to check whether localhost is available, I did not test

. Of course, if you do not want to access the oracledbconsoleorcl service, you can set it to 127.0.0.1.

========================================================== ========================================================== ====================

The above method only temporarily solves the access problem between the oracleserviceorcl service and the oracleoradb10g_home1tnslistener service. To solve the problem of starting oracledbconsoleorcl, follow the steps below (which is repeated with the above steps)

To skip)
Note: you must first start the oracleserviceorcl and oracleoradb10g_home1tnslistener services.

Step 1: Change the new IP address or machine name
C: \ oracle \ product \ 10.2.0 \ db_1 \ Solaris \ J2EE \ oc4j_dbconsole_192.168.0.136_orcl (Replace the new IP address or machine name, but it cannot be 127.0.0.1. We recommend that you use the machine name)

C: \ oracle \ product \ 10.2.0 \ db_1 \ computer_name_orcl)

Step 2:
Enter:

Set oracle_sid = orcl
Emca-repos recreate

Emca started at 14:19:40

Em configuration assistant 10.2.0.1.0 official version
Copyright (c) 2003,200 5, Oracle. All rights reserved.

Enter the following information:
Database Sid: orcl

ListenersProgramPort: 1521
Sys user password:
Password of the sysman User:
Password of the sysman User:
Continue? [Yes (y)/NO (n)]: Y
2009-11-25 14:20:10 oracle. sysman. emcp. emconfig perform
Information: The operation is being recorded to D: \ oracle \ product \ 10.2.0 \ db_1 \ export toollogs \ emca \ orcl \ e
Mca_2009-11-25_14-20-10-Afternoon. log.
14:20:10 oracle. sysman. emcp. emreposconfig droprepository
Information: deleting the EM archives. This operation may take some time )...
14:20:10 oracle. sysman. emcp. emreposconfig invoke
Information: The archive has been deleted successfully.
14:20:10 oracle. sysman. emcp. emreposconfig createrepository
Information: creating the EM archives (this operation may take some time )...
14:20:10 oracle. sysman. emcp. emreposconfig invoke
Information: You have created a Data Archiving database.
The Enterprise Manager configuration has been completed successfully.
Emca ended at 14:20:10

Step 3: (omitted)

CMD:

> Emctl start dbconsole
Environment Variable oracle_sid not defined. Please define it.

> Set oracle_sid = orcl

> Emctl start dbconsole

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996,200 5 Oracle Corporation.
All rights reserved.
Http: // 192.168.0.136: 1158/EM/console/aboutapplication
Starting Oracle Enterprise Manager 10g Database Control... oracledbconsoledgtest

The service is starting.
The oracledbconsoledgtest service cannot be started.

System error.

System Error 3.

The specified path cannot be found.

Step 4:
> Emca-config dbcontrol DB

Emca started at 14:21:10
Em configuration assistant 10.2.0.1.0 official version
Copyright (c) 2003,200 5, Oracle. All rights reserved.

Enter the following information:
Database Sid: orcl

You have configured Database Control for the database dgtest.
You have selected to configure Database Control to manage the database dgtest
This operation will remove the existing configuration and default settings, and re-execute the configuration
Continue? [Yes (y)/NO (n)]: Y
Listener port: 1521
Sys user password:
Dbsnmp user password:
Password of the sysman User:
Invalid username/password.
Password of the sysman User:
Password of the sysman User: email address of the notification (optional ):
Notification sending (SMTP) server (optional ):
-----------------------------------------------------------------

The following settings have been specified:

Database ORACLE_HOME ...... c: \ oracle \ product \ 10.2.0 \ db_1

Database Host Name...
Listener port number ...... 1521
Database Sid ...... orcl
Email Address of the notification ...............
Notification sending (SMTP) server ...............

-----------------------------------------------------------------
Continue? [Yes (y)/NO (n)]: Y
2009-11-25 14:23:10 oracle. sysman. emcp. emconfig perform
Information: The operation is being recorded in c: \ oracle \ product \ 10.2.0 \ db_1 \ export toollogs \ emca \ orcl \ e
Mca_2009-11-25_14-23-10-Afternoon. log.
14:23:10 oracle. sysman. emcp. util. portmanager isportinuse
Warning the specified port 5540 is in use.
2009-11-25 14: 23: 10oracle. sysman. emcp. util. portmanager isportinuse
Warning the specified port 5520 is in use.
2009-11-25 14: 23: 10oracle. sysman. emcp. util. portmanager isportinuse
Warning the specified port 1158 is in use.
14:23:10 oracle. sysman. emcp. util. dbcontrolutil stopoms
Information: The Database Control is being stopped (this operation may take some time )...
2009-11-25 14:23:10 oracle. sysman. emcp. util. dbcontrolutil startoms
Information: Starting Database Control (this operation may take some time )...
14:23:10 oracle. sysman. emcp. emdbpostconfig configure mconfiguration
Information: The Database Control has been started successfully.
14:23:10 oracle. sysman. emcp. emdbpostconfig configure mconfiguration
Warning: The Database Control shortcut cannot be created.
14:23:10 oracle. sysman. emcp. emdbpostconfig configure mconfiguration
Information: >>>>>>>>>> Database Control URL is http: // computer_name: 1158/EM <
The Enterprise Manager configuration has been completed successfully.
Emca ended at 14:23:10

 

Re-log on to the IE column: http: // localhost: 1158/em

Http://hi.baidu.com/sysuzzjit/blog/item/3960c6fbe55c82d5b48f31f4.html