Troubleshooting 12c database issues with EBS



Here is the compilation of known 12c database issues with EBS. Hope it helps

Issue 1

The database was recently upgraded from 11g to 12c, and when trying to register database to sso using: $FND_TOP/bin/txkrun.pl the following error is received:

‘ORA-28040: No matching authentication protocol’

Resolution:To resolve the issue test the following steps in a development instance and then migrate accordingly:

  1. Copy ojdbc6.jar and orai18n.jar into the $IAS_ORACLE_HOME/jdbc/lib
  2. Make a backup of $HOME/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkSetSSOReg.pl by copying the file to txtSetSSOReg.pl-bk1
  3. Update the $HOME/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkSetSSOReg.pl to use ojdbc6.jar instead of ojdbc14.jar
  4. Retest the script execution, txkrun.pl

 

Issue 2: Script perl /product/12.1.0.2/appsutil/bin/adbldxml.pl fails when generating the Database Context File with the following errors:

‘Can’t locate Config.pm in @INC (@INC contains: /ebs/db/11.2.0/perl/lib/5.8.3 /ebs/db/11.2.0/perl/lib/site_perl/5.8.3 /ebs/db/11.2.0/appsutil/perl ../lib/site_perl/5.14.1/sun4-solaris-thread-multi-64 ../lib/site_perl/5.14.1 ../lib/5.14.1/sun4-solaris-thread-multi-64 ../lib/5.14.1 .) at /ebs/ebs/product/12.1.0.2/appsutil/bin/adbldxml.pl line 32.
BEGIN failed–compilation aborted at /ebs/ebs12c/product/12.1.0.2/appsutil/bin/adbldxml.pl line 32.

The issue occurs during a database upgrade to 12c referencing the following document:

Root Cause

Perl library location was referring to wrong version and path.

The existing perl version was referring to lower version, which adbldxml.pl is not able to locate as a new version is required.

Resolution

To resolve the issue test the following steps in a development instance and then migrate accordingly:

  1. For an instance with 12c Database, the perl version on the Database tier required is ‘5.14’.

  2. If the current perl version on the system is not 5.14 or greater (eg. 5.14.1) download the correct version of perl.

  3. Set the variable ‘PERL5LIB’ on the 12c database tier to to following:
    export PERL5LIB=<ORACLE_HOME>/perl/lib/5.14.1:<ORACLE_HOME>/perl/lib/site_perl/5.14.1:<ORACLE_HOME>/appsutil/perl

  4. Retest the context file creation via adbldxml.pl and confirm the error is resolved.

 

 

Issue 3 : You may get  the below ORA error in many cases while using 12c database

‘ORA-28040: No matching authentication protocol’

Resolution

If you are on E-Business Suite Release 12.0, ensure that your sqlnet_ifile.ora has the line:
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8
If you are on E-Business Suite Release 12.1, ensure that your sqlnet_ifile.ora has the line:
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8 (if the initialization parameter SEC_CASE_SENSITIVE_LOGON is set to FALSE)
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 10 (if SEC_CASE_SENSITIVE_LOGON is set to TRUE)

Issue  4

TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Solaris Error: 29: Illegal seek

Resolution

Add the below parameter in listener.ora

CRS_NOTIFICATION_LISTENER=OFF
CRS_NOTIFICATION_LISTENER_SCAN1=OFF
CRS_NOTIFICATION_LISTENER_SCAN2=OFF
CRS_NOTIFICATION_LISTENER_SCAN3=OFF

 

Issue  5  Database links may give tns errors after upgrading to 12c

Resolution:

Make sure you copied all the tns entries for the database link to work

 

Issue 6 sqlplus “/ as sysdba”
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

Resolution
unset ORA_TZFILE

 

Issue 7

AutoPatch error:
The following ORACLE error:

ORA-28000: the account is locked

 

occurred while executing the SQL statement:

CONNECT SYSTEM/*****

AutoPatch error:
Unable to connect to ‘SYSTEM’; password may be invalid.

AutoPatch needs the password for your ‘SYSTEM’ ORACLE schema
in order to determine your installation configuration.

Resolution

Account was locked .Unlock the system account

 

Issue 8

After database upgrade to 12.1.0.2, ” AR XLAACCUP module: Accounting Program ” concurrent job failed very quick with error:
An internal error occurred. Please inform your system administrator or support representative that:
An internal error has occurred in the program xla_ae_lines_pkg.AccountingReversal. ORA-01555: snapshot too old: rollback segment number 28
Resolution

The fix is EBS patch 19591608 or workaround

set temp_undo_enabled = FALSE

 

Issue 9

Oracle 12c introduces a new default feature of using multiple LGWRs which may lead to DEADLOCK / Database Hang or ORA-742 “Log read detects lost write” or ORA-600 [kcrfrgv_nextlwn_scn] during instance OPEN or ORA-600 [krr_process_read_error_2] during Recovery on IBM AIX and potentially on HPUX Itanium 64bit.

The database may become unusable and fail to be OPEN.

This issue is specific to RDBMS version 12c (12.1.0.1 or 12.1.0.2) where the new default feature of using multiple LGWRs is introduced.

It affects databases on IBM AIX and potentially on HPUX Itanium 64bit

Resolution

Disable the new feature of multiple LGWR slave processes by proactively setting _use_single_log_writer=true.

Setting _use_single_log_writer = true is a safe workaround; it is the behavior before 12c where multiple LGWR slave groups were not available.

ALTER SYSTEM SET “_use_single_log_writer”=TRUE SID=’*’ SCOPE=SPFILE;
— Restart the database or all instances of the RAC database

Note that while _use_single_log_writer=true is not set, then error ORA-600 [kcrfrgv_nextlwn_scn] might be produced avoiding the database to OPEN. Once the problem is introduced, _use_single_log_writer=true may not fix it. _use_single_log_writer = true prevents inconsistencies in the redo log to be introduced which causes that error.

If the parameter does not help, because the problem was already introduced when _use_single_log_writer=true had not been proactively set, then Point in Time Recovery (PITR) or Flashback Database are the options to recover from this situation.

Related Articles

How to upgrade R12.1 Instance database to 12c

Top Oracle 12c New Features for developers

Top 10 oracle 12c new features

Step by Step Oracle 12c Database Installation on Linux


Leave a Reply