asrblogger, Author at ASRblogger

Protected: Invalid Sys object after applying PSU patch

This content is password protected. To view it please go to the post page and enter the password.

asrblogger July 26, 2022

Cluster failed to start due to ASM password file Issue (ORA-01017: invalid username/password)

Node server2 got evicted from the Cluster due to NIC hardware failure oracle@server2 /home/oracle06:19:25 : olsnodes -nserver1 1server2 2server3 3 DB Alert Log: /u01/oracle/product/diag/crs/server3/crs/trace/alert.log String containing event: 2022-07-09 04:06:51.055 [OCSSD(62652)]CRS-1612:…

asrblogger July 26, 2022No Comments

Oracle

WHILE RUNNING DATAPATCH VERBOSE WE ARE GETTING FOLLOWING ERROR ORA-20002, ORA-04088, ORA-00604, ORA-20002

ISSUE: - WHILE RUNNING DATAPATCH VERBOSE WE ARE GETTING FOLLOWING ERROR -> Error at line 255138: script md/admin/sdordfm.plb- ORA-20002: ORA-06502: PL/SQL: numeric or value error: character string buffer-> Error at…

asrblogger July 26, 2022No Comments

Oracle

PDB went in restricted mode in Oracle 19c

Issue: PDB went into restricted mode Investigation su - oracle export ORACLE_HOME=/u01/oracle/product/19/db export ORACLE_SID= cp9494 $ORACLE_HOME/OPatch/datapatch -verbose If you get INVALID object error, run the utlrp as below cd $ORACLE_HOME/rdbms/admin$ORACLE_HOME/perl/bin/perl…

asrblogger July 26, 2022No Comments

DataGuard Oracle

ORA-10567: Redo is inconsistent with data block on standby !!

Issues: ORA-10567: Redo is inconsistent with data block on standb Error: Thu May 21 18:24:10 2022 Errors in file /u02/diag/rdbms/prod/prod1/trace/prod1_pr0s_12697.trc (incident=360771): ORA-00600: internal error code, arguments: [3020], [408], [671265], [1711947297],…

asrblogger July 26, 2022No Comments

Oracle

Export from 11g and import to 19c

To perform the export/import first we need to create a backup directory at the OS level as well as Database level using the following steps. Create a backup directory $mkdir…

asrblogger July 19, 2022No Comments

Oracle RAC

Protected: Fixing a Corrupt Database Home.

This content is password protected. To view it please go to the post page and enter the password.

asrblogger July 18, 2022

Oracle

Recovery using datafile copy – SWITCH DATAFILE TO COPY

By using Optimized Incremental Backup to disk backup strategy, an up to date copy of the database is always available on disk. In the event of a failure, the SWITCH…

asrblogger July 16, 2022No Comments

Oracle SQL

Trigger – Oracle Database Objects

Overview of Triggers A database trigger is a compiled stored program unit, written in either PL/SQL or Java, that Oracle Database invokes ("fires") automatically in certain situations. A trigger fires…