Fred, This link (https://community.oracle.com/thread/287327) suggests that IMP_FULL_DATABASE fixes this...but is apparently considered overkill...another post says
SELECT ANY TABLE UPDATE ANY TABLE eliminates this error http://stackoverflow.com/questions/20988572/getting-ora-01031-insufficient-privileges-while-querying-a-table-instead-of-ora suggests ORA-01031: insufficient privileges happens when the object exists in the schema but do not have any access to that object. On Tue, Feb 7, 2017 at 7:49 AM, Grooms, Frederick W < [email protected]> wrote: > I am trying to upgrade an 8.1.02 ARS only (Single server, no CMDB no ITSM) > to 9.1 and when it tries to start I get the following > > INFO - Thu Feb 02 11:45:11.013 2017 Application context refresh failed ( > OsgiBundleXmlApplicationContext(bundle=com.bmc.arsys.server, > config=spring-context/base_context.xml,spring-context/ > infrastructure_septran_context.xml,spring-context/profiles/aspectj_ctw/ > application_context.xml,spring-context/osgi.xml)) > INFO - org.springframework.beans.factory.BeanCreationException: Error > creating bean with name 'sqlHelper' defined in URL [bundleentry://162. > fwk796684896/spring-context/application/sql_context.xml]: Cannot resolve > reference to bean 'configurator' while setting bean property > 'configurator'; nested exception is > org.springframework.beans.factory.BeanCreationException: > Error creating bean with name 'arTransactionalManager' defined in URL > [bundleentry://162.fwk796684896/spring-context/ > application/aspects_context.xml]: Cannot resolve reference to bean > 'cacheManager' while setting bean property 'cacheManager'; nested exception > is org.springframework.beans.factory.BeanCreationException: Error > creating bean with name 'cacheManager' defined in URL [bundleentry://162. > fwk796684896/spring-context/application/cache_context.xml]: Cannot > resolve reference to bean 'serverGroupBoardDAOManager' while setting > constructor argument; nested exception is org.springframework.beans. > factory.BeanCreationExceptio > n: Error creating bean with name 'serverGroupBoardDAOManager' defined in > URL > [bundleentry://162.fwk796684896/spring-context/application/domain/servergroup_context.xml]: > Invocation of init method failed; nested exception is ERROR (552): Message > not in catalog; Message number = 552; Exception [EclipseLink-4002] (Eclipse > Persistence Services - 2.4.2.v20130514-5956486): org.eclipse.persistence. > exceptions.DatabaseException > INFO - Internal Exception: org.apache.commons.dbcp.SQLNestedException: > Cannot create PoolableConnectionFactory (ORA-01031: insufficient privileges > INFO - ) > INFO - Error Code: 0; nested exception is > javax.persistence.PersistenceException: > Exception [EclipseLink-4002] (Eclipse Persistence Services - > 2.4.2.v20130514-5956486): org.eclipse.persistence. > exceptions.DatabaseException > INFO - Internal Exception: org.apache.commons.dbcp.SQLNestedException: > Cannot create PoolableConnectionFactory (ORA-01031: insufficient privileges > INFO - ) > > I have a ticket opened with BMC but they have not responded. > > According to the install docs (which I had to find under the ITSM install) > the only rights needed for ARS are (which I have): > grant alter session, create cluster, create database link, create > sequence, create session, create synonym, create table, create view, create > procedure, create trigger, query rewrite to ARole_arsys; > > Anybody know what other permissions I need to have granted for ARS 9.1 to > run. > I am on Red-Hat Linux 7 with Oracle 11g and the installer did not complain > about any missing privileges. > > Fred > > ____________________________________________________________ > ___________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
