Forum: help


RE: Error with dbi_link [ reply ] By: Cristiano Duarte on 2009-09-11 14:12 | [forum:1005333] |
Hi Alain, Sorry for the late response, I'm currently on a business travel in the middle of the Amazon rain forest and answering this post through a private satellite connection. You don't need to setup dbi-link in order to have pgsnapshot working. I can't help you much with dbi-link, since i'm not following its changes anymore. i think, due to the spi implementation, that dbi-link doesn't have persistent connections and so doesn't pgsnapshots. Regards, Cristiano |
Error with dbi_link [ reply ] By: Alain PERSONNAT on 2009-09-08 14:53 | [forum:1005321] |
Hello, I 've installed the dbi-link-2.0.0 package with success and I also could performed a request on my Oracle database with the following query : select * from test_dblink."SALES"; After bounced the both databases I wanted to re-test the dblink before begining the intall of the snapshot package and I had this message (sorry I didn't find the 'attach file' button) : testdb=# select * from test1_dblink."SALES"; NOTICE: Setting bail in %_SHARED hash. at line 25. CONTEXT: SQL statement "SELECT dbi_link.dbi_link_init()" NOTICE: Setting quote_literal in %_SHARED hash. at line 25. CONTEXT: SQL statement "SELECT dbi_link.dbi_link_init()" NOTICE: Setting get_connection_info in %_SHARED hash. at line 25. CONTEXT: SQL statement "SELECT dbi_link.dbi_link_init()" NOTICE: Setting quote_ident in %_SHARED hash. at line 25. CONTEXT: SQL statement "SELECT dbi_link.dbi_link_init()" NOTICE: Setting get_dbh in %_SHARED hash. at line 25. CONTEXT: SQL statement "SELECT dbi_link.dbi_link_init()" NOTICE: Setting remote_exec_dbh in %_SHARED hash. at line 25. CONTEXT: SQL statement "SELECT dbi_link.dbi_link_init()" NOTICE: SELECT dbi_link.cache_connection( 1 ) at line 12. NOTICE: In cache_connection, there's no shared dbh 1 at line 7. CONTEXT: SQL statement "SELECT dbi_link.cache_connection( 1 )" NOTICE: Entering get_connection_info at line 44. CONTEXT: SQL statement "SELECT dbi_link.cache_connection( 1 )" NOTICE: ref($args) is HASH --- data_source_id: 1 CONTEXT: SQL statement "SELECT dbi_link.cache_connection( 1 )" NOTICE: Leaving get_connection_info at line 75. CONTEXT: SQL statement "SELECT dbi_link.cache_connection( 1 )" NOTICE: --- auth: SH data_source: dbi:Oracle:host=localhost;sid=BT2P;port=1521 dbh_attributes: | --- AutoCommit: 1 RaiseError: 1 local_schema: test1_dblink remote_catalog: ~ remote_schema: ~ user_name: SH CONTEXT: SQL statement "SELECT dbi_link.cache_connection( 1 )" NOTICE: In get_dbh, input connection info is --- auth: SH data_source: dbi:Oracle:host=localhost;sid=BT2P;port=1521 dbh_attributes: | --- AutoCommit: 1 RaiseError: 1 local_schema: test1_dblink remote_catalog: ~ remote_schema: ~ user_name: SH CONTEXT: SQL statement "SELECT dbi_link.cache_connection( 1 )" ERROR: error from Perl function "remote_select": error from Perl function "cache_connection": DBI connect('host=localhost;sid=BT2P;port=1521','SH',...) failed: (UNKNOWN OCI STATUS 1804) OCIInitialize. Check Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions, etc at line 137 at line 13. After checking the PATH, the ORACLE_HOME, the LD_LIBRARY_PATH I tested an ODBC cnx with success. So I re-installed the package and the test was OK. This morning I have the same issue, does it mean that the dblink is not persistent ? Thanks for your answer ;-) Regards, Alain |