Connect to Oracle database

Hi,

I am using sqlplus user/pass to connect to DB.
Is there a way to hide the username/password and connect to db and perform actions like wallet ?

Please share few other options on it.

Thanks
LVL 5
magentoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark BullockQA EngineerCommented:
You can use Oracle Wallet Manager on your client.
Launch it with the command owm.

Here's a tutorial which walks you through the entire process.
http://askdba.org/weblog/2009/09/using-oracle-wallet-to-execute-shell-scriptcron-without-hard-coded-oracle-database-password/

Details on how to configure it are here:
http://docs.oracle.com/cd/B28359_01/network.111/b28530/asowalet.htm#i1009041
johnsoneSenior Oracle DBACommented:
What are you trying to hide them from?  Are you just looking to get them off the command line so they cannot be seen with a ps command (for instance)?

Hiding them on the command line is pretty simple.  Just don't enter them.  SQL*Plus will prompt for then, or you can use  /NOLOG as a parameter and it will not prompt.  If you use /NOLOG, just use the connect command to connect.

You can also use OS authentication.  Where no username and password is supplied.  It is passed through from the host OS.  Again, good for hiding the command line, but if a client machine is compromised, the database can be accessed.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.