Oracle for linux mint

Linux Mint Forums

How to install Oracle Databse 18C-XE (rpm) on Linux Mint

Forum rules
Before you post please read how to get help. Topics in this forum are automatically closed 6 months after creation.

How to install Oracle Databse 18C-XE (rpm) on Linux Mint

Post by lhqution » Fri Nov 15, 2019 5:20 pm

How to install Oracle Database 18C-XE .rpm file? i searched that and found https://askubuntu.com/questions/1095737 . untu-18-04 but i think second step not succeed and i can’t complete the final step the deb part.

 sudo alien --scripts oracle-database-xe-18c-1.0-1.x86_64.rpm

warning: oracle-database-xe-18c-1.0-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEYdpkg-shlibdeps: error: cannot find library libclntsh.so.18.1 needed by debian/oracle-database-xe-18c/opt/oracle/product/18c/dbhomeXE/bin/xmlpatch (ELF format: 'elf64-x86-64' abi: '0201003e00000000'; RPATH: '') dpkg-shlibdeps: warning: can't extract name and version from library name 'libsc_ut.so' dpkg-shlibdeps: warning: can't extract name and version from library name 'libsc_ut.so' exit code 2 dh_shlibdeps: Aborting due to earlier error debian/rules:17: recipe for target 'binary-arch' failed make: [binary-arch] Error 2 (ignored) dh_gencontrol dpkg-gencontrol: warning: Depends field of package oracle-database-xe-18c: unknown substitution variable $ dh_md5sums dh_builddeb dpkg-deb: error: control directory has bad permissions 777 (must be >=0755 and <=0775) dh_builddeb: dpkg-deb --build debian/oracle-database-xe-18c .. returned exit code 2 dh_builddeb: Aborting due to earlier error debian/rules:17: recipe for target 'binary-arch' failed make: *** [binary-arch] Error 2 

Which path i should enter the final step i can't see the deb file ( That if the second step succeeded)? anyway the output (the same path)

 sudo apt install oracle-database-xe-18c-1.0-1.x86_64.rpm.deb Reading package lists. Done Building dependency tree Reading state information. Done E: Unable to locate package oracle-database-xe-18c-1.0-1.x86_64.rpm.deb E: Couldn't find any package by glob 'oracle-database-xe-18c-1.0-1.x86_64.rpm.deb' E: Couldn't find any package by regex 'oracle-database-xe-18c-1.0-1.x86_64.rpm.deb' 

Last edited by LockBot on Wed Dec 28, 2022 7:16 am, edited 1 time in total.
Reason: Topic automatically closed 6 months after creation. New replies are no longer allowed.

Re: How to install Oracle Databse 18C-XE (rpm) on Linux Mint

Post by ajgringo619 » Fri Nov 15, 2019 6:02 pm

sudo apt deb oracle-database-xe-18c-1.0-1.x86_64.rpm.deb

Re: How to install Oracle Databse 18C-XE (rpm) on Linux Mint

Post by lhqution » Sat Nov 16, 2019 2:45 am

sudo apt deb oracle-database-xe-18c-1.0-1.x86_64.rpm.deb

There is no deb file ( founded ) i think that can be done successfully if the second step " alien rpm file " succeed
The file type is .rpm i even searched inside the extracted folders.

smurphos Level 18
Posts: 8501 Joined: Fri Sep 05, 2014 12:18 am Location: Irish Brit in Portugal Contact:

Re: How to install Oracle Databse 18C-XE (rpm) on Linux Mint

Post by smurphos » Sat Nov 16, 2019 3:02 am

Some googling suggests there are a lots of hoops to jump through to get this working on Debian/Ubuntu based systems - e.g. see some of the responses in this thread on the Oracle forums - https://community.oracle.com/thread/418 . 0&tstart=0

For custom Nemo actions, useful scripts for the Cinnamon desktop, and Cinnamox themes visit my Github pages.

Re: How to install Oracle Databse 18C-XE (rpm) on Linux Mint

Post by lhqution » Sun Nov 17, 2019 8:42 pm

smurphos wrote: ⤴ Sat Nov 16, 2019 3:02 am see some of the responses in this thread on the Oracle forums - https://community.oracle.com/thread/418 . 0&tstart=0

Sorry for my late reply, i saw the link there is an reply about installation the zip file instead of rpm file but unfortunately it seems for the 18c version not the express one i can not find the zip file for XE version .

I saw this https://www.linuxquestions.org/question . 175648196/ most posts about "that it is not supported on Ubuntu / Linux Mint and you should install it on other supported distributions etc but there is another important point there the old version Oracle Database 11g Release 2 Express Edition working on Ubuntu/Linux Mint, so i installed it the deb file was generated successfully details for who don't know how / Link:https://mikesmithers.wordpress.com/2011 . nd-ubuntu/ but i just skipped the other steps ( what after the deb part)

In short : i installed Oracle database 11g-XE until Oracle just provide deb file for Linux Mint or i was able to fix that somehow.
I might make this Topic/Post "solved" soon but before that i might search more about Linux Mint supporting point etc or update this post if something changed.

phd21 Level 20
Posts: 10102 Joined: Thu Jan 09, 2014 9:42 pm Location: Florida

Re: How to install Oracle Databse 18C-XE (rpm) on Linux Mint

Post by phd21 » Sun Nov 17, 2019 10:01 pm

I just read your post and the good replies to it. Here are my thoughts on this as well.

I think you might first have to install the "oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm" before installing the "oracle-database-xe-18c-1.0-1.x86_64.rpm" file. Obviously both of these would have to be converted into deb files using the "alien" software first. I have not been able to download the actual database rpm yet, maybe a browser issue?

install some dependencies

sudo apt-get install binutils net-tools

curl -o oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

FYI:
How to install Oracle Database 18c XE on Linux – Gerald on IT
https://geraldonit.com/2018/10/23/how-t . -on-linux/

ORACLE-BASE - Oracle Database 18c Express Edition (XE) RPM Installation On Oracle Linux 6 (OL6) and 7 (OL7)
https://oracle-base.com/articles/18c/or . ux-6-and-7

Phd21 : Mint 20 Cinnamon & xKDE (Mint Xfce + Kubuntu KDE) & KDE Neon 64-bit (new based on Ubuntu 20.04) Awesome OS's , Dell Inspiron I5 7000 (7573) 2 in 1 touch screen, Dell OptiPlex 780 Core2Duo E8400 3GHz,4gb Ram, Intel 4 Graphics.

Re: How to install Oracle Databse 18C-XE (rpm) on Linux Mint

Post by lhqution » Tue Nov 19, 2019 5:53 pm

Reply to some parts
Sorry for my late reply, for the first dependencies i think i installed before, but "preinstall rpm" i just installed it successfully after converting it to deb file, for the links you posted or linked i think for other distributions and the steps not for or working with Mint.

i faced something like that a temporary error at login may be a Server/Network/VPN issue etc before downloading fixed by re login refreshing etc. just try again this might fix that.

Now this might be the key for this issue
I just have a theory i was testing and found something when i am trying to " sudo alien " an rpm file on partition which" Linux not installed on it /mounted" The deb generation failed but if i moved it to the Linux Partition Then the process succeed as i remember i tested that with the ( Oracle 11g-XE rpm / the preinstall file rpm ) which i think it is might the key for this

But the ironic side that i can't test that on oracle 18c-XE rpm file on Linux Partition because there is no space or barely enough to test that right now the file converting and the installation require some space, i am working on that anyway but if i did not free some space soon or just stick with the old version i might mark the topic "solved" but with this note that i did not test that practically .

anyway if you have an idea or interesting and for Linux learning purpose is the path or the partition can affect " alien /converting to deb " process and how if it is like extracting converting not installation ?

Источник

Install Oracle Database on Linux Mint

This is an Easy and Step-by-Step Guide to Install the Oracle 11g R2 Database on Linux Mint 13 Maya Cinnamon 32bit/64bit Desktop.

Ubuntu-like Systems are Not in the List of Oracle 11g Database Supported OS So you should Be Carefull and Use It At Most for Development and Not As Production Database Server!

The Guide Include All the Essentials Commands and Basic Screenshots of the Installation Process.

The Process is somewhat Extended and Advanced so it Demand some Basic Command Line Confidence.

Now Relax and Take the Time of Reading, Understanding and Executing Carefully the Instructions Contained here.

To the Post Bottom you Find Link to Oracle 11g Database Installation Troubleshooting Guides.

apt-get install alien autoconf automake autotools-dev binutils doxygen \ elfutils expat gawk gcc gcc-multilib g++-multilib ksh less lesstif2 \ lesstif2-dev lib32z1 libaio1 libaio-dev libc6-dev libelf-dev libltdl-dev \ libmotif4 libodbcinstq4-1 libpth-dev libpthread-stubs0 libpthread-stubs0-dev \ libstdc++5 lsb-cxx make openssh-serverpdksh rlwrap rpm sysstat unixodbc \ unixodbc-dev x11-utils zlibc

ln -s /usr/bin/basename /bin/basename

useradd -u 502 -g oinstall -G dba,asmadmin,oper -s /bin/bash -m oracle

mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1

chown -R oracle:oinstall /u01

#### Oracle 11g Kernel Parameters #### fs.suid_dumpable = 1 fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 # semaphores: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default=4194304 net.core.rmem_max=4194304 net.core.wmem_default=262144 net.core.wmem_max=1048586

#net.bridge.bridge-nf-call-ip6tables = 0 #net.bridge.bridge-nf-call-iptables = 0 #net.bridge.bridge-nf-call-arptables = 0

nano /etc/security/limits.conf

#### oracle User Settings 4 Oracle 11g #### oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240

unzip linux_11gR2_database_1of2.zip

unzip linux_11gR2_database_2of2.zip

chown -R oracle:oinstall database

# Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME= ; export ORACLE_HOSTNAME ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME ORACLE_SID= ; export ORACLE_SID PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

sed -i 's/^\(ORACLE_LINKLINE.*\$(ORACLE_LINKER)\) \(\$(PL_FLAGS)\)/\1 -Wl,--no-as-needed \2/g' $ORACLE_HOME/rdbms/lib/env_rdbms.mk

If you Get: "Check if the DISPLAY variable is set. Failed". Look Link Below.Link2+ Oracle 11g Database TroubleshootingOn the first screen If you Do Not Dispose of an Oracle Subscription Just Leave Blank eMail and Un-Check the Demand of Security Update Support then Click on NextThen Confirm on Warning and Follow. On "Select Installation Option" Select "Install database software only" and Click on NextOn Step 3 Leave Default "Single instance database installation" and Click on NextOn Step 4 Select your Language and Click on NextOn Step 5 Leave Default Enterprise Edition and Click on NextOn "Installation Location" Set All As Here Below and Click on Next

• Oracle Base: /u01/app/oracle
• Software Location: /u01/app/oracle/product/11.2.0/dbhome_1

These are the Same Settings Inserted into the .bash_profile File.

On "Create Inventory" if you Setup the Path on .bash_profile Like Here Leave Default and Click on Next

On "Operating System Groups" if you Setup the Path on .bash_profile Like Here Leave Default and Click on Next

On "Prerequisite Checks" you will Get Easily a "Warning Message" about some Missing Requirements

Just Check: "Ignore All" and Follow Up with Installation.

Check Ignore All and Follow.

On the "Summary" Click on "Save Response File" to Take Note of Settings and then Click on Finish

The Installation Product Procedure should Start.

Execute Scripts Right Before the End of Process a Pop-Up Window will Show the Path to Two Configuration Scripts you Need to Execute on Terminal! Last Oracle Should Confirm you of a Successful Installation! 🙂

After you Should Access the "Enterprise Manager" on Browser by the URL shown on the Last Screen. On a Localhost for Example you Should Access the Enterprise Manager by the Address:

And you can Login with: User Name: SYS Password: oracleDatabasePassword From the Drop-down below Select >> Connect as SYSDBA You Should be Able to Access the Database by the Enterprise Manager!

Источник