Home » SQL & PL/SQL » Client Tools » How to connect to sql plus (Oracle 10g)
How to connect to sql plus [message #483060] Thu, 18 November 2010 00:58 Go to next message
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
Re: How to connect to sql plus [message #483061 is a reply to message #483060] Thu, 18 November 2010 01:01 Go to previous messageGo to next message
BlackSwan
Messages: 26187
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: How to connect to sql plus [message #483063 is a reply to message #483060] Thu, 18 November 2010 01:03 Go to previous messageGo to next message
John Watson
Messages: 7615
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 Go to previous messageGo to next message
Littlefoot
Messages: 21439
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
Re: How to connect to sql plus [message #485593 is a reply to message #483070] Thu, 09 December 2010 00:05 Go to previous messageGo to next message
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


Re: How to connect to sql plus [message #486653 is a reply to message #485593] Sat, 18 December 2010 00:43 Go to previous message
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.

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


Current Time: Tue Oct 16 13:20:14 CDT 2018