Home » RDBMS Server » Server Administration » ORA-01031: insufficient privileges during create pfile from spfile (10.2.0.4.0 windows 2000)
ORA-01031: insufficient privileges during create pfile from spfile [message #406217] Tue, 02 June 2009 22:17 Go to next message
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
Re: ORA-01031: insufficient privileges during create pfile from spfile [message #406219 is a reply to message #406217] Tue, 02 June 2009 22:23 Go to previous messageGo to next message
BlackSwan
Messages: 25037
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 Go to previous messageGo to next message
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>
Re: ORA-01031: insufficient privileges during create pfile from spfile [message #406223 is a reply to message #406217] Tue, 02 June 2009 22:45 Go to previous messageGo to next message
BlackSwan
Messages: 25037
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
Re: ORA-01031: insufficient privileges during create pfile from spfile [message #406225 is a reply to message #406217] Tue, 02 June 2009 22:50 Go to previous messageGo to next message
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>
Re: ORA-01031: insufficient privileges during create pfile from spfile [message #406226 is a reply to message #406217] Tue, 02 June 2009 22:52 Go to previous messageGo to next message
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

Re: ORA-01031: insufficient privileges during create pfile from spfile [message #406227 is a reply to message #406217] Tue, 02 June 2009 22:55 Go to previous message
BlackSwan
Messages: 25037
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.
Previous Topic: Oracle 11i Server installation
Next Topic: Querying installed bugfixes (10.2.0.4.0 merged 2)
Goto Forum:
  


Current Time: Mon Dec 05 06:51:25 CST 2016

Total time taken to generate the page: 0.10525 seconds