Path 8350262, which has been tried only on 10.2.0.4.0. I wonder if it can be used on 10.2.0.5.
The patch file is located in this directory.
My actual environment: The system is windows2008serverR2,DatabaseIt is oracle10.2.0.4.0.
If you do not need EM in the application, you do not need to apply this patch.
InstallProcess:
1. Use opatch to install the patchOracleMedium:
Set the system environment parameters of ORACLE_HOME and ORACLE_SID (it is recommended that you do not set temporary parameters for system environment parameters ), add % ORACLE_HOME % \ opatch to the PATH system environment parameters (this is because the opatch Command needs to be called in the patch directory, so the opatch directory must be placed in the path environment parameter ), decompress path 8350262 and use CMD to enter the decompressed directory:
Opatch apply
After completion, check the log files generated under the % ORACLE_HOME % \ export toollogs \ opatch directory to check whether the path is successfully installed.
Log File, which may prompt:
Information: The following warnings have occurred during OPatch execution:
Information: 1) OUI-67294:
**************************************** **************************************** ***********
Oracle Configuration Manager is installed but not configured. OCM enables Oracle
Provide superior, proactive support for our MERs. Oracle stronugly recommends customers
Configure OCM. To complete the configuration of OCM, refer to the OCM Installation and
Administration Guide (http://www.oracle.com/technology/documentation/ocm.html ).
The installation is successful but not configured. You need to reconfigure it here.
Then restart the machine.
2. the recommended method is to repeat it step by step:
(1) re-build the EM archive: emca-repos recreate
(2) Reconfigure console database control: emca-config dbcontrol db
(3) when creating the EM archive, you may be prompted that you cannot create the EM archive, because after the patch is completed, the ORACLEDBCONSOLEORCL system service has been deleted and cannot be found, you need to restart the machine to continue. Therefore, restart the machine after the patch is installed.
(4) When you configure the console above, you may be prompted that the EM key and database control are in unprotected mode. You need to correct the issue and follow the methods provided by the program.
(5) set ORACLE_SID = orcl
(6) Emctl stop dbconsole
(7) Emctl config emkey-sysman_pwd
(8) Emctl secure dbconsole-sysman_pwd
(9) Emctl start dbconsole
(10) The-sysman_pwd in the above command is entered according to the input. You do not need to enter it. After the command is executed, a prompt will be prompted asking you to enter the password of SYSMAN.
3. In general, the EM should be ready for use. However, in practice, the HTTP security mode appears to be used, that is, when you enter EM, you must use HTTPS instead of HTTP, which is easy to ignore.
4. It seems that the listener is finished. However, when IE enters EM, the database cannot be found. The Listener is not automatically started. Set the listener to auto start. The simplest way isWindowsIn the service interface, find the oracle listening service and set it to automatic.