8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Oracle REST Data Services (ORDS) : Installation on Tomcat


Srinivas said...

Hi,

is it possible to install ORDS without APEX?

Thanks,
Srini

Tim... said...

Hi.

Yes, but you will probably do the config of RESTful web services from APEX, so it's probably not a great idea to set it up without APEX. I guess you could so the config from SQL Developer.

Cheers

Tim...

Laury said...

Hi Tim, vey good page. But I think the last step is not correct. The modification of ords.war to apex.war needs to be done just before doing java -jar ords.war. Then, the war file can be copied to the Tomcat webapps. Cheers.

Tim... said...

Hi Laury.

You are correct. I've altered the article to reflect that. I've also done a run through with the latest versions of ORDS, Java 7 and 8 as well as Tomcat 7 and 8.

Cheers

Tim...

Peter said...

Hello, thank you for you post, it is very useful!!

One question, is possible to install in tomcat 6.x?

Regards


Tim... said...

Hi.

The documentation says Tomcat 7. I tried Tomcat 8 and it worked, though the documentation doesn't suggest it.

I doubt Tomcat 6 was considered as it is extremely old now.

Cheers

Tim...

Peter said...

Hi Tim, I'm running APEX 5.x on tomcat 6 and Tomcat 9 following your step tutorial. It work !!!

Thank you again for you very useful post..

Peter

Tim... said...

Hi.

I've added a comment to the article to reflect what you said. :)

Cheers

Tim...

Peter Olumolu said...

Got this error while trying to install
ORA-12705: Cannot access NLS data files or invalid environment specified
any help?

Tim... said...

Hi.

Never seen that before. I would suggest uninstalling and trying again from a fresh download. I did a 3.0.8 installation a few days ago and it went fine.

Cheers

Tim...

Sasha said...

2Peter Olumolu: check access to db with Your account info from parameters sys.user=SYS and sys.password=OraPassword1

Tim, would You explain a parameter plsql.gateway.add=true? I it significant fot APEX-ORDS case?

Tim... said...

Hi.

Yes. You have to make sure your passwords are set correctly and accounts are unlocked.

plsql.gateway.add determines if you want to configure the APEX_PUBLIC_USER user for the embedded PL/SQL gateway. I always set this to true on DBs with APEX installed.

Cheers

Tim...

Sasha said...

Tim, do You have experience with Java 9 and ords 3.0.12 errors? I mean some specific java class errors (i don't understand details in fact) on step "$JAVA_HOME/bin/java -jar ords.war configdir /u01/ords/conf" so ords is not installed. Just Java 8 solve it. But it's not good retreat...

Tim... said...

Hi.

If I remember correctly, Java 9 support will start with version 17 (currently 17.3 beta).

http://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/ords-relnotes-173-3873542.html

Cheers

Tim...

Sasha said...

You are definitely right. Thank You. Still wondering about version enumeration. It seems 3.0.12 to be the latest release... 17 is still in beta.

Sasha said...

By the way, what is the /webapps/params/ folder that ords.war automaticaly create after deploying? Is this correct behavoiur? Still 3.0.9 doesn't have it...

Tim... said...

Hi.

Oracle are moving to yearly release number for all products including ORDS and the database. If ORDS is delayed much more it will be 18.0.

Not really looked much under the webapps directory.

Cheers

Tim...

Pierre said...

Hi TIm,
we have install Ords 17.x on Tomcat. It worked very well. After restart Tomcat, Ords is now not accessible. You said that "ORDS is started or stopped by starting or stopping the Tomcat instance it is deployed to. Assuming you have the CATALINA_HOME environment variable set correctly, the following commands should be used." But is not true. How to restart Ords? We have Ords 17.x on Linux.

Tim... said...

Hi.

If you have ORDS on Tomcat, it is definitely the Tomcat stop/start that controls the ORDS stop/start. It's like any other Java app running on Tomcat. Check the "$CATALINA_HOME/logs/" directory. The logs there may contain errors that will show why ORDS is not working.

If you are using standalone mode, then Tomcat is nothing to do with ORDS.

Cheers

Tim...

Pierre said...

Hi Tim,
the log show me: 13-Feb-2018 17:17:27.930 WARNING [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [ords] appears to have started a thread named [Timer-76100] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread. Is here the issue?

Regards

Pierre said...

Hi Tim,
i have that Error too
The web application [ords] registered the JDBC driver [oracle.jdbc.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

Regards

Tim... said...

Hi.

I get a load of ORDS startup messages. The first time I call a service it then gives me more information about the connection pool startup. We use ORDS on Tomcat instances for APEX apps and web services.

I can only assume you have some configuration problem. Redo it and see what happens. It's safe to redo the config. You won't lose service definitions in the DB.

Cheers

Tim...

Sasha said...

Just one cent to Tim's heap of knowledge.

After *each* updating ords.war version we should run java -jar ords.war It's update db part of ords installation and may be vilally for project working state.

Sasha said...

Hi, Tim!

I'm wondering how i can setup/verify ORDS by running java -jar ords.war under user with sysdba privilegies but not SYS?
I've been trying ./params/ords_params.properties with sys.user=MYUSER, but it doesn't work.

Appreciate for ideas!

Tim... said...

Hi.

I'm not sure if that is possible. I guess the best thing to do is the ask the question in an SR, or in the Oracle forum. I know the ORDS PMs answer questions in the ORDS forum there.

Cheers

Tim...

Peter said...

Hi Tim
Setting the configdir with "$JAVA_HOME/bin/java -jar ords.war configdir /u01/ords/conf" creates a separate ords folder at this position.
As I am using /etc/ords for the config files, I execute "$JAVA_HOME/bin/java -jar ords.war configdir /etc". This will modifies the .war file to look at /etc/ords/ for the configuration files.
Done with ORDS 18.2 and java 1.8.0_181 on ol7.5.

Tim... said...

Hi.

I prefer to keep it another layer down. In your example, the defaults.xml file is the /etc/ords directory, with the rest of the config in the /etc/ords/conf directory. I just like everything to sit under an explicit conf location, even if it adds repeat dirs. Just a preference.

I wouldn't put it in /etc/, but once again, just a preference.

Cheers

Tim...

Tim... said...

Hi.

Not that it makes a difference, but I just checked a few other people's things. All the ones I found install under a conf directory, similar to me, including Colm Divilly from the ORDS team. At the end of the day it doesn't matter, so do what you prefer. :)

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.