1 2 3 4 5 Previous Next 94 Replies Latest reply: Oct 14, 2013 5:15 AM by user13573211 Go to original post RSS
      • 30. Re: Oracle to POstgresql db link not working.....
        user13573211

        Oracle Dr.Klaus


        Still getting the same error, even after changing the LISTNER file as above as you sugested.


         

         

        SQL> select count(*) from "usr_acct"@pg_link;

        select count(*) from "usr_acct"@pg_link

                                        *

        ERROR at line 1:

        ORA-28545: error diagnosed by Net8 when connecting to an agent

        Unable to retrieve text of NETWORK/NCR message 65535

        ORA-02063: preceding 2 lines from PG_LINK

        • 31. Re: Oracle to POstgresql db link not working.....
          user13573211

          hi Klaus..can you pleaseeee respond...

          • 32. Re: Oracle to POstgresql db link not working.....
            Kgronau-Oracle

            Why did you now set again the home to the GRID home "(ORACLE_HOME = /oracle/product/11.2.0/grid)"

            we already have set it to the DATABASE HOME where dg4odbc is located.

            Please hcnage it back and then stop and start the listener.

             

            When it continues to fail with the ORA-28545 error please get a strace file:

            1. check out the listener process PID: ps -ef|grep tns

            2. strace -fae -o dg4odbc.log -p <PID of the Postgres Listener>

            => now start again another SQL*Plus session and execute your select.

            Once you got the error, kill the strace process and upload the strace output file dg4odbc.log to a file share like drop box.

            • 33. Re: Oracle to POstgresql db link not working.....
              user13573211

              very latest one

               

              LISTENER_POSTGRES =

                (DESCRIPTION_LIST =

                  (DESCRIPTION =

                    (ADDRESS = (PROTOCOL = TCP)(HOST = devdb00.office.corp)(PORT = 1525))

                    (ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))

                  )

                )

               

               

              SID_LIST_LISTENER_POSTGRES =

              (SID_LIST =

                      (SID_DESC =

                              (SID_NAME = postgresql)

                              (ORACLE_HOME = /oracle/product/11.2.0/dbhome)

                              (PROGRAM = /oracle/product/11.2.0/dbhome/bin/dg4odbc)

                      (ENV = "LD_LIBRARY_PATH=/oracle/product/11.2.0/dbhome/lib:/usr/lib64")

                      )

              )

               

               

              #ADR_BASE_LISTENER_POSTGRES = /oracle/database

               

               

              LOGGING_LISTENER_POSTGRES = ON

              ADR_BASE_LISTENER = /oracle

              ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

              TRACE_LEVEL_LISTENER = OFF

              • 34. Re: Oracle to POstgresql db link not working.....
                Kgronau-Oracle

                does it work with that listener? If not, please provide the strace log file generated as described in my previous update.

                • 35. Re: Oracle to POstgresql db link not working.....
                  user13573211

                  [oracle@devdb00 lib]$ cat dg4odbc.log

                  21744 futex(0x1036484, FUTEX_WAIT_PRIVATE, 1, NULL <unfinished ...>

                  21743 restart_syscall(<... resuming interrupted call ...> <unfinished ...>

                  19849 restart_syscall(<... resuming interrupted call ...> <unfinished ...>

                  21743 <... restart_syscall resumed> ) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0}, 0x7fa04d916e00) = 0

                  21743 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 13

                  21743 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  21743 setsockopt(13, SOL_SOCKET, SO_LINGER, {onoff=1, linger=900}, 8) = 0

                  21743 connect(13, {sa_family=AF_INET, sin_port=htons(6100), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)

                  21743 shutdown(13, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected)

                  21743 close(13) = 0

                  21743 rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0

                  21743 rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0

                  21743 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0

                  21743 nanosleep({5, 0},  <unfinished ...>

                  19849 <... restart_syscall resumed> ) = 1

                  19849 times({tms_utime=36, tms_stime=254, tms_cutime=0, tms_cstime=0}) = 683658010

                  19849 getsockname(8, {sa_family=AF_INET6, sin6_port=htons(1525), inet_pton(AF_INET6, "::", &sin6_addr), sin6_flowinfo=0, sin6_scope_id=0}, [28]) = 0

                  19849 getpeername(8, 0x7fff8e687fb8, [28]) = -1 ENOTCONN (Transport endpoint is not connected)

                  19849 accept(8, {sa_family=AF_INET6, sin6_port=htons(44083), inet_pton(AF_INET6, "::ffff:127.0.0.1", &sin6_addr), sin6_flowinfo=0, sin6_scope_id=0}, [28]) = 13

                  19849 getsockname(13, {sa_family=AF_INET6, sin6_port=htons(1525), inet_pton(AF_INET6, "::ffff:127.0.0.1", &sin6_addr), sin6_flowinfo=0, sin6_scope_id=0}, [28]) = 0

                  19849 fcntl(13, F_SETFL, O_RDONLY|O_NONBLOCK) = 0

                  19849 getsockopt(13, SOL_SOCKET, SO_SNDBUF, [-8185148080564155596], [4]) = 0

                  19849 getsockopt(13, SOL_SOCKET, SO_RCVBUF, [-8185148080564076352], [4]) = 0

                  19849 setsockopt(13, SOL_TCP, TCP_NODELAY, [1], 4) = 0

                  19849 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  19849 times({tms_utime=36, tms_stime=254, tms_cutime=0, tms_cstime=0}) = 683658010

                  19849 rt_sigaction(SIGPIPE, {SIG_IGN, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x3c2d60f500}, {SIG_IGN, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x3c2d60f500}, 8) = 0

                  19849 times({tms_utime=36, tms_stime=254, tms_cutime=0, tms_cstime=0}) = 683658010

                  19849 times({tms_utime=36, tms_stime=254, tms_cutime=0, tms_cstime=0}) = 683658010

                  19849 poll([{fd=8, events=POLLIN|POLLRDNORM}, {fd=11, events=POLLIN|POLLRDNORM}, {fd=12, events=POLLIN|POLLRDNORM}, {fd=13, events=POLLIN|POLLRDNORM}], 4, 60000) = 1 ([{fd=13, revents=POLLIN|POLLRDNORM}])

                  19849 read(13, "\0\317\0\0\1\0\0\0\1:\1,\f\1 \0\377\377\177\10\0\0\1\0\0\225\0:\0\0\0\0"..., 8208) = 207

                  19849 fcntl(13, F_GETFL) = 0x802 (flags O_RDWR|O_NONBLOCK)

                  19849 fcntl(13, F_SETFL, O_RDWR) = 0

                  19849 times({tms_utime=36, tms_stime=254, tms_cutime=0, tms_cstime=0}) = 683658010

                  19849 socket(PF_NETLINK, SOCK_RAW, 0) = 14

                  19849 bind(14, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 0

                  19849 getsockname(14, {sa_family=AF_NETLINK, pid=19849, groups=00000000}, [12]) = 0

                  19849 sendto(14, "\24\0\0\0\26\0\1\3/|VR\0\0\0\0\0\0\0\0", 20, 0, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 20

                  19849 recvmsg(14, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"0\0\0\0\24\0\2\0/|VR\211M\0\0\2\10\200\376\1\0\0\0\10\0\1\0\177\0\0\1"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 108

                  19849 recvmsg(14, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"@\0\0\0\24\0\2\0/|VR\211M\0\0\n\200\200\376\1\0\0\0\24\0\1\0\0\0\0\0"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 128

                  19849 recvmsg(14, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"\24\0\0\0\3\0\2\0/|VR\211M\0\0\0\0\0\0\1\0\0\0\24\0\1\0\0\0\0\0"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 20

                  19849 close(14) = 0

                  19849 fcntl(13, F_SETFD, 0) = 0

                  19849 pipe([14, 15]) = 0

                  19849 pipe([16, 17]) = 0

                  19849 clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0x7fa04ebc19d0) = 8631

                  8631  set_robust_list(0x7fa04ebc19e0, 0x18 <unfinished ...>

                  19849 wait4(8631,  <unfinished ...>

                  8631  <... set_robust_list resumed> ) = 0

                  8631  clone( <unfinished ...>

                  8632  set_robust_list(0x7fa04ebc19e0, 0x18 <unfinished ...>

                  8631  <... clone resumed> child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0x7fa04ebc19d0) = 8632

                  8632  <... set_robust_list resumed> ) = 0

                  8632  close(15) = 0

                  8632  close(16 <unfinished ...>

                  8631  exit_group(0) = ?

                  8632  <... close resumed> ) = 0

                  8632  setsid() = 8632

                  8632  geteuid() = 500

                  8632  setsid( <unfinished ...>

                  19849 <... wait4 resumed> [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0, NULL) = 8631

                  8632  <... setsid resumed> ) = -1 EPERM (Operation not permitted)

                  19849 --- SIGCHLD (Child exited) @ 0 (0) ---

                  19849 close(14 <unfinished ...>

                  8632  execve("/oracle/product/11.2.0/grid/bin/dg4odbc", ["/oracle/product/11.2.0/grid/bin/"..., "(LOCAL=NO)"], [/* 36 vars */] <unfinished ...>

                  19849 <... close resumed> ) = 0

                  19849 close(17) = 0

                  19849 fcntl(16, F_SETFD, FD_CLOEXEC) = 0

                  19849 fcntl(15, F_SETFD, FD_CLOEXEC) = 0

                  19849 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  19849 poll([{fd=8, events=POLLIN|POLLRDNORM}, {fd=11, events=POLLIN|POLLRDNORM}, {fd=12, events=POLLIN|POLLRDNORM}, {fd=16, events=POLLIN|POLLRDNORM}, {fd=15, events=0}], 5, -1 <unfinished ...>

                  8632  <... execve resumed> ) = -1 ENOEXEC (Exec format error)

                  8632  execve("/bin/sh", ["/bin/sh", "/oracle/product/11.2.0/grid/bin/"..., "(LOCAL=NO)"], [/* 36 vars */]) = 0

                  8632  brk(0) = 0x9d7000

                  8632  mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f545ec2a000

                  8632  access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)

                  8632  open("/oracle/database/11.2.0.3/lib/tls/x86_64/libtinfo.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  stat("/oracle/database/11.2.0.3/lib/tls/x86_64", 0x7fffc12c3cc0) = -1 ENOENT (No such file or directory)

                  8632  open("/oracle/database/11.2.0.3/lib/tls/libtinfo.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  stat("/oracle/database/11.2.0.3/lib/tls", 0x7fffc12c3cc0) = -1 ENOENT (No such file or directory)

                  8632  open("/oracle/database/11.2.0.3/lib/x86_64/libtinfo.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  stat("/oracle/database/11.2.0.3/lib/x86_64", 0x7fffc12c3cc0) = -1 ENOENT (No such file or directory)

                  8632  open("/oracle/database/11.2.0.3/lib/libtinfo.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  stat("/oracle/database/11.2.0.3/lib", 0x7fffc12c3cc0) = -1 ENOENT (No such file or directory)

                  8632  open("/home/oracle/temp/psqlodbc-09.02.0100/.libs/tls/x86_64/libtinfo.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  stat("/home/oracle/temp/psqlodbc-09.02.0100/.libs/tls/x86_64", 0x7fffc12c3cc0) = -1 ENOENT (No such file or directory)

                  8632  open("/home/oracle/temp/psqlodbc-09.02.0100/.libs/tls/libtinfo.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  stat("/home/oracle/temp/psqlodbc-09.02.0100/.libs/tls", 0x7fffc12c3cc0) = -1 ENOENT (No such file or directory)

                  8632  open("/home/oracle/temp/psqlodbc-09.02.0100/.libs/x86_64/libtinfo.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  stat("/home/oracle/temp/psqlodbc-09.02.0100/.libs/x86_64", 0x7fffc12c3cc0) = -1 ENOENT (No such file or directory)

                  8632  open("/home/oracle/temp/psqlodbc-09.02.0100/.libs/libtinfo.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  stat("/home/oracle/temp/psqlodbc-09.02.0100/.libs", 0x7fffc12c3cc0) = -1 ENOENT (No such file or directory)

                  8632  open("/usr/lib64/tls/x86_64/libtinfo.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  stat("/usr/lib64/tls/x86_64", 0x7fffc12c3cc0) = -1 ENOENT (No such file or directory)

                  8632  open("/usr/lib64/tls/libtinfo.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  stat("/usr/lib64/tls", {st_mode=S_IFDIR|0555, st_size=4096, ...}) = 0

                  8632  open("/usr/lib64/x86_64/libtinfo.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  stat("/usr/lib64/x86_64", 0x7fffc12c3cc0) = -1 ENOENT (No such file or directory)

                  8632  open("/usr/lib64/libtinfo.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  stat("/usr/lib64", {st_mode=S_IFDIR|0555, st_size=69632, ...}) = 0

                  8632  open("/etc/ld.so.cache", O_RDONLY) = 3

                  8632  fstat(3, {st_mode=S_IFREG|0644, st_size=84738, ...}) = 0

                  8632  mmap(NULL, 84738, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f545ec15000

                  8632  close(3) = 0

                  8632  open("/lib64/libtinfo.so.5", O_RDONLY) = 3

                  8632  read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0@\310\240=<\0\0\0"..., 832) = 832

                  8632  fstat(3, {st_mode=S_IFREG|0755, st_size=138280, ...}) = 0

                  8632  mmap(0x3c3da00000, 2232320, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3c3da00000

                  8632  mprotect(0x3c3da1d000, 2097152, PROT_NONE) = 0

                  8632  mmap(0x3c3dc1d000, 16384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1d000) = 0x3c3dc1d000

                  8632  close(3) = 0

                  8632  open("/usr/lib64/tls/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  open("/usr/lib64/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  open("/lib64/libdl.so.2", O_RDONLY) = 3

                  8632  read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340\r -<\0\0\0"..., 832) = 832

                  8632  fstat(3, {st_mode=S_IFREG|0755, st_size=22536, ...}) = 0

                  8632  mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f545ec14000

                  8632  mmap(0x3c2d200000, 2109696, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3c2d200000

                  8632  mprotect(0x3c2d202000, 2097152, PROT_NONE) = 0

                  8632  mmap(0x3c2d402000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x3c2d402000

                  8632  close(3) = 0

                  8632  open("/usr/lib64/tls/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  open("/usr/lib64/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)

                  8632  open("/lib64/libc.so.6", O_RDONLY) = 3

                  8632  read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360\355\341,<\0\0\0"..., 832) = 832

                  8632  fstat(3, {st_mode=S_IFREG|0755, st_size=1922152, ...}) = 0

                  8632  mmap(0x3c2ce00000, 3745960, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3c2ce00000

                  8632  mprotect(0x3c2cf8a000, 2093056, PROT_NONE) = 0

                  8632  mmap(0x3c2d189000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x189000) = 0x3c2d189000

                  8632  mmap(0x3c2d18e000, 18600, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3c2d18e000

                  8632  close(3) = 0

                  8632  mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f545ec13000

                  8632  mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f545ec12000

                  8632  mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f545ec11000

                  8632  arch_prctl(ARCH_SET_FS, 0x7f545ec12700) = 0

                  8632  mprotect(0x3c2d402000, 4096, PROT_READ) = 0

                  8632  mprotect(0x3c2d189000, 16384, PROT_READ) = 0

                  8632  mprotect(0x3c2cc1f000, 4096, PROT_READ) = 0

                  8632  munmap(0x7f545ec15000, 84738) = 0

                  8632  rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0

                  8632  open("/dev/tty", O_RDWR|O_NONBLOCK) = -1 ENXIO (No such device or address)

                  8632  ioctl(0, SNDCTL_TMR_TIMEBASE or TCGETS, 0x7fffc12c4300) = -1 ENOTTY (Inappropriate ioctl for device)

                  8632  brk(0) = 0x9d7000

                  8632  brk(0x9f8000) = 0x9f8000

                  8632  open("/usr/lib/locale/locale-archive", O_RDONLY) = 3

                  8632  fstat(3, {st_mode=S_IFREG|0644, st_size=99158576, ...}) = 0

                  8632  mmap(NULL, 99158576, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f5458d80000

                  8632  close(3) = 0

                  8632  getuid() = 500

                  8632  getgid() = 500

                  8632  geteuid() = 500

                  8632  getegid() = 500

                  8632  rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0

                  8632  open("/proc/meminfo", O_RDONLY) = 3

                  8632  fstat(3, {st_mode=S_IFREG|0444, st_size=0, ...}) = 0

                  8632  mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f545ec29000

                  8632  read(3, "MemTotal:       16467476 kB\nMemF"..., 1024) = 1024

                  8632  close(3) = 0

                  8632  munmap(0x7f545ec29000, 4096) = 0

                  8632  rt_sigaction(SIGCHLD, {SIG_DFL, [], SA_RESTORER, 0x3c2ce32920}, {SIG_DFL, [], 0}, 8) = 0

                  8632  rt_sigaction(SIGCHLD, {SIG_DFL, [], SA_RESTORER, 0x3c2ce32920}, {SIG_DFL, [], SA_RESTORER, 0x3c2ce32920}, 8) = 0

                  8632  rt_sigaction(SIGINT, {SIG_DFL, [], SA_RESTORER, 0x3c2ce32920}, {SIG_DFL, [], 0}, 8) = 0

                  8632  rt_sigaction(SIGINT, {SIG_DFL, [], SA_RESTORER, 0x3c2ce32920}, {SIG_DFL, [], SA_RESTORER, 0x3c2ce32920}, 8) = 0

                  8632  rt_sigaction(SIGQUIT, {SIG_DFL, [], SA_RESTORER, 0x3c2ce32920}, {SIG_DFL, [], 0}, 8) = 0

                  8632  rt_sigaction(SIGQUIT, {SIG_DFL, [], SA_RESTORER, 0x3c2ce32920}, {SIG_DFL, [], SA_RESTORER, 0x3c2ce32920}, 8) = 0

                  8632  rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0

                  8632  rt_sigaction(SIGQUIT, {SIG_IGN, [], SA_RESTORER, 0x3c2ce32920}, {SIG_DFL, [], SA_RESTORER, 0x3c2ce32920}, 8) = 0

                  8632  uname({sys="Linux", node="devdb00.office.corp", ...}) = 0

                  8632  stat("/oracle/product/11.2.0/dbhome/network/admin", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0

                  8632  stat(".", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0

                  8632  getpid() = 8632

                  8632  open("/usr/lib64/gconv/gconv-modules.cache", O_RDONLY) = 3

                  8632  fstat(3, {st_mode=S_IFREG|0644, st_size=26060, ...}) = 0

                  8632  mmap(NULL, 26060, PROT_READ, MAP_SHARED, 3, 0) = 0x7f545ec23000

                  8632  close(3) = 0

                  8632  getppid() = 1

                  8632  getpgrp() = 8632

                  8632  rt_sigaction(SIGCHLD, {0x43f2b0, [], SA_RESTORER, 0x3c2ce32920}, {SIG_DFL, [], SA_RESTORER, 0x3c2ce32920}, 8) = 0

                  8632  getrlimit(RLIMIT_NPROC, {rlim_cur=16*1024, rlim_max=16*1024}) = 0

                  8632  rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0

                  8632  open("/oracle/product/11.2.0/grid/bin/dg4odbc", O_RDONLY) = 3

                  8632  ioctl(3, SNDCTL_TMR_TIMEBASE or TCGETS, 0x7fffc12c4360) = -1 ENOTTY (Inappropriate ioctl for device)

                  8632  lseek(3, 0, SEEK_CUR) = 0

                  8632  read(3, "", 80) = 0

                  8632  lseek(3, 0, SEEK_SET) = 0

                  8632  getrlimit(RLIMIT_NOFILE, {rlim_cur=64*1024, rlim_max=64*1024}) = 0

                  8632  fcntl(255, F_GETFD) = -1 EBADF (Bad file descriptor)

                  8632  dup2(3, 255) = 255

                  8632  close(3) = 0

                  8632  fcntl(255, F_SETFD, FD_CLOEXEC) = 0

                  8632  fcntl(255, F_GETFL) = 0x8000 (flags O_RDONLY|O_LARGEFILE)

                  8632  fstat(255, {st_mode=S_IFREG|0751, st_size=0, ...}) = 0

                  8632  lseek(255, 0, SEEK_CUR) = 0

                  8632  rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0

                  8632  read(255, "", 1) = 0

                  8632  exit_group(0) = ?

                  19849 <... poll resumed> ) = 2 ([{fd=16, revents=POLLHUP}, {fd=15, revents=POLLERR}])

                  19849 read(16, "", 64) = 0

                  19849 close(16) = 0

                  19849 close(15) = 0

                  19849 close(13) = 0

                  19849 lseek(7, 19968, SEEK_SET) = 19968

                  19849 read(7, "\f\0005\4\0\0P\0006\4\0\0j\0007\4\0\0\206\0008\4\0\0\240\0009\4\0\0\335\0"..., 512) = 512

                  19849 lstat("/oracle/diag/tnslsnr/devdb00/listener_postgres/alert/log.xml", {st_mode=S_IFREG|0640, st_size=58004, ...}) = 0

                  19849 stat("/oracle/diag/tnslsnr/devdb00/listener_postgres/alert/log.xml", {st_mode=S_IFREG|0640, st_size=58004, ...}) = 0

                  19849 lstat("/oracle/diag/tnslsnr/devdb00/listener_postgres/alert/log.xml", {st_mode=S_IFREG|0640, st_size=58004, ...}) = 0

                  19849 open("/oracle/diag/tnslsnr/devdb00/listener_postgres/alert/log.xml", O_WRONLY|O_CREAT|O_APPEND, 0660) = 13

                  19849 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  19849 write(13, "<msg time='2013-10-10T03:06:39.7"..., 376) = 376

                  19849 close(13) = 0

                  19849 stat("/oracle/diag/tnslsnr/devdb00/listener_postgres/alert/log.xml", {st_mode=S_IFREG|0640, st_size=58380, ...}) = 0

                  19849 times({tms_utime=36, tms_stime=254, tms_cutime=0, tms_cstime=0}) = 683658011

                  19849 lstat("/oracle/diag/tnslsnr/devdb00/listener_postgres/trace/listener_postgres.log", {st_mode=S_IFREG|0640, st_size=23708, ...}) = 0

                  19849 open("/oracle/diag/tnslsnr/devdb00/listener_postgres/trace/listener_postgres.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = 13

                  19849 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  19849 write(13, "Thu Oct 10 03:06:39 2013\n", 25) = 25

                  19849 times({tms_utime=36, tms_stime=254, tms_cutime=0, tms_cstime=0}) = 683658012

                  19849 write(13, "10-OCT-2013 03:06:39 * (CONNECT_"..., 198) = 198

                  19849 close(13) = 0

                  19849 lseek(7, 38912, SEEK_SET) = 38912

                  19849 read(7, "\7\0\3440\0\0002\0\3460\0\0|\0\3470\0\0\255\0\3500\0\0\325\0\3510\0\0\37\1"..., 512) = 512

                  19849 lseek(7, 40448, SEEK_SET) = 40448

                  19849 read(7, "\20\0\0021\0\0h\0\0031\0\0}\0\0041\0\0\215\0\0051\0\0\251\0\0061\0\0\325\0"..., 512) = 512

                  19849 lseek(7, 40448, SEEK_SET) = 40448

                  19849 read(7, "\20\0\0021\0\0h\0\0031\0\0}\0\0041\0\0\215\0\0051\0\0\251\0\0061\0\0\325\0"..., 512) = 512

                  19849 lseek(7, 14848, SEEK_SET) = 14848

                  19849 read(7, "\16\0\1\2\0\0\\\0\2\2\0\0x\0\3\2\0\0\243\0\4\2\0\0\336\0\5\2\0\0\357\0"..., 512) = 512

                  19849 lstat("/oracle/diag/tnslsnr/devdb00/listener_postgres/alert/log.xml", {st_mode=S_IFREG|0640, st_size=58380, ...}) = 0

                  19849 stat("/oracle/diag/tnslsnr/devdb00/listener_postgres/alert/log.xml", {st_mode=S_IFREG|0640, st_size=58380, ...}) = 0

                  19849 lstat("/oracle/diag/tnslsnr/devdb00/listener_postgres/alert/log.xml", {st_mode=S_IFREG|0640, st_size=58380, ...}) = 0

                  19849 open("/oracle/diag/tnslsnr/devdb00/listener_postgres/alert/log.xml", O_WRONLY|O_CREAT|O_APPEND, 0660) = 13

                  19849 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  19849 write(13, "<msg time='2013-10-10T03:06:39.7"..., 368) = 368

                  19849 close(13) = 0

                  19849 stat("/oracle/diag/tnslsnr/devdb00/listener_postgres/alert/log.xml", {st_mode=S_IFREG|0640, st_size=58748, ...}) = 0

                  19849 times({tms_utime=36, tms_stime=254, tms_cutime=0, tms_cstime=0}) = 683658012

                  19849 lstat("/oracle/diag/tnslsnr/devdb00/listener_postgres/trace/listener_postgres.log", {st_mode=S_IFREG|0640, st_size=23931, ...}) = 0

                  19849 open("/oracle/diag/tnslsnr/devdb00/listener_postgres/trace/listener_postgres.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = 13

                  19849 fcntl(13, F_SETFD, FD_CLOEXEC) = 0

                  19849 write(13, "TNS-12518: TNS:listener could no"..., 190) = 190

                  19849 close(13) = 0

                  19849 poll([{fd=8, events=POLLIN|POLLRDNORM}, {fd=11, events=POLLIN|POLLRDNORM}, {fd=12, events=POLLIN|POLLRDNORM}], 3, -1 <unfinished ...>

                  21743 --- SIGTRAP (Trace/breakpoint trap) @ 0 (0) ---

                  21744 +++ killed by SIGTRAP (core dumped) +++

                  19849 +++ killed by SIGTRAP (core dumped) +++

                  • 36. Re: Oracle to POstgresql db link not working.....
                    user13573211

                    Hello Sir: Please find the attached STRACE file.

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

                      you see in the dg4odbc.log file that it tries to pick up the executable dg4odbc from the wrong location:

                      execve("/oracle/product/11.2.0/grid/bin/dg4odbc", ["/oracle/product/11.2.0/grid/bin/"..., "(LOCAL=NO)"], [/* 36 vars */] <unfinished ...>

                      Are you sure you restarted the listener all the time you changed the listener.ora parameters?

                      What's the output of ps -eauwww >PID of the Gateway listener>?

                      • 38. Re: Oracle to POstgresql db link not working.....
                        user13573211

                        I can not say, that I have stopped and started every time or not, but I did that many times(for sure the last time)...just now I did stop and start...and listner stopped working...it was working few minutes before well...

                         

                        [oracle@devdb00 admin]$ lsnrctl status LISTENER_POSTGRES

                         

                         

                        LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 10-OCT-2013 03:25:48

                         

                         

                        Copyright (c) 1991, 2011, Oracle.  All rights reserved.

                         

                         

                        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=devdb00.office.corp)(PORT=1525)))

                        TNS-12541: TNS:no listener

                        TNS-12560: TNS:protocol adapter error

                          TNS-00511: No listener

                           Linux Error: 111: Connection refused

                        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY)))

                        TNS-12541: TNS:no listener

                        TNS-12560: TNS:protocol adapter error

                          TNS-00511: No listener

                           Linux Error: 111: Connection refused

                        • 39. Re: Oracle to POstgresql db link not working.....
                          user13573211

                          [oracle@devdb00 lib]$ ps -ef|grep tns

                          root        39     2  0 Sep10 ?        00:00:00 [netns]

                          oracle    8496     1  0 02:59 ?        00:00:00 /oracle/product/11.2.0/dbhome/bin/tnslsnr LISTENER -inherit

                          oracle    8558  7567  0 03:02 pts/2    00:00:00 grep tns

                          oracle   19849     1  0 Oct08 ?        00:00:02 /oracle/product/11.2.0/dbhome/bin/tnslsnr LISTENER_POSTGRES -inherit

                          • 40. Re: Oracle to POstgresql db link not working.....
                            user13573211

                            could you please let me know, what do you exactly mean, when you say the below line:

                             

                            "What's the output of ps -eauwww >PID of the Gateway listener>?"

                            • 41. Re: Oracle to POstgresql db link not working.....
                              Kgronau-Oracle

                              Just post the output of: ps -eauwww 19849

                              • 42. Re: Oracle to POstgresql db link not working.....
                                user13573211

                                [oracle@devdb00 admin]$ ps -eauwww 19849

                                Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.8/FAQ

                                USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND

                                root      3122  0.0  0.0   4108     8 tty2     Ss+  Sep10   0:00 /sbin/mingetty /dev/tty2

                                root      3124  0.0  0.0   4108     8 tty3     Ss+  Sep10   0:00 /sbin/mingetty /dev/tty3

                                root      3126  0.0  0.0   4108     8 tty4     Ss+  Sep10   0:00 /sbin/mingetty /dev/tty4

                                root      3128  0.0  0.0   4108     8 tty5     Ss+  Sep10   0:00 /sbin/mingetty /dev/tty5

                                root      3130  0.0  0.0   4108     8 tty6     Ss+  Sep10   0:00 /sbin/mingetty /dev/tty6

                                root      7078  0.0  0.1 106092 16872 tty7     Ss+  Oct07   0:02 /usr/bin/Xorg -br -verbose -audit 4 -auth /var/run/gdm/auth-for-gdm-j2Zt76/database -nolisten tcp

                                oracle    7567  0.0  0.0 108516  1908 pts/2    Ss+  01:23   0:00 -bash USER=oracle LOGNAME=oracle HOME=/home/oracle PATH=/usr/local/bin:/bin:/usr/bin MAIL=/var/mail/oracle SHELL=/bin/bash SSH_CLIENT=172.17.200.80 53293 22 SSH_CONNECTION=172.17.200.80 53293 172.17.1.82 22 SSH_TTY=/dev/pts/2 TERM=vt100

                                oracle    8604  0.0  0.0 108516  1892 pts/0    Ss   03:06   0:00 -bash USER=oracle LOGNAME=oracle HOME=/home/oracle PATH=/usr/local/bin:/bin:/usr/bin MAIL=/var/mail/oracle SHELL=/bin/bash SSH_CLIENT=172.17.200.80 54598 22 SSH_CONNECTION=172.17.200.80 54598 172.17.1.82 22 SSH_TTY=/dev/pts/0 TERM=vt100

                                oracle    8722  0.0  0.0 100980   488 pts/2    T    03:15   0:00 cat HOSTNAME=devdb00.office.corp TERM=vt100 SHELL=/bin/bash HISTSIZE=1000 ORACLE_UNQNAME=mwdev001 SSH_CLIENT=172.17.200.80 53293 22 QTDIR=/usr/lib64/qt-3.3 QTINC=/usr/lib64/qt-3.3/include SSH_TTY=/dev/pts/2 USER=oracle LD_LIBRARY_PATH=/oracle/product/11.2.0/grid/lib:/usr/lib64:LD_LIBRARY_PATH=//oracle/product/11.2.0/dbhome/lib LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36: ORACLE_SID=mwdev001 ORACLE_BASE=/oracle TNS_ADMIN=/oracle/product/11.2.0/grid/network/admin MAIL=/var/spool/mail/oracle PATH=/oracle/product/11.2.0/dbhome/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/home/oracle/bin PWD=/oracle/product/11.2.0/grid/hs/admin LANG=en_US.UTF-8 SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass HISTCONTROL=ignoredups SHLVL=1 HOME=/home/oracle ODBCINI=/home/oracle/temp/psqlodbc-09.02.0100/test/odbc.ini LOGNAME=oracle QTLIB=/usr/lib64/qt-3.3/lib CVS_RSH=ssh SSH_CONNECTION=172.17.200.80 53293 172.17.1.82 22 LESSOPEN=|/usr/bin/lesspipe.sh %s ORA_NLS33=/oracle/product/11.2.0/dbhome/ocommon/nls/admin/data ORACLE_HOME=/oracle/product/11.2.0/dbhome ODBCINSTINI=/home/oracle/temp/psqlodbc-09.02.0100/test/odbcinst.ini G_BROKEN_FILENAMES=1 _=/bin/cat OLDPWD=/oracle/product/11.2.0/grid/hs

                                oracle    9212  0.0  0.0 110240  1156 pts/0    R+   03:40   0:00 ps -eauwww 19849 HOSTNAME=devdb00.office.corp TERM=vt100 SHELL=/bin/bash HISTSIZE=1000 ORACLE_UNQNAME=mwdev001 SSH_CLIENT=172.17.200.80 54598 22 QTDIR=/usr/lib64/qt-3.3 QTINC=/usr/lib64/qt-3.3/include SSH_TTY=/dev/pts/0 USER=oracle LD_LIBRARY_PATH=/oracle/product/11.2.0/grid/lib:/usr/lib64:LD_LIBRARY_PATH=//oracle/product/11.2.0/dbhome/lib LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36: ORACLE_SID=mwdev001 ORACLE_BASE=/oracle TNS_ADMIN=/oracle/product/11.2.0/grid/network/admin MAIL=/var/spool/mail/oracle PATH=/oracle/product/11.2.0/dbhome/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/home/oracle/bin PWD=/oracle/product/11.2.0/grid/network/admin LANG=en_US.UTF-8 SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass HISTCONTROL=ignoredups SHLVL=1 HOME=/home/oracle ODBCINI=/home/oracle/temp/psqlodbc-09.02.0100/test/odbc.ini LOGNAME=oracle QTLIB=/usr/lib64/qt-3.3/lib CVS_RSH=ssh SSH_CONNECTION=172.17.200.80 54598 172.17.1.82 22 LESSOPEN=|/usr/bin/lesspipe.sh %s ORA_NLS33=/oracle/product/11.2.0/dbhome/ocommon/nls/admin/data ORACLE_HOME=/oracle/product/11.2.0/dbhome ODBCINSTINI=/home/oracle/temp/psqlodbc-09.02.0100/test/odbcinst.ini G_BROKEN_FILENAMES=1 _=/bin/ps OLDPWD=/oracle/product/11.2.0/grid/network

                                [oracle@devdb00 admin]$

                                • 43. Re: Oracle to POstgresql db link not working.....
                                  Kgronau-Oracle

                                  Don't know why the setting shows 2 times a LD_LIBRARY_PATH:

                                  LD_LIBRARY_PATH=/oracle/product/11.2.0/grid/lib:/usr/lib64:LD_LIBRARY_PATH=//oracle/product/11.2.0/dbhome/lib

                                   

                                  Message was edited by: kgronau as the latest posted listener looks fine - maybe just a missing stop/start of the gateway listener ....

                                   

                                  Message was edited by: kgronau Maybe that's interesting: oracle   19849     1  0 Oct08 ?        00:00:02 /oracle/product/11.2.0/dbhome/bin/tnslsnr LISTENER_POSTGRES -inherit Again the listener was started from the DATABASE home, not from the GRID!

                                  • 44. Re: Oracle to POstgresql db link not working.....
                                    user13573211

                                    that is becuase of the ENV file...

                                     

                                    what is that that I should remove....

                                     

                                    [oracle@devdb00 ~]$ env

                                    HOSTNAME=devdb00.office.corp

                                    TERM=vt100

                                    SHELL=/bin/bash

                                    HISTSIZE=1000

                                    ORACLE_UNQNAME=mwdev001

                                    SSH_CLIENT=172.17.200.80 49497 22

                                    QTDIR=/usr/lib64/qt-3.3

                                    QTINC=/usr/lib64/qt-3.3/include

                                    SSH_TTY=/dev/pts/0

                                    USER=oracle

                                    LD_LIBRARY_PATH=/oracle/product/11.2.0/grid/lib:/usr/lib64:LD_LIBRARY_PATH=//oracle/product/11.2.0/dbhome/lib

                                    LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:

                                    ORACLE_SID=mwdev001

                                    ORACLE_BASE=/oracle

                                    TNS_ADMIN=/oracle/product/11.2.0/grid/network/admin

                                    MAIL=/var/spool/mail/oracle

                                    PATH=/oracle/product/11.2.0/dbhome/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/home/oracle/bin

                                    PWD=/home/oracle

                                    LANG=en_US.UTF-8

                                    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

                                    HISTCONTROL=ignoredups

                                    SHLVL=1

                                    HOME=/home/oracle

                                    ODBCINI=/home/oracle/temp/psqlodbc-09.02.0100/test/odbc.ini

                                    LOGNAME=oracle

                                    QTLIB=/usr/lib64/qt-3.3/lib

                                    CVS_RSH=ssh

                                    SSH_CONNECTION=172.17.200.80 49497 172.17.1.82 22

                                    LESSOPEN=|/usr/bin/lesspipe.sh %s

                                    ORA_NLS33=/oracle/product/11.2.0/dbhome/ocommon/nls/admin/data

                                    ORACLE_HOME=/oracle/product/11.2.0/dbhome

                                    ODBCINSTINI=/home/oracle/temp/psqlodbc-09.02.0100/test/odbcinst.ini

                                    G_BROKEN_FILENAMES=1

                                    _=/bin/env

                                    1 2 3 4 5 Previous Next