RE: missing edition but no editions exist
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <jbeckstrom@xxxxxxxxx>, <knecht.stefan@xxxxxxxxx>
- Date: Fri, 23 Mar 2018 12:58:17 -0400
If one public grant is missing…
I would run a count on public grants or something like that, possibly by owner,
as a quick diagnostic. You may have more subtle problems if the migration
method left behind some public grants.
Or everything else could be just fine. I’m not paranoid, DBAs past or present
cannot be paranoid because the world really is out to get you…
And yeah, this list is gold. Too many to thank
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Jeffrey Beckstrom
Sent: Friday, March 23, 2018 12:43 PM
To: knecht.stefan@xxxxxxxxx; Mark W.Farnham
Cc: oracle-l-freelist
Subject: RE: missing edition but no editions exist
Thanks. This list has saved me before and did it again. In this one database,
the grant to public was missing for ora$base. As part of the migration, we put
on the Oct. 2017 PSU. It must have included a check for the grant that was not
in our Windows PSU.
"Mark W. Farnham" <mwf@xxxxxxxx> 3/23/18 12:19 PM >>>
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 >>>
Logon trigger?
On Fri, Mar 23, 2018 at 8:08 PM, Jeffrey Beckstrom <jbeckstrom@xxxxxxxxx> wrote:
Migrated 11.2.0.4 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
<
https://urldefense.proofpoint.com/v2/url?u=https-3A__maps.google.com_-3Fq-3D1240-2BW.-2B6th-2BStreet-2BCleveland-2C-2BOhio-2B44113-26amp-3Bentry-3Dgmail-26amp-3Bsource-3Dg&d=DwMFAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=aX52EdIcM-g13JIccaUt3dvPc_g2X17qM3viz0cXt9w&m=ALMviH7kNDXtkxhlV5vKNnVPL3Qzl8H5uIn3AEYIDSI&s=_mx1nKrqv0JFm7YTNV84eB601IbsKrBp_4wz4dkINxo&e=>
Cleveland, Ohio 44113
<
https://urldefense.proofpoint.com/v2/url?u=https-3A__maps.google.com_-3Fq-3D1240-2BW.-2B6th-2BStreet-2BCleveland-2C-2BOhio-2B44113-26amp-3Bentry-3Dgmail-26amp-3Bsource-3Dg&d=DwMFAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=aX52EdIcM-g13JIccaUt3dvPc_g2X17qM3viz0cXt9w&m=ALMviH7kNDXtkxhlV5vKNnVPL3Qzl8H5uIn3AEYIDSI&s=_mx1nKrqv0JFm7YTNV84eB601IbsKrBp_4wz4dkINxo&e=>
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at
<
https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_&d=DwMFAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=aX52EdIcM-g13JIccaUt3dvPc_g2X17qM3viz0cXt9w&m=ALMviH7kNDXtkxhlV5vKNnVPL3Qzl8H5uIn3AEYIDSI&s=mrLcuNDSTlOfAdwvf-dazzVJECzWcBcNLpWddMEX3Uw&e=>
zztat.net | @zztat_oracle | fb.me/zztat
<
https://urldefense.proofpoint.com/v2/url?u=http-3A__fb.me_zztat&d=DwMFAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=aX52EdIcM-g13JIccaUt3dvPc_g2X17qM3viz0cXt9w&m=ALMviH7kNDXtkxhlV5vKNnVPL3Qzl8H5uIn3AEYIDSI&s=d0dPyvCKcl5-Mnri40OqtvU9RJZXEqSwkQpvjz_v71I&e=>
| zztat.net/blog/
<
https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_blog_&d=DwMFAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=aX52EdIcM-g13JIccaUt3dvPc_g2X17qM3viz0cXt9w&m=ALMviH7kNDXtkxhlV5vKNnVPL3Qzl8H5uIn3AEYIDSI&s=Vh6GzufKcpYEaEzB9FxC7vpI8R-34QsWpSky3Zdsa7A&e=>
_____
This email has been scanned for spam and viruses. Click here
<
https://attseg.cloud-protect.net/index01.php?mod_id=11&mod_option=logitem&mail_id=1521822002-fQyBYpV9yywD&r_address=jbeckstrom%40gcrta.org&report=1>
to report this email as spam.
Other related posts:
