RE: Using hidden parameter_trace_file_public=true

What does 'ls -ld' for each directory show?

e.g. directory is $ORACLE_HOME/admin/db01/udump 'ls -ld $ORACLE_HOME/admin/db01/udump'

Also, there is another way to accomplish this.

Say there is a group 'users' that the developers all belong to.

Using these commands:

  chgrp users $ORACLE_HOME/admin/db01/udump   chmod g+s $ORACLE_HOME/admin/db01/udump

This will cause all files written to $ORACLE_HOME/admin/db01/udump to be created with a group of 'users'.

HTH Jared

"Stephane Paquette" <stephane.paquette_at_standardlife.ca> Sent by: root_at_fatcity.com
 04/23/2003 08:36 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: Using hidden parameter_trace_file_public=true

I've checked permissions on oracle executable and they are the same on both
server: -rwsr-s--x

On the good server, the trace files are created as -rw-rw-r-- On the bad server, when using an OS account other than Oracle : -rw-r-----

Stephane
-----Original Message-----
Faroult
Sent: Tuesday, April 22, 2003 10:32 PM
To: Multiple recipients of list ORACLE-L

Stephane Paquette wrote:
>
> Hi all,
>
> Oracle 8.1.7.2 AIX 4.3.3
>
> On one server if works fine, developpers can access the trace files.
Trace
> files are generated by session in client-server mode or directly on the
unix
> box.
>
> On another server, it works fine in client server but when connect on
the
> unix server it works only if connected as oracle.
>
> Any ideas why it is not working when connecting as someone else than
oracle
> ?
>
> Stephane Paquette
> Administrateur de bases de donnees
> Database Administrator
> Standard Life
> www.standardlife.ca
> Tel. (514) 925-7187
> stephane.paquette_at_standardlife.ca

<mailto:stephane.paquette_at_standardlife.ca>
>

This good old setuid bit missing from the oracle executable ?

--
Regards,

Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Paquette
  INET: stephane.paquette_at_standardlife.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).