Upgrade R12.1.3 to R12.2

[satish]

Dear erman,

We have lay down the filesystem and completed running upgrade driver. We ran admkappsutilpl and copied to database and rabn autonconfig on database node.Autoconfig error out. Below is the log file.Can you pls suggest.

We have ran the environment file before running autoconfig.

[oracrp@sssterpdev1 SSSEBSTR_sssterpdev1]$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u02/ CRP/db/tech_st/11.2.0/appsutil/log/ SSSEBSTR_sssterpdev1/02242134/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location: /u02/CRP/ db/tech_st/11.2.0
Classpath
::/u02/CRP/db/
tech_st/11.2.0/jdbc/lib/ojdbc5.jar:/u02/CRP/db/ tech_st/11.2.0/appsutil/java/xmlparserv2.jar:/u02/ CRP/db/tech_st/11.2.0/appsutil/java:/u02/CRP/db/ tech_st/11.2.0/jlib/netcfg.jar:/u02/CRP/db/ tech_st/11.2.0/jlib/IdapjcInt11.jar
Exception in thread "main"
java.lang.UnsupportedClassVersionError: Bad version number in .class file
at java.lang.ClassLoader.defineClass1(Native
Method)
at java.lang.ClassLoader.defineClass(ClassLoader.j ava:621)
at java.security.SecureClassLoader.defineClass(Se cureClassLoader.java:124)
at java.net.URLClassLoader.defineClass(URLClassL oader.java:260)
at lava.net.URLClassLoader.access$100/URLCIassL oader.iava:56)
at
java.net.URLClassLoader$1.run(URLClassLoader.
lava:195)
at java.security.AccessController.doPrivileged(Nati ve Method)
at lava.net.URLClassLoader.findClassURLClassLoa der.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.jav a:307)
at sun.misc.Launcher$AppClassLoader.loadClass(L auncher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.jav a:252)
at java.lang.ClassLoader.loadClassInternal(ClassLo ader.java:320)
ERROR: Version Conflicts utility failed.
Terminate.
The logfile for this session is located at: /u02/ CRP/db/tech_st/11.2.0/appsutil/log/ SSSEBSTR_sssterpdev1/02242134/adconfig.log [oracrp@sssterpdev1 SSSEBSTR_sssterpdev1]$ cat /u02/CRP/db/tech_st/11.2.0/appsutil/log/ SSSEBSTR_sssterpdev1/02242134/adconfig.log
Starting AutoConfig at Fri Feb 24 21:34:20 2023
Using adconfig. pl version
120.32.12020000.1.1220100.2
Classpath
::/u02/CRP/db/
tech_st/11.2.0/jdbc/lib/ojdbc5.jar:/u02/CRP/db/ tech_st/11.2.0/appsutil/java/xmlparserv2.jar:/u02/ CRP/db/tech_st/11.2.0/appsutil/java:/u02/CRP/db/ tech_st/11.2.0/jlib/netcfg.jar:/u02/CRP/db/ tech_st/11.2.0/jlib/IdapjcInt11.jar
ERROR: Version Conflicts utility failed.
Terminate.
The logfile for this session is located at: /u02/ CRP/db/tech_st/11.2.0/appsutil/log/ SSSEBSTR_sssterpdev1/02242134/adconfig.log

Thanks,
Satish

[ErmanArslansOracleBlog]

Check your environment..
Your Oracle home, your path, your java config, anything - any env variable set in your terminal's environment.. Probably an old version of java is used during the autoconfig run and that's why you are getting that error.

[satish]

Dear Erman,


We are following --->https://docs.oracle.com/cd/E26401_01/doc.122/e73540.pdf

Step Finishing the 12.2.0 Upgrade.
Update the DB ORACLE_HOME file system with AutoConfig and Clone files--->Failed



We have ran adbldxml.pl as ran autoconfig,it went fine. Not sure what happened internally.I think,even we are using existing home while upgrading,it is mandatory to run adbldxml.pl?


[oracrp@sssterpdev1 bin]$ perl adbldxml.pl

Starting context file generation for db tier.
Using JVM from /u02/CRP/db/tech_st/11.2.0/appsutil/jre/bin/java to execute java programs..
APPS Password:

The log file for this adbldxml session is located at:
/u02/CRP/db/tech_st/11.2.0/appsutil/log/adbldxml_02251841.log
Java HotSpot(TM) Server VM warning: You have loaded library /u02/CRP/db/tech_st/11.2.0/lib/libnjni11.so which might have disabled stack guard. The VM will try to fix the stack guard now.
It's highly recommended that you fix the library with 'execstack -c <libfile>', or link it with '-z noexecstack'.
UnsatisfiedLinkError exception loading native library: njni11
java.lang.UnsatisfiedLinkError: /u02/CRP/db/tech_st/11.2.0/lib/libnjni11.so: /u02/CRP/db/tech_st/11.2.0/lib/libnjni11.so: wrong ELF class: ELFCLASS64 (Possible cause: architecture word width mismatch)

Could not Connect to the Database with the above parameters, Please answer the Questions below


Enter Hostname of Database server: sssterpdev1

Enter Port of Database server: 1526

Enter SID of Database server: SSSEBSTR

Enter Database Service Name: SSSEBSTR

Enter the value for Display Variable:

Invalid input, reenter the value for Display Variable: sssterpdev1:0.0

Context File  /u02/CRP/db/tech_st/11.2.0/appsutil/SSSEBSTR_sssterpdev1.xml
 already exists.

Overwriting Context File may cause loss of existing settings, hence
 backing it up as: /u02/CRP/db/tech_st/11.2.0/appsutil/SSSEBSTR_sssterpdev1.xml.bak



The context file has been created at:
/u02/CRP/db/tech_st/11.2.0/appsutil/SSSEBSTR_sssterpdev1.xml
[oracrp@sssterpdev1 bin]$


[oracrp@sssterpdev1 bin]$ adconfig.sh
Enter the full path to the Context file: /u02/CRP/db/tech_st/11.2.0/appsutil/SSSEBSTR_sssterpdev1.xml
Enter the APPS user password:
The log file for this session is located at: /u02/CRP/db/tech_st/11.2.0/appsutil/log/SSSEBSTR_sssterpdev1/02251843/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /u02/CRP/db/tech_st/11.2.0
        Classpath                   : :/u02/CRP/db/tech_st/11.2.0/jdbc/lib/ojdbc6.jar:/u02/CRP/db/tech_st/11.2.0/appsutil/java/xmlparserv2.jar:/u02/CRP/db/tech_st/11.2.0/appsutil/java:/u02/CRP/db/tech_st/11.2.0/jlib/netcfg.jar:/u02/CRP/db/tech_st/11.2.0/jlib/ldapjclnt11.jar

        Using Context file          : /u02/CRP/db/tech_st/11.2.0/appsutil/SSSEBSTR_sssterpdev1.xml

Context Value Management will now update the Context file
Java HotSpot(TM) Server VM warning: You have loaded library /u02/CRP/db/tech_st/11.2.0/lib/libnjni11.so which might have disabled stack guard. The VM will try to fix the stack guard now.
It's highly recommended that you fix the library with 'execstack -c <libfile>', or link it with '-z noexecstack'.
UnsatisfiedLinkError exception loading native library: njni11
java.lang.UnsatisfiedLinkError: /u02/CRP/db/tech_st/11.2.0/lib/libnjni11.so: /u02/CRP/db/tech_st/11.2.0/lib/libnjni11.so: wrong ELF class: ELFCLASS64 (Possible cause: architecture word width mismatch)

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.
[oracrp@sssterpdev1 bin]$
[oracrp@sssterpdev1 bin]$

Thanks,
Satish

[ErmanArslansOracleBlog]

autoconfig seems completed successfully but you have "libnjni11.so: wrong ELF class: ELFCLASS64 (Possible cause: architecture word width mismatch)" error in the output.

Probably you are executing it with wrong java/jre..
I m talking about the one in $ORACLE_HOME/appsutil. This seems like a architecture(32bit/64bit) related problem.. Ensure you are using the correct java (64 bit).
That may be the cause of it.

But you can also directly check the following MOS note and apply the relevant patch if necessary ->

Why Does Autoconfig Fail On 11.2 Database ORACLE_HOME? (Doc ID 1058815.1)

" 11.2 ORACLE_HOME does not contain 32-bit libraries, but Autoconfig still uses a 32-bit Java version. Therefore the solution is to ensure 64-bit Java is used by applying a Patch." -> 7651166