Re: os_authent_prefix

c-eriks_at_algonet.se (Christian Eriksson) wrote in message news:<d0d6f67c.0407061337.481a5a11_at_posting.google.com>...
> Hi!
>
> Where running Oracle database 9.2.0.1.0 on Sun Solaris 8 7/01 (SPARC
> platform). I'm trying to use the OS authentication method for a user
> owning objects in the database. I've started the instance with an
> spfile with the os_authent_prefix='':
>
> oracle_at_S0232119 # grep os spfileftgdb.ora
> *.os_authent_prefix=''
> oracle_at_S0232119 # pwd
> /opt/oracle/product/9.2.0.1.0/dbs
> oracle_at_S0232119 #
>
> I've also create a user to be "identified externally" called ftgadm:
>
> SQL> select username,password from dba_users where username =
> 'FTGADM';
>
> USERNAME PASSWORD
> ------------------------------ ------------------------------
> FTGADM EXTERNAL
>
> Then when I login to Unix as ftgadm I still cant connect with only
> "sqlplus /":
>
> ftgadm_at_S0232119 # sqlplus /
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Tis Jul 6 23:33:47 2004
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27121: unable to determine size of shared memory segment
> SVR4 Error: 13: Permission denied
>
>
> Enter user-name:
>
> Any ideas?
>
> Regards Christian Eriksson

Incorrect permissions on the Oracle directories and/or on the Oracle executable or the setuid bit not set on the Oracle executable. Connecting using an ordinary account will result in the same error. This has nothing to do with O/S authentication.

Sybrand Bakker
Senior Oracle DBA Received on Wed Jul 07 2004 - 09:32:29 CEST