NB: Kindly note that the Repository DB and OEM is ready installed and running
Environments: Repos db OEM
Repo_host: db.db.com Hostname:upgrade.db.com
Repos_sid: DBLAB
--check if SYSMAN and DBSNMP has execute privilege to DBMS_RANDOM package and
--PUBLIC role has NO access to DBMS_RANDOM
SQL> GRANT EXECUTE ON dbms_random TO dbsnmp;
SQL> GRANT EXECUTE ON dbms_random TO sysman;
SQL> REVOKE EXECUTE ON dbms_random FROM public;
--Run emctl to copy EMKey from emkey.ora file to the management repository database
./emctl config emkey -copy_to_repos_from_file -repos_host db.db.com -repos_port 1521 -repos_sid DBLAB -repos_user sysman -emkey_file $OMS_HOME/sysman/config/emkey.ora
--check for invalid packages on repository database
SELECT owner, object_name, object_type,status FROM dba_objects WHERE status = 'INVALID' AND owner IN ('SYS', 'SYSTEM', 'SYSMAN', 'MGMT_VIEW', 'DBSNMP', 'SYSMAN_MDS');
--Compile invalid objects
SQL> EXEC UTL_RECOMP.recomp_serial('SYS');
SQL> EXEC UTL_RECOMP.recomp_serial('DBSNMP');
SQL> EXEC UTL_RECOMP.recomp_serial('SYSMAN');
--Stop the OMS
cd $OMS_HOME/oms/bin
./emctl stop oms -all
----INCASE of ERROR : Insufficient privileges to access Database Vault features
1.SQL> GRANT SELECT_CATALOG_ROLE to sys;
2.--Stop the database, Database Control console process, and listener
$ sqlplus sys as sysdba
SQL> shu immediate
$ emctl stop dbconsole
$ lsnrctl stop
3.--For Oracle RAC installations, shut down each database instance as follows:
$ srvctl stop database -d db_name
4.--Disable the Oracle Database Vault option --on the repostory DB
cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk dv_off
$ cd $ORACLE_HOME/bin
relink all
5.--After the above is completed run;
$ chopt disable dv
6.--Stop the listener ,database and the Database Control console process
$ lsnrctl start
$ sqlplus sys as sysdba
SQL> startup
$ emctl start dbconsole
---INCASE of processes ERROR: run the alter statements and proceed
sqlplus / as sysdba
ALTER SYSTEM SET processes=300 SCOPE=SPFILE;
ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;
ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;
ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;
ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;
ALTER SYSTEM SET job_queue_processes=20 SCOPE=SPFILE;
--UPGRADE AGENT after a sucessiful upgrade --on the Console
Setup>cloud control>agent upgade task> select the agents you want to upgrade>next>......>click done
Setup>cloud control>post >agent upgade task>select the agents from the list>click submit
--Before upgrade
[oracle@upgrade bin]$ ./emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 3
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 12.1.0.3.0
OMS Version : 12.1.0.3.0
Protocol Version : 12.1.0.1.0
Agent Home : /u01/app/oracle/agent_base/agent_inst
Agent Binaries : /u01/app/oracle/agent_base/core/12.1.0.3.0
Agent Process ID : 3187
Parent Process ID : 3140
Agent URL : https://upgrade.db.com:3872/emd/main/
Repository URL : https://upgrade.db.com:4904/empbs/upload
Started at : 2015-10-15 17:25:59
Started by user : oracle
Last Reload : (none)
Last successful upload : 2015-10-15 21:48:21
Last attempted upload : 2015-10-15 21:48:21
Total Megabytes of XML files uploaded so far : 0.43
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0
Available disk space on upload filesystem : 45.06%
Collection Status : Collections enabled
Heartbeat Status : Ok
Last attempted heartbeat to OMS : 2015-10-15 21:54:25
Last successful heartbeat to OMS : 2015-10-15 21:54:25
Next scheduled heartbeat to OMS : 2015-10-15 21:55:25
---------------------------------------------------------------
--After upgrade
[oracle@upgrade bin]$ ./emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 12.1.0.5.0
OMS Version : 12.1.0.5.0
Protocol Version : 12.1.0.1.0
Agent Home : /u01/app/oracle/agent_base/agent_inst
Agent Log Directory : /u01/app/oracle/agent_base/agent_inst/sysman/log
Agent Binaries : /u01/app/oracle/agent_base/core/12.1.0.5.0
Agent Process ID : 18623
Parent Process ID : 18579
Agent URL : https://upgrade.db.com:3872/emd/main/
Local Agent URL in NAT : https://upgrade.db.com:3872/emd/main/
Repository URL : https://upgrade.db.com:4904/empbs/upload
Started at : 2015-10-16 08:04:03
Started by user : oracle
Operating System : Linux version 3.8.13-16.2.1.el6uek.x86_64 (amd64)
Last Reload : 2015-10-16 08:06:49
Last successful upload : 2015-10-16 08:49:38
Last attempted upload : 2015-10-16 08:49:38
Total Megabytes of XML files uploaded so far : 0.29
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0
Available disk space on upload filesystem : 47.48%
Collection Status : Collections enabled
Heartbeat Status : Ok
Last attempted heartbeat to OMS : 2015-10-16 08:53:20
Last successful heartbeat to OMS : 2015-10-16 08:53:20
Next scheduled heartbeat to OMS : 2015-10-16 08:54:20
---------------------------------------------------------------
Agent is Running and Ready
Have fun and learn more !!!
No comments:
Post a Comment