Location: SQL Developer FAQ

Discussion: Do i have to install oracle 10g clientReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 10 posts

kushanxp
Do i have to install oracle 10g client
Oct 20 2009, 2:22 PM EDT | Post edited: Oct 20 2009, 2:22 PM EDT
Hi..

I have installed oracle enterprise 10g on a server and still i didnt install oracle client on my machine...my question is do i have to install oracle client in order to use the sql developer Do you find this valuable?    
Keyword tags: Oracle SQL Developer FAQ
m.noaman
m.noaman
1. RE: Do i have to install oracle 10g client
Oct 23 2009, 12:29 PM EDT | Post edited: Oct 23 2009, 12:29 PM EDT
yes you should
and be sure to install it administrator or custom
if custom you should select sql-plus to be installed

after you finish you should edit your tns_names file to connect to the database manually
or using Net Configuration Assistant will do the same

 0  out of 1 found this valuable. Do you?    

naveenhks
2. RE: Do i have to install oracle 10g client
Oct 23 2009, 1:11 PM EDT | Post edited: Oct 23 2009, 1:11 PM EDT
Hi Kushan,

If you are using sqldeveloper and If you use the connection Type as "Basic" to connect to oracle database then sqlplus client is not required. However If you want to use the connection Type as TNS then yes you need to install the sqlplus client on your workstation/pc/laptop/desktop

Naveen
 1  out of 1 found this valuable. Do you?    

naveenhks
3. RE: Do i have to install oracle 10g client
Oct 23 2009, 1:13 PM EDT | Post edited: Oct 23 2009, 1:13 PM EDT
"Hi Kushan,

If you are using sqldeveloper and If you use the connection Type as "Basic" to connect to oracle database then sqlplus client is not required. However If you want to use the connection Type as TNS then yes you need to install the sqlplus client on your workstation/pc/laptop/desktop

Naveen
"
You can see the connection type options when you select "New connection" which is the "+" button on the left top corner which is under the toolbar and its in green color 0  out of 1 found this valuable. Do you?    

kushanxp
4. RE: Do i have to install oracle 10g client
Oct 23 2009, 11:29 PM EDT | Post edited: Oct 23 2009, 11:29 PM EDT
"You can see the connection type options when you select "New connection" which is the "+" button on the left top corner which is under the toolbar and its in green color"
Hi Naveen,

Is there another client for SQL Developer too, i have downloaded Oracle Enterprise 10g and the Instant Client of the version... and the SQL Developer..

i have installed the Oracle 10g server on one Linux machine and the Instant Client on my machine(which is Linux too)

i have given the (rpm -ivh instant-client.rpm) to install the Instant Client on my machine and tried to create a new connection through SQL Developer
but still i couldnt establish the connection from my machine to the server...

Please guide me....

Thank you.. 0  out of 1 found this valuable. Do you?    

naveenhks
5. RE: Do i have to install oracle 10g client
Oct 24 2009, 12:12 AM EDT | Post edited: Oct 24 2009, 12:12 AM EDT
Hi Kushan,

Yo dont need an client installed if you want to use sql developer. You can connect to any database instance.

while configuring new connection, select the connection type as "Basic" and fill in the relevant info. and press "test" button to validate. Once after successful then press "save" button and then click "connect" button to get connected to the connection

Naveen
 3  out of 3 found this valuable. Do you?    

kushanxp
6. RE: Do i have to install oracle 10g client
Oct 24 2009, 1:19 AM EDT | Post edited: Oct 24 2009, 1:19 AM EDT
"Hi Kushan,

Yo dont need an client installed if you want to use sql developer. You can connect to any database instance.

while configuring new connection, select the connection type as "Basic" and fill in the relevant info. and press "test" button to validate. Once after successful then press "save" button and then click "connect" button to get connected to the connection

Naveen
"
Hi Naveen,

Thank you very much for the guidance, i will do as you said and let you know wht happened! :)

Kushan 0  out of 1 found this valuable. Do you?    
zaferaktan
zaferaktan
7. RE: Do i have to install oracle 10g client
Oct 28 2009, 6:27 PM EDT | Post edited: Oct 28 2009, 6:27 PM EDT
what jdbc thin drive do ? don't use OCI - which means don't need TNS - right ? ;) Naveen is absolutely correct. When "basic" connection is selected the jdbc thin driver is used - and you don't need to install the Oracle client - isn't that beautiful (I do love SqlDeveloper - try to install the latest version 2.1 - which has some new features compared to 1.5.X - I am sure you will like it too. Also use SqlDeveloper to administer APEX - how cool is that :) 2  out of 2 found this valuable. Do you?    

kushanxp
8. RE: Do i have to install oracle 10g client
Wednesday, 1:15 AM EST | Post edited: Wednesday, 1:15 AM EST
"Hi Naveen,

Thank you very much for the guidance, i will do as you said and let you know wht happened! :)

Kushan"
Hi Naveen, It worked thank you very much.. :) Do you find this valuable?    

naveenhks
9. RE: Do i have to install oracle 10g client
Wednesday, 9:34 AM EST | Post edited: Wednesday, 9:34 AM EST
Hi Kushan

Super. Enjoy the beauty of sqlDeveloper

Naveen Do you find this valuable?    

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
SQL Developer FAQ Publish to APEX ?