Shulou(Shulou.com)05/31 Report--

The main content of this article is to explain "what is the method of Oracle12 OEM upgrading Oracle13", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what is the method of upgrading Oracle13 by Oracle12 OEM"?

Software

Download the following software:

Http://www.oracle.com/technetwork/oem/grid-control/downloads/index.html

Prerequisites:

RHEL5 does not support OEM13C,Oracle database version must be 12.1.0.2.

If your database and OS version are normal, you need to change the parameters and restart the database.

ALTER SYSTEM SET COMPATIBLE ='12. 1.0.2.0'SCOPE = SPFILE; ALTER SYSTEM SET optimizer_adaptive_features = false SCOPE = SPFILE;sqlplus / as sysdbaGRANT EXECUTE ON dbms_random TO dbsnmp; GRANT EXECUTE ON dbms_random TO sysman;REVOKE EXECUTE ON dbms_random FROM public

Check for invalid objects

SELECT owner, object_name, object_typeFROM dba_objects WHERE status = 'INVALID'AND owner IN (' SYS', 'SYSTEM',' SYSMAN', 'MGMT_VIEW',' DBSNMP', 'SYSMAN_MDS')

Compile invalid object

EXEC UTL_RECOMP.recomp_serial ('SYS'); EXEC UTL_RECOMP.recomp_serial (' DBSNMP'); EXEC UTL_RECOMP.recomp_serial ('SYSMAN')

Use the following command to copy the emkey and adjust as needed. You must enter your OEM sysman password

$export OMS_HOME=/u01/app/oracle/oms12cr5/oms$ $OMS_HOME/bin/emctl config emkey-copy_to_reposOracle Enterprise Manager Cloud Control 12c Release 5Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.Enter Enterprise Manager Root (SYSMAN) Password: The EMKey has been copied to the Management Repository. This operation will cause the EMKey to become unsecure.After the required operation has been completed, secure the EMKey by running "emctl config emkey-remove_from_repos". $$OMS_HOME/bin/emctl status emkeyOracle Enterprise Manager Cloud Control 12c Release 5Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.Enter Enterprise Manager Root (SYSMAN) Password: The EMKey is configured properly, but is not secure. Secure the EMKey by running "emctl config emkey-remove_from_repos". $

Stop OEM and Agent

Export OMS_HOME=/u01/app/oracle/oms12cr5/omsexport AGENT_HOME=/u01/app/oracle/agent12c/agent_inst$OMS_HOME/bin/emctl stop oms-all$AGENT_HOME/bin/emctl stop agent

Create an oem directory

Mkdir-p / u01/app/oracle/middleware

Run the upgrade

Chmod upright x em13100_linux64.bin./em13100_linux64.bin

If the above prerequisites have been implemented, the installation should pass all prerequisite checks. Click the next button. In this case, I get a warning from the kernel parameter because my "ip_local_port_range" is greater than the required range. I ignored it by clicking the "ignore" button, followed by the "OK" button, and then the "next" button.

Enter the new location, I use "/ u01/app/oracle/oem12cr5", and then click the "next" button

Enter the passwords for the SYS and SYSMAN users and select the two check boxes, and then click the next button.

In the first warning dialog box, click OK. Subsequent error screens should list things that can be fixed by the installer.

If you have any other warnings, check that they do not look like display stoppers, and then click the Yes button to continue.

If you are satisfied with the plug-in upgrade information, click the next button.

Enter WebLogic details, and then click the next button. / u01/app/oracle/gc_inst1.

Waiting for installation and configuration.

When prompted, run the root script, and then click OK.

After the upgrade is complete, you should use the following command to protect EMKey.

$OMS_HOME/bin/emctl config emkey-remove_from_repos

$export AGENT_HOME=/u01/app/oracle/agent12c/agent_inst

$$AGENT_HOME/bin/emctl start agent

The login screen can use the URL ("https://emcc.localdomain:7802/em")" provided on the previous screen from the browser. Log in with the user name "sysman" and the password you specified during installation.

Upgrade Agent

If you do not configure Root access or sudo to allow you to run the root script, click OK on the warning message. After the installation is complete, you can run the root script.

If you need to run any root script manually, execute it now. They are located on the agent home page (AGENT_HOME/agent_13.1.0.0.0/root.sh) on each monitored machine.

The upgraded principal is now complete.

Navigate to the Post-upgrade tasks screen (Settings > manage Cloud Control > Post-upgrade tasks). Highlight each task in the list, and then click the start button. This will only perform some final data migration.

Start / close

Cloud control is set to start automatically using the gcstartup service. The / etc/oragchome list file contains the projects that the system will start. After the upgrade, it may list two OMS installations. If you want to use this automatic startup, you need to modify the contents of the file to ensure that it is consistent with the new installation.

/ u01/app/oracle/middleware/u01/app/oracle/agent12c/agent_13.1.0.0.0:/u01/app/oracle/agent12c/agent_inst

In a simple installation, the default automatic startup will cause problems because the cloud control will try to start before the database starts. You can disable the service by commenting (using all the contents of the *) "/ etc/oragchome list" file to prevent automatic startup and use of the start / stop scripts described below.

If you need to start / stop automatically, you can do this in the usual way using the Linux service, which invokes a start / stop script that contains database management.

Use the following command to open all components installed in this article. If you have a startup / shutdown script, remember to modify it to consider the new path.

#! / bin/bashexport ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1export OMS_HOME=/u01/app/oracle/middlewareexport AGENT_HOME=/u01/app/oracle/agent12c/agent_inst# Start everything$ORACLE_HOME/bin/dbstart $ORACLE_HOME$OMS_HOME/bin/emctl start oms$AGENT_HOME/bin/emctl start agent

Use the following command to close all components installed in this article.

#! / bin/bashexport ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1export OMS_HOME=/u01/app/oracle/middlewareexport AGENT_HOME=/u01/app/oracle/agent12c/agent_inst$OMS_HOME/bin/emctl stop oms-all$AGENT_HOME/bin/emctl stop agent$ORACLE_HOME/bin/dbshut $ORACLE_HOME here, I believe you have a better understanding of "what is the method of upgrading Oracle13 by Oracle12 OEM". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.