Re: connect target results in rman-07001

bikle_at_my-deja.com wrote in message <7pfgom$pst$1_at_nnrp1.deja.com>...
>Hi
>
>I started tinkering with Recovery Manager
>(oracle 8.0.5 on solaris 2.6)
>
>According to the documentation I may issue this shell command:
>
>rman nocatalog
>
>which puts me in the rman command line interface
>
>I did so and then tried this rman command:
>
>connect target
>
>I then encountered a problem; here is a screen dump:
>
>oooooooooooooooooooooooooooooooooooooooooooooooooooooo
>bikle.com-csh-8 % rman nocatalog
>
>Recovery Manager: Release 8.0.5.0.0 - Production
>RMAN-06009: using target database controlfile instead of recovery
>catalog
>
>RMAN> connect target
>
>RMAN-06005: connected to target database: BIKLE
>RMAN-00569: ================error message stack follows================
>RMAN-07001: could not open channel default
>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
>
>RMAN> exit
>oooooooooooooooooooooooooooooooooooooooooooooooooooooo
>
>Eventually the problem went away & I was able to connect with
>no problem... mysterious
>
>I did find another post like this from a guy running 8.0.4 on NT
>
>He seemed suspicious of replication
>
>I checked dba_jobs to see if replication is running on my database
>and found no rows in dba_jobs
>
>Also I checked ps -ef to see if anyone else was running rman;
>I did not see anyone.
>
>Anyone out there in oracle land run into this problem?
>

Its a known Oracle bug - 666637 - fixed at 8.0.6 - no fix available for earlier versions

Sometimes it's there every day - sometimes not !!

Alex Received on Thu Aug 19 1999 - 02:51:38 CDT