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)








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

Comments

Post a Comment

Popular posts from this blog

QUERY DATAGUARD AND STANDBY STATUS

-- Find which logs were applied in the last day  SELECT SEQUENCE#, to_char(FIRST_TIME,'hh24:mi:ss dd/mm/yyyy'), to_char(NEXT_TIME,'hh24:mi:ss dd/mm/yyyy'),APPLIED FROM V$ARCHIVED_LOG where next_time>sysdate-1 ORDER BY SEQUENCE# ; -- Find last applied log   select to_char(max(FIRST_TIME),'hh24:mi:ss dd/mm/yyyy') FROM V$ARCHIVED_LOG where applied='YES';   -- What are the managed standby processes doing?   SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;   -- Are we on production or standby?  SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE;   -- Check for errors  SELECT MESSAGE FROM V$DATAGUARD_STATUS;   -- Check that the DB was openned correctly   SELECT RECOVERY_MODE FROM V$ARCHIVE_DEST_STATUS; -- important lag statistics  select * from v$dataguard_stats;  -- co...
Read more

Blocking session on RAC database

Blocking session on RAC database Blocking session of the databases Generate the report for Blocking session The SQL will provide Blocking sessions with SID, node information SELECT DISTINCT S1.USERNAME || '@' || S1.MACHINE || ' ( INST=' || S1.INST_ID || ' SID=' || S1.SID || ' ) IS BLOCKING ' || S2.USERNAME || '@' || S2.MACHINE || ' ( INST=' || S1.INST_ID || ' SID=' || S2.SID || ' ) ' AS BLOCKING_STATUS FROM GV$LOCK L1, GV$SESSION S1, GV$LOCK L2, GV$SESSION S2 WHERE S1.SID=L1.SID AND S2.SID=L2.SID AND S1.INST_ID=L1.INST_ID AND S2.INST_ID=L2.INST_ID AND L1.BLOCK > 0 AND L2.REQUEST > 0 AND L1.ID1 = L2.ID1 AND L1.ID2 = L2.ID2; Blockers information select s1.username || '@' || s1.machine  || ' ( SID=' || s1.sid || ' ) is blocking '  || s2.username || '@' || s2.machine || ' ( SID=' || s2.sid || ' ) ' AS blocking_status from gv$lock l1, gv$session s...
Read more

Finding object size in Oracle database

Ref: http://www.runningoracle.com/product_info.php?cPath=2_44&products_id=153 Finding object size in Oracle database is very important and common. Is it very useful to know the exact size occupied by the object at the tablespace. The object size in the following scripts is in Mbytes. The scripts have been formatted to work very easily with TOAD SQL Editor. For example you can filter with tablespace_name, or owner, or size (for example more than 1GByte)  SELECT owner, segment_name, segment_type, partition_name, ROUND(bytes/(1024*1024),2) SIZE_MB, tablespace_name  FROM DBA_SEGMENTS  WHERE SEGMENT_TYPE IN ('TABLE', 'TABLE PARTITION', 'TABLE SUBPARTITION',  'INDEX', 'INDEX PARTITION', 'INDEX SUBPARTITION', 'TEMPORARY')  --AND TABLESPACE_NAME LIKE 'COSTE%'  --AND SEGMENT_NAME LIKE 'P2010201%'  --AND partition_name LIKE 'P20100201%' --AND segment_type = 'TABLE' --AND OWNER = 'TARG...
Read more