RAC One Node Database And HTTP Endpoint (XMLDB)

(Doc ID 2344527.1)

Last updated on JANUARY 03, 2018

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Goal

A Rac One Node database is running on a 2 node cluster.

The HTTP endpoint is configured for the database:

a)
select DBMS_XDB.GETHTTPPORT from dual;
8080

b)
$ lsnrctl status LISTENER|grep 8080
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<host>)(PORT=8080))(Presentation=HTTP)(Session=RAW))

c)
# netstat -nltp|grep 8080
tcp 0 0 0.0.0.0:8080 0.0.0.0:* LISTEN 28453/tnslsnr


What address should the client use to connect to HTTP port 8080 (webservice, SOAP)? When RAC One Node database instance is running on one of the nodes?  The local listener process is listening on 8080 port, but there is no process on the other node that listens on 8080 port which prevents SCAN addresses from being used.

Does a VIP need to be created for the HTTP service that will follow RAC One Node database instance in the case of relocation or failover? 
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms