Hi all!
I really hate to make another topic about a problem that many people have posted about already, but now matter how hard I try, I can't resolve the following error:
ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from DBLSS.WORLD
I've followed this tutorial with the exception of step 7, where I substituted hsodbc for dg4odbc: Database link from Oracle to SQL Server
Also, the database link worked before the databasename of the SQL Server had to change, so I know the right programs/drivers are installed.
MSSQL Server: MS10, database: SXSS
Oracle Server: OR39, database: SXSO
3. Test the ODBC drivers to ensure that connectivity is made to the SQL Server database.
On the oracle database server OR39:
Start -> Data Sources (ODBC) -> System DSN -> Name=SXSS, Server = MS10, change default database=SXSS
Test Data source results:
Microsoft SQL Server ODBC Driver Version 06.01.7601
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
4. Ensure that your global_names parameter is set to False.
SQL> select name from v$database;
NAME
---------
SXSO
SQL> show parameter global_names
------------------------------------ ----------- ------
| global_names | boolean | FALSE |
5. Configure the Oracle Heterogeneous services by creating an initodbc.ora file within the Oracle database.
In %Oracle_Home%/hs/admin I have the file initSXSS.ora:
HS_FDS_CONNECT_INFO=SXSS
HS_FDS_TRACE_LEVEL=OFF
also initdg4odbc.ora which I didn't modify, and an extproc.ora which only says
SET EXTPROC_DLLS=
7. Modify the Listener.ora file.
this is part of my listener
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = OR39)(PORT = 1521))
)
)
| SID_LIST_LISTENER = (SID_LIST = |
| (SID_DESC = |
| | (SID_NAME = SXSS) |
| | (ORACLE_HOME = F:\oracle\ora112) |
| | (PROGRAM = dg4odbc) |
| ) ) |
8. Modify the Tnsnames.ora file.
(ADDRESS= (PROTOCOL=TCP) (HOST = OR39 )(PORT=1521))
(CONNECT_DATA= (SID = SXSS))(HS=OK))
c:> tnsping SXSS
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION=[..])
OK (30 msec)
9. Reload the listener on local Oracle database
Done
10. Create a database link on the local Oracle installation that accesses the heterogeneous connection, which, in turn, connect to SQL Server.
CREATE PUBLIC DATABASE LINK "MICRO.WORLD" CONNECT TO "ORUSER" IDENTIFIED by "******" USING 'SXSS'
Then I go to management studio, to my SXSO database, to Database Links, click on MICRO.WORLD, click on test and then I get the ORA-28545.
It had worked before following the same manual, but now it doesn't seem to work anymore. Am I doing anything wrong? Or am I missing a step?