I have a completely fresh OracleDB running in KVM but I cannot connect to DB.
For one, sqlplus is not installed, and trying to install downloaded instantclient-*rpm packages fails with various errors. I am told that the install process should have brought in sqlplus on its own to /home/oracle/bin but there's no such file.
Linux command line ps & ss show that the DB Engine is up and running, and listening on port 1521
When I try to connect using sqldeveloper or dbeaver I get an authentication error as user/password incorrect. I suppose this is normal since I'm unable to run the needed sqlplus command post-install. But confirms DB is up & running. In mysql (and variants) there's a safe-mode restart where no auth is required; I assume there's no such option with OracleDB
My Q: How do I get into the DataBase? I have no CLI, and have no user/pw at DB admin level.
Thanks & Regards.
Host: Debian 12 - Bookworm, Guest: Oracle Linux R8-U7-x86_64 in KVM qcow2
Oracle DB version: oracle-database-ee-19c-1.0-1.x86_64.rpm
I followed this guide to preinstall, then localinstall, then ran below script to finalize
/etc/init.d/oracledb_ORCLCDB-19c configure