ORDS and APEX Setup

OWFR - check for pre-requisites....>install Infra...>install fr binary.....>run RCU .......>setup Domain
Commands that we need to use for setup are given below:

1. java -jar fmw_12.2.1.3.0_infrastructure.jar -silent -responseFile /u01/appl_techs/products/software/inst_proc/infra.rsp -invPtrLoc /u01/appl_techs/products/software/inst_proc/oraInventory/oraInst.loc
2. ./fmw_12.2.1.3.0_fr_linux64.bin -silent -responseFile /u01/appl_techs/products/software/inst_proc/fr.rsp -invPtrLoc /u01/appl_techs/products/software/inst_proc/oraInventory/oraInst.loc
3. run rcu from Middleware/oracle_common/bin/rcu
4. Setup Domains from Middleware/oracle_common/common/bin]> ./config.sh

ORDS Configuration
configure the ORDS for the first time
/appl/forms/products/jdk1.8.0_172/bin/java -jar ords.war install
or
/appl/forms/products/jdk1.8.0_172/bin/java -jar ords.war install advanced
system will ask for SYS privilles if ords schema is out dated

Now Deploy to the weblogic

java -jar ords.war static /u01/formsapps/products/ords_app05/apex/images
WAR Generation complete
WAR location : /u01/formsapps/products/ords_app05/i.war
Context path : /i
Static resources : /u01/formsapps/products/ords_app05/apex/images
Ensure the static resources are available at path: /u01/formsapps/products/ords_app05/apex/images
on the server where the WAR is deployed

———————————————————————————————————————
deploy ords as different names
———————————————————————————————————————
[/techs/application/products/ctechs_ords/weblogic_deploye/ctechapp_2nd_attempt_due_to_come_bug]> mv ords.war dctechapp.war
vi params/ords_params.properties
-----------------------------------------------
db.hostname=ctech-serv005
db.port=1521
db.servicename=dctechapp
db.sid=
db.username=APEX_PUBLIC_USER
migrate.apex.rest=false
rest.services.apex.add=true
rest.services.ords.add=false
schema.tablespace.default=SYSAUX
schema.tablespace.temp=TEMP
standalone.http.port=8080
standalone.static.images=
user.tablespace.default=USERS
user.tablespace.temp=TEMP
-----
java -jar dctechapp.war install advanced
-----
owfr_o1: [/techs/application/products/ctechs_ords/weblogic_deploye/ctechapp]> mkdir dctechapp_config
owfr_o1: [/techs/application/products/ctechs_ords/weblogic_deploye/ctechapp_2nd_attempt_due_to_come_bug]> java -jar dctechapp.war install advanced
This Oracle REST Data Services instance has not yet been configured.
Please complete the following prompts
-------------------------------------------------------
Enter the location to store configuration data:/techs/application/products/ctechs_ords/weblogic_deploye/ctechapp_2nd_attempt_due_to_come_bug/dctechapp_config
Enter the name of the database server [ctech-serv005]:
Enter the database listen port [1521]:
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:
Enter the database service name [dctechapp]:
Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]:
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Retrieving information.
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:
Enter the PL/SQL Gateway database user name [APEX_PUBLIC_USER]:
Enter the database password for APEX_PUBLIC_USER:
Confirm password:
Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step [1]:
Enter the database password for APEX_LISTENER:
Confirm password:
Enter the database password for APEX_REST_PUBLIC_USER:
Confirm password:
Aug 20, 2018 10:04:43 PM
INFO: Updated configurations: defaults, apex, apex_pu, apex_al, apex_rt
Aug 20, 2018 10:04:43 PM oracle.dbtools.rt.config.setup.SchemaSetup install
INFO: Oracle REST Data Services schema version 18.1.1.95.1251 is installed.
Enter 1 if you wish to start in standalone mode or 2 to exit [1]:
Enter the APEX static resources location:/techs/application/products/ctechs_ords/apex/images
Enter 1 if using HTTP or 2 if using HTTPS [1]:
Enter the HTTP port [8080]:
2018-08-20 22:07:24.684:INFO::main: Logging initialized @271902ms to org.eclipse.jetty.util.log.StdErrLog
Aug 20, 2018 10:07:24 PM
INFO: HTTP and HTTP/2 cleartext listening on port: 8080
Aug 20, 2018 10:07:24 PM
INFO: Disabling document root because the specified folder does not exist: /techs/application/products/ctechs_ords/weblogic_deploye/ctechapp_2nd_attempt_due_to_come_bug/dctechapp_config/dctechapp/standalone/doc_root
2018-08-20 22:07:25.592:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT, build timestamp: 2017-11-21T22:27:37+01:00, git hash: 82b8fb23f757335bb3329d540ce37a2a2615f0a8
2018-08-20 22:07:25.619:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2018-08-20 22:07:25.619:INFO:oejs.session:main: No SessionScavenger set, using defaults
2018-08-20 22:07:25.620:INFO:oejs.session:main: Scavenging every 660000ms
Aug 20, 2018 10:07:25 PM
WARNING: /techs/application/products/ctechs_ords/weblogic_deploye/ctechapp_2nd_attempt_due_to_come_bug/dctechapp_config/ords/conf
java.nio.file.NoSuchFileException: /techs/application/products/ctechs_ords/weblogic_deploye/ctechapp_2nd_attempt_due_to_come_bug/dctechapp_config/ords/conf
at sun.nio.fs.UnixException.translateToIOException(UnixException.java:86)
at sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:102)
at sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:107)
at sun.nio.fs.UnixFileSystemProvider.newDirectoryStream(UnixFileSystemProvider.java:427)
at java.nio.file.Files.newDirectoryStream(Files.java:525)
at oracle.dbtools.common.config.db.DataSourceConfigurationsProvider.dataSourceIdentifiers(DataSourceConfigurationsProvider.java:95)
at oracle.dbtools.common.config.db.DataSourceValidation.startup(DataSourceValidation.java:34)
at oracle.dbtools.common.app.PluginLifeCycles.startup(PluginLifeCycles.java:39)
at oracle.dbtools.common.app.ApplicationContext.(ApplicationContext.java:133)
at oracle.dbtools.common.app.ApplicationContext.(ApplicationContext.java:50)
at oracle.dbtools.entrypoint.WebApplicationEntryPoint.contextInitialized(WebApplicationEntryPoint.java:67)
at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:890)
at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:532)
at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:853)
at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:344)
at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:785)
at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:261)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:115)
at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:167)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:115)
at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133)
at org.eclipse.jetty.server.Server.start(Server.java:418)
at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113)
at org.eclipse.jetty.server.Server.doStart(Server.java:385)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
at oracle.dbtools.standalone.StandaloneConfiguration.start(StandaloneConfiguration.java:231)
at oracle.dbtools.standalone.Standalone.execute(Standalone.java:494)
at oracle.dbtools.cmdline.DefaultCommand.execute(DefaultCommand.java:138)
at oracle.dbtools.cmdline.Commands.execute(Commands.java:196)
at oracle.dbtools.cmdline.Commands.main(Commands.java:157)
at oracle.dbtools.cmdline.Commands.main(Commands.java:350)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.dbtools.jarcl.Entrypoint.invoke(Entrypoint.java:66)
at oracle.dbtools.jarcl.Entrypoint.main(Entrypoint.java:89)
Aug 20, 2018 10:07:25 PM
INFO: No pools configured yet
Aug 20, 2018 10:07:25 PM
INFO: Oracle REST Data Services initialized
Oracle REST Data Services version : 18.1.1.95.1251
Oracle REST Data Services server info: jetty/9.4.z-SNAPSHOT
2018-08-20 22:07:25.936:INFO:oejsh.ContextHandler:main: Started [email protected]{/ords,null,AVAILABLE}
2018-08-20 22:07:25.937:INFO:oejsh.ContextHandler:main: Started [email protected]{/i,null,AVAILABLE}
2018-08-20 22:07:25.964:INFO:oejs.AbstractConnector:main: Started [email protected]{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:8080}
2018-08-20 22:07:25.965:INFO:oejs.Server:main: Started @273183ms
^C2018-08-20 22:07:28.318:INFO:oejs.AbstractConnector:Thread-4: Stopped [email protected]{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:8080}
2018-08-20 22:07:28.319:INFO:oejs.session:Thread-4: Stopped scavenging
2018-08-20 22:07:28.320:INFO:oejsh.ContextHandler:Thread-4: Stopped [email protected]{/i,null,UNAVAILABLE}
2018-08-20 22:07:28.324:INFO:oejsh.ContextHandler:Thread-4: Stopped [email protected]{/ords,null,UNAVAILABLE}

Now Next step is to update the new name in the standalone.properties

vi ctechs_conf/ctechs/standalone/standalone.properties

If you are planning to change the images refrence as well then update the standalone.properties
#Mon Aug 20 22:13:06 CEST 2018
jetty.port=8888
standalone.context.path=/ctechs
standalone.doc.root=/your setuppath/ctechs/standalone/doc_root
standalone.scheme.do.not.prompt=true
standalone.static.context.path=/c
standalone.static.path=/your path to ords/ctechs_ords/apex/images

now create a image war as per /c/ name:-
java -jar ctechs.war static --context-path /c /path to ords setup/ctechs_ords/apex/images

Issue found with accessing the deployed war on Weblogic Server.
Got the errors like: –
[2018-09-05T11:53:58.8025+02:00] [OHS] [ERROR:32] [OH99999] [weblogic] [client_id: 192.168.5.42] [host_id: ctechssrv005] [host_addr: 192.168.5.75] [pid: 6172] [tid: 139644756739840] [user: ctechs_user05] [ecid: 005TKJwYt_1Fk3F5R3T4id0001WJ00000O] [rid: 0] [VirtualHost: ctechssrv005.techsteppers.com:0] <005TKJwYt_1Fk3F5R3T4id0001WJ00000O> *******Exception type [FAILOVER_REQUIRED] (Service Unavailable) raised at line 241 of BaseProxy.cpp
[2018-09-05T11:53:58.8027+02:00] [OHS] [ERROR:32] [OH99999] [weblogic] [client_id: 192.168.5.42] [host_id: ctechssrv005] [host_addr: 192.168.5.75] [pid: 6172] [tid: 139644756739840] [user: ctechs_user05] [ecid: 005TKJwYt_1Fk3F5R3T4id0001WJ00000O] [rid: 0] [VirtualHost: ctechssrv005.techsteppers.com:0] ap_proxy: trying GET /tpow1 at backend host 192.168.5.75/9025, client 192.168.5.42/64111, total tries 1; got exception 'FAILOVER_REQUIRED [line 241 of BaseProxy.cpp]: Service Unavailable'; state: reading status line or response headers from WLS; failing over
[2018-09-05T11:53:58.8053+02:00] [OHS] [ERROR:32] [OH99999] [weblogic] [client_id: 192.168.5.42] [host_id: ctechssrv005] [host_addr: 192.168.5.75] [pid: 6172] [tid: 139644756739840] [user: ctechs_user05] [ecid: 005TKJwYt_1Fk3F5R3T4id0001WJ00000O] [rid: 0] [VirtualHost: ctechssrv005.techsteppers.com:0] <005TKJwYt_1Fk3F5R3T4id0001WJ00000O> *******Exception type [FAILOVER_REQUIRED] (Service Unavailable) raised at line 241 of BaseProxy.cpp
[2018-09-05T11:53:58.8054+02:00] [OHS] [ERROR:32] [OH99999] [weblogic] [client_id: 192.168.5.42] [host_id: ctechssrv005] [host_addr: 192.168.5.75] [pid: 6172] [tid: 139644756739840] [user: ctechs_user05] [ecid: 005TKJwYt_1Fk3F5R3T4id0001WJ00000O] [rid: 0] [VirtualHost: ctechssrv005.techsteppers.com:0] ap_proxy: trying GET /tpow1 at backend host 192.168.5.75/9025, client 192.168.5.42/64111, total tries 2; got exception 'FAILOVER_REQUIRED [line 241 of BaseProxy.cpp]: Service Unavailable'; state: reading status line or response headers from WLS; failing over
[2018-09-05T11:53:58.8075+02:00] [OHS] [ERROR:32] [OH99999] [weblogic] [client_id: 192.168.5.42] [host_id: ctechssrv005] [host_addr: 192.168.5.75] [pid: 6172] [tid: 139644756739840] [user: ctechs_user05] [ecid: 005TKJwYt_1Fk3F5R3T4id0001WJ00000O] [rid: 0] [VirtualHost: ctechssrv005.techsteppers.com:0] <005TKJwYt_1Fk3F5R3T4id0001WJ00000O> *******Exception type [FAILOVER_REQUIRED] (Service Unavailable) raised at line 241 of BaseProxy.cpp
[2018-09-05T11:53:58.8076+02:00] [OHS] [ERROR:32] [OH99999] [weblogic] [client_id: 192.168.5.42] [host_id: ctechssrv005] [host_addr: 192.168.5.75] [pid: 6172] [tid: 139644756739840] [user: ctechs_user05] [ecid: 005TKJwYt_1Fk3F5R3T4id0001WJ00000O] [rid: 0] [VirtualHost: ctechssrv005.techsteppers.com:0] ap_proxy: trying GET /tpow1 at backend host 192.168.5.75/9025, client 192.168.5.42/64111, total tries 3; got exception 'FAILOVER_REQUIRED [line 241 of BaseProxy.cpp]: Service Unavailable'; state: reading status line or response headers from WLS; failing over

Fix for this Error is that, once deployement is done to the FMW –

check that deployemnts are in active state else start the deployments.

—————————————————————————————————————————-
ISSUE WITH APEX STATIC FILES
—————————————————————————————————————————-
ERROR:

when accessing ORDS, There are issues with the configuration of the Static Files in your environment. Please consult the "Configuring Static File Support" section in the Application Express Installation Guide.
Cause:

This issue occures if APEX_REST_PUBLIC_USER and APEX_LISTENER users are not created in the database where APEX has been installed or option to confugre these users is skipped wiht ORDS

Solution:

cd into the apex scripts directory
$ sqlplus [email protected] as SYSDBA
SQL> @apex_rest_config.sql
when prompted during runnong script
Enter a password for the APEX_LISTENER user []
Enter a password for the APEX_REST_PUBLIC_USER user []
...set_appun.sql
...create APEX_LISTENER and APEX_REST_PUBLIC_USER users
PL/SQL procedure successfully completed.

Now map the users again if required

java -jar techs.war setup --database apex_rt
java -jar techs.war setup --database apex_al

Set/Reset APEX Admin pass
——————————

SQL> @apxchpwd.sql
================================================================================
This script can be used to change the password of an Application Express
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator's username [ADMIN]
User "ADMIN" exists.
Enter ADMIN's email [ADMIN]
Enter ADMIN's password []
--------------------------------------------------------------------------------
Password does not conform to this site's password complexity rules.
* Password must contain at least one punctuation character
(!"#$%&()``*+,-/:;?_).
--------------------------------------------------------------------------------
declare
*
ERROR at line 1:
ORA-20001: Password validation failed.
ORA-06512: at line 30
SQL> @apxchpwd.sql
================================================================================
This script can be used to change the password of an Application Express
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator's username [ADMIN]
User "ADMIN" exists.
Enter ADMIN's email [ADMIN]
Enter ADMIN's password []
Changed password of instance administrator ADMIN.

================================================================================
RESET THE Image Prefix
================================================================================
cd into your apex/utilities directory
connect as sys
Run the reset_image_prefix.sql script.
SQL> @reset_image_prefix.sql
Note:- you need these three scripts - reset_image_prefix.sql , reset_image_prefix_con.sql , reset_image_prefix_core.sql
Also make sure your APEX instance is stoped or db is in restricted mode when you preform this change.

================================================================================
BASIC ORACLE DB Commands
================================================================================
sqlplus [email protected] as SYSDBA
SELECT username,
account_status
FROM dba_users;
set lines 180 pages 500
/
select * from dba_users where username like 'APEX%';
alter profile default limit password_verify_function null;
alter user APEX_PUBLIC_USER identified by Teechs2018;

==============================================================================
UPDATE the apex users passwords for ORDS setup
==============================================================================
To edit the password from the config file by puttin in an exclamation mark before the password, like "!your_password" (without the quotes). When you restart webserver, ORDS will update the config file with an encrypted version of the password.

Leave a Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!