|
|
| Re: Cannot Configure Listener [message #594632 is a reply to message #594631] |
Sat, 31 August 2013 08:27   |
John Watson
Messages: 8964
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 #594634 is a reply to message #594633] |
Sat, 31 August 2013 08:44 |
John Watson
Messages: 8964
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 #594644 is a reply to message #594643] |
Sat, 31 August 2013 16:47 |
 |
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 #594657 is a reply to message #594644] |
Sun, 01 September 2013 01:34 |
John Watson
Messages: 8964
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 |
 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
