By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,701 Members | 1,966 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,701 IT Pros & Developers. It's quick & easy.

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

P: 1
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!
Expand|Select|Wrap|Line Numbers
  1. #this code has implemented in the inittest123.ora (this is the copy of inithsodbc.ora) placed at "C:\OracleHomes\db10g\hs\admin" directory.
  2.  
  3. # This is a sample agent init file that contains the HS parameters that are
  4. # needed for an ODBC Agent. 
  5.  
  6. #
  7. # HS init parameters
  8. #
  9. HS_FDS_CONNECT_INFO = test0907==>this is the SYSTEMDSNname
  10. HS_FDS_TRACE_LEVEL = OFF
  11.  
  12. #
  13. # Environment variables required for the non-Oracle system
  14. #
  15. #set <envvar>=<value>
  16.  
Expand|Select|Wrap|Line Numbers
  1. # listener.ora Network Configuration File: C:\OracleHomes\db10g\network\admin\listener.ora
  2. # generated by Oracle configuration tools.  
  3. #it is placed at C:\OracleHomes\db10g\NETWORK\ADMIN
  4.  
  5. #TRACE_LEVEL_LISTENER = ADMIN
  6.  
  7. SID_LIST_LISTENERTEST0707 =
  8.   (SID_LIST =
  9.     (SID_DESC =
  10.       (SID_NAME = test0907)==>systemdsn name
  11.       (ORACLE_HOME = C:\)==>here my OracleHomes dir is there (C:\OracleHomes\db10g)
  12.  
  13.       (PROGRAM = test123)===>this is hs file
  14.     )
  15.   )
  16.  
  17. LISTENERTEST0707 =
  18.   (DESCRIPTION_LIST =
  19.     (DESCRIPTION =
  20.       (ADDRESS_LIST =
  21.         (ADDRESS = (PROTOCOL = TCP)(HOST = "here i have placed my server ip")(PORT = 1522))
  22.       )
  23.       (ADDRESS_LIST =
  24.         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
  25.       )
  26.     )
  27.   )
  28.  
  29.  

Expand|Select|Wrap|Line Numbers
  1.  
  2. # This is a tnsnames.ora that contains the NET8 parameters that are
  3. # needed to connect to an HS Agent
  4. #it is placed at C:\OracleHomes\db10g\NETWORK\ADMIN
  5.  
  6.  
  7. test0907 =
  8.   (DESCRIPTION=
  9.     (ADDRESS=(PROTOCOL=tcp)(HOST=gsmc-wipro.viking.net)(PORT=1522))
  10.     (CONNECT_DATA=(SERVER = DEDICATED)
  11.                   (SID=test0907))
  12.     (HS=ok)
  13.   ) 
  14.  
  15.  
  16.  

Expand|Select|Wrap|Line Numbers
  1. # sqlnet.ora Network Configuration File: C:\OracleHomes\db10g\network\admin\sqlnet.ora
  2. # generated by Oracle configuration tools.
  3.  
  4. SQLNET.AUTHENTICATION_SERVICES= (NTS)
  5.  
  6. NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
  7.  
After that I have configured the LISTENER (name is LISTENERtest0907) 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==>working fine.
I have created the dblink like that
create public database link sqldblink connect to "username" by "password" using test0907("dsnname")==>created 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.
Jul 10 '08 #1
Share this Question
Share on Google+
2 Replies


Nepomuk
Expert 2.5K+
P: 3,112
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
Jul 10 '08 #2

acoder
Expert Mod 15k+
P: 16,027
Moved to the Oracle forum.

Moderator.
Jul 10 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.