Hi Guys,
I am trying to create a database using DBCA and i encounter the error : Could not validate ASMSNMP due to : ORA-15241 TNS no listener.
My setup is:
VM using Oracle Virtual Box
OS : Oracle Linux 6.5
Oracle database software 11.2.0.4 & Grid infrastructure for single-instance installed.
Listener created by Grid installation in grid home.
What i have tried:
1. Configure another listener using netca : i get an error saying that the port 15xx is in use no matter what port i choose.
2. Adding to listener.ora static registration to +ASM instance, see below.
3. Drop and recreating ASMSNMP, grant SYSDBA, etc.
-----------------------------
listener.ora
----------------------------
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = +ASM)
(SID_NAME = +ASM)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/grid)
)
)
-----------------------------
LISTENER status
-----------------------------
[oracle@oradb11g admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 16-FEB-2014 07:54:29
Copyright (c) 1991, 2013, 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.4.0 - Production
Start Date 16-FEB-2014 07:42:03
Uptime 0 days 0 hr. 12 min. 25 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oradb11g/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary..
Service "+ASM" has 1 instance(s).
Instance "+ASM", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
----------------------------
OS port 1521 listening
------------------------------
[oracle@oradb11g admin]$ netstat -tulpn | grep lsn
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 127.0.0.1:1521 0.0.0.0:* LISTEN 4657/tnslsnr
All firewalls implied are disabled. If i tcpdump port 1521 i can see the request from DBCA, but i still get this error.
Can someone point me what could be the next step to get this working?
Thanks