ORA-01144: File size (4194304 blocks) exceeds maximum of 4194303 blocks

You may get this error while creating a tablespace in your environment.

Oracle has some boundaries to set datafile maximum size based on the db_block_size parameter. db_block_size maximum allowed size for datafile 2k 8GB 4K 16GB 8K 32GB 16K 64GB 32K 128GB The formula to calculate the max size is db_block_size * 4194303. If […]

Read More

Physical Standby Database: Redo Apply Architecture

In the previous article, we have seen basics about the architecture of Oracle Dataguard. Oracle Dataguard Architecture Oracle Data Guard works on physical standby and logical standby sites. Physical Standby: When primary database generates redo entries, those redo are transferred to standby database and then redo is applied to standby database. Logical Standby: When primary […]

Read More

Upgrade Grid Infrastructure to 18.2 by applying RU

Database 18c Patch As of the Release date (17-Apr-2018), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Therefore, the following patches for Oracle Database 18 are only for on-premise Exadata systems that are running Oracle Database 18.1.0. More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1) OPatch Utility Information You must […]

Read More

Upgrade Version to 18.2 from Oracle 18c by applying RU

Database 18c Patch As of the Release date (17-Apr-2018), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Therefore, the following patches for Oracle Database 18 are only for on-premise Exadata systems that are running Oracle Database 18.1.0. More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1) OPatch Utility Information […]

Read More

CDB Fleets in Oracle 18c

A lead CDB is the central location for monitoring and managing the CDBs in the fleet. A CDB fleet provides the database infrastructure for scalability and centralized management of many CDBs. Designate one CDB in the fleet to be the lead CDB by setting its LEAD_CDB database property to TRUE. The other CDBs in the […]

Read More

SET ROWLIMIT in Oracle 18c

Sets a limit for the number of rows to display for a query. By default, ROWLIMIT is OFF. SET ROWLIMIT {n | OFF} n can be any number between 1 and 2,000,000,000. An error is displayed when the value that is entered is outside this range. OFF displays all the rows in the output. Example To set […]

Read More

Duplicating a PDB to an Existing CDB in Oracle 18c

Use the DUPLICATE command to duplicate a PDB to an existing CDB. To duplicate a PDB to an existing CDB: Ensure that the required prerequisites are met. Review the limitations of duplicating a PDB to an existing CDB Create the directories that store the duplicate database files on the destination CDB Establish Oracle net connectivity […]

Read More

createPluggableDatabase with DBCA in Oracle 18c

In this post, we can use createPluggableDatabase command creates a pluggable database (PDB) in a multitenant container database (CDB) with DBCA in Oracle 18c.

Let’s connect to the database and check the PDB is created or not.

In the next post, we can delete the PDB with DBCA in Oracle 18c. Stay tuned for more […]

Read More

deletePluggableDatabase with DBCA in Oracle 18c

In this post, we can use deletePluggableDatabase command creates a pluggable database (PDB) in a multitenant container database (CDB) with DBCA in Oracle 18c.

Let’s connect to the database and check the PDB is deleted or not.

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read the […]

Read More

createDuplicateDB with DBCA in Oracle 18c

We can use createDuplicateDB command duplicates a database with DBCA in Oracle 18c. Syntax and Parameters Use the dbca -createDuplicateDB command with the following syntax:

For creating the duplicate database, our primary database must be in archive log, otherwise we will get an error.

Run the following command to create a duplicate database.

Stay tuned for more […]

Read More