Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connecting my application to Oracle 10g stored on another machine

 
Hargobind Singh
Greenhorn
Posts: 7
Eclipse IDE Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey people, I really need help >> to connect my application running in Weblogic Application Server (basically my server computer) to Oracle 10g Database on another machine... How to achieve this in minimum possible time ... Only if there is a way to make my computer reach to DB installed on another computer...

Please help me out asap... have to submit the project .. :(
 
sudipto shekhar
Ranch Hand
Posts: 826
Chrome Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,



to connect my application running in Weblogic Application Server (basically my server computer) to Oracle 10g Database on another machine...



As far as I can understand by this, you need to create/configure a data source that will connect to your database.



How to achieve this in minimum possible time ...



To accomplish this task in minimum possible time by you is to try Oracle Documentation for this.

Try it out and if you get stuck, let us know. There would be someone or other out here to help you out.
 
sudipto shekhar
Ranch Hand
Posts: 826
Chrome Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I did a little google for you..... webpage
 
Hargobind Singh
Greenhorn
Posts: 7
Eclipse IDE Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
First of all, Thanks alot ... it did directed me towards the right approach

Somehow, I was able to achieve my connection part of application server to Oracle 10g... by configuring the data source part in application server to connect to my remote db, i.e., oracle 10g (say on a machine - harry002)
Application server is on machine : harry001
Now having successfully established the connection by giving static IPs to both the machines within same subnetwork... harry001 =>192.168.1.2 and harry002=>192.168.1.3 ( I'm using these only for demonstration purposes so that i can achieve what i want)

After my application has launched, when query the DB through my application for a simple Login page i get the following exception...

java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: localhost:1521 : orcl

Now i have no idea how to get rid of this exception... please help me out

Thanks ..
 
sudipto shekhar
Ranch Hand
Posts: 826
Chrome Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hargobind Singh wrote:
After my application has launched, when query the DB through my application for a simple Login page i get the following exception...

java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: localhost:1521 : orcl




Did you test the connection that you created from the weblogic console?

It seems that the database SID you specified is incorrect. Or else when the database instance has not been started.

Please check the connection from the console and also make sure that the database instance is started when you do the test.

Let us know with your progress.
 
Hargobind Singh
Greenhorn
Posts: 7
Eclipse IDE Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i'm not getting how to do this ... ... is it related to the no. we provide:1521 -- for connectivity ??
 
sudipto shekhar
Ranch Hand
Posts: 826
Chrome Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hargobind Singh wrote:i'm not getting how to do this ... ... is it related to the no. we provide:1521 -- for connectivity ??



Hargobind, can you be a little more specific? what did you not get? 1521 is the port number to connect to the database. That would be you environment specific configuration.

You can post the screenshot of your weblogic console to configure Data Source, or the config.xml file of your domain, so that we can have a look!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic