Double space in front of equal symbol in tnsnames entry causes an ORA-12541 error when executing (4282650)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Double space in front of equal symbol in tnsnames entry causes an ORA-12541 error when executing
Description

Error received when a double sapce exists in front of the equal '=' symbol in tnsnames.ora file and Toad locks the file and doesn't allow other users to access the database:

"ORA-12541: TNS:no listener"
Cause

Double space in the tnsnames.ora file.
Resolution

WORKAROUND:

Avoid double space in the TNSNAMES entry.

STATUS:

Waiting for fix in a future release of Toad for Oracle.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title