Monday, 28 November 2016

AWR baseline creation using OEM Cloud control

Please check below link for this article -

http://www.slideshare.net/monowar94ru/oracle-awr-baseline-basic


Enterprise Manager Cloud Control 12c upgrade to Release 5 [12.1.0.5]



Enterprise Manager Cloud Control 12c upgrade to Release 5 [12.1.0.5] from 12.1.0.4 with Repository database of 12.1.0.2 (Non-Container)


UPGRADE OMS



Download and unzipped Software
unzip em12105_linux64_disk1.zip
unzip em12105_linux64_disk2.zip
unzip em12105_linux64_disk3.zip

STOP AGENT

NOTE: All OMS and Agents were up to date patch level

[oracle@IOMDC-LINT0003 bin]$ ./emctl stop agent
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
Stopping agent .....stopped.

[oracle@IOMDC-LINT0004 bin]$ ./emctl stop agent
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
Stopping agent .....stopped.

STOP OMS
[oracle@IOMDC-LINT0004 bin]$  cd /u02/app/oracle/product/12.1.0/middleware/oms/bin/
[oracle@IOMDC-LINT0004 bin]$ ./emctl stop oms -all
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
AdminServer Successfully Stopped
Oracle Management Server is Down

Grant/Revoke Privileges

Reset Different database parameters[Repository database]if not set before --
Example:
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;
alter system set db_securefile=PERMITTED;
alter system set parallel_max_servers=10;
alter database add logfile group 4 '/u01/app/oracle/oradata/oem/redo04.log' size 300M;
alter database add logfile group 5 '/u01/app/oracle/oradata/oem/redo05.log' size 300M;
alter database add logfile group 6 '/u01/app/oracle/oradata/oem/redo06.log' size 300M;

grant execute on DBMS_RANDOM to DBSNMP;
grant execute on DBMS_RANDOM to SYSMAN;
revoke execute on DBMS_RANDOM from PUBLIC;


Check Invalid Objects
SQL> select owner,object_name, object_type from all_objects
where status='INVALID' and owner in
('SYS','SYSTEM','SYSMAN','MGMT_VIEW', 'DBSNMP','SYSMAN_MDS');
no rows selected

EMKEY COPIED TO THE REPOSITORY

[oracle@IOMDC-LINT0004 bin]$ ./emctlconfigemkey -copy_to_repos_from_file \
> -repos_host IOMDC-LINT0004.domain -repos_port 1524 -repos_sidoem \
> -repos_usersysman -emkey_file /u02/app/oracle/product/12.1.0/middleware/oms/sysman/config/emkey.ora
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
Enter Admin User's Password :
Enter Enterprise Manager Root (SYSMAN) Password :
The EMKey has been copied to the Management Repository. This operation will cause the EMKey to be                                            come unsecure.
After the required operation has been completed, secure the EMKey by running "emctlconfigemkey                                             -remove_from_repos".

Run Installation
$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 400 MB.   Actual 4731 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 16318 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-06-24_02-27-20PM. Please


 
 


Step 3 Prerequisite check, only failed was for ulimit value



I checked and it was unlimited – so expected 4096.

[oracle@IOMDC-LINT0004 EM]$ ulimit
unlimited