Hi,
on 11.2.0.4 on Oracle Linix
I did:
SQL> ALTER SYSTEM REGISTER;
System altered.
I have :
[oracle@oamim2 ~]$ ps -ef | grep -i listener
oracle 2840 1 0 15:34 ? 00:00:00 /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit
But:
lsnrctl status
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
$ tnsping orcl
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oamim2.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
TNS-12541: TNS:no listener
[oracle@oamim2 ~]$ sqlplus system@orcl
Enter password:
ERROR:
ORA-12541: TNS:no listener
Thanks for help.