This is my first time installing Oracle 11g R2 on Linux. I followed all the instructions in the Oracle documentation, but in the installation process, the Net Configuration Manager is failed. I continued the process, and after it finished, I couldn't connect to sqlplus.
tnsnames.ora
# tnsnames.ora Network Configuration File: /Oracle/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.localhost)
)
listener.ora
# listener.ora Network Configuration File: /Oracle/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /Oracle/u01/app/oracle
Output of lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-MAR-2013 02:35:48
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
I used ./netca
to reconfigure the listener, but the program told me that the port is in use. I deleted it and added a new one, but the same warning that port is in use. When I kill the process that uses this port (1521). and reconfigure the listener, the same message appears that the port is used.
When I run lsnrctl status
, I get:
Services Summary...
Service "orcl.localhost" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.localhost" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
But when I use sqlplus and enter user-name SYSTEM and its password, I get:
ERROR: ORA-12541: TNS:no listener