RE: Doubts reg :Export and import

[Tatireddy, Shrinivas (MED, Keane)]

If we use compress=y in export, it will compress the whole table table
data into a single extent. if not, the table will be exported as is with
same extent sizes.

you must be carefule to use compress=y.

'coz in the target, while doing import, your import may fail,if it
doesnt find contiguous space to allocate such a big extent for that
table.(if the source table is very big)

eg: exported table size is 2 gig. Can your system find 2 Gig contiguous
space in the target.? (as this is a single extent)

HTH
Srinivas
-Original Message-
Sent: Saturday, December 01, 2001 12:45 AM
To: Multiple recipients of list ORACLE-L


The compress=y compesses your brain while it exports, if you dont want
you brain compressed then do compress=n.  But if your brain is all ready
in a compressed state, then they work the opposite.

joe


Alex Hillman wrote:
> 
> Another one that apparently has access to e-mail but not to the
internet to
> RTFM :-) . Or maybe s/he knows how to write but cannot read or maybe
can
> read e-mails but cannot read FM etc.
> 
> Alex Hillman
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
sangeetha
> > Sent: Wednesday, November 28, 2001 12:16 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Doubts reg :Export and import
> >
> >
> > hi list,
> >
> > what is the exact use of mentioning 'compress' yes
> > or no while exportingwill this store the .dmp file
> > in compressed format in system,if given 'yes'.
> >
> > while importing the dumpfile why is it necessary to
> > give 'fromuser',is 'touser' not enough.
> >
> > sangeetha
> >
> > __
> > Do You Yahoo!?
> > Yahoo! GeoCities - quick and easy web site hosting, just
$8.95/month.
> > http://geocities.yahoo.com/ps/info1
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: sangeetha
> >   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: Alex Hillman
>   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)

-- 
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Export/Import Job

[John Kanagaraj]

Nick,
 
Export/Import on an Oracle Apps database is not very well supported. It is
my understanding (from another list) that a bug (or is that a feature :)
currently exists. This may not be applicable in your situation. A loss of
Java objects has been reported. Keeping in mind that Quest may need to know
about this for a testing scenario, this may be Ok, but not if you want the
Apps database to work from a logical point of view Nick, if you would to
like to follow this up, join the OAUGnet-DBA list at 'www.oaug.net' via the
Web ans search for the thread 'RE: export/import of 11i database - fyi
update'.
 

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Kill your killer-commute! Listen to great commercial-free christian music
24x7 (details at www.klove.com)

** The opinions and statements above are entirely my own and not
those of my employer or clients **


-Original Message-
Sent: Friday, November 30, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L


If anyone out there has a good time estimate for the following export/import
job I would appreciate it.  The goal is to change the DB_BLOCK_SIZE.  
 
Application: Oracle Apps 11i
Database Size: 100GB, actually only about 80GB is used space.
2 CPU HP L-Class machine.  
 
I just need a couple of good estimates of how many days/hours this will
take.   I'm guessing around 3 days...  but I have never done anything this
large before. 
 
Thanks!! 
 
Nick

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Not able to view table

[Tatireddy, Shrinivas (MED, Keane)]

In oracle what ever the case we use while creating object name, the data
dict willbe updated in upper case.

eg: emp/Emp/EMP  are all same for oracle. 

(if table is created without double quotes. eg: create table emp (col1 ,
col2 ..)

But in any case if we want to create any object with specific case we
have to put them in double quotes. 

Next time when you query the object you have to use the same convention.

eg:   "emp"  / "Emp" / "EMP" are different one from the other.

create table "emp"
(col1 
col2 )


if you select 

select * from emp; you cant see anything.

you have to select

selecdt * from "emp";

HTH
Srinivas

-Original Message-
Sent: Friday, November 30, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L


Mark,
I am a really confused with your last statement.
"Have you tried either of the following:

select * from "tblBundleCon";
select * from 'tblBundleCon';

If you really did create them in lower and upper case, this could be
your
problem. Enclosing the table names in double quotes usually solves
this.."

Would you or someone else elaborate on this, pleeaassee?  Are we still
talking Oracle here

-Original Message-
Sent: Friday, November 30, 2001 7:25 AM
To: Multiple recipients of list ORACLE-L


Jyoti,

Did you create the tables as SYSTEM? One thing I will say is that *YOU
SHOULD NOT DO THIS*. When creating objects as SYSTEM, these objects will
be
stored in the SYSTEM tablespace - which is not a good idea. As system,
create another tablespace (if one does not already exist), create a new
user, with a default tablespace of the new tablespace, and use this user
(with the appropriate system/object privileges) to create your
tables/indexes/objects.

On to another point about your mail - the password for SYSTEM is
actually
the default. How about changing that for security reasons? This may just
be
a test box, but there's nothing like good safe practice.

Back to the original question:

Who were you logged on as when you created the tables?
Where did you create them? (tablespace).

Have you tried either of the following:

select * from "tblBundleCon";
select * from 'tblBundleCon';

If you really did create them in lower and upper case, this could be
your
problem. Enclosing the table names in double quotes usually solves
this..

HTH

Mark

-Original Message-
Sent: 30 November 2001 06:50
To: Multiple recipients of list ORACLE-L


Hi all,
I have created with the following details:

Global DB name: manu.ifpjyo
SID:manu
Username:   SYSTEM
Password:manager
Tables:tblBundleCon, tblTextCon, tblFinalImage

I am able to connect to the database:
SQL> connect system@manu
password: ***
Connected.

But I am unable to view the tables that I have created:
SQL>select * from tblBundleCon;
*
ERROR at line 1:
ORA-00942: table or view does not exist

I get the above error. Where am I going wrong,
Thanx a lot in advance.
Jyoti.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  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: 
  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: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: total tranx ran

[Tatireddy, Shrinivas (MED, Keane)]

This will give the peak usage of the transactions, since instance
started, but not the cumulative.



-Original Message-
Sent: Friday, November 30, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L


if you're using Oracle 8
check v$resource_limit.transactions view

HTH
Diego Cutrone

- Original Message - 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 7:05 AM


> Hi lists,
> 
> Does anybody have a query to find , how many transactions ran since
the
> instance started.
> 
> v$transaction will have only the current trnx running.
> 
> is there any other views that will show the total trnx since instance
> startup.
> 
> Thnx and regards,
> 
> Srinivas
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Tatireddy, Shrinivas (MED, Keane)
>   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: Diego Cutrone
  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: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Deleting files on w2k

[Tatireddy, Shrinivas (MED, Keane)]

Title: Deleting files on w2k



    Hi
 
    I got this problem many times,when I 
wokred on win95/98. To resolve this, I used to take the TS offline, shutdown db 
and windows and restart them and did rename.
 
This 
worked for me.
 
Srinivas

  -Original Message-From: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 
  6:10 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Deleting files on w2k
  Lisa,
   
  you 
  can take it offline, and it may release it.  on NT, it does not release 
  the file unless it is not in use.  W2k might be 
  different.
   
  Tom Mercadante Oracle Certified Professional 
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 
3:40 PMTo: Multiple recipients of list 
ORACLE-LSubject: Deleting files on w2k
I'm trying to test out backup and recovery on 
w2k.  However, I can't remove or rename a file while the database is 
running!  It says "file in use".  
Am I missing something or is there a way to force 
this?  
Thanks 
Lisa Koivu Oracle 
Database Monkey Fairfield Resorts, Inc. 
954-935-4117 

Re: Doubts reg :Export and import

[Joe Testa]

The compress=y compesses your brain while it exports, if you dont want
you brain compressed then do compress=n.  But if your brain is all ready
in a compressed state, then they work the opposite.

joe


Alex Hillman wrote:
> 
> Another one that apparently has access to e-mail but not to the internet to
> RTFM :-) . Or maybe s/he knows how to write but cannot read or maybe can
> read e-mails but cannot read FM etc.
> 
> Alex Hillman
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of sangeetha
> > Sent: Wednesday, November 28, 2001 12:16 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Doubts reg :Export and import
> >
> >
> > hi list,
> >
> > what is the exact use of mentioning 'compress' yes
> > or no while exportingwill this store the .dmp file
> > in compressed format in system,if given 'yes'.
> >
> > while importing the dumpfile why is it necessary to
> > give 'fromuser',is 'touser' not enough.
> >
> > sangeetha
> >
> > __
> > Do You Yahoo!?
> > Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
> > http://geocities.yahoo.com/ps/info1
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: sangeetha
> >   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: Alex Hillman
>   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)

-- 
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Doubts reg :Export and import

[Alex Hillman]

Another one that apparently has access to e-mail but not to the internet to
RTFM :-) . Or maybe s/he knows how to write but cannot read or maybe can
read e-mails but cannot read FM etc.

Alex Hillman

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of sangeetha
> Sent: Wednesday, November 28, 2001 12:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Doubts reg :Export and import
>
>
> hi list,
>
> what is the exact use of mentioning 'compress' yes
> or no while exportingwill this store the .dmp file
> in compressed format in system,if given 'yes'.
>
> while importing the dumpfile why is it necessary to
> give 'fromuser',is 'touser' not enough.
>
> sangeetha
>
> __
> Do You Yahoo!?
> Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
> http://geocities.yahoo.com/ps/info1
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: sangeetha
>   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: Alex Hillman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Standby Database

[K Gopalakrishnan]

Richard,

You are right. It is close to Zero data loss. Not exactly Zero Data loss.

Best Regards,
K Gopalakrishnan
Bangalore, INDIA


-Original Message-
Sent: Friday, November 30, 2001 6:45 AM
To: Multiple recipients of list ORACLE-L

Kay, thanks for the explanation.  Sorry for being a pain in butt.  But I see
that the C program will write IMMEDIATELY AS SOON AS the log is written.
But this is not the same as doing it simultaneously.  So there is a chance
(very very
small of course) that after LGWR writes the committed transaction and before
your C program copies the block which contains the change vector that the
system crash and online redo is lost.  Therefore you can guarantee 99.99%
but not 100%?
Am I correct?

Thanks again.

Richard

>>> [EMAIL PROTECTED] 11/29/01 10:45PM >>>


Richard,

Comments inline..

-Original Message-
Sent: Thursday, November 29, 2001 6:40 AM
To: Multiple recipients of list ORACLE-L

This sounds good, but I have a couple of questions.  How do you guarantee
that
you won't lose any committed transactions?  I mean, the C program could lag
behind
the LGWR since it's only reading it without lock and it's copying the online
redo over
to a remote machine.  So for a busy database, the LGWR will just keep
writing and the
C program won't be able to keep up with it's pace.

The external program uses X$KCCCP as a feedback for copying process. X$KCCCP
will have
the current log block (Disk RBA) and this will have the change vectors for
last commit. So you
copy the change vectors/ redo records immediately as soon as it is written.
If LGWR can keep
writing the files means why can't your C program copy the files?

Are you copying the whole partially filled online redo? or just the
difference
since the last commit?
Difference from last copy.. (last commit )



Did I miss understand it?  Please advise.

>>> [EMAIL PROTECTED] 11/29/01 12:40AM >>>

If you want to Zero data loss in standby you can copy the online redo logs
thru an external C program.  You can copy the online redo log files when
the LGWR is writing to it.

The program should read the log files without locking. You can use the fixed
table  X$KCCLE and X$KCCCP to find how much is written in the log files.
The partially filled log file  can be shipped to the standby location and
you can
open the standby database with the new control file created with NORESETLOGs
.

In this way you have a graceful fail over in the standby database and no
committed
Transaction is lost in the standby database

Does this sound good?

Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Sent: Wednesday, November 28, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L

I am also facing the same problem. All these disadvantages in 8i standby DB
have been taken care of in oracle 9i version. The other solution could be to
buy an expensive Veritas Cluster server/Database edition.

Thanks,
-- Janardhana babu

-Original Message-
Sent: Wednesday, November 28, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Quick question.  Is it a fair statement to say that using Oracle's hot
standby database allows you recoverability up to the last archive log, but
would NOT recover to the latest redo log (prior to a log switch).  In other
words, the potential to lose transactions is very high if you depend on this
for failover (not good for e-commerce type databases).  Would it be possible
to somehow mirror redo logs across to the failover server and apply them
when activating the standby database, or is the only real solution
clustering or something like DoubleTake?

Am I making sense?

Thanks,

Ed


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ed
  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: Janardhana Babu
  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).


__

Extract from latest SANS security digest

[Boivin, Patrice J]

Fyi, which company had the most security bugs reported in November?

Section II: Security Alert Summary
4.  Microsoft Security Bulletins

CRITICAL RISK Bulletins
4.1 MS01-056: Windows Media Player .ASF Processor Contains Unchecked
Buffer
*** HIGH RISK Bulletins
4.2 MS01-055: Cookie Data in IE Can Be Exposed or Altered Through
Script Injection
**  MODERATE RISK Bulletins
There were no moderate risk bulletins issued this month.
*   LOW RISK Bulletins
4.3 MS01-054: Invalid Universal Plug and Play Request can Disrupt
System Operation

5.  Additional Microsoft Software Issues

5.1 Internet Explorer Issues
5.1.1   Internet Explorer allows spoofing of file extensions
5.1.2   Internet Explorer file reading vulnerability
5.1.3   Internet Explorer patch existence vulnerability

5.2 Microsoft Office Issues
No issues reported this month.
5.3 Other Microsoft Product Issues
5.3.1   Voyager Alpha Force worm targets Microsoft SQL Server
5.3.2   Flaw in Microsoft Passport Allows Theft of Personal
Information
5.3.3   ISA Server Denial of Service
5.3.4   Windows Terminal Services IP Address Spoofing
5.3.5   Windows 2000 "RunAs" vulnerabilities


6.  Virus Alerts
6.1 Badtrans.B worm
6.2 Aliz worm
6.3 Klez worm variant


7.  Third-Party Software Issues

7.1 Buffer Overflows
7.1.1   Ipswitch WS_FTP Server Buffer Overflow
7.1.2   ActiveState ActivePerl Buffer Overflow
7.1.3   Compaq Insight Manager Buffer Overflow

7.2 Flaw in personal firewall outbound traffic filtering
7.3 DeltaThree PC-to-Phone information disclosure
7.4 Lotus Notes automatic code execution
7.5 RSA WebID vulnerabilities
7.6 CheckPoint VPN-1 account harvesting
7.7 Symantec Raptor Firewall denial of service
7.8 Web Crossing WebX unauthorized access
7.9 Progress Database privilege elevation
7.10Entrust GetAccess directory traversal
7.11Multiple Lotus Domino vulnerabilities
7.12Opera Web Browser cross-site scripting


8.  Updates and Corrections
8.1 Patch Available for Citrix MetaFrame Denial of Service


Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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).

Time Zone

[Hamid Alavi]

Hi List,
Is there any way to handle the TIME ZONE in oracle 8, I know there are some
new features in oracle 9



Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Some 9i Questions - Help!

[Steve McClure]

Something I always consider before upgrading to the latest and 'greatest'
release of any software.

I once worked for an IT manager who had a different opinion on this topic.
He used to say that the biggest problem with being a pioneer was that
historically a lot of pioneers ended up with arrows in their backs.

However, that has nothing to do with the fact that I am currently migrating
our production databases to 8.1.6 from 7.3.4.5.

Steve McCLure

-Original Message-
Sent: Friday, November 30, 2001 9:52 AM
To: Multiple recipients of list ORACLE-L

An edict just came down from our CIO that we should upgrade all our
databases to 9i by the end of the year (he's decided it's important that we
always be on the latest release of all software).

Aside from the fact that other than a small play database we haven't done
any testing yet, aside from the fact that to do this I'd have to cancel all
my holiday plans with friends and family to work every weekend in December
(probably plus Christmas and New Years) to meet this arbitrary deadline, I'm
still nervous about upgrading to such a relatively new release (I wasn't
intending to consider it until late next year).

So, one question and one request.

1.  When was 9i first released for Solaris (I haven't been able to find this
information after poking around the Oracle website)?

2.  Could anyone please post any 9i horror stories you've had?  I know about
the Managed Rollback Segment problem, but since that feature is optional it
doesn't give me a lot of ammunition.

If this was a better job market I'd be contacting my headhunter right now.

Jay Miller
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
  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: Steve McClure
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: DISK LAYOUT & RAID LEVEL

[Edward Shevtsov]

Hi Harvinder,

If I were you I would

- put OS and Oracle executables on a RAID1 volume with minimal raid block size
- put redo log files in "chess order" on two dedicated RAID1 volumes (the odd redo 
groups locate on
the first volume and the even redo groups locate on the second RAID1 volume). It seems 
9Gb disks are
more suited for that goal. I'm still not sure what raid block size should be choosen 
for these
volumes. I assume it should be minimal and cover your average redo write size.
- make a RAID1 volume for archive redo logs, let say 2x36 (depends on the volume of 
your archive
logs)

The most difficult decision I think is how to locate your index, data, rbs, temp and 
what stripe
size to choose. In general it depends on your application. In your case I would prefer 
to have
several RAID volumes in order to be able to balance disk loading on data and indexes. 
Levels RAID1+0
or RAID0+1 are more suitable here.

There are several articles at Steve Adams' site www.ixora.com.au  and good Gaja's 
article about RAID
at www.quest.com

I think 25-30% of RAM is a good start point for SGA.

Regards,
Ed

> Hi,
>
> We have to do benchmarks tests(scalability,performance) for our product and
> have machine with following
> configuration..We dont have experience for large size databases layout.
> It will be greatly appreciated if someone points out from his experience:
>
> 1) Which raid level to use for which files and on how many disks.
> 2) As we have 10 disks what file to place on which disk.
> 3) How much RAM to use for SGA.(this is database dedicated machine)
>
> Server - E3500 with 2 internal boot disks (18GB)
>   4 400MHZ/8MB ecache and 2 GB ram
>   2 I/O boards
>
>  Arrays - HDS 9210 Fiber channel array with 10 36GB disks @ 10K RPM with
>  5.7 read and 6.5 write seek.
> Sun A5200 with 22 9GB Seagate drives @ 10KRPM with 5.4 read and
>  6.2 write seek.
>
>  HDS is a hardware based array and the A5200 is software with Veritas VM
>
> Thanks
> -Harvinder
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Harvinder Singh
>   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: Edward Shevtsov
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Resume issues - (Not posting my resume)

[Kimberly Smith]

I have to agree.  In the end I did shorten it but its three pages now.
Not quite as experienced;-)  I did move a few things around so that
my technical stuff is the first thing they see.  Hopefully I won't have to
use
it and I get another contract within the organization but better
safe then sorry.

-Original Message-
WILLIAMS
Sent: Friday, November 30, 2001 2:40 PM
To: Multiple recipients of list ORACLE-L


Bambi - Excellent. I printed it and it is going into my "off-site
repository". I especially like your point to Make Your Resume Friendly to
The People Making Small Piles of Big Piles. If you've gotten to meet the
people that could hire you, then the resume is just a nice addition to your
stunning personality. And if your personality didn't impress then they won't
read any document, no matter how brief. If you aren't to that point, then
the resume has to do the heavy lifting to get you past HR. At that point you
ARE your resume. Your resume's job is to get into the small pile. A 10-page
epistle full of technical gobbeldy-gook will just convince him/her that you
will probably be a headache. Put those technical buzzwords where they are
easy to find. If you are selling your Oracle expertise, put that in bold
type near the top of page 1. Don't hide it among an alphabetized list of
every database you have ever touched. Well, time to shut up and go home.
Have a nice weekend.

-Original Message-
Sent: Friday, November 30, 2001 3:10 PM
To: Multiple recipients of list ORACLE-L


Dennis --

I sent Kimberly my tips offline (and my resume) but thought I would forward
my tips based on nearly 24 years of experience to you folks in case you find
it of value.  If so, great, if not, oh well, but they were lessons learned
over the years and apply to all jobs, contract and perm.

If you have a boodle of experience, great.  Don't hide it.  But if your
resume is going to be over two pages, go ahead and add a page to the front.
The first page should be all the buzzwords that people are looking for,
broken up into categories:

Education
Hardware
Databases
Languages
Software
Security Clearances
Certifications
Publications
Major Industries That You Know Well (ie., not just database administration
but a good knowledge of a good segment of the industry itself)

That way, nobody has to fish on your resume for words like Oracle, Unix,
C++, PeopleSoft or "Oil and Gas".  If HR people are looking through a pile
of resumes for those buzzwords, the faster you can get into the smaller pile
of people who have those skills, the better off you are.  If someone has to
wade through 4 pages just to see a skill they're looking for, you can pretty
much assume they're not going to take the time.  A-Number-One rule in
job-hunting is Make Your Resume Friendly to The People Making Small Piles of
Big Piles.  The person you're actually going to be working for won't get to
be impressed by all the cool stuff you've done if he/she never gets the
resume.

Work experience (if you've been an employee most of your professional
career) or project experience (if you've been a consultant most of your
professional career) should follow.  Write about the major things you've
done at your jobs/clients in paragraphs.  Use whole sentences.  Pretend that
you are as comfortable with the written word as you are with grep and awk.
Some people say bullet points with action verbs are the way to go; I don't
agree.  You have a small amount of space to demonstrate "verbal and written
communication skills" (which is a requirement for EVERY JOB), make the most
of it.

As for which jobs to list and which not to, my rule of thumb is that if
you've been at a particular job/client for more than 6 months, it should be
listed by name, you might want to modify that to suit your experience.
Regardless, if you've been doing a bunch of short-term projects, you can
clump them in together in a single paragraph that shows a particular chunk
of time with only your major clients listed by name in there.  If you have
minor clients (companies nobody's ever heard of) in that chunk of time,
don't bother listing them, even if you have no major clients in there.
There's no shame in saying "small business" or "mid-size corporation" rather
than "Joe's Barbershop" or "Peppers Waterbeds".  When you have client with a
household name, their name should appear in the paragraph.

If you did vastly different things for different clients on a short-term
basis, it is still better to cluster them together than not to.  You'd
rather look like a stable person with a variety of skills than a huge
job-hopper who never stays anywhere very long (even if the latter is
substantially more true than the former).

One mistake to avoid:  if you've been at a client for 12 years, the
paragraph doesn't have to be long to prove it.  You may have a shorter
paragraph for a long job where your job function was clearly defined than a
much shorter job where you were a maverick/firefighter/janitor.

And if your res

RE: RMAN disaster recovery

[Orr, Steve]

> I START TO LOAD THE RMAN BACKUP FILE TO /ora01 AND DISCOVER THE NEW
> SYSTEM DOESN'T HAVE THAT DEVICE. Do I simply create a link and RMAN 
> will be fine with that?

I vaguely recall that prior versions of the docs did not support this but
now I see no such "non-support warning" from Oracle (in the 817 docs) so
symbolic links "should" be fine as long as you ensure that they resolve to
the same name as occurs in the control files. Quoting page 10-123 of the
manual:

"If datafile filenames are symbolic links, that is, files that point to
other files, then the control file contains the filenames of the link files
but RMAN performs I/O on the datafiles pointed to by the link files. If a
link file is lost and you restore a datafile without first re-creating the
symbolic link, however, then RMAN restores the datafile to the location of
the link file rather than to the location pointed to by the link."

Of course you should test this... and let us know how it turns out. :-)

If you have trouble with the symbolic links then you can always fall back to
the "Oracle sanctioned" method Tom pointed out. It's in the section titled,
"Moving the Target Database to a New Host with a Different File System,"
page 6-7. I did this using control files (nocatalog) and it worked just
fine.

For comfort factor, I'd recommend that you create the smallest test database
you can and prove the 11 steps in this section by restoring your small test
DB to another machine. Besides, it's a fun thing to do. :-)

Steve Orr
Bozeman, MT


P.S. 
Speaking of "backups," I got my OOW badge and I'm leaving Walt here to hold
down the fort. Between the two of us we've somehow fooled damagement into
thinking that they really need us... but the down side is that we can't both
be out of town at the same time. So when Walt goes to IOUG I have to stay
here as his backup. If you have any more questions about RMAN for the next
week feel free to pummel Walt. Along with other folks on this list, he's one
of the gurus listed in the Acknowledgments of the new "Oracle RMAN Pocket
Reference" from O'Reilly. :-) 



-Original Message-
Sent: Friday, November 30, 2001 2:05 PM
To: Multiple recipients of list ORACLE-L

Thanks for the input, Cherie, Kimberly, Tom

The part I'm still uncertain is as follows - see the sentence in caps below:
On my current system let's say I have RMAN write its backup file to
a disk location "/ora01". I also have my RMAN catalog on a separate server,
and have written an export to my backup tape also.
After my disaster, my hardware vendor offers me the use of a
comparable system at a different location. I grab my backup tape and get in
the car. And if it is a real disaster, maybe it is the older backup out of
the off-site vault.
Let's assume that Oracle is already installed on this new system
just to move the story along as Hollywood would say.
I load my RMAN catalog.
I START TO LOAD THE RMAN BACKUP FILE TO /ora01 AND DISCOVER THE NEW
SYSTEM DOESN'T HAVE THAT DEVICE. Do I simply create a link and RMAN will be
fine with that?
I fire up RMAN and start the recovery process. Using the syntax Tom
provided, I should be able to account for any other device naming or path
naming problems.

Kimberly - we aren't quite talking about the need for a standby database.
This manager's point, and I feel it is a good one, is that if you have been
making backups and storing them off-site, you should be able to mount those
backups on a new machine and get your system back. Eventually. Given a lot
of time. If something catastrophic happens and you say that because the
company didn't spend the big bucks for a duplicate remote data center with a
standby database, the recovery will take a week, that would be survivable.
But if you say that because you switched to this really keen backup method
there is just no way to ever get the data back, well you better make sure
your resume was off-site as well. 
Naturally before we quit making weekly cold backups we are going to
have to actually test this scenario. I assume that the same applies to your
sites also.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Friday, November 30, 2001 11:52 AM
To: Multiple recipients of list ORACLE-L

Also, if that is the type of recovery he wants then sell him on
a standby database.  If you lose your server that severely you
will only be able to get back to the last backup regardless of
where your recovery catalog is (hopefully on another server or
at least backed up).

-Original Message-
Killough
Sent: Friday, November 30, 2001 7:11 AM
To: Multiple recipients of list ORACLE-L

I have never tried to burn my servers to ash, but I usually try to put the
rman catalog on a different server than the ones that it is backing up. You
also need to backup the catalog, which I do w/ a nightly export.

>From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple 

RE: GRANT REFERENCES

[Troiano, Paul (CAP, GEFA)]

What SQL or PL/SQL are you trying to run?


-Original Message-
Sent: Thursday, November 29, 2001 12:53 PM
To: Multiple recipients of list ORACLE-L


Thanks for your reply Paul.

Would you be kind enough to elaborate on the 3rd point.  I thought I
followed but what I implemented gave me this error
ORA-02021: DDL operations are not allowed on a remote database.

Any pointers would be most appreciated.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 10:00 AM


> I haven't done it with the REFERENCES privilige but with others the
> following will work:
>
> 1. create the same user account with the same password in the other
> database.
> 2. grant the appropriate permissions to that user.
> 3. refer to the table with @servicename or create a synonym with the
> @servicename notation. When the user refers to the object the
> username/password from the current instance will be passed to the other
> instance.
>
> -Original Message-
> Sent: Thursday, November 29, 2001 8:50 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi All,
>
> I am trying to GRANT REFERENCES on a table that resides on a different
> database, on a different server. Is this possible and how do I go about
> doing it.
>
> TIA
> E.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Troiano, Paul (CAP, GEFA)
>   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: Ekan Emokpae
  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: Troiano, Paul (CAP, GEFA)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Some 9i Questions - Help!

[Boivin, Patrice J]

I was just wondering... does he have pointy hair?

; )

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Miller, Jay [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, November 30, 2001 1:52 PM
To: Multiple recipients of list ORACLE-L
Subject:Some 9i Questions - Help!

An edict just came down from our CIO that we should upgrade all our
databases to 9i by the end of the year (he's decided it's important
that we
always be on the latest release of all software).

Aside from the fact that other than a small play database we haven't
done
any testing yet, aside from the fact that to do this I'd have to
cancel all
my holiday plans with friends and family to work every weekend in
December
(probably plus Christmas and New Years) to meet this arbitrary
deadline, I'm
still nervous about upgrading to such a relatively new release (I
wasn't
intending to consider it until late next year).

So, one question and one request.

1.  When was 9i first released for Solaris (I haven't been able to
find this
information after poking around the Oracle website)?

2.  Could anyone please post any 9i horror stories you've had?  I
know about
the Managed Rollback Segment problem, but since that feature is
optional it
doesn't give me a lot of ammunition.

If this was a better job market I'd be contacting my headhunter
right now.

Jay Miller
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  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: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Has anyone heard of "Mirror Accessible"?

[DENNIS WILLIAMS]

I'm sure it has a few bugs in Metalink against it so a responsible site
wouldn't implement it until after Jan. 1. ;-)

-Original Message-
Sent: Friday, November 30, 2001 4:00 PM
To: Multiple recipients of list ORACLE-L


Dataguard is available in 901 ... of course we don't use it.

oraclei@angel-TICK2> dgmgrl
DGMGRL for IBM/AIX RISC System/6000: Version 9.0.1.0.0 - Production.

(c) Copyright 2001 Oracle Corporation. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> help
The following commands are available:
quit
exit
showSee "help show" for syntax
enable  See "help enable" for syntax
disable See "help disable" for syntax
help [] 
connect / [@] 
alter   See "help alter" for syntax
create  See "help create" for syntax
remove  See "help remove" for syntax
startup See "help startup" for syntax
shutdownSee "help shutdown" for syntax
DGMGRL> quit

HTH
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Friday, November 30, 2001 4:45 PM
To: Multiple recipients of list ORACLE-L


Can anyone confirm this?  I've been searching technet and metalink and can't
turn up any details.
-- 
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).

RE: Some 9i Questions - Help!

[Jamadagni, Rajendra]

Jay,

Apart from our outstanding RAC problem, I don't have any complaints *right
now* about our instance. 

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!



*1

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.

*1

RE: Resume issues - (Not posting my resume)

[DENNIS WILLIAMS]

Bambi - Excellent. I printed it and it is going into my "off-site
repository". I especially like your point to Make Your Resume Friendly to
The People Making Small Piles of Big Piles. If you've gotten to meet the
people that could hire you, then the resume is just a nice addition to your
stunning personality. And if your personality didn't impress then they won't
read any document, no matter how brief. If you aren't to that point, then
the resume has to do the heavy lifting to get you past HR. At that point you
ARE your resume. Your resume's job is to get into the small pile. A 10-page
epistle full of technical gobbeldy-gook will just convince him/her that you
will probably be a headache. Put those technical buzzwords where they are
easy to find. If you are selling your Oracle expertise, put that in bold
type near the top of page 1. Don't hide it among an alphabetized list of
every database you have ever touched. Well, time to shut up and go home.
Have a nice weekend.

-Original Message-
Sent: Friday, November 30, 2001 3:10 PM
To: Multiple recipients of list ORACLE-L


Dennis --

I sent Kimberly my tips offline (and my resume) but thought I would forward
my tips based on nearly 24 years of experience to you folks in case you find
it of value.  If so, great, if not, oh well, but they were lessons learned
over the years and apply to all jobs, contract and perm.

If you have a boodle of experience, great.  Don't hide it.  But if your
resume is going to be over two pages, go ahead and add a page to the front.
The first page should be all the buzzwords that people are looking for,
broken up into categories:

Education
Hardware
Databases
Languages
Software
Security Clearances
Certifications
Publications
Major Industries That You Know Well (ie., not just database administration
but a good knowledge of a good segment of the industry itself)

That way, nobody has to fish on your resume for words like Oracle, Unix,
C++, PeopleSoft or "Oil and Gas".  If HR people are looking through a pile
of resumes for those buzzwords, the faster you can get into the smaller pile
of people who have those skills, the better off you are.  If someone has to
wade through 4 pages just to see a skill they're looking for, you can pretty
much assume they're not going to take the time.  A-Number-One rule in
job-hunting is Make Your Resume Friendly to The People Making Small Piles of
Big Piles.  The person you're actually going to be working for won't get to
be impressed by all the cool stuff you've done if he/she never gets the
resume.

Work experience (if you've been an employee most of your professional
career) or project experience (if you've been a consultant most of your
professional career) should follow.  Write about the major things you've
done at your jobs/clients in paragraphs.  Use whole sentences.  Pretend that
you are as comfortable with the written word as you are with grep and awk.
Some people say bullet points with action verbs are the way to go; I don't
agree.  You have a small amount of space to demonstrate "verbal and written
communication skills" (which is a requirement for EVERY JOB), make the most
of it.

As for which jobs to list and which not to, my rule of thumb is that if
you've been at a particular job/client for more than 6 months, it should be
listed by name, you might want to modify that to suit your experience.
Regardless, if you've been doing a bunch of short-term projects, you can
clump them in together in a single paragraph that shows a particular chunk
of time with only your major clients listed by name in there.  If you have
minor clients (companies nobody's ever heard of) in that chunk of time,
don't bother listing them, even if you have no major clients in there.
There's no shame in saying "small business" or "mid-size corporation" rather
than "Joe's Barbershop" or "Peppers Waterbeds".  When you have client with a
household name, their name should appear in the paragraph.

If you did vastly different things for different clients on a short-term
basis, it is still better to cluster them together than not to.  You'd
rather look like a stable person with a variety of skills than a huge
job-hopper who never stays anywhere very long (even if the latter is
substantially more true than the former).

One mistake to avoid:  if you've been at a client for 12 years, the
paragraph doesn't have to be long to prove it.  You may have a shorter
paragraph for a long job where your job function was clearly defined than a
much shorter job where you were a maverick/firefighter/janitor.

And if your resume has to be 5 pages, then it has to be 5 pages.  There's a
limit to how small you can make the type and how short you can make the
paragraphs.  You still need your resume to be your representative, and if
you've been in the field for a long time, you sometimes just can't be
represented by one page.  

Hope this helps...
Bambi.
-Original Message-
Sent: Friday, November 30, 2001 1:56 PM
To: Multiple recipient

RE: Deleting files on w2k

[Jack C. Applewhite]

Title: Deleting files on w2k



Lisa,
 
You've 
got to stop the Oracle Service for the Instance.  Then you can delete 
files.
 
Jack
Jack C. 
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, 
Inc.Austin, 
Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Friday, November 30, 2001 2:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Deleting files on w2k
  I'm trying to test out backup and recovery on w2k.  
  However, I can't remove or rename a file while the database is running!  
  It says "file in use".  
  Am I missing something or is there a way to force 
  this?  
  Thanks 
  Lisa Koivu Oracle Database 
  Monkey Fairfield Resorts, Inc. 954-935-4117 

RE: Has anyone heard of "Mirror Accessible"?

[Jamadagni, Rajendra]

Dataguard is available in 901 ... of course we don't use it.

oraclei@angel-TICK2> dgmgrl
DGMGRL for IBM/AIX RISC System/6000: Version 9.0.1.0.0 - Production.

(c) Copyright 2001 Oracle Corporation. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> help
The following commands are available:
quit
exit
showSee "help show" for syntax
enable  See "help enable" for syntax
disable See "help disable" for syntax
help [] 
connect / [@] 
alter   See "help alter" for syntax
create  See "help create" for syntax
remove  See "help remove" for syntax
startup See "help startup" for syntax
shutdownSee "help shutdown" for syntax
DGMGRL> quit

HTH
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Friday, November 30, 2001 4:45 PM
To: Multiple recipients of list ORACLE-L


Can anyone confirm this?  I've been searching technet and metalink and can't
turn up any details.



*1

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.

*1

Export/Import Job

[Nick Wagner]

If anyone out there 
has a good time estimate for the following export/import job I would appreciate 
it.  The goal is to change the DB_BLOCK_SIZE.  
 
Application: Oracle 
Apps 11i
Database Size: 
100GB, actually only about 80GB is used space.
2 CPU HP L-Class 
machine.  
 
I just need a couple 
of good estimates of how many days/hours this will take.   I'm 
guessing around 3 days...  but I have never done anything this large 
before. 
 
Thanks!! 

 
Nick

RE: Has anyone heard of "Mirror Accessible"?

[Miller, Jay]

Can anyone confirm this?  I've been searching technet and metalink and can't
turn up any details.

-Original Message-
Sent: Friday, November 30, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L


Isn't that just in release 2 though?  My understanding is that its not out
yet.

-Original Message-
Sent: Friday, November 30, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L


Ah, this sounds likely.  And it might explain why they were keen on having
us upgrade to 9i.  That's the problem with receiving the request filtered
through two additional levels of people.

Jay Miller

-Original Message-
Sent: Friday, November 30, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L


9i has a new feature on standby databases that let's you run reports in read
only while continuing the managed recovery.  I think they call it a logical
standby database.  See the 9i DataGuard manual for more information.  (I
just happened to be looking into this lately).  This might be what they are
talking about.

Best,

Ed

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 12:05 PM


> Only thing I can think of off the top of my head is a standby database
> opened in read only mode.  Its one of the purposes totted for that
>
> -Original Message-
> Sent: Friday, November 30, 2001 9:47 AM
> To: Multiple recipients of list ORACLE-L
>
>
> My CIO woes continue. My manager has been told by the CIO that Oracle has
a
> product called "mirror accessible" which allows the database to be
mirrored
> for reporting purposes. He wants us to use this product.
>
> Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby
> and Oracle Replication but he says it isn't any of these. Any idea what he
> might be talking about?
>
> Jay Miller
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Miller, Jay
>   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: Kimberly Smith
>   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: Ed
  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: Miller, Jay
  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: Kimberly Smith
  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 con

UTF8 or AL16UTF16

[Harvinder Singh]

Title: Deleting files on w2k



Hi,
We need to store the unicode data in column defined as varchar2 datatype so 
we have to use unicode data set.
In 9i which is the preferred value for (NLS_CHARACTERSET and 
NLS_NCHAR_CHARACTERSET)
UTF8 or AL16UTF16 and why?
Thanks
-Harvinder

RE: Deleting files on w2k

[Kimberly Smith]

Title: Deleting files on w2k



Um, 
port it to Unix

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Friday, November 30, 2001 12:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Deleting files on w2k
  I'm trying to test out backup and recovery on w2k.  
  However, I can't remove or rename a file while the database is running!  
  It says "file in use".  
  Am I missing something or is there a way to force 
  this?  
  Thanks 
  Lisa Koivu Oracle Database 
  Monkey Fairfield Resorts, Inc. 954-935-4117 

RE: Resume issues - (Not posting my resume)

[Bellows, Bambi]

Dennis --

I sent Kimberly my tips offline (and my resume) but thought I would forward
my tips based on nearly 24 years of experience to you folks in case you find
it of value.  If so, great, if not, oh well, but they were lessons learned
over the years and apply to all jobs, contract and perm.

If you have a boodle of experience, great.  Don't hide it.  But if your
resume is going to be over two pages, go ahead and add a page to the front.
The first page should be all the buzzwords that people are looking for,
broken up into categories:

Education
Hardware
Databases
Languages
Software
Security Clearances
Certifications
Publications
Major Industries That You Know Well (ie., not just database administration
but a good knowledge of a good segment of the industry itself)

That way, nobody has to fish on your resume for words like Oracle, Unix,
C++, PeopleSoft or "Oil and Gas".  If HR people are looking through a pile
of resumes for those buzzwords, the faster you can get into the smaller pile
of people who have those skills, the better off you are.  If someone has to
wade through 4 pages just to see a skill they're looking for, you can pretty
much assume they're not going to take the time.  A-Number-One rule in
job-hunting is Make Your Resume Friendly to The People Making Small Piles of
Big Piles.  The person you're actually going to be working for won't get to
be impressed by all the cool stuff you've done if he/she never gets the
resume.

Work experience (if you've been an employee most of your professional
career) or project experience (if you've been a consultant most of your
professional career) should follow.  Write about the major things you've
done at your jobs/clients in paragraphs.  Use whole sentences.  Pretend that
you are as comfortable with the written word as you are with grep and awk.
Some people say bullet points with action verbs are the way to go; I don't
agree.  You have a small amount of space to demonstrate "verbal and written
communication skills" (which is a requirement for EVERY JOB), make the most
of it.

As for which jobs to list and which not to, my rule of thumb is that if
you've been at a particular job/client for more than 6 months, it should be
listed by name, you might want to modify that to suit your experience.
Regardless, if you've been doing a bunch of short-term projects, you can
clump them in together in a single paragraph that shows a particular chunk
of time with only your major clients listed by name in there.  If you have
minor clients (companies nobody's ever heard of) in that chunk of time,
don't bother listing them, even if you have no major clients in there.
There's no shame in saying "small business" or "mid-size corporation" rather
than "Joe's Barbershop" or "Peppers Waterbeds".  When you have client with a
household name, their name should appear in the paragraph.

If you did vastly different things for different clients on a short-term
basis, it is still better to cluster them together than not to.  You'd
rather look like a stable person with a variety of skills than a huge
job-hopper who never stays anywhere very long (even if the latter is
substantially more true than the former).

One mistake to avoid:  if you've been at a client for 12 years, the
paragraph doesn't have to be long to prove it.  You may have a shorter
paragraph for a long job where your job function was clearly defined than a
much shorter job where you were a maverick/firefighter/janitor.

And if your resume has to be 5 pages, then it has to be 5 pages.  There's a
limit to how small you can make the type and how short you can make the
paragraphs.  You still need your resume to be your representative, and if
you've been in the field for a long time, you sometimes just can't be
represented by one page.  

Hope this helps...
Bambi.
-Original Message-
Sent: Friday, November 30, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L

Kimberly - From my admittedly meager experience of job-hunting for both
permanent and contract work, here is my impression:
1. If the resume is for permanent work, keep the resume brief and to the
point. The objective is to keep HR from tossing your resume. Keep it to a
single page and hit the major points that you are selling yourself on.
2. If the resume is for contract work, throw in the kitchen sink. Consulting
companies are always receiving that oddball request for that Forth
programming position and maybe you worked on Forth for one week ten years
ago, but it may turn out that you are the most qualified contractor that can
be located quickly.

I really found the book "What Color is Your Parachute?" to be really good
training. Most of us don't think of job-hunting as a skill to be learned.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, November 30, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L


My resume that gets passed around EDS accounts is 5 pages.  That is a little
long for applying for jo

Re: Deleting files on w2k

[orantdba]

Title: Deleting files on w2k



This has always been a "testing issue" with winnt or win2k.  Files being
read are "locked" by the OS.  I know of no way to override this behaviour.

JH

[EMAIL PROTECTED] wrote:

  
  
  I'm trying to test out backup and recovery on w2k. 
However, I can't remove or rename a file while the database is running! 
It says "file in use".  
  Am I missing something or is there a way to force
this?  
  Thanks
  Lisa Koivu
  Oracle Database Monkey
  Fairfield Resorts, Inc.
  954-935-4117
  
  
  
  

RE: Deleting files on w2k

[Mercadante, Thomas F]

Title: Deleting files on w2k



Lisa,
 
you 
can take it offline, and it may release it.  on NT, it does not release the 
file unless it is not in use.  W2k might be different.
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 
  3:40 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Deleting files on w2k
  I'm trying to test out backup and recovery on w2k.  
  However, I can't remove or rename a file while the database is running!  
  It says "file in use".  
  Am I missing something or is there a way to force 
  this?  
  Thanks 
  Lisa Koivu Oracle Database 
  Monkey Fairfield Resorts, Inc. 954-935-4117 

RE: RMAN disaster recovery

[DENNIS WILLIAMS]

Thanks for the input, Cherie, Kimberly, Tom

The part I'm still uncertain is as follows - see the sentence in caps below:
On my current system let's say I have RMAN write its backup file to
a disk location "/ora01". I also have my RMAN catalog on a separate server,
and have written an export to my backup tape also.
After my disaster, my hardware vendor offers me the use of a
comparable system at a different location. I grab my backup tape and get in
the car. And if it is a real disaster, maybe it is the older backup out of
the off-site vault.
Let's assume that Oracle is already installed on this new system
just to move the story along as Hollywood would say.
I load my RMAN catalog.
I START TO LOAD THE RMAN BACKUP FILE TO /ora01 AND DISCOVER THE NEW
SYSTEM DOESN'T HAVE THAT DEVICE. Do I simply create a link and RMAN will be
fine with that?
I fire up RMAN and start the recovery process. Using the syntax Tom
provided, I should be able to account for any other device naming or path
naming problems.

Kimberly - we aren't quite talking about the need for a standby database.
This manager's point, and I feel it is a good one, is that if you have been
making backups and storing them off-site, you should be able to mount those
backups on a new machine and get your system back. Eventually. Given a lot
of time. If something catastrophic happens and you say that because the
company didn't spend the big bucks for a duplicate remote data center with a
standby database, the recovery will take a week, that would be survivable.
But if you say that because you switched to this really keen backup method
there is just no way to ever get the data back, well you better make sure
your resume was off-site as well. 
Naturally before we quit making weekly cold backups we are going to
have to actually test this scenario. I assume that the same applies to your
sites also.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]



-Original Message-
Sent: Friday, November 30, 2001 11:52 AM
To: Multiple recipients of list ORACLE-L


Also, if that is the type of recovery he wants then sell him on
a standby database.  If you lose your server that severely you
will only be able to get back to the last backup regardless of
where your recovery catalog is (hopefully on another server or
at least backed up).

-Original Message-
Killough
Sent: Friday, November 30, 2001 7:11 AM
To: Multiple recipients of list ORACLE-L


I have never tried to burn my servers to ash, but I usually try to put the
rman catalog on a different server than the ones that it is backing up. You
also need to backup the catalog, which I do w/ a nightly export.


>From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RMAN disaster recovery
>Date: Fri, 30 Nov 2001 06:25:23 -0800
>
>I am wondering how RMAN would work for disaster recovery. Our manager's
>statement is "assume your server is reduced to a pile of ash. Now take your
>backup tape and build me a new system on a loaner from the vendor." I am
>trying to figure how that would work with RMAN. We are still at the stage
>of
>just using RMAN to create disk copies, and we are on Compaq Tru64 UNIX. He
>wants us to demonstrate that level of recoverability, but I'm not sure how
>that would work. I think we could assume that we have a database to load
>the
>RMAN catalog from an export.
>   One issue would be whether the disk location of the RMAN files might
>be different, and I'm not sure how to get RMAN to accept a different
>location. A more minor issue is if the database file locations are
>different, but I think that is pretty well documented.
>   Has anyone else tried this? What am I overlooking? Any ideas will be
>appreciated.
>Dennis Williams
>DBA
>Lifetouch, Inc.
>[EMAIL PROTECTED]
>
>--
>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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-

RE: Some 9i Questions - Help!

[David Wagoner]

"How the CIO Stole Christmas" ...

The Grinch would be jealous!


We upgraded a small-ish production database to 9i in August 2001 on Solaris
2.8.  Took no more than 1.5 - 2 days as I recall.  Much more time to read
the manuals though.  Look at this list's archive and MetaLink for bugs and
gotchas.  Overall, I've really enjoyed using 9i but I'm sure you can find
some serious horror stories and gotchas to provide as evidence for waiting
until after New Years to upgrade.

Happy Holidays.

david

David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide Inc.
4815 Emperor Blvd., Suite 110
Durham, NC 27703
Tel. (919) 941-4645
Fax (919) 474-0735
Email mailto:[EMAIL PROTECTED]
Web http://www.arsenaldigital.com/

 
***  NOTICE  ***
This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, 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 the sender at (919) 941-4645 and delete this e-mail
message from your computer.  Thank you.

-Original Message-
Sent: Friday, November 30, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L

An edict just came down from our CIO that we should upgrade all our
databases to 9i by the end of the year (he's decided it's important that we
always be on the latest release of all software).

Aside from the fact that other than a small play database we haven't done
any testing yet, aside from the fact that to do this I'd have to cancel all
my holiday plans with friends and family to work every weekend in December
(probably plus Christmas and New Years) to meet this arbitrary deadline, I'm
still nervous about upgrading to such a relatively new release (I wasn't
intending to consider it until late next year).

So, one question and one request.

1.  When was 9i first released for Solaris (I haven't been able to find this
information after poking around the Oracle website)?

2.  Could anyone please post any 9i horror stories you've had?  I know about
the Managed Rollback Segment problem, but since that feature is optional it
doesn't give me a lot of ammunition.

If this was a better job market I'd be contacting my headhunter right now.

Jay Miller
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
  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: David Wagoner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Resume issues - (Not posting my resume)

[Don Granaman]

One page?!?!!?  My one page resume would have to just say "Call me for
details"!  Two would be cutting to the bone!

-Don Granaman
[OraSaurus]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 1:56 PM


> Kimberly - From my admittedly meager experience of job-hunting for
both
> permanent and contract work, here is my impression:
> 1. If the resume is for permanent work, keep the resume brief and to
the
> point. The objective is to keep HR from tossing your resume. Keep it
to a
> single page and hit the major points that you are selling yourself
on.
> 2. If the resume is for contract work, throw in the kitchen sink.
Consulting
> companies are always receiving that oddball request for that Forth
> programming position and maybe you worked on Forth for one week ten
years
> ago, but it may turn out that you are the most qualified contractor
that can
> be located quickly.
>
> I really found the book "What Color is Your Parachute?" to be really
good
> training. Most of us don't think of job-hunting as a skill to be
learned.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Friday, November 30, 2001 1:26 PM
> To: Multiple recipients of list ORACLE-L
>
>
> My resume that gets passed around EDS accounts is 5 pages.  That is
a little
> long for applying for jobs outside of EDS.  I was wondering how
other folks
> who work for the same type of companies shorting this (companies
like CGI,
> XWave, etc) where you get billed out to various contracts.  If my
> responsibilities on those contracts were always the same I guess it
would be
> easier but sometimes I get billed out to provide one on one
training,
> sometimes I am there for development, sometimes DBA stuff.  You get
the
> idea.  Do you just list all the key things you have done for the
company as
> a whole and leave out the individual contract stuff?  I guess
contractors
> would have the same issue.
>
>
>
> ___
> Kimberly Smith
> Portland, OR
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kimberly Smith
>   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.com
-- 
Author: Don Granaman
  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).

Deleting files on w2k

[Koivu, Lisa]

Title: Deleting files on w2k





I'm trying to test out backup and recovery on w2k.  However, I can't remove or rename a file while the database is running!  It says "file in use".  

Am I missing something or is there a way to force this?  


Thanks


Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117

Re: Has anyone heard of "Mirror Accessible"?

[Don Granaman]

There seems to be a bit of confusion here.  RAC is not related to
"standby database".  DataGuard is the big enhancement for standby
databases in 9i.  RAC is the name for the 9i incarnation of OPS
(Oracle Parallel Server.).  If the "database to be mirrored", then it
is completely independent of OPS/RAC - which shares a single database.
It could be a standby database, geo-mirroring, ...

The term "mirror accessible" sounds like it came from one of those
pseudo-technical trade magazine articles that are famous for
misinforming senior IT management. ;-)

-Don Granaman
[OraSaurus]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 1:10 PM


> Jay - I did a search on Google and that returned nada, so I don't
believe
> that "mirror accessible" is a bona fide term. However, looking at
your words
> "Oracle has a product . . . database to be mirrored for reporting
purposes",
> he might be referring to Oracle9i's Real Application Clusters.
> In the Oracle 8i incarnation, there was a limitation with a standby
> database. The standby could be made current by applying the redo
logs from
> the production database (using recovery), then opened and used for
> reporting. But you couldn't have both - currency and reporting. I
think I
> heard that with Oracle 9i RAC this limitation has been bypassed so
you can
> do reporting while the logs are continuing to be applied. Don't take
my word
> for it (this is Friday after all), but you might want to look at
RAC, and
> maybe someone more knowledgeable than me will respond on this list.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Friday, November 30, 2001 11:47 AM
> To: Multiple recipients of list ORACLE-L
>
>
> My CIO woes continue. My manager has been told by the CIO that
Oracle has a
> product called "mirror accessible" which allows the database to be
mirrored
> for reporting purposes. He wants us to use this product.
>
> Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle
Standby
> and Oracle Replication but he says it isn't any of these. Any idea
what he
> might be talking about?
>
> Jay Miller

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: O/S upgrade

[Hand, Michael T]

Darren,

We gone through several Tru64 versions (4.0d - 4.0g, 5.1) with 8.0.6.  The
Oracle binaries transitioned fine.

Mike

-Original Message-
Sent: Thursday, November 29, 2001 5:57 PM
To: Multiple recipients of list ORACLE-L


I recently upgraded one of my Tru64 Unix system from 4.0f to 5.1.

Can I run the 4.0f compiled 8.0.5 binaries under 5.1, or should they
re-compiled under 5.1.

Also can I copy a database from a 4.0f system to 5.1, or is this a
export/import situation. ?

Thanks

Darren


--
Darren Browett P.EngThis message
was transmitted
Data Administrator  using 100%
recycled electrons 
Information and Communication Technology
City of Coquitlam 
P:(604)927 - 3614 
E:[EMAIL PROTECTED] 

--- 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Browett, Darren
  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: Hand, Michael T
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Crontabs and Oracle

[Rao, Maheswara]

Good idea.

Rao

-Original Message-
Sent: Friday, November 30, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L


What I did is create a file that sets the environment for each database.
This file is sourced in my profile as well as any script I create.
Therefore,
when it comes time to put a script in cron I do nothing but place it
in there.  Plus, that gives me one spot I ever have to change when I
upgrade.  This file takes the database sid as a parameter.

-Original Message-
Maheswara
Sent: Friday, November 30, 2001 7:07 AM
To: Multiple recipients of list ORACLE-L


Tim,

Sourcing a .profile within cron jobs is not a good way doing a shell
scripting.  One big reason --- A .profile might contain a lot of functions
which are OK if you are loggin in with that specific user id.  And those
functions might be doing some job that might affect the cron job.

In my opinion, the correct way is to export the required variables or
setting them in the beginning of the cron job.

Rao

-Original Message-
Sent: Friday, November 30, 2001 5:35 AM
To: Multiple recipients of list ORACLE-L


On Thu, Nov 29, 2001 at 11:15:43AM -0800, [EMAIL PROTECTED] wrote:
>
> I've seen a number of suggestions for sourcing .profile
> in the cron jobs, but this is not always a good idea, as
> .profile often contains script that will not execute when
> not attached to a tty.

I think sourcing .profile is the 'right' thing to do.

If that breaks then the .profile needs fixing as it'll probably
also break things like rsh/rcp etc.

I've seen both these code sytles used (for sh/ksh/bash etc):

if [ "$PS1" ]
then
... interactive stuff here ...
fi

or
case $- in
*i*)
... commands for an interactive shell here ...
;;
*)  ;;
esac

Tim.
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rao, Maheswara
  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: Kimberly Smith
  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: Rao, Maheswara
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Has anyone heard of "Mirror Accessible"?

[Kimberly Smith]

Isn't that just in release 2 though?  My understanding is that its not out
yet.

-Original Message-
Sent: Friday, November 30, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L


Ah, this sounds likely.  And it might explain why they were keen on having
us upgrade to 9i.  That's the problem with receiving the request filtered
through two additional levels of people.

Jay Miller

-Original Message-
Sent: Friday, November 30, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L


9i has a new feature on standby databases that let's you run reports in read
only while continuing the managed recovery.  I think they call it a logical
standby database.  See the 9i DataGuard manual for more information.  (I
just happened to be looking into this lately).  This might be what they are
talking about.

Best,

Ed

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 12:05 PM


> Only thing I can think of off the top of my head is a standby database
> opened in read only mode.  Its one of the purposes totted for that
>
> -Original Message-
> Sent: Friday, November 30, 2001 9:47 AM
> To: Multiple recipients of list ORACLE-L
>
>
> My CIO woes continue. My manager has been told by the CIO that Oracle has
a
> product called "mirror accessible" which allows the database to be
mirrored
> for reporting purposes. He wants us to use this product.
>
> Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby
> and Oracle Replication but he says it isn't any of these. Any idea what he
> might be talking about?
>
> Jay Miller
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Miller, Jay
>   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: Kimberly Smith
>   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: Ed
  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: Miller, Jay
  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: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Resume issues - (Not posting my resume)

[DENNIS WILLIAMS]

Kimberly - From my admittedly meager experience of job-hunting for both
permanent and contract work, here is my impression:
1. If the resume is for permanent work, keep the resume brief and to the
point. The objective is to keep HR from tossing your resume. Keep it to a
single page and hit the major points that you are selling yourself on.
2. If the resume is for contract work, throw in the kitchen sink. Consulting
companies are always receiving that oddball request for that Forth
programming position and maybe you worked on Forth for one week ten years
ago, but it may turn out that you are the most qualified contractor that can
be located quickly.

I really found the book "What Color is Your Parachute?" to be really good
training. Most of us don't think of job-hunting as a skill to be learned.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, November 30, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L


My resume that gets passed around EDS accounts is 5 pages.  That is a little
long for applying for jobs outside of EDS.  I was wondering how other folks
who work for the same type of companies shorting this (companies like CGI,
XWave, etc) where you get billed out to various contracts.  If my
responsibilities on those contracts were always the same I guess it would be
easier but sometimes I get billed out to provide one on one training,
sometimes I am there for development, sometimes DBA stuff.  You get the
idea.  Do you just list all the key things you have done for the company as
a whole and leave out the individual contract stuff?  I guess contractors
would have the same issue.



___
Kimberly Smith
Portland, OR
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  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).

RE: Has anyone heard of "Mirror Accessible"?

[Miller, Jay]

Ah, this sounds likely.  And it might explain why they were keen on having
us upgrade to 9i.  That's the problem with receiving the request filtered
through two additional levels of people.

Jay Miller

-Original Message-
Sent: Friday, November 30, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L


9i has a new feature on standby databases that let's you run reports in read
only while continuing the managed recovery.  I think they call it a logical
standby database.  See the 9i DataGuard manual for more information.  (I
just happened to be looking into this lately).  This might be what they are
talking about.

Best,

Ed

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 12:05 PM


> Only thing I can think of off the top of my head is a standby database
> opened in read only mode.  Its one of the purposes totted for that
>
> -Original Message-
> Sent: Friday, November 30, 2001 9:47 AM
> To: Multiple recipients of list ORACLE-L
>
>
> My CIO woes continue. My manager has been told by the CIO that Oracle has
a
> product called "mirror accessible" which allows the database to be
mirrored
> for reporting purposes. He wants us to use this product.
>
> Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby
> and Oracle Replication but he says it isn't any of these. Any idea what he
> might be talking about?
>
> Jay Miller
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Miller, Jay
>   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: Kimberly Smith
>   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: Ed
  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: Miller, Jay
  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).

Resume issues - (Not posting my resume)

[Kimberly Smith]

My resume that gets passed around EDS accounts is 5 pages.  That is a little
long for applying for jobs outside of EDS.  I was wondering how other folks
who work for the same type of companies shorting this (companies like CGI,
XWave, etc) where you get billed out to various contracts.  If my
responsibilities on those contracts were always the same I guess it would be
easier but sometimes I get billed out to provide one on one training,
sometimes I am there for development, sometimes DBA stuff.  You get the
idea.  Do you just list all the key things you have done for the company as
a whole and leave out the individual contract stuff?  I guess contractors
would have the same issue.



___
Kimberly Smith
Portland, OR
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  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).

Oracle Apps Hints and Techniques

[Molina, Gerardo]

This paper by Craig Ward is a pretty good guide for those dba's new to
Oracle Apps.

It has pretty good coverage on applying patches among other goodies.

http://www.adm.uwaterloo.ca/infofsp/fspupg/techdocs/AppDBAHints.pdf

Gerardo


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Has anyone heard of "Mirror Accessible"?

[DENNIS WILLIAMS]

Jay - I did a search on Google and that returned nada, so I don't believe
that "mirror accessible" is a bona fide term. However, looking at your words
"Oracle has a product . . . database to be mirrored for reporting purposes",
he might be referring to Oracle9i's Real Application Clusters. 
In the Oracle 8i incarnation, there was a limitation with a standby
database. The standby could be made current by applying the redo logs from
the production database (using recovery), then opened and used for
reporting. But you couldn't have both - currency and reporting. I think I
heard that with Oracle 9i RAC this limitation has been bypassed so you can
do reporting while the logs are continuing to be applied. Don't take my word
for it (this is Friday after all), but you might want to look at RAC, and
maybe someone more knowledgeable than me will respond on this list.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, November 30, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L


My CIO woes continue. My manager has been told by the CIO that Oracle has a
product called "mirror accessible" which allows the database to be mirrored
for reporting purposes. He wants us to use this product.

Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby
and Oracle Replication but he says it isn't any of these. Any idea what he
might be talking about?

Jay Miller

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  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).

Ang: Testing

[Roland . Skoldblom]

It is






[EMAIL PROTECTED]@fatcity.com den 2001-11-30 10:40 PST

Sänd svar till [EMAIL PROTECTED]

Sänt av:  [EMAIL PROTECTED]


Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Kopia:


Testing to see if the server is working properly.

Jared


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Has anyone heard of "Mirror Accessible"?

[Ed]

9i has a new feature on standby databases that let's you run reports in read
only while continuing the managed recovery.  I think they call it a logical
standby database.  See the 9i DataGuard manual for more information.  (I
just happened to be looking into this lately).  This might be what they are
talking about.

Best,

Ed

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 12:05 PM


> Only thing I can think of off the top of my head is a standby database
> opened in read only mode.  Its one of the purposes totted for that
>
> -Original Message-
> Sent: Friday, November 30, 2001 9:47 AM
> To: Multiple recipients of list ORACLE-L
>
>
> My CIO woes continue. My manager has been told by the CIO that Oracle has
a
> product called "mirror accessible" which allows the database to be
mirrored
> for reporting purposes. He wants us to use this product.
>
> Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby
> and Oracle Replication but he says it isn't any of these. Any idea what he
> might be talking about?
>
> Jay Miller
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Miller, Jay
>   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: Kimberly Smith
>   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: Ed
  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).

Testing

[Jared . Still]

Testing to see if the server is working properly.

Jared


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Has anyone heard of "Mirror Accessible"?

[Baker, Barbara]

I think that's "smoke and mirrors accessible".
sounds like vaporware to me

--
Barbara Baker
DBA
"If at first you don't succeed, skydiving might not be for you."


> --
> From: Miller, Jay[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Friday, November 30, 2001 10:47 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Has anyone heard of "Mirror Accessible"?
> 
> My CIO woes continue. My manager has been told by the CIO that Oracle has
> a
> product called "mirror accessible" which allows the database to be
> mirrored
> for reporting purposes. He wants us to use this product.
> 
> Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby
> and Oracle Replication but he says it isn't any of these. Any idea what he
> might be talking about?
> 
> Jay Miller
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Miller, Jay
>   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: Baker, Barbara
  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).

Freelist question.

[CC Harvest]

I have some stats tables to collect statistics. 
So I have to insert about 500K records into each table
per day. It seems like it has some contention 

CLASS  COUNT
data block  1298  

free list   0   

How do I determine how many freelist for these tables?
There will be insert-intensive on these tables, will
be archived/deleted after a few weeks.

Thanks,

Chris Harvest

__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CC Harvest
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Not able to view table

[lhoska]

Mark,
I am a really confused with your last statement.
"Have you tried either of the following:

select * from "tblBundleCon";
select * from 'tblBundleCon';

If you really did create them in lower and upper case, this could be your
problem. Enclosing the table names in double quotes usually solves this.."

Would you or someone else elaborate on this, pleeaassee?  Are we still
talking Oracle here

-Original Message-
Sent: Friday, November 30, 2001 7:25 AM
To: Multiple recipients of list ORACLE-L


Jyoti,

Did you create the tables as SYSTEM? One thing I will say is that *YOU
SHOULD NOT DO THIS*. When creating objects as SYSTEM, these objects will be
stored in the SYSTEM tablespace - which is not a good idea. As system,
create another tablespace (if one does not already exist), create a new
user, with a default tablespace of the new tablespace, and use this user
(with the appropriate system/object privileges) to create your
tables/indexes/objects.

On to another point about your mail - the password for SYSTEM is actually
the default. How about changing that for security reasons? This may just be
a test box, but there's nothing like good safe practice.

Back to the original question:

Who were you logged on as when you created the tables?
Where did you create them? (tablespace).

Have you tried either of the following:

select * from "tblBundleCon";
select * from 'tblBundleCon';

If you really did create them in lower and upper case, this could be your
problem. Enclosing the table names in double quotes usually solves this..

HTH

Mark

-Original Message-
Sent: 30 November 2001 06:50
To: Multiple recipients of list ORACLE-L


Hi all,
I have created with the following details:

Global DB name: manu.ifpjyo
SID:manu
Username:   SYSTEM
Password:manager
Tables:tblBundleCon, tblTextCon, tblFinalImage

I am able to connect to the database:
SQL> connect system@manu
password: ***
Connected.

But I am unable to view the tables that I have created:
SQL>select * from tblBundleCon;
*
ERROR at line 1:
ORA-00942: table or view does not exist

I get the above error. Where am I going wrong,
Thanx a lot in advance.
Jyoti.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Some 9i Questions - Help!

[Kimberly Smith]

Try and get him to delay for the new 9i release 2 that is coming soon.
New features and all that.  I do not believe its coming out this year
so if you sell it good enough you get Christmas back.

-Original Message-
Sent: Friday, November 30, 2001 9:52 AM
To: Multiple recipients of list ORACLE-L


An edict just came down from our CIO that we should upgrade all our
databases to 9i by the end of the year (he's decided it's important that we
always be on the latest release of all software).

Aside from the fact that other than a small play database we haven't done
any testing yet, aside from the fact that to do this I'd have to cancel all
my holiday plans with friends and family to work every weekend in December
(probably plus Christmas and New Years) to meet this arbitrary deadline, I'm
still nervous about upgrading to such a relatively new release (I wasn't
intending to consider it until late next year).

So, one question and one request.

1.  When was 9i first released for Solaris (I haven't been able to find this
information after poking around the Oracle website)?

2.  Could anyone please post any 9i horror stories you've had?  I know about
the Managed Rollback Segment problem, but since that feature is optional it
doesn't give me a lot of ammunition.

If this was a better job market I'd be contacting my headhunter right now.

Jay Miller
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
  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: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Some 9i Questions - Help!

[orantdba]

HI Jay,

Oracle9i on Solaris has been around since April ofr May of 2001.

Good Luck
JH
[EMAIL PROTECTED] wrote:

>An edict just came down from our CIO that we should upgrade all our
>databases to 9i by the end of the year (he's decided it's important that we
>always be on the latest release of all software).
>
>Aside from the fact that other than a small play database we haven't done
>any testing yet, aside from the fact that to do this I'd have to cancel all
>my holiday plans with friends and family to work every weekend in December
>(probably plus Christmas and New Years) to meet this arbitrary deadline, I'm
>still nervous about upgrading to such a relatively new release (I wasn't
>intending to consider it until late next year).
>
>So, one question and one request.
>
>1.  When was 9i first released for Solaris (I haven't been able to find this
>information after poking around the Oracle website)?
>
>2.  Could anyone please post any 9i horror stories you've had?  I know about
>the Managed Rollback Segment problem, but since that feature is optional it
>doesn't give me a lot of ammunition.
>
>If this was a better job market I'd be contacting my headhunter right now.
>
>Jay Miller
>


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Has anyone heard of "Mirror Accessible"?

[Kimberly Smith]

Only thing I can think of off the top of my head is a standby database
opened in read only mode.  Its one of the purposes totted for that

-Original Message-
Sent: Friday, November 30, 2001 9:47 AM
To: Multiple recipients of list ORACLE-L


My CIO woes continue. My manager has been told by the CIO that Oracle has a
product called "mirror accessible" which allows the database to be mirrored
for reporting purposes. He wants us to use this product.

Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby
and Oracle Replication but he says it isn't any of these. Any idea what he
might be talking about?

Jay Miller

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  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: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 32-bit Oracle on 64-bit Unix

[Molina, Gerardo]

You should have no problem running 32-bit Oracle in a 64-bit OS environment.

Gerardo

-Original Message-
Sent: Friday, November 30, 2001 9:33 AM
To: Multiple recipients of list ORACLE-L


Hi - 

We are about to upgrade a Unix box (Sun Solaris) to version 8 (2.8).
Someone mentioned that we can't run the 64-bit version because that would
require the 64-bit version of Oracle.  I thought that you could run the
32-bit version of Oracle on a 64-bit operating system.

Am I wrong?

Thanks-
Lisa
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: YTTRI  Lisa
  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: Molina, Gerardo
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RMAN disaster recovery

[Kimberly Smith]

Also, if that is the type of recovery he wants then sell him on
a standby database.  If you lose your server that severely you
will only be able to get back to the last backup regardless of
where your recovery catalog is (hopefully on another server or
at least backed up).

-Original Message-
Killough
Sent: Friday, November 30, 2001 7:11 AM
To: Multiple recipients of list ORACLE-L


I have never tried to burn my servers to ash, but I usually try to put the
rman catalog on a different server than the ones that it is backing up. You
also need to backup the catalog, which I do w/ a nightly export.


>From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RMAN disaster recovery
>Date: Fri, 30 Nov 2001 06:25:23 -0800
>
>I am wondering how RMAN would work for disaster recovery. Our manager's
>statement is "assume your server is reduced to a pile of ash. Now take your
>backup tape and build me a new system on a loaner from the vendor." I am
>trying to figure how that would work with RMAN. We are still at the stage
>of
>just using RMAN to create disk copies, and we are on Compaq Tru64 UNIX. He
>wants us to demonstrate that level of recoverability, but I'm not sure how
>that would work. I think we could assume that we have a database to load
>the
>RMAN catalog from an export.
>   One issue would be whether the disk location of the RMAN files might
>be different, and I'm not sure how to get RMAN to accept a different
>location. A more minor issue is if the database file locations are
>different, but I think that is pretty well documented.
>   Has anyone else tried this? What am I overlooking? Any ideas will be
>appreciated.
>Dennis Williams
>DBA
>Lifetouch, Inc.
>[EMAIL PROTECTED]
>
>--
>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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike Killough
  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: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 32-bit Oracle on 64-bit Unix

[Kimberly Smith]

You can.  I had it running on many boxes at Fujitsu (before they
shut their doors that is).

Only thing to keep in mind is memory utilization.  Oracle 32 bit will
only allow you to utilize 1.75G total (all instances).  There is a 
thing called memory windows on HP that removes that but puts a restriction
of 1G per instance.  Not sure if there is an equivalent on Sun.

-Original Message-
Sent: Friday, November 30, 2001 9:33 AM
To: Multiple recipients of list ORACLE-L


Hi - 

We are about to upgrade a Unix box (Sun Solaris) to version 8 (2.8).
Someone mentioned that we can't run the 64-bit version because that would
require the 64-bit version of Oracle.  I thought that you could run the
32-bit version of Oracle on a 64-bit operating system.

Am I wrong?

Thanks-
Lisa
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: YTTRI  Lisa
  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: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Duplicating a Database and Changig SID

[Kimberly Smith]

Looks 
ok to me.  If its useful people will read it in any 
format:-)

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Ron YountSent: Friday, 
  November 30, 2001 9:06 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Duplicating a Database and Changig 
  SID
  This 
  is not real pretty as text, if you want a MS Word copy, send me your e-mail. 
  [EMAIL PROTECTED]
   
   

Some 9i Questions - Help!

[Miller, Jay]

An edict just came down from our CIO that we should upgrade all our
databases to 9i by the end of the year (he's decided it's important that we
always be on the latest release of all software).

Aside from the fact that other than a small play database we haven't done
any testing yet, aside from the fact that to do this I'd have to cancel all
my holiday plans with friends and family to work every weekend in December
(probably plus Christmas and New Years) to meet this arbitrary deadline, I'm
still nervous about upgrading to such a relatively new release (I wasn't
intending to consider it until late next year).

So, one question and one request.

1.  When was 9i first released for Solaris (I haven't been able to find this
information after poking around the Oracle website)?

2.  Could anyone please post any 9i horror stories you've had?  I know about
the Managed Rollback Segment problem, but since that feature is optional it
doesn't give me a lot of ammunition.

If this was a better job market I'd be contacting my headhunter right now.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Crontabs and Oracle

[Kimberly Smith]

What I did is create a file that sets the environment for each database.
This file is sourced in my profile as well as any script I create.
Therefore,
when it comes time to put a script in cron I do nothing but place it
in there.  Plus, that gives me one spot I ever have to change when I
upgrade.  This file takes the database sid as a parameter.

-Original Message-
Maheswara
Sent: Friday, November 30, 2001 7:07 AM
To: Multiple recipients of list ORACLE-L


Tim,

Sourcing a .profile within cron jobs is not a good way doing a shell
scripting.  One big reason --- A .profile might contain a lot of functions
which are OK if you are loggin in with that specific user id.  And those
functions might be doing some job that might affect the cron job.

In my opinion, the correct way is to export the required variables or
setting them in the beginning of the cron job.

Rao

-Original Message-
Sent: Friday, November 30, 2001 5:35 AM
To: Multiple recipients of list ORACLE-L


On Thu, Nov 29, 2001 at 11:15:43AM -0800, [EMAIL PROTECTED] wrote:
>
> I've seen a number of suggestions for sourcing .profile
> in the cron jobs, but this is not always a good idea, as
> .profile often contains script that will not execute when
> not attached to a tty.

I think sourcing .profile is the 'right' thing to do.

If that breaks then the .profile needs fixing as it'll probably
also break things like rsh/rcp etc.

I've seen both these code sytles used (for sh/ksh/bash etc):

if [ "$PS1" ]
then
... interactive stuff here ...
fi

or
case $- in
*i*)
... commands for an interactive shell here ...
;;
*)  ;;
esac

Tim.
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rao, Maheswara
  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: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Not able to view table

[Kimberly Smith]

Hum, must disagree (sort of).  Although I don't recommend creating objects
as system normally the first thing I do when I create a database is change
the default tablespace of all users except sys.  OK, it might not be the
first thing I do, but its up there in the beginning somewhere.

You could also use the data dictionary to find your tables.  Look in
dba_tables
or dba_objects.  But Mark has a good point about the case of your tables.

-Original Message-
Sent: Friday, November 30, 2001 4:25 AM
To: Multiple recipients of list ORACLE-L


Jyoti,

Did you create the tables as SYSTEM? One thing I will say is that *YOU
SHOULD NOT DO THIS*. When creating objects as SYSTEM, these objects will be
stored in the SYSTEM tablespace - which is not a good idea. As system,
create another tablespace (if one does not already exist), create a new
user, with a default tablespace of the new tablespace, and use this user
(with the appropriate system/object privileges) to create your
tables/indexes/objects.

On to another point about your mail - the password for SYSTEM is actually
the default. How about changing that for security reasons? This may just be
a test box, but there's nothing like good safe practice.

Back to the original question:

Who were you logged on as when you created the tables?
Where did you create them? (tablespace).

Have you tried either of the following:

select * from "tblBundleCon";
select * from 'tblBundleCon';

If you really did create them in lower and upper case, this could be your
problem. Enclosing the table names in double quotes usually solves this..

HTH

Mark

-Original Message-
Sent: 30 November 2001 06:50
To: Multiple recipients of list ORACLE-L


Hi all,
I have created with the following details:

Global DB name: manu.ifpjyo
SID:manu
Username:   SYSTEM
Password:manager
Tables:tblBundleCon, tblTextCon, tblFinalImage

I am able to connect to the database:
SQL> connect system@manu
password: ***
Connected.

But I am unable to view the tables that I have created:
SQL>select * from tblBundleCon;
*
ERROR at line 1:
ORA-00942: table or view does not exist

I get the above error. Where am I going wrong,
Thanx a lot in advance.
Jyoti.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
  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: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: stripes, partitions, and spindles

[Ruth Gramolini]

Thanks!  Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 11:25 AM


> Oracle's thoughts on the matter can be found at:
>
> http://technet.oracle.com/deploy/performance/pdf/opt_storage_conf.pdf
>
>
>
>
> Ruth
> GramoliniTo: Multiple recipients of
list ORACLE-L
> 
> @tax.state.vtcc:
> .us> Subject: Re: stripes,
partitions, and
> Sent by: rootspindles
>
>
> 11/30/2001
> 10:15 AM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
> Thanks all, I am going to give the IBM guy the book after I read it.
>
> Ruth
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, November 30, 2001 8:30 AM
>
>
> > Ruth:
> >
> > Get a copy of the Oracle8i DBA Handbook by Loney & Theriault.  Chapter
> 4's
> > topic is Physical Database Layouts.  It goes from 22 disks down to 7.
> >
> > Hope this helps,
> >
> > Ken
> >
> >  -Original Message-
> > Sent: Friday, November 30, 2001 6:55 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: stripes,  partitions, and spindles
> >
> > Good morning all,
> >
> > We have purchased new IBM AIX boxes and the guy whole sold them to us is
> > here puting them together. ( He used to work for IBM.)  The question
> rises
> > again, do I put my tablespaces on separate spindles, e.g. Data on one,
> Data2
> > (big extents) on 2, Index1, Index2 all on separate spindles or do I
stipe
> > everything.  We are planning to partition or largest table (bottleneck)
> > after the duhvelopers figure out how to do it.
> >
> > We will have plenty of spindles for system,redo, etc.
> >
> > I need some good arguments for each.  I don't really think the ex-IBMer
> > should have the final word.
> >
> > We have a three-tier application  which all employees use and nightly
> batch
> > processing.   We have two databases which run separately during the day
> and
> > communicat with each other at night through db_links.   Everything runs
> > through this one huge table (it is like a general ledger).
> >
> > The boss says she has run a stiped Oracle database in the past but
> doesn't
> > really know if this is the best.
> >
> > I will be eternally grateful for all info.
> >
> > TIA,
> > Ruth
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ruth Gramolini
> >   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: Ken Janusz
> >   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: Ruth Gramolini
>   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:
>   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

Has anyone heard of "Mirror Accessible"?

[Miller, Jay]

My CIO woes continue. My manager has been told by the CIO that Oracle has a
product called "mirror accessible" which allows the database to be mirrored
for reporting purposes. He wants us to use this product.

Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby
and Oracle Replication but he says it isn't any of these. Any idea what he
might be talking about?

Jay Miller

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  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).

oracle hangs, but why?

[Mohan, Ross]

look at dlm configuration at the os level...pings? up/down converts normal?
apply all patches.
also look at UDP buffer size settings in the kernel. 

Oracle DLM use udp vice tcp and bad buffer sizes cause hangs. 

hth

Ross Mohan

-Original Message-
Sent: Friday, November 30, 2001 12:12 PM
To: Multiple recipients of list ORACLE-L


Hi.

I'm running oracle 8172 on AIX SP 4.3.3 in ops mode on

4 nodes. I have noticed that the queries that are
trying to read the GV$ tables are hanging, while
those using the V$ tables don't. I have looked at 
the locks/waits on each node, but didn't see anything
unusual (or may be I missed). What/where should I be
looking to figure out what is going on? Thanks for any
input



=


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  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: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Crontabs and Oracle

[Jared . Still]

Tim,

Sourcing .profile may be the 'right' thing to do technically,  but I
suppose it really hinges on the environment.

If it works as is, then fine.  If not, changing .profile and/or .kshrc
may not be an option.

In a medium to large shop, changing the .profile or .kshrc can
be rather dangerous, even with proper change control procedures
in place.

It might be a few weeks before it bites you when that report
that runs once a quarter suddenly hangs or quits working.

Jared



   
 
Tim Bunce  
 

ox.com>  cc:   
 
Sent by: Subject: Re: Crontabs and Oracle  
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
11/30/01 02:35 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




On Thu, Nov 29, 2001 at 11:15:43AM -0800, [EMAIL PROTECTED] wrote:
>
> I've seen a number of suggestions for sourcing .profile
> in the cron jobs, but this is not always a good idea, as
> .profile often contains script that will not execute when
> not attached to a tty.

I think sourcing .profile is the 'right' thing to do.

If that breaks then the .profile needs fixing as it'll probably
also break things like rsh/rcp etc.

I've seen both these code sytles used (for sh/ksh/bash etc):

if [ "$PS1" ]
then
   ... interactive stuff here ...
fi

or
case $- in
*i*)
   ... commands for an interactive shell here ...
   ;;
*)  ;;
esac

Tim.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Bunce
  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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Duplicating a Database and Changig SID

[Prakriteswar Santikary]

thanks 
Ron. this will work.

  -Original Message-From: Ron Yount 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 9:06 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Duplicating a Database and Changig SID
  This 
  is not real pretty as text, if you want a MS Word copy, send me your e-mail. 
  [EMAIL PROTECTED]
   
   

32-bit Oracle on 64-bit Unix

[YTTRI Lisa]

Hi - 

We are about to upgrade a Unix box (Sun Solaris) to version 8 (2.8).
Someone mentioned that we can't run the 64-bit version because that would
require the 64-bit version of Oracle.  I thought that you could run the
32-bit version of Oracle on a 64-bit operating system.

Am I wrong?

Thanks-
Lisa
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: YTTRI  Lisa
  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).

oracle hangs, but why?

[Gene Gurevich]

Hi.

I'm running oracle 8172 on AIX SP 4.3.3 in ops mode on

4 nodes. I have noticed that the queries that are
trying to read the GV$ tables are hanging, while
those using the V$ tables don't. I have looked at 
the locks/waits on each node, but didn't see anything
unusual (or may be I missed). What/where should I be
looking to figure out what is going on? Thanks for any
input



=


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: portable statistics

[Connor McDonald]

If you genuinely clone a database ie copy the
datafiles, then the stats will also be transferred. 
Other than that, you would need dbms_stats which comes
only at 8.1+.

You could always hack the internal sys tables -
probably not the wisest option to persue :-)

Cheers
Connor

 --- Ruth Gramolini <[EMAIL PROTECTED]>
wrote: > Good morning again,
> 
> I know that in 8i you can move statistics where you
> clone a database.  Is it
> possible in 8.0.6.3?
> 
> Thanks!
> Ruth
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Ruth Gramolini
>   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). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

__
Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music 
Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: * Oracle 8i DBA Needed in New York City..

[sfaroult]

>There are many exciting projects on which you would participate including an
>SAP implementation,
>CRM applications implementations, and data migrations from other databases
>to ORACLE.=20

We musn't have the same definition of 'exciting'.


--
Diese E-Mail wurde mit http://www.mail-inspector.de verschickt
Mail Inspector ist ein kostenloser Service von http://www.is-fun.net
Der Absender dieser E-Mail hatte die IP: 194.51.96.14

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Duplicating a Database and Changig SID

[Ron Yount]

This 
is not real pretty as text, if you want a MS Word copy, send me your e-mail. [EMAIL PROTECTED]
 
 

The purpose of this document is to define the process and commands necessary to 
duplicate (clone) an existing database and alter its Database Identifier (DBID).  
There are two separate approaches, one with standard file systems and the other 
utilizing a BCV split.

Standard File System Procedures
1. Connect to the database as "internal"
2. Issue "alter database backup controlfile to trace resetlogs".  (This file will be 
located in the user_dump_dest defined in the init.ora file and will be called 
"ora_.trc".)
3. sql> select name, dbid from v$database;   (Use this for later reference).
4. Shutdown the database using "shutdown normal"
5. Copy the database (dbf) files to the file system(s) for the new database. (for a 
list of all the files, look at the trace file generated in step 2)
6. Copy the redo log files to the file system(s) for the new database.
7. Copy and rename the init file to init to the new database file 
structure.
8. Do not copy the control files to the new location.
9. Restart the original database instance.
10. Edit the trace file created in Step 2.
a. Delete all lines from the top of the file down to (and including) the line that 
says "startup nomount".
b. Alter the line that starts with "Create controlfile…" so that:
 i. (REUSE) is changed to (SET)
 ii. (NORESETLOGS) is changed to (RESETLOGS)
 iii. DATABASE = "" is changed to "".
c. After the semicolon that ends the "create controlfile..." statement, delete 
everything except the line "alter database open resetlogs;"
d. Alter all of the path statements for the data files so that they reference the 
"new" path.
e. Save the file to a meaningful name such as 
"$ORACLE_BASE/admin//create/cr_cfile.sql"
11. Edit the new init file.
a. Update SERVICE_NAMES, DB_NAME, and INSTANCE_NAME to the new SID.
b. Change the CONTROL_FILES to point to the correct path.
c. Change the USER_DUMP_DEST, LOG_ARCHIVE_DEST, CORE_DUMP_DEST, and 
BACKGROUND_DUMP_DEST, UTL_FILE_DIR to the new file system paths.
12. Create a password file for the new database with the "orapwd" command.
13. Create a link from $ORACLE_HOME/dbs/init.ora to  
$ORACLE_BASE/admin//pfile/init.ora using "ln -s   syntax.
14. Change to the directory where the control file script from step (10-d) is located.
15. export ORACLE_SID=
16. Use sqlplus to connect internal
a. sql> startup nomount
b. sql> @cr_cfile.sql
c. sql> select name, dbid from v$database.  (There should be a new name, but same dbid 
from step 3)
d. sql> shutdown normal
e. sql> startup mount;
f. sql> exec dbms_backup_restore.zeroDbid(0);
g. sql> shutdown normal;
17. Rename the control files from the new instance, so they will appear to be missing.
a. sql> startup nomount;
b. sql> @cr_cfile.sql
c. sql> select name, dbid from v$database.  (There should be the new name, and new 
dbid)
18. Add an entry in tnsnames.ora for the new database.
19. Register the new database with RMAN and request a full backup (level 0).
20. Add an appropriate entry in the "oratab" file.

Re: DISK LAYOUT & RAID LEVEL

[tday6]

http://technet.oracle.com/deploy/performance/pdf/opt_storage_conf.pdf



   

Harvinder  

SinghTo: Multiple recipients of list ORACLE-L  



ngh  cc:   

@MetraTech.coSubject: DISK LAYOUT & RAID LEVEL 

m> 

Sent by: root  

   

   

11/30/2001 

10:35 AM   

Please 

respond to 

ORACLE-L   

   

   





Hi,

We have to do benchmarks tests(scalability,performance) for our product and
have machine with following
configuration..We dont have experience for large size databases layout.
It will be greatly appreciated if someone points out from his experience:

1) Which raid level to use for which files and on how many disks.
2) As we have 10 disks what file to place on which disk.
3) How much RAM to use for SGA.(this is database dedicated machine)

Server - E3500 with 2 internal boot disks (18GB)
  4 400MHZ/8MB ecache and 2 GB ram
  2 I/O boards

 Arrays - HDS 9210 Fiber channel array with 10 36GB disks @ 10K RPM with
 5.7 read and 6.5 write seek.
   Sun A5200 with 22 9GB Seagate drives @ 10KRPM with 5.4 read and
 6.2 write seek.

 HDS is a hardware based array and the A5200 is software with Veritas VM

Thanks
-Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
  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: 
  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).

Oracle and UDB

[Jamadagni, Rajendra]

Hi 
Does anyone know if there is a comparison about Oracle and UDB anywhere? I
need some ammo for a discussion going on here. Also does anyone have
experience running Oracle Forms against UDB?

Thanks in advance
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!




*2

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

RE: total tranx ran

[Diego Cutrone]

if you're using Oracle 8
check v$resource_limit.transactions view

HTH
Diego Cutrone

- Original Message - 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 7:05 AM


> Hi lists,
> 
> Does anybody have a query to find , how many transactions ran since the
> instance started.
> 
> v$transaction will have only the current trnx running.
> 
> is there any other views that will show the total trnx since instance
> startup.
> 
> Thnx and regards,
> 
> Srinivas
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Tatireddy, Shrinivas (MED, Keane)
>   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: Diego Cutrone
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RMAN disaster recovery

[Cherie_Machler]

Dennis,

We have all of our RMAN catalogs on a small unix server that is fairly
isolated and doesn't have much else on it.
We also backup up the databases that contain those catalogs to other
catalogs using RMAN to a second small,
isolated UNIX server.

In addition, we also take logical backups of all databases containing RMAN
catalogs every night using exp utility.
The exports stay on the backup servers for a week.

If you're going to go to all of the work of setting RMAN up, you might as
well go the extra step and locate your
RMAN catalog on a separate server.  If you have a server go bad, it could
well take down your RMAN catalog too.

My $.02

Cherie Machler
Oracle DBA
Gelco Information Network




   

DENNIS WILLIAMS

  
TOUCH.COM>cc:  

Sent by:  Subject: RMAN disaster recovery  

[EMAIL PROTECTED]

m  

   

   

11/30/01 08:25 

AM 

Please respond 

to ORACLE-L

   

   





I am wondering how RMAN would work for disaster recovery. Our manager's
statement is "assume your server is reduced to a pile of ash. Now take your
backup tape and build me a new system on a loaner from the vendor." I am
trying to figure how that would work with RMAN. We are still at the stage
of
just using RMAN to create disk copies, and we are on Compaq Tru64 UNIX. He
wants us to demonstrate that level of recoverability, but I'm not sure how
that would work. I think we could assume that we have a database to load
the
RMAN catalog from an export.
   One issue would be whether the disk location of the RMAN files
might
be different, and I'm not sure how to get RMAN to accept a different
location. A more minor issue is if the database file locations are
different, but I think that is pretty well documented.
   Has anyone else tried this? What am I overlooking? Any ideas
will be
appreciated.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

--
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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Duplicating a Database and Changig SID

[SARKAR, Samir]

Same here Ron.will 
really appreciate it if u could send me the file at my email 
id
as an attachment..I 
think the LIST doesnt support attachments..else, a text 
file
will also 
help.
 
Samir Sarkar 
Oracle DBA - Lennon 
Team SchlumbergerSema 
Email :  
[EMAIL PROTECTED]     
[EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 
EPABX : +44 (0) 115 - 957 6418 
Ext. 76217 Fax 
: +44 (0) 115 - 957 
6018    


  -Original Message-From: Prakriteswar Santikary 
  [mailto:[EMAIL PROTECTED]]Sent: 30 November 2001 
  16:21To: Multiple recipients of list ORACLE-LSubject: 
  RE: Duplicating a Database and Changig SID
  Ron,
   
  I 
  was trying to open your attached document. I get this 
  error:
   
    
  
   
  Could you pl. 
  send this doc as .txt file to me ? I would really appreciate 
  that.
   
  thanks
  Santi
  
-Original Message-From: Ron Yount 
[mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 7:41 
AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Duplicating a Database and Changig SID
Sonja,
 
Here are my rough instructions for how to duplicate 
a database (by copying files) and then how to alter the database name 
(typically referred to as "cloning" a database).  
 
At 
the end, you will find how to alter the dbid so that RMAN will see it as a 
new database.
 
Be 
sure to bounce the instance as instructed.
 
-Ron-

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Sonja SehovicSent: 
  Friday, November 30, 2001 3:11 AMTo: Multiple recipients of 
  list ORACLE-LSubject: RE: Duplicating a Database and Changig 
  SID
  Yes, 
  please, I'm very interested.
   
  Sonja
  
-Original Message-From: Ron Yount 
[mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 
12:50 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Duplicating a Database and Changig 
SID
If you are using RMAN and would like some direction on how to 
change the DBID as well, let me know and I will send you some 
directions/steps for that as well.
 
-Ron-

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Sonja 
  SehovicSent: Thursday, November 29, 2001 5:45 
  AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Duplicating a Database and Changig 
  SID
  Hi!
   
  Before 
  I tell you procedure, be aware that when you make a clone of your 
  database DBID remains the same, which is a problem if you use RMAN for 
  you backups.
   
  Steps 
  are:
  0. On 
  your database issue: 
   alter 
  database backup controlfile to trace 
  resetlogs;
  1. 
  Backup your database.
  2. Shutdown database (shutdown 
  immediate)
  3. Copy 
  all your datafile, logfiles, controlfiles to the new 
  location
  4. Edit 
  your new init.ora file and change DB_NAME, DB_BLOCK_SIZE must be the 
  same, 
    
    change path for controlfiles, user_dump_dest, 
  background_dump_dest, core_dump_dest
  5. 
  Edit  your new controlfile (which you get in step 0) and change 
  it in:
      
  CREATE CONTROLFILE REUSE SET DATABASE 'NEWSID' RESETLOGS 
  
      and change the path of 
  datafiles and logs
  6. 
  Recreate you control file.
  7. 
  Change your tnsnames.ora and sqlnet.ora files.
   
  This 
  should do. 
  I had 
  no problems in doing that
   
  HTH,
      Sonja
   
  
-Original Message-From: MRaval 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, 
November 28, 2001 7:55 PMTo: Multiple recipients of list 
ORACLE-LSubject: Duplicating a Database and Changig 
SID
Hi Guys,
 
I am newbie oracle DBA and want to duplicate my  
development database to Test database and want to change ORACLE_SID, 
Could anyone tell exact steps that I have to follow. My database is 
on SUN 5.6 and oracle 8.1.6.
 
Thanks,

___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received this
email in error and

Re: stripes, partitions, and spindles

[tday6]

Oracle's thoughts on the matter can be found at:

http://technet.oracle.com/deploy/performance/pdf/opt_storage_conf.pdf



   

Ruth   

GramoliniTo: Multiple recipients of list ORACLE-L  



@tax.state.vtcc:   

.us> Subject: Re: stripes, partitions, and 

Sent by: rootspindles  

   

   

11/30/2001 

10:15 AM   

Please 

respond to 

ORACLE-L   

   

   





Thanks all, I am going to give the IBM guy the book after I read it.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 8:30 AM


> Ruth:
>
> Get a copy of the Oracle8i DBA Handbook by Loney & Theriault.  Chapter
4's
> topic is Physical Database Layouts.  It goes from 22 disks down to 7.
>
> Hope this helps,
>
> Ken
>
>  -Original Message-
> Sent: Friday, November 30, 2001 6:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: stripes,  partitions, and spindles
>
> Good morning all,
>
> We have purchased new IBM AIX boxes and the guy whole sold them to us is
> here puting them together. ( He used to work for IBM.)  The question
rises
> again, do I put my tablespaces on separate spindles, e.g. Data on one,
Data2
> (big extents) on 2, Index1, Index2 all on separate spindles or do I stipe
> everything.  We are planning to partition or largest table (bottleneck)
> after the duhvelopers figure out how to do it.
>
> We will have plenty of spindles for system,redo, etc.
>
> I need some good arguments for each.  I don't really think the ex-IBMer
> should have the final word.
>
> We have a three-tier application  which all employees use and nightly
batch
> processing.   We have two databases which run separately during the day
and
> communicat with each other at night through db_links.   Everything runs
> through this one huge table (it is like a general ledger).
>
> The boss says she has run a stiped Oracle database in the past but
doesn't
> really know if this is the best.
>
> I will be eternally grateful for all info.
>
> TIA,
> Ruth
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
>   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: Ken Janusz
>   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: Ruth Gramolini
  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 EXA

RE: Duplicating a Database and Changig SID

[Prakriteswar Santikary]

Ron,
 
I was 
trying to open your attached document. I get this error:
 
 

 
Could you pl. 
send this doc as .txt file to me ? I would really appreciate 
that.
 
thanks
Santi

  -Original Message-From: Ron Yount 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 7:41 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Duplicating a Database and Changig SID
  Sonja,
   
  Here 
  are my rough instructions for how to duplicate a database (by copying files) 
  and then how to alter the database name (typically referred to as "cloning" a 
  database).  
   
  At 
  the end, you will find how to alter the dbid so that RMAN will see it as a new 
  database.
   
  Be 
  sure to bounce the instance as instructed.
   
  -Ron-
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Sonja SehovicSent: 
Friday, November 30, 2001 3:11 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Duplicating a Database and Changig 
SID
Yes, please, 
I'm very interested.
 
Sonja

  -Original Message-From: Ron Yount 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 12:50 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Duplicating a Database and Changig SID
  If you are using RMAN and would like some direction on how to 
  change the DBID as well, let me know and I will send you some 
  directions/steps for that as well.
   
  -Ron-
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Sonja 
SehovicSent: Thursday, November 29, 2001 5:45 
AMTo: Multiple recipients of list ORACLE-LSubject: 
RE: Duplicating a Database and Changig SID
Hi!
 
Before I 
tell you procedure, be aware that when you make a clone of your database 
DBID remains the same, which is a problem if you use RMAN for you 
backups.
 
Steps 
are:
0. On 
your database issue: 
 alter 
database backup controlfile to trace 
resetlogs;
1. Backup 
your database.
2. Shutdown database (shutdown 
immediate)
3. Copy 
all your datafile, logfiles, controlfiles to the new 
location
4. Edit 
your new init.ora file and change DB_NAME, DB_BLOCK_SIZE must be the 
same, 
  
  change path for controlfiles, user_dump_dest, 
background_dump_dest, core_dump_dest
5. 
Edit  your new controlfile (which you get in step 0) and change it 
in:
    
CREATE CONTROLFILE REUSE SET DATABASE 'NEWSID' RESETLOGS 

    and change the path of 
datafiles and logs
6. 
Recreate you control file.
7. Change 
your tnsnames.ora and sqlnet.ora files.
 
This 
should do. 
I had no 
problems in doing that
 
HTH,
    Sonja
 

  -Original Message-From: MRaval 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 
  28, 2001 7:55 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Duplicating a Database and Changig 
  SID
  Hi Guys,
   
  I am newbie oracle DBA and want to duplicate my  
  development database to Test database and want to change ORACLE_SID, 
  Could anyone tell exact steps that I have to follow. My database is on 
  SUN 5.6 and oracle 8.1.6.
   
  Thanks,

Oracle client compatibility with Windows XP

[Ben Poels]

Hi

According to Metalink note 161546.1 you need at least the 9.0.1
Oracle client for Windows XP. We are currently using the 8.1.7
client to go against 8.1.7 databases and 7.3.4 databases. Does
anyone know of any issues when you use the 9 client against
7.3.4 databases?

Thanks,

Ben


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SqlSever 2000 question

[Chris Beckley]

Title: RE: SqlSever 2000 question






But, that's not normal :)

I can't think of a way to do that with standard SQL, however in transact sql (which is SQL on SqlServer) you do have flow control and cursors and string functions.  However, cursors with SqlServer are really slow.  Only use them after you have selected the records you want to use into a temporary table i.e.,

select c1, c2, c3 into #tempTableName from  where ...
the # in the table name makes it a temporary table - it will go away when the session ends.



hth,
Chris



-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 11/28/2001 10:30 AM

Hi All,

Sorry for OT but I am very new(few hours) to sql server and need help
with
constructing a query.

I have 2 tables

Table1 Table2
id id
name,   county
state

There is 1 -> many from table1 to table2
I want to retrieve each record in table1 along with all the counties in
table2 for that ID in one record
For ex.   1,SmithJ,TN,county1 | county2 | county3 | countyN

Any ideas,

Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RMAN disaster recovery

[Mercadante, Thomas F]

Dennis,

RMan is able to restore files to different locations with the following
command:

run { 
 sql 'ALTER TABLESPACE tbs_3 OFFLINE IMMEDIATE';
 allocate channel ch1 type disk;
 set newname for datafile '/oracle/dbs/tbs_33.f' to
'/oracle/temp/tbs_33.f';
 restore tablespace tbs_3;
 switch datafile all;
 recover tablespace tbs_3;
 sql 'ALTER TABLESPACE tbs_3 ONLINE';
}

The above is out of Chapter 6 of the Oracle Recovery Manager Users Guide.
I think your disaster recovery steps would be:

1).  Secure a new server.
2).  Install the same versions of Oracle software that was on your prod
servers.
3).  Re-Create your Rman Catalog and import the data from your export.
4).  I think you would need to re-create a minimal production instance.
5).  Run Rman to restore the control files for this instance, and then
perform 
 a full restore.

If I were you, I would try this scenario if you can get your hands on
another server.  There is nothing like practice to get familiar with all the
steps.
You can try part of this by creating a test instance, back it up via Rman,
delete all of the files, and try restoring it to another location on the
same machine.  You could even go nuts and create a different Rman catalog,
importing an export file to simulate most of what a disaster recovery would
require.

Hope this helps!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, November 30, 2001 9:25 AM
To: Multiple recipients of list ORACLE-L


I am wondering how RMAN would work for disaster recovery. Our manager's
statement is "assume your server is reduced to a pile of ash. Now take your
backup tape and build me a new system on a loaner from the vendor." I am
trying to figure how that would work with RMAN. We are still at the stage of
just using RMAN to create disk copies, and we are on Compaq Tru64 UNIX. He
wants us to demonstrate that level of recoverability, but I'm not sure how
that would work. I think we could assume that we have a database to load the
RMAN catalog from an export. 
One issue would be whether the disk location of the RMAN files might
be different, and I'm not sure how to get RMAN to accept a different
location. A more minor issue is if the database file locations are
different, but I think that is pretty well documented. 
Has anyone else tried this? What am I overlooking? Any ideas will be
appreciated.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-- 
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.com
-- 
Author: Mercadante, Thomas F
  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).

* Oracle 8i DBA Needed in New York City..

[OraStaff]

*Description:
International news and media organization in New York City, New York has an
immediate
need for a senior level ORACLE 8i DBA to join their team of DBAs. 
There are many exciting projects on which you would participate including an
SAP implementation,
CRM applications implementations, and data migrations from other databases
to ORACLE. 

This is a full time staff position so no sub-contractors or third parties
please.

Please do not call or send a resume if you are not in the U.S. and/or need 
sponsorship.

REQUIREMENTS: 
Must have 6 or more years as an ORACLE DBA. Must have solid ORACLE 8i
experience. Must have solid disaster recovery experience, including strong
knowledge of data replication and fault tolerance, as well as backup and
restore procedures. Programming background with PL/SQL and Pro*C are
strongly preferred. Strong pluses include: ORACLE 9i, SAP, CRM (Siebel or
ORACLE), Progress, Informix, Solaris and AIX. 

U.S. citizenship or permanent residency is also required.

This position offers:
* Opportunity to become a key member of the team
* Compensation up 95K D.O.E.
* Challenge
   
For  immediate consideration, please send your resume as an attachment to:
Bill Law, 
Oracle Placement Specialist
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/DBA/NYC/Donna

We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the
posiition described above- if it is not a match for your skills.
Thanks,
Bill Law

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: PATCH confirmation

[Fisher, Julie]

This also happens in patch 8.1.6.1.0 for Solaris 7 64-bit.  Really annoyed
me last night when Oracle said I needed 412M of space to apply the patch and
then didn't use it.

Julie Fisher
Sandia National Laboratories
Oracle 8i DBA - OCP8i
Solaris 2.6,7/HP-UX 11.0 System Administrator
Web Server Administrator


-Original Message-
Sent: November 30, 2001 8:16 AM
To: Multiple recipients of list ORACLE-L


btw...
When you apply this patch, the installer will likely tell you that the patch
needs an addtional 500 megs on your /oracle partition (on top of the space
already consumed by 8.1.7.0).

This is an Oracle faux pas.
8.1.7.2 takes about 20 megs more than 8.1.7.0 already consumed.



> --
> From: Nikunj Gupta[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, November 29, 2001 11:30 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: PATCH confirmation
> 
> How long does it take to install complete patch from 8.1.7.0 to 8.1.7.2 ?
> 
> 
> 
> Make a FREE long distance call from your PC!
> http://www.eboom.com/free/
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, November 29, 2001 12:10 PM
> 
> 
> > yes
> > 
> > Seema Singh wrote:
> > >
> > > Hi
> > > I think patch 1882450 is for upgrade from 8.1.7.0.0 to 8.1.7.2.0
> right?
> > > thanks
> > > seema
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Dennis M. Heisler
> >   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: Nikunj Gupta
>   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: Baker, Barbara
  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: Fisher, Julie
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: PATCH confirmation

[Gogala, Mladen]

So, patch installation is not scalable?

-Original Message-
Sent: Friday, November 30, 2001 10:07 AM
To: Multiple recipients of list ORACLE-L


>From your patch number, I assume you're Sun/Solaris.
On a 3500 with 4 cpu's, patch took nearly 30 minutes.
On a 4500 with 8 cpu's, patch took about 20 minutes
YMMV

Barb


> --
> From: Nikunj Gupta[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, November 29, 2001 11:30 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: PATCH confirmation
> 
> How long does it take to install complete patch from 8.1.7.0 to 8.1.7.2 ?
> 
> 
> 
> Make a FREE long distance call from your PC!
> http://www.eboom.com/free/
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, November 29, 2001 12:10 PM
> 
> 
> > yes
> > 
> > Seema Singh wrote:
> > >
> > > Hi
> > > I think patch 1882450 is for upgrade from 8.1.7.0.0 to 8.1.7.2.0
> right?
> > > thanks
> > > seema
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Dennis M. Heisler
> >   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: Nikunj Gupta
>   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: Baker, Barbara
  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: Gogala, Mladen
  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).

DISK LAYOUT & RAID LEVEL

[Harvinder Singh]

Hi,

We have to do benchmarks tests(scalability,performance) for our product and
have machine with following
configuration..We dont have experience for large size databases layout.
It will be greatly appreciated if someone points out from his experience:

1) Which raid level to use for which files and on how many disks.
2) As we have 10 disks what file to place on which disk.
3) How much RAM to use for SGA.(this is database dedicated machine)
  
Server - E3500 with 2 internal boot disks (18GB)
 4 400MHZ/8MB ecache and 2 GB ram
 2 I/O boards 
 
 Arrays - HDS 9210 Fiber channel array with 10 36GB disks @ 10K RPM with
 5.7 read and 6.5 write seek.
  Sun A5200 with 22 9GB Seagate drives @ 10KRPM with 5.4 read and
 6.2 write seek.
 
 HDS is a hardware based array and the A5200 is software with Veritas VM
 
Thanks
-Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Duplicating a Database and Changig SID

[Ron Yount]

Sonja,
 
Here 
are my rough instructions for how to duplicate a database (by copying files) and 
then how to alter the database name (typically referred to as "cloning" a 
database).  
 
At the 
end, you will find how to alter the dbid so that RMAN will see it as a new 
database.
 
Be 
sure to bounce the instance as instructed.
 
-Ron-

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Sonja SehovicSent: 
  Friday, November 30, 2001 3:11 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Duplicating a Database and Changig 
  SID
  Yes, please, 
  I'm very interested.
   
  Sonja
  
-Original Message-From: Ron Yount 
[mailto:[EMAIL PROTECTED]]Sent: Friday, November 30, 2001 12:50 
AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Duplicating a Database and Changig SID
If 
you are using RMAN and would like some direction on how to change the DBID 
as well, let me know and I will send you some directions/steps for that as 
well.
 
-Ron-

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Sonja SehovicSent: 
  Thursday, November 29, 2001 5:45 AMTo: Multiple recipients of 
  list ORACLE-LSubject: RE: Duplicating a Database and Changig 
  SID
  Hi!
   
  Before I 
  tell you procedure, be aware that when you make a clone of your database 
  DBID remains the same, which is a problem if you use RMAN for you 
  backups.
   
  Steps 
  are:
  0. On your 
  database issue: 
   alter 
  database backup controlfile to trace 
  resetlogs;
  1. Backup 
  your database.
  2. Shutdown database (shutdown 
  immediate)
  3. Copy all 
  your datafile, logfiles, controlfiles to the new 
  location
  4. Edit 
  your new init.ora file and change DB_NAME, DB_BLOCK_SIZE must be the same, 
  
    
    change path for controlfiles, user_dump_dest, background_dump_dest, 
  core_dump_dest
  5. 
  Edit  your new controlfile (which you get in step 0) and change it 
  in:
      CREATE 
  CONTROLFILE REUSE SET DATABASE 'NEWSID' RESETLOGS 
      and change the path of 
  datafiles and logs
  6. Recreate 
  you control file.
  7. Change 
  your tnsnames.ora and sqlnet.ora files.
   
  This should 
  do. 
  I had no 
  problems in doing that
   
  HTH,
      Sonja
   
  
-Original Message-From: MRaval 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 
28, 2001 7:55 PMTo: Multiple recipients of list 
ORACLE-LSubject: Duplicating a Database and Changig 
SID
Hi Guys,
 
I am newbie oracle DBA and want to duplicate my  development 
database to Test database and want to change ORACLE_SID, Could anyone 
tell exact steps that I have to follow. My database is on SUN 5.6 and 
oracle 8.1.6.
 
Thanks,


New_dbid_guide.doc
Description: MS-Word document

Re: rman disk channel destination

[Ruth Gramolini]

Lisa,
I don't think that the channel has a location.  It is like a pipe to take
data from the db to the backup destination or put it back.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 4:30 PM


> This info isn't forthcoming on metalink or in the doco as far as I can
tell.
> Can anyone tell me how to change the directory associated with the rman
> command 'allocate channel disk'?  Or at least figure out where it is,
rather
> than hunt and peck?
>
> Is it fixed?  Boy that would really bite.
>
> Thanks
>
> Lisa Koivu
> Oracle Database Monkey Mama
> Fairfield Resorts, Inc.
> 954-935-4117
>
>

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: stripes, partitions, and spindles

[Ruth Gramolini]

Thanks all, I am going to give the IBM guy the book after I read it.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 8:30 AM


> Ruth:
>
> Get a copy of the Oracle8i DBA Handbook by Loney & Theriault.  Chapter 4's
> topic is Physical Database Layouts.  It goes from 22 disks down to 7.
>
> Hope this helps,
>
> Ken
>
>  -Original Message-
> Sent: Friday, November 30, 2001 6:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: stripes,  partitions, and spindles
>
> Good morning all,
>
> We have purchased new IBM AIX boxes and the guy whole sold them to us is
> here puting them together. ( He used to work for IBM.)  The question rises
> again, do I put my tablespaces on separate spindles, e.g. Data on one,
Data2
> (big extents) on 2, Index1, Index2 all on separate spindles or do I stipe
> everything.  We are planning to partition or largest table (bottleneck)
> after the duhvelopers figure out how to do it.
>
> We will have plenty of spindles for system,redo, etc.
>
> I need some good arguments for each.  I don't really think the ex-IBMer
> should have the final word.
>
> We have a three-tier application  which all employees use and nightly
batch
> processing.   We have two databases which run separately during the day
and
> communicat with each other at night through db_links.   Everything runs
> through this one huge table (it is like a general ledger).
>
> The boss says she has run a stiped Oracle database in the past but doesn't
> really know if this is the best.
>
> I will be eternally grateful for all info.
>
> TIA,
> Ruth
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
>   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: Ken Janusz
>   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: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RMAN disaster recovery

[Mike Killough]

I have never tried to burn my servers to ash, but I usually try to put the 
rman catalog on a different server than the ones that it is backing up. You 
also need to backup the catalog, which I do w/ a nightly export.


>From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RMAN disaster recovery
>Date: Fri, 30 Nov 2001 06:25:23 -0800
>
>I am wondering how RMAN would work for disaster recovery. Our manager's
>statement is "assume your server is reduced to a pile of ash. Now take your
>backup tape and build me a new system on a loaner from the vendor." I am
>trying to figure how that would work with RMAN. We are still at the stage 
>of
>just using RMAN to create disk copies, and we are on Compaq Tru64 UNIX. He
>wants us to demonstrate that level of recoverability, but I'm not sure how
>that would work. I think we could assume that we have a database to load 
>the
>RMAN catalog from an export.
>   One issue would be whether the disk location of the RMAN files might
>be different, and I'm not sure how to get RMAN to accept a different
>location. A more minor issue is if the database file locations are
>different, but I think that is pretty well documented.
>   Has anyone else tried this? What am I overlooking? Any ideas will be
>appreciated.
>Dennis Williams
>DBA
>Lifetouch, Inc.
>[EMAIL PROTECTED]
>
>--
>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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: PATCH confirmation

[Baker, Barbara]

btw...
When you apply this patch, the installer will likely tell you that the patch
needs an addtional 500 megs on your /oracle partition (on top of the space
already consumed by 8.1.7.0).

This is an Oracle faux pas.
8.1.7.2 takes about 20 megs more than 8.1.7.0 already consumed.



> --
> From: Nikunj Gupta[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, November 29, 2001 11:30 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: PATCH confirmation
> 
> How long does it take to install complete patch from 8.1.7.0 to 8.1.7.2 ?
> 
> 
> 
> Make a FREE long distance call from your PC!
> http://www.eboom.com/free/
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, November 29, 2001 12:10 PM
> 
> 
> > yes
> > 
> > Seema Singh wrote:
> > >
> > > Hi
> > > I think patch 1882450 is for upgrade from 8.1.7.0.0 to 8.1.7.2.0
> right?
> > > thanks
> > > seema
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Dennis M. Heisler
> >   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: Nikunj Gupta
>   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: Baker, Barbara
  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).

portable statistics

[Ruth Gramolini]

Good morning again,

I know that in 8i you can move statistics where you clone a database.  Is it
possible in 8.0.6.3?

Thanks!
Ruth

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: PATCH confirmation

[Baker, Barbara]

>From your patch number, I assume you're Sun/Solaris.
On a 3500 with 4 cpu's, patch took nearly 30 minutes.
On a 4500 with 8 cpu's, patch took about 20 minutes
YMMV

Barb


> --
> From: Nikunj Gupta[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, November 29, 2001 11:30 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: PATCH confirmation
> 
> How long does it take to install complete patch from 8.1.7.0 to 8.1.7.2 ?
> 
> 
> 
> Make a FREE long distance call from your PC!
> http://www.eboom.com/free/
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, November 29, 2001 12:10 PM
> 
> 
> > yes
> > 
> > Seema Singh wrote:
> > >
> > > Hi
> > > I think patch 1882450 is for upgrade from 8.1.7.0.0 to 8.1.7.2.0
> right?
> > > thanks
> > > seema
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Dennis M. Heisler
> >   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: Nikunj Gupta
>   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: Baker, Barbara
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Crontabs and Oracle

[Rao, Maheswara]

Tim,

Sourcing a .profile within cron jobs is not a good way doing a shell
scripting.  One big reason --- A .profile might contain a lot of functions
which are OK if you are loggin in with that specific user id.  And those
functions might be doing some job that might affect the cron job.

In my opinion, the correct way is to export the required variables or
setting them in the beginning of the cron job.

Rao

-Original Message-
Sent: Friday, November 30, 2001 5:35 AM
To: Multiple recipients of list ORACLE-L


On Thu, Nov 29, 2001 at 11:15:43AM -0800, [EMAIL PROTECTED] wrote:
> 
> I've seen a number of suggestions for sourcing .profile
> in the cron jobs, but this is not always a good idea, as
> .profile often contains script that will not execute when
> not attached to a tty.

I think sourcing .profile is the 'right' thing to do.

If that breaks then the .profile needs fixing as it'll probably
also break things like rsh/rcp etc.

I've seen both these code sytles used (for sh/ksh/bash etc):

if [ "$PS1" ]
then
... interactive stuff here ...
fi

or
case $- in
*i*)
... commands for an interactive shell here ...
;;
*)  ;;
esac

Tim.
-- 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, Maheswara
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Control files & Redo Logs

[Mike Killough]

There are advantages to oracle mirroring the redo logs. In the case of 
corruption, hardware or os level mirroring will duplicate the corruption 
accross the mirror. In the case of Oracle mirroring, Oracle should detect 
the corruption and write to the valid redo members.


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Control files & Redo Logs
>Date: Fri, 30 Nov 2001 05:45:23 -0800
>
>There's no point in mirroring control files on the same disk.  Control
>files should be mirrored across disks.  That way, if one disk crashes you
>can get a copy of the current control file from another disk (or just drop
>that control file from your init.ora file).  Control files are small and
>have minimal disk I/O.
>
>If you are mirroring your disks in hardware there is nothing to be gained
>by mirroring control files and redo logs in Oracle.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Standby Database

[Richard Ji]

Kay, thanks for the explanation.  Sorry for being a pain in butt.  But I see 
that the C program will write IMMEDIATELY AS SOON AS the log is written.
But this is not the same as doing it simultaneously.  So there is a chance (very very
small of course) that after LGWR writes the committed transaction and before
your C program copies the block which contains the change vector that the
system crash and online redo is lost.  Therefore you can guarantee 99.99% but not 100%?
Am I correct?

Thanks again.

Richard

>>> [EMAIL PROTECTED] 11/29/01 10:45PM >>>


Richard,

Comments inline..

-Original Message-
Sent: Thursday, November 29, 2001 6:40 AM
To: Multiple recipients of list ORACLE-L

This sounds good, but I have a couple of questions.  How do you guarantee
that
you won't lose any committed transactions?  I mean, the C program could lag
behind
the LGWR since it's only reading it without lock and it's copying the online
redo over
to a remote machine.  So for a busy database, the LGWR will just keep
writing and the
C program won't be able to keep up with it's pace.

The external program uses X$KCCCP as a feedback for copying process. X$KCCCP
will have
the current log block (Disk RBA) and this will have the change vectors for
last commit. So you
copy the change vectors/ redo records immediately as soon as it is written.
If LGWR can keep
writing the files means why can't your C program copy the files?

Are you copying the whole partially filled online redo? or just the
difference
since the last commit?
Difference from last copy.. (last commit )



Did I miss understand it?  Please advise.

>>> [EMAIL PROTECTED] 11/29/01 12:40AM >>>

If you want to Zero data loss in standby you can copy the online redo logs
thru an external C program.  You can copy the online redo log files when
the LGWR is writing to it.

The program should read the log files without locking. You can use the fixed
table  X$KCCLE and X$KCCCP to find how much is written in the log files.
The partially filled log file  can be shipped to the standby location and
you can
open the standby database with the new control file created with NORESETLOGs
.

In this way you have a graceful fail over in the standby database and no
committed
Transaction is lost in the standby database

Does this sound good?

Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Sent: Wednesday, November 28, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L

I am also facing the same problem. All these disadvantages in 8i standby DB
have been taken care of in oracle 9i version. The other solution could be to
buy an expensive Veritas Cluster server/Database edition.

Thanks,
-- Janardhana babu

-Original Message-
Sent: Wednesday, November 28, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Quick question.  Is it a fair statement to say that using Oracle's hot
standby database allows you recoverability up to the last archive log, but
would NOT recover to the latest redo log (prior to a log switch).  In other
words, the potential to lose transactions is very high if you depend on this
for failover (not good for e-commerce type databases).  Would it be possible
to somehow mirror redo logs across to the failover server and apply them
when activating the standby database, or is the only real solution
clustering or something like DoubleTake?

Am I making sense?

Thanks,

Ed


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Ed
  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: Janardhana Babu
  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).


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com 

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

Fat City Network Services-- (858

RMAN disaster recovery

[DENNIS WILLIAMS]

I am wondering how RMAN would work for disaster recovery. Our manager's
statement is "assume your server is reduced to a pile of ash. Now take your
backup tape and build me a new system on a loaner from the vendor." I am
trying to figure how that would work with RMAN. We are still at the stage of
just using RMAN to create disk copies, and we are on Compaq Tru64 UNIX. He
wants us to demonstrate that level of recoverability, but I'm not sure how
that would work. I think we could assume that we have a database to load the
RMAN catalog from an export. 
One issue would be whether the disk location of the RMAN files might
be different, and I'm not sure how to get RMAN to accept a different
location. A more minor issue is if the database file locations are
different, but I think that is pretty well documented. 
Has anyone else tried this? What am I overlooking? Any ideas will be
appreciated.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

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

RE: rman disk channel destination

[Koivu, Lisa]

Title: RE: rman disk channel destination





Thanks Deepak, Steve, Dennis, Jack... I was hoping I could set a default destination for the target database I guess.  Looks like that's not the case.  

I can live with this, though. 


Gracias
Lisa


-Original Message-
From:   Deepak Thapliyal [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, November 29, 2001 5:54 PM
To: Multiple recipients of list ORACLE-L
Subject:    Re: rman disk channel destination


try this ..


RUN
{ 
  ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT
'/disk1/%d_backups/%U'; 
  ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT
'/disk2/%d_backups/%U'; 
  ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT
'/disk3/%d_backups/%U';
  BACKUP DATABASE; 
} 



Deepak


PS: straight from the manual (based on search criteria
entered on google .. hehehe)



--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> This info isn't forthcoming on metalink or in the
> doco as far as I can tell.
> Can anyone tell me how to change the directory
> associated with the rman
> command 'allocate channel disk'?  Or at least figure
> out where it is, rather
> than hunt and peck?  
> 
> Is it fixed?  Boy that would really bite. 
> 
> Thanks
> 
> Lisa Koivu
> Oracle Database Monkey Mama
> Fairfield Resorts, Inc.
> 954-935-4117
> 
> 



__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: stripes, partitions, and spindles

[tday6]

Let's see if I can remember a summary of our last discussion on this.

RAID 10 (mirror then stripe) is the way to go unless it's a decision
support database (mostly read only) in which case RAID 5 takes fewer
platters.

If you have enough spindles, I personally would treat them as disks and go
with the "DBA Handbook" OFA.  Try to avoid not just "disk" contention but
also controller contention.

If you have a small number of users connected at any one time, make the
stripe small.  This will spread data over many platters and allow a single
user's query to be answered by multiple heads.  On the down side, it will
tie up the RAID device for the duration of the data fetch.  If you have a
large number of users at any one time, make the stripe small.  This reduces
the number of heads being used to answer a single user's query and allows
the RAID device to fetch data for multiple users simultaneously.

I would take the "general ledger" table and put it in its own tablespace
and probably spread that tablespace across multiple spindles by using
several datafiles.

I hope that this sparks a useful discussion.



   

Ruth   

GramoliniTo: Multiple recipients of list ORACLE-L  



@tax.state.vtcc:   

.us> Subject: stripes, partitions, and 
spindles
Sent by: root  

   

   

11/30/2001 

07:55 AM   

Please 

respond to 

ORACLE-L   

   

   





Good morning all,

We have purchased new IBM AIX boxes and the guy whole sold them to us is
here puting them together. ( He used to work for IBM.)  The question rises
again, do I put my tablespaces on separate spindles, e.g. Data on one,
Data2
(big extents) on 2, Index1, Index2 all on separate spindles or do I stipe
everything.  We are planning to partition or largest table (bottleneck)
after the duhvelopers figure out how to do it.

We will have plenty of spindles for system,redo, etc.

I need some good arguments for each.  I don't really think the ex-IBMer
should have the final word.

We have a three-tier application  which all employees use and nightly batch
processing.   We have two databases which run separately during the day and
communicat with each other at night through db_links.   Everything runs
through this one huge table (it is like a general ledger).

The boss says she has run a stiped Oracle database in the past but doesn't
really know if this is the best.

I will be eternally grateful for all info.

TIA,
Ruth

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ruth Gramolini
  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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Control files & Redo Logs

[Ruth Gramolini]

Thanks!  That is what I thought but you know the system folks think they
know more that us DBA's. And my boss thinks she know everything...
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 7:25 AM


> Yea it is - if you have enough disks, and I take it you are going to
mirror
> this as well, and not have *all* of your control files or on the *same*
> disk?
>
> -Original Message-
> Madan
> Sent: 30 November 2001 05:05
> To: Multiple recipients of list ORACLE-L
>
>
> Hi!!!
>
> Is it a good idea to put redo logs and control files on the same disk with
> nothing else on the disk???
>
> Thanks
>
> Sujatha
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sujatha Madan
>   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: Mark Leith
>   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: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Control files & Redo Logs

[tday6]

There's no point in mirroring control files on the same disk.  Control
files should be mirrored across disks.  That way, if one disk crashes you
can get a copy of the current control file from another disk (or just drop
that control file from your init.ora file).  Control files are small and
have minimal disk I/O.

If you are mirroring your disks in hardware there is nothing to be gained
by mirroring control files and redo logs in Oracle.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Export Problem - Urgent

[Cale, Rick T (Richard)]

You should try changing the nls_lang value on the client to match the
server.

Rick

-Original Message-
Sent: Friday, November 30, 2001 8:10 AM
To: Multiple recipients of list ORACLE-L





Hi,

  I am trying to export a data from server and getting following error
message:

EXP-00041: Export done in server's WE8ISO8859P1, different from user's 
character set US7ASCII
EXP-0: Export terminated unsuccessfully

How do I fix a problem.

My environment is SUN OS 5.6 and Oracle 8.1.6 and trying to export from
server itself but still getting error message.


Thanks,
Meghdeep
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MRaval
  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: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: stripes, partitions, and spindles

[Ken Janusz]

Ruth:

Get a copy of the Oracle8i DBA Handbook by Loney & Theriault.  Chapter 4's
topic is Physical Database Layouts.  It goes from 22 disks down to 7.

Hope this helps,

Ken 

 -Original Message-
Sent:   Friday, November 30, 2001 6:55 AM
To: Multiple recipients of list ORACLE-L
Subject:stripes,  partitions, and spindles

Good morning all,

We have purchased new IBM AIX boxes and the guy whole sold them to us is
here puting them together. ( He used to work for IBM.)  The question rises
again, do I put my tablespaces on separate spindles, e.g. Data on one, Data2
(big extents) on 2, Index1, Index2 all on separate spindles or do I stipe
everything.  We are planning to partition or largest table (bottleneck)
after the duhvelopers figure out how to do it.

We will have plenty of spindles for system,redo, etc.

I need some good arguments for each.  I don't really think the ex-IBMer
should have the final word.

We have a three-tier application  which all employees use and nightly batch
processing.   We have two databases which run separately during the day and
communicat with each other at night through db_links.   Everything runs
through this one huge table (it is like a general ledger).

The boss says she has run a stiped Oracle database in the past but doesn't
really know if this is the best.

I will be eternally grateful for all info.

TIA,
Ruth

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: Ken Janusz
  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).

Export Problem - Urgent

[MRaval]

Hi,

  I am trying to export a data from server and getting following error
message:

EXP-00041: Export done in server's WE8ISO8859P1, different from user's 
character set US7ASCII
EXP-0: Export terminated unsuccessfully

How do I fix a problem.

My environment is SUN OS 5.6 and Oracle 8.1.6 and trying to export from
server itself but still getting error message.


Thanks,
Meghdeep
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MRaval
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: RE: Siebel.

[Linda . Miller-Coker]

You'd almost have to be God to fix it.it consists of 1000s of tables.
It took me 2 weeks to reverse into Designer.  My customer is not welling to
pay for the time to fix the design.




"Mohan, Ross" <[EMAIL PROTECTED]>@fatcity.com on 11/29/2001 04:17:58 PM

Please respond to [EMAIL PROTECTED]



Sent by:  [EMAIL PROTECTED]


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


Dick,

question for yaif you "owned" Siebel, lock, stock and barrel,
what would you do?

1) Fix and switch ALL RI to the database ( oracle and ms and ibm and
others)
2) Just fix it where it is broken, but leave it in the app itself
3) leave it out but publish a tech spec document telling users/DBAs how
 and where to implement RI constraints.
4) something else.

I am curious how you would solve Tom Siebel's problem of shipping an app
across, say, four or five major different dbms platforms while
simultaneously
keeping bugs, development costs , requiring consulting and document costs
down,
and upgrade schedules and bug fixes in place.

In other words...if you were "god" how would you fix this problem you see?

curious,

Ross

-Original Message-
Sent: Thursday, November 29, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L


Dennis,

You ought to be a sales droid!  That was a perfectly worded reply and
in
MANY instances I'll agree with you.  The ease or of lack thereof in
administering an application is very often decided on by damagement by
whether
or not they need a dedicated/specialized resource to handle it.  Therefore
sales
droids will constantly downplay that requirement, until the check is in
hand.
Actually sales droids downplay a lot of requirements for their software
until
the deal is in the bank.  Then they drop the bomb.  And then people like us
are
left to clean up.

Dick Goulet

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
  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: 
  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).