RE: missing edition but no editions exist

From: Mark W. Farnham <>
Date: Fri, 23 Mar 2018 12:19:36 -0400
Message-ID: <04b601d3c2c2$bd28d490$377a7db0$>

I think he might have meant set the default edition in the logon trigger.  

I don't remember in my head and I'm not stopping to look up at which release and patch the default edition became a thing whether or not you're "using" editions.  

Possibly your migration method dropped grants to the default edition or something like that.  

Log on as sys or system and  

select edition_name from all_editions;  

and that might yield a clue.  

If the public grant is missing to the database default edition, then  

grant use on edition <edition_name> to public;  

should fix it.  

YMMV, this could be something completely different.  


From: [] On Behalf Of Jeffrey Beckstrom
Sent: Friday, March 23, 2018 11:34 AM
Cc: oracle-l-freelist
Subject: Re: missing edition but no editions exist  

Disabled it and same result.  

Weird thing is that the original Windows database works fine. On Linux it does not. Only sys and system can connect on Linux.

>>> Stefan Knecht <> 3/23/18 9:18 AM >>>

Logon trigger?  

On Fri, Mar 23, 2018 at 8:08 PM, Jeffrey Beckstrom <> wrote:

Migrated from Windows 2003 to Linux X64 using Transportable database. Migration had no errors. SYSDBA can connect. All other users get ORA-38802: edition does not exist. However, there are NO editions in the database!!!  

Any ideas?

Jeffrey Beckstrom
Lead Database Administrator

Information Technology Department

Greater Cleveland Regional Transit Authority

1240 W. 6th Street
<,+Ohio+44113&entry=g mail&source=g>
Cleveland, Ohio 44113
<,+Ohio+44113&entry=g mail&source=g>      



zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!

Visit us at  <> | _at_zztat_oracle | |

Received on Fri Mar 23 2018 - 17:19:36 CET

Original text of this message