473,225 Members | 1,330 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,225 software developers and data experts.

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

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
2 5516
Nepomuk
3,112 Expert 2GB
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
16,027 Expert Mod 8TB
Moved to the Oracle forum.

Moderator.
Jul 10 '08 #3

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

Similar topics

3
by: Darren | last post by:
Hi Oracle experts, We are getting this error on our Oracle system. I've searched Google, MSDN, Oracle tech support and newsgroups to death, but our DBAs seem to have already applied all the...
0
by: Miran Kopmajer | last post by:
I have Oracle JDeveloper10g installed on my computer and connection to Oracle AS works fine but connection to database returns Io exception: The Network Adapter could not establish the connection...
1
by: Semaj | last post by:
Environment: DB2 8.1.4; Windows 2000 We are evaluating the feasibility of upgrading our production DB from 7.2 to 8.1. During this process we've encountered an error when starting our...
10
by: Brian Conway | last post by:
I have no idea what is going on. I have a Login screen where someone types in their login information and this populates a datagrid based off of the login. Works great in debug and test through...
5
by: petro | last post by:
Hello all, My asp.net web application works on my machine but I get the following error on our test web server, There is only one oracle home on the test server. Does anyone know how to resolve...
1
by: Mark Richards | last post by:
Hi, I am interfacing with another company using web services (they are a java shop). We've been doing this for over 2 years, but a couple months age we started getting this error randomly. It...
0
by: xdduk012x | last post by:
I'm new to Oracle and having a problem connecting to Oracle SQL Developer (version 1.1.0.23). The error message when I ran a test was as follows: Failure -lo exception: The Network Adaptor could...
3
by: Ted | last post by:
In WSAT, I get the following error when trying to set up my provider: Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site...
0
by: mbenedict | last post by:
I am rather new at this code and am attempting to modify existing code to use clob datatypes, which I have never used before. The database tables have been set up for clob data. When trying to use...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.