Unable to add numbers at the beggining of my TNS entry in the TNSNames Editor
EXAMPLE:
Add the number 0 in front of the TNS entry:
0MYINSTANCE =
(DESCRIPTION=
(ADDRESS=
(COMMUNITY=######)
(PROTOCOL=TCP)
(HOST=####)
(PORT=####)
)
(CONNECT_DATA=
(GLOBAL_NAME=####)
(SID=####)
)
)
When pressing Validate or Save, the zero is removed.
Result:
MYINSTANCE =
(DESCRIPTION=
(ADDRESS=
(COMMUNITY=#####)
(PROTOCOL=TCP)
(HOST=####)
(PORT=####)
)
(CONNECT_DATA=
(GLOBAL_NAME=####)
(SID=####)
)
)
When typing in the value to the ADD Service window, the TNSNAMES Editor performs checks after the user clicks 'OK'. TNS_ NAMES entries cannot begin with a number so it removes this.
WORKAROUND:
Manually edit the tnsnames.ora file via Notepad.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center