Re: Upgrade 11g to 12c - recyclebin

From: Lyall personal <lyallbarbour_at_sanfranmail.com>
Date: Fri, 28 Aug 2015 13:53:19 -0400
Message-ID: <20150828175319.5492817.84442.32020_at_sanfranmail.com>

                                                                                      
Also, u should be able to look into the 12c upgrade script to see how it gets that error

Sent from my BlackBerry 10 smartphone.
From: Peter Sharman
Sent: Friday, August 28, 2015 1:47 PM
To: sbecker6925_at_gmail.com
Reply To: pete.sharman_at_oracle.com
Cc: oracle-l
Subject: RE: Upgrade 11g to 12c - recyclebin

Oh well, always best to get the easy answer out first. J

 

What do you get from a SELECT * FROM RECYCLEBIN?

 

Pete

Oracle logo

Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA

Phone: +61262924095 | | Fax: +61262925183 | | Mobile: +61414443449 
Email: pete.sharman_at_oracle.com  Twitter: _at_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 <pete.sharman@oracle.com> wrote:

Did you purge recyclebin (i.e. for the user) or purge dba_recyclebin?

 

Pete

Oracle logo

Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA

Phone: +61262924095 | | Fax: +61262925183 | | Mobile: +61414443449 
Email: pete.sharman_at_oracle.com  Twitter: _at_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:12 AM
To: oracle-l <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-l


image001.jpg
Received on Fri Aug 28 2015 - 19:53:19 CEST

Original text of this message