Home » RDBMS Server » Backup & Recovery » RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 (Oracle 11.2.0.3.0, linux 2.6)
RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627147] Fri, 07 November 2014 21:42 Go to next message
oracle11
Messages: 29
Registered: October 2014
Location: India
Junior Member
Hi,

When running database backup found following error.
released channel: disk4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "CATLG_30.DBMS_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package "CATLG_30.DBMS_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "CATLG_30.DBMS_PKG"

I dont find the package in the database.Could that be reason for this ORA error ?Could you clarify ?
SQL> select owner,object_name,object_type from dba_objects where object_name='DBMS_PKG' and object_type='PACKAGE';
no rows selected

Regards,
Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627148 is a reply to message #627147] Fri, 07 November 2014 21:44 Go to previous messageGo to next message
BlackSwan
Messages: 26193
Registered: January 2009
Location: SoCal
Senior Member
when was the last time RMAN worked without error?
What changed since then?

>(Oracle 11.2.0.3.0, linux 2.6)
is above a supported combination?
Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627150 is a reply to message #627148] Fri, 07 November 2014 21:53 Go to previous messageGo to next message
oracle11
Messages: 29
Registered: October 2014
Location: India
Junior Member
Hi Blackswan,

Please find my inline answers below.

1.when was the last time RMAN worked without error?
Yesterday it ran success

2.What changed since then?
No changes done as far as i know.

3.>(Oracle 11.2.0.3.0, linux 2.6)
is above a supported combination?
How to find that ?

And there is no invalid objects in the database
SQL> select object_name,status,object_type from dba_objects where status !='VALID';
no rows selected

Regards,

[Updated on: Fri, 07 November 2014 21:58]

Report message to a moderator

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627151 is a reply to message #627150] Fri, 07 November 2014 21:59 Go to previous messageGo to next message
BlackSwan
Messages: 26193
Registered: January 2009
Location: SoCal
Senior Member
Does not exist in my DB either.
[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri Nov 7 19:51:36 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> 
SQL> select owner,object_name,object_type from dba_objects where object_name='DBMS_PKG' and object_type='PACKAGE';

no rows selected



any additional clues in alert_SID.log file?
Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627152 is a reply to message #627151] Fri, 07 November 2014 22:19 Go to previous messageGo to next message
oracle11
Messages: 29
Registered: October 2014
Location: India
Junior Member
Hi Blackswan,

Sorry the package name is CATLG_30.DBMS_RCVCAT. I don't find any information related to this error in the alert log file.

I guess 'CATLG_30'is the username and i dont find this username in the database.
SQL> select username from dba_users where username='CATLG_30';

no rows selected

Regards,

[Updated on: Fri, 07 November 2014 22:21]

Report message to a moderator

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627153 is a reply to message #627152] Fri, 07 November 2014 22:26 Go to previous messageGo to next message
BlackSwan
Messages: 26193
Registered: January 2009
Location: SoCal
Senior Member

  1* select owner,object_name,object_type from dba_objects where object_name='DBMS_RCVCAT'
SQL> /

no rows selected

SQL> select owner, count(*) from dba_objects where owner like 'C%' group by owner order by 1;

OWNER                            COUNT(*)
------------------------------ ----------
CACHEADM                               14
CTXSYS                                382

SQL> 



what exactly are you doing that throws these errors?

[Updated on: Fri, 07 November 2014 22:32]

Report message to a moderator

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627154 is a reply to message #627153] Fri, 07 November 2014 22:34 Go to previous messageGo to next message
oracle11
Messages: 29
Registered: October 2014
Location: India
Junior Member
Hi Blackswan,

<what exactly are you doing that throws these errors?>
While running database backup i found this errors.

I found one note in metalink 1192068.1 related to this error.Its given "To prevent this problem you can either
disable Fast Validation or install the fix for Bug 7284151

To disable fast validation
alter system set "_disable_fast_validate"=TRUE [scope=both]

Regards

[Updated on: Fri, 07 November 2014 22:38]

Report message to a moderator

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627155 is a reply to message #627154] Fri, 07 November 2014 22:39 Go to previous messageGo to next message
oracle11
Messages: 29
Registered: October 2014
Location: India
Junior Member
Hi Blackswan,
SQL> select owner, count(*) from dba_objects where owner like 'C%' group by owner order by 1;

no rows selected


Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627163 is a reply to message #627152] Sat, 08 November 2014 01:15 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Sorry the package name is CATLG_30.DBMS_RCVCAT.


Then how the message in your first post is possible?
Always COPY AND PASTE what you do and get.

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627164 is a reply to message #627154] Sat, 08 November 2014 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I found one note in metalink 1192068.1 related to this error.Its given "To prevent this problem you can either
disable Fast Validation or install the fix for Bug 7284151


This bug is present in 11.1 and fixed in 11.2, version you said you are, so it can't be that.

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627165 is a reply to message #627164] Sat, 08 November 2014 01:28 Go to previous messageGo to next message
oracle11
Messages: 29
Registered: October 2014
Location: India
Junior Member
Hi Michel,
So you don't agree what Oracle support team is suggesting ??

Regards,

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627167 is a reply to message #627147] Sat, 08 November 2014 01:36 Go to previous messageGo to next message
John Watson
Messages: 7618
Registered: January 2010
Location: Global Village
Senior Member
Are you trying to find that package in the target database or the recovery catalog database?
Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627168 is a reply to message #627165] Sat, 08 November 2014 01:43 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I don't agree with your analysis and interpretation of what Oracle support says.
Note says it is for 11.1 and it is fixed in 11.2, you say you are in 11.2, so you can't apply what is in this note.

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627169 is a reply to message #627168] Sat, 08 November 2014 02:25 Go to previous messageGo to next message
oracle11
Messages: 29
Registered: October 2014
Location: India
Junior Member
Hi John,
Quote:
Are you trying to find that package in the target database or the recovery catalog database?

Target database

Hi Michel,
Quote:
Note says it is for 11.1 and it is fixed in 11.2, you say you are in 11.2, so you can't apply what is in this note.

If so , then what is the fix for this error?

Regards,

[Updated on: Sat, 08 November 2014 02:26]

Report message to a moderator

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627170 is a reply to message #627169] Sat, 08 November 2014 02:29 Go to previous messageGo to next message
John Watson
Messages: 7618
Registered: January 2010
Location: Global Village
Senior Member
Think, man! In what database do the RCV objects reside? What do you think will happen if there is problem with the connection to that database during a backup operation?
Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627171 is a reply to message #627170] Sat, 08 November 2014 02:37 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I don't know, open a SR to Oracle and tell us what is the solution.
Of course, you will have to give them much more than what you gave us.

And the first thing will be, as I said, to copy and paste all what you did and got.

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627172 is a reply to message #627170] Sat, 08 November 2014 02:42 Go to previous messageGo to next message
oracle11
Messages: 29
Registered: October 2014
Location: India
Junior Member
Hi John,

RCV objects resides in catalog database.When i query in catalog database i get error.

Server08:DB1:/opt/nokia/backup>rman catalog CATLG_30.DBMS_PKG@CATLG

Recovery Manager: Release 11.2.0.3.0 - Production on Sat Nov 8 10:38:30 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database

RMAN> select * from rc_database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "advise, allocate, alter, backup, @, catalog, change, configure, connect, convert, copy, create, crosscheck, delete, drop, duplicate, exit, flashback, grant, host, import, list, mount, open, print, quit, recover, register, release, repair, replace, report, reset, restore, resync, revoke, run, send, set, show, shutdown, spool, sql, startup, switch, transport, unregister, upgrade, validate, {, "
RMAN-01008: the bad identifier was: select
RMAN-01007: at line 1 column 1 file: standard input

Regards,
Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627173 is a reply to message #627172] Sat, 08 November 2014 03:04 Go to previous messageGo to next message
John Watson
Messages: 7618
Registered: January 2010
Location: Global Village
Senior Member
Now yoou are telling lies. This did not happen:
Server08:DB1:/opt/nokia/backup>rman catalog CATLG_30.DBMS_PKG@CATLG

Recovery Manager: Release 11.2.0.3.0 - Production on Sat Nov 8 10:38:30 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database



--update: corrected tags

[Updated on: Sat, 08 November 2014 03:06]

Report message to a moderator

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627174 is a reply to message #627173] Sat, 08 November 2014 03:36 Go to previous messageGo to next message
oracle11
Messages: 29
Registered: October 2014
Location: India
Junior Member
Hi John,

I did not get you what you are telling.Can you be precise?

Regards

[Updated on: Sat, 08 November 2014 03:37]

Report message to a moderator

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627175 is a reply to message #627174] Sat, 08 November 2014 03:48 Go to previous messageGo to next message
John Watson
Messages: 7618
Registered: January 2010
Location: Global Village
Senior Member
oracle11 wrote on Sat, 08 November 2014 09:36
Hi John,

I did not get you what you are telling.Can you be precise?

Regards
More precise? OK. What you posted pretends to be a copy/paste. It isn't. This could be described as: mendacious; obfuscation; dissembling; or lying. Ehichever term you prefer, you cannot expect help if you do not tell the truth.

By the way, do you really work for Nokia? This might explain their recent disastrous financial performance.
Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627176 is a reply to message #627175] Sat, 08 November 2014 03:55 Go to previous messageGo to next message
oracle11
Messages: 29
Registered: October 2014
Location: India
Junior Member
Hi John,

Whatever the data i provided you is true to my knowledge.If you want to help me else leave it.

Regards,

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627181 is a reply to message #627176] Sat, 08 November 2014 04:29 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
ORA-04065: not executed, altered or dropped package "CATLG_30.DBMS_PKG"

Quote:
Sorry the package name is CATLG_30.DBMS_RCVCAT.


Now it is sure you are lying.


Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627183 is a reply to message #627172] Sat, 08 November 2014 06:11 Go to previous messageGo to next message
EdStevens
Messages: 981
Registered: September 2013
Senior Member
oracle11 wrote on Sat, 08 November 2014 02:42
Hi John,

RCV objects resides in catalog database.When i query in catalog database i get error.

Server08:DB1:/opt/nokia/backup>rman catalog CATLG_30.DBMS_PKG@CATLG

Recovery Manager: Release 11.2.0.3.0 - Production on Sat Nov 8 10:38:30 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database

RMAN> select * from rc_database;

<snip>

Regards,


You don't issue SQL commands from rman. At least not like that. If you want to investigate the catalog database, just connect with sqlplus, just like you would any other database. After all, it IS just another database.
Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627200 is a reply to message #627183] Sat, 08 November 2014 21:11 Go to previous messageGo to next message
oracle11
Messages: 29
Registered: October 2014
Location: India
Junior Member
Hi Stevens,

Yes,i am able to connect catalog database as per your instructions. Thanks
Server08:DB1:/opt/nokia/backup>:SYNC1:/opt/nokia/backup>sqlplus cat11_26/****@CATLG

SQL*Plus: Release 11.2.0.3.0 Production on Sun Nov 9 05:06:20 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
CAT1

Regards,

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627201 is a reply to message #627200] Sat, 08 November 2014 21:17 Go to previous messageGo to next message
oracle11
Messages: 29
Registered: October 2014
Location: India
Junior Member
Hi ,

The package does exist in the catalog database and it is in valid state.
SQL> select OBJECT_NAME,CREATED,TIMESTAMP,STATUS,OBJECT_TYPE from user_objects where OBJECT_TYPE='PACKAGE' and  OBJECT_NAME='DBMS_RCVCAT';

OBJECT_NAME          CREATED            TIMESTAMP           STATUS  OBJECT_TYPE
-------------------- ------------------ ------------------- ------- -------------------
DBMS_RCVCAT          26-JUN-12          2014-11-07:21:25:51 VALID   PACKAGE

I see the package was last modified at below timestamp.Could you tell me how to find out what changes were made on this package
and who has made it?
SQL> select object_name,object_type,to_char(created,'DD-MM-YY HH24:MI:SS')created,to_char(last_ddl_time,'DD-MM-YY HH24:MI:SS')last_ddl from user_objects where object_name='DBMS_RCVCAT';

OBJECT_NAME          OBJECT_TYPE         CREATED           LAST_DDL
-------------------- ------------------- ----------------- -----------------
DBMS_RCVCAT          PACKAGE             26-06-12 10:54:05 07-11-14 21:26:04
DBMS_RCVCAT          PACKAGE BODY        26-06-12 10:54:06 07-11-14 21:25:52

I used user_audit_trail to find out who has made those change in the package in catalog database but it returned no row.
SQL> SELECT username,
       owner,
       obj_name,
       action_name
FROM   user_audit_trail
where OBJ_NAME like'DBMS_RCVCAT'
ORDER BY timestamp;  

no rows selected

Regards,

[Updated on: Sat, 08 November 2014 22:13]

Report message to a moderator

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627203 is a reply to message #627201] Sun, 09 November 2014 01:36 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I used user_audit_trail to find out who has made those change in the package in catalog database but it returned no row.


Is there any audit activated in this database?

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627255 is a reply to message #627164] Mon, 10 November 2014 03:12 Go to previous messageGo to next message
gazzag
Messages: 986
Registered: November 2010
Location: Bristol, UK
Senior Member
OP is on 11.2.0.3
Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627259 is a reply to message #627255] Mon, 10 November 2014 03:53 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And?

Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627261 is a reply to message #627168] Mon, 10 November 2014 04:02 Go to previous messageGo to next message
gazzag
Messages: 986
Registered: November 2010
Location: Bristol, UK
Senior Member
Michel Cadot wrote on Sat, 08 November 2014 07:43

Note says it is for 11.1 and it is fixed in 11.2, you say you are in 11.2, so you can't apply what is in this note.


It may seem a small detail but versioning exists for a reason.
Re: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508 [message #627262 is a reply to message #627261] Mon, 10 November 2014 04:13 Go to previous message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I don't understand your point.

Previous Topic: OS SNAP for Oracle DB in NOARCHIVE LOG MODE.
Next Topic: RMAN connection
Goto Forum:
  


Current Time: Thu Oct 18 17:00:07 CDT 2018