Posted by Mir Sayeed Hassan on December 6th, 2022
Apply the Latest OPatch (12.2.0.1.34) Nov-2022 for 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
Check the last updated OPatch
[oracle@PROD-DB ~]$ $ORACLE_HOME/OPatch/opatch...
Read more..
Posted in DB Patch | Comments Off on Apply the Latest OPatch (12.2.0.1.34) Nov-2022 for Oracle Database 19c
Posted by Mir Sayeed Hassan on November 16th, 2022
Learn the basic command of Oracle ASM in Oracle Database
Login to the Oracle ASM Instance
[oracle@ractest1 ~]$ . oraenv
ORACLE_SID = [+ASM1] ? +ASM1
The Oracle base remains unchanged with value /u02/app/oracle
ls – It displays the list of disk associated to single instance.
ASMCMD> ls
DATA/
Posted in ASM | Comments Off on Learn the basic Oracle ASM Command in Oracle Database
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
