Oracle通过DBLINK访问PG13
2022/3/21 2:28:16
本文主要是介绍Oracle通过DBLINK访问PG13,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
root用户执行:
yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm yum install -y unixODBC.x86_64 yum - y install postgresql13-odbc.x86_64 unlink /usr/lib64/libpq.so.5 ln -s /usr/pgsql-13/lib/libpq.so.5.13 /usr/lib64/libpq.so.5
修改文件/etc/odbcinst.ini,将Driver改成pg13的
[PostgreSQL] Description = ODBC for PostgreSQL Driver = /usr/pgsql-13/lib/psqlodbcw.so Setup = /usr/lib/libodbcpsqlS.so Driver64 = /usr/pgsql-13/lib/psqlodbcw.so Setup64 = /usr/lib64/libodbcpsqlS.so FileUsage = 1
创建文件/etc/odbc.ini
[postgresql] Description = PostgresSQLODBC Driver = PostgreSQL Database = demo Servername = 192.168.0.42 UserName = test Password = test123 Port = 5432 ReadOnly = 0 ConnSettings = set client_encoding to UTF8
测试连接:
isql -v postgresql
oracle用户执行下面的步骤:
创建文件~/.odbc.ini
[PG_LINK] Description = PostgreSQL connection to SallyDB Driver = /usr/pgsql-13/lib/psqlodbc.so Setup = /usr/lib64/libodbcpsqlS.so Database = demo Servername = 192.168.0.42 UserName = test Password = test123 Port = 5432 Protocol = 13.1 ReadOnly = No RowVersioning = No ShowSystemTables = No ConnSettings = set client_encoding to UTF8
创建文件: /u01/app/oracle/product/19.0.0/dbhome_1/hs/admin/initPG_LINK.ora
HS_FDS_CONNECT_INFO = PG_LINK HS_FDS_TRACE_LEVEL = 255 HS_FDS_SHAREABLE_NAME=/usr/pgsql-13/lib/psqlodbc.so HS_LANGUAGE=AMERICAN_AMERICA.UTF8 set ODBCINI=/home/oracle/.odbc.ini HS_NLS_NCHAR=UCS2 HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
在文件 /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora 中追加如下内容:
PG_LINK = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.24)(PORT=1521)) (CONNECT_DATA=(SID=PG_LINK)) (HS=OK) )
在文件 /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora 中追加:
SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (SID_NAME=PG_LINK) (ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1) (ENV="LD_LIBRARY_PATH=/usr/lib64/:/u01/app/oracle/product/19.0.0/dbhome_1/bin/") (PROGRAM=dg4odbc) ) )
创建dblink
drop database link to_pglink; create database link to_pglink connect to "test" identified by "test123" using 'PG_LINK';
使用DBLINK连接访问
select count(*) from "gupolicymain"@to_pglink;
使用同义词访问:
create or replace synonym testx for "gupolicymain"@to_pglink; select count(*) from gupolicymain;
这篇关于Oracle通过DBLINK访问PG13的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-09-28pyqt 怎么打包整个项目-icode9专业技术文章分享
- 2024-09-28laravel Commands 创建带有参数的 Artisan 命令的步骤和示例-icode9专业技术文章分享
- 2024-09-28antd怎么实现渲染tiff图片-icode9专业技术文章分享
- 2024-09-28英文半角中划线和中文全角的中划线有什么区别-icode9专业技术文章分享
- 2024-09-28nvm npm 和node 他们之间有什么关系-icode9专业技术文章分享
- 2024-09-28Node Version Manager (nvm)使用教程-icode9专业技术文章分享
- 2024-09-28nvm命令太慢,是什么原因-icode9专业技术文章分享
- 2024-09-28Kotlin 如何增加、删除和修改 MutableStateFlow 中的值。-icode9专业技术文章分享
- 2024-09-28Kotlin的stateFlow.update 写法介绍-icode9专业技术文章分享
- 2024-09-28kotlin 怎么获取当前时间格式-icode9专业技术文章分享