Creating DB Manually

From: Hari Om <hari_om_at_hotmail.com>
Date: 8 Sep 2003 09:10:46 -0700
Message-ID: <d1d5ebe4.0309080810.5725427@posting.google.com>

Creating DB Manually

Hello,

I wanted to create a Database Manually (without using DBCA) I already have a database running called "BILL" I want to creat a database manually called "GATES"

Here is what I did:

1. Copied initBILL.ora file (/oracle/data1/admin/bill/pfile/) to initGATES.ora (/oracle/data1/admin/gates/pfile/)
2. Modified the following parametsrs in above file: DB_NAME = GATES background_dump_dest=/oracle/data1/admin/gates/bdump core_dump_dest=/oracle/data1/admin/gates/cdump user_dump_dest=/oracle/data1/admin/gates/udump control_files=("/oracle/data1/gates/control01.ctl",
   "/oracle/data1/gates/control02.ctl",
   "/oracle/data2/gates/control03.ctl")
   instance_name=gates
3. At OS (IBM AIX 5.1) Prompt I do: export ORACLE_SID=gates
4. I execute "./sqlplus /nolog
5. Issued Startup command as followsS:

startup nomount pfile=/oracle/data1/admin/gates/pfile/initgates.ora

I get following Error message wonder why:

---

SQL> startup nomount
pfile=/oracle/data1/admin/gates/pfile/initgates.ora ORA-01031: insufficient privileges

---

Once the above command is successful, I can then run "CREATE DATABASE Command"....but how do I proceed from here?

(In book it says in step 4- above Start SVRMGR and connect as internal)

Is the above sequence of steps proper...?

Any related information is appreciated!

THANKS! Received on Mon Sep 08 2003 - 11:10:46 CDT