Moneycontrol Brokerage Recos

Thursday, July 26, 2018

Oracle Database 18c - Database Creation using DBCA


In our last article,[click here] we seen Oracle database 18c deployment - Software only. Here in this blog post, we would create a fresh database using Oracle database 18.3 DBCA.



$export ORACLE_HOME
$cd $ORACLE_HOME/bin

$export DISPLAY=:0.0


$./dbca

Select "Create a database" option and click next.





Fill the values for "Typical Configuration" options of database being created - i.e. your container (CDB) database name, and other options along with your container database SYS/SYSTEM user password. Choose option "Create as Container database" if you want your database to be Multi-tenant database and provide the PDB(Pluggable database) name under that. Click Next.





Since I have give a simple password so it pops up a warning that the password provided doesn't meet the Oracle recommended standards - to provide complex password, well I am OK with this and click on Yes to proceed with next step.



Here on this summary page, you can review all options you have selected - new thing here you would see that this summary page also lists the "Initialization Parameters" for the typical configuration option. Once you are OK with the options, click on Finish.





Database creation starts.......




Click on Close.....



Set the database OS environment.....and login to verify the instance.







By default, non-default pluggable databases open in MOUNTED state, you can then open them later using ALTER PLUGGABLE database command as below.




Subscribe to this blog to stay tuned for upcoming Oracle Database 18c articles.........


No comments:

Post a Comment