on 02-04-2008 5:18 PM
We just upgraded from Oracle 9.2.0.6 to Oracle 10.2.0.2 and noticed that if we start the listener with oraSID you cannot shut it down with SIDadm and vice-versa. The error message we get is a TNS-01190 "the user is not authorized to execute the requested listener command". How can you fix this? Please help.
Thanks
Jorge
quick fix: put user sidadm in group dba
you can do this by modifying file /etc/group
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The problem was solved by adding the line LOCAL_OS_AUTHENTICATION_LISTENER = OFF in the listener.ora file.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.