oracle generica binary for linux .

marrowyung
marrowyung used Ask the Experts™
on
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 ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
David FavorFractional CTO
Distinguished Expert 2018

Commented:
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.
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
@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.
marrowyungSenior Technical architecture (Data)

Author

Commented:
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?
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
>>what is Oracle Optimal Flexible Architecture recommendations  ?

In the doc link I posted, look at Appendix C:
https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/optimal-flexible-architecture.html#GUID-34434C8B-EBEE-497A-BB92-26B43561B6B1

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

Not for Oracle installs.

>>no more command mode at all ?

I don't understand what you mean by this.

>>so we also UPGRADE using that setup too ?

Unless you are installing a patch, Oracle is pretty much unzip in a new home and "register" these days.

>>the setup is for windows or linux ? seems windows.....

I posted the Linux doc link but both OS's are pretty much the same now.
David FavorFractional CTO
Distinguished Expert 2018

Commented:
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.
marrowyungSenior Technical architecture (Data)

Author

Commented:
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 ?
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
>>   this means still no installation at all but launch using new oracle DB image binary ?

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

If your question is installing without yum, no need to do what David is suggesting.  I believe he didn't understand what you were asking.
marrowyungSenior Technical architecture (Data)

Author

Commented:
"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 ?
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
>>the setup will setup everything, right ? not just do all registration ?

From my very first post:
and run the setup wizard to register the Oracle Database product

I'm not sure what else you mean by "setup everything".

I would suggest you read through the install guide I provided in my first post.  It will tell you everything you need to know.

Farther down in that doc there is "Installing the Oracle Database Software".

Which gets you to "Running Oracle Database Setup Wizard to Install Oracle Database".

It has everything you need to know.
marrowyungSenior Technical architecture (Data)

Author

Commented:
tks.
marrowyungSenior Technical architecture (Data)

Author

Commented:
tks all.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial