Oracle Database Discussions

Unable to start listener service.
Running Oracle Database 11gr2 on Windows 7.
I just installed Oracle with the "install software only" option.
Already set up the instance, the database, the dictionary views, etc.
Created tsnames.ora, sqlnet.ora and listener.ora as shown below.

Before installing Oracle I followed the instruction on Oracle
documentation to install a Loopback Adapter.
It is set up as the primary adapter as indicated on the
instructions. The name is "gabylan" (previously the computer
name was "P4". I set up the "hosts" file as indicated, the oracle_hostname
variable, etc. as you will see below. I don't know if it's important to "uncomment"
the line on the "hosts" file for the "localhost" entry, I left it
as it was originally.

Services currently in "Started" Status:

OracleServiceorcl
Oracle orcl VSS Writer Service
OracleMTSRecoveryService
OracleOraDb11g_home1ClrAgent
OracleServiceorcl

Below is a summary of the error message and some information
about my system setup to help you diagnose my problem.
===============================================================================
c:\Users\Public\myscripts>lsnrctl start

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 18-SEP-2012 13:48

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Starting tnslsnr: please wait...

TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
-------------------------------------------------------------------------------
c:\Users\Public\myscripts> lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 18-SEP-2012 16:17:16

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=gabylan)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error

================================================================================
My "hosts" File: (c:\windows\system32\drivers\etc\hosts)

# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost
192.168.5.5 gabylan gabylan

=================================================================================
c:\Users\Public\myscripts>ipconfig /all

Windows IP Configuration

Host Name . . . . . . . . . . . . : gabylan
Primary Dns Suffix . . . . . . . :
Node Type . . . . . . . . . . . . : Hybrid
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No

Ethernet adapter Local Area Connection 2:

Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Microsoft Loopback Adapter
Physical Address. . . . . . . . . : 02-00-4C-4F-4F-50
DHCP Enabled. . . . . . . . . . . : No
Autoconfiguration Enabled . . . . : Yes
Link-local IPv6 Address . . . . . : fe80::b8f5:bbb0:cf8b:c735%15(Preferred)
IPv4 Address. . . . . . . . . . . : 192.168.5.5(Preferred)
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . :
DHCPv6 IAID . . . . . . . . . . . : 335675468
DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-17-B7-78-52-00-25-22-51-68-AB
DNS Servers . . . . . . . . . . . : fec0:0:0:ffff::1%1
fec0:0:0:ffff::2%1
fec0:0:0:ffff::3%1
NetBIOS over Tcpip. . . . . . . . : Enabled

Ethernet adapter Local Area Connection:

Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Realtek RTL8102E/RTL8103E Family PCI-E Fast Ethernet NIC (NDIS 6.20)
Physical Address. . . . . . . . . : 00-25-22-51-68-AB
DHCP Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
Link-local IPv6 Address . . . . . : fe80::7538:173c:c202:4985%10(Preferred)
IPv4 Address. . . . . . . . . . . : 192.168.1.2(Preferred)
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Lease Obtained. . . . . . . . . . : Tuesday, September 18, 2012 11:37:37 AM
Lease Expires . . . . . . . . . . : Wednesday, September 19, 2012 1:45:01 PM
Default Gateway . . . . . . . . . : 192.168.1.1
DHCP Server . . . . . . . . . . . : 192.168.1.1
DHCPv6 IAID . . . . . . . . . . . : 234890530
DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-17-B7-78-52-00-25-22-51-68-AB
DNS Servers . . . . . . . . . . . : 192.168.1.1
NetBIOS over Tcpip. . . . . . . . : Enabled

=================================================================================
# sqlnet.ora Network Configuration File:
# c:\app\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

# OTHER OPTION FOR AUTHENTICATION IS: SQLNET.AUTHENTICATION_SERVICES= (NTS)

SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, EZCONNECT)

ADR_BASE = c:\app\oracle\

====================================================================================
# tnsnames.ora Network Configuration File:
# c:\app\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gabylan)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

====================================================================================
# listener.ora Network Configuration File:
# c:\app\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gabylan)(PORT = 1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = c:\app\oracle\product\11.2.0\dbhome_1)
(SID_NAME = orcl)
)
)

ADR_BASE_LISTENER = c:\app\oracle
=================================================================================
c:\Users\Public\myscripts>ping gabylan

Pinging gabylan [192.168.5.5] with 32 bytes of data:
Reply from 192.168.5.5: bytes=32 time<1ms TTL=128
Reply from 192.168.5.5: bytes=32 time<1ms TTL=128
Reply from 192.168.5.5: bytes=32 time<1ms TTL=128
Reply from 192.168.5.5: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.5.5:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

=================================================================================
Some related environment variables on my system:

COMPUTERNAME=GABYLAN
FP_NO_HOST_CHECK=NO
HOMEPATH=\Users\oracle
LOGONSERVER=\\GABYLAN
ORACLE_HOME=c:\app\oracle\product\11.2.0\dbhome_1
ORACLE_HOSTNAME=gabylan
ORACLE_SID=orcl
ORACLE_UNQNAME=orcl
SQLPATH=c:\users\public\myscripts
USERDOMAIN=GABYLAN
USERNAME=oracle
USERPROFILE=C:\Users\oracle
==================================================================================
Summary from V$INSTANCE VIEW:

INSTANCE
NAME HOSTNAME STARTUP_T STATUS DATABASE_STATUS ACTIVE_ST
------- --------- ---------------- --------------- ----------
orcl GABYLAN STARTED ACTIVE NORMAL

=================================================================================

Thanks,
Gabriel