unsubscribe
- From: Bob Bryla <rjbryla@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 08 Apr 2005 22:06:51 -0500
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" <adrian.ciocoiu@xxxxxxxxxxx>[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"
<adrian.ciocoiu@xxxxxxxxxxx>[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@xxxxxxxxxxxx[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'
<adrian.ciocoiu@xxxxxxxxxxx>[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 -- //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"
<Slava.Zayarny@xxxxxxx>[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 <tricia_mckellar@xxxxxxxx>[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 <zoran_martic@xxxxxxxxx>[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 <rjamya@xxxxxxxxx>[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 <zoran_martic@xxxxxxxxx>[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] --
//www.freelists.org/webpage/oracle-l[14]
--- Links ---
1 mailto:adrian.ciocoiu@xxxxxxxxxxx
2 mailto:adrian.ciocoiu@xxxxxxxxxxx
3 mailto:sfaroult@xxxxxxxxxxxx
4 http://www.roughsea.com
5 mailto:adrian.ciocoiu@xxxxxxxxxxx
6 //www.freelists.org/webpage/oracle-l
7 mailto:Slava.Zayarny@xxxxxxx
8 mailto:tricia_mckellar@xxxxxxxx
9 mailto:zoran_martic@xxxxxxxxx
10 http://www.advision.webevents.yahoo.com/emoticontest
11 mailto:rjamya@xxxxxxxxx
12 mailto:zoran_martic@xxxxxxxxx
13 http://www.advision.webevents.yahoo.com/emoticontest
14 //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
