Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Status of operating system support for XE 11.2

UdoSep 4 2011 — edited Aug 21 2012
Document History
<li>created on Sep 04 2011
<li>review on Dec 31 2011: document is up to date
<li>edit on Jan 03 2012: added direct link to recent version of Ubuntu installer
<li>review on Feb 03 2012: document is up to date
<li>review on Mar 13 2012: document is up to date
<li>edit on Jul 05 2012: added reference to message for differences between Ubuntu 11.10 and 12.04
<li>edit on Aug 21 2012: added reference to supported OS versions in Installation Guides


Because there were repeated questions on this topic in the beta forum for XE 11.2 and similar questions come up here, I think it is a good idea to summarize the different requests and the announced release plan for each operating system. I'll try to keep this post updated as any new information is published.

h1. Windows
- Windows 32bit: released. Supported Windows versions: See [url http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#BABHICJH]Installation Guide Download: [url http://www.oracle.com/technetwork/database/express-edition/downloads/index.html]OTN
- Windows 64bit: planned. See {thread:id=2277728}

h1. Linux
- Linux 32bit: not planned. See {thread:id=2201349}
- Linux 64bit: released. Supported Linux versions: See [url http://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm#BABHICJH]Installation Guide Download: [url http://www.oracle.com/technetwork/database/express-edition/downloads/index.html]OTN
- other Linux flavors: Debian/Ubuntu: no announcement yet. See {thread:id=2277791} for discussion and a summary of working solutions without official release.
-- For a complete Installation-HowTo: {thread:id=2301639}
-- Additional workaround for Ubuntu 12.04: {message:id=10298240}

h1. Other OS
- Mac OS X: not planned. Users may use the upcoming VirtualBox image. See {thread:id=2201543}

I'd appreciate if this thread would not be used for any discussion on if or why some port will (not) be available. Please either follow the threads referenced above or, if anybody think it's necessary, start a new one.

Thanks and enjoy XE 11.2,

Udo

Comments

Mark D Powell
Answer
The package was in use. There are a couple of ways to find who is using a package at any given moment.

You can join v$session to dba_ddl_locks or you can use v$acess but you can see who is executing the package. The code cannot be recompiled while the code is in use.

HTH -- Mark D Powell --
Marked as Answer by 784227 · Sep 27 2020
Helios-GunesEROL
Hi;

For can root cause please see:
How to analyze ORA-04021 or ORA-4020 errors? [ID 169139.1]

Hope it helps

Regard
Helios
784227
Hi,

Thanks for reply.

There are two session id which are access same package in dba_ddl_locks, do i need to kill that session id?

Thanks
oradba
do i need to kill that session id?
I would first try to find out, WHO is behind this id.
Mark D Powell
It would have been nice if you had posted your query and results so we could make suggestions on how to improve the query or what you should check next.

Generally speaking if you submit a create or replace on a package and it takes longer than expected you can open a second session and query for usage. Depending on what you find determines your action.

If may be you just need to re-submit immediately or wait till a batch job completes. There could be a daemon (continuously running batch) job that you have stopped and re-started right after you make the change. It depends on your environment.

HTH -- Mark D Powell --
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 2 2011
Added on Sep 4 2011
0 comments
1,135 views