Ameer Khan

Env Details:- Primary DB Version: 19.15 Env : RAC 2 node Exadata GI: 19.15.0.0 OS: OEL 7 Standby DB Version : 19.15 Env : Standalone DB on ODA GI: 19.15.0.0 OS: OEL 7 Scenario: – For one of my customers, there was a requirement to change compatible parameter in both primary and standby database. The customer… Continue Reading

[root@oda02 ~]# odaadmcli show env_hw BM ODA X7-2 Medium [root@hkoda02 ~]# fwupdate list disk ================================================== CONTROLLER ================================================== ID    Type   Manufacturer   Model     Product Name              FW Version     BIOS Version   EFI Version    FCODE Version  Package Version  NVDATA Version    XML Support ————————————————————————————————————————————————————————– c0    HDC    Intel          0xa182    0x4866                    –              –              –              –              –                –                 N/A DISKS =============== ID        Manufacturer   Model               ATA Model                     Chassis Slot   Type   Media   Size(GiB) FW Version ATA FW Ver XML Support —————————————————————————————————————————————————- c0d0      INTEL          SSDSGFTG480G7       INTEL_SSDSCKJB874G7           –       1      sata   SSD     447       0121       N2010121   N/A c0d1      INTEL          SSDSGFTG480G7       INTEL_SSDSCKJB874G7           –       –      sata   SSD     447       0121       N2010121   N/A [root@oda02 ~]# odaadmcli show server         Power State              : On         Open Problems            : 0         Model                    : ODA X7-2M         Type                     : Rack Mount         Part Number              : ODA X7-2M         Serial Number            : 19355THJ026         Primary OS               : Not Available         ILOM Address             : 172.10.38.191         ILOM… Continue Reading

Env:- DB : 12.1.0.2 GI: 19.0.0(Oracle restart) OS: OEL 7 DB Type: Standalone Database During execution of  rman duplicate database  following error is observed. RMAN> run{allocate auxiliary channel C1 DEVICE TYPE DISK;allocate auxiliary channel C2 DEVICE TYPE DISK;allocate auxiliary channel C3 DEVICE TYPE DISK;allocate auxiliary channel C4 DEVICE TYPE DISK;duplicate database to ‘E1THS’ backup location ‘/u01/rman18062021/databkp’ nofilenamecheck;}… Continue Reading

Issue:- [grid@hkgdbs004 bin]$ ./crsctl stop crs CRS-4013: This command is not supported in a single-node configuration. CRS-4000: Command Stop failed, or completed with errors. Solution:- There is no crs in standalone grid installation. Hence try shutting down Has Component [grid@hkgdbs004 bin]$ ./crsctl stop hasCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘hkgdbs004’CRS-2673: Attempting… Continue Reading

So while applying patch on grid home(19c) we faced the above error $ ./gridSetup.sh ApplyRU /u01/app/33803476 ERROR: The home is not clean. This home cannot be used since there was a failed OPatch execution in this home. Use a different home to proceed. Solution:- In our last attempt to patch grid home , the opatch… Continue Reading

Env:- 2 node RAC Database DB Version: 12.2.0.1 Platform:- Exadata x6 OS- OEL 7 Recently , while working on a crucial database upgrade project (12.2.0.1 to 19c), I came across with one observation . For upgrade , I ran preupgrade.jar script which generally throws a list of recommendations along with fixes . After checking the… Continue Reading

This is one handy script which helps how to extract DDL for a dbms scheduler job SQL> set long 999999 SQL> set pagesize 222 SQL> set long 1000 Syntax:- select dbms_metadata.get_ddl(‘PROCOBJ’,’JOB_NAME’,’OWNER OF THE JOB’) from dual; SQL>select dbms_metadata.get_ddl(‘PROCOBJ’,’PROD_DB_BACKUP’,’SYSTEM’) from dual; DBMS_METADATA.GET_DDL(‘PROCOBJ’,’PROD_DB_BACKUP’,’SYSTEM’) ——————————————————————————– BEGIN dbms_scheduler.create_job(‘”PROD_DB_BACKUP”‘, job_type=>’PLSQL_BLOCK’, job_action=> ‘BEGIN   jde_schema_backup(”(””PRODDTA””,””PRODCTL””,””SY920””,””SVM920′ ”’,””PD920””)”                    ,”soumyad@wizertech.in”                    ); END;’ , number_of_arguments=>0, start_date=>TO_TIMESTAMP_TZ(’10-JAN-2019… Continue Reading

In our daily life, sometimes we require to gather various information related to different jobs or jobs scheduled in dba_scheduler  and for many of us it becomes challenging to remember all the views to gather that information. Using this script, we can gather various information related to undo tablespace in a single go.  [db@server102 ~]$… Continue Reading

Step 1. Download latest version of  TFACTL from Doc ID 2550798.1 Step 2. Upload the downloaded zip into the server and extract it as Run tfactl as root user [root@jdepddb AHF]# ./ahf_setup AHF Installer for Platform Linux Architecture x86_64 AHF Installation Log : /tmp/ahf_install_221000_32516_2022_05_09-08_29_04.log Starting Autonomous Health Framework (AHF) Installation AHF Version: 22.1.0 Build Date: 202204111557 Default… Continue Reading

Objective:- Change DBID in oracle database . For example, we will be changing existing DBID LOGCDB to a new DBID UATCDB Step 1. Shutdown database instance SQL> shu immediate Database closed. Database dismounted. ORACLE instance shut down. Step 2. Start database in mount mode SQL> STARTUP MOUNT ORACLE instance started. Total System Global Area 4294964000… Continue Reading