My Oracle Support Banner

Problems Installing Oracle Service Registry Using SYS User (Doc ID 1322934.1)

Last updated on FEBRUARY 12, 2019

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] <ORACLE OSR INST DIR>/etc/setup/database.xml:737: The following error occurred while executing this line:
[java] <ORACLE OSR INST DIR>/etc/setup/database.xml:350: The following error occurred while executing this line:
[java] <ORACLE OSR INST DIR>/registry111/etc/setup/database.xml:411: The following error occurred while executing this line:
[java] <ORACLE OSR INST DIR>/registry111/etc/setup/database.xml:207: The following error occurred while executing this line:
[java] <ORACLE OSR INST DIR>/registry111/etc/db/oracle/installOracleDB.xml:120: The following error occurred while executing this line:
[java] <ORACLE OSR INST DIR>/registry111/etc/db/oracle/installOracleDB.xml:133: The following error occurred while executing this line:
[java] <ORACLE OSR INST DIR>/registry111/etc/db/oracle/installOracleDB.xml:147: Java returned: 1

[java] Total time: 8 seconds
Java returned: 1
Installation failed. If accessible, see "<ORACLE OSR INST DIR>/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 <WEBLOGIC INST DIR>/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] <WEBLOGIC INST DIR>/osr_delete/etc/setup/database.xml:737: The following error occurred while executing this line:
[java] <WEBLOGIC INST DIR>/osr_delete/etc/setup/database.xml:339: The following error occurred while executing this line:
[java] <WEBLOGIC INST DIR>/osr_delete/etc/setup/database.xml:422: The following error occurred while executing this line:
[java] <WEBLOGIC INST DIR>/osr_delete/etc/setup/database.xml:207: The following error occurred while executing this line:
[java] <WEBLOGIC INST DIR>/osr_delete/etc/db/oracle/installOracleDB.xml:99: The following error occurred while executing this line:
[java] <WEBLOGIC INST DIR>/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 "<WEBLOGIC INST DIR>/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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.