April 2020 ~ Blog for oracle RAC Goldengate Dataguard ASM database

Error in invoking target 'links proc gen_pcscfg procob' of makefile 12.1 database

Issue : Error in invoking target 'links proc gen_pcscfg procob' of makefile '/oracle/app/orawork/product/12.1.0.2/db_1/precomp/...

Sql_id used for example : 5qw0w762nh6sq Step 1 : Create Tuning Task DECLARE l_sql_tune_task_id VARCHAR2(100); BEGIN l_sql_tune_task_...

---------------------Stop and start db using srvctl------------------- -- SYNTAX FOR STOP DB --- srvctl stop database -d db_name [-o stop_op...

Steps to be done : Step 1 : SET MARKUP HTML ON SPOOL ON HEAD "<TITLE>LOGMNR - INFO </title> - <STYLE TYPE='TEXT/CS...

Windows to linux convert database 11.2.0.3 select * from v$version; select platform_id, platform_name from v$database; show parameter co...

ISSUE : SQL> alter database mount; alter database mount * ERROR at line 1: ORA-00214 : control file '+DATA/ISTDB/controlfile/Current....

DB Node config : Compute node : Do all prerequisite for database installation such as : sysctl.conf , limits.conf , rpm install there after ...

Issue : 2020/04/12 18:30:22 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service' 2020/04/12 18:31:54 CLSRSC-400: A...

Script 1 : Script will provide the output of full, incremental, and archive log backup with timing of backup col STATUS format a9 col hrs ...

ISSUE : [celladmin@Exacell ~]$ cellcli -e alter cell status services all Stopping the RS, CELLSRV, and MS services... The SHUTDOWN of servic...

Step 1 : VM setup 1. Create a VM with 8gb Ram and 1 cpu with 1 core 2. add 2 Nat to the vm while creation install linux 6.8 3...