ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

http://localhost:8888/ords/ apex listener 503 service unavailable on ora11gr2 RAC

ghassanAlTJan 11 2015 — edited Jan 20 2015

i got

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

i upgrade apex from 3.2 to 4.2.6 then install and configure ORDS (formally apex listener)

my java version :

[root@node1 ~]# java -version

java version "1.7.0_65"

OpenJDK Runtime Environment (rhel-2.5.1.2.0.1.el6_5-x86_64 u65-b17)

OpenJDK 64-Bit Server VM (build 24.65-b04, mixed mode)

when i run (java - jar ords.war) the result is :

[oracle@node1 ~]$ java -jar ords.war

Jan 11, 2015 5:19:23 PM oracle.dbtools.standalone.Standalone execute

INFO: NOTE:

Standalone mode is designed for use in development and test environments. It is not supported for use in production environments.

Jan 11, 2015 5:19:23 PM oracle.dbtools.standalone.Standalone execute

INFO: Starting standalone Web Container in: /ora01/app/oracle/product/11.2.0/rest/ords

Jan 11, 2015 5:19:23 PM oracle.dbtools.standalone.Deployer deploy

INFO: Will deploy application path = /ora01/app/oracle/product/11.2.0/rest/ords/ords/WEB-INF/web.xml

Jan 11, 2015 5:19:24 PM oracle.dbtools.standalone.Deployer deploy

INFO: Deployed application path = /ora01/app/oracle/product/11.2.0/rest/ords/ords/WEB-INF/web.xml

Jan 11, 2015 5:19:25 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder

INFO: Using configuration folder: /ora01/app/oracle/product/11.2.0/rest/ords

Default Database connection not configured properly

Jan 11, 2015 5:19:27 PM oracle.dbtools.rt.web.SCListener contextInitialized

INFO: Oracle REST Data Services initialized

Oracle REST Data Services version : 2.0.10.289.08.09

Oracle REST Data Services server info: Grizzly/1.9.49

Jan 11, 2015 5:19:27 PM com.sun.grizzly.Controller logVersion

INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 1/11/15 5:19 PM

Jan 11, 2015 5:19:27 PM oracle.dbtools.standalone.Standalone execute

INFO: http://localhost:8888/ords/ started.

but when i try to open the URL i got this

Jan 11, 2015 5:19:51 PM oracle.dbtools.rt.web.HttpEndpointBase modApex

SEVERE: The pool named: apex is not correctly configured, error: IO Error: The Network Adapter could not establish the connection

oracle.dbtools.common.jdbc.ConnectionPoolException: The pool named: apex is not correctly configured, error: IO Error: The Network Adapter could not establish the connection

at oracle.dbtools.common.jdbc.ConnectionPoolException.badConfiguration(ConnectionPoolException.java:65)

at oracle.dbtools.common.config.db.DatabaseConfig.badConfiguration(DatabaseConfig.java:209)

at oracle.dbtools.common.config.db.DatabaseConfig.getPool(DatabaseConfig.java:351)

at oracle.dbtools.common.config.db.DatabaseConfig.getPool(DatabaseConfig.java:331)

at oracle.dbtools.common.config.db.DatabaseConfig.access$200(DatabaseConfig.java:44)

at oracle.dbtools.common.config.db.DatabaseConfig$DatabaseFactory.apply(DatabaseConfig.java:385)

at oracle.dbtools.common.config.db.PerThreadConnectionCache$DisposableConnectionFactory.apply(PerThreadConnectionCache.java:239)

at oracle.dbtools.common.config.db.PerThreadConnectionCache$DisposableConnectionFactory.apply(PerThreadConnectionCache.java:223)

at oracle.dbtools.common.util.PerThreadCache.get(PerThreadCache.java:60)

at oracle.dbtools.common.config.db.PerThreadConnectionCache.get(PerThreadConnectionCache.java:49)

at oracle.dbtools.common.config.db.DatabaseConfig.getConnection(DatabaseConfig.java:80)

at oracle.dbtools.common.jdbc.ora.OraPrincipal.connection(OraPrincipal.java:69)

at oracle.dbtools.apex.ModApexContext.getConnection(ModApexContext.java:384)

at oracle.dbtools.apex.OWA.getStatement(OWA.java:542)

at oracle.dbtools.apex.OWA.init(OWA.java:311)

at oracle.dbtools.apex.ModApex.doGet(ModApex.java:90)

at oracle.dbtools.apex.ModApex.service(ModApex.java:301)

at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:350)

at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:132)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.doFilter(ServletAdapter.java:1059)

at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.invokeFilterChain(ServletAdapter.java:999)

at com.sun.grizzly.http.servlet.ServletAdapter.doService(ServletAdapter.java:434)

at oracle.dbtools.standalone.SecureServletAdapter.doService(SecureServletAdapter.java:91)

at com.sun.grizzly.http.servlet.ServletAdapter.service(ServletAdapter.java:379)

at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)

at com.sun.grizzly.tcp.http11.GrizzlyAdapterChain.service(GrizzlyAdapterChain.java:196)

at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)

at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:849)

at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:746)

at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1045)

at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:228)

at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)

at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)

at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)

at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)

at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)

at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)

at com.sun.grizzly.ContextTask.run(ContextTask.java:71)

at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)

at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)

at java.lang.Thread.run(Thread.java:745)

------------------------------

my listener status as this : (lsnctl status - lsnctl service)

LSNRCTL> status

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date 11-JAN-2015 15:28:53

Uptime 0 days 1 hr. 48 min. 26 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /ora01/app/grid/product/11.2.0/grid/network/admin/listener.ora

Listener Log File /ora01/app/oracle/diag/tnslsnr/node1/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.50)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.111)(PORT=1521)))

Services Summary...

Service "+ASM" has 1 instance(s).

Instance "+ASM1", status READY, has 1 handler(s) for this service...

Service "ORA11G.itp310.com" has 1 instance(s).

Instance "ORA11G1", status READY, has 1 handler(s) for this service...

Service "ORA11GXDB.itp310.com" has 1 instance(s).

Instance "ORA11G1", status READY, has 1 handler(s) for this service...

The command completed successfully

LSNRCTL> service

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

Services Summary...

Service "+ASM" has 1 instance(s).

Instance "+ASM1", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:130 refused:0 state:ready

LOCAL SERVER

Service "ORA11G.itp310.com" has 1 instance(s).

Instance "ORA11G1", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:147 refused:0 state:ready

LOCAL SERVER

Service "ORA11GXDB.itp310.com" has 1 instance(s).

Instance "ORA11G1", status READY, has 1 handler(s) for this service...

Handler(s):

"D000" established:0 refused:0 current:0 max:1022 state:ready

DISPATCHER <machine: node1.itp310.com, pid: 4990>

(ADDRESS=(PROTOCOL=tcp)(HOST=node1.itp310.com)(PORT=18334))

The command completed successfully

-----------------------------

my users : SQL> select username,account_status from dba_users;

USERNAME		ACCOUNT_STATUS
FLOWS_FILES		OPEN
APEX_040200		OPEN
ANONYMOUS		OPEN
APEX_LISTENER		OPEN
APEX_PUBLIC_USER		OPEN
APEX_REST_PUBLIC_USER		OPEN

----------------------------------

my defaults.xml : (cat /ora01/app/oracle/product/11.2.0/rest/ords/defaults.xml)

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">

<comment>Saved on Thu Jan 08 21:46:52 EET 2015</comment>

<entry key="cache.caching">false</entry>

<entry key="cache.directory">/tmp/apex/cache</entry>

<entry key="db.hostname">localhost</entry>

<entry key="db.password">@05ED679DC62E338365684748A7EC0ED52450B36CC9FAAEF2AB</entry>

<entry key="debug.debugger">false</entry>

<entry key="debug.printDebugToScreen">false</entry>

<entry key="log.logging">false</entry>

<entry key="security.disableDefaultExclusionList">false</entry>

<entry key="security.verifySSL">false</entry>

</properties>

--------------------------

try to reconfigure : (java -jar ords.war setup)

-Enter the location to store configuration data: /ora01/app/oracle/product/11.2.0/rest

-Enter the name of the database server :localhost

-Enter the database listen port :1521

-Enter 1 to specify the database service name, or 2 to specify the database SID [1]:1

-Enter the database service name:ORA11G.itp310.com

-Enter the database user name [APEX_PUBLIC_USER]: APEX_PUBLIC_USER

-Enter the database password for APEX_PUBLIC_USER: Passw0rd

-Enter 1 to enter passwords for the RESTful Services database users (APEX_LISTENER,APEX_REST_PUBLIC_USER), 2 to use the same password as used for APEX_PUBLIC_USER or, 3 to skip this step: 2

-Enter the APEX static resources location or Enter to skip: /ora01/app/oracle/product/11.2.0/db_1/apex/images

-Enter the HTTP port [8080]: 8888

---------------------------

so any solution ??

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2015

Added on Jan 11 2015

1 comment

2,301 views