Oracle Rest Data Services (ORDS) (MOSC)

MOSC Banner

installing ORDS24 on Linux with Oracle 19.26 without sysdba or DBMS_NETWORK_ACL_ADMIN priv

in Oracle Rest Data Services (ORDS) (MOSC) 4 commentsAnswered ✓

We are trying to install ORDS 24.4 but we are not allowed within the organization to use sysdba for this installation.

We are using pdbadmin account which has lower privileges compared to sysdba and we tried to install ORDS by commenting out in the ords_grant_privs.sql script the following 2 privileges as it can case security risk:

'UTL_SMTP'

'DBMS_NETWORK_ACL_ADMIN'

When we run the installation of ORDS it is failing while script: ords_verify_install.sql is being executed with the following error:

ERROR at line 1:

ORA-20006: ERROR: Validating objects failed. ORA-20006: ERROR: ORDS schema database objects contains INVALID status.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center