I'm trying to install ORDS schema with a user who has SYSDBA role. But still I'm getting this error. Any reason?
Prompt says I can use any user with SYSDBA privileges, apparently it does not work. is it a BUG? Please confirm. Please provide workaround.
When we are installing with non-SYS user who has SYSDBA role, do we need to provide any others GRANTs? Please advise.
or it should be done only with SYS user? Please confirm..
1 person found this helpful
Yes, currently you have to be exactly sys.
I found scripts to install ORDS schema inside the .war file
- Extract content of ords.war file
- Looks for ords_manual_install.sql script file in "ords\scripts\install\core" path
- Connect as SYS user and run this script (in my case, I have requested our DBA to do it) and get the password for ORDS_PUBLIC_USER
@ords_manual_install.sql /logs/ SYSAUX TEMPSYSAUX TEMP
Once ORDS schema already installed and you know password for ORDS_PUBLIC_USER, then you can configure ORDS for APEX w/o need to SYS access.
This might be a rare case, where you need to configure ORDS for APEX w/o direct SYS access. But if you have this case, this is the way to do it