Little Notes
- When you want to test your Oracle DB is running on your machine, open command line and enter:
connect sys/password as sysdba
If you get message like this:
connected to an idle instance
This means your Oracle DB is not running. From Starts/Administrative Tools/Services/ find OracleDB in your services list. With right click restart it again. - When you can connect your OracleXE Database home page from the link:
http://127.0.0.1:8080/apex
but can’t connect from:
http://yourpcipaddress:8080/apex
Connect your sysdba account from command line and execute the code below:
exec dbms_xdb.setListenerLocalAccess(l_access=>FALSE);
