Re: Unable to access the Oracle Database from users other oracle...

From: Andy <enzoweb_at_hotmail.com>
Date: 26 Aug 2001 15:48:23 -0700
Message-ID: <8d4033cd.0108261448.89619ce@posting.google.com>

I got this off Metalink. My advice would be to contact Oracle Support, it doesn't sound like an easy fix, or speak to your Unix Admins (or NT, whatever the OS):

Error: ORA 7320
Text: smsget: shmat error when trying to attach sga.

---

Cause: Unable to attach segment.
Action: Check errno. sercose[0] returns segment id. Verify segment

        exists and that permissions are correct.  

• Important: The notes below are for experienced users - See [NOTE:22080.1]

Explanation:

        Shared memory for the SGA was gotten with shmget() but could
        not be attached with the system call shmat().
        The OS error code is important in determining the cause of
this
        error.
        This occurred in 'smsget' which implies the shared memory
segment
        should already exist and that this process has got hold of the
        segment but cannot attach it.

Diagnosis:
        Check the OS error code. Common causes are:

        - Error 13 [EPERM]       Permission Denied. This usually
                                 occurs if the Oracle executable does
                                 not have the set-uid bit set and the
                                 user is not the Oracle user.
                                    cd $ORALCE_HOME/bin
                                    ls -l oracle
                                 It should show rwsr-xr-x or similar
                                 permissions. If not:
                                    chmod 4755 oracle

        - Error 12 [ENOMEM]      If attached the process size
                                 greater than the maximum allowed. 
                                 Increase any per process memory
limits.
                                 Also check the available SWAP space.

Articles:
        See also Oracle Error ORA-7307                     

<OERR:ORA:7307>

sree_at_ecil.co.in (Sreelatha) wrote in message news:<465b2b9b.0108230043.5354f195_at_posting.google.com>...
> We had Oracle 7.1 on SCO UNIX . Accidentally we lost the whole
> Oracle directories (i.e ..dbs,rdbms etc.). All the files were recovered
> from the Backup. We are unable to access the database from unix users other than
> unix oracle user.
> But if we login as other user it is showing ORA-7320 error. The text of error is
> smhat error uanble to get sga...
> Can you please help me in this matter. We have made the stand by system
> up..
> We couldn't able to solve this problem...........Please help
> Sreelatha
Received on Sun Aug 26 2001 - 17:48:23 CDT