OPSS - UpgradeOpss script Failed With ORA-01735: Invalid ALTER TABLE Option in Oracle 10g DB (Doc ID 2129696.1)

Last updated on AUGUST 30, 2017

Applies to:

Oracle Platform Security for Java - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

On OPSS : 11.1.1.9.0 version, observing the next Error, When upgrading from OIM 11gr2 PS2 to PS3,

while running upgradeOpss() script. Observing the net Error:

wls:/offline> upgradeOpss(jpsConfig="$Middleware_Home/user_projects/domains/oim_domain/config/fmwconfig/jps-config.xml", jaznData="$Middleware_Home/oracle_common/modules/oracle.jps_11.1.1/domain_config/system-jazn-data.xml", jdbcDriver="oracle.jdbc.OracleDriver", url="jdbc:oracle:thin:@<HOST>:1521/<SERVICE>", user="XXX_OPSS", password="xxxxxx", upgradeJseStoreType="true")
{upgradeJseStoreType=true, transformData=null, auditStore=null, user=XXX_OPSS, url=jdbc:oracle:thin:@<HOST>:1521/<SERVICE>, jdbcDriver=oracle.jdbc.OracleDriver, jaznData=$Middleware_Home/oracle_common/modules/oracle.jps_11.1.1/domain_config/system-jazn-data.xml, jpsConfig=$Middleware_Home/user_projects/domains/oim_domain/config/fmwconfig/jps-config.xml}
Starting upgrade of opss configuration and security stores.
Apr 01, 2016 10:39:49 AM oracle.security.jps.util.JpsUtil disableAudit
INFO: JpsUtil: isAuditDisabled set to true
WLS ManagedService is not up running. Fall back to use system properties for configuration.
Apr 01, 2016 10:40:42 AM oracle.security.jps.internal.tools.utility.destination.apibased.JpsDstPolicy migrateDataInternal
INFO: Migration of Admin Roles started
Apr 01, 2016 10:40:42 AM oracle.security.jps.internal.tools.utility.destination.apibased.JpsDstPolicy cloneAdminRoleMembers
INFO: Migration of Admin Role Members started
Apr 01, 2016 10:40:42 AM oracle.security.jps.internal.tools.utility.destination.apibased.JpsDstPolicy cloneAdminRoleMembers
INFO: Migration of 1 Admin Role Members completed in 00:00:00
Apr 01, 2016 10:40:42 AM oracle.security.jps.internal.tools.utility.destination.apibased.JpsDstPolicy migrateDataInternal
INFO: Migration of 1 Admin Roles completed in 00:00:00
Apr 01, 2016 10:40:43 AM oracle.security.jps.wls.JpsWlsPlatformFactory$2 run
WARNING: Cannot get server log directory. Reason: Cannot get audit log path by environment setting..
Apr 01, 2016 10:40:46 AM oracle.security.jps.internal.tools.utility.JpsUtilMigrationAuditStoreImpl migrateAuditStoreData
INFO: Migration of Audit Store data in progress.....
Apr 01, 2016 10:43:07 AM oracle.security.jps.internal.tools.utility.JpsUtilMigrationAuditStoreImpl migrateAuditStoreData
INFO: Migration of Audit Store data completed, Time taken for migration is 00:02:20
Apr 01, 2016 10:43:10 AM oracle.security.jps.upgrade.tools.DBMassageUtil transformData
INFO: Transformation of security store started.
Apr 01, 2016 10:43:16 AM oracle.security.jps.util.JpsUtil disableAudit
INFO: JpsUtil: isAuditDisabled set to false
Command FAILED, Reason: ORA-01735: invalid ALTER TABLE option
ORA-06512: at line 24

java.sql.SQLSyntaxErrorException: ORA-01735: invalid ALTER TABLE option
ORA-06512: at line 24

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1845)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1810)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
at oracle.security.jps.upgrade.tools.DBMassageUtil.execSQL(DBMassageUtil.java:193)
at oracle.security.jps.upgrade.tools.DBMassageUtil.runScript(DBMassageUtil.java:170)
at oracle.security.jps.upgrade.tools.DBMassageUtil.transformData(DBMassageUtil.java:119)
at oracle.security.jps.upgrade.tools.utility.Upgrade.upgradeInternal(Upgrade.java:469)
at oracle.security.jps.upgrade.tools.utility.Upgrade.upgrade(Upgrade.java:342)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.python.core.PyReflectedFunction.__call__(Unknown Source)
at org.python.core.PyReflectedFunction.__call__(Unknown Source)
at org.python.core.PyObject.__call__(Unknown Source)
at org.python.core.PyObject.invoke(Unknown Source)
at org.python.pycode._pyx34.upgradeOpss$57($Middleware_Home/oracle_common/common/wlst/jpsWlstCmd.py:1545)
at org.python.pycode._pyx34.call_function($Middleware_Home/oracle_common/common/wlst/jpsWlstCmd.py)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyFunction.__call__(Unknown Source)
at org.python.pycode._pyx51.f$0(<console>:1)
at org.python.pycode._pyx51.call_function(<console>)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyCode.call(Unknown Source)
at org.python.core.Py.runCode(Unknown Source)
at org.python.core.Py.exec(Unknown Source)
at org.python.util.PythonInterpreter.exec(Unknown Source)
at org.python.util.InteractiveInterpreter.runcode(Unknown Source)
at org.python.util.InteractiveInterpreter.runsource(Unknown Source)
at org.python.util.InteractiveInterpreter.runsource(Unknown Source)
at weblogic.management.scripting.WLST.main(WLST.java:188)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at weblogic.WLST.main(WLST.java:29)

Traceback (innermost last):
File "<console>", line 1, in ?
File "$Middleware_Home/oracle_common/common/wlst/jpsWlstCmd.py", line 1551, in upgradeOpss
ORA-06512: at line 24

java.sql.SQLSyntaxErrorException: ORA-01735: invalid ALTER TABLE option
ORA-06512: at line 24

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1845)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1810)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
at oracle.security.jps.upgrade.tools.DBMassageUtil.execSQL(DBMassageUtil.java:193)
at oracle.security.jps.upgrade.tools.DBMassageUtil.runScript(DBMassageUtil.java:170)
at oracle.security.jps.upgrade.tools.DBMassageUtil.transformData(DBMassageUtil.java:119)
at oracle.security.jps.upgrade.tools.utility.Upgrade.upgradeInternal(Upgrade.java:469)
at oracle.security.jps.upgrade.tools.utility.Upgrade.upgrade(Upgrade.java:342)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)

oracle.security.jps.JpsException: oracle.security.jps.JpsException: ORA-01735: invalid ALTER TABLE option
ORA-06512: at line 24

java.sql.SQLSyntaxErrorException: ORA-01735: invalid ALTER TABLE option
ORA-06512: at line 24

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1845)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1810)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
at oracle.security.jps.upgrade.tools.DBMassageUtil.execSQL(DBMassageUtil.java:193)
at oracle.security.jps.upgrade.tools.DBMassageUtil.runScript(DBMassageUtil.java:170)
at oracle.security.jps.upgrade.tools.DBMassageUtil.transformData(DBMassageUtil.java:119)
at oracle.security.jps.upgrade.tools.utility.Upgrade.upgradeInternal(Upgrade.java:469)
at oracle.security.jps.upgrade.tools.utility.Upgrade.upgrade(Upgrade.java:342)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.python.core.PyReflectedFunction.__call__(Unknown Source)
at org.python.core.PyReflectedFunction.__call__(Unknown Source)
at org.python.core.PyObject.__call__(Unknown Source)
at org.python.core.PyObject.invoke(Unknown Source)
at org.python.pycode._pyx34.upgradeOpss$57($Middleware_Home/oracle_common/common/wlst/jpsWlstCmd.py:1545)
at org.python.pycode._pyx34.call_function($Middleware_Home/oracle_common/common/wlst/jpsWlstCmd.py)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyFunction.__call__(Unknown Source)
at org.python.pycode._pyx51.f$0(<console>:1)
at org.python.pycode._pyx51.call_function(<console>)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyCode.call(Unknown Source)
at org.python.core.Py.runCode(Unknown Source)
at org.python.core.Py.exec(Unknown Source)
at org.python.util.PythonInterpreter.exec(Unknown Source)
at org.python.util.InteractiveInterpreter.runcode(Unknown Source)
at org.python.util.InteractiveInterpreter.runsource(Unknown Source)
at org.python.util.InteractiveInterpreter.runsource(Unknown Source)
at weblogic.management.scripting.WLST.main(WLST.java:188)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at weblogic.WLST.main(WLST.java:29)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms