Verify the pbs’s in the database. Create the pluggable database using the below command. In the above screenshot, new pluggable database opened with errors and in restriction mode. While verifying…
Read MoreStep 1: Login to database where you want to change the sys password. In the example we choose Oracle Base Database Service. Step 2 : In the Database Page :…
Read MoreIntroduction: DbFetchX is a robust application designed to streamline data extraction, transformation, and retrieval from Oracle Databases. Its installation involves integrating the application’s schema, objects, and configurations into an Oracle…
Read MoreIntroduction: Upgrading from Linux 7 to Linux 8 in the Oracle Cloud Infrastructure (OCI) environment is a crucial step to ensure the operating system is up-to-date, secure, and capable…
Read MoreIntroduction: Oracle Cloud Infrastructure (OCI) offers robust tools and features that allow database administrators to manage backups and restores efficiently. Ensuring that data is securely backed up and easily restorable…
Read MoreIntroduction : Maintaining the security and performance of your Oracle Database is crucial, and applying patches is a key aspect of this maintenance. Oracle Cloud Infrastructure (OCI) simplifies the process…
Read MoreSETUPAWS CERTIFICATE TO SEND E-MAIL Download the certificates from the link provided by Amazon. Click on PEM Copy the text. Create five certificate file using notepad with extension .crt. Move…
Read MoreEnabling Database management and Operation insights in OCI console Enabling Database Management: Navigate to the Observability & Management. In the Observability & Management, under Database Management section select the…
Read MoreStep 1: List the disks using the below command. #oracleasm listdisks Step 2: Create the oracleasm disk using the below command. #oracleasm createdisk ARCH03 /dev/mapper/DISK014_ARCH_4T1 Step 3: Scan the disks…
Read MoreDescription : Oratop is an interface that takes data from top and oracle databases on a host. The utility combines the data to OS data and session data. It allows…
Read More