Hello all,
Need to establish connection in Oracle 10.2.0.5 / Windows Server 2008 R2 64bit to download some data from HP3000 MPE/IX before old system is shut down for good. Server Admin claimed he has installed MINISOFT 32 bit drivers and have created System DSN.
Anyone familiar with the how-tos for these connections? I tried to follow http://www.easysoft.com/applications/oracle/hsodbc.html but stumble into connections issues.
1) I believe I got the TNSNAMES and listners correct. TNSPING returns
C:\Windows\system32>tnsping mnop
TNS Ping Utility for 64-bit Windows: Version 10.2.0.5.0 - Production on 28-OCT-2
011 10:00:11
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = XXXX.abcd.com)(PORT = 1521)) (CONNECT_DATA = (SID = MNOP)) (HS=OK))
OK (10 msec)
2) But, I don't understand how it relates to MINISOFT - there's a whole folder of connections and schema files, specifying table structures in XML file extensions. I can't find anything at www.minisoft.com
3) I am getting errors
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 on the Database Link test in EM.
4) I am getting errors trying to query data from the MNOP.
ORA-02019: connection description for remote database not found