• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Connecting my application to Oracle 10g stored on another machine

 
Greenhorn
Posts: 7
Eclipse IDE Tomcat Server Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 .. :(
 
Ranch Hand
Posts: 826
Eclipse IDE Oracle Chrome
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Eclipse IDE Oracle Chrome
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I did a little google for you..... webpage
 
Hargobind Singh
Greenhorn
Posts: 7
Eclipse IDE Tomcat Server Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Eclipse IDE Oracle Chrome
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 Tomcat Server Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Eclipse IDE Oracle Chrome
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!
 
Eliminate 95% of the weeds in your lawn by mowing 3 inches or higher. Then plant tiny ads:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic