OraFAQ Forum: Server Administration » ORA-01031: insufficient privileges during create pfile from spfile

Home » RDBMS Server » Server Administration » ORA-01031: insufficient privileges during create pfile from spfile (10.2.0.4.0 windows 2000)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01031: insufficient privileges during create pfile from spfile [message #406217]

Tue, 02 June 2009 22:17

fairdaus
Messages: 14
Registered: May 2009
Location: KL

Junior Member

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 3 11:14:39 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-01031: insufficient privileges

SQL>

any solution

tq

Report message to a moderator

Re: ORA-01031: insufficient privileges during create pfile from spfile [message #406219 is a reply to message #406217]

Tue, 02 June 2009 22:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

log onto OS as user who owns Oracle s/w.
open command window

sqlplus
/ as sysdba
create pfile from spfile;
exit

CUT commands above & PASTE into command window.
CUT & PASTE results back here

[Updated on: Tue, 02 June 2009 22:24]

Report message to a moderator

Re: ORA-01031: insufficient privileges during create pfile from spfile [message #406221 is a reply to message #406219]

Tue, 02 June 2009 22:41

fairdaus
Messages: 14
Registered: May 2009
Location: KL

Junior Member

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Sqlplus /nolog
Connect / as sysdba

create pfile from spfile
*
ERROR at line 1:
ORA-01031: insufficient privileges

SQL>

Report message to a moderator

Re: ORA-01031: insufficient privileges during create pfile from spfile [message #406223 is a reply to message #406217]

Tue, 02 June 2009 22:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

log onto OS as user who owns Oracle s/w.
open command window

SET
sqlplus
/ as sysdba
create pfile from spfile;
exit

CUT commands above & PASTE into command window.
CUT & PASTE results back here

Report message to a moderator

Re: ORA-01031: insufficient privileges during create pfile from spfile [message #406225 is a reply to message #406217]

Tue, 02 June 2009 22:50

fairdaus
Messages: 14
Registered: May 2009
Location: KL

Junior Member

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

sqlplus / as sysdba

create pfile from spfile
*
ERROR at line 1:
ORA-01031: insufficient privileges

SQL>

Report message to a moderator

Re: ORA-01031: insufficient privileges during create pfile from spfile [message #406226 is a reply to message #406217]

Tue, 02 June 2009 22:52

fairdaus
Messages: 14
Registered: May 2009
Location: KL

Junior Member

got answer

On the server, create a group called ORA_DBA and add your user to that group. You should be able to CONNECT / AS SYSDBA after that.

tq
for help

Report message to a moderator

Re: ORA-01031: insufficient privileges during create pfile from spfile [message #406227 is a reply to message #406217]

Tue, 02 June 2009 22:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Where is output from SET command?

How can you CUT & PASTE?

My post contains semicolon after spfile; and your response contains no semicolon?

Enjoy the error & your mystery.

Report message to a moderator

Previous Topic:	Oracle 11i Server installation
Next Topic:	Querying installed bugfixes (10.2.0.4.0 merged 2)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 06:38:38 CDT 2024