DB12c - when THREADED_EXECUTION=TRUE native authentication is not supported

When threaded execution is enabled (threaded_execution=TRUE) in the initialization parameter file on UNIX platforms, native authentication (that is, connect / as sysdba or connect /) is not supported.

Workaround: Use password-based authentication. Native authentication will not work for connections where the server execution is a thread.

SQL> select banner from v$version where rownum<=1;

BANNER

--------------------------------------------------------------------------------

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

SQL> select platform_name from v$database;

PLATFORM_NAME

--------------------------------------------------------------------------------

Linux x86 64-bit

SQL> show parameter threaded_execution;

NAME                                                        TYPE VALUE

------------------------------------ ----------- ------------------------------

threaded_execution                           boolean          FALSE

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oracle@xxxxx]$ sqlplus /nolog

SQL*Plus: Release 12.1.0.1.0 Production on Thu Sep 5 19:14:48 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> connect / as sysdba

Connected.

SQL> show user

USER is "SYS"

SQL> alter system set threaded_execution=TRUE scope=spfile;

System altered.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORA-01017: invalid username/password; logon denied

SQL> connect / as sysdba

ERROR:

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

SQL> exit

[oracle@xxxxx]$ sqlplus /nolog

SQL*Plus: Release 12.1.0.1.0 Production on Thu Sep 5 19:17:18 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> connect sys as sysdba

Enter password:

Connected.

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

SQL> show user

USER is "SYS"

SQL> show parameter threaded_execution

NAME                                                        TYPE VALUE

------------------------------------ ----------- ------------------------------

threaded_execution                           boolean          TRUE

This is logged as Bug 13877504