Home Blog Page 3
full frame shot of shelf

Protected: 2 node RAC with Dataguard Configuration (DGMGRL)

0
This guide will take you through the steps configure Oracle Grid Infrastructure 12c and Database 12c including RAC to RAC Data Guard and Data...
people space apple industry

Protected: Fixing Corrupted Grid Home

0
--Detach home /u01/grid/oracle/product/11.2.0.4/grid export ORACLE_HOME=/u01/grid/oracle/product/11.2.0.4/grid cd /u01/grid/oracle/product/11.2.0.4/grid/oui/bin ./detachHome.sh --Validate the home are detached cat /u01/oracle/product/oraInventory/ContentsXML/inventory.xml --Take a backup of below files cd /u01/grid/oracle/product/11.2.0.4/grid/crs/install cp s_crsconfig_enabl11_env.txt /home/oracle/s_crsconfig_enabl11_env_bkp.txt cp crsconfig_params /home/oracle/crsconfig_params_bkp.txt --Remove the files...

Protected: srvctl related configurations

0
--add database to GRID and create the service, for example: srvctl add database -d cm1919 -i cm19191 -o $ORACLE_HOME -p "+M1919_DG1/m1919/spfilecm1919.ora" -a "M1919_DG1,M1919_DG_FLASH" -m world...
a close up shot of a command key

Protected: Monitor Standby Database with Lag Time Report

0
vi /home/oracle/scripts/lag_time_report_and_diskgroup_space.ksh #!/bin/ksh export ORACLE_SID=<Target_ORACLE_SID> export ORACLE_HOME=/u01/oracle/product/11.2.0.4/db /u01/oracle/product/11.2.0.4/db/bin/sqlplus -s / as sysdba << NACHO > /tmp/standbylag.log set feedback off select 'Standby thread '|| thread# || ' is '|| round((sysdate -...
person writing on notebook

Protected: Configure MRP in Standby

0
Add the Target Database TNS entry to the Source's tnsnames.ora file(s) (all of them if it's a clustered Source) Set the log_archive_dest_<#> parameter on the...
a close up shot of a command key

Protected: De-configure MRP in Standby

0
On Source, as Oracle user: export ORACLE_SID=<source_sid> sqlplus '/as sysdba' alter system set log_archive_dest_state_<whatever_#_used>='DEFER' scope=both sid='*'; alter system set log_archive_dest_<whatever_#_used>='' scope=both sid='*'; alter system set log_archive_config='dg_config=(<only the db_unique_name's...
a close up shot of a command key

Protected: Performance Tuning Scripts.

0
Top Wait Events: col EVENT format a60 select * from ( select active_session_history.event, sum(active_session_history.wait_time + active_session_history.time_waited) ttl_wait_time from v$active_session_history active_session_history where active_session_history.event is not null group by active_session_history.event order by 2 desc) where...
a close up shot of a command key

GGSCI Command for GoldenGate

0
INFO INFO MANAGER Provides details of the Manager process INFO MGR Also provides details of the Manager process STATUS MANAGER This command also display the info of manager REFRESH REFRESH MANAGER Reloads from...
black internal hdd on black surface

Recover Block Corruption

0
What is a data block corruption? Data block corruptions occur whenever data is not in its expected state. The block may have contents that are...

Resync Standby Database Using RMAN Incremental Backups

0
Normally in DR setup, the archives from primary shipped to standby and applied there. Suppose some of the archives hasn’t been shipped to secondary...
black blue and red graph illustration

RMAN Recovery Catalog in Oracle

0
RMAN recovery catalog is separate DB/ Server and which will save only the details of your backups in terms of metadata of the backup. Whenever...
yellow scrabble tiles

ORA-16525: DGMGRL Create Configuration Failing

0
PROBLEM: When DGMGRL is used to create DG broker configuration it fails with below error : DGMGRL> connect sys Password: Connected to "<DB_UNIQUE_NAME>" Connected as SYSDBA. DGMGRL> Create configuration...
yellow scrabble tiles

How to fix ‘ORA-01000 maximum open cursors exceeded’ issue in Oracle database

0
OPEN_CURSORS specifies the maximum number of open cursors (handles to private SQL areas) a session can have at once. You can use this parameter to...
a close up shot of a command key

RMAN Basic Commands

1
Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle data formats. RMAN  provides a common interface,...
a close up shot of a command key

RAC Basic Commands

0
Check the status of the cluster $ crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster...
a close up shot of a command key

Oracle Dataguard Scripts

0
1) Information of database (Primary & Standby). SQL> SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; 2) To display current status for Physical Standby...

Buffer & Dictionary Hit Ratio

0
The Data Buffer Hit Ratio Oracle metric is a measure of the effectiveness of the Oracle data block buffer. The higher the buffer hit ratio, the...
black and white photo of clocks

Protected: Linux Shell Script To Monitor GoldenGate Lag

0
Schedule this script on (Source & Destination) replication servers in order to detect the lag on all processes (Extract, Pump, and Replicate). Set following...

Relocating enabl database for oracle 19c

0
Relocating enabl database for oracle 19c 1:- After the upgrade add this hosting members as below $GRID_HOME/bin/crsctl modify resource ora.enabl.db -attr "HOSTING_MEMBERS='server01 server02' PLACEMENT='favored'" -unsupported 2:- Create...
close up photo of programming of codes

Oratop Utility

0
Oratop is a text based user interface tool similar to top command for monitoring basic database operations in real time for RAC and Standalone...

Standby : Unnamed file issue

0
Sun Jan 1 22:02:11 2022 Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb1/trace/proddb1_pr00_117080.trc: ORA-01111: name for data file 185 is unknown - rename to correct file ORA-0111: data file 185: '/u01/oracle/product/19/db/dbs/UNNAMED00185' ORA-01157:...
yellow scrabble tiles

Protected: CRS-41053: Checking Oracle Grid Infrastructure for file permission issues CRS-4000

0
# crsctl start crs CRS-41053: checking Oracle Grid Infrastructure for file permission issues PRVG-11960 : Set user ID bit is not set for file "/u01/app/grid/12.2.0/grid/bin/extjob" on...
close up shot of keyboard buttons

Protected: Improve Performance of Data Pump Import In Oracle 19c

0
The Oracle Data Pump Export and Import utilities are designed especially for very large databases. If you have large quantities of data versus metadata,...
yellow scrabble tiles

Protected: CRS-2974: unable to act on resource

0
Problem Summary: On a 19c RAC DB when shutting down instance using srvctl command it throws below error: $ srvctl stop instance -d prod -i...
close up shot of black rifle with scope

Protected: Create Trigger to Detect Client/App related error.

0
Use the CREATE TRIGGER statement to create and enable a database trigger, which is: A stored PL/SQL block associated with a table, a schema, or the database orAn anonymous...