OraFAQ Forum: Client Tools » connect from oracle 9i to sql developer

Home » SQL & PL/SQL » Client Tools » connect from oracle 9i to sql developer (winxp)

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

connect from oracle 9i to sql developer [message #521502]

Tue, 30 August 2011 11:47

anand143sharma
Messages: 1
Registered: August 2011
Location: Mumbai

Junior Member

how i can add new connection to sql developer i had made a database name abb how i will connect that to sql developer

Report message to a moderator

Re: connect from oracle 9i to sql developer [message #521597 is a reply to message #521502]

Wed, 31 August 2011 08:45

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

Senior Member
Account Moderator

I believe it is described in the documentation. Did you read it? Follow it? What difficulties did you have when trying to connect?

Report message to a moderator

Re: connect from oracle 9i to sql developer [message #522166 is a reply to message #521597]

Wed, 07 September 2011 01:46

Baranor
Messages: 83
Registered: September 2011
Location: Netherlands

Member

Since I am new here, are we talking about Oracle's SQL developer or PL/SQL developer?

Report message to a moderator

Re: connect from oracle 9i to sql developer [message #522178 is a reply to message #522166]

Wed, 07 September 2011 02:38

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

Senior Member
Account Moderator

As the OP didn't mention PL/SQL developer, I suppose it is Oracle's SQL developer.

Report message to a moderator

Re: connect from oracle 9i to sql developer [message #522491 is a reply to message #522178]

Sun, 11 September 2011 00:00

msol25
Messages: 396
Registered: June 2011

Senior Member

hi Anand,

Please go into sqldeveloper and then mention :

Username
Password
IP
SID

and add tns into tnsname.ora into /$ORACLE_HOME/admin directory

Report message to a moderator

Re: connect from oracle 9i to sql developer [message #522502 is a reply to message #522491]

Sun, 11 September 2011 00:58

Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The question is "how i can add new connection", do you think your post answers this?

Regards
Michel

[Updated on: Sun, 11 September 2011 00:59]

Report message to a moderator

Re: connect from oracle 9i to sql developer [message #522504 is a reply to message #522502]

Sun, 11 September 2011 01:02

msol25
Messages: 396
Registered: June 2011

Senior Member

I think that new connection means adding new tns entry..

Report message to a moderator

Re: connect from oracle 9i to sql developer [message #522506 is a reply to message #522504]

Sun, 11 September 2011 01:06

Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I don't think so.
I think it is rather: in "Connections" left panel, how to add a new one, don't you think?

Regards
Michel

Report message to a moderator

Re: connect from oracle 9i to sql developer [message #522507 is a reply to message #522506]

Sun, 11 September 2011 01:07

msol25
Messages: 396
Registered: June 2011

Senior Member

yes i am telling that only..

so i m giving to add username,Password,SID,IP Address etc...

Report message to a moderator

Re: connect from oracle 9i to sql developer [message #522508 is a reply to message #522507]

Sun, 11 September 2011 01:12

Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes but how do you add a new connection?

Regards
Michel

[Updated on: Sun, 11 September 2011 01:12]

Report message to a moderator

Re: connect from oracle 9i to sql developer [message #522511 is a reply to message #521502]

Sun, 11 September 2011 03:02

msol25
Messages: 396
Registered: June 2011

Senior Member

Just click on new in left side panel

Then enter :

Username
Password
hostname
sid

Then New connection will be connected.

If not connecting then try to connect with sqlplus like:


 /home/sqlplus
 Enter username : tmp@tnsname
 Enter Password : tmp

if not connected then check tnsnames.ora in $ORACLE_HOME/admin and then check tnsname i.e. correct or not.

If not then it can be other issue that you can discuss in orafaq.

Report message to a moderator

Re: connect from oracle 9i to sql developer [message #522545 is a reply to message #522506]

Mon, 12 September 2011 05:44

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Michel Cadot wrote on Sun, 11 September 2011 07:06

I don't think so.
I think it is rather: in "Connections" left panel, how to add a new one, don't you think?

Regards
Michel

In fairness I think that he's assuming there's a problem with actually making the connection/TNS listing rather than how to get to the right GUI page...

After all, how can someone seriously miss the big green plus sign complete with tooltip saying 'New connection...' or indeed right clicking the connections part and selecting 'New connection...' all held in the connections window Wink

Report message to a moderator

Re: connect from oracle 9i to sql developer [message #522548 is a reply to message #522545]

Mon, 12 September 2011 06:04

Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You cannot imagine what I saw...
I once saw someone telling me there is no space key on his keyboard and was surprised when I pointed him to the space bar (too large to be seen). Wink

Regards
Michel

Report message to a moderator

Previous Topic:	toad connect using
Next Topic:	Language setting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 15 15:47:37 CST 2021