Error in report RSORADJV

[former_member209959]

Hi everybody,

After to upgrade our database to release 11.2.0.2 we get the next error when we execute the automated Oracle DB parameter check from note 1171650:

The following table has not owner PUBLIC or SYS: DBA_TABLES

Before the upgrade, the report worked fine.

Could someone help me to solve this issue?.

Best Regards

[sivakumar_kilari3]

This message was moderated.

[former_member209959]

Thanks Siva, but it's not the same problem, because we have SAP Basis 6.40 level 19 and we don't have the SQL Command Editor in DBACOCKPIT. The report exists, but we get the error I reported before.

Regards.

[Former Member]

Hi Maximino,

Execute the the statement, below and check owner of the table;

1) SELECT * FROM USER_TAB_PRIVS where table_name='DBA_TABLES';

If the owner is SYS, then check OPS$ mechanism (grants) on your system.

2) Did you you executed sapdba_role.sql, after the upgrade? If not, then apply Note 134592 - Importing the SAPDBA role (sapdba_role.sql)

3) Execute, SELECT owner FROM dba_objects WHERE object_name = 'DBA_TABLES';

It should contain the records, below;

OWNER

-

---

SYS

PUBLIC

Best regards,

Orkun Gedik

Edited by: Orkun Gedik on Apr 29, 2011 3:37 PM

[former_member209959]

Hi Orkun, and thanks for your help. I'll try to answer you:

1) This is the output of the query:

SQL> select GRANTEE OWNER FROM USER_TAB_PRIVS where table_name='DBA_TABLES';

OWNER

-

---

PUBLIC

SELECT_CATALOG_ROLE

SQL> SELECT * FROM USER_TAB_PRIVS where table_name='DBA_TABLES';

GRANTEE OWNER TABLE_NAME GRANTOR

-

---

-

---

-

---

-

---

PRIVILEGE GRA HIE

-

---

--- ---

PUBLIC SYS DBA_TABLES SYS

SELECT NO NO

SELECT_CATALOG_ROLE SYS DBA_TABLES SYS

SELECT NO NO

2) I have executed the sapdba_role.sql for release 11g, but the issue continues.

3) SQL> SELECT owner FROM dba_objects WHERE object_name = 'DBA_TABLES';

OWNER

-

---

SYS

PUBLIC

PATROL

What will I have to do now?

Thanks.

[Former Member]

There shouldn't be any table with name 'DBA_TABLES' ...

What is the output of:

SELECT owner, object_type FROM dba_objects WHERE object_name = 'DBA_TABLES';

And what is user PATROL in your system?

Was it installed recently? Or was it already there in Oracle 10g?

Did someone play around with BMC Patrol or something like that?

[former_member209959]

Hi Joe, this is the ouptut:

SQL> SELECT owner, object_type FROM dba_objects WHERE object_name = 'DBA_TABLES';

OWNER OBJECT_TYPE

-

---

-

---

SYS VIEW

PUBLIC SYNONYM

PATROL SYNONYM

The user Patrol is used for monitoring task (I think for BMC patrol) but he already existed in Oracle 10g

I have just finished to test the query of the note 1171650 for Oracle 11g in a system that is still in Oracle 10g, and I get the same error that in the system that is in Oracle 11g. Maybe a SAP error in the new version?.

Thanks and Regards.

[Former Member]

H Maximino,

There's no problem with the script. I just downladed the script and able execute it, successfully on Oracle 11g. Under this circumstance, I recommend that you open a ticket to OSS, in order to investigate the issue, on the site.

Best regards,

Orkun Gedik

[Former Member]

I agree with Orkun here.

The last select shows that there isn't any table with name 'DBA_TABLES'.

Let SAP find out what confused the script.

[former_member209959]

Thanks everybody,

I have just finished to open a ticket to SAP. If they give me some solution I'll report it in the forum.

Best Regards.

Maxi

[fidel_vales]

> Hi Joe, this is the ouptut:
> 
> SQL> SELECT owner, object_type FROM dba_objects WHERE object_name = 'DBA_TABLES';
> 
> OWNER                          OBJECT_TYPE
> -
-
 -
-
> SYS                            VIEW
> PUBLIC                         SYNONYM
> PATROL                         SYNONYM
> 
> The user Patrol is used for monitoring task (I think for BMC patrol) but he already existed in Oracle 10g
> 
> I have just finished to test the query of the note 1171650 for Oracle 11g in a system that is still in Oracle 10g, and I get the same error that in the system that is in Oracle 11g.  Maybe a SAP error in the new version?.
> 
> Thanks and Regards.

Hi, the problem is that there is 2 synonyms.

it is a bug in dbacockpit, it gets "confused" by the second synonym and it is corrected.

I'm trying to find the note where it is explained, but it is not easy even whne I know it is there

Found, check

Note 1261465 - DBACockpit: Obj owner incorrect if using SQL command editor

Edited by: Fidel Vales on Apr 29, 2011 8:54 PM

[former_member209959]

Hi everybody,

The solutions was this query:

SQL> drop synonym PATROL.DBA_TABLES;

And now the script works fine.

Thanks and Regards.