Problem with Oracle 8

From: Fabienne Dubos <fdubos_at_France.Sun.Com>
Date: Mon, 22 Jun 1998 19:34:36 +0200
Message-ID: <358E95AC.107F@France.Sun.Com>

Hello,

	I'm working on Oracle 8.0.3 on Ultra platform, 


	(OS : Solaris 2.5 and 2.6) and


	I've some problems. Someone ca help me PLEASE ????



	

1. First problem ...

   ---

SQL> select * from V$PWFILE_USERS
  2 where username='INTERNAL';
ERROR:
ORA-00600: internal error code, arguments: [1113], [], [], [], [], [], [], []

        IS there normal ... or is-there a patch ???                  

2. Second problem ...

---

        I've some problem with snapshot. I can't execute dbms_snapshot.refresh_all.

        I think I've some problems with the package catproc. The QUEUE part can't

	compile correctly, and I think there's some repercution on the snapshot
	package ...
	
	

SQL> execute sys.dbms_snapshot.refresh_all; begin sys.dbms_snapshot.refresh_all; end;

*
ERROR at line 1:

ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_SNAPSHOT" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1


	When I look at this package, it's invalid. It cant't compile
	It searchs for a variable named : DEFTRANDEST


	Someone knows this problem ?????
	
	
	
	
	
	

3. Third problem ...

---

	I've tried to use recover manager. And I can't resynchronise the
	database and the catalog :
	
	
	

RMAN> resync catalog;

RMAN-03022: compiling command: resync
RMAN-03023: executing command: resync
RMAN-00569: ================error message stack follows================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-00600: internal error, arguments [10053] [1] [] [] []

vancouver (sh) [ora] $

        From a deseparate DBA ... Thank a lot for yours anwers ...         

(please send me directely the answer, I'm not in the alias)
        

			Fabienne Dubos
			(fdubos_at_France.sun.com).

Received on Mon Jun 22 1998 - 12:34:36 CDT