Hello Friend's, In This Post we will discuss about How to set and check the max size of PLUGGABLE DATABASE STORAGE So let's get started When creating a Pluggable Database (PDB) in a Container Database (CDB), you can set its maximum size limit using the STORAGE clause in the CREATE PLUGGABLE DATABASE command. If you need to adjust this limit later, you can use the ALTER PLUGGABLE DATABASE query. To alter a PDB's storage limit, you must connect to the PDB and issue the ALTER DATABASE command with the appropriate parameters. This is the only ALTER PLUGGABLE DATABASE operation that requires dedica ..read more

Hello Friend's, In This Post we will discuss about How to reolve ORA-28365 for Standby database So let's get started Error in Alert log : ORA-28365 Dwn-cvts replayed, VALBLKs dubious All grantable enqueues granted Reconfiguration complete (total time 0.2 secs) 2023-03-28T02:37:10.294247+03:00 Stopping change tracking 2023-03-28T02:37:10.298854+03:00 Errors in file /u02/app/oracle/diag/rdbms/cdbtmbp/CDBTESTDB/trace/CDBTESTDB_pr00_177969.trc: ORA-28365: wallet is not open 2023-03-28T02:37:11.484520+03:00 Background Media Recovery process shutdown (CDBTESTDB) All grantable enqueues granted Re ..read more

Hello Friend's, In This Post is continuation to discussion we started in part 1 about how to manage server ssh public keys with OKV , Now lets start with Part 2 So let's get started Step 1 : Generate ssh keys [oracle@dm01db01 okvrestcli]$ ssh-keygen -t rsa -b 2048 Generating public/private rsa key pair. Enter file in which to save the key (/home/oracle/.ssh/id_rsa): Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /home/oracle/.ssh/id_rsa. Your public key has been saved in /home/oracle/.ssh/id_rsa.pub. The key fingerprint is: SHA25 ..read more

Hello Friend's, In This Post we will discuss about how to manage server ssh public keys with OKV So let's get started Step 1 : Create Directory for wallet and log [oracle@dm01db01 extra]$ mkdir -p okvrestcli/wallet [oracle@dm01db01 extra]$ mkdir -p okvrestcli/log Step 2 download the software using the IP used in OK server installation [oracle@dm01db01 extra]$ cd okvrestcli/ [oracle@dm01db01 okvrestcli]$ curl -O -k https://192.168.136.146:5695/okvrestclipackage.zip % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload ..read more

Hello Friend's, In This Post we will discuss about how to install Configure OKV on vmware So let's get started What is OKV (Oracle Key Vault) : Oracle Key Vault is a specialized software program from Oracle that handles the storage and management of encryption keys, confidential data called secrets, and digital certificates throughout an organization. Functions of Oracle Key Vault (OKV): * **Key Management:** OKV acts as a central point for managing encryption keys used by different Oracle products and third-party software, such as databases, middleware, and applications. It stores these keys ..read more

Hello Friend's, In This Post we will discuss about how to migrate database from Noncdb to PDB 19.3 using autoupgrade utility So let's get started Enviornment Used for Activity Noncdb to PDB : Source : Hostname : MUMSX0019c.database.com Database : MIGDB Version : 19.3.0 CDB/PDB : NON CDB/PDB Oacle_Home : /oracle/app/orawork/product/19.0.0/db_1 OS : OEL 8.4 Target : Hostname : MUMSX0019c.database.com Database : CDBMIG PDB : MIGDB Version : 19.3.0 CDB/PDB : Yes Oacle_Home : /oracle/app/orawork/product/19.0.0/db_1 OS : OEL 8.4 The Oracle AutoUpgrad ..read more

Hello Friends, In this post we will talk about how we can install oracle clinet 19c on Oracle Linux 8.8 Work on GGHost : Unzip Oracle client : Version used 19c [oracle@Goldengate oracle]$ ls -ltr total 1108316 -rw-r--r--. 1 oracle oinstall 1134912540 Oct 28 14:15 LINUX.X64_193000_client.zip drwxr-xr-x. 3 oracle oinstall 21 Oct 28 18:05 app [oracle@Goldengate oracle]$ unzip --q LINUX.X64_193000_client.zip Archive: LINUX.X64_193000_client.zip creating: client/ inflating: client/runInstaller creating: client/install/ inflating: client/install/runInstaller.sh inflating: cl ..read more

Hello Friends, In this post we will talk about how we can Drop redologs from filesystem and recreate redo logs on ASM Path So the scenario is : Database has been migrated from NON ASM to asm and now in this post we will drop and recreate the redologs on ASM check for the current path of redologs from view v$logfile and v$log SQL> col MEMBER for a55 SQL> set lines 200 SQL> / GROUP# STATUS TYPE MEMBER IS_ CON_ID ---------- ------- ------- ------------------------------------------------------- --- ---------- 1 ..read more

Hello Friends, In this post we will talk about how we can recover dropped PDB after we flashback CDB (root container) So the scenario is : We were attempting database cloning; however, before cloning, we dropped PDB on the target side; moreover, due to some difficulty, it had to rollback the target to its former state, nevertheless, owing to the issue we dropped PDB, the datafiles were in Offline mode after flashback. Today, in this article, I'll explain how to solve the problem and restore the PDB to its original state. So lets get started. So we will start with the point of roll back of tar ..read more

Hello Friends, In this post we will discuss about an issue with the migrated database showing in failed state in OCI console . So lets get started, We had an issue where our migrated database CDBFIN was showing as failed in OCI console as in image below even my pdb in database was shown with wrong name . So i will provide the steps what i did to resolve the issue . Solution 1 : check the creg file on locaton below in the server it should be by the name of the database or there should be a softlink to the unique name ini file with database name cd /var/opt/oracle/creg/creg]$ ls -l...-rw-rw ..read more