Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Create pfile from spfile

I want to create pfile from spfile (oracle\product\11.2.0\server\dbs) then I want to see and edit it and then create spfile new from pfile.
Is it possible? How?

CREATE pfile='G:/my_init.ora' FROM spfile; 

Error: SQL Error: ORA-01031: insufficient privileges

  1. 00000 - "insufficient privileges"

*Cause: An attempt was made to perform a database operation without the necessary privileges.

*Action: Ask your database administrator or designated security administrator to grant you the necessary privileges

like image 856
zloctb Avatar asked Jul 20 '26 05:07

zloctb


2 Answers

If you are connected to the server on which oracle is running, try using sqlplus like so - sqlplus / as sysdba.
It will allow you to connect with the required privileges to run this statement.

like image 109
Yaron Idan Avatar answered Jul 22 '26 13:07

Yaron Idan


The message is rather clear. Not sufficient privileges.

From CREATE PFILE doc

You must have the SYSDBA or the SYSOPER role to execute this statement. You can execute this statement either before or after instance startup.

like image 33
Lukasz Szozda Avatar answered Jul 22 '26 11:07

Lukasz Szozda



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!