RE: SET ORACLE-L NOMAIL

2002-10-15 Thread Nastase, Mr. C. (Catalin) 
Title: SET ORACLE-L NOMAIL



Sind 
Sie ein Idiot?

  -Message 
  d'origine-De: Farnsworth, Dave 
  [mailto:[EMAIL PROTECTED]]Date: mardi 15 octobre 2002 
  18:20À: Multiple recipients of list ORACLE-LObjet: RE: 
  SET ORACLE-L NOMAIL
  HILFE
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 15, 2002 
10:34 AMTo: Multiple recipients of list 
ORACLE-LSubject: SET ORACLE-L NOMAIL
SET ORACLE-L NOMAIL 
Mit freundlichen Grüßen, 
Brigitte Türk KAUFHOF WARENHAUS AG IT-Controlling Datenbankadm. Leonhard-Tietz-Str. 1 D-50676 Köln Tel.:+49 (0)221 
223-21 88 eMail: [EMAIL PROTECTED]

RE: methodology to keep only certain programs to connect to

2002-09-10 Thread Nastase, Mr. C. (Catalin) 



Joe,

you may try: 

select sid, serial#, 
username, program from v$session where audsid = userenv( 
'sessionid')

Regards,
Catalin 
Nastase


  -Message d'origine-De: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Date: mardi 10 septembre 2002 
  17:58À: Multiple recipients of list ORACLE-LObjet: 
  methodology to keep only certain programs to connect to
  I've been tasked to ensure only certain app programs access the 
  database.
  
  I'm thinking on-logon trigger, check the program field from 
  v$session. unfortunately v$session is for all sessions, i can't seem to 
  find the view that tells me only MY info during login. I only want the 
  sid, serial#, username and program for my just now connection to the 
  database.
  
  Does this exist or am I going about this the wrong way?
  
  We're thinking of checking those fields to make sure sql*plus, toad, etc 
  can't connect as a particular user(even though the password is known out in 
  the community).
  
  any ideas would be greatly appreciated.
  
  joe

RE: OT : Apache version

2002-07-09 Thread Nastase, Mr. C. (Catalin) 
Title: RE: OT : Apache version 





Hi,


You may try httpd -v if I remember correctly.


Regards,
Catalin


 -Message d'origine-
 De: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]]
 Date: mardi 9 juillet 2002 12:03
 À: Multiple recipients of list ORACLE-L
 Objet: OT : Apache version 
 
 
 Hi Guru,
 
 Does anyone know how to find the apache vision in Unix ? Is 
 pkginfo -i
 |grep -i apache the correct command to find the apache 
 version ? Please
 advise. Thanks.
 
 Regds,
 New Bee
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: CHAN Chor Ling Catherine (CSC)
 INET: [EMAIL PROTECTED]
 
 Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
 San Diego, California -- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (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).

RE: Urgent : UTL file problem

2002-06-21 Thread Nastase, Mr. C. (Catalin) 
Title: RE: Urgent : UTL file problem





vijay,


check the permissions for the /users/vijay directory.
Directories that UTL_FILE can read from and write to must have permissions of the Oracle instance owner and the user running the package.

Also, utl_file_dir=* is not recommended.


Catalin



 -Message d'origine-
 De: Vijaya Chander V.S [mailto:[EMAIL PROTECTED]]
 Date: vendredi 21 juin 2002 13:58
 : Multiple recipients of list ORACLE-L
 Objet: Urgent : UTL file problem
 
 
 my prog looks like this (utl_file_dir=* is present in 
 initSID.ora file):
 
 DECLARE
 fileHandler UTL_FILE.FILE_TYPE;
 BEGIN
 dbms_output.put_line('1');
 fileHandler := UTL_FILE.FOPEN('/users/vijay', 
 'myoutput.lst', 'W');
 dbms_output.put_line('2');
 UTL_FILE.PUTF(fileHandler, 'hai vijay \n');
 UTL_FILE.FCLOSE(fileHandler);
 EXCEPTION
 WHEN utl_file.invalid_path THEN
 raise_application_error(-2, 'ERROR: Invalid path 
 for file.');
 END;
 
 and when i am running this script i am getting a message like this:
 
 1
 DECLARE
 *
 ERROR at line 1:
 ORA-06510: PL/SQL: unhandled user-defined exception
 ORA-06512: at SYS.UTL_FILE, line 101
 ORA-06512: at SYS.UTL_FILE, line 157
 ORA-06512: at line 5
 
 what can be the problem...
 
 regards,
 vijay
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Vijaya Chander V.S
 INET: [EMAIL PROTECTED]
 
 Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
 San Diego, California -- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (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).