ORA-00001: Unique constraint violated

if SELINUX is activated then

chcon -R --reference=/var/www /var/www/apex/images

Hi Morten,

Thank you for saving me -and likely other people as well- lots of time figuring out all these details. Great job!

Extra tip for other readers: don't be stubborn like me to choose ORDS 3.0 instead of 2.0.10 for now. Using 3.0 will lead to a 404 with the top line of the Java stack saying "oracle.dbtools.http.errors.NotFoundException"

Regards,
Rob.

Thank you for this awesome tutorial.
I got it working with Tomcat 8 and ORDS 3.0 - with some modifications of course.

Best Regards!
Kai

Thanks for these great notes.

In my case, Centos7 required libaio - this was easily fixed with the "yum install libaio -y" command

rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm
error: Failed dependencies:
libaio >= 0.3.104 is needed by oracle-xe-11.2.0-1.0.x86_64

Thanks for this tutorial!
Please tell me what adjustments need to be made to make it working with ORDS 3.0.2?
Thanks in advance

Thanks for this tutorial!

Could you please tell my how to get this system running with the latest ORDS 3.0.2 and tomcat 8 (java jdk 8.66) installed?
Requesting /ords leads to a 404 http error.
Thanks in advance.

two things in your tutorial concerning the server ports are not quite clear to me:

1) Tomcat is configured for port 8090, but the default port offered by the ords
installation is 8080!?
2) The Apex port in the Apache configuration is 8009 - is this a typo??

it's a miracle to me - please help!

Thanks in Advance
Peter

@Peter: To clarify regarding the port numbers:

* Port 80: Apache listens on this port. This is the standard port for HTTP requests.

* Port 443: Apache listens on this port if you have enabled SSL. This is the standard port for HTTPS requests.

* Port 8080: This is the default port for the Embedded PL/SQL Gateway (aka DBMS_EPG). The EPG should not be used in production deployments, and should be disabled.

* Port 8090: In this tutorial, Tomcat is set up to use port 8090, since the default for Tomcat is port 8080, and this would conflict with EPG. It is explained in the article: "To avoid conflicts with Oracle XE running the Embedded PL/SQL Gateway on port 8080, change Tomcat's default port number to 8090 by editing the server.xml file. (Note: Because we will put Apache in front of Tomcat, we won't ever access Tomcat directly on port 8090, and we will soon disable EPG, but let's just avoid possible conflicts anyway by assigning different ports.)"

* Port 8009: This is not a typo. This is the port used by Tomcat to talk to the Apache server via the AJP protocol. Port number 8009 is the default for the AJP protocol in Tomcat. We therefore add this port number to the Apache configuration so it knows which port it should talk with Tomcat on. All traffic to Apache for the "/ords" folder will be redirected to Tomcat on port 8009.

Remember that the only ports that should be open in the firewall to the outside world is port 80 (for http) and port 443 (for https). And since you need to be able to login via ssh to administer the machine, you need to open port 22 (or whatever port you have assigned for ssh), but for this port you could also set additional restrictions such as only allowing certain IP addresses to login via ssh.

- Morten

Hi Morten.
What should i chage in apex.conf http config file to get url redirect from my domain to apex?

Example: I enter example.com in url, and it's redirected to https://example.com/apex/

I tried to add this at begin, but not working:

DocumentRoot "/var/www/html/"
ServerName example.com

Redirect / https://example.com/apex/

Thanks

@Nikola: Try the following, it should redirect any request on the root website on port 80 to the full URL (such as an APEX application, if desired).

# forward root to default website
RedirectMatch 302 ^/$ https://www.example.com/ords/f?p=100

- Morten

Hey!, I'm getting an error when i try to open ip_address/ords/apex and ip_address/ords after all the steps, AuthConfigFactory error: java.lang.reflect.InvocationTargetException

Any idea on what it could be?

@Hugo: I would check the Tomcat log (/logs/catalina.out) for any errors first. Then perhaps enable debug error messages to screen in ORDS as described here: https://docs.oracle.com/cd/E37099_01/doc.20/e25066/trouble.htm#AELIG7207

- Morten

Hi Morton,
great cookbook. it enabled me to get the ords in connection with tomcat and apache up and running very quick.
what confuses me and what took the most time to figure out is the defintion of the image directory.
on my windows box i have to define it like that Alias /i/ "D:\Temp\apex\apex_5.1.1\apex\images/"
including the trailing "/" otherwise i will get "GET /i/css/apex_ui.min.css?v=5.1.1.00.08 HTTP/1.1" 404 .... in the sccess log.
do you know the reason or is that just an odd behavior of windows-apache

greetings
peter

- just to get follow up mails ;-)

@Peter: The Apache docs (https://httpd.apache.org/docs/trunk/platform/windows.html) have this to say about the slashes: "The directives that accept filenames as arguments must use Windows filenames instead of Unix ones. However, because Apache may interpret backslashes as an "escape character" sequence, you should consistently use forward slashes in path names, not backslashes."

- Morten

Hi.
With java -jar ords.war install advanced, I can configure my remote database connection with port 1521. But how do I configure the ords connection to an SSL Listener via port 2484 with oracle wallet?

@Sergei: Perhaps somebody on the ORDS discussion forum can help you with advanced ORDS setup:

https://community.oracle.com/community/database/developer-tools/oracle_rest_data_services/content

- Morten

Hello!

Great tutorial!

In section # enable client caching of static content

Will performance improve with
FileETag none ?

Best regards Ola

Hello Morten

Great tutorial for the steps to learn Linux basics and APEX with Secure Apache Web Server install.

Instead of DigitalOcean, I provisioned my Cloud server using Upcloud.com CentOS 6.9. https://www.upcloud.com/vs/digitalocean/

After completing Part Two: Installation I can access the initial APEX Designer page using my server IP address and url :

http://83.136.255.138/ords/apex

I really want to access it using my server name

http://bsd.com/ords/apex

...but receive error : server IP address could not be found.

My hosts file entry is :

83.136.255.138 bsd.com bsd.com

Any assistance regarding server name access @Morten? or anybody else with successful installation?

Kind Regards
Ade

@Ade: To use a domain name instead of your IP address, you must own/control the domain name, and you typically use a control panel at the provider where you bought the domain name to map it against an IP address. Ask you domain name provider for the specifics.

- Morten

	# install Oracle XE 11g on CentOS

	# assumes the installation file has already been copied to /u01/download

	# create Oracle user and groups
	groupadd oinstall
	groupadd dba
	useradd -g oinstall -G dba,oinstall oracle
	chown -R oracle:oinstall /u01

	# change the password
	passwd oracle

	# unzip the installation files
	cd /u01/download
	unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
	cd /u01/download/Disk1

	# run installation
	rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm

	# run the configuration script
	# accept the defaults (unless you know what you are doing!)
	/etc/init.d/oracle-xe configure

	# setup Oracle environment in bash profile to be able to access sqlplus from anywhere

	# http://stackoverflow.com/questions/16823591/how-to-add-lines-to-end-of-file-linux
	# this adds the Oracle environment variables to the "oracle" user, but you may also want to add it to root or any other users
	echo '. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh' >> /home/oracle/.bash_profile

	# initial test of Oracle XE database after install

	# become the "oracle" user
	su - oracle

	# connect to database
	sqlplus /nolog
	connect sys as sysdba

	-- basic query to see stuff working
	select sysdate, sys_context('userenv', 'server_host') from dual;

	-- check components and versions
	select comp_id, version, status
	from dba_registry;

	-- check users
	select username, account_status
	from dba_users
	order by 1;

	# install Oracle Java JDK
	# see http://stackoverflow.com/questions/20901442/how-to-install-jdk-in-centos

	# remove OpenJDK
	yum remove java*

	# assume .rpm file is already copied to /u01/download
	cd /u01/download
	rpm -ivh jdk-7u79-linux-x64.rpm

	# see the java_env.sh script for how to add the Java environment to the bash profile

	# check the java version installed
	java -version

	# setup Java environment in bash profile to be able to access java from anywhere

	# http://stackoverflow.com/questions/16823591/how-to-add-lines-to-end-of-file-linux
	# http://www.davidghedini.com/pg/entry/install_tomcat_7_on_centos
	echo "JAVA_HOME=/usr/java/latest" >> /root/.bash_profile
	echo "export JAVA_HOME" >> /root/.bash_profile
	echo "PATH=$JAVA_HOME/bin:$PATH" >> /root/.bash_profile
	echo "export PATH" >> /root/.bash_profile

ORA-00001: Unique constraint violated

Monday, June 15, 2015

Installing Oracle XE, ORDS and Apex on CentOS - Part Two: Installation

Installing Oracle XE

Installing Java

Installing Tomcat

Installing ORDS

Installing Apache

Installing (upgrading to) latest Apex version

20 comments:

	# download and install Tomcat

	cd /u01/download

	# see https://tomcat.apache.org/download-70.cgi for latest version
	wget "http://www.eu.apache.org/dist/tomcat/tomcat-7/v7.0.64/bin/apache-tomcat-7.0.64.zip"

	# copy file and unzip it
	cp apache-tomcat-7.0.64.zip /usr/share/apache-tomcat-7.0.64.zip
	cd /usr/share
	mkdir tomcat7
	unzip apache-tomcat-7.0.64.zip -d tomcat7

	# make a symbolic link so we can reference the latest version using /latest instead of a specific version
	cd /usr/share/tomcat7
	ln -s apache-tomcat-7.0.64 latest

	# create tomcat group and user
	groupadd tomcat
	useradd -s /bin/bash -g tomcat tomcat
	chown -Rf tomcat:tomcat /usr/share/tomcat7/apache-tomcat-7.0.64/

	# set password
	passwd tomcat

	<Connector port="8090" protocol="HTTP/1.1"
	connectionTimeout="20000"
	maxThreads="400"
	compression="on"
	compressableMimeType="text/html,text/xml,text/plain,text/css,text/javascript"
	redirectPort="8443"
	server="whateverFakeName"
	URIEncoding="UTF-8" />

	#!/bin/bash
	# description: Tomcat Start Stop Restart
	# processname: tomcat
	# chkconfig: 234 20 80
	JAVA_HOME=/usr/java/latest
	export JAVA_HOME
	PATH=$JAVA_HOME/bin:$PATH
	export PATH
	CATALINA_HOME=/usr/share/tomcat7/latest

	case $1 in
	start)
	/bin/su tomcat $CATALINA_HOME/bin/startup.sh
	;;
	stop)
	/bin/su tomcat $CATALINA_HOME/bin/shutdown.sh
	;;
	restart)
	/bin/su tomcat $CATALINA_HOME/bin/shutdown.sh
	/bin/su tomcat $CATALINA_HOME/bin/startup.sh
	;;
	esac
	exit 0

	# assumes you have created a service script at /etc/init.d/tomcat

	cd /etc/init.d/

	# make the script executable
	chmod 755 tomcat

	# set to start at boot time
	chkconfig --add tomcat
	chkconfig --level 234 tomcat on

	# verify it
	chkconfig --list tomcat

	# start tomcat
	service tomcat start

	# note: this gave error "Cannot find /usr/share/tomcat7/latest/bin/catalina.sh
	# The file is absent or does not have execute permission"
	# see http://louis-sawtell.com/content/tomcat-cannot-find-bincatalinash
	cd /usr/share/tomcat7/latest/bin
	chmod +x *.sh
	chmod +x *.jar

	# stop tomcat
	service tomcat stop

	# restart tomcat
	service tomcat restart

	# check logfile and look for any errors
	cat /usr/share/tomcat7/latest/logs/catalina.out

	# install Oracle Rest Data Services (ORDS)

	# assumes you have already downloaded ORDS from the Oracle website
	# and copied the ORDS zip file to the server

	# unzip the files, and move them into a dedicated directory
	cd /u01/download
	mkdir ords210
	unzip ords.2.0.10.289.08.09.zip -d ords210
	mv /u01/download/ords210 /u01/ords

	# Run the ORDS configuration before deployment
	cd /u01/ords
	java -jar ords.war

	# the ORDS configuration "wizard" will now start
	# when prompted for ORDS configuration directory, enter /u01/ords/config
	# then provide the necessary connection info (server, port, sid, passwords, etc)
	# the values get stored in /u01/ords/config/defaults.xml and may be modified there

	# IMPORTANT: "RESTful Services" is required by Apex 5,
	# so enable this by specifying passwords for the APEX_LISTENER and APEX_REST_PUBLIC_USER when prompted

	# for a DEV environment, open the config file and set "debug.printDebugToScreen" to "true" to get detailed errors on screen
	# for a production environment, this setting should be left as "false"

	# the "tomcat" user (created as part of Tomcat install) needs write access to the /config/ folder
	chown -R tomcat:tomcat /u01/ords/config

	# copy the .war into the webapps folder
	cp ords.war /usr/share/tomcat7/latest/webapps/ords.war
	# restart Tomcat to deploy the .war
	service tomcat restart

	# if using Tomcat standalone, copy the Apex image files to Tomcat "i" folder
	# NOTE: no need to do this if using Apache as web server in front of Tomcat
	# cp -r /u01/download/apex/images /usr/share/tomcat7/latest/webapps/i/

	# install Apache on CentOS
	# see https://www.linode.com/docs/websites/apache/apache-2-web-server-on-centos-6

	# install
	yum install httpd -y

	# start the server
	service httpd start

	# set to start automatically on boot
	chkconfig httpd on

	# customized Apache configuration
	# add this to the end of /etc/httpd/conf/httpd.conf
	# or put it in a separate file such as /etc/httpd/conf.d/apex.conf

	# disable sensitive version info
	ServerSignature Off
	ServerTokens Prod

	# standard alias for Apex image files
	Alias /i/ "/var/www/apex/images/"

	# forward dynamic (ORDS) requests to Tomcat
	<VirtualHost *:80>
	ProxyRequests Off
	ProxyPreserveHost On
	<Proxy *>
	Order deny,allow
	Allow from all
	</Proxy>
	ProxyPass /ords ajp://localhost:8009/ords
	ProxyPassReverse /ords ajp://localhost:8009/ords
	</VirtualHost>

	# enable compression of static content
	<IfModule mod_deflate.c>
	SetOutputFilter DEFLATE
	AddOutputFilterByType DEFLATE text/plain text/html text/xml text/css text/javascript
	</IfModule>

	# enable client caching of static content
	<IfModule mod_expires.c>
	ExpiresActive On
	ExpiresByType image/gif "access plus 7 days"
	ExpiresByType image/jpeg "access plus 7 days"
	ExpiresByType image/png "access plus 7 days"
	ExpiresByType text/css "access plus 7 days"
	ExpiresByType text/javascript "access plus 7 days"
	ExpiresByType application/javascript "access plus 7 days"
	ExpiresByType application/x-javascript "access plus 7 days"
	</IfModule>

	# install (or upgrade) Apex on Oracle XE on CentOS

	# change to the "oracle" user (created as part of XE installation)
	su - oracle

	# assumes you have already copied Apex installation file to server
	cd /u01/download
	unzip apex_5.0.1_en.zip
	cd apex

	# start sqlplus and run the installation script
	sqlplus /nolog

	# connect sys as sysdba

	# -- run the following for a full installation (including the Application Builder)
	# @apexins.sql SYSAUX SYSAUX TEMP /i/
	# -- run the following for a runtime-only installation (for production environments)
	# @apxrtins.sql SYSAUX SYSAUX TEMP /i/

	# check the installation log (last 200 lines)
	tail -n 200 *.log

	# rename the folder so we can have multiple versions downloaded (apex501, apex502, apex60, etc)
	cd /u01/download/
	mv apex apex501

	# now remember to copy the Apex images files into the web server "/i/" folder

	-- run as SYS

	-- set up service profile to avoid expiring passwords
	create profile web_service_profile
	limit password_life_time unlimited;

	alter user apex_public_user profile web_service_profile;
	alter user apex_listener profile web_service_profile;
	alter user apex_rest_public_user profile web_service_profile;

	-- unlock the apex public user and set a password
	alter user apex_public_user account unlock;
	alter user apex_public_user identified by pick_a_password;

	-- remove previous versions of Apex, if desired
	-- drop user apex_040000 cascade;
	-- drop user apex_040100 cascade;
	-- drop user apex_040200 cascade;

	# copy the Apex image files to corresponding Apache web folder
	# assumes you have unzipped the Apex files already
	mkdir -p /var/www/apex/images
	cp -rf /u01/download/apex501/images/ /var/www/apex

	# note: make sure you have set up an Apache alias "/i/" to the /images folder above

	# configure ORDS RESTful Services for Apex
	# see https://docs.oracle.com/cd/E59726_01/install.50/e39144/listener.htm#HTMIG29335

	su - oracle

	cd /u01/download/apex501
	sqlplus /nolog

	connect sys as sysdba
	@apex_rest_config.sql