📜 ⬆️ ⬇️

What should be the installer. Oracle Master Class


The theater begins with a hanger, and the software product begins with the installer. We all at least once installed the program and we know that often by the way the installation program is done, we can judge the attitude of the developers to the entire software product.
Also, everyone has heard about such a "monster", "evil corporation" that buys Sun, is suing Google, etc. This is Oracle Corporation, which employs more than 100 thousand employees.
By the nature of my business, I had to deal with the company's flagship DBMS, Oracle Database 11g Release 2.
Before that, my communication with this DBMS was frozen on version 9i and now, although spoiled by another well-known DBMS, I decided to take pleasure in the engineering of Oracle Corporation.

Below you will get acquainted with my first impressions.

Introduction


When I look at the interfaces of software products of Oracle Corporation, it seems to me that these wonderful people flew in from another planet and live in some kind of conserved world where there is no competition, as well as testers and user interface specialists.

Breaking stereotypes


When you install a program, where do you think it is most logical to install it? That's right - in c: \ app \ Administrator, well, or f: \ app \ Administrator. Depending on where you have more free space. And the best placement of database files is, of course, c: \ app \ Administrator \ oradata
')


The equipment of your civilization is unknown to us.


When checking the requirements, I was never able to find out if the computer meets the minimum requirements for installation. That on Windows Server 2008 R2, that for 2003 R2 the answer to me was short: “n / a”.


It’s good that there is a “Ignore All” checkbox, otherwise Oracle Database 11g Release 2 would not be installed at all, because “Next” button is not active.

This is not a bug, this is a feature.


Well, suppose everything is set correctly:



Something with my memory has become


We start SQL Developer. It requires you to specify the path to java.exe, dear, didn’t you yourself recently asked where to install? Sclerosis? As the colleagues noted, “it’s good that at least the“ Browse ”button exists.”


Java even found two copies. And that is good.



Low self-esteem


We create connections to a DB. With these settings (the default!), We will not be able to connect to the database. The fact is that the default is SID "xe" - short for eXpress Edition. And we were installed with the default settings (SID "orcl").


The humor is that with Oracle eXpressEdition the SQL Developer software is not supplied.

findings


Why did I write this topic? I can't understand why Oracle Corporation does this to its products. Is it an artificial increase in the technology entry threshold for developers or just the slob of a manufacturing company?

Adding


Already after writing the topic, I found a very interesting document from Oracle Corporation, which contains “independent peer review” of a comparative study of labor costs for managing Oracle Database 10g Release 2 and Microsoft SQL Server 2005 databases.
I recommend reading. Separate label comparing the installation process .
Based on such analytical studies for a long time, you can think that all is well.

Source: https://habr.com/ru/post/104789/


All Articles