I have a sql script as follows:
- SET ECHO ON
- SET TERMOUT ON
- SPOOL d:\oracle\admin\db00\create\createdb00_01.log
- CONNECT sys/manager as sysdba
- STARTUP NOMOUNT PFILE = 'd:\oracle\admin\db00\pfile\init.ora.00'
- 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.
Received on Thu Jul 27 2006 - 02:14:17 CDT