apex 5.0 installation
Posted by
Roshan on
Mar 03, 2016; 7:57pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/apex-5-0-installation-tp648.html
EBSR12.2.4
Oracle Linux 6.5
Oracle Database 11gR2
I am installing APEX 5.0.3. the installation completed successfully. When I am installing REST services from
https://docs.oracle.com/cd/E37099_01/doc.20/e25066/install.htm#AELIG7217in section 1.4.3, when I am executing java -jar ords.war
it says:
... Verified database prerequisites
Error executing script: ords_verify_tablespace.sql Error: ORA-20005: ERROR: The temporary tablespace TEMP does not exist. An existing tablespace is required for ORDS installation.
ORA-06512: at line 19
ORA-06512: at line 28
Refer to log file /u01/oracle/PREPROD/db/apexTools/REST/logs/ordsinstall_2016-03-04_000910_00294.log for details
I do not have TEMP tablespace but when I create it it says:
SQL> CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'temp05.dbf' SIZE 200M AUTOEXTEND ON;
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'temp05.dbf' SIZE 200M AUTOEXTEND ON
*
ERROR at line 1:
ORA-01543: tablespace 'TEMP' already exists
Find attached the logs
ordsinstall_2016-03-03_235950_00651.logordsinstall_2016-03-04_000910_00294.log