connect target results in rman-07001

From: <bikle_at_my-deja.com>
Date: Wed, 18 Aug 1999 23:48:41 GMT
Message-ID: <7pfgom$pst$1@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?

-Dan Bikle

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 18 1999 - 18:48:41 CDT