Home » RDBMS Server » Networking and Gateways » Generic Connectivity Not Working (Oracle -Ms Access) (Oracle 10.2.0.4.0 on Linux)
Generic Connectivity Not Working (Oracle -Ms Access) [message #411899] Tue, 07 July 2009 04:56 Go to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi,

I am trying to establish connection from Oracle to Ms Access (before I can start with SQL server etc).
However it is not working.
I am getting "ORA-28545: error diagnosed by Net8 when connecting to an agent" error
along with
"Unable to establish RPC connection to HS Agent"

I am unable to understand which step I am missing.

Please help

Thanks and Regards,
OraKaran

Following are the configuration setps I carried out

Oracle 10g installed on Linux server Sever1
MS Access is installed on my windows XP machine

On My Windows machine -Client1
1)
Opened MS Access
Created Table named Table1
Saved the file as db1

2)
Data Source(ODBC)->System DSN->Add->Microsoft Access Driver (*.mdb)->Data Source Name->Entered "TEST" ->(Database) Select ->select "db1" ->OK

On Server1
1)
cd $ORACLE_HOME/hs/admin
cp inithsodbc.ora inittest.ora

2)
edit inittest.ora
HS_FDS_CONNECT_INFO = mdb
HS_FDS_TRACE_LEVEL = off
HS_FDS_SHAREABLE_NAME = /usr/lib/libodbc.so
set ODBCINI = /usr/lib/libodbc.so

On Server1
3)
add entry in Listener.ora

    (SID_DESC =
      (SID_NAME = TEST)
      (ORACLE_HOME = /data/oracle/product/10.2.0/db)
      (PROGRAM = hsodbc)
    )

On Server1
4)
add entry in Tnsnames.ora

TEST = 
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST=server1.domain)
        (PORT=1521)
      )
    )
    (CONNECT_DATA=(SID=TEST))
    (HS=OK)
  )

On Server1 
5)
lsnrctl stop
lsnrctl start

tnsping TEST
Used TNSNAMES adapter to resolve the alias
Attempting to contact  (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP) (HOST=Server1.domain) (PORT=1521))) (CONNECT_DATA=(SID=TEST)) (HS=OK))
OK (10 msec)

6)
create database link test using '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Server1)(PORT=1521))(CONNECT_DATA=(SID=TEST))(HS=OK))';

{tried Server.doamin also as
create database link test using '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Server1.domain)(PORT=1521))(CONNECT_DATA=(SID=TEST))(HS=OK))';}

Server1
7)
select * from table1@test

select * from table1@test
                     *
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 TEST


Alert.log
HS:  Unable to establish RPC connection to HS Agent...
HS:  ... Agent SID = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(Server1)(PORT=1521))(CONNECT_DATA=(SID=TEST))), NCR error = 65535 Unable to retrieve text of NETWORK/NCR message 65535



Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #411905 is a reply to message #411899] Tue, 07 July 2009 05:09 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

ORA-28545: error diagnosed by Net8 when connecting to an agent 
Cause: An attempt to call an external procedure or to issue SQL to a non-Oracle system on a Heterogeneous Services database link failed at connection initialization. The error diagnosed by Net8 NCR software is reported separately.
 
Action: Refer to the Net8 NCRO error message. If this isn't clear, check connection administrative setup in tnsnames.ora and listener.ora for the service associated with the Heterogeneous Services database link being used, or with 'extproc_connection_data' for an external procedure call. 


Babu
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #411916 is a reply to message #411905] Tue, 07 July 2009 05:21 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi gentlebabu,

Many Thanks for the quick reply

As you can see there is hardly any configuration related to Listener.ora and Tnsnames.ora. In fact I have copy/paste it from my files.

Also checked with TNSPING.

Could you please advice me if the steps I have followed are correct?

I am not confident as the Metalink Note 109730.1 says
"Install the third party ODBC driver from Microsoft"
which is confusing me.

Thanks and Regards,
OraKaran
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #411924 is a reply to message #411916] Tue, 07 July 2009 05:31 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>I am not confident as the Metalink Note 109730.1 says

Oh god.

1/ You have created DSN name like 'TEST' but HS_FDS_CONNECT_INFO given wrong name

Refer : http://download.oracle.com/docs/cd/B10501_01/server.920/a96544/gencon.htm

Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #411930 is a reply to message #411899] Tue, 07 July 2009 05:40 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi gentlebabu,

My apologies

The DSN is mdb only..it's my TYPO

Do I need to install any drivers on Oracle Server?

Regards,
OraKaran
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #411949 is a reply to message #411930] Tue, 07 July 2009 06:00 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


We don't have permission to post metalink details. As per your document id; DId you notice step II

Can you try that.

Thanks
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #411963 is a reply to message #411899] Tue, 07 July 2009 06:16 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi gentlebabu,

I executed the query mentioned in Step 2 and it returns following result

SQL> col FDS_CLASS_COMMENTS format a30
SQL> select * from SYS.HS_FDS_CLASS;
FDS_CLASS_NAME                 FDS_CLASS_COMMENTS             FDS_CLASS_ID
------------------------------ ------------------------------ ------------
BITE                           Built-In Test Environment                 1



even I tried configuring another Listener with another port but nothing works

1)Listener.ora

LISTENER1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Server1.domain)(PORT = 1523))
  )

SID_LIST_LISTENER1 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = TEST)
      (ORACLE_HOME = /data/oracle/product/10.2.0/db)
      (PROGRAM = hsodbc)
    )
  )

2) Tnsnames.ora

TEST =
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST=Server1.domain)
        (PORT=1523)
      )
    )
    (CONNECT_DATA=(SID=TEST))
    (HS=OK)
  )

3)lsnrctl start LISTENER1

tnsping test

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 07-JUL-2009 16:31:40

Copyright (c) 1997,  2007, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP) (HOST=Server1.domain) (PORT=1523))) (CONNECT_DATA=(SID=TEST)) (HS=OK))
OK (0 msec)

4)
SQL> create database link test using '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Server1.domain)(PORT=1523))(CONNECT_DATA=(SID=TEST))(HS=OK))';



Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #411965 is a reply to message #411963] Tue, 07 July 2009 06:19 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

>>even I tried configuring another Listener with another port but nothing works

Why your trying another port ?? is there any other listener service running?

Babu
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #411967 is a reply to message #411899] Tue, 07 July 2009 06:24 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi gentlebabu,

We have few database instances listening on ports 1521 and 1522 with listener name as LISTENER and LISTENER10G

I just thought may be it is causing obstruction. But no ..it did not work on any of the ports.

Regards,
OraKaran


Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #411971 is a reply to message #411967] Tue, 07 July 2009 06:27 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Use 1521 & Try to execue below SQL

select * from table1@test
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #411976 is a reply to message #411899] Tue, 07 July 2009 06:32 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi gentlebabu,

I tried using 1521 at very first but it did not worked for both of the following queries

select * from Table1@test;

select * from "Table1"@test;

Regards,
OraKaran
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #412135 is a reply to message #411976] Tue, 07 July 2009 23:22 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
>>I am not confident as the Metalink Note 109730.1 says


I hope now you have confident with metalink Smile

Quote:
System DSN Name: msdb


BEFORE LISTENER.ORA

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = f:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
          (SID_NAME = msdb)
          (ORACLE_HOME = f:\oracle\product\10.2.0\db_1)
          (PROGRAM = hsodbc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = babu)(PORT = 1521))
    )
  )


BEFORE TNSNAMES.ORA

msaccess  =
  (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
    (CONNECT_DATA=(SID=hsodbc))
    (HS=OK)
  ) 



SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> select name from v$database;

NAME
---------
KNBDB

SQL> select * from SYS.HS_FDS_CLASS;

FDS_CLASS_NAME                 FDS_CLASS_COMMENTS
                                                                                               FDS_CLASS_ID
------------------------------ ------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------- ------------
BITE                           Built-In Test Environment
                                                                                                      1

SQL> host tnsping msaccess

TNS Ping Utility for 32-bit Windows: Version 10.2.0.4.0 - Production on 08-JUL-2009 09:42:01

Copyright (c) 1997,  2007, Oracle.  All rights reserved.

Used parameter files:
f:\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=localhost)(PORT=1521)) (CONNECT_DATA=(SID=hsodbc)) (HS=OK))
OK (50 msec)

SQL>
SQL> create database link msaccess using '(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)) (CONNECT_DATA=(SID=hsodbc)) (HS=OK))';

Database link created.

SQL> select * from ms_emp@msaccess;
select * from ms_emp@msaccess
                     *
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 MSACCESS


After fixing listener.ora & tnsnames.ora problem

LISTENER.ORA

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = f:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
          (SID_NAME = hsodbc)
          (ORACLE_HOME = f:\oracle\product\10.2.0\db_1)
          (PROGRAM = hsodbc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = babu)(PORT = 1521))
    )
  )



BEFORE TNSNAMES.ORA
msaccess  =
  (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
    (CONNECT_DATA=(SID=hsodbc))
    (HS=OK)
  ) 

SQL> select * from ms_emp@msaccess;
select * from ms_emp@msaccess
*
ERROR at line 1:
ORA-02085: database link MSACCESS connects to HO.WORLD


SQL> show parameter global_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
global_names                         boolean     TRUE
SQL>
SQL> alter system set global_names=false ;

System altered.

SQL> select * from ms_emp@msaccess;

       eno name
---------- --------------------------------------------------
        10 babu
        20 taj

also 

SQL> host type F:\oracle\product\10.2.0\db_1\hs\admin\inithsodbc.ora
# 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 = msdb
HS_FDS_TRACE_LEVEL = off


#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>


Thanks

[Updated on: Tue, 07 July 2009 23:28]

Report message to a moderator

Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #412141 is a reply to message #412135] Tue, 07 July 2009 23:46 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Just verification purpose.

SQL> l
  1* select * from SYS.HS_FDS_CLASS
SQL> /

FDS_CLASS_NAME                 FDS_CLASS_COMMENTS             FDS_CLASS_ID
------------------------------ ------------------------------ ------------
BITE                           Built-In Test Environment                 1
ODBC10.2.0.4.0_300             self-registered FDS class                21
ODBC                           self-registered FDS class                22
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #412142 is a reply to message #411899] Tue, 07 July 2009 23:54 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
hi gentlebabu,

Thanks for patience

As I can see in your last reply the following error was replicated when SID was different in tnsnames.ora and listener.ora
in my case in my case it is the same ->'TEST'

Please suggest, I am really worried now

Thanks and Regards,
OraKaran

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 MSACCESS


My tnsnames.ora and listener.ora are as follows

TEST =
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST=Server1.domain)
        (PORT=1523)
      )
    )
    (CONNECT_DATA=(SID=TEST))
    (HS=OK)
  )
------------------------------
LISTENER1G =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Server1.domain)(PORT = 1523))
  )

SID_LIST_LISTENER1G =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = TEST)
      (ORACLE_HOME = /data2/oraclestd/product/10.2.0/db)
      (PROGRAM = hsodbc)
    )
  )

Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #412144 is a reply to message #412142] Tue, 07 July 2009 23:59 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


1/ What's your System DSN name?

2/ Please post your complete listener.ora & tnsnames.ora

Babu
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #412146 is a reply to message #411899] Wed, 08 July 2009 00:12 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi gentlebabu,

Please find listener.ora and tnsnames.ora attached herewith

Also my System DSN name is "mdb"

Thanks and Regards,
OraKaran
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #412148 is a reply to message #412146] Wed, 08 July 2009 00:28 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Listener.ORA
# listener.ora Network Configuration File: /data/oracle/product/10.2.0/db/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER10G =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Server1.domain)(PORT = 1522))
  )

SID_LIST_LISTENER10G =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /data/oracle/product/10.2.0/db)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = DEV)
      (ORACLE_HOME = /data/oracle/product/10.2.0/db)
      (SID_NAME = DEV)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = PROD)
      (ORACLE_HOME = /data/oracle/product/10.2.0/db)
      (SID_NAME = PROD)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = SIT)
      (ORACLE_HOME = /data/oracle/product/10.2.0/db)
      (SID_NAME = SIT)
    )
    (SID_DESC =
          (SID_NAME = hsodbc)
          (ORACLE_HOME = /data/oracle/product/10.2.0/db)
          (PROGRAM = hsodbc)
    )
  )

LISTENER1G =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Server1.domain)(PORT = 1523))
  )


TnsNames.Ora

TEST =        
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=
        (PROTOCOL=TCP)    
        (HOST=Server1.domain)  
        (PORT=1523)       
      )
    )
    (CONNECT_DATA=(SID=TEST))
    (HS=OK)
  ) 


Restart/reload your listener using

lsnrctl reload LISTENER10G 


Now Try..
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #412151 is a reply to message #411899] Wed, 08 July 2009 00:39 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi gentlebabu,

I am chaging the files, only thing is according to the listener.ora you have mentioned, seems I will need to mention port as 1522 in my tnsnames.ora

also I will change my inittest.ora as inithsodbc.ora and SID in db link as well

Hope my understanding is correct

Thanks and Regards,
OraKaran

Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #412155 is a reply to message #412151] Wed, 08 July 2009 00:54 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>I am chaging the files, only thing is according to the listener.ora you have mentioned, seems I will need to mention port as 1522 in my tnsnames.ora

It's okay. but make sure listener services running.

>>also I will change my inittest.ora as inithsodbc.ora and SID in db link as well

I think your trying to confuse.

1/ Don't touch your pfile ( I mean inittest.ora); Don't remove/add new entry's in your pfile.

2/ In inithsodbc.ora (which located in ORACLE_HOME/HS/ADMIN). Just add your system DSN name in HS_FDS_CONNECT_INFO.

For example: my system dsn name "msdb". check the below inithsodbc.ora file content.

Quote:
SQL> host type F:\oracle\product\10.2.0\db_1\hs\admin\inithsodbc.ora
# 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 = msdb
HS_FDS_TRACE_LEVEL = off


#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #412156 is a reply to message #411899] Wed, 08 July 2009 01:05 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi gentlebabu,

after the changes suggested by you new error is as follows

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][unixODBC][Driver Manager]Data source name not
found, and no default driver specified (SQL State: IM002; SQL Code: 0)
ORA-02063: preceding 2 lines from HSODBC


The latest configurations are as follows

inithsodbc.ora
-----------------

# 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 = mdb
HS_FDS_TRACE_LEVEL = off
HS_FDS_SHAREABLE_NAME = /usr/lib/libodbc.so

#
# ODBC specific environment variables
#
set ODBCINI = /usr/lib/libodbc.so


#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

tnsnames.ora
---------------
hsodbc =
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST=Server1.domain)
        (PORT=1522)
      )
    )
    (CONNECT_DATA=(SID=hsodbc))
    (HS=OK)
  )

DBLINK
-------

create database link hsodbc using '(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)) (CONNECT_DATA=(SID=hsodbc)) (HS=OK))';

SQL> select * from Table1@hsodbc;
select * from Table1@hsodbc
                     *
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][unixODBC][Driver Manager]Data source name not
found, and no default driver specified (SQL State: IM002; SQL Code: 0)
ORA-02063: preceding 2 lines from HSODBC

Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #412158 is a reply to message #411899] Wed, 08 July 2009 01:07 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi gentlebabu,

Do I need to add any contents in odbc.ini file?

Thanks and Regards,
OraKaran
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #412160 is a reply to message #412156] Wed, 08 July 2009 01:11 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>Generic Connectivity Using ODBC][unixODBC][Driver Manager

Looks like you don't have sufficient driver. Try to install.

Babu
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #412172 is a reply to message #412160] Wed, 08 July 2009 02:00 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>Do I need to add any contents in odbc.ini file?

Actually i tried using windows environment but your working working as Linux.

Try to do something in drivers.

Thanks
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #412179 is a reply to message #411899] Wed, 08 July 2009 02:17 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi gentlebabu,

I assume I need to install Microsoft Access drivers [for ODBC ] on my Linux server.

Could you please point me to any link from where I can download such drivers for Linux 23 bit and Linux 64 bit?

After that will I need to configure odbc.ini?

Many Many thanks for your help

Thanks and Regards,
OraKaran
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #412192 is a reply to message #412179] Wed, 08 July 2009 03:21 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>Could you please point me to any link from where I can download such drivers for Linux 23 bit and Linux 64 bit?

Google is your friend; 99% answer avaliable in Linux document (bug/any nay patch for odbc releated details) Please search.

Thanks
Babu
Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #412256 is a reply to message #411899] Wed, 08 July 2009 06:47 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi gentlebabu,

Yes I searched on google but found nothing

Easysoft has close match but not exactly what I want i.e. Microsoft Access Drivers for Linux 32bit and 64 bit

Thanks and Regards,
OraKaran
Re: Generic Connectivity Not Working (Oracle -MYSQL) [message #658207 is a reply to message #412256] Wed, 07 December 2016 02:57 Go to previous messageGo to next message
dileepkallone
Messages: 2
Registered: December 2007
Junior Member
Hi,

I am facing an issue while connecting to MySQL database from Oracle (11.2.0). The below error is popping up while testing the database link. Anyone, please help!.

An error was encountered performing the requested operation:

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 MYSQL
28545. 0000 - "error diagnosed by Net8 when connecting to an agent"
*Cause: An attempt to call an external procedure or to issue SQL
to a non-Oracle system on a Heterogeneous Services database link
failed at connection initialization. The error diagnosed
by Net8 NCR software is reported separately.
*Action: Refer to the Net8 NCRO error message. If this isn't clear,
check connection administrative setup in tnsnames.ora
and listener.ora for the service associated with the
Heterogeneous Services database link being used, or with
'extproc_connection_data' for an external procedure call.
Vendor code 28545


-------------


Below is my listener.ora & tnsnames.ora


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = F:\Oracle\product\11.2.0\dbhome_1)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\Oracle\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = F:\Oracle\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
)
(SID_DESC =
(PROGRAM = hsodbc)
(ORACLE_HOME = F:\Oracle\product\11.2.0\dbhome_1)
(SID_NAME =MySQL)
)



)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.40.40.14)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

ADR_BASE_LISTENER = F:\Oracle
-------------


TNSNAMES.ORA
-----------


LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

MYSQL =
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=MySQL))(HS=OK))





Re: Generic Connectivity Not Working (Oracle -MYSQL) [message #658215 is a reply to message #658207] Wed, 07 December 2016 04:15 Go to previous messageGo to next message
dileepkallone
Messages: 2
Registered: December 2007
Junior Member
The issue resolved.

replaced hsodbc with dg4odbc
Re: Generic Connectivity Not Working (Oracle -MYSQL) [message #658230 is a reply to message #658215] Wed, 07 December 2016 06:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thanks for the feedback, it will hep future readers.

Re: Generic Connectivity Not Working (Oracle -Ms Access) [message #658237 is a reply to message #411967] Wed, 07 December 2016 06:55 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
OraKaran wrote on Tue, 07 July 2009 06:24
Hi gentlebabu,

We have few database instances listening on ports 1521 and 1522
Databases do not listen on ports. Listener do.

Quote:
with listener name as LISTENER and LISTENER10G


You have already made your installation overly complex.
============================================================================
Please stay after school and write the following sentence 100 times:

One single listener, using the default name of LISTENER and the default port of 1521, is quite capable of -- indeed, WAS DESIGNED TO -- service multiple databases of multiple versions running from multiple homes. Multiple listeners simply adds complications, and for no gain whatsoever.
============================================================================
Previous Topic: CONNECT TO DB2 ERROR by Oracle Gateway in Linux "ORA-28500 AND Data source name not found, and no de
Next Topic: ORA-12560: TNS:protocol adapter error
Goto Forum:
  


Current Time: Thu Mar 28 18:52:53 CDT 2024