0 Replies Latest reply on Jun 23, 2014 1:03 PM by user13321848

    Weblogic 10.3.4 - connect to remote oracle AQ jms topic with foreign server - which queries are run during connection?

    user13321848

      Hi All.

       

      I have configured a foreign server to connect to a remote oracle AQ topic from weblogic server. I have used https://blogs.oracle.com/soaproactive/entry/jms_step_6_how_to

      I still have one error:

       

      ####<2014-06-23_12:48:39,015> <Warning> <EJB> <sinfctsmnbe01.corproot.net> <managed1> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (s elf-tuning)'> <<anonymous>> <> <> <1403520519015> <WL-010061> <The Message-Driven EJB: LocalReader is unable to connect to the JMS destination: jms/remoteTopic. The Error was:

      6459 oracle.jms.AQjmsException: ORA-01031: insufficient privileges

      6460 ORA-06512: at "SYS.DBMS_AQADM_SYS", line 6274

      6461 ORA-06512: at line 1

      6462 ORA-06512: at "SYS.DBMS_AQJMS", line 129

      6463 ORA-06512: at line 1

      6464

      6465 Nested exception: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

      6466 ORA-06512: at "SYS.DBMS_AQADM_SYS", line 6274

      6467 ORA-06512: at line 1

      6468 ORA-06512: at "SYS.DBMS_AQJMS", line 129

      6469 ORA-06512: at line 1


      Grants for my db user which I use at datasource level are:


      oracle@appserver:/tmp/: sqlplus APP_USER/****@db/APP

       

       

       

      SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 16:22:52 2014

       

       

       

      Copyright (c) 1982, 2011, Oracle.  All rights reserved.

       

       

       

       

       

      Connected to:

       

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

       

      With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

       

      Data Mining and Real Application Testing options

       

       

       

      SQL> set linesize 200

       

      SQL> col grantor format a15

       

      SQL> col grantee format a14

       

      SQL> col table_schema format a15

       

      SQL> col table_name format a19

       

      SQL> col privilege format a10

       

      SQL>

       

      SQL> select * from all_tab_privs

       

        2  where (

       

      3     grantee in (select granted_role from user_role_privs)

       

      4     or table_name like '%APP%'=ł

       

       

       

      GRANTOR GRANTEE TABLE_SCHEMA TABLE_NAME PRIVILEGE  GRA HIE

       

      --------------- -------------- --------------- ------------------- ---------- --- ---

       

      SYS AQ_USER_ROLE SYS DBMS_AQ EXECUTE    NO  NO

       

      SYS AQ_USER_ROLE SYS DBMS_AQIN EXECUTE    NO  NO

       

      SYS AQ_USER_ROLE SYS DBMS_AQJMS_INTERNAL EXECUTE    NO  NO

       

      SYS AQ_USER_ROLE SYS DBMS_TRANSFORM      EXECUTE    NO NO

       

      APP_ADMIN APP_USER_R APP_ADMIN APP_NOTIF_Q     DEQUEUE    NO  NO

       

      APP_ADMIN APP_USER_R APP_ADMIN APP_NOTIF_Q     ENQUEUE    NO  NO

       

      APP_ADMIN APP_APP    APP_ADMIN APP_NOTIF_Q     DEQUEUE    NO  NO

       

      APP_ADMIN APP_APP    APP_ADMIN APP_NOTIF_Q     ENQUEUE    NO  NO

       

      APP_ADMIN APP_APP    APP_ADMIN APP_NOTIF_QTAB  UPDATE     NO  NO

       

      APP_ADMIN APP_APP    APP_ADMIN APP_NOTIF_QTAB  SELECT     NO  NO

       

      APP_ADMIN APP_APP    APP_ADMIN APP_NOTIF_QTAB  INSERT     NO  NO

       

      APP_ADMIN APP_APP    APP_ADMIN APP_NOTIF_QTAB  DELETE     NO  NO

       

      12 rows selected.

       

      SQL>


      I would like to have a list of queries which are performed when my local weblogic server tries to connect to the remote topic. Is it possible to get such list?

       

      BR,

      Rafal.