ORA-28547: connection to server failed
Bonjour,
ORA-28547: Lors de la connexion distante:
Code:
1
2
3
4
5
6
7
| [oracle]$ sqlplus sys@STAT as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed May 22 11:03:33 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error
Enter user-name: |
Le listener écoute bien:
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
| oracle@]$ lsnrctl status LISTENER_STAT
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 22-MAY-2013 11:03:08
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1525)))
STATUS of the LISTENER
------------------------
Alias LISTENER_STAT
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 22-MAY-2013 10:12:57
Uptime 0 days 0 hr. 50 min. 10 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /moteurs/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /moteurs/oracle/product/11.2.0/db_1/log/diag/tnslsnr/Server/listener_bkp/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1525)))
Services Summary...
Service "STAT" has 1 instance(s).
Instance "STAT", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully |
TNSPING répond bien:
Code:
1
2
3
4
5
6
7
8
| [oracle@]$ tnsping "STAT"
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 22-MAY-2013 11:03:24
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =server)(PORT = 1525))) (CONNECT_DATA = (SERVICE_NAME = STAT)))
OK (0 msec) |
Le port est ouvert:
Code:
1
2
3
4
| [oracle@]$ telnet server 1525
Trying server...
Connected to server (server).
Escape character is '^]'. |
Merci.
