| ERROR-06553 [message #4878] |
Fri, 17 January 2003 14:08  |
mitra fatolahi
Messages: 38
Registered: October 2002
|
Member |
|
|
Hello Everyone,
I am trying to add a new column to a table using ORACLE 9i EM or changing a PW for a User and i keep getting the following ORA Errors for both above modifications:
ORA-00604: error occured at recursive SQL Level 1
ORA-06553: PLS-213: package STANDARD not accessible
I had been able to do both kind of changes before without getting any error.
Thank you for your help!
Mitra
|
|
|
|
| Re: ERROR-06553 [message #4891 is a reply to message #4878] |
Sun, 19 January 2003 11:28  |
Robert Kuhlmann
Messages: 35
Registered: March 2002
|
Member |
|
|
Hey mitra,
test the following statment and post the answer!
select count(object_name), object_type, status
from dba_objects
where object_type = 'PACKAGE'
group by object_type, status;
I think you don't have an undo tablespace.
Robert
|
|
|
|
| Re: ERROR-06553 [message #4908 is a reply to message #4891] |
Mon, 20 January 2003 11:03 |
mitra fatolahi
Messages: 38
Registered: October 2002
|
Member |
|
|
Robert,
i just read your reply and ran the SQL statements you posted. Here is what i got:
COUNT(OBJECT_NAME) OBJECT_TYPE STATUS
315 PACKAGE INVALID
138 PACKAGE VALID
I had no problem Creating/Editing any schema objects after i had installed ORACLE 9i for sometime. I don't know what caused this issue all of a suddent!
I appeciate your help!
Thank you,
Mitra
|
|
|
|
| Re: ERROR-06553 [message #4933 is a reply to message #4891] |
Tue, 21 January 2003 12:52 |
Robert Kuhlmann
Messages: 35
Registered: March 2002
|
Member |
|
|
HEy, you see that a lot of packages are invalid so you must compile them
First find then
select object_name from dab_objects
where status = 'INVALID';
Then compile them
alter package PACKAGENAME compile;
then try to change the Password
bye
|
|
|
|
| Re: ERROR-06553 [message #4938 is a reply to message #4891] |
Tue, 21 January 2003 14:12 |
mitra fatolahi
Messages: 38
Registered: October 2002
|
Member |
|
|
Robert,
Thanks for replying!
I was about to post my question again and hoping that you will see it and reply back to me on the result i had posted on Monday after i ran the statement you posted for me on Sunday.
My question is how in the world i got 315 INVALID packages. Obviously, they were NOT INVALID a week ago when i was creating/editing schema objects. What do you think i must of had done to cause this big issue (disaster)?
And are you saying that i have to do:
ALTER PACKAGE PACKAGENAME compile;
for every single 315 packages that are INVALID.
In other words, i have to run the above statement 315 times, one for each one of the PACKAGENAME?
Are there any other ways to get this issue resolved?
Again, thank you so much for your help!
|
|
|
|
| Re: ERROR-06553 [message #4940 is a reply to message #4891] |
Tue, 21 January 2003 14:49 |
mitra fatolahi
Messages: 38
Registered: October 2002
|
Member |
|
|
Robert,
The packages are from 5 different owners!
Owner sys is one of the 5 owners.
I am connected to ORACLE 9i Enterprise Edition Release 9.0.1.1.1 through ORACLE SQL*Plus using one of the owners in the list i got from running the statement you posted:
select distinct owner from dba_objects where status = 'INVALID';
Then I typed the next statment you had posted:
exec dbms_utility.compile_schema('USERNAME');
I noticed after i clicked Enter, SQL*PLUS added this line of code:
BEGIN dbms_utility.compile_schema('USERNAME');END:
And then gave me the same ERROR MESSAGE:
ORA-06553: PLS-213: package STANDARD not accessible
Mitra
|
|
|
|
| Re: ERROR-06553 [message #4942 is a reply to message #4891] |
Tue, 21 January 2003 15:38 |
mitra fatolahi
Messages: 38
Registered: October 2002
|
Member |
|
|
Robert,
I seem to be having one problem after another.
I can connect to the ORACLE database using ORACLE Enterprise Manager Console Standalone using the following Username:
username: sys
password: *******
AS sysdba
But i can not connect to the same ORACLE database using the same username and password using the ORACLE SQL*PLUS.
I entered the following statement at the SQL command prompt:
SQL> connect as sysdba
Enter User-name: sys
Enter password: *******
SQL*PLUS gave me the following ERROR:
ORA-12560: TNS: protocol adapter error
Why?
My OracleOraHome90TNSLISTENER service is running other wise i could not have connected thru ORACLE EM.
Please help me out!
Thank you very much for all your help!
Mitra
|
|
|
|
| Re: ERROR-06553 [message #4948 is a reply to message #4891] |
Wed, 22 January 2003 02:23 |
Joyjeet
Messages: 23
Registered: January 2003
|
Junior Member |
|
|
Then yr first attempt should be to connect Oracle with sys as dba.
Since y are getting protocol adapter ERROR, check whether OCA in installed in the server m/c or not.
U should also check out the tnsnames.ora in yr client m/c and server.
Good luck...
JD.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
