12c: Threaded_execution=true Prevents OS Login As Sysdba
(Doc ID 1639445.1)
Last updated on FEBRUARY 03, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Connecting "/ as sysdba" is successful if threaded_execution=false. It fails if threaded_execution=true.
This is reproducible with and without Multi-tenant. Also, reproducible on Exadata and non-Exadata hardware.
SQL> show parameter threaded_execution;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
threaded_execution boolean FALSE
SQL> connect / as sysdba
Connected.
SQL> alter system set threaded_execution=true scope=spfile; <<<<<<< Parameter value True
System altered.
After Changing parameter restart the database
SQL> shutdown immediate;
Database closed.
Database dismounted.
SQL> startup
ORACLE instance started.
Total System Global Area 413372416 bytes
Fixed Size 2289016 bytes
Variable Size 322962056 bytes
Database Buffers 79691776 bytes
Redo Buffers 8429568 bytes
Database mounted.
Database opened.
SQL> connect / as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied <<<<<<<<<
Warning: You are no longer connected to ORACLE.
SQL> exit
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Fri Mar 7 07:24:59 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied <<<<<<<<<<<
[oracle@localhost ~]$ sqlplus sys/XXXXXX as sysdba <<<<<<<<<<<< Solution you have to provided username & password
SQL*Plus: Release 12.1.0.1.0 Production on Fri Mar 7 07:25:05 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> show parameter threaded_execution
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
threaded_execution boolean TRUE
System altered.
SQL> shutdown immediate;
startup;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> ORACLE instance started.
Total System Global Area 413372416 bytes
Fixed Size 2289016 bytes
Variable Size 322962056 bytes
Database Buffers 79691776 bytes
Redo Buffers 8429568 bytes
Database mounted.
Database opened.
SQL> connect / as sysdba << Authentication successfull
Connected.
SQL>
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |