12c: Threaded_execution=true Prevents OS Login As Sysdba (Doc ID 1639445.1)

Last updated on JULY 20, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 21-Jul-2017***

Goal

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

 

 

 

SQL> alter system set threaded_execution=false scope=spfile;               <<<<<< Changing the parameter value to False

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms