When trying to connect to my databases it will not allow me to connect with my short database name and require that I use the long name. I use to be able to connect with either. SQL Navigator picks up the name correctly as it is in the tnsnames.ora file, but I still cannot connect. Why has this change? Is there a setting I need to adjust?
Example:
Tnsnames.ora uses short name
ORA10GR2=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ABC123456)(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORA10GR2)
)
)
But to log in through SQL Navigator, I need to use the long name ORA10GR2.PROD.COMPANY.CORP
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center