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
- 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
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With