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 Software from http://www.oracle.com/technetwork/oem/grid-control/downloads/linuxx8664soft-085949.html

UPGRADE Guide: http://docs.oracle.com/cd/E24628_01/upgrade.121/e22625/toc.htm

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


 


 

















UPGRADE AGENTS:













[oracle@IOMDC-LINT0004 bin]$ ./emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 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             : /u02/app/oracle/product/12.1.0/agent/agent_inst
Agent Log Directory    : /u02/app/oracle/product/12.1.0/agent/agent_inst/sysman/log
Agent Binaries         : /u02/app/oracle/product/12.1.0/agent/core/12.1.0.5.0
Agent Process ID       : 29975
Parent Process ID      : 29920
Agent URL              : https://IOMDC-LINT0004.domain:3872/emd/main/
Local Agent URL in NAT : https://IOMDC-LINT0004.domain:3872/emd/main/
Repository URL         : https://IOMDC-LINT0004.domain:4903/empbs/upload
Started at             : 2015-06-25 08:26:51
Started by user        : oracle
Operating System       : Linux version 2.6.32-504.16.2.el6.x86_64 (amd64)
Last Reload            : 2015-06-25 08:27:16
Last successful upload                       : 2015-06-25 08:38:22
Last attempted upload                        : 2015-06-25 08:38:22
Total Megabytes of XML files uploaded so far : 0.25
Number of XML files pending upload           : 0
Size of XML files pending upload(MB)         : 0
Available disk space on upload filesystem    : 90.28%
Collection Status                            : Collections enabled
Heartbeat Status                             : Ok
Last attempted heartbeat to OMS              : 2015-06-25 08:38:02
Last successful heartbeat to OMS             : 2015-06-25 08:38:02
Next scheduled heartbeat to OMS              : 2015-06-25 08:39:02
---------------------------------------------------------------
Agent is Running and Ready

Agent Update completed successfully.

Comments

Post a Comment

Popular posts from this blog

Oracle DataGuard – How to resize Redo Log and Standby Redo Log

Oracle DataGuard – How to resize Redo Log and Standby Redo Log set linesize 200 col dest_name for a30 select DEST_NAME,STATUS,PROTECTION_MODE,ARCHIVED_SEQ#,APPLIED_SEQ# from v$archive_dest_status; On Standby server - make file management parameter to manual if not: show parameter standby; alter system set standby_file_management=manual; ================== +     On Primary             + ==================  SQL> select group#,thread#,status from v$log; col member for a60 set linesize 200 select member,group#,status from v$logfile; SQL> select group#,thread#,status from v$log;     GROUP#    THREAD# STATUS ---------- ---------- ----------------          1          1 ACTIVE          2       ...
Read more

Exadata - Smart Scan Testing

Image
Exadata - SMART SCAN testing -------------------------------------------- Samrt scan works with cell offloading which relate to offloaded the sql processing from the database layer to the cell (storage) layer. Smart scan is the access mechanism to offload data from storage layer. For example passing only required data blocks after applying predicate filters at the cell layer instead of sending every possible blocks from cell server to database server.                           Figure 1: Traditional Database Storage I/O and SQL Processing Model   Process Steps: ------------------- 1.    The client issues a SELECT statement . 2.    The database kernel maps this request to the database files and extents which contain the table data. 3.    The database kernel issues the I/Os to read all the table bloc...
Read more

Exadata Flash Cache - Management

Total size of Flash CellCLI>  list flashcache attributes effectiveCacheSize          5.82122802734375T Flashcache Mode:  [root@Cellc01-adm ~]# su - celladmin cellcli CellCLI>  list cell attributes flashCacheMode,status          WriteThrough    online > list celldisk where disktype=flashdisk > list physicaldisk FLASH_1_1 detail List PhysicalDisk for FlashCache: CellCLI> list physicaldisk attributes name, disktype, makemodel, physicalrpm, physicalport, status      8:0           HardDisk      "HGST    H7240AS60SUN4.0T"                              normal      8:1  ...
Read more