FW: Upgrade 11g to 12c - recyclebin

From: Peter Sharman <pete.sharman_at_oracle.com>
Date: Fri, 28 Aug 2015 13:11:33 -0700 (PDT)
Message-ID: <0c2f69ab-d4e1-4396-b263-56c730415529_at_default>

Just for the sake of completion, copying the list back in.

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 5:15 AM
To: Peter Sharman <pete.sharman_at_oracle.com> Subject: Re: Upgrade 11g to 12c - recyclebin

Re-ran the preupgrd.sql script and the error is gone. Thanks for pointing me in the right direction.

On Fri, Aug 28, 2015 at 1:01 PM, Peter Sharman <HYPERLINK "mailto:pete.sharman_at_oracle.com"pete.sharman_at_oracle.com> wrote:

OK, dunno why that would take time unless they were really big objects. In any case, retry the upgrade script and see what happens now.

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 4:57 AM
To: Peter Sharman <HYPERLINK "mailto:pete.sharman_at_oracle.com"pete.sharman_at_oracle.com>

Subject: Re: Upgrade 11g to 12c - recyclebin

It's not showing anything now from that select.

Sandy

On Fri, Aug 28, 2015 at 12:29 PM, Peter Sharman <HYPERLINK "mailto:pete.sharman_at_oracle.com"pete.sharman_at_oracle.com> wrote:

What does this show you in your environment (output from mine as an example)?

SQL> show user

USER is "SYS"

SQL> select obj#, owner#, original_name from recyclebin$;

OBJ# OWNER# ORIGINAL_NAME

---------- ------------------------------

91994 0 WRI$_RCS_19_1

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 "tel:%2B61262925183"+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 4:11 AM
To: Lyall personal <HYPERLINK "mailto:lyallbarbour_at_sanfranmail.com"lyallbarbour_at_sanfranmail.com> Cc: Peter Sharman <HYPERLINK "mailto:pete.sharman_at_oracle.com"pete.sharman_at_oracle.com>; oracle-l <HYPERLINK "mailto:oracle-l_at_freelists.org"oracle-l_at_freelists.org>

Subject: Re: Upgrade 11g to 12c - recyclebin

sys=> select * from recyclebin;

no rows selected

It's throwing the error from the statement "select count(*) from sys.recyclebin$;'

On Fri, Aug 28, 2015 at 11:53 AM, Lyall personal <HYPERLINK "mailto:lyallbarbour_at_sanfranmail.com"lyallbarbour_at_sanfranmail.com> wrote:

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: HYPERLINK "mailto:sbecker6925_at_gmail.com"sbecker6925_at_gmail.com

Reply To: HYPERLINK "mailto:pete.sharman_at_oracle.com"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

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

_____

"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:33 AM
To: Peter Sharman <HYPERLINK "mailto:pete.sharman_at_oracle.com"pete.sharman_at_oracle.com> Cc: oracle-l <HYPERLINK "mailto:oracle-l_at_freelists.org"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

_____

"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

 




-- 

Sandy
GHX




-- 

Sandy
GHX




-- 

Sandy
GHX


--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 28 2015 - 22:11:33 CEST

This message: [ Message body ]
Next message: Cee Pee: "index on null"
Previous message: Andrew Kerber: "Re: Monitoring emails"
Maybe in reply to: Sandra Becker: "Upgrade 11g to 12c - recyclebin"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message