From oracle-l-bounce@freelists.org Fri Apr 8 23:34:31 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j394YVTV012481 for ; Fri, 8 Apr 2005 23:34:31 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j394Y1em012464 for ; Fri, 8 Apr 2005 23:34:09 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E846B93FC1; Fri, 8 Apr 2005 22:09:37 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17749-09; Fri, 8 Apr 2005 22:09:37 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5D04093F90; Fri, 8 Apr 2005 22:09:37 -0500 (EST) Message-ID: <425746CB.9000208@centurytel.net> Date: Fri, 08 Apr 2005 22:06:51 -0500 From: Bob Bryla User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: oracle-l@freelists.org Subject: unsubscribe References: <20050408070347.44B9792D3F@turing.freelists.org> In-Reply-To: <20050408070347.44B9792D3F@turing.freelists.org> Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 18243 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rjbryla@centurytel.net Precedence: normal Reply-To: rjbryla@centurytel.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: unsubscribe FreeLists Mailing List Manager wrote: oracle-l Digest Thu, 07 Apr 2005 Volume: 02 Issue: 095 In This Issue: Get windows domain user in a web application RE: Get windows domain user in a webapplication Re: rman duplicate fails to identify file Index on status field? Re: Index on status field? Re: Index on status field? RE: rman duplicate fails to identify file Clone to new box Re: 10g Clusterware (OracleCRS) documentation ? Query capture RTFM: Oracle 10g OS-specific default values Re: Query capture Re: Query capture RE: Index on status field?Re: RTFM: Oracle 10g OS-specific default values Re: Clone to new box Re: RTFM: Oracle 10g OS-specific default values Re: Clone to new box Re: RTFM: Oracle 10g OS-specific default values Re: mysql Re: Query capture Re: RTFM: Oracle 10g OS-specific default values Re: Query capture Transparent Gateway for MSSQL not working Re: Clone to new box RE: mysql - OT Re: RTFM: Oracle 10g OS-specific default values RE: Transparent Gateway for MSSQL not working Re: ANSI join syntax Re: mysql RE: rman duplicate fails to identify file 9i Rac config RE: Any way to run more than listener on the same port? Re: Oracle on EMC Clarion CX500 Re: anyone use java EJBs? Multiple installed versions of Oracle RE: library cache lock Re: Re: A SQL solution possible? RE: Any way to run more than listener on the same port? Re: Query capture Re:Query capture Oracle Application 11.5.4 cloning OPIRIP: Uncaught Error 10gRe: Query capture Re: OPIRIP: Uncaught Error 10g Re: Query capture Re: Query capture Re: Query capture RE: ANSI join syntax Re: Query capture Re: Query capture Re: Clone to new box RE: Oracle Application 11.5.4 cloning RE: Multiple installed versions of Oracle RE: Transparent Gateway for MSSQL not working (solved) Changing the SSL Port in 10 GAS Release 2 RE: Changing the SSL Port in 10 GAS Release 2 ---------------------------------------------------------------------- Subject: Get windows domain user in a web application Date: Thu, 7 Apr 2005 12:50:48 +0300 From: "Ciocoiu Adrian" [1] Hello, I have an web application hosted on Oracle application server writen in plsql(unix machine). In our company we have IE as standard browser. How can Iget windows domain user on server ? Thank you very much ------------------------------ Subject: RE: Get windows domain user in a web application Date: Thu, 7 Apr 2005 13:48:32 +0300 From: "Ciocoiu Adrian" [2] Thank you for quick answer. I'm quite new in oracle technology and maybe this is the reason that I do not understand exactly what you are saying. In table V$SESSION are stored database users, amI right? In my application all database operations are done by the same user, configured in dad file. What I need is the user who make a request to web server. This a windows domain user and he has no rights to database. He only can access the web application. I hope now is more clear what I want. regards, Adrian Ciocoiu ________________________________ From: Stephane Faroult [mailto:sfaroult@roughsea.com[3]] Sent: Thursday, April 07, 2005 2:14PM To: Ciocoiu Adrian Subject: Re: Get windows domain user in a web application Adrian, Check in V$SESSION. If you don't find here the information you want, it is probably possible to set in (on the application side) using the DBMS_APPLICATION_INFO package. Check the 'Supplied PL/SQL packages' manual. HTH, Stephane Faroult RoughSea Ltd http://www.roughsea.com[4]On Thu, 7 Apr 2005 12:50 , 'Ciocoiu Adrian' [5] sent: Hello, I have an web application hostedon Oracle application server writen in plsql(unix machine). In our company we have IE as standard browser. How can I get windows domain user on server ? Thank you very much -- http://www.freelists.org/webpage/oracle-l[6] ------------------------------ Subject: Re: rman duplicate fails to identify file Date: Thu, 7 Apr 2005 09:13:09 -0400 From: "Slava Zayarny" [7] Tricia, One sure thing that will cause duplicationto fail (especially when = going off tape media manager layer, which is not the case here) is difference = in file ownership. For instance, you backed up source database as user ORAPRD. On the = auxiliary (duplicate) node you are restoring these files as user ORADEV. Two other things to consider are: difference in Oracle versions and OS=20 versions between sourceand auxiliary nodes. Cheers, Slava Zayarny Oracle DBA ----------------------------------------------------------------- From: Tricia McKellar [8] Subject: rman duplicate fails to identify file Date: Wed, 6 Apr 2005 17:38:44 -0400 Hello, I'm having trouble duplicating a db to another host with a different=20 path structure (oracle 9.2.0.6 on solaris). I'm able to connect to=20 both db's and the filerename parameters in the initDUP.ora seem to be=20 working--rman seems toknow to rename /prod/oradata/vsid/ifs_lobs01.dbf TO /dup/oradata/vsid5/ifs_lobs01.dbf but rman seems to get stuck on the backup pieces. The backup files do=20 exist. I've been rman'ing to disk only (not tape). I've tried copying=20 the backup pieces to the dup host, but it still gets stuck. Ideas? ### ... restoring datafile 00034 to /dup/oradata/vsid5/ifs_lobs13.dbf restoring datafile 00035 to /dup/oradata/vsid5/ifs_lobs14.dbf RMAN-00571: = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D RMAN-00569: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE = STACK FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D RMAN-00571: = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D RMAN-03002: failure of Duplicate Db command at 04/04/2005 13:35:00 RMAN-03015: error occurred in stored script Memory ScriptORA-19505: failed to identify file "/prod/backup/vsid/1fggopji_1_1" ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 ### Thanks, Tricia ------------------------------ Date: Thu, 7 Apr 2005 06:26:39 -0700 (PDT) From: Martic Zoran [9] Subject: Index on status field? The index is on the simple status field on the huge partitioned table per day. Initially it is populated with value 0. When the record is processedI am thinking to put the value to NULL so removing entries from the index and making the index more compact (in opposed to 1). The idea is simple, but not sure about the drawbacks? If you have 1M rows of status fieldwith 0 and 400M with NULL. Then you insert another many millions into the table every day, then put them back to NULL after they are processed. Howis Oracle choosing where to place the new 0 in the index? What is going tohappened to the index in simple manner? Is it going to grow or as we all know old blocks will be reused? I should think of this myself or even try it,but too busy at the moment. Also, my brain is not working nicely at the moment. Thanks in advance. Regards, Zoran __________________________________ Yahoo! Messenger Show us what our next emoticon should look like. Join the fun. http://www.advision.webevents.yahoo.com/emoticontest[10] ------------------------------ Date: Thu, 7 Apr 2005 09:48:38 -0400 From: rjamya [11] Subject: Re: Index on status field? how about using a FBI so you index only those rows with status <>0? Raj On Apr 7, 2005 9:26 AM, Martic Zoran [12] wrote: The index is on thesimple status field on the huge partitioned table per day. Initially it ispopulated with value 0. When the record is processed I am thinking to put the value to NULL so removing entries from the index and making the index more compact (in opposed to 1). The idea is simple, but not sure about the drawbacks? If you have 1M rows of status field with 0 and 400M with NULL. Then you insert another many millions into the table every day, then put themback to NULL after they are processed. How is Oracle choosing where to place the new 0 in the index? What is going to happened to the index in simple manner? Is it going to grow or as we all know old blocks will be reused? I should think of this myself or even try it, but too busy at the moment. Also, my brain is not working nicely at the moment. Thanks in advance. Regards, Zoran __________________________________ Yahoo! Messenger Show us what our next emoticon should look like. Join the fun. http://www.advision.webevents.yahoo.com/emoticontest[13] -- http://www.freelists.org/webpage/oracle-l[14] --- Links --- 1 mailto:adrian.ciocoiu@siemens.com 2 mailto:adrian.ciocoiu@siemens.com 3 mailto:sfaroult@roughsea.com 4 http://www.roughsea.com 5 mailto:adrian.ciocoiu@siemens.com 6 http://www.freelists.org/webpage/oracle-l 7 mailto:Slava.Zayarny@sas.com 8 mailto:tricia_mckellar@ncsu.edu 9 mailto:zoran_martic@yahoo.com 10 http://www.advision.webevents.yahoo.com/emoticontest 11 mailto:rjamya@gmail.com 12 mailto:zoran_martic@yahoo.com 13 http://www.advision.webevents.yahoo.com/emoticontest 14 http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l