Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

oracle generica binary for linux .

hi,

as MySQL installation has generic binary build so MySQL can be install without yum and therefore yum is not going to keep asking for dependence, which some bank do not allow that.

how about Oracle DB, like 18c and 19c, any generic binary for linux for download so that for any production/UAT/SiT platform, so that no need yum and download all dependnece one by one ?
Avatar of David Favor
David Favor
Flag of United States of America image

Imagining you only have a single binary for MySQL or MariaDB... is likely incorrect, as both these products implement storage engines as loadable modules for the database server. They database client mysql tool is normally a standalone binary.

And both client + server packages for MariaDB/MySQL involve many files, so likely your mysql client will also require many libraries.

The only way to install MariaDB/MySQL/Oracle/PostgreSQL or any any other SQL server/client package is by using apt (Debian/Ubuntu) or yum/rpm (RedHat/CentOS/Fedora).

If you try installing a single executable, for this to work, you must build the product from source as a standalone binary, so with --disable-shared passed at every build step.

Since Oracle isn't available as source, you can certainly accomplish this... if you have unlimited time + budget... by running lld on the exact binary file, then do a copy on every referenced .so in the load map. Also your client/server will most likely still crash, so for first few crashes, you'll record the crash message, which will contain the dynamically loaded .so files, then copy these over too.

Likely you can come close to a working system in a few hours to a few days.

Be sure to collect all these .so files in one place so you can use LD variable hacks like LD_LIBRARY_PATH setting (or however your Distro does this) so you can point your binary to all the .so files you downloaded.

Note: You'll have to go through this same process every time you update the binary too.
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

@David,
I believe the question is how to install without using yum.

Oracle has a ZIP file that you can use:
https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html

You can use the Image Based Installation:
https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/about-image-based-database-installation.html#GUID-0315AA15-1C03-4E96-B801-3A8E5F5D4B39

To install Oracle Database, create the new Oracle home, extract the image file into the newly-created Oracle home, and run the setup wizard to register the Oracle Database product.


Note:  You must extract the image software (db_home.zip) into the directory where you want your Oracle Database home to be located, and then run the Oracle Database Setup Wizard to start the Oracle Database installation and configuration. Oracle recommends that the Oracle home directory path you create is in compliance with the Oracle Optimal Flexible Architecture recommendations.
Avatar of marrowyung

ASKER

David Favor,

"The only way to install MariaDB/MySQL/Oracle/PostgreSQL or any any other SQL server/client package is by using apt (Debian/Ubuntu) or yum/rpm (RedHat/CentOS/Fedora)"

no.. for MySQL, it is so common for banking industry to not using RPM and yum to install MySQL here.

Do team here will usually use generic binary for it, just like Oracle SQL developer with java SDK included ! no need to install separately !

"If you try installing a single executable, for this to work, you must build the product from source as a standalone binary, so with --disable-shared passed at every build step."

look at MySQL download page, for each version it will have a tar.gz file, that is the one !

but I agree that, using that binary involve a lot more work then RPM ! specially when upgrading MySQL to newer version, but it works !

some banking has the requirement to not using RPM and yum as we don't know what RPM yum will download for dependence !

slightwv ,

"I believe the question is how to install without using yum."

basically yes but I am looking for the same thing in MySQL , sadly MariaDB do not have, they only offer RPM, I think that's why some large company here do not choose MariaDB but MySQL.

probably need to download this :  https://downloads.mariadb.com/MariaDB/mariadb-10.5.0/source/

"Oracle recommends that the Oracle home directory path you create is in compliance with the Oracle Optimal Flexible Architecture recommendations. "

what is Oracle Optimal Flexible Architecture recommendations  ?

"You can use the Image Based Installation:
https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/about-image-based-database-installation.html#GUID-0315AA15-1C03-4E96-B801-3A8E5F5D4B39"

so this means once we have this image we don't need RPM and yum any more?

create a home directory, and put that image inside that folder, then run setup, so this is it? no more command mode at all ? so we also UPGRADE using that setup too ? the setup is for windows or linux ? seems windows.....

I see this in that page:

Directions
Installation guides and general Oracle Database 19c documentation are here.

Open in new window


once clicked in, I don't see any installation or upgrade procedure at all, any idea?
SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Your installation options are very simple.

1) Build from source.

2) Install a package from your Distro's repository.

Any other method... means you're using a questionable source for your installation code, which shouldn't be done, especially for a bank.

Likely best you close out this question, then open another 2x questions, one for MariaDB + one for Oracle, as these are completely different pieces of software.
slightwv,

>>no more command mode at all ? 

I don't understand what you mean by this.

Open in new window


I mean, as according to the link we have to setup the db_home folder and has to run setup to start installation, then once run setup , the rest of the operation all via UI ?

"Oracle is pretty much unzip in a new home and "register" these days."

   this means still no installation at all but launch using new oracle DB image binary ?

David Favor,

"Likely best you close out this question, then open another 2x questions, one for MariaDB + one for Oracle, as these are completely different pieces of software."

I only focus on Oracle but not MySQL, I meant I am running MySQL using generic binary already and how can i do the same thing for Oracle .

"1) Build from source.

2) Install a package from your Distro's repository."

 oracle's source is the IMAGE discuss above, right ? and  Distro's repository is for Oracle image installation too ? so we can find Oracle source from this repository ?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"If your question is installing without yum, no need to do what David is suggesting"

yeah, no yum and no rpm package dependence need to download, this is what I meant.

":You need to run the setup to do all the registration that makes it all work"

the setup will setup everything, right ? not just do all registration ?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
tks.
tks all.