Mir Sayeed Hassan – Oracle Blog

Patching Oracle Database 19C Grid Infrastructure on Standalone server for Patch_19.22 (p35940989)

Check the status of Database

[oracle@stagdb1 ~]$ sqlplus / as sysdba

SQL> select instance_name, version, open_mode from V$database, v$instance;

INSTANCE_NAME    VERSION        OPEN_MODE
---------------- ---------------------------
DBSTAGE  ... 
Read more..			

APPLY THE LATEST OPTACH (12.2.0.1.42) ON 19C DATABASE

Check the status of Database

SQL> select instance_name, version, open_mode from v$database, v$instance;

INSTANCE_NAME     VERSION        OPEN_MODE
---------------- ---------------------------
testdb1          19.0.0.0.0      READ WRITE

Check the last updated OPatch

[oracle@testdb... 
Read more..			

Export the data by using the where clause from Pluggable database in Oracle 19C

Check the database status

SQL> select instance_name,version, open_mode from V$instance, v$database;

INSTANCE_NAME    VERSION        OPEN_MODE
---------------- --------------------------
prod1db         19.0.0.0.0      READ WRITE

Check the CDB & PDB...
Read more..

Encrypting Pluggable database in Oracle 19c by using the Oracle Transparent Data Encryption (TDE).

Here will implement Transparent Data Encryption method in our Oracle 19c Test Environment, The Database should contain the Pluggable database init.

Check the database status, name , version of Oracle database

SYS @ ora19cdb > select status,version,... 
Read more..			

How to use the Proxy only connect in Oracle Database 19c

Usage of the proxy only connect as if you want the application schema can be only access through a proxy user, in this case no user connects directly to the application schema even though if you known the user password.

Check the status of database

SYS @ ora19cdb > select status,... 
Read more..			

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"... 
Read more..