Re: Shared pool wait for library cache pin
Hi, Queries with high version counts can cause library cache latch contention, as the query must hold that latch during soft parse and has to go through the entire list of query versions in the data dictionary. High version_count's are often caused by a high number of invalidations on the query. Invalidations of a query can be caused by a number of different things (one is the bug with timed_statistics, another is a bug present up to 8.1.6.3 in some instances when materialized views are used), other causes of invalidations are analyzing a dependent table or index, or truncating a dependent table. If this is causing you a problem, the next step is to track down what the cause of your high version_counts is, and work to correct it or workaround it (depending on the frequency that the query is executed, a shared pool flush may remove all versions (or none)). If it's not causing you a service problem currently, I would still keep an eye on it, as the version_count for queries rises, the chances of getting severe contention on the library cache latch increases. George // George Schlossnagle // www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN // Smarter than adding another team member, Pythian has new services // for supplementing DBAs: get our help with monitoring, 24x7 on-call, // daily verifications, storage management, performance and more. On Wednesday, January 2, 2002, at 04:35 PM, [EMAIL PROTECTED] wrote: Yes, there are a handful with more than 400. I'm not sure what high is? Cherie "George Schlossnagle" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> thian.com> Subject: Re: Shared pool wait for library cache pin Sent by: [EMAIL PROTECTED] 01/02/02 02:41 PM Please respond to ORACLE-L Do any of your queries have a high version_count (visible through v$sqlarea)? George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 3:20 PM We are seeing a lot of shared pool waits (for libary cache pin) on our 8.1.5 web-based application. We are seeing this via Precise/Indepth SQL monitoring tool. I haven't been able to find much documentation on shared pool waits or library cache pins. Can anyone tell me what might be causing this problem? Thanks, Cherie -- 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: George Schlossnagle 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: A DBA's career development
Dear Andrey and other Fellow DBA's, For quite some time I have been wondering about the same fact that Andrey has thought. I started my career Oracle 7 DBA and moved on. When 8 was released, we quickly did not upgrade the db. Now when 9i is released, with so many things in it, I asked myself what will happen to the future of DBA's who are associated with Oracle as DBA's. May now it is the time that we have to shift our gears and think of something innovative and do things which are beneficial to our children. If I'm wrong in any ways, then please excuse me. Regards Venkat -- On Wed, 02 Jan 2002 07:15:23 Andrey Bronfin wrote: >Dear list ! >Having been an Oracle DBA on UNIX & win platforms for past several years, i >feel like i'd like to change something. >Don't get me wrong , i like what i'm doing , but i think it's time to expand >my horizons. >I wouldn't like to completely quit the filed of Oracle/DBAing , but i'd like >to add something to it. >I also know some system UNIX (mainly Solaris) and some development (java , >perl , pl/sql etc.) >Where would i go next ? >I'm thinking of several possible paths : > Oracle DBA + UNIX sysadmin ; > Ora DBA + developer ; > DBA of Oracle + some other DB , that i'll need to learn >Or may be it's time to move to some sort of system analysis , >datawarehousing ,ERP or ... ??? >I'm thinking about the future of the market , demand for employees in >various fields , salaries etc.. > >What would U , dear gurus , say ? What do U think about your careers / >future ? > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Andrey Bronfin > 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). > -- Click here for your very own create-a-date adventure from MatchMaker Go to http://ecard.matchmaker.com/dating.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Shared pool wait for library cache pin
Have u tried disabling the timed_statistics=false in 8.1.5 there is a bug I am not sure. But try this out, When you are saying u are seeing very high version_count,then I have a feeling it pointing to that bug. Try disabling the timed_statistics and see. >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Shared pool wait for library cache pin >Date: Wed, 02 Jan 2002 13:35:20 -0800 > > >Yes, there are a handful with more than 400. >I'm not sure what high is? > >Cherie > > > > "George > Schlossnagle" To: Multiple recipients of >list ORACLE-L <[EMAIL PROTECTED]> > thian.com> Subject: Re: Shared pool >wait for library cache pin > Sent by: > [EMAIL PROTECTED] > > > 01/02/02 02:41 > PM > Please respond > to ORACLE-L > > > > > > >Do any of your queries have a high version_count (visible through >v$sqlarea)? > >George > >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Wednesday, January 02, 2002 3:20 PM > > > > > > We are seeing a lot of shared pool waits (for libary cache pin) on > > our 8.1.5 web-based application. We are seeing this via Precise/Indepth > > SQL monitoring tool. > > > > I haven't been able to find much documentation on shared pool waits or > > library cache pins. > > > > Can anyone tell me what might be causing this problem? > > > > Thanks, > > > > Cherie > > > > -- > > 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: George Schlossnagle > 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). _ 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: ARUN K C 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: Problem Setting Up User
Ken, First a question - what did you do for Oracle when you worked there? second... KIMV needs a synonym for the table to be able to refer to it with an owner qualifier third, you can only have ONE default role. Think about it. If you really want the user to have the privs of several roles at once, create another role, a "superrole" that is granted both DB and RESOURCE and the grant that one as default. And you really do have to RTFM Rachel --- Ken Janusz <[EMAIL PROTECTED]> wrote: > I am having a problem setting up a user on my DB (W2000 / 8.1.7). > > I have my self as user KENNETH and the new user is KIMV. > > She can access tables via KENNETH.TABLE_NAME or SYS.TABLE_NAME but > not jus > TABLE_NAME. > > Here is what I have (I am grantee KENNETH and the user I am setting > up is > KIMV): > > GRANTEE GRANTED_ROLEDEFAULT_ROLE > KENNETH CONNECT YES > KENNETH DBA YES > KENNETH EXP_FULL_DATABASE YES > KENNETH IMP_FULL_DATABASE YES > KENNETH RESOURCEYES > KENNETH SELECT_CATALOG_ROLE YES > KIMV CONNECT NO > KIMV DB NO > KIMV KIMVO NO > KIMV RESOURCEYES > KIMVO CONNECT YES > KIMVO RESOURCEYES > > Also, Oracle will only allow me to have one granted role as YES at a > time. > For example if I set DB to YES then RESOURCE goes to NO. > > Your help will be greatly appreciated. > > Thanks, > Ken > -- > 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). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Becoming a DBA questions
You know, I did not intend to leave the Fujitsu account either. But come the end of March I will be. -Original Message- Judy Sent: Wednesday, January 02, 2002 7:45 AM To: Multiple recipients of list ORACLE-L Somewhat different, but my son's taking his CCNA (Cisco Certified Networking Associate) this p.m. He realizes that it's not going to guarantee him a job, but he hopes it will help him get his foot in the door. He's 19, and just finished the Cisco networking academy. He took the first year at his high school, and the second year at the local community college. Without experience, he knows it will be more difficult to get a job. He hopes this will indicate that he has at least some background and training in the area. His intent is to work full time as a network admin type while he goes to a four-year college part-time. He eventually wants to get a degree in theatre arts, but doesn't want mom and dad to pay for it. (I don't know why - he's very different from his sibs!) He figures this will allow him to get a half-way decent job while he goes to school. I don't yet have my OCP, but my boss is encouraging me to go for it. The higher ed types seem to be impressed by pieces of paper! I think it would look nice on a resume, but I don't intend to leave here so I'm not sure it's worth the effort. -Original Message- Sent: Tuesday, January 01, 2002 11:00 PM To: Multiple recipients of list ORACLE-L Kimberly, I'm with you and like you I only took the 8 test because at the time, my employer paid for the tests and gave me a bonus to pass them(like $250/test and $1000K when all done, if i remember correctly), so i had incentive :). Joe Kimberly Smith wrote: > I for the most part have stayed out of this whole OCP thing cause I too > think its fairly worthless to determine if someone has the skills necessary > to perform the job of DBA. And that is despite the fact I have gone > ahead and gotten my Oracle8 DBA and then upgrading to 8i after. > > That, however, does not make it worthless in getting an interview. I > believe > that we have already pretty much gone over the whole fact that you have > to get by HR before getting an interview and you do need to have something > to > get you that edge. Sometimes all it takes is the OCP. Are managers wrong > to let it influence them? It depends. If they are saying, that person has > an OCP, they must be good, then yes, they are being influenced incorrectly. > However, if they are saying hey, that person took some time to get an OCP. > Lets bring them in for an interview and see if they know what they are > talking > about then I say its a good thing. And so far I have seem more of the later > then the former, at least within the company I work for. > > To me it just shows that I am keeping up to date on my database of choice. > I back it up with my experience. And if that gets me a job over someone > with similar experience but thought it was not worth their time to get the > OCP then sucks to be you. Its not predominate on my resume but bet your > ass that its there. > > Granted, having my company pay for the tests make it an easier decision to > go get them and I am not so sure I would be so willing to do it if the > company > was not willing. If the company is paying, get the damn chip off your > shoulder > and go take the tests. If you are good as you say you are and the tests > as easy as you say they are then what the hell is the big deal. I have yet > to take longer then 15 minutes to do the test (including the survey). > Including the drive and stuff surely you can all spare an hour and increase > the cash inflow at Oracle > > This email was not directed specifically at you Joe, just replying to the > whole OCP thing (especially since you seem to have the same thought process > in > this case). OK, back to the wine... > > -Original Message- > Sent: Tuesday, January 01, 2002 6:10 PM > To: Multiple recipients of list ORACLE-L > > > Edward, i beg to differ, the ONLY thing that OCP is good for is a > discriminator between to evenly qualified/interviewed candidates. > > As someone who does hiring of oracle DBAs and who's been one for 10 > years and is OCP, I'm skeptical of those who make a big deal out of > being OCP, since that tends to make me believe that they DONT have the > experience to back it up. > > Joe > 8 and 8i OCP(but rarely makes it known). > > Edward Lock wrote: > > >>As someone with 7 years in the HR (Compensation) field, and now in the >>IT/ERP field working on my Oracle DBA OCP, I can speak with some >>knowledge and experience. >> >> >> >>Using the term "Entry Level" on a resume is self-defeating. Most >>technical resumes are still screened by by the HR departments first, >>before the hiring managers even see them. A good recruiter will be able >>to identify whether you have the experience or not. If not, they will >>defer a judgment call to the hiring IT manager anyway. That doesn't
Perl Script to get DDL from Indexfile - Part3
Finally, to get the ALTER statements from the
indexfile:
#!/usr/local/bin/perl -w
# Extract ALTER TABLE statements
# By: MKB Jan 02 2002
# Inputs: Location of log file and file output
# Outputs: Writes to file output
# Modification History:
#
use strict;
my ($infile, $outfile);
my $usage = "usage: \n";
$usage = $usage . "Example: /home/oracle/file.log
/home/oracle/alter.log \n";
if ($#ARGV != 1) { die($usage) }
else { $infile = $ARGV[0];
$outfile = $ARGV[1];
};
open my $fh, $infile or die print "can't open";
open my $fh_out, ">$outfile" or die
my @strg;
my $i = 0;
my $long_strg = "";
while (<$fh>) {
$_=~ s/^REM //;
$_=~ s/\n//;
@strg = split / /, $_;
# print all elements in array
# and make one long string
for ($i = 0; $i <= $#strg; $i++) {
if ($strg[$i] ne ";") {
$long_strg = $long_strg . " " . $strg[$i];
}
else {
if ($long_strg =~ m/ALTER TABLE/) {
$long_strg =~ s/"//g;
$long_strg =~ s/ALTER TABLE
((\w+).(\w+))/ALTER TABLE $1\n/;
$long_strg =~ s/ADD CONSTRAINT
(\w+|\W+)/ADD CONSTRAINT $1\n/;
$long_strg =~ s/PRIMARY KEY
(\w+|\W+)/PRIMARY KEY $1\n/;
$long_strg =~ s/(\w+|\W+),/ $1,\n/g;
$long_strg =~ s/INITRANS/\n INITRANS/g;
$long_strg =~ s/MINEXTENTS/\n
MINEXTENTS/g;
$long_strg =~ s/PCTINCREASE/\n
PCTINCREASE/g;
$long_strg =~ s/PCTFREE (\d+) /\n PCTFREE
$1 /g;
$long_strg =~ s/((LOGGING|NOLOGGING)
(LOCAL|GLOBAL))\(/$1\n\(/g;
$long_strg =~ s/(TABLESPACE
(\w+|\W+))|(TABLESPACE (\w+\W+) LOB)/\n $1/g;
$long_strg =~ s/ STORAGE\(/\n STORAGE
\(/g;
print $fh_out $long_strg . ";\n\n";
}
$long_strg = "";
}
}
}
close $fh;
close $fh_out;
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mohammed bhatti
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).
Perl Script to get DDL from Indexfile - Part2
For indexes, use this:
#!/usr/local/bin/perl -w
# Extract CREATE UNIQUE|BITMAP INDEX statements
# By: MKB Jan 02 2002
# Inputs: Location of log file and file output
# Outputs: Writes to file output
# Modification History:
#
use strict;
my ($infile, $outfile);
my $usage = "usage: \n";
$usage = $usage . "Example: /home/oracle/file.log
/home/oracle/index.log \n";
if ($#ARGV != 1) { die($usage) }
else { $infile = $ARGV[0];
$outfile = $ARGV[1];
};
open my $fh, $infile or die print "can't open";
open my $fh_out, ">$outfile" or die
"Can't create $!";
my @strg;
my $i = 0;
my $long_strg = "";
while (<$fh>) {
$_=~ s/^REM //;
$_=~ s/\n//;
@strg = split / /, $_;
# print all elements in array
# and make one long string
for ($i = 0; $i <= $#strg; $i++) {
if ($strg[$i] ne ";") {
$long_strg = $long_strg . " " . $strg[$i];
}
else {
if ($long_strg =~ m/CREATE UNIQUE|BITMAP
INDEX/) {
$long_strg =~ s/"//g;
$long_strg =~ s/CREATE (UNIQUE|BITMAP)
INDEX ((\w+).(\w+))/CREATE $1 INDEX $2 \n/;
$long_strg =~ s/(\w+|\W+),/$1,\n/g;
$long_strg =~ s/INITRANS/\n INITRANS/g;
$long_strg =~ s/MINEXTENTS/\n
MINEXTENTS/g;
$long_strg =~ s/PCTINCREASE/\n
PCTINCREASE/g;
$long_strg =~ s/PCTFREE (\d+) /\n PCTFREE
$1 /g;
$long_strg =~ s/((LOGGING|NOLOGGING)
(LOCAL|GLOBAL))\(/$1\n\(/g;
$long_strg =~ s/(TABLESPACE
(\w+|\W+))|(TABLESPACE (\w+\W+) LOB)/\n $1/g;
$long_strg =~ s/ STORAGE\(/\n STORAGE
\(/g;
print $fh_out $long_strg . ";\n\n";
}
$long_strg = "";
}
}
}
close $fh;
close $fh_out;
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mohammed bhatti
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).
Perl Script to get DDL from Indexfile - Part1
I've always wanted an easy way to extract DDL info
from an import indexfile so I wrote a little perl
script that will extract create table ddl from an
indexfile. Seems to work and is a lot faster than
hand editing. Would appreciate any feedback/criticism
or ways to improve the script.
#!/usr/local/bin/perl -w
# Extract CREATE TABLE statements from export file
# By: MKB Jan 02 2002
# Inputs: Location of log file and file output
# Outputs: Writes to file output
# Modification History:
#
use strict;
my ($infile, $outfile);
my $usage = "usage: \n";
$usage = $usage . "Example: /home/oracle/file.log
/home/oracle/table.log \n";
if ($#ARGV != 1) { die($usage) }
else { $infile = $ARGV[0];
$outfile = $ARGV[1];
};
open my $fh, $infile or die print "can't open";
open my $fh_out, ">$outfile" or die
"Can't create $!";
my @strg;
my $i = 0;
my $long_strg = "";
while (<$fh>) {
$_=~ s/^REM //;
$_=~ s/\n//;
@strg = split / /, $_;
# print all elements in array
# and make one long string
for ($i = 0; $i <= $#strg; $i++) {
if ($strg[$i] ne ";") {
$long_strg = $long_strg . " " . $strg[$i];
}
else {
if ($long_strg =~ m/CREATE TABLE/) {
$long_strg =~ s/"//g;
$long_strg =~ s/CREATE TABLE
((\w+).(\w+))/CREATE TABLE $1 \n/;
$long_strg =~ s/(\w\D),/$1,\n/g;
$long_strg =~ s/INITRANS/\n INITRANS/g;
$long_strg =~ s/MINEXTENTS/\n
MINEXTENTS/g;
$long_strg =~ s/PCTINCREASE/\n
PPCTINCREASE/g;
$long_strg =~ s/PCTFREE (\d+) /\n PCTFREE
$1 /g;
$long_strg =~ s/(TABLESPACE
(\w+|\W+))|(TABLESPACE (\w+\W+) LOB)/\n $1/g;
$long_strg =~ s/STORE AS/\n STORE AS/;
$long_strg =~ s/ STORAGE\(/\n STORAGE
\(/g;
print $fh_out $long_strg . ";\n\n";
}
$long_strg = "";
}
}
}
close $fh;
close $fh_out;
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mohammed bhatti
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: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.
Happy New Year! Agreed! I like so much with locally managed tablespace because every extent size is uniform, therefore no fragmentation; you don't have to worry about the number of extents at the table level. I even make the temporary tablespace to be LMT. What is the acceptable extent size if you mix large tables with small tables (in terms of nbr of rows) in one tablespace? For example: you have 20 tables; 10 of them will have only less than 1000 rows, 5 of them will have less than 2 rows and the rest will have 10 rows or more. Now what is the appropriate extent size for the tablespace if you decide to create only one tablespace for all 20 tables? If you split into 3 tablespaces, then you can easily set the extent size for each. Please don't let it frustrate you! If you are very concerned with wasting space, then you should split into more tablespaces. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 1/2/02 2:15 AM Connor McDonald wrote: > > Dictionary managed tspaces are practically > obsolete...Go with locally managed - they are the > default in 9i and as of 9i.2, *all* tablespaces will > default to locallly managed (including system) > > hth > connor > > --- Arul kumar <[EMAIL PROTECTED]> wrote: > Hi > DBAs, > > > > I would like to know on what basis we arrive at the > > decision of making a > > tablespace as LOCALLY Managed / DICTIONARY > > Managed... > > > > Any Suggestions / Tips > > > > Thank you.. > > > > Arul. > > > > > * > > Disclaimer > > > > This message (including any attachments) contains > > confidential information intended for a specific > > individual and purpose, and is protected by law. > > If you are not the intended recipient, you should > > delete this message and are hereby notified that > > any disclosure, copying, or distribution of this > > message, or the taking of any action based on it, > > is strictly prohibited. > > > > > * > > Visit us at http://www.mahindrabt.com > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Arul kumar > > 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 Sybasation ;-) ? -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Wong, Bing 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: A DBA's career development
"Khedr, Waleed" wrote: > I'd like to be rich and retire now. Spend more time with my family and kids. >... > When this happens, I do not want to see Oracle:)- Ooohkay...but you still going to stick with us sorry lot that still have to fight the brain-frying, mutant-cyber pokemon-beast, right ??? Robert Chin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin 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: Install 8.1.7 release 3 Enterprise Edition
Just skip the default database.
If you really want it, just have the installer generate scripts then
run the scripts manually.
Jared
"Gordon, Emery
{PDBI~Palo To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Alto}" cc:
Sent by:
[EMAIL PROTECTED]
om
01/02/02 02:00
PM
Please respond
to ORACLE-L
I installed on NT 4.0 server. Taking the default install it installes all
and begins to initialize the default database and gives the message
ora-03113(End of file on communications channel) after about 90%
installation. Have tried it from multiple machines with the same results.
It
worked fine for windows 2000.
Emery Gordon
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gordon, Emery {PDBI~Palo Alto}
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: A DBA's career development
I'd like to be rich and retire now. Spend more time with my family and kids. Also spend more time in playing Tennis. When this happens, I do not want to see Oracle:)- But can't! -Original Message- Sent: Wednesday, January 02, 2002 10:15 AM To: Multiple recipients of list ORACLE-L Dear list ! Having been an Oracle DBA on UNIX & win platforms for past several years, i feel like i'd like to change something. Don't get me wrong , i like what i'm doing , but i think it's time to expand my horizons. I wouldn't like to completely quit the filed of Oracle/DBAing , but i'd like to add something to it. I also know some system UNIX (mainly Solaris) and some development (java , perl , pl/sql etc.) Where would i go next ? I'm thinking of several possible paths : Oracle DBA + UNIX sysadmin ; Ora DBA + developer ; DBA of Oracle + some other DB , that i'll need to learn Or may be it's time to move to some sort of system analysis , datawarehousing ,ERP or ... ??? I'm thinking about the future of the market , demand for employees in various fields , salaries etc.. What would U , dear gurus , say ? What do U think about your careers / future ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: Khedr, Waleed 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: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.
Google to the rescue... just one of the many links: http://www.dbatoolbox.com/WP2001/spacemgmt/defrag.htm -Joe At 02:10 PM 1/2/02 -0800, you wrote: >Arul - I would recommend reading "How to Stop Defragmenting and Start >Living: The Definitive Word on Fragmentation" by Bhaskar Himatsingka, an >Oracle white paper. I was going to provide a link to it, but Oracle's >website search function doesn't seem to work for me right now. >Dennis Williams >DBA >Lifetouch, Inc. >[EMAIL PROTECTED] > > > > >-Original Message- >Sent: Wednesday, January 02, 2002 12:10 AM >To: Multiple recipients of list ORACLE-L > > >Hi DBAs, > >I would like to know on what basis we arrive at the decision of making a >tablespace as LOCALLY Managed / DICTIONARY Managed... > >Any Suggestions / Tips > >Thank you.. > >Arul. > >* >Disclaimer > >This message (including any attachments) contains >confidential information intended for a specific >individual and purpose, and is protected by law. >If you are not the intended recipient, you should >delete this message and are hereby notified that >any disclosure, copying, or distribution of this >message, or the taking of any action based on it, >is strictly prohibited. > >* >Visit us at http://www.mahindrabt.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Arul kumar > 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: Joe Raube 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: A DBA's career development
Andrey - You may also want to consider positioning yourself toward being a system architect. How are your data modeling skills? Skills at building a group consensus? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 02, 2002 9:15 AM To: Multiple recipients of list ORACLE-L Dear list ! Having been an Oracle DBA on UNIX & win platforms for past several years, i feel like i'd like to change something. Don't get me wrong , i like what i'm doing , but i think it's time to expand my horizons. I wouldn't like to completely quit the filed of Oracle/DBAing , but i'd like to add something to it. I also know some system UNIX (mainly Solaris) and some development (java , perl , pl/sql etc.) Where would i go next ? I'm thinking of several possible paths : Oracle DBA + UNIX sysadmin ; Ora DBA + developer ; DBA of Oracle + some other DB , that i'll need to learn Or may be it's time to move to some sort of system analysis , datawarehousing ,ERP or ... ??? I'm thinking about the future of the market , demand for employees in various fields , salaries etc.. What would U , dear gurus , say ? What do U think about your careers / future ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: Problem Setting Up User
Ken, Take a look at 'create synonym' in the docs. There are two kinds: public and private. For a private synonyms, the user KIMV would need to execute the statement 'create synonym TABLE_NAME for KENNETH.TABLE_NAME'; For a public synonym, a user with the 'create any synonym privilege' would need to do: 'create public synonym TABLE for KENNETH.TABLE_NAME;' There can be performance implications in the use of synonyms in a busy system. Read more about it at www.ixora.com.au. Jared Ken Janusz fsys.com>cc: Sent by: Subject: Problem Setting Up User [EMAIL PROTECTED] om 01/02/02 01:05 PM Please respond to ORACLE-L I am having a problem setting up a user on my DB (W2000 / 8.1.7). I have my self as user KENNETH and the new user is KIMV. She can access tables via KENNETH.TABLE_NAME or SYS.TABLE_NAME but not jus TABLE_NAME. Here is what I have (I am grantee KENNETH and the user I am setting up is KIMV): GRANTEE GRANTED_ROLE DEFAULT_ROLE KENNETH CONNECT YES KENNETH DBA YES KENNETH EXP_FULL_DATABASE YES KENNETH IMP_FULL_DATABASE YES KENNETH RESOURCEYES KENNETH SELECT_CATALOG_ROLEYES KIMV CONNECT NO KIMV DB NO KIMV KIMVO NO KIMV RESOURCEYES KIMVO CONNECT YES KIMVO RESOURCEYES Also, Oracle will only allow me to have one granted role as YES at a time. For example if I set DB to YES then RESOURCE goes to NO. Your help will be greatly appreciated. Thanks, Ken -- 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: 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: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.
Arul - I would recommend reading "How to Stop Defragmenting and Start Living: The Definitive Word on Fragmentation" by Bhaskar Himatsingka, an Oracle white paper. I was going to provide a link to it, but Oracle's website search function doesn't seem to work for me right now. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 02, 2002 12:10 AM To: Multiple recipients of list ORACLE-L Hi DBAs, I would like to know on what basis we arrive at the decision of making a tablespace as LOCALLY Managed / DICTIONARY Managed... Any Suggestions / Tips Thank you.. Arul. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar 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).
Install 8.1.7 release 3 Enterprise Edition
I installed on NT 4.0 server. Taking the default install it installes all
and begins to initialize the default database and gives the message
ora-03113(End of file on communications channel) after about 90%
installation. Have tried it from multiple machines with the same results. It
worked fine for windows 2000.
Emery Gordon
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gordon, Emery {PDBI~Palo Alto}
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: Shared pool wait for library cache pin
Cherie, What constitutes 'a lot of shared pool waits (for libary cache pin)'? Does it represent a significant percentage of total waits, or is it just crossing some predetermined threshold? Is it causing a performance problem? ( as seen by users, not by a monitoring tool ) Jared Cherie_Machler @gelco.com To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Shared pool wait for library cache pin om 01/02/02 12:20 PM Please respond to ORACLE-L We are seeing a lot of shared pool waits (for libary cache pin) on our 8.1.5 web-based application. We are seeing this via Precise/Indepth SQL monitoring tool. I haven't been able to find much documentation on shared pool waits or library cache pins. Can anyone tell me what might be causing this problem? Thanks, Cherie -- 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: Problem Setting Up User
Hi Ken, You have to fully specify all of the roles that you want to be default in one alter statement alter user kimv default role connect,db,resource; should turn all to YES. You may also need to make sure that your synonyms are public. Hope this helps, John [EMAIL PROTECTED] wrote: >I am having a problem setting up a user on my DB (W2000 / 8.1.7). > >I have my self as user KENNETH and the new user is KIMV. > >She can access tables via KENNETH.TABLE_NAME or SYS.TABLE_NAME but not jus >TABLE_NAME. > >Here is what I have (I am grantee KENNETH and the user I am setting up is >KIMV): > >GRANTEE GRANTED_ROLEDEFAULT_ROLE >KENNETH CONNECT YES >KENNETH DBA YES >KENNETH EXP_FULL_DATABASE YES >KENNETH IMP_FULL_DATABASE YES >KENNETH RESOURCEYES >KENNETH SELECT_CATALOG_ROLE YES >KIMVCONNECT NO >KIMVDB NO >KIMVKIMVO NO >KIMVRESOURCEYES >KIMVO CONNECT YES >KIMVO RESOURCEYES > >Also, Oracle will only allow me to have one granted role as YES at a time. >For example if I set DB to YES then RESOURCE goes to NO. > >Your help will be greatly appreciated. > >Thanks, >Ken > -- 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: Problem Setting Up User
Have you created synonyms? At 01:05 PM 1/2/02 -0800, you wrote: >I am having a problem setting up a user on my DB (W2000 / 8.1.7). > >I have my self as user KENNETH and the new user is KIMV. > >She can access tables via KENNETH.TABLE_NAME or SYS.TABLE_NAME but not jus >TABLE_NAME. > >Here is what I have (I am grantee KENNETH and the user I am setting up is >KIMV): > >GRANTEE GRANTED_ROLEDEFAULT_ROLE >KENNETH CONNECT YES >KENNETH DBA YES >KENNETH EXP_FULL_DATABASE YES >KENNETH IMP_FULL_DATABASE YES >KENNETH RESOURCEYES >KENNETH SELECT_CATALOG_ROLE YES >KIMVCONNECT NO >KIMVDB NO >KIMVKIMVO NO >KIMVRESOURCEYES >KIMVO CONNECT YES >KIMVO RESOURCEYES > >Also, Oracle will only allow me to have one granted role as YES at a time. >For example if I set DB to YES then RESOURCE goes to NO. > >Your help will be greatly appreciated. > >Thanks, >Ken >-- >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: Joe Raube 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: Problem Setting Up User
Create a synonym for KENNETH.TABLE_NAME coz if she(KIMV) doesn't own it she will have to prefix the owner before the table_name. HTH Shailesh -Original Message- Sent: Wednesday, January 02, 2002 4:05 PM To: Multiple recipients of list ORACLE-L I am having a problem setting up a user on my DB (W2000 / 8.1.7). I have my self as user KENNETH and the new user is KIMV. She can access tables via KENNETH.TABLE_NAME or SYS.TABLE_NAME but not jus TABLE_NAME. Here is what I have (I am grantee KENNETH and the user I am setting up is KIMV): GRANTEE GRANTED_ROLEDEFAULT_ROLE KENNETH CONNECT YES KENNETH DBA YES KENNETH EXP_FULL_DATABASE YES KENNETH IMP_FULL_DATABASE YES KENNETH RESOURCEYES KENNETH SELECT_CATALOG_ROLE YES KIMVCONNECT NO KIMVDB NO KIMVKIMVO NO KIMVRESOURCEYES KIMVO CONNECT YES KIMVO RESOURCEYES Also, Oracle will only allow me to have one granted role as YES at a time. For example if I set DB to YES then RESOURCE goes to NO. Your help will be greatly appreciated. Thanks, Ken -- 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: Yadav, Shailesh 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: Shared pool wait for library cache pin
Yes, there are a handful with more than 400. I'm not sure what high is? Cherie "George Schlossnagle" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Shared pool wait for library cache pin Sent by: [EMAIL PROTECTED] 01/02/02 02:41 PM Please respond to ORACLE-L Do any of your queries have a high version_count (visible through v$sqlarea)? George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 3:20 PM > > We are seeing a lot of shared pool waits (for libary cache pin) on > our 8.1.5 web-based application. We are seeing this via Precise/Indepth > SQL monitoring tool. > > I haven't been able to find much documentation on shared pool waits or > library cache pins. > > Can anyone tell me what might be causing this problem? > > Thanks, > > Cherie > > -- > 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: George Schlossnagle 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).
Problem Setting Up User
I am having a problem setting up a user on my DB (W2000 / 8.1.7). I have my self as user KENNETH and the new user is KIMV. She can access tables via KENNETH.TABLE_NAME or SYS.TABLE_NAME but not jus TABLE_NAME. Here is what I have (I am grantee KENNETH and the user I am setting up is KIMV): GRANTEE GRANTED_ROLEDEFAULT_ROLE KENNETH CONNECT YES KENNETH DBA YES KENNETH EXP_FULL_DATABASE YES KENNETH IMP_FULL_DATABASE YES KENNETH RESOURCEYES KENNETH SELECT_CATALOG_ROLE YES KIMVCONNECT NO KIMVDB NO KIMVKIMVO NO KIMVRESOURCEYES KIMVO CONNECT YES KIMVO RESOURCEYES Also, Oracle will only allow me to have one granted role as YES at a time. For example if I set DB to YES then RESOURCE goes to NO. Your help will be greatly appreciated. Thanks, Ken -- 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).
RE: VLDB backup policy
Title: RE: VLDB backup policy check out SharePlex for Oracle. The target system is completely open and available while it is applying the changes from the source. If you are expecting < 25 GB of redo generation per day, it will usually be under 15 seconds latency. And it's a LOT cheaper than the hardware solutions. (not to mention nicer to the network too) -Original Message- From: Loughmiller, Greg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 12:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: VLDB backup policy It works really well for a DR site though!! Greg -Original Message- Sent: Wednesday, January 02, 2002 2:20 PM To: Multiple recipients of list ORACLE-L One problem with SRDF though is that it doesn't protect against block corruption. SRDF is really really cool, but is not a complete backup plan in and of itself. George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 12:48 PM > The problem is, most business users say "5 minutes" (and btw, the emc > srdf option is actually faster than a hot standby, since a hot standby > might need log files to be applied while the mirroring does not -- > check out Lawrence To's papers) > > so you go ahead and figure out what a "5 minutes" scenario costs and > then they say "no way, it's too expensive".. but they still want "5 > minutes" > > It doesn't hurt to give them all their options and let them do the > "time vs money" decision. > > > --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > > Andrey, > > > > I think that you are looking at this problem from the wrong end. > > Rather > > than come up with backup scenarious first and reporting back to > > management, > > I think you need to get managment to declare to you their "Mean Time > > to > > Recovery". By this I mean that they need to tell you how long they > > can > > survive without a database before it begins to affect their > > operations. > > > > Depending on their answer, it drives your research in certain > > directions. > > > > If they say "10 minutes", you have no choice but to have a > > hot-standby > > database running. > > > > If they say 1 hour, you could use EMC/mirror disk options (like > > Rachel just > > mentioned). > > > > If they say 24 hours, then RMan backup/restore from tape (probably > > the > > cheapest solution) would work for you. > > > > Kimberly's suggestions are very good if you are following the Rman > > scenario. > > > > Hope this helps > > > > Tom Mercadante > > Oracle Certified Professional > > > > > > -Original Message- > > Sent: Wednesday, January 02, 2002 10:35 AM > > To: Multiple recipients of list ORACLE-L > > > > > > You could split off a mirror and backup the mirror however, I have > > never > > done that so I am not going > > to get into it. I know there are others in the list who have done it > > for > > their backup strategy. > > > > Keep in mind that if you are running in archive log mode you need not > > backup > > every data file at the > > same time. This would be your cheap end solution. Make sure you > > have > > enough disk to deal with > > your archive logs (depends on how much you want to keep on disk). I > > would > > place objects in tablespaces > > based on usage rather then size or functionality. In other words, if > > you > > have a bunch of tables that > > have very little data changed or data that does get changed does so > > infrequently then place them in > > the same tablespace. If you have tables that have change constantly > > then > > keep them together. Granted > > you may end up with more then one tablespace per change type but > > don't mix. > > Then schedule backups > > of those tablespaces more frequently then others. Try and get the > > full > > backup done by the end of > > the week for all tablespaces. Keep in mind that the control file and > > other > > stuff need to be backed up > > as well. > > > > Your recovery is going to be a little more complicated this way and > > time to > > recover is going to be > > longer but if you get the frequently changed tablespaces more often > > then it > > should not be too bad. > > > > -Original Message- > > Sent: Wednesday, January 02, 2002 6:50 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Dear list ! > > I'm reposting this , since got no replies yet. > > > > I need to design a backup policy for a VLDB sized some 10TB, running > > as close to 24X7 as possible. > > I need 2 versions of the policy: > > One is the "best case" , i.e. money does not matter, the company can > > aquire > > any software / hardware , the only goal is to have a solid backup and > > ability to backup and recover as fast as possible. > > The second is the opposite case - how to achieve a good backup > > spending as > > little money as possible, possibly tolerating a little more downtime > > in case > > of a crash. > > > > I just have ne
Re: stupid oracle on windoze question
learn something new every day. --- orantdba <[EMAIL PROTECTED]> wrote: > HI All, > > It is in that useless documentation, from the Net8 Administrators > Guide > >1. Ensure that the client machine has the tnsnames.ora and the > sqlnet.ora files in $ORACLE_HOME/network/admin on UNIX and > ORACLE_HOME\network\admin on Windows platforms. > > The search order for sqlnet.ora and tnsnames.ora follows: > > 1. Current working directory from where an application is > executed > 2. TNS_ADMIN environment variable > > If the TNS_ADMIN environment variable is not defined as a > variable on Windows NT, it may be in the registry. > > 3. If TNS_ADMIN is not defined, $ORACLE_HOME/network/admin > on > UNIX and ORACLE_HOME\network\admin on Windows platforms > > The one that I haven't seen documented is the "dot tnsnames.ora" on > unix > > Hope this helps, > -- John > > [EMAIL PROTECTED] wrote: > > >ah but you can do something similar, at least according to Joe -- he > >found it on a thread on MetaLink. > > > >You put a tnsnames.ora file in your local directory (I would suppose > >without setting TNS_ADMIN) and then it will use the local one > > > >interesting, veddy interesting > > > > > >--- [EMAIL PROTECTED] wrote: > > > >>Not only is it not in the flaming manuals, I don't think you > >>can even do that on Windoze. > >> > >>Sure, you can set the TNS_ADMIN var in > >>ControlPanel->System->EnvVars, but that is rather broad > >>in scope and does not offer the granularity available on unix. > >> > >>Jared > >> > >> > >> > >> > > >> > >>Rachel > > >> > >>Carmichael To: Multiple > recipients > >>of list ORACLE-L <[EMAIL PROTECTED]> > >> > >> > >>AHOO.COM>Subject: RE: stupid > >>oracle on windoze question > >>Sent by: > > >> > >>[EMAIL PROTECTED] > > >> > >>om > > >> > >> > > >> > >> > > >> > >>01/02/02 07:50 > > >> > >>AM > > >> > >>Please respond > > >> > >>to ORACLE-L > > >> > >> > > >> > >> > > >> > >> > >> > >> > >> > >>well the thing is, he wasn't looking for TNS_ADMIN since that just > >>re-sets the directory Oracle looks at but wanted something that > >>worked > >>more like how login.sql works -- where if you have the file in your > >>local working directory, it is used and overrides any other file. > >> > >>In Unix, if you have a .tnsnames.ora file (please note the initial > >>".") > >>in your own personal $HOME directory) it will override the values > in > >>the $ORACLE_HOME/network/admin/tnsnames.ora or the > >>$TNS_ADMIN/tnsnames.ora file > >> > >>THAT is what Joe wanted for Windows. It ain't in the flaming > >>manuals. > >> > >> > >>--- Kimberly Smith <[EMAIL PROTECTED]> wrote: > >> > >>>Damn, why don't people use the manuals. TNS_ADMIN. Actually, you > >>>can set > >>>the puppy on Unix as well. > >>> -Original Message- > >>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE > >>>TESTA > >>> Sent: Wednesday, January 02, 2002 6:15 AM > >>> To: Multiple recipients of list ORACLE-L > >>> Subject: stupid oracle on windoze question > >>> > >>> > >>> ok in the unix world, we have .tnsnames.ora file which overrides > >>> > >>a > >> > >>>$HOME/network/admin/tnsnames.ora file. > >>> > >>> Is there such a thing in the windoze world. a registry entry > >>>maybe? > >>> > >>> thanks, joe > >>> > >>> > >> > >>__ > >>Do You Yahoo!? > >>Send your FREE holiday greetings online
Re: Shared pool wait for library cache pin
Do any of your queries have a high version_count (visible through v$sqlarea)? George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 3:20 PM > > We are seeing a lot of shared pool waits (for libary cache pin) on > our 8.1.5 web-based application. We are seeing this via Precise/Indepth > SQL monitoring tool. > > I haven't been able to find much documentation on shared pool waits or > library cache pins. > > Can anyone tell me what might be causing this problem? > > Thanks, > > Cherie > > -- > 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: George Schlossnagle 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: Table MONITORING
In one version (I think is was 8.1.6.x.x) analyze stale didn't work right. In 8.1.7 (releases the we've tried, .0 and .2), it didn't work for partitioned tables. The monitor piece appears to work, so one of the other dba's here wrote a script using all_tab_modifications and dynamic sql to handle this. It get's tricky with global indexes and big partitioned tables because some days the whole thing finishes in a couple minutes while when a table is stale enough that it analyzes the whole index. But it's working better than before. Stephen >>> [EMAIL PROTECTED] 01/01/02 04:35PM >>>Paul,The bug actually says:"Rediscovery Information:You will see this bug when using dbms_stats.gather_xxx_stats and :1. An invalid granularity is supplied2. The GATHER STALE or GATHER EMPTY options are used3. The procedure call does not seem to work.Workaround:Correct the granularity parameter"So, provided you spell the granularity parameter correctly, this bug doesnot apply.We are using monitoring and gather_xxx_stats on NT under 81714 and it seemsto be working ok (ie num_rows is being updated correctly).Are you aware of any other bugs relating to monitoring / gather stats?(I know of bug 1407738 relating to table names > 28 characters).Regards,Bruce Reardonmailto:[EMAIL PROTECTED]-Original Message-Sent: Saturday, 29 December 2001 10:00The DBMS_STATS.GATHER_SCHEMA_STATS procedure (with the GATHER STALEoption), which uses the information produced when a table is inMONITORING mode, does not work properly in any current release ofOracle (see bug 1890016 on MetaLink).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: A DBA's career development
Andrey, Valid questions: And the answer? "It depends" :) It depends on some factors such as the size of your shop and their plans (in case you want to stay with them), the time (and $$) that you can invest on learning, your own background, likes and dislike, etc., as well as possible predictions of what the market needs a few years down the line. > I'm thinking of several possible paths : > Oracle DBA + UNIX sysadmin ; This is definitely a good one as the combination is an effective and has better employability during a downturn. A combination of these skills is required to keep the servers / dbs running and if you can assume both responsibilities, then your staying power and employability increases. > Ora DBA + developer ; This is a good one if you tend to lean towards development and have a bent for it. The problem is that there is such a huge variety of tools, so if you specialize in one, you will still need to look specifically fo that technology at your next gig. If this is an older technology or becomes obsolete, then you have lost your investment. You haven't lost your programming skills, just the tool related stuff, but that still counts... > DBA of Oracle + some other DB , that i'll need to learn This is Ok if you are in a 'junior' position, or the shop is small. 'Enterprise-wide' DBAs (with a team of 5 or more) would certainly specialize in one Database. You wouldn't want to use your expensive hunting knife for paring vegetables, would you? > Or may be it's time to move to some sort of system analysis , > datawarehousing ,ERP or ... ??? ERP is certainly a good area to be, and I notice that Oracle Applications is steadily increasing in its reach and depth of market penetration. I grew from a 'normal' DBA to an 'Apps DBA' - there are a few additional things, but one needs to grow from a 'normal' DBA position into this. Such a path will utilize known, hands-on skills. So would System Analysis (to some extent) and Data Warehousing - these skills do command wide employability. One thing that you could think of is aquiring expertise in the area of Security - not only IT but organizational/process/networking security - I believe there is a huge untapped market for this out there in the future. YMMV! and a happy new year to all. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Fear is the darkroom where Evil develops your negatives. Wanna break free of fear? Click on 'http://www.needhim.org' ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- 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: VLDB backup policy
It works really well for a DR site though!! Greg -Original Message- Sent: Wednesday, January 02, 2002 2:20 PM To: Multiple recipients of list ORACLE-L One problem with SRDF though is that it doesn't protect against block corruption. SRDF is really really cool, but is not a complete backup plan in and of itself. George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 12:48 PM > The problem is, most business users say "5 minutes" (and btw, the emc > srdf option is actually faster than a hot standby, since a hot standby > might need log files to be applied while the mirroring does not -- > check out Lawrence To's papers) > > so you go ahead and figure out what a "5 minutes" scenario costs and > then they say "no way, it's too expensive".. but they still want "5 > minutes" > > It doesn't hurt to give them all their options and let them do the > "time vs money" decision. > > > --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > > Andrey, > > > > I think that you are looking at this problem from the wrong end. > > Rather > > than come up with backup scenarious first and reporting back to > > management, > > I think you need to get managment to declare to you their "Mean Time > > to > > Recovery". By this I mean that they need to tell you how long they > > can > > survive without a database before it begins to affect their > > operations. > > > > Depending on their answer, it drives your research in certain > > directions. > > > > If they say "10 minutes", you have no choice but to have a > > hot-standby > > database running. > > > > If they say 1 hour, you could use EMC/mirror disk options (like > > Rachel just > > mentioned). > > > > If they say 24 hours, then RMan backup/restore from tape (probably > > the > > cheapest solution) would work for you. > > > > Kimberly's suggestions are very good if you are following the Rman > > scenario. > > > > Hope this helps > > > > Tom Mercadante > > Oracle Certified Professional > > > > > > -Original Message- > > Sent: Wednesday, January 02, 2002 10:35 AM > > To: Multiple recipients of list ORACLE-L > > > > > > You could split off a mirror and backup the mirror however, I have > > never > > done that so I am not going > > to get into it. I know there are others in the list who have done it > > for > > their backup strategy. > > > > Keep in mind that if you are running in archive log mode you need not > > backup > > every data file at the > > same time. This would be your cheap end solution. Make sure you > > have > > enough disk to deal with > > your archive logs (depends on how much you want to keep on disk). I > > would > > place objects in tablespaces > > based on usage rather then size or functionality. In other words, if > > you > > have a bunch of tables that > > have very little data changed or data that does get changed does so > > infrequently then place them in > > the same tablespace. If you have tables that have change constantly > > then > > keep them together. Granted > > you may end up with more then one tablespace per change type but > > don't mix. > > Then schedule backups > > of those tablespaces more frequently then others. Try and get the > > full > > backup done by the end of > > the week for all tablespaces. Keep in mind that the control file and > > other > > stuff need to be backed up > > as well. > > > > Your recovery is going to be a little more complicated this way and > > time to > > recover is going to be > > longer but if you get the frequently changed tablespaces more often > > then it > > should not be too bad. > > > > -Original Message- > > Sent: Wednesday, January 02, 2002 6:50 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Dear list ! > > I'm reposting this , since got no replies yet. > > > > I need to design a backup policy for a VLDB sized some 10TB, running > > as close to 24X7 as possible. > > I need 2 versions of the policy: > > One is the "best case" , i.e. money does not matter, the company can > > aquire > > any software / hardware , the only goal is to have a solid backup and > > ability to backup and recover as fast as possible. > > The second is the opposite case - how to achieve a good backup > > spending as > > little money as possible, possibly tolerating a little more downtime > > in case > > of a crash. > > > > I just have never happened to work with 10 Terrabytes size of DB, in > > particular ,i believe that my proven backup strategies that work well > > with > > 100GB DB might need some amending when it comes to 10 TB size. > > > > Another constraint is that i'm limited to Oracle 8.1.7 , and can not > > upgrade > > to 9i. > > > > I need to decide which hardware/software needs to be > > purchased/evaluated to > > implement solid DRP and HA. > > People say : EMC , Veritas , Legato etc... > > I'm just lost among these (and many others) buzzwords and need a > > "Second > > opinion" from g
Shared pool wait for library cache pin
We are seeing a lot of shared pool waits (for libary cache pin) on our 8.1.5 web-based application. We are seeing this via Precise/Indepth SQL monitoring tool. I haven't been able to find much documentation on shared pool waits or library cache pins. Can anyone tell me what might be causing this problem? Thanks, Cherie -- 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: VLDB backup policy
absolutely true -- but if they want "instant" recovery, then this will handle hardware failure --- George Schlossnagle <[EMAIL PROTECTED]> wrote: > One problem with SRDF though is that it doesn't protect against block > corruption. SRDF is really really cool, but is not a complete backup > plan > in and of itself. > > George > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, January 02, 2002 12:48 PM > > > > The problem is, most business users say "5 minutes" (and btw, the > emc > > srdf option is actually faster than a hot standby, since a hot > standby > > might need log files to be applied while the mirroring does not -- > > check out Lawrence To's papers) > > > > so you go ahead and figure out what a "5 minutes" scenario costs > and > > then they say "no way, it's too expensive".. but they still want "5 > > minutes" > > > > It doesn't hurt to give them all their options and let them do the > > "time vs money" decision. > > > > > > --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > > > Andrey, > > > > > > I think that you are looking at this problem from the wrong end. > > > Rather > > > than come up with backup scenarious first and reporting back to > > > management, > > > I think you need to get managment to declare to you their "Mean > Time > > > to > > > Recovery". By this I mean that they need to tell you how long > they > > > can > > > survive without a database before it begins to affect their > > > operations. > > > > > > Depending on their answer, it drives your research in certain > > > directions. > > > > > > If they say "10 minutes", you have no choice but to have a > > > hot-standby > > > database running. > > > > > > If they say 1 hour, you could use EMC/mirror disk options (like > > > Rachel just > > > mentioned). > > > > > > If they say 24 hours, then RMan backup/restore from tape > (probably > > > the > > > cheapest solution) would work for you. > > > > > > Kimberly's suggestions are very good if you are following the > Rman > > > scenario. > > > > > > Hope this helps > > > > > > Tom Mercadante > > > Oracle Certified Professional > > > > > > > > > -Original Message- > > > Sent: Wednesday, January 02, 2002 10:35 AM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > You could split off a mirror and backup the mirror however, I > have > > > never > > > done that so I am not going > > > to get into it. I know there are others in the list who have > done it > > > for > > > their backup strategy. > > > > > > Keep in mind that if you are running in archive log mode you need > not > > > backup > > > every data file at the > > > same time. This would be your cheap end solution. Make sure you > > > have > > > enough disk to deal with > > > your archive logs (depends on how much you want to keep on disk). > I > > > would > > > place objects in tablespaces > > > based on usage rather then size or functionality. In other > words, if > > > you > > > have a bunch of tables that > > > have very little data changed or data that does get changed does > so > > > infrequently then place them in > > > the same tablespace. If you have tables that have change > constantly > > > then > > > keep them together. Granted > > > you may end up with more then one tablespace per change type but > > > don't mix. > > > Then schedule backups > > > of those tablespaces more frequently then others. Try and get > the > > > full > > > backup done by the end of > > > the week for all tablespaces. Keep in mind that the control file > and > > > other > > > stuff need to be backed up > > > as well. > > > > > > Your recovery is going to be a little more complicated this way > and > > > time to > > > recover is going to be > > > longer but if you get the frequently changed tablespaces more > often > > > then it > > > should not be too bad. > > > > > > -Original Message- > > > Sent: Wednesday, January 02, 2002 6:50 AM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Dear list ! > > > I'm reposting this , since got no replies yet. > > > > > > I need to design a backup policy for a VLDB sized some 10TB, > running > > > as close to 24X7 as possible. > > > I need 2 versions of the policy: > > > One is the "best case" , i.e. money does not matter, the company > can > > > aquire > > > any software / hardware , the only goal is to have a solid backup > and > > > ability to backup and recover as fast as possible. > > > The second is the opposite case - how to achieve a good backup > > > spending as > > > little money as possible, possibly tolerating a little more > downtime > > > in case > > > of a crash. > > > > > > I just have never happened to work with 10 Terrabytes size of DB, > in > > > particular ,i believe that my proven backup strategies that work > well > > > with > > > 100GB DB might need some amending when it comes to 10 TB size. > > > > > > Another constraint is that i'm limited to Oracle 8.1
Re: stupid oracle on windoze question
HI All, It is in that useless documentation, from the Net8 Administrators Guide Ensure that the client machine has the tnsnames.ora and the sqlnet.ora files in $ORACLE_HOME/network/admin on UNIX and ORACLE_HOME\network\admin on Windows platforms. The search order for sqlnet.ora and tnsnames.ora follows: Current working directory from where an application is executed TNS_ADMIN environment variable If the TNS_ADMIN environment variable is not defined as a variable on Windows NT, it may be in the registry. If TNS_ADMIN is not defined, $ORACLE_HOME/network/admin on UNIX and ORACLE_HOME\network\admin on Windows platforms The one that I haven't seen documented is the "dot tnsnames.ora" on unix Hope this helps, -- John [EMAIL PROTECTED] wrote: ah but you can do something similar, at least according to Joe -- hefound it on a thread on MetaLink.You put a tnsnames.ora file in your local directory (I would supposewithout setting TNS_ADMIN) and then it will use the local oneinteresting, veddy interesting--- [EMAIL PROTECTED] wrote: Not only is it not in the flaming manuals, I don't think youcan even do that on Windoze.Sure, you can set the TNS_ADMIN var inControlPanel->System->EnvVars, but that is rather broadin scope and does not offer the granularity available on unix.Jared Rachel Carmichael To: Multiple recipientsof list ORACLE-L <[EMAIL PROTECTED]> AHOO.COM>Subject: RE: stupidoracle on windoze question Sent by: [EMAIL PROTECTED] om 01/02/02 07:50 AM Please respond to ORACLE-Lwell the thing is, he wasn't looking for TNS_ADMIN since that justre-sets the directory Oracle looks at but wanted something thatworkedmore like how login.sql works -- where if you have the file in yourlocal working directory, it is used and overrides any other file.In Unix, if you have a .tnsnames.ora file (please note the initial".")in your own personal $HOME directory) it will override the values inthe $ORACLE_HOME/network/admin/tnsnames.ora or the$TNS_ADMIN/tnsnames.ora fileTHAT is what Joe wanted for Windows. It ain't in the flamingmanuals. --- Kimberly Smith <[EMAIL PROTECTED]> wrote: Damn, why don't people use the manuals. TNS_ADMIN. Actually, youcan setthe puppy on Unix as well. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOETESTA Sent: Wednesday, January 02, 2002 6:15 AM To: Multiple recipients of list ORACLE-L Subject: stupid oracle on windoze question ok in the unix world, we have .tnsnames.ora file which overrides a $HOME/network/admin/tnsnames.ora file. Is there such a thing in the windoze world. a registry entrymaybe? thanks, joe __Do You Yahoo!?Send your FREE holiday greetings online!http://greetings.yahoo.com--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Rachel Carmichael INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / MailingListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a l ine containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HEL
local partitioning question
Esteem members of the list. I hope this new year finds you and your's healthy and prosperous. I have a question on partitioning and the changing of the values assigned to the partition during creation. The tablespace was created with AUTOEXTEND ON next 2 M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2 M. This was used for the table partitions that qualified for the (MAXVALUE) clause and an identical tablespace was created for the indexes with the LOCAL option. The partition range was by a date field and the MAXVALUE partitions was created to catch the data inputs that were greater that '12-31-2001'. I created an opportunity for learning by naming the partition xxx02 and now I would like to use the partition for the year 2002 data. I can add a partition to the table but I can not add a partition to the index because it is a local index. If I drop the table partition and then recreate it with the values I desire, The index storage is created with the table's tablespace name not the tablespace I wanted for the index. Other than dropping the index and recreating it with the proper values and storage information does anyone know of a simple method to accomplish what I desire. I have created a script that will make the tablespaces READ WRITE, create the indexes, make the tablespaces READ ONLY, and step through the tables needing the new 02 partitions. I have already dropped and recreated the tablespaces and added the new partitions the tables. This time I got smart and did not use the year indicator in the (MAXVALUE) partition. With the size of the tables and the amount of data, the script should be completed by 6:00 am tomorrow. (8 years of data for 6 different tables approx 200,000 rows per day) Any ideas or references? Thanks, Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: VLDB backup policy
One problem with SRDF though is that it doesn't protect against block corruption. SRDF is really really cool, but is not a complete backup plan in and of itself. George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 12:48 PM > The problem is, most business users say "5 minutes" (and btw, the emc > srdf option is actually faster than a hot standby, since a hot standby > might need log files to be applied while the mirroring does not -- > check out Lawrence To's papers) > > so you go ahead and figure out what a "5 minutes" scenario costs and > then they say "no way, it's too expensive".. but they still want "5 > minutes" > > It doesn't hurt to give them all their options and let them do the > "time vs money" decision. > > > --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > > Andrey, > > > > I think that you are looking at this problem from the wrong end. > > Rather > > than come up with backup scenarious first and reporting back to > > management, > > I think you need to get managment to declare to you their "Mean Time > > to > > Recovery". By this I mean that they need to tell you how long they > > can > > survive without a database before it begins to affect their > > operations. > > > > Depending on their answer, it drives your research in certain > > directions. > > > > If they say "10 minutes", you have no choice but to have a > > hot-standby > > database running. > > > > If they say 1 hour, you could use EMC/mirror disk options (like > > Rachel just > > mentioned). > > > > If they say 24 hours, then RMan backup/restore from tape (probably > > the > > cheapest solution) would work for you. > > > > Kimberly's suggestions are very good if you are following the Rman > > scenario. > > > > Hope this helps > > > > Tom Mercadante > > Oracle Certified Professional > > > > > > -Original Message- > > Sent: Wednesday, January 02, 2002 10:35 AM > > To: Multiple recipients of list ORACLE-L > > > > > > You could split off a mirror and backup the mirror however, I have > > never > > done that so I am not going > > to get into it. I know there are others in the list who have done it > > for > > their backup strategy. > > > > Keep in mind that if you are running in archive log mode you need not > > backup > > every data file at the > > same time. This would be your cheap end solution. Make sure you > > have > > enough disk to deal with > > your archive logs (depends on how much you want to keep on disk). I > > would > > place objects in tablespaces > > based on usage rather then size or functionality. In other words, if > > you > > have a bunch of tables that > > have very little data changed or data that does get changed does so > > infrequently then place them in > > the same tablespace. If you have tables that have change constantly > > then > > keep them together. Granted > > you may end up with more then one tablespace per change type but > > don't mix. > > Then schedule backups > > of those tablespaces more frequently then others. Try and get the > > full > > backup done by the end of > > the week for all tablespaces. Keep in mind that the control file and > > other > > stuff need to be backed up > > as well. > > > > Your recovery is going to be a little more complicated this way and > > time to > > recover is going to be > > longer but if you get the frequently changed tablespaces more often > > then it > > should not be too bad. > > > > -Original Message- > > Sent: Wednesday, January 02, 2002 6:50 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Dear list ! > > I'm reposting this , since got no replies yet. > > > > I need to design a backup policy for a VLDB sized some 10TB, running > > as close to 24X7 as possible. > > I need 2 versions of the policy: > > One is the "best case" , i.e. money does not matter, the company can > > aquire > > any software / hardware , the only goal is to have a solid backup and > > ability to backup and recover as fast as possible. > > The second is the opposite case - how to achieve a good backup > > spending as > > little money as possible, possibly tolerating a little more downtime > > in case > > of a crash. > > > > I just have never happened to work with 10 Terrabytes size of DB, in > > particular ,i believe that my proven backup strategies that work well > > with > > 100GB DB might need some amending when it comes to 10 TB size. > > > > Another constraint is that i'm limited to Oracle 8.1.7 , and can not > > upgrade > > to 9i. > > > > I need to decide which hardware/software needs to be > > purchased/evaluated to > > implement solid DRP and HA. > > People say : EMC , Veritas , Legato etc... > > I'm just lost among these (and many others) buzzwords and need a > > "Second > > opinion" from gurus, like you. > > Please share your experience and thoughts. > > Thanks a lot in advance ! > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
RE: VLDB backup policy
Title: RE: VLDB backup policy What type of application is it (OLTP, DSS, mixed, etc.)? Also, is it monolithic or can the functionality be broken down into usage profiles (i.e. mostly read, high velocity update, etc.)? -Original Message- From: Andrey Bronfin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 9:50 AM To: Multiple recipients of list ORACLE-L Subject: VLDB backup policy Dear list ! I'm reposting this , since got no replies yet. I need to design a backup policy for a VLDB sized some 10TB, running as close to 24X7 as possible. I need 2 versions of the policy: One is the "best case" , i.e. money does not matter, the company can aquire any software / hardware , the only goal is to have a solid backup and ability to backup and recover as fast as possible. The second is the opposite case - how to achieve a good backup spending as little money as possible, possibly tolerating a little more downtime in case of a crash. I just have never happened to work with 10 Terrabytes size of DB, in particular ,i believe that my proven backup strategies that work well with 100GB DB might need some amending when it comes to 10 TB size. Another constraint is that i'm limited to Oracle 8.1.7 , and can not upgrade to 9i. I need to decide which hardware/software needs to be purchased/evaluated to implement solid DRP and HA. People say : EMC , Veritas , Legato etc... I'm just lost among these (and many others) buzzwords and need a "Second opinion" from gurus, like you. Please share your experience and thoughts. Thanks a lot in advance ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: VLDB backup policy
The problem is, most business users say "5 minutes" (and btw, the emc srdf option is actually faster than a hot standby, since a hot standby might need log files to be applied while the mirroring does not -- check out Lawrence To's papers) so you go ahead and figure out what a "5 minutes" scenario costs and then they say "no way, it's too expensive".. but they still want "5 minutes" It doesn't hurt to give them all their options and let them do the "time vs money" decision. --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > Andrey, > > I think that you are looking at this problem from the wrong end. > Rather > than come up with backup scenarious first and reporting back to > management, > I think you need to get managment to declare to you their "Mean Time > to > Recovery". By this I mean that they need to tell you how long they > can > survive without a database before it begins to affect their > operations. > > Depending on their answer, it drives your research in certain > directions. > > If they say "10 minutes", you have no choice but to have a > hot-standby > database running. > > If they say 1 hour, you could use EMC/mirror disk options (like > Rachel just > mentioned). > > If they say 24 hours, then RMan backup/restore from tape (probably > the > cheapest solution) would work for you. > > Kimberly's suggestions are very good if you are following the Rman > scenario. > > Hope this helps > > Tom Mercadante > Oracle Certified Professional > > > -Original Message- > Sent: Wednesday, January 02, 2002 10:35 AM > To: Multiple recipients of list ORACLE-L > > > You could split off a mirror and backup the mirror however, I have > never > done that so I am not going > to get into it. I know there are others in the list who have done it > for > their backup strategy. > > Keep in mind that if you are running in archive log mode you need not > backup > every data file at the > same time. This would be your cheap end solution. Make sure you > have > enough disk to deal with > your archive logs (depends on how much you want to keep on disk). I > would > place objects in tablespaces > based on usage rather then size or functionality. In other words, if > you > have a bunch of tables that > have very little data changed or data that does get changed does so > infrequently then place them in > the same tablespace. If you have tables that have change constantly > then > keep them together. Granted > you may end up with more then one tablespace per change type but > don't mix. > Then schedule backups > of those tablespaces more frequently then others. Try and get the > full > backup done by the end of > the week for all tablespaces. Keep in mind that the control file and > other > stuff need to be backed up > as well. > > Your recovery is going to be a little more complicated this way and > time to > recover is going to be > longer but if you get the frequently changed tablespaces more often > then it > should not be too bad. > > -Original Message- > Sent: Wednesday, January 02, 2002 6:50 AM > To: Multiple recipients of list ORACLE-L > > > Dear list ! > I'm reposting this , since got no replies yet. > > I need to design a backup policy for a VLDB sized some 10TB, running > as close to 24X7 as possible. > I need 2 versions of the policy: > One is the "best case" , i.e. money does not matter, the company can > aquire > any software / hardware , the only goal is to have a solid backup and > ability to backup and recover as fast as possible. > The second is the opposite case - how to achieve a good backup > spending as > little money as possible, possibly tolerating a little more downtime > in case > of a crash. > > I just have never happened to work with 10 Terrabytes size of DB, in > particular ,i believe that my proven backup strategies that work well > with > 100GB DB might need some amending when it comes to 10 TB size. > > Another constraint is that i'm limited to Oracle 8.1.7 , and can not > upgrade > to 9i. > > I need to decide which hardware/software needs to be > purchased/evaluated to > implement solid DRP and HA. > People say : EMC , Veritas , Legato etc... > I'm just lost among these (and many others) buzzwords and need a > "Second > opinion" from gurus, like you. > Please share your experience and thoughts. > Thanks a lot in advance ! > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Andrey Bronfin > 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
RE: stupid oracle on windoze question
ah but you can do something similar, at least according to Joe -- he found it on a thread on MetaLink. You put a tnsnames.ora file in your local directory (I would suppose without setting TNS_ADMIN) and then it will use the local one interesting, veddy interesting --- [EMAIL PROTECTED] wrote: > > Not only is it not in the flaming manuals, I don't think you > can even do that on Windoze. > > Sure, you can set the TNS_ADMIN var in > ControlPanel->System->EnvVars, but that is rather broad > in scope and does not offer the granularity available on unix. > > Jared > > > > > > Rachel > > Carmichael To: Multiple recipients > of list ORACLE-L <[EMAIL PROTECTED]> > > AHOO.COM>Subject: RE: stupid > oracle on windoze question > Sent by: > > [EMAIL PROTECTED] > > om > > > > > > 01/02/02 07:50 > > AM > > Please respond > > to ORACLE-L > > > > > > > > > > well the thing is, he wasn't looking for TNS_ADMIN since that just > re-sets the directory Oracle looks at but wanted something that > worked > more like how login.sql works -- where if you have the file in your > local working directory, it is used and overrides any other file. > > In Unix, if you have a .tnsnames.ora file (please note the initial > ".") > in your own personal $HOME directory) it will override the values in > the $ORACLE_HOME/network/admin/tnsnames.ora or the > $TNS_ADMIN/tnsnames.ora file > > THAT is what Joe wanted for Windows. It ain't in the flaming > manuals. > > > --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > > Damn, why don't people use the manuals. TNS_ADMIN. Actually, you > > can set > > the puppy on Unix as well. > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE > > TESTA > > Sent: Wednesday, January 02, 2002 6:15 AM > > To: Multiple recipients of list ORACLE-L > > Subject: stupid oracle on windoze question > > > > > > ok in the unix world, we have .tnsnames.ora file which overrides > a > > $HOME/network/admin/tnsnames.ora file. > > > > Is there such a thing in the windoze world. a registry entry > > maybe? > > > > thanks, joe > > > > > > > __ > Do You Yahoo!? > Send your FREE holiday greetings online! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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 contai
RE: stupid oracle on windoze question
nope, it doesn't. in unix, Oracle will check the same path with this exception: it first looks for a ".tnsnames.ora" file in the $HOME directory of the logged in user. If the file is there, it is used, if not, Oracle continues to check TNS_ADMIN and then network/admin --- eric harrington <[EMAIL PROTECTED]> wrote: > In my research the TNS_ADMIN does not actually "re-set" the directory > where > Oracle looks. > > The presence of a TNS_ADMIN env var is checked first, if found then > this > path is used to locate the tnsnames.ora and sqlnet.ora. If it is not > found, > Oracle looks at the ORACLE_HOME env var, if found then it looks at > the > registry for this HOME to see if the TNS_ADMIN exist there, if it > does it > uses that location. > > The point being that the TNS_ADMIN is checked first. It appears that > setting > this variable would satisfy Joe's request. > > Eric Harrington > > -Original Message- > Carmichael > Sent: Wednesday, January 02, 2002 10:51 AM > To: Multiple recipients of list ORACLE-L > > > well the thing is, he wasn't looking for TNS_ADMIN since that just > re-sets the directory Oracle looks at but wanted something that > worked > more like how login.sql works -- where if you have the file in your > local working directory, it is used and overrides any other file. > > In Unix, if you have a .tnsnames.ora file (please note the initial > ".") > in your own personal $HOME directory) it will override the values in > the $ORACLE_HOME/network/admin/tnsnames.ora or the > $TNS_ADMIN/tnsnames.ora file > > THAT is what Joe wanted for Windows. It ain't in the flaming > manuals. > > > --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > > Damn, why don't people use the manuals. TNS_ADMIN. Actually, you > > can set > > the puppy on Unix as well. > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE > > TESTA > > Sent: Wednesday, January 02, 2002 6:15 AM > > To: Multiple recipients of list ORACLE-L > > Subject: stupid oracle on windoze question > > > > > > ok in the unix world, we have .tnsnames.ora file which overrides > a > > $HOME/network/admin/tnsnames.ora file. > > > > Is there such a thing in the windoze world. a registry entry > > maybe? > > > > thanks, joe > > > > > > > __ > Do You Yahoo!? > Send your FREE holiday greetings online! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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: eric harrington > 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!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
iFS
Title: RE: A DBA's career development Out of curiosity, is anyone using iFS in a production environment? Regards, Patrice Boivin Systems Analyst (Oracle DBA) Acting Head, System Admin & Operations Bedford Institute of Oceanography Fisheries and Oceans Canada subscribing).
Re: stupid oracle on windoze question
Hi Jared, Sorry, I misunderstood the question. Environment variables can, however be set locally instead of at the system level tns_admin= inside of a .bat or a .cmd script, maybe even perl :-) John [EMAIL PROTECTED] wrote: Not only is it not in the flaming manuals, I don't think youcan even do that on Windoze.Sure, you can set the TNS_ADMIN var inControlPanel->System->EnvVars, but that is rather broadin scope and does not offer the granularity available on unix.Jared RachelCarmichael To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> AHOO.COM>Subject: RE: stupid oracle on windoze question Se nt by: [EMAIL PROTECTED]om01/02/02 07:50AMPlease respondto ORACLE-L well the thing is, he wasn't looking for TNS_ADMIN since that justre-sets the directory Oracle looks at but wanted something that workedmore like how login.sql works -- where if you have the file in yourlocal working directory, it is used and overrides any other file.In Unix, if you have a .tnsnames.ora file (please note the initial ".")in your own personal $HOME directory) it will override the values inthe $ORACLE_HOME/network/admin/tnsnames.ora or the$TNS_ADMIN/tnsnames.ora fileTHAT is what Joe wanted for Windows. It ain't in the flaming manuals.--- Kimberly Smith <[EMAIL PROTECTED]> wrote: Damn, why don't people use the manuals. TNS_ADMIN. Actually, youcan setthe puppy on Unix as well. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOETESTA Sent: Wednesday, January 02, 2002 6:15 AM To: Multiple recipients of list ORACLE-L Subject: stupid oracle on windoze question ok in the unix world, we have .tnsnames.ora file which overrides a$HOME/network/admin/tnsnames.ora file. Is there such a thing in the windoze world. a registry entrymaybe? thanks, joe __Do You Yahoo!?Send your FREE holiday greetings online!http://greetings.yahoo.com--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Rachel Carmichael INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: VLDB backup policy
Thanks a lot to all who replied ! Tom , thanks , i forgot to mention , the DB is expected to get recovered in something like 1-3 hours. Another correction , the DB size will be around 1TB for the beginning and is expected to grow to 10TB within a couple of years. HAPPY NEW YEAR ALL ! DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 02, 2002 6:37 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Andrey, I think that you are looking at this problem from the wrong end. Rather than come up with backup scenarious first and reporting back to management, I think you need to get managment to declare to you their "Mean Time to Recovery". By this I mean that they need to tell you how long they can survive without a database before it begins to affect their operations. Depending on their answer, it drives your research in certain directions. If they say "10 minutes", you have no choice but to have a hot-standby database running. If they say 1 hour, you could use EMC/mirror disk options (like Rachel just mentioned). If they say 24 hours, then RMan backup/restore from tape (probably the cheapest solution) would work for you. Kimberly's suggestions are very good if you are following the Rman scenario. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 02, 2002 10:35 AM To: Multiple recipients of list ORACLE-L You could split off a mirror and backup the mirror however, I have never done that so I am not going to get into it. I know there are others in the list who have done it for their backup strategy. Keep in mind that if you are running in archive log mode you need not backup every data file at the same time. This would be your cheap end solution. Make sure you have enough disk to deal with your archive logs (depends on how much you want to keep on disk). I would place objects in tablespaces based on usage rather then size or functionality. In other words, if you have a bunch of tables that have very little data changed or data that does get changed does so infrequently then place them in the same tablespace. If you have tables that have change constantly then keep them together. Granted you may end up with more then one tablespace per change type but don't mix. Then schedule backups of those tablespaces more frequently then others. Try and get the full backup done by the end of the week for all tablespaces. Keep in mind that the control file and other stuff need to be backed up as well. Your recovery is going to be a little more complicated this way and time to recover is going to be longer but if you get the frequently changed tablespaces more often then it should not be too bad. -Original Message- Sent: Wednesday, January 02, 2002 6:50 AM To: Multiple recipients of list ORACLE-L Dear list ! I'm reposting this , since got no replies yet. I need to design a backup policy for a VLDB sized some 10TB, running as close to 24X7 as possible. I need 2 versions of the policy: One is the "best case" , i.e. money does not matter, the company can aquire any software / hardware , the only goal is to have a solid backup and ability to backup and recover as fast as possible. The second is the opposite case - how to achieve a good backup spending as little money as possible, possibly tolerating a little more downtime in case of a crash. I just have never happened to work with 10 Terrabytes size of DB, in particular ,i believe that my proven backup strategies that work well with 100GB DB might need some amending when it comes to 10 TB size. Another constraint is that i'm limited to Oracle 8.1.7 , and can not upgrade to 9i. I need to decide which hardware/software needs to be purchased/evaluated to implement solid DRP and HA. People say : EMC , Veritas , Legato etc... I'm just lost among these (and many others) buzzwords and need a "Second opinion" from gurus, like you. Please share your experience and thoughts. Thanks a lot in advance ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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
Re: Determining Striping
vxprint -ht will print it out in nicer format than just vxprint, explicitly listing the stripe width/colums for each plex. i.e.: v index01 fsgenENABLED ACTIVE 97179648 SELECTindex01-01 pl index01-01 index01 ENABLED ACTIVE 97180800 STRIPE5/64 RW sd index-a-01 index01-01 index-a 019436160 0/0 c3t2d10 ENA sd index-b-01 index01-01 index-b 019436160 1/0 c3t2d11 ENA sd index-c-01 index01-01 index-c 019436160 2/0 c3t2d12 ENA sd index-d-01 index01-01 index-d 019436160 3/0 c3t2d13 ENA sd index-e-01 index01-01 index-e 019436160 4/0 c3t2d14 ENA 5 columns of 64k stripe size in a single (unmirrored) plex. (HW mirrrored, for those who care). George --- http://www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 12:15 PM > Typically vxprint if you're using Veritas, or metastat > (or cat /etc/opt/SUNWmd/md.cf) for Disksuite. > > hth > connor > > --- Robertson Lee - lerobe <[EMAIL PROTECTED]> > wrote: > If memory serves on Solaris it is called > Solaris > > Online Disksuite or > > something like that > > > > -Original Message- > > Sent: 02 January 2002 15:30 > > To: Multiple recipients of list ORACLE-L > > > > > > Not sure if you can show striping with a command. > > Using the DF command > > usually shows all disks in the disk farm. > > Alternatively, there is an admin > > tool for disk maintenance, but I don't remember the > > name. > > > > Thank You > > > > Stephen P. Karniotis > > Technical Alliance Manager > > Compuware Corporation > > Direct: (248) 865-4350 > > Mobile: (248) 408-2918 > > Email: [EMAIL PROTECTED] > > Web: www.compuware.com > > > > > > -Original Message- > > Sent: Wednesday, January 02, 2002 10:15 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Determining Striping > > > > Is there a UNIX command to determine what, if any, > > striping was used when > > setting up a server and it's disk? > > > > Sun Solaris 6, 7 and 8 are what I'm specifically > > interested in. > > > > TIA, > > > > Terry > > > > Terry Ball, DBA > > Birch Telecom > > Work: 816-300-1335 > > FAX: 816-300-1801 > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Ball, Terry > > 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: Karniotis, Stephen > > 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). > > > > > > The information contained in this communication is > > confidential, is intended only for the use of the > > recipient > > named above, and may be legally privileged. If the > > reader > > of this message is not the intended recipient, you > > are > > hereby notified that any dissemination, distribution > > or > > copying of this communication is strictly > > prohibited. > > If you have received this communication in error, > > please > > re-send this communication to the sender and delete > > the > > original message or any copy of it from your > > computer > > system. > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Robertson Lee - lerobe > > 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 m
RE: A DBA's career development
Title: RE: A DBA's career development Try learning other databases. That way when you go into a new project, you can decide which may be a better one to use for the job. i.e. Having oracle for a small in-house database to track your timecards would be serious overkill and costly. Even a free database like MySQL or PostgreSQL would do here. Perhpas for job portability learning SQL Server or DB2 would be good. Jon Baker Database Architect <[EMAIL PROTECTED]> www.netsec.net -Original Message- From: Andrey Bronfin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 10:15 AM To: Multiple recipients of list ORACLE-L Subject: A DBA's career development Dear list ! Having been an Oracle DBA on UNIX & win platforms for past several years, i feel like i'd like to change something. Don't get me wrong , i like what i'm doing , but i think it's time to expand my horizons. I wouldn't like to completely quit the filed of Oracle/DBAing , but i'd like to add something to it. I also know some system UNIX (mainly Solaris) and some development (java , perl , pl/sql etc.) Where would i go next ? I'm thinking of several possible paths : Oracle DBA + UNIX sysadmin ; Ora DBA + developer ; DBA of Oracle + some other DB , that i'll need to learn Or may be it's time to move to some sort of system analysis , datawarehousing ,ERP or ... ??? I'm thinking about the future of the market , demand for employees in various fields , salaries etc.. What would U , dear gurus , say ? What do U think about your careers / future ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: Determining Striping
Typically vxprint if you're using Veritas, or metastat (or cat /etc/opt/SUNWmd/md.cf) for Disksuite. hth connor --- Robertson Lee - lerobe <[EMAIL PROTECTED]> wrote: > If memory serves on Solaris it is called Solaris > Online Disksuite or > something like that > > -Original Message- > Sent: 02 January 2002 15:30 > To: Multiple recipients of list ORACLE-L > > > Not sure if you can show striping with a command. > Using the DF command > usually shows all disks in the disk farm. > Alternatively, there is an admin > tool for disk maintenance, but I don't remember the > name. > > Thank You > > Stephen P. Karniotis > Technical Alliance Manager > Compuware Corporation > Direct: (248) 865-4350 > Mobile: (248) 408-2918 > Email:[EMAIL PROTECTED] > Web: www.compuware.com > > > -Original Message- > Sent: Wednesday, January 02, 2002 10:15 AM > To: Multiple recipients of list ORACLE-L > Subject: Determining Striping > > Is there a UNIX command to determine what, if any, > striping was used when > setting up a server and it's disk? > > Sun Solaris 6, 7 and 8 are what I'm specifically > interested in. > > TIA, > > Terry > > Terry Ball, DBA > Birch Telecom > Work: 816-300-1335 > FAX: 816-300-1801 > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Ball, Terry > 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: Karniotis, Stephen > 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). > > > The information contained in this communication is > confidential, is intended only for the use of the > recipient > named above, and may be legally privileged. If the > reader > of this message is not the intended recipient, you > are > hereby notified that any dissemination, distribution > or > copying of this communication is strictly > prohibited. > If you have received this communication in error, > please > re-send this communication to the sender and delete > the > original message or any copy of it from your > computer > system. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Robertson Lee - lerobe > 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).
(Fwd) Forms (v5) Developer Supported on Windows2000Pro?
--- Forwarded message follows --- Will Forms 5 work on Windows2000Pro? Is it (or was it) officially "supported" by Oracle? thanks, ep --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: Ora-1555
Note, I have been able to find many Oracle white papers using google.com... -Original Message- Sent: Monday, December 17, 2001 7:21 AM To: Multiple recipients of list ORACLE-L Thanks a bunch, Gopalakrishnan 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- Sent: 17 December 2001 11:45 To: Multiple recipients of list ORACLE-L www.evdbt.com Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- Sent: Monday, December 17, 2001 2:40 AM To: Multiple recipients of list ORACLE-L Hi list, Could anybody tell me on which site shall I find Tim Gorman's paper "Cats, Dogs and ORA-1555" ?? Thanks, Samir 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 ___ 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 that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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) 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: SARKAR, Samir 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: Grabowy, Chris 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: VLDB backup policy
I would also suggest (in a world somewhere between ideal and 'cheapest') using Veritas NetBackup with the Block-Level Incremental extension for Oracle. This is really nice for saving on tape costs and backup time - it performs incremental backups of your datafiles on a block level (thus the name), meaning that in a large but moderately static datatabase only your full backups will be huge. I would also recommend (closer to the ideal world), a (as many as you can afford)-head LTO based jukebox system so that you can stream your data to multiple drives simultaneously. In a perfectly ideal world, I would also agree with Rachel's advice to use SRDF for box-to-box storage mirroring, but even with that nothing replaces having long-term storage on tape (for example, SRDF does _not_ prtoect you against block-corruption if you do it close to real-time, is infinitely (100+ times) more expensive than tape, gig for gig, and doesn't allow for multiple versions (unless you have a bunch of extra arrays lying around, see caveat 2 regarding $'s) George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 11:20 AM > thanks a lot Kimberly ! > > DBAndrey > > * 03-9254520 > * 053-464562 > * mailto:[EMAIL PROTECTED] > > > > -Original Message- > Sent: Wednesday, January 02, 2002 5:35 PM > To: Multiple recipients of list ORACLE-L > > > You could split off a mirror and backup the mirror however, I have never > done that so I am not going > to get into it. I know there are others in the list who have done it for > their backup strategy. > > Keep in mind that if you are running in archive log mode you need not backup > every data file at the > same time. This would be your cheap end solution. Make sure you have > enough disk to deal with > your archive logs (depends on how much you want to keep on disk). I would > place objects in tablespaces > based on usage rather then size or functionality. In other words, if you > have a bunch of tables that > have very little data changed or data that does get changed does so > infrequently then place them in > the same tablespace. If you have tables that have change constantly then > keep them together. Granted > you may end up with more then one tablespace per change type but don't mix. > Then schedule backups > of those tablespaces more frequently then others. Try and get the full > backup done by the end of > the week for all tablespaces. Keep in mind that the control file and other > stuff need to be backed up > as well. > > Your recovery is going to be a little more complicated this way and time to > recover is going to be > longer but if you get the frequently changed tablespaces more often then it > should not be too bad. > > -Original Message- > Sent: Wednesday, January 02, 2002 6:50 AM > To: Multiple recipients of list ORACLE-L > > > Dear list ! > I'm reposting this , since got no replies yet. > > I need to design a backup policy for a VLDB sized some 10TB, running > as close to 24X7 as possible. > I need 2 versions of the policy: > One is the "best case" , i.e. money does not matter, the company can aquire > any software / hardware , the only goal is to have a solid backup and > ability to backup and recover as fast as possible. > The second is the opposite case - how to achieve a good backup spending as > little money as possible, possibly tolerating a little more downtime in case > of a crash. > > I just have never happened to work with 10 Terrabytes size of DB, in > particular ,i believe that my proven backup strategies that work well with > 100GB DB might need some amending when it comes to 10 TB size. > > Another constraint is that i'm limited to Oracle 8.1.7 , and can not upgrade > to 9i. > > I need to decide which hardware/software needs to be purchased/evaluated to > implement solid DRP and HA. > People say : EMC , Veritas , Legato etc... > I'm just lost among these (and many others) buzzwords and need a "Second > opinion" from gurus, like you. > Please share your experience and thoughts. > Thanks a lot in advance ! > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Andrey Bronfin > 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)
RE: Becoming a DBA questions
You're right - it keeps me gainfully employed! :) -Original Message- Sent: Wednesday, January 02, 2002 10:15 AM To: Multiple recipients of list ORACLE-L Judy, Of course they are. After all, that's what they sell. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 > -Original Message- > From: Peddycoart, Judy [SMTP:[EMAIL PROTECTED]] > I don't yet have my OCP, but my boss is encouraging me to go for it. > The > higher ed types seem to be impressed by pieces of paper! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whittle Jerome Contr NCI 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: Peddycoart, Judy 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: VLDB backup policy
Andrey, I think that you are looking at this problem from the wrong end. Rather than come up with backup scenarious first and reporting back to management, I think you need to get managment to declare to you their "Mean Time to Recovery". By this I mean that they need to tell you how long they can survive without a database before it begins to affect their operations. Depending on their answer, it drives your research in certain directions. If they say "10 minutes", you have no choice but to have a hot-standby database running. If they say 1 hour, you could use EMC/mirror disk options (like Rachel just mentioned). If they say 24 hours, then RMan backup/restore from tape (probably the cheapest solution) would work for you. Kimberly's suggestions are very good if you are following the Rman scenario. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 02, 2002 10:35 AM To: Multiple recipients of list ORACLE-L You could split off a mirror and backup the mirror however, I have never done that so I am not going to get into it. I know there are others in the list who have done it for their backup strategy. Keep in mind that if you are running in archive log mode you need not backup every data file at the same time. This would be your cheap end solution. Make sure you have enough disk to deal with your archive logs (depends on how much you want to keep on disk). I would place objects in tablespaces based on usage rather then size or functionality. In other words, if you have a bunch of tables that have very little data changed or data that does get changed does so infrequently then place them in the same tablespace. If you have tables that have change constantly then keep them together. Granted you may end up with more then one tablespace per change type but don't mix. Then schedule backups of those tablespaces more frequently then others. Try and get the full backup done by the end of the week for all tablespaces. Keep in mind that the control file and other stuff need to be backed up as well. Your recovery is going to be a little more complicated this way and time to recover is going to be longer but if you get the frequently changed tablespaces more often then it should not be too bad. -Original Message- Sent: Wednesday, January 02, 2002 6:50 AM To: Multiple recipients of list ORACLE-L Dear list ! I'm reposting this , since got no replies yet. I need to design a backup policy for a VLDB sized some 10TB, running as close to 24X7 as possible. I need 2 versions of the policy: One is the "best case" , i.e. money does not matter, the company can aquire any software / hardware , the only goal is to have a solid backup and ability to backup and recover as fast as possible. The second is the opposite case - how to achieve a good backup spending as little money as possible, possibly tolerating a little more downtime in case of a crash. I just have never happened to work with 10 Terrabytes size of DB, in particular ,i believe that my proven backup strategies that work well with 100GB DB might need some amending when it comes to 10 TB size. Another constraint is that i'm limited to Oracle 8.1.7 , and can not upgrade to 9i. I need to decide which hardware/software needs to be purchased/evaluated to implement solid DRP and HA. People say : EMC , Veritas , Legato etc... I'm just lost among these (and many others) buzzwords and need a "Second opinion" from gurus, like you. Please share your experience and thoughts. Thanks a lot in advance ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: Mercadante, Thomas F INET
Re: stupid oracle on windoze question
[EMAIL PROTECTED] wrote: >well the thing is, he wasn't looking for TNS_ADMIN since that just >re-sets the directory Oracle looks at but wanted something that worked >more like how login.sql works -- where if you have the file in your >local working directory, it is used and overrides any other file. > >In Unix, if you have a .tnsnames.ora file (please note the initial ".") >in your own personal $HOME directory) it will override the values in >the $ORACLE_HOME/network/admin/tnsnames.ora or the >$TNS_ADMIN/tnsnames.ora file > >THAT is what Joe wanted for Windows. It ain't in the flaming manuals. > and this is a surprise how?;-) you didn't think they'd put anything actually practical in there did you?;-) -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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: stupid oracle on windoze question
In my research the TNS_ADMIN does not actually "re-set" the directory where Oracle looks. The presence of a TNS_ADMIN env var is checked first, if found then this path is used to locate the tnsnames.ora and sqlnet.ora. If it is not found, Oracle looks at the ORACLE_HOME env var, if found then it looks at the registry for this HOME to see if the TNS_ADMIN exist there, if it does it uses that location. The point being that the TNS_ADMIN is checked first. It appears that setting this variable would satisfy Joe's request. Eric Harrington -Original Message- Carmichael Sent: Wednesday, January 02, 2002 10:51 AM To: Multiple recipients of list ORACLE-L well the thing is, he wasn't looking for TNS_ADMIN since that just re-sets the directory Oracle looks at but wanted something that worked more like how login.sql works -- where if you have the file in your local working directory, it is used and overrides any other file. In Unix, if you have a .tnsnames.ora file (please note the initial ".") in your own personal $HOME directory) it will override the values in the $ORACLE_HOME/network/admin/tnsnames.ora or the $TNS_ADMIN/tnsnames.ora file THAT is what Joe wanted for Windows. It ain't in the flaming manuals. --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > Damn, why don't people use the manuals. TNS_ADMIN. Actually, you > can set > the puppy on Unix as well. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE > TESTA > Sent: Wednesday, January 02, 2002 6:15 AM > To: Multiple recipients of list ORACLE-L > Subject: stupid oracle on windoze question > > > ok in the unix world, we have .tnsnames.ora file which overrides a > $HOME/network/admin/tnsnames.ora file. > > Is there such a thing in the windoze world. a registry entry > maybe? > > thanks, joe > > __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: eric harrington 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: stupid oracle on windoze question
Not only is it not in the flaming manuals, I don't think you can even do that on Windoze. Sure, you can set the TNS_ADMIN var in ControlPanel->System->EnvVars, but that is rather broad in scope and does not offer the granularity available on unix. Jared Rachel Carmichael To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: stupid oracle on windoze question Sent by: [EMAIL PROTECTED] om 01/02/02 07:50 AM Please respond to ORACLE-L well the thing is, he wasn't looking for TNS_ADMIN since that just re-sets the directory Oracle looks at but wanted something that worked more like how login.sql works -- where if you have the file in your local working directory, it is used and overrides any other file. In Unix, if you have a .tnsnames.ora file (please note the initial ".") in your own personal $HOME directory) it will override the values in the $ORACLE_HOME/network/admin/tnsnames.ora or the $TNS_ADMIN/tnsnames.ora file THAT is what Joe wanted for Windows. It ain't in the flaming manuals. --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > Damn, why don't people use the manuals. TNS_ADMIN. Actually, you > can set > the puppy on Unix as well. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE > TESTA > Sent: Wednesday, January 02, 2002 6:15 AM > To: Multiple recipients of list ORACLE-L > Subject: stupid oracle on windoze question > > > ok in the unix world, we have .tnsnames.ora file which overrides a > $HOME/network/admin/tnsnames.ora file. > > Is there such a thing in the windoze world. a registry entry > maybe? > > thanks, joe > > __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: VLDB backup policy
thanks a lot Kimberly ! DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 02, 2002 5:35 PM To: Multiple recipients of list ORACLE-L You could split off a mirror and backup the mirror however, I have never done that so I am not going to get into it. I know there are others in the list who have done it for their backup strategy. Keep in mind that if you are running in archive log mode you need not backup every data file at the same time. This would be your cheap end solution. Make sure you have enough disk to deal with your archive logs (depends on how much you want to keep on disk). I would place objects in tablespaces based on usage rather then size or functionality. In other words, if you have a bunch of tables that have very little data changed or data that does get changed does so infrequently then place them in the same tablespace. If you have tables that have change constantly then keep them together. Granted you may end up with more then one tablespace per change type but don't mix. Then schedule backups of those tablespaces more frequently then others. Try and get the full backup done by the end of the week for all tablespaces. Keep in mind that the control file and other stuff need to be backed up as well. Your recovery is going to be a little more complicated this way and time to recover is going to be longer but if you get the frequently changed tablespaces more often then it should not be too bad. -Original Message- Sent: Wednesday, January 02, 2002 6:50 AM To: Multiple recipients of list ORACLE-L Dear list ! I'm reposting this , since got no replies yet. I need to design a backup policy for a VLDB sized some 10TB, running as close to 24X7 as possible. I need 2 versions of the policy: One is the "best case" , i.e. money does not matter, the company can aquire any software / hardware , the only goal is to have a solid backup and ability to backup and recover as fast as possible. The second is the opposite case - how to achieve a good backup spending as little money as possible, possibly tolerating a little more downtime in case of a crash. I just have never happened to work with 10 Terrabytes size of DB, in particular ,i believe that my proven backup strategies that work well with 100GB DB might need some amending when it comes to 10 TB size. Another constraint is that i'm limited to Oracle 8.1.7 , and can not upgrade to 9i. I need to decide which hardware/software needs to be purchased/evaluated to implement solid DRP and HA. People say : EMC , Veritas , Legato etc... I'm just lost among these (and many others) buzzwords and need a "Second opinion" from gurus, like you. Please share your experience and thoughts. Thanks a lot in advance ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: Andrey Bronfin 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: Becoming a DBA questions
Judy, Of course they are. After all, that's what they sell. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 > -Original Message- > From: Peddycoart, Judy [SMTP:[EMAIL PROTECTED]] > I don't yet have my OCP, but my boss is encouraging me to go for it. > The > higher ed types seem to be impressed by pieces of paper! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whittle Jerome Contr NCI 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: stupid oracle on windoze question
well the thing is, he wasn't looking for TNS_ADMIN since that just re-sets the directory Oracle looks at but wanted something that worked more like how login.sql works -- where if you have the file in your local working directory, it is used and overrides any other file. In Unix, if you have a .tnsnames.ora file (please note the initial ".") in your own personal $HOME directory) it will override the values in the $ORACLE_HOME/network/admin/tnsnames.ora or the $TNS_ADMIN/tnsnames.ora file THAT is what Joe wanted for Windows. It ain't in the flaming manuals. --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > Damn, why don't people use the manuals. TNS_ADMIN. Actually, you > can set > the puppy on Unix as well. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE > TESTA > Sent: Wednesday, January 02, 2002 6:15 AM > To: Multiple recipients of list ORACLE-L > Subject: stupid oracle on windoze question > > > ok in the unix world, we have .tnsnames.ora file which overrides a > $HOME/network/admin/tnsnames.ora file. > > Is there such a thing in the windoze world. a registry entry > maybe? > > thanks, joe > > __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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 not available ???
If the database was shutdown cleanly, the online logs are not required or desired. If the database was not shutdown cleanly, you will not be able to open the database without them. Jared [EMAIL PROTECTED] .tenet.eduTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: RE: oracle not available ??? 01/01/02 07:30 PM Please respond to ORACLE-L Nagaraj, Yes, you may indeed have a problem. You say you backed up the datafiles. Did you get the redo logs and controlfile? How did your DB go down? Did it crash, or were you able to shut it down? If you're not in archivelog mode, are the redo logs that were current at the time of the most recent backup available? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Nagaraj Panyam" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/01/2002 11:55 AM PST Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Hi list I have a database recovery problem. The scenario is like this a) My database is not in archive mode. b) I have taken a cold back up on two different times. 6 data files in the morning and 6 in the evening. In between the database was started and again Was shutdown before taking back up in the evening. I want to recover the database completely but I don't mind losing the data of the period between the back ups. Can any one have solution. Thanks in advance NAGARAJ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nagaraj Panyam 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: 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: Determining Striping
If memory serves on Solaris it is called Solaris Online Disksuite or something like that -Original Message- Sent: 02 January 2002 15:30 To: Multiple recipients of list ORACLE-L Not sure if you can show striping with a command. Using the DF command usually shows all disks in the disk farm. Alternatively, there is an admin tool for disk maintenance, but I don't remember the name. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, January 02, 2002 10:15 AM To: Multiple recipients of list ORACLE-L Subject:Determining Striping Is there a UNIX command to determine what, if any, striping was used when setting up a server and it's disk? Sun Solaris 6, 7 and 8 are what I'm specifically interested in. TIA, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: Karniotis, Stephen 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: VLDB backup policy
best case, unlimited funds, you need something like EMC's SRDF or IBM's HACMP which are remote mirrored solutions. --- Andrey Bronfin <[EMAIL PROTECTED]> wrote: > Dear list ! > I'm reposting this , since got no replies yet. > > I need to design a backup policy for a VLDB sized some 10TB, running > as close to 24X7 as possible. > I need 2 versions of the policy: > One is the "best case" , i.e. money does not matter, the company can > aquire > any software / hardware , the only goal is to have a solid backup and > ability to backup and recover as fast as possible. > The second is the opposite case - how to achieve a good backup > spending as > little money as possible, possibly tolerating a little more downtime > in case > of a crash. > > I just have never happened to work with 10 Terrabytes size of DB, in > particular ,i believe that my proven backup strategies that work well > with > 100GB DB might need some amending when it comes to 10 TB size. > > Another constraint is that i'm limited to Oracle 8.1.7 , and can not > upgrade > to 9i. > > I need to decide which hardware/software needs to be > purchased/evaluated to > implement solid DRP and HA. > People say : EMC , Veritas , Legato etc... > I'm just lost among these (and many others) buzzwords and need a > "Second > opinion" from gurus, like you. > Please share your experience and thoughts. > Thanks a lot in advance ! > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Andrey Bronfin > 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!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.
Generally, if you are on a version of Oracle that has a bug free implementation of LMT's, then use them. 8.1.7.1 or 8.1.7.2 I believe. There's no reason not to use them otherwise. Jared Arul kumar drabt.com> cc: Sent by: Subject: Locally Managed Tblsp. Vs Dictionary Managed Tblsp. [EMAIL PROTECTED] om 01/01/02 10:10 PM Please respond to ORACLE-L Hi DBAs, I would like to know on what basis we arrive at the decision of making a tablespace as LOCALLY Managed / DICTIONARY Managed... Any Suggestions / Tips Thank you.. Arul. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar 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: Becoming a DBA questions
Somewhat different, but my son's taking his CCNA (Cisco Certified Networking Associate) this p.m. He realizes that it's not going to guarantee him a job, but he hopes it will help him get his foot in the door. He's 19, and just finished the Cisco networking academy. He took the first year at his high school, and the second year at the local community college. Without experience, he knows it will be more difficult to get a job. He hopes this will indicate that he has at least some background and training in the area. His intent is to work full time as a network admin type while he goes to a four-year college part-time. He eventually wants to get a degree in theatre arts, but doesn't want mom and dad to pay for it. (I don't know why - he's very different from his sibs!) He figures this will allow him to get a half-way decent job while he goes to school. I don't yet have my OCP, but my boss is encouraging me to go for it. The higher ed types seem to be impressed by pieces of paper! I think it would look nice on a resume, but I don't intend to leave here so I'm not sure it's worth the effort. -Original Message- Sent: Tuesday, January 01, 2002 11:00 PM To: Multiple recipients of list ORACLE-L Kimberly, I'm with you and like you I only took the 8 test because at the time, my employer paid for the tests and gave me a bonus to pass them(like $250/test and $1000K when all done, if i remember correctly), so i had incentive :). Joe Kimberly Smith wrote: > I for the most part have stayed out of this whole OCP thing cause I too > think its fairly worthless to determine if someone has the skills necessary > to perform the job of DBA. And that is despite the fact I have gone > ahead and gotten my Oracle8 DBA and then upgrading to 8i after. > > That, however, does not make it worthless in getting an interview. I > believe > that we have already pretty much gone over the whole fact that you have > to get by HR before getting an interview and you do need to have something > to > get you that edge. Sometimes all it takes is the OCP. Are managers wrong > to let it influence them? It depends. If they are saying, that person has > an OCP, they must be good, then yes, they are being influenced incorrectly. > However, if they are saying hey, that person took some time to get an OCP. > Lets bring them in for an interview and see if they know what they are > talking > about then I say its a good thing. And so far I have seem more of the later > then the former, at least within the company I work for. > > To me it just shows that I am keeping up to date on my database of choice. > I back it up with my experience. And if that gets me a job over someone > with similar experience but thought it was not worth their time to get the > OCP then sucks to be you. Its not predominate on my resume but bet your > ass that its there. > > Granted, having my company pay for the tests make it an easier decision to > go get them and I am not so sure I would be so willing to do it if the > company > was not willing. If the company is paying, get the damn chip off your > shoulder > and go take the tests. If you are good as you say you are and the tests > as easy as you say they are then what the hell is the big deal. I have yet > to take longer then 15 minutes to do the test (including the survey). > Including the drive and stuff surely you can all spare an hour and increase > the cash inflow at Oracle > > This email was not directed specifically at you Joe, just replying to the > whole OCP thing (especially since you seem to have the same thought process > in > this case). OK, back to the wine... > > -Original Message- > Sent: Tuesday, January 01, 2002 6:10 PM > To: Multiple recipients of list ORACLE-L > > > Edward, i beg to differ, the ONLY thing that OCP is good for is a > discriminator between to evenly qualified/interviewed candidates. > > As someone who does hiring of oracle DBAs and who's been one for 10 > years and is OCP, I'm skeptical of those who make a big deal out of > being OCP, since that tends to make me believe that they DONT have the > experience to back it up. > > Joe > 8 and 8i OCP(but rarely makes it known). > > Edward Lock wrote: > > >>As someone with 7 years in the HR (Compensation) field, and now in the >>IT/ERP field working on my Oracle DBA OCP, I can speak with some >>knowledge and experience. >> >> >> >>Using the term "Entry Level" on a resume is self-defeating. Most >>technical resumes are still screened by by the HR departments first, >>before the hiring managers even see them. A good recruiter will be able >>to identify whether you have the experience or not. If not, they will >>defer a judgment call to the hiring IT manager anyway. That doesn't >>mean that you should lie on your resume or deceive anyone. But don't >>shoot yourself in the foot before you even get your foot in the door. >> >> >> >>Annual salaries for DBAs are, indeed, coming d
Determining Striping
Is there a UNIX command to determine what, if any, striping was used when setting up a server and it's disk? Sun Solaris 6, 7 and 8 are what I'm specifically interested in. TIA, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: stupid oracle on windoze question
Not to mention that this is something that you also need to know for the OCP exam;-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kimberly SmithSent: Wednesday, January 02, 2002 7:05 AMTo: Multiple recipients of list ORACLE-LSubject: RE: stupid oracle on windoze question Damn, why don't people use the manuals. TNS_ADMIN. Actually, you can set the puppy on Unix as well. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Wednesday, January 02, 2002 6:15 AMTo: Multiple recipients of list ORACLE-LSubject: stupid oracle on windoze question ok in the unix world, we have .tnsnames.ora file which overrides a $HOME/network/admin/tnsnames.ora file. Is there such a thing in the windoze world. a registry entry maybe? thanks, joe
RE: VLDB backup policy
You could split off a mirror and backup the mirror however, I have never done that so I am not going to get into it. I know there are others in the list who have done it for their backup strategy. Keep in mind that if you are running in archive log mode you need not backup every data file at the same time. This would be your cheap end solution. Make sure you have enough disk to deal with your archive logs (depends on how much you want to keep on disk). I would place objects in tablespaces based on usage rather then size or functionality. In other words, if you have a bunch of tables that have very little data changed or data that does get changed does so infrequently then place them in the same tablespace. If you have tables that have change constantly then keep them together. Granted you may end up with more then one tablespace per change type but don't mix. Then schedule backups of those tablespaces more frequently then others. Try and get the full backup done by the end of the week for all tablespaces. Keep in mind that the control file and other stuff need to be backed up as well. Your recovery is going to be a little more complicated this way and time to recover is going to be longer but if you get the frequently changed tablespaces more often then it should not be too bad. -Original Message- Sent: Wednesday, January 02, 2002 6:50 AM To: Multiple recipients of list ORACLE-L Dear list ! I'm reposting this , since got no replies yet. I need to design a backup policy for a VLDB sized some 10TB, running as close to 24X7 as possible. I need 2 versions of the policy: One is the "best case" , i.e. money does not matter, the company can aquire any software / hardware , the only goal is to have a solid backup and ability to backup and recover as fast as possible. The second is the opposite case - how to achieve a good backup spending as little money as possible, possibly tolerating a little more downtime in case of a crash. I just have never happened to work with 10 Terrabytes size of DB, in particular ,i believe that my proven backup strategies that work well with 100GB DB might need some amending when it comes to 10 TB size. Another constraint is that i'm limited to Oracle 8.1.7 , and can not upgrade to 9i. I need to decide which hardware/software needs to be purchased/evaluated to implement solid DRP and HA. People say : EMC , Veritas , Legato etc... I'm just lost among these (and many others) buzzwords and need a "Second opinion" from gurus, like you. Please share your experience and thoughts. Thanks a lot in advance ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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).
Stupid windoze question
better work around was to have a modified version of tnsnames.ora file in a bin directory that we execute our batch files from. Since this is an rexec and we execute from different directories based on the userid, we can use the same alias DSS to point to different db based on the login, dev login has a tnsnames.ora file that has dss alias in it that points to the dev database, test login points to test database, etc. thanks for everyone's input. tested and it works fine. joe
RE: Determining Striping
Not sure if you can show striping with a command. Using the DF command usually shows all disks in the disk farm. Alternatively, there is an admin tool for disk maintenance, but I don't remember the name. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, January 02, 2002 10:15 AM To: Multiple recipients of list ORACLE-L Subject:Determining Striping Is there a UNIX command to determine what, if any, striping was used when setting up a server and it's disk? Sun Solaris 6, 7 and 8 are what I'm specifically interested in. TIA, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: Karniotis, Stephen 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: Problem Granting Roles
Is the role set as her default role? Having the role is not enough. You can have a role assigned to you but its not necessarily 'active' at the time. -Original Message- Sent: Wednesday, January 02, 2002 4:30 AM To: Multiple recipients of list ORACLE-L I granted myself roles via SYS. I have another user on our server (W2000 / 8.1.7) and I have gone through the same process of granting the new user roles via SYS. However, when she connects to the DB she gets the message that the objects don't exist. The owner of the DB is me. What am I doing wrong? Should I grant her roles from my user name or from SYS? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- 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: 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: stupid oracle on windoze question
Ah ha! Revenge of the RTFM! ;P Original Message- Sent: 02 January 2002 14:45 To: Multiple recipients of list ORACLE-L HI Joe, >From the documentation: TNS_ADMIN Oracle software looks for TNS_ADMIN in one location in the registry (depending upon the type of Oracle home installed). If you installed software into the default Oracle home, then any software running from that Oracle home will look in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE. If you installed a new-style (8.0.4 or later) multiple Oracle home, then the Oracle software looks in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID . The ALL_HOMES key is used by the installer and plays no role when translating variables. The environment always overrides the registry, so if TNS_ADMIN is set in the environment, that takes precedence over the TNS_ADMIN setting in the registry. No variables should be set in the environment by the Oracle Home Selector except for the PATH. Hope this helps, John [EMAIL PROTECTED] wrote: ok in the unix world, we have .tnsnames.ora file which overrides a $HOME/network/admin/tnsnames.ora file. Is there such a thing in the windoze world. a registry entry maybe? thanks, joe -- 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).
A DBA's career development
Dear list ! Having been an Oracle DBA on UNIX & win platforms for past several years, i feel like i'd like to change something. Don't get me wrong , i like what i'm doing , but i think it's time to expand my horizons. I wouldn't like to completely quit the filed of Oracle/DBAing , but i'd like to add something to it. I also know some system UNIX (mainly Solaris) and some development (java , perl , pl/sql etc.) Where would i go next ? I'm thinking of several possible paths : Oracle DBA + UNIX sysadmin ; Ora DBA + developer ; DBA of Oracle + some other DB , that i'll need to learn Or may be it's time to move to some sort of system analysis , datawarehousing ,ERP or ... ??? I'm thinking about the future of the market , demand for employees in various fields , salaries etc.. What would U , dear gurus , say ? What do U think about your careers / future ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: OTN Download Hanging
I just thought of something... do you have enough disk space for your TEMP directory. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, January 02, 2002 10:25 AM To: Multiple recipients of list ORACLE-L Subject:RE: OTN Download Hanging Ken, Your system is most probably running through the last stage of the download, where it copies the file to the download destination from your temporary directory, once the download is complete and verified.. Depending on your system, and connection this could take a little while to do as each download is around 500 Mb right? How long is it hanging for - and what system / connection do you have? Mark -Original Message- Sent: 02 January 2002 12:50 To: Multiple recipients of list ORACLE-L I am trying to download the three .zip for 9i to my laptop (W2000). The download goes OK until it gets to 99%. Then I look at Task Mgr. and it says 99% complete Not Responding. Why is it hanging? This has happened to me three times in a row. Thanks, Ken -- 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: 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: 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: stupid oracle on windoze question
Damn, why don't people use the manuals. TNS_ADMIN. Actually, you can set the puppy on Unix as well. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Wednesday, January 02, 2002 6:15 AMTo: Multiple recipients of list ORACLE-LSubject: stupid oracle on windoze question ok in the unix world, we have .tnsnames.ora file which overrides a $HOME/network/admin/tnsnames.ora file. Is there such a thing in the windoze world. a registry entry maybe? thanks, joe
RE: stupid oracle on windoze question
Re: stupid oracle on windoze question
HI Joe, >From the documentation: TNS_ADMIN Oracle software looks for TNS_ADMIN in one location in the registry (depending upon the type of Oracle home installed). If you installed software into the default Oracle home, then any software running from that Oracle home will look in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE. If you installed a new-style (8.0.4 or later) multiple Oracle home, then the Oracle software looks in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID . The ALL_HOMES key is used by the installer and plays no role when translating variables. The environment always overrides the registry, so if TNS_ADMIN is set in the environment, that takes precedence over the TNS_ADMIN setting in the registry. No variables should be set in the environment by the Oracle Home Selector except for the PATH. Hope this helps, John [EMAIL PROTECTED] wrote: ok in the unix world, we have .tnsnames.ora file which overrides a $HOME/network/admin/tnsnames.ora file. Is there such a thing in the windoze world. a registry entry maybe? thanks, joe
VLDB backup policy
Dear list ! I'm reposting this , since got no replies yet. I need to design a backup policy for a VLDB sized some 10TB, running as close to 24X7 as possible. I need 2 versions of the policy: One is the "best case" , i.e. money does not matter, the company can aquire any software / hardware , the only goal is to have a solid backup and ability to backup and recover as fast as possible. The second is the opposite case - how to achieve a good backup spending as little money as possible, possibly tolerating a little more downtime in case of a crash. I just have never happened to work with 10 Terrabytes size of DB, in particular ,i believe that my proven backup strategies that work well with 100GB DB might need some amending when it comes to 10 TB size. Another constraint is that i'm limited to Oracle 8.1.7 , and can not upgrade to 9i. I need to decide which hardware/software needs to be purchased/evaluated to implement solid DRP and HA. People say : EMC , Veritas , Legato etc... I'm just lost among these (and many others) buzzwords and need a "Second opinion" from gurus, like you. Please share your experience and thoughts. Thanks a lot in advance ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: stupid oracle on windoze question
Joe, You can set TNS_ADMIN as an environment variable or registry variable in HKLM/Software/Oracle and use it. I prefer to use a variable instead of registry variable. 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-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 02, 2002 9:15 AMTo: Multiple recipients of list ORACLE-LSubject: stupid oracle on windoze question ok in the unix world, we have .tnsnames.ora file which overrides a $HOME/network/admin/tnsnames.ora file. Is there such a thing in the windoze world. a registry entry maybe? thanks, joe *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: stupid oracle on windoze question
Joe: The Environment variable TNS_ADMIN can direct the location to another position. It can be stored within the registry or as a environment variable in windows. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: JOE TESTA [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 9:15 AM To: Multiple recipients of list ORACLE-L Subject: stupid oracle on windoze question ok in the unix world, we have .tnsnames.ora file which overrides a $HOME/network/admin/tnsnames.ora file. Is there such a thing in the windoze world. a registry entry maybe? thanks, joe
RE: OTN Download Hanging
Ken, Your system is most probably running through the last stage of the download, where it copies the file to the download destination from your temporary directory, once the download is complete and verified.. Depending on your system, and connection this could take a little while to do as each download is around 500 Mb right? How long is it hanging for - and what system / connection do you have? Mark -Original Message- Sent: 02 January 2002 12:50 To: Multiple recipients of list ORACLE-L I am trying to download the three .zip for 9i to my laptop (W2000). The download goes OK until it gets to 99%. Then I look at Task Mgr. and it says 99% complete Not Responding. Why is it hanging? This has happened to me three times in a row. Thanks, Ken -- 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: 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).
stupid oracle on windoze question
ok in the unix world, we have .tnsnames.ora file which overrides a $HOME/network/admin/tnsnames.ora file. Is there such a thing in the windoze world. a registry entry maybe? thanks, joe
RE: OTN Download Hanging
Get Download Accelerator Plus, it downloads things in parallel and re-downloads corrupted segments. It won't work with all the Oracle download files (e.g. doesn't work with 11i patchset), but it works for most of them. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 02, 2002 8:50 AM To: Multiple recipients of list ORACLE-L Subject:OTN Download Hanging I am trying to download the three .zip for 9i to my laptop (W2000). The download goes OK until it gets to 99%. Then I look at Task Mgr. and it says 99% complete Not Responding. Why is it hanging? This has happened to me three times in a row. Thanks, Ken -- 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: 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: Becoming a DBA questions
No, Access *IS* a relational database! I almost want to add ;P to the end of that, but it's true! It's just a "compact" relational database, that resides in one file. It is still SQL based, and geared around objects such as tables, indexes etc. A poor man's RDBMS.. That does the trick quite nicely for the niche that it's in.. Happy New Year everyone!! Trying to get back in to the swing of things now eh!! May you all have a prosperous one! Cheers Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Boivin, Patrice JSent: 02 January 2002 12:40To: Multiple recipients of list ORACLE-LSubject: RE: Becoming a DBA questions Did you mean... "MS SQL Server is a relational database" and not MS Access? Regards, Patrice Boivin Systems Analyst (Oracle DBA) Acting Head, System Admin & Operations Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message-From: Edward Lock [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 01, 2002 7:50 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Becoming a DBA questions As someone with 7 years in the HR (Compensation) field, and now in the IT/ERP field working on my Oracle DBA OCP, I can speak with some knowledge and experience. Using the term "Entry Level" on a resume is self-defeating. Most technical resumes are still screened by by the HR departments first, before the hiring managers even see them. A good recruiter will be able to identify whether you have the experience or not. If not, they will defer a judgment call to the hiring IT manager anyway. That doesn't mean that you should lie on your resume or deceive anyone. But don't shoot yourself in the foot before you even get your foot in the door. Annual salaries for DBAs are, indeed, coming down. If you can get ahold of a good IT salary survey, make note of not only the average salary, but the median salary. The median salary is what is commonly used to benchmark a position--not the average salary. If a formal salary structure exists at a company, they will normally use the median as the compa-ratio for the particular paygrade or step. Use common sense, do your homework, and ask what you're worth; but always leave room for compromise. MS Access IS a relational database. However it is a file-server application, not a client-server database, and was not designed to handle large transactional systems over a large network. It is designed for small to medium sized, non mission-critical business environments. Properly designed, MS Access can serve many purposes, but you will never find Payroll or Financial systems using MS Access as a db platform or front-end. MS Access is a great environment for learning databases and SQL, but it is only a starting point. Concerning Oracle training--use everything that you can afford. If it's a career-change, then consider formal Oracle University instructor-led training classes. If you're already in the field, then self-study may work. It takes tremendous self-discipline to go the self-study route with books and CDS or online training. People who say that the OCP is valueless to the market have never tested. I say to them--why not test? Edward Lock Sr. Programmer Analyst PeopleSoft Project Office, University of Houston System [EMAIL PROTECTED] - Original Message - From: Karniotis, Stephen Sent: Monday, December 31, 2001 12:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Becoming a DBA questions Good afternoon all: I have been holding back on replying to this email because I reallywanted to see what some of the other answers were, especially ones relatedto OCP. Rachel C. will understand as my answers will be very direct.1. What is the average salary range for an entry-level DBA position? Ora position for someone who is just starting out as a DBA?>>> As a person that has worked as an Oracle DBA for over 13years, the entry-level salary had changed quite dramatically. From themid-to late 1990s when starting DBAs could make upwards of 100K to "REALITY"when entry-level DBAs should be making no more than 70K. Some may disagree,however, I don't think paying high salaries is warranted just because theperson is a DBA. If they don't have the experience, they don't deserve thehigh monetary return. I would say that 50K is probably on the high end forentry-level DBAs. The days of high salaries, similarly the high consultingrates, are gone and organizations are now back to reality. I actually hadsomeone whom has been out
Re:How to Compile Pro*c
I assume we're talking Unix here, therefore the command line is: $make -f proc.mk build EXE=petrol OBJS=petrol.o Or if your using shared libraries: $make -f proc.mk build_shared EXE=petrol OBJS=petrol.o Dick Goulet Reply Separator Author: [EMAIL PROTECTED] (N J Neog) Date: 1/2/2002 1:05 AM Hi Everybody !! Pl. help me out from this problem !!! My Boss had asked me to Compile a Pro*C after making some very simple Changes. This was a running program. I had tried to comiple with $make -f proc.mk petrol Make: Don't know how to make petrol. Stop. Environment is 1.digital unix 2. Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production Any help is appreciated. Thanks in advance. Naba -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: N J Neog 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: Problem Granting Roles
Hi You own the objects, and the other user can't see them? Try creating synonyms or add the schemaname in front of the object. ---select * from owner.table; what roles did you grant (connect resource dba. or something you created yourself)? A little more info would help in resolving problems (be specific to avoid the nasty RTFM reply) Jack Ken Janusz <[EMAIL PROTECTED]>@fatcity.com on 02-01-2002 13:30:17 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) I granted myself roles via SYS. I have another user on our server (W2000 / 8.1.7) and I have gone through the same process of granting the new user roles via SYS. However, when she connects to the DB she gets the message that the objects don't exist. The owner of the DB is me. What am I doing wrong? Should I grant her roles from my user name or from SYS? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- 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). === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. === -- 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).
OTN Download Hanging
I am trying to download the three .zip for 9i to my laptop (W2000). The download goes OK until it gets to 99%. Then I look at Task Mgr. and it says 99% complete Not Responding. Why is it hanging? This has happened to me three times in a row. Thanks, Ken -- 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).
RE: Problem Granting Roles
Title: RE: Problem Granting Roles What exactly is the error message - if it is table or view does not exist (ORA-904) then I suspect that it is synonyms that are not working/created. get the user to select from the full table name sys.x and see what happens. -Original Message- From: Ken Janusz [mailto:[EMAIL PROTECTED]] Sent: 02 January 2002 12:30 To: Multiple recipients of list ORACLE-L Subject: Problem Granting Roles I granted myself roles via SYS. I have another user on our server (W2000 / 8.1.7) and I have gone through the same process of granting the new user roles via SYS. However, when she connects to the DB she gets the message that the objects don't exist. The owner of the DB is me. What am I doing wrong? Should I grant her roles from my user name or from SYS? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- 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). = This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. =
RE: Becoming a DBA questions
Did you mean... "MS SQL Server is a relational database" and not MS Access? Regards, Patrice Boivin Systems Analyst (Oracle DBA) Acting Head, System Admin & Operations Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message-From: Edward Lock [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 01, 2002 7:50 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Becoming a DBA questions As someone with 7 years in the HR (Compensation) field, and now in the IT/ERP field working on my Oracle DBA OCP, I can speak with some knowledge and experience. Using the term "Entry Level" on a resume is self-defeating. Most technical resumes are still screened by by the HR departments first, before the hiring managers even see them. A good recruiter will be able to identify whether you have the experience or not. If not, they will defer a judgment call to the hiring IT manager anyway. That doesn't mean that you should lie on your resume or deceive anyone. But don't shoot yourself in the foot before you even get your foot in the door. Annual salaries for DBAs are, indeed, coming down. If you can get ahold of a good IT salary survey, make note of not only the average salary, but the median salary. The median salary is what is commonly used to benchmark a position--not the average salary. If a formal salary structure exists at a company, they will normally use the median as the compa-ratio for the particular paygrade or step. Use common sense, do your homework, and ask what you're worth; but always leave room for compromise. MS Access IS a relational database. However it is a file-server application, not a client-server database, and was not designed to handle large transactional systems over a large network. It is designed for small to medium sized, non mission-critical business environments. Properly designed, MS Access can serve many purposes, but you will never find Payroll or Financial systems using MS Access as a db platform or front-end. MS Access is a great environment for learning databases and SQL, but it is only a starting point. Concerning Oracle training--use everything that you can afford. If it's a career-change, then consider formal Oracle University instructor-led training classes. If you're already in the field, then self-study may work. It takes tremendous self-discipline to go the self-study route with books and CDS or online training. People who say that the OCP is valueless to the market have never tested. I say to them--why not test? Edward Lock Sr. Programmer Analyst PeopleSoft Project Office, University of Houston System [EMAIL PROTECTED] - Original Message - From: Karniotis, Stephen Sent: Monday, December 31, 2001 12:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Becoming a DBA questions Good afternoon all: I have been holding back on replying to this email because I reallywanted to see what some of the other answers were, especially ones relatedto OCP. Rachel C. will understand as my answers will be very direct.1. What is the average salary range for an entry-level DBA position? Ora position for someone who is just starting out as a DBA?>>> As a person that has worked as an Oracle DBA for over 13years, the entry-level salary had changed quite dramatically. From themid-to late 1990s when starting DBAs could make upwards of 100K to "REALITY"when entry-level DBAs should be making no more than 70K. Some may disagree,however, I don't think paying high salaries is warranted just because theperson is a DBA. If they don't have the experience, they don't deserve thehigh monetary return. I would say that 50K is probably on the high end forentry-level DBAs. The days of high salaries, similarly the high consultingrates, are gone and organizations are now back to reality. I actually hadsomeone whom has been out of work for over 6 months refuse a salary of 65Kas a DBA because he felt it was demeaning for him to accept it.2. In a job resume, should I request an entry-level position or wouldthat set me up for no phone calls?>>> I disagree with everyone else regarding not using"entry-level" on your resume. If you have no experience and you are lookingto work in a team environment, then using this wording is acceptable. Youwill have to pick the job postings carefully so you don't send resumes toorganizations that require lots of experience. If you can control that,then remove "entry-level" and use "junior" instead.3. What are some steps I should take to becoming a DBA w/ thebackground that I have (ie. generated databases w/ MS Access)?>>> Well, MS Access, although people consider this a relationaldatabase,
Problem Granting Roles
I granted myself roles via SYS. I have another user on our server (W2000 / 8.1.7) and I have gone through the same process of granting the new user roles via SYS. However, when she connects to the DB she gets the message that the objects don't exist. The owner of the DB is me. What am I doing wrong? Should I grant her roles from my user name or from SYS? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- 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).
educate yourself
Nice stuff : http://www.intelinfo.com/newly_researched_free_training.html http://www.intelinfo.com/free_it_training_materials_and_books.html http://w3.softlookup.com/ http://www.intelinfo.com/cat1.html http://www.intelinfo.com/cat2.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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).
AHA!!! Re: ORA-00904 on a valid view when using count(*)
hahaha! i found it! i found the answer to my problem the part that causes the error was the order by clause using an alias... i tried to change the sql for the view using the whole exp (((sq.last_trade_price - sq.previous)/sq.previous) * 100) in the order by clause instead of the "perc_change" alias... and it worked! almost a week of thinking about this problem... i was itching to touch my database...while everyone else were sooo into the new year celebrations... now I can celebrate! =) this looks like a bug...if anyone of you is working for oracle...kindly take note of this... Maria Aurora VT de la Vega wrote: yup. tried to validate...no luck, tried to rebuild...no luck, tried creating a new base table (CTAS)...and create new views (same sql as orig views)...still no luck...problem can be recreated... here's the objects involved SQL> desc stock_quote Name Null? Type - SECURITY_ID VARCHAR2(10) BID NUMBER(12,4) ASK NUMBER(12,4) PREVIOUS NUMBER(12,4) OPEN NUMBER(12,4) HIGH NUMBER(12,4) LOW NUMBER(12,4) CLOSE NUMBER(12,4) LAST_TRADE_PRICE NUMBER(12,4) TOTAL_VOLUME NUMBER(18,4) TOTAL_VALUE NUMBER(18,4) PROJECTED_OPEN NUMBER(16,4) SPECIAL_VOLUME NUMBER(18,4) SPECIAL_VALUE NUMBER(18,4) TOTAL_FOREIGN_BUYING NUMBER(16,4) TOTAL_FOREIGN_SELLING NUMBER(16,4) TOTAL_OUTSTANDING NUMBER(16,4) CURR_FOREIGN_SHARES_AVAIL NUMBER(16,4) SECURITY_SYMBOL VARCHAR2(12) SQL> desc company Name Null? Type - - COMPANY_ID NOT NULL VARCHAR2(10) NAME VARCHAR2(60) TELEPHONE VARCHAR2(200) FAX VARCHAR2(40) URL VARCHAR2(50) EMAIL VARCHAR2(30) PROFILE_FNAME VARCHAR2(100) SUBSECTOR_ID VARCHAR2(8) LOGO VARCHAR2(100) INCORP_DATE DATE LISTING_DATE DATE ADDRESS VARCHAR2(250) SQL> desc security Name Null? Type - SECURITY_ID NOT NULL VARCHAR2(10) SECURITY_SYMBOL VARCHAR2(12) ISIN VARCHAR2(12) SUBSECTOR_ID VARCHAR2(8) ALIAS VARCHAR2(15) COMPANY_ID VARCHAR2(10) SECURITY_TYPE CHAR(1) CEILING NUMBER(12,4) FLOOR NUMBER(12,4) PRIOR_CLOSE NUMBER(12,4) LAST_TRADED_DATE DATE PAR_VALUE NUMBER(12,4) BOARD_LOT NUMBER(16,4) BIG_LOT NUMBER(16,4) DESIGNATED CHAR(1) SUSPENSION CHAR(1) DELIST CHAR(1) HALT CHAR(1) SPLIT CHAR(1) BENEFIT CHAR(1) EX_DIVIDEND CHAR(1) EX_RIGHTS CHAR(1) FOREIGN_ID_REQUIRED CHAR(1) TOTAL_OUTSTANDING_SHARES NUMBER(16,4) FOREIGN_OWNABLE_SHARES NUMBER(16,4) CURRENT_FOREIGN_SHARES NUMBER(16,4) MATURITY_DATE
Re: Becoming a DBA questions
I've tested OCP... and it's not that it is totally valueless (if nothing else it can show that someone is willing to learn) but that WHAT OCP teaches you does not tend to apply in the real world. I won't reject a resume out-of-hand if they have OCP on it, but they'd better have something else that tells me that they have the ability to think beyond what they've been taught. OCP teaches you to parrot back Oracle's preferred method of doing things (btw, only having GUI experience on your resume does the same). I want someone who can think for themselves as well --- Edward Lock <[EMAIL PROTECTED]> wrote: > As someone with 7 years in the HR (Compensation) field, and now in > the IT/ERP field working on my Oracle DBA OCP, I can speak with some > knowledge and experience. > > Using the term "Entry Level" on a resume is self-defeating. Most > technical resumes are still screened by by the HR departments first, > before the hiring managers even see them. A good recruiter will be > able to identify whether you have the experience or not. If not, > they will defer a judgment call to the hiring IT manager anyway. > That doesn't mean that you should lie on your resume or deceive > anyone. But don't shoot yourself in the foot before you even get > your foot in the door. > > Annual salaries for DBAs are, indeed, coming down. If you can get > ahold of a good IT salary survey, make note of not only the average > salary, but the median salary. The median salary is what is commonly > used to benchmark a position--not the average salary. If a formal > salary structure exists at a company, they will normally use the > median as the compa-ratio for the particular paygrade or step. Use > common sense, do your homework, and ask what you're worth; but always > leave room for compromise. > > MS Access IS a relational database. However it is a file-server > application, not a client-server database, and was not designed to > handle large transactional systems over a large network. It is > designed for small to medium sized, non mission-critical business > environments. Properly designed, MS Access can serve many purposes, > but you will never find Payroll or Financial systems using MS Access > as a db platform or front-end. MS Access is a great environment for > learning databases and SQL, but it is only a starting point. > > Concerning Oracle training--use everything that you can afford. If > it's a career-change, then consider formal Oracle University > instructor-led training classes. If you're already in the field, > then self-study may work. It takes tremendous self-discipline to go > the self-study route with books and CDS or online training. > > People who say that the OCP is valueless to the market have never > tested. I say to them--why not test? > > Edward Lock > Sr. Programmer Analyst > PeopleSoft Project Office, University of Houston System > [EMAIL PROTECTED] > - Original Message - > Sent: Monday, December 31, 2001 12:08 PM > To: Multiple recipients of list ORACLE-L > > Good afternoon all: > >I have been holding back on replying to this email because I > really > wanted to see what some of the other answers were, especially ones > related > to OCP. Rachel C. will understand as my answers will be very direct. > > 1. What is the average salary range for an entry-level DBA position? > Or > a position for someone who is just starting out as a DBA? > >>> As a person that has worked as an Oracle DBA for over 13 > years, the entry-level salary had changed quite dramatically. From > the > mid-to late 1990s when starting DBAs could make upwards of 100K to > "REALITY" > when entry-level DBAs should be making no more than 70K. Some may > disagree, > however, I don't think paying high salaries is warranted just because > the > person is a DBA. If they don't have the experience, they don't > deserve the > high monetary return. I would say that 50K is probably on the high > end for > entry-level DBAs. The days of high salaries, similarly the high > consulting > rates, are gone and organizations are now back to reality. I > actually had > someone whom has been out of work for over 6 months refuse a salary > of 65K > as a DBA because he felt it was demeaning for him to accept it. > > 2. In a job resume, should I request an entry-level position or would > that set me up for no phone calls? > >>> I disagree with everyone else regarding not using > "entry-level" on your resume. If you have no experience and you are > looking > to work in a team environment, then using this wording is acceptable. > You > will have to pick the job postings carefully so you don't send > resumes to > organizations that require lots of experience. If you can control > that, > then remove "entry-level" and use "junior" instead. > > 3. What are some steps I should take to becoming a DBA w/ the > background that I have (ie. generated databases w/ MS Access)? > >>> Well, MS Access, although people con
Re: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.
Connor McDonald wrote: > > Dictionary managed tspaces are practically > obsolete...Go with locally managed - they are the > default in 9i and as of 9i.2, *all* tablespaces will > default to locallly managed (including system) > > hth > connor > > --- Arul kumar <[EMAIL PROTECTED]> wrote: > Hi > DBAs, > > > > I would like to know on what basis we arrive at the > > decision of making a > > tablespace as LOCALLY Managed / DICTIONARY > > Managed... > > > > Any Suggestions / Tips > > > > Thank you.. > > > > Arul. > > > > > * > > Disclaimer > > > > This message (including any attachments) contains > > confidential information intended for a specific > > individual and purpose, and is protected by law. > > If you are not the intended recipient, you should > > delete this message and are hereby notified that > > any disclosure, copying, or distribution of this > > message, or the taking of any action based on it, > > is strictly prohibited. > > > > > * > > Visit us at http://www.mahindrabt.com > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Arul kumar > > 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 Sybasation ;-) ? -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: How to Compile Pro*c
I would assume that the source code file either isn't there or is not called petrol.pc HTH Lee -Original Message- Sent: 02 January 2002 09:05 To: Multiple recipients of list ORACLE-L Hi Everybody !! Pl. help me out from this problem !!! My Boss had asked me to Compile a Pro*C after making some very simple Changes. This was a running program. I had tried to comiple with $make -f proc.mk petrol Make: Don't know how to make petrol. Stop. Environment is 1.digital unix 2. Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production Any help is appreciated. Thanks in advance. Naba -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: N J Neog 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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 not available ???
A Cold Backup is always a Full backup --- all datafiles (and, highly recommended, all control files and redo log files). Did you shutdown the database twice but only backup 6 files each time ? How many log switches occurred between the first backup and the second ? If the transactions are still in the online redo logs, you might try a recovery. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "Nagaraj Panyam" <[EMAIL PROTECTED]> 02/01/2002 03:55 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: RE: oracle not available ??? Hi list I have a database recovery problem. The scenario is like this a) My database is not in archive mode. b) I have taken a cold back up on two different times. 6 data files in the morning and 6 in the evening. In between the database was started and again Was shutdown before taking back up in the evening. I want to recover the database completely but I don't mind losing the data of the period between the back ups. Can any one have solution. Thanks in advance NAGARAJ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nagaraj Panyam 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: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.
Dictionary managed tspaces are practically obsolete...Go with locally managed - they are the default in 9i and as of 9i.2, *all* tablespaces will default to locallly managed (including system) hth connor --- Arul kumar <[EMAIL PROTECTED]> wrote: > Hi DBAs, > > I would like to know on what basis we arrive at the > decision of making a > tablespace as LOCALLY Managed / DICTIONARY > Managed... > > Any Suggestions / Tips > > Thank you.. > > Arul. > > * > Disclaimer > > This message (including any attachments) contains > confidential information intended for a specific > individual and purpose, and is protected by law. > If you are not the intended recipient, you should > delete this message and are hereby notified that > any disclosure, copying, or distribution of this > message, or the taking of any action based on it, > is strictly prohibited. > > * > Visit us at http://www.mahindrabt.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Arul kumar > 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).
How to Compile Pro*c
Hi Everybody !! Pl. help me out from this problem !!! My Boss had asked me to Compile a Pro*C after making some very simple Changes. This was a running program. I had tried to comiple with $make -f proc.mk petrol Make: Don't know how to make petrol. Stop. Environment is 1.digital unix 2. Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production Any help is appreciated. Thanks in advance. Naba -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: N J Neog 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).
