How to create manual database in oracle 10g step by step

 · STEPS TO CREATE ORACLE DATABASE MANUALLY ON LINUX. Step 1: First create all the necessary directories. Followings are my directories: testdb1]$ ls admin backup archive admin]$ ls adump bdump cdump udump Step 2: Next prepare the database creation www.doorway.ruted Reading Time: 3 mins.  · Oracle Database 10g Enterprise Edition Release ssh is configured for user oracle on both nodes Oracle Home is on identical path on both nodes Implementation notes: Once you have your primary database up and running these are the steps to follow: 1. Enable Forced Logging 2. Create a Password File 3. Configure a Standby Redo Log 4. Lets say we will create a database named DBATEAM. 1. First, create a profile with a correct environment variable. ORACLE_SID = SYSTEM IDENTIFIER, SAME AS db instance name. ORACLE_HOME = Oracle database binary installation location. www.doorway.rue_DBATEAM #!/bin/sh umask ORACLE_SID=DBATEAM; export ORACLE_SID .

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. Step 7: Issue the CREATE DATABASE Statement. Step 8: Create Additional Tablespaces. Step 9: Run Scripts to Build Data Dictionary Views. Step Run Scripts to Install Additional Options (Optional) Step Back Up the Database. The examples shown in these steps create an example database mynewdb. Data Guard must use SPFILE. Create the SPFILE and restart database. – On windows: SQL shutdown immediate; SQL startup nomount pfile=’\database\www.doorway.ru’; SQLcreate spfile from pfile=’\database\www.doorway.ru’; — Restart the PRIMARY database using the newly created SPFILE. SQLshutdown immediate; SQLStartup;.

Step 1: Decide on Your Instance's System Identifier (SID) · Step 2: Create the Initialization Parameter File · Step 3: Connect to and Start the Instance · Step 4. In step 2, Oracle installer ask you to whether you want to create and configure a database, install database software only or just upgrade an existing database. Install Oracle 10g Release 2, Oracle 11g Release 1, or Oracle 11g Release 2 on the portal server. · Use the Database Configuration Assistant (DBCA) to create a.