using sqlplus.

[Boniface Chiwenda]

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.

[RAC_1 · Accepted solution]

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

Anil

[Boniface Chiwenda]

Thanks Anil
You have made my day.

Regards.

Bonnie.

[Yogeeraj_1]

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