Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. Design and Architecture
  4. asp.net + oracle project architecture

asp.net + oracle project architecture

Scheduled Pinned Locked Moved Design and Architecture
windows-adminquestioncsharpasp-netdatabase
8 Posts 2 Posters 6 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • P Offline
    P Offline
    praetorean
    wrote on last edited by
    #1

    hi all, i'm going to be working on a web application project using asp.net 2.0 with the database backend as oracle. i would not have any problem developing my web application with oracle database, since ODP's are available and i can probably learn Oracle along the way... my problem is such that, how do i set up the architecture such that, the web applications (asp.net) are hosted in a windows server 2003 machine (iis 6.0) and the database server (Oracle 10g) would be on a SUSE linux machine. my queries would be: 1- how do i let the web app (asp.net + iis 6.0) communicate /access the oracle database hosted in suse linux? 2- would a SOA approach work on this? where there would be a service in the Oracle machine to access requests from the web apps & vice versa? 3- i also have to consider that i'm provided with a 64mb bandwidth connections. any inputs would be much appreciated. thanks all, praetorean

    I 1 Reply Last reply
    0
    • P praetorean

      hi all, i'm going to be working on a web application project using asp.net 2.0 with the database backend as oracle. i would not have any problem developing my web application with oracle database, since ODP's are available and i can probably learn Oracle along the way... my problem is such that, how do i set up the architecture such that, the web applications (asp.net) are hosted in a windows server 2003 machine (iis 6.0) and the database server (Oracle 10g) would be on a SUSE linux machine. my queries would be: 1- how do i let the web app (asp.net + iis 6.0) communicate /access the oracle database hosted in suse linux? 2- would a SOA approach work on this? where there would be a service in the Oracle machine to access requests from the web apps & vice versa? 3- i also have to consider that i'm provided with a 64mb bandwidth connections. any inputs would be much appreciated. thanks all, praetorean

      I Offline
      I Offline
      il_masacratore
      wrote on last edited by
      #2

      Hi! I'm working on a similar way: WindowsAPP/ASP.NET versus Oracle Database. Answering to your first question I'm using Oraclenet 10g client to access to database. It's the most faster to acces. You can download from oracle website. If you don't find it ask me. Answering to the second question, when you install an oracle database, is included a service called listener that get connection from the outside. Refering to your third question 64mb connection is Ok. If you want more information ask me. I hope I help you.

      Visit my blog at http://dotnetforeveryone.blogspot.com/

      P 2 Replies Last reply
      0
      • I il_masacratore

        Hi! I'm working on a similar way: WindowsAPP/ASP.NET versus Oracle Database. Answering to your first question I'm using Oraclenet 10g client to access to database. It's the most faster to acces. You can download from oracle website. If you don't find it ask me. Answering to the second question, when you install an oracle database, is included a service called listener that get connection from the outside. Refering to your third question 64mb connection is Ok. If you want more information ask me. I hope I help you.

        Visit my blog at http://dotnetforeveryone.blogspot.com/

        P Offline
        P Offline
        praetorean
        wrote on last edited by
        #3

        so i guess it's feasible on the architecture that i'm working on. i'll take a peek on the oracle 10g client.. but i'm afraid, Oracle is a new thing for me... so, i may need some catching up as for the listener service, would appreciate if i get set some more details on this. my understanding would that, upon oracle installation on the linux machine; oracle also installs the said listener. any applications wanting to access oracle on the linux machine would be going thru that listener? could i ask for more details on this... or can you point me to references pertaining this? 64mb is the initial constraint, the web application will be serving around 1800 users simultaneously at worst... would that be an issue? thanks again

        I 1 Reply Last reply
        0
        • P praetorean

          so i guess it's feasible on the architecture that i'm working on. i'll take a peek on the oracle 10g client.. but i'm afraid, Oracle is a new thing for me... so, i may need some catching up as for the listener service, would appreciate if i get set some more details on this. my understanding would that, upon oracle installation on the linux machine; oracle also installs the said listener. any applications wanting to access oracle on the linux machine would be going thru that listener? could i ask for more details on this... or can you point me to references pertaining this? 64mb is the initial constraint, the web application will be serving around 1800 users simultaneously at worst... would that be an issue? thanks again

          I Offline
          I Offline
          il_masacratore
          wrote on last edited by
          #4

          Here you have Oracle Client for .NET http://www.oracle.com/technology/software/tech/windows/odpnet/index.html and you have already running Oracle in that linux machine?

          Visit my blog at http://dotnetforeveryone.blogspot.com/

          1 Reply Last reply
          0
          • I il_masacratore

            Hi! I'm working on a similar way: WindowsAPP/ASP.NET versus Oracle Database. Answering to your first question I'm using Oraclenet 10g client to access to database. It's the most faster to acces. You can download from oracle website. If you don't find it ask me. Answering to the second question, when you install an oracle database, is included a service called listener that get connection from the outside. Refering to your third question 64mb connection is Ok. If you want more information ask me. I hope I help you.

            Visit my blog at http://dotnetforeveryone.blogspot.com/

            P Offline
            P Offline
            praetorean
            wrote on last edited by
            #5

            hi il_masacratore, thanks for the heads up, my apologies for my delayed reply... referring to your earlier input "Refering to your third question 64mb connection is Ok." i was mistaken... my bandwith connection would be limited to a 64kb connection... would it still be ok? thanks

            I 1 Reply Last reply
            0
            • P praetorean

              hi il_masacratore, thanks for the heads up, my apologies for my delayed reply... referring to your earlier input "Refering to your third question 64mb connection is Ok." i was mistaken... my bandwith connection would be limited to a 64kb connection... would it still be ok? thanks

              I Offline
              I Offline
              il_masacratore
              wrote on last edited by
              #6

              This 64Kb are client download capacity or server offer 64kb to client?

              Visit my blog at http://dotnetforeveryone.blogspot.com

              P 1 Reply Last reply
              0
              • I il_masacratore

                This 64Kb are client download capacity or server offer 64kb to client?

                Visit my blog at http://dotnetforeveryone.blogspot.com

                P Offline
                P Offline
                praetorean
                wrote on last edited by
                #7

                i can't tell for exact just yet... let's just say, it'll be either of the two... how do they differ?

                I 1 Reply Last reply
                0
                • P praetorean

                  i can't tell for exact just yet... let's just say, it'll be either of the two... how do they differ?

                  I Offline
                  I Offline
                  il_masacratore
                  wrote on last edited by
                  #8

                  I supose that your Windows Server has a connection of 64Kb with Oracle server. I supose it will be enough. If in the future your web app works slowly, you know which is your first bottleneck to check.

                  Visit my blog at http://dotnetforeveryone.blogspot.com

                  1 Reply Last reply
                  0
                  Reply
                  • Reply as topic
                  Log in to reply
                  • Oldest to Newest
                  • Newest to Oldest
                  • Most Votes


                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • World
                  • Users
                  • Groups