Sunday, 28 December 2025

Oracle Grid Infrastructure Upgrading Oracle Restart, 19c for Linux and Unix-Based Operating Systems

›
Oracle Grid Infrastructure Upgrading Oracle Restart, 19c for Linux and Unix-Based Operating Systems 1 Preparing to Upgrade Oracle Restart...

Oracle grid upgrade from 19.3 to 21.3

›
mkdir -p /u01/app/21.0.0/grid ls -ltr /u01/app/19.0.0/ pwd ls -ltr /u01/app/21.0.0/grid pwd ls -ltr *.zip unzip V...
Sunday, 21 December 2025

Oracle secure listener

›
Oracle secure listener https://anuj-singh.blogspot.com/2016/09/oracle-session-count-info-and-kill-and.html $ srvctl add listener -li...
Thursday, 4 December 2025

How to solve ORA-02291: integrity constraint violated - parent key not found

›
How to solve ORA-02291: integrity constraint violated - parent key not found . =====================================================...
Wednesday, 26 November 2025

unix command for DBA

›
Basic File Navigation The "pwd" command displays the current directory. root> pwd /u01/app/oracle/product/9.2.0.1.0 The ...
Tuesday, 18 November 2025

ON DELETE CASCADE | CASCADE CONSTRAINTS

›
ON DELETE CASCADE and CASCADE CONSTRAINTS ==================================================== CREATE TABLE DEPTX (DEPTNO NUMBER PRIMA...
Wednesday, 12 November 2025

ORA-02292: integrity constraint violated - child record found

›
SQL> delete from ANUJ.DEPT where deptno=10; delete from ANUJ.DEPT where deptno=10 * ERROR at line 1: ORA-02292: integrity constraint (ANU...