13 Replies Latest reply on Mar 13, 2012 1:12 PM by Bill Robinson

    Appserver unable to access DB

      Installed a test instance of 8.1 SP4 on RH Linux

      Post-install wizard succeeded.

      But When  I try to start the appserver service :

      It fails with the following in appserver.log

      Error installing to Start: name=bladelogic.service.AppServerService state=Create

      com.bladelogic.om.infra.app.service.ServiceInitializationException: com.bladelogic.om.infra.app.db.DBException: An error occurred while attempting to access the database:

      Message : invalid name pattern: BLADELOGIC_81_USER.IDLST SQLState: null ErrorCode: 17074

       

      Bells a ring for anyone ?

      Anyone seen this ?

        • 1. Re: Ora 17074 - Appserver unable to access DB
          Bill Robinson

          Can you post the whole appserver log?

           

          And the output of ‘blasadmin –a show data all’

          • 2. Ora 17074 - Appserver unable to access DB

            This is appserver.log

             

            [13 Mar 2012 15:01:03,896] [main] [INFO] [::] [] Starting Agent Service...
            [13 Mar 2012 15:01:03,901] [main] [INFO] [::] [] Agent Service started.
            [13 Mar 2012 15:01:04,074] [main] [INFO] [::] [] ClientValidation Service started.
            [13 Mar 2012 15:01:04,079] [main] [INFO] [::] [] Starting Configuration Service...
            [13 Mar 2012 15:01:04,282] [main] [INFO] [::] [] Configuration Service started.
            [13 Mar 2012 15:01:04,295] [main] [INFO] [::] [] Starting Content Importer Service...
            [13 Mar 2012 15:01:04,295] [main] [INFO] [::] [] Content Importer Service started.
            [13 Mar 2012 15:01:04,397] [main] [INFO] [::] [] Loading JNI libaries...
            [13 Mar 2012 15:01:04,411] [main] [INFO] [::] [] Loaded JNI library BlAsJni
            [13 Mar 2012 15:01:04,412] [main] [INFO] [::] [] Loaded JNI library XJNIService
            [13 Mar 2012 15:01:04,412] [main] [INFO] [::] [] Loaded JNI library Atrium Core
            [13 Mar 2012 15:01:04,413] [main] [INFO] [::] [] Initializing JNI Configuration...
            [13 Mar 2012 15:01:04,414] [main] [INFO] [::] [] Initialized JNI library BlAsJni
            [13 Mar 2012 15:01:04,417] [main] [INFO] [::] [] Initialized JNI library XJNIService
            [13 Mar 2012 15:01:04,417] [main] [INFO] [::] [] Initialized JNI library Atrium Core
            [13 Mar 2012 15:01:04,417] [main] [INFO] [::] [] JNI Configuration complete.
            [13 Mar 2012 15:01:04,428] [main] [INFO] [::] [] Job Infra Manager Service is starting
            [13 Mar 2012 15:01:04,460] [main] [INFO] [::] [] Starting LDAP Connection Service...
            [13 Mar 2012 15:01:04,460] [main] [INFO] [::] [] LDAP Connection Service started.
            [13 Mar 2012 15:01:04,582] [main] [INFO] [::] [] Starting Model Graph Service...
            [13 Mar 2012 15:01:06,970] [main] [INFO] [::] [] Model Graph Service started.
            [13 Mar 2012 15:01:07,048] [main] [INFO] [::] [] Starting ObjectExporter Service...
            [13 Mar 2012 15:01:07,048] [main] [INFO] [::] [] Verifying exporter classes...
            [13 Mar 2012 15:01:07,058] [main] [INFO] [::] [] Object exporters verified.
            [13 Mar 2012 15:01:07,059] [main] [INFO] [::] [] ObjectExporter Service started.
            [13 Mar 2012 15:01:07,069] [main] [INFO] [::] [] Starting PKI Service...
            [13 Mar 2012 15:01:07,083] [main] [INFO] [::] [] PKI Service started.
            [13 Mar 2012 15:01:07,087] [main] [INFO] [::] [] Starting LDAP Service...
            [13 Mar 2012 15:01:07,087] [main] [INFO] [::] [] LDAP service is not configured.
            [13 Mar 2012 15:01:07,087] [main] [INFO] [::] [] LDAP Service started.
            [13 Mar 2012 15:01:07,092] [main] [INFO] [::] [] Starting Port Provider...
            [13 Mar 2012 15:01:07,092] [main] [INFO] [::] [] Port Provider started.
            [13 Mar 2012 15:01:07,126] [main] [INFO] [::] [] Starting Sizing Service...
            [13 Mar 2012 15:01:07,126] [main] [INFO] [::] [] Sizing Service started.
            [13 Mar 2012 15:01:07,129] [main] [INFO] [::] [] Starting Caching Service...
            [13 Mar 2012 15:01:07,130] [main] [INFO] [::] [] Caching Service started.
            [13 Mar 2012 15:01:07,134] [main] [INFO] [::] [] Starting Session Service...
            [13 Mar 2012 15:01:07,140] [main] [INFO] [::] [] Session Service started.
            [13 Mar 2012 15:01:07,163] [main] [INFO] [::] [] Starting Task Scheduling Service...
            [13 Mar 2012 15:01:07,169] [main] [INFO] [::] [] Task Scheduling Service started.
            [13 Mar 2012 15:01:07,176] [main] [INFO] [::] [] Starting Directory Service...
            [13 Mar 2012 15:01:07,189] [main] [INFO] [::] [] Starting RMI registry on host: blade-test-server
            [13 Mar 2012 15:01:07,201] [main] [INFO] [::] [] Directory Service started.
            [13 Mar 2012 15:01:07,203] [main] [INFO] [::] [] Setting authenticator: com.bladelogic.om.infra.app.service.manage.auth.BlSessionServerAuthenticator
            [13 Mar 2012 15:01:07,203] [main] [INFO] [::] [] Setting client socket factory: com.bladelogic.om.infra.app.service.client.OMClientSocketFactory
            [13 Mar 2012 15:01:07,203] [main] [INFO] [::] [] Setting server socket factory: com.bladelogic.om.infra.app.service.client.ServerSocketFactory
            [13 Mar 2012 15:01:07,205] [main] [INFO] [::] [] Starting Management Service ...
            [13 Mar 2012 15:01:07,673] [main] [INFO] [::] [] Management Service started.
            [13 Mar 2012 15:01:07,686] [main] [INFO] [::] [] Starting Instrumentation Service...
            [13 Mar 2012 15:01:07,690] [main] [INFO] [::] [] Instrumentation Service started.
            [13 Mar 2012 15:01:07,691] [main] [INFO] [::] [] Starting App Server Data Source...
            [13 Mar 2012 15:01:08,187] [main] [INFO] [::] [] Initialized connection pool General-Connection-Pool with url = jdbc:oracle:thin:@DBSERVER:1521:MYSID and user = BLADELOGIC_81_USER
            [13 Mar 2012 15:01:08,312] [main] [INFO] [::] [] Initialized connection pool Job-Connection-Pool with url = jdbc:oracle:thin:@DBSERVER:1521:MYSID and user = BLADELOGIC_81_USER
            [13 Mar 2012 15:01:08,431] [main] [INFO] [::] [] Initialized connection pool Client-Connection-Pool with url = jdbc:oracle:thin:@DBSERVER:1521:MYSID and user = BLADELOGIC_81_USER
            [13 Mar 2012 15:01:08,431] [main] [INFO] [::] [] App Server Data Source started.
            [13 Mar 2012 15:01:08,575] [main] [INFO] [::] [] Starting Database Service...
            [13 Mar 2012 15:01:08,576] [main] [INFO] [::] [] Loaded /opt/nsh/NSH/br/deployments/default/sql/blas-sqlmap.properties
            [13 Mar 2012 15:01:08,592] [main] [INFO] [::] [] Loaded /opt/nsh/NSH/br/deployments/default/sql/sqlmap.properties
            [13 Mar 2012 15:01:08,636] [main] [INFO] [::] [] Loaded /opt/nsh/NSH/br/deployments/default/sql/streamable_sqlmap.properties
            [13 Mar 2012 15:01:08,636] [main] [INFO] [::] [] Loaded /opt/nsh/NSH/br/deployments/default/sql/reports-sqlmap.properties
            [13 Mar 2012 15:01:08,654] [main] [INFO] [::] [] Database service loaded 4 mapping files.
            [13 Mar 2012 15:01:08,655] [main] [INFO] [::] [] Database Service started.
            [13 Mar 2012 15:01:08,775] [main] [INFO] [::] [] Starting Notification Service...
            [13 Mar 2012 15:01:08,781] [main] [INFO] [::] [] Notification Service started.
            [13 Mar 2012 15:01:08,782] [main] [INFO] [::] [] Starting App Server Service...
            [13 Mar 2012 15:01:10,757] [main] [ERROR] [::] [] Error installing to Start: name=bladelogic.service.AppServerService state=Create
            com.bladelogic.om.infra.app.service.ServiceInitializationException: com.bladelogic.om.infra.app.db.DBException: An error occurred while attempting to access the database:
            Message : invalid name pattern: BLADELOGIC_81_USER.IDLST SQLState: null ErrorCode: 17074

                    at com.bladelogic.om.infra.app.service.appserver.DefaultAppServerServiceImpl.start(DefaultAppServerServiceImpl.java:452)
                    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                    at java.lang.reflect.Method.invoke(Method.java:597)
                    at org.jboss.joinpoint.plugins.reflect.ReflectMethodJoinPoint.dispatch(ReflectMethodJoinPoint.java:72)
                    at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$DispatchJoinPoint.run(KernelControllerContextActions.java:631)
                    at java.security.AccessController.doPrivileged(Native Method)
                    at org.jboss.kernel.plugins.dependency.KernelControllerContextActions.dispatchJoinPoint(KernelControllerContextActions.java:99)
                    at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$LifecycleAction.installAction(KernelControllerContextActions.java:452)
                    at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$1.run(KernelControllerContextActions.java:156)
                    at java.security.AccessController.doPrivileged(Native Method)
                    at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$KernelControllerContextAction.install(KernelControllerContextActions.java:179)
                    at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
                    at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:226)
                    at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:593)
                    at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:346)
                    at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:438)
                    at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:379)
                    at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:225)
                    at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:151)
                    at org.jboss.kernel.plugins.deployment.AbstractKernelDeployer.deployBean(AbstractKernelDeployer.java:291)
                    at com.bladelogic.om.infra.app.service.bootstrap.ServiceBeanXMLDeployer.deployBean(ServiceBeanXMLDeployer.java:38)
                    at org.jboss.kernel.plugins.deployment.AbstractKernelDeployer.deployBeans(AbstractKernelDeployer.java:261)
                    at org.jboss.kernel.plugins.deployment.AbstractKernelDeployer.deploy(AbstractKernelDeployer.java:117)
                    at org.jboss.kernel.plugins.deployment.xml.BeanXMLDeployer.deploy(BeanXMLDeployer.java:91)
                    at com.bladelogic.om.infra.app.service.bootstrap.ServiceBootstrap.deploy(ServiceBootstrap.java:252)
                    at com.bladelogic.om.infra.app.service.bootstrap.ServiceBootstrap.deployService(ServiceBootstrap.java:199)
                    at com.bladelogic.om.infra.app.service.bootstrap.ServiceBootstrap.bootstrap(ServiceBootstrap.java:153)
                    at org.jboss.kernel.plugins.bootstrap.AbstractBootstrap.run(AbstractBootstrap.java:91)
                    at com.bladelogic.om.infra.app.service.bootstrap.ServiceBootstrap.startup(ServiceBootstrap.java:66)
                    at com.bladelogic.om.infra.mfw.fw.BlManager.start(BlManager.java:863)
                    at com.bladelogic.om.infra.mfw.fw.BlManager.main(BlManager.java:1381)
            Caused by: com.bladelogic.om.infra.app.db.DBException: An error occurred while attempting to access the database:
            Message : invalid name pattern: BLADELOGIC_81_USER.IDLST SQLState: null ErrorCode: 17074

                    at com.bladelogic.om.infra.app.util.ServerUtil.throwDBException(ServerUtil.java:171)
                    at com.bladelogic.om.infra.model.base.SBlAce.save(SBlAce.java:520)
                    at com.bladelogic.om.infra.model.rbac.BlAceImpl.save(BlAceImpl.java:148)
                    at com.bladelogic.om.infra.model.rbac.BlAceFactory$1.doDBOperation(BlAceFactory.java:89)
                    at com.bladelogic.om.infra.app.db.TransactionalOperation.manageTransaction(TransactionalOperation.java:174)
                    at com.bladelogic.om.infra.app.db.TransactionalOperation.execute(TransactionalOperation.java:136)
                    at com.bladelogic.om.infra.model.rbac.BlAceFactory.insertNewBlAce(BlAceFactory.java:104)
                    at com.bladelogic.om.infra.model.rbac.BlAceFactory.save(BlAceFactory.java:74)
                    at com.bladelogic.om.infra.model.rbac.BlAclImpl.internal_save(BlAclImpl.java:551)
                 at com.bladelogic.om.infra.model.rbac.BlAclImpl.save(BlAclImpl.java:572)
                     at com.bladelogic.om.infra.model.rbac.BlAclFactory$2.doDBOperation(BlAclFactory.java:542)
                     at com.bladelogic.om.infra.app.db.TransactionalOperation.manageTransaction(TransactionalOperation.java:174)
                     at com.bladelogic.om.infra.app.db.TransactionalOperation.execute(TransactionalOperation.java:136)
                     at com.bladelogic.om.infra.model.rbac.BlAclFactory.testAndSetNewBlAcl(BlAclFactory.java:547)
                     at com.bladelogic.om.infra.model.rbac.BlAclFactory.save(BlAclFactory.java:521)
                     at com.bladelogic.om.infra.model.property.LazyPropertySetInstanceImpl.save(LazyPropertySetInstanceImpl.java:654)
                    at com.bladelogic.om.infra.model.typesystem.value.BlValueServiceImpl$1.doDBOperation(BlValueServiceImpl.java:1166)
                     at com.bladelogic.om.infra.app.db.TransactionalOperation.execute(TransactionalOperation.java:132)
                     at com.bladelogic.om.infra.model.typesystem.value.BlValueServiceImpl.save(BlValueServiceImpl.java:1169)
                     at com.bladelogic.om.infra.model.property.PropertySetInstanceServiceImpl$12.doDBOperation(PropertySetInstanceServiceImpl.java:1874)
                     at com.bladelogic.om.infra.app.db.TransactionalOperation.execute(TransactionalOperation.java:132)
                     at com.bladelogic.om.infra.model.property.PropertySetInstanceServiceImpl.create(PropertySetInstanceServiceImpl.java:1877)
                     at com.bladelogic.om.infra.model.property.PropertySetInstanceServiceImpl.create(PropertySetInstanceServiceImpl.java:1693)
                     at com.bladelogic.om.infra.model.property.PropertySetInstanceServiceImpl.create(PropertySetInstanceServiceImpl.java:1670)
                     at com.bladelogic.om.infra.model.appserver.ApplicationServerModelImpl.create(ApplicationServerModelImpl.java:844)
                     at com.bladelogic.om.infra.model.appserver.ApplicationServerModelImpl.save(ApplicationServerModelImpl.java:832)
                     at com.bladelogic.om.infra.model.appserver.ApplicationServerModelServiceImpl$1.doDBOperation(ApplicationServerModelServiceImpl.java:241)
                     at com.bladelogic.om.infra.app.db.TransactionalOperation.manageTransaction(TransactionalOperation.java:174)
                     at com.bladelogic.om.infra.app.db.TransactionalOperation.execute(TransactionalOperation.java:136)
                     at com.bladelogic.om.infra.model.appserver.ApplicationServerModelServiceImpl.saveInternal(ApplicationServerModelServiceImpl.java:244)
                     at com.bladelogic.om.infra.model.appserver.ApplicationServerModelServiceImpl.save(ApplicationServerModelServiceImpl.java:217)
                     at com.bladelogic.om.infra.app.service.appserver.AppServerServiceImpl.registerAppServerModel(AppServerServiceImpl.java:60)
                     at com.bladelogic.om.infra.app.service.appserver.DefaultAppServerServiceImpl.registerApplicationServer(DefaultAppServerServiceImpl.java:885)
                     at com.bladelogic.om.infra.app.service.appserver.DefaultAppServerServiceImpl.start(DefaultAppServerServiceImpl.java:416)
                     ... 32 more
            Caused by: java.sql.SQLException: invalid name pattern: BLADELOGIC_81_USER.IDLST
                     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
                     at oracle.jdbc.oracore.OracleTypeADT.initMetadata(OracleTypeADT.java:463)
                     at oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeADT.java:362)
                     at oracle.sql.ArrayDescriptor.initPickler(ArrayDescriptor.java:1756)
                     at oracle.sql.ArrayDescriptor.<init>(ArrayDescriptor.java:272)
                     at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:196)
                     at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:165)
               at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:150)
                    at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:115)
                    at oracle.jdbc.driver.NamedTypeAccessor.otypeFromName(NamedTypeAccessor.java:71)
                    at oracle.jdbc.driver.TypeAccessor.initMetadata(TypeAccessor.java:79)
                    at oracle.jdbc.driver.T4CCallableStatement.allocateAccessor(T4CCallableStatement.java:640)
                    at oracle.jdbc.driver.OracleCallableStatement.registerOutParameterInternal(OracleCallableStatement.java:148)
                    at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:194)
                    at com.bladelogic.om.infra.shared.db.BlCallableStatement.registerOutParameter(BlCallableStatement.java:295)
                    at org.apache.commons.dbcp.DelegatingCallableStatement.registerOutParameter(DelegatingCallableStatement.java:174)
                    at org.apache.commons.dbcp.DelegatingCallableStatement.registerOutParameter(DelegatingCallableStatement.java:174)
                    at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.executeSqlStringNoUpdate(DefaultDatabaseServiceImpl.java:1162)
                    at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.executeSqlStringNoUpdate(DefaultDatabaseServiceImpl.java:1124)
                    at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.getNextId(DefaultDatabaseServiceImpl.java:1594)
                    at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.executeInsert(DefaultDatabaseServiceImpl.java:1432)
                    at com.bladelogic.om.infra.app.service.db.DefaultDatabaseServiceImpl.executeInsert(DefaultDatabaseServiceImpl.java:1393)
                    at com.bladelogic.om.infra.app.db.DBServiceImpl.executeInsert(DBServiceImpl.java:259)
                    at com.bladelogic.om.infra.app.db.DBServiceImpl.executeInsert(DBServiceImpl.java:246)
                    at com.bladelogic.om.infra.model.base.SBlAce.save(SBlAce.java:505)
                    ... 64 more
            [13 Mar 2012 15:01:10,761] [main] [INFO] [::] [] Starting SRP Authentication Service...
            [13 Mar 2012 15:01:10,764] [main] [INFO] [::] [] Creating primary numbers file
            [13 Mar 2012 15:01:10,780] [main] [INFO] [::] [] SRP Authentication Service started.
            [13 Mar 2012 15:01:10,780] [main] [INFO] [::] [] Starting Atrium Import Service...
            [13 Mar 2012 15:01:10,780] [main] [INFO] [::] [] Atrium Import Service started.
            [13 Mar 2012 15:01:10,780] [main] [INFO] [::] [] Verifying object deleters...
            [13 Mar 2012 15:01:10,785] [main] [INFO] [::] [] Object deleters verified.
            [13 Mar 2012 15:01:10,785] [main] [INFO] [::] [] Verifying object soft deleters...
            [13 Mar 2012 15:01:10,794] [main] [INFO] [::] [] Object soft deleters verified.
            [13 Mar 2012 15:01:10,794] [main] [INFO] [::] [] Verifying object purgers...
            [13 Mar 2012 15:01:10,795] [main] [INFO] [::] [] Object purgers verified.
            [13 Mar 2012 15:01:10,795] [main] [INFO] [::] [] Starting Job Executor Service...
            [13 Mar 2012 15:01:10,795] [main] [INFO] [::] [] Job Executor Service started.
            [13 Mar 2012 15:01:10,798] [main] [INFO] [::] [] Starting RBAC Role Service...
            [13 Mar 2012 15:01:10,798] [main] [INFO] [::] [] RBAC Role Service started.
            [13 Mar 2012 15:01:10,798] [main] [INFO] [::] [] Starting RBAC User Service...
            [13 Mar 2012 15:01:10,799] [main] [INFO] [::] [] RBAC User Service started.
            [13 Mar 2012 15:01:10,801] [main] [INFO] [::] [] Starting RBAC Service...
            [13 Mar 2012 15:01:10,801] [main] [INFO] [::] [] Registering Security checkers...
            [13 Mar 2012 15:01:10,805] [main] [INFO] [::] [] Security checkers registered.
            [13 Mar 2012 15:01:10,805] [main] [INFO] [::] [] RBAC Service started.
            [13 Mar 2012 15:01:10,807] [main] [INFO] [::] [] Starting RBAC Authentication User Service...
            [13 Mar 2012 15:01:10,807] [main] [INFO] [::] [] RBAC Authentication User Service started.
            [13 Mar 2012 15:01:10,827] [main] [INFO] [::] [] Starting Authentication Service...
            [13 Mar 2012 15:01:10,828] [main] [INFO] [::] [] Authentication-Service is starting worker threads
            [13 Mar 2012 15:01:10,835] [main] [INFO] [::] [] Authentication Service started.
            [13 Mar 2012 15:01:10,845] [Authentication-Service-Thread-0] [INFO] [::] [] Authentication Service thread started
            [13 Mar 2012 15:01:10,854] [Authentication-Service-Thread-1] [INFO] [::] [] Authentication Service thread started
            [13 Mar 2012 15:01:10,856] [Authentication-Service-Thread-2] [INFO] [::] [] Authentication Service thread started
            [13 Mar 2012 15:01:10,857] [main] [INFO] [::] [] Starting Service Lifecycle Service...
            [13 Mar 2012 15:01:10,858] [main] [INFO] [::] [] Service Lifecycle Service started.
            [13 Mar 2012 15:01:10,859] [main] [INFO] [::] [] Registering remote services...
            [13 Mar 2012 15:01:10,859] [main] [INFO] [::] [] Shutdown processes complete
            [13 Mar 2012 15:01:10,861] [Thread-0] [INFO] [::] [] Undeploying
            [13 Mar 2012 15:01:10,872] [Thread-0] [ERROR] [::] [] java.rmi.NotBoundException: bladelogic.service.AuthenticationService

             

            This is AppserverLauncher.log

            ] [] Starting application server launcher ...
            [13 Mar 2012 15:22:36,219] [main] [INFO] [::] [] Starting RMI registry on host : blade-test-server
            [13 Mar 2012 15:22:36,351] [main] [INFO] [::] [] Setting client socket factory: com.bladelogic.om.infra.app.service.client.ClientSocketFactory
            [13 Mar 2012 15:22:36,351] [main] [INFO] [::] [] Setting server socket factory: com.bladelogic.om.infra.app.service.client.ServerSocketFactory
            [13 Mar 2012 15:22:36,351] [main] [INFO] [::] [] Setting authenticator: com.bladelogic.om.infra.app.service.manage.auth.BlSessionServerAuthenticator
            [13 Mar 2012 15:22:36,351] [main] [INFO] [::] [] Starting Management Service ...
            [13 Mar 2012 15:22:36,863] [main] [INFO] [::] [] Management Service started.
            [13 Mar 2012 15:22:36,863] [main] [INFO] [::] [] Setting up app server message listener on port: 9701

            • 3. Ora 17074 - Appserver unable to access DB
              Bill Robinson

              what about the blasadmin output ?

              • 4. Ora 17074 - Appserver unable to access DB

                Here you go : ( In the meantime, I have asked DBA to reconfirm that all requied configuration has been set as per BMC's Documentation, first in my list to blame   )

                 

                 

                blasadmin -a show data all

                blasadmin now running against the following deployments: _template, default

                [Database]

                AutoBatchEnabled:true

                ConnectionString:jdbc:oracle:thin:@DBSERVER:1521:MYSID

                DatabaseInstrumentationFilePath:

                DatabaseInstrumentationRolloverCount:10

                DatabaseInstrumentationRolloverSize:10000

                DatabaseVersion:8.1.1

                DriverClass:oracle.jdbc.driver.OracleDriver

                FetchSize:100

                IdleConnectionTestPeriod:600

                MaxClientConnections:100

                MaxGeneralConnections:100

                MaxIdleTime:600

                MaxJobExecutionConnections:100

                MaxWaitTime:

                MinClientConnections:0

                MinGeneralConnections:0

                MinJobExecutionConnections:0

                MinTimeToLog:0

                Password:blablaENCYRTPEDSTRINGblabla

                SqlFiles:

                    sql/blas-sqlmap.properties

                    sql/sqlmap.properties

                    sql/streamable_sqlmap.properties

                    sql/reports-sqlmap.properties

                TransactionAttempts:10

                UserId:BLADELOGIC_81_USER

                • 5. Ora 17074 - Appserver unable to access DB
                  Bill Robinson

                  what is the actual userid ? is it 'BLADELOGIC_81_USER' ?

                   

                  the error is:

                   

                  Message : invalid name pattern: BLADELOGIC_81_USER.IDLST SQLState: null ErrorCode: 17074

                   

                  which means you might not have the user specified correctly.

                  • 6. Re: Ora 17074 - Appserver unable to access DB

                    'BLADELOGIC_81_USER' is the the actual user

                    I would have expect this to fail at the time of using the post install configuration wizard, if the User ID was wrong.

                     

                    Won't it fail at that time only if it was wrong ? I have seen that  happening in the past

                    • 7. Re: Ora 17074 - Appserver unable to access DB
                      Bill Robinson

                      Why does the error say ‘BLADELOGIC_81_USER.IDLST’ ?

                      • 8. Appserver unable to access DB

                        No Idea.

                        But I do suspect , something is wrong with this user id .

                        May be previliges for this user are messed up.

                         

                        Thanks,

                        Rohit

                        • 9. Appserver unable to access DB

                          Apart from blasadmin, where else can the user be wrong ? 

                          is it pikcing  up this BLADELOGIC_81_USER.IDLST ?

                          • 10. Appserver unable to access DB

                            The installation gude tells you:

                            When you install BMC BladeLogic Server Automation, you should be the owner of

                            the schema. If your organization’s policy does not permit you to own the schema,

                            your user account must have the following grants:

                            SELECT ANY TABLE

                            UPDATE ANY TABLE

                            INSERT ANY TABLE

                            DELETE ANY TABLE

                            CREATE ANY TABLE

                            ALTER ANY TABLE

                            DROP ANY TABLE

                            SELECT ANY SEQUENCE

                            SELECT ANY DICTIONARY

                            EXECUTE ANY PROCEDURE

                            CREATE VIEW

                            In addition, all synonyms must be public

                             

                            These are only required for the user creating the schema ? Right ?

                            not for the logon user ?

                             

                             

                            • 11. Re: Appserver unable to access DB
                              Bill Robinson

                              They are required by the user connecting to run the app.

                              • 12. Re: Appserver unable to access DB

                                Thanks.  I was thinking so but somehow i have been told the already running 7.6 user doesn't have these

                                So in this case the user bladelogic_81_user should have all of these ?

                                 

                                 

                                 

                                Sent from my iPhone

                                • 13. Re: Appserver unable to access DB
                                  Bill Robinson

                                  The user should have whatever is in the schema creation script for the version that you are running.  I think what you listed is accurate but you should check.