apex 5.0 installation

[Roshan]

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

Find attached the logs

ordsinstall_2016-03-03_235950_00651.log
ordsinstall_2016-03-04_000910_00294.log

[ErmanArslansOracleBlog]

 select tablespace_name from dba_tablespaces; to check the TEMP tablespace.

Maybe you already  have a TEMP tablespace named TEMP but there is no tempfiles on it.
Add tempfiles to your TEMP tablespace and retest.

[Roshan]

When I do SQL> select tablespace_name from dba_tablespaces;
TEMP tablespace is not present. Below is the result:

TABLESPACE_NAME
------------------------------
SYSTEM
CTXD
OWAPUB
TEMP1
ODM
PORTAL
APPS_UNDOTS1
APPS_TS_TX_DATA
APPS_TS_TX_IDX
APPS_TS_SEED
APPS_TS_INTERFACE

TABLESPACE_NAME
------------------------------
APPS_TS_SUMMARY
APPS_TS_NOLOGGING
APPS_TS_ARCHIVE
APPS_TS_QUEUES
APPS_TS_MEDIA
OLAP
SYSAUX
APPS_TS_TOOLS
TEMP2
APEX
APEX_FILES

when I do:
SQL> SELECT PROPERTY_NAME, PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE
   PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

I gives me:
PROPERTY_NAME
------------------------------
PROPERTY_VALUE
--------------------------------------------------------------------------------
DEFAULT_TEMP_TABLESPACE
TEMP

[ErmanArslansOracleBlog]

You have a temp tbs group consists of temp1 and temp2 . check from dba_tablespace_groups.

Add tempfile to temp1 and temp2 , if they dont have one

4 Mar 2016 05:28 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

When I do SQL> select tablespace_name from dba_tablespaces;
TEMP tablespace is not present. Below is the result:

TABLESPACE_NAME
------------------------------
SYSTEM
CTXD
OWAPUB
TEMP1
ODM
PORTAL
APPS_UNDOTS1
APPS_TS_TX_DATA
APPS_TS_TX_IDX
APPS_TS_SEED
APPS_TS_INTERFACE

TABLESPACE_NAME
------------------------------
APPS_TS_SUMMARY
APPS_TS_NOLOGGING
APPS_TS_ARCHIVE
APPS_TS_QUEUES
APPS_TS_MEDIA
OLAP
SYSAUX
APPS_TS_TOOLS
TEMP2
APEX
APEX_FILES

when I do:
SQL> SELECT PROPERTY_NAME, PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE
   PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

I gives me:
PROPERTY_NAME
------------------------------
PROPERTY_VALUE
--------------------------------------------------------------------------------
DEFAULT_TEMP_TABLESPACE
TEMP

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/apex-5-0-installation-tp648p650.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Roshan]

SQL> select tablespace_name from  dba_tablespace_groups;

TABLESPACE_NAME
------------------------------
TEMP1
TEMP2

I have added datafiles on both TEMP1 and TEMP2.

alter tablespace  TEMP1 add tempfile    '/u01/oracle/PREPROD/db/data/temp102.dbf' size  50m
reuse autoextend on next   10m maxsize    1000m;

alter tablespace  TEMP2 add tempfile    '/u01/oracle/PREPROD/db/data/temp103.dbf' size  50m
reuse autoextend on next   10m maxsize    1000m;

Still same issue

[Roshan]

Don't you think I have to modify  ords_verify_tablespace.sql to point to another tablespace?

[ErmanArslansOracleBlog]

Send me that script

4 Mar 2016 07:47 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Don't you think I have to modify  ords_verify_tablespace.sql to point to another tablespace?

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/apex-5-0-installation-tp648p653.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Roshan]

I cannot find ords_verify_tablespace.sql. In fact the REST installation I am launching it from a war file.
http://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/index.html

You have to launch it using java -jar ords.war.

https://docs.oracle.com/cd/E37099_01/doc.20/e25066/install.htm#AELIG7021

[Roshan]

I managed to extract the script files:
java -jar ords.war ords-scripts

please find attached
core.rar

[ErmanArslansOracleBlog]

if I could ses the script it would be better but lets apply this workaround. Drop temp "tablespace group" named temp and create a temp "tablespace" called temp and retry.

4 Mar 2016 07:47 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Don't you think I have to modify  ords_verify_tablespace.sql to point to another tablespace?

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/apex-5-0-installation-tp648p653.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Roshan]

o.k I will try. I have already attached it. in the core file

[ErmanArslansOracleBlog]

I see the sql;

It does the control with this statement:

select p_def_tablespace tbs_name from dual
                     where upper(p_def_tablespace) not in
                        (select tablespace_name from sys.dba_tablespaces where tablespace_name = upper(p_def_tablespace)))

So, you can do as I suggested, but you can also change the default temporary tablespace from TEMP to TEMP1 or TEMP2, as it is documented in https://docs.oracle.com/cd/E56351_01/doc.30/e56293/install.htm#AELIG7015 

ords_params.properties file:
Make any desired values to default values to reflect your environment and preferences. If you change any of the tablespace-related values, you must ensure that the tablespaces you specify already exist in the database.

The default ords_params.properties file includes the following:

db.hostname=localhost
db.port=1521
db.servicename=
db.sid=
db.username=APEX_PUBLIC_USER
migrate.apex.rest=false
rest.services.apex.add=
rest.services.ords.add=true
schema.tablespace.default=SYSAUX
schema.tablespace.temp=TEMP --> SO YOU CAN CHANGE THIS TO TEMP1 or TEMP2
standalone.http.port=8080
standalone.mode=true
standalone.static.images=
user.tablespace.default=USERS
user.tablespace.temp=TEMP

[Roshan]

O.k Thank you Sir

[Roshan]

I managed to install REST Data service. I also deployed the ords war file and i.war file. After installation is complete it remained stuck at started. Please find attached screenshot. When I access the URL:
erppreprod.sunresort.local:8080 it gives me "HTTP Error 500 Internal server error"
Capture.PNG
Capture2.PNG

In case I close putty, how can I start REST services?

[ErmanArslansOracleBlog]

500 Internal Server Error When Trying To Access APEX Using ORACLE REST DATA SERVICES (Doc ID 1936160.1)

[Roshan]

Thanks. I am now able to access the login page. however, I deployed the i.war file and ords.war file on Admin server and all managed server. When I am restarting the application system, I am getting cannot start Weblogic. Please find attached the log files. Thanks
Outlook.zip

[ErmanArslansOracleBlog]

Roshan,

I will not analyze the logs file for every error you get.
It is not a good thing for you also. It isnt a good way for learning.
Analyze the logs and read the docs.

Ask me the final question if you will have one.

[ErmanArslansOracleBlog]

As for your question about the deployment, see the document, here it says:


Select the servers and/or clusters to which you want to deploy the application or module and click Next.

Tip:
If you have not created additional Managed Servers or clusters, you do not see this assistant page.

[Roshan]

From this screen, can you please tell me which I should choose. I do not know what I chose last time to deploy ords.war and i.war, when I restarted weblogic it could not start.

Please find attached.

ords.PNG

[ErmanArslansOracleBlog]

I wouldnt use the EBS Weblogic server for Apex. I would go with a new Weblogic server for Apex.

If you are unfamiliar with domains, managed servers, deployment, security, users and roles, refer to your Oracle WebLogic Server documentation.