Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

FW: [suse-oracle] More Database 9.2 to 10.2 Upgrade Problems

Greg Wallace

2006-12-11



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-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.