Re: help on installation (HP-UX)

In article i5b_at_hermes.uni-konstanz.de, timo_at_PROBLEM_WITH_INEWS_GATEWAY_FILE (Timo Salzsieder) writes:
> Howdy,
>
> we have problems with the installation oracle v7 on a hp 9000 workstation.
>
> Now the description of the problem. We work with sqlnet V1 (tcp) and if we
> login into the database using sqlplus on the machine with user oracle it's
> allright, no problem. But if we try it through the net with a normal database-
> user we've got the following error-code:
> 07318, 00000, "smsget: open error when opening sgadef.dbf file."
>
> I check the permissions on this file which is located in $ORACLE_HOME/rds
> and can't find any difference between the installation on the other machines
> and this machine. We set for testing permissions on sgadef-file to 0777 and get
> now the following error-code:
> 07320, 00000, "smsget: shmat error when trying to attach sga."
>
> Under inspection the system-calls it looks like a problem in the shared-memory
> segments. Is this an error during installation of database, OS, or what else ??
> Can we solve the problem through setting the kernel-parameters??
>

Timo,

We have a different environment (Sun 670MP/SunOS 4.1.3), but when we installed 7.0.13.1 we had similar problems, possibly identical. There are two binaries that need the SUID bit set on in order to effectively access shared memory. They and the permissions we use are:

-rwsr-s--x 1 oracle 5718016 Jan 25 19:23 oracle -rwsr-x--- 1 root 57344 Jun 17 1993 orasrv

I hope this helps.

Jim

---
Jim Goode <jeg_at_codev.csg.eds.com>                EDS
Voice: 214-604-0744 (8-834) Fax: 604-8981        5400 Legacy Drive C5-1D-09
Commercial Services Group, CoDevelopment         Plano, Texas 75024 USA
"Opinions expressed herein are not necessarily supported by my employer."