Creating the Database
Creating a database can either be done manually, using SQL scripts and the CREATE DATABASE command, or with the Database Creation Assistant (DBCA).
Before you can create a database, either manually, or with DBCA, the operating system environment needs to be configured properly, or the database will fail to create correctly.
ORACLE_BASE specifies the topmost directory that will house the Oracle software.
For example: /Oracle or C:\Oracle.
ORACLE_HOME provides the directory where the Oracle software will be installed. Oracle Flexible Architecture suggests that the value of the ORACLE_HOME be set to ORACLE_BASE/product/release#.
For example: /Oracle/product/9_2 or C:\Oracle\database\9_2.
ORACLE_SID is the instance name. This ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.