Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00000 error during upgration

790945May 7 2011 — edited May 10 2011

I want to upgrade 11.1.0.6.0 to 11gR2.

After the installation of 11gR2.
1.I startup 11.1.0.6.0 database,run preupgrade script, and shutdown 11.1.0.6.0 database.

All steps before this are normal.

2.I get "connected" information when I "sqlplus / as sysdba" to 11gR2(I haven't started up any database,and there is no oracle process in "ps -ef").
3. I get "ORA-00000 normal, successful completion" information if I try to "startup upgrade"(Here, the "ipcs" shows shared memory has been allocated). After that, I always get "ORA-01012: not logged on" for other sql queries.

There are not any related information in alert log.

Has anyone hit this issue before and give me some advice?

Thanks,
Candy

Edited by: Candy.Liu on May 6, 2011 11:17 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2011

Added on May 7 2011

#database-upgrade, #upgrade

8 comments

822 views