troubleshooting Question

connect to the Oracle database using shell script

Avatar of chanikya
chanikya asked on
Unix OSOracle Database
12 Comments1 Solution2431 ViewsLast Modified:
Hi Experts,

I am new to shell script.

In the shell script i have the below statement.

sqlplus  / @connectstring << EOF
.... some statements
EOF

When I am  trying to execute the shell script, it is asking  me  username and password.
But as per my requirement it should not ask the username and password and also i should not hard code username and password in the shell script.

what else i need to do, to make use of the same statement without any changes.

your suggestions will be highly appreciated.

Thanks In Advance .

Thanks,
Chanikya.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros