Re: login is rejected

Yes, if you did set ORACLE_SID properly and it still doesn't work this is a privilege problem, usually $ORACLE_HOME/dbs/sga${ORACLE_SID}.dbf, but there may be more files wrong. Had the same experience. I ended up reviewing the documentation and changing the protection and ownership of all files because of the NIS problem outlined below. Also: I don't know whether you are running NIS/Yellow Pages, and this system is not the NIS server. If this is true, make sure the user oracle has the same uid and gid everywhere, on all systems in your network Oracle on AIX uses IPC and hence directly attaches to the SGA/ shared memory segment.

Hth,
Sybrand Bakker, Oracle DBA
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
Received on Wed Sep 23 1998 - 12:33:35 CDT