Discussions
Categories
- 384.5K All Categories
- 2.5K Data
- 552 Big Data Appliance
- 1.9K Data Science
- 451.3K Databases
- 222.1K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 561 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 561 SQLcl
- 4K SQL Developer Data Modeler
- 187.5K SQL & PL/SQL
- 21.4K SQL Developer
- 296.9K Development
- 1 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 293.6K Development Tools
- 112 DevOps
- 3.1K QA/Testing
- 646.2K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 193 Java Community Process
- 106 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 166 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 532 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 178 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 236 Portuguese
Reg: migration to gateway connection from oracle to gateway server
Hi experts,
I have to create db link from oracle db to gateway mysql server, how can i create the db link.
I have addedd the listener entry from Gateway server to tnsnames.ora file in oracle db server, ,and tnsping is working fine.
after this i need to create the dblink to connect from oracle to mysql server db, but i dont' have username and password to create db link.
Any suggestions.
Answers
-
Get the username and password credentials of the mysql server db account you want to login as to see the mysql objects, and use those credentials in your Oracle db link.
If you mean you do not have the Oracle privileges to create a database link, then perhaps get your friendly DBA to grant you "create database link..." or you login as, say, system and "grant user you create database link;" and then login as you and create the db link.
-
You might find this blog article helpful.
It describes each step of of the chain in using a db link. The article uses MS SQL as the example target, but it would be exactly the same for any other target database.
