ORA-7320: smsget: shmat error when trying to attach sga

dsa...@getnet.com

unread,

Aug 28, 1997, 3:00:00 AM8/28/97

to

Hi, I have an Oracle installation I have inherited. It is Oracle 7.2.2.3.0
production release.

I am running under Solaris 2.5.1 on an ultra Enterprise 1.

There is a unix user named oracle, who owns all the files in the oracle
directory. There is a group called dba that has group ownership of all the
files.

As the oracle user I can use sqlplus (version 3.2.2.0.0 production) to log
into the database, but as any other user I get this message:

jabba:/home/dsacks> sqlplus

SQL*Plus: Release 3.2.2.0.0 - Production on Thu Aug 28 12:55:47 1997

Enter user-name: dennis
Enter password:
ERROR: ORA-01034: ORACLE not available
ORA-07320: smsget: shmat error when trying to attach sga.
SVR4 Error: 13: Permission denied

My environment is exactly the same as the oracle user's environment.

Can anyone help me out?

--
---
Okay, you can reach me at: dsa...@getnet.com
or at Denni...@aol.com
Support Linux!

dsa...@getnet.com

unread,

Aug 28, 1997, 3:00:00 AM8/28/97

to

Hello,

I got further than I was: I can now get into Oracle from any account on
the machine it is running on. The original problem was some SUID bits not
being set on executables.

Now I have the /oracle directory nfs mounted to another machine and am
trying to run sqlplus from there.

This is the error I get now:

ERROR: ORA-01034: ORACLE not available

ORA-07429: smsgsg: shmget() failed to get segment.
SVR4 Error: 2: No such file or directory

Also, can someone explain to me how tnsping works?

Billy Verreynne

unread,

Sep 2, 1997, 3:00:00 AM9/2/97

to

dsa...@getnet.com wrote in article <5u4sca$igl$1...@news.getnet.com>...

> Now I have the /oracle directory nfs mounted to another machine and am
> trying to run sqlplus from there.

Huh? Oracle is client-server - I doubt that using NFS mounts of Oracle
databases and software will work. And even if it works, NFS will slow it
down a lot. :-)

> ERROR: ORA-01034: ORACLE not available
> ORA-07429: smsgsg: shmget() failed to get segment.
> SVR4 Error: 2: No such file or directory

To run an Oracle client utility you need the following:
- SQL*Net correct installed with a valid TNSNAMES.ORA (see
$ORACLE_HOME/network/admin)
- PATH variable must include $ORACLE_HOME/bin
- ORACLE_SID variable should contain the Oracle Database's SID

> Also, can someone explain to me how tnsping works?

It's checks if a listener is running for a SID (Oracle Instance) on a
specific IP. But remember, it only checks the Oracle listener on the server
and not the database (i.e. the db instance may be down). Check your
TNSNAMES.ORA file - let's say you use the default orcl.world connection
string:
# tnsping orcl
If it returns ok, it means that the Oracle listener is running and
accepting client connections. If not, logon into oracle on the server and
start the listener using 'lnsrctl start'.

> Support Linux!

Slak rules! :-)

regards,
Billy