ORACLE APPS: ORA 01031 during clone build.

Today I was working on building new clone .

System admin give me the system which was not build as per deployment Doc and having loose ends all over the places. Some example

DNS was not push out.

Unix account created but no group added

/var/opt/oracle was not created.

I continue with my build.

After I run clone for oracle account which exit with status code 0.

I was trying to build database from Source backup.

Every time I try to connect as sysdba to ideal database. I have all required environment variable required for ORACLE database.

$ sqlplus 

SQL*Plus: Release 9.2.0.6.0 - Production on Fri Oct 6 18:34:00 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: / as sysdba

ERROR:

ORA-01031: insufficient privileges

Enter user-name: 

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name: 

ERROR:

ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

Here is what I had

$ id

uid=70002(oracle) gid=70035

This is Solaris 10 and database inside Zone

I did a quick search on Metalink but No direct hit.

Confirm the Oracle is re-compile and have permission setup correctly. oracle binary have permission "rwsr-s--x" (6751)

Confirm no issue with ENV

Only suspicious object was my gid was not listed in /etc/group.

Talk to SA ask him to add entry in /etc/group for dba with GID =70035 and add oracle and applmgr to dba group.

After SA make modification to /etc/group file, I have

$ id

uid=70002(oracle) gid=70035(dba)

 
But again when I try to connect SQLPLUS as sysdba I
have same error message. Time is ticking, I rethink what I
did so for, The oracle code was relink using the oracle apps
utility rapid clone. The linking and all modification was
done when group was not setup. 

Ok time for redo the work. 

I re-run the clone process for oracle account.
It finish again with exit code 0. So for so good. 

Now I try sqlplus “/ as sysdba”

addlnctl.sh: exiting with status 0

$ sqlplus 

SQL*Plus: Release 9.2.0.6.0 - Production on Fri Oct 6 18:50:18 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: / as sysdba

Connected to an idle instance.

SQL> exit

CONCUSION:
The apps clone take the group name for the user provided in interactive
question set. 

LESSION LEARN: Make sure you have uid and gid with there corresponding
username and groupname before staring cloning.

NEXT : Find if there are txt files which have Group name.