Home » SQL & PL/SQL » Client Tools » Open a Oracle Shell?
Open a Oracle Shell? [message #114944] Wed, 06 April 2005 09:47 Go to next message
Vishal_7
Messages: 63
Registered: April 2005
Member
Which application do you use to open an oracle shell? I am new to oracle and doesnt really know how to do that. For example in the following thread Barbara uses some kind of shell and types in the SQL. I have Toad and Embarcadero installed, but dont see any shell option there.

Thanks
Re: Open a Oracle Shell? [message #114946 is a reply to message #114944] Wed, 06 April 2005 09:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I beleive, it is just sql*plus ( the old, default, native and cool command line tool that is distributed along with oracle).
Re: Open a Oracle Shell? [message #114947 is a reply to message #114944] Wed, 06 April 2005 10:00 Go to previous messageGo to next message
Art Metzer
Messages: 2478
Registered: December 2002
Senior Member
SQL*Plus.

If you're using Windows, look for something called sqlplus.exe or sqlplusw.exe.
Re: Open a Oracle Shell? [message #114951 is a reply to message #114944] Wed, 06 April 2005 10:09 Go to previous messageGo to next message
Vishal_7
Messages: 63
Registered: April 2005
Member
I dont have sqlplus.exe or sqlplusw.exe installed. I just have the Oracle .NET provider installed on my system. The Oracle database is on another server. I guess I have to download the tool from somewhere.
Re: Open a Oracle Shell? [message #114955 is a reply to message #114947] Wed, 06 April 2005 10:21 Go to previous messageGo to next message
Vishal_7
Messages: 63
Registered: April 2005
Member
I am trying to locate the tool via google, but cant find it. Anybody knows where to download it?
Re: Open a Oracle Shell? [message #114956 is a reply to message #114955] Wed, 06 April 2005 10:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just download the oracle client from oracle.com
install the client. you get your sqlplus tool.
http://www.oracle.com/technology/software/index.html
Re: Open a Oracle Shell? [message #114958 is a reply to message #114956] Wed, 06 April 2005 10:43 Go to previous messageGo to next message
Vishal_7
Messages: 63
Registered: April 2005
Member
Hey Mahesh,

is the (Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP) on that page:

http://www.oracle.com/technology/software/products/oracle9i/index.html


I cant seem to find it. We have oracle 9.2.0.3 installed. can you help me to locate it please?
Re: Open a Oracle Shell? [message #114960 is a reply to message #114958] Wed, 06 April 2005 10:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
the product titled.
Oracle9i Database Release 2 Enterprise/Standard/Personal/Client Edition for Windows XP 2003/Windows Server 2003 (64-bit)

should help ( are you in 64 bit env?. else look for 32 bit)
Oracle9i Database Release 2 Enterprise/Standard/Personal/Client Edition for Windows Server 2003 (32-bit)

DOnt worry about versions.
any version of 9i /10g client would help.
( except in a very few cases, like export and import of database, where you need to do something more becuause of version difference. No big deal) sqlplus tool remains almost the same!.
download the software ( needs a free membership), install the client ( ONLY THE CLIENT), edit your tnsnames.ora to identify and connect to the databases in server.

Re: Open a Oracle Shell? [message #114962 is a reply to message #114960] Wed, 06 April 2005 10:57 Go to previous messageGo to next message
Vishal_7
Messages: 63
Registered: April 2005
Member
Thanks buddy.

I am downloading right now:


Oracle9i Database Release 2 Client for Microsoft Windows 98/2000/NT/XP for 32 Bit.

I downloaded sqlplus for Oracle10, but when I run it I got:

The procedure entry point Ifipthad could not be located in the dynamic link library OCI.dll

It seems that this version doesnt work for me.
Re: Open a Oracle Shell? [message #114969 is a reply to message #114962] Wed, 06 April 2005 11:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
seems the .net provider previously installed is not happy.
I am not sure.

Did you install the oracle in a new ORACLE_HOME ( install in seperate directory).
did you try 9i?

Re: Open a Oracle Shell? [message #114984 is a reply to message #114969] Wed, 06 April 2005 12:28 Go to previous messageGo to next message
Vishal_7
Messages: 63
Registered: April 2005
Member
Hey,

I got sqlplus installed, however when trying to login, I always get:

TNS-12560 TNS:protocol adapter error

Where can I set the protocol specification. I did that with the netmanager and also connected successfuly via that. However when running sqlplus.exe it doesnt work.

Re: Open a Oracle Shell? [message #114987 is a reply to message #114984] Wed, 06 April 2005 12:39 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
edit sqlnet.ora and comment all entries.
edit tnsnames.ora and add entries to talk to your databases.
search this forum or google for examples.
Previous Topic: How to call procedure from SQL Plus Worksheet
Next Topic: iSQL*Plus: Adjusting Time-out limits
Goto Forum:
  


Current Time: Wed Aug 05 20:07:27 CDT 2020