Re: login is rejected

csquared_of_va_at_my-dejanews.com wrote:

> We have Oracle Server 7.3 running on an RS6000 F50 (AIX 4.3), using OS
> login authentication. Remote logins (vi sqlnet) work perfectly.
>
> However, whenever anyone except the oracle id itself tries to start
> an oracle process on the server, the login is rejected. A sample
> attempted sqlplus session follows:
>
> //BEGIN ERROR MESSAGE
>
> $ sqlplus
>
> SQL*Plus: Release 3.3.3.0.0 - Production on Thu Sep 17 11:18:27 1998
>
> Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
>
> Enter user-name: /
> ERROR: ORA-01034: ORACLE not available
> ORA-07320: smsget: shmat error when trying to attach sga.
> IBM AIX RISC System/6000 Error: 13: Permission denied
>
> //END ERROR MESSAGE
>
> Any hints??
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

You should set setuid and setgid bits for file $ORACLE_HOME/bin/oracle. Try this:

chmod 6751 $ORACLE_HOME/bin/oracle

This statement should be executed during installation of Oracle software, but some UNIX's give possibility to execute this statement only by root. So, it is very possible that it failed. Check also ownership for this file:

  $ ls -ld $ORACLE_HOME/bin/oracle

-rwsr-sr-- ... oracle dba .... oracle

Good Luck, Sergey.

--
Sergey V. Nikolayenko Software Engineer, Server Applications

Parametric Technology     email: snikolayenko_at_ptc.com
128 Technology Drive      phone: (617) 398-6519
Waltham, MA 02154           fax: (617) 398-5633