Rishikesh
1) Installation
and Configuration of ORDS.
2)
Installation
Check
3) Uninstallation
of ORDS
Copy
the binaries to the server using WINSCP to the below location on the server.
[oraebsinstance@sym01 apex]$ pwd;hostname
/tmp/apex
sym01.oracomp.com
[oraebsinstance@sym01 apex]$ ls -ltr
total 99736
drwxr-xr-x 3 root root 4096 May 1 10:23 docs
drwxr-xr-x 2 root root 4096 May 1 10:28 params
-rw-r--r-- 1 root root 23806 May 1 10:28 readme.html
drwxr-xr-x 6 root root 4096 May 1 10:28 examples
-rw-r--r-- 1 root dba
55850624 Jun 12 13:36 ords.3.0.0.121.10.23.zip
-rw-r--r-- 1 root root
46105873 Jun 15 07:18 ords.war
drwxrwxr-x 7 oraebsinstance oinstall 4096 Jun 15 10:46 apex
drwxr-xr-x 2 root root 4096 Jun 15 14:39 logs
-rw-r--r-- 1 root root 0 Jun 15 17:07 derby.log
-rw------- 1 root root 8615 Jun 16 10:50 nohup.out
Note:
Installation user is root here.
Command to Installed ORDS
[root@sym01 apex]# java -jar ords.war
install advanced
Verify ORDS schema in Database Configuration apex
Please login with SYSDBA privileges to verify
Oracle REST Data Services schema. Installation may be required.
Enter the username with SYSDBA privileges to verify
the installation [SYS]: Press Enter
Enter the database password for SYS: Password for SYS User
Confirm password: Confirm the SYS Password here
Jun 15, 2015 2:39:13 PM
oracle.dbtools.rt.config.setup.SchemaSetup addSchemaParams
INFO:
Oracle REST Data Services schema does not exist and
will be created.
Enter the default tablespace for ORDS_METADATA
[SYSAUX]: Press Enter
Enter the temporary tablespace for ORDS_METADATA
[TEMP]: Press Enter
Enter the default tablespace for ORDS_PUBLIC_USER
[USERS]: Press Enter
Enter the temporary tablespace for ORDS_PUBLIC_USER
[TEMP]: Press Enter
Jun 15, 2015 2:39:16 PM
oracle.dbtools.installer.Installer installORDS
INFO:
Installing Oracle REST Data Services version
3.0.0.121.10.23
...
Log file written to /tmp/apex/logs/ordsinstall_2015-06-15_143916_00601.log
... Verified database prerequisites
... Created Oracle REST Data Services schema
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database
objects
... Created Oracle REST Data Services proxy user
Jun 15, 2015 2:39:25 PM
oracle.dbtools.installer.Installer installORDS
INFO: Completed installation for Oracle REST Data
Services version 3.0.0.121.10.23. Elapsed time: 00:00:09.292
2015-06-15 14:39:25.867:INFO::main: Logging
initialized @46795ms
2015-06-15 14:39:26.623:INFO:oejs.Server:main:
jetty-9.2.z-SNAPSHOT
2015-06-15
14:39:26.731:INFO:oejsh.ContextHandler:main: Started
o.e.j.s.h.ContextHandler@53f4e2a6{/i,null,AVAILABLE}
2015-06-15 14:39:26.830:INFO:/ords:main: INFO:
Using configuration folder: /u02/ORDS/ords
2015-06-15 14:39:26.831:INFO:/ords:main: FINEST:
|ApplicationContext [configurationFolder=/u02/ORDS/ords, services=Application
Scope]|
Jun 15, 2015 2:39:26 PM oracle.dbtools.common.config.db.DatabasePools
validatePool
INFO: Validating pool: apex
Jun 15, 2015 2:39:26 PM
oracle.dbtools.common.config.db.DatabasePools validatePool
INFO: Pool: apex is correctly configured
Jun 15, 2015 2:39:26 PM
oracle.dbtools.common.config.db.DatabasePools validatePool
INFO: Validating pool: apex_al
Jun 15, 2015 2:39:26 PM
oracle.dbtools.common.config.db.DatabasePools validatePool
INFO: Pool: apex_al is correctly configured
Jun 15, 2015 2:39:26 PM
oracle.dbtools.common.config.db.DatabasePools validatePool
INFO: Validating pool: apex_pu
Jun 15, 2015 2:39:26 PM
oracle.dbtools.common.config.db.DatabasePools validatePool
INFO: Pool: apex_pu is correctly configured
Jun 15, 2015 2:39:26 PM
oracle.dbtools.common.config.db.DatabasePools validatePool
INFO: Validating pool: apex_rt
Jun 15, 2015 2:39:26 PM
oracle.dbtools.common.config.db.DatabasePools validatePool
INFO: Pool: apex_rt is correctly configured
2015-06-15 14:39:27.130:INFO:/ords:main: INFO:
Oracle REST Data Services initialized|Oracle REST Data Services version :
3.0.0.121.10.23|Oracle REST Data Services server info: jetty/9.2.z-SNAPSHOT|
2015-06-15
14:39:27.133:INFO:oejsh.ContextHandler:main: Started
o.e.j.s.ServletContextHandler@66b21aae{/ords,null,AVAILABLE}
2015-06-15 14:39:27.153:INFO:oejs.ServerConnector:main:
Started ServerConnector@25bde0f0{HTTP/1.1}{0.0.0.0:8889}
2015-06-15 14:39:27.154:INFO:oejs.Server:main:
Started @48085ms
Jun 15, 2015 2:40:21 PM
oracle.dbtools.common.config.db.DatabasePools createPool
INFO: Configuration properties for: apex_pu
Jun 15, 2015 2:40:21 PM
oracle.dbtools.common.config.db.DatabasePools listConfiguration
INFO: cache.caching=false
cache.directory=/tmp/apex/cache
cache.duration=days
cache.expiration=7
cache.maxEntries=500
cache.monitorInterval=60
cache.procedureNameList=
cache.type=lru
db.hostname=sym01.oracomp.com
db.port=1521
db.sid=ORACLEEBSINSTANCE
debug.debugger=false
debug.printDebugToScreen=false
error.keepErrorMessages=true
error.maxEntries=50
jdbc.DriverType=thin
jdbc.InactivityTimeout=1800
jdbc.InitialLimit=3
jdbc.MaxConnectionReuseCount=1000
jdbc.MaxLimit=10
jdbc.MaxStatementsLimit=10
jdbc.MinLimit=1
jdbc.statementTimeout=900
log.logging=false
log.maxEntries=50
misc.compress=
misc.defaultPage=apex
security.crypto.enc.password=******
security.crypto.mac.password=******
security.disableDefaultExclusionList=false
security.maxEntries=2000
db.password=******
db.username=ORDS_PUBLIC_USER
Jun 15, 2015 2:40:21 PM
oracle.dbtools.common.config.db.ConfigurationValues log
WARNING: *** jdbc.MaxLimit in configuration apex_pu
is using a value of 10, this setting may not be sized adequately for a
production environment ***
Jun 15, 2015 2:40:21 PM
oracle.dbtools.common.config.db.ConfigurationValues log
WARNING: *** jdbc.InitialLimit in configuration
apex_pu is using a value of 3, this setting may not be sized adequately for a
production environment ***
Jun 15, 2015 2:40:21 PM
oracle.ucp.common.UniversalConnectionPoolBase
initInactiveConnectionTimeoutTimer
INFO: inactive connection timeout timer scheduled
Jun 15, 2015 2:40:21 PM oracle.dbtools.common.config.db.DatabasePools
createPool
INFO: Configuration properties for: apex_al
Jun 15, 2015 2:40:21 PM
oracle.dbtools.common.config.db.DatabasePools listConfiguration
INFO: cache.caching=false
cache.directory=/tmp/apex/cache
cache.duration=days
cache.expiration=7
cache.maxEntries=500
cache.monitorInterval=60
cache.procedureNameList=
cache.type=lru
db.hostname=sym01.oracomp.com
db.port=1521
db.sid=ORACLEEBSINSTANCE
debug.debugger=false
debug.printDebugToScreen=false
error.keepErrorMessages=true
error.maxEntries=50
jdbc.DriverType=thin
jdbc.InactivityTimeout=1800
jdbc.InitialLimit=3
jdbc.MaxConnectionReuseCount=1000
jdbc.MaxLimit=10
jdbc.MaxStatementsLimit=10
jdbc.MinLimit=1
jdbc.statementTimeout=900
log.logging=false
log.maxEntries=50
misc.compress=
misc.defaultPage=apex
security.crypto.enc.password=******
security.crypto.mac.password=******
security.disableDefaultExclusionList=false
security.maxEntries=2000
db.password=******
db.username=APEX_LISTENER
Jun 15, 2015 2:40:21 PM oracle.dbtools.common.config.db.ConfigurationValues
log
WARNING: *** jdbc.MaxLimit in configuration apex_al
is using a value of 10, this setting may not be sized adequately for a
production environment ***
Jun 15, 2015 2:40:21 PM
oracle.dbtools.common.config.db.ConfigurationValues log
WARNING: *** jdbc.InitialLimit in configuration
apex_al is using a value of 3, this setting may not be sized adequately for a
production environment ***
Jun 15, 2015 2:40:21 PM
oracle.ucp.common.UniversalConnectionPoolBase initInactiveConnectionTimeoutTimer
INFO: inactive connection timeout timer scheduled
Jun 15, 2015 2:40:21 PM
oracle.dbtools.common.config.db.DatabasePools createPool
INFO: Configuration properties for: apex
Jun 15, 2015 2:40:21 PM
oracle.dbtools.common.config.db.DatabasePools listConfiguration
INFO: cache.caching=false
cache.directory=/tmp/apex/cache
cache.duration=days
cache.expiration=7
cache.maxEntries=500
cache.monitorInterval=60
cache.procedureNameList=
cache.type=lru
db.hostname=sym01.oracomp.com
db.port=1521
db.sid=ORACLEEBSINSTANCE
debug.debugger=false
debug.printDebugToScreen=false
error.keepErrorMessages=true
error.maxEntries=50
jdbc.DriverType=thin
jdbc.InactivityTimeout=1800
jdbc.InitialLimit=3
jdbc.MaxConnectionReuseCount=1000
jdbc.MaxLimit=10
jdbc.MaxStatementsLimit=10
jdbc.MinLimit=1
jdbc.statementTimeout=900
log.logging=false
log.maxEntries=50
misc.compress=
misc.defaultPage=apex
security.crypto.enc.password=******
security.crypto.mac.password=******
security.disableDefaultExclusionList=false
security.maxEntries=2000
db.password=******
db.username=APEX_PUBLIC_USER
Jun 15, 2015 2:40:21 PM
oracle.dbtools.common.config.db.ConfigurationValues log
WARNING: *** jdbc.MaxLimit in configuration apex is
using a value of 10, this setting may not be sized adequately for a production
environment ***
Jun 15, 2015 2:40:21 PM
oracle.dbtools.common.config.db.ConfigurationValues log
WARNING: *** jdbc.InitialLimit in configuration
apex is using a value of 3, this setting may not be sized adequately for a
production environment ***
Jun 15, 2015 2:40:21 PM
oracle.ucp.common.UniversalConnectionPoolBase
initInactiveConnectionTimeoutTimer
INFO: inactive connection timeout timer scheduled
Below Command is used to create the User
from Backend and reset the password.
Make the SYSDBA Connection and
execute the below script.
Like
admin3 user you will be able to make number of users here.
begin
wwv_flow_api.set_security_group_id(p_security_group_id=>10);
wwv_flow_fnd_user_api.create_fnd_user(
p_user_name
=> 'admin3',
p_email_address => 'dev@null.com',
p_web_password => 'admin3') ;
end;
/
commit
/
Installation Check and URL
Uninstallation
of ORDS.
[root@sym01 apex]# java -jar ords.war uninstall
Enter the name of the database server [sym01.oracomp.com]:
Enter the database listen port [1521]:
Enter the database SID [ORACLEEBSINSTANCE]:
Please login with SYSDBA privileges to verify
Oracle REST Data Services schema. Installation may be required.
Enter the username with SYSDBA privileges to verify
the installation [SYS]:
Enter the database password for SYS:
Confirm password:
Jun 15, 2015 2:25:34 PM
oracle.dbtools.installer.Installer uninstallORDS
INFO:
Uninstall Oracle REST Data Services
... Log file written to
/tmp/apex/logs/ordsuninstall_2015-06-15_142534_00508.log
Jun 15, 2015 2:25:47 PM
oracle.dbtools.installer.Installer uninstallORDS
INFO: Completed uninstall for Oracle REST Data
Services. Elapsed time: 00:00:12.650
Posted in: ORDS
0 comments:
Post a Comment