Question:
We are doing a CRM 40 install on Windows2K with Oracle 9i. During DB creation, the install terminates with Ora-01031 Insufficient privilage error. I have checked <sid>adm user groups (assigned to ORA_DBA, ORA_<SID>_ADM) and all other groups that it requires and still getting the same error. We did a previous install about two weeks ago and it worked fine. Weird thing, when you log in as a local user e.g pamadm, you can connect to sqlplus with no errors, but doing the same thing using the domain user/s gives the ora01031 error.
I'm thinking of creating orapwd file etc
Answer:
Early in the installation, the installation gui asked you if you wanted to sign off and back on so it could update your privileges. Did you? And did you sign back on with the exact same user ID you used previosuly?
It is normal for the <sid>adm to "see" more than the administrator, or any other user ID. Because the environment variables to control and run SAP are added only to <sid>adm. These control you <SID> name, database type, etc. which is information that the SAP instance needs in order to work.