Skip to Main Content
Forums

APEX

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

APEX installation

2907350Mar 3 2016 — edited Mar 3 2016

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#AELIG7217

in 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

Comments

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

Post Details

Locked on Mar 31 2016
Added on Mar 3 2016
#apex-discussions
0 comments
238 views