Create database manually oracle 9i windows

Here I have provided steps for creating database Manually with installation of differnt optional components. Before creating an oracle database, Make sure oracle database software is installed. REFER – Steps to install oracle 12c software. Lets say we will create a database named DBATEAM. 1. First, create a profile with a correct environment.  · Im a newbie in Oracle and Im reading a book titled "Oracle 9i DBA Handbook" by Oracle Press. I tried following its instructions in manually creating a database but it always fail. Firstly, I ran the following statment in sqlplus: startup nomount pfile="C:\oracle\admin\mydb\pfile\www.doorway.ru"; Afterwards, I ran the following script. Creating an Oracle 9i database from the command line only; For Unix users, the command line is their shell while for Windows users, the command line is the dos box. Windows users usually start the dos box with start-run and then enter cmd and press enter.

Im a newbie in Oracle and Im reading a book titled "Oracle 9i DBA Handbook" by Oracle Press. I tried following its instructions in manually creating a database but it always fail. Firstly, I ran the following statment in sqlplus: startup nomount pfile="C:\oracle\admin\mydb\pfile\www.doorway.ru"; Afterwards, I ran the following script. To create the database, issue the CREATE DATABASE command. The CREATE DATABASE command creates data files, control files, redo log files, the system tablespace along with the data file associated with it, and a system rollback segment. Windows users usually start the dos box with start-runand then enter cmdand press enter. Creating a database consists basically of the following steps: Creating the database's datafiles, its controlfilesand its online redo log files. Creating the systemtablespace. Creating the systemrollback segment.

Set up the ORACLE_HOME environment variable to point to the directory where the Oracle database client software is installed. Set the variable on the admin. Steps to create a database in Window Environment · Task Compose a parameter file: With the name of (· Task 3. Create a service in NT and a. ORACLE-BASE - Database Configuration Assistant (DBCA): Creating Databases in Silent Mode.