Oracle listener ("DEDICATED" established: 0 refused: 0)

Recently, when using the listner of the previous server, the following error occurs: "The current link cannot be identified." I found a lot of information, but I was very helpless. Then I calmed down and thought that the client was not strong enough to support Oracle, it indicates a problem with the server dispatcher:

Check the dispatcher parameters:

SQL> show parameter dispachers;

NAME TYPE VALUE
-----------------------------------------------------------------------------
Dispatchers string
Max_dispatchers integer

NO content. Add the Server Configuration:

SQL> alter system set dispatchers = '(ADDRESS = (PROTOCOL = TCP) (HOST = NAME) (PORT = port) scope = spile;

System altered.

You can view our modified Configuration:

SQL> select name, network, paddr, status from v $ dispatcher;

NAME
----
NETWORK
--------------------------------------------------------------------------------
PADDR STATUS
------------------------
D000
(ADDRESS = (PROTOCOL = tcp) (HOST = gyc) (PORT = 37090 ))
2C21A6EC WAIT

Another reason is that the LISTENER is not the local default LISTENER.

SQL> alter system set local_listener = 'local _ listener ';

Check the local listener:

SQL> show parameter local_listener;

NAME TYPE VALUE
-----------------------------------------------------------------------------
Local_listener string (ADDRESS = (PROTOCOL = TCP) (HOST = g
Yc) (PORT = 1522 ))

Static and Dynamic listeners:

[Oracle @ gyc ~] $ Lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0-Production on 04-AUG-2011 22:07:39

Copyright (c) 1991,200 5, Oracle. All rights reserved.

Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = gyc) (PORT = 1521 )))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0-Production
Start Date 04-AUG-2011 20:48:53
Uptime 0 days 1 hr. 18 min. 46 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File/opt/oracle/product/10.2.0/db_1/network/admin/listener. ora
Listener Log File/opt/oracle/product/10.2.0/db_1/network/log/listener. log
Listening Endpoints Summary...
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = gyc) (PORT = 1521 )))
Services Summary...
Service "PLSExtProc" has 1 instance (s ).
Instance "PLSExtProc", status UNKNOWN, has 1 handler (s) for this service...
Service "orcl" has 1 instance (s ).
Instance "orcl", status UNKNOWN, has 1 handler (s) for this service...
The command completed successfully

1 2 Next Page