> Cool! The last time I ever saw one without suid was 8.0.5.x, and I can't > remember the details about it. All I can remember is that it would run. > Now, you got me wondering how the listener interacts with or uses the oracle > executable to spawn a dedicated session that it requires suid on the > executable; and what differences (if any) there are when connecting with > shared server with pre-spawn server processes. > > I doubt if knowing this has any practical use, but for those who are > terminally bored, looking for something to pass the time .... > Without SUID, Oracle cannot shmat() to IPC memory segments when the oracle binary is invoked by a user. 13:56-rsysdevdb:dv06:jkstill-4 > sqlplus js001292/no_password_here SQL*Plus: Release 10.1.0.2.0 - Production on Thu Aug 12 13:56:07 2004 Copyright (c) 1982, 2004, Oracle. All rights reserved. ERROR: ORA-01034: ORACLE not available ORA-27123: unable to attach to shared memory segment Linux Error: 13: Permission denied Enter user-name: [ /home/jkstill/tmp ] 13:56-rsysdevdb:dv06:jkstill-4 > oerr ora 27123 27123, 00000, "unable to attach to shared memory segment" // *Cause: shmat() call failed // *Action: check permissions on segment, contact Oracle support [ /home/jkstill/tmp ] 13:56-rsysdevdb:dv06:jkstill-4 > Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------