cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle upgrade

Former Member
0 Kudos

Hi ,

     When i try to upgrade oracle from 10.2.0.4 to 11g using DBUA.I'm the getting the below error

" ORA-04023 - Object sys.standard could not be validated or authorized ".

I'm unable to ignore the error also.

I've run the pre-requisite scripts and compiled the invalid objects also before running DBUA.

But still issue is there.

I've attached the screenshot also of that error message.

Regards

Yugandhar

Accepted Solutions (1)

Accepted Solutions (1)

former_member206552
Active Contributor
0 Kudos

Hi Yungandhar

You need to run this script while using the 10g binaries. See http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/upgrade.htm#UPGRD12395

Best Regards

Marius

Answers (1)

Answers (1)

former_member182034
Active Contributor
0 Kudos

hi Yugandhar,

Please check the following solution.

(During Upgrade Of Database : ORA-04023: Object SYS.STANDARD Could Not Be Validated Or Authorized [ID 1343500.1])

Symptoms:
When attempting to STARTUP UPGRADE, the following error occurs:

ERROR
———————–
ORA-04023: Object SYS.STANDARD could not be validated or authorized

The above error is seen as soon as STARTUP UPGRADE is executed and SYS connections are established through other terminals.

Cause:
SQLPATH defined in the environment when it should not be.

Once the SQLPATH was removed the upgrade completed successfully.

Solution:
1. Remove/unset the SQLPATH environmental variable.
2. Proceed with the upgrade of the database.

Regards,