Re: rman connect (remote_login_passwordfile=exclusive)

Well, first: you can't just suddenly pretend you're not using a password file, if that's your normal method of authenticating as a Privileged User. You can dispense with the password file only if you've implemented O/S authentication (by setting up the appropriate O/S groups and establishing appropriate o/s user memberships)

Secondly: the example I gave you wouldn't have touched a password file in a million years. SYSTEM is not a privileged User, and is therefore authenticated (as are 99.99% of other Users) via the data dictionary. So if you were trying to log on as SYSTEM and got an invalid logon message, it means you typed the wrong password for SYSTEM.

What is the exact configuration you are using, what are the exact O/S and Oracle versions, what is the connect string you are typing, and what is the exact sequence of error messages you're getting. Let me have all of those, and I can certainly work through this one with you.

Regards
HJR

--
---------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
---------------------------------------------------------------------------


<tedchyn_at_yahoo.com> wrote in message news:8v3lbv$mj0$1_at_nnrp1.deja.com...


> howard,  I got invalid username/password, after commenting out

> remote_login_passwordfile. any clues ?

>

> ted chyn

> In article <3a148e4b_at_news.iprimus.com.au>,

>   "Howard J. Rogers" <howardjr_at_www.com> wrote:

> > I haven't tested this carefully, but the answer is almost certainly

 yes.  In


> > Backup and Recovery classes, all my students use RMAN on the last day

 of the


> > course -and I'm 99.9% certain that we've changed the

> > remote_login_passwordfile to NONE by then.

> >

> > In fact, I'll stick my neck out and say that I'm 99.999% certain that

 they


> > connect to the target as system/manager -which is using data

 dictionary


> > authentication, and hence the passwordfile parameter setting is

 utterly


> > irrelevant.

> >

> > connect catalog rman/rman_at_catdb target system/manager_at_db1  ....seems

 fairly


> > familiar to me.

> >

> > Regards

> > HJR

> > --

> > ----------------------------------------------------------------------

 -----


> > Opinions expressed are my own, and not those of Oracle Corporation

> > Oracle DBA Resources:

 http://www.geocities.com/howardjr2000


> > ----------------------------------------------------------------------

 -----


> >

> > <tedchyn_at_yahoo.com> wrote in message

 news:8v1mht$58n$1_at_nnrp1.deja.com...


> > > Sir, Is is possible connecting  to target database from a rman

 remote


> > > catalog DB without using remote_login_passwordfile=exclusive on the

> > > target db init.ora file ?

> > >

> > > Thnx ted

> > >

> > >

> > > Sent via Deja.com http://www.deja.com/

> > > Before you buy.

> >

> >

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.