Problems Installing Oracle Service Registry Using SYS User

(Doc ID 1322934.1)

Last updated on FEBRUARY 24, 2017

Applies to:

Oracle Service Registry - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Symptoms

When installing Oracle Service Registry (version 11.1.1.2), the default Oracle database administrator user is 'system'.
You can use other users such as SYS, as shown below.




However when using SYS on its own as shown above, the OSR installer fails with the following error.

[java] BUILD FAILED
[java] /usr/local/oracle/mw/registry111/etc/setup/database.xml:737: The following error occurred while executing this line:
[java] /usr/local/oracle/mw/registry111/etc/setup/database.xml:350: The following error occurred while executing this line:
[java] /usr/local/oracle/mw/registry111/etc/setup/database.xml:411: The following error occurred while executing this line:
[java] /usr/local/oracle/mw/registry111/etc/setup/database.xml:207: The following error occurred while executing this line:
[java] /usr/local/oracle/mw/registry111/etc/db/oracle/installOracleDB.xml:120: The following error occurred while executing this line:
[java] /usr/local/oracle/mw/registry111/etc/db/oracle/installOracleDB.xml:133: The following error occurred while executing this line:
[java] /usr/local/oracle/mw/registry111/etc/db/oracle/installOracleDB.xml:147: Java returned: 1

[java] Total time: 8 seconds
Java returned: 1
Installation failed. If accessible, see "/usr/local/oracle/mw/registry111/log/install.log".
To correct installation parameters and resume installation click Recovery.


The following extended errors is shown when using debug mode:

[java] create_db:
[java] [echo] Creating new tablespace and database user ...
[java] [copy] Copying 1 file to /home/oracle/products/ApplicationServer/Weblogic_11gR4/osr_delete/etc/db/oracle

[java] set_connection_string:

[java] create_quiet:
[java] [java] java.sql.SQLException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

[java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:452)
[java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
[java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:384)
[java] [java] at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:657)
[java] [java] at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:433)
[java] [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:471)
[java] [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:199)
[java] [java] at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:365)

[java] BUILD FAILED
[java] /home/oracle/products/ApplicationServer/Weblogic_11gR4/osr_delete/etc/setup/database.xml:737: The following error occurred while executing this line:
[java] /home/oracle/products/ApplicationServer/Weblogic_11gR4/osr_delete/etc/setup/database.xml:339: The following error occurred while executing this line:
[java] /home/oracle/products/ApplicationServer/Weblogic_11gR4/osr_delete/etc/setup/database.xml:422: The following error occurred while executing this line:
[java] /home/oracle/products/ApplicationServer/Weblogic_11gR4/osr_delete/etc/setup/database.xml:207: The following error occurred while executing this line:
[java] /home/oracle/products/ApplicationServer/Weblogic_11gR4/osr_delete/etc/db/oracle/installOracleDB.xml:99: The following error occurred while executing this line:
[java] /home/oracle/products/ApplicationServer/Weblogic_11gR4/osr_delete/etc/db/oracle/installOracleDB.xml:166: Java returned: 1
[java] [java] at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:812)
[java] [java] at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411)
[java] [java] at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:549)
[java] [java] at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:225)
[java] [java] at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:29)
[java] [java] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:556)
[java] [java] at java.sql.DriverManager.getConnection(DriverManager.java:582)
[java] [java] at java.sql.DriverManager.getConnection(DriverManager.java:154)
[java] [java] at com.systinet.uddi.database.util.CreateSchema.setUpConnection(CreateSchema.java:269)
[java] [java] at com.systinet.uddi.database.util.Connector.init(Connector.java:133)
[java] [java] at com.systinet.uddi.database.util.CreateSchema.main(CreateSchema.java:352)

[java] Total time: 2 seconds
[java] [java] java.lang.RuntimeException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

[java] [java] at com.systinet.uddi.database.util.Connector.handleSQLException(Connector.java:74)
[java] [java] at com.systinet.uddi.database.util.CreateSchema.setUpConnection(CreateSchema.java:276)
[java] [java] at com.systinet.uddi.database.util.Connector.init(Connector.java:133)
[java] [java] at com.systinet.uddi.database.util.CreateSchema.main(CreateSchema.java:352)
Java returned: 1
Installation failed. If accessible, see "/home/oracle/products/ApplicationServer/Weblogic_11gR4/osr_delete/log/install.log".
To correct installation parameters and resume installation click Recovery.



To see the full extent of the error it always better to run the OSR installer in debug mode.

java -jar oracle-service-registry-11.1.1.jar --debug

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