Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

update manager from 3.4.4 to 3.4.5 and java exception on UPDATE WL_LLR_ADMINSERVER

798463Dec 5 2018 — edited Dec 6 2018

Hello,

I have one 3.4.4 manager just installed where I then applied 3.4.5 upgrade.

All seems to have been good apart this java exception:

Failed to UPDATE WL_LLR_ADMINSERVER

0 rows affected

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ovs.WL_LLR_ADMINSERVER' doesn't exist

at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:398)

I'm able to connect to the new manager version GUI (reported as 3.4.5) and able to successfully discover 2 new Oracle VM servers (in 3.4.5).

See below full output of runInstaller.sh

Gianluca

[root@ovmgr mnt]# ./runInstaller.sh

Oracle VM Manager Release 3.4.5 Installer

Oracle VM Manager Installer log file:

/var/log/ovmm/ovm-manager-3-install-2018-12-05-001537.log

Please select an installation type:

1: Install

2: Upgrade

3: Uninstall

4: Help

Select Number (1-4): 2

Verifying upgrading prerequisites ...

*** WARNING: Ensure that each Oracle VM Server for x86 has at least 200MB of available space for the /boot partition and 3GB of available space for the / partition.

Starting Upgrade ...

Reading database parameters from config ...

==========================

Typically the current Oracle VM Manager database password will be the same as the Oracle VM Manager application password.

==========================

Database Repository

==========================

Please enter the current Oracle VM Manager database password for user ovs:

Oracle VM Manager application

=============================

Please enter the current Oracle VM Manager application password for user admin:

Oracle Weblogic Server 12c

==========================

Please enter the current password for the WebLogic domain administrator:

Please enter your fully qualified domain name, e.g. ovs123.us.oracle.com, (or IP address) of your management server for SSL certification generation 192.168.122.233 [ovmgr.localdomain.local]:

Successfully verified password for user root

Successfully verified password for user appfw

Verifying configuration ...

Verifying 3.4.4 meets the minimum version for upgrade ...

Upgrading from version 3.4.4.1709 to version 3.4.5.1919

Start upgrading Oracle VM Manager:

1: Continue

2: Abort

Select Number (1-2): 1

Running full database backup ...

Successfully backed up database to /u01/app/oracle/mysql/dbbackup/3.4.4_preUpgradeBackup-20181205_001640

Running ovm_preUpgrade script, please be patient this may take a long time ...

Exporting weblogic embedded LDAP users

Stopping service on Linux: ovmcli ...

Stopping service on Linux: ovmm ...

Exporting core database, please be patient this may take a long time ...

NOTE: To monitor progress, open another terminal session and run: tail -f /var/log/ovmm/ovm-manager-3-install-2018-12-05-001537.log

Product component : Java in '/u01/app/oracle/java'

Java is installed ...

Removing Java installation ...

Installing Java ...

DB component : MySQL RPM package

MySQL RPM package installed by OVMM was found...

Removing MySQL RPM package installation ...

Installing Database Software...

Retrieving MySQL Database 5.6 ...

Unzipping MySQL RPM File ...

Installing MySQL 5.6 RPM package ...

Configuring MySQL Database 5.6 ...

Installing MySQL backup RPM package ...

Product component : Oracle VM Manager in '/u01/app/oracle/ovm-manager-3/'

Oracle VM Manager is installed ...

Removing Oracle VM Manager installation ...

Product component : Oracle WebLogic Server in '/u01/app/oracle/Middleware/'

Oracle WebLogic Server is installed

Removing Oracle WebLogic Server installation ...

Service ovmm is deleted.

Service ovmcli is deleted.

Retrieving Oracle WebLogic Server 12c and ADF ...

Installing Oracle WebLogic Server 12c and ADF ...

Applying patches to Weblogic ...

Applying patch to ADF ...

Installing Oracle VM Manager Core ...

Retrieving Oracle VM Manager Application ...

Extracting Oracle VM Manager Application ...

Retrieving Oracle VM Manager Upgrade tool ...

Extracting Oracle VM Manager Upgrade tool ...

Installing Oracle VM Manager Upgrade tool ...

Installing Oracle VM Manager WLST Scripts ...

Failed to UPDATE WL_LLR_ADMINSERVER

0 rows affected

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ovs.WL_LLR_ADMINSERVER' doesn't exist

at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:398)

at Djc.main(Djc.java:60)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ovs.WL_LLR_ADMINSERVER' doesn't exist

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.Util.getInstance(Util.java:386)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:842)

at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681)

at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:499)

at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:470)

at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:664)

at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:627)

at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:370)

... 1 more

--- Nested Exception ---