Posted by Mir Sayeed Hassan on November 5th, 2022
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...
Read more..
Posted in Oracle 12C & 18C | Comments Off on How to Prevent an OS Authenticated Oracle User To Connect via sqlplus / as sysdba
Posted by Mir Sayeed Hassan on September 20th, 2022
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...
Read more..
Posted in Oracle 12C & 18C | Comments Off on Oracle 21C New Features: Immutable Tables
Posted by Mir Sayeed Hassan on September 18th, 2022
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 ~]$ srvctl status database...
Read more..
Posted in ASM | Comments Off on Stop the Single ASM Instance in Oracle Database
Posted by Mir Sayeed Hassan on June 25th, 2022
expdp from lower version (11.2.0) and import into higher version (19.x) in pluggable DB
Check the status of database.
SQL> select instance_name,version, open_mode from v$instance, v$database;
INSTANCE_NAME VERSION OPEN_MODE
---------------- ---------------------------------
testdb ...
Read more..
Posted in Datapump (Expdp/Impdp) | Comments Off on expdp from lower version (11.2.0) and import into higher version (19.x) in pluggable DB
Posted by Mir Sayeed Hassan on May 2nd, 2022
Find the Useful OPATCH Commands for Oracle Database
List inventory details of patch.
[oracle@miroradb ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch...
Read more..
Posted in DB Patch | Comments Off on Find the Useful OPATCH Commands for Oracle Database
Posted by Mir Sayeed Hassan on May 2nd, 2022
ORA-30032: The Suspended (Resumable) Statement has Timed Out in Oracle Database 11gR2(11.2.0.4)
Issue: This issue was occur while doing a transaction in real-time database & it’s was hung for few seconds & get the error
SQL> select instance_name, version, status, open_mode from V$database, v$instance;
INSTANCE_NAME VERSION STATUS OPEN_MODE
----------------...
Read more..
Posted in ORA-Error | Comments Off on ORA-30032: The Suspended (Resumable) Statement has Timed Out in Oracle Database 11gR2(11.2.0.4)
