Can’t connect to Oracle XE after migrating to Windows 10

Comments (1) | Share

1) After migrating from Win7 to Win10 I couldn’t connect to XE on localhost (127.0.0.1)

2) I did add XE to listeners.ora

3) LSTNRCTL status does not show service XEXDB in ready status.

Solution:

sqlplus / as sysdba

SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))' scope=both;

System altered.

SQL> alter system register;

System altered.

SQL> exit

http://stackoverflow.com/a/37129023/39542 – This post solved the question of changing an IP, which was the ticket.