RE: Upgrade 11g to 12c - recyclebin
Date: Fri, 28 Aug 2015 10:45:29 -0700 (PDT)
Message-ID: <b49830fc-95e4-4f13-9228-96d1c20ff20c_at_default>
Oh well, always best to get the easy answer out first. J
What do you get from a SELECT * FROM RECYCLEBIN?
Pete
Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA
Phone: HYPERLINK "tel:+61262924095"+61262924095 | | Fax: HYPERLINK "fax:+61262925183"+61262925183 | | Mobile: +61414443449 Email: HYPERLINK "mailto:pete.sharman_at_oracle.com"pete.sharman_at_oracle.com Twitter: @SharmanPete LinkedIn: au.linkedin.com/in/petesharman Website: petewhodidnottweet.com
_____
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not, it's much harder than that!"
Bruce Pihlamae, long term Oracle DBA
_____
From: Sandra Becker [mailto:sbecker6925_at_gmail.com]
Sent: Saturday, August 29, 2015 3:33 AM
To: Peter Sharman <pete.sharman_at_oracle.com>
Cc: oracle-l <oracle-l_at_freelists.org>
Subject: Re: Upgrade 11g to 12c - recyclebin
I was logged in as sys and did "purge recyclebin". I also did "purge dba_recyclebin".
Sandy
On Fri, Aug 28, 2015 at 11:15 AM, Peter Sharman <HYPERLINK "mailto:pete.sharman_at_oracle.com"pete.sharman_at_oracle.com> wrote:
Did you purge recyclebin (i.e. for the user) or purge dba_recyclebin?
Pete
Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA
Phone: HYPERLINK "tel:+61262924095"+61262924095 | | Fax: +61262925183 | | Mobile: HYPERLINK "tel:%2B61414443449"+61414443449 Email: HYPERLINK "mailto:pete.sharman_at_oracle.com"pete.sharman_at_oracle.com Twitter: _at_SharmanPete LinkedIn: HYPERLINK "http://au.linkedin.com/in/"au.linkedin.com/in/petesharman Website: HYPERLINK "http://petewhodidnottweet.com"petewhodidnottweet.com
_____
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not, it's much harder than that!"
Bruce Pihlamae, long term Oracle DBA
_____
From: Sandra Becker [mailto:HYPERLINK "mailto:sbecker6925_at_gmail.com"sbecker6925_at_gmail.com]
Sent: Saturday, August 29, 2015 3:12 AM
To: oracle-l <HYPERLINK "mailto:oracle-l_at_freelists.org"oracle-l_at_freelists.org>
Subject: Upgrade 11g to 12c - recyclebin
I can't get logged into MOS right now, so I'm posting my questions here. I am preparing to upgrade an 11.2.0.4 database to 12.1.0.2. The preupgrd.sql script returned the following error:
ERROR: --> RECYCLE_BIN not empty.
Your recycle bin contains 64 object(s). It is REQUIRED that the recycle bin is empty prior to upgrading. Immediately before performing the upgrade, execute the following command: EXECUTE dbms_preup.purge_recyclebin_fixup;
When I select a count from the recyclebin or dba_recyclebin, it returns 0. I went ahead and executed the statement. I then reran the preupgrd.sql script. It showed the same error. I ran the preupgrade_fixups.sql script and reran the preupgrd.sql script. It still shows the same error. The executions to purge the recyclebin said they were successful.
What am I missing? Do I really need to rerun the preupgrd.sql script? Am I looking in the wrong place for the count? This is the only error I had for this database.
-- Sandy GHX -- Sandy GHX -- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 28 2015 - 19:45:29 CEST