Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to retrieve the Connect String in UNIX script?

How to retrieve the Connect String in UNIX script?

From: Wes Brooks <wes_brooks_at_yahoo.com>
Date: Sat, 14 Aug 2004 21:37:21 -0700 (PDT)
Message-ID: <20040815043721.60520.qmail@web51008.mail.yahoo.com>


Hello expert,

My environment has 10 Oracle databases. The job is run called up by UNIX script. The job may need to sign on with different User IDs to different Oracle database instance in order to get the batch job running. To avoid to logon with a wrong database instance, the current practice is to hard-code the logon ID, password, and the Connect String on the UNIX script.

If I want to remove the hard-code of the logon information, would you mind to share your experience how to handle this change? How to set up the UNIX User environment based on the job so that the script can retrieve the Connect String easily?



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Sat Aug 14 2004 - 23:33:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US