Oracle Database Creation

Databases

Oracle

Oracle DB Lifecycle

Oracle Install

DBCA GUI Mode

Oracle Database Configuration Assistant

X11

Without X11 you will be unable to use GUI Mode. But, you should still be able to perform Silent Mode database creation/configuration using DBCA (see later).

As 'oracle'...

touch /home/oracle/.Xauthority

xauth add localhost.localdomain/unix:0 MIT-MAGIC-COOKIE-1 99999999999999999

Copy magic cookie from output of xauth list as 'root'

(TODO - not sure this is the right thing to do - but it does work)

CREATE Database

dbca

The dbca executable can be found at:$ORACLE_HOME/bin/dbca

Troubleshooting

SGA set to 4478MB
shmmax set to 4096MB (4,294,967,295 bytes)
Physical memory is 14930MB

Oracle recommend shmmax is set to 50% of physical memory.

In this case 50% of physical memory is 7465MB (7,827,619,840 bytes)

To address this issue....

vi /etc/sysctl.d/97-oracle-database-sysctl.conf

update value of kernel.shmmax to...

7827619840

then run...

/sbin/sysctl --system

...to apply

DBCA Silent Mode

Create Responsefile

A fully commented sample is available at $ORACLE_HOME/assistants/dbca/dbca.rsp

responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0

19c

The example below achieves the same things as the GUI creation above.

vi /tmp/dbca.rsp

responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0

gdbName= "ORCL1"

sid= "ORCL1"

databaseConfigType= "SI"

createAsContainerDatabase= "TRUE"

numberOfPDBs= 1

pdbName= "PDB1"

useLocalUndoForPDBs= "TRUE"

pdbAdminPassword= "sTamp-1379!-panDa"

nodelist=

templateName=

sysPassword= "sTamp-1379!-panDa"

systemPassword= "sTamp-1379!-panDa"

oracleHomeUserPassword=

emConfiguration= "NONE"

emExpressPort=5500

runCVUChecks=

dbsnmpPassword=

omsHost=

omsPort=

emUser=

emPassword=

dvConfiguration=

dvUserName=

dvUserPassword=

dvAccountManagerName=

dvAccountManagerPassword=

olsConfiguration=

datafileJarLocation=

datafileDestination= "/u02/oradata/ORCL1"

recoveryAreaDestination= "/fra/fast_recovery_area/ORCL1"

storageType= "FS"

diskGroupName=

asmsnmpPassword=

recoveryGroupName=

characterSet= "AL32UTF8"

nationalCharacterSet= "AL16UTF16"

registerWithDirService=

dirServiceUserName=

dirServicePassword=

walletPassword=

listeners=

variablesFile=

variables=

initParams=

sampleSchema=

memoryPercentage=

databaseType=

automaticMemoryManagement= "FALSE"

totalMemory=

CREATE Database

dbca -createDatabase -silent -responseFile /tmp/dbca.rsp

CLI

You can also create a database using a CLI like SQL*Plus...

The example below achieves the same things as the DBCA creations above.

As 'oracle'...

OLD_UMASK=`umask`

umask 0027

mkdir -p /fra/fast_recovery_area

mkdir -p /u01/app/oracle

mkdir -p /u01/app/oracle/admin/ORCL1/adump

mkdir -p /u01/app/oracle/admin/ORCL1/dpdump

mkdir -p /u01/app/oracle/admin/ORCL1/pfile

mkdir -p /u01/app/oracle/audit

mkdir -p /u01/app/oracle/cfgtoollogs/dbca/ORCL1

mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/dbs

mkdir -p /u01/oradata/ORCL1

mkdir -p /u02/oradata

mkdir -p /u02/oradata/ORCL1

umask ${OLD_UMASK}

PERL5LIB=$ORACLE_HOME/rdbms/admin:$PERL5LIB

export PERL5LIB

ORACLE_SID=ORCL1

export ORACLE_SID

PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$PATH

export PATH

Add entry to /etc/oratab...

vi /etc/oratab

ORCL1:/u01/app/oracle/product/19.0.0/dbhome_1:Y

TODO

Bibliography

https://oracle-base.com/articles/misc/database-configuration-assistant-dbca-silent-mode
https://support.oracle.comMaximum SHMMAX values for Linux x86 and x86-64 (Doc ID 567506.1)[DBT-11207][DBT-05509] Failed to connect to the specified database with ORA-12547: TNS:lost contact error (Doc ID 2785868.1)DBCA Silent Mode New features in Database 19C (Doc ID 2477805.1)

Page updated

Google Sites

Report abuse