4 ms·
Oracle SQL and PL/SQL is the better side of Oracle. Having to install and maintain Oracle software is the real hell. You sometimes need a patch for the install
by forinti 5y ago
Oracle SQL and PL/SQL is the better side of Oracle.
Having to install and maintain Oracle software is the real hell. You sometimes need a patch for the installer (I kid you not, the OAM 12.2.1.4 installer needs a patch to work on Oracle Linux). The syntax for Advanced Rules in OAM is not completely described in the manual, the examples are wrong, and you have to disable the parser in version 12.2.1.4 because it is doesn't work.
It seems every little task turns into an investigation into a series of bugs, errors, and undocumented features.
- tracker1 5y agoI hate that you have to install the Oracle Client, which is its' own byzantine exercise in frustration to use an application that talks to Oracle. Most other databases, the application includes a library that communicates to the DB via a protocol implementation... Oracle doesn't want this kind of use case.
- orthoxerox 5y agoThere are rather usable clients for Java and .Net that do not require that. Well, the .Net one silently converts async calls to sync, but Oracle wouldn't be Oracle without nasty surprises.
- sebazzz 5y agoWe had an extra optional curriculum on university, and to pass you had to successfully install Oracle.
- chasil 5y agoThe Oracle 19.3 installer must be used to install on RedHat/Oracle Linux 8, but nothing lower that 19.6 will run on this OS. Two patch sets must be applied to the nonfunctional installer before it will work, which was quite hostile to learn and master. At least with 11.2, a new install set was issued for RedHat 7.