Posted by Mir Sayeed Hassan on May 12th, 2024
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..
Posted in DB Patch | Comments Off on APPLY THE LATEST OPTACH (12.2.0.1.42) ON 19C DATABASE
Posted by Mir Sayeed Hassan on May 12th, 2024
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..
Posted in Datapump (Expdp/Impdp) | Comments Off on Export the data by using the where clause from Pluggable database in Oracle 19C
Posted by Mir Sayeed Hassan on April 23rd, 2024
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..
Posted in DBA Administration | Comments Off on Encrypting Pluggable database in Oracle 19c by using the Oracle Transparent Data Encryption (TDE)
Posted by Mir Sayeed Hassan on April 17th, 2024
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..
Posted in DBA Administration | Comments Off on How to use the Proxy only connect in Oracle Database 19c
Posted by Mir Sayeed Hassan on April 8th, 2024
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..
Posted in Datapump (Expdp/Impdp) | Comments Off on Export Dumpfile error with ORA-31617: unable to open dump file for write in RAC Database
Posted by Mir Sayeed Hassan on April 6th, 2024
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...
Read more..
Posted in DBA Administration | Comments Off on Configuration & Generating database report with DBSAT in Oracle 19C
