Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 473 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Getting ORA-01031: insufficient privileges when trying to run ords.enable_schema

I've been able to get ORDS standalone (connected to Database A) running locally via SQL Developer. I'm now trying to install it (connected to Database B) using instructions provided by Tim Hall's excellent resource: https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-standalone-mode
I've also checked the install against the following instructions: Installing Oracle REST Data Services
When I try to enable rest service for a schema on Database B. I get the following error.
So far the only difference I can tell between this install and the ORDS install for Database A is my chosen schema has a proxied user to ORDS_PUBLIC_USER. So I tried to mimic this on Database B using alter user my_schema grant connect through ORDS_PUBLIC_USER;
I've run java -jar ords.war validate and can see no errors in the log.
I even tried create an admin user java -jar ords.war user adminlistener "Listener Administrator" so I could use the REST Data Services > Admininistration feature. I've connected to the ORDS on Database B, but when I right click on Database B in the Connections panel there's no Enable REST services.
Answers
-
Hi Mark Sta Ana,
Mark Sta Ana wrote:I've been able to get ORDS standalone (connected to Database A) running locally via SQL Developer. I'm now trying to install it (connected to Database B) using instructions provided by Tim Hall's excellent resource: https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-standalone-mode I've also checked the install against the following instructions: Installing Oracle REST Data Services When I try to enable rest service for a schema on Database B. I get the following error.
Regarding ORDS.ENABLE_SCHEMA: "Only database users with the DBA role can enable or disable a schema other than their own."
See the "Usage Notes" for ORDS.ENABLE_SCHEMA API.
Refer: https://docs.oracle.com/cd/E56351_01/doc.30/e56293/ORDS-reference.htm#AELIG90218
Hope this helps!
Regards,
Kiran
-
Hi Kiran,
I am the schema owner in this case, so it should work.
Any other ideas?
Mark
-
>>but when I right click on Database B in the Connections panel there's no Enable REST services
Is the ORDS metadata schema installed on this database? We look for it at connect time - you see us looking for it when you connect if you observe the View > Log > Statements panel.
-
Hi Mark Sta Ana,
Mark Sta Ana wrote:I am the schema owner in this case, so it should work.Any other ideas?
As aptly pointed out by Jeff Smith, have you installed ORDS in Database B correctly? Is the user ORDS_METADATA exist in Database B?
You can validate your ORDS installation in Database B using the following command:
java -jar ords.war validate [-database <dbname>]
Hope this helps!
Regards,
Kiran