'oracle apex not work the Error: The Network Adapter could not establish the connectio

[enter image description here I install orcle database and oracle apex locally but I am getting this error, when try to open the workspace

enter image description here

also the same schema when try to connect through the sql developer not connect and error show How can I fix that?

enter image description here



Solution 1:[1]

To connect to the database, you make a request to a "listener" which then hands off your connection to the database. The listener listens (hence the name) on a port. If your listener is not running, or you are sending your request on the wrong port, then you see errors like this, because we can't find the listener.

Try this on a command line:

lsnrctl status

If you get errors, then your listener probably is not running. Go into Services, and you look for OracleTNS.... and start that. If your output suggests the listener is up and running already, then look for the information about the port and IP address (or hostname) that it is listening on. You then use those for your connection details in SQLDev and ORDS and the like.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Connor McDonald