| RMAN - Error [message #333457] |
Fri, 11 July 2008 13:15  |
marcossantos
Messages: 42
Registered: June 2008 |
Member |
|
|
Hi,
for all commands I get this error in RMAN. For examplo:
RMAN>reset database;
starting full resync of recovery catalog
RMAN-00571: ==========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of reset command at 07/10/2008 08:09:15
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 07/10/2008 08:09:15
ORA-00001: unique constraint (RMAN_USER.TS_P) violated
Anybody can help me?
Marcos Santos
|
|
|
|
| Re: RMAN - Error [message #333461 is a reply to message #333457 ] |
Fri, 11 July 2008 13:35  |
Michel Cadot
Messages: 18894
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
There are several known bugs around this in 10g.
The most likely in your case is Bug 4754328, explained in Metalink note 345159.1.
Regards
Michel
|
|
|
| Re: RMAN - Error [message #333469 is a reply to message #333461 ] |
Fri, 11 July 2008 15:35 |
ehegagoka
Messages: 363
Registered: July 2005
Location: USA/Philippines |
Senior Member |
|
|
|
hi, this may be a bit off-topic, just want to ask, is it illegal for other sites to post those "metalink notes"? because i havent seen any metalink notes also being posted even here in orafaq.com.
|
|
|
|
| Re: RMAN - Error [message #333471 is a reply to message #333469 ] |
Fri, 11 July 2008 15:39 |
anacedent
Messages: 6777
Registered: July 2005
Location: surf meets turf in SoCal |
Senior Member |
|
|
| ehegagoka wrote on Fri, 11 July 2008 13:35 | hi, this may be a bit off-topic, just want to ask, is it illegal for other sites to post those "metalink notes"? because i havent seen any metalink notes also being posted even here in orafaq.com.
|
Yes posting them violates the support contract with Oracle.
The Notes: are copyrighted by Oracle.
|
|
|
| Re: RMAN - Error [message #333479 is a reply to message #333471 ] |
Fri, 11 July 2008 18:17 |
ehegagoka
Messages: 363
Registered: July 2005
Location: USA/Philippines |
Senior Member |
|
|
|
thank you very much. i wonder why some companies that use oracle don't have metalink accounts =(
[Updated on: Fri, 11 July 2008 18:18]
|
|
|
| Re: RMAN - Error [message #333480 is a reply to message #333479 ] |
Fri, 11 July 2008 18:22 |
anacedent
Messages: 6777
Registered: July 2005
Location: surf meets turf in SoCal |
Senior Member |
|
|
| ehegagoka wrote on Fri, 11 July 2008 16:17 | thank you very much. i wonder why some companies that use oracle don't have metalink accounts =(
|
The support contract with Oracle cost money on top of s/w license fee.
I suspect that the Oracle s/w may not be (properly?) licensed.
|
|
|
| Re: RMAN - Error [message #333544 is a reply to message #333480 ] |
Sat, 12 July 2008 08:29 |
ehegagoka
Messages: 363
Registered: July 2005
Location: USA/Philippines |
Senior Member |
|
|
|
hi, thanks again. do you mean that when you buy "oracle database" you first pay for the "software/installer" then you have to pay for those metalink login accounts?
|
|
|
| Re: RMAN - Error [message #333552 is a reply to message #333544 ] |
Sat, 12 July 2008 10:05 |
Michel Cadot
Messages: 18894
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
You don't pay for software if you don't use it in production (for instance development, education...).
You don't have to pay for software in any case if you use XE (in the limit of the license).
You have to pay to get support which includes Metalink access.
Regards
Michel
|
|
|
| Re: RMAN - Error [message #333786 is a reply to message #333457 ] |
Mon, 14 July 2008 07:54 |
marcossantos
Messages: 42
Registered: June 2008 |
Member |
|
|
Hi,
I decide apply patch set 10.2.0.3 in my Oracle Database, but I have a question: Patch sets are cumulative? If I install 10.2.0.3, its fixes all bugs for 10.2.0.2?
Marcos Santos
|
|
|
|
| Re: RMAN - Error [message #333830 is a reply to message #333786 ] |
Mon, 14 July 2008 09:24 |
Michel Cadot
Messages: 18894
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
This is what is said in the readme file you got with patchset.
Regards
Michel
|
|
|
| Re: RMAN - Error [message #334152 is a reply to message #333457 ] |
Tue, 15 July 2008 09:50 |
marcossantos
Messages: 42
Registered: June 2008 |
Member |
|
|
Hi,
I am installing patch set 10.2.0.3 and after install, I connect with "sqlplus sys/pass as sysdba" and execute the script $?db_1/rdbms/admin/catupgrd.sql. I get error:
The following statement will cause an "ORA-01722: invalid number"
error if the user running this script is not SYS. Disconnect
and reconnect with AS SYSDBA.
and not complete upgrade.
Thanks,
Marcos
|
|
|
|
| Re: RMAN - Error [message #334164 is a reply to message #333457 ] |
Tue, 15 July 2008 10:36 |
marcossantos
Messages: 42
Registered: June 2008 |
Member |
|
|
Hi,
not is error. This messages of script. But, its stop in this point:
SQL> grant select on user_repgrouped_column to public with grant option
2 /
Grant succeeded.
SQL>
SQL> -- This view is for internal use only and may change without notice.
SQL> REM For the remote acess of POS in repcat$_grouped_column,
SQL> REM "_ALL_REPGROUPED_COLUMN" is added.
SQL> REM This view is for internal use only and may change without notice.
SQL> create or replace view "_ALL_REPGROUPED_COLUMN"
2 (
3 sname, oname, group_name, column_name, pos
4 )
5 as
6 select
7 gc.sname, gc.oname, gc.group_name,
8 gc.column_name,
9 gc.pos
10 from all_tab_columns tc, system.repcat$_grouped_column gc
11 where gc.sname = tc.owner
12 and gc.oname = tc.table_name
13 and (gc.column_name = tc.column_name OR
14 (gc.column_name = 'SYS_NC_OID$' AND
15 -- sOID column
16 exists (select 1 from system.repcat$_repcolumn rc
17 where rc.sname = gc.sname
18 and rc.oname = gc.oname
19 and rc.cname = 'SYS_NC_OID$'
20 and utl_raw.bit_and(utl_raw.substr(rc.property, 1, 1),
21 '10') = '10')))
22 union
23 select
24 gc.sname, gc.oname, gc.group_name,
25 gc.column_name,
26 gc.pos
27 from "_ALL_REPL_NESTED_TABLE_NAMES" nt, system.repcat$_grouped_column gc
28 where gc.sname = nt.owner
29 and gc.oname = nt.table_name
30 /
thanks,
Marcos
|
|
|
|
]
Members
Search
Help
Register
Login
Home
