Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PostgreSQL TNS-12547

Killy GonzalesSep 29 2012 — edited Jan 17 2017
Hi,
I've problem with connecting from 11g to PostgreSQL database.
First I configure initpostgresql.ora
 HS_FDS_CONNECT_INFO = postgresql
 HS_FDS_TRACE_LEVEL = 4
 HS_FDS_TRACE_FILE_NAME = /u01/app/oracle/product/11.1.0/db_1/hs/log/hsodbc.trc
 #HS_FDS_TRACE_FILE_NAME = /tmp/oracle_trace_host_143
 HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so

 HS_FDS_SUPPORT_STATISTICS = FALSE
 #
 # ODBC specific environment variables
 #
 set ODBCINI=/etc/odbc.ini
then listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = VBoxCentOS)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME =/u01/app/oracle/product/11.1.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)
      (SID_NAME = orcl)
    )
   (SID_DESC=
      (SID_NAME=postgresql)
      (ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1)
      (PROGRAM=dg4odbc)
      (ENV="LD_LIBRARY_PATH=/usr/lib64:/u01/app/oracle/product/11.1.0/db_1/lib")
    )
  )
and tnsnames.ora
pgsql = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = vboxxp)(PORT = 5432) (CONNECT_DATA = (SID = postgresql))(HS = OK)))
after listener restart when I try tnsping pgsql I got message

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = vboxxp)(PORT = 5432) (CONNECT_DATA = (SID = postgresql))(HS = OK)))
TNS-12547: TNS:lost contact

Can somebody tell me what might be wrong with this configuration?
This post has been answered by Kgronau-Oracle on Oct 1 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2012
Added on Sep 29 2012
2 comments
2,966 views