Ameer Khan

Step 1:- List all the current redo log file in databaseSQL> Select * from v$logfile;   GROUP#   TYPE    MEMBER                      ———- ——- ——- ————————————–         1   ONLINE  /u01/app/oracle/oradata/prim/redo01.log         2   ONLINE  /u01/app/oracle/oradata/prim/redo02.log         3   ONLINE… Continue Reading

Automating Object Privileges in Oracle with Stored Procedures Introduction Granting object privileges in Oracle can be a repetitive and time-consuming task, especially when dealing with multiple objects within a schema. This blog post demonstrates how to automate granting SELECT, INSERT, UPDATE, and DELETE privileges on all tables and views of a schema to a specified user using PL/SQL stored procedures. Creating… Continue Reading

How to take Hot backup & restore in  Oracle 11gR2 database:- Step 1:-Prerequisites:-$Select log_mode from v$database;If the database is not in archivelog mode then put the database in the archive log modesql>shut immediate;sql>startup mount;sql>alter database archivelog ;sql>alter database open; Step 2:-Taking a hot backup- Now that we have prepared our database for a hot backup,… Continue Reading

sqlplus / as sysdba SQL> archive log list;Database log mode              Archive ModeAutomatic archival             EnabledArchive destination            USE_DB_RECOVERY_FILE_DESTOldest online log sequence     13Next log sequence to archive   15Current log sequence           15 To check current archiving location: SQL> SHOW PARAMETER DB_RECOVERY_FILE_DEST NAME                                 TYPE        VALUE———————————— ———– ——————————db_recovery_file_dest                string      /u01/app/oracle/flash_recovery                                                 _area SQL> ALTER SYSTEM SET log_archive_dest =’/u01/arch’ scope=both;ERROR at line 1:ORA-02097:… 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… Continue Reading

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… Continue Reading

By default oracle stores audit data in system tablespace. Most of the customers tend to keep it in default tablespace but as a best practice its best to move the AUD$ table in a non system tablespaces. Step 1:-To find out existing tablespace of AUD$ table:- SQL> select owner,segment_name,segment_type,tablespace_name,bytes/1024/1024 as Size from dba_segments where segment_name=’AUD$’;… Continue Reading

Summary :-The table sys.user$ contains the field ptime, which keeps the time when the password waschanged the last time over. Do not confound it with ctime, which is the “creation time”, nor withltime, which is the time the account has been locked (if any). SQL>SELECT NAME, ptime AS “LAST TIME CHANGED”, ctime “CREATION TIME”, ltime… Continue Reading

Introduction Oracle Forms 11g lacks native support for client-side operations, such as file selection dialogs, clipboard access, or interactions with Microsoft Office. WebUtil bridges this gap by enabling Oracle Forms applications to perform these client-side operations. This guide provides a detailed step-by-step procedure to configure WebUtil in Oracle Forms 11g, complete with actual commands. 1.      Prepare the Database Schema for WebUtil Before… Continue Reading

Automating Oracle Forms 11g Compilation with a Shell Script In the world of Oracle applications, managing and compiling forms can be a time-consuming task, especially when dealing with a large number of forms. Fortunately, with the power of shell scripting in Linux, we can automate this process to save time and reduce errors. In this… Continue Reading