os_authent_prefix

From: Christian Eriksson <c-eriks_at_algonet.se>
Date: 6 Jul 2004 14:37:58 -0700
Message-ID: <d0d6f67c.0407061337.481a5a11@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 Received on Tue Jul 06 2004 - 16:37:58 CDT