 compilation of SYS.DBMS_STANDARD [message #127931] |
Thu, 14 July 2005 03:52  |
truptipan
Messages: 3
Registered: July 2005
Location: Pune
|
Junior Member |
|
|
Hi,
I have a 9.2.0.4 database which has the package SYS.DBMS_STANDARD package uncompiled.
I tried doing 'alter package dbms_standard compile' as sys user but it hangs. I also executed utlrp.sql as sys user but that dint help.
How can i come out of it.
This is pretty urgent.
Thank you,
Trupti
|
|
|
|
|
|
| Re: compilation of SYS.DBMS_STANDARD [message #128087 is a reply to message #128026] |
Thu, 14 July 2005 23:43  |
truptipan
Messages: 3
Registered: July 2005
Location: Pune
|
Junior Member |
|
|
Hi,
thank you for the response. I tried executing catalog.sql in restricted mode, but got the following error.
create or replace
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_STANDARD
create or replace
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_STANDARD
Grant succeeded.
create or replace package dbms_standard is
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_STANDARD
Hence, I stopped the execution of the script. Is there anything I need to do to get this package compiled ?
Thank you ,
Trupti
|
|
|
|
|
|
| Re: compilation of SYS.DBMS_STANDARD [message #128113 is a reply to message #128092] |
Fri, 15 July 2005 03:25 |
truptipan
Messages: 3
Registered: July 2005
Location: Pune
|
Junior Member |
|
|
hi,
thank you for the response. The alert file contains the following entries at the end of the file
--------------------------------
Fri Jul 8 20:29:25 2005
Errors in file /database/oracle/products/9.2/admin/CHIPDB0/udump/chipdb_ora_25353.trc:
ORA-00600: internal error code, arguments: [4194], [25], [32], [], [], [], [], []
Recovery of Online Redo Log: Thread 1 Group 2 Seq 15884 Reading mem 0
Mem# 0 errs 0: /database/Redo2/CHIPDB/redo02.log
Recovery of Online Redo Log: Thread 1 Group 2 Seq 15884 Reading mem 0
Mem# 0 errs 0: /database/Redo2/CHIPDB/redo02.log
Fri Jul 8 20:29:36 2005
Errors in file /database/oracle/products/9.2/admin/CHIPDB0/udump/chipdb_ora_25345.trc:
ORA-00600: internal error code, arguments: [4194], [25], [32], [], [], [], [], []
Fri Jul 8 20:29:38 2005
Recovery of Online Redo Log: Thread 1 Group 2 Seq 15884 Reading mem 0
Mem# 0 errs 0: /database/Redo2/CHIPDB/redo02.log
Recovery of Online Redo Log: Thread 1 Group 2 Seq 15884 Reading mem 0
Mem# 0 errs 0: /database/Redo2/CHIPDB/redo02.log
Fri Jul 8 20:50:45 2005
Errors in file /database/oracle/products/9.2/admin/CHIPDB0/bdump/chipdb_smon_24530.trc:
ORA-00600: internal error code, arguments: [4194], [25], [32], [], [], [], [], []
Fri Jul 8 20:50:48 2005
Recovery of Online Redo Log: Thread 1 Group 2 Seq 15884 Reading mem 0
Mem# 0 errs 0: /database/Redo2/CHIPDB/redo02.log
Recovery of Online Redo Log: Thread 1 Group 2 Seq 15884 Reading mem 0
Mem# 0 errs 0: /database/Redo2/CHIPDB/redo02.log
Fri Jul 8 20:50:49 2005
Errors in file /database/oracle/products/9.2/admin/CHIPDB0/bdump/chipdb_smon_24530.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [25], [32], [], [], [], [], []
--------------------------------
I tried exporting the data as .dmp files but i get the error
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_STANDARD
Thank you.
Trupti
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
