I got a error when i am establish the connection between oracle and sql server

[devas]

Hai,

Issue: I am using OEM 10g grid control. I want to establish the connection from oracle to sql server=>I can’t able to connect it. Please help me

I have created the system dsn below steps.
Step 1) Open the odbc data source administrator
Step 2) select the system dsn tab page. And gave the dsnname
Step 3) configure the server and tested the connection
Step 4) connection has COMPLETED SUCCESSFULLY!

#this code has implemented in the inittest123.ora (this is the copy of inithsodbc.ora) placed at "C:\OracleHomes\db10g\hs\admin" directory.
 
# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent. 
 
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = test0907==>this is the SYSTEMDSNname
HS_FDS_TRACE_LEVEL = OFF
 
#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>
 

# listener.ora Network Configuration File: C:\OracleHomes\db10g\network\admin\listener.ora
# generated by Oracle configuration tools.  
#it is placed at C:\OracleHomes\db10g\NETWORK\ADMIN
 
#TRACE_LEVEL_LISTENER = ADMIN
 
SID_LIST_LISTENERTEST0707 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = test0907)==>systemdsn name
      (ORACLE_HOME = C:\)==>here my OracleHomes dir is there (C:\OracleHomes\db10g)
 
      (PROGRAM = test123)===>this is hs file
    )
  )
 
LISTENERTEST0707 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = "here i have placed my server ip")(PORT = 1522))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )
 
 

 
# This is a tnsnames.ora that contains the NET8 parameters that are
# needed to connect to an HS Agent
#it is placed at C:\OracleHomes\db10g\NETWORK\ADMIN
 
 
test0907 =
  (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=gsmc-wipro.viking.net)(PORT=1522))
    (CONNECT_DATA=(SERVER = DEDICATED)
                  (SID=test0907))
    (HS=ok)
  ) 
 
 
 

# sqlnet.ora Network Configuration File: C:\OracleHomes\db10g\network\admin\sqlnet.ora
# generated by Oracle configuration tools.
 
SQLNET.AUTHENTICATION_SERVICES= (NTS)
 
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
 

After that I have configured the LISTENER (name is LISTENERtest090 7) through net configuation assistent.

Then

I have started the LISTENR through this exe(lsnrctl.exe )=started successfully.
I have tested the tns through the tnsping test0907==>work ing fine.
I have created the dblink like that
create public database link sqldblink connect to "username" by "password" using test0907("dsnna me")==>create d successfully.

after that when i am executing this script
("select * from EMP1@sqldblink" )
it shows the follwing error.

ERROR at line 1:
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 SQLDBLINK6.

Please help me, where I have made a mistake, I am a fresh for this oracle and oracle OEM 10G Grid control.

[Nepomuk]

Hi devas! Welcome to bytes.com!
This post either belongs in the Oracle Forum or the SQL Server Forum, but not in the Feedback, Suggestions, Bugs and Comments Section. Please post your questions in the correct sections.

Greetings,
Nepomuk

[acoder]

Moved to the Oracle forum.

Moderator.