Re: on "_system_trig_enabled" parameter setting

  • From: Bala <oratips@xxxxxxxxx>
  • To: "Jared Still" <jkstill@xxxxxxxxx>
  • Date: Mon, 12 Mar 2007 17:12:24 -0400

###
17:09:42 NVUATDB > select * from dual;

D
-
X

Elapsed: 00:00:00.02
###

17:09:45 NVUATDB > select * from x$dual;

ADDR                   INDX    INST_ID D
---------------- ---------- ---------- -
0000000102E229E0          0          1 X

Elapsed: 00:00:00.01
###
Thank you Very much for the reply.

Bala --



On 3/12/07, Jared Still <jkstill@xxxxxxxxx> wrote:


What are the results of running these queries?

select * from dual;

select * from x$dual;



On 3/12/07, Bala < oratips@xxxxxxxxx> wrote:
>
>  1) I am getting ORA-06553: PLS-213: package STANDARD not accessible,
> temporary workaround i am doing is setting init.ora parameter
> "_system_trig_enabled=false" and recreate standard package.
> 2) If i dont do the above , i cant even chanage users password , get the
> following
>
> SQL> alter user test identified by welcome
> --
> ERROR at line 1:
>
> ORA-00604: error occurred at recursive SQL level 1
>
> ORA-01422: exact fetch returns more than requested number of rows
>
> ORA-06512: at line 11
> 3) any insight is very much appreciated. Thanks for your time.
>
>
> Solaris 2.9, Oracle 9.2.0.6
>
> Regards,
>
> --
> Bala Rao
>



--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist





--
Bala Rao

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2007