I want create pfile from spfile (oracle\product\11.2.0\server\dbs) then i want see and edit his and then create spfile new from pfile .
It's possible ? How?
CREATE pfile='G:/my_init.ora' FROM spfile;
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 connecting to sqlplus using this command - "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.
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.
I ran into this error while connected as sysdba, but I forgot that in the interim before I invoked the
create pfile command, I had been timing some SQL statements and had invoked the
set autotrace on at one point, then did a
set autotrace off later, then tried the
create pfile command and got the
ORA-01031 error. A simple reconnect as sysdba fixed it:
[email protected]> create pfile = 'pinitextuat01_from_mem.ora' from memory; create pfile = 'pinitextuat01_from_mem.ora' from memory * ERROR at line 1: ORA-01031: insufficient privileges [email protected]> connect / as sysdba Connected. [email protected]> create pfile = 'pinitextuat01_from_mem.ora' from memory; File created. [email protected]>