Re: How to get unique value using AWK?
On Thu, 2004-01-22 at 10:09, [EMAIL PROTECTED] wrote:
> Hi All,
>
> My manager wants to get all the unique wait events from the trace file.
> I tried the below but how do i get DISTICT wait event name?
>
> Any help would be really appreciated.
>
grep -i WAIT devdb1_ora_989.trc_orig|awk '{print $3" " $4 " " $5 " "$6}'
| sort | uniq -c
Or something similar should work.
--
Edward Simmonds RHCE, OCP
- Real men don't send html email.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ed
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: How to get unique value using AWK?
On Thu, 2004-01-22 at 10:34, Simpson, Ken wrote: > How about piping it through uniq? uniq normally assumes the input is sorted. See my other response. Best, -- Edward Simmonds RHCE, OCP - Real men don't send html email. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT REPORTS
Gene, Good stuff. Thanks for the tip. ed - Original Message - From: Gene Sais To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 6:29 PM Subject: RE: URGENT REPORTS What I like about VNC, is that all you need for a client is a browser. http://ip.address:5800 gets you a nice java client connection. Gene>>> [EMAIL PROTECTED] 09/24/03 06:14PM >>>If y'all do choose a VNC route, I'd highly recommend the free and GPL'dTightVNC from http://www.tightvnc.com/Better compression, better security, and better performance then otherRFB-compliant VNC flavors.RichRich Jesse System/Database Administrator[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA-Original Message-Sent: Wednesday, September 24, 2003 4:20 PMTo: Multiple recipients of list ORACLE-LSetting up vnc server and directing DISPLAY to that is easier, I think. Ihave a Apps reports server setup which has run for few years for now withvnc server.Tanel.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jesse, Rich INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Offshore protests
t;>>>>> > >>>>>> > >>>demanding better > >>> > >>> > >>>>>>pay > >>>>>> > >>>>>> > >>>>>for > >>>>> > >>>>> > >>>>>>starved database > >>>>>>administrators. What do you think, should we mandate > >>>>>> > >>>>>> > >>9i OCP for > >> > >> > >>>>>>joining > >>>>>> > >>>>>> > >>>>>the > >>>>> > >>>>> > >>>>>>union? If we were > >>>>>>in London, we could have a permanent beer table at the > >>>>>> > >>>>>> > >>>>>White Heart pub > >>>>> > >>>>> > >>>>>>(or is it the Sphere?). We might even encounter Harry > >>>>>> > >>>>>> > >>Purvis and > >> > >> > >>>>>>exchange the union stories. > >>>>>> > >>>>>>-- > >>>>>>Mladen Gogala > >>>>>>Oracle DBA > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>>>-Original Message- > >>>>>>>From: [EMAIL PROTECTED] > >>>>>>> > >>>>>>> > >>>>>[mailto:[EMAIL PROTECTED] On Behalf > >>>>> > >>>>> > >>>>>>>Of DENNIS WILLIAMS > >>>>>>>Sent: Monday, September 22, 2003 10:45 AM > >>>>>>>To: Multiple recipients of list ORACLE-L > >>>>>>>Subject: Offshore protests > >>>>>>> > >>>>>>> > >>>>>>>Looks as if tech workers are learning the basics of > >>>>>>> > >>>>>>> > >>>protesting. > >>> > >>> > >>http://informationweek.com/story/showArticle.jhtml?articleID=15000146 > >> > >> > >>>>>>>Dennis Williams > >>>>>>>DBA, 80%OCP, 100% DBA > >>>>>>>Lifetouch, Inc. > >>>>>>>[EMAIL PROTECTED] > >>>>>>>-- > >>>>>>>Please see the official ORACLE-L FAQ: http://www.orafaq.net > >>>>>>>-- > >>>>>>>Author: DENNIS WILLIAMS > >>>>>>> INET: [EMAIL PROTECTED] > >>>>>>> > >>>>>>>Fat City Network Services-- 858-538-5051 > >>>>>>> > >>>>>>> > >>>>>http://www.fatcity.com > >>>>> > >>>>> > >>>>>>>San Diego, California-- Mailing list and web > >>>>>>> > >>>>>>> > >>>>>hosting services > >>>>> > >>>>> > >>>>-- > >>>>Please see the official ORACLE-L FAQ: http://www.orafaq.net > >>>>-- > >>>>Author: Orr, Steve > >>>> INET: [EMAIL PROTECTED] > >>>> > >>>>Fat City Network Services-- 858-538-5051 > >>>> > >>>> > >>http://www.fatcity.com > >> > >> > >>>>San Diego, California-- Mailing list and web > >>>> > >>>> > >>>hosting services > >>> > >>> > >>- > >> > >> > >>>>To REMOVE yourself from this mailing list, send an E-Mail message > >>>>to: [EMAIL PROTECTED] (note EXACT spelling of > >>>> > >>>> > >>'ListGuru') and in > >> > >> > >>>>the message BODY, include a line containing: UNSUB > >>>> > >>>> > >>ORACLE-L (or the > >> > >> > >>>>name of mailing list you want to be removed from). You may also > >>>>send the HELP command for other information (like subscribing). > >>>> > >>>> > >>>> > >>>-- > >>>Please see the official ORACLE-L FAQ: http://www.orafaq.net > >>>-- > >>>Author: <[EMAIL PROTECTED] > >>> INET: [EMAIL PROTECTED] > >>> > >>>Fat City Network Services-- 858-538-5051 http://www.fatcity.com > >>>San Diego, California-- Mailing list and web > >>> > >>> > >>hosting services > >> > >> > >>- > >> > >> > >>>To REMOVE yourself from this mailing list, send an E-Mail message > >>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >>>the message BODY, include a line containing: UNSUB ORACLE-L (or the > >>>name of mailing list you want to be removed from). You may > >>> > >>> > >>also send > >> > >> > >>>the HELP command for other information (like subscribing). > >>> > >>> > >>> > >>> > >>-- > >>Please see the official ORACLE-L FAQ: http://www.orafaq.net > >>-- > >>Author: Weaver, Walt > >> INET: [EMAIL PROTECTED] > >> > >>Fat City Network Services-- 858-538-5051 http://www.fatcity.com > >>San Diego, California-- Mailing list and web hosting services > >>- > >>To REMOVE yourself from this mailing list, send an E-Mail message > >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > >>and in the message BODY, include a line containing: UNSUB > >>ORACLE-L (or the name of mailing list you want to be removed > >>from). You may also send the HELP command for other > >>information (like subscribing). > >> > >> > >> > > > > > > > > > >Note: > >This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. > >Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Joe Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ed Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OCP Architecture question
Ryan, I will research the answer but I have an urgent question. Do you have SelfTest Software for the SQL and PL/SQL test or do you have the Architecure and Administration SelfTest Software? Thanks, Ed -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of RyanSent: Thursday, August 14, 2003 9:24 PMTo: Multiple recipients of list ORACLE-LSubject: OCP Architecture question Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value?
Re: "union all" problems
Yes, this is a trace file that
contains
ORA-07445: exception encountered: core
dump...
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent: Thursday, July 31, 2003 3:39
PM
Subject: RE: "union all" problems
What does the trace file says on the server ??? do you see a ora-7445
trace file?
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this
email are strictly personal. QOTD:
Any clod can have facts, having an opinion is an art !
-Original Message-----From: Ed Lewis
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 2:59
PMTo: Multiple recipients of list ORACLE-LSubject:
"union all" problems
Hi,
We have a query which
uses
a "union all". After upgrading
to
a patch release of Oracle this
query
no longer works. We get the
following error :
ERROR at line 1:ORA-03113: end-of-file
on communication channel
ORA-24323: value not allowedError accessing package
DBMS_APPLICATION_INFOERROR:ORA-03114: not connected to ORACLE
I've searched metalink, but have been unsuccessful
finding a solution.
As a quick fix, we changed the "union all" to a "union",
and that worked.
We'll still like to find the root cause though.
The environment is AIX 4.3.3. It worked with
Oracle 8.1.7.2, but after upgrading to 8.1.7.4
we get this error.
Has anyone experienced this ? thanks.
ed
"union all" problems
Hi, We have a query which uses a "union all". After upgrading to a patch release of Oracle this query no longer works. We get the following error : ERROR at line 1:ORA-03113: end-of-file on communication channel ORA-24323: value not allowedError accessing package DBMS_APPLICATION_INFOERROR:ORA-03114: not connected to ORACLE I've searched metalink, but have been unsuccessful finding a solution. As a quick fix, we changed the "union all" to a "union", and that worked. We'll still like to find the root cause though. The environment is AIX 4.3.3. It worked with Oracle 8.1.7.2, but after upgrading to 8.1.7.4 we get this error. Has anyone experienced this ? thanks. ed
Re: Upgrade gotchas - 8.1.7.4->9.2.0.3 on Windows
Title: Upgrade gotchas - 8.1.7.4->9.2.0.3 on Windows Lisa, Just a follow-up question. I've set the ORA_SID_PFILE parameter in the registry, but do not use a password file. When I start up the database it looks for the PFILE in the default directory instead of the path specified in the registry. So, I'm required to provide the "pfile= " in my startup command, or place the "pfile" in the default directory. From what I understand, the value of ORA_SID_PFILE in the registry will be used at database startup automatically, so the "pfile = " parameter is not required. Is this correct ? I've checked metalink, but have been unsuccessful in finding a solution. thanks. ed - Original Message - From: Koivu, Lisa To: Multiple recipients of list ORACLE-L Sent: Wednesday, June 18, 2003 12:40 PM Subject: Upgrade gotchas - 8.1.7.4->9.2.0.3 on Windows Thought I'd let you know since a couple of people are planning upgrades to 9.2 on Windows (that I've heard from) - here's the gotchas I ran into with my upgrade. The databases were fine but other stuff broke, of course. After upgrading, there's crap left in the registry that refers to the older version of Oracle. Backup Exec doesn't like that. I had to delete the old oracle_home out of the registry and reboot. Suddenly all my backups were working. Of course I only run one oracle_home so I was able to remove this entry without consequence. Also, the install doesn't set the right path for SQLPATH: it sets it to a unix directory, \dbs. Once I changed it to OH\bin, my perl scripts were able to connect to sqlplus. They were failing before... It also doesn't set ORA_sid_PWFILE at all. This value needs to be there and be correct if you want to run startup without specifying the pfile on the command line. I'm not getting any emails from the list for some reason so I don't know if this will be well received... but I hope this helps at least one person. Lisa Koivu Oracle Database Stressmonkey Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN - Some basic Qs.
> Qs.4 Is it easy to integrate 3rd part tools like Legato etc with RMAN > for enabling taking of backups onto backup devices OR does it need an extensive setup ? I found it to be fairly easy to get RMAN working with Legato NetWorker. We had to go through a few hoops to get it working on a Veritas Cluster, but the problems were related to implementing Legato NetWorker on the cluster rather than the RMAN/Legato interface. The setup and configuration is well documented. -Original Message- Sent: Tuesday, April 01, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Qs.4 Is it easy to integrate 3rd part tools like Legato etc with RMAN for enabling taking of backups onto backup devices OR does it need an extensive setup ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ed Bittel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: veritas backup via RMAN troubles
Title: veritas backup via RMAN troubles I had a remarkably similar experience a few months ago with Legato NetWorker and performed all of the steps you listed with the same results. The problem turned out to be very simple. The SA installed the 64-bit version of the Legato Networker client because it is a 64-bit server. However, we were running a 32-bit version of Oracle on it. Installing the 32-bit client solved the problem. I am mentioning this since your post did not indicate if you are using 64-bit Oracle on that server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Testa, Joe Sent: Wednesday, March 26, 2003 1:04 PM To: Multiple recipients of list ORACLE-L Subject: veritas backup via RMAN troubles AIX 5.1, oracle 9ir2(9.2.0.1), veritas 4.5 followed instructions for installing veritas on disk, got the agent, did NOT relink oracle executable, but ran the oracle install script so the link from /usr/openv/netbackup/bin/libobk.a64 is linked to $ORACLE_HOME/lib/libobk.a Set(and unset multiple times), LIBPATH, LD_LIBRARY_PATH. Continue to get ORA-27211 Failed to load media management library. Been thru RMAN chapters multiple times, I'm totally out of ideas(and read every damn document on metalstink about this error). I've also tried to use the dummy MML library and that works fine. What the heck am I doing wrong? thanks, joe
RE: Oracle Performance Tuning Exam
Wow, I'm actually sending two messages in quick succession... The SQL test was extremely easy if you have any SQL experience in the "real world". I never understood why people said not to take it first, it was by far the easiest test of the five. There probably is no best test to take first. It varies by person. Best, Ed On Fri, 2003-02-28 at 10:45, DENNIS WILLIAMS wrote: > David - I haven't taken all the exams yet, but the advice I heard was not to > take the SQL exam first. On the surface it sounds easy, but it tends to be > more of a SQL trivia test. For most of us practicing DBAs, I heard that the > DBA exam tends to be the easiest, and is a good place to start and build > your confidence. Naturally I didn't do it that way, but from what I have > seen it is good advice. Depending on what you work with most, some exams may > be easier for you than others. Perhaps some on the list who have taken all 5 > can provide you more opinions. > > > > Dennis Williams > DBA, 40%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Thursday, February 27, 2003 2:20 PM > To: Multiple recipients of list ORACLE-L > > > > There are totally five exams we have to pass to get certified, I'd like to > know which exam should I take first and what next in order? > > > > Thanks, > > David > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i OCP Upgrade Exam - Again
I took this 4-5 months ago and passed with a 97%, so it's not impossible. It was about twice as hard as any of the 8i tests. It covers a huge amount of material, and it assumes you have knowledge of many things that were NOT on the 8i certification objectives. I think I studied about three weeks in my spare time. You will want the Benjamin book. To me the inaccuracies in the certification books have always jumped out and been obvious, so I wouldn't worry about it much. Also, the STS practice test was very useful. Best of luck, Ed On Mon, 2003-03-03 at 15:24, [EMAIL PROTECTED] wrote: > I don't worry about knowing too much about Oracle. At the same time I > am worried about maximizing my time as time has an opportunity cost - > I have heard that the Benjamin book is incorrect in places. I think > Robert's book, the self-tests and Metalink, Oracle Docs for > clarification works for me. I also have the basic OCP 9i exam kit > (not upgrade). > > -Original Message- > From: M Rafiq [mailto:[EMAIL PROTECTED] > Sent: Monday, March 03, 2003 3:19 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: 9i OCP Upgrade Exam - Again > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBArtisan
Suzy, We use it here, but only for Oracle. I highly recommend it. It's very useful for everyday tasks, for reverse-engineering database objects, as well as other things. The support has also been good. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, March 03, 2003 10:08 AM > > Anyone using DBArtisan? Any good/bad feedback about this product? > Someone in our office is looking at the Cross-Platform version that > works with Oracle, Sybase and MSSQL. > > Thanks, > Suzy > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Suzy Vordos > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ed Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Skipping a table on import (Using FGAC)
Suggestion: Investigate using FGAC.
I just spent part of my day working on a solution to a very similar problem.
I wanted to do a user level export but restrict the records from one table
based on the value of a timestamp field. I did not want to have multiple
exports. I originally considered a combination of tablespace and table
level exports, but it made the nightly import process rather difficult to
perform the way I would like.
The solution I settled on was to use Oracle's fine-grained access control
(FGAC). This feature has been available since 8i. I found FGAC a bit
difficult to get my head around, but I had no problems after I worked
through the example. I got the idea from Metalink DOC_ID: 162914.1 which
explains how to use FGAC to skip a table during an export. I also referred
to the Application Developer's Guide documentation.
The effect of the FAGC I implemented is restrict which records the EXPORT
user can see in a table. This effects only the EXPORT user. All other
users see all of the records.
RECORD COUNT ISSUED RUN AS ME (I SEE ALL RECORDS)
SQL> select count(*) from bigjet.message;
COUNT(*)
--
342559
Export run as user EXPORT (HE SEES FILTERED RECORDS)
exp export/freewilly@WHALEJET file=test.dmp tables=bigjet.message
About to export specified tables via Conventional Path ...
Current user changed to BIGJET
EXP-00079: Data in table "MESSAGE" is protected. Conventional path may only
be exporting partial table.
. . exporting tableMESSAGE 52445 rows exported
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
The basic steps I followed are listed below.
/
CREATE Function to return predicate
used to filter records for the EXPORT user
/
CREATE OR REPLACE FUNCTION export.export_message(obj_schema varchar2,
obj_name varchar2)
RETURN VARCHAR2 IS d_predicate VARCHAR2(2000);
BEGIN
IF sys_context('USERENV','SESSION_USER')='EXPORT' THEN
d_predicate := 'SYS_LAST_CHANGED_TS > TRUNC(SYSDATE-2) ';
ELSE
d_predicate := '';
END IF;
RETURN d_predicate;
END export_message;
/
/
CREATE FGAC Policy Group
/
EXECUTE DBMS_RLS.CREATE_POLICY_GROUP('BIGJET','MESSAGE','MESSAGE_GROUP');
/
CREATE FGAC Policy in the Policy Group
/
EXECUTE
DBMS_RLS.ADD_GROUPED_POLICY('BIGJET','MESSAGE','MESSAGE_GROUP','EXPORT_POL',
'EXPORT','EXPORT_MESSAGE');
/
ENABLE FGAC Policy
/
EXECUTE DBMS_RLS.ENABLE_GROUPED_POLICY
('BIGJET','MESSAGE','MESSAGE_GROUP','EXPORT_POL',TRUE);
/
DISABLE FGAC Policy
/
EXECUTE DBMS_RLS.ENABLE_GROUPED_POLICY
('BIGJET','MESSAGE','MESSAGE_GROUP','EXPORT_POL',FALSE);
> -Original Message-
> Is there a
> way to skip
> certain tables during an import?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ed Bittel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RMAN: delete archivelog... backed up 1 times to tape
I am trying to use the DELETE ARCHIVELOG command that is available in version 9.2.0.1. The complete syntax I wish to use is this command: RMAN>delete archivelog until time 'trunc(sysdate)-2' backed up 1 times to tape; I have tried this as part of a backup script and as a standalone command after allocating a maintenance channel, but it doesn't work. Furthermore, this command DOES NOT return records: RMAN> list archivelog all backed up 1 times to tape; But this command DOES return records: RMAN> list archivelog all backed up 0 times to tape; I know I have backups of archivelogs on tape because they are reported when I issue this command: RMAN> list backup of archivelog from time 'sysdate-3' device type sbt; Does anyone know what is going on here? Thanks, Ed / RDBMS Version: 9.2.0.1 OS: Sun Solaris 8 Product: RMAN (9.2.0.1) */ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ed Bittel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Hot Backups or RMAN
I'm sure this topic has come up before. I don't need to know the difference between these backup methods. I am more curious about which is preferred. >From what I can tell, I'd be a fool not to use RMAN whenever possible. What experiences have you all had with these in production environments? Best, Ed . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Lisa, We've been using timed_statistics=true at our site for over a year, without any problems. ed - Original Message - From: Koivu, Lisa To: Multiple recipients of list ORACLE-L Sent: Thursday, February 06, 2003 9:23 AM Subject: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Good morning everyone - Quick poll for those of you on 8.1.7 and AIX 4.3.3: Do you have TIMED_STATISTICS = true? Have you encountered any problems with it? The databases I inherited have this set false all over the place, hence my tuning efforts are really limited. However I don't want to change it without checking around first. And a tuning question: This environment (peoplesoft) is very very low on memory. When the app servers and databases are up there's less than 50MB of memory free. Adding hardware is not a choice here. The databases have 100MB set for the SGA. It really looks like not much thought went into some of the parm settings. What I've read about tuning says that you must have a goal in mind. Well, afaik nothing is "broken", nothing is suffering - then again, no one really paid much attention to Oracle. It was up, fine, move on. Am I on the wrong path if my goal for tuning is to figure out if I can reduce the size of the SGA and redo logs without adversely affecting performance? Any comments are appreciated. Thanks everyone Lisa Koivu Oracle Dingbat Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459
Size of a Long Field
How do you determine the size, in bytes, of a long field? Please. No tape measure jokes. Ed
Re: Re:Resource Management
Dick,
Which version of Oracle ?
Was your test with 2 different user ID's ?
Our problem is that all users log on
with the same user id, which seems
to diminish the product's effectiveness.
thanks.
ed
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 18, 2002 12:54 PM
> Kirti,
>
> I've toyed with the product due to a perceived need here. The
experiment
> was to have two users loggin to the database both running very nasty
queries (we
> have the GOD of obfuscated SQL here). On the first pass, with no resource
> management in place both queries ran successfully in 30 minutes but boy
did the
> server take a hit (4 processors with < 10% idle across them). On the
second
> pass we put resource management in place for one user really clamping down
on
> it. The first user's query completed in 10 minutes where as the second
user
> took 45 minutes to complete and the server didn't even break a sweat (one
> processor was 100% idle throughout). I'd like to do more with it, but
> PeopleSoft does things in a way the precludes resource manager from being
> effective.
>
> Dick Goulet
>
> Reply Separator
> Author: "Deshpande; Kirti" <[EMAIL PROTECTED]>
> Date: 10/18/2002 8:00 AM
>
> Hello Listers,
>
> Anyone using Oracle's Database Resource Manager?
> Does it really work as outlined in the Docs?
> Care to share your experience?
>
> Thanks,
>
> - Kirti
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ed Lewis
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Re:RE: Re[2]: controlling CPU usage through Oracle
Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle Tony, No, as of now it does not have that functionality. Thanks for your input. ed - Original Message - From: Aponte, Tony To: Multiple recipients of list ORACLE-L Sent: Thursday, August 29, 2002 1:33 PM Subject: RE: Re:RE: Re[2]: controlling CPU usage through Oracle Just some thoughts. Does your OS have any domain partitioning features that you can use to create separate "servers"? You could carve out a portion of the CPU resources into a small domain and dedicate it to your problem child. The net effect would be to throttle the problem database by denying it the resources used by the others. How about using processor sets do achieve the same thing. I'm thinking along the lines of two sets, one with a very low number of CPU's. You would then bind your problem child to the small set and the rest to the other. HTH Tony Aponte
Re: Re:RE: Re[2]: controlling CPU usage through Oracle
Dick and Dennis,
The application here is the same, where all
users are logged in as the same user via
the application server.
But in my case, I want to throttle all the
users who use this id. Wouldn't ORM be beneficial in that
situation ? thanks.
ed
> Dennis,
>
> You've got that right. Damned PeopleSoft! We were hoping we might be
able
> to leverage ORM to control PeopleSorft query users. No such luck since
everyone
> is PeopleSoft. Now on the other hand, if you've got the LUXURY of having
people
> logged in with their own usernames you certainly can throttle down those
you
> want, almost to a crawl.
>
dick goulet
> Dick - My understanding is that Oracle Resource Manager controls resources
> based on userid. In other words, if a third-party application or an
> application server uses the same Oracle userid for access, then Oracle
> Resource Manager wouldn't help much. Is that what you've seen?
> Dennis Williams
> DBA
> Lifetouch, Inc.
>
> Ed,
>
> The only way your going to do this is through Oracle Resource Manager.
> You'll need an 8.1.x Enterprise database. Then you can setup your
resource
> plans and groups to manage who gets how much CPU at a time. Any of the
> operating level tools out there cannot get down to the level of
granularity
> your
> asking for since all of the activity happens within Oracle. All those
tools
> can
> do is control the amount of CPU that Oracle gets which has a global effect
> that
> hampers all users of the database.
>
> Dick Goulet
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ed Lewis
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Re[2]: controlling CPU usage through Oracle
Kevin, Thanks for your input. Just to clarify; I only want to control this one database. I want to limit its resources so it does not impact the other 4 databases on the box. So, in that case would resource manager be beneficial ? Also, besides profiles, and resource manager, does anyone know of any other tools provided by Oracle which would limit resources ? Or, any 3rd party tools that my be beneficial ? I thank everyone for providing their input; it's much appreciated. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 28, 2002 5:23 PM I don't think Resource Manager is going to do the trick here (I just read about it over the last week while preparing for OCP exam 4). Resource Manager would work great for a single database but Ed is trying to divvy up resources between 5 databases. I don't have any good solution. I suppose if everything running on this one database was less important than anything on the other 4 databases, you could renice the one database. I think that would be ok provided all components of the one database were at the same nice level. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Wednesday, August 28, 2002 9:52 AM To: Multiple recipients of list ORACLE-L -Original Message- From: Ed Lewis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 4:18 PM To: Multiple recipients of list ORACLE-L Subject: controlling CPU usage through Oracle Hi, I'm looking for a way to control CPU usage of particular queries on a database. After exploring, and implementing ways of optimizing the code, these queries can run anywhere from 45 seconds to 2 minutes. This database is 1 of 5 on this box. So, although it's important to build effective queries, it's also important in this environment that these queries do not impact the other 4 databases. What I want to do is place a limit on CPU usage without terminating the query. I've looked at profiles with the "cpu_per_call" and "cpu_per_session" settings. I have never used profiles, but from what I understand, these will kill the session once they reach a threshold. I'm also looking at database resource management. This may be more appropriate for this situation. Has anyone used this, and if so what are you experiences ? Would you recommend it ? Would the only way to control CPU usage on this box, be through the operating system ? I welcome any suggestions. I appreciate your time. The environment is Oracle 8.1.7.2, AIX 4.3.3. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman question(allocating channels)
Joe, I have the same situation. I my case I used 2 channels, and so around a 25-30% decrease in the backup time for a 30gb database. Once I increased it to 3 channels the payback was minimal. It also became very cpu intensive, so I kept the setting at 2. - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 28, 2002 8:38 AM Subject: rman question(allocating channels) I've tried to find this in the docs to no avail. If I'm writing out an RMAN backup to one disk(yes this is not ideal), then does it make sense to allocate multiple channels? Are multiple channels related to CPUs or to destinations? thanks, joe
Re: controlling CPU usage through Oracle
Raj, Thanks for your input. From what I understand with profiles, the session will be terminated once a threshold is reached. In this particular case, I cannot terminate the session. I need to be able to control the CPU usage of a session, without ending it. If this cannot be done within Oracle, then maybe it can be accomplished through the OS. thanks. ed - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 27, 2002 4:48 PM Subject: RE: controlling CPU usage through Oracle You could use profiles to control CPU usage as well, more info is in manuals. 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: Ed Lewis [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 27, 2002 4:18 PMTo: Multiple recipients of list ORACLE-LSubject: controlling CPU usage through Oracle Hi, I'm looking for a way to control CPU usage of particular queries on a database. After exploring, and implementing ways of optimizing the code, these queries can run anywhere from 45 seconds to 2 minutes. This database is 1 of 5 on this box. So, although it's important to build effective queries, it's also important in this environment that these queries do not impact the other 4 databases. What I want to do is place a limit on CPU usage without terminating the query. I've looked at profiles with the "cpu_per_call" and "cpu_per_session" settings. I have never used profiles, but from what I understand, these will kill the session once they reach a threshold. I'm also looking at database resource management. This may be more appropriate for this situation. Has anyone used this, and if so what are you experiences ? Would you recommend it ? Would the only way to control CPU usage on this box, be through the operating system ? I welcome any suggestions. I appreciate your time. The environment is Oracle 8.1.7.2, AIX 4.3.3.
controlling CPU usage through Oracle
Hi, I'm looking for a way to control CPU usage of particular queries on a database. After exploring, and implementing ways of optimizing the code, these queries can run anywhere from 45 seconds to 2 minutes. This database is 1 of 5 on this box. So, although it's important to build effective queries, it's also important in this environment that these queries do not impact the other 4 databases. What I want to do is place a limit on CPU usage without terminating the query. I've looked at profiles with the "cpu_per_call" and "cpu_per_session" settings. I have never used profiles, but from what I understand, these will kill the session once they reach a threshold. I'm also looking at database resource management. This may be more appropriate for this situation. Has anyone used this, and if so what are you experiences ? Would you recommend it ? Would the only way to control CPU usage on this box, be through the operating system ? I welcome any suggestions. I appreciate your time. The environment is Oracle 8.1.7.2, AIX 4.3.3.
General Replication question
I'm curious, based on a discussion I had with a DBA here at work, how many people use the replication features of Oracle. I often see replication listed as one of the selling points of Oracle, but it's also very hard to get a class on replication because they are always closing classes for poor registration. How common is replication (basic or advanced)? It makes more sense to use simple snapshots than DB links for what we are doing, but given that our support from Oracle has been TERRIBLE with snapshot problems, I now wonder if anyone uses them. We are switching to db links, but that can pose potential performance issues with, for example, joins across the db link. Best, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
export with "first rows"
Hello, We have the optimizer mode set to "first rows" on our (25gb) database to meet a vendor requirement. When I do an "direct" export, it runs for 6-7 hours. When I change the optimizer mode to "choose" it runs in around an hour. It also runs in an hour when I set the the optimizer mode to "first rows", and run stats on the "sys" schema. I'm curious why this occurs. Has anyone experienced this ? Any ideas why this happens ? Is this normal behavior ? I could not find anything on metalink. thanks. Oracle 8.1.7.2, aix 4.3.3. ed
visual workbench problem
Hello, I'm installing "Oracle's Visual Workbench for Oracle Procedural gateways for IBM Mqseries" version 8.0.4.1.0 on W2k. (that's a mouthful) When I run the program I get the following error : "error while connecting to the repository, protocol violation" I searched metalink for a solution, and one recommendation was to replace the "class111.zip" from the install, with the 8.1.7 version of the same file. After doing that, I ran the program and got the following : "the database has no (compatible) repository installed. Do you want to install/upgrade a repository ? " At this point I was not allowed to respond; the response was "greyed-out". The repository though is created and is running on AIX, Oracle 8.1.7.2. I was also able to connect to the repository from my client using sqlplus. Any help is appreciated. thanks. ed
Load Testing Help Needed
Can anyone recommend and low cost tool(s) for load testing a database server? I looked at Quest's Benchmark Factory, but it doesn't provide the flexibility I need in this situation I'm facing The $15K I was quoted for the Quest tool is a bit pricey, so I don't believe more expensive tools (e.g., Load Runner) are viable candidates. Here's what I have to work with: I will have a log file from our mid tier server that will contain all the SQL generated by the application. However, since the system is not in production, I will be limited to using a single user or small group to simulate use of the application. Therefore, I will have to find a way to scale the limited capture to production-like levels and substitute values for transactions and queries. Can anyone recommend a tool(s) that would allow me to 1) automate substitution of values in WHERE clauses and INSERT/UPDATE statements and 2) perform load testing using ascii files as the input? TIA for your help, Ed _ 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: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Bug, tuning issue or bad sql?
Oracle 8.1.6.0 NT 4.0 I'm having a problem with a query which is basically just a bunch of UNION ALL's that I want sorted in a certain way. The query runs flawlessly when I limit the result set with a where clause, but when I remove it, the query crashes when sorting (in the order by at the far bottom). If I remove the ORDER BY, the query runs beautifully. The max rows returned by this is about 12,000. I am confident that the values returned are consistant across each of the UNION's. Here's the error returned: trans_demographic td * ERROR at line 257: ORA-00600: internal error code, arguments: [5213], [], [], [], [], [], [], [] In other words: 1. Query runs with no ORDER BY. 2. Query runs with ORDER BY, when limiting rows returned. 3. When limiting rows returned, I can use any value in the full range (in this case poe_assoc_id), and everything works as long as the total rows returned are less than around 3,000. I have tested every range of data, and I can use any set of valid values as long as I do it in pieces. So my question is: is the sql bad somehow (I don't think so). Is this a tuning issue on the database itself? Is this a bug in 8.1.6.0? Thanks in advance! Ed P.S. Here's the big ole query: select ae_email_addr, ae_assoc_id, poe_assoc_id, table_type, poe, adds, changes, drops, ae_name from (select a.assoc_id poe_assoc_id, a.poe poe, 'Member' table_type, SUM(DECODE(tm.record_change_type,'A',1,0)) adds, SUM(DECODE(tm.record_change_type,'C',1,0)) + SUM(DECODE(tm.record_change_type,'T',1,0)) changes, SUM(DECODE(tm.record_change_type,'D',1,0)) drops, a.ae_email_addr ae_email_addr, a.ae_name ae_name, a.ae_assoc_id ae_assoc_id from(select a.assoc_id, poe_am.mem_id poe, ae_m.first_name||' '||ae_m.last_name ae_name, ae_am.assoc_id ae_assoc_id, NVL(ae_m.email_addr,'[EMAIL PROTECTED]') ae_email_addr from ASSOCIATION a, ASSOCIATION_MEMBER poe_am, MEMBER poe_m, ASSOCIATION_MEMBER ae_am, MEMBER ae_m where a.assoc_type = 'L' anda.assoc_status_cd = 'A' anda.assoc_id = poe_am.assoc_id andpoe_am.relation_type = 'POE' andpoe_am.mem_id = poe_m.mem_id andpoe_m.primary_assoc_id = ae_am.assoc_id andae_am.relation_type = 'EO_ID' andae_am.mem_id = ae_m.mem_id) a, TRANS_MEMBER tm wherea.assoc_id = tm.primary_assoc_id(+) and a.poe = tm.sender_id(+) and tm.last_changed_dt(+) BETWEEN '01-JUN-2001' AND '30-JUN-2001' GROUP BY a.assoc_id, a.poe, a.ae_email_addr, a.ae_name, a.ae_assoc_id UNION ALL SELECT a.assoc_id poe_assoc_id, a.poe poe, 'Member Supplemental' table_type, SUM(DECODE(tms.record_change_type,'A',1,0)) adds, SUM(DECODE(tms.record_change_type,'C',1,0)) changes, SUM(DECODE(tms.record_change_type,'D',1,0)) drops, a.ae_email_addr ae_email_addr, a.ae_name ae_name, a.ae_assoc_id ae_assoc_id FROM(select a.assoc_id, poe_am.mem_id poe, ae_m.first_name||' '||ae_m.last_name ae_name, ae_am.assoc_id ae_assoc_id, NVL(ae_m.email_addr,'[EMAIL PROTECTED]') ae_email_addr from ASSOCIATION a, ASSOCIATION_MEMBER poe_am, MEMBER poe_m, ASSOCIATION_MEMBER ae_am, MEMBER ae_m where a.assoc_type = 'L' anda.assoc_status_cd = 'A' anda.assoc_id = poe_am.assoc_id andpoe_am.relation_type = 'POE' andpoe_am.mem_id = poe_m.mem_id andpoe_m.primary_assoc_id = ae_am.assoc_id andae_am.relation_type = 'EO_ID' andae_am.mem_id = ae_m.mem_id) a, trans_member_supplemental tms WHEREa.assoc_id = tms.assoc_id(+) AND a.poe = tms.sender_id(+) and tms.last_changed_dt(+) BETWEEN '01-JUN-2001' AND '30-JUN-2001' GROUP BY a.assoc_id, a.poe, a.ae_email_addr, a.ae_name, a.ae_assoc_id UNION ALL SELECT a.assoc_id poe_assoc_id, a.poe poe, 'Office' table_type, SUM(DECODE(tof.record_change_type,'A',1,0)) adds, SUM(DECODE(tof.record_change_type,'C',1,0)) + SUM(DECODE(tof.record_change_type,'T',1,0)) changes, SUM(DECODE(tof.record_change_type,'D',1,0))
DLL question
Okay, I can't find where this is documented. What .dll corresponds to ora805.dll in 8.1.6? Better yet, where is that documented? Best, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN-20202 error while recovery
Have you tried removing the "" from around the tablespace name?
Sona wrote:
> Hi
> i am trying to recover the database from the loss of SYSTEM datafile.
> After mounting the database ,I tried recovery using RMAN
> RMAN> run
> 2> {
>3> allocate channel c1 type disk ;
> 4> restore tablespace "system";
> 5> recover tablespace "system";
> 6> sql 'alter database open';
> 7> release channel c1;
> 8> }
>
> I have a Incremental level 0 backup and also a incremental level 1 database
> backup.
> i got the following error while recpovering
> RMAN-03022: compiling command: allocate
> RMAN-03023: executing command: allocate
> RMAN-08030: allocated channel: c1
>RMAN-08500: channel c1: sid=11 devtype=DISK
>
> RMAN-03022: compiling command: restore
> RMAN-03025: performing implicit partial resync of recovery catalog
>
>>RMAN-03023: executing command: partial resync
>>RMAN-08003: starting partial resync of recovery catalog
>>RMAN-08005: partial resync complete
>>
>>RMAN-03022: compiling command: IRESTORE
>>RMAN-03026: error recovery releasing channel resources
>>RMAN-08031: released channel: c1
>>RMAN-00571: ===
>>RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
>>RMAN-00571: ===
>>RMAN-03002: failure during compilation of command
>>RMAN-03013: command type: restore
>>RMAN-03002: failure during compilation of command
>>RMAN-03013: command type: IRESTORE
>>RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202:
>>tablespace not found in the recovery catalog
>>RMAN-06019: could not translate tablespace name "system"
>>
>Any ideas why this error occurs
>The intersting thing is that if i use "recover datafile" ,the recovery goes
> thru.
>
>TIA
>
_
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: Ed
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Recovery scenario query
We use Rman with Legato Netwoker. Once we got Legato Networker set up correctly, it was pretty straight forward from the Rman side of the fence. We use networker to schedule the jobs. That adds some complexity to the setup, but it's pretty well documented. I added some script trickery that I found on metalink to avoid having the username and password for the rman user from being written to the log files. You can also run your jobs manually or from cron if you desire. Now, we had a good deal of difficulty getting Legato Networker to play nice with our Veritas cluster, but that is a story for the Unix admin to tell. The RMAN interface is pretty straight forward if you take the time to read the NetWorker Module for Oracle Administration Guide . Gene Sais wrote: >Speaking of Rman, has anyone used it directly interfaced w/ Legato networker? I have >to park my trusty scripts and learn Rman w/ Legato. Any gotchas I should be aware >of. I know to keep a sep schema for each Oracle version, anything else? Reason for >this is that I have a 1tb db of blobs and I need to do incremental backups and I >understand Rman is the tool. Thanks for any insight on these products. > >Gene > >>>>[EMAIL PROTECTED] 01/11/02 03:20PM >>> >>>> >Instead of writing a fancy backup script, why not learn and use Rman? It >does everything that is needed - backup, removal of archivelog files, easily >restore to any point in time. > >a real no-brainer. > >Tom Mercadante >Oracle Certified Professional > _ 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: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Veritas Quick IO & Oracle Performance
I was asked to evaluate the potential benefit of using Veritas Quick I/O for one of our databases. I put together some simple tests to gauge the expected impact of Veritas Quick I/O on Oracle performance. The tests were designed so that the only variable when running the test scripts was type of datafile the scripts were reading from or writing to (i.e., Quick I/O or non-Quick I/O). The results of the tests were very surprising. Only the performance of large DDL operations, such as copying tables and creating indexes, was significantly improved after implementing Veritas Quick I/O for an Oracle datafile. Performance of DML operations ranged from marginally improved to markedly worse after implementing Veritas Quick I/O for an Oracle datafile. Large selects were particularly poor performing with Quick IO. Are these results typical? Are there any issue I should be aware of? We're running Oracle 8.1.6.3 on Solaris with Veritas Database Edition for Oracle 2.1.1. TIA, Ed __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Bittel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Resend: Re: unused blocks BELOW HWM - Thanks
This is a GREAT idea. Ed > On Wednesday 19 December 2001 00:15, Hallas John wrote: > > I agree with your reasoning Dennis. I have long felt that one of the > > problems with the list is that the original raiser of the question should > > have some sort of responsibility for summarising the various responses and > > posting a short summarised reply showing the solutions(s) that worked for > > him/her > > This type of question where various solutions were proposed is the ideal > > candidate for this type of summarised response. I used to be on a Unix list > > and that strategy was used quite well there. > > > > John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Revert from 8.1.6 to 8.0.5
Thanks all. Everything worked perfectly for us (we weren't using any 8i features yet). I didn't realize the migration guide had a downgrade section, but we didn't need it anyways! Best, Ed - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 18, 2001 9:20 PM > > Check out the Chapter on downgrading in the 8i Migration manual > The 8.1.6 manual pages are still online at > http://otn.oracle.com/doc/oracle8i_816/server.816/a76957/migdowng.htm#15124 > > You need to remove whatever 8i features you may have implemented that are > not available in 8.0.5 > Depending on what changes you may have made, you may or may not be able to > downgrade. Try > the downgrade on reviewing the doc. It would be faster than rebuilding the > database (unless the upgrade > from 8.0.5 to 8.1.6 was itself a rebuild !!). > > > Hemant K Chitale > Principal DBA > Chartered Semiconductor Manufacturing Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Revert from 8.1.6 to 8.0.5
Looks like we have to revert an 8.1.6 database that was upgraded over the weekend back to 8.0.5, but we need to export/import so we don't lose data from the last 2 days. Anything I need to know? The plan is to export using the 8.0.5 export utility before importing back into 8.0.5. Does this make sense? Thanks, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OCP
Just finished this a few months ago. My advice is to use the Oracle Exam Guide, Sybex Exam Guides, and Exam Cram as a third choice, but get the other two first. The ExamCram has much more detail, but does not explain concepts well. The STS (selftestsoftware.com) practice tests are really very good. I only used one, but it was done very well. I passed all tests on the first try with an average of about 90%. The actual tests are MUCH harder than the practice tests in the study guides (any of them). Also note, you not only need to study, but also TRY things. I installed Oracle on Linux at home and tinkered to my heart's content. Make sure you understand the DBA and V$ views or you won't pass. Best of luck, Ed - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 4:40 AM > Hi > > I have been a DBA for a few years now, I am consdering doing the OCP exams > > I have bought the Oracle 8i DBA certification Exam Guide. > > However I have been informed by a fellow DBA that he bought the same book, > studied it and took the practice tests and was getting around 90% in > these tests.. however when he came to doing the actual he just failed ! > > Does anyone have any thoughts on this ? > > Also is it possible to get mock exams that are more reflective of the > actual exams , from anywhere > > Regards > > Saj > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sajid Iqbal > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Has anyone heard of "Mirror Accessible"?
The Logical Standby Database is listed in Oracle 9i's "New Features" documentation on Technet, but there is nothing about it in the actual Data Guard manual that I have found. Maybe it is a 9.0.2 feature as someone else already indicated. Best, Ed - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, December 01, 2001 9:35 PM > AFAIK, 9iDataGuard in the current release is only a Physical Standby > database > (not "logical standby database"). This is similar to 8i except for the > fact that, if you > ensure that you do a clean failover-and-failback (ie have the controlfiles > and > online redo log files available) you can actually switch to and from the > standby. > > Never tried it and wouldn't try it till 9.0.2 (at the minimum) > > Hemant > > > > "Miller, Jay" <[EMAIL PROTECTED]>01/12/2001 05:45 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: Has anyone heard of "Mirror Accessible"? > > > > > > > > > Can anyone confirm this? I've been searching technet and metalink and > can't > turn up any details. > > -Original Message- > Sent: Friday, November 30, 2001 3:01 PM > To: Multiple recipients of list ORACLE-L > > > Isn't that just in release 2 though? My understanding is that its not out > yet. > > -Original Message- > Sent: Friday, November 30, 2001 11:36 AM > To: Multiple recipients of list ORACLE-L > > > Ah, this sounds likely. And it might explain why they were keen on having > us upgrade to 9i. That's the problem with receiving the request filtered > through two additional levels of people. > > Jay Miller > > -Original Message- > Sent: Friday, November 30, 2001 1:56 PM > To: Multiple recipients of list ORACLE-L > > > 9i has a new feature on standby databases that let's you run reports in > read > only while continuing the managed recovery. I think they call it a logical > standby database. See the 9i DataGuard manual for more information. (I > just happened to be looking into this lately). This might be what they are > talking about. > > Best, > > Ed > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, November 30, 2001 12:05 PM > > > > Only thing I can think of off the top of my head is a standby database > > opened in read only mode. Its one of the purposes totted for that > > > > -Original Message- > > Sent: Friday, November 30, 2001 9:47 AM > > To: Multiple recipients of list ORACLE-L > > > > > > My CIO woes continue. My manager has been told by the CIO that Oracle has > a > > product called "mirror accessible" which allows the database to be > mirrored > > for reporting purposes. He wants us to use this product. > > > > Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby > > and Oracle Replication but he says it isn't any of these. Any idea what > he > > might be talking about? > > > > Jay Miller > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Miller, Jay > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Kimberly Smith > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru'
Re: Has anyone heard of "Mirror Accessible"?
9i has a new feature on standby databases that let's you run reports in read only while continuing the managed recovery. I think they call it a logical standby database. See the 9i DataGuard manual for more information. (I just happened to be looking into this lately). This might be what they are talking about. Best, Ed - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, November 30, 2001 12:05 PM > Only thing I can think of off the top of my head is a standby database > opened in read only mode. Its one of the purposes totted for that > > -Original Message- > Sent: Friday, November 30, 2001 9:47 AM > To: Multiple recipients of list ORACLE-L > > > My CIO woes continue. My manager has been told by the CIO that Oracle has a > product called "mirror accessible" which allows the database to be mirrored > for reporting purposes. He wants us to use this product. > > Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby > and Oracle Replication but he says it isn't any of these. Any idea what he > might be talking about? > > Jay Miller > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kimberly Smith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Standby Database
Ditto this. Pretty much exactly what I suspected, but I was certain someone here had dealt with this already and might have better insight. Thanks, Ed - Original Message - > Excellent post Don! > > This one's going straight in to my "special" folder :P -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Standby Database
Quick question. Is it a fair statement to say that using Oracle's hot standby database allows you recoverability up to the last archive log, but would NOT recover to the latest redo log (prior to a log switch). In other words, the potential to lose transactions is very high if you depend on this for failover (not good for e-commerce type databases). Would it be possible to somehow mirror redo logs across to the failover server and apply them when activating the standby database, or is the only real solution clustering or something like DoubleTake? Am I making sense? Thanks, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: For You Telnet Experts
Assuming this is Unix of some kind: Are the binaries (svrmgrl/sqlplus) in your path ($ORACLE_HOME/bin) and environmental variables set (ie. $ORACLE_HOME)? Is the telnetd daemon running to receive telnet requests (ps -ef | grep "telnetd")? Problems connecting with telnet and using svrmgrl or sqlplus from the console are unrelated (separate issues). Best, Ed - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 8:10 AM > I cannot get svrmgrl to run at the Command Prompt or sql*plus prompt. I > keep getting an error - unrecognized command. When I try to get Telnet to > connect to the server it won't. Could this be the problem of why svrmgrl > won't work? I need svrmgrl to run my "cat" scripts. > > Thanks, > Ken Janusz, CPIM > Database Conversion Lead > Sufficient System, 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: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrade 8.0.5 to 8.1.6
Sheesh, glad you pointed this out. -Original Message- Baker Sent: Wednesday, November 21, 2001 9:50 PM To: Multiple recipients of list ORACLE-L Ed: If you choose to upgrade your database from 8.0.5 to 8.1.6, there's a potential difficulty you need to know about. If you're not aware of the dictionary corruption problem, be sure you read the metalink alert (96117.1). This has something to do with block checking enabled in 8.1.6 Essentially, you need to analyze all your system tables to insure no corruption has been introduced. If you have any problem finding the info on metalink, take a look at the Tim Gorman's web site (www.evdbt.com). He has some info about it under "downloads". Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrade 8.0.5 to 8.1.6
Thanks all. Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrade 8.0.5 to 8.1.6
Yes, I agree 100%, but people here are concerned that upgrading will "break" the database, and we have to QUICKLY move everything over to 8.1.6. (Long story). What I was really after in my original question was: why is the upgrade script a better solution than just recreating the tablespaces in 8.1.6 and importing from an export of the old database? Does it just save time? Is there a downside to using export/import this way? Best! Ed -Original Message- Thapliyal Sent: Wednesday, November 21, 2001 12:20 PM To: Multiple recipients of list ORACLE-L Ed, the whole point of compatable is to mimick behaviour of an older release .. like optimizer plans etc. upgrading the db would be the way to go for this.. like many have already pointed out Deepak --- Ed <[EMAIL PROTECTED]> wrote: > A DBA here is trying to upgrade several 8.0.5 > databases to 8.1.6 > by using export/import. This will probably work, > but wouldn't it be > easier to just do a cold backup and open them using > the > COMPATIBLE parameter in the 8.1.6 environment? Is > there > any downside to using export/import? (ie. will it > affect snapshots, > db links, etc...). > > I thought the whole point of the compatible > parameter was that > it let you open up an older database with no > questions asked. > Then you could run any of the upgrade .sql scripts > at your leisure, > yes? > > Best, > > Ed > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Ed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrade 8.0.5 to 8.1.6
That's exactly what I was saying I think. ie. To quickly move 8.0.5 to 8.1.6, set compatible and everything should run without doing anything else (including the u*.sql script). You can run migration later if you need new features of 8.1.6. Reasonable statement? Best, Ed -Original Message- Sent: Wednesday, November 21, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Ed, COMPATIBLE is there to allow backwards compatibility. If you upgrade from 8.0.5 to 8.1.6 and set COMPATIBLE=8.0.5 in your init.ora, new features will not be turned on, allowing an easier port back to 8.0.5 if necessary. Quoting from Oracle8i Reference Release: "COMPATIBLE lets you use a new release, while at teh same time guaranteeing backward compatibility with an earlier release... This parameter specifies the release with which the Oracle server must maintain compatiibility. It allows you to take advantage of the maintenance imporvements of a new release immediately in you production systems without testing the new functionality in your environment." Henry -Original Message- Sent: Wednesday, November 21, 2001 9:30 AM To: Multiple recipients of list ORACLE-L When I read through Oracle's migration info it looks to me like all init ora params from 8.0.5 are supported, though obsolete, in 8.1.6. What is the point of the "compatible" parameter then if you have to run the conversion script on the database? Thanks for answering. Best, Ed On Wed, 21 Nov 2001, Adams, Matthew (GEA, 088130) wrote: > Ed, > > There's more to it than just setting the > COMPATIBLE parameter. The basic steps > are > > 1) install new 8.1.6 executables > 2) copy init.ora file from old 8.0.5 home to 8.1.6 home, > making whatever modifications are necessary due to > new or obsoleted parameters > 3) startup database > 4) run u0800050.sql as sys. This modifies internal Oracle objects > to new forms needed by 8.1.6 software. Once this is done, NEVER > open the database using the old version, as it can corrupt the database. > > > Matt Adams - GE Appliances - [EMAIL PROTECTED] > "Doing linear scans over an associative array is like > trying to club someone to death with a loaded Uzi." > - Larry Wall (creator of Perl) > > > -Original Message- > > From: Ed [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, November 20, 2001 6:00 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Upgrade 8.0.5 to 8.1.6 > > > > > > A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6 > > by using export/import. This will probably work, but wouldn't it be > > easier to just do a cold backup and open them using the > > COMPATIBLE parameter in the 8.1.6 environment? Is there > > any downside to using export/import? (ie. will it affect snapshots, > > db links, etc...). > > > > I thought the whole point of the compatible parameter was that > > it let you open up an older database with no questions asked. > > Then you could run any of the upgrade .sql scripts at your leisure, > > yes? > > > > Best, > > > > Ed > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ed > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mr. Clark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- P
Upgrade 8.0.5 to 8.1.6
A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6 by using export/import. This will probably work, but wouldn't it be easier to just do a cold backup and open them using the COMPATIBLE parameter in the 8.1.6 environment? Is there any downside to using export/import? (ie. will it affect snapshots, db links, etc...). I thought the whole point of the compatible parameter was that it let you open up an older database with no questions asked. Then you could run any of the upgrade .sql scripts at your leisure, yes? Best, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Logminer Question
I'm analyzing archive logs from an 8.1.6.3 database running on Solaris. There are many entries in v$logmnr_contents with a NULL username and DATA_OBJ# and DATA_OBJD# values that don't match anything I can find in sys.obj$. What would account for these entries in v$logmnr_contents? Example === SELECT username, OPERATION, count(*) FROM v$logmnr_contents group by username, operation / USERNAME OPERATION COUNT(*) -- -- WANT_NUTS COMMIT 301 WANT_NUTS DELETE4 WANT_NUTS INSERT4 WANT_NUTS INTERNAL884 WANT_NUTS START 301 WANT_NUTS UPDATE 296 ZEDWARDS COMMIT3 ZEDWARDS INSERT 446 ZEDWARDS INTERNAL 15 ZEDWARDS START 4 OKSERVER1 COMMIT 20 OKSERVER1 DELETE 30 OKSERVER1 INSERT 296 OKSERVER1 INTERNAL269 OKSERVER1 START20 OKSERVER1 UPDATE 163 SYSCOMMIT 4034 SYSDELETE 291 SYSINSERT 71 SYSINTERNAL 6997 SYSSTART 4036 SYSUPDATE 4346 COMMIT7 DELETE 1235 INSERT 2242 INTERNAL843 START 2 UNSUPPORTED 266 UPDATE59002 37 rows selected. FYI, data from this database is being replicated via snapshot to a reporting database. Could that be responsible for the NULL username entries? Solaris 7 & Oracle 8.1.6.3 __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Bittel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mass Storage/Network Stuff
Tim, Definitely. We're just researching options right now. I was certain we'd end up with something working over a fiber card or 1000 Megabit NIC of some kind. Thanks, Ed - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 15, 2001 10:50 AM > Ed... > > Make sure you read the last couple lines of Dick's email carefully... He > is absolutely correct... There is a big difference between being certified > by Oracle and being certified by Oracle USING THE SUPPORTED CONFIGURATION... [SNIP] > > Tim > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Mass Storage/Network Stuff
To those who answered: thanks! This mailing list is a wonderful resource. Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Mass Storage/Network Stuff
Are there any problems running Oracle on one box, and pointing the database files to a mass storage network device (ie. a disk array or some external storage solution). In other words, will Oracle run using network addressable storage? I'm assuming this is not a difficult thing to do, but I would love to hear some war stories. Any configuration or specific recommendations on how to do this? Unix/NT an issue? Best, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database Copy Problem
Thanks to those that responded. This is working now. Someone else here made a mistake and reverted the DB to an old init.ora that was causing this problem. I put in the correct init.ora and everything is working just fine. Best, Ed > Used the backup controlfile to trace method to create a copy > of a database on the same server. Copied prod to test. Test > already existed, but was overwritten by new copy. > > We are now getting an ORA-01102, cannot mount in EXCLUSIVE > mode when trying to open the test database. This is on NT 4.0, > Oracle 8.16. > > Ideas? > > Thanks. > > Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Database Copy Problem
Used the backup controlfile to trace method to create a copy of a database on the same server. Copied prod to test. Test already existed, but was overwritten by new copy. We are now getting an ORA-01102, cannot mount in EXCLUSIVE mode when trying to open the test database. This is on NT 4.0, Oracle 8.16. Ideas? Thanks. Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
backup of large databases
Hello, I'm curious how people handle the backups for large/very large databases; 200gb or greater. My questions are not targeted towards any specific hardware platform, but we are using Oracle 8.1.7. I'm assuming that archiving is enabled. Are backups done nightly, or because of time constraints are they done weekly ? If weekly, do you feel comfortable having to possibly apply a week of archives, in the case of a recovery ? Do you use disk or tape ? Do you use RMAN or other backup tools ? What are the customer's expections for recovery and how do they effect your backup strategy ? I appreciate your input. ed
Where 1 = 1
I was monitoring a load test of my company's new application when I came across something interesting. One of the more monstrous queries had the following as part of its WHERE clause: 'AND 1 = 1' Has anyone seen this used before? What is it supposed to achieve? __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Bittel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
v$tempstat question
I've been trying to track down the source of high 'direct path read' and 'direct path write' waits. It appears the waits are related to locally managed temporary tablespaces. However, I'm puzzled by what is reported in v$tempstat. SQL> select FILE#, READTIM, WRITETIM, AVGIOTIM, LSTIOTIM, MINIOTIM, MAXIORTM, MAXIOWTM from v$tempstat; FILE# READTIM WRITETIM AVGIOTIM LSTIOTIM MINIOTIM MAXIORTM MAXIOWTM - --- -- -- -- 1 3001 0 6393 78 2 2 252 443 636 0 1387188 How could the values for MAXIORTM (maximum time spent doing a single read) be substatially greater than those reported for READTIM (time spent doing all reads)? This situtation persists even after all of the users have logged out of the database, so it doesn't appear to be a case of the read having not yet completed. FYI: We're running Oracle 8.1.6.3 on Sun Solaris. -Ed __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Bittel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
wait events & v$filestat.readtim
Are the 'db file scattered read' and 'db file sequential read' waits directly related to the readtim values in v$filestat? For every 1/100th sec of v$filestat.readtim, should I see corresponding wait time reported for the 'db file scattered read' or 'db file sequential read'? If this is the case, where would I find the corresponding I/O value(s) for the 'direct path read' wait event? __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Bittel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SP Non-Parse CPU Calculation IS Incorrect
I don't know if anyone else uses Statspack, but I couldn't help but notice the incorrect '% Non Parse CPU' result in the instance efficiency section of the report. Non-Parse CPU % calculation taken from STATSPACK 8.1.7: STATSREP.SQL: round(100*1-(:prscpu/:tcpu),2). It should be: round(100*(1-(:prscpu/:tcpu),2)). Here's an example using actual statspack values for 'CPU used by this session' and 'parse time cpu'. select round(100*1-(23255/234162),2) pctval from dual; PCTVAL -- 99.9 select round(100*(1-(23255/234162)),2) pctval from dual; PCTVAL -- 90.07 So instead of .10% of CPU being used to parse as reported by Statspack, the database is actually using 10% of CPU to parse. Using the statspack calculation, my database could be using 50% of CPU to parse and the report would still report a high non-parse CPU %. I guess it pays to remember "My Dear Aunt Sally". __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Bittel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Physical access to servers for maintenance
Title: RE: Physical access to servers for maintenance Jack, Any issues with Terminal Services...since Oracle doesn't support Terminal Service's use? Thanks, Ed -Original Message-From: Jack C. Applewhite [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 26, 2001 2:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Physical access to servers for maintenance Me too. We've got our 4 Production Win2k servers (2 Oracle8i servers, 2 Webservers) at a colocation facility and have used either PCAnywhere or Terminal Services to access them over the Internet for the last 9 months. The developers have never needed to have access to the servers except to put in the Cold Fusion CD to install CF Server. I've only needed access once, to load some big files that I later imported into a test db on one of the servers (actually, that's when I put in the CF CD, to save the developers a trip). Even then, I really didn't need to be there, I could have transferred my files via PCAnywhere. If I were the SysAdmin I would have needed access a couple of times to replace failed drives, but the colocation guys took care of that. I recovered our Production db remotely after they replaced the drives. It's very nice to be able to PCAnywhere in to those boxes from home. Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kimberly SmithSent: Wednesday, September 26, 2001 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Physical access to servers for maintenance You can use a tool such as ControlIT to connect to NT machines. Its how I do it, both from the office, and from home. How do all these people who claim you need access to the server room to do the day to day stuff provide remote support? I will be damned if I come in during the middle of the night for a database issue.
RE: Oracle Pure Name and Address
Title: Oracle Pure Name and Address I think it could be part of the Oracle Business Intelligence Suite (ETL: Extract, Transform, and Load). I know Oracle has a feature within such that allows for cleaning up names and addresses!! Ed Haskins -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 2:30 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle Pure Name and Address Recently got a 8.1.7 shipment (for hp-ux) and found some CDs I've never seen in an Oracle shipment before Oracle Pure Name & Address (5.5.0.33) Oracle Pure Name & Address (North America) (5.5.0.33) Oracle Pure Name & Address (Europe, Middle East & Africa , Asia Pacific, and Latin America) (5.5.0.33) Oracle Geocode (US Data) (5.5.0.33) Anybody familiar with this stuff? (I could just drop it in the CD-ROM but I don't have time at the moment.) Matt Adams GE Appliances
RE: What happens if you lose the alert log?
!! Please do not post Off Topic to this List !! Oracle will automatically recreate the ALERT log file and begin writing to it. Ed -Original Message- Sent: Thursday, September 13, 2001 10:50 AM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Hi, I had a situation yesterday where a rogue process wrote millions of error messages into the alert log. I was able to get rid of the process, then delete the error messages out. But it would have been quicker to just blow it away and create a new, empty one. I was concerned as to the effect that would have on Oracle. Would it bring Oracle down? What is the best way to handle this? Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Nostradamus: RE: RE: STOP THE PRESS!!
The following quatrain has been circulating the Internet after the WTC bombings. In the City of God there will be a great thunder, two brothers torn apart by chaos, while the fortress endures, the great leader will sucumb. The third big war will begin when the big city is burning. It is NOT by Nostradamus. The original source may be http://www.ed.brocku.ca/~nmarshal/nostradamus.htm. Here is a short excerpt from that page. How does this apply to Nostradamus? Well I will show you... If I make say a thousand prophecies that are fairly abstract for example: In the City of God there will be a great thunder, Two brothers torn apart by Chaos, while the fortress endures, the great leader will succumb Well let us analyse this. For Example what does City of God mean? It could be Mecca, Medina, Rome, Jeruselum, Salt Lake City, or any holy city depending on your religion. What do I mean by thunder--a storm? War? EarthQuake? lots of stuff can be described by thunder. There are a lot of two brothers on this world (I think the Number runs among the Billions) and fortress edure's what--Besiegement, Famine, etc? What Great Leader? How will he succumb? To what? -Original Message- Sent: Wednesday, September 12, 2001 1:15 PM To: Multiple recipients of list ORACLE-L I just got this from a friend. "In the City of God there will be a great thunder, two brothers torn apart by chaos, while the fortress endures, the great leader will succumb. The third big war will begin when the big city is burning. On the 11th day of the 19th month that two metal birds would crash into two tall statues in the new city and the world will end soon after." Michel de Nostredame Nostradamus Century 9, Quatrain 16:54 -Original Message- Sent: Tuesday, September 11, 2001 5:12 PM To: Multiple recipients of list ORACLE-L YEAH, CRUSH THE A**HOLE'S and ANYONE or GOVERNMENT who supports this act! * THIS IS AN ACT OF WAR, comparable if not worst than Pearl Harbor * Gene >>> [EMAIL PROTECTED] 09/11/01 12:15PM >>> My heart goes out to our friends in America...this is sad, sad newslet's hope your president makes the right decisions in handling this affair... K. -Original Message- Sent: 11 September 2001 15:55 To: Multiple recipients of list ORACLE-L The BBC seems to have more info than the U.S. web sites. Tuesday, 11 September, 2001, 13:35 GMT 14:35 UK Planes 'attack' World Trade Center A huge explosion rocks one of towers Two planes have crashed into the World Trade Center in New York City while an explosion has rocked the Pentagon in Washington DC. The White House is reportedly being evacuated. One report says six people have been killed in the New York incident while hundreds have been injured. Smoke is pouring from the upper storeys of both towers of the World Trade Center. The building, one of the world's tallest, has been badly damaged in what President George W Bush has described as "an apparent terrorist attack". He said: "We will find those who committed this attack." New York police have been quoted as saying that both planes were hijacked from Boston. A few minutes after the first tower was hit by a passenger plane, a second, similar plane was seen flying into the second tower. A huge explosion was seen. Eyewitnesses say the first plane crashed into the West Tower after flying unusually low over Manhattan Island. A BBC correspondent says 10 to 15 floors have been affected by the crash. Briton James Winter, 30, living in an apartment close to the centre, said he was woken a huge bang at around 0800 local time. "I was in bed and there was a huge explosion. The whole building rattled and shook," he said. "I ran to the window and there was smoke billowing from the south side of one of the towers. Everyone in my building was panicking and running around." The World Trade Center consists of two 110-story skyscrapers, New York's tallest buildings. One of the towers is just six feet (two metres) taller than the other. About 40,000 people work inside the two-building centre, and more than 150,000 people enter the complex every day. On 26 February, 1993, a terrorist bomb exploded in building number one's lower level. -- Please see the off
RE: An OPS & tnsnames question
Look at Transparent Application Failover as a Net8 option. You'll need to determine Oracle Client compatibility / requirements with such! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, August 29, 2001 11:15 AM To: Multiple recipients of list ORACLE-L Dear list ! I've got an OPS database named OPS with 2 instances OPS1 and OPS2 . I want the users to connect to OPS1 and ONLY if it is down , to connect to OPS2. It's Oracle 8.0.5.1 on NT4. I put the following lines in clients' tnsnames.ora file : OPS.world = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = DB1) (PORT = 1526)) (CONNECT_DATA = (SID = OPS1)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT = 1526)) (CONNECT_DATA = (SID = OPS2)) ) ) This works perfectly fine except for the case when OPS1 instance is down , but the listener is up. Then clients try to connect to OPS1 and fail - "Oracle not available" . When i bring the listener on OPS1 host down - everybody perfectly connect to OPS2. Is there a solution ? Thanks a lot in advance ! DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: financial problems with fatcity.com
How about Corporate Sponsorship? -Original Message- Sent: Wednesday, August 29, 2001 11:16 AM To: Multiple recipients of list ORACLE-L I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am sure that everybody working with Oracle and living in US or UK or other developed country can afford such fees. We will not need to charge people from developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
aix tools
Hi, Can anyone tell me where I can download a copy of "top" to run on aix 4.3.3 ? thanks for your help. ed lewis
RE: TNSPING Test Script for NT
Tom,
Thanks!!
Ed
-Original Message-
Sent: Tuesday, August 21, 2001 3:13 PM
To: Multiple recipients of list ORACLE-L
Ed,
how about:
tnsping {sid} 1000 > ping.lis
will tnsping the {sid} 1000 times, with the result being placed in a file
created named ping.lis
changing it to
*** file name pingtest.bat
tnsping %1 1000 > ping.lis
Can be executed as pingtest {sid}
Another way to do this using a loop within the .bat file follows.
This would execute the tnsping command 1000 times:
*** file name pingtest1.bat
echo TnsPing Test > ping.lis
echo date /T >> ping.lis
for /L %I in (1,1,1000) do tnsping r816 >> ping.lis
And a third way, using goto looping:
*** file name pingtest2.bat
@rem
@rem Loop through a counter searching for the RunDaily.{seq} file
@rem
@set /A ctr=0
:again
echo TnsPing Test > ping.lis
echo date /T >> ping.lis
set /A ctr=ctr+1
if (%ctr%) == (1000) goto endloop
tnsping r816 >> ping.lis
goto again
:endloop
hope these help.
Tom Mercadante
Oracle Certified Professional
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 2:37 PM
To: Multiple recipients of list ORACLE-L
Can anyone help me with a simple .bat script for NT that will run a TNSPING
against a certain connect descriptor and write the results to a file. I
need to have the TNSPING run for say 1000 loops. Once complete, I can
search through the file for errors.
Thanks,
Ed
--
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: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Haskins, Ed
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
TNSPING Test Script for NT
Can anyone help me with a simple .bat script for NT that will run a TNSPING against a certain connect descriptor and write the results to a file. I need to have the TNSPING run for say 1000 loops. Once complete, I can search through the file for errors. Thanks, Ed -- 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: Apologies... linux & Oracle
Title: Apologies... linux & Oracle SCO makes a version of Linux now? Ed -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 11:51 AMTo: Multiple recipients of list ORACLE-LSubject: Apologies... linux & Oracle Sorry everyone, I know you were just discussing this recently. What is the most stable combination of Oracle & Linux? What would you recommend? I want to say the consensus was SCO Linux but I don't quite remember. Thank you Lara Croft Oracle Database Administrator Fairfield Resorts, Inc
RE: Apologies... linux & Oracle
Title: Apologies... linux & Oracle O.K...it looks like SCO was bought by Caldera, who sells a distribution of Linux under that name. Ed -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 12:36 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Apologies... linux & Oracle Lisa SuSe is the best so I have been told. I am about to install 8i on 7.1 and another guy here is installing 9i on 7.2. Totally untested on my behalf as I haven't started yet but that is the best I have been told. Probably of no use whatsoever !!! Lee -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: 21 August 2001 16:51To: Multiple recipients of list ORACLE-LSubject: Apologies... linux & Oracle Sorry everyone, I know you were just discussing this recently. What is the most stable combination of Oracle & Linux? What would you recommend? I want to say the consensus was SCO Linux but I don't quite remember. Thank you Lara Croft Oracle Database Administrator Fairfield Resorts, Inc The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying 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 computersystem.
RE: linux
Nope! -Original Message-From: Saravana Kumar [mailto:[EMAIL PROTECTED]]Sent: Monday, August 20, 2001 10:46 AMTo: Multiple recipients of list ORACLE-LSubject: linux Hi Friends, I have small clarification to be made. Can oracle for linux software be intalled on FREE BSD. Thanks in advance Saravana
RE: No TNSListner service after intall 8.1.7 on Win 2k
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k Lisa, C:\> set ORACLE_SID=SID_NAME Then... C:\> set ORACLE_SID ORACLE_SID=SID_NAME Ed Haskins Oracle DBA Verizon Wireless -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 2:22 PMTo: Multiple recipients of list ORACLE-LSubject: RE: No TNSListner service after intall 8.1.7 on Win 2k Hi Igor, thanks for your reply. Call me a bonehead... but I got nothing. What am I missing? C:\>set ORACLE_SID Environment variable ORACLE_SID not defined C:\>sqlplus system SQL*Plus: Release 8.1.7.0.0 - Production on Thu Aug 16 13:18:15 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter password: Connected to: Oracle8i Release 8.1.7.0.0 - Production JServer Release 8.1.7.0.0 - Production SQL> select name from v$database; NAME - VIKING SQL> -Original Message- From: Igor Neyman [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Subject: Re: No TNSListner service after intall 8.1.7 on Win 2k Lisa, Try: SET ORACLE_SID You should get: ORACLE_SID='your_sid' Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> - Original Message - From: Koivu, Lisa <mailto:[EMAIL PROTECTED]> To: Multiple recipients of list ORACLE-L <mailto:[EMAIL PROTECTED]> Sent: Thursday, August 16, 2001 1:28 PM Subject: RE: No TNSListner service after intall 8.1.7 on Win 2k Hi Rick, I ran into this as well. I figured I didn't need a listener on my w2k box because everything was going to be local. However I couldn't connect via sqlplus gui without a listener (no listener error - maybe because I am specifying the sid). I guess it's just another difference between Oracle on windows and Oracle on Unix. If I remember right (it's been s long) when you connect in Unix with the $ORACLE_SID as part of your env, you can do so without @. If you do it with the @, it looks for a listener. When connecting via a windows gui, you are specifying the sid. I'm guessing it's doing something similar to the @ in the background. The cmd window connects without the @ because it's in the environment. By the way, how do you display an environment variable in Windows? I thought it was echo %ORACLE_SID%, but that doesn't work. Anyone? Again I may be pre-coffee. Lisa KoivuOracle Database AdministratorFairfield Resorts, Inc.954-935-4117 -Original Message-From: Cale, Rick T (Richard) [SMTP:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 12:36 PMTo: Multiple recipients of list ORACLE-LSubject: No TNSListner service after intall 8.1.7 on Win 2k Hi All, I did a typical installation of Oracle 8.1.7 on Win 2k. It appears to haveinstalled Ok. I can use srvmgrl -> create database -> etc.However when I try to use worksheet I get no listner. I should not need onefrom the server. Anyway the install did not create serviceto start the listener. All other installs I have done on NT always createda tnslistner service. This in my first install on Win 2k.Anyone have any ideas on why service did not get created and how to correct? ThanksRick--Please see the official ORACLE-L FAQ: <http://www.orafaq.com>--Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-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: Unix Client Install - OraInventory
Actually, on my original install, it went one level up from ORACLE_HOME - e.g, ORACLE_HOME was /dsk001/app/oracle/product/8.1.7; the OraInventory,oui,jre went into /dsk001/app/oracle/product - one level up. Since that's where I tarred/untarred to on the new machine, I should have the installer info - at least it appears there. All seems to work fine. I'll keep an eye out when/if patching! Much and Many thanks for all the responses, I'll sleep easier. Ed Maurer. > -Original Message- > From: Lord, David - C&S [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 09, 2001 1:45 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Unix Client Install > > > But it is stored, by default, under the oracle account's home > directory > (together with the OUI and jre). I haven't tried it, but > maybe you could > copy those as well? I would guess that the paths to all of > these bits would > have to be the same on both machines. > > YMMV > David Lord > > -Original Message- > Sent: 09 August 2001 02:56 > To: Multiple recipients of list ORACLE-L > > > It will allow you to run Oracle, but you won't be able > to upgrade it later. There some "orainventory" directory > where OUI keeps track of what it has installed on this > system. This folder is NOT stored in or under ORACLE_HOME > > HTH & YYMV! > > Ed Maurer wrote: > > > Given virtually identical Unix machines (i.e., > > same kernel and patch sets,) is there any reason NOT > > to take the cowards way out and use a tar file of > > $ORACLE_HOME from the first client only install > > (from CD with X-win client) to install to another > > machine? My original install CD has 'walked'; I > > could download and cpio ... or wait 3 days for > > support to get me new CD's. Why shouldn't I use > > the working installation as a base? Are there any > > machine specific actions taken by the installer > > besides obvious tnsnames if you use the installation > > gui) for client installations ? > > > > TIA > > Ed Maurer > > Acquirex > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ed Maurer > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / > Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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: Charlie Mengler > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Lord, David - C&S > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > ---- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Maurer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unix Client Install
Given virtually identical Unix machines (i.e., same kernel and patch sets,) is there any reason NOT to take the cowards way out and use a tar file of $ORACLE_HOME from the first client only install (from CD with X-win client) to install to another machine? My original install CD has 'walked'; I could download and cpio ... or wait 3 days for support to get me new CD's. Why shouldn't I use the working installation as a base? Are there any machine specific actions taken by the installer besides obvious tnsnames if you use the installation gui) for client installations ? TIA Ed Maurer Acquirex -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Maurer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
3rd Party Java and Oracle Triggers
In the course of customizing one of our 3rd party apps that uses Entity Beans to do multiple inserts to some tables, It has been decided we'd use triggers on the tables to do some RI logic and insert essentially duplicate data into another database - Oracle Financials interface, to be exact, I've been opposed to this methodology, on the grounds that nobody here can tell me exactly how this app is behaving in the first place. I've heard that some beans do stupid (sic) things like insert a row, then update each column in the course of a single transactional insert, thus requiring both insert and update triggers; performance could be nightmarish, assuming we don't hit 4091 errors even trying to write the code. Unfortunately, without some hard facts, I'm going to have a hard time convincing anyone this is bad practice. And without tools to see exactly how the object(s) behaving, I won't be able to prove it on our development platforms either. Anyone have any experience here, or ideas for tools (besides packet capture) that can assist ? TIA Ed Maurer
Experience using Legato on a Veritas Cluster?
If anyone on the list has any experience using Legato NetWorker on a Veritas cluster and wouldn't mind responding to some questions, please send me a e-mail. My questions pertain to configuration of Legato on a Veritas cluster and some concerns I've developed about recoverability after a node failover. Thanks, Ed __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Bittel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SHARED SQLNET.ora? RE: tnsnames.ora in clients
Has anyone been successful with putting the SQLNET.ora file in the same shared location as the TNSNAMES.ora file? I know it's supposed to be used solely on the user workstation in /network/admin (Net80/admin), but some people are trying to place it on the shared drive as well. We're actually implementing ONAMES, so we're replacing the SQLNET.ora file to specify ONAMES, and some Regions are thinking they only need to place this on the shared drive where TNS_ADMIN points to. I don't think this is supported or works in all situations. Any experiences or comments?? Ed -Original Message- Sent: Tuesday, July 24, 2001 1:02 PM To: Multiple recipients of list ORACLE-L We use a shared tnsnames.ora from a NT server. > -Original Message- > From: Ron Rogers [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 23, 2001 2:33 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: tnsnames.ora in clients > > > Does this method of "sharing" the tnsnames work for you? What > operating system are you using? I use Novell and when I tried > this method of sharing the tnsnames it wouls not work. We had > to resolve to downloading the latest copy to the users when > they logged in. > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 07/23/01 11:41AM >>> > You can write a script and each time when a user logs into a domain > it will check and copy the latest tnsnames.ora file. Or you can just > place the tnsnames.ora file on the network drive and point everyone > to it. > > >>> [EMAIL PROTECTED] 07/23/01 10:55AM >>> > Hello All, > > Good morning! > I would like to know how the 'tnsnames.ora' file on all > client(windows) > machines can be updated automatically whenever something changed on > central 'tnsnames.ora' file. > Is this the process still being used extensively or else > advanced features > like ONS. > > Your suggestions are highly appreciated. > > Thanks, > > Suren > Consultant DBA > Sony > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tirumala, Surendra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Richard Ji > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other inf
RE: Re: Oracle Internet Directory
It's free if you use it simply for Net8...in replace of Oracle Names. If you want to use it for the other features...user authentication, etc...then you need to pay. I would contact Oracle for current pricing. When I last checked...you could purchase licensing based upon the number of entries in the Directory. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Tuesday, July 17, 2001 1:12 PM To: Multiple recipients of list ORACLE-L Sorry for the OT question. Is OID free if I have the Enterprise license? if not, how much is it? I can't find pricing for it on oraclestore site. thanks for any help. >>> [EMAIL PROTECTED] 07/17/01 12:50PM >>> Check if the schemas ODS and ODSCOMMON exists. Regards. --- [EMAIL PROTECTED] wrote: > Hello All. > > I have a problem in starting my ldap server > instance. > I have created a database say OIDB2 using UTF8 > character set. > Oracle internet Directory already installed in my > oracle home. > I started OID monitor after setting environment > variable > NLS_LANG=AMERICAN_AMERICA.UTF8, >using command "oidmon connect=oidb2 sleep=10 > start". It started > successfully. > but when i tried to start ldap server instance > using command (oidctl > connect=oidb2 server=oidldapd instance=5 start) > i received error message ---"[gsdsiConnect] > ORA-1017, ORA-01017: > invalid username/password; logon denied" > > I am stuck with this now. > > Please help me to come out of this problem. > > Thanks and Regards > > Vinay > -- > 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Scsi I/O speed
Kev, Make sure that the SCSI CD-ROM or Tape Drive aren't connected to this controller. Ed -Original Message- Sent: Wednesday, July 11, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Well yeah, all of this makes perfect sense to me. However, if I am testing the devices I would assume that the test software is going to send as much info as it can down the pipe, you know stuff it. With the Ultra/160 I am assuming that there is only a 80mb/s drive in there, I never opened it up and looked, but I will now. I will use a couple different utilities and see if the rates are the same. Also, I know that the drives I have in these machines are all 80mb/s drives, at least in the other machines, so there shouldn't be any device that is "bringing" down the rate. I don't know, but I would love to try and iprove this rate. KK -Original Message- Sent: Wednesday, July 11, 2001 2:00 PM To: Multiple recipients of list ORACLE-L Kevin, One thing to remember with SCSI...it's not necessarily the speed of the controller that matters. The SCSI bus will be slowed down to the speed of the slowest device in the chain...or on the bus. For example, if you have a controller with 80mb/s and 3 HDs with 80mb/s and 1 HD at 40mb/s...all running off the same controller...the bus speed will be no more than 40mb/s (the speed of the slowest device). Again, that is the theoretical max speed. Ed -Original Message- Sent: Wednesday, July 11, 2001 12:22 PM To: Multiple recipients of list ORACLE-L Hi all, I was measuring the i/o performance of my scsi drives and I have a quick question that maybe someone could shed some light upon. Currently I am using Ultra 2/Wide scsi conrollers, this is supposed to have an I/O of 80mb/s. Well, when I perform the test all of the machines seem to be operation at halp of the max speed. One operates at about 20mb/s read and write and the others are even slower than that. Now on the first one, it is the only HD on the controller, on the others there are two disks. Even on my Ultra/160 it seems to be maxing out at 40 read and write. Am I missing something? Am I reading this the wrong way? Help:( Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle on NT unattended installation
Joe, I've done it for the Oracle Client, successfully. This question was posted on LazyDBA, and a couple others responded that they were successful with it. Ed -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 2:41 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle on NT unattended installation Ed, you've gotten thats to work?, theory is nice, but r/l is what counts joe >>> [EMAIL PROTECTED] 07/11/01 02:05PM >>> Audrey, Yes, you can do a silent install. On a workstation / server that has Oracle installed (NT/2000), go to: START | PROGRAMS | Oracle Installation Products | Universal Installed Concepts Guide This is in HTML format and will show you how you can do a silent install. Ed -Original Message-From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 11:26 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle on NT unattended installation Dear list ! Is there a possibility to do an unattended installation of Oracle server (8.1.7) on NT (Win2000) ? I mean an installation with a script or so without answering questions and clicking 'Next' during the installation. If there is such a possibility for NT , would You please point me to a manual ? I tried to RTFM and found nothing. Thanks a lot in advance. Andrey.
RE: Oracle on NT unattended installation
Title: Oracle on NT unattended installation Audrey, Yes, you can do a silent install. On a workstation / server that has Oracle installed (NT/2000), go to: START | PROGRAMS | Oracle Installation Products | Universal Installed Concepts Guide This is in HTML format and will show you how you can do a silent install. Ed -Original Message-From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 11:26 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle on NT unattended installation Dear list ! Is there a possibility to do an unattended installation of Oracle server (8.1.7) on NT (Win2000) ? I mean an installation with a script or so without answering questions and clicking 'Next' during the installation. If there is such a possibility for NT , would You please point me to a manual ? I tried to RTFM and found nothing. Thanks a lot in advance. Andrey.
RE: Scsi I/O speed
Kevin, One thing to remember with SCSI...it's not necessarily the speed of the controller that matters. The SCSI bus will be slowed down to the speed of the slowest device in the chain...or on the bus. For example, if you have a controller with 80mb/s and 3 HDs with 80mb/s and 1 HD at 40mb/s...all running off the same controller...the bus speed will be no more than 40mb/s (the speed of the slowest device). Again, that is the theoretical max speed. Ed -Original Message- Sent: Wednesday, July 11, 2001 12:22 PM To: Multiple recipients of list ORACLE-L Hi all, I was measuring the i/o performance of my scsi drives and I have a quick question that maybe someone could shed some light upon. Currently I am using Ultra 2/Wide scsi conrollers, this is supposed to have an I/O of 80mb/s. Well, when I perform the test all of the machines seem to be operation at halp of the max speed. One operates at about 20mb/s read and write and the others are even slower than that. Now on the first one, it is the only HD on the controller, on the others there are two disks. Even on my Ultra/160 it seems to be maxing out at 40 read and write. Am I missing something? Am I reading this the wrong way? Help:( Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL-Server Presentation/Reality Check
>From SQL-Server BOL (Books on Line) "READ COMMITTED Specifies that shared locks are held while the data is being read to avoid dirty reads, but the data can be changed before the end of the transaction, resulting in nonrepeatable reads or phantom data. This option is the SQL Server default. READ UNCOMMITTED Implements dirty read, or isolation level 0 locking, which means that no shared locks are issued and no exclusive locks are honored. When this option is set, it is possible to read uncommitted or dirty data; values in the data can be changed and rows can appear or disappear in the data set before the end of the transaction. This option has the same effect as setting NOLOCK on all tables in all SELECT statements in a transaction. This is the least restrictive of the four isolation levels." Note in the above 'nonreaptable reads' and 'phantom data'. Again, from BOL: nonrepeatable read: When a transaction reads the same row more than one time, and between the two (or more) reads, a separate transaction modifies that row. Because the row was modified between reads within the same transaction, each read produces different values, which introduces inconsistency. phantom: By one task, the insertion of a new row or the deletion of an existing row in a range of rows previously read by another task that has not yet committed its transaction. The task with the uncommitted transaction cannot repeat its original read because of the change to the number of rows in the range. If a connection sets its transaction isolation level to serializable, SQL Server uses key-range locking to prevent phantoms. My observations: Note that setting the transaction isolation level to serializeable may make large portions of a table unavailable to another transaction yet that's the only way to insure no phantom data, and is too restrictive to be the default. Also note that unless a transaction explicitly defines 'Begin Transaction', data is auto-committed. i.e. 'update students set lname='Smith' followed by 'go' will trash your student table if you forget the 'where' clause. You cannot issue a rollback, since you didn't define a transaction. In addition, another transaction already reading the student table will get some percentage of all rows as 'Smith' even though it began before the 'bad' update. Try it yourself, as a I did (I used a large 'waitfor' in the middle of a procedural loop to simulate a larger table or more per-row processing) HTH Still unashamedly anti-Redmond, Ed Maurer Sr. DBA Acquirex > -Original Message- > From: Post, Ethan [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 27, 2001 2:35 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: SQL-Server Presentation/Reality Check > > > Can you provide some references to lack of support of > read-consistency. Not > that I don't believe you but I just read that to a guy next > to me and he is > clamoring for evidence. - E > > -Original Message- > Sent: Wednesday, June 27, 2001 2:07 PM > To: Multiple recipients of list ORACLE-L > > > Privilege ? Reality? Reality and MS is an oxymoron. > I've had the fortune (misfortune) to become a SQL Server DBA > in addition to my Oracle duties, due to packaged application > requirements. As an admitted defiler of all MS stands for and > it's dubious accomplishments, I'll offer a few grains of sand, > most of which you might be advised to take up with management > away from the MS marketing morons. > > First, be aware that MS pricing is not nearly as inexpensive > as their hype would have you believe, once you remember that they > have always charged for upgrades, their discounts aren't usually > as steep, and support... well, what there is of it s. I've > spent 3 calls at $245.00 each only to be told each time the > answer was to 'reboot'. This on W2K/SS2K fail-over cluster, > with many of their best support people contributing to this > non-solution. > > On a technical note: Virtually every one of their new speed > marks of note have been done on multi-server clusters; Oracle > still holds most single-server benchmarks. Additionally, their > application benchmarks have no relationship to real world, as > even their SAP benchmark was done on a modified SAP installation > not available in 'ordinary' SAP applications. > The overhead of multi-server/cluster management makes their > scalability arguments, even if they could be accommodated by > existing software, moot. > > Self-Tuning - Bah, Humbug. I've had the opportunity to see > some server code from SAP, PeopleSoft and Commerce One designed > for SQL Server. Guess what ? The real
RE: SQL-Server Presentation/Reality Check
Privilege ? Reality? Reality and MS is an oxymoron. I've had the fortune (misfortune) to become a SQL Server DBA in addition to my Oracle duties, due to packaged application requirements. As an admitted defiler of all MS stands for and it's dubious accomplishments, I'll offer a few grains of sand, most of which you might be advised to take up with management away from the MS marketing morons. First, be aware that MS pricing is not nearly as inexpensive as their hype would have you believe, once you remember that they have always charged for upgrades, their discounts aren't usually as steep, and support... well, what there is of it s. I've spent 3 calls at $245.00 each only to be told each time the answer was to 'reboot'. This on W2K/SS2K fail-over cluster, with many of their best support people contributing to this non-solution. On a technical note: Virtually every one of their new speed marks of note have been done on multi-server clusters; Oracle still holds most single-server benchmarks. Additionally, their application benchmarks have no relationship to real world, as even their SAP benchmark was done on a modified SAP installation not available in 'ordinary' SAP applications. The overhead of multi-server/cluster management makes their scalability arguments, even if they could be accommodated by existing software, moot. Self-Tuning - Bah, Humbug. I've had the opportunity to see some server code from SAP, PeopleSoft and Commerce One designed for SQL Server. Guess what ? The real stuff, that which has to perform, is often hinted (statements like 'option (loop join , force order, maxdop 1 )' which is pretty much self explanatory; 'maxdop 1' = Oracle's noparallel.) Then there's the entire discussion of read-consistency, which SQL Server doesn't support. A whole thread there, and one reason why SQL Server can be very quick in some operations: No RBS to support. Everything is done from the transaction logs. And then there's functionality... Just my 2 cents... Ed Maurer Sr. DBA Acquirex -Original Message- Sent: Wednesday, June 27, 2001 11:32 AM To: Multiple recipients of list ORACLE-L I have the privilege of being tasked to attend a SQL Server presentation to be conducted by Microsoft at our site. Our company's current take on SQL Server is that it's to be used only in the case where a packaged application requires it, or when there are 'tactical' exceptions, while Oracle is viewed as being 'strategic'. However, given the 'challenges' with Oracle's new pricing methods, there is being given increased consideration to expanding SQL Server's use. Now, I know next to nothing about SQL Server, and while I would appreciate the opportunity to learn it, I don't want to go to the presentation and let the MS marketing droids completely have their way, some reality checks need to be presented. So, what questions/issues/considerations should I raise during the presentation? TIA! Jeff T [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Maurer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Legato NetWorker & RMAN: A troublesome pair?
The subject line may be overstating things a bit, but I'm pretty frustrated at the moment. Backups are working fine when I run them manually (i.e., from a command line or within the RMAN utility). The problem is trying to schedule the Oracle backups through the NetWorker Administration GUI. Scheduled filesystem backups work fine. Our attempts to schedule a working backup fail without generating any useful errors in /nsr/logs/messages or /nsr/logs/daemon.log. Basically, the logs just say that the savegroup failed. Setting the NSR_SB_DEBUG_FILE in the nsrnmo script hasn't helped because nothing is being written to the log file. The Legato knowledgebase, if you can call it that, has been of little use (other than to confirm that the output we have received isn't specific enough to debug the problem). What I've seen on MetaLink leads me to wonder if people who use the Legato NetWorker/RMAN actually schedule their backups through the Administration GUI or fall back to good 'ol reliable cron jobs. So, if you use Legato NetWorker for your Oracle backups: Do you schedule them through the Admin GUI or through cron? Do you know of anything we should check that may not have been covered in the NetWorker administration manual? If you've had similar problems, I love to hear what the problem was. TIA for your help. Ed = Ed Bittel, Oracle DBA Executive Jet Technology Services ~~ If you're in Ohio and work with Oracle why not join the Ohio Oracle Users Group? Visit OOUG on-line at: http://www.ooug.org ~~~ __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Bittel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Serious Question (believe it or not)...
Jonathan, Everyone has there own reasons for wanting to write a book. For me, the reasons are: 1. Credibility with peers / clients 2. Sense of accomplishment 3. Enjoy sharing information with people 4. Some extra cash I would certainly say that the first 3 are TRUELY the reason that I would consider such a project, but the extra cash is always a plus!! I certainly am not interested in getting into anyone's personal finances...but could you give us some indication / range of what an author could expect to receive from a book deal? I'm sure it varies depending upon the topic and salesability...but what's a good range? How are book deals typically structured? Thanks, Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, June 07, 2001 1:26 PM To: Multiple recipients of list ORACLE-L Wednesday, June 06, 2001, 4:53:21 PM, Christopher Spence wrote: CS> I hope your not doing it to get rich :) Chris brings up a good point. It's *extremely* difficult to predict book sales in advance. Editors get surprised all the time. Books we think will sell well, don't. And sometimes it's the other way around. It's best to go in with low expectations, and hopefully you'll come out pleasantly surprised. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What stands for i in Oracle 8i
I'm pretty sure it means..."i"ncredibly expensive!! Ed Haskins Oracle DBA Verizon Wireless -Original Message-From: Muthaiah [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 06, 2001 12:56 PMTo: Multiple recipients of list ORACLE-LSubject: What stands for i in Oracle 8iHi,I am just curious about to know for what that i stands for in Oracle 8i.Can any one shed some light?Thanks, Muths "Do not go where the path may lead, go instead where there is no path and leave a trail."
RE: What stands for i in Oracle 8i
Actually now that I think about it... the "i" in Oracle8i actually stands for "i"diot proof. This is what Larry was talking about when he made things easier so that less DBAs were needed. Are you an idiot?? ;-) Ed Haskins Oracle DBA Verizon Wireless -Original Message-From: Muthaiah [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 06, 2001 12:56 PMTo: Multiple recipients of list ORACLE-LSubject: What stands for i in Oracle 8iHi,I am just curious about to know for what that i stands for in Oracle 8i.Can any one shed some light?Thanks, Muths "Do not go where the path may lead, go instead where there is no path and leave a trail."
RE: OT: TUSC and Kevin Loney
. > > >-- > > >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). > > > > _ > > Get your FREE download of MSN Explorer at http://explorer.msn.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: Jeroen van Sluisdam > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists >---- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(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 -- 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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TUSC and Kevin Loney
This info can be found on www.tusc.com in a Press Release. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Monday, June 04, 2001 3:32 PM To: Multiple recipients of list ORACLE-L >I guess I am the last to discover this, but Kevin now works for TUSC. No Patrice - you were not the last! I thought Kevin was 'independent', so where did you get this info from? Anyway, TUSC is big in the Oracle area, and I wouldn't be surprised. John Kanagaraj -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database writer
Kev, Trying to add multiple DBWR processes on NT is useless since NT uses asynch. I/O. If you remember, all the Oracle processes (DBWR, LGWR, CKPT, ARCH, etc.) run as threads under the oracle.exe process. Multiple DBWR processes are definitely a Unix thing! Also, here's something from MetaStink on the issue: Oracle on NT only allows/needs a single database writer process (DBWR). Multiple DBWRs on UNIX is not multiple "real" DBWRs which all go scan for dirty buffers and write them to disk. It's really just one "real" DBWR and some I/O slaves. The "real" DBWR tells the slave DBWRs to do I/O. On NT, there's really no need for this since async I/O and NT will take care of all that for you. NT acts as the I/O slaves and the "real" DBWR [1 DBWR thread] then checks the "slaves" to see if the I/O is done. Melissa Holman Oracle Support Ed Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Monday, June 04, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Bumoer Stickers [RE: Rebuilding indexes]
Kev, Read The F*%&ing Manual People get RTFM'd much more on the LazyDBA list than here...but I'm fairly certain this must have been used on this List as well at one point or another!! Ed Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Friday, June 01, 2001 5:09 PM To: Multiple recipients of list ORACLE-L What does RTFM mean? -Original Message- Sent: Friday, June 01, 2001 4:28 PM To: Multiple recipients of list ORACLE-L Don't forget these: "RTFM" "Unix or NT?" "URGENT: Tell me everything you know about ___?" Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Friday, June 01, 2001 3:31 PM To: Multiple recipients of list ORACLE-L >It got me thinking that it would be fun to have some bumper stickers made up for >members of this list. Some ideas I had: >"ARE YOU AN IDIOT?" >or >"SHUTDOWN ABORT" Don't forget "HELP" - Kirti > -Original Message- > From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] > Sent: Friday, June 01, 2001 12:47 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Rebuilding indexes > > On Fri, 1 Jun 2001, Hatzistavrou Giannis wrote: > > > I don;t quite understand you quoting > > "Once the indexes have all > > been rebuilt nologging into the original tablespace, all that's left > > is to > > refresh the datafiles for that tablespace onto the primary. " > > Is primary a typo error (i.e. standby)? > > Argh! It was a typo. Of course, after doing many unrecoverable > operations, you > should refresh the affected datafiles from the primary to the standby. > > Vadim Gorbounov mentioned the column 'unrecoverable_change#' in > v$datafile. > This looks like an SCN, not a count of unrecoverable changes. Either way, > it > seems like a useful way to decide if a datafile shoule be refreshed onto > the > standby. I can even imagine improving a standby log applier that could be > made > to refresh such files from the primary automatically. > > On another topic, I believe I qualify for some sort of award as uber geek. > This week I obtained the Washington State license plate "ORA DBA" for my > '74 > Volvo. > > It got me thinking that it would be fun to have some bumper stickers made > up for > members of this list. Some ideas I had: > > "ARE YOU AN IDIOT?" > > or > > "SHUTDOWN ABORT" > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access
RE: Bumoer Stickers [RE: Rebuilding indexes]
Don't forget these: "RTFM" "Unix or NT?" "URGENT: Tell me everything you know about ___?" Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Friday, June 01, 2001 3:31 PM To: Multiple recipients of list ORACLE-L >It got me thinking that it would be fun to have some bumper stickers made up for >members of this list. Some ideas I had: >"ARE YOU AN IDIOT?" >or >"SHUTDOWN ABORT" Don't forget "HELP" - Kirti > -Original Message- > From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] > Sent: Friday, June 01, 2001 12:47 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Rebuilding indexes > > On Fri, 1 Jun 2001, Hatzistavrou Giannis wrote: > > > I don;t quite understand you quoting > > "Once the indexes have all > > been rebuilt nologging into the original tablespace, all that's left > > is to > > refresh the datafiles for that tablespace onto the primary. " > > Is primary a typo error (i.e. standby)? > > Argh! It was a typo. Of course, after doing many unrecoverable > operations, you > should refresh the affected datafiles from the primary to the standby. > > Vadim Gorbounov mentioned the column 'unrecoverable_change#' in > v$datafile. > This looks like an SCN, not a count of unrecoverable changes. Either way, > it > seems like a useful way to decide if a datafile shoule be refreshed onto > the > standby. I can even imagine improving a standby log applier that could be > made > to refresh such files from the primary automatically. > > On another topic, I believe I qualify for some sort of award as uber geek. > This week I obtained the Washington State license plate "ORA DBA" for my > '74 > Volvo. > > It got me thinking that it would be fun to have some bumper stickers made > up for > members of this list. Some ideas I had: > > "ARE YOU AN IDIOT?" > > or > > "SHUTDOWN ABORT" > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE NAMES /LDAP
Interesting...Oracle must have changed their minds on this issue. I know we complained that it seemed crazy for us to pay for OiD when ONAMES is free...considering Oracle is de-supporting ONAMES and practically forcing customers to go with OiD (LDAP). I guess they actually used some of the feedback we and others provided to straighten out the inconsistency!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, May 31, 2001 5:47 PM To: Multiple recipients of list ORACLE-L Hi, Actually, it's not so bad. OiD is licensed separately ONLY when used as general purpose directory service. Check Metalink Note:135696.1 "13. Do I need to license OID when deploying the directory for NET8 ? Answer -- No, deploying OID for NET8 is free of charge." Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, May 31, 2001 4:44 PM To: Multiple recipients of list ORACLE-L OiD is a "separately licensable product"...not included as part of the DB license. If I remember correctly, you have the UPU license calculation or a per entry license @ $50/, with 5000 entries being the minimum!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, May 31, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Hi Ed, Why do you say that OiD "is not cheap"? I haven't seen any associated costs, other than servers to put it on. Can you explain? The "complicated" part, though I definitely agree with! :) Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, May 31, 2001 10:51 To: Multiple recipients of list ORACLE-L Vikas, I just implemented Oracle Names (8.1.6) for Verizon Wireless...corporate-wide. I've setup three ONAMES servers: 1. At Corporate Headquarters in NJ. This server contains the region database for ONAMES. It also serves as the "Secondary" ONAMES server corporate-wide. 2. In data center in NY. This server provides "Primary" ONAMES services to the corporate regions in both the North East and South areas. 3. In data center in CA. This server provides "Primary" ONAMES services to the corporate regions in both the West and Midwest areas. This infrastructure supports 26,000 users accessing 250+ databases corporate-wide. Oracle Names is making its' terminal release in 9i. Oracle is recommending that companies migrate to their LDAP (Oracle Internet Directory) solution. This solution is not cheap...so we have decided to wait probably another year or so before going this route. OiD is also a bit more complicated to setup and administer. Ed Haskins Oracle DBA Verizon Wireless -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network S
RE: ORACLE NAMES /LDAP
OiD is a "separately licensable product"...not included as part of the DB license. If I remember correctly, you have the UPU license calculation or a per entry license @ $50/, with 5000 entries being the minimum!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, May 31, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Hi Ed, Why do you say that OiD "is not cheap"? I haven't seen any associated costs, other than servers to put it on. Can you explain? The "complicated" part, though I definitely agree with! :) Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, May 31, 2001 10:51 To: Multiple recipients of list ORACLE-L Vikas, I just implemented Oracle Names (8.1.6) for Verizon Wireless...corporate-wide. I've setup three ONAMES servers: 1. At Corporate Headquarters in NJ. This server contains the region database for ONAMES. It also serves as the "Secondary" ONAMES server corporate-wide. 2. In data center in NY. This server provides "Primary" ONAMES services to the corporate regions in both the North East and South areas. 3. In data center in CA. This server provides "Primary" ONAMES services to the corporate regions in both the West and Midwest areas. This infrastructure supports 26,000 users accessing 250+ databases corporate-wide. Oracle Names is making its' terminal release in 9i. Oracle is recommending that companies migrate to their LDAP (Oracle Internet Directory) solution. This solution is not cheap...so we have decided to wait probably another year or so before going this route. OiD is also a bit more complicated to setup and administer. Ed Haskins Oracle DBA Verizon Wireless -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Suggestions on SCSI
Kev, 1. I have never heard of a cache directly on the hard drive (Which certainly doesn't mean it doesn't exist). I have heard of a cache on the controller for the HD! 2. I assume that you are looking at upgrading one of the Dell Workstations, yes? If so, I highly recommend calling Dell and ordering HD's from them that are supported for that Workstation. Dell uses high quality products such as Seagate and IBM for HDs, so don't worry. The main concern is compatibility and continued support!! 3. The majority of Dulcian's DBs are small development databases...so you will likely never need 4x18 GB of space... 4x9 GB will suffice. But, check the pricing difference...if the price diff isn't too crazy...go with 18. You should probably go with 1 9 GB for the OS and 3 18s for the database. 4. Ultra Fibre SCSI...I'm not 100% on this, but I would say that these drives are optimized for external storage where Fibre Channel is used to connect the server to the storage cabinet (certainly not your case). Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, May 31, 2001 1:16 PM To: Multiple recipients of list ORACLE-L Hi all, Just thought I would throw this one out there and see what all of you hot shots think. I am going to rebuild a server into a DB Server. Currently it has IDE drives in there and obviously I am not going to be using those. So I need to invest in some new SCSI drives. Here's what I had in mind: Either 4 X 9.2 Gig 10K RPM with 2mb Cache OR 4 X 18.4 GIG 10K with 4MB cache I was initially leaning towards the 9 gigs to save on cost, however someone pointed out that 18 would be a better idea for growth down the line. Also I want to keep them all of the same size in case one goes down then I may have room on another. What are your thoughts on this? Does anyone know what "ultra fibre scsi" means? Does anyone recommend brands to stear clear of? I know that Seagate is a pretty good name, but I can't find any in Ultra 2? Anyone know if Hitachi is a good name? Thanks in advance. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Applications
Finding Oracle DBAs with 4 years experience is tough enough...forget about 4 years experience with Apps!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, May 31, 2001 10:51 AM To: Multiple recipients of list ORACLE-L Still no response from Oracle Canada, I left a message again - they didn't know what to do when people order CD Packs... Meanwhile I saw on the 'net a job posting that had as one of the competency requirements: 4 years experience with Oracle Applications. I guess this is supposed to be funny. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE NAMES /LDAP
Vikas, I just implemented Oracle Names (8.1.6) for Verizon Wireless...corporate-wide. I've setup three ONAMES servers: 1. At Corporate Headquarters in NJ. This server contains the region database for ONAMES. It also serves as the "Secondary" ONAMES server corporate-wide. 2. In data center in NY. This server provides "Primary" ONAMES services to the corporate regions in both the North East and South areas. 3. In data center in CA. This server provides "Primary" ONAMES services to the corporate regions in both the West and Midwest areas. This infrastructure supports 26,000 users accessing 250+ databases corporate-wide. Oracle Names is making its' terminal release in 9i. Oracle is recommending that companies migrate to their LDAP (Oracle Internet Directory) solution. This solution is not cheap...so we have decided to wait probably another year or so before going this route. OiD is also a bit more complicated to setup and administer. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, May 31, 2001 5:06 AM To: Multiple recipients of list ORACLE-L Anyone using this product as an alternative to Local Naming ? How about LDAP ? Any info /suggestions/comments are welcome vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is DBMS_OBFUSCATION free in Enterprise Edition?
Free...unless you look at the TCO (Total Cost of Ownership). ;-) Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, May 30, 2001 3:51 PM To: Multiple recipients of list ORACLE-L It is free - very definite answer :-) Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 2:02 PM To: Multiple recipients of list ORACLE-L We have Enterprise Edition 8.1.7.1 on Sun Solaris 2.6. My manager needs a definitive answer. Is DBMS_OBFUSCATION free with this version of Enterprise Edition server or is it part of an extra-cost add-on. All definitive answers welcome. I have a call in to Oracle but they have not yet responded. My manager wants to know today. Thanks, Cherie Machler Oracle DBA Gelco Information Network -- 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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS access
Title: MS access Li, 1GB for Access would be huge...and cause very poor performance. The only way to overcome the size limitation is to upgrade to a real database...preferably Oracle, but that SQL Server thing would work as well for a DB that size. Ed Haskins Oracle DBA Verizon Wireless -Original Message-From: Li, Xiangli [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 11:57 AMTo: Multiple recipients of list ORACLE-LSubject: MS access Hi, List Is there anyone happen to know what's the database size limitation for MS access97? I heard it's 1 gigabytes, how to overcome it if that's true? thanks Li
