Create database manually oracle 10g rac

 · The common way to create oracle database is to use the DBCA, a tool provided by oracle. but if you are the type that wants to do it your self then i think this is for you. i will take you through the process and also explain some errors that you might face. i did this on oracle 10g on windows xp. i feel it should work for others as well. so lets get www.doorway.ruted Reading Time: 4 mins.  · Manual Database creation steps as follows. Step 1: Environment variable Settings (First Node). export ORACLE_BASE=/u02/app/oracle. export ORACLE_HOME=$ORACLE_BASE/product//db_1. export ORACLE_SID=DEVDB1. Step 2: Verify exist RAC setup. For more details about RAC installation guide www.doorway.ruted Reading Time: 3 mins.  · Manually Creating a RAC Database (RAC Database Creation without DBCA) The article assumes that you already have a clustered ASM installation up and running on Linux, so let's get going. My database is called DEMO, instances are DEMO1 and DEMO2. My hostnames are rac1 and rac2. www.doorway.rul www.doorway.ru Go to $ORACLE_HOME/dbs and create a simple www.doorway.ru file as follows.

Hemant K Chitale. Here are several ways to manually issue the "create database" syntax for Oracle: This is just an abbreviated sample of the Oracle create database command and there are many more options: clone/copy oracle with create database command. Oracle 10g Automated create database DBCA. Oracle9i DBCA Database Creation Assistant Templates. It is always recommended to create a database in RAC using DBCA only (GUI). But for some reason, if you want to create manually, then follow below steps: In this article, we will create a database in a 2 node RAC. Database name will be DBATST with instance names DBATST1,DBATST2. 1. Prepare a init file:(as below). Manually Creating a RAC Database (RAC Database Creation without DBCA) The article assumes that you already have a clustered ASM installation up and running on Linux, so let's get going. My database is called DEMO, instances are DEMO1 and DEMO2. My hostnames are rac1 and rac2 www.doorway.rul www.doorway.ru

ASM instances are up and running on both nodes with +DATA and +RCV (flash recovery area) disk group created. ORACLE_BASE= /u01/app/oracle. Create Folder where we need to create a Database: [oracle@ram ~]$ cd /u01 [oracle@ram ~]$ ls app ARC_BKP [oracle@ram ~]$ mkdir test. How to drop Oracle RAC database with 2 RAC instances manually without using including contents and datafiles; create pfile from spfile;.