From Oracle 8.1.5 to 8.1.6 after Upgrading Problem

[rameshgiri26]

SQL*Plus: Release 8.1.6.0.0 - Production on Mon May 7 18:59:20 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

ERROR:
ORA-06553: PLS-908: The stored format of SYS.STANDARD is not supported by this
release


Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06553: PLS-908: The stored format of SYS.STANDARD is not supported by this
release



Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SQL>

----------------------------------

This Error is displaying and While Creating types This error is displaying


SQL> create type my_ctx_feedback_type
2 is
3 table of my_ctx_feedback_item_type;
4 /
create type my_ctx_feedback_type
*
ERROR at line 1:
ORA-06541: PL/SQL: compilation error - compilation aborted
ORA-06553: PLS-908: The stored format of SYS.STANDARD is not supported by this release

and in V$OPTION,

Java = FALSE
Paralel Server = FALSE


Please give me a sugession.

[sambavan]

After the upgrade, did you run the cat*.sql scripts? Probably you would have forgot to run them. Check the upgrade manual for detail.

Sam

[dknight]

This is the fourth time I have posted this in the last 10 days. I think Oracle's docs are incomplete.

----------------------------------------------------------------------

I had a related problem a few days ago. It may be related to the installation.

Try this:

1. run catalog.sql in $ORACLE_HOME/rdbms/admin
2. run dbmsstdx.sql in $ORACLE_HOME/rdbms/admin
3. run catproc.sql in $ORACLE_HOME/rdbms/admin

I found that running only catalog and catproc did not successfully create and compile the DBMS_STANDARD package.

You can view DBA_OBJECTS with owner='SYS' and object_type = 'PACKAGE' to see if the packages are valid.

Good luck

[rameshgiri26]

Originally posted by dknight
This is the fourth time I have posted this in the last 10 days. I think Oracle's docs are incomplete.

----------------------------------------------------------------------

I had a related problem a few days ago. It may be related to the installation.

Try this:

1. run catalog.sql in $ORACLE_HOME/rdbms/admin
2. run dbmsstdx.sql in $ORACLE_HOME/rdbms/admin
3. run catproc.sql in $ORACLE_HOME/rdbms/admin

I found that running only catalog and catproc did not successfully create and compile the DBMS_STANDARD package.

You can view DBA_OBJECTS with owner='SYS' and object_type = 'PACKAGE' to see if the packages are valid.

Good luck

while running catproc.sql the error is

create or replace function client_ip_address
*
ERROR at line 1:
ORA-06554: package DBMS_STANDARD must be created before using PL/SQL

[sambavan]

Are you connected as internal? You have to be connected as internal before running these scripts.

svrmgrl
svrmgr> connect internal
svrmgr> @catlog
svrmgr> @catproc

Hope this would help you.

Sam

[sambavan]

Check this posting article 98162.1 From metalink.

Problem Description
-------------------

You are upgrading to 8.1.6 from 8.1.5 either using the Oracle Data Migration
Assistant or manually and the upgrade fails. Now package STANDARD is not valid
and any attempt to rebuild it or using it yields PLS-213: package STANDARD not
accessible. The upgrade logs show errors ORA-604 and ORA-904.

Problem Explanation
-------------------

The upgrade script, u0801050.sql, references another script, i0801050.sql
which should modify the dictionary table sys.argument$ adding a new column,
named pls_type, which is a varchar2(30) column. However, the latter script
is only installed if you select the Migration Utility which should not be
needed as Oracle Data Migration Assistant is what you are using to upgrade
from 8.1.5 to 8.1.6. The Migration Utility is only needed to upgrade from
7.3.4 databases.

Solution Description
--------------------

Either install the Migration Utility (which you WILL NOT use).

or

Make sure the size of the pls_type column is appropriate by checking
the $ORACLE_HOME/rdbms/admin/sql.bsq script of your 8.1.6 distribution
where it creates the argument$ table; you should see size tags such
as M_IDEN and M_XDBI. In 8.1.6, pls_type should be a varchar2("M_IDEN"),
which means a size of 30.

Using your favorite text editor, create a file named i0801050.sql in
$ORACLE_HOME/rdbms/admin and insert the following instruction:

alter table argument$ add pls_type varchar2(30); -- 30 = M_IDEN

Now rerun your upgrade procedure and it should complete without errors.

Explanation
-----------
The i0801050.sql is not installed unless you install the Migration
Utility, even though it is required when upgrading the database
manually. So, you must go back and install the Migration Utility.
.



Curtesy to metalink,

Sam

[rameshgiri26]

Every Thing is ok What you mentioned SQL also ok the same thing is there in that sql files i am not modified that sql files

Because What you are mentioned modification's It is already is there in that SQL...

And i am re executed that sql then also the same problem


Actuall i am unable to list User_objects table also Know after Executing SQL.bsq and i0801050.sql i can see the table Thanx,

But still The problem is there



SQL*Plus: Release 8.1.6.0.0 - Production on Tue May 8 11:38:33 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

ERROR:
ORA-06553: PLS-908: The stored format of SYS.STANDARD is not supported by this
release


Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06553: PLS-908: The stored format of SYS.STANDARD is not supported by this
release



Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SQL>