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@S0232119 # grep os spfileftgdb.ora
*.os_authent_prefix=''
oracle@S0232119 # pwd
/opt/oracle/product/9.2.0.1.0/dbs
oracle@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@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

c-eriks (AT) algonet (DOT) se (Christian Eriksson) wrote in message news:<d0d6f67c.0407061337.481a5a11 (AT) posting (DOT) google.com>...

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

sybrandb (AT) yahoo (DOT) com wrote in message news:<a1d154f4.0407062332.76988f6a (AT) posting (DOT) google.com>...
I don't know for shure what you mean by an ordinary account but:

ftgadm@S0232119 # sqlplus ftgweb@ftgdb

SQL*Plus: Release 9.2.0.1.0 - Production on Tor Jul 8 11:02:03 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> show user
USER is "FTGWEB"
SQL>

connecting as the user FTGWEB is possible.

Regards Christian Eriksson

c-eriks (AT) algonet (DOT) se (Christian Eriksson) wrote in message news:<d0d6f67c.0407080106.6b437632 (AT) posting (DOT) google.com>...
You are not quite connecting the same way ... indicating that the
problem may be with the way you identify the database, and if it is
local or not.
Can you connect successfully without specifying the @SID (sqlplus
ftgweb<cr>).
Or try setting both ORACLE_SID and TWO_TASK (export TWO_TASK=<Oracle
SID>) before calling sqlplus.
If this doesn't work, confirm the value of ORACLE_SID (echo
$ORACLE_SID),
and confirm that it's a local database (tnsping $ORACLE_SID).
If it is on another server, then you must export TWO_TASK=$ORACLE_SID.

HTH
Guy.

dbaguy_ott (AT) yahoo (DOT) com (GQ) wrote in message news:<aad8b5cb.0407080814.6e52cedd (AT) posting (DOT) google.com>...

ftgadm@S0232119 # sqlplus ftgadm

SQL*Plus: Release 9.2.0.1.0 - Production on Lör Jul 10 00:03:19 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:

ftgadm@S0232119 # env | grep TWO_TASK
TWO_TASK=ftgdb
ftgadm@S0232119 # sqlplus ftgadm

SQL*Plus: Release 9.2.0.1.0 - Production on Lör Jul 10 00:04:55 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:
ftgadm@S0232119 # sqlplus /

SQL*Plus: Release 9.2.0.1.0 - Production on Lör Jul 10 00:05:06 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-01004: default username feature not supported; logon denied


Enter user-name: ^C
ftgdb

TNS Ping Utility for Solaris: Version 9.2.0.1.0 - Production on
10-JUL-2004 00:06:16

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
/opt/oracle/product/9.2.0.1.0/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP)
(HOST = S0232119)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = ftgdb)))
OK (10 msec)

I'll guess the above does not resolve as a local database. Is that
required for OS authentication to work?
Regards Christian Eriksson