Skip to Main Content

Infrastructure Software

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!

Verifying oracle connection from shell script

user640001Oct 13 2010 — edited Oct 13 2010
Hi,

Oracle 9.2
Solaris 10

From the shell script ........How can we verify whether oracle connection is successful or not ?

Shell script will prompt the user to enter the oracle schema username, password and tns name.

So, how to verify whether oracle connection has been established or not ??

If user entered schema name & password is correct then proceed further else script will again prompt for schema user name & password.


With Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2010
Added on Oct 13 2010
3 comments
1,158 views