{"id":13917,"date":"2020-04-07T22:53:01","date_gmt":"2020-04-07T20:53:01","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/setup-oracle-xe-on-linux-mint-a-funny-exercise\/"},"modified":"2020-04-07T22:53:01","modified_gmt":"2020-04-07T20:53:01","slug":"setup-oracle-xe-on-linux-mint-a-funny-exercise","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/setup-oracle-xe-on-linux-mint-a-funny-exercise\/","title":{"rendered":"Setup Oracle XE on Linux Mint – a funny exercise"},"content":{"rendered":"

On my old Laptop (Acer Travelmate with an Intel Celeron N3160 CPU) I wanted to install Oracle XE. Currently the available XE version is 18.4. My Laptop runs on Linux Mint 19.3 (Tricia). The Blog will describe the steps I had to follow (steps for Ubuntu would be similar).<\/p>\n

REMARK: The following steps were done just for fun and are not supported and not licensable from Oracle. If you follow them then you do it at your own risk \ud83d\ude09<\/p>\n

Good instructions on how to install Oracle XE are already available here<\/a>.<\/p>\n

But the first issue not mentioned in the instructions above is that Oracle can no longer be installed on the latest Mint version due to a change in glibc. This has also been described in various blogs about e.g. installing Oracle on Fedora 26 or Fedora 27<\/a>. The workaround for the problem is to do the following:<\/p>\n

\ncd $ORACLE_HOME\/lib\/stubs\nmkdir BAK\nmv libc* BAK\/\n$ORACLE_HOME\/bin\/relink all\n<\/code><\/pre>\n
This brings us to the second issue. Oracle does not provide you with a mechanism to relink Oracle XE. You can of course relink an Enterprise Edition or a Standard Edition 2 version, but relinking XE is not possible because lots of archives and objects are not available in a XE-release. So how can we achieve to install Oracle XE on Linux Mint then? This needs a bit of an unsupported hack by copying archive and object-files from an Enterprise Edition version to XE, but I’ll get to that later.<\/p>\n
So here are the steps to install Oracle XE on Linux Mint (if not separately mentioned, the steps are done as root. I.e. you may prefix your command with a “sudo” if you do not login to root directly):<\/p>\n
1. Install libaio and alien<\/p>\n
\nroot@clemens-TravelMate:~# apt-get update && apt-get upgrade\nroot@clemens-TravelMate:~# apt-get install libaio*\nroot@clemens-TravelMate:~# apt-get install alien\n<\/code><\/pre>\n
2. Download the Oracle rpm from here<\/a> and convert it to a deb-file<\/p>\n
\nroot@clemens-TravelMate:~# cd \/opt\/distr\nroot@clemens-TravelMate:\/opt\/distr# alien --script oracle-database-xe-18c_1.0-2_amd64.rpm\n<\/code><\/pre>\n
3. Delete the original rpm to save some space<\/p>\n
\nroot@clemens-TravelMate:\/opt\/distr# ls -l oracle-database-xe-18c_1.0-2_amd64.deb\n...\nroot@clemens-TravelMate:\/opt\/distr# rm oracle-database-xe-18c_1.0-2_amd64.rpm\n<\/code><\/pre>\n
4. Install the package<\/p>\n
\nroot@clemens-TravelMate:\/opt\/distr# dpkg -i oracle-database-xe-18c_1.0-2_amd64.deb\n<\/code><\/pre>\n
REMARK: In case the installation fails or the database cannot be created then you can find instructions on how to clean everything up again here<\/a>.<\/p>\n
5. Make sure your host has an IPv4 address in your hosts file<\/p>\n
\nroot@clemens-TravelMate:\/opt\/distr# more \/etc\/hosts\n127.0.0.1 localhost localhost.localdomain\n192.168.10.49 clemens-TravelMate.fritz.box clemens-TravelMate\n<\/code><\/pre>\n
6. Disable the system check in the configuration script<\/p>\n
\ncd \/etc\/init.d\/\ncp -p oracle-xe-18c oracle-xe-18c-cfg\nvi oracle-xe-18c-cfg\n<\/code><\/pre>\n
Add the parameter <\/p>\n
\n-J-Doracle.assistants.dbca.validate.ConfigurationParams=false \n<\/code><\/pre>\n
in line 288 of the script, so that it finally looks as follows:<\/p>\n
\n    $SU -s \/bin\/bash  $ORACLE_OWNER -c \"(echo '$ORACLE_PASSWORD'; echo '$ORACLE_PASSWORD'; echo '$ORACLE_PASSWORD') | $DBCA -silent -createDatabase -gdbName $ORACLE_SID -templateName $TEMPLATE_NAME -characterSet $CHARSET -createAsContainerDatabase $CREATE_AS_CDB -numberOfPDBs $NUMBER_OF_PDBS -pdbName $PDB_NAME -sid $ORACLE_SID -emConfiguration DBEXPRESS -emExpressPort $EM_EXPRESS_PORT -J-Doracle.assistants.dbca.validate.DBCredentials=false -J-Doracle.assistants.dbca.validate.ConfigurationParams=false -sampleSchema true $SQLSCRIPT_CONSTRUCT $DBFILE_CONSTRUCT $MEMORY_CONSTRUCT\"\n<\/code><\/pre>\n
7. Adjust user oracle, so that it has bash as its default shell<\/p>\n
\nmkdir -p \/home\/oracle\nchown oracle:oinstall \/home\/oracle\nvi \/etc\/passwd\ngrep oracle \/etc\/passwd\noracle:x:54321:54321::\/home\/oracle:\/bin\/bash\n<\/code><\/pre>\n
You may of course add a .bashrc or .bash_profile in \/home\/oracle.<\/p>\n
8. Adjust the Oracle make-scripts for Mint\/Ubuntu (I took the script from here<\/a>):<\/p>\n
\noracle@clemens-TravelMate:~\/scripts$ cat omkfix_XE.sh \n#!\/bin\/sh\n# Change the path below to point to your installation\nexport ORACLE_HOME=\/opt\/oracle\/product\/18c\/dbhomeXE\n# make changes in orld script\nsed -i 's\/exec gcc \"$@\"\/exec gcc -no-pie \"$@\"\/' $ORACLE_HOME\/bin\/orald\n# Take backup before committing changes\ncp $ORACLE_HOME\/rdbms\/lib\/ins_rdbms.mk $ORACLE_HOME\/rdbms\/lib\/ins_rdbms.mk.back\ncp $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk.back\ncp $ORACLE_HOME\/network\/lib\/env_network.mk $ORACLE_HOME\/network\/lib\/env_network.mk.back\ncp $ORACLE_HOME\/srvm\/lib\/env_srvm.mk $ORACLE_HOME\/srvm\/lib\/env_srvm.mk.back\ncp $ORACLE_HOME\/crs\/lib\/env_has.mk $ORACLE_HOME\/crs\/lib\/env_has.mk.back\ncp $ORACLE_HOME\/odbc\/lib\/env_odbc.mk $ORACLE_HOME\/odbc\/lib\/env_odbc.mk.back\ncp $ORACLE_HOME\/precomp\/lib\/env_precomp.mk $ORACLE_HOME\/precomp\/lib\/env_precomp.mk.back\ncp $ORACLE_HOME\/ldap\/lib\/env_ldap.mk $ORACLE_HOME\/ldap\/lib\/env_ldap.mk.back\ncp $ORACLE_HOME\/ord\/im\/lib\/env_ordim.mk $ORACLE_HOME\/ord\/im\/lib\/env_ordim.mk.back\ncp $ORACLE_HOME\/ctx\/lib\/env_ctx.mk $ORACLE_HOME\/ctx\/lib\/env_ctx.mk.back\ncp $ORACLE_HOME\/plsql\/lib\/env_plsql.mk $ORACLE_HOME\/plsql\/lib\/env_plsql.mk.back\ncp $ORACLE_HOME\/sqlplus\/lib\/env_sqlplus.mk $ORACLE_HOME\/sqlplus\/lib\/env_sqlplus.mk.back\ncp $ORACLE_HOME\/bin\/genorasdksh $ORACLE_HOME\/bin\/genorasdksh.back\n#\n# make changes changes in .mk files\n#\nsed -i 's\/$(ORAPWD_LINKLINE)\/$(ORAPWD_LINKLINE) -lnnz18\/' $ORACLE_HOME\/rdbms\/lib\/ins_rdbms.mk\nsed -i 's\/$(HSOTS_LINKLINE)\/$(HSOTS_LINKLINE) -lagtsh\/' $ORACLE_HOME\/rdbms\/lib\/ins_rdbms.mk\nsed -i 's\/$(EXTPROC_LINKLINE)\/$(EXTPROC_LINKLINE) -lagtsh\/' $ORACLE_HOME\/rdbms\/lib\/ins_rdbms.mk\nsed -i 's\/$(OPT) $(HSOTSMAI)\/$(OPT) -Wl,--no-as-needed $(HSOTSMAI)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/$(OPT) $(HSDEPMAI)\/$(OPT) -Wl,--no-as-needed $(HSDEPMAI)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/$(OPT) $(EXTPMAI)\/$(OPT) -Wl,--no-as-needed $(EXTPMAI)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/$(SPOBJS) $(LLIBDMEXT)\/$(SPOBJS) -Wl,--no-as-needed $(LLIBDMEXT)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\n \nsed -i 's\/$(S0MAIN) $(SSKRMED)\/$(S0MAIN) -Wl,--no-as-needed $(SSKRMED)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/$(S0MAIN) $(SSBBDED)\/$(S0MAIN) -Wl,--no-as-needed $(SSBBDED)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/$(S0MAIN) $(SSKRSED)\/$(S0MAIN) -Wl,--no-as-needed $(SSKRSED)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/$(S0MAIN) $(SKRNPT)\/$(S0MAIN) -Wl,--no-as-needed $(SKRNPT)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/$(S0MAIN) $(SSTRCED)\/$(S0MAIN) -Wl,--no-as-needed $(SSTRCED)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/$(S0MAIN) $(SSTNTED)\/$(S0MAIN) -Wl,--no-as-needed $(SSTNTED)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/$(S0MAIN) $(SSKFEDED)\/$(S0MAIN) -Wl,--no-as-needed $(SSKFEDED)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\n \nsed -i 's\/$(S0MAIN) $(SSKFODED)\/$(S0MAIN) -Wl,--no-as-needed $(SSKFODED)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/$(S0MAIN) $(SSKFNDGED)\/$(S0MAIN) -Wl,--no-as-needed $(SSKFNDGED)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/$(S0MAIN) $(SSKFMUED)\/$(S0MAIN) -Wl,--no-as-needed $(SSKFMUED)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/$(S0MAIN) $(SSKFSAGED)\/$(S0MAIN) -Wl,--no-as-needed $(SSKFSAGED)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/$(S0MAIN) $(DBGVCI)\/$(S0MAIN) -Wl,--no-as-needed $(DBGVCI)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/$(S0MAIN) $(DBGUCI)\/$(S0MAIN) -Wl,--no-as-needed $(DBGUCI)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/$(S0MAIN) $(SSKECED)\/$(S0MAIN) -Wl,--no-as-needed $(SSKECED)\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\n \nsed -i 's\/^(ORACLE_LINKLINE.*$(ORACLE_LINKER)) ($(PL_FLAGS))\/1 -Wl,--no-as-needed 2\/g' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/^(TNSLSNR_LINKLINE.*$(TNSLSNR_OFILES)) ($(LINKTTLIBS))\/1 -Wl,--no-as-needed 2\/g' $ORACLE_HOME\/network\/lib\/env_network.mk\nsed -i 's\/$LD $1G\/$LD -Wl,--no-as-needed $LD_RUNTIME\/' $ORACLE_HOME\/bin\/genorasdksh\nsed -i 's\/$(GETCRSHOME_OBJ1) $(OCRLIBS_DEFAULT)\/$(GETCRSHOME_OBJ1) -Wl,--no-as-needed $(OCRLIBS_DEFAULT)\/' $ORACLE_HOME\/srvm\/lib\/env_srvm.mk\nsed -i 's\/LDDISABLENEWDTAGS=-Wl,--disable-new-dtags\/LDDISABLENEWDTAGS=-Wl,--no-as-needed,--disable-new-dtags\/' $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk\nsed -i 's\/LDDISABLENEWDTAGS=-Wl,--disable-new-dtags\/LDDISABLENEWDTAGS=-Wl,--no-as-needed,--disable-new-dtags\/' $ORACLE_HOME\/crs\/lib\/env_has.mk;\nsed -i 's\/LDDISABLENEWDTAGS=-Wl,--disable-new-dtags\/LDDISABLENEWDTAGS=-Wl,--no-as-needed,--disable-new-dtags\/' $ORACLE_HOME\/odbc\/lib\/env_odbc.mk\nsed -i 's\/LDDISABLENEWDTAGS=-Wl,--disable-new-dtags\/LDDISABLENEWDTAGS=-Wl,--no-as-needed,--disable-new-dtags\/' $ORACLE_HOME\/precomp\/lib\/env_precomp.mk\nsed -i 's\/LDDISABLENEWDTAGS=-Wl,--disable-new-dtags\/LDDISABLENEWDTAGS=-Wl,--no-as-needed,--disable-new-dtags\/' $ORACLE_HOME\/srvm\/lib\/env_srvm.mk;\nsed -i 's\/LDDISABLENEWDTAGS=-Wl,--disable-new-dtags\/LDDISABLENEWDTAGS=-Wl,--no-as-needed,--disable-new-dtags\/' $ORACLE_HOME\/network\/lib\/env_network.mk\nsed -i 's\/LDDISABLENEWDTAGS=-Wl,--disable-new-dtags\/LDDISABLENEWDTAGS=-Wl,--no-as-needed,--disable-new-dtags\/' $ORACLE_HOME\/ldap\/lib\/env_ldap.mk\nsed -i 's\/LDDISABLENEWDTAGS=-Wl,--disable-new-dtags\/LDDISABLENEWDTAGS=-Wl,--no-as-needed,--disable-new-dtags\/' $ORACLE_HOME\/ord\/im\/lib\/env_ordim.mk\nsed -i 's\/LDDISABLENEWDTAGS=-Wl,--disable-new-dtags\/LDDISABLENEWDTAGS=-Wl,--no-as-needed,--disable-new-dtags\/' $ORACLE_HOME\/ctx\/lib\/env_ctx.mk\nsed -i 's\/LDDISABLENEWDTAGS=-Wl,--disable-new-dtags\/LDDISABLENEWDTAGS=-Wl,--no-as-needed,--disable-new-dtags\/' $ORACLE_HOME\/plsql\/lib\/env_plsql.mk\nsed -i 's\/LDDISABLENEWDTAGS=-Wl,--disable-new-dtags\/LDDISABLENEWDTAGS=-Wl,--no-as-needed,--disable-new-dtags\/' $ORACLE_HOME\/sqlplus\/lib\/env_sqlplus.mk\noracle@clemens-TravelMate:~\/scripts$ \noracle@clemens-TravelMate:~\/scripts$ chmod +x omkfix_XE.sh\noracle@clemens-TravelMate:~\/scripts$ . .\/omkfix_XE.sh\noracle@clemens-TravelMate:~\/scripts$ \n<\/code><\/pre>\n
9. Install an Oracle Enterprise Edition 18.4. in a separate ORACLE_HOME \/u01\/app\/oracle\/product\/18.0.0\/dbhome_1. You may follow the steps to install it here<\/a>. <\/p>\n
REMARK: At this step I also updated the \/etc\/sysctl.conf with the usual Oracle requirements and activated the parameters with sysctl -p.<\/p>\n
\nvm.swappiness=1\nfs.file-max = 6815744\nfs.aio-max-nr = 1048576\nfs.file-max = 6815744\nkernel.shmmni = 4096\nkernel.shmall = 2097152\nkernel.shmmax = 8589934592\nkernel.sem = 250 32000 100 128\nkernel.panic_on_oops = 1\nnet.core.rmem_default = 262144\nnet.core.rmem_max = 4194304\nnet.core.wmem_default = 262144\nnet.core.wmem_max = 1048576\nnet.ipv4.ip_local_port_range = 9000 65500\nnet.ipv4.conf.all.rp_filter = 1\nnet.ipv4.conf.default.rp_filter = 1\nvm.nr_hugepages = 600\n<\/code><\/pre>\n
10. Copy Object- and archive-files from the Enterprise Edition Oracle-Home to the XE Oracle-Home:<\/p>\n
\noracle@clemens-TravelMate:~\/scripts$ cat cpXE.bash \nOH1=\/u01\/app\/oracle\/product\/18.0.0\/dbhome_1\nOH=\/opt\/oracle\/product\/18c\/dbhomeXE\ncp -p $OH1\/rdbms\/lib\/libknlopt.a $OH\/rdbms\/lib\ncp -p $OH1\/rdbms\/lib\/opimai.o $OH\/rdbms\/lib\ncp -p $OH1\/rdbms\/lib\/ssoraed.o $OH\/rdbms\/lib\ncp -p $OH1\/rdbms\/lib\/ttcsoi.o $OH\/rdbms\/lib\ncp -p $OH1\/lib\/nautab.o $OH\/lib\ncp -p $OH1\/lib\/naeet.o $OH\/lib\ncp -p $OH1\/lib\/naect.o $OH\/lib\ncp -p $OH1\/lib\/naedhs.o $OH\/lib\n \ncp -p $OH1\/lib\/*.a $OH\/lib\ncp -p $OH1\/rdbms\/lib\/*.a $OH\/rdbms\/lib\noracle@clemens-TravelMate:~\/scripts$ bash .\/cpXE.bash\n<\/code><\/pre>\n
11. relink oracle<\/p>\n
\ncd $ORACLE_HOME\/rdbms\/lib\nmake -f ins_rdbms.mk config.o ioracle\n<\/code><\/pre>\n
REMARK: This is of course not supported and you’ve effectively changed your Oracle XE to an Enterprise Edition version now!!!<\/p>\n
12. Configure XE as root
\nREMARK: Without the relink above the script below would hang at the output “Copying database files”. Actually it would hang during the “startup nomount” of the DB.<\/p>\n
\nroot@clemens-TravelMate:\/etc\/init.d# .\/oracle-xe-18c-cfg configure\n\/bin\/df: unrecognized option '--direct'\nTry '\/bin\/df --help' for more information.\nSpecify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:\nConfirm the password:\nConfiguring Oracle Listener.\nListener configuration succeeded.\nConfiguring Oracle Database XE.\nEnter SYS user password: \n************\nEnter SYSTEM user password: \n**********\nEnter PDBADMIN User Password: \n***********\nPrepare for db operation\n7% complete\nCopying database files\n29% complete\nCreating and starting Oracle instance\n30% complete\n31% complete\n34% complete\n38% complete\n41% complete\n43% complete\nCompleting Database Creation\n47% complete\n50% complete\nCreating Pluggable Databases\n54% complete\n71% complete\nExecuting Post Configuration Actions\n93% complete\nRunning Custom Scripts\n100% complete\nDatabase creation complete. For details check the logfiles at:\n \/opt\/oracle\/cfgtoollogs\/dbca\/XE.\nDatabase Information:\nGlobal Database Name:XE\nSystem Identifier(SID):XE\nLook at the log file \"\/opt\/oracle\/cfgtoollogs\/dbca\/XE\/XE.log\" for further details.\n \nConnect to Oracle Database using one of the connect strings:\n     Pluggable database: clemens-TravelMate.fritz.box\/XEPDB1\n     Multitenant container database: clemens-TravelMate.fritz.box\nUse https:\/\/localhost:5500\/em to access Oracle Enterprise Manager for Oracle Database XE\nroot@clemens-TravelMate:\/etc\/init.d# \n<\/code><\/pre>\n
Done. Now you can use your XE-DB:<\/p>\n
\noracle@clemens-TravelMate:~$ . oraenv\nORACLE_SID = [oracle] ? XE\nThe Oracle base has been set to \/opt\/oracle\noracle@clemens-TravelMate:~$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Mon Apr 6 21:22:46 2020\nVersion 18.4.0.0.0\n \nCopyright (c) 1982, 2018, Oracle.  All rights reserved.\n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.4.0.0.0\n \nSQL> show pdbs\n \n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 XEPDB1                         READ WRITE NO\nSQL> \n<\/code><\/pre>\n
REMARK: As you can see, the logon-Banner shows “Enterprise Edition”. I.e. the software installed is no longer Oracle XE and absolutely not supported and not licensable under XE. The installation may just serve as a simple test and fun exercise to get Oracle working on Linux Mint.<\/p>\n
Finally I installed the Swingbench Simple Order Entry schema and ran a test with 100 concurrent OLTP-Users. It worked without issues.<\/p>\n","protected":false},"excerpt":{"rendered":"
On my old Laptop (Acer Travelmate with an Intel Celeron N3160 CPU) I wanted to install Oracle XE. Currently the available XE version is 18.4. My Laptop runs on Linux Mint 19.3 (Tricia). The Blog will describe the steps I had to follow (steps for Ubuntu would be similar). REMARK: The following steps were done […]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[1893,96,1302],"type_dbi":[],"class_list":["post-13917","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-linux-mint","tag-oracle","tag-xe"],"acf":[],"yoast_head":"\nSetup Oracle XE on Linux Mint - a funny exercise - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/setup-oracle-xe-on-linux-mint-a-funny-exercise\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Setup Oracle XE on Linux Mint - a funny exercise\" \/>\n<meta property=\"og:description\" content=\"On my old Laptop (Acer Travelmate with an Intel Celeron N3160 CPU) I wanted to install Oracle XE. Currently the available XE version is 18.4. My Laptop runs on Linux Mint 19.3 (Tricia). The Blog will describe the steps I had to follow (steps for Ubuntu would be similar). REMARK: The following steps were done […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/setup-oracle-xe-on-linux-mint-a-funny-exercise\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-07T20:53:01+00:00\" \/>\n<meta name=\"author\" content=\"Clemens Bleile\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ifgtxD2SrQ8r!YuXj\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Clemens Bleile\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setup-oracle-xe-on-linux-mint-a-funny-exercise\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setup-oracle-xe-on-linux-mint-a-funny-exercise\\\/\"},\"author\":{\"name\":\"Clemens Bleile\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ac04011f60f2e93c115358d0789c2da\"},\"headline\":\"Setup Oracle XE on Linux Mint – a funny exercise\",\"datePublished\":\"2020-04-07T20:53:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setup-oracle-xe-on-linux-mint-a-funny-exercise\\\/\"},\"wordCount\":600,\"commentCount\":0,\"keywords\":[\"linux mint\",\"Oracle\",\"XE\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setup-oracle-xe-on-linux-mint-a-funny-exercise\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setup-oracle-xe-on-linux-mint-a-funny-exercise\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setup-oracle-xe-on-linux-mint-a-funny-exercise\\\/\",\"name\":\"Setup Oracle XE on Linux Mint - a funny exercise - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2020-04-07T20:53:01+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ac04011f60f2e93c115358d0789c2da\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setup-oracle-xe-on-linux-mint-a-funny-exercise\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setup-oracle-xe-on-linux-mint-a-funny-exercise\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/setup-oracle-xe-on-linux-mint-a-funny-exercise\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Setup Oracle XE on Linux Mint – a funny exercise\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ac04011f60f2e93c115358d0789c2da\",\"name\":\"Clemens Bleile\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"caption\":\"Clemens Bleile\"},\"description\":\"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.\",\"sameAs\":[\"https:\\\/\\\/www.dbi-services.com\",\"https:\\\/\\\/x.com\\\/ifgtxD2SrQ8r!YuXj\"],\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/clemens-bleile\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Setup Oracle XE on Linux Mint - a funny exercise - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/setup-oracle-xe-on-linux-mint-a-funny-exercise\/","og_locale":"en_US","og_type":"article","og_title":"Setup Oracle XE on Linux Mint - a funny exercise","og_description":"On my old Laptop (Acer Travelmate with an Intel Celeron N3160 CPU) I wanted to install Oracle XE. Currently the available XE version is 18.4. My Laptop runs on Linux Mint 19.3 (Tricia). The Blog will describe the steps I had to follow (steps for Ubuntu would be similar). REMARK: The following steps were done […]","og_url":"https:\/\/www.dbi-services.com\/blog\/setup-oracle-xe-on-linux-mint-a-funny-exercise\/","og_site_name":"dbi Blog","article_published_time":"2020-04-07T20:53:01+00:00","author":"Clemens Bleile","twitter_card":"summary_large_image","twitter_creator":"@ifgtxD2SrQ8r!YuXj","twitter_misc":{"Written by":"Clemens Bleile","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/setup-oracle-xe-on-linux-mint-a-funny-exercise\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/setup-oracle-xe-on-linux-mint-a-funny-exercise\/"},"author":{"name":"Clemens Bleile","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"headline":"Setup Oracle XE on Linux Mint – a funny exercise","datePublished":"2020-04-07T20:53:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/setup-oracle-xe-on-linux-mint-a-funny-exercise\/"},"wordCount":600,"commentCount":0,"keywords":["linux mint","Oracle","XE"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/setup-oracle-xe-on-linux-mint-a-funny-exercise\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/setup-oracle-xe-on-linux-mint-a-funny-exercise\/","url":"https:\/\/www.dbi-services.com\/blog\/setup-oracle-xe-on-linux-mint-a-funny-exercise\/","name":"Setup Oracle XE on Linux Mint - a funny exercise - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2020-04-07T20:53:01+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/setup-oracle-xe-on-linux-mint-a-funny-exercise\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/setup-oracle-xe-on-linux-mint-a-funny-exercise\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/setup-oracle-xe-on-linux-mint-a-funny-exercise\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Setup Oracle XE on Linux Mint – a funny exercise"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da","name":"Clemens Bleile","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","caption":"Clemens Bleile"},"description":"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.","sameAs":["https:\/\/www.dbi-services.com","https:\/\/x.com\/ifgtxD2SrQ8r!YuXj"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13917","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=13917"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13917\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=13917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=13917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=13917"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=13917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}