Unfortunately, the installer or more specifically the root.sh script for the Oracle 11g grid (Clusterware) installer can be very flaky. If it fails and you need to fix something or rerun it for any reason, it will fail the next time if you have not cleaned up the install by de-configuring CRS. I also …
You can directly upgrade an Oracle database from version 9.2.0.4 or higher, directly to 11g Upgrade Process. Open database in Upgrade mode: startup upgrade Pre-Upgrade information tool: utlu111i.sql Precursor to the upgrade. Generated report on required and recommended changes to make.. Generally increasing tablespace sizes or remove parameters. Upgrade script: …
In much the same way as with the Undo tablespace, you may want to reduce the size of the Temp tablespace in Oracle to reclaim space. 11g —- ALTER TABLESPACE [tbsp_name] SHRINK SPACE KEEP 30M; 10g and earlier —————— Unfortunatly, if the temp tablespace is full (as will be the case if it has …
There is no function in Oracle (up to 11g currently) that will allow you to reduce the size of the undo tablespace. Sometimes you will need to free up space and the best way to get it will be to reduce the size of the undo tablespace. The way to do this is basically to …