After the Oracle server is restarted, the following error is encountered when using the Toad client to connect to Oracle:
Oracle Ora-12514:tns:no Listener
Tns:listener does not currently know of SID give in Connect descriptor
Step one: Start TNS monitoring
[[email protected] ~]$ lsnrctl start
Lsnrctl for linux:version 11.2.0.1.0-production on 06-aug-2014 20:07:41
Copyright (c) 1991, Oracle. All rights reserved.
Starting/opt/oracle/11g/bin/tnslsnr:please wait ...
Tnslsnr for Linux:version 11.2.0.1.0-production
System parameter File Is/opt/oracle/11g/network/admin/listener.ora
Log messages Written To/opt/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Listening on: (Description= (Address= (PROTOCOL=IPC) (key=extproc1521)))
Listening on: (Description= (Address= (protocol=tcp) (host=127.0.0.1) (port=1521)))
Connecting to (Description= (address= (PROTOCOL=IPC) (key=extproc1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version Tnslsnr for Linux:version 11.2.0.1.0-production
Start Date 06-aug-201420:07:43
Uptime 0 days 0 hr. 0min. 0 sec
Trace level off
Security on:local osauthentication
SNMP OFF
Listener Parameter File/opt/oracle/11g/network/admin/listener.ora
Listener Log File/opt/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Listening Endpoints Summary ...
(Description= (address= (PROTOCOL=IPC) (key=extproc1521)))
(Description= (address= (protocol=tcp) (host=127.0.0.1) (port=1521)))
The listener supports no services
The command completed successfully
Step two: Start the database
[[Email protected] ~]$ startup (normal startup database)
Or
[[Email protected] ~]$ startup (Force shutdown database + Normal startup database)
Unable to connect after Oracle server is restarted