Re: Startup ora-01031 error

sabeer.oracle_at_gmail.com wrote:
> I have a sql script as follows:
>
> 1) SET ECHO ON
> 2) SET TERMOUT ON
> 3) SPOOL d:\oracle\admin\db00\create\createdb00_01.log
> 4) CONNECT sys/manager as sysdba
> 5) STARTUP NOMOUNT PFILE = 'd:\oracle\admin\db00\pfile\init.ora.00'
> 6) CREATE DATABASE db00
> LOGFILE
> GROUP 1 ('d:\oracle\oradata\db00\redo_01a.log',
> 'd:\oracle\db00\redo_01b.log'
> ) size 100K,
> GROUP 2 ('d:\oracle\oradata\db00\redo_02a.log',
> 'd:\oracle\oradata\db00\redo_02b.log'
> ) size 100K
> MAXLOGFILES 32
> MAXLOGMEMBERS 2
> MAXLOGHISTORY 1
> DATAFILE 'd:\oracle\oradata\db00\system01.dbf'
> SIZE 75M
> MAXDATAFILES 254
> MAXINSTANCES 1;
> SPOOL OFF
>
> When I run this script in sql*Plus, the line 4 can executed and
> connection can be done. But line 5 got error, "ORA-01031: insufficient
> privileges" and failed to startup the oracle.
> Pls guide me how to solve this.

Please search Google and/or Metalink for ORA-1031 Please avoid asking FAQs!!!
Please always make sure you read the installation manual prior to installing so you have a correct installation.

-- 
Sybrand Bakker
Senior Oracle DBA