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 […]
Category: Oracle 18c
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 […]
Image-Based Oracle Database Installation in Oracle 18c
Starting with Oracle Database 18c, installation and configuration of Oracle Database software are simplified with the image-based installation. To install Oracle Database, create the new Oracle home directory, extract the image file into the newly-created Oracle home, and run the setup wizard to register the Oracle Database product. Using image-based installation, you can install and […]
Cancel Session in Oracle 18c
As of Oracle 18c , you can not only abort a database session, but also just a single SQL command. This tip shows how it works. There are situations where the execution of SQL commands takes too long and there is a desire to cancel them. Be it because the SQL command is incorrect, or […]