Tuesday, 6 December 2016

one eighth to one quartor Exadata X5-2


NOTE:
The resourcecontrol script source is used for this activity which is residing under /opt/oracle.SupportTools/onecommand/resourcecontrol on the first database server in the rack. Distributed resourcecontrol script  all database servers and cell nodes that require CPU cores to be disabled. Make sure this is placed in the proper location.

==> Blackout Setup using OEM

================
On compute nodes
===============
root@exadb01-adm
cd /opt/oracle.SupportTools/
#./resourcecontrol -show
[INFO] Validated hardware and OS. Proceed.
[SHOW] Number of cores active per socket: 9
[SHOW] Total number of cores active: 18

# ./resourcecontrol -core 36
----
---
[INFO] Import all bios settings
Preparing to restore XML file to BIOS...
Done preparing to restore settings in ------/bios_settings_new.xml to BIOS.
Restoring BIOS configuration (allow several minutes)................................................................................................................................................................................................................................Done.
[INFO] All bios settings have been imported with success

[ACTION] Reboot server for settings to take effect

Output will be like below:
$ ./resourcecontrol -show
[INFO] Validated hardware and OS. Proceed.
[SHOW] Number of cores active per socket: 18
[SHOW] Total number of cores active: 36
#reboot

===========
On cell nodes
===========

[root@iormsc01-adm ~]#cd /opt/oracle.SupportTools/
# ./resourcecontrol -show
# dcli -g cell_group -l root 'cellcli -e list cell attributes eighthrack'
Make eighthrack to False
# dcli -g cell_group -l root 'cellcli -e alter cell eighthrack=false'

From each storage cell node run
==========================
CellCLI> list celldisk
CellCLI> list celldisk
         CD_00_msc01_adm      normal
         CD_01_msc01_adm      normal
         CD_02_msc01_adm      normal
         CD_03_msc01_adm      normal
         CD_04_msc01_adm      normal
         CD_05_msc01_adm      normal
         FD_00_msc01_adm      normal
         FD_01_msc01_adm      normal

CellCLI> alter cell restart services all ignore redundancy;
CellCLI> create celldisk all;
CellCLI> create flashlog all;

Output will be like below:
CellCLI> list celldisk
         CD_00_msc01_adm        normal
         CD_01_msc01_adm        normal
         CD_02_msc01_adm        normal
         CD_03_msc01_adm        normal
         CD_04_msc01_adm        normal
         CD_05_msc01_adm        normal
         CD_06_msc01_adm        normal
         CD_07_msc01_adm        normal
         CD_08_msc01_adm        normal
         CD_09_msc01_adm        normal
         CD_10_msc01_adm        normal
         CD_11_msc01_adm        normal
         FD_00_msc01_adm        normal
         FD_01_msc01_adm        normal
         FD_02_msc01_adm        normal
         FD_03_msc01_adm        normal

Create Grid disks with additional celldisks
CellCLI> create griddisk <DATA_CD_06_*> celldisk =<6> size=<>
CellCLI> create griddisk <> celldisk =<7> size=<>
CellCLI> create griddisk <> celldisk =<8> size=<>
CellCLI> create griddisk <> celldisk =<9> size=<>
CellCLI> create griddisk <> celldisk =<10> size=<>
CellCLI> create griddisk <DATA_CD_11_*> celldisk =<11> size=<>

CellCLI> create griddisk all harddisk prefix=DATA, size=<>G;

CellCLI> create griddisk all harddisk prefix=RECO, cachingPolicy='none' ;


Referenece :
How to properly disable cores on Exadata database nodes (Doc ID 1499114.1)

Monday, 28 November 2016

Integrated Lights Out Manager Operation


Click below link -

Exadata-ilom-operation

APPLYING PATCH TO EXADATA FULL SYSTEMS

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