Yum install postgres dblink

It can easily be achieved by using the following command:. Or, if you are comfortable with the GUI installer, you can install using the stack builder as well:. Avoid the uppercase while assigning the DNS names. Amit Sharma Jun 29, Migration. Configure tnsnames. Once the configuration is done perform tnsping pg. Step 6. We are ready to create dblink, connect to Oracle Database, and use Create database link command to create database link.

Hope so you like this article! Click here to understand more about our pursuit. Vote count: 0. No votes so far! Be the first to rate this post.

Your email address will not be published. Save my name, email, and website in this browser for the next time I comment. Total Website Visits: Oracle Database 21c is Available Innovation Release. Step by step silent installation of Oracle 19c on Linux 7. Website Tracking Website Tracking.

Skip to content Open Menu. All rights reserved. Service "pg" has 1 instance s. Service "test01" has 1 instance s. Service "test01XDB" has 1 instance s. How useful was this post? This setup also helps us evaluate PostgreSQL without taking risks with the production environment and make a path forward to future migration and reducing costs.

It can easily be achieved by using the following command:. Or, if you are comfortable with the GUI installer, you can install using the stack builder as well:.