Showing posts with label dbca. Show all posts
Showing posts with label dbca. Show all posts
Wednesday, April 23, 2025

How to create a database with non-default blocksize using dbca

›
Prerequisites: You have a valid Oracle 19c installation in a server You have set your Oracle environment already, so that your PATH, ORACLE...
Tuesday, October 15, 2024

Arguments that can be passed to "dbca -createDatabase" usage output

›
This can certainly come in handy one day... -createDatabase - Command to Create a database. -responseFile | (-gdbN...
Monday, October 14, 2024

How to add a post-creation script to your dbca createDatabase statement

›
Given that you have saved your responsefile in the oracle user's home directory, use the -customScripts to point out a script that will...
Thursday, October 3, 2024

Workaround for RMAN-04014: startup failed: ORA-27069: attempt to do I/O beyond the range of the file when using dbca

›
Late night error when trying to create a cdb out of the same ORACLE_HOME as an older, non-cdb database: dbca reports: [ 2024-10-03 18:34:...
Monday, September 23, 2024

How prevent dbca to create folders in capital letters during database creation

›
This post is derived from my previous post, but I have come to realize that I have needed to look up this particular detail at at least a co...
Wednesday, April 17, 2024

Solution to [FATAL] [DBT-05509] Failed to connect to the specified database (cdb) in dbca

›
I was attempting to create a container database using dbca like this: dbca -createDatabase -responsefile /home/oracle/scripts/cdb.rsp -sil...
Thursday, February 8, 2024

Script snipplet to scan the dbca logs for errors

›
Here is a way to scan the logs in the directory where dbca creates its logfiles, by default under your $ORACLE_BASE/cfgtoollogs/dbca/$ORACL...
Friday, January 26, 2024

[DBT-50000] Unable to check available system memory when running dbca

›
dbca returned the following error upon launch: [FATAL] [DBT-50000] Unable to check available system memory. CAUSE: An exception occured...
Thursday, October 5, 2023

How to create a template that includes a seed database using dbca

›
This is how you can create a new template which will include the database "mydb01" as a seed database for future installations: ...
Wednesday, September 27, 2023

Using the dbca General Purpose template and the resulting database

›
If you execute the dbca GUI and choose the simple configuration, you will be using the "General Purpose" template, which gives yo...
Tuesday, September 26, 2023

What are dbca templates and how do they work?

›
What are dbca templates?  Database Configuration Assistant (DBCA) templates are XML files that contain information required to create a...
Thursday, September 14, 2023

Solution for [WARNING] ORA-01081: cannot start already-running ORACLE - shut it down first when running dbca

›
I received the following error multiple times, when executing dbca like below: dbca -createDatabase -responsefile ./cdb.rsp -silent 2023-...
Tuesday, September 12, 2023

How to delete a pluggable database with dbca using the command line

›
dbca -silent -deletePluggableDatabase \ -sourceDB cdb \ -pdbName pdb3 \

How to create a pluggable database with dbca using the command line

›
In the following code snippet, I am creating the pluggable database "pdb3" as a copy of the already existing pluggable database ...
Friday, September 8, 2023

Script for creating a multitenant database with dbca

›
Prerequisites: You have a valid Oracle 19c installation in a server You have set your Oracle environment already, so that your PATH, ORAC...

Solution for [DBT-10317] Specified SID Name (SID) already exists when running dbca

›
When running dbca, for example like this: dbca -createDatabase -responsefile ./cdb.rsp -silent [FATAL] [DBT-10317] Specified SID Name (cdb...
Tuesday, August 22, 2023

Cause and solution to ORA-00058: DB_BLOCK_SIZE must be 8192 to mount this database (not 16384)

›
You attempt to execute dbca silently, using a response file, as shown below: dbca -createDatabase -responsefile mydb01.rsp -silent But i...
Friday, August 4, 2023

How to trace the dbca tool

›
These notes are taken directly from MOS, and jotted down here so I have it readily available for the future. To trace the DBCA, we need ...