Call: +44 (0)1904 557620 Call
Blog

Pete Finnigan's Oracle Security Weblog

This is the weblog for Pete Finnigan. Pete works in the area of Oracle security and he specialises in auditing Oracle databases for security issues. This weblog is aimed squarely at those interested in the security of their Oracle databases.

[Previous entry: "Oracle Security Training Manuals for Sale"] [Next entry: "PL/SQL That is not DEFINER or INVOKER rights - BUG?"]

Installing Oracle 19c on Linux



I needed to create a new 19c install yesterday for a test of some customer software and whilst I love Oracle products I have to say that installing the software and database has never been issue free and simple over many many years. I can remember installing Oracle 7.0 and all versions since. Those earlier versions are simple compared to 19c with multitenant architecture but the troubles still occur.

I first downloaded the V???.zip image for 19c from Oracles edelivery site and trying to unzip it I got invalid zip file format errors. So, unperturbed I downloaded it again and same error. Hmm, so I looked at the downloads available from OTN and took the rpm image and thought I would catch up some time and instead do an rpm install of the software and then build a database with the scripts provided.

yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm

So, downloaded the rpm and installed this pretty quickly but the database build with the provided script:

/etc/init.d/oracledb_ORCLCDB-19c configure

Failed with a message that the LISTENER process was already in use - which it wasn't an netstat -aun check proved this. There was no obvious explanations on line so decided to now download the third version of 19c, the LINUX file system zip that allows all files to be unzipped into the pre-prepared ORACLE_HOME:

unzip -oq /path/to/software/LINUX.X64_193000_db_home.zip

Yes, you guessed it; this unzip also failed. I downloaded it a second time and tried again. Nope, it really failed with a CRC checksum failure for the file dcore.bsq; hmmm, so zip failed and dcore.bsq is empty when inspected. What to do?

I decided to revert the vm back to the base Linux and reinstall the rpm version software again as that part worked; save the dcore.bsq file and then revert the VM again and unzip the LINUX install and replace the dcore.bsq file and then continue and install 19c.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

SQL>
SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

SQL>

I installed 19c some time ago and didn't have issues so not sure why this install was troublesome?