TNS-01190: The user is not authorized to execute the requested listener command

[Former Member]

Hi All,

I am installing PI7.3 on running ECC6.0 ehp5 with linux and Oracle 11.2.

After Oracle client software installed successfully, I am getting an error at step "configure oracle network server".

While I am trying  to change the listener password getting the same authorization error.

please help me on this.

Thanks,

Mahendar

[former_member192421 · Accepted solution]

Hi Mahemdar,

Could you please tell me with which OS user you are trying to change the password?

Just make sure that user should belong to local administrator group.

Regards,

Rajkumar

[Former Member · Accepted solution]

Hi RajKumar,

listener is running with ora<SID> user. But I have two ora<SID>s one is for ECC and another one for PI. The listener running with ora<ECCSID> is running fine even I am able to change the password.

My question is,there is no lister running with ora<PISID>, so I am getting an error while installing PI.

Thanks,

Mahendar

[former_member188883 · Accepted solution]

Hi Mahemdar,

Login to the server with su - ora<PIsid>.

Paste the output of  ls -l `which lsnrctl'

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

lxvfgh:orap3d 57> ls -l | grep lsnrctl

-rwxr-x--x 1 orap3d dba    153050 Feb 20 15:06 lsnrctl

-rwxr-xr-x 1 orap3d dba         0 Sep 17  2011 lsnrctl0

Thanks,

Mahendar

[former_member192421 · Accepted solution]

Hi Mahendar,

Can you try adding ora<PISID> user to Administrator Group and check?

Regards,

Rajkumar

[Former Member · Accepted solution]

Hi Rajkumar,

The user is already belongs to admin group.

Thanks,

Mahendar

[Former Member · Accepted solution]

Hi,

Please login as root user.

check whether ora<PISID> is part of dba and oper group in /etc/group..

If not, please try to add it up and restart  your server and check again.

As well as please mv  lsnrctl to lsnrctl_copy and rename lsnrctl0 to lsnrctl and check whether it resolves.

I have faced this issue and for me, I found that orasid is not part of dba and oper group.After adding and restarting the server , everything was fine.

Please check and provide your feedback.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Hi Vimal,

user ora<sid> is part of dba,oper. But I have moved  lsnrctl to lsnrctl_copy and renamedlsnrctl0 to lsnrctl, it works fine.

Thank you.

Mahendar

[former_member188883]

Hi Mahemdar,

Login to the server with su - ora<sid>.

Paste the output of  ls -l `which lsnrctl'.

Also check for user ora<sid> whether environement  ORACLE_HOME is set correctly

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

ora<ECCsid>   13216     1  0 12:30 ?        00:00:00 /oracle/SID/112_64/bin/tnslsnr LISTENER -inherit

orasid   15046 14886  0 15:19 pts/0    00:00:00 grep -i listener

with the ora<sid> of ECC system I am able to stop n start listener.But with ora <PISID> I am not able to change. I am installing PI on running ECC.

Thanks,

Mahendar