1 2 3 Previous Next 40 Replies Latest reply: Oct 9, 2013 10:51 PM by user13573211 Go to original post RSS
      • 30. Re: ORACLE to POSTGRES db link not working
        user13573211

        Let me post those file also::

         

        [oracle@scflsdb001 admin]$ cat /home/oracle/temp/psqlodbc-09.02.0100/test/odbc.ini

        [postgresql]

        Description             = psqlodbc regression test DSN

        Driver                          = /home/oracle/temp/psqlodbc-09.02.0100/.libs/psqlodbcw.so

        Trace                       = Yes

        TraceFile               = /home/oracle/tmp/sql.log

        Database                = *********

        Servername              = devpgres00.office.corp

        Username                = ********

        Password                = **********

        Port                        = 5432

        Protocol                = 6.4

        ReadOnly                = No

        RowVersioning           = No

        ShowSystemTable         = No

        ShowOidColumn           = No

        FakeOidIndex            = No

        ConnSettings            =

        [oracle@scflsdb001 admin]$

         

        [oracle@scflsdb001 admin]$ cat /home/oracle/temp/psqlodbc-09.02.0100/test/odbcinst.ini

        [psqlodbc]

        Description     = PostgreSQL ODBC driver (Unicode version), for regression tests

        Driver          = ../.libs/psqlodbcw.so

        Debug           = 0

        CommLog         = 1

        [oracle@scflsdb001 admin]$

        • 31. Re: ORACLE to POSTGRES db link not working
          Kgronau-Oracle

          the error is:

           

          Unable to open init file initpostgresql.ora in directory /oracle/database/11.2.0.3/hs/admin

          HS Gateway:  NULL connection context at exit

           

           

          In one of the first threads you stated your gateway init file is:

          /oracle/database/11.2.0.3/hs/admin/initdg4odbc.ora

           

          But the listener SID is postgresql ((SID_NAME = postgresql))

          So please rename initdg4odbc.ora to initpostgresql.ora

           

          BTW, did you already change the HS_FDS_SHAREABLE_NAME parameter so that it now refers to the 64bit Driver Manager?

          According to another thread -> yes, but cross check that again.

          It should be similar to HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so

           

          - Klaus

          • 32. Re: ORACLE to POSTGRES db link not working
            user13573211

            Finally it looks like it is working....

             

            SQL> select * from "shopping_list"@pg_link1;               

            select * from "shopping_list"@pg_link1

                          *

            ERROR at line 1:

            ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

            ERROR:  relation "shopping_list" does not exist at character 21;

            No query has been executed with that handle {HY000,NativeErr = 1}

            ORA-02063: preceding 3 lines from PG_LINK1

             

            But I dont know any table name in the POSTGRES DB, is there any way that I can know the POSTGRES table..?? SO that I can test the link..??

            • 33. Re: ORACLE to POSTGRES db link not working
              Kgronau-Oracle

              there are queries to check objects at the foreign database - unfortunately not all work with foreign databases all the time.

              Try:

              select user from dual@pg_link1;

              dual is an Oracle table and when t does not exist at the foreign database the gateway will use internal mechanisms to return a result. But that would require that the ODBC driver returns a correct error code (like table does not exist) which then triggers the internal gateway mechanism. That does not always work using a gateway with foreign ODBC drivers, but works very often and is worth to check.

               

              Then check:

              select * from all_catalog@pg_link1;

              also all_catalog will use internal mechanisms to get a result and when it works, then it reports a list of available objects in the foreign Postgres database.

               

               

              Finally ask the Postgres admin which object you can select. Take care about the object name, it might be case sensitive. So write it as it is in the select statement and make sure to surround it by double quotes.

              • 34. Re: ORACLE to POSTGRES db link not working
                user13573211

                I have got errors for every try...Can I really trust that my connection is working....?? what tells me that my connection is working..???

                 

                SQL> select user from dual@pg_link1;

                select user from dual@pg_link1

                                 *

                ERROR at line 1:

                ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

                ERROR:  relation "DUAL" does not exist at character 21;

                No query has been executed with that handle {HY000,NativeErr = 1}

                ORA-02063: preceding 3 lines from PG_LINK1

                 

                 

                 

                 

                SQL> select * from all_catalog@pg_link1;

                select * from all_catalog@pg_link1

                              *

                ERROR at line 1:

                ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

                ERROR:  relation "ALL_CATALOG" does not exist at character 21;

                No query has been executed with that handle {HY000,NativeErr = 1}

                ORA-02063: preceding 3 lines from PG_LINK1

                • 35. Re: ORACLE to POSTGRES db link not working
                  Kgronau-Oracle

                  as I said - that can happen for mimicked tables when the ODBC driver does not return the correct error message which forces the gateway to use the internal mechanisms (root cause analysis would require ODBC traces). So best would be in those cases to ask the Postgres admin which objects exist in the database and then to check if you can query one of them.

                  • 36. Re: ORACLE to POSTGRES db link not working
                    user13573211

                    [oracle@scflsdb001 log]$ cat postgresql_agt_16113.trc

                     

                     

                     

                     

                    Oracle Corporation --- FRIDAY    SEP 27 2013 09:01:47.541

                     

                     

                     

                     

                    Heterogeneous Agent Release

                    11.2.0.3.0

                     

                     

                     

                     

                     

                     

                     

                     

                    Oracle Corporation --- FRIDAY    SEP 27 2013 09:01:47.541

                     

                     

                        Version 11.2.0.3.0

                     

                     

                    Entered hgogprd

                    HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG"

                    Entered hgosdip

                    setting HS_OPEN_CURSORS to default of 50

                    setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"

                    setting HS_FDS_RECOVERY_PWD to default value

                    setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG

                    setting HS_IDLE_TIMEOUT to default of 0

                    setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"

                    setting HS_NLS_NCHAR to default of "AL32UTF8"

                    setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"

                    setting HS_FDS_DATE_MAPPING to default of "DATE"

                    setting HS_RPC_FETCH_REBLOCKING to default of "ON"

                    setting HS_FDS_FETCH_ROWS to default of "100"

                    setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"

                    setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"

                    setting HS_FDS_PROC_IS_FUNC to default of "FALSE"

                    setting HS_FDS_MAP_NCHAR to default of "TRUE"

                    setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"

                    setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"

                    setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"

                    setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"

                    setting HS_FDS_QUERY_DRIVER to default of "TRUE"

                    setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"

                    setting HS_FDS_QUOTE_IDENTIFIER to default of "TRUE"

                    setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"

                    setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"

                    setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"

                    Default value of 64 assumed for HS_FDS_SQLLEN_INTERPRETATION

                    setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"

                    setting HS_FDS_DELAYED_OPEN to default of "TRUE"

                    setting HS_FDS_WORKAROUNDS to default of "0"

                    Exiting hgosdip, rc=0

                    ORACLE_SID is "postgresql"

                    Product-Info:

                      Port Rls/Upd:3/0 PrdStat:0

                      Agent:Oracle Database Gateway for ODBC

                      Facility:hsa

                      Class:ODBC, ClassVsn:11.2.0.3.0_0011, Instance:postgresql

                    Exiting hgogprd, rc=0

                    Entered hgoinit

                    HOCXU_COMP_CSET=1

                    HOCXU_DRV_CSET=31

                    HOCXU_DRV_NCHAR=873

                    HOCXU_DB_CSET=178

                    HS_LANGUAGE not specified

                    LANG=en_US.UTF-8

                    HOCXU_SEM_VER=112000

                    Entered hgolofn at 2013/09/27-09:01:47

                    HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/lib64/libodbc.so"

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d608300

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d608390

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d608b50

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d609dc0

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d611890

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d611d30

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d614580

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d615a20

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d616220

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d617c40

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d617c60

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d619370

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d61c4f0

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d61c890

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d61e330

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d61ef80

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d61f280

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d6210b0

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d621480

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d622fc0

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d622e10

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d60a3e0

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d60bb80

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d60f4f0

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d611150

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d612890

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d6154b0

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d616b40

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d617fb0

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d6199d0

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d619e90

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d61b060

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d61bc90

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d61cad0

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d61d4d0

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d61df90

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d61f9b0

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d61fec0

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d620470

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d620b00

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d621770

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d624320

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d622b30

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d6258c0

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Entered hgolofns at 2013/09/27-09:01:47

                    symbol_peflctx=0x3d626550

                    hoaerr:0

                    Exiting hgolofns at 2013/09/27-09:01:47

                    Exiting hgolofn, rc=0 at 2013/09/27-09:01:47

                    HOSGIP for "HS_OPEN_CURSORS" returned "50"

                    HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"

                    HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"

                    HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"

                    HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"

                    HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"

                    HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"

                    HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"

                    HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"

                    Invalid value of 64 given for HS_FDS_SQLLEN_INTERPRETATION

                    treat_SQLLEN_as_compiled = 1

                    Exiting hgoinit, rc=0 at 2013/09/27-09:01:47

                    Entered hgolgon at 2013/09/27-09:01:47

                    reco:0, name:postgres, tflag:0

                    Entered hgosuec at 2013/09/27-09:01:47

                    Exiting hgosuec, rc=0 at 2013/09/27-09:01:47

                    HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"

                    HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"

                    HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"

                    HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"

                    HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"

                    HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"

                    HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"

                    HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"

                    HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"

                    using postgres as default value for "HS_FDS_DEFAULT_OWNER"

                    HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"

                    Entered hgocont at 2013/09/27-09:01:47

                    HS_FDS_CONNECT_INFO = "postgresql"

                    RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"

                    Entered hgogenconstr at 2013/09/27-09:01:47

                    dsn:postgresql, name:postgres

                    optn:

                    Entered hgocip at 2013/09/27-09:01:47

                    dsn:postgresql

                    Exiting hgocip, rc=0 at 2013/09/27-09:01:47

                    Exiting hgogenconstr, rc=0 at 2013/09/27-09:01:47

                    Entered hgolosf at 2013/09/27-09:01:47

                    Exiting hgolosf, rc=0 at 2013/09/27-09:01:47

                    DriverName:psqlodbcw.so, DriverVer:09.02.0100

                    DBMS Name:PostgreSQL, DBMS Version:PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit

                    Exiting hgocont, rc=0 at 2013/09/27-09:01:47

                    SQLGetInfo returns Y for SQL_CATALOG_NAME

                    SQLGetInfo returns 0 for SQL_MAX_CATALOG_NAME_LEN

                    Exiting hgolgon, rc=0 at 2013/09/27-09:01:47

                    Entered hgoulcp at 2013/09/27-09:01:47

                    Entered hgowlst at 2013/09/27-09:01:47

                    Exiting hgowlst, rc=0 at 2013/09/27-09:01:47

                    SQLGetInfo returns 0x1d for SQL_OWNER_USAGE

                    TXN Capable:2, Isolation Option:0xa

                    SQLGetInfo returns 64 for SQL_MAX_SCHEMA_NAME_LEN

                    SQLGetInfo returns 64 for SQL_MAX_TABLE_NAME_LEN

                    SQLGetInfo returns 0 for SQL_MAX_PROCEDURE_NAME_LEN

                    HOSGIP returned value of "TRUE" for HS_FDS_QUOTE_IDENTIFIER

                    SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR

                    2 instance capabilities will be uploaded

                      capno:1989, context:0x00000000, add-info:        0

                      capno:1992, context:0x0001ffff, add-info:        0

                    Exiting hgoulcp, rc=0 at 2013/09/27-09:01:47

                    Entered hgouldt at 2013/09/27-09:01:47

                    NO instance DD translations were uploaded

                    Exiting hgouldt, rc=0 at 2013/09/27-09:01:47

                    Entered hgobegn at 2013/09/27-09:01:47

                    tflag:0 , initial:1

                    hoi:0x540d5238, ttid (len 30) is ...

                      00: 4D59574C 44445632 2E636236 33323431  [MYWLDDV2.cb63241]

                      10: 372E322E 32302E36 32363232 3332      [7.2.20.6262232]

                                     tbid (len 27) is ...

                      00: 4D59574C 44445632 5B322E32 302E3632  [MYWLDDV2[2.20.62]

                      10: 36323233 325D5B31 2E345D             [62232][1.4]]

                    Exiting hgobegn, rc=0 at 2013/09/27-09:01:47

                    Entered hgodtab at 2013/09/27-09:01:47

                    count:1

                      table: shopping_list

                    Allocate hoada[0] @ 0x1697a950

                    Free hoada[0] @ 0x1697a950

                    SQL text from hgodtab, id=0, len=29 ...

                         00: 73656C65 6374202A 2066726F 6D202273  [select * from "s]

                         10: 686F7070 696E675F 6C697374 22        [hopping_list"]

                    Entered hgopoer at 2013/09/27-09:01:47

                    hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...

                    ERROR:  relation "shopping_list" does not exist at character 21;

                    No query has been executed with that handle {HY000,NativeErr = 1}

                    Exiting hgopoer, rc=0 at 2013/09/27-09:01:47

                    Entered hgopdsc at 2013/09/27-09:01:47

                    Describing procedure shopping_list

                    Output hoada

                    hgopdsc, line 1434: NO hoada to print

                    Exiting hgopdsc, rc=942 at 2013/09/27-09:01:47

                    The hoada for table shopping_list follows...

                    hgodtab, line 1092: NO hoada to print

                    Exiting hgodtab, rc=0 at 2013/09/27-09:01:47

                    Entered hgopars, cursor id 1 at 2013/09/27-09:01:47

                    type:0

                    SQL text from hgopars, id=1, len=29 ...

                         00: 53454C45 4354202A 2046524F 4D202273  [SELECT * FROM "s]

                         10: 686F7070 696E675F 6C697374 22        [hopping_list"]

                    Entered hgopoer at 2013/09/27-09:01:47

                    hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...

                    ERROR:  relation "shopping_list" does not exist at character 21;

                    No query has been executed with that handle {HY000,NativeErr = 1}

                    Exiting hgopoer, rc=0 at 2013/09/27-09:01:47

                    hgopars, line 526: calling SQLNumResultCols got sqlstate HY000

                    Exiting hgopars, rc=28500 at 2013/09/27-09:01:47 with error ptr FILE:hgopars.c LINE:556 FUNCTION:hgopars() ID:Preprocess number of columns

                    Entered hgodtab at 2013/09/27-09:07:17

                    count:1

                      table: usr_acct

                    Allocate hoada[0] @ 0x1697a950

                    Free hoada[0] @ 0x1697a950

                    SQL text from hgodtab, id=0, len=24 ...

                         00: 73656C65 6374202A 2066726F 6D202275  [select * from "u]

                         10: 73725F61 63637422                    [sr_acct"]

                    Entered hgopoer at 2013/09/27-09:07:17

                    hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...

                    ERROR:  relation "usr_acct" does not exist at character 21;

                    No query has been executed with that handle {HY000,NativeErr = 1}

                    Exiting hgopoer, rc=0 at 2013/09/27-09:07:17

                    Entered hgopdsc at 2013/09/27-09:07:17

                    Describing procedure usr_acct

                    Output hoada

                    hgopdsc, line 1434: NO hoada to print

                    Exiting hgopdsc, rc=942 at 2013/09/27-09:07:17

                    The hoada for table usr_acct follows...

                    hgodtab, line 1092: NO hoada to print

                    Exiting hgodtab, rc=0 at 2013/09/27-09:07:17

                    Entered hgopars, cursor id 1 at 2013/09/27-09:07:17

                    type:0

                    SQL text from hgopars, id=1, len=24 ...

                         00: 53454C45 4354202A 2046524F 4D202275  [SELECT * FROM "u]

                         10: 73725F61 63637422                    [sr_acct"]

                    Entered hgopoer at 2013/09/27-09:07:17

                    hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...

                    ERROR:  relation "usr_acct" does not exist at character 21;

                    No query has been executed with that handle {HY000,NativeErr = 1}

                    Exiting hgopoer, rc=0 at 2013/09/27-09:07:17

                    hgopars, line 526: calling SQLNumResultCols got sqlstate HY000

                    Exiting hgopars, rc=28500 at 2013/09/27-09:07:17 with error ptr FILE:hgopars.c LINE:556 FUNCTION:hgopars() ID:Preprocess number of columns

                    Entered hgodtab at 2013/09/27-09:07:42

                    count:1

                      table: Usr_acct

                    Allocate hoada[0] @ 0x1697a950

                    Free hoada[0] @ 0x1697a950

                    SQL text from hgodtab, id=0, len=24 ...

                         00: 73656C65 6374202A 2066726F 6D202255  [select * from "U]

                         10: 73725F61 63637422                    [sr_acct"]

                    Entered hgopoer at 2013/09/27-09:07:42

                    hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...

                    ERROR:  relation "Usr_acct" does not exist at character 21;

                    No query has been executed with that handle {HY000,NativeErr = 1}

                    Exiting hgopoer, rc=0 at 2013/09/27-09:07:42

                    Entered hgopdsc at 2013/09/27-09:07:42

                    Describing procedure Usr_acct

                    Output hoada

                    hgopdsc, line 1434: NO hoada to print

                    Exiting hgopdsc, rc=942 at 2013/09/27-09:07:42

                    The hoada for table Usr_acct follows...

                    hgodtab, line 1092: NO hoada to print

                    Exiting hgodtab, rc=0 at 2013/09/27-09:07:42

                    Entered hgopars, cursor id 1 at 2013/09/27-09:07:42

                    type:0

                    SQL text from hgopars, id=1, len=24 ...

                         00: 53454C45 4354202A 2046524F 4D202255  [SELECT * FROM "U]

                         10: 73725F61 63637422                    [sr_acct"]

                    Entered hgopoer at 2013/09/27-09:07:42

                    hgopoer, line 231: got native error 1 and sqlstate HY000; message follows...

                    ERROR:  relation "Usr_acct" does not exist at character 21;

                    No query has been executed with that handle {HY000,NativeErr = 1}

                    Exiting hgopoer, rc=0 at 2013/09/27-09:07:42

                    hgopars, line 526: calling SQLNumResultCols got sqlstate HY000

                    Exiting hgopars, rc=28500 at 2013/09/27-09:07:42 with error ptr FILE:hgopars.c LINE:556 FUNCTION:hgopars() ID:Preprocess number of columns

                    Entered hgocomm at 2013/09/27-10:04:10

                    keepinfo:0, tflag:1

                       00: 4D59574C 44445632 2E636236 33323431  [MYWLDDV2.cb63241]

                       10: 372E322E 32302E36 32363232 3332      [7.2.20.6262232]

                                     tbid (len 27) is ...

                       00: 4D59574C 44445632 5B322E32 302E3632  [MYWLDDV2[2.20.62]

                       10: 36323233 325D5B31 2E345D             [62232][1.4]]

                    cmt(0):

                    Entered hgocpctx at 2013/09/27-10:04:10

                    Exiting hgocpctx, rc=0 at 2013/09/27-10:04:10

                    Exiting hgocomm, rc=0 at 2013/09/27-10:04:10

                    Entered hgolgof at 2013/09/27-10:04:10

                    tflag:1

                    Exiting hgolgof, rc=0 at 2013/09/27-10:04:10

                    Entered hgoexit at 2013/09/27-10:04:10

                    Exiting hgoexit, rc=0

                    • 37. Re: ORACLE to POSTGRES db link not working
                      Kgronau-Oracle

                      Please start isql, the ODBC test utility and try to select from these tables that you want to access using the gateway (shopping_list, usr_acct), does that work?

                      - Klaus

                      • 38. Re: ORACLE to POSTGRES db link not working
                        Kgronau-Oracle

                        According to your configuration the unixODBC Driver Manager library was installed into /usr/lib64 - see the location of the libodbc.so file. I assume you've used a package to install the driver manager, so check out the package details where it might have placed all other required libs/source files.

                        • 39. Re: ORACLE to POSTGRES db link not working
                          user13573211

                          Hello MR.Kgronau:

                           

                          Could you PLEASE PLEASE PLEASE look into the below thread please.

                           

                          https://forums.oracle.com/message/11222242#11222242

                          • 40. Re: ORACLE to POSTGRES db link not working
                            user13573211

                            Hello MR.Kgronau:

                             

                            Could you PLEASE look into the below thread please.

                             

                            https://forums.oracle.com/thread/2590577?start=0&tstart=0

                            1 2 3 Previous Next