Most of the reasons for the lack of access are due to changes in the configuration of TNS in Oracle.
The cause of TNS configuration problems may be: 1. Computer Name 2 was modified. Modified the IP
The default Oraclexe launches Oraclexetnslistener and oracleservicexe two services.
Oraclexetnslistener is Oracle's listening service, without which it will not be able to access the database, can not access the Http://127.0.0.1:8080/apex
Once the administrator modifies my domain name and computer names. The result is that Oraclexetnslistener cannot start.
The best way to solve this problem:
Modify:
%oracle_home%/app/oracle/product/10.2.0/server/network/admin under
Listener.ora
Tnsnames.ora
Modify the specified computer name section in these two files.
After modification, restart service. OK:)
Similarly, the following command can assist in finding errors:
C:\oraclexe\app\oracle\product\10.2.0\server\bin>lsnrctl start