| insufficient privs at database creation time [message #248374] |
Thu, 28 June 2007 14:54  |
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
|
Senior Member |
|
|
Hello,
I am trying to create a database from using a script that I generated using DBCA. And when I run the script, I get the following error:
startup nomount pfile='/opt/app/oracle/admin/FPRCEDGE/pfile/initFPRCEDGE.ora';
ORA-01031: insufficient privileges SQL> set echo on;
Before this I was getting a "Cannot write to audit file" error and after I changed the permissions now I am getting this error.
Please help
|
|
|
|
|
|
|
|
| Re: insufficient privs at database creation time [message #248378 is a reply to message #248374] |
Thu, 28 June 2007 15:05  |
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
|
Senior Member |
|
|
Ok, I am trying to create a database (Oracle10g on RHEL 4). When I run the CREATE DATABASE script I get the following errors (NOTE:this script was created by DBCA and I modified it a bit and put it in one big script):
SQL> startup nomount pfile='/opt/app/oracle/admin/FPRCEDGE/pfile/initFPRCEDGE.ora';
ORA-01031: insufficient privilegesSQL>
SQL> set echo on;
SQL>
SQL> CREATE DATABASE "FPRCEDGE"
2 MAXINSTANCES 8
3 MAXLOGHISTORY 1
4 MAXLOGFILES 100
5 MAXLOGMEMBERS 5
6 MAXDATAFILES 100
7 DATAFILE '/u01/oradata/FPRCEDGE/system01.dbf' SIZE 1026M REUSE
8 AUTOEXTEND ON NEXT 8200M MAXSIZE UNLIMITED
9 EXTENT MANAGEMENT LOCAL
10 SYSAUX DATAFILE '/u01/oradata/FPRCEDGE/sysaux01.dbf' SIZE 1026M REUSE
11 AUTOEXTEND ON NEXT 8200M MAXSIZE UNLIMITED
12 SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u02/oradata/FPRCEDGE/temp01.dbf' SIZE 1026M REUSE
13 AUTOEXTEND ON NEXT 8200M MAXSIZE UNLIMITED
14 SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u03/oradata/FPRCEDGE/undotbs01.dbf' SIZE 770M REUSE
15 AUTOEXTEND ON NEXT 8200M MAXSIZE UNLIMITED
16 CHARACTER SET "WE8ISO8859P1"
17 NATIONAL CHARACTER SET AL16UTF16
18 LOGFILE GROUP 1 ('/u01/oradata/FPRCEDGE/redoG1L1_FPRCEDGE.log', '/u02/oradata/FPRCEDGE/redoG1L2_FPRCEDGE.log') SIZE 32M,
19 GROUP 2 ('/u02/oradata/FPRCEDGE/redoG2L1_FPRCEDGE.log', '/u03/oradata/FPRCEDGE/redoG2L2_FPRCEDGE.log') SIZE 32M,
20 GROUP 3 ('/u03/oradata/FPRCEDGE/redoG3L1_FPRCEDGE.log', '/u04/oradata/FPRCEDGE/redoG3L2_FPRCEDGE.log') SIZE 32M,
21 GROUP 4 ('/u04/oradata/FPRCEDGE/redoG4L1_FPRCEDGE.log', '/u01/oradata/FPRCEDGE/redoG4L2_FPRCEDGE.log') SIZE 32M,
22 GROUP 5 ('/u01/oradata/FPRCEDGE/redoG5L1_FPRCEDGE.log', '/u02/oradata/FPRCEDGE/redoG5L2_FPRCEDGE.log') SIZE 32M,
23 GROUP 6 ('/u02/oradata/FPRCEDGE/redoG6L1_FPRCEDGE.log', '/u03/oradata/FPRCEDGE/redoG6L2_FPRCEDGE.log') SIZE 32M,
24 GROUP 7 ('/u03/oradata/FPRCEDGE/redoG7L1_FPRCEDGE.log', '/u04/oradata/FPRCEDGE/redoG7L2_FPRCEDGE.log') SIZE 32M,
25 GROUP 8 ('/u04/oradata/FPRCEDGE/redoG8L1_FPRCEDGE.log', '/u01/oradata/FPRCEDGE/redoG8L2_FPRCEDGE.log') SIZE 32M
26 USER SYS IDENTIFIED BY oracleadmin USER SYSTEM IDENTIFIED BY oracleadmin
27 ;
SP2-0640: Not connected
SQL>
SQL> prompt
SQL> prompt Creating USERS and TOOLS tablespaces ...
Creating USERS and TOOLS tablespaces ...
SQL> prompt
SQL> connect SYS/password as SYSDBA
ERROR:
ORA-09925: Unable to create audit trail file
SQL> set echo on
SQL>
SQL> CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE '/u02/oradata/FPRCEDGE/users01.dbf' SIZE 300M REUSE
2 AUTOEXTEND ON NEXT 1026M MAXSIZE UNLIMITED
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
4 ;
SP2-0640: Not connected
[Updated on: Thu, 28 June 2007 15:06] Report message to a moderator |
|
|
|
| Re: insufficient privs at database creation time [message #248380 is a reply to message #248378] |
Thu, 28 June 2007 15:11 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | SQL> startup nomount pfile='/opt/app/oracle/admin/FPRCEDGE/pfile/initFPRCEDGE.ora';
ORA-01031: insufficient privilegesSQL>
SQL> set echo on;
SQL>
|
conn sys as sysdba or
sqlplus '/ as sysdba'
post the last 100 entries from AlERT LOG file.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
