[bhavirisetty]

Hi i am using My Eclipse 9.0 M2

when i am trying to use thin driver to create database i got some errors.

error is-“unable to login into database network protocol adapter error”

In my system i am using oracle 11g R2, windows 7 professional

So please tell me how to connect database using oracle thin driver,

1. what is the driver template name to use thin driver?

2.what is the driver name i need to place?

3. what is the connection url name i need to place?

->My oracle port number is 1521

->My oracle sid is CLRExtProc

4. which driver jar file i need to use? and where can i download the jar file?

Please tell me please

[support-swapna]

bhavirisetty,

1) To download the driver, take a look at this post :
https://www.genuitec.com/forums/topic/db-where-can-i-download-a-oracle-jdbc-driver/

2) Attached is the screenshot which gives you a clear picture about the driver template,name and url to use (where cad-135 is the system name and XE is the database). You can replace with your system details in the url.

Hope this helps.

Attachments:

You must be logged in to view attached files.

[bhavirisetty]

I already tried for several drivers including what u mention but still i face the prob?

Please solve me

[bhavirisetty]

Hello sir,

I done everything as per your said but still i get this error

“IO Exception:The network adapter could not establish the connection”.

Please resolve this problem[/img]

[support-swapna]

bhavirisetty,

1) Can you connect to your database with SQL*Plus?

2) Can you check if your Oracle is running in Services application, available under Administrative Tools in Control Panel?.Look for Services named Orcl… One will be the database itself, and will have the database name at the end of the service name. Another will be OrclTNSListener.

3) Can you check your Oracle Net configuration (tnsnames, listener).

[bhavirisetty]

@support-swapna wrote:

bhavirisetty,

1) Can you connect to your database with SQL*Plus?

2) Can you check if your Oracle is running in Services application, available under Administrative Tools in Control Panel?.Look for Services named Orcl… One will be the database itself, and will have the database name at the end of the service name. Another will be OrclTNSListener.

3) Can you check your Oracle Net configuration (tnsnames, listener).

Thanks to every one,

My problem is resolved.

Problem is with my oracle 11g R2 on windows, I just uninstall oracle and install
Oracle 10g express edition.

and then i follow what u said its work perfectly till now.

Thanx to every one thanks for ur support

[bhavirisetty]

@support-swapna wrote:

bhavirisetty,

1) Can you connect to your database with SQL*Plus?

2) Can you check if your Oracle is running in Services application, available under Administrative Tools in Control Panel?.Look for Services named Orcl… One will be the database itself, and will have the database name at the end of the service name. Another will be OrclTNSListener.

3) Can you check your Oracle Net configuration (tnsnames, listener).

Thanks to every one,

My problem is resolved.

Problem is with my oracle 11g R2 on windows, I just uninstall oracle and install
Oracle 10g express edition.

and then i follow what u said its work perfectly till now.

Thanx to every one thanks for ur support

[support-swapna]

bhavirisetty,

Glad to know that it is working fine for you.
Do let us know if you have any other issues.

[bhavirisetty]

Thank you for your support.

[Author]

Posts