1Z0-067 · Question #153
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…
The correct answer is C. because the threaded architecture requires authentication using a password file before issuing a. 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…
Question
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?
Options
- Abecause the threaded architecture requires exiting from sqlpIus and reconnecting with sqlPIus /
- Bbecause the threaded architecture requires issuing a new connect / as sysdba from within
- Cbecause the threaded architecture requires authentication using a password file before issuing a
- Dbecause the threaded architecture requires connecting to the instance via a listener before
- Ebecause the threaded architecture requires restarting the listener before issuing a startup
How the community answered
(40 responses)- A5% (2)
- B3% (1)
- C75% (30)
- D3% (1)
- E15% (6)
Explanation
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-
Topics
Community Discussion
No community discussion yet for this question.