Oracle Personal Edition Sucks!
x...@oraclexg.com
wrote:
Allright, so I installed Oracle personal edition on my desktop. Here
are my peeves against oracle -
a) First of all, the installation was in 3 cd's equivalent - so much
for microsoft being bloatware.
b) When my PC boots up, I have Oracle's process taking up 96 MB of
memory compared to SQL Server's under 10MB, the memory usage keeps
going up exponentially as I use either product.
c) Here's my biggest problem - when I wanted to uninstall Oracle, it
isn't in add/remove programs like all other friendly citizens of the
computer world, instead it has it's own crappy java based installer,
and instead of uninstall they prefer to call it "Deinstall", and
what's worse in the treeview it shows me, when I check an item to be
unistalled, the zillions of items under it, are still unchecked - are
they going to be uninstalled or will they be not? It takes a minimum of
3-4 hours to individually check everything there is.
d) When the frickin' "de"-installation is complete, the installer
remains on the system. But it's group dissappears from my start menu or
add/remove programs or everywhere. Is there spyware in that?
e) Talk about all the JUNK that Oracle installed in the first place,
look at your registry before and after Oracle got done trading the soul
of your poor PC, it adds many megabytes of information to the registry
.. what in the world !!!!
Larry Ellison IMHO has only one business idea - "Defeat bill gates
and trap every programmer in matrix like pods powering oracle
databases". WHAT THE HECK !! Time he matured up a bit.
SQL Server, especially Yukon is a MUCH better dbms in my opinion, the
only reason Oracle will continue to survive is
a) Anti-Microsoft Zealots and Bigots .. and ..
b) The huge installed base of Oracle (It isn't easy porting your DBMS
from Oracle to SQL Server).
steph
William Robertson
Yes they should scrap Personal Edition and replace it with a free,
almost-fully featured version that is easy to download and install.
Oh wait, they have.
x...@oraclexg.com
Jaap W. van Dijk
>http://codebetter.com/blogs/sahil.malik/archive/2004/08/28/23563.aspx
>wrote:
<snip>
>c) Here's my biggest problem - when I wanted to uninstall Oracle, it
>isn't in add/remove programs like all other friendly citizens of the
>computer world, instead it has it's own crappy java based installer,
>and instead of uninstall they prefer to call it "Deinstall", and
>what's worse in the treeview it shows me, when I check an item to be
>unistalled, the zillions of items under it, are still unchecked - are
>they going to be uninstalled or will they be not? It takes a minimum of
>3-4 hours to individually check everything there is.
>d) When the frickin' "de"-installation is complete, the installer
>remains on the system. But it's group dissappears from my start menu or
>add/remove programs or everywhere. Is there spyware in that?
>e) Talk about all the JUNK that Oracle installed in the first place,
>look at your registry before and after Oracle got done trading the soul
>of your poor PC, it adds many megabytes of information to the registry
>.. what in the world !!!!
<snip>
I'm a Oracle-adept myself, but with regards to uninstalling (sorry,
deinstalling) it from Windows I couldn't agree with you more.
There's a note on Oracle's Metalink, how to remove all traces, but
it's many, many steps. For your benefit I copy it here anyway, so you
can check what you've missed. Have fun!
Subject: WIN: Manually Removing all Oracle Components on
Microsoft Windows Platforms
Doc ID: Note:124353.1 Type: REFERENCE
Last Revision Date: 06-FEB-2006 Status:
PUBLISHED
PURPOSE
-------
This article describes the procedure how to manually perform the
actions to
create a "clean machine" on Microsoft Windows 95/98/NT/2000/XP and how
to
manually remove all Oracle components (e.g.: oracle RDBMS database
server,
IAS, OEM, client installations, etc) and services from your computer.
SCOPE & APPLICATION
-------------------
This article is intended for DBA's on the Microsoft Windows platform.
WARNING:
1. Remove all Oracle components from your computer only as a last
resort,
and only if you want to remove ALL Oracle components from your
system.
2. These instructions remove all Oracle components, services, and
registry
entries from your computer. In addition, any database files in the
subdirectories under ORACLE_BASE\ORADATA\ are also removed.
3. These procedures will also remove Oracle network configuration
files,
user written scripts and any other user generated files that may be
stored
in Oracle_Base directories.
4. Exercise extreme care when removing registry entries. Removing
incorrect
entries can severely compromise your computer.
MANUALLY REMOVING ALL ORACLE COMPONENTS AND SERVICES FROM YOUR
COMPUTER
-----------------------------------------------------------------------
Section A (steps 1-6) describes the removal of all Oracle components
on
Windows NT,2000 and XP.
Section B (steps 1-4) describes the removal of all Oracle components
on
Windows 95 and Windows 98.
A. Removing Components on Windows NT/2000/XP.
---------------------------------------------
To remove all Oracle components from a computer on Windows NT/2000/XP:
1. Check privileges:
-----------------
1.a. Ensure you are logged in as a user with Administrator privileges.
2. Stop all Oracle services (if any are running):
----------------------------------------------
2.a. NT: Choose Start > Settings > Control Panel > Services.
2000,XP: Right click My Computer > Manage > Services and
Applications >
> Services
2.b. If any Oracle services (their names begin with Oracle) exist and
have
the status Started, select the service and click Stop.
2.c. Click Close to exit the Services window.
2.d. Close the Control Panel/Computer Management window.
3. Remove the entries in the Windows registry:
-------------------------------------------
3.a. Start the registry editor:
Choose Start > Run > regedit
Note: On Windows NT you can use regedt32 instead. The searching
capabilities of regedt32 is limited compared to regedit. It
will be
needed to be able to edit 32-bit entries in the registry.
Since we
are not going to update any 32-bit entry it is not needed.
3.b. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
Note the value of the key INST_LOC, this is the location of the
Oracle Universal Installer (OUI). The default location is
C:\Program Files\Oracle\Inventory. If this value is different,
make
note of it, so we can delete these files later.
Delete this ORACLE key.
3.c. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC and expand all subkeys and
remove all keys under here which are related with the
"Oracle ODBC Driver"
3.d. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and
remove
all keys under here that begin with ORACLE or ORAWEB.
3.e. Go to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\...
...\Application and remove all keys under here that begin with
ORACLE.
3.f. Go to
HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\...
...\Uninstall and remove any entries related to Oracle.
3.g. Go to HKEY_CLASSES_ROOT, remove all keys that begin with Ora or
ORCL
(e.g. Oracle..., ORADC..., ORAMMC..., OraOLE..., OraPerf... and
ORCL...).
3.h. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Classes, remove all keys that
begin
with Ora or ORCL
(e.g. Oracle..., ORADC..., ORAMMC..., OraOLE..., OraPerf... and
ORCL...).
3.i. Go to HKEY_CURRENT_USER\Software\Oracle, delete this ORACLE key.
3.j. Go to HKEY_USERS\匼Software\Oracle, delete this ORACLE key.
3.k. Close the registry.
4. Clean up the environment settings:
----------------------------------
4.a. NT: Choose Start > Settings > Control Panel > System >
Environment tab
2000,XP: Choose Start > Settings > Control Panel > System >
Advanced tab > Environment variables.
4.b. At "System Variables" click on the variable PATH in order to
modify
the value. For example, you may see a path similar to this one:
C:\ORACLE\ORA81\BIN;C:\PROGRAM FILES\ORACLE\JRE\1.1.7\BIN
4.c. If an %ORACLE_HOME% was installed, remove this %ORACLE_HOME%\BIN
path.
4.d. If JRE was installed by Oracle, remove the JRE path.
4.e. If there is a CLASSPATH variable under "System Variables", first
make
note of the path defined, then delete it. This variable can be
added
back at a later date if needed.
4.f. Check if there are any other Oracle variables set in "System
Variables",
ORACLE_HOME, ORACLE_SID, TNS_ADMIN, JSERV or WV_GATEWAY_CFG. If
these
exist, delete them also.
4.g. Click on APPLY and OK.
4.h. Close the Control Panel window.
5. Delete the software and icons:
------------------------------
5.a. NT: Choose Start > Programs > Windows NT Explorer.
2000,XP: Choose Start > Programs > Accessories > Windows
Explorer.
5.b. NT: Go to %SystemDrive%\WINNT\PROFILES\ALL USERS\START
MENU\PROGRAMS
2000,XP: Go to %SystemDrive%\DOCUMENTS AND SETTINGS\ALL USERS\...
...\START MENU\PROGRAMS
Note 1: These locations depend on whether OS was upgraded from
NT, or
this was a fresh install of 2000/XP.
Note 2: To locate your System Drive, type in DOS-box: echo
%SystemDrive%
and delete the following icons:
- Oracle Installation Products
- PRODUCT_NAME - HOME_NAME e.g.
Oracle for Windows NT - Dev6i
Oracle Reports 6i - Dev6i
Oracle Olap Client 2.2 - Dev6i
Oracle9i Lite
Oracle - OraHome92
5.c. Go to %SystemDrive%\Program Files\Oracle or the location of
INST_LOC as
noted earlier in step 3.b. and delete this directory.
Note: In order to successfully delete all files, you may have to
reboot
your computer first, in order to clear Operating System
locks
on those files.
5.d. Go to the temporary directory and delete all files and
directories in
here (see note in 5.c.).
NT: %SystemDrive%\Temp
2000,XP:
%SystemDrive%\Documents and Settings\<username>\Local
Settings\Temp\
5.e. Go to the drive where the Oracle software is installed on your
machine
and delete all ORACLE_BASE directories on your hard drive (see
note in
5.c.).
5.f. Close the Windows Explorer / Windows NT Explorer.
6. Finish the removal:
-------------------
6.a. Empty the recycle bin
Right click on recycle bin > Empty Recycle Bin.
6.b. Reboot your computer.
6.c. Optionally: If you are on Windows 2000 or XP run the System
Defragmenter
utility:
- from Control Panel, select Administrative Tools > Computer
Management
- expand Storage, then select Disk Defragmenter
- highlight each virtual drive, in turn, and click Defragment
- reboot your computer when finished.
B. Removing Components on Windows 95 or Windows 98.
---------------------------------------------------
To remove all Oracle components from a computer on Windows 95/Windows
98:
1. Remove the entries in the Windows registry:
-------------------------------------------
1.a. Start the registry editor at the MS-DOS command prompt:
C:\> REGEDIT
1.b. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
Note the value of the key INST_LOC, this is the location of the
Oracle
Universal Installer. The default location is
C:\Program Files\Oracle\Inventory
If this value is different, make note of it, so we can delete
these files
later. Delete this ORACLE key.
1.c. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC and expand all subkeys and
remove all keys under here which are related with the
"Oracle ODBC Driver".
1.d. Go to:
HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Uninstall
and remove any entries related to Oracle.
1.e. Go to HKEY_CLASSES_ROOT, remove all keys that begin with Ora or
ORCL
(e.g. Oracle..., ORADC..., ORAMMC..., OraOLE..., OraPerf... and
ORCL...).
1.f. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Classes, remove all keys that
begin
with Ora or ORCL
(e.g. Oracle..., ORADC..., ORAMMC..., OraOLE..., OraPerf... and
ORCL...).
1.g. Go to HKEY_CURRENT_USER\Software\Oracle, delete this ORACLE key.
1.h. Go to HKEY_USERS\匼Software\Oracle, delete this ORACLE key.
1.i. Close the registry.
2. Clean up the environment settings:
----------------------------------
2.a. Open your AUTOEXEC.BAT with an editor to modify the PATH
variable.
For example, you may see a path similar to this one:
C:\ORACLE\ORA81\BIN;G:\PROGRAM FILES\ORACLE\JRE\1.1.7\BIN .
2.b. If an %ORACLE_HOME% was installed, remove this %ORACLE_HOME%\BIN
path.
2.c. If there is a CLASSPATH variable set in the AUTOEXEC.BAT, first
make note
of the path defined, then delete it. This variable can be added
back at
a later date if needed.
2.d. If JRE was installed by Oracle, remove the JRE path.
2.e. Save the AUTOEXEC.BAT file and close the edit.
3. Delete the software and icons:
------------------------------
3.a. Choose Start > Programs > Windows Explorer.
3.b. Go to SYSTEM_DRIVE:\WINDOWS\START MENU\PROGRAMS
and delete the following icons:
- Oracle - HOME_NAME
where HOME_NAME is the previous Oracle home name.
- Oracle Installation Products
3.c. Go to SYSTEM_DRIVE:\Program Files\Oracle or the location of
INST_LOC as
noted earlier in step 1.b and delete this directory.
3.d Go to SYSTEM_DRIVE:\Temp and delete all files and directories in
here.
3.e. Go to the drive where the Oracle software is installed on your
machine
and delete all ORACLE_BASE directories on your hard drive.
3.f. Remove any Oracle-related .INI files that may exist in the
Windows
directory. The Windows directory may be found by entering
"echo %WINDIR%" from a command prompt.
Typical Oracle .INI files include ORADIM73.INI, ORADIM80.INI,
ORACLE.INI, ORAODBC.INI
3.g. Close the Windows Explorer.
4. Finish the removal:
-------------------
4.a. Empty the recycle bin
Right click on recycle bin > Empty Recycle Bin
4.b. Reboot your computer.
Bob Jones
<x...@oraclexg.com> wrote in message
news:1145515759.2...@u72g2000cwu.googlegroups.com...
Yup, Oracle may have gotten too carried away with the Java stuff. They are
using it where ever possible. JVM is a problematic, memory robbing, slow
beast we all have to put up with.
> SQL Server, especially Yukon is a MUCH better dbms in my opinion, the
> only reason Oracle will continue to survive is
>
> a) Anti-Microsoft Zealots and Bigots .. and ..
> b) The huge installed base of Oracle (It isn't easy porting your DBMS
> from Oracle to SQL Server).
>
>
Also because it runs on many platforms and has more advanced features.
ianal Vista
news:KAC2g.4831$Lm5....@newssvr12.news.prodigy.com:
such as exactly where?
"problematic"? such as where & demonstrated by which metrics?
> robbing, slow beast we all have to put up with.
Based upon which reproducable and measurable metrics compared to what?
Bob Jones
"ianal Vista" <ianal...@hotmail.com> wrote in message
news:Xns97ADDFE8FA98Eia...@70.169.32.36...
I am not sure where your fixation on metrics is coming from. Some experience
will help.
Dusan Bolek
x...@oraclexg.com wrote:
> http://codebetter.com/blogs/sahil.malik/archive/2004/08/28/23563.aspx
> wrote:
>
> Allright, so I installed Oracle personal edition on my desktop. Here
> are my peeves against oracle -
My problem with Oracle PE is that it doesn't run on any decent
operating system. One would expect more from company that is giving
cute little penguins as christmas presents. :-(
--
Dusan Bolek
HansF
I concur.
I've tried on several occasions to get Linux people to speak up on this.
No one does. So Oracle doesn't realize that PE on Linux is an
opportunity.
Possibly because they think PE is 'less than SE', whereas PE is actually
'more than EE' in capability, just licensed for a max of one user.
--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting [replies] guarantees I won't respond. ***
HansF
I concur.
I've tried on several occasions to get Linux people to speak up on this.
No one does. So Oracle doesn't realize that PE on Linux is an
opportunity.
Possibly because they (Linux developers) think PE is 'less than SE',
whereas PE is actually 'more than EE' in capability, just licensed for a
max of one user.
And possibly because of the 'old school' Linux thinking "if it ain't free,
it ain't good".
JEDIDIAH
> "Bob Jones" <em...@me.not> wrote in
> news:KAC2g.4831$Lm5....@newssvr12.news.prodigy.com:
>
>>
>> <x...@oraclexg.com> wrote in message
>> news:1145515759.2...@u72g2000cwu.googlegroups.com...
>> Yup, Oracle may have gotten too carried away with the Java stuff. They
>> are using it where ever possible. JVM is a problematic, memory
>
> such as exactly where?
> "problematic"? such as where & demonstrated by which metrics?
>
>> robbing, slow beast we all have to put up with.
>
> Based upon which reproducable and measurable metrics compared to what?
The tendency to leak memory, run amok and consume the resources
of an entire machine. This tended to be the big problem in the last shop
where a JVM based application server was used.
Now Java apps aren't necessarily bad. Oracle just sets a bad example.
Most Oracle GUI tools just encourage me to write more shell scripts
and use sqlplus more.
--
The best OS in the world is ultimately useless |||
if it is controlled by a Tramiel, Jobs or Gates. / | \
Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com
JEDIDIAH
> On Sun, 23 Apr 2006 22:24:08 -0700, Dusan Bolek wrote:
>
>>
>> x...@oraclexg.com wrote:
>>> http://codebetter.com/blogs/sahil.malik/archive/2004/08/28/23563.aspx
>>> wrote:
>>>
>>> Allright, so I installed Oracle personal edition on my desktop. Here are
>>> my peeves against oracle -
>>
>> My problem with Oracle PE is that it doesn't run on any decent operating
>> system. One would expect more from company that is giving cute little
>> penguins as christmas presents. :-(
>
> I concur.
>
> I've tried on several occasions to get Linux people to speak up on this.
> No one does. So Oracle doesn't realize that PE on Linux is an
> opportunity.
>
> Possibly because they think PE is 'less than SE', whereas PE is actually
> 'more than EE' in capability, just licensed for a max of one user.
XE will never be used to power a realtime datawarehouse that can
eat multiple 9980's for breakfast, a few E15K's for lunch and still be
ready to devour something else for dinner.
XE is infact rediculously crippled even for an educational tool.
I can see why people with easy access to postgres or mysql would not
pay much attention to it (XE).
Bob Jones
"JEDIDIAH" <je...@nomad.mishnet> wrote in message
news:cimvh3-...@nomad.mishnet...
> On 2006-04-23, ianal Vista <ianal...@hotmail.com> wrote:
>> "Bob Jones" <em...@me.not> wrote in
>> news:KAC2g.4831$Lm5....@newssvr12.news.prodigy.com:
>>
>>>
>>> <x...@oraclexg.com> wrote in message
>>> news:1145515759.2...@u72g2000cwu.googlegroups.com...
> [deletia]
>>> Yup, Oracle may have gotten too carried away with the Java stuff. They
>>> are using it where ever possible. JVM is a problematic, memory
>>
>> such as exactly where?
>> "problematic"? such as where & demonstrated by which metrics?
>>
>>> robbing, slow beast we all have to put up with.
>>
>> Based upon which reproducable and measurable metrics compared to what?
>
> The tendency to leak memory, run amok and consume the resources
> of an entire machine. This tended to be the big problem in the last shop
> where a JVM based application server was used.
>
> Now Java apps aren't necessarily bad. Oracle just sets a bad example.
>
> Most Oracle GUI tools just encourage me to write more shell scripts
> and use sqlplus more.
>
> --
On top of that, Oracle apps use Oracle Java, IBM apps use IBM Java, and some
other apps need Sun Java. Just think of what kind of mess you can run into.
hans
>> Possibly because they think PE is 'less than SE', whereas PE is actually
>> 'more than EE' in capability, just licensed for a max of one user.
>
> XE will never be used to power a realtime datawarehouse that can
> eat multiple 9980's for breakfast, a few E15K's for lunch and still be
> ready to devour something else for dinner.
>
> XE is infact rediculously crippled even for an educational tool.
>
SO what does this have to do with PE?
JEDIDIAH
Considering that an attempt to seek out a 10g version of PE
gets you sent to a download page for XE: quite a lot I would imagine.
--
Linux: because everyone should get to drink the beer of their |||
choice and not merely be limited to pretensious imports or hard cider. / | \