This forum is currently locked. You can't register or post questions at this time. (read more)

setting up native webservices on the internet

All posts relating to Oracle database administration.

Moderator: Tim...

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

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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

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

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.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 7 guests

cron