Wednesday, July 6, 2022

Installation and Configuration Guide ORDS 22.2

 Step 1: Go to your SQL plus    And connect the sys user

Step 2: From the location of ORDS Folder take the path 

@F:\ords\scripts\installer\ords_installer_privileges.sql  hr

Run the above script.

Now go the CMD Command Prompt and Give the locations

F:\ords\bin

and the second locations

F:\ords\bin>ords install

ORDS: Release 22.2 Production on Wed Jul 06 16:43:47 2022


Copyright (c) 2010, 2022, Oracle.


Configuration:

  /F:/ords/bin/


The configuration folder F:\ords\bin does not contain any configuration files.


Oracle REST Data Services - Interactive Install


  Enter a number to select the type of installation

    [1] Install or upgrade ORDS in the database only

    [2] Create or update a database pool and install/upgrade ORDS in the database

    [3] Create or update a database pool only

  Choose [2]:

  Enter a number to select the database connection type to use

    [1] Basic (host name, port, service name)

    [2] TNS (TNS alias, TNS directory)

    [3] Custom database URL

  Choose [1]:

  Enter the database host name [localhost]:

  Enter the database listen port [1521]:

  Enter the database service name [orcl]:

  Provide database user name with administrator privileges.

    Enter the administrator username: sys

  Enter the database password for SYS AS SYSDBA:

Connecting to database user: SYS AS SYSDBA url: jdbc:oracle:thin:@//localhost:1521/orcl


Retrieving information.

  Enter the default tablespace for ORDS_METADATA and ORDS_PUBLIC_USER [SYSAUX]:

  Enter the temporary tablespace for ORDS_METADATA and ORDS_PUBLIC_USER [TEMP]:

  Enter a number to select additional feature(s) to enable:

    [1] Database Actions  (Enables all features)

    [2] REST Enabled SQL and Database API

    [3] REST Enabled SQL

    [4] Database API

    [5] None

  Choose [1]:

  Enter a number to configure and start ORDS in standalone mode

    [1] Configure and start ORDS in standalone mode

    [2] Skip

  Choose [1]:

  Enter a number to use HTTP or HTTPS protocol

    [1] HTTP

    [2] HTTPS

  Choose [1]:

  Enter the HTTP port [8080]: 8080

Blog link : https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/22.1/ordig/about-REST-configuration-files.html#GUID-006F916B-8594-4A78-B500-BB85F35C12A0

No comments:

Post a Comment