RMAN failed

From: Jovan Sarai <jsarai_at_tpg.au.com>
Date: Fri, 31 Mar 2000 10:11:11 +1000
Message-ID: <g2SE4.57$3X3.3276_at_nsw.nnrp.telstra.net>

Hi,
my target and recovery catalog databases are on Oracle 8.0.5 on Solaris 5.6.
Ocassionally when I am trying to execute some of the stored scripts RMAN fails with the following error:

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=26 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-00569: ================error message stack follows================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-07001: could not open channel d2
RMAN-10008: could not create channel context

RMAN-10024: error setting up for rpc polling RMAN-10006: error running sql statement: select distinct my.sid, sex.serial from v$mystat my, x$ksusex sex where sex.sid = my.sid RMAN-10002: ORACLE error: ORA-01455: converting column overflows integer datatype

The thing is that there is no overlfows or something similar (as I can see). The main problem is in allocation of the necessary number of channels. Sometimes this script succeds after allocation of 3 channels, sometimes it failes to allocate 3rd, sometimes (as here) fails to allocate 2nd. At the very first instance, there were six channels and everything was working fine (?!).
I was thinking that it could be problem with allocation of memory resources but I couldn't find any configuration parameter in documentation to change.

Can anyone have some fresh ideas?

Thanks,
Jovan Received on Fri Mar 31 2000 - 02:11:11 CEST