on 07-12-2013 6:27 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.