Re: authid current_user and loops

From: Kamal <kamal80_at_virgilio.it>
Date: 13 May 2003 04:18:05 -0700
Message-ID: <4e766a02.0305130318.1f1f3dff@posting.google.com>

Umhhh... I was sure I've installed a 9iR2 but I see:

SQL> select version from v$instance;

VERSION

9.2.0.1.0

I'm confused. Anyway, the problem persists.

The strange thing I found is that that procedure "fails" only against the tables of the owner of the package.

For example if user y:

exec x.test.outpm('z')

it works.

Only if user y:

exec x.test.outpm('x')

it doesn't work.

It could be certainly a "broken" database but even Apurba Kalita found this problem.
Could it be broken in the same way?

However:

> Sounds like a good time to suggest the following:

> 1. Run DBV to check the physical integrity of the datafiles

$ dbv file=system.dbf logfile=system_df.log blocksize=32768 feedback=100

system_df.log:

DBVERIFY: Release 9.2.0.1.0 - Production on Tue May 13 11:13:39 2003

DBVERIFY - Verification starting : FILE = system.dbf

DBVERIFY - Verification complete

Total Pages Examined         : 15360
Total Pages Processed (Data) : 9233
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 2273
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 1425
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 2429
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0

> 2. Run a full export to check the logical integrity of the database

Done.
But what do you mean "check the logical integrity of the database"?

> 3. Run catalog.sql followed by catproc.sql

Hum hum. Little problem.

SQL> @/oracle/home92/rdbms/admin/catalog create or replace
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$AFTER_CREATE
ORA-00060: deadlock detected while waiting for resource

And 1.3 Mb of log and errors.
I was connected as sys and no other user was connected.

Can you please help me? It is quite urgent.

Kamal Received on Tue May 13 2003 - 06:18:05 CDT