How to create oracle 9i database manually

 · Create a Database Manually. Step 1: Decide on Your Instance's System Identifier (SID) The first step in creating the database is to determine the System Identifier (SID). This Step 2: Create the Initialization Parameter File. Step 3: Connect to and Start the Instance. Step 4: Issue the CREATE. 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. Create the database manually from a script. If you already have existing scripts for creating your database, you can still create your database manually. However, consider editing your existing script to take advantage of new Oracle features.

Manually Cloning an Existing Oracle Database Installation on Linux This article describes the steps necessary to manually clone an existing Oracle database installation to a new Linux server. It was written in response to a specific request for a manual process for cloning a 9i home on a test system. momer79 said: ↑. Hi, I am using Oracle 9i on development server and want to copy the all database structure to the new oracle server. Both server are using oracle 9i and window server. On development server If i run following query then it brings 19 rows. - select * from dba_data_files order by tablespace_name; And this query returns rows. There are two ways for creating an Oracle database, one is using Oracle Database Configuration Assistant and the other is manually, I'll provide a small step by step guide for the latter on windows XP. This are the main steps: 1. Create the directory structure 2. Declare an oracle SID name. 3. Create a windows service and password file 4.

So, I tried to use a CREATE DATABASE statement for setting the dimensions of the files to smaller values. I checked the documentation (Oracle 9i Database Administrator's Guide, cap. 1 Postinstallation Database Creation, Creating a Database Manually) and follow the steps described there: I have created the file "www.doorway.ru". Create a Database Manually. Step 1: Decide on Your Instance's System Identifier (SID) The first step in creating the database is to determine the System Identifier (SID). This Step 2: Create the Initialization Parameter File. Step 3: Connect to and Start the Instance. Step 4: Issue the CREATE. Create an Oracle database manually This tutorial explains you how to create an Oracle database manually. This example was tested on Oracle 11gR2 database and it use the Linux syntax.