setting up native webservices on the internet

All posts relating to Oracle database administration.

Moderator: Tim...

setting up native webservices on the internet

Postby eclipsechaser » Mon Sep 30, 2013 10:26 pm

I read a lot of examples of publishing pl/sql procedures on the internet using native plsql web serice. They all seem to show the database itself listening on port 8080. However a more likely soulution would be the database connected to another machine typically with an app server on it and that connected to the internet. Is there an out of the box way of connecting the db via another machine to the internet?


my setup will be

11g db sitting on amazon rds

an ec2 on amazon connected to the internet.



would anyone be able to guide me on this?

thanks
eclipsechaser
Member
 
Posts: 16
Joined: Sun Jun 05, 2005 11:47 am

Re: setting up native webservices on the internet

Postby Tim... » Tue Oct 01, 2013 7:26 am

Hi.

I would just put a reverse proxy or load balancer directly in front of it, to give you a secure HTTPS termination in front of the database.

http://www.oracle-base.com/articles/mis ... ration.php

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17957
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: setting up native webservices on the internet

Postby eclipsechaser » Tue Oct 01, 2013 10:18 am

much obliged. Will check out how to do that in amazon ec2. Will post back when I have found out.
eclipsechaser
Member
 
Posts: 16
Joined: Sun Jun 05, 2005 11:47 am

Re: setting up native webservices on the internet

Postby Tim... » Tue Oct 01, 2013 11:22 am

Hi.

I'm guessing you could probably fire up a micro instance running Apache...

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17957
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 2 guests