More Database 9.2 to 10.2 Upgrade Problems

I just wrote:

I checked my 9.2/bin directory and it looks like my 10.2
directory -- x's,
not s's.  Is this something new with 10.2?

>On Sunday, December 10, 2006  10:05 PM, Tom Corr wrote:

>I am a member of the dba group.  Here's what I get when
I do ls -l oracle
>under $ORACLE_HOME/bin --

>-rwxrwx--x 1 oracle dba 95119786 2006-12-10 oracle

>Should I just try doing --

>chmod u+s oracle
>chmod g+s oracle

>and see if that fixes the problem?  Is that the only
file that has those
>attributes in bin, or are there others?

>Thanks,
>Greg Wallace

>>On Sunday 10 December 2006 22:40, you wrote:
>>when you installed oracle i presume you created two
groups "oinstall" and 
>>"dba".  is gregw a member of the
"dba" group?

>>then I would check that the permissions on the
"oracle" binary.  change 
>>directory to ORACLE_HOME/bin

>>cd $ORACLE_HOME/bin
>>ls -l oracle

>>mine looks like:

>>-rwsr-s--x 1 oracle oinstall 108852921 2006-10-02
09:09 oracle*

>>> Well, still more glitches with my conversion
from 9.2 to 10.2.  It seems
>>> like as soon as I get one set of problems
resolved I find something
else.
>>> Right now, I am have the following 2 problems
(neither of which occurred
>>> under 9.2) --
>>>
>>> 1)  I have 2 user accounts, one called ORACLE
and one called GREGW.  I
use
>>> ORACLE only for installing and upgrading
ORACLE.  I do all of my actual
>>> development work under GREGW.  Under 9.2, I
could start and stop the
>>> database, listener, and apache (ISQLPLUS) from
either id and if I
switched
>>> over to the other id I could still access
everything.  Under 10.2,
that's
>>> not the case.  If I start Oracle under ORACLE,
then I cannot access
Oracle
>>> under GREGW, and vice versa.  In either case,
if I start the database
under
>>> one of these ids, switch to the other id, and
try to log in, I get the
>>> following --
>>>
>>> ORA-01034:  ORACLE not available
>>> ORA-27123:  unable to attach to shared memory
segment
>>> Linux Error: 13: Permission denied
>>>
>>> 2)  I am only able to start ISQLPLUS from the
ORACLE account.  If I try
to
>>> start it from GREGW, it gives me the same
messages as under ORACLE, all
>>> indicating that it started, but it is, indeed,
not started (I go to the
>>> ISQLPLUS port via a browser and there's nothing
there).  Maybe there's
an
>>> error log somewhere, but there were no dumps
written into bdump or udump
>>> and no messages in the alert file under bdump.
>>>
>>> Any help greatly appreciated.
>>>
>>> Greg Wallace



-- 
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting