os_authent_prefix
Date: 6 Jul 2004 14:37:58 -0700
Message-ID: <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
I've also create a user to be "identified externally" called ftgadm:
SQL> select username,password from dba_users where username =
'FTGADM';
Then when I login to Unix as ftgadm I still cant connect with only
"sqlplus /":
Any ideas?
*.os_authent_prefix=''
oracle_at_S0232119 # pwd
/opt/oracle/product/9.2.0.1.0/dbs
oracle_at_S0232119 #
USERNAME PASSWORD
------------------------------ ------------------------------
FTGADM EXTERNAL
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:
Regards Christian Eriksson Received on Tue Jul 06 2004 - 23:37:58 CEST