Complete error: Status: Failure: Failed to test: Litener refused the connection with the following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor
the port in the web interface is " 1158 ", I change it to where it says " 1521 " and it does not connect either.
What do I move to the SID following the instruction?
Surely it connects by SID and not by service ??
First verify that the listenner is not with the status of Sleeep.
If the command is executed successfully, it is not a problem to listenner.
If the execution runs with error (Windows error 61), the problem is in the Listenner.
Solution:
With that the listenner starts. Try again the connection.
If done the above procedure, still not connected, verify that the ORA file is correct: listener.ora
../ u01 / app / oracle / product / 11.2.0 / dbhome_1 / network / admin / listener.ora
Open, ORA.file and validate that the SID, Host and Port are correct.
Basically your error is because the connection data or the not started listenner is not correct. It also tests the connection type to "Advanced" and there locates the complete connection string and hits Test.
Edit:
If it shows you an error: No more data to read from the socket
I solved the error in this way:
Windows + R you type services.msc and look for the OracleServiceXE service, secondary mouse button and start.
Greetings !!