| 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
|
|
|
|
|
|
|
|
| Re: ORA-38802: edition does not exist [message #644602 is a reply to message #644601] |
Wed, 11 November 2015 01:21  |
|
Acronis2286
Messages: 16
Registered: December 2014
|
Junior Member |
|
|
SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 11 12:50:26 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @create_user
Enter username to be created:
ercore
Enter password of the user:
ercore
old 1: CREATE USER &user IDENTIFIED BY &passwd
new 1: CREATE USER ercore IDENTIFIED BY ercore
User created.
old 1: GRANT RESOURCE, CONNECT, QUERY REWRITE TO &user
new 1: GRANT RESOURCE, CONNECT, QUERY REWRITE TO ercore
Grant succeeded.
old 1: grant create view to &user
new 1: grant create view to ercore
Grant succeeded.
old 1: grant create synonym to &user
new 1: grant create synonym to ercore
Grant succeeded.
old 1: alter user &user enable editions
new 1: alter user ercore enable editions
User altered.
old 1: grant create any edition to &user
new 1: grant create any edition to ercore
Grant succeeded.
SQL> exit;
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Hope this helps as well ...
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-38802: edition does not exist [message #644607 is a reply to message #644606] |
Wed, 11 November 2015 01:52 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Using the string 15.10 as your edition name may be your problem. SQL identifiers are not allowed to begin with a digit. It looks as though you did it by enclosing the string within double quotes (though you have not yet shown the creation of the edition). Any code that does not use double quotes will not work subsequently.
I would do it all again, using a legal name.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-38802: edition does not exist [message #644625 is a reply to message #644622] |
Wed, 11 November 2015 02:21 |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
There are some inconsistencies in the post.
See my test:
SQL> create edition 15.10;
create edition 15.10
*
ERROR at line 1:
ORA-00931: missing identifier
SQL> create edition "15.10";
Edition created.
SQL> conn michel/michel edition=15.10;
ERROR:
ORA-38801: improper value for ORA_EDITION
Warning: You are no longer connected to ORACLE.
SQL> conn michel/michel edition="15.10";
Connected.
SQL> conn michel/michel edition=ora$base;
Connected.
SQL> conn michel/michel edition="ORA$BASE"
Connected.
As you can see I have to use "15.10" between double quotes to be able to connect and I am still able to connect to ORA$BASE (with both syntaxes).
Your test seems to indicate that ORA$BASE no more exists but your previous output shows it in USABLE state in DBA_EDITIONS.
Check again.
[Updated on: Wed, 11 November 2015 02:23] Report message to a moderator |
|
|
|
|
|
| Re: ORA-38802: edition does not exist [message #644628 is a reply to message #644624] |
Wed, 11 November 2015 02:34 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Just start again, man. You have so many mistakes and inconsistencies. Another example: you are trying to connect as er, but you said this earlier:
Quote:SQL> @create_user
Enter username to be created:
ercore
Enter password of the user:
ercore
old 1: CREATE USER &user IDENTIFIED BY &passwd
new 1: CREATE USER ercore IDENTIFIED BY ercore
Create a new database, do it all again, and this time do it right.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-38802: edition does not exist [message #644637 is a reply to message #644636] |
Wed, 11 November 2015 04:07 |
|
Acronis2286
Messages: 16
Registered: December 2014
|
Junior Member |
|
|
$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 11 15:35:32 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn sys@orcl as sysdba
Enter password:
Connected.
SQL>
SQL> col property_name format a30
SQL> col property_value format a50
SQL> set lines 1000 pages 1000
SQL> select property_name, property_value from database_properties
where property_name = 'DEFAULT_EDITION'; 2
PROPERTY_NAME PROPERTY_VALUE
------------------------------ --------------------------------------------------
DEFAULT_EDITION ORA$BASE
SQL> conn er/er@orcl
Connected.
SQL> select sys_context('userenv','current_edition_name') from dual;
SYS_CONTEXT('USERENV','CURRENT_EDITION_NAME')
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ORA$BASE
SQL> conn er/er@orcl EDITION=ora$base
Connected.
SQL> select sys_context('userenv','current_edition_name') from dual;
SYS_CONTEXT('USERENV','CURRENT_EDITION_NAME')
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ORA$BASE
SQL> conn er/er@orcl EDITION="15.10"
Connected.
SQL> select sys_context('userenv','current_edition_name') from dual;
SYS_CONTEXT('USERENV','CURRENT_EDITION_NAME')
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
15.10
SQL>
SQL> exit;
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
