Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Creating DB Manually

Re: Creating DB Manually

From: Harald Maier <maierh_at_myself.com>
Date: Mon, 08 Sep 2003 18:39:13 +0200
Message-ID: <m3llszw7ym.fsf@ate.maierh>


hari_om_at_hotmail.com (Hari Om) writes:

> 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:
>

SQL> connect / as sysdba;

> 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!
You forgot to connect as sysdba. See above.

Harald Received on Mon Sep 08 2003 - 11:39:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US