Home » RDBMS Server » Server Administration » insufficient privs at database creation time
insufficient privs at database creation time [message #248374] Thu, 28 June 2007 14:54 Go to next message
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 #248375 is a reply to message #248374] Thu, 28 June 2007 14:56 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
ORA-01031: insufficient privileges SQL> set echo on;


under which user to try to run the script?
Re: insufficient privs at database creation time [message #248376 is a reply to message #248374] Thu, 28 June 2007 14:58 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
You'll get more, better, faster answers if you read & FOLLOW the posting guideline in the #1 SITCKY post at the top of this forum.
You have not posted sufficient details for anyone to know what you are doing wrong or not doing right.
Re: insufficient privs at database creation time [message #248378 is a reply to message #248374] Thu, 28 June 2007 15:05 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: insufficient privs at database creation time [message #248388 is a reply to message #248374] Thu, 28 June 2007 18:16 Go to previous messageGo to next message
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
Senior Member
There is no alert log yet.
Re: insufficient privs at database creation time [message #248982 is a reply to message #248388] Tue, 03 July 2007 00:41 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

ORA-01031: insufficient privilegesSQL>
YOu should recreate your password file and connect to database
Before run any scripts you must connect to database.



ORA-09925: Unable to create audit trail file
Check your INIT<sid>.ora file for any parameter is related to audit trail . if set properly or remove from init<sid>.ora
Regards
Taj
Re: insufficient privs at database creation time [message #249258 is a reply to message #248982] Tue, 03 July 2007 16:12 Go to previous messageGo to next message
shaseeb
Messages: 113
Registered: April 2007
Location: Madison, WI
Senior Member
I figured it out. It was something silly. The ORACLE_SID was in lowercase in the .bash_profile. Mad

thank you all
Re: insufficient privs at database creation time [message #249259 is a reply to message #249258] Tue, 03 July 2007 16:12 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Laughing Laughing
Previous Topic: Informix to Oracle conversion
Next Topic: Connectiong as sysdba
Goto Forum:
  


Current Time: Fri Dec 02 22:45:46 CST 2016

Total time taken to generate the page: 0.09062 seconds