Step 8: Start the Instance

Start an instance without mounting a database.

• Run the STARTUP command with the NOMOUNT clause.

red hat certified system administrator rhcsa malaysia

Typically, you do this only during database creation or while performing maintenance on the database. In this example, because the initialization parameter file or server parameter file is stored in the default location, you are not required to specify the PFILE clause:

agile project management certification training courses malaysia

Step 9: Issue the CREATE DATABASE Statement

To create the new database, use the CREATE DATABASE statement.

• Run the CREATE DATABASE statement.

Step 10: Create Additional Tablespaces

To make the database functional, you must create additional tablespaces for your application data.

• Run the CREATE TABLESPACE statement to create additional tablespaces.

Microsoft windows server certification training courses malaysia

Step 11: Run Scripts to Build Data Dictionary Views

Run the scripts necessary to build data dictionary views, synonyms, and PL/SQL packages, and to support proper functioning of SQL*Plus.

red hat certified specialist in red hat enterprise Linux diagnostics and troubleshooting malaysia