I'm trying to migrate my Oracle XE database to Standard. I have Standard 10.2.0.1 and the instructions say they it needs to be 10.2.0.3 before this can be done. So I downloaded the upgrade "patch" (which is larger than the Standard install package). Once I downloaded it, I found that one of the prerequisites for this patch is another patch. So I downloaded that patch, only to find that it has a patch prerequisite also - opatch needs upgrading.
Cue one of those 60's rotating spiral patterns in conjunction with paranoid sound effects...
How difficult would it be to create a one-shot 10.2.0.3 install? I wouldn't mind having to reboot half way through, honest...
One of the patches required disabling of the Distributed Transaction Coordinator. If you don't restart it, you won't be able to do things like connect / as sysdba.
If you can't get restarted with Sqlplus as per instructions, you'll want to get on to the Enterprise Manager site. But you won't be able to without setting up "logon as a batch job" rights for your windows user.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment