List Info

Thread: More Database 9.2 to 10.2 Upgrade Problems




More Database 9.2 to 10.2 Upgrade Problems
user name
2006-12-11 04:05:17
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

More Database 9.2 to 10.2 Upgrade Problems
user name
2006-12-11 07:23:21
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

[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )