Export Dumpfile error with ORA-31617: unable to open dump file for write in RAC Database Error occur while performing the Schema export in RAC Database. Error Occur. ORA-31693: Table data object "PRG1"."IRM":"P1575" failed to load/unload and is being skipped due to error: ORA-31617: unable to open dump file "/SWITCHBKP/DUMPBKP/PRG1_08042024_07.dmp" for write ORA-19505: failed to identify Read More The post Export Dumpfile error with ORA-31617: unable to open dump file for write in RAC Database appeared first on Mir Sayeed Hassan - Oracle Blog ..read more

Configuration & Generating database report with DBSAT in Oracle 19C Brief about DBSTAT: – The Oracle Database Security Assessment Tool (DBSAT) is a command-line tool focused on detecting potential security vulnerabilities in database. – This tool provides insight into the current status of users, roles, permissions, and security control policies to promote successful approaches and Read More The post Configuration & Generating database report with DBSAT in Oracle 19C appeared first on Mir Sayeed Hassan - Oracle Blog ..read more

Various methods to STARTUP,SHUTDOWN the Container(CDB) and Pluggable Databases(PDBs) in Oracle 19C STARTUP CONTAINER AND PLUGGABLE DATABASES Check the database env at OS Level [oracle@ora19c ~]$ cat /etc/oratab | grep -i ora19cdb ora19cdb:/u01/app/oracle/product/19.3.0/db_1:N Set the above database env [oracle@ora19c ~]$ . oraenv ORACLE_SID = [ora19cdb] ? ora19cdb The Oracle base remains unchanged with value /u01/app/oracle Read More The post Various methods to STARTUP,SHUTDOWN the Container(CDB) and Pluggable Databases(PDBs) in Oracle 19C appeared first on Mir Sayeed Hassan - Oracle Blog ..read more

Apply the latest DB RU Patch_19.19 (35042068) on Oracle Database 19C Check the status of Database SQL> select instance_name, version, open_mode from v$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE ---------------- ----------------- -------------------- oemswdb 19.0.0.0.0 READ WRITE Verify the lastest OPatch applied on it., If not use the below link to apply [oracle@OEM-DB-SW ~]$ cd /u01/app/oracle/product/19c/db_1/OPatch [oracle@OEM-DB-SW OPatch]$ Read More The post Apply the latest DB RU Patch_19.19 (35042068) on Oracle Database 19C appeared first on Mir Sayeed Hassan - Oracle Blog ..read more

Apply the Latest OMSPatcher on OEM Server before apply the Main DBRU Patch Check the status of the OMS [oracle@oemdb ~]$ cd /u01/OEM13.5C/middleware/bin/ [oracle@oemdb bin]$ ./emctl status oms Oracle Enterprise Manager Cloud Control 13c Release 5 Copyright (c) 1996, 2021 Oracle Corporation. All rights reserved. WebTier is Up Oracle Management Server is Up JVMD Engine Read More The post Apply the Latest OMSPatcher on OEM Server before apply the Main DBRU Patch appeared first on Mir Sayeed Hassan - Oracle Blog ..read more

Useful tips to find the Sysdate Commands from Oracle Database by issuing SQL Queries Find the First Day of the Month SQL> SELECT TRUNC (SYSDATE, 'MONTH') FROM DUAL; TRUNC(SYS --------- 01-JAN-23 Find the Last Day of the Month SQL> SELECT TRUNC (LAST_DAY (SYSDATE)) FROM DUAL; TRUNC(LAS --------- 31-JAN-23 Find the Number of Days in this Read More The post Useful tips to find the Sysdate Commands from Oracle Database by issuing SQL Queries appeared first on Mir Sayeed Hassan - Oracle Blog ..read more

How to create the trigger for failed & success login attemp in Oracle Database Note: The below given trigger is created to attempt the success and failed login attempt of the all the user in Oracle database., Data will be recorded in the table as well as at the OS Level (directory loc). Verify the Read More The post How to create the trigger for failed & success login attemp in Oracle Database appeared first on Mir Sayeed Hassan - Oracle Blog ..read more

How to Prevent an OS Authenticated Oracle User To Connect via SQLPLUS / AS SYSDBA Login to the server [oracle@testdb ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 – Production on Sat Nov 5 03:24:11 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 Read More The post How to Prevent an OS Authenticated Oracle User To Connect via sqlplus / as sysdba appeared first on Mir Sayeed Hassan - Oracle Blog ..read more

Oracle 21C New Features: Immutable Tables Overview of Immutable table: – The Functionality of the immutable table is inherits the similar syntax of Native Blockchain Table, but removes the link of internal row records to improve performance. – Benifits of the this immutable table is a read-only table, this can prevent the unauthorized/accidental/hacks/illegal changes in Read More The post Oracle 21C New Features: Immutable Tables appeared first on Mir Sayeed Hassan - Oracle Blog ..read more

Stop the Single ASM Instance in Oracle Database – To stop the ASM Instance, First we need to Stop the RDBMS & then we need to stop the ASM Instance Check the status of database [oracle@pri-db1 ~]$ srvctl status database -d testdb1 Instance testdb1 is running on node testdb1 Stop the RDBMS Database [oracle@pri-db1 ~]$ Read More The post Stop the Single ASM Instance in Oracle Database appeared first on Mir Sayeed Hassan - Oracle Blog ..read more