Home » SQL & PL/SQL » Client Tools » connect from oracle 9i to sql developer (winxp)
connect from oracle 9i to sql developer [message #521502] Tue, 30 August 2011 11:47 Go to next message
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
Re: connect from oracle 9i to sql developer [message #521597 is a reply to message #521502] Wed, 31 August 2011 08:45 Go to previous messageGo to next message
Littlefoot
Messages: 19605
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?
Re: connect from oracle 9i to sql developer [message #522166 is a reply to message #521597] Wed, 07 September 2011 01:46 Go to previous messageGo to next message
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?
Re: connect from oracle 9i to sql developer [message #522178 is a reply to message #522166] Wed, 07 September 2011 02:38 Go to previous messageGo to next message
Littlefoot
Messages: 19605
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.
Re: connect from oracle 9i to sql developer [message #522491 is a reply to message #522178] Sun, 11 September 2011 00:00 Go to previous messageGo to next message
msol25
Messages: 234
Registered: June 2011
Location: Mumbai
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

Re: connect from oracle 9i to sql developer [message #522502 is a reply to message #522491] Sun, 11 September 2011 00:58 Go to previous messageGo to next message
Michel Cadot
Messages: 59100
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 Go to previous messageGo to next message
msol25
Messages: 234
Registered: June 2011
Location: Mumbai
Senior Member
I think that new connection means adding new tns entry..
Re: connect from oracle 9i to sql developer [message #522506 is a reply to message #522504] Sun, 11 September 2011 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 59100
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
Re: connect from oracle 9i to sql developer [message #522507 is a reply to message #522506] Sun, 11 September 2011 01:07 Go to previous messageGo to next message
msol25
Messages: 234
Registered: June 2011
Location: Mumbai
Senior Member
yes i am telling that only..

so i m giving to add username,Password,SID,IP Address etc...
Re: connect from oracle 9i to sql developer [message #522508 is a reply to message #522507] Sun, 11 September 2011 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 59100
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 Go to previous messageGo to next message
msol25
Messages: 234
Registered: June 2011
Location: Mumbai
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.



Re: connect from oracle 9i to sql developer [message #522545 is a reply to message #522506] Mon, 12 September 2011 05:44 Go to previous messageGo to next message
Roachcoach
Messages: 1202
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
Re: connect from oracle 9i to sql developer [message #522548 is a reply to message #522545] Mon, 12 September 2011 06:04 Go to previous message
Michel Cadot
Messages: 59100
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
Previous Topic: toad connect using
Next Topic: Language setting
Goto Forum:
  


Current Time: Wed Sep 17 04:34:24 CDT 2014

Total time taken to generate the page: 0.14883 seconds