Re: Oracle 7.3.4 with 8.0.4

P M User <gregg_at_computex.com> writes:

> I am trying to have both Oracle 7.3.4 and Oracle 8.0.4 live together on
> my Solaris 2.6 system. I wound up loading 8.0.4 first and then putting
> 7.3.4 on the system.
>
> I cannot access any 7.3.4 databases through the listener. I can get to
> them from the command line.
>
> I understand that Oracle 7 isn't getting a shared memory segment, but I
> don't know what to do about it.
>
> Here's the error message I get:
>
> -----
> SQL*Plus: Release 3.3.4.0.1 - Production on Wed Dec 30 17:34:28 1998
>
> Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
>
> ERROR: ORA-01034: ORACLE not available
> ORA-07320: smsget: shmat error when trying to attach sga.
> SVR4 Error: 13: Permission denied

It sounds like the oracle binary in the Oracle7 instance does not have the correct permissions. It should be setuid to the user ID of the oracle user. To correct it, do the following:

cd $ORACLE_HOME/bin # the ORACLE_HOME of the Oracle7 instance chown oracle7 oracle
chmod 4755 oracle

Sometimes, the installer fails to set the correct ownership and/or permissions. --

                                        Rick
                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com