oracle12c bug,Oracle 12c Bug?

Oracle 12C 有一个新参数 threaded_execution, 是用来设置多线程模式，不过这个设置在某些环境下可能会引起bug。

第一个发现的不正常是， 不能用OS authentication：

[oracle tmp]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 615:11:03 2017Copyright (c) 1982, 2014, Oracle.  All rights reserved.

ERROR:

ORA-01017: invalid username/password; logon deniedEnter user-name:

SP2-0157: unable to CONNECT to ORACLE after 3 attempts,exiting SQL*Plus

第二个不正常是， SMON 进程不见了：

[oracle tmp]$ ps -ef|grep smon

重设一下这个参数， 并重启数据库：

[oracle tmp]$ sqlplus sys as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 615:12:40 2017Copyright (c) 1982, 2014, Oracle.  All rights reserved.Enter password:Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 -64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and RealApplication Testing optionsSYS@HRDEV>show parameter threadedNAME                                TYPE        VALUE------------------------------------ -----------------------------------------threaded_execution                  boolean     TRUESYS@HRDEV>alter system set threaded_execution=FALSEscope=spfile;System altered.SYS@HRDEV>shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SYS@HRDEV>startup;ORACLE instance started.Total System Global Area 1.2885E+10 bytesFixedSize                 3725224 bytesVariableSize           7012878424 bytesDatabaseBuffers         5838471168 bytesRedoBuffers              29827072 bytesDatabase mounted.Database opened.SYS@HRDEV>exitDisconnected from Oracle Database 12c Enterprise EditionRelease 12.1.0.2.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and RealApplication Testing options

SMON进程和OS Authentication 都正常了：

[oracle tmp]$ ps -ef|grep smonoracle   16848     1  015:15 ?        00:00:00ora_smon_HRDEV

[oracle tmp]$ sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 615:16:36 2017Copyright (c) 1982, 2014, Oracle.  All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 -64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and RealApplication Testing optionsSYS@HRDEV>