Skip to main content

Posts

Showing posts from July, 2017

Creating Oracle Instance In Silent Mode

Database creation using dbca is preferred by most Oracle DBAs, because it is a more automated approach, and your database is ready to use when   DBCA  completes.  DBCA  can be launched by the Oracle Universal Installer (OUI), depending upon the type of install that you select. It can also be used to delete a database or configure other options of a database. Sometimes when working remotely, you may not have access to a GUI, or simply using GUI may be annoyingly slow for example when exporting display for a server installed in the cloud, as was my case. In such situations and others, you can use dbca in silent mode to create your instance. In this article we will look at how we can create a database using a non-interactive silent mode. Creating Database Using DBCA Silent Mode The “silent” argument is passed to DBCA to achieve this. Other options like password for SYS and SYSTEM users, which template to use and where to put datafiles are also provided to the DBCA as an ar