Home » RDBMS Server » Server Administration » what is the procedure to select mysql database data from oracle 11g (oracle 11g, Redhat 5)
what is the procedure to select mysql database data from oracle 11g [message #621885] Tue, 19 August 2014 07:26 Go to next message
morad_dba
Messages: 93
Registered: June 2008
Member
Dear all,

what procedure i can follow to configure database connectivity so that i can select mysql database data from oracle 11g in linux?

please tell me what package i can download?

regards,
Morad.


Re: what is the procedure to select mysql database data from oracle 11g [message #621886 is a reply to message #621885] Tue, 19 August 2014 07:42 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Oracle Gateway.

Unless you use the Gateway for ODBC, it will entail additional licensing

If you use the Gateway for ODBC, it is free but you will also need an ODBC driver for the target database.

I believe that Oracle Gateway for ODBC is installed in your ORACLE_HOME by default.

If you have an MOS account, see note 1083703.1

If not, start googling, based on the clues I've given above.

See http://docs.oracle.com/cd/E11882_01/server.112/e11050/admin.htm#HETER004

Also, you will need to create a db link in the source (oracle) database.

[Updated on: Tue, 19 August 2014 07:43]

Report message to a moderator

Re: what is the procedure to select mysql database data from oracle 11g [message #621888 is a reply to message #621886] Tue, 19 August 2014 07:50 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
PERL can inter-operate with both MYSQL & Oracle concurrently.
Re: what is the procedure to select mysql database data from oracle 11g [message #621889 is a reply to message #621888] Tue, 19 August 2014 08:08 Go to previous message
morad_dba
Messages: 93
Registered: June 2008
Member

dear all,

can u please give me step by step procedure of configuration of mysql-connector-odbc and oracle hs configuration ?

regards,
morad.
Previous Topic: dba_tables.container_data
Next Topic: Database down but database missing
Goto Forum:
  


Current Time: Thu Mar 28 04:50:44 CDT 2024