This discussion is archived
3 Replies Latest reply: May 13, 2013 12:24 PM by user12002352 RSS

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

user12002352 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points