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