Re: logging onto svrmgrl remotely

Answers embedded

Hth,

--
Sybrand Bakker, Oracle DBA
<kal121_at_my-deja.com> wrote in message news:87fh2o$r3j$1_at_nnrp1.deja.com...
> Can anybody answer these?
>
> 1. Can you log onto svrmgrl remotely? In other words, is it possible to
> run svrmgrl locally while connecting to a remote machine?
>

Yes, no problem at all and don't forget Instance Manager and OEM and a number of other tools.

> The reason I ask is, if you can't do this, then what's the point of the
> REMOTE_LOGIN_PASSWORDFILE parameter? If you can't login remotely, it's a
> moot point.
>
> 2. Okay, then what about sqlplus? Yes, you can run sqlplus locally, but
> you're always going to have to login as a database user, so
> authentication is not occurring at the OS level, so who cares about
> REMOTE_LOGIN_PASSWORD?
>

But authentication can occur at the OS level, both in Unix and NT! You need to set an init.ora parameter or two, OPS_AUTHENT_PREFIX and REMOTE_OS_AUTHENT, but it is possible. In that case you can just use a / to connect.

> So my question is, when is REMOTE_LOGIN_PASSWORD in effect? Because so
> far I can't figure out a way to login to Oracle remotely unless I'm
> using sqlplus, in which case you're never authenticated at the OS level.
> Not to mention, they're phasing out svrmgrl.
>
>

That's your own choice. If you have trusted connections to the server (and the server is in a server room behind a locked door, and miles away), you can enable in order to do privilege work at your own desk. In a distributed environment we did set it up (leased line) and I was able to restart a database 6000 miles away. Without the passwordfile I wouldn't have been able to do so.
If you don't have trusted connections you should keep it disabled and execute all privileged actions directly on the server.

>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Feb 04 2000 - 16:46:10 CST