on 04-27-2007 6:06 PM
Hi,
I have installed a new ECC5 system on Oracle/Linux. Everything looks fine except that the startsap and stopsap scripts are not able to start or shutdown the database. It fails with ORA-01031: insufficient privileges.
The SAPR3 user has CONNECT, RESOURCE AND SELECT_CATALOG_ROLE ROLES. The system user has DBA,SAPDBA, and AQ_ADMINISTRATOR_ROLE..
To try out things, I have executed the sapconn_role.sql script to grant the sapconn ROLE aslo to SAPR3 user. But the same problem is there.
The oracle user environment and everything else seems to be fine as everything else is working.
What might be the problem here? What am i missing?
Hi,
SIDadm does belong to the oper group.
sapdba role is also assigned. I have executed both sapdba and sapcon_role but didnt help.
I dont understand Junaid's answer that ops$sidadm needs admin role.
I still feel it is related to our OS NIS groups.Something might be setup wrong.
Any other ideas guys?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Cyrus,
go to usr/sap/SID/SYS/exe and get into SQL and execute sapdba_role.sql it should grant the permissions.
Let me know if it worked.
Regards,
Ershad Ahmed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the info.
The OPS$<SID>ADM user already exists and it have dba,connect and resource roles.
Can this problem be related to OS user groups?
<SID>ADM user is part of dba group though.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Cyrus,
yes, it could be related to the OS groups. Do you added the <sid>adm to the oper group in /etc/group? sidadm does not need to be member of the dba group afiak. Check how the database connect in the startscript is done. Probably by calling sqlplus "/ as sysoper" or with a file sqlplus /nolog @file with file content: connect / as sysoper.
Best regards
Ralph
check SAP Note 361641 - Creating OPS$ users on UNIX
SAP uses OPS$[SID]adm user to authenticate and connect to Oracle.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.