Hi,
tried to install latest 21.4.0.348.1956 in an 19.13 instance - no previous version of ords was installed.
Output:
root@apex:~gweber # java -Xms512m -Xmx1024m -jar ords.war install advanced
Specify the database connection type to use.
Enter number for [1] Basic [2] TNS [3] Custom URL [1]:1
Enter the name of the database server [localhost]:192.168.0.110
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:HOME
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:
Grant succeeded.
SYNONYM USER_ORDS_REPOVERSIONS created.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
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_210200.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_app_contexts.sql]
Error starting at line : 17 in command -
begin
execute immediate 'CREATE OR REPLACE CONTEXT http$env USING ords_metadata.ords_services_internal';
end;
Error report -
ORA-02012: missing USING keyword
ORA-06512: at line 2
02012. 00000 - "missing USING keyword"
*Cause:
*Action:
Whats the reason for the ORA-02012 error ?
thanks in advance