Hi,
I had Oracle xe R11.2 installed on Windows 10 running on a VM. Everything was working fine and I had a schema created and in use.
I then changed the hostname and rebooted to find that I couldn't connect to the database instance using SQL Developer nor the following in a cmd window:
>sqlplus <user>/<pass>@<dbname>
I then realised that I probably needed to change tnsnames.ora and listener.ora which i did using the new hostname
Still no luck.
I then tried using "localhost" in the two files above.
Still no luck.
The error i'm currently getting is: ORA-12505 Listener does not know of SID given in connect descriptor.
I can connect successfully using:
>sqlplus / as sysdba
I've restarted the listener many times and i've restarted the VM many times.
What am I missing?
Many thanks,
Warren