Geeks With Blogs
Blue Probe It’s the parting gift when you host an alien abduction

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.

Posted on Tuesday, December 27, 2016 8:56 AM | Back to top


Comments on this post: Can’t connect to Oracle XE after migrating to Windows 10

# re: Can’t connect to Oracle XE after migrating to Windows 10
Requesting Gravatar...
I believe this is a simple issue which may have occurred due to the incompatibility of the drivers. This issue has been raised here on this forum several times by the users before. I am sure that you can rectify this issue if you download the latest version.
originalorkopina.com
Left by Shawn on Feb 14, 2018 10:29 PM

Your comment:
 (will show your gravatar)


Copyright © Ken Hortsch | Powered by: GeeksWithBlogs.net