Home » Infrastructure » Windows » Cannot Configure Listener (11g Enterprise - 11.2.0, Windows Server 2008 R2 x64)
icon8.gif  Cannot Configure Listener [message #594631] Sat, 31 August 2013 08:18 Go to next message
mikepartridge
Messages: 4
Registered: August 2013
Location: Sydney, Australia
Junior Member
Hi All,
So I've spent the last 6 hours at least trying to solve this. I'm a SQL server DBA so please bear with me if any of this seems obvious.

I've been trying to rebuild our Oracle 11g server. I started off by wiping Oracle completely and kicked off the install again. The install goes smoothly, but does not create the Listener. I've been trying to use netca to create it myself. The below is the output from netca:

Listner Control complete.
Listener start failed. 


Looking in the netca trace file, I see the following error (note I'm only including the error with a few lines before):

[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:91]  NativeResult: The String obtained is1|SUCCESSFUL
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:99]  The status string is: 1
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:112]  The result string is: SUCCESSFUL 1
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [WindowsSystem.deleteService:787]  _WS_: deleting service2 OracleRemExecService on AUSYD5756 ignoreNotExist = true
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [WindowsSystem.deleteService:793]  _WS_ deleteService2: node AUSYD5756 Service OracleRemExecService result: 0|Access is denied.

[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:91]  NativeResult: The String obtained is0|Access is denied.

[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:99]  The status string is: 0
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:112]  The result string is: Access is denied.
 1
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [WindowsSystem.startRemoteExecServer:1833]  _WS_ Failed to delete Service OracleRemExecService on AUSYD5756
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [CmdToolUtil.doexecute:365]  nativeSystem.startRemoteExecServer failed
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [HAUtils.isHASConfigured:364]  Ignoring exception in isHASConfigured: PRCT-1013 : Failed to start remote execution server on local node.
PRKN-1016 : Failed to create service "OracleRemExecService" on node "AUSYD5756", Error: "Access is denied.


The OracleRemExecService services does not exist. Can anyone please shed some light on this error? I've tried reinstalling the whole instance a number of times but each time I hit this error.

Any advice would be greatly appreciated.

Thanks.
Re: Cannot Configure Listener [message #594632 is a reply to message #594631] Sat, 31 August 2013 08:27 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum.

I don't know a lot about Windows, but it looks to me as though you are not logged on with appropriate group membership.
You need the goups ora_dba and some sort of admin group too, this is me on a Windows machine logged on with an account that works:
c:\users\john\home>
c:\users\john\home>
c:\users\john\home>whoami /user /groups /fo list

USER INFORMATION
----------------

User Name: jwdell\john
SID:       S-1-5-21-3642582072-1318583595-1076227079-1000


GROUP INFORMATION
-----------------

Group Name: Everyone
Type:       Well-known group
SID:        S-1-1-0
Attributes: Mandatory group, Enabled by default, Enabled group

Group Name: jwdell\ora_dba
Type:       Alias
SID:        S-1-5-21-3642582072-1318583595-1076227079-1002
Attributes: Mandatory group, Enabled by default, Enabled group

Group Name: BUILTIN\Administrators
Type:       Alias
SID:        S-1-5-32-544
Attributes: Mandatory group, Enabled by default, Enabled group, Group owner

Group Name: BUILTIN\Users
Type:       Alias
SID:        S-1-5-32-545
Attributes: Mandatory group, Enabled by default, Enabled group

Group Name: NT AUTHORITY\INTERACTIVE
Type:       Well-known group
SID:        S-1-5-4
Attributes: Mandatory group, Enabled by default, Enabled group

Group Name: NT AUTHORITY\Authenticated Users
Type:       Well-known group
SID:        S-1-5-11
Attributes: Mandatory group, Enabled by default, Enabled group

Group Name: NT AUTHORITY\This Organization
Type:       Well-known group
SID:        S-1-5-15
Attributes: Mandatory group, Enabled by default, Enabled group

Group Name: LOCAL
Type:       Well-known group
SID:        S-1-2-0
Attributes: Mandatory group, Enabled by default, Enabled group

Group Name: NT AUTHORITY\NTLM Authentication
Type:       Well-known group
SID:        S-1-5-64-10
Attributes: Mandatory group, Enabled by default, Enabled group

Group Name: Mandatory Label\High Mandatory Level
Type:       Unknown SID type
SID:        S-1-16-12288
Attributes: Mandatory group, Enabled by default, Enabled group

c:\users\john\home>

Re: Cannot Configure Listener [message #594633 is a reply to message #594632] Sat, 31 August 2013 08:32 Go to previous messageGo to next message
mikepartridge
Messages: 4
Registered: August 2013
Location: Sydney, Australia
Junior Member
Thanks. I am logged in with my domain account which is a member of the Administrators group and also a member of the ora_dba group on this server.

[Updated on: Sat, 31 August 2013 08:33]

Report message to a moderator

Re: Cannot Configure Listener [message #594634 is a reply to message #594633] Sat, 31 August 2013 08:44 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Well, all I can add is that I have had problems when using domain accounts, and try to use local accounts only. I'm sure domain accounts can work, but I don't understand them.

Perhaps someone else can assist.
Re: Cannot Configure Listener [message #594635 is a reply to message #594631] Sat, 31 August 2013 09:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Forget netca.
Connect as a local administrator, open a DOS box, set ORACCE_HOME and include %ORACLE_HOME%\bin in your path.
Then execute "lsnrctl start". Post (copy and paste) the result.

Regards
Michel
Re: Cannot Configure Listener [message #594636 is a reply to message #594635] Sat, 31 August 2013 10:18 Go to previous messageGo to next message
mikepartridge
Messages: 4
Registered: August 2013
Location: Sydney, Australia
Junior Member

C:\Users\mikaupartridge>lsnrctl start

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 01-SEP-2013 01:13
:41

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

Starting tnslsnr: please wait...

TNS-12560: TNS:protocol adapter error
 TNS-00530: Protocol adapter error


Here's my listener.ora file:

# Generated by Oracle configuration tools.

LISTENER3 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = AUSYD5756.au.deloitte.com)(PORT = 1521))
    )
  )

LISTENER1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = AUSYD5756.au.deloitte.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

SID_LIST_LISTENER1 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

ADR_BASE_LISTENER5 = D:\oracle

ADR_BASE_LISTENER4 = D:\oracle

ADR_BASE_LISTENER3 = D:\oracle

ADR_BASE_LISTENER1 = D:\oracle

LISTENER5 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = AUSYD5756.au.deloitte.com)(PORT = 1521))
    )
  )

LISTENER4 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = AUSYD5756.au.deloitte.com)(PORT = 1521))
    )
  )
Re: Cannot Configure Listener [message #594637 is a reply to message #594636] Sat, 31 August 2013 11:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't set ORACLE_HOME.

Regards
Michel
Re: Cannot Configure Listener [message #594638 is a reply to message #594637] Sat, 31 August 2013 12:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also, if your listener has not the default name (LISTENER), you must name it in the command:
lsnrctl start LISTENER1

Regards
Michel
Re: Cannot Configure Listener [message #594643 is a reply to message #594638] Sat, 31 August 2013 16:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Each listener must have corresponding OS service started & running before lsnrctl can successfully issue any commands.

Only a single listener can listen on any specific port number.
In other words you can NOT have more than one listener using port #1521.

Since you obviously don't know what you are doing, you should delete, remove & eliminate your messed up listener.ora file.
The listener will start & be operational when no listener.ora file exists!
Re: Cannot Configure Listener [message #594644 is a reply to message #594643] Sat, 31 August 2013 16:47 Go to previous messageGo to next message
mikepartridge
Messages: 4
Registered: August 2013
Location: Sydney, Australia
Junior Member
ORACLE_HOME is set to "D:\oracle\product\11.2.0\dbhome_1"

Contents of my listener.ora file now:

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = AUSYD5756.au.deloitte.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = D:\oracle


And trying to start the listener:

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 01-SEP-2013 07:46
:28

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

Starting tnslsnr: please wait...

TNS-12560: TNS:protocol adapter error
 TNS-00530: Protocol adapter error


No service exists for my listener and Netca will not work, it keeps saying Listener start failed..

[Updated on: Sat, 31 August 2013 17:00]

Report message to a moderator

Re: Cannot Configure Listener [message #594645 is a reply to message #594644] Sat, 31 August 2013 17:12 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
OS Service for both the database & listener MUST be running prior to doing anything with the listener or the database!
Please confirm that both services exist & are running.

You should delete, remove & eliminate the listener.ora file.
The listener will start & be operational when no listener.ora file exists!
Re: Cannot Configure Listener [message #594657 is a reply to message #594644] Sun, 01 September 2013 01:34 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Keep trying, man, I know how frustrating this sort of thing can be. Some suggestions:

First don't use the netca: it only complicates things.

Second, the service will be created, automatically, the first time the listener starts.

Third, can you confirm that you are logging on with a local administrator account?

Fourth, I think you get that error message if you don't have privileges to open the port.

Fifth, that listener.ora file looks fine to me.

Sixth, AUSYD5756.au.deloitte.com must resolve correctly to a local IP address. Put it in your hosts file, which should be formatted correctly: ipaddress, fully qualified domain name, short name. A lot of Windows administrators have the order wring (short name followed by FQDN) which is wrong (read the RFC if you don't believe me) and Oracle sometimes checks this.
Re: Cannot Configure Listener [message #595279 is a reply to message #594631] Mon, 09 September 2013 20:09 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Don't know if you are still having this problem, but as BlackSwan mentioned, you should delete the listener.ora file (any necessary changes can be made to it AFTER you are able to at least start a listener).

I assume you are using the same account for this whole process. You can try to delete any remaining Oracle services manually from the command line with the following:

sc delete <service_name>

ie:  sc delete OracleOraDb11g_home1TNSListener

As a double check, you should search the registry for any of the services that are still giving you problems. You should remove these from the registry. Of course, the normal caveats go with modifying the registry, but this may be your last resort.

After you have removed any remnants of Oracle services, you should reboot the server and try to start the listener again or start the install again.
Previous Topic: Oracle 12c installation not progressing
Next Topic: Am unable to start DBCONSOLE after initial installation of Oracle 11g R2
Goto Forum:
  


Current Time: Thu Mar 28 17:49:54 CDT 2024