问题描述:

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;

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

网友答案:

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.

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.

网友答案:

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]>
相关阅读:
Top