Skip to Main Content

SQL & PL/SQL

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!

Sqlplus Minimal Linux Install; Can't Connect to DB

720356Sep 1 2009 — edited Sep 5 2009
All -

I am trying to install a minimum of software on a Linux VM (with not too much disk space and memory) that will allow me to run sqlplus.

I went to the Oracle client download page and downloaded the basic client package and the sqlplus package. (Is there anything else I need to install?)

Should I be able to connect to a data base by simply running sqlplus with the correct configuration, or does some other process need to be running?

I'd like to find a way to simply specify the connection parameters on the command line. I noticed on a forum somewhere that you can append to a sqlplus command line the content of the configuration of a tnsnames.ora file. However, when I did so, I could not connect.

I also tried putting a tnsnames.ora file in the $ORACLE_HOME configuration directory (it was 2 levels down from it, but I don't remember now what it was and don't have access to the machine). This didn't work either.

Can anyone offer a clue as to what I'm doing wrong? And is not possible to construct a sqlplus command line with connection parameters but without the verbose tnsnames.ora data format?

Thanks for any help,
Keith Bennett
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 3 2009
Added on Sep 1 2009
22 comments
2,409 views