The listener support no services
hello all,
I just installed Oracle 11g r2 on linux x64
after installation, i went to sqldeveloper to test the connection. it worked, so i shutdown the box.
now, i turned on the box. I opened sqldeveloper to create a new account.
it return an error ORA-12514
I checked lsnrctl status, it said no services.
what should i do to get the database running again?
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-JAN-2013 12:06:49
Copyright (c) 1991, 2009, Oracle. All rights reserved.
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-JAN-2013 20:04:58
Uptime 496 days 18 hr. 29 min. 44 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/ryan/app/ryan/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /home/ryan/app/ryan/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully