Home » RDBMS Server » Server Administration » ORA-38802: edition does not exist (Oracle 11.2.0.1, RHEL7)
| ORA-38802: edition does not exist [message #644599] |
Wed, 11 November 2015 01:04  |
 |
Acronis2286
Messages: 16
Registered: December 2014
|
Junior Member |
|
|
Hello All,
I am installing one database application built by a colleague of mine, which requires the DB schema user to have grants to create editions. However, once I have given the grants to the user and then i have also created the requisite edition, when I run the application is gives the error:
ORA-38802: edition does not exist
To give grants, I have issues below commands:
GRANT CREATE ANY EDITION, DROP ANY EDITION to <username>;
alter user <username> enable editions;
Even after multiple tries I am getting same error. I tried to create the Edition using SYS user and then granted its use to the application user as well, but that did not work.
create edition "<edition_name>" as child of "ORA$BASE";
grant use on edition "<edition_name>" to <username>;
Kindly advise if I am missing anything here!.
In case of more information kindly let me know.
Thanks,
Suddhasatwa
|
|
|
|
Current Time: Tue Apr 16 01:43:48 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
