RE: Alternatives to REMOTE_OS

From: Jeffery Stevenson <jeff_at_mpv.com>
Date: Wed, 3 Jan 2001 16:29:00 -0600
Message-Id: <10730.125644@fatcity.com>

Would it be possible to use a database link so you could query the other database for the datafile names?

Jeffery Stevenson
Chief Databeast Tamer
Medical Present Value, Inc.
Austin, TX

-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com] Sent: Wednesday, January 03, 2001 3: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 also send the HELP command for other information (like subscribing). Received on Wed Jan 03 2001 - 16:29:00 CST

RE: Alternatives to REMOTE_OS_AUTHENT?