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 […]
Articles Tagged: Oracle 18c
Patching (or Updating) home and database to 18.2 from base release 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 […]
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 […]
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 […]
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 […]
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. [oracle@18c admin]$ dbca -silent -createPluggableDatabase -pdbName DBCAPDB -sourceDB CDB18C Enter PDBADMIN User Password: — Provide password — Prepare for db operation 13% complete Creating Pluggable Database 15% complete 19% complete 23% complete […]
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. [oracle@18c admin]$ dbca -silent -deletePluggableDatabase -pdbName DBCAPDB -sourceDB CDB18C Prepare for db operation 25% complete Deleting Pluggable Database 40% complete 85% complete 92% complete 100% complete Pluggable database “DBCAPDB” deleted successfully. Look […]
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: dbca -createDuplicateDB -gdbName global_database_name -primaryDBConnectionString easy_connect_string_to_the_primary_database -sid database_system_identifier [-initParams initialization_parameters [-initParamsEscapeChar initialization_parameters_escape_character]] [-policyManaged | -adminManaged] [-policyManaged -serverPoolName server_pool_names [-pqPoolName pq_pool_name] [-createServerPool new_server_pool_name [-pqPoolName new_pq_pool_name] [-force] [-pqCardinality pq_cardinality_of_the_new_server_pool] [-cardinality cardinality_of_the_new_server_pool]]] [-adminManaged] [-datafileDestination data_files_directory] [-databaseConfigType {SINGLE […]
executePrereqs with DBCA in Oracle 18c
The executePrereqs command executes the prerequisites checks and reports the results. This command can be used to check the environment before running dbca to create a database. Syntax and Parameters Use the dbca –executePrereqs command with the following syntax: [oracle@18c admin]$ dbca -executePrereqs -help -executePrereqs – Command to execute prerequisite checks. -databaseConfigType <SINGLE | RAC […]
Shadow Tablespaces in Oracle 18c
A shadow tablespace is a bigfile tablespace intended for shadow lost write protection. Purpose of Shadow Tablespaces Shadow lost write protection provides fast detection and immediate response to a lost write. A data block lost write occurs when an I/O subsystem acknowledges the completion of the block write even though the writers did not occur or when a former […]