-
PL/SQL re-installation
Something happen few days ago which i dont want reveal and some of the views and packages become invalid, so i tried to reinstall PL/SQL.
Before reinstalling what is my mistake is to delete all the packages
and types including the Standard package.
Now iam trying to reinstall PL/SQL, but i got following errors.
Please help me out.
The following are the series of steps i followed for reinstallation
SQL> @\\Ed10\c_oracle\ora92\rdbms\admin\catalog.sql
create or replace
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.CDC_CREATE_CTABLE_BEFORE
ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
ORA-06553: PLS-213: package STANDARD not accessible
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
"after the above error i added the following parameter in init.ora file
_system_trig_enabled=false
and rerun the script"
SQL> startup pfile="C:\Documents and Settings\Administrator\Desktop\init.ora"
ORACLE instance started.
Total System Global Area 655433488 bytes
Fixed Size 454416 bytes
Variable Size 603979776 bytes
Database Buffers 50331648 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> @\\Ed10\c_oracle\ora92\rdbms\admin\catalog.sql
create or replace
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
create or replace
*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible
The database is running know but for only queries and DML statements but
I cant able to run PL/SQL stuff.
I can't even able to export the data.
-
May I ask why you set _system_trig_enabled=false? That is onlyused when you are upgrading or downgrading
-
to disable any triggers which are raised during creation of oracle objects in the database
-
And that´s what you think or you have been told...? Or read from somewhere :-?
-
I have read on internet.
If u knw wat to do,specify that...dont ask cross questions plz
-
Originally Posted by tabreaz
I have read on internet.
If u knw wat to do,specify that...dont ask cross questions plz
First things first... do not get offended when some one is asking you question. They are trying to help you here and trying to understand why you are doing what you are doing. They do not know what situation you are in and the cannot understand the gravity of the problem. So without understanding your problem they cannot simply say run this and see, run that and see.
Be polite to someone who is trying to help you...
And run catproc.sql not catalog.sql to get back all the procedures and packages. Catalog creates the data dictionary. Catproc creates all structures required for PL/SQL.
HTH
Amar
"There is a difference between knowing the path and walking the path."
-
Thanks for all the replies from everyone,
Its a test server but there is a strange error,
even there is a
create or replace package
statement in the stdspec.sql
why is not considering as any other packages.
the create or replace statement must replace the existing one if exist or create the package.
but why it is giving an error as it is already in use???
is there any script exist for clearing the total database,
including the base tables and recreate them???
-
show us
select * from dba_objects where object_name = 'STANDARD'
-
and dont set that system trigger to FALSE, you are not upgrading/patching arent you?
-
Thanks pando for ur reply,
There are only two packages available in the sys schema
they are
DBMS_CDC_SUBSCRIBE (With Package Body)
SYS_STUB_FOR_PURITY_ANALYSIS(It does not have package body)
What are CDC Tables; i mean wat are there usage?
when am removing this parameter from init.ora file, iam getting following error; and it is not allowing me to create any objects
SQL> @\\Ed10\c_oracle\ora92\rdbms\admin\catalog.sql
create or replace
*
0ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.CDC_CREATE_CTABLE_BEFORE
ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
ORA-06553: PLS-213: package STANDARD not accessible
what i hope is SYS.CDC_CREATE_CTABLE_BEFORE will log some information regarding the objects created in the database, and by disabling that system trigger we can create the objects without any problem(it is purly my guess) which is true.
Last edited by tabreaz; 09-08-2005 at 03:42 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|