Deploy PL/SQL Web Toolkit on ORDS (Oracle REST Data Services) with Apache Tomcat
1. Download and Install Java SE Development Kit 8u101
http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
rpm -Uvh jdk-8u101-linux-x64.rpm
export JRE_HOME=/usr/java/latest
PS.
If both JRE_HOME and JAVA_HOME are specified, JRE_HOME is used.
2. Download Apache Tomcat and startup the Catalina Server in SSL mode
https://tomcat.apache.org/download-90.cgi
--> /source/apache-tomcat-9.0.0.M10.tar
[oracle@danbrother source]$ tar xvf apache-tomcat-9.0.0.M10.tar
[oracle@danbrother source]$ export CATALINA_BASE=/source/apache-tomcat-9.0.0.M10
|
Please refer to http://danbrother.pixnet.net/blog/post/220420927 |
[oracle@danbrother source]$ cd $CATALINA_BASE/bin
[oracle@danbrother bin]$ ./startup.sh
Using CATALINA_BASE: /source/apache-tomcat-9.0.0.M10
Using CATALINA_HOME: /source/apache-tomcat-9.0.0.M10
Using CATALINA_TMPDIR: /source/apache-tomcat-9.0.0.M10/temp
Using JRE_HOME: /usr/java/latest
Using CLASSPATH: /source/apache-tomcat-9.0.0.M10/bin/bootstrap.jar:/source/apache-tomcat-9.0.0.M10/bin/tomcat-juli.jar
Tomcat started.
3. Download ORDS (Oracle REST Data Services)
http://docs.oracle.com/cd/E56351_01/doc.30/e56293/install.htm#AELIG7217
Download the file ords.version.number.zip from the Oracle REST Data Services download page. See:
http://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/index.html
[root@danbrother sf_Oracle_WebTier_12cR2_(HTTP_Server)]# unzip ords.3.0.6.176.08.46.zip -d /source/ords
[root@danbrother sf_Oracle_WebTier_12cR2_(HTTP_Server)]# chown -R oracle:dba /source/ords
[oracle@danbrother ~]$ sqldeveloper
Tools --> REST Data Services -> Install
Click Verify to verify database user:
[oracle@danbrother ords]$ cp -p /source/ords/ords.war /source/apache-tomcat-9.0.0.M10/webapps/
Initializing ORDS by:
https://127.0.0.1:8443/ords
Test the PL/SQL Web Toolkit:
create or replace procedure web_admin.hello_world
is
begin
htp.p('<font color="red">');
htp.p('Hello World! </font><br><br>');
htp.p('<font color="blue">PL/SQL Web Tookit on ORDS is working!</font>');
htp.p('</font>');
end;
/
create synonym web_user.hello_world for web_admin.hello_world;
grant execute on web_admin.hello_world to web_user;
https://127.0.0.1:8443/ords/hello_world
