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
Correct answer is C. See here: http://www.dbaglobe.com/2013/12/database-12c-initialization-parameter.html See here also: https://docs.oracle.com/cloud/latest/db121/REFRN/refrn10335.htm#REFRN10335
Password is different from password file!
D is correct!
Should be C.
I agree C
C
C
https://petesdbablog.wordpress.com/2013/07/09/12c-new-feature-multi-process-multi-threaded-oracle/
C. confirm
The first pitfall is, when you try to configure your database for such use. You need a connection which is authenticated trough the password file. Otherwise you will get are error similar to this.
https://petesdbablog.wordpress.com/2013/07/09/12c-new-feature-multi-process-multi-threaded-oracle/
Correctly said, it’s C. Same very well explained in blog,
https://martincarstenbach.wordpress.com/2014/07/21/implications-of-threaded_execution-true-in-12c/
ะก – (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.
C Is correct!
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=109430287441260&id=730067.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=oj74kpw9v_82
C
https://docs.oracle.com/cd/E49329_01/server.121/b71292/refrn10335.htm
C