Re: Recovery Manager - Can't connect to target

Yes, but I never tried that password. But that doesn't explain:

1. Why system/manager doesn't work
2. Why it works in one direction and not the other.

I can't try it right now, I'm catching a plane. I'll try all suggestions when I return on Mon.

Thanks
Jay

--

Jay Strauss
jstrauss_at_bazillion.com
(h) 773.935.5326
(c) 312.617.0264

"holders" <holders_at_demon.co.uk> wrote in message
news:39E56BB3.D3917A68_at_demon.co.uk...


> Have you executed the ORAPWD command file to create a password file ?

>

> Jay Strauss wrote:

>

> > I can't seem to figure this out.

> >

> > I have 2 - 8.1.6 instances (ORCL, RMAN) one machine.  I can connect to

 both


> > over my network (so no network probs).  RMAN has only one user - RMAN,

> > outside of sys and system, and in the RMAN schema I've installed the

> > recovery catalog.

> >

> > The ORCL instance is my regular development instance.

> >

> > When ORACLE_SID = ORCL

> >

> > I can:

> > # rman

> > RMAN> connect target /

> > RMAN> connect catalog rman/rman_at_rman

> >

> > When ORACLE_SID = RMAN

> > I can:

> > # rman

> > RMAN> connect catalog /

> > or

> > RMAN> connect catalog rman/rman_at_rman

> >

> > But when I

> > RMAN> connect target sys/sys_at_orcl

> >

> > RMAN-00571: ===========================================================

> > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

> > RMAN-00571: ===========================================================

> > RMAN-04005: error from target database: ORA-01017: invalid

> > username/password; logon denied

> >

> > or

> >

> > RMAN> connect target system/manager_at_orcl

> >

> > RMAN-00571: ===========================================================

> > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

> > RMAN-00571: ===========================================================

> > RMAN-04005: error from target database: ORA-01031: insufficient

> > privileges

> >

> > What gives???

> >

> > And if anyone could suggest som recovery manager reading (I've read the

> > recovery manager users guide - but it ain't too good)

> >

> > Thanks

> > Jay

>