OraFAQ Forum: Client Tools » How to connect to sql plus

Home » Other » Client Tools » How to connect to sql plus (Oracle 10g)

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

How to connect to sql plus [message #483060]

Thu, 18 November 2010 00:58

monasingh
Messages: 229
Registered: May 2006
Location: Mumbai

Senior Member

Hi,
I have to connect to sql*plus to get explain plan.
When I conect in Toad, the credentials are as:-
User/schema :- TestDb
Password :- TestDb

Under direct tab:-
Host :- 172.17.252.96 Port :- 1521

Service Name :- xe

I am not able to connect to sql*plus using:-

Username :- TestDb
Password :- TestDb
Host String :- 172.17.252.96

Not sure how to login when I have IP address

I also tried login as:-

Username :- TestDb
Password :- TestDb
Host String :- xe

Please advice,

Mona

Report message to a moderator

Re: How to connect to sql plus [message #483061 is a reply to message #483060]

Thu, 18 November 2010 01:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: How to connect to sql plus [message #483063 is a reply to message #483060]

Thu, 18 November 2010 01:03

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Try this:

sqlplus TestDb/TestDb@172.17.252.96:1521/xe

Update - code tags

[Updated on: Thu, 18 November 2010 01:05]

Report message to a moderator

Re: How to connect to sql plus [message #483070 is a reply to message #483063]

Thu, 18 November 2010 01:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you consider putting alias of that database into the TNSNAMES.ORA file so that you wouldn't have to remember IP address and port number, but simply say something like

sqlplus testdb/testdb@my_db

Report message to a moderator

Re: How to connect to sql plus [message #485593 is a reply to message #483070]

Thu, 09 December 2010 00:05

bhadresh4u
Messages: 41
Registered: May 2005
Location: Japan

Member

Refer SQL*Plus Guide,

http://download.oracle.com/docs/cd/B10501_01/server.920/a90842/qstart.htm

Report message to a moderator

Re: How to connect to sql plus [message #486653 is a reply to message #485593]

Sat, 18 December 2010 00:43

gregjay
Messages: 8
Registered: December 2010
Location: Kent

Junior Member

If you're being asked for a hoststring, it looks to me like you're attempting to connect to sql*plusW, rather than sql*plus.

To connect to a local XE installation, a simple

sqlplus testdb/testdb

should do the trick.

Report message to a moderator

Previous Topic:	about oracle monitoring
Next Topic:	error in PLSQL Developer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 06:27:32 CST 2024