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!

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

HernawanDec 21 2016 — edited Dec 29 2016

all, need help to solve above problem. I have search n try , but still occured.

we have some remote server, with same configuration.

but for this site, I can not connect with above message error.

I connect from my windows PC, using Orange software.

the server use linux ,

Oracle Database 11g Release 11.2.0.1.0 - 64bit

but if we connect directly to server ( by telnet ), and the doing sqlplus user/password, its work normally.

listener.ora

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = ins211)(PORT = 1521))

    )

  )

ADR_BASE_LISTENER = /oracle

tnsnames.ora

INS211 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = INS211)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = INS211)

    )

  )

Message was edited by: Hernawan

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2017
Added on Dec 21 2016
21 comments
12,667 views