How to find prior versions of rdbms that were installed on a box
From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Sun, 8 May 2011 20:11:36 -0700
Message-ID: <BANLkTimMPcaG6zV4F9RkfVei_s+15XDibA_at_mail.gmail.com>
Hi
If you are at a new client site and let us say they are on 11.1.0.7 but they got there via upgrade paths and not a fresh install of 11g code tree. How do you find out what were the prior versions of Oracle that were used. I could have started with 8.1.7.4 and then upgraded to 9.2.0.6 and then upgraded to 10.2.0.4 and then to 11gR1.
But is there any way to find out that my original code tree base started with 8.1.7.4
Date: Sun, 8 May 2011 20:11:36 -0700
Message-ID: <BANLkTimMPcaG6zV4F9RkfVei_s+15XDibA_at_mail.gmail.com>
Hi
If you are at a new client site and let us say they are on 11.1.0.7 but they got there via upgrade paths and not a fresh install of 11g code tree. How do you find out what were the prior versions of Oracle that were used. I could have started with 8.1.7.4 and then upgraded to 9.2.0.6 and then upgraded to 10.2.0.4 and then to 11gR1.
But is there any way to find out that my original code tree base started with 8.1.7.4
The reason I ask this is, I am migrating a 11.1.0.7 database from Solaris to Linux and there are objects in SYS and MDSYS schema that dont exist on my Linux platform but do exist on Solaris. One of the reasons that this could be possible is , because Solaris had an history of base installs and upgrades but Linux box had a fresh install of 11.1.0.6 and patchsets on top of it. There could be some objects that were created in prior installs and upgrades that are obsolete in later versions but hang around in the schemas (SYS or MDSYS or any other base schemeas). I dont think it matters but I am using datapump to export and import data between platforms.
Thank you
Kumar
-- http://www.freelists.org/webpage/oracle-lReceived on Sun May 08 2011 - 22:11:36 CDT