The following library is required for pblighttpd to connect to the Oracle ODBC: /usr/lib/oracle/18.5/client64/lib/libsqora.so.18.1.Create /opt/pbul/etc/odbcinst.ini: ĭriver = /usr/lib/oracle/18.5/client64/lib/libsqora.so.18.1.Copying it elsewhere and setting environment variable TNS_ADMIN to the new directory does not work. The tnsnames.ora file needs to be in /etc. ORCLCDB=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=moonfish)(PORT=1521)))(CONNECT_DATA=(SID=ORCLCDB))) Create /etc/tnsnames.ora: # cat /etc/tnsnames.ora. In pb.settings set: eventdestinations authevt=odbc=Oracle.Install unixODBC needed by Oracle ODBC: # yum install unixODBC Version 19.3 does not work on RHEL 6, but works on RHEL 7: # cd /tmp/Oracle On RHEL 6, install oracle-instantclient-basic… and oracle-instantclient-odbc v18.5. Oracle InstantClient (basic and ODBC) can be downloaded from. Steps shown below are on a CentOS 6 system: Run the following steps on the log server, where only the Oracle ODBC connector needs to be installed.SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production SQL> GRANT UNLIMITED TABLESPACE to mdavis SQL> GRANT CONNECT,RESOURCE,DBA to mdavis SQL> create user mdavis identified by mdavis SQL> alter session set "_ORACLE_SCRIPT"=true Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Last login: Wed Sep 4 17:28: from on pts/0
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |