OraFAQ Forum: Client Tools » Open a Oracle Shell?

Home » Other » Client Tools » Open a Oracle Shell?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Open a Oracle Shell? [message #114944]

Wed, 06 April 2005 09:47

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

Report message to a moderator

Re: Open a Oracle Shell? [message #114946 is a reply to message #114944]

Wed, 06 April 2005 09:59

Mahesh Rajendran
Messages: 10708
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).

Report message to a moderator

Re: Open a Oracle Shell? [message #114947 is a reply to message #114944]

Wed, 06 April 2005 10:00

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

SQL*Plus.

If you're using Windows, look for something called sqlplus.exe or sqlplusw.exe.

Report message to a moderator

Re: Open a Oracle Shell? [message #114951 is a reply to message #114944]

Wed, 06 April 2005 10:09

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.

Report message to a moderator

Re: Open a Oracle Shell? [message #114955 is a reply to message #114947]

Wed, 06 April 2005 10:21

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?

Report message to a moderator

Re: Open a Oracle Shell? [message #114956 is a reply to message #114955]

Wed, 06 April 2005 10:24

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: Open a Oracle Shell? [message #114958 is a reply to message #114956]

Wed, 06 April 2005 10:43

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?

Report message to a moderator

Re: Open a Oracle Shell? [message #114960 is a reply to message #114958]

Wed, 06 April 2005 10:52

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Open a Oracle Shell? [message #114962 is a reply to message #114960]

Wed, 06 April 2005 10:57

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.

Report message to a moderator

Re: Open a Oracle Shell? [message #114969 is a reply to message #114962]

Wed, 06 April 2005 11:20

Mahesh Rajendran
Messages: 10708
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?

Report message to a moderator

Re: Open a Oracle Shell? [message #114984 is a reply to message #114969]

Wed, 06 April 2005 12:28

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.

Report message to a moderator

Re: Open a Oracle Shell? [message #114987 is a reply to message #114984]

Wed, 06 April 2005 12:39

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Previous Topic:	How to call procedure from SQL Plus Worksheet
Next Topic:	iSQL*Plus: Adjusting Time-out limits

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 31 03:04:48 CST 2025