Hi All,
Oracle database version : 12.2.0.1.0
I was connecting the Oracle database to SQL Server using ODBC Connective and HS services and created the datalink also.
I did with the configuration but I am facing one issue.
SQLNET.AUTHENTICATION_SERVICES = (NTS) or SQLNET.AUTHENTICATION_SERVICES = (NONE)
if I configurated NTS and restarted the database it's working fine there is no issue but I can't able connect to the SQL server.
ORA - 28454:error diagnosed by Net8 when connecting to an agent unable to retrieve the text of Network/NCR message 65535
ORA - 02063:Preceding 2 Lines from DBLINKNAME
if I configurated NONE and restarted the database but the error occurred database did not start
How it's working now :(Work Around)
First I configured NTS IN SQLNET file and then restarted the oracle database, Oracle DB connected successfully but I changed the SQLNET file NTS TO NONE then without restarting the DB services try to access the oracle database and SQL server both working fine.
After some time I restarted the oracle database services and the listener not working.