3 Replies Latest reply: May 13, 2013 2:24 PM by user12002352 RSS

    ORA-28547: connection to server failed, probable Oracle Net admin error

    user12002352
      Hi Gurus

      I can't get the gateway to work? I'm running on AIX. Any suggestions are appreciated.

      listener.ora
      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
      # (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
      )
      )

      SID_LIST_LISTENER=
      (SID_LIST=
      (SID_DESC=
      (SID_NAME=dg4msql)
      (ORACLE_HOME=/oracle/rcsr/base/product/11.2.0/gateway)
      (PROGRAM=dg4msql)
      )
      )

      tnsnames.ora
      dg4msql =
      (DESCRIPTION=
      (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522))
      (CONNECT_DATA=(SID=dg4msql))
      (HS=OK)
      )

      sqlnet.ora
      SQL_AUTHENTICATION_SERVICES = (NONE)
      NAMES.DIRECTORY_PATH= (TNSNAMES)

      ADR_BASE = /oracle/rcsr/base

      initdg4msql.ora
      HS_FDS_CONNECT_INFO=142.178.205.42:1433//komodo
      # alternate connect format is hostname/serverinstance/databasename
      HS_FDS_TRACE_LEVEL=debug
      HS_FDS_RECOVERY_ACCOUNT=RECOVER
      HS_FDS_RECOVERY_PWD=RECOVER

      $ lsnrctl status

      LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 03-MAY-2013 13:48:01

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

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1522)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
      Start Date 03-MAY-2013 13:38:14
      Uptime 0 days 0 hr. 9 min. 47 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP ON
      Listener Parameter File /oracle/rcsr/base/product/11.2.0/gateway/network/admin/listener.ora
      Listener Log File /oracle/rcsr/base/diag/tnslsnr/abe-rcsr-01/listener/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))
      Services Summary...
      Service "dg4msql" has 1 instance(s).
      Instance "dg4msql", status UNKNOWN, has 1 handler(s) for this service...
      The command completed successfully
      $ tnsping dg4msql

      TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 03-MAY-2013 13:48:53

      Copyright (c) 1997, 2009, Oracle. All rights reserved.

      Used parameter files:
      /oracle/rcsr/base/product/11.2.0/gateway/network/admin/sqlnet.ora


      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)) (CONNECT_DATA=(SID=dg4msql)) (HS=OK))
      OK (0 msec)

      $ sqlplus aa/aa@dg4msql

      SQL*Plus: Release 11.2.0.1.0 Production on Fri May 3 13:49:52 2013

      Copyright (c) 1982, 2009, Oracle. All rights reserved.

      ERROR:
      ORA-28547: connection to server failed, probable Oracle Net admin error