topic using sqlplus. in Operating System - HP-UX

using sqlplus.

Boniface Chiwenda — Fri, 02 Jul 2004 09:51:02 GMT

Hi everyone
I have a situation where Iam starting sqlplus under root with this command:
su - asy -c /home/asy/sqlplus username/password
and the command starts sqlplus without any problem but it asks me of the username and password which I have supplied on the command line. I suspect the system can only interprate the command upto sqlplus which means it's not seeing the username and password supplied.
How can I execute the same command without been asked for a username and password.
Regards

Bonnie.

Re: using sqlplus.

RAC_1 — Fri, 02 Jul 2004 09:58:55 GMT

su - asy -c "/home/asy/sqlplus username/password"

Anil

Re: using sqlplus.

Boniface Chiwenda — Fri, 02 Jul 2004 10:10:43 GMT

Thanks Anil
You have made my day.

Regards.

Bonnie.

Re: using sqlplus.

Yogeeraj_1 — Sat, 03 Jul 2004 01:57:12 GMT

Bonnie,

please allow me to added the following:

if you Database allows for OS authentication, you can also avoid specifying the username and password by just running:
su - asy -c "/home/asy/sqlplus /"

assumptions:
a. You have OS parameters enabled at the database level
e.g.
SQL> show parameter os_auth

NAME TYPE VALUE
------------------------------------ ------- ------------------------------
os_authent_prefix string ops$
remote_os_authent boolean TRUE

b. you have a user ops$asy in your database.

hope this helps too!
regards
Yogeeraj