Entry is there but not workin
daxesh laiwala, July 13, 2022 - 6:44 am UTC
HERE IS MY POOL.XML file as you said link this entry is there
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "
http://java.sun.com/dtd/properties.dtd" >
<properties>
<comment>Saved on Thu Jul 07 09:54:13 UTC 2022</comment>
<entry key="db.connectionType">basic</entry>
<entry key="db.hostname">localhost</entry>
<entry key="db.port">1521</entry>
<entry key="db.servicename">xepdb1</entry>
<entry key="db.username">ORDS_PUBLIC_USER</entry>
<entry key="feature.sdw">true</entry>
<entry key="plsql.gateway.mode">proxied</entry>
<entry key="restEnabledSql.active">true</entry>
<entry key="security.requestValidationFunction">wwv_flow_epg_include_modules.authorize</entry>
<entry key="security.verifySSL">false</entry>
</properties>
but still not working. If i change ords version from 22.2 to 21.4 than it is working. Pleasee guid me my action recording is here
https://drive.google.com/file/d/19uJZH4tpWyacpCKp0tnCZHXi8kwtPD0L/view?usp=sharing
July 14, 2022 - 1:57 am UTC
and did you enable the demo schema?
Daxesh, July 15, 2022 - 12:09 pm UTC
Yes i did it see my recorded actions.
I tried entire setup process on three different machine but same
July 18, 2022 - 3:40 am UTC
OK, check the ords logs - what have you got in there
Is any solution for that
Daxesh, July 20, 2022 - 4:17 am UTC
I tried what you said but not working I think you not seen my recorded actions. Hope you can understand what I try to say.
July 21, 2022 - 2:59 am UTC
I *did* look at the recording.
You're getting an error back from ORDS ... so there should be some information in the ORDS logs.
where to find ords.log
DAXESH LAIWALA, July 21, 2022 - 6:43 pm UTC
I search in ORDS folder but not getting log file can you guide me please where ords.log.
July 26, 2022 - 7:21 am UTC
my ords install log
DAXESH LAIWALA, July 21, 2022 - 7:08 pm UTC
ORDS Install log
-----------
[*** script: ords_alter_session_script.sql]
PL/SQL procedure successfully completed.
[*** script: ords_alter_session_metadata.sql]
Session altered.
[*** script: ords_migrate.pls]
Package ORDS_MIGRATE compiled
[*** script: ords_apex_repair_internal.pls]
Package ORDS_APEX_REPAIR_INTERNAL compiled
[*** script: ords_apex_repair.pls]
Package ORDS_APEX_REPAIR compiled
[*** script: ords_migrate.plb]
Package Body ORDS_MIGRATE compiled
[*** script: ords_apex_repair_internal.plb]
Package Body ORDS_APEX_REPAIR_INTERNAL compiled
[*** script: ords_apex_repair.plb]
Package Body ORDS_APEX_REPAIR compiled
[*** script: ords_migrate_pub_synonym.sql]
Session altered.
Synonym ORDS_MIGRATE created.
[*** script: ords_migrate_grant_priv.sql]
Session altered.
INFO: Verify if Application Express exists to setup the migration privileges for
ORDS.
INFO: Completed setting up the APEX REST migration privileges for ORDS.
PL/SQL procedure successfully completed.
Session altered.
[*** script: ords_apex_repair_pub_synonym.sql]
Synonym ORDS_APEX_REPAIR created.
[*** script: ords_verify_install.sql]
Session altered.
INFO: 11:55:06 Validating objects for Oracle REST Data Services.
VALIDATION: 11:55:06 Starting validation for schema: ORDS_METADATA
VALIDATION: 11:55:06 Validating objects
VALIDATION: 11:55:06 Validating roles granted to ORDS_METADATA and
ORDS_PUBLIC_USER
VALIDATION: 11:55:06 Validating ORDS Public Synonyms
VALIDATION: 11:55:07 Total objects: 320, invalid objects: 0, missing objects: 0
VALIDATION: 11:55:07 86 INDEX
VALIDATION: 11:55:07 3 LOB
VALIDATION: 11:55:07 20 PACKAGE
VALIDATION: 11:55:07 19 PACKAGE BODY
VALIDATION: 11:55:07 1 PROCEDURE
VALIDATION: 11:55:07 56 PUBLIC SYNONYM
VALIDATION: 11:55:07 1 SEQUENCE
VALIDATION: 11:55:07 14 SYNONYM
VALIDATION: 11:55:07 30 TABLE
VALIDATION: 11:55:07 30 TRIGGER
VALIDATION: 11:55:07 20 TYPE
VALIDATION: 11:55:07 6 TYPE BODY
VALIDATION: 11:55:07 34 VIEW
VALIDATION: 11:55:07 Validation completed.
INFO: 11:55:07 Completed validation for Oracle REST Data Services.
PL/SQL procedure successfully completed.
Commit complete.
----
i repair now and repair log is
-----------------
------------------------------------------------------------
Date : 21 Jul 2022 19:01:31
Release : Oracle REST Data Services 22.2.0.r1721758
Type : ORDS Repair
Database : Oracle Database 21c Express Edition
DB Version : 21.3.0.0.0
------------------------------------------------------------
Container Name: XEPDB1
------------------------------------------------------------
[*** script: ords_alter_session_script.sql]
PL/SQL procedure successfully completed.
[*** script: ords_version.sql]
Session altered.
PL/SQL procedure successfully completed.
[*** script: ords_schema_mapping.sql]
INFO: Configuring ORDS_PUBLIC_USER to map APEX Workspaces and ORDS schemas
Session altered.
Configuring APEX and ORDS schemas for url mapping
Made APEX_PUBLIC_USER proxiable from ORDS_PUBLIC_USER
Made APEX_REST_PUBLIC_USER proxiable from ORDS_PUBLIC_USER
APEX_POOL_CONFIG Synonym exists
Created ORDS_METADATA.APEX_WWV_FLOW_POOL_CONFIG as view over
APEX_220100.APEX_POOL_CONFIG
PL/SQL procedure successfully completed.
INFO: Completed configuring ORDS_PUBLIC_USER to map APEX Workspaces and ORDS Schemas
Session altered.
[*** script: ords_repair_proxy_connect.sql]
INFO: Checking ords enabled schemas and its proxy user
Session altered.
PL/SQL procedure successfully completed.
[*** script: ords_alter_schema_no_auth.sql]
PL/SQL procedure successfully completed.
[*** script: ords_migrate_grant_priv.sql]
INFO: Verify if Application Express exists to setup the migration privileges for
ORDS.
INFO: Completed setting up the APEX REST migration privileges for ORDS.
PL/SQL procedure successfully completed.
Session altered.
[*** script: ords_validate_objects.sql]
INFO: 00:31:37 Validating objects for Oracle REST Data Services.
VALIDATION: 00:31:37 Starting validation for schema: ORDS_METADATA
VALIDATION: 00:31:37 Validating objects
VALIDATION: 00:31:38 Validating roles granted to ORDS_METADATA and
ORDS_PUBLIC_USER
VALIDATION: 00:31:38 Validating ORDS Public Synonyms
VALIDATION: 00:31:39 Total objects: 312, invalid objects: 0, missing objects: 0
VALIDATION: 00:31:39 88 INDEX
VALIDATION: 00:31:39 1 JOB
VALIDATION: 00:31:39 3 LOB
VALIDATION: 00:31:39 20 PACKAGE
VALIDATION: 00:31:39 19 PACKAGE BODY
VALIDATION: 00:31:39 1 PROCEDURE
VALIDATION: 00:31:39 56 PUBLIC SYNONYM
VALIDATION: 00:31:39 1 SEQUENCE
VALIDATION: 00:31:39 31 TABLE
VALIDATION: 00:31:39 31 TRIGGER
VALIDATION: 00:31:39 20 TYPE
VALIDATION: 00:31:39 6 TYPE BODY
VALIDATION: 00:31:39 35 VIEW
VALIDATION: 00:31:39 Validation completed.
INFO: 00:31:39 Completed validating objects for Oracle REST Data Services.
PL/SQL procedure successfully completed.
[*** script: ords_alter_session_script.sql]
PL/SQL procedure successfully completed.
[*** script: ords_version.sql]
Session altered.
PL/SQL procedure successfully completed.
[*** Info: Completed repair for Oracle REST Data Services version 22.2.0.r1721758. Elapsed time: 00:00:07.605
]