0

I installed Oracle XE 18c on RHEL on my laptop, got it configured, created connections with two applications (DBeaver and DbVisualizer) as well as able to connect with sqlplus. It all worked "perfectly".

This morning, I had to "IT Crowd" reboot my laptop (turned it off and back on again), then started Oracle XE using sqlplus, accessed a table to confirm the engine actually came up although the appropriate startup messages were generated.

My problem is neither of the DB apps (above) can connect to the XE database again. I've checked the listener.ora file, it matches the connection configuration in both applications for the hostname and port number. The /etc/hosts file still contains the same configuration.

Note that the server is configured in listener.ora to listen on port 1539.

The message I get from both apps when I "ping the server" is effectively the same: "

Cannot connect to '<redacted>' on port 1539

along with the standard "please check and try again" advice. I can't find any log files with entries for today. It sounds trite, but none of the configuration files changed, the only difference I can see is having rebooted and possibly something did not "stick", perhaps a process did not get started.

Please accept my thanks in advance.

  • Is RHEL installed natively on your machine or in a VM? netstat -an | grep LISTEN | grep 1521 will tell you which interfaces the listener is up on – Philᵀᴹ May 13 at 19:01
  • @Phil - nothing is listening on 1521 NOR 1539, which is the configured port (listener.ora). So I'm a dope, I mean novice, with sqlplus - does it require the engine to access the database? – saquaro May 13 at 20:58
  • @Phil ... its a native install – saquaro May 13 at 21:05
  • Do lsnrctl start to start the listener – Philᵀᴹ May 13 at 21:07
  • @Phil - Thanks! I'm still puzzled as to why this command was omitted from the Oracle resources I was able to find. I don't see how to up-vote or I would. – saquaro May 14 at 11:26
0

The listener is not running.

As the Oracle user (which may be called oracle or oraclexe) run:

lsnrctl start

... to start the Oracle listener.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.