ORA- 28040: No matching Authentication protocol after 12c Upgrade

Issue:

Web application was not working, when connecting through ODBC application team is getting error ORA-28040 .

What Was changed:

Oracle database upgraded from oracle 11.2.0.2 to 12.1.0.2

Resolution/Workaround:

SQLNET.ALLOWED_LOGON_VERSION default is changed to 11 from 8 in earlier versions.  We need to modify the parameter to value 9 or less. SQLNET.ALLOWED_LOGON_VERSION is depreciated in 12c, SQLNET.ALLOWED_LOGON_VERSION_SERVER and SQLNET.ALLOWED_LOGON_VERSION_CLIENT replaced this parameter.

Ref: https://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF2016

Advertisements

ORA-39126 – During Schema Export

Issue:

Schema export form system user failed with below errors.

Estimate in progress using BLOCKS method…
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD [ESTIMATE_PHASE]
ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPW$WORKER”, line 9001

—– PL/SQL Call Stack —–
object line object
handle number name
4069d2ac0 20462 package body SYS.KUPW$WORKER
4069d2ac0 9028 package body SYS.KUPW$WORKER
4069d2ac0 6814 package body SYS.KUPW$WORKER
4069d2ac0 13688 package body SYS.KUPW$WORKER
4069d2ac0 2654 package body SYS.KUPW$WORKER
4069d2ac0 9697 package body SYS.KUPW$WORKER
4069d2ac0 1775 package body SYS.KUPW$WORKER
4053c83e8 2 anonymous block

Solution:

There was a DUAL table created under SYSTEM user having multiple rows.

SQL> select table_name,owner from dba_Tables where table_name=’DUAL’;

TABLE_NAME OWNER
—————————— ——————————
DUAL SYS
DUAL SYSTEM

SQL> select * from dual;

D

X
X
X
X

Dropped the custom dual table created under system and the export worked fine.

drop table system.dual;