RE: Alternatives to REMOTE_OS_AUTHENT?

Use an rsh to the remote host. The account on the remote host can then be an ops$ account. No passwords at all. (You'll have to set up .rhosts file appropriately. Assuming you are using rcp to do the file copies, this shouldn't be a problem.)

• Sample in-line sqlplus session rsh -n remote_host " export ORACLE_SID=ORCL; export ORACLE_HOME=/opt/app/oracle/product/7.3.4; \$ORACLE_HOME/bin/sqlplus -s / <<EOS set pages 0 set pause off set trimspool off

select * from v\\\$database;
EOS
"
-- End sample

Obviously you could put a script on the remote host to do the sqlplus stuff. Then it becomes a much more simple rsh command. 8) Redirect the contents to a file, or my favorite, add a while/read loop and operate on the output directly. (Yes, I still have 7.3 databases. ;) Hopefully not long though.)

You could even parse a 'tnsping' to get the host. Then you don't hard code that either. That would have the added bonus of checking availability before starting also.

HTH
Shawn M Ferris
Oracle DBA - Time Warner Telecom

> -----Original Message-----
> From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com]
> Sent: Wednesday, January 03, 2001 2:13 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Alternatives to REMOTE_OS_AUTHENT?
>
>
> Hi all,
>
> I'm trying to automate a DB copy across our network. Part of
> this involves
> logging into the production DB from the test box to get the
> datafile names.
>
> Without setting REMOTE_OS_AUTHENT in our production DB (huge
> security hole),
> does anyone have an idea as to how to accomplish this without
> hardcoding
> usernames/passwords and without using an add-on product like
> Kerberos? e.g.
> "sqlplus /@PRODDB @get_file_names"
>
> BTW, the databases are 8.0.5 on HPUX. (Can't wait until I
> can get to 8i!)
>
> TIA,
> Rich Jesse System/Database Administrator
> Rich.Jesse_at_qtiworld.com Quad/Tech International,
> Sussex, WI USA
>
>
> --------------------------------------------------------------
> ----------
>
> This message has been scanned for viruses with Trend Micro's
> Interscan VirusWall.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Jan 04 2001 - 14:52:07 CST