Why does the startup command return the error shown?

You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your
UNIX-based Oracle 12c database:
CONNECT/AS SYSDBA
ALTER SYSTEMSETTHREADED__EXECUTION= TRUESCOPE=SPFILE;
SHUTDOWNIMMEDIATE
You then restart the instance and get an error:
STARTUP
ORA-01031:insufficientprivileges
Why does the startup command return the error shown?

You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your
UNIX-based Oracle 12c database:
CONNECT/AS SYSDBA
ALTER SYSTEMSETTHREADED__EXECUTION= TRUESCOPE=SPFILE;
SHUTDOWNIMMEDIATE
You then restart the instance and get an error:
STARTUP
ORA-01031:insufficientprivileges
Why does the startup command return the error shown?

A.
because the threaded architecture requires exiting from sql*pIus and reconnecting with
sql*PIus / as sysdba before issuing a startup command

B.
because the threaded architecture requires issuing a new connect / as sysdba from within
sql*pIus before issuing a startup command

C.
because the threaded architecture requires authentication using a password file before
issuing a startup command

D.
because the threaded architecture requires connecting to the instance via a listener before
issuing a startup command

E.
because the threaded architecture requires restarting the listener before issuing a startup
command



Leave a Reply 12

Your email address will not be published. Required fields are marked *


puntano

puntano

I agree C

Extortioner

Extortioner

ะก – (http://docs.oracle.com/database/121/REFRN/GUID-7A668A49-9FC5-4245-AD27-10D90E5AE8A8.htm#REFRN10335)
When this initialization parameter is set to TRUE, which enables the multithreaded Oracle model, operating system authentication is not supported. Attempts to connect to the database using operating system authentication (for example, CONNECT / AS SYSDBA or CONNECT / ) when this initialization parameter is set to TRUE receive an ORA-01031 “insufficient privileges” error.