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.
mwf
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Jeffrey Beckstrom
Sent: Friday, March 23, 2018 11:34 AM
To: knecht.stefan@xxxxxxxxx
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 <knecht.stefan@xxxxxxxxx> 3/23/18 9:18 AM >>>
