12c : Windows Oracle Home User and Listener Administration (Doc ID 1595375.1)

Last updated on MAY 01, 2017

Applies to:

Oracle Net Services - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Microsoft Windows x64 (64-bit)

Goal

The Administrator account can start and stop listener.

However, a Windows user account in the ora_dba group cannot start and stop listener. It can start and stop a database.

The account cannot start and stop listener when local administrator right is granted to that account, it errors out with : TNS-01190 error when using LSNRCTL STOP.

The issue is that the DBA should not use the Administrator account which should be used by the system administrator.

The workaround seems to be start/stop listener using the Oracle listener service.

Oracle installation has been done using the Administrator account and option 2 'Create New Windows User' .

1. Does Oracle 12c requires Administrator account for install and administration ?

2. Does Oracle Home user can lsnrctl start/stop the listener ?

3.Which are the rights needed to administer the listener ?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms