Error Message Error: SQL> select 'x' from dual@mssql; select 'x' from dual@mssql * ERROR at line 1: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA Defect Number Enhancement Number Cause Resolution Install 11g Gateway for ODBC into separate home directory than 10g...
Once the DEFAULT_SERVICE parameter is configured, reload the listener to bring this change into effect:- lsnrctl reload Sol 2. If using a service name, check that the connect descriptor corresponding to the service name in TNSNAMES.ORA of the client has a SERVICE_NAME...
Help Center Home Oracle.com Home Get started with Cloud Help Center Database Error Messages Oracle Account Manage your account and access personalized content.Sign up for an Oracle Account Sign in to my Account Sign in to Cloud Access your cloud dashboard, manage orders, and more.Free Cloud ...