Re: RE: Scritp to Generate "Create Table" ??

[Prem Khanna J]

Thanx Ganesh.
(B
(BtriedEXP/IMP/Databee.
(Bthought of avoiding file copy --> which consumes more time.
(B
(B.a script would be more handy , isn't it ?!
(B
(BRegards,
(BJp.
(B
(B20-06-2003 15:09:33, [EMAIL PROTECTED] wrote:
(B>Oracle is ready to share it with u ;)
(B>Use exp and then Imp into a Index file or use the DataBee Tool .. 
(B
(B
(B
(B-- 
(BPlease see the official ORACLE-L FAQ: http://www.orafaq.net
(B-- 
(BAuthor: Prem Khanna J
(B  INET: [EMAIL PROTECTED]
(B
(BFat City Network Services-- 858-538-5051 http://www.fatcity.com
(BSan Diego, California-- Mailing list and web hosting services
(B-
(BTo REMOVE yourself from this mailing list, send an E-Mail message
(Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
(Bthe message BODY, include a line containing: UNSUB ORACLE-L
(B(or the name of mailing list you want to be removed from).  You may
(Balso send the HELP command for other information (like subscribing).

Scritp to Generate "Create Table" ??

[Prem Khanna J]

Guys,

I would to generate "Create Table .." script 
for a schema WITHOUT storage parameters.

Can someone share a script for the same ?!

ENV is 8.1.6/Win2K.

TIA.
Jp.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: [EMAIL PROTECTED]

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: [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).

Oracle JMS

[Basavaraja, Ravindra]

Hi All,

I need some help in setting up ORACLE JMS to post and read messages from
queue.I am a newbie in this and I ave gone through
the Oracle application developers guide for Advanced queuing document but it
is too exhaustive.

Does anyone have any examples,web links to get started with Oracle JMS.

Appreciate any help.

Thanks
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Basavaraja, Ravindra
  INET: [EMAIL PROTECTED]

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: [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: controlfile backup obsolete

[M Rafiq]

Is your control_file_record_keep_time database parameter value is less than 
the time set for retention policy?
I am not using rman but in Robert Freeman's 9i new features book I saw 
aboves point.

It might help or Robert may see your message and suggest some  solution.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 19 Jun 2003 18:09:18 -0800
Hello List, sorry about posting this again but , no one responded and
I am really stuck
I am using Oracle 9i release 2 enterprise edition on win32
After connecting thru rman , I made sure that I did not have any
backupsets by running
delete backup ;
and then checked with list backup ;
I have set a recovery window of 4 days with :
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;
And enabled autobackup of controlfiles and spfiles :
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'D:\%F';
Then I created a backup of the entire database :
 backup database ;
(This created a separate backup piece : D:\C-2202427048-20030619-05)
This is the only backup of the control file I have.  I checked with
RMAN> LIST BACKUP OF CONTROLFILE;
List of Backup Sets
===
BS Key  Type LV Size   Device Type Elapsed Time Completion Time

---  -- -- ---  --
--
60  Full672K   DISK00:00:02 19-Jun-2003 08:04:
42
BP Key: 60   Status: AVAILABLE   Tag:
Piece Name: D:\C-2202427048-20030619-05
  Controlfile Included: Ckp SCN: 190854   Ckp time: 19-Jun-2003
08:04:40
Now when I run report obsolete ;
Its gives me the following o/p
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 4 days
Report of obsolete backups and copies
Type KeyCompletion TimeFilename/Handle
 -- -- 
Backup Set 60 19-Jun-2003 08:04:42
Backup Piece  60 19-Jun-2003 08:04:42
D:\C-2202427048-20030619-05
Why is this sole backup of the controlfile , obsolete ?
If someone runs a delete obselete; they will delete this backup.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]
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: [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).
_
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
 INET: [EMAIL PROTECTED]
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: [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: controlfile backup obsolete

[Mladen Gogala]

Obsolescence of a backup is defined by existance of other, redundant backups.
Give a "redundant" option to your backup command and RMAN will wait for 30 
backups before declaring the current one obsolete.

On 2003.06.19 22:09, [EMAIL PROTECTED] wrote:
Hello List, sorry about posting this again but , no one responded and
I am really stuck
I am using Oracle 9i release 2 enterprise edition on win32
After connecting thru rman , I made sure that I did not have any
backupsets by running
delete backup ;
and then checked with list backup ;
I have set a recovery window of 4 days with :
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;
And enabled autobackup of controlfiles and spfiles :
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'D:\%F';
Then I created a backup of the entire database :
 backup database ;
(This created a separate backup piece : D:\C-2202427048-20030619-05)
This is the only backup of the control file I have.  I checked with
RMAN> LIST BACKUP OF CONTROLFILE;
List of Backup Sets
===
BS Key  Type LV Size   Device Type Elapsed Time Completion Time

---  -- -- ---  --
--
60  Full672K   DISK00:00:02 19-Jun-2003 08:04:
42
BP Key: 60   Status: AVAILABLE   Tag:
Piece Name: D:\C-2202427048-20030619-05
  Controlfile Included: Ckp SCN: 190854   Ckp time: 19-Jun-2003
08:04:40
Now when I run report obsolete ;
Its gives me the following o/p
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 4 days
Report of obsolete backups and copies
Type KeyCompletion TimeFilename/Handle
 -- -- 
Backup Set 60 19-Jun-2003 08:04:42
Backup Piece  60 19-Jun-2003 08:04:42
D:\C-2202427048-20030619-05
Why is this sole backup of the controlfile , obsolete ?
If someone runs a delete obselete; they will delete this backup.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]
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: [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).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
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: [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).

controlfile backup obsolete

[bulbultyagi]

Hello List, sorry about posting this again but , no one responded and
I am really stuck
I am using Oracle 9i release 2 enterprise edition on win32

After connecting thru rman , I made sure that I did not have any
backupsets by running
delete backup ;
and then checked with list backup ;

I have set a recovery window of 4 days with :
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;

And enabled autobackup of controlfiles and spfiles :
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'D:\%F';

Then I created a backup of the entire database :
 backup database ;
(This created a separate backup piece : D:\C-2202427048-20030619-05)

This is the only backup of the control file I have.  I checked with
RMAN> LIST BACKUP OF CONTROLFILE;

List of Backup Sets
===

BS Key  Type LV Size   Device Type Elapsed Time Completion Time

---  -- -- ---  --
--
60  Full672K   DISK00:00:02 19-Jun-2003 08:04:
42
BP Key: 60   Status: AVAILABLE   Tag:
Piece Name: D:\C-2202427048-20030619-05
  Controlfile Included: Ckp SCN: 190854   Ckp time: 19-Jun-2003
08:04:40

Now when I run report obsolete ;
Its gives me the following o/p

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 4 days
Report of obsolete backups and copies
Type KeyCompletion TimeFilename/Handle
 -- -- 
Backup Set 60 19-Jun-2003 08:04:42
Backup Piece  60 19-Jun-2003 08:04:42
D:\C-2202427048-20030619-05

Why is this sole backup of the controlfile , obsolete ?
If someone runs a delete obselete; they will delete this backup.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

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: [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: TEXT FILE

[Stephen Lee]

A somewhat messy way to do this, if you are on Unix, is a shell script
something like:

 snip ---
#!/usr/bin/ksh

export ORACLE_SID=BUBBA
export ORALCE_HOME=/dir/dir/product/9.2.0
export PATH=$ORACLE_HOME/bin:${PATH:-/usr/bin:/usr/sbin:/whatever/else}

... anything else I forgot ...

cat /dev/null > my_text_file

{
sqlplus -s <<-XXX
username/[EMAIL PROTECTED]
set lines 300 pages 0 trims on heading off feedback off
set whatever else
select this,that,the,other,thing from my_big_table;
XXX
} | /usr/bin/sed '/^$/d' | while read LINE; do
echo "$LINE" >> my_text_file
done

exit 0
- snip ---

Note: The sed statement deletes blank lines, so it is probably not required
but is there as an example.
You aren't required to use the while read LINE stuff.  You can take it out
and run the script as:

./my_script > my_text_file

If you are on MS-DOS, I think you can put the sqlplus commands in a file
called, for example, sql_plus_commands, then do something like:

sqlplus -s < sql_plus_commands > my_text_file

This will work on Unix too; but it's not as cool as the self-contained shell
script.  And we all want to be as cool as possible.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [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: copy a datafile to a raw device

[Richard Ji]

You just have lots of empty space left on your raw device.

-Original Message-
Sent: Thursday, June 19, 2003 6:30 PM
To: Multiple recipients of list ORACLE-L



And if I dd a 200 Mb data file to a 1500 Mb raw device  ???

> -Original Message-
> 
> 
> Well, this oracle "file system" is the logical storage structure of
> tablespace, segment, extent, db blocks which is the same on 
> File System or raw device.
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

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: [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: data architecture/conferences/documents/lists

[DENNIS WILLIAMS]

David - Well, some people on this list write books, some of us read 'em.
Actually the Reingruber & Gregory book is awesome if you are in the position
of evaluating data models, which happens from time to time with us DBAs.
They analyze darn near all common modeling alternatives and provide great
reasons for not choosing some alternatives. Made me look a lot less dumb in
a pinch. And if the modeler wants to argue you can just state that you are
just providing information so it isn't you against them, but them against
some noted authors.



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, June 19, 2003 4:40 PM
To: Multiple recipients of list ORACLE-L



Dennis, 

I think you are even more of a book worm than I am.  I agree that the Ralph
Kimball books are great for star schema design.  I will check out the other
book for normalized models.  Thanks for the tip.


Best regards, 

David B. Wagoner 
Database Administrator 
Arsenal Digital Solutions 



-Original Message- 
 ] 
Sent: Thursday, June 19, 2003 3:42 PM 
To: Multiple recipients of list ORACLE-L 


Paula - My impression is that the data architecture arena is now split 
between OLTP (normalized) and DW (star schema), with different mindsets 
accordingly. The best resource for normalized data modeling that I have 
found is: 
The Data Modeling Handbook by Michael C. Reingruber and William W. Gregory 
For Star schema I think Ralph Kimball is the place to start. 



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message- 
Sent: Thursday, June 19, 2003 2:11 PM 
To: Multiple recipients of list ORACLE-L 



Interested in data architecture issues beyond a particular RDBMS (sorry guys

just have to be) and I was wondering if anyone had any good resources: 

-listservers 
-conferences (what are the best for a ltd. budget) 
-good books/articles/magazines 

I just received a request about 

"The Next Big Thing Panel was part of the Wilshire Meta-Data Conference and 
DAMA International Symposium - the world's largest and most authoritative 
vendor-neutral data management conference. If you missed this event and 
would like to order the documentation, please visit the conference home 
page." 

Anyone know if this is worth going to?  It looks very interesting. 

Thanks, 
Paula 

-Original Message- 
< mailto:[EMAIL PROTECTED]  > ] 
Sent: Wednesday, August 14, 2002 11:24 AM 
To: Multiple recipients of list ORACLE-L 


Srinivas 
   It would help if we knew what you were trying to achieve. Is this some 
type of security solution? My guess is that the oracle binary will get 
Oracle started, but maybe it would be simplest if you just tried it. I will 
warn you of one thing. If the oracle binary isn't setuid to root, you get a 
situation where only the Oracle user can execute it. 
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 


-Original Message- 
Sent: Wednesday, August 14, 2002 2:08 AM 
To: Multiple recipients of list ORACLE-L 


Hello All, 

I am curious to know what are the executables that are 
used when we say startup/shutdown of oracle database 
on Sun box. 

I think it is $ORACLE_HOME/bin/oracle 

are there any other executables/kernel files 
(important) in bin or in anyother areas. 

Can somebody throw somelight ??/ 

Thanks in advance, 
Srinivas 

__ 
Do You Yahoo!? 
HotJobs - Search Thousands of New Jobs 
http://www.hotjobs.com   < http://www.hotjobs.com
 >  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
< http://www.orafaq.com  >  
-- 
Author: kommareddy sreenivasa 
  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). 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
< http://www.orafaq.com  >  
-- 
Author: DENNIS WILLIAMS 
  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 containin

RE: Book Recommendation for Apache

[Cary Millsap]

The Lincoln Stein book called "How to Set Up and Maintain a Web Site" is
good.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic 101 in Dallas, Washington, Denver, Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Rogers
Sent: Thursday, June 19, 2003 4:15 PM
To: Multiple recipients of list ORACLE-L

Drums along the mohawk.

>>> [EMAIL PROTECTED] 06/19/03 04:44PM >>>
Hi,

 

Any recommendations on good Apache books?

 

We will be bringing in Oracle 9iAS shortly.  Third party application
constraints require the use of Forms 6i, which in turn requires that
we
stay with 9iAS Release 1 (version 1.0.2.x.x).   We are currently
running
Oracle Application Server.  

 

I want to understand how 9iAS works.  For me, the steps to
understanding
this are something like:

 

1)   Understand HTTP

2)   Understand Apache

3)   Understand 9iAS

 

I have found useful information on the Internet describing the HTTP
protocol, and I am comfortable I understand that well enough to move
on.
Now I want to get a handle on the Apache Server.  I have had a brief
look at a book from O'reilly called "Apache, The Definitive Guide".
This looks like a good book.  

 

Thanks,

 

Sam 

 

p.s. A few months, I read on the List that the Publisher of Tom Kyte's
book ""Expert One-On-One Oracle" has gone bankrupt.  Can anybody
confirm
if this is true?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

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: [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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Cary Millsap
  INET: [EMAIL PROTECTED]

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: [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: copy a datafile to a raw device

[Stephen Lee]

And if I dd a 200 Mb data file to a 1500 Mb raw device  ???

> -Original Message-
> 
> 
> Well, this oracle "file system" is the logical storage structure of
> tablespace, segment, extent, db blocks which is the same on 
> File System or raw device.
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [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: oracle authentication from windows

[Arup Nanda]

Mladen,
 
This is precisely the content I have gone in depth 
in my upcoming book where this practice of OPS$ accounts have been discussed. 

 
The security hole in OPS$ accounts is a bit 
overrated. Chagnign username in Windows XP alone does not allow logging in to 
the database directly if OPS$ accounts are used. What you are referring to is 
setting the ORA_DBA group in Windows. Here is an excerpt from the 
book:
 
"If OPS$ accounts must be used, make sure that 
init.ora parameter os_authent_prefix is set to OPS$ or some other value, not 
NULL. If it is null, as shown by an empty string "", the security is severely 
threatened. Any one can create a userid called SYSTEM in the OS and then logon 
without a password as the Oracle user SYSTEM. If the os_authent_prefix is set to 
OPS$, then the corresponding user id in Oracle will be OPS$SYSTEM, not SYSTEM. 
they are different users."
 
As you might notice, OPS$ accounts are somehow 
insecure, and I personally eschew them; but let's face it, in some situations, 
like in the case AK mentioned, the use is required. When the DBAs can do is to 
take some precautions to ensure security.
 
HTH.
 
Arup

  - Original Message - 
  From: 
  Gogala, Mladen 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, June 19, 2003 4:19 
  PM
  Subject: RE: oracle authentication from 
  windows
  
  That, of course, will render your database totally 
  insecure and open to anybody 
  who 
  can bring in a WinXP laptop, change the windoze username and log in as he 
  pleases.
  DBA 
  that sets his production parameters the way Arup described deserves to be 
  
  publicly tortured by Bill O'Reilly in the "no spin 
  zone".
   
  Mladen Gogala Oracle DBA Phone:(203) 
  459-6855 Email:[EMAIL PROTECTED] 
  
-Original Message-From: Arup Nanda 
[mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 3:46 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
oracle authentication from windows
Sure.
 
Just declare these in your 
init.ora
 
os_authent_prefix=OPS$remote_os_authent=TRUE
 
bounce the database, add a user called 
OPS$, e.g. OPS$AK if your Windows login id is AK 
as
 
create user ops$ak identified 
externally
 
From windows connect as "/@servicename", 
e.g. sqlplus /@service1
 
If it doesn't work, the OS user may be 
different. Use this query while connected to the database from Windows 
cleint.
 
SQL> select sys_context('USERENV','OS_USER') 
from dual;
 
See what OS username comes up; use that 
instead.
 
HTH.
 
Arup Nanda
www.proligence.com
 
 

  - Original Message - 
  From: 
  AK 
  
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Thursday, June 19, 2003 1:10 
  PM
  Subject: oracle authentication from 
  windows
  
  We want our client users ( forms user )  
  to just enter windows password and then automatically able to get in to 
  oracle .Is there a way oracle can authenticate from windows ( or active 
  directory ) . enbadding password in runform.exe not an option 
  .
   
  thanks,
  -ak

RE: TEXT FILE

[Jesse, Rich]

It depends.  What version of Oracle?

You can also create a file via Java Stored Procedure (requires at least
v8.0, possibly 8i?).  If you're able to grant JAVA_SYSPRIV to the account
creating the file, you can also avoid the hassle of being restricted to
directories specified by the UTL_FILE_DIR init.ora parameter for OS file
access.

For extensive searches and indexes, you may also want to consider Oracle's
ConText/InterMedia/Text cartridge (names depend on your version).


Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA

> -Original Message-
> From: Seema Singh [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 4:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: TEXT FILE
> 
> 
> Hi,
> Is there any other packages thru which we can generate text 
> file except 
> UTL_FILE?
> I want to generate text file dump into another server ,that 
> server will 
> indexes and processing that data and improve search.
> How to do that?
> Thanks
> -Seema
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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: [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: copy a datafile to a raw device

[Richard Ji]

You didn't mention what Unix platform you are on.
But since a striaght dd didn't work, you need to use seek to
skip some blocks.

-Original Message-
Sent: Thursday, June 19, 2003 2:55 PM
To: Multiple recipients of list ORACLE-L


hi all:

I need to move a SYSTEM datafile from a filesystem
to a raw device. I have shutdown the database,
copied the file via

dd if=system of=/dev/raw

renamed the file in the database, but couldn't open
the database because of the error: Unknown File Header
Version read for file number 1.

I tried another dd:

dd if=system of=/dev/raw obs=32768 (32K is the db
block size), but I got the same error. Can anyone
see what else could be wrong with my dd command

thanks

Gene

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

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: [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: Re: Passwords and authentication

[Arup Nanda]

Thanks, Scott. 

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 6:04 PM


> "HIPAA Auditing for Oracle Database Security"  Nice.
> 
> Well, Arup, Get to publishing!
> 
> ;-)
> 
> --Scott
> 
> 
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> Sent: 6/19/03 3:19 PM
> 
> 
> http://www.dba-oracle.com/bp/bp_titles.htm
> 
> Look about in the middle of the page.
> 
> > -Original Message-
> > what will be the name of your book? when will it be out? you 
> > have an extract of what it will cover yet? 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> 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: [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).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

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: [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).

Wrox Press catalog purchased by APress (was RE: Book Recommendati on for Apache)

[Pardee, Roy E]

I believe it's true that wrox is out of business.  But APress
(www.apress.com) has purchased the bulk of their catalog, so hopefully
they'll resume publishing these books...

Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487 
-Original Message-
Sent: Thursday, June 19, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L


Hi,

Any recommendations on good Apache books?

We will be bringing in Oracle 9iAS shortly.  Third party application
constraints require the use of Forms 6i, which in turn requires that we stay
with 9iAS Release 1 (version 1.0.2.x.x).   We are currently running Oracle
Application Server.  

I want to understand how 9iAS works.  For me, the steps to understanding
this are something like:

1)   Understand HTTP
2)   Understand Apache
3)   Understand 9iAS

I have found useful information on the Internet describing the HTTP
protocol, and I am comfortable I understand that well enough to move on.
Now I want to get a handle on the Apache Server.  I have had a brief look at
a book from O'reilly called "Apache, The Definitive Guide".  This looks like
a good book.  

Thanks,

Sam 

p.s. A few months, I read on the List that the Publisher of Tom Kyte's book
""Expert One-On-One Oracle" has gone bankrupt.  Can anybody confirm if this
is true?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pardee, Roy E
  INET: [EMAIL PROTECTED]

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: [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: copy a datafile to a raw device

[Scott . Shafer]

You left out, "...and why is there a goat in the corner?" 

Sounds like a fun way to have at my duhvelopers (not the good ones).


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/19/03 4:49 PM


Concerning my speculation about error messages in the Oracle kernel, the
following is an actual error message in an app here.  Of course, the
error
is never supposed to occur -- so says the programmer when I asked about
it.

SERROR_MESSAGE := 'How did I Get Here? Where is my car? Who is that
laying
next to me? Oh my God is that a marriage license?!';

Just in case you developers out there have any creative urges.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [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: Re: Passwords and authentication

[Scott . Shafer]

"HIPAA Auditing for Oracle Database Security"  Nice.

Well, Arup, Get to publishing!

;-)

--Scott


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/19/03 3:19 PM


http://www.dba-oracle.com/bp/bp_titles.htm

Look about in the middle of the page.

> -Original Message-
> what will be the name of your book? when will it be out? you 
> have an extract of what it will cover yet? 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [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: copy a datafile to a raw device

[Richard Ji]

Well, this oracle "file system" is the logical storage structure of
tablespace, segment, extent, db blocks which is the same on File System
or raw device.

Richard Ji

-Original Message-
Sent: Thursday, June 19, 2003 5:20 PM
To: Multiple recipients of list ORACLE-L



I might expand on this some.  If you think about it, any time you store
bytes on something, the storing process has to make a note of where it put
the bytes; maybe how many bytes it put there; if the bytes are not
contiguous, then info about where one set leaves off and where the next set
picks up.  And on and on ...

I've never worked with Oracle raw devices and am just guessing here, but
applying some knowledge about how other forms of storage work, I seems
logical that Oracle would have to "format" the raw device and essentially
create a sort of proprietary "file system" there.  If you just toss some
bytes on a raw device and tell Oracle to go get 'em, then I'm guessing
Oracle will just say something like: "This might be a raw device, but it
ain't no stinkin' ORACLE raw device."

Or, to put it another way: "What's this merde?"  (Pardon my French.)

(You have to wonder if there is an error message *something* like this
buried down in the Oracle kernel by some irreverent programmer.)


> -Original Message-
> From: Stephen Lee 
> Sent: Thursday, June 19, 2003 3:27 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: copy a datafile to a raw device
> 
> 
> 
> Well heck.  Nobody else has replied, so I might take a stab 
> at it here.  I
> suspect that the format of the data (bits and bytes) required on a raw
> device is different than the format of the data in a file in 
> a file system.
> I'm stretching a bit here, but I think an analogy would be 
> what would happen
> if you dd a file from UFS to NTFS.  The data on the NTFS 
> might be a digital
> copy of what was on UFS, but it's format is totally useless 
> in the context
> of NTFS.
> 
> > -Original Message-
> > From: Gurelei [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, June 19, 2003 1:55 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: copy a datafile to a raw device
> > 
> > 
> > hi all:
> > 
> > I need to move a SYSTEM datafile from a filesystem
> > to a raw device. I have shutdown the database,
> > copied the file via
> > 
> > dd if=system of=/dev/raw
> > 
> > renamed the file in the database, but couldn't open
> > the database because of the error: Unknown File Header
> > Version read for file number 1.
> > 
> > I tried another dd:
> > 
> > dd if=system of=/dev/raw obs=32768 (32K is the db
> > block size), but I got the same error. Can anyone
> > see what else could be wrong with my dd command
> > 
> > thanks
> > 
> > Gene
> > 
> > __
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Gurelei
> >   INET: [EMAIL PROTECTED]
> > 
> > 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: [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).
> > 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Stephen Lee
>   INET: [EMAIL PROTECTED]
> 
> 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: [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).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ric

RE: TEXT FILE

[Nelson, Allan]

Sure, write your own pro C++ to text converter.  Otherwise nothing I
know about.

Allan

-Original Message-
Sent: Thursday, June 19, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L


Hi,
Is there any other packages thru which we can generate text file except 
UTL_FILE?
I want to generate text file dump into another server ,that server will 
indexes and processing that data and improve search.
How to do that?
Thanks
-Seema

_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seema Singh
  INET: [EMAIL PROTECTED]

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: [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).


__
This email is intended solely for the person or entity to which it is addressed and 
may contain confidential and/or privileged information.  Copying, forwarding or 
distributing this message by persons or entities other than the addressee is 
prohibited. If you have received this email in error, please contact the sender 
immediately and delete the material from any computer.  This email may have been 
monitored for policy compliance.  [021216]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nelson, Allan
  INET: [EMAIL PROTECTED]

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: [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: copy a datafile to a raw device

[Stephen Lee]

Concerning my speculation about error messages in the Oracle kernel, the
following is an actual error message in an app here.  Of course, the error
is never supposed to occur -- so says the programmer when I asked about it.

SERROR_MESSAGE := 'How did I Get Here? Where is my car? Who is that laying
next to me? Oh my God is that a marriage license?!';

Just in case you developers out there have any creative urges.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [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: IO Topology Anyone???

[chao_ping]

Freeman Robert - IL,ÄúºÃ£¡

It  seems that in oracle10i, there is such feature. But I have not read much 
about it.

=== 2003-06-19 09:55:00 ÄúÔÚÀ´ÐÅÖÐдµÀ£º===

>Anyone use the IO Topology features with Oracle9iR2 and Veritas? Does
>Veritas have a mapping file that you can use with this feature? (I've posed
>the same question with Veritas, so it's a race to the answer!) Any
>experiences you can share about this feature?
>
>Robert 
>
>  
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>-- 
>Author: Freeman Robert - IL
>  INET: [EMAIL PROTECTED]
>
>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: [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).

= = = = = = = = = = = = = = = = = = = =


ÖÂ
Àñ£¡
 
 
chao_ping
[EMAIL PROTECTED]
2003-06-20



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: chao_ping
  INET: [EMAIL PROTECTED]

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: [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: data architecture/conferences/documents/lists

[David Wagoner]

Title: RE: data architecture/conferences/documents/lists





Dennis,


I think you are even more of a book worm than I am.  I agree that the Ralph Kimball books are great for star schema design.  I will check out the other book for normalized models.  Thanks for the tip.


Best regards,


David B. Wagoner
Database Administrator
Arsenal Digital Solutions




-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 19, 2003 3:42 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: data architecture/conferences/documents/lists



Paula - My impression is that the data architecture arena is now split
between OLTP (normalized) and DW (star schema), with different mindsets
accordingly. The best resource for normalized data modeling that I have
found is:
The Data Modeling Handbook by Michael C. Reingruber and William W. Gregory
For Star schema I think Ralph Kimball is the place to start. 




Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, June 19, 2003 2:11 PM
To: Multiple recipients of list ORACLE-L




Interested in data architecture issues beyond a particular RDBMS (sorry guys
just have to be) and I was wondering if anyone had any good resources:


-listservers 
-conferences (what are the best for a ltd. budget) 
-good books/articles/magazines 


I just received a request about 


"The Next Big Thing Panel was part of the Wilshire Meta-Data Conference and
DAMA International Symposium - the world's largest and most authoritative
vendor-neutral data management conference. If you missed this event and
would like to order the documentation, please visit the conference home
page."


Anyone know if this is worth going to?  It looks very interesting. 


Thanks, 
Paula 


-Original Message- 
 ] 
Sent: Wednesday, August 14, 2002 11:24 AM 
To: Multiple recipients of list ORACLE-L 



Srinivas 
   It would help if we knew what you were trying to achieve. Is this some 
type of security solution? My guess is that the oracle binary will get 
Oracle started, but maybe it would be simplest if you just tried it. I will 
warn you of one thing. If the oracle binary isn't setuid to root, you get a 
situation where only the Oracle user can execute it. 
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 



-Original Message- 
Sent: Wednesday, August 14, 2002 2:08 AM 
To: Multiple recipients of list ORACLE-L 



Hello All, 


I am curious to know what are the executables that are 
used when we say startup/shutdown of oracle database 
on Sun box. 


I think it is $ORACLE_HOME/bin/oracle 


are there any other executables/kernel files 
(important) in bin or in anyother areas. 


Can somebody throw somelight ??/ 


Thanks in advance, 
Srinivas 


__ 
Do You Yahoo!? 
HotJobs - Search Thousands of New Jobs 
http://www.hotjobs.com   
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: kommareddy sreenivasa 
  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). 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: DENNIS WILLIAMS 
  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). 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]


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: [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 fo

TEXT FILE

[Seema Singh]

Hi,
Is there any other packages thru which we can generate text file except 
UTL_FILE?
I want to generate text file dump into another server ,that server will 
indexes and processing that data and improve search.
How to do that?
Thanks
-Seema

_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Seema Singh
 INET: [EMAIL PROTECTED]
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: [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: copy a datafile to a raw device

[chao_ping]

Gurelei,ÄúºÃ£¡
   hi, what is your OS? In some os, you have to skip some block on that raw 
device for lvm usage.
If you use rman copy, rman will handle it for you.
Good luck


=== 2003-06-19 10:55:00 ÄúÔÚÀ´ÐÅÖÐдµÀ£º===

>hi all:
>
>I need to move a SYSTEM datafile from a filesystem
>to a raw device. I have shutdown the database,
>copied the file via
>
>dd if=system of=/dev/raw
>
>renamed the file in the database, but couldn't open
>the database because of the error: Unknown File Header
>Version read for file number 1.
>
>I tried another dd:
>
>dd if=system of=/dev/raw obs=32768 (32K is the db
>block size), but I got the same error. Can anyone
>see what else could be wrong with my dd command
>
>thanks
>
>Gene
>
>__
>Do you Yahoo!?
>SBC Yahoo! DSL - Now only $29.95 per month!
>http://sbc.yahoo.com
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>-- 
>Author: Gurelei
>  INET: [EMAIL PROTECTED]
>
>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: [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).

= = = = = = = = = = = = = = = = = = = =


ÖÂ
Àñ£¡
 
 
chao_ping
[EMAIL PROTECTED]
2003-06-20



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: chao_ping
  INET: [EMAIL PROTECTED]

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: [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: OEM question

[Stephen Lee]

No No.  THOSE guys did replication.  Then the worst of the bunch worked in
conjunction with the authors of graduate Math texts to come up with Advanced
Queuing.

-Original Message-
I have tried to automate various things with OEM jobs and events and
eventually decided that at and dbms_job worked perfectly adequately. bearing
in mind that DBMS_JOB is - I'm pretty sure - designed by a bunch of sadists
who have it in for Admin guys this is not a huge recommendation :( 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [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: copy a datafile to a raw device

[Stephen Lee]

I might expand on this some.  If you think about it, any time you store
bytes on something, the storing process has to make a note of where it put
the bytes; maybe how many bytes it put there; if the bytes are not
contiguous, then info about where one set leaves off and where the next set
picks up.  And on and on ...

I've never worked with Oracle raw devices and am just guessing here, but
applying some knowledge about how other forms of storage work, I seems
logical that Oracle would have to "format" the raw device and essentially
create a sort of proprietary "file system" there.  If you just toss some
bytes on a raw device and tell Oracle to go get 'em, then I'm guessing
Oracle will just say something like: "This might be a raw device, but it
ain't no stinkin' ORACLE raw device."

Or, to put it another way: "What's this merde?"  (Pardon my French.)

(You have to wonder if there is an error message *something* like this
buried down in the Oracle kernel by some irreverent programmer.)


> -Original Message-
> From: Stephen Lee 
> Sent: Thursday, June 19, 2003 3:27 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: copy a datafile to a raw device
> 
> 
> 
> Well heck.  Nobody else has replied, so I might take a stab 
> at it here.  I
> suspect that the format of the data (bits and bytes) required on a raw
> device is different than the format of the data in a file in 
> a file system.
> I'm stretching a bit here, but I think an analogy would be 
> what would happen
> if you dd a file from UFS to NTFS.  The data on the NTFS 
> might be a digital
> copy of what was on UFS, but it's format is totally useless 
> in the context
> of NTFS.
> 
> > -Original Message-
> > From: Gurelei [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, June 19, 2003 1:55 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: copy a datafile to a raw device
> > 
> > 
> > hi all:
> > 
> > I need to move a SYSTEM datafile from a filesystem
> > to a raw device. I have shutdown the database,
> > copied the file via
> > 
> > dd if=system of=/dev/raw
> > 
> > renamed the file in the database, but couldn't open
> > the database because of the error: Unknown File Header
> > Version read for file number 1.
> > 
> > I tried another dd:
> > 
> > dd if=system of=/dev/raw obs=32768 (32K is the db
> > block size), but I got the same error. Can anyone
> > see what else could be wrong with my dd command
> > 
> > thanks
> > 
> > Gene
> > 
> > __
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Gurelei
> >   INET: [EMAIL PROTECTED]
> > 
> > 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: [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).
> > 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Stephen Lee
>   INET: [EMAIL PROTECTED]
> 
> 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: [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).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [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: copy a datafile to a raw device

[Gurelei]

Dennis,

Thanks for your input. I am doing what the manual says
- 
shutdown , copy, mount, alter, open and every time
I'm getting the "unknown file header" message. I
suspect that I am missing some parameters in my dd
command because of - as Stephen suggested - different
formats. I guess I will have to play with different
parameters to see which one is correct.

thanks

Gene
--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Gene
>Good ideas from Stephen. A more basic issue if
> you haven't dealt with it
> is that copying a system datafile is different from
> copying other datafiles.
> You can't have the database open. I recall that you
> have to STARTUP MOUNT
> and ALTER DATABASE DATAFILE. This procedure is
> covered in the Oracle
> Manuals. Just thought I should mention this in case
> you hadn't considered
> it.
> 
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 



__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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: [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: Book Recommendation for Apache

[Ron Rogers]

Drums along the mohawk.

>>> [EMAIL PROTECTED] 06/19/03 04:44PM >>>
Hi,

 

Any recommendations on good Apache books?

 

We will be bringing in Oracle 9iAS shortly.  Third party application
constraints require the use of Forms 6i, which in turn requires that
we
stay with 9iAS Release 1 (version 1.0.2.x.x).   We are currently
running
Oracle Application Server.  

 

I want to understand how 9iAS works.  For me, the steps to
understanding
this are something like:

 

1)   Understand HTTP

2)   Understand Apache

3)   Understand 9iAS

 

I have found useful information on the Internet describing the HTTP
protocol, and I am comfortable I understand that well enough to move
on.
Now I want to get a handle on the Apache Server.  I have had a brief
look at a book from O'reilly called "Apache, The Definitive Guide".
This looks like a good book.  

 

Thanks,

 

Sam 

 

p.s. A few months, I read on the List that the Publisher of Tom Kyte's
book ""Expert One-On-One Oracle" has gone bankrupt.  Can anybody
confirm
if this is true?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

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: [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: Read SQL Server from Oracle

[Mandar A. Ghosalkar]

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96544/admi
n.htm#169283

> -Original Message-
> From: Smith, Ron L. [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, June 19, 2003 1:27 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Read SQL Server from Oracle
> 
> 
> I need to be able to read SQL Server tables from an Oracle 
> procedure. Can anyone point me in the right direction for info?
> 
> Ron Smith
> If you are not the intended recipient of this e-mail message, 
> any use, distribution or copying of the message is 
> prohibited.  Please let me know immediately by return e-mail 
> if you have received this message by mistake, then delete the 
> e-mail message. Thank you.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
> 
> 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: [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).
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mandar A. Ghosalkar
  INET: [EMAIL PROTECTED]

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: [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: OEM question

[Niall Litchfield]

Title: Message



You 
are correct about the chicken/egg problem with the repository. You don't 
necessarily require a repository if you are using it as a management console 
rather than an application managament framework. 
 
I have 
tried to automate various things with OEM jobs and events and eventually decided 
that at and dbms_job worked perfectly adequately. bearing in mind that DBMS_JOB 
is - I'm pretty sure - designed by a bunch of sadists who have it in for Admin 
guys this is not a huge recommendation :( 
 
However OEM does allow you to generate a db change and then copy the 
correct sql syntax to your text editor.If your brain is fried this is kinda 
nice. 

Niall 
 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Koivu, LisaSent: 17 June 2003 18:50To: Multiple 
  recipients of list ORACLE-LSubject: OEM 
  question
  Hello all, 
  I'm configuring OEM for the first time.  I see 
  it needs a repository to operate.  So for the db-up functionality, if the 
  database that contains your repository goes down, your db-up function is dead, 
  right?  Sounds like the rman catalog quandry.  YOu have a catalog to 
  backup your database, but then you have to backup your catalog...
  And just as a fyi:  I completed the upgrade 
  from 8.1.7.4->9.2.0.3 on Windows 2000 without incident last night.  It 
  actually went pretty quickly. 
  Thanks in advance for any comments about OEM. 
  
  Lisa Koivu Oracle Database Stressmonkey Fairfield Resorts, Inc. 5259 
  Coconut Creek Parkway Ft. Lauderdale, FL, 
  USA  33063 Office: 954-935-4117  
  Fax:    954-935-3639 
  Cell:    954-683-4459 
  "The sender 
  believes that this E-Mail and any attachments were free of any virus, worm, 
  Trojan horse, and/or malicious code when sent. This message and its 
  attachments could have been infected during transmission.  By reading the 
  message and opening any attachments, the recipient accepts full responsibility 
  for taking proactive and remedial action about viruses and other defects. The 
  sender's business entity is not liable for any loss or damage arising in any 
  way from this message or its attachments."-- Please see 
  the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: 
  [EMAIL PROTECTED] 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: 
  [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: copy a datafile to a raw device

[Kirtikumar Deshpande]

What platform is this on?
On some UNIX platforms the file header for the raw device may vary in size. (It has 
been a while
since I dealt with raw devices). You may have to use seek= option (dd command) to skip 
the header
bytes before actually writing the data using 'dd'.

Or just call Oracle Support.

- Kirti


--- Stephen Lee <[EMAIL PROTECTED]> wrote:
> 
> Well heck.  Nobody else has replied, so I might take a stab at it here.  I
> suspect that the format of the data (bits and bytes) required on a raw
> device is different than the format of the data in a file in a file system.
> I'm stretching a bit here, but I think an analogy would be what would happen
> if you dd a file from UFS to NTFS.  The data on the NTFS might be a digital
> copy of what was on UFS, but it's format is totally useless in the context
> of NTFS.
> 
> > -Original Message-
> > From: Gurelei [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, June 19, 2003 1:55 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: copy a datafile to a raw device
> > 
> > 
> > hi all:
> > 
> > I need to move a SYSTEM datafile from a filesystem
> > to a raw device. I have shutdown the database,
> > copied the file via
> > 
> > dd if=system of=/dev/raw
> > 
> > renamed the file in the database, but couldn't open
> > the database because of the error: Unknown File Header
> > Version read for file number 1.
> > 
> > I tried another dd:
> > 
> > dd if=system of=/dev/raw obs=32768 (32K is the db
> > block size), but I got the same error. Can anyone
> > see what else could be wrong with my dd command
> > 
> > thanks
> > 
> > Gene
> > 
> > 

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

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: [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: copy a datafile to a raw device

[Daniel Fink]

Gene,
I recall a similar scenario (this was Oracle7, so it may not apply). The real 
issue was that oracle uses different file header configurations for cooked and raw 
files when it uses them. I don't think you can copy the file to a raw device and 
expect oracle to be happy about it. I think you will have to recreate the database 
(since it is the system tablespace). If it were another tablespace, I think you could 
get by with just recreating the tablespace.

Daniel Fink


> > -Original Message-
> > From: Gurelei [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, June 19, 2003 1:55 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: copy a datafile to a raw device
> >
> >
> > hi all:
> >
> > I need to move a SYSTEM datafile from a filesystem
> > to a raw device. I have shutdown the database,
> > copied the file via
> >
> > dd if=system of=/dev/raw
> >
> > renamed the file in the database, but couldn't open
> > the database because of the error: Unknown File Header
> > Version read for file number 1.
> >
> > I tried another dd:
> >
> > dd if=system of=/dev/raw obs=32768 (32K is the db
> > block size), but I got the same error. Can anyone
> > see what else could be wrong with my dd command
> >
> > thanks
> >
> > Genebegin:vcard 
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard

RE: copy a datafile to a raw device

[DENNIS WILLIAMS]

Gene
   Good ideas from Stephen. A more basic issue if you haven't dealt with it
is that copying a system datafile is different from copying other datafiles.
You can't have the database open. I recall that you have to STARTUP MOUNT
and ALTER DATABASE DATAFILE. This procedure is covered in the Oracle
Manuals. Just thought I should mention this in case you hadn't considered
it.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, June 19, 2003 3:27 PM
To: Multiple recipients of list ORACLE-L



Well heck.  Nobody else has replied, so I might take a stab at it here.  I
suspect that the format of the data (bits and bytes) required on a raw
device is different than the format of the data in a file in a file system.
I'm stretching a bit here, but I think an analogy would be what would happen
if you dd a file from UFS to NTFS.  The data on the NTFS might be a digital
copy of what was on UFS, but it's format is totally useless in the context
of NTFS.

> -Original Message-
> From: Gurelei [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 1:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: copy a datafile to a raw device
> 
> 
> hi all:
> 
> I need to move a SYSTEM datafile from a filesystem
> to a raw device. I have shutdown the database,
> copied the file via
> 
> dd if=system of=/dev/raw
> 
> renamed the file in the database, but couldn't open
> the database because of the error: Unknown File Header
> Version read for file number 1.
> 
> I tried another dd:
> 
> dd if=system of=/dev/raw obs=32768 (32K is the db
> block size), but I got the same error. Can anyone
> see what else could be wrong with my dd command
> 
> thanks
> 
> Gene
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Gurelei
>   INET: [EMAIL PROTECTED]
> 
> 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: [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).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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: [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).

Book Recommendation for Apache

[Sam Bootsma]

Hi,

 

Any recommendations on good Apache books?

 

We will be bringing in Oracle 9iAS shortly.  Third
party application constraints require the use of Forms 6i, which in turn
requires that we stay with 9iAS Release 1 (version 1.0.2.x.x).   We
are currently running Oracle Application Server.  

 

I want to understand how 9iAS works.  For me, the steps
to understanding this are something like:

 

1)  
Understand HTTP

2)  
Understand Apache

3)  
Understand 9iAS

 

I have found useful information on the Internet describing
the HTTP protocol, and I am comfortable I understand that well enough to move
on.  Now I want to get a handle on the Apache Server.  I have had a
brief look at a book from O’reilly called “Apache, The Definitive
Guide”.  This looks like a good book.  

 

Thanks,

 

Sam 

 

p.s. A few months, I read on the List that the Publisher of Tom Kyte’s
book “"Expert One-On-One
Oracle" has gone bankrupt.  Can anybody confirm if this is true?

RE: Read SQL Server from Oracle

[Paula_Stankus]

Title: RE: Read SQL Server from Oracle





Can use Heterogeo. Services and an ODBC driver (just be careful case-sensitivity is an issue) or pay extra for a Gateway to SQL Server.  

-Original Message-
From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 19, 2003 4:27 PM
To: Multiple recipients of list ORACLE-L
Subject: Read SQL Server from Oracle



I need to be able to read SQL Server tables from an Oracle procedure.
Can anyone point me in the right direction for info?


Ron Smith
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.  Please let me know
immediately by return e-mail if you have received this message by mistake,
then delete the e-mail message. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]


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: [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: copy a datafile to a raw device

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: copy a datafile to a raw device





It's been a number of years since I did anything with
raw devices, so this is all ancient and possibly 
out of date/incorrect.


I believe Stephen to be wrong.  The bits and bytes
written on the data file are identical, regardless of
whether the device is raw or cooked.  However, 
back in the day I worked with these, the file could not use
the first block of the raw device, as that was reserved for
operating system usage (and back then on those devices, this was
8K).  So, we had to do something like 


dd if=system of=/dev/raw obs=8192 seek=1


to force the dd to skip the first 8K.  


Since you have already overwritten the first block of the raw
device, you might have to drop it and re-create it.


Also, since the first 8K was reserved for the OS, the size of 
the raw device must be at LEAST the size of the datafile + 8K.


Matt



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Another month has ended.
All Targets Met. All Systems Working.
All Customers Satisfied. All Staff Enthusiastic. 
All Pigs Fed And Ready To Fly.


-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 19, 2003 4:27 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: copy a datafile to a raw device




Well heck.  Nobody else has replied, so I might take a stab at it here.  I
suspect that the format of the data (bits and bytes) required on a raw
device is different than the format of the data in a file in a file system.
I'm stretching a bit here, but I think an analogy would be what would happen
if you dd a file from UFS to NTFS.  The data on the NTFS might be a digital
copy of what was on UFS, but it's format is totally useless in the context
of NTFS.


> -Original Message-
> From: Gurelei [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 19, 2003 1:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: copy a datafile to a raw device
> 
> 
> hi all:
> 
> I need to move a SYSTEM datafile from a filesystem
> to a raw device. I have shutdown the database,
> copied the file via
> 
> dd if=system of=/dev/raw
> 
> renamed the file in the database, but couldn't open
> the database because of the error: Unknown File Header
> Version read for file number 1.
> 
> I tried another dd:
> 
> dd if=system of=/dev/raw obs=32768 (32K is the db
> block size), but I got the same error. Can anyone
> see what else could be wrong with my dd command
> 
> thanks
> 
> Gene
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Gurelei
>   INET: [EMAIL PROTECTED]
> 
> 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: [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).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]


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: [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: INDEX REBUILD

[DENNIS WILLIAMS]

Guang - Below is what Jared said on this topic:

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, December 26, 2002 9:14 PM
To: Multiple recipients of list ORACLE-L

Though I have published a script for determining indexes that
need to be rebuilt, and then rebuilding them,  I have to say that
this is almost never necessary.

Why are you rebuilding indexes?  About the only reason for ever
doing so is that the BLEVEL >= 5.

go to asktom.oracle.com, and do a search on 'index rebuild'.

Currently, the third article may be of interest.

Jared

-Original Message-
Sent: Thursday, June 19, 2003 12:34 PM
To: Multiple recipients of list ORACLE-L


Where can I find more detail info about "frequent index rebuilds can reduce
your performance" ?

Thanks.

Guang

-Original Message-
Sent: Thursday, June 19, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L

Seema - If you analyze in conjunction with rebuilds, you could track with
the LAST_ANALYZED column in USER_INDEXES table. That is all I can think of.
Why do you ask? Jared has spoken eloquently about how frequent index
rebuilds can reduce your performance.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: [EMAIL PROTECTED]

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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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: [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: oracle authentication from windows

[AK]

Got it . Thanks Arup .

  - Original Message - 
  From: 
  Arup Nanda 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, June 19, 2003 12:45 
  PM
  Subject: Re: oracle authentication from 
  windows
  
  Sure.
   
  Just declare these in your init.ora
   
  os_authent_prefix=OPS$remote_os_authent=TRUE
   
  bounce the database, add a user called 
  OPS$, e.g. OPS$AK if your Windows login id is AK 
  as
   
  create user ops$ak identified 
  externally
   
  From windows connect as "/@servicename", 
  e.g. sqlplus /@service1
   
  If it doesn't work, the OS user may be different. 
  Use this query while connected to the database from Windows 
  cleint.
   
  SQL> select sys_context('USERENV','OS_USER') 
  from dual;
   
  See what OS username comes up; use that 
  instead.
   
  HTH.
   
  Arup Nanda
  www.proligence.com
   
   
  
- Original Message - 
From: 
AK 

To: Multiple recipients of list ORACLE-L 

Sent: Thursday, June 19, 2003 1:10 
PM
Subject: oracle authentication from 
windows

We want our client users ( forms user )  
to just enter windows password and then automatically able to get in to 
oracle .Is there a way oracle can authenticate from windows ( or active 
directory ) . enbadding password in runform.exe not an option .
 
thanks,
-ak

Re: Re: Passwords and authentication

[Arup Nanda]

Title: Passwords and authentication



The book is called "HIPAA Security and Auditing for 
Oracle".from Rampant TechPress. Although it is targeted towards the 
organizations and individuals in US healthcare scene affected  by the new 
law HIPAA, the books is a handbook for security and auditing in Oracle 
context with lots of scripts and real life examples. Don Burleson is the 
co-author and we are trying to cover the details of security and auditing as 
related to Oracle DBAs, developers and architects, leaving the stuff 
related to other professionals, e.g. firewall setup, etc.
 
You can find an abstract of the book at http://www.dba-oracle.com/bp/bp_book11_audit.htm. 
The target date is September from Rampant website and December everywhere 
else.

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, June 19, 2003 3:59 
  PM
  Subject: Re: Re: Passwords and 
  authentication
  what will be the name of your book? when will it be out? you 
  have an extract of what it will cover yet? > > From: "Arup 
  Nanda" <[EMAIL PROTECTED]>> Date: 
  2003/06/19 Thu PM 03:31:43 EDT> To: Multiple recipients of list 
  ORACLE-L <[EMAIL PROTECTED]>> 
  Subject: Re: Passwords and authentication> > Passwords and 
  authenticationMladen,> > Thanks for bringing it up. In my book I 
  will cover the VPD (vitual private database) in detail and will explain how to 
  use the application user model into making a secure authentication and 
  authorization model. Label security is nothing but a specialized tool based on 
  the more general VPD. Most security conscious organizations will probably like 
  VPD more as it provides more flexibility in defining who sees what? OLS is 
  narrower in focus, a carry over from the old CIA project where each record in 
  a table was treated like a file with a security level and persons were 
  assigned cklearance levels. The check was whether user's clearance is greater 
  than or equal to the record's (or the docuemnts) clearance. The authorization 
  requirements were simple.> > Most real life system will most 
  likely have different and more complex requirements, though. Instead of plain 
  simple levels, your records will have to be verified against a lot of 
  parameters. For instance, in your database (Oxford Health), you may have a 
  senior business analyst (John Napoli) with authorization to see claims that 
  are (i) from a list of providers he is approved to see, (ii) below $1, 
  (iii) for procedure codes that are not protected by HIPAA's protected health 
  information and perhaps a lot more. This is not as simple as assigning a level 
  to a row, but a rather complicated set of where conditions applied at the 
  runtime. VPD addresses that issue. Along with application context, you will 
  have the toolbox to build a complete iron-clad authentication and 
  authorization system.> > Hope this helps.> > Arup 
  Nanda> www.proligence.com> > > 
  >   - Original Message - >   From: 
  Gogala, Mladen >   To: Multiple recipients of list ORACLE-L 
  >   Sent: Thursday, June 19, 2003 12:45 
  PM>   Subject: RE: Passwords and authentication> 
  > >   There is also label security option which is 
  present on Enterprise Edition CD. That would >   alleviate 
  the need for manual encryption because the table cannot be seen unless there 
  is>   sufficient security clearance. Also, logging in from 
  SQL*Plus can be disabled from the USER_PRODUCT_PROFILE. Connected to that, is 
  anybody on this list using label>   security? Does anybody 
  have experience with it? Arup, you are writing a book about security 
  >   in Oracle 9.2  and I hope that you will cover label 
  security.> >   Mladen Gogala >   
  Oracle DBA >   Phone:(203) 459-6855 >   
  Email:[EMAIL PROTECTED] > > -Original 
  Message-> From: Arup Nanda 
  [mailto:[EMAIL PROTECTED]> Sent: Thursday, 
  June 19, 2003 12:15 PM> To: Multiple recipients 
  of list ORACLE-L> Subject: Re: Passwords and 
  authentication> > > Raj,> 
  > My first question will be how you would want 
  to pass the encrypted password. sqlplus /? 
  But won't the encrypted password be known before making the connection? If so, 
  then the user who will encrypt the password will also know how to decrypt 
  them. What's the advantage in doing that?> 
  > Are you concerned someone sniffing the 
  network uncovers a clear password? If so, have you considered network security 
  with password encryption by Oracle Net?> 
  > If that is not the concern but rather you 
  don't want the users to know the real password, here is a solution you might 
  be interested. It's part of a elaborate application security design. Please 
  read on if you are interested.> > You 
  would have user called SECUSER with only table APP_USERS. The table has two 
  columns - APP_USER and APP_PASS, in encrypted manner, with Triple DES 
  Encryption. The

Read SQL Server from Oracle

[Smith, Ron L.]

I need to be able to read SQL Server tables from an Oracle procedure.
Can anyone point me in the right direction for info?

Ron Smith
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.  Please let me know
immediately by return e-mail if you have received this message by mistake,
then delete the e-mail message. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

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: [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: oracle authentication from windows

[Gogala, Mladen]

That, 
of course, will render your database totally insecure and open to anybody 

who 
can bring in a WinXP laptop, change the windoze username and log in as he 
pleases.
DBA 
that sets his production parameters the way Arup described deserves to be 

publicly tortured by Bill O'Reilly in the "no spin 
zone".
 
Mladen Gogala Oracle DBA Phone:(203) 459-6855 
Email:[EMAIL PROTECTED] 

  -Original Message-From: Arup Nanda 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 3:46 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  oracle authentication from windows
  Sure.
   
  Just declare these in your init.ora
   
  os_authent_prefix=OPS$remote_os_authent=TRUE
   
  bounce the database, add a user called 
  OPS$, e.g. OPS$AK if your Windows login id is AK 
  as
   
  create user ops$ak identified 
  externally
   
  From windows connect as "/@servicename", 
  e.g. sqlplus /@service1
   
  If it doesn't work, the OS user may be different. 
  Use this query while connected to the database from Windows 
  cleint.
   
  SQL> select sys_context('USERENV','OS_USER') 
  from dual;
   
  See what OS username comes up; use that 
  instead.
   
  HTH.
   
  Arup Nanda
  www.proligence.com
   
   
  
- Original Message - 
From: 
AK 

To: Multiple 
recipients of list ORACLE-L 
Sent: Thursday, June 19, 2003 1:10 
PM
Subject: oracle authentication from 
windows

We want our client users ( forms user )  
to just enter windows password and then automatically able to get in to 
oracle .Is there a way oracle can authenticate from windows ( or active 
directory ) . enbadding password in runform.exe not an option .
 
thanks,
-ak

RE: copy a datafile to a raw device

[Stephen Lee]

Well heck.  Nobody else has replied, so I might take a stab at it here.  I
suspect that the format of the data (bits and bytes) required on a raw
device is different than the format of the data in a file in a file system.
I'm stretching a bit here, but I think an analogy would be what would happen
if you dd a file from UFS to NTFS.  The data on the NTFS might be a digital
copy of what was on UFS, but it's format is totally useless in the context
of NTFS.

> -Original Message-
> From: Gurelei [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 1:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: copy a datafile to a raw device
> 
> 
> hi all:
> 
> I need to move a SYSTEM datafile from a filesystem
> to a raw device. I have shutdown the database,
> copied the file via
> 
> dd if=system of=/dev/raw
> 
> renamed the file in the database, but couldn't open
> the database because of the error: Unknown File Header
> Version read for file number 1.
> 
> I tried another dd:
> 
> dd if=system of=/dev/raw obs=32768 (32K is the db
> block size), but I got the same error. Can anyone
> see what else could be wrong with my dd command
> 
> thanks
> 
> Gene
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Gurelei
>   INET: [EMAIL PROTECTED]
> 
> 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: [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).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [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: Re: Passwords and authentication

[Stephen Lee]

http://www.dba-oracle.com/bp/bp_titles.htm

Look about in the middle of the page.

> -Original Message-
> what will be the name of your book? when will it be out? you 
> have an extract of what it will cover yet? 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [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: Passwords and authentication

[Gogala, Mladen]

Title: Passwords and authentication



Bummer! I was hoping for a commission from 
Oracle!
 
Mladen Gogala Oracle DBA Phone:(203) 459-6855 
Email:[EMAIL PROTECTED] 

  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 
  3:18 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Passwords and authentication
  Label Security = 
   
  Sometimes we need to compile forms against production instance (please 
  don't ask) to resolve some really stupid issues. When compiling, the form has 
  to be compiled with schema owner (again don't ask). As the production schema 
  are locked down, we need a way to connect to compile. I do not want to set-up 
  an elaborate scheme as mentioned by Arup, because this will _NOT_ be a regular 
  feature.
   
  This all came into picture because the new release mechanism that we 
  are testing ... you check in a form into PVCS, as it gets promoted to R_F_P, 
  the DBAs would check it out, compile it and release it. And all three 
  processes will be managed by event triggers in PVCS. The main use of using 
  encrypted connection to connect to db is to compile forms and reports (from 
  windows platform).
   
  Ok well, seems like a bit of impossible task to me ... to connect using 
  the encrypted value from dba_users view.
  Thanks for the ideas though ...
  Raj
   
  Rajendra dot Jamadagni at nospamespn dot 
  com All Views expressed in this 
  email are strictly personal. QOTD: 
  Any clod can have facts, having an opinion is an art ! 
  
-Original Message-From: Gogala, Mladen 
[mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 12:45 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Passwords and authentication
There is also label security option which is 
present on Enterprise Edition CD. That would 
alleviate the need for manual encryption because 
the table cannot be seen unless there is
sufficient security clearance. Also, logging in 
from SQL*Plus can be disabled from the USER_PRODUCT_PROFILE. Connected to 
that, is anybody on this list using label
security? Does anybody have experience with it? 
Arup, you are writing a book about security 
in 
Oracle 9.2  and I hope that you will cover label 
security.
 
Mladen Gogala Oracle DBA Phone:(203) 
459-6855 Email:[EMAIL PROTECTED] 


  -Original Message-From: Arup Nanda 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 12:15 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: Passwords and authentication
  Raj,
   
  My first question will be how you 
  would want to pass the encrypted password. sqlplus 
  /? But won't the encrypted password be 
  known before making the connection? If so, then the user who will encrypt 
  the password will also know how to decrypt them. What's the advantage in 
  doing that?
   
  Are you concerned someone sniffing the 
  network uncovers a clear password? If so, have you considered network 
  security with password encryption by Oracle Net?
   
  If that is not the concern but rather you 
  don't want the users to know the real password, here is a solution you 
  might be interested. It's part of a elaborate application security design. 
  Please read on if you are interested.
   
  You would have user called SECUSER with only 
  table APP_USERS. The table has two columns - APP_USER and APP_PASS, in 
  encrypted manner, with Triple DES Encryption. The user also has one 
  function - check_app_password, which accepts two parameters - the userid 
  and the password and returns a string. The return value is YES is the 
  password supplied is correct and NO, if it isn't. It does not shw the 
  correct password, ever; just shows if the supplied password is correct or 
  not. This function is defined as DEFINER rights. All users get an execute 
  privilege on this function, nothing else on the rest of the objects of the 
  SECUSER user.
   
  Inside the function, the password is 
  retrieved from the table, decrypted with the key inside the procedure and 
  matched with the supplied one. Another function is provided to encrypt the 
  password using teh same key. For more ecurity, the userid and password 
  combination can encrypted, not just the password. If you want I can give 
  you the code for the functions.
   
  When the app user connects, the connection is 
  done through a generic id, that, after the conenction, validates the 
  password using the function and authenticates the user. If the password is 
  not correct, the user is booted out.
   
  Now comes other issues - fine grained access 
  control and fine grained audi

Re: Re: Passwords and authentication

[rgaffuri]

what will be the name of your book? when will it be out? you have an extract of what 
it will cover yet? 
> 
> From: "Arup Nanda" <[EMAIL PROTECTED]>
> Date: 2003/06/19 Thu PM 03:31:43 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Passwords and authentication
> 
> Passwords and authenticationMladen,
> 
> Thanks for bringing it up. In my book I will cover the VPD (vitual private database) 
> in detail and will explain how to use the application user model into making a 
> secure authentication and authorization model. Label security is nothing but a 
> specialized tool based on the more general VPD. Most security conscious 
> organizations will probably like VPD more as it provides more flexibility in 
> defining who sees what? OLS is narrower in focus, a carry over from the old CIA 
> project where each record in a table was treated like a file with a security level 
> and persons were assigned cklearance levels. The check was whether user's clearance 
> is greater than or equal to the record's (or the docuemnts) clearance. The 
> authorization requirements were simple.
> 
> Most real life system will most likely have different and more complex requirements, 
> though. Instead of plain simple levels, your records will have to be verified 
> against a lot of parameters. For instance, in your database (Oxford Health), you may 
> have a senior business analyst (John Napoli) with authorization to see claims that 
> are (i) from a list of providers he is approved to see, (ii) below $1, (iii) for 
> procedure codes that are not protected by HIPAA's protected health information and 
> perhaps a lot more. This is not as simple as assigning a level to a row, but a 
> rather complicated set of where conditions applied at the runtime. VPD addresses 
> that issue. Along with application context, you will have the toolbox to build a 
> complete iron-clad authentication and authorization system.
> 
> Hope this helps.
> 
> Arup Nanda
> www.proligence.com
> 
> 
> 
>   - Original Message - 
>   From: Gogala, Mladen 
>   To: Multiple recipients of list ORACLE-L 
>   Sent: Thursday, June 19, 2003 12:45 PM
>   Subject: RE: Passwords and authentication
> 
> 
>   There is also label security option which is present on Enterprise Edition CD. 
> That would 
>   alleviate the need for manual encryption because the table cannot be seen unless 
> there is
>   sufficient security clearance. Also, logging in from SQL*Plus can be disabled from 
> the USER_PRODUCT_PROFILE. Connected to that, is anybody on this list using label
>   security? Does anybody have experience with it? Arup, you are writing a book about 
> security 
>   in Oracle 9.2  and I hope that you will cover label security.
> 
>   Mladen Gogala 
>   Oracle DBA 
>   Phone:(203) 459-6855 
>   Email:[EMAIL PROTECTED] 
> 
> -Original Message-
> From: Arup Nanda [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 12:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Passwords and authentication
> 
> 
> Raj,
> 
> My first question will be how you would want to pass the encrypted password. 
> sqlplus /? But won't the encrypted password be known before 
> making the connection? If so, then the user who will encrypt the password will also 
> know how to decrypt them. What's the advantage in doing that?
> 
> Are you concerned someone sniffing the network uncovers a clear password? If so, 
> have you considered network security with password encryption by Oracle Net?
> 
> If that is not the concern but rather you don't want the users to know the real 
> password, here is a solution you might be interested. It's part of a elaborate 
> application security design. Please read on if you are interested.
> 
> You would have user called SECUSER with only table APP_USERS. The table has two 
> columns - APP_USER and APP_PASS, in encrypted manner, with Triple DES Encryption. 
> The user also has one function - check_app_password, which accepts two parameters - 
> the userid and the password and returns a string. The return value is YES is the 
> password supplied is correct and NO, if it isn't. It does not shw the correct 
> password, ever; just shows if the supplied password is correct or not. This function 
> is defined as DEFINER rights. All users get an execute privilege on this function, 
> nothing else on the rest of the objects of the SECUSER user.
> 
> Inside the function, the password is retrieved from the table, decrypted with 
> the key inside the procedure and matched with the supplied one. Another function is 
> provided to encrypt the password using teh same key. For more ecurity, the userid 
> and password combination can encrypted, not just the password. If you want I can 
> give you the code for the functions.
> 
> When the app user connects, the connection is done through a generic id, that, 
> after the conenction, validates the password using the fun

RE: World premier performance of the BAARF party logo

[MacGregor, Ian A.]

There is no question that RAID 10 performs  better than RAID 5.  But it highly 
questionable that every Oracle database requires RAID 10 for all its data files.  
Though I'd never consider putting redo logs on RAID 5  

Also, often the  DBA has no clue about what type of disk throughput is needed.  Not 
because the DBA is ignorant, but extracting the information from the potential users 
which  enables the DBA to arrive at an estimate is far too often close to impossible.


Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Sunday, June 15, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L


Mladen - I would propose another theory. Please consider this rant for entertainment 
value, and hopefully to consider a book on this topic.
   Usually companies request bids from several vendors. If you as a storage 
salesperson always bid RAID1+0, you will always be underbid by your competitors, 
receive no commissions, and in the end be fired. If you always bid RAID5, you will 
probably receive some business, some commissions, and keep your job. Now, pretend I'm 
a storage system salesperson. Which system am I going to specify to the customer? 
Now, if the customer insists on purchasing RAID1+0 or whatever, I'll probably argue a 
little because I've been stung before where I was suckered into bidding RAID1+0 and 
then my ignoramus competitor just blindly quoted RAID5 and when it bubbled up to the 
V.P. he asked "why are you going with the more expensive vendor"? And trying to quote 
a salesperson isn't a good move at that point.
   I thought Rachel had a good point on this topic awhile back. If you are a top-notch 
consultant that is often called in to solve performance problems, you have often cured 
them by switching from RAID5. So you have a lot of confidence in it. But if you are 
the lowly on-site DBA just trying to hang onto your job in the political turbulence, 
you usually don't have enough facts to challenge the system administrators who trust 
their storage vendors a lot more than a DBA that couldn't actually configure a storage 
system to save his or her life.
   So suppose I do try to challenge the system administrators. I say that
RAID1+0 will write faster than RAID5. The reply is "okay how much 
RAID1+faster?" I
mumble that I've never seen any actual figures published anywhere. He or she says 
maybe at the low level there is a slight advantage to RAID1+0, but with a gig of 
battery-backed cache that won't be true. Or he or she asks "What does Oracle 
recommend?". And on it goes.
   Okay, I'm being provocative here. But how do I, a lowly DBA, prove which is faster? 
Should I talk my system administrator into going to the trouble of configuring a 
system both ways and run some tests? What type of tests would be most useful? If I 
choose the wrong test, and RAID5 looks just as good as RAID1+0, I'm sunk. Then for 
years to come when I try to make a point at a meeting someone will say "yeah, is this 
another RAID1+0 theory?"

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Sunday, June 15, 2003 2:49 AM
To: Multiple recipients of list ORACLE-L


RAID-5 microkernel has more lines of code then Oracle7? Wow! This is an astonishing 
piece of information and if it wasn't coming from you, I'd dismiss it as yet another 
conspiracy theory.

On 2003.06.15 01:44, Cary Millsap wrote:
> > Meanwhile I have never understood why storage vendors would prefer 
> > selling RAID5 over RAID10.
> 
> ...Because if they don't sell RAID5, they don't recover the R&D costs 
> of creating a RAID5 microkernel that has more lines of code than the 
> Oracle7 executable. I'm not kidding.
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Hotsos Clinic 101 in Dallas, Washington, Denver, Sydney
> - Hotsos Symposium 2004, March 7-10 Dallas
> - Visit www.hotsos.com for schedule details...
> 
> 
> -Original Message-
> Niall Litchfield
> Sent: Thursday, June 12, 2003 12:05 PM
> To: Multiple recipients of list ORACLE-L
> 
> Jared writes
> > At the meeting last week I wore my 'No RAID 5' hat.
> >
> > Those of you at IOUG 99 in Denver may have seen it, I
> > wore it every day there.  ;)
> 
> I'm curious now. Pictures required.
> 
> Meanwhile I have never understood why storage vendors would prefer 
> selling RAID5 over RAID10. More disks=more profit surely? Also 10 > 5 
> therefore self evidently twice as good for all applications. Meanwhile 
> we have this strange situation where performance consultants are 
> publicising the fact that you have less need for performance 
> consultants with RAID10 than with RAID5.
> 
> Niall
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Niall Litchfield
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hos

Re: oracle authentication from windows

[Arup Nanda]

Sure.
 
Just declare these in your init.ora
 
os_authent_prefix=OPS$remote_os_authent=TRUE
 
bounce the database, add a user called OPS$, e.g. OPS$AK if your Windows login id is AK as
 
create user ops$ak identified 
externally
 
From windows connect as "/@servicename", 
e.g. sqlplus /@service1
 
If it doesn't work, the OS user may be different. 
Use this query while connected to the database from Windows cleint.
 
SQL> select sys_context('USERENV','OS_USER') 
from dual;
 
See what OS username comes up; use that 
instead.
 
HTH.
 
Arup Nanda
www.proligence.com
 
 

  - Original Message - 
  From: 
  AK 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, June 19, 2003 1:10 
  PM
  Subject: oracle authentication from 
  windows
  
  We want our client users ( forms user )  to 
  just enter windows password and then automatically able to get in to oracle 
  .Is there a way oracle can authenticate from windows ( or active directory ) . 
  enbadding password in runform.exe not an option .
   
  thanks,
  -ak

RE: data architecture/conferences/documents/lists

[DENNIS WILLIAMS]

Paula - My impression is that the data architecture arena is now split
between OLTP (normalized) and DW (star schema), with different mindsets
accordingly. The best resource for normalized data modeling that I have
found is:
The Data Modeling Handbook by Michael C. Reingruber and William W. Gregory
For Star schema I think Ralph Kimball is the place to start. 



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, June 19, 2003 2:11 PM
To: Multiple recipients of list ORACLE-L



Interested in data architecture issues beyond a particular RDBMS (sorry guys
just have to be) and I was wondering if anyone had any good resources:

-listservers 
-conferences (what are the best for a ltd. budget) 
-good books/articles/magazines 

I just received a request about 

"The Next Big Thing Panel was part of the Wilshire Meta-Data Conference and
DAMA International Symposium - the world's largest and most authoritative
vendor-neutral data management conference. If you missed this event and
would like to order the documentation, please visit the conference home
page."

Anyone know if this is worth going to?  It looks very interesting. 

Thanks, 
Paula 

-Original Message- 
 ] 
Sent: Wednesday, August 14, 2002 11:24 AM 
To: Multiple recipients of list ORACLE-L 


Srinivas 
   It would help if we knew what you were trying to achieve. Is this some 
type of security solution? My guess is that the oracle binary will get 
Oracle started, but maybe it would be simplest if you just tried it. I will 
warn you of one thing. If the oracle binary isn't setuid to root, you get a 
situation where only the Oracle user can execute it. 
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 


-Original Message- 
Sent: Wednesday, August 14, 2002 2:08 AM 
To: Multiple recipients of list ORACLE-L 


Hello All, 

I am curious to know what are the executables that are 
used when we say startup/shutdown of oracle database 
on Sun box. 

I think it is $ORACLE_HOME/bin/oracle 

are there any other executables/kernel files 
(important) in bin or in anyother areas. 

Can somebody throw somelight ??/ 

Thanks in advance, 
Srinivas 

__ 
Do You Yahoo!? 
HotJobs - Search Thousands of New Jobs 
http://www.hotjobs.com   
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: kommareddy sreenivasa 
  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). 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: DENNIS WILLIAMS 
  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). 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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: [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: Passwords and authentication

[Arup Nanda]

Reginald,

Could you explain how, please.

Arup
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 12:05 PM


>
> Yes it is.
>
> RWB
>


>
> Reginald W. Bailey
> IBM Global Services - ETS SW GDSD - Database Management
> Your Friendly Neighborhood DBA
> 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
>


>
>
>
> Rajendra.Jamadagn
> [EMAIL PROTECTED]  To: [EMAIL PROTECTED]
> Sent by:cc:
> [EMAIL PROTECTED]   Subject: Passwords and
authentication
> .com
>
>
> 06/19/2003 08:19
> AM
> Please respond to
> ORACLE-L
>
>
>
>
>
>
>
>
> Is it possible to connect to database using encrypted passwords? Using
> sqlplus?
>
> Thanks
> Raj
> --
--
>
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
>
> (See attached file: ESPN_Disclaimer.txt)
>
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

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: [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: IO Topology Anyone???

[Anjo Kolk]

Yes, there is file mapping that works with 9ir2 and veritas.

Anjo.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 7:55 PM


> Anyone use the IO Topology features with Oracle9iR2 and Veritas? Does
> Veritas have a mapping file that you can use with this feature? (I've
posed
> the same question with Veritas, so it's a race to the answer!) Any
> experiences you can share about this feature?
>
> Robert
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Freeman Robert - IL
>   INET: [EMAIL PROTECTED]
>
> 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: [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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anjo Kolk
  INET: [EMAIL PROTECTED]

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: [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: recreating a create database file

[Ruth Gramolini]

Thanks, Mladen.  I will look forward to it.  Meanwhile, I at least have
something to recreate them as they are.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 12:40 PM


> I have it at home. It's a modified version of the script
> in Orac_Dba, concocted by Jared Still and Andy Duncan. You
> can get the script from CPAN and I'll send you my version
> when I get home. I've even sent it to Jared and Andy, but I
> don't have time to maintain Orac_Dba right now. May be Jared
> has it somewhere at hand.
>
> Mladen Gogala
> Oracle DBA
> Phone:(203) 459-6855
> Email:[EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Tuesday, June 17, 2003 10:09 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Good morning all,
>
> Somehow all of my scripts to create the databases on my 9i sandbox have
> disappeared.  Does anyone have a script or trick or something to recreate
> these files?  I could recreate them manually but I am somewhat of a time
> crunch.
>
> Thanks in advance,
> Ruth
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
>
> 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: [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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Gogala, Mladen
>   INET: [EMAIL PROTECTED]
>
> 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: [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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

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: [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: Passwords and authentication

[Arup Nanda]

Title: Passwords and authentication



Mladen,
 
Thanks for bringing it up. In my book I will cover 
the VPD (vitual private database) in detail and will explain how to use the 
application user model into making a secure authentication and authorization 
model. Label security is nothing but a specialized tool based on the more 
general VPD. Most security conscious organizations will probably like VPD 
more as it provides more flexibility in defining who sees what? OLS is narrower 
in focus, a carry over from the old CIA project where each record in a table was 
treated like a file with a security level and persons were assigned cklearance 
levels. The check was whether user's clearance is greater than or equal to the 
record's (or the docuemnts) clearance. The authorization requirements were 
simple.
 
Most real life system will most likely have 
different and more complex requirements, though. Instead of plain simple levels, 
your records will have to be verified against a lot of parameters. For instance, 
in your database (Oxford Health), you may have a senior business analyst (John 
Napoli) with authorization to see claims that are (i) from a list of providers 
he is approved to see, (ii) below $1, (iii) for procedure codes that are not 
protected by HIPAA's protected health information and perhaps a lot more. This 
is not as simple as assigning a level to a row, but a rather complicated set of 
where conditions applied at the runtime. VPD addresses that issue. Along with 
application context, you will have the toolbox to build a complete 
iron-clad authentication and authorization system.
 
Hope this helps.
 
Arup Nanda
www.proligence.com
 
 
 

  - Original Message - 
  From: 
  Gogala, Mladen 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, June 19, 2003 12:45 
  PM
  Subject: RE: Passwords and 
  authentication
  
  There is also label security option which is present 
  on Enterprise Edition CD. That would 
  alleviate the need for manual encryption because the 
  table cannot be seen unless there is
  sufficient security clearance. Also, logging in from 
  SQL*Plus can be disabled from the USER_PRODUCT_PROFILE. Connected to that, is 
  anybody on this list using label
  security? Does anybody have experience with it? Arup, 
  you are writing a book about security 
  in 
  Oracle 9.2  and I hope that you will cover label 
  security.
   
  Mladen Gogala Oracle DBA Phone:(203) 
  459-6855 Email:[EMAIL PROTECTED] 
  
-Original Message-From: Arup Nanda 
[mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 12:15 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
Passwords and authentication
Raj,
 
My first question will be how you 
would want to pass the encrypted password. sqlplus 
/? But won't the encrypted password be 
known before making the connection? If so, then the user who will encrypt 
the password will also know how to decrypt them. What's the advantage in 
doing that?
 
Are you concerned someone sniffing the network 
uncovers a clear password? If so, have you considered network security with 
password encryption by Oracle Net?
 
If that is not the concern but rather you don't 
want the users to know the real password, here is a solution you might be 
interested. It's part of a elaborate application security design. Please 
read on if you are interested.
 
You would have user called SECUSER with only 
table APP_USERS. The table has two columns - APP_USER and APP_PASS, in 
encrypted manner, with Triple DES Encryption. The user also has one function 
- check_app_password, which accepts two parameters - the userid and the 
password and returns a string. The return value is YES is the password 
supplied is correct and NO, if it isn't. It does not shw the correct 
password, ever; just shows if the supplied password is correct or not. This 
function is defined as DEFINER rights. All users get an execute privilege on 
this function, nothing else on the rest of the objects of the SECUSER 
user.
 
Inside the function, the password is retrieved 
from the table, decrypted with the key inside the procedure and matched with 
the supplied one. Another function is provided to encrypt the password using 
teh same key. For more ecurity, the userid and password combination can 
encrypted, not just the password. If you want I can give you the code for 
the functions.
 
When the app user connects, the connection is 
done through a generic id, that, after the conenction, validates the 
password using the function and authenticates the user. If the password is 
not correct, the user is booted out.
 
Now comes other issues - fine grained access 
control and fine grained auditing. These features need to have a sepcific 
named database user. However, that can be easily fixed by s

RE: Passwords and authentication

[Jamadagni, Rajendra]

Title: Passwords and authentication



Label Security = 
 
Sometimes we need to compile forms against production instance (please 
don't ask) to resolve some really stupid issues. When compiling, the form has to 
be compiled with schema owner (again don't ask). As the production schema are 
locked down, we need a way to connect to compile. I do not want to set-up an 
elaborate scheme as mentioned by Arup, because this will _NOT_ be a regular 
feature.
 
This all came into picture because the new release mechanism that we are 
testing ... you check in a form into PVCS, as it gets promoted to R_F_P, the 
DBAs would check it out, compile it and release it. And all three processes will 
be managed by event triggers in PVCS. The main use of using encrypted connection 
to connect to db is to compile forms and reports (from windows 
platform).
 
Ok well, seems like a bit of impossible task to me ... to connect using 
the encrypted value from dba_users view.
Thanks for the ideas though ...
Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  -Original Message-From: Gogala, Mladen 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 12:45 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Passwords and authentication
  There is also label security option which is present 
  on Enterprise Edition CD. That would 
  alleviate the need for manual encryption because the 
  table cannot be seen unless there is
  sufficient security clearance. Also, logging in from 
  SQL*Plus can be disabled from the USER_PRODUCT_PROFILE. Connected to that, is 
  anybody on this list using label
  security? Does anybody have experience with it? Arup, 
  you are writing a book about security 
  in 
  Oracle 9.2  and I hope that you will cover label 
  security.
   
  Mladen Gogala Oracle DBA Phone:(203) 
  459-6855 Email:[EMAIL PROTECTED] 
  
-Original Message-From: Arup Nanda 
[mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 12:15 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
Passwords and authentication
Raj,
 
My first question will be how you 
would want to pass the encrypted password. sqlplus 
/? But won't the encrypted password be 
known before making the connection? If so, then the user who will encrypt 
the password will also know how to decrypt them. What's the advantage in 
doing that?
 
Are you concerned someone sniffing the network 
uncovers a clear password? If so, have you considered network security with 
password encryption by Oracle Net?
 
If that is not the concern but rather you don't 
want the users to know the real password, here is a solution you might be 
interested. It's part of a elaborate application security design. Please 
read on if you are interested.
 
You would have user called SECUSER with only 
table APP_USERS. The table has two columns - APP_USER and APP_PASS, in 
encrypted manner, with Triple DES Encryption. The user also has one function 
- check_app_password, which accepts two parameters - the userid and the 
password and returns a string. The return value is YES is the password 
supplied is correct and NO, if it isn't. It does not shw the correct 
password, ever; just shows if the supplied password is correct or not. This 
function is defined as DEFINER rights. All users get an execute privilege on 
this function, nothing else on the rest of the objects of the SECUSER 
user.
 
Inside the function, the password is retrieved 
from the table, decrypted with the key inside the procedure and matched with 
the supplied one. Another function is provided to encrypt the password using 
teh same key. For more ecurity, the userid and password combination can 
encrypted, not just the password. If you want I can give you the code for 
the functions.
 
When the app user connects, the connection is 
done through a generic id, that, after the conenction, validates the 
password using the function and authenticates the user. If the password is 
not correct, the user is booted out.
 
Now comes other issues - fine grained access 
control and fine grained auditing. These features need to have a sepcific 
named database user. However, that can be easily fixed by setting up an 
application context and passing the app_user value to a context attribute. 
This attribute can now be tracked, rather than the userid.
 
Hope this helps.
 
Arup Nanda
www.proligence.com

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Thursday, June 19, 2003 9:19 
  AM
 

Re: recreating a create database file

[Ruth Gramolini]

I just logged on to sqlplus using the logon / as 
sysdba and did an 'alter controlfile backup controlfile to trace;'  This 
creates a file in your dump destination.  Then you can recreate the db 
using this file.  
 
HTH,
Ruth

  - Original Message - 
  From: 
  laura pena 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, June 17, 2003 1:29 
PM
  Subject: Re: recreating a create database 
  file
  
   
  Ruth,
  Ummm how did you do this in 9i?
   
  Thanks,
  -LizzRuth Gramolini <[EMAIL PROTECTED]> 
  wrote:
  I 
got the answer, thanks anyway. Ruth- Original Message - 
To: "Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]>Sent: Tuesday, June 17, 2003 10:09 
AM> Good morning all,> > Somehow all of my 
scripts to create the databases on my 9i sandbox have> disappeared. 
Does anyone have a script or trick or something to recreate> these 
files? I could recreate them manually but I am somewhat of a time> 
crunch.> > Thanks in advance,> Ruth> > 
> -- > Please see the official ORACLE-L FAQ: 
http://www.orafaq.net> -- > Author: Ruth Gramolini> 
INET: [EMAIL PROTECTED]> > 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: [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).-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net-- 
Author: Ruth GramoliniINET: [EMAIL PROTECTED]Fat 
City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, 
California -- Mailing list and web hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe 
message BODY, include a line containing: UNSUB ORACLE-L(or the name of 
mailing list you want to be removed from). You mayalso send the HELP 
command for other information (like subscribing).
  
  
  Do you Yahoo!?SBC 
  Yahoo! DSL - Now only $29.95 per month!

Re: oracle authentication from windows

[Jose Luis Delgado]

Hm

I haven't tried on Windows, but...
have you tried: IDENTIFIED EXTERNALLY???

using remote authentication I guess...

HTH
JL

--- AK <[EMAIL PROTECTED]> wrote:
> We want our client users ( forms user )  to just
> enter windows password and then automatically able
> to get in to oracle .Is there a way oracle can
> authenticate from windows ( or active directory ) .
> enbadding password in runform.exe not an option .
> 
> thanks,
> -ak


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: [EMAIL PROTECTED]

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: [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: data architecture/conferences/documents/lists

[Paula_Stankus]

Title: RE: data architecture/conferences/documents/lists





Interested in data architecture issues beyond a particular RDBMS (sorry guys just have to be) and I was wondering if anyone had any good resources:

-listservers
-conferences (what are the best for a ltd. budget)
-good books/articles/magazines


I just received a request about 


"The Next Big Thing Panel was part of the Wilshire Meta-Data Conference and DAMA International Symposium - the world's largest and most authoritative vendor-neutral data management conference. If you missed this event and would like to order the documentation, please visit the conference home page."

Anyone know if this is worth going to?  It looks very interesting.


Thanks,
Paula


-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 14, 2002 11:24 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: startup shutdown steps



Srinivas
   It would help if we knew what you were trying to achieve. Is this some
type of security solution? My guess is that the oracle binary will get
Oracle started, but maybe it would be simplest if you just tried it. I will
warn you of one thing. If the oracle binary isn't setuid to root, you get a
situation where only the Oracle user can execute it.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]



-Original Message-
Sent: Wednesday, August 14, 2002 2:08 AM
To: Multiple recipients of list ORACLE-L



Hello All,


I am curious to know what are the executables that are
used when we say startup/shutdown of oracle database
on Sun box.


I think it is $ORACLE_HOME/bin/oracle


are there any other executables/kernel files
(important) in bin or in anyother areas.


Can somebody throw somelight ??/


Thanks in advance,
Srinivas


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: kommareddy sreenivasa
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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).

copy a datafile to a raw device

[Gurelei]

hi all:

I need to move a SYSTEM datafile from a filesystem
to a raw device. I have shutdown the database,
copied the file via

dd if=system of=/dev/raw

renamed the file in the database, but couldn't open
the database because of the error: Unknown File Header
Version read for file number 1.

I tried another dd:

dd if=system of=/dev/raw obs=32768 (32K is the db
block size), but I got the same error. Can anyone
see what else could be wrong with my dd command

thanks

Gene

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

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: [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: RMAN FILESPERSET

[MacGregor, Ian A.]

The question has to do with backup sets not pieces.  A backup set can comprise many 
pieces.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Tuesday, June 17, 2003 9:15 AM
To: Multiple recipients of list ORACLE-L


You have the maxpiecesize set to 2048.  It will fill the backup piece and then start 
another.  Have the datafile sized changed alot from one day to the next?

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 6:25 PM


> I'm a bit confused by the default for filesperset.  I ran the 
> following
yesterday 
>
> run
> {
> allocate channel c1 device type sbt format 'df_%t_%s_%p'
maxpiecesize=2048M
> PARMS="SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
> ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)";
> backup database;
> backup current controlfile;
> release channel c1;
> }
>
> There were 245 datafiles in the database.  RMAN made the following 
> backup
sets
>
>BS_KEY COUNT(B.FILE#)
> -- --
>   9623 63
>   9727 64
>   9810 64
>   9892 35
>   9893  4
>   9894  4
>   9895  6
>   9896  5
>--
> sum   245
>
>
> As I understand it the default for filesperset is the lesser of 64 or 
> the
number of input files / the number of channels.
> As there was only one channel I would have expected  3 backup sets of 
> 64
files and one of 53 channels.
>
> Today I ran  against  the same target database
>
> run
> {
> allocate channel c1 device type sbt format 'df_%t_%s_%p'
maxpiecesize=2048M
> PARMS="SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
> ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)";
> allocate channel c2 device type sbt format 'df_%t_%s_%p'
maxpiecesize=2048M
> PARMS="SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
> ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)";
> backup database skip readonly;
> backup current controlfile;
> release channel c1;
> release channel c2;
> }
>
> There are 92 read write datafiles.  I would have expected the job to 
> be
divided into two backup sets with 46 files each.
>
> Instead I got
>
> BS_KEY COUNT(B.FILE#)
> -- --
>  10704  2
>  10705  2
>  10721  2
>  10722  2
>  10723  2
>  10724  2
>  10725  2
>  10726  2
>  10727  2
>  10728  2
>  10765 33
>  10766  4
>  10767  2
>  10768  1
>  10769  1
>  10770  1
>  10771  1
>  10772  1
>  10773  1
>  10774  1
>  10775  1
>  10776  1
>  10777  1
>  10778  1
>  10779  1
>  10780  2
>  10781  1
>  10782 18
>--
> sum92
> --
> 
---
>
> Any guesses as to why so many backup sets are being created.
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: MacGregor, Ian A.
>   INET: [EMAIL PROTECTED]
>
> 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: [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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network S

RE: INDEX REBUILD

[Seefelt, Beth]

8i which release?  It was broken in 8.1.6 and before, but fixed in
8.1.7.


-Original Message-
Sent: Thursday, June 19, 2003 2:01 PM
To: Multiple recipients of list ORACLE-L


Anup
this view will not help in 8i.
thanks anyway!


>From: "Arup Nanda" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: INDEX REBUILD
>Date: Thu, 19 Jun 2003 08:20:06 -0800
>
>Seema,
>
>Select last_ddl_time and timestamp from user_objects where the
object_name 
>=
>''
>
>HTH
>
>Arup Nanda
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Thursday, June 19, 2003 11:29 AM
>
>
> > Hi,
> >
> > Is any view available which can tell us indexe rebuild status in 8i?
> > Means how can we know these are indexes rebuilded recently?
> > thx
> > -Seema
> >
> > _
> > The new MSN 8: smart spam protection and 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Seema Singh
> >   INET: [EMAIL PROTECTED]
> >
> > 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: [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).
> >
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Arup Nanda
>   INET: [EMAIL PROTECTED]
>
>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: [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).

_
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seema Singh
  INET: [EMAIL PROTECTED]

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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

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: [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: Inserting blanks from a PROCOBOL program

[Kirtikumar Deshpande]

Can't he use a working storage variable that is defined with value space? 
Else try inserting ASCII value for a blank. 

- Kirti

--- "Schauss, Peter" <[EMAIL PROTECTED]> wrote:
> I have a programmer who wants to insert blanks from a PIC X host variable
> into a not null CHAR column
> from a COBOL program.  The generated code insists on converting his
> blanks to a null which is, of course, rejected since the column is defined
> as not null.  Is there a way of forcing the blanks to go into the field?
> 
> Oracle version is 8.1.7 on AIX 4.3
> Procobol 1.8.52.0.0
> 
> 
> Thanks,
> Peter Schauss
> -- 
> 

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

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: [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: APPS 11i (Linux) question

[Dale Edgar]

Hi Senthil
 
I don't have any information on your specific 
problem - but I did write up a summary of my experiences installing 11.5.7 on 
Redhat 8 and SUSE 8.1  You might find elements of this to be useful during 
your install.
 
http://databee.com/apps11i_install.htm
 
Kind regards
- Dale 

  - Original Message - 
  From: 
  Senthil Kumar D 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, June 19, 2003 3:24 
  PM
  Subject: APPS 11i (Linux) question
  
  Hi 
  Group,
   
  I'm installing apps 
  11.5.8 on Linux 8. 
   
  Rapidwiz , first unzipping some 55 components. 
  After 54th component is hanging and the unzip process is getting 
  "defunct".
   
  Anybody faced the same issue during the 
  installation.
   
  Any 
  help on this Reg.
   
  Thanks,
  Senthil.

RE: Partitions of table read only

[Rachel Carmichael]

much better -- now I understand :)


--- "Johnston, Tim" <[EMAIL PROTECTED]> wrote:
> Ah...  That's why the example helps... The text above the example is
> unclear
> but the example is a little bit better...
> 
> 
> 
> 
> "If you find it is taking a long time for the tablespace to quiesce,
> it is
> possible to identify the transactions which are preventing the
> read-only
> state from taking effect. The owners of these transactions can be
> notified
> and a decision can be made to terminate the transactions, if
> necessary. The
> following example illustrates how you might identify the blocking
> transactions. 
> 
> Identify the transaction entry for the ALTER TABLESPACE...READ ONLY
> statement. 
> 
> SELECT sql_text, saddr 
> FROM v$sqlarea,v$session
> WHERE v$sqlarea.address = v$session.sql_address
> AND sql_text like 'alter tablespace%'; 
> 
> SQL_TEXT SADDR   
>  
> alter tablespace tbs1 read only  80034AF0
> 
> 
> The start SCN of each active transaction is stored in the
> V$TRANSACTION
> view. Displaying this view sorted by ascending start SCN lists the
> transactions in execution order. Knowing the transaction entry for
> the
> read-only statement, it can be located in the V$TRANSACTION view. All
> transactions with lesser or equal start SCN can potentially hold up
> the
> quiesce and subsequent read-only state of the tablespace. 
> 
> SELECT ses_addr, start_scnb 
> FROM v$transaction
> ORDER BY start_scnb;
> 
> SES_ADDR START_SCNB
>  --
> 800352A0   3621   --> waiting on this txn
> 80035A50   3623   --> waiting on this txn
> 80034AF0   3628   --> this is the ALTER TABLESPACE statement
> 80037910   3629   --> don't care about this txn
> 
> 
> After making the tablespace read-only, it is advisable to back it up
> immediately. As long as the tablespace remains read-only, no further
> backups
> of the tablespace are necessary since no changes can be made to it."
> 
> 
> 
> 
> Notice it says "All transactions with lesser or equal start SCN can
> potentially hold up the quiesce and subsequent read-only state of the
> tablespace"...  Not just the transactions against that tablespace... 
> And,
> they are checking all entries in v$transaction...
> 
> 
> On the other hand, you can still alter tablespaces to read only even
> though
> your system is busy...  The point is that the command will hang until
> all
> transactions that started before your alter command finish...  Maybe
> this is
> a better way...
> 
> 1) tx1 starts at time t1
> 2) You alter tablespace tbsp1 to read only at t2 (it hangs)
> 3) tx2 starts at time t3 and does not go against tbsp1
> 4) tx3 starts at time t4 and does go against tbsp1 (it fails since
> tbsp1 is
> in transitional read only)
> 5) tx1 completes
> 6) The alter to read only can not complete since tx1 was the only
> transaction that started before it
> 
> Better?
> 
> Tim
> 
> 
> -Original Message-
> Sent: Wednesday, June 18, 2003 9:50 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> The admin guide doesn't say "no transactions in the database". In
> fact,
> it specifically says in the tablespace:
> 
> " You do not have to wait for transactions to complete before issuing
> the ALTER TABLESPACE...READ ONLY statement. When the statement is
> issued, the target tablespace goes into a transitional read-only mode
> in which no further DML statements are allowed, though existing
> transactions that modified the tablespace will be allowed to commit
> or
> rollback. Once this occurs, the tablespace is quiesced, with respect
> to
> active transactions."
> 
> There were other transactions in the database, but none affecting
> that
> tablespace.
> 
> The concepts guide is somewhat ambiguous and could be read either as
> "in the database" or "against the tablespace" since it isn't
> specified.
> 
> 
> Have I mentioned lately that I hate the docs?  :)
> 
> 
> 
> 
> --- "Johnston, Tim" <[EMAIL PROTECTED]> wrote:
> > In order to complete an alter to read only, ALL transactions
> against
> > the
> > database that were started before you issued that alter command
> must
> > complete before the alter will continue...  From the concepts
> > guide...
> > 
> > 
> > The ALTER TABLESPACE ... READ ONLY statement places the tablespace
> in
> > a
> > transitional read-only mode and waits for existing transactions to
> > complete
> > (commit or roll back). This transitional state does not allow any
> > further
> > write operations to the tablespace except for the rollback of
> > existing
> > transactions that previously modified blocks in the tablespace.
> > Hence, in
> > transition the tablespace behaves like a read-only tablespace for
> all
> > user
> > statements except ROLLBACK. After all of the existing transactions
> > have
> > either committed or rolled back, the ALTER TABLESPACE ... READ ONLY
> > statement completes and the tablespace is

Re: 9i Ques

[Alessandro Guimarães]

Hi,
option a is the default .
option c if you have create the database  with DBCA

Alessandro


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 9:34 AM


> Hi Group,
>
> What is the default value of Undo_retention?
>
> a. 900
> b. 0
> c. 10800
> d. None of the above
>
> I have selected option a. The answer given by the system is c.
>
> Which one is right. I have checked out with oracle doc's. It says 900. But
> db (which has default parameters) says 10800.!
>
> Any answers??
>
> TIA
> Senthil
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Senthil Kumar D
>   INET: [EMAIL PROTECTED]
>
> 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: [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).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?Q?Alessandro_Guimar=E3es?=
  INET: [EMAIL PROTECTED]

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: [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: INDEX REBUILD

[Seema Singh]

Anup
this view will not help in 8i.
thanks anyway!

From: "Arup Nanda" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: INDEX REBUILD
Date: Thu, 19 Jun 2003 08:20:06 -0800
Seema,

Select last_ddl_time and timestamp from user_objects where the object_name 
=
''

HTH

Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 11:29 AM
> Hi,
>
> Is any view available which can tell us indexe rebuild status in 8i?
> Means how can we know these are indexes rebuilded recently?
> thx
> -Seema
>
> _
> The new MSN 8: smart spam protection and 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
>
> 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: [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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
  INET: [EMAIL PROTECTED]
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: [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).
_
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Seema Singh
 INET: [EMAIL PROTECTED]
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: [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: Oracle releases by the different platforms...

[Mercadante, Thomas F]

Title: RE: Oracle releases by the different platforms...



This 
story makes it sound like SCO is an attorney's office that specializes in 
scoring rainmaker lawsuits based on purchasing old rights to software.  
Doesn't sound like a software company to me.  I'd be updating my resume if 
I was a SCO developer working for this bunch.
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 
  11:40 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Oracle releases by the different platforms...
  I think everyone should read http://www.forbes.com/2003/06/18/cz_dl_0618linux.html 
  
  Raj  
  Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. 
  QOTD: Any clod can have facts, having an opinion is an art 
  ! 
  -Original Message- From: Mark 
  Leith [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, June 19, 2003 10:13 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle releases by the different platforms... 
  
  This may not be a bad idea in the not too distant future 
  April! : 

RE: Partitions of table read only

[Johnston, Tim]

Ah...  That's why the example helps... The text above the example is unclear
but the example is a little bit better...




"If you find it is taking a long time for the tablespace to quiesce, it is
possible to identify the transactions which are preventing the read-only
state from taking effect. The owners of these transactions can be notified
and a decision can be made to terminate the transactions, if necessary. The
following example illustrates how you might identify the blocking
transactions. 

Identify the transaction entry for the ALTER TABLESPACE...READ ONLY
statement. 

SELECT sql_text, saddr 
FROM v$sqlarea,v$session
WHERE v$sqlarea.address = v$session.sql_address
AND sql_text like 'alter tablespace%'; 

SQL_TEXT SADDR   
 
alter tablespace tbs1 read only  80034AF0


The start SCN of each active transaction is stored in the V$TRANSACTION
view. Displaying this view sorted by ascending start SCN lists the
transactions in execution order. Knowing the transaction entry for the
read-only statement, it can be located in the V$TRANSACTION view. All
transactions with lesser or equal start SCN can potentially hold up the
quiesce and subsequent read-only state of the tablespace. 

SELECT ses_addr, start_scnb 
FROM v$transaction
ORDER BY start_scnb;

SES_ADDR START_SCNB
 --
800352A0   3621   --> waiting on this txn
80035A50   3623   --> waiting on this txn
80034AF0   3628   --> this is the ALTER TABLESPACE statement
80037910   3629   --> don't care about this txn


After making the tablespace read-only, it is advisable to back it up
immediately. As long as the tablespace remains read-only, no further backups
of the tablespace are necessary since no changes can be made to it."




Notice it says "All transactions with lesser or equal start SCN can
potentially hold up the quiesce and subsequent read-only state of the
tablespace"...  Not just the transactions against that tablespace...  And,
they are checking all entries in v$transaction...


On the other hand, you can still alter tablespaces to read only even though
your system is busy...  The point is that the command will hang until all
transactions that started before your alter command finish...  Maybe this is
a better way...

1) tx1 starts at time t1
2) You alter tablespace tbsp1 to read only at t2 (it hangs)
3) tx2 starts at time t3 and does not go against tbsp1
4) tx3 starts at time t4 and does go against tbsp1 (it fails since tbsp1 is
in transitional read only)
5) tx1 completes
6) The alter to read only can not complete since tx1 was the only
transaction that started before it

Better?

Tim


-Original Message-
Sent: Wednesday, June 18, 2003 9:50 PM
To: Multiple recipients of list ORACLE-L


The admin guide doesn't say "no transactions in the database". In fact,
it specifically says in the tablespace:

" You do not have to wait for transactions to complete before issuing
the ALTER TABLESPACE...READ ONLY statement. When the statement is
issued, the target tablespace goes into a transitional read-only mode
in which no further DML statements are allowed, though existing
transactions that modified the tablespace will be allowed to commit or
rollback. Once this occurs, the tablespace is quiesced, with respect to
active transactions."

There were other transactions in the database, but none affecting that
tablespace.

The concepts guide is somewhat ambiguous and could be read either as
"in the database" or "against the tablespace" since it isn't specified.


Have I mentioned lately that I hate the docs?  :)




--- "Johnston, Tim" <[EMAIL PROTECTED]> wrote:
> In order to complete an alter to read only, ALL transactions against
> the
> database that were started before you issued that alter command must
> complete before the alter will continue...  From the concepts
> guide...
> 
> 
> The ALTER TABLESPACE ... READ ONLY statement places the tablespace in
> a
> transitional read-only mode and waits for existing transactions to
> complete
> (commit or roll back). This transitional state does not allow any
> further
> write operations to the tablespace except for the rollback of
> existing
> transactions that previously modified blocks in the tablespace.
> Hence, in
> transition the tablespace behaves like a read-only tablespace for all
> user
> statements except ROLLBACK. After all of the existing transactions
> have
> either committed or rolled back, the ALTER TABLESPACE ... READ ONLY
> statement completes and the tablespace is placed in read-only mode. 
> 
> 
> And there is a good example in the admin guide...
> 
>
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/tspa
> ces.htm#6884
> 
> HTH
> 
> Tim
> 
> -Original Message-
> Sent: Wednesday, June 18, 2003 3:30 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> there WERE no active transactions against that tablespace.
> 
>

Re: 9i Ques

[Thomas Day]

I believe that when you create a database with the GUI it sets
undo_retention to 10800.  Perhaps if you set it to blank then 9.2 will
default to 900.



   

  "Senthil Kumar   

  D"   To:  Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
  

  Sent by: 

  ml-errors

   

   

  06/19/2003 12:34 

  PM   

  Please respond   

  to ORACLE-L  

   

   





Hi Group,

What is the default value of Undo_retention?

a. 900
b. 0
c. 10800
d. None of the above

I have selected option a. The answer given by the system is c.

Which one is right. I have checked out with oracle doc's. It says 900. But
db (which has default parameters) says 10800.!

Any answers??

TIA
Senthil

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Senthil Kumar D
  INET: [EMAIL PROTECTED]

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: [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).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thomas Day
  INET: [EMAIL PROTECTED]

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: [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).

IO Topology Anyone???

[Freeman Robert - IL]

Anyone use the IO Topology features with Oracle9iR2 and Veritas? Does
Veritas have a mapping file that you can use with this feature? (I've posed
the same question with Veritas, so it's a race to the answer!) Any
experiences you can share about this feature?

Robert 

  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

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: [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).

oracle authentication from windows

[AK]

We want our client users ( forms user )  to 
just enter windows password and then automatically able to get in to oracle .Is 
there a way oracle can authenticate from windows ( or active directory ) . 
enbadding password in runform.exe not an option .
 
thanks,
-ak

RE: AQ, RAC and delay

[Jamadagni, Rajendra]

Title: RE: AQ, RAC and delay





I haven't tried with mcpd=0 yet ...


Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 19, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: AQ, RAC and delay




With MPCD=0, Is your primary wait event shown as "on-going reading of SCN
to complete" in the statspack reports? Oracle Support insisted we set it to
7 coz of this.


Raj




   
    "K 
    Gopalakrishnan   To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>   
    "    cc:   
    <[EMAIL PROTECTED]   Subject: RE: AQ, RAC and delay    
    o.com> 
    Sent by:   
    [EMAIL PROTECTED] 
    ity.com    
   
   
    06/19/2003 
    10:29 AM   
    Please respond 
    to ORACLE-L    
   
   





Hemant:


You are right. 7 seconds is the MAX difference,  but the control files are
synced
every 3 seconds during the 'split brain' check. So most of the cases, it is
3 seconds
with the maximum of 7 seconds subject to the MCPD settings.


KG




Best Regards,
K Gopalakrishnan





-Original Message-
Hemant K Chitale
Sent: Thursday, June 19, 2003 5:38 AM
To: Multiple recipients of list ORACLE-L



Although MCPD may default to 700centiseconds [although I have seen a much
lower value on 9.2 on Tru64],
in most cases, delays of 7seconds don't occur [and shouldn't be acceptable
?!].


I do have a 9iRAC environment but am comfortably using mcpd=0.
And I have AQ in an 8.1.7 single-instance environment.
So I can't make any statements about AQ in OPS/RAC !


Hemant


At 07:05 AM 17-06-03 -0800, you wrote:


 A colleague casually mentioned that in RAC, the test to de-queue an AQ
 set-up from BOTH instances didn't succeed. The side where we were
 enqueuing was able to see queued messages faster than the 'other'
 side. About 7-8 seconds ... that got me thinking ... is this an effect
 of MCPD which defaults to like 7 seconds?


 Do you use AQ in RAC and enqueue/dequeue on both nodes? What is your
 experience?


 ps: mcpd - max commit propagation delay
 TIA
 Raj
 


 Rajendra dot Jamadagni at nospamespn dot com
 All Views expressed in this email are strictly personal.
 QOTD: Any clod can have facts, having an opinion is an art !



Hemant K Chitale





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]


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: [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).



This e-

RE: INDEX REBUILD

[Guang Mei]

Where can I find more detail info about "frequent index rebuilds can reduce
your performance" ?

Thanks.

Guang

-Original Message-
Sent: Thursday, June 19, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L

Seema - If you analyze in conjunction with rebuilds, you could track with
the LAST_ANALYZED column in USER_INDEXES table. That is all I can think of.
Why do you ask? Jared has spoken eloquently about how frequent index
rebuilds can reduce your performance.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: [EMAIL PROTECTED]

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: [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: INDEX REBUILD

[zhu chao]

hi,
From user_objects.last_ddl_time.

Regards
zhu chao
msn:[EMAIL PROTECTED]
www.cnoug.org
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 20, 2003 12:00 AM


> Seema - If you analyze in conjunction with rebuilds, you could track with
> the LAST_ANALYZED column in USER_INDEXES table. That is all I can think
of.
> Why do you ask? Jared has spoken eloquently about how frequent index
> rebuilds can reduce your performance.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Thursday, June 19, 2003 10:29 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
>
> Is any view available which can tell us indexe rebuild status in 8i?
> Means how can we know these are indexes rebuilded recently?
> thx
> -Seema
>
> _
> The new MSN 8: smart spam protection and 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
>
> 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: [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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> 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: [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).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: zhu chao
  INET: [EMAIL PROTECTED]

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: [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: Passwords and authentication

[Gogala, Mladen]

Title: Passwords and authentication



There 
is also label security option which is present on Enterprise Edition CD. That 
would 
alleviate the need for manual encryption because the 
table cannot be seen unless there is
sufficient security clearance. Also, logging in from 
SQL*Plus can be disabled from the USER_PRODUCT_PROFILE. Connected to that, is 
anybody on this list using label
security? Does anybody have experience with it? Arup, 
you are writing a book about security 
in 
Oracle 9.2  and I hope that you will cover label 
security.
 
Mladen Gogala Oracle DBA Phone:(203) 459-6855 
Email:[EMAIL PROTECTED] 

  -Original Message-From: Arup Nanda 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 12:15 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Passwords and authentication
  Raj,
   
  My first question will be how you 
  would want to pass the encrypted password. sqlplus 
  /? But won't the encrypted password be 
  known before making the connection? If so, then the user who will encrypt the 
  password will also know how to decrypt them. What's the advantage in doing 
  that?
   
  Are you concerned someone sniffing the network 
  uncovers a clear password? If so, have you considered network security with 
  password encryption by Oracle Net?
   
  If that is not the concern but rather you don't 
  want the users to know the real password, here is a solution you might be 
  interested. It's part of a elaborate application security design. Please read 
  on if you are interested.
   
  You would have user called SECUSER with only 
  table APP_USERS. The table has two columns - APP_USER and APP_PASS, in 
  encrypted manner, with Triple DES Encryption. The user also has one function - 
  check_app_password, which accepts two parameters - the userid and the password 
  and returns a string. The return value is YES is the password supplied is 
  correct and NO, if it isn't. It does not shw the correct password, ever; just 
  shows if the supplied password is correct or not. This function is defined as 
  DEFINER rights. All users get an execute privilege on this function, nothing 
  else on the rest of the objects of the SECUSER user.
   
  Inside the function, the password is retrieved 
  from the table, decrypted with the key inside the procedure and matched with 
  the supplied one. Another function is provided to encrypt the password using 
  teh same key. For more ecurity, the userid and password combination can 
  encrypted, not just the password. If you want I can give you the code for the 
  functions.
   
  When the app user connects, the connection is 
  done through a generic id, that, after the conenction, validates the password 
  using the function and authenticates the user. If the password is not correct, 
  the user is booted out.
   
  Now comes other issues - fine grained access 
  control and fine grained auditing. These features need to have a sepcific 
  named database user. However, that can be easily fixed by setting up an 
  application context and passing the app_user value to a context attribute. 
  This attribute can now be tracked, rather than the userid.
   
  Hope this helps.
   
  Arup Nanda
  www.proligence.com
  
- Original Message - 
From: 
Jamadagni, Rajendra 
To: Multiple 
recipients of list ORACLE-L 
Sent: Thursday, June 19, 2003 9:19 
AM
Subject: Passwords and 
authentication

Is it possible to connect to database 
using encrypted passwords? Using sqlplus? 
Thanks Raj  
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this 
email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 

Inserting blanks from a PROCOBOL program

[Schauss, Peter]

I have a programmer who wants to insert blanks from a PIC X host variable
into a not null CHAR column
from a COBOL program.  The generated code insists on converting his
blanks to a null which is, of course, rejected since the column is defined
as not null.  Is there a way of forcing the blanks to go into the field?

Oracle version is 8.1.7 on AIX 4.3
Procobol 1.8.52.0.0


Thanks,
Peter Schauss
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Schauss, Peter
  INET: [EMAIL PROTECTED]

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: [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: Passwords and authentication

[Arup Nanda]

Title: Passwords and authentication



Raj,
 
My first question will be how you 
would want to pass the encrypted password. sqlplus 
/? But won't the encrypted password be known 
before making the connection? If so, then the user who will encrypt the password 
will also know how to decrypt them. What's the advantage in doing 
that?
 
Are you concerned someone sniffing the network 
uncovers a clear password? If so, have you considered network security with 
password encryption by Oracle Net?
 
If that is not the concern but rather you don't 
want the users to know the real password, here is a solution you might be 
interested. It's part of a elaborate application security design. Please read on 
if you are interested.
 
You would have user called SECUSER with only table 
APP_USERS. The table has two columns - APP_USER and APP_PASS, in encrypted 
manner, with Triple DES Encryption. The user also has one function - 
check_app_password, which accepts two parameters - the userid and the password 
and returns a string. The return value is YES is the password supplied is 
correct and NO, if it isn't. It does not shw the correct password, ever; just 
shows if the supplied password is correct or not. This function is defined as 
DEFINER rights. All users get an execute privilege on this function, nothing 
else on the rest of the objects of the SECUSER user.
 
Inside the function, the password is retrieved from 
the table, decrypted with the key inside the procedure and matched with the 
supplied one. Another function is provided to encrypt the password using teh 
same key. For more ecurity, the userid and password combination can encrypted, 
not just the password. If you want I can give you the code for the 
functions.
 
When the app user connects, the connection is done 
through a generic id, that, after the conenction, validates the password using 
the function and authenticates the user. If the password is not correct, the 
user is booted out.
 
Now comes other issues - fine grained access 
control and fine grained auditing. These features need to have a sepcific named 
database user. However, that can be easily fixed by setting up an application 
context and passing the app_user value to a context attribute. This attribute 
can now be tracked, rather than the userid.
 
Hope this helps.
 
Arup Nanda
www.proligence.com

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, June 19, 2003 9:19 
  AM
  Subject: Passwords and 
  authentication
  
  Is it possible to connect to database using 
  encrypted passwords? Using sqlplus? 
  Thanks Raj  
  Rajendra dot Jamadagni at nospamespn dot 
  com All Views expressed in this 
  email are strictly personal. QOTD: 
  Any clod can have facts, having an opinion is an art ! 

Re: MySQL in the future?

[Glenn Stauffer]

Goulet, Dick wrote:

I think we've all seen and are once again seeing a similar maneuver.  Can you get MySql from mysql.org, sure but it's going to be left way in the dirt by MySql AB until their version is the only acceptable one out there.  Course by then it probably will acquire a different name. and of course a higher price tag.  Only the lawyers win!!!

 

The only version out there is the MySQL AB version.  The company owns 
MySQL: mysql.org points to mysql.com and mysql.com is MySQL AB. 

MySQL is a lot like RedHat Linux in many respects - you can download and 
use the software for free; you can buy the boxed CD and Manuals; you can 
buy a commercial license; you can buy support and training; and you can 
pay to take certification exams.

Glenn Stauffer

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Glenn Stauffer
 INET: [EMAIL PROTECTED]
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: [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: memory swapping and rollback

[Daniel Fink]

David,
Commit frequency can help or hurt performance. The more often you commit, the 
more often undo blocks will be reused. This will also cause the log buffer and 
committed blocks in the buffer cache to be flushed. If you commit less often, these 
actions happen less often, but undo blocks will not be reused as often. This could 
cause space management problems if there is not enough space in the tablespace or 
other processes are causing rollback segments to shrink. 
The short version is that frequent commits = additional housekeeping (impact 
can't be known exactly until tested) and infrequent commits = additional space 
allocation (impact can't be exactly known until tested).

The issue of swapping is not related to rollback. I have not tested the merge, 
but it may be doing some sorting. When it exceeds your sort_area_size in memory it 
begins to write sort runs to disk (temporary tablespace). Is this what they mean by 
swapping?

The best approach (IMHO) is to go back to the critics and ask for more 
detailed information, including the logic and scenarios describing the logic.

Daniel Fink

David Turner wrote:
> 
> I was presenting a new load process and I am using straight merge selects
> from external tables and one of the complaints that came up was that
> 
> Performance would be worse because I wasn't committing more frequently.
> 
> If my merge was too large memory swapping would occur and it was possibly
> related to rollback.
> 
> I said I was not aware of this and would look into it but I had never heard
> of this before and couldn't find any information on this so of course I'm
> sending mail to the list. Both items sound bogus to me. I've really never
> heard where committing more frequently on a load would help performance in
> any way.
> 
> Thanks, Dave
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: David Turner
>   INET: [EMAIL PROTECTED]
> 
> 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: [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).begin:vcard 
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard

Oracle 9i and streaming technology

[Michael Kline]

Have a client that 
is using Linux and Oracle 9i.
 
They are attempting 
to do live inventory on 5
branches using 
streaming technology,
but when it kicks 
it, it literally
shuts the network 
down... If you are not in
before it starts 
you can't get on. It appears
to do this to all 5 
branches.
 
Oracle, of course, 
while they say the client is
"pushing the 
envelope", also has very little
to offer in the 
line of help.
 
Being so new, would 
like to have an idea
of what to start 
checking on.
 
Has anyone played 
with this and have you found
any "tips" that 
might help in set up?
 
Client belongs to 
one of my fellow consultants.
 
 
Michael Alan Kline, Sr.Principal ConsultantBusiness to Business 
Solutions, LLCPhone: 804-744-1545  Cell: 804-314-6262ICQ: 1009605, 
975313Email: [EMAIL PROTECTED] Web: www.b2bsol.com
 

Re: Passwords and authentication

[Reginald . W . Bailey]

Yes it is.

RWB


Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)



   
 
Rajendra.Jamadagn  
 
[EMAIL PROTECTED]  To: [EMAIL PROTECTED]   
 
Sent by:cc:
 
[EMAIL PROTECTED]   Subject: Passwords and authentication  
 
.com   
 
   
 
   
 
06/19/2003 08:19   
 
AM 
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 






Is it possible to connect to database using encrypted passwords? Using
sqlplus?

Thanks
Raj


Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !

(See attached file: ESPN_Disclaimer.txt)



ESPN_Disclaimer.txt
Description: Binary data

RE: MySQL in the future?

[Weaver, Walt]

I'll second Tim's choices. Got both books and they're excellent.

BTW, I got the MySQL Cookbook at the Rocky Mountain Oracle Users Group
Conference.   :>)

--Walt Weaver
  Bozeman, Montana

> -Original Message-
> From: M Rafiq [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 10:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: MySQL in the future?
> 
> Tim,
> 
> Thanks
> Regards
> Rafiq
> 
> 
> 
> 
> Date: Thu, 19 Jun 2003 02:24:39 -0800
> 
> On Wed, Jun 18, 2003 at 09:10:39AM -0800, M Rafiq wrote:
>  > Tim,
>  > May be a an off-topic question to you or anybody who can answer.
>  >
>  > What is the best source / books to learn mysql quickest possible
> without
>  > too much cost to an individual?
> 
> The online docs are good:
>http://www.mysql.com/doc/en/index.html
> 
> For dead trees, these are good:
>http://www.amazon.com/exec/obidos/tg/detail/-/0735712123
>http://www.amazon.com/exec/obidos/tg/detail/-/0596001452
> 
> Tim.
> 
>  > I am asking this because in my recent job search I found couple of
good
>  > companies are also using mysql.
>  >
>  > Regards
>  > Rafiq

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

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: [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: Bewildered by RMAN

[MacGregor, Ian A.]

Another poster had suggested

CHANGE archivelog all VALIDATE; 

This fixed the problem.  Oh, and I do have your book.  

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, June 18, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L


Ian,

This is a problem I run into a great deal. Before you backup issue this command (I 
assume 9i here and pre-configured defaults so no allocate channel
commands):

crosscheck archivelog all;
backup database archivelog all;

The crosscheck command will compare the archivelogs currently on disk to those in the 
control file. Any missing will be marked expired. If you were to restore them you can 
run the crosscheck command to remark them as available.

/*+ Cheap_Plug(this is in my RMAN book by the way... :-) ) */

HTH,

RF


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/18/2003 3:05 PM

Ian,
You can try resyncing the catalog and if that still doesn't work try to uncatalog that 
log:
rman> change archivelog '/full_path/log_name_8192.arc' uncatalog;'

Ruth


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 10:14 PM


> A few days ago the physicists turned on what they call the waveform
channels.  The  channel archive database tracking this information was able to 
withstand the additional 2,000,000 rows per hour load for 20 + hours. Then the 257 
errors hit.  As  we are migrating from a very old ADSM system to TSM with a better 
SILO, this database seemed a good choice.  The old backup system is still handling a 
score of databases without using RMAN. I was also able to procure an additional 18 GB 
internal disk  on which to place the archived redo logs.  I shutdown the channel 
archive database
(9.0.1.3) changed the destination parameter for archive logs to point to the new 
location, then did  an alter system switch logfile.  I then logged into the RMAN 
catalog and registered the database for the first time.
>
> I tried
>
> run
> {
> allocate channel c1 device type sbt format 'df_%t_%s_%p'
maxpiecesize=2048M
> PARMS="SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
> ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)";
> backup archivelog all delete input;
> release channel c1;
> }
>
> But it wanted log sequence 8192 which was backed up and deleted on the
old
system long ago.
>
> Any way
>
> run
> {
> allocate channel c1 device type sbt format 'df_%t_%s_%p'
maxpiecesize=2048M
> PARMS="SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
> ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)";
> backup archivelog from sequence 9645 delete input;
> release channel c1;
> }
>
> Backed up that log file.  I then ran a backup of all the data files to
get
even the read only ones, and then a backup of the read write tablespaces.  I didn't 
include archive logs in these backups.  I have asked the physicists to hold off on 
their 2,000,000 rows per hour data which they can do for a while.  They had some other 
waveform data which created slightly over 7,000,000 records per day.  I placed the 
archive log backup as written above into a different cron job.  Currently invoked 
hourly, than the one for the database backup invoked daily.
>
> All backups use the recovery catalog.  The catalog database is
9.2.0.3.
Here's the gist of the problem
> select name from rc_archived_log where db_key = 6411;
>
> (Many previous rows removed)
>
> NAME
>

--
--
> /opt/oracle/admin/NLCO/arch/NLCO_9633_1.ARC
> /opt/oracle/admin/NLCO/arch/NLCO_9634_1.ARC
> /opt/oracle/admin/NLCO/arch/NLCO_9635_1.ARC
> /opt/oracle/admin/NLCO/arch/NLCO_9636_1.ARC
> /opt/oracle/admin/NLCO/arch/NLCO_9637_1.ARC
> /opt/oracle/admin/NLCO/arch/NLCO_9638_1.ARC
> /opt/oracle/admin/NLCO/arch/NLCO_9639_1.ARC
> /opt/oracle/admin/NLCO/arch/NLCO_9640_1.ARC
> /opt/oracle/admin/NLCO/arch/NLCO_9641_1.ARC
> /opt/oracle/admin/NLCO/arch/NLCO_9642_1.ARC
> /opt/oracle/admin/NLCO/arch/NLCO_9643_1.ARC
> /opt/oracle/admin/NLCO/arch/NLCO_9644_1.ARC
>
> List archived logs from the old location.  These were never backed up
by
RMAN.
>
> List archivelog all;
>
> Again lists only old archive files never backed up by rman
>
> 956019633A 10-JUN-03
/opt/oracle/admin/NLCO/arch/NLCO_9633_1.ARC
> 956119634A 10-JUN-03
/opt/oracle/admin/NLCO/arch/NLCO_9634_1.ARC
> 956219635A 10-JUN-03
/opt/oracle/admin/NLCO/arch/NLCO_9635_1.ARC
> 956319636A 10-JUN-03
/opt/oracle/admin/NLCO/arch/NLCO_9636_1.ARC
> 956419637A 10-JUN-03
/opt/oracle/admin/NLCO/arch/NLCO_9637_1.ARC
> 956519638A 10-JUN-03
/opt/oracle/admin/NLCO/arch/NLCO_9638_1.ARC
> 956619639A 10-JUN-03
/opt/oracle/admin/NLCO/arch/NLCO_9639_1.ARC
> 956719640A 10-JUN-03
/opt/oracle/admin/NLCO/arch/NLCO_9640_1.ARC
> 956819641A 10-JUN-03
/opt/oracle/

Re: INDEX REBUILD

[Arup Nanda]

Seema,

Select last_ddl_time and timestamp from user_objects where the object_name =
''

HTH

Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 11:29 AM


> Hi,
>
> Is any view available which can tell us indexe rebuild status in 8i?
> Means how can we know these are indexes rebuilded recently?
> thx
> -Seema
>
> _
> The new MSN 8: smart spam protection and 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
>
> 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: [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).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

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: [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: MySQL in the future?

[Matthew Zito]

There's a specific reason for that - mysql.org was run by NuSphere, a
company that released an extended version of MySQL with a custom
database engine.  Mysql the corporation sued for trademark infringement
on the name mysql, claiming that customers would be confused that the
mysql.org listed version of mysql was the official one.  MySQL AB won,
and took the name over.

Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Goulet, Dick
> Sent: Thursday, June 19, 2003 9:30 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: MySQL in the future?
> 
> 
> Richard,
> 
>   Now this is interesting.  When you enter www.mysql.org 
> into your browser you get forwarded onto www.mysql.com.
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA 
> 
> -Original Message-
> Sent: Wednesday, June 18, 2003 5:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Dick,
> 
> That's the commercial version your link points to which 
> provides additional functionality like InnoDB.  But you can 
> get free MySQL from www.mysql.org.
> 
> Richard
> 
> -Original Message-
> Sent: Wednesday, June 18, 2003 1:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Richard,
> 
>   Oh Contrare, if your using MySql for a commercial 
> purpose then you owe MySql AB in Germany $475 US, at last 
> look.  Here's from their web site 
> (http://www.mysql.com/products/licensing.html):
> 
> MySQL Licensing 
> 
> Policy In Brief
> 
> This is our licensing policy in brief: Our software is 100% 
> GPL, and if yours is 
> also 100% GPL (or OSI compliant), then you never have to pay 
> us for the 
> licences. In all other instances, you are better served by 
> our commercial 
> licence. Read the details below! Licensing
> 
> MySQL software is licensed under the GPL license. The formal 
> terms of the GPL 
> license can be found in the GNU General Public License 
> section of the MySQL 
> Reference Manual.
> 
> MySQL is also available under commercial non-GPL license. For 
> pricing and 
> ordering information, see our online store 1. Free use for 
> those who are 100% 
> GPL
> 
> If your application is licensed under GPL or compatible OSI 
> license approved by 
> MySQL AB, you are free and welcome to ship any GPL software 
> of MySQL AB with 
> your application. By "application" we mean any type of 
> software application, 
> system, tool or utility. For doing this, you do not need a 
> separate signed 
> agreement with MySQL AB, because the GPL text is sufficient. 
> But we do recommend 
> you to be in touch with us as there usually are good 
> opportunities for 
> partnership and co-marketing. 2. Free use for those who never 
> copy, modify or 
> distribute
> 
> As long as you never distribute (internally or externally) 
> the MySQL Software in 
> any way, you are free to use it for powering your 
> application, irrespective of 
> whether your application is under GPL or other OSI approved 
> license or not.
> 
> More specifically:
> 
> Modifying - You are allowed to modify MySQL Software source 
> code any way you 
> like. If you distribute the modified version, all changes, 
> all interface code 
> and all code that connects directly or indirectly to the 
> interface code fall 
> under GPL.
> 
> Copying - You are allowed to copy MySQL binaries and source 
> code, but when you 
> do so, the copies will fall under the GPL license. 3. 
> Commercial use for 
> everyone else
> 
> If your application is not licensed under GPL or compatible 
> OSI license approved 
> by MySQL AB and you intend to distribute MySQL software (be 
> that internally or 
> externally), you must first obtain a commercial license to 
> the MySQL software in 
> question.
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA 
> 
> -Original Message-
> Sent: Wednesday, June 18, 2003 1:20 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Yes, agreed.  But out of all the MySql running out there, how 
> many of them do you think people purchased support for?  
> People run MySql just like Apache because it's free.  And 
> they get most of the support through internal mailing-list, 
> groups etc.
> 
> Richard
> 
> -Original Message-
> Sent: Wednesday, June 18, 2003 12:55 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Richard,
> 
>   I believe someone else here put the magic phrase on the 
> subject.  Support.  MySql has a commercial company that you 
> can buy support from, namely MySQL.  PostGreSql use to have a 
> vendor who would sell you a support contract, Great Bridge 
> Software.  Don't know what happen to them.
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA 
> 
> -Original Message-
> Sent: Wednesday, June 18, 2003 12:04 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Glad to see another Post

Re: MySQL in the future?

[M Rafiq]

Tim,

Thanks
Regards
Rafiq


Date: Thu, 19 Jun 2003 02:24:39 -0800

On Wed, Jun 18, 2003 at 09:10:39AM -0800, M Rafiq wrote:
> Tim,
> May be a an off-topic question to you or anybody who can answer.
>
> What is the best source / books to learn mysql quickest possible without
> too much cost to an individual?
The online docs are good:
  http://www.mysql.com/doc/en/index.html
For dead trees, these are good:
  http://www.amazon.com/exec/obidos/tg/detail/-/0735712123
  http://www.amazon.com/exec/obidos/tg/detail/-/0596001452
Tim.

> I am asking this because in my recent job search I found couple of good
> companies are also using mysql.
>
> Regards
> Rafiq
_
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
 INET: [EMAIL PROTECTED]
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: [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).

Monitoring SQL without where clause

[Reddy, Madhusudana]

Morning All,

Is somebody here monitoring SQL statements which do not have Where clause ??

Couple of times on our DB ( 8.1.7 ), some SQL statements were issued by Application ( 
bad code ) as well as users without where clause causing HUGE rollback ( almost 400 
Million blocks ) and also causing LOCKS some times. When we kill these session(s) , 
its taking almost 6 to 7 hours to parallel rollback. 

Also , can you guys provide me some script to monitor the Rollback segments , like 
when the rollback usage by session reaches 200 Million blocks, script has to mail me. 
Basic SQL script should be fine for me. 

Thank you,
Madhu Reddy



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

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: [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: INDEX REBUILD

[DENNIS WILLIAMS]

Seema - If you analyze in conjunction with rebuilds, you could track with
the LAST_ANALYZED column in USER_INDEXES table. That is all I can think of.
Why do you ask? Jared has spoken eloquently about how frequent index
rebuilds can reduce your performance.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, June 19, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L


Hi,

Is any view available which can tell us indexe rebuild status in 8i?
Means how can we know these are indexes rebuilded recently?
thx
-Seema

_
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Seema Singh
  INET: [EMAIL PROTECTED]

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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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: [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: MySQL in the future?

[Gogala, Mladen]

How can a honest DBA become a lawyer? It seems to me that technology
has become dependent on lawyers. If AIX is stopped, it will be a disaster 
of biblical proportions which will seriously disrupt business. I believe
that the future lies in litigation, not technology.
As for MySQL, it has never been a favorite of mine. If I need an open source

database, it seems to me that Postgres is the way to go. It supports
transactions 
from the start and it also supports more or less classic SQL.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, June 19, 2003 10:13 AM
To: Multiple recipients of list ORACLE-L


I think we've all seen and are once again seeing a similar maneuver.  Can
you get MySql from mysql.org, sure but it's going to be left way in the dirt
by MySql AB until their version is the only acceptable one out there.
Course by then it probably will acquire a different name. and of course a
higher price tag.  Only the lawyers win!!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Wednesday, June 18, 2003 11:35 PM
To: Multiple recipients of list ORACLE-L


I'm glad I'm not a lawyer. What does distribute internally mean? I work for
company X and write an application to use a MySQL database. I take the zip
file I downloaded from MySQL and install it to another server, and now two
sets of people are using the database on different machines with the same
application. Does that mean I distributed it internally?

> -Original Message-
> From: Matthew Zito [mailto:[EMAIL PROTECTED]
> 
> But its not that clear, though - look at this part:
> 
> "As long as you never distribute (internally or externally) the MySQL
> Software in any way, you are free to use it for powering your
> application, irrespective of whether your application is under GPL or
> other OSI approved license or not.
> "
> 
> So, I would interpret that as saying that if you wrote a web 
> application
> or a win32 application that just connects to a centrally located mysql
> database and runs queries, no need to GPL your software.  If your app
> comes with an installer that installs the app as well as mysql, its
> gotta be GPL or you have to purchase a commercial license.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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: [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: Oracle releases by the different platforms...

[DENNIS WILLIAMS]

Mark - Good article. What I've seen in the press on "the story behind the
headlines" is that the lawsuit is all SCO has left. Hicks has hinted that a
buyout from IBM would be an okay thing. Sounds like he wants to ratchet up
the noise until IBM feels it is cheaper to buy SCO and bury the issue. I'm
sure Hicks is not anticipating a management career with IBM. I would
speculate that he has his golden parachute all loaded and ready.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, June 19, 2003 9:13 AM
To: Multiple recipients of list ORACLE-L


This may not be a bad idea in the not too distant future April! :



http://theregister.com/content/53/31234.html

SCO pulls AIX licence, calls for permanent ban
By Ashlee Vance in San Francisco
Posted: 16/06/2003 at 22:54 GMT

Terminating IBM's AIX licence wasn't enough for the SCO Group on Monday. The
company has asked for a permanent injunction blocking IBM from shipping AIX.

To steal a line from Bill Hicks, SCO's balls are so big, you would need a
wheelbarrow to cart them about. The court has already ordered extra support
for the witness stand.

SCO had warned IBM this day would come. The IP squad gave IBM 100 days to
explain why bits of AIX kept popping up in Linux source code. With the
deadline now passed, SCO has called for IBM to stop shipping anything that
uses Unix System V source code, namely the AIX operating system.

Existing customers are to flush their copies of AIX, according to SCO.

Buster Gonads

This move was expected. It's the amendment to SCO's lawsuit that really
calls for the wheelbarrow to be rolled out.

SCO wants IBM "to destroy or return all copies of Unix Systems V source
code", to cough up more cash in damages tied to AIX server sales and to
never use or ship AIX again.

IBM is telling its customers that everything is fine.

"IBM's Unix licence is irrevocable, perpetual and fully paid up," the
company said in a statement. "It cannot be terminated.

"IBM will continue to ship, support and develop AIX, which represents years
of IBM innovation, hundreds of millions of dollars of investment and many
patents."

IBM's composure is appreciated, but there are more than a few legal scholars
out there that think SCO has a case.

Sun has taken delight in watching this IP battle play out. Scott McNealy,
CEO at Sun, said the company paid $100 million to use Unix "free and clear".

Even though Sun is backing Linux now, it has tended to be very selective
about the Unix technology it's willing to put into the public domain.
There's no need for Linux to grow up too fast if you are in the Solaris
camp.

Sun, however, has partnered with Red Hat, which should be a bit of a worry,
since McNealy expects SCO to tackle Linux makers and users should it win a
court battle against IBM.

"If SCO wins against IBM, they will go after people with smaller pockets,"
McNealy said, during JavaOne last week. Didn't Sun have remarkable timing
with its decision to start promoting Solaris x86 right before the SCO/IBM
war broke out?

Any concerned AIX users out there are urged to go to SCO's homepage and
chant, "Relax, Worry-Free Software" until the nerves settle. Look past the
box, toward the ocean and breathe deep.



I think I may become a corporate lawyer, they must be making tons out of the
big guys lately!

Mark

-Original Message-
Wells
Sent: 19 June 2003 14:10
To: Multiple recipients of list ORACLE-L


NO PLEASE don't tell me that we have been coupled with
Windows  Say it aint so!!!

I'm thinking we really need to migrate from AIX to Linux!

April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path when you come upon it, because you will
suddenly have all the energy and imagination you will ever need.
~ Jerry Gillies ~
-Original Message-
Sent: Wednesday, June 18, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L


Greg:

  Order is
Solaris (development platform base)
HP-UX, Linux - Same time
AIX, Windows - Same time
OpenVMS
MVS


Thank You

Stephen P. Karniotis
Strategic Alliance Manager
Compuware Corporation
Direct:  (313) 227-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:  www.compuware.com

-Original Message-
Sent: Tuesday, June 17, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L

does anyone have a reasonable idea about which Hardware platforms and their
order that Oracle releases the RDBMS???  For example, SUN,IBM,HP,LINUX?
SUN,HP?etc,etc


Thanks in advance!!
Greg




The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.


The inf

Re: Oracle releases by the different platforms...

[Glenn Stauffer]

April Wells wrote:

NO PLEASE don't tell me that we have been coupled with 
Windows  Say it aint so!!!
 
I'm thinking we really need to migrate from AIX to Linux!
 
You have until midnight Friday...

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Glenn Stauffer
 INET: [EMAIL PROTECTED]
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: [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).

9i Ques

[Senthil Kumar D]

Hi Group,

What is the default value of Undo_retention?

a. 900
b. 0
c. 10800
d. None of the above

I have selected option a. The answer given by the system is c.

Which one is right. I have checked out with oracle doc's. It says 900. But
db (which has default parameters) says 10800.!

Any answers??

TIA
Senthil

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Senthil Kumar D
  INET: [EMAIL PROTECTED]

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: [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: APPS 11i (Linux) question

[James J. Morrow]

Senthil Kumar D wrote:
Hi Group,
 
I'm installing apps 11.5.8 on Linux 8.
 
Rapidwiz , first unzipping some 55 components. After 54th component is 
hanging and the unzip process is getting "defunct".
 
Anybody faced the same issue during the installation.
 
Any help on this Reg.
 
Thanks,
Senthil.
Yes.  Basically, rapidwiz has decided that your unzip process has taken too long 
and killed it.  So, you have two choices:

1.	(This is the preferred choice)  Download the newest version of the RapidWiz. 
 The problem you are facing exists in the RapidWiz that ships on the media (and 
in the one that immediately followed it).  It should be corrected in the newest 
release of RapidWiz.

2.	(This can be somewhat confusing)  Identify which files did not unzip 
completely (by culling through the log files) and unzip them manually.

Personally, it's just alot easier to download the latest version of RapidWiz 
(The version of RapidWiz on the media is _ALWAYS_ out of date).

As of today (19 June, 2003) the latest patch for RapidWiz is 2981384 (159M - 
Generic Platform) and contains RapidWiz version 11.5.8.18.

You can determine your current version of RapidWiz by running the 
RapidWizVersion command.

-- James

=
James J. Morrow mailto:[EMAIL PROTECTED]
Senior Technical Consultant
Nascent Systems
Dallas, TX
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: James J. Morrow
 INET: [EMAIL PROTECTED]
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: [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: INDEX REBUILD

[John Clarke]

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
<>

RE: MySQL in the future?

[Weaver, Walt]

We've been using MySQL extensively for three years now and haven't seen
any of this kind of behavior. In fact, MySQL AB has been very enjoyable
to work with and we've been able to bend their ear to put features into
MySQL that we'd like to have. And, as Tim Bunce says, we've found their
support to be excellent. 

We pay a certain amount for licensing fees and support, but it's
miniscule compared to the Oracle licenses we have to pay for.

--Walt (an Oracle bigot, but pretty impressed with MySQL) Weaver
  Bozeman, Montana

> -Original Message-
> From: Goulet, Dick [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 8:13 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: MySQL in the future?
> 
> I think we've all seen and are once again seeing a similar maneuver.
Can
> you get MySql from mysql.org, sure but it's going to be left way in
the
> dirt by MySql AB until their version is the only acceptable one out
there.
> Course by then it probably will acquire a different name. and of
course a
> higher price tag.  Only the lawyers win!!!
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
> 
> -Original Message-
> Sent: Wednesday, June 18, 2003 11:35 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I'm glad I'm not a lawyer. What does distribute internally mean? I
work
> for company X and write an application to use a MySQL database. I take
the
> zip file I downloaded from MySQL and install it to another server, and
now
> two sets of people are using the database on different machines with
the
> same application. Does that mean I distributed it internally?
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

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: [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: AQ, RAC and delay

[Rajesh . Rao]

With MPCD=0, Is your primary wait event shown as "on-going reading of SCN
to complete" in the statspack reports? Oracle Support insisted we set it to
7 coz of this.

Raj



   

"K 

Gopalakrishnan   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
"cc:   

<[EMAIL PROTECTED]   Subject: RE: AQ, RAC and delay

o.com> 

Sent by:   

[EMAIL PROTECTED]  
   
ity.com

   

   

06/19/2003 

10:29 AM   

Please respond 

to ORACLE-L

   

   





Hemant:

You are right. 7 seconds is the MAX difference,  but the control files are
synced
every 3 seconds during the 'split brain' check. So most of the cases, it is
3 seconds
with the maximum of 7 seconds subject to the MCPD settings.

KG



Best Regards,
K Gopalakrishnan




-Original Message-
Hemant K Chitale
Sent: Thursday, June 19, 2003 5:38 AM
To: Multiple recipients of list ORACLE-L


Although MCPD may default to 700centiseconds [although I have seen a much
lower value on 9.2 on Tru64],
in most cases, delays of 7seconds don't occur [and shouldn't be acceptable
?!].

I do have a 9iRAC environment but am comfortably using mcpd=0.
And I have AQ in an 8.1.7 single-instance environment.
So I can't make any statements about AQ in OPS/RAC !

Hemant

At 07:05 AM 17-06-03 -0800, you wrote:

 A colleague casually mentioned that in RAC, the test to de-queue an AQ
 set-up from BOTH instances didn't succeed. The side where we were
 enqueuing was able to see queued messages faster than the 'other'
 side. About 7-8 seconds ... that got me thinking ... is this an effect
 of MCPD which defaults to like 7 seconds?

 Do you use AQ in RAC and enqueue/dequeue on both nodes? What is your
 experience?

 ps: mcpd - max commit propagation delay
 TIA
 Raj
 

 Rajendra dot Jamadagni at nospamespn dot com
 All Views expressed in this email are strictly personal.
 QOTD: Any clod can have facts, having an opinion is an art !


Hemant K Chitale




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [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: Partitions of table read only

[Richard Foote]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 5:59 AM


> Jack, maybe this has been covered. I seem to recall from the B&R module
> (knew it would prove useful sometime) that after you make a tablespace
> read-only that you should take a backup. Recovering a database with
> tablespaces that were read-write when backed up but are read-only now
> requires an extra step or two (something I never like in a recovery).
>

Hi Dennis

Backing up the tablespace files (and lets not forget the control file) is
certainly not a bad idea.

Something else that many don't consider is to select from all objects within
the tablespace with full scans *before* making the tablespace read only.
This has the effect of performing all the necessary block cleanouts (ie. for
all the blocks written to disk before they could be committed and cleaned
out in memory) while Oracle still can.

If the tablespace is made read only and some poor blocks haven't been
cleaned out, upon reading the block Oracle has no choice but to go to the
rollback/undo segments in it's attempt to confirm the consistency of the
block. However upon confirming that indeed the transaction is long gone and
block cleanout can take place with the "latest possible SCN", it can't
actually perform the necessary block changes because, you guessed it,  the
tablespace is currently read only.

This means that the overhead of checking for consistency but failing to
actually perform the block cleanout continues on and on and on ...

Hence the suggestion to guarantee block cleanout while the tablespace is in
a position to do so (in read/write mode).

Cheers

Richard Foote


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Foote
  INET: [EMAIL PROTECTED]

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: [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: MySQL in the future?

[Stephen Lee]

I say it's time to resurrect ndbm!
We KNOW that one is free ... and it's already there in your OS utilities (if
you are using the right OS).

> -Original Message-
> 
> I think we've all seen and are once again seeing a similar 
> maneuver.  Can you get MySql from mysql.org, sure but it's 
> going to be left way in the dirt by MySql AB until their 
> version is the only acceptable one out there.  Course by then 
> it probably will acquire a different name. and of course a 
> higher price tag.  Only the lawyers win!!!
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [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: MySQL in the future?

[Goulet, Dick]

Richard,

Now this is interesting.  When you enter www.mysql.org into your browser you 
get forwarded onto www.mysql.com.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Wednesday, June 18, 2003 5:15 PM
To: Multiple recipients of list ORACLE-L


Dick,

That's the commercial version your link points to which provides
additional functionality like InnoDB.  But you can get free MySQL
from www.mysql.org.

Richard

-Original Message-
Sent: Wednesday, June 18, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L


Richard,

Oh Contrare, if your using MySql for a commercial purpose then you owe MySql 
AB in Germany $475 US, at last look.  Here's from their web site 
(http://www.mysql.com/products/licensing.html):

MySQL Licensing 

Policy In Brief

This is our licensing policy in brief: Our software is 100% GPL, and if yours is 
also 100% GPL (or OSI compliant), then you never have to pay us for the 
licences. In all other instances, you are better served by our commercial 
licence. Read the details below! Licensing

MySQL software is licensed under the GPL license. The formal terms of the GPL 
license can be found in the GNU General Public License section of the MySQL 
Reference Manual.

MySQL is also available under commercial non-GPL license. For pricing and 
ordering information, see our online store 1. Free use for those who are 100% 
GPL

If your application is licensed under GPL or compatible OSI license approved by 
MySQL AB, you are free and welcome to ship any GPL software of MySQL AB with 
your application. By "application" we mean any type of software application, 
system, tool or utility. For doing this, you do not need a separate signed 
agreement with MySQL AB, because the GPL text is sufficient. But we do recommend 
you to be in touch with us as there usually are good opportunities for 
partnership and co-marketing. 2. Free use for those who never copy, modify or 
distribute

As long as you never distribute (internally or externally) the MySQL Software in 
any way, you are free to use it for powering your application, irrespective of 
whether your application is under GPL or other OSI approved license or not.

More specifically:

Modifying - You are allowed to modify MySQL Software source code any way you 
like. If you distribute the modified version, all changes, all interface code 
and all code that connects directly or indirectly to the interface code fall 
under GPL.

Copying - You are allowed to copy MySQL binaries and source code, but when you 
do so, the copies will fall under the GPL license. 3. Commercial use for 
everyone else

If your application is not licensed under GPL or compatible OSI license approved 
by MySQL AB and you intend to distribute MySQL software (be that internally or 
externally), you must first obtain a commercial license to the MySQL software in 
question.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Wednesday, June 18, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L


Yes, agreed.  But out of all the MySql running out there, how
many of them do you think people purchased support for?  People
run MySql just like Apache because it's free.  And they get most
of the support through internal mailing-list, groups etc.

Richard

-Original Message-
Sent: Wednesday, June 18, 2003 12:55 PM
To: Multiple recipients of list ORACLE-L


Richard,

I believe someone else here put the magic phrase on the subject.  Support.  
MySql has a commercial company that you can buy support from, namely MySQL.  
PostGreSql use to have a vendor who would sell you a support contract, Great Bridge 
Software.  Don't know what happen to them.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Wednesday, June 18, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L


Glad to see another PostGresql like here.  I always wonder
why is MySql bigger than PostGreSql when it was inferior.
My guess is that it was widely used as Web logging, site logging
as an alternative to file based logging where people don't care
much about transaction 'n such.

Richard Ji

-Original Message-
Sent: Wednesday, June 18, 2003 9:50 AM
To: Multiple recipients of list ORACLE-L


Jesse,

In the Open Source world I'm becoming a PostGreSql bigot.  While there are a 
lot of folks out there using MySql I believe they acquired an inferior product.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Tuesday, June 17, 2003 6:00 PM
To: Multiple recipients of list ORACLE-L


I haven't really used either in-depth, but the features of PostrgeSQL
http://advocacy.postgresql.org/advantages/ seem to be a lot closer to
"Enterprise" than MySQL 4.x, IMHO.  Then again, I'm an Oracle bigot -- for
now.  :)

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech I

Re: ORA-01555 with Automatic Undo Management mode

[Thomas Day]

I looked through metalink (doc 40689.1) and I don't see how the delayed
block cleanout scenario could happen (in my case) given that there was only
one transaction running.

I'm still stuck with that last 4g block that was allocated with only 3G of
free space remaining.  Also, that filespace was not autoextensible.

SQL> select * from dba_data_files where tablespace_name = 'UNDOTBS1';

FILE_NAME

   FILE_ID TABLESPACE_NAME   BYTES BLOCKS
STATUSRELATIVE_FNO AUT   MAXBYTES  MAXBLOCKS INCREMENT_BY
-- --  --
-  --- -- -- 
USER_BYTES USER_BLOCKS
-- ---
D:\ORACLE92\ORADATA\EID9SNP\UNDOTBS01.DBF
 2 UNDOTBS1209,715,200  25600
AVAILABLE2 YES 3.4360E+104194302  640
 209649664   25592

D:\ORACLE92\ORADATA\EID9SNP\UNDOTBS02.DBF
25 UNDOTBS1  7,340,032,000 896000
AVAILABLE   25 NO   0  00
7339966464  895992


SQL> select tablespace_name, initial_extent, next_extent, status,
extent_management, allocation_type, segment_space_management
  2  from dba_tablespaces where  tablespace_name = 'UNDOTBS1';

TABLESPACE_NAMEINITIAL_EXTENT NEXT_EXTENT STATUS
EXTENT_MAN ALLOCATIO SEGMEN
-- -- --- -
-- - --
UNDOTBS165536 ONLINELOCAL
SYSTEMMANUAL



The snapshot built just fine (7G in 9.5 hrs) using rollback segments -
RBS_LARGE below.


Map of Tablespace rbs2
   File
OWNER  OBJECT  Id BLOCK_ID BLOCKS
BYTES
-- ---  -- --

SYSRBS_LARGE   249  25600
209,715,200
SYSRBS_LARGE   2425609  25600
209,715,200
SYSRBS_LARGE   2451209  25600
209,715,200
SYSRBS_LARGE   2476809  25600
209,715,200
SYSRBS_LARGE   24   102409  25600
209,715,200
SYSRBS_LARGE   24   128009  25600
209,715,200
SYSRB3 24   153609  25600
209,715,200
SYSRB3 24   179209  25600
209,715,200

You can't argue with success and we're out of time so automatic undo bites
(bytes) the dust on this database.  I haven't given up on it, I just don't
have enough time to make it work here.



   

  "Darrell 

  Landrum" To:  Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
 Subject: Re: ORA-01555  with Automatic 
Undo Management mode 
  Sent by: 

  ml-errors

   

   

  06/19/2003 08:44 

  AM   

  Please respond   

  to ORACLE-L  

   

   





>>Are you certain that the 1555 was caused by extent stealing?

Nope, not certain at all.

>>> [EMAIL PROTECTED] 06/18/03 09:54PM >>>
Darrell,
The space management algorithm is such that free extent acquisition

is the second method for undo alloc

RE: Oracle releases by the different platforms...

[Jamadagni, Rajendra]

Title: RE: Oracle releases by the different platforms...





I think everyone should read http://www.forbes.com/2003/06/18/cz_dl_0618linux.html


Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 19, 2003 10:13 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle releases by the different platforms...



This may not be a bad idea in the not too distant future April! :



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2