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

  1. The Skill PediaMarch 10, 2023 at 10:59 PM

    Really good post, thanks for sharing..
    Oracle Training Online

    ReplyDelete
  2. GeoPITS Global Pvt LtdJune 23, 2026 at 10:40 PM

    Thank you for sharing this valuable information. It’s an excellent resource for database professionals looking to enhance their Oracle knowledge and stay current with industry best practices. For businesses seeking dependable oracle dba support services , GeoPITS is a trusted provider known for expert database management, performance tuning, and proactive support.

    ReplyDelete

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

Oracle Standby database

Shutting Down a Physical Standby Database Issue the following query to find out if the standby database is performing Redo Apply or real-time apply.  If the MRP0 or MRP process exists, then the standby database is applying redo. SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY; If Redo Apply is running, cancel it as shown in the following example: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; Shut down the standby database. SQL> SHUTDOWN IMMEDIATE; Start and mount the physical standby database: SQL> STARTUP MOUNT; Start Redo Apply or real-time apply: To start Redo Apply, issue the following statement: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  DISCONNECT FROM SESSION; To start real-time apply, issue the following statement: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  USING CURRENT LOGFILE; ALTER SESSION SET nls_date_format=’DD-MON-YYYY HH24:MI:SS’; select ...
Read more

SQL to find the SQL,SID , long running , CPU, I/O

Script – Find SQL being executed by a OS Process ID (PID) prompt "Please Enter The UNIX Process ID" set pagesize 50000 set linesize 30000 set long 500000 set head off select s.username su, substr(sa.sql_text,1,540) txt from v$process p, v$session s, v$sqlarea sa where p.addr=s.paddr and s.username is not null and s.sql_address=sa.address(+) and s.sql_hash_value=sa.hash_value(+) and spid=&SPID; script used to find out cpu used by this session SELECT substr(a.sid,1,5) "Sid", substr(a.process,1,7) "Process", nvl(a.USERNAME,'ORACLE PROC') "user", v.value "CPU used by this session" FROM v$statname s, v$sesstat v, v$session a WHERE s.name = 'CPU used by this session' and v.statistic#=s.statistic# AND v.sid = a.sid and v.value > 0 ORDER BY v.value DESC; Top 10 cpu heavy SQLs set pagesize 999 set linesize 150 col cpu_time format 9999999999 heading "Cputime" col sql_text f...
Read more