Pluggable Database – Ahmed AbdelFattah Blog !

ORA-01017: invalid username/password; logon denied

Posted on March 19, 2023 by Ahmed Abdel Fattah

I have a virtual machine with Oracle Database 19c installed. I downloaded this machine from Oracle. {If you are interested, you can download it from the following url: https://www.oracle.com/downloads/developer-vm/community-downloads.html } I started the virtual machine, login as oracle user, and ensured that the environment is set correctly: Then, I tried to login to the database … Continue reading ORA-01017: invalid username/password; logon denied

Oracle Database Security Assessment Sample Report

Posted on April 25, 2021April 25, 2021 by Ahmed Abdel Fattah

Highly Confidential Assessment Date & Time Date of Data CollectionDate of ReportReporter VersionSun Apr 25 2021 00:12:00Sun Apr 25 2021 00:22:012.2.1 (May 2020) - f3a1 Database Identity NameContainer (Type:ID)PlatformDatabase RoleLog ModeCreatedORCLCDBPDB1 (PDB:4)Linux x86 64-bitPRIMARYNOARCHIVELOGMon Jan 13 2020 20:12:00 Summary SectionPassEvaluateAdvisoryLowRiskMediumRiskHighRiskTotalFindingsBasic Information0000011User Accounts70222013Privileges and Roles156100022Authorization Control0020002Fine-Grained Access Control0050005Auditing08500013Encryption0110002Database Configuration92010113Network Configuration0110103Operating System2200105Total33201734279 Basic Information Database Version Oracle … Continue reading Oracle Database Security Assessment Sample Report

Oracle RMAN Multi-Section Feature

Posted on December 30, 2020 by Ahmed Abdel Fattah

RMAN can optionally break up large files into sections and back up and restore these sections independently. This feature is built into RMAN. You can use it by creating multisection backups, which break up the files generated for the backup set into separate files. This can be done for backup sets and image copies. Each … Continue reading Oracle RMAN Multi-Section Feature

Oracle Backup & Recovery Hands-on Practice – Oracle Database 18c VM

Posted on September 30, 2020October 2, 2020 by Ahmed Abdel Fattah

Do you want to practice recovering from the following common failures (with a guided step-by-step procedure)?: Recovering from a critical file loss (SYSTEM , UNDO)Recovering from a non-critical file lossRecovering from the loss of the control fileRecovering from the loss of all control filesRecovering from the loss of an inactive redo log fileRecovering from the … Continue reading Oracle Backup & Recovery Hands-on Practice – Oracle Database 18c VM

Alter Pluggable Database Open – (ORA-00604/ORA-01405) After Apex Installation

Posted on May 2, 2020 by Ahmed Abdel Fattah

While trying to open one pluggable database, I got the following errors: Background: While installing Apex 20.1 in one PDB, and while being very close to the installation completion, the session fully stucked.I restarted the database (the CDB), then I tried to open the PDB, but I got the above errors. While searching for this … Continue reading Alter Pluggable Database Open – (ORA-00604/ORA-01405) After Apex Installation

Is it possible to map one Tablespace to many Tablespaces with impdp?

Posted on March 18, 2020 by Ahmed Abdel Fattah

I got this question from one of my clients. He is going to migrate one database from one platform to another. In this database many users are sharing the same tablespace. For example: In the current database, all application users are sharing the tablespaces “USERS” The client wants to change this, so as each schema … Continue reading Is it possible to map one Tablespace to many Tablespaces with impdp?

Oracle Database 19c (19.3) Installation on the Oracle Cloud Compute Instance.

Posted on January 13, 2020January 16, 2020 by Ahmed Abdel Fattah

As, I already have access to one Oracle Cloud Free Compute Instance (Oracle Linux), then I decided to install Oracle database 19c there and create a test database. This time, I'll use a different technique by installing Oracle Database rpm.Oracle delivered the oracle database software as rpm for Linux since Oracle 18c. Installation procedure is … Continue reading Oracle Database 19c (19.3) Installation on the Oracle Cloud Compute Instance.

Oracle Read Only Tables

Posted on January 12, 2020January 12, 2020 by Ahmed Abdel Fattah

Starting from Oracle 11gR1, oracle allows us to change a table to be a read-only table. Let us have a quick demo: I'm connecting as user HR ( to a 19c pluggable database). I have a small table "DEPT": So, now I'm going to change the table to be read only table: Now let us … Continue reading Oracle Read Only Tables