11g Downgrading a Database

Downgrading a Database You can easily downgrade a database back to the release from which you upgraded it to the Oracle Database 11g release. Here are the steps:

1. Shut down the database and start it up in the downgrade mode.
SQL> startup downgrade
2. Spool the results of the downgrade script.
SQL> spool downgrade.log
3. Execute the downgrade script, called catdwgrd.sql.
SQL> @catdwgrd.sql
4. After the catdwgrd.sql script finished executing, shut down the database
cleanly.
SQL> shutdown immediate5. Start up the database in the upgrade mode, from the pre-upgrade ORACLE_
HOME environment.
SQL> startup upgrade
6. Reload the old PL/SQL packages and data dictionary views.
SQL> @catrelod.sql
7. After the reloading of the old packages and views, shut down the database
and restart it.
SQL> shutdown immediate
SQL> startup
8. Run the utlrp.sql script to recompile any packages, procedures, and types that
became invalid during the downgrading of the database.
SQL> @utlrp.sql
This completes the downgrading process. You can run the utlrp.sql script may times. and you should make sure that you handle all invalid objects.

Comments

Post a Comment

Popular posts from this blog

OCM 11g -Finally complete

Hello everybody.... Many thanks to god....... finally my OCM exam result is out and I got a mail ..and I have successfully cleared the Oracle Certified Master exam and I have been awarded OCM status by Oracle Corp.....It was the most awaited email which i got couple of hours back................Cheers !!!
Read more

First Step : Oracle DBA

First Step towards Oracle DBA: My thoughts: I think a learner DBA should not jump on the Oracle database,sql,plsql to start with. It will be really nice to understand the basics of RDBMS: (May be learnig in parallel, But donot avoid Learning database design concpets) To learn DBA from very basics you must understand the database design. Learn RDBMS concepts. Learn Normalization Relations Between Tables Best Practices in Database Design Try to Create Few tables based on some data, Normalization is an important step in database design, as it minimizes the redundancy in information. If required level of Normalization is not achieved , It will not be a good database design. If redundancy is not eliminated then more space is required to store the data. Which is not a good database design. You can google normalization and you will get lot of pages so i am not describing here. You can read from the website http://www.dbnormalization.com/ The key here is that you sh...
Read more

List of Third party softwares for Oracle applications. (third party bolt-ons to Apps)

I have compiled a list of commonly use (Obviously -not all) 3rd party softwares with Oracle applications. These products extend the capabilities of Oracle applications. as an Oracle Apps DBA you may need to work with these software vendors and Sometime you may also need to configure these softwares with Oracle applications. Fortunately i have worked on all of these in the past. 1. AventX The AventX Oracle Connector (hereafter referred to as AventX Connector) provides the capability to deliver reports via fax, email or printer. AventX Connector processes documents from Oracle E-business suite (hereafter referred to as Oracle Applications or OA) and submits them to the document delivery system for delivery AventX Connector uses a set of tables in the Oracle database to store site-specific configuration options and document delivery information. In addition, AventX Connector requires the compilation, installation, and registration of customized forms and library files. http://www....
Read more