Re: Connecting via Scripts

jdob_at_ping.at (Jacek Dobosz) wrote:
>DAGMARA_at_news.delphi.com (DAGMARA_at_DELPHI.COM) wrote:
>
>>I am currently supporting a client who embeds their ORACLE accounts and
>>passwords within their UNIX scripts (for all the world to see). It's
>>been quite a while since I wrote cron jobs to connect to ORACLE using a
>>user account (my world is more or less isolated to SQL*DBA) and I can't
>>recall how to do this. Suggestions please! They are using HP-UX UNIX.
 

>>Dagmar Anne Bogan
 

>>Kopania & Komorovsky Specializing in Data Architecture
>>Richardson, TX 75081 and Performance Engineering
 

>>dagmara_at_delphi.com
>
>I think, the best solution for connecting sql-scripts that are running
>in background is auto login. How to do it ?
>
>1. Create DB-User: "ops$<os-user-name>
>If you don't like ops$ you can overload it with OS_AUTHENT_PREFIX
>parameter in ini file.
>
>2. Login on your UNIX-Box as <os-user-name>
>
>3. Set ORACLE_HOME, ORACLE_SID and/or TWO_TASK
>
>4. After successfull login on your operating system you can perform
>autologin on ORACLE i.e :
>
>sqlplus /
>
>
>
>hope this helps
>
>jacek
>

You've neglected to mention a major action point. That is, the ORACLE user account's password must be defined to be authenticated by the OS (externally).

E.g. For OS_AUTHENT_PREFIX="" (Note: the default is ops$)

For new user:

sqlplus> create user new_dba identified externally..(and so on)

For existing user:

sqlplus> alter user old_dba identified externally

-- 
=============================================
= Theodore Do                               =
= Senior Technical Specialist, UNIX/ORACLE  =
= TRW Information Technology Services       =
= tdo_at_mailsrv1.trw.com                      =
=============================================