Oracle blogs

 

https://www.luxoug.org/configuring-tde-on-a-pdb-with-plug-and-unplug-option/

https://ittutorial-org.cdn.ampproject.org/c/s/ittutorial.org/oracle-19c-database-upgrade-from-18-9-to-19-8-0-0-on-exadata-x7-oracle-19c-database-upgrade-manual-method/amp/

https://ittutorial.org/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba/

https://ittutorial-org.cdn.ampproject.org/c/s/ittutorial.org/oracle-database-architecture-1-controlfile-datafile-sga-and-pga/amp/

https://ittutorial.org/sql-server-mssql-dba-database-tutorials-for-beginners-database-administrators/

http://blog.umairmansoob.com/tag/patching-exadata-machine/

http://blog.umairmansoob.com/shutting-down-exadata-storage-cell-for-maintenance/

http://blog.umairmansoob.com/migrating-database-from-aix-to-exadata-using-data-pump/

http://blog.umairmansoob.com/clone-oracle-database-home-on-exadata-machine/

http://blog.umairmansoob.com/deconfigure-reconfigure-exadata-node-from-crs/

http://blog.umairmansoob.com/how-to-clear-exadata-storage-alerts/

http://blog.umairmansoob.com/drop-cell-disks-before-converting-to-1-8th-rack/

https://emilianofusaglia.net/2020/02/16/bulk-exadata-patching/

Read the following MOS notes carefully.

• Exadata Database Machine and Exadata Storage Server Supported Versions (Doc ID 888828.1)
• Exadata 18.1.12.0.0 release and patch (29194095) (Doc ID 2492012.1)   
• Oracle Exadata Database Machine exachk or HealthCheck (Doc ID 1070954.1)dbnodeupdate.sh and dbserver.patch.zip: Updating Exadata Database Server Software using the DBNodeUpdate Utility and patchmgr (Doc ID 1553103.1)   

• Download latest Exachk utility from the MOS note. As of writing the latest Exachk verion available is “12.2.0.1.4_20171212”

Oracle Exadata Database Machine exachk or Health Check (Doc ID 1070954.1)

https://netsoftmate.com/exadata-health-check-exachk/

https://netsoftmate.com/convert-physical-standby-to-snapsho/

https://netsoftmate.com/blog/creating-new-file-system-on-exadata-compute-node/

https://netsoftmate.com/blog/how-to-restore-compute-node-from-snapshot-backup-for-oracle-exadata/

https://netsoftmate.com/blog/step-by-step-exadata-storage-cell-rescue/

https://www.oracle.com/technical-resources/articles/enterprise-manager/exadata-commands-intro.html

Exadata alert

dcli -l root -g ~/cell_group "cellcli -e list metriccurrent where alertState!=\'Normal\'"

Exadata cell CPU utilization

dcli -l root -g ~/cell_group "cellcli -e list metriccurrent CL_CPUT"

Exadata cells flashdisk with status NOT present

dcli -l root -g ~/cell_group "cellcli -e list physicaldisk attributes name, id, slotnumber where disktype=\"flashdisk\" and status=\'not present\'"

Exadata cell current temperature

dcli -l root -g ~/cell_group 'cellcli -e list cell detail' | egrep temperature 

Exadata alert history

dcli -l root -g ~/cell_group "cellcli -e list metrichistory where alertState!=\'Normal\'" 

Exadata cells battery replacement checks

dcli -l root -g ~/cell_group '/opt/MegaRAID/MegaCli/MegaCli64 -adpbbucmd -aALL' |grep replaced

Exadata cells harddisk with status NOT present

dcli -l root -g ~/cell_group "cellcli -e list physicaldisk attributes name, id, slotnumber where disktype=\"harddisk\" and status=\'not present\'" 

Exadata cells services checks

dcli -l root -g ~/cell_group 'cellcli -e list cell detail' | egrep '(cellsrvStatus)|(msStatus)|(rsStatus)'

Exadata cells memory checks

dcli -l root -g ~/cell_group --vmstat="-a 3 2"

Exadata physical memory checks

dcli -g ~/all_group -l root "cat /proc/meminfo | egrep '^MemTotal:|^MemFree:|^Cached:

Exadata physical disk checks

dcli -g ~/all_group -l root /opt/MegaRAID/MegaCli/MegaCli64 AdpAllInfo -aALL | grep "Device Present" -A 8

Exadata cell fan status

dcli -l root -g ~/cell_group 'cellcli -e list cell detail' | egrep fan 

Exadata storage cell model detail

dcli -l root -g ~/cell_group 'cellcli -e list cell detail' | egrep makeModel -- For cell

dcli -l root -g ~/dbs_group 'dmidecode -s system-product-name'  -- For DB node

Exadata cells power status

dcli -l root -g ~/cell_group 'cellcli -e list cell detail' | egrep power

SET LONG 20000

SET LONGCHUNKSIZE 20000

SET PAGESIZE 0

SET LINESIZE 1000

SET FEEDBACK OFF

SET VERIFY OFF

SET TRIMSPOOL ON

 

BEGIN

   DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'SQLTERMINATOR', true);

   DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'PRETTY', true);

END;

/

 

--extract tablespaces. Replace TBS1, TBS2

 

SELECT DBMS_METADATA.get_ddl ('TABLESPACE', tablespace_name)

FROM   dba_tablespaces

WHERE  upper(tablespace_name) in ('TBS1','TBS2')

--role DDL

 

--extract roles. Replace ROLE1, ROLE2

 

select dbms_metadata.get_ddl('ROLE', role) AS ddl

from   dba_roles

where  upper(role) in

( 'ROLE1','ROLE2')

 

--role grants

select 'grant ' || granted_role || ' to ' || GRANTEE || ';'

from dba_role_privs

where grantee in

('ROLE1','ROLE2');

order by granted_role;

 

--system grants to roles

select ' grant ' || privilege || ' to ' || grantee || ';'  as system_grants

from dba_sys_privs where grantee in ('ROLE1','ROLE2');

 

--extract profile DDL

select dbms_metadata.get_ddl('PROFILE', profile) as profile_ddl

from   (select distinct profile from   dba_profiles)

where  upper(profile) in ('DEFAULT');

 

--extract public synonyms

select 'create or replace public synonym ' || SYNONYM_NAME ||

' for ' || table_owner || '.' || table_name || ' ;'

from dba_synonyms

where owner='PUBLIC'

and table_owner in ('USER1','USER2')

order by table_owner, synonym_name;

 

--extract db links through expdp; parameter file

expdp_public_db_links.par

 

DIRECTORY=UPG_DIR

REUSE_DUMPFILES=YES

DUMPFILE=expdp_public_db_links.dmp

LOGFILE=expdp_public_db_links.log

SCHEMAS=PUBLIC

INCLUDE=DB_LINK