数据库报错dispatcher ‘D000’ encountered error getting listening address

   

现象:

[root@Oracle ~]# cat /u01/app/oracle/diag/rdbms/test/test/trace/alert_test.log |grep err
dispatcher 'D000' encountered error getting listening address
dispatcher 'D000' encountered error getting listening address
dispatcher 'D000' encountered error getting listening address
dispatcher 'D000' encountered error getting listening address
dispatcher 'D000' encountered error getting listening address
dispatcher 'D000' encountered error getting listening address
dispatcher 'D000' encountered error getting listening address
dispatcher 'D000' encountered error getting listening address
dispatcher 'D000' encountered error getting listening address

原因:

[root@Oracle ~]# hostname
Oracle
[root@Oracle ~]# ping Oracle
ping: unknown host Oracle

解决:

[root@Oracle ~]# vi /etc/hosts
[root@Oracle ~]# ping Oracle
PING localhost (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.024 ms
64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.016 ms
^C
--- localhost ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1519ms
rtt min/avg/max/mdev = 0.016/0.020/0.024/0.004 ms

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  776646656 bytes
Fixed Size                  2217384 bytes
Variable Size             608176728 bytes
Database Buffers          159383552 bytes
Redo Buffers                6868992 bytes
Database mounted.

发表评论