About Creating an Oracle Database

You typically create a database during Oracle Database software installation. However, you can also create a database after installation.

visual studio net training courses malaysia

Reasons to create a database after installation are as follows:

• You used Oracle Universal Installer (OUI) to install software only, and did not create a database.
• You want to create another database (and database instance) on the same host computer as an existing Oracle database. In this case, this chapter assumes that the new database uses the same Oracle home as the existing database. You can also create the database in a new Oracle home by running OUI again.
• You want to make a copy of (clone) a database.

Microsoft system center certification training courses malaysia

The specific methods for creating a database are:

• With Database Configuration Assistant (DBCA), a graphical tool.See “Creating a Database with DBCA”
• With the CREATE DATABASE SQL statement.See “Creating a Database with the CREATE DATABASE Statement”

Considerations Before Creating the Database

Microsoft sql server certification training courses malaysia

Database creation prepares several operating system files to work together as an Oracle Database. You only need to create a database once, regardless of how many data files it has or how many instances access it. You can create a database to erase information in an existing database and create a new database with the same name and physical structure.

• Planning for Database Creation
  Prepare to create the database by research and careful planning.
• About Selecting a Character Set
  It is important to select the right character set for your database. Oracle recommends AL32UTF8 as the database character set.
• About Configuring an Oracle Home in Read-Only Mode
  Starting with Oracle Database 18c, you can configure an Oracle home in read-only mode. A read-only Oracle home prevents creation as well as modification of files inside the Oracle home directory ORACLE_HOME. A read-only Oracle home can be used as a software image for simplifying patching and mass rollout of software across multiple database servers.
• Prerequisites for Database Creation
  To ensure that your Oracle Database is created successfully, review database prerequisites.

Microsoft sharepoint certification training courses malaysia