Skip to Main Content

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!

Trying to get the APEX Listener to run in standalone mode

alarzabalDec 7 2011 — edited Dec 7 2011
We were having issues try to get APEX Listener running in standalone mode on AIX, but that didn't work. We decided to move to Linux, and now we are getting the issues below on the Linux (Red Hat) box. Any ideas?

Thank you!

[oracle@ban-apex-prod apex_listener]$ java -Dapex.port=8070 -Dapex.images=/home/orale/apex/images -jar apex.war
INFO: Starting: /home/oracle/apex_listener/apex.war
See: 'java -jar apex.war --help' for full range of configuration options
INFO: Extracting to: /tmp/apex
INFO: Using classpath: file:/tmp/apex/apex/____embedded/start.jar:file:/tmp/apex/apex/WEB-INF/lib/xdb-1 1.2.0.jar:file:/tmp/apex/apex/WEB-INF/lib/poi-3.6-20091214.jar:file:/tmp/apex/apex/WEB-INF/lib/apex.jar :file:/tmp/apex/apex/WEB-INF/lib/ojdbc6.jar:file:/tmp/apex/apex/WEB-INF/lib/je-4.0.103.jar:file:/tmp/ap ex/apex/WEB-INF/lib/xmlparserv2-11.2.0.jar:file:/tmp/apex/apex/WEB-INF/lib/ojmisc.jar:file:/tmp/apex/ap ex/WEB-INF/lib/ucp.jar:file:/tmp/apex/apex/WEB-INF/lib/commons-fileupload-1.2.1.jar:
INFO: Starting Embedded Web Container in: /tmp/apex
Dec 7, 2011 4:36:55 PM ____bootstrap.Deployer deploy
INFO: Will deploy application path=/tmp/apex/apex/WEB-INF/web.xml
Dec 7, 2011 4:36:56 PM ____bootstrap.Deployer deploy
INFO: deployed application path=/tmp/apex/apex/WEB-INF/web.xml
Dec 7, 2011 4:36:56 PM com.sun.grizzly.Controller logVersion
INFO: Starting Grizzly Framework 1.9.18-o - Wed Dec 07 16:36:56 EST 2011
INFO: http://localhost:8070/apex started.
Dec 7, 2011 4:37:02 PM com.sun.grizzly.http.servlet.ServletAdapter doService
SEVERE: service exception:
java.lang.IllegalStateException: Not yet initialised
at oracle.dbtools.apex.config.ApexConfig.notInitialized(ApexConfig.java:249)
at oracle.dbtools.apex.config.ApexConfig.getFile(ApexConfig.java:234)
at oracle.dbtools.apex.config.ApexConfig.exists(ApexConfig.java:63)
at oracle.dbtools.apex.admin.AdminManager.populateAdminFieldValues(AdminManager.java:868)
at oracle.dbtools.apex.admin.AdminManager.getFieldMaps(AdminManager.java:841)
at oracle.dbtools.apex.admin.Admin.displayAdminHTML(Admin.java:164)
at oracle.dbtools.apex.admin.Admin.displayAdminPage(Admin.java:147)
at oracle.dbtools.apex.admin.Admin.doGet(Admin.java:50)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at com.sun.grizzly.http.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:195)
at com.sun.grizzly.http.servlet.FilterChainImpl.invokeFilterChain(FilterChainImpl.java:139)
at com.sun.grizzly.http.servlet.ServletAdapter.doService(ServletAdapter.java:376)
at ____bootstrap.SecureServletAdapter.doService(SecureServletAdapter.java:72)
at com.sun.grizzly.http.servlet.ServletAdapter.service(ServletAdapter.java:324)
at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:166)
at com.sun.grizzly.tcp.http11.GrizzlyAdapterChain.service(GrizzlyAdapterChain.java:180)
at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:166)
at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:791)
at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:693)
at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:954)
at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:170)
at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:135)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:102)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:88)
at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)
at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:53)
at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:57)
at com.sun.grizzly.ContextTask.run(ContextTask.java:69)
at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:330)
at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:309)
at java.lang.Thread.run(Thread.java:679)


Dec 7, 2011 4:58:39 PM com.sun.grizzly.http.servlet.ServletAdapter doService
SEVERE: service exception:
oracle.dbtools.rt.service.ServiceLocatorException: There are no services defined
at oracle.dbtools.rt.service.ServiceLocator.acquireAll(ServiceLocator.java:91)
at oracle.dbtools.rt.service.ServiceLocator.acquire(ServiceLocator.java:74)
at oracle.dbtools.rt.service.ServiceLocator.acquire(ServiceLocator.java:85)
at oracle.dbtools.rt.web.HttpEndpointBase.dispatchers(HttpEndpointBase.java:138)
at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:85)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at com.sun.grizzly.http.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:195)
at com.sun.grizzly.http.servlet.FilterChainImpl.invokeFilterChain(FilterChainImpl.java:139)
at com.sun.grizzly.http.servlet.ServletAdapter.doService(ServletAdapter.java:376)
at ____bootstrap.SecureServletAdapter.doService(SecureServletAdapter.java:72)
at com.sun.grizzly.http.servlet.ServletAdapter.service(ServletAdapter.java:324)
at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:166)
at com.sun.grizzly.tcp.http11.GrizzlyAdapterChain.service(GrizzlyAdapterChain.java:180)
at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:166)
at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:791)
at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:693)
at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:954)
at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:170)
at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:135)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:102)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:88)
at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)
at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:53)
at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:57)
at com.sun.grizzly.ContextTask.run(ContextTask.java:69)
at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:330)
at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:309)
at java.lang.Thread.run(Thread.java:679)
This post has been answered by Udo on Dec 7 2011
Jump to Answer

Comments

Dude!

There's no problem to have copies of the same control files in different directories and ideally on different media and independent storage controllers. It's called control file multiplexing and very common.

Yes, you can use the alter system command according to  your needs. There are many examples on the web, For instance: https://oracle-base.com/articles/misc/renaming-or-moving-oracle-files#controlfiles

EdStevens

Sorry, in my quick-scan first read I saw your opening statement:

We have created a new 11gR2 instance on Windows 2012 R2. By mistake

As

We have created a new 11gR2 instance on Windows 2012 R2 by mistake

And thought to myself, "yes, creating it on a Windows machine is certainly a mistake!"

Seriously,though, many would consider installing a new 11g to be a mistake regardless of platform.  It is effectively at end of life, going into sustaining support by the end of this year.

As for your actual question, Oracle doesn't care if the individual file names are the same.  It is using the fully-qualified name (complete directory path) to identify all files.  But from a human management perspective, it seems to make more sense to name them as you want (control01, control02, etc.).  And your procedure is essentially correct.  I say 'essentially' because it is one of several minor variations on the theme, all of which will get you there in the end.  The common theme being 'alter database' to change the entry in the spfile', stop the database, move/rename the file at the OS level, start the database.

EdStevens
Joerg.Sobottka

Yes, it works as you have described it, if you run with spfile. If you run with the old init.ora you need to specify the right names in there, shutdown immediate the database, rename/copy your controlfiles to the right names/places and startup the database again.

That's easy. You could also use rman to mirror the controlfiles, but stay at the easy path...

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 4 2012
Added on Dec 7 2011
1 comment
389 views