Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bypass user name and password prompt for sqlplus on Windows

563244Feb 21 2007 — edited Feb 23 2007

Hi folks,
I had oracle 10g installed on my Windows XP SP2 system and everytime I use sqlplus, it prompts for user name and password. Some folks wrote some Unix shell scripts which invokes "sqlplus" without giving it user name and password, and these scripts are running fine on Solaris. So I would like to make these script to work on my Windows box as well. But obviously, it asks me user name and password every time. Since it is a shell script, sqlplus << EOT .... EOT will fail right away with : Fatal NI connect error 12560, blah blah blah...

So my question is how to make sqlplus bypass the user name and password questions.

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 23 2007

Added on Feb 21 2007

#general-database-discussions

20 comments

6,457 views