9 Replies Latest reply on Feb 6, 2012 3:58 AM by girish_shivanigi

    Server startup error in jboss-soa-p-5 soa platform installation

    girish_shivanigi

      Hi All,

       

      I have just installed jboss-soa-p-5 platform and updated the database configuration to point to Oracle XE 11g on the local machine, however I am running into below two exceptions

       

      1) On starting the default server I get the below error

       

           org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

           and

           org.jboss.util.NestedSQLException: Unable to get managed connection for JBossESBDS; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for JBossESBDS)

       

      2) Also, not able to deploy and run the quickstarts example Helloworld

       

      Any help/pointers is much appreciated

       

      Regards

      Girish

        • 1. Re: Server startup error in jboss-soa-p-5 soa platform installation
          pmuthya

          In you service/deploy/jbossesb.esb, check these files 

          jbossesb-service.ml, if you see the datasource declaration and relevant details, like below:

           

          <?xml version="1.0" encoding="UTF-8"?>

           

          <server>

             <mbean code="org.jboss.internal.soa.esb.dependencies.DatabaseInitializer"

                 name="jboss.esb:service=MessageStoreDatabaseInitializer">

                <attribute name="Datasource">java:/JBossESBDS</attribute>

                <attribute name="ExistsSql">select count(*) from message</attribute>

                <attribute name="SqlFiles">

                   message-store-sql/oracle/create_database.sql

                </attribute>

                <depends>jboss.jca:service=DataSourceBinding,name=JBossESBDS</depends>

             </mbean>

          </server>

           

          message-store-ds.xml,

          should have the jndi name and connection properties setup correctly.

          • 2. Re: Server startup error in jboss-soa-p-5 soa platform installation
            tcunning

            Did you use the jboss-as/tools/schema script to change your settings?   If not I'd advise using that script rather than doing everything by hand.    

            • 3. Re: Server startup error in jboss-soa-p-5 soa platform installation
              girish_shivanigi

              Yup, I used schema scripts to update the database configurations

              • 4. Re: Server startup error in jboss-soa-p-5 soa platform installation
                tcunning

                Did you configure it to use the SYS user?   It looks like that won't work - your or your DBA need to provide a different user with add/drop privileges, or you can change a parameter (07_DICTIONARY_ACCESSIBILITY) - but it looks like Oracle strongly advises against doing that.        It looks like it'd be better just to set up a new user for this purpose.

                • 5. Re: Server startup error in jboss-soa-p-5 soa platform installation
                  pmuthya

                  Is there some documentation which explains on the usage of scripts for setting up a new jboss soa platform?

                  • 6. Re: Server startup error in jboss-soa-p-5 soa platform installation
                    girish_shivanigi

                    Hi,

                     

                    I did change the 07_DICTIONARY_ACCESSIBILITY to true but didn't work, also created the new user and gave all the grants to the new user still doesn't work

                    Is there anything else I am missing there?

                     

                    Regards

                    Girish

                    • 7. Re: Server startup error in jboss-soa-p-5 soa platform installation
                      girish_shivanigi

                      Hi,

                       

                      The issue has been resolved, below are the steps

                       

                      1) Created new db user and granted connec,resource permission to the user.

                      2) Changed SYS user the new user credetntials in all *-ds.xml (datasource files) for all the components.

                       

                      Thanks everyone for the help

                       

                      Regards

                      Girish

                      • 8. Re: Server startup error in jboss-soa-p-5 soa platform installation
                        tcunning

                        P M wrote:

                         

                        Is there some documentation which explains on the usage of scripts for setting up a new jboss soa platform?

                        http://docs.redhat.com/docs/en-US/JBoss_Enterprise_SOA_Platform/5/html/SOA_Getting_Started_Guide/chap-setup.html#sect-changing_database

                        • 9. Re: Server startup error in jboss-soa-p-5 soa platform installation
                          girish_shivanigi

                          Hi All,

                           

                          Having made progress on the above issues, I am bumping into these exceptions below during the server startup..  Please help

                           

                          1) java.lang.IllegalStateException: deployment file does not exist D:\JBoss%20SOA%20Platform\SOA_ROOT\jboss-soa-p-5\jboss-as\server\default\deploy\oracle-ds.xml

                           

                          and getting below excepion for java:/juddiDB

                           

                          2) 12:19:43,529 INFO  [DatasourceConnectionProvider] Using datasource: java:/juddiDB

                              12:19:43,533 INFO  [SettingsFactory] RDBMS: Oracle, version: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

                              12:19:43,534 INFO  [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 9.2.0.1.0

                              12:19:43,563 INFO  [Dialect] Using dialect: org.hibernate.dialect.Oracle10gDialect

                              12:19:43,574 INFO  [JdbcSupportLoader] Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException

                              12:19:43,575 WARN  [SettingsFactory] Could not obtain connection metadata

                              java.sql.SQLException: Unsupported feature

                                  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

                           

                           

                          3)  BPEL schema access.. 

                           

                             12:19:44,865 INFO  [JdbcSupportLoader] Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException

                             12:19:44,866 WARN  [SettingsFactory] Could not obtain connection metadata

                             java.sql.SQLException: Unsupported feature

                           

                          4)

                           

                          12:19:59,565 INFO  [DatasourceConnectionProvider] Using datasource: java:/JbpmDS

                          12:19:59,567 INFO  [SettingsFactory] RDBMS: Oracle, version: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

                          12:19:59,568 INFO  [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 9.2.0.1.0

                          12:19:59,569 INFO  [Dialect] Using dialect: org.hibernate.dialect.Oracle10gDialect

                          12:19:59,571 INFO  [JdbcSupportLoader] Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException

                          12:19:59,572 WARN  [SettingsFactory] Could not obtain connection metadata

                          java.sql.SQLException: Unsupported feature