Re: how is it possible
It could have unprintable characters in the name. You can do ls -m, then rename the file. $ ls -m mytest1.lis, mytest.lis , mytest2.lis $ mv "mytest.lis " mytest.lis From: "AK" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: how is it possible Date: Thu, 23 Oct 2003 14:49:24 -0800 This happening with me 3 rd time on this hp box . When I do ls -alt I can see a file in current directory but when I try to open it (vi/cat ) it says no such file or directory . I am same user who created the file . ( no permission problem ) Any idea ?? -ak /home/ak/myscripts/shell_scr $ ls -alt total 4 drwxrwxrwx 2 ak dba 96 Oct 23 14:40 . -rwxrwxrwx 1 ak dba412 Oct 23 14:40 mon_scr drwxr-x--- 10 ak dba 1024 Oct 13 16:07 .. /home/ak/myscripts/shell_scr $ cat mon_scr cat: Cannot open mon_scr: No such file or directory /home/ak/myscripts/shell_scr $ cat ./mon_scr cat: Cannot open ./mon_scr: No such file or directory /home/ak/myscripts/shell_scr $ /home/ak/shell_scr $ whoami ak _ Add MSN 8 Internet Software to your current Internet access and enjoy patented spam control and more. Get two months FREE! http://join.msn.com/?page=dept/byoa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mike Killough 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).
Materialized view restriction?
I am trying to create a top layer materialized view that joins other materialized views and I am getting an ORA-12053: this is not a valid nested materialized view. I can't even use one of the MV's. Here is a simple example to illustrate the problem. Could someone please tell me what I'm missing? QUESTD:scott> create materialized view log on emp 2 with sequence, rowid ( 3 EMPNO, 4 ENAME, 5 JOB, 6 MGR, 7 HIREDATE, 8 SAL, 9 COMM, 10 DEPTNO) 11 including new values 12 / Materialized view log created. QUESTD:scott> create materialized view log on dept 2 with sequence, rowid( 3 DEPTNO, 4 DNAME, 5 LOC) 6 including new values 7 / Materialized view log created. QUESTD:scott> CREATE MATERIALIZED VIEW "EMP_DEPT_MVT" 2BUILD IMMEDIATE 3USING INDEX 4REFRESH FAST 5-- ON COMMIT 6WITH ROWID USING DEFAULT LOCAL ROLLBACK SEGMENT 7ENABLE QUERY REWRITE 8 as 9 select a.rowid emprowid, b.rowid deptrowid, a.ename, b.loc 10from emp a, dept b 11 where a.deptno = b.deptno 12 / Materialized view created. QUESTD:scott> create materialized view log on emp_dept_mvt 2 with sequence, rowid( 3 ENAME, 4 LOC) 5 including new values 6 / Materialized view log created. QUESTD:scott> QUESTD:scott> CREATE MATERIALIZED VIEW "EMP_DEPT_NEST_MVT" 2BUILD IMMEDIATE 3USING INDEX 4REFRESH FAST 5-- ON COMMIT 6WITH ROWID USING DEFAULT LOCAL ROLLBACK SEGMENT 7ENABLE QUERY REWRITE 8 as 9 select a.ename 10from emp_dept_mvt a 11 / from emp_dept_mvt a * ERROR at line 10: ORA-12053: this is not a valid nested materialized view TIA, Mike _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mike Killough 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: Red Hat or Suse
Me too. She was unstable. From: "Farnsworth, Dave" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Red Hat or Suse Date: Mon, 04 Nov 2002 08:45:06 -0800 I think I used to date Suse. -Original Message- Sent: Monday, November 04, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Hmmm, I'm using SuSE on my servers more than 3 years and I've never used kernel from distribution and I hope nobody is using standard kernel on server. (SuSE standard kernel doesn't know ServerWorks chipset). Software location in SuSE is very orderly organized, but other than in RH. I don't think this the way they urge you to use only SuSE. SuSE helpdesk is usable only if you need "shit of the day". But it is the same with RedHat, Microsoft, Oracle, IBM etc. But, I think, SuSE have closed the US office. JP On Monday 04 November 2002 15:38, you wrote: > There was a little squabble when RH tried promoting Postgres (a.k.a "Red > Hat database") > but after a retaliation from Oracle, Red Hat came to its senses. Suse was > merely a tool > in this squabble. It isn't big enough, software availability is so much > worse then for RH and > they are trying to lock people in SuSE distribution by putting software in > unusual places. > Relinking SuSE kernel was practically impossible, because of unexpected > dependencies > and kernel not returning the proper version string so that OSS was unable > to recognize it. > Need I say that SuSE Helpdesk was less then helpful? I ended up downloading > the > regular kernel from ftp://ftp.kernel.org <ftp://ftp.kernel.org> compiling > it and ditching the SuSE kernel altogether. > For Thanksgiving, I'll go back to RH, now that they are using standard GNU > CC again. > > -Original Message- > Sent: Monday, November 04, 2002 3:29 AM > To: Multiple recipients of list ORACLE-L > > > I heard that Oracle is shifting it's priorities from Suse toward Red Hat. > > Yechiel Adar > Mehish > > - Original Message - > To: Multiple <mailto:ORACLE-L@;fatcity.com> recipients of list ORACLE-L > Sent: Thursday, October 31, 2002 5:53 PM > > > Hello > > Red Hat advanced server or Suse Enterprise ? > > What is better with Oracle ? > > What is more recent (kernel 2.4.19, asynch I/O, big mem, etc) ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: Farnsworth, Dave 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). _ Surf the Web without missing calls! Get MSN Broadband. http://resourcecenter.msn.com/access/plans/freeactivation.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 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: oracle or mssql
-- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OEM can't seem to discover 1 instance
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: John Weatherman 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: John Weatherman 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). _ Surf the Web without missing calls! Get MSN Broadband. http://resourcecenter.msn.com/access/plans/freeactivation.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OEM can't seem to discover 1 instance
: UNSUB ORACLE-L (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: John Weatherman 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: John Weatherman 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). _ Internet access plans that fit your lifestyle -- join MSN. http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OEM can't seem to discover 1 instance
LE-L (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: John Weatherman 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: Phil Wilson (DBA) 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: John Weatherman 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: Kevin Lange 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). _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough 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: Any way to see the currently running SQL in one session.
This is what I use to see what sql they are running: select c.osuser unix_user, c.process, c.username ora_user, c.sid, c.program, c.terminal, a.sql_text fromv$session c, v$sqlarea a, v$process p where p.addr = c.paddr and c.process is not NULL and c.sql_address = a.address(+) and c.sql_hash_value = a.hash_value(+) and p.spid = &1 order by c.osuser, c.process / >From: ora ak <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Any way to see the currently running SQL in one session. >Date: Wed, 16 Oct 2002 08:04:09 -0800 > > >there is a x$ table which can give u this info I am not able to recall that >at the moment . >oramagic > Paulo Gomes <[EMAIL PROTECTED]> wrote:u could use top sessions > >-Original Message- >Sent: quarta-feira, 16 de Outubro de 2002 2:28 >To: Multiple recipients of list ORACLE-L > > >Dear ALL, > >Is there any way to see the currently running SQL in one session? I >used v$open_cursor, but there might be many SQL statements, I don't know >which one is currently running. And more, if I execute a stored procedure, >which SQL statements could be seen in v$open_cursor? > >Any clues would be much appreciated. > >TIA > >Chuan >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Paulo Gomes >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). > > >- >Do you Yahoo!? >Faith Hill - Exclusive Performances, Videos, & more >faith.yahoo.com _ Internet access plans that fit your lifestyle -- join MSN. http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 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 restore to another node
s > > > were being spontaneously released? Is Oracle > > Support > > > looking into this as a > > > possible bug, and you are just checking to see > > > whether anyone else has > > > experienced this behavior? > > > > > > Dennis Williams > > > DBA > > > Lifetouch, Inc. > > > [EMAIL PROTECTED] > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > -Original Message- > > > From: Johnson Poovathummoottil > > > [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, September 17, 2002 9:02 AM > > > To: DENNIS WILLIAMS; '[EMAIL PROTECTED]' > > > Cc: '[EMAIL PROTECTED]' > > > Subject: RE: RMAN restore to another node > > > > > > > > > Oracle support too pointed to that. I tested with > > > allocating 3 more channnels after 'set newname'. > > But > > > no change. They were released. and same error > > > followed. > > > > > > --- DENNIS WILLIAMS <[EMAIL PROTECTED]> > > wrote: > > > > Johnson > > > >From what I read of your trace file, the > > > channels > > > > are being released, > > > > presumably just before you need them. Do you > > have > > > > that explicitly coded in > > > > your RMAN recovery script, or are they being > > > > released for another reason. My > > > > immediate response is that maybe the problem > > lies > > > in > > > > why those channels are > > > > being released. Can you move your channel > > commands > > > > after the SET NEWNAME > > > > commands? > > > > > > > > Dennis Williams > > > > DBA > > > > Lifetouch, Inc. > > > > [EMAIL PROTECTED] > > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > -Original Message- > > > > From: Johnson Poovathummoottil > > > > [mailto:[EMAIL PROTECTED]] > > > > Sent: Tuesday, September 17, 2002 9:23 AM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: RMAN restore to another node > > > > > > > > > > > > Hi all, > > > > > > > > I am stuck on this restore for two days and > > Oracle > > > > support seems to offering little help. > > > > > > > > I seem to be doing everything according to > > manuals > > > > and > > > > metalink notes but am not able to do the > > restore. > > > > > > > > The case is I am restoring a database to another > > > > node. > > > > I have successfully restore the control file but > > > > when > > > > I tried to restore the database I get > > > > RMAN-06100: no channel to restore a backup or > > copy > > > > of > > > > datafile 1 > > > > for every datafile. > > > > > > > > I am inserting the RMAN trace . I would > > appreciate > > > > if > > > > someone can lead in the right direction. > > > > Recovery Manager: Release 9.2.0.1.0 - Production > > > > > > > > Copyright (c) 1995, 2002, Oracle Corporation. > > All > > > > rights reserved. > > > > > > > > ORACLE_HOME = /opt/Apps/oracle/product/9.2.0 > > > > System name:SunOS > > > > Node name: EdwDev > > > > Release:5.8 > > > > Version:Generic_108528-15 > > > > Machine:sun4u > > > > > > > > Starting with debugging turned off > > > > > > > > connected to target database: DB01 (not mounted) > > > > using target database controlfile instead of > > > > recovery > > > > catalog > > > > > > > > RMAN> > > > > executing command: SET DBID > > > > > > > > RMAN> 2> 3> 4> > > > > allocated channel: ci > > > > channel ci: sid=10 devtype=DISK > > > > > > > > Starting restore at 17-SEP-02 > > > > > > > > channel ci: restoring controlfile > > > > channel ci: restore complete > > > > replicating controlfile > > > > input filename=/extracts1/DB01_temp/ctrl1.ctl > > > > output filename=/extracts1/DB01_temp/ctrl2.ctl > > > > output filename=/extracts1/DB01_tem
RE: recovery question - I know I am missing something
select * from v$logfile. Specify the current logfile.
>From: Kathy Duret <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: recovery question - I know I am missing something
>Date: Thu, 12 Sep 2002 11:08:33 -0800
>
>Let me clarify a bit. I cloned the database from coldbackup .
>
>I opened the database fine, but I goofed up the name. I shutdown the
>database, it hung so I
>did a shutdown abort and forgot to open it up normally before I tried to
>rename the database.
>
>I don't have any archive files created by the wrong named database.
>
>Kathy
>
>-Original Message-
>Sent: Thursday, September 12, 2002 11:38 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Database 8.1.7
>
>Cloning a database that was brought down using shutdown abort.
>
>I know I have done this before and I can't remember what I had to do to
>resolve this.
>
>STARTUP NOMOUNT
>CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS NOARCHIVELOG
>
>RECOVER DATABASE using backup controlfile until cancel
>
>SVRMGR> recover database using backup controlfile until cancel;
>ORA-00279: change 776233169 generated at 09/12/2002 09:58:18 needed for
>thread 1
>ORA-00289: suggestion : /u07/oracle/testdb/8.1.7/dbs/arch1_1.dbf
>ORA-00280: change 776233169 for thread 1 is in sequence #1
>Specify log: {=suggested | filename | AUTO | CANCEL}
>
>CANCEL
>
>ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
>below
>ORA-01194: file 1 needs more recovery to be consistent
>ORA-01110: data file 1: '/testu01/oracle/testdata/system01.dbf'
>
>Thanks
>
>Kathy
>
>
>
>
>Confidential
>This e-mail and any files transmitted with it are the property
>of Belkin Components and/or its affiliates, are confidential,
>and are intended solely for the use of the individual or
>entity to whom this e-mail is addressed. If you are not one
>of the named recipients or otherwise have reason to believe
>that you have received this e-mail in error, please notify the
>sender and delete this message immediately from your computer.
>Any other use, retention, dissemination, forwarding, printing
>or copying of this e-mail is strictly prohibited.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Kathy Duret
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>Confidential
>This e-mail and any files transmitted with it are the property
>of Belkin Components and/or its affiliates, are confidential,
>and are intended solely for the use of the individual or
>entity to whom this e-mail is addressed. If you are not one
>of the named recipients or otherwise have reason to believe
>that you have received this e-mail in error, please notify the
>sender and delete this message immediately from your computer.
>Any other use, retention, dissemination, forwarding, printing
>or copying of this e-mail is strictly prohibited.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Kathy Duret
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike Killough
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Extremely slow query
- > >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=154 Card=6698 Bytes= > > 1024794) > >10 SORT (ORDER BY) (Cost=154 Card=6698 Bytes=1024794) > >21 NESTED LOOPS (Cost=1 Card=6698 Bytes=1024794) > >32 NESTED LOOPS (Cost=1 Card=82 Bytes=10086) > >43 NESTED LOOPS (Cost=7 Card=1 Bytes=80) > >54 NESTED LOOPS (Cost=6 Card=1 Bytes=60) > >65 NESTED LOOPS (Cost=2 Card=1 Bytes=40) > >76 FIXED TABLE (FULL) OF 'X$KSUSE' (Cost=1 Card=1 > > Bytes=20) > >86 FIXED TABLE (FIXED INDEX #1) OF 'X$KSUSE' >(Cost=1 > > Card=1 Bytes=20) > >95 VIEW OF 'GV$_LOCK' > > 109 UNION-ALL > > 11 10 VIEW OF 'GV$_LOCK1' (Cost=2 Card=2 Bytes=40) > > 12 11 UNION-ALL > > 13 12 FIXED TABLE (FULL) OF 'X$KDNSSF' (Cost=1 > > Card=1 Bytes=20) > > 14 12 FIXED TABLE (FULL) OF 'X$KSQEQ' (Cost=1 > > Card=1 Bytes=20) > > 15 10 FIXED TABLE (FULL) OF 'X$KTADM' (Cost=1 Card=1 > > Bytes=20) > > 16 10 FIXED TABLE (FULL) OF 'X$KTCXB' (Cost=1 Card=1 > > Bytes=20) > > 174 FIXED TABLE (FIXED INDEX #1) OF 'X$KSQRS' (Cost=1 > > Card=100 Bytes=2000) > > 183 TABLE ACCESS (BY INDEX ROWID) OF 'OBJ$' (Cost=1 >Card=8168 > > Bytes=351224) > > 19 18 INDEX (UNIQUE SCAN) OF 'I_OBJ1' (UNIQUE) > > 202 TABLE ACCESS (CLUSTER) OF 'USER$' (Cost=1 Card=8168 > > Bytes=245040) > > 21 20 INDEX (UNIQUE SCAN) OF 'I_USER#' (CLUSTER) > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Baker, Barbara > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > ---- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Bunyamin Karadeniz > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: why so much slower
Why don't you try using a leading or ordered hint to get oracle to use the smaller table first? >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: why so much slower >Date: Wed, 05 Jun 2002 12:18:45 -0800 > >more info. It seemed just when I went from two to three tables in a join >there was a very substantial increase in elapsed time. I did join with one >large table and small codetable alone and performed like a champ. H. >Any ideas? > >-Original Message- >Sent: Wednesday, June 05, 2002 3:03 PM >To: '[EMAIL PROTECTED]' > > > >Set sort_area_size to very large as 20Gb (obscene) amount of space >available. >Doing 2 large table outer joins returns results in .341 seconds - both >partitioned on same criteria >added one small codetable equijoin with one of the larger tables. There is >a foreign key to codetable and index that is unique. >Used hash join hint >Used nested loop hint > >Basically saw two large joins sort merged hash join then nested join to >smaller table - much much smaller codetable. > >NO matter what it seems query is much much slower - Any ideas? > > > _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
What makes a fast refresh materialized view too complex?
I am not clear on what will make a fast refresh materialized view too complex. What functions cannot be used in a FRMV that is a single table aggregation? The following example won't work if I try to add the decode: create materialized view log on emp tablespace &&tbsname with sequence, primary key, rowid (job, hiredate, sal, comm) including new values ; create materialized view emp_mv2 tablespace &&tbsname build immediate refresh fast on commit with rowid enable query rewrite as select count(*) n, job, to_char(hiredate,'DD-MON-') hiredate, sum(sal) sum_sal, count(sal) cnt_sal, sum(comm) sum_comm, count(comm) cnt_comm -- , sum(decode(status,'O',sal,comm)), count(decode(status,'O',sal,comm)) -- Add this line and it is not fast refresh. from emp group by job, to_char(hiredate,'DD-MON-') / Thanks, Mike _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fast refresh materialized view is not updateable
Vadim,
I added the field but it still won't fast refresh. When it is first created,
the STALENESS col in dba_mviews = FRESH. When I delete a record in the base
table, it becomes UNUSABLE. A fast refresh gives me this error:
QUESTT:hcl_data> exec
dbms_mview.refresh('scd_financial_summary_pit_mv1','F');
BEGIN dbms_mview.refresh('scd_financial_summary_pit_mv1','F'); END;
*
ERROR at line 1:
ORA-12057: materialized view "HCL_DATA"."SCD_FINANCIAL_SUMMARY_PIT_MV1" is
INVALID and must complete refresh
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 814
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 872
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 852
ORA-06512: at line 1
Mike
>From: Vadim Gorbounov <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Fast refresh materialized view is not updateable
>Date: Tue, 16 Apr 2002 13:53:29 -0800
>
> Mike,
> You missing this field:
>
> count(trn_reserve) cnt_tot_res
>
> Cheers,
>
>Vadim Gorbounov
>Oracle DBA
>724 Solutions Inc.
>Tel:(416)226-2900 ext 5070
>Email: [EMAIL PROTECTED]
>
>
>-Original Message-
>Sent: Tuesday, April 16, 2002 4:14 PM
>To: Multiple recipients of list ORACLE-L
>
>
>I create a fast refresh materialized view that is a single table
>aggregation, but dml on the base table does not update the materialized
>view. In dba_mviews, FAST_REFRESHABLE = DIRLOAD_LIMITEDDML. I think that I
>have satisfied the requirements for a fast refresh MV. I can't see the
>problem. Here is a stripped down version of the view, that can be created,
>but is not updateable:
>
>create materialized view log on scd_financial_detail
>tablespace &&tbsname
>with rowid (claim_carrier_key, eval_date, trn_reserve)
>including new values
>;
>
>create materialized view scd_financial_summary_pit_mv
> tablespace &&tbsname
> build immediate
> refresh fast on commit
> with rowid
> enable query rewrite AS
> select count(*),
>claim_carrier_key,
>eval_date,
>sum(trn_reserve) fin_tot_res
> from scd_financial_detail
> group by
>claim_carrier_key,
>eval_date
>/
>
>Could anyone please tell me what I'm missing?
>
>Thanks,
>
>Mike
>
>
>_
>MSN Photos is the easiest way to share and print your photos:
>http://photos.msn.com/support/worldwide.aspx
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mike Killough
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: 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).
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike Killough
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Fast refresh materialized view is not updateable
I create a fast refresh materialized view that is a single table aggregation, but dml on the base table does not update the materialized view. In dba_mviews, FAST_REFRESHABLE = DIRLOAD_LIMITEDDML. I think that I have satisfied the requirements for a fast refresh MV. I can't see the problem. Here is a stripped down version of the view, that can be created, but is not updateable: create materialized view log on scd_financial_detail tablespace &&tbsname with rowid (claim_carrier_key, eval_date, trn_reserve) including new values ; create materialized view scd_financial_summary_pit_mv tablespace &&tbsname build immediate refresh fast on commit with rowid enable query rewrite AS select count(*), claim_carrier_key, eval_date, sum(trn_reserve) fin_tot_res from scd_financial_detail group by claim_carrier_key, eval_date / Could anyone please tell me what I'm missing? Thanks, Mike _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Java permissions
Could someone please tell me how to see the java permissions granted in the data dictionary from dbms_java.grant_permission, something similiar to dba_sys_privs, dba_role_privs, dba_tab_privs? Mike _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RECOVERY PROBLEM
Greg,
How did you do your hot backup? Did you do the following for each
tablespace?:
alter tablespace begin backup;
!cp datafile1
alter tablespace end backup;
Mike
>From: "Greg Faktor" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RECOVERY PROBLEM
>Date: Wed, 06 Mar 2002 12:48:41 -0800
>
>Hi All!
>I'm trying recovery TEST database from hot backup.
>I create database with a couple tables. Make couple log switches to
>generate redo log files (basically it's generate 3 redo log files:
>arch.log1_15.dbf
>, arch.log1_16.dbf, arch.log1_17.dbf).
>Then I run hot backup and backup all dbf files, redo log files, control
>files and arch redo log files. Shutdown database and delete all files.
>Then I restore all files from hot backup. Then I mount database and run:
>
>SVRMGR> recover database using backup control file until cancel;
>ORA-00279: change 28494 generated at 03/06/02 13:19:24 needed for thread 1
>ORA-00289: suggestion : /u00/app/oracle/admin/TEST/arch/arch.log1_18.dbf
>ORA-00280: change 28494 for thread 1 is in sequence #18
>Specify log: {=suggested | filename | AUTO | CANCEL}
>
>cancel
>
>ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
>below
>ORA-01195: online backup of file 1 needs more recovery to be consistent
>ORA-01110: data file 1: '/ff01uc31/ora_c15d05/TEST/oradata/system01.dbf'
>
>It's looking for arch.log1_18.dbf files, which is, was not they're when I
>run my hot backup.
>Any ideas what I did wrong?
>
>Thanks a lot.
>Oracle 8.1.5 on Digital Unix
>
>Greg.
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Greg Faktor
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
_____
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike Killough
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: RE: Changing dump destinations in init.ora
Chris, Hi there. This is Mike Killough. (this is such a friendly list!) >From: "Grabowy, Chris" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: RE: Changing dump destinations in init.ora >Date: Mon, 25 Feb 2002 07:25:01 -0800 > >Helen, > >Hi there. This is Chris Grabowy. > >-Original Message- >Sent: Monday, February 25, 2002 9:43 AM >To: Multiple recipients of list ORACLE-L > > >Rich, > >Hi there. This is Helen Mitchell. > > > >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Sunday, February 24, 2002 7:58 PM > > > > Yes, the SPFILE is stored in binary format in the database, but you can > > sort of work around it. To create a text file from the SPFILE, you can > > issue: > > > > CREATE PFILE 'pfilename' FROM SPFILE 'filename'; > > > > And vice versa with: > > > > CREATE SPFILE = 'filename' FROM PFILE = 'pfilename'; > > > > When starting the instance, you can also specify an alternate SPFILE: > > > > SQL> startup pfile=filename > > > > There's also some new syntax for the ALTER SYSTEM command to specify the > > scope of the change: > > > > ALTER SYSTEM set parameter = value SCOPE = MEMORY | SPFILE | > > BOTH; > > > > Rich Holland > > Guidance Technologies, Inc. > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of > > > [EMAIL PROTECTED] > > > Sent: Wednesday, February 13, 2002 3:43 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Re:RE: Changing dump destinations in init.ora > > > > > [...] > > > during the discussion on database management it was revealed that init > > > > > files are on the way out, probably in 9i version 2. Their being > > replaced > > > by an SF file that is humanly unreadable and consequently > > unmodifiable. > > > Seems we'll have to do all modifications with the assistance of an > > alter > > > database or alter system command. > > > On the plus side, if your starting a database remotely you'll not need > > a > > > copy of the init.ora locally. > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rich Holland > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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: Helen J Mitchell > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Grabowy, Chris > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: question on EXPLAIN_PLAN
Kevin, Have you analyzed the tables on both databases? Card is the CBO's estimate of the number of rows it will process. Mike >From: "kevin wang" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: question on EXPLAIN_PLAN >Date: Wed, 06 Feb 2002 11:43:38 -0800 > > Hi, guys > > The problem belows is really make me confused and gave me big trouble, >is there someone can give me some hlep? > > I have two databses, same version(oracle 8.1.6),same O/S(win2000), same >schema structure, different data(but small difference of size). > and even exactly same explain_plan of my sql query. > But on one database, the cardinality of one PK index access upon one >table is 27(cost=2,card=27,bytes=756) (table rows 263758) > and the other is 11706 (cost=3,card=11706,bytes=199002)( table rows >351173). > so, on one DB the sql query took 300ms, one the other, it took 5 >seconds! > > Any advise is highly appreciated. > > thanks, > > Kevin Wang > Database Administrator > Vivonet Canada Inc. > > > _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Dump of the buffer cache to trace
Hi, Has anyone run into this error. I had an 8.1.6.3 database on Solaris hang and found hundreds of waits in v$session_wait. I also found the following in the alert.log: Dumping the buffer at level 8 instead of level 0 For full buffer dumps enable the following named event alter session set events 'immediate trace name full_dumps level 1' I found one forum on Metalink in which they said that it's related to bug 791428 and the explaination is that database encountered an internal error which causes a dump of the buffer cache to a trace file. I was not able to find this bug on Metalink. Thanks, Mike _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix - script
It could be faster to remote copy: rcp -p /archive/orcl/arch_1_2290.arc oracle@server2:/archive/orcl/arch_1_2290.arc Mike >From: "Thomas, Kevin" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Unix - script >Date: Wed, 09 Jan 2002 00:35:23 -0800 > >Forgot to mention, the 'cd scripts' line in both examples is not required, >it's just been left in from the script I copied. oops! >K. > >-Original Message- >Sent: 09 January 2002 08:20 >To: Multiple recipients of list ORACLE-L > > >Roland, > >Try this by setting up environment variables at the top of your script: > >SERVER1= 10.10.10.10 >USER1= 'xxx' >PWD1= 'xxx' >SERVER2= 10.10.10.20 >USER1= 'yyy' >PWD2= '' > >Then have this: > >ftp -i -n << EOF >open $SERVER1 >user $USER1 $PWD1 >cd scripts >get >close >EOF > >You can then have a section like the one below if you want to copy to a >different server >other than the one you are running this script from: > >ftp -i -n << EOF >open $SERVER2 >user $USER2 $PWD2 >cd scripts >put >close >EOF > >Both of these can be included in the one shell script. > >Hope that helps. >Kev. > > >'In Windows no one can hear you scream' >__ > >Kevin Thomas >Technical Analyst >Deregulation Services >Calanais Ltd. >(2nd Floor East - Weirs Building) >Tel: 0141 568 2377 >Fax: 0141 568 2366 >http://www.calanais.com > > > > > >-Original Message- >Sent: 09 January 2002 07:16 >To: Multiple recipients of list ORACLE-L > > >Hallo, > >I would like to have an example of a unix script, which does the following: > >copy some files from directory /prod/sas/data located at "hardy".(which is >a computer) >to the other database hakon. Is it possible to do this. Please help me >quick. > > >Thanks in advance > >Roland S > >-- >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: Thomas, Kevin > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(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: Thomas, Kevin > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CHAINED ROWS
Just one thing to add to the instructions to rebuild migrated rows. It says don't forget to disable any foreign key constraints. Don't forget the on delete cascade constraints too. I made that mistake once. Mike >From: "SARKAR, Samir" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: CHAINED ROWS >Date: Wed, 09 Jan 2002 01:56:54 -0800 > >Thanks Jacques...forgot about the Index-organized tables. > >Samir > >Samir Sarkar >Oracle DBA - Lennon Team >SchlumbergerSema >Email : [EMAIL PROTECTED] > [EMAIL PROTECTED] >Phone : +44 (0) 115 - 95 76217 >EPABX : +44 (0) 115 - 957 6418 Ext. 76217 >Fax : +44 (0) 115 - 957 6018 > >-Original Message- >Sent: 08 January 2002 18:56 >To: Multiple recipients of list ORACLE-L > > > >If your chained rows are inside an Index-Organized table, be sure to read >the Oracle manual on the "Analyze" command. There are two versions of the >"chained-row" table, for index-organized tables you should create the >"chained-row" table with universal rowids (head_rowid has datatype urowid). >The "chained-row" table with universal rowids is the one named "...1.sql", >i.e. has a 1 at the end of the file name. > >-Original Message- ><mailto:[EMAIL PROTECTED]> ] > >If Oracle 8i is ur current version, run the utlchain1.sql script available >in ur ORACLE_HOME/rdbms/admin >directory. This will create the chained_rows table for u. >Now analyze the affected table using the command : > >analyze table list chained rows into chained_rows; > >Now when u select from the chained_rows table, u will get the rowid of all >the rows that r chained in the table as >head_rowid. > >The best way to deal with chained rows is to export the table's data, >rebuild the table with a higher pctfree and >import the data back. > >Otherwise, copy the chained rows into a temporary work table in the >following way : > >create table as >select * from where rowid in >(select head_rowid from chained_rows where table_name = '' > and owner_name = ''); > >Then delete the chained rows from the main table in the following way : > > delete from > where rowid in >(select head_rowid from chained_rows where table_name = '' > and owner_name = ''); > >Next, re-insert the chained rows into the table : > >insert into table_name > select * from ; > >Commit ur work. Remember to disable any foreign key constraints during the >deletion stage and re-enable them >again after re-insertion of the rows. >This should eliminate most of ur chained rows. > > >-Original Message- ><mailto:[EMAIL PROTECTED]> ] > >I have seen that There are some number of chained rows in several tables >of >a schema in my database . >What is it done in such a situation ? > > > >___ >This email is confidential and intended solely for the use of the >individual to whom it is addressed. Any views or opinions presented are >solely those of the author and do not necessarily represent those of >SchlumbergerSema. >If you are not the intended recipient, be advised that you have received >this >email in error and that any use, dissemination, forwarding, printing, or >copying of this email is strictly prohibited. > >If you have received this email in error please notify the SchlumbergerSema >Helpdesk by telephone on +44 (0) 121 627 5600. >___ _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hot Backup Recovery Scenario
;(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Performance problem .... HELP :-(
--- > > 0 SELECT STATEMENT GOAL: CHOOSE > > 848 SORT (ORDER BY) > > 11660FILTER > >8790 NESTED LOOPS > >8790 NESTED LOOPS > >8790 NESTED LOOPS > >8790NESTED LOOPS > >8790 NESTED LOOPS > > 25596 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF > > 'FINANCIAL_TRANSACTION_B' > > 25752 INDEX GOAL: ANALYZED (RANGE SCAN) OF > > 'FINANCIAL_TRANSACTION_PK' (UNIQUE) > > 12869 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF > > 'RATE_SCHEDULE_LINK_B' > > 16078 INDEX GOAL: ANALYZED (RANGE SCAN) OF > > 'RATE_SCHEDULE_LINK_PK' (UNIQUE) > > 26131 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF > > 'RATE_VERSION_B' > > 37867 INDEX GOAL: ANALYZED (RANGE SCAN) OF > > 'RATE_VERSION_PK' (UNIQUE) > > 30064TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF > > 'RATE_VERSION_B' > > 41800 INDEX GOAL: ANALYZED (RANGE SCAN) OF > > 'RATE_VERSION_PK' (UNIQUE) > > 11736 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF > > 'BILL_HEADER_B' > > 11736INDEX GOAL: ANALYZED (UNIQUE SCAN) OF > > 'BILL_HEADER_PK' (UNIQUE) > > 23396 INDEX GOAL: ANALYZED (RANGE SCAN) OF > > 'ALLOCATION_TRANSACTION_B_PK' (UNIQUE) > > 667 NESTED LOOPS > >8764 TABLE ACCESS GOAL: ANALYZED (BY ROWID) OF > > 'ACCOUNT_ENTITLEMENT_B' > > 12620 INDEX GOAL: ANALYZED (RANGE SCAN) OF > > 'ACCOUNT_ENTITLEMENT_PK' (UNIQUE) > > 848 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF > > 'INDICATOR_DESC_PK' (UNIQUE) > > > > > > _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Password Changes
Sounds like you had better fess up and ask the user what it is ;-)
If you know ahead of time that this is what you want to do, there is an old
trick to change it and then change it back to the original when done. I just
tried it on 8.1.7 and it still works:
col password old_value pw10
select password from dba_users where username = upper('&1');
alter user &1 identified by temp1;
Open another sqlplus sessions and logon using temp1 as the password. When
you're done, change it back to the original password from the original
session:
alter user &1 identified by values '&pw10';
Mike
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Password Changes
>Date: Thu, 06 Dec 2001 16:36:59 -0800
>
>
>
>It can be seen in dba_users. The table is sys.user$.
>
>Once you've changed it, the old value is gone for good.
>
>Jared
>
>
>
>
>
>
> "Burton, Laura
> L." To: Multiple recipients of
>list ORACLE-L <[EMAIL PROTECTED]>
> plus.com>Subject: Password Changes
> Sent by:
> [EMAIL PROTECTED]
> om
>
>
> 12/06/01 10:29
> AM
> Please respond
> to ORACLE-L
>
>
>
>
>
>
>When you alter a user's password, what table does it update?
>
>
>I need to 'restore' a password for a user back to what it was before I
>changed it, but do not know what it was.
>
>
>Any ideas?? Can this be done?
>
>
>Thanks,
>Laura
>
>
>
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike Killough
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: RMAN disaster recovery
I have never tried to burn my servers to ash, but I usually try to put the rman catalog on a different server than the ones that it is backing up. You also need to backup the catalog, which I do w/ a nightly export. >From: DENNIS WILLIAMS <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RMAN disaster recovery >Date: Fri, 30 Nov 2001 06:25:23 -0800 > >I am wondering how RMAN would work for disaster recovery. Our manager's >statement is "assume your server is reduced to a pile of ash. Now take your >backup tape and build me a new system on a loaner from the vendor." I am >trying to figure how that would work with RMAN. We are still at the stage >of >just using RMAN to create disk copies, and we are on Compaq Tru64 UNIX. He >wants us to demonstrate that level of recoverability, but I'm not sure how >that would work. I think we could assume that we have a database to load >the >RMAN catalog from an export. > One issue would be whether the disk location of the RMAN files might >be different, and I'm not sure how to get RMAN to accept a different >location. A more minor issue is if the database file locations are >different, but I think that is pretty well documented. > Has anyone else tried this? What am I overlooking? Any ideas will be >appreciated. >Dennis Williams >DBA >Lifetouch, Inc. >[EMAIL PROTECTED] > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Control files & Redo Logs
There are advantages to oracle mirroring the redo logs. In the case of corruption, hardware or os level mirroring will duplicate the corruption accross the mirror. In the case of Oracle mirroring, Oracle should detect the corruption and write to the valid redo members. >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Control files & Redo Logs >Date: Fri, 30 Nov 2001 05:45:23 -0800 > >There's no point in mirroring control files on the same disk. Control >files should be mirrored across disks. That way, if one disk crashes you >can get a copy of the current control file from another disk (or just drop >that control file from your init.ora file). Control files are small and >have minimal disk I/O. > >If you are mirroring your disks in hardware there is nothing to be gained >by mirroring control files and redo logs in Oracle. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Poor dc_histogram_defs hit rate
I have a database w/ a library cache hit rate at ~99%, disk cache hit rate ~98%, but the dictionary cache hit rate is 82%. The biggest problem looks like dc_histogram_defs: NameCount UsageModifications Flushes Requests Misses Hit Ratio dc_histogram_defs 11,488 11,487 13,796 13,796 33,969 16,837 66.8600 Does anyone know what would be causing this? Thanks, Mike _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB Monitoring
Define ORA- errors that are critical and grep the alert.log and page if there are errors. Segments that cannot extend. Segments near max extents. Archive log disk space low. Locks. Hit rates, system statistics, etc. >From: "Koivu, Lisa" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: DB Monitoring >Date: Thu, 30 Aug 2001 05:21:31 -0800 > >HI Vivek, off the top of my head: > >Number of extents - any reaching huge numbers? >Tablespaces running out of room? Drives on the host filling up? >Any jobs that have been running over 24 hours? >Possible zombie processes? >Top 10 most resource-intensive queries. Can they be tuned? >utlbstat/utlestat - anything stand out? >And most importantly, is the DATABASE UP? Page immediately if it isn't. > >I'm sure there's much more. This is just a start. And again I advocate >home-cooked scripts in comparison to any gui tool doing this for you. > >Lisa Koivu >VIKINGS FAN and DBA >Ft. Lauderdale, FL, USA > > > > -Original Message- > > From: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]] > > Sent: Thursday, August 30, 2001 3:55 AM > > To: Multiple recipients of list ORACLE-L > > Subject:DB Monitoring > > > > > > What Monitoring Activities Need to be Carried Out on Large Databases ( > > Excess of 100 GB ) ? > > > > Any Experiences , best Practices , Documents , Links ? > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: VIVEK_SHARMA > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: lsnrctl options
The Net8 Administrators Guide may help some too... >From: "Mohammad Rafiq" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: lsnrctl options >Date: Fri, 20 Jul 2001 09:26:22 -0800 > >type 'lsnrctl' on prompt and then type help and you will see all available >option of your version of listener... > >MOHAMMAD RAFIQ > > > >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: Fri, 20 Jul 2001 09:07:50 -0800 > >Where can I find out what syntax options there are for lsnrctl? > >John >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: John Dunn > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Mohammad Rafiq > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _____ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Common Oracle RDBMS Misconceptions - standby db?
ode explained > > > > If this is true then I may be a victim of a disease called > > > > 'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim > > >carrey-MASK style) > > > > Please help me. If some one has few more articles like this >enlighten > > me > > > > > >-- > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > > >-- > > >Author: Jeremiah Wilton > > > INET: [EMAIL PROTECTED] > > > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > >San Diego, California-- Public Internet access / Mailing Lists > > > > > >To REMOVE yourself from this mailing list, send an E-Mail message > > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > >the message BODY, include a line containing: UNSUB ORACLE-L > > >(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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Common Oracle RDBMS Misconceptions
How about timed_statistics=true is a performance overhead.
Or you still worry about temp segments not being released after a sort.
>From: Jeremiah Wilton <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Common Oracle RDBMS Misconceptions
>Date: Tue, 26 Jun 2001 09:05:27 -0800
>
>All right folks, I'm collecting misconceptions, of the type held by newbies
>and
>oldtimers alike. My OOW proposal this year is for a presentation and paper
>on a
>whole laundry list of these things, similar to what I wrote for hot backup.
> I
>want to share what I have so far and solicit input for your favorites (pet
>peeves). I most certainly will credit individuals and this list for any
>ideas I
>glean.
>
>So far my favorite misconceptions are:
>
>* Hot backup stops writing to datafiles
>* All network communication is done through the listener
>* Always 'switch logfile' after (before, inbetween) hot backups
>* Media recovery is required if you crash during backup mode
>* Cold backup once a week ("just in case," "as a 'baseline'")
>* Export is a good way to back up your database
>* Shutdown abort is bad, crash recovery time is as long as 'shutdown
>immediate'
>* Listener.log/alert.log clearing confusion
>* ORA-1555 can be solved by setting transaction (use specific rollback seg)
>* Big batch jobs should use one big RBS
>* ORA-600 means you have corruption / just call support for ORA-600
>* Lots of extents are bad
>* Databases can't be renamed
>* Select count (1) is better than count (*).
>* Listeners have to be started before the instance
>* NOLOGGING turns off logging for all operations
>* Oracle Corp. won't support NFS datafiles
>* checkpoint not complete - misguided solutions
>* Must reinstantiate standby after failover by recopying
>* redolog size change requires outage
>
>What's *your* pet misconception?
>
>--
>Jeremiah Wilton
>http://www.speakeasy.net/~jwilton
>
>On Tue, 26 Jun 2001, novicedba wrote:
>
> > I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
> > I was shocked to read Hot backup mode explained
> > If this is true then I may be a victim of a disease called
> > 'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim
>carrey-MASK style)
> > Please help me. If some one has few more articles like this enlighten me
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jeremiah Wilton
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Mike Killough
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: TUSC and Kevin Loney
And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think Steve Adams is on the hit list. >From: "Rachel Carmichael" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: TUSC and Kevin Loney >Date: Mon, 04 Jun 2001 12:36:50 -0800 > >and Steven Feuerstein works for Quest > > >>From: "Ron Rogers" <[EMAIL PROTECTED]> >>Reply-To: [EMAIL PROTECTED] >>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >>Subject: Re: TUSC and Kevin Loney >>Date: Mon, 04 Jun 2001 12:02:09 -0800 >> >>I just had a meeting with the TUSC organization in Atlanta GA. and Mike >>Ault now works for TUSC also. >>Ron Rogers >>ROR mª¿ªm >> >> >>> [EMAIL PROTECTED] 06/04/01 02:51PM >>> >>I guess I am the last to discover this, but Kevin now works for TUSC. >> >> >>Patrice Boivin >>Systems Analyst (Oracle Certified DBA) >> >>Systems Admin & Operations | Admin. et Exploit. des systèmes >>Technology Services| Services technologiques >>Informatics Branch | Direction de l'informatique >>Maritimes Region, DFO | Région des Maritimes, MPO >> >>E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >> >>-- >>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: 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). > >_ >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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: stupid DBA
line containing: UNSUB > > > > ORACLE-L > > > > (or the name of mailing list you want to be removed > > > > from). You may > > > > also send the HELP command for other information > > > > (like subscribing). > > > > > > > > > __ > > > Do You Yahoo!? > > > Get email at your own domain with Yahoo! Mail. > > > http://personal.mail.yahoo.com/ > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Oracle DBA > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (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: Robert Chen > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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: Michael Sun > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(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: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Invoking svrmgrl
Try putting the connect in the script: shut.sql = connect internal shutdown immediate; exit; svrmgrl @shut >From: "Witold Iwaniec" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Invoking svrmgrl >Date: Thu, 01 Mar 2001 08:16:02 -0800 > >Hi > >In one of my applications, that connects to Oracle database, I >generate a package and have to compile it. The platform of the >application - Windows while database can be on a remote machine. > >I know that from my application I can call sqlplus to compile the >package. For example: > >sqlplus user/password@my_db @c:\temp\my_script.sql > >but I think in some minimal installations you may not have sqlplus >installed. > >I thought about calling svrmgrl but I don't think it accepts command >line parameters. I tried to write small batch file: > >svrmgrl >connect user/password@my_db >@c:\temp\my_script.sql > >But it is not going to work - the problem is that the commands are >executed as three separate commands while I need to write the >batch file so that the connect... and @c:\tmp\... commands are >executed by server manager. Can anyone show me the correct >way to write the batch file? > >Or maybe there is another way - in my application I am already >connected to the database using ODBC API. > >Thanks > >Witold > > > > > >== >Witold Iwaniec >Senior Software Developer >NovaLIS Technologies >[EMAIL PROTECTED] >http://www.novalistech.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Witold Iwaniec > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(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: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to find a listener service without running lsnrctl services
ps -ef | grep lsnrctl | awk -F: '{print $4}'
>From: "Rao, Maheswara" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: How to find a listener service without running lsnrctl services
>Date: Tue, 20 Feb 2001 15:00:26 -0800
>
>Hi DBAs,
>
>I would like to find out whether a specific listener service is up or not
>without running the command ---> lsnrctl services. Is there any way I can
>do this through a shell script or unix command?
>
>My environment : Solaris 2.7 : Oracle 8.0.4
>
>Thanks for your help,
>
>Rao
>
>[EMAIL PROTECTED]
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rao, Maheswara
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
_____
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike Killough
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: How to find a listener service without running lsnrctl servic
Why don't you want to use lsnrctl? Wouldn't this tell you if a listener service is started? $ lsnrctl stat | grep PRD PRD1 has 1 service handler(s) >From: "Mohan, Ross" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: How to find a listener service without running lsnrctl servic >Date: Wed, 21 Feb 2001 06:26:26 -0800 > >hmmmyou could do some grepping in the listener.log i 'spose.. > >-Original Message- >Sent: Wednesday, February 21, 2001 8:06 AM >To: Multiple recipients of list ORACLE-L > > > >Mohan, > > > >Thanks for your suggestion. > > > >Ps -ef | grep tns > gives me only the LISTENER. I would like to know >a >specific service that is started by a listener service or alternately I >would like to grep for a specific service in the listener. For example, if >my listener is starting a service by name - MINT4, I would like to know >that >the service MINT4 is up. > > > >Please suggest a way how to do this without doing lsnrctl services. > > > >Rao > > > >[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > >-Original Message- >Sent: Tuesday, February 20, 2001 6:41 PM >To: Multiple recipients of list ORACLE-L > > > > > >ps -ef | grep tns > > > >-Original Message- ><mailto:[EMAIL PROTECTED]> ] >Sent: Tuesday, February 20, 2001 6:00 PM >To: Multiple recipients of list ORACLE-L > > > >Hi DBAs, > >I would like to find out whether a specific listener service is up or not >without running the command ---> lsnrctl services. Is there any way I can >do this through a shell script or unix command? > >My environment : Solaris 2.7 : Oracle 8.0.4 > >Thanks for your help, > >Rao > >[EMAIL PROTECTED] > > > > > _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OFFTOPIC: Spam.
> > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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: Paul Baumgartel > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > >-- >Charlie Mengler Maintenance Warehouse >[EMAIL PROTECTED] 10641 Scripps Summit Ct >858-831-2229 San Diego, CA 92131 >HOME DEPOT - The Big Boy's Toy store! >-- >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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OFFTOPIC: Spam, Death, the Universe, and Everything
IBE from OraKnowledges email list, please send an email to >href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED] with the >subject >of UNSUBSCRIBE and your email address in the email body. > > > > > > > > > > >Dennis Taylor > >I never metamorphosis I didn't like. > >-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: >Dennis Taylor INET: [EMAIL PROTECTED] >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, >California -- Public Internet access / Mailing Lists > To >REMOVE yourself from this mailing list, send an E-Mail message to: >[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message >BODY, include a line containing: UNSUB ORACLE-L (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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Recovering a failed database copy
Try recover database until cancel; cancel alter database open resetlogs; >From: "Hand, Michael T" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Recovering a failed database copy >Date: Mon, 12 Feb 2001 06:25:23 -0800 > >Fellow DBA's > >System is 8.0.6 on Compaq Tru64 40f > >Normally my database copies go smoothly, without incident. However this >time the rollback parameter on the target system did not match the rollback >segment that existed in the source database. The create controlfile script >ran successfully to rename the database, but when I tryed to "alter >database >open resetlogs;" I got a ORA-1534 rollback segment does not exist. After >correcting the init file and trying this command again I get a ORA-1139 >(resetlogs is now invalid option). Trying to open the database without the >resetlogs option generates a ORA-600 error. ls -l shows that all datafile >have a current datestamp. > >Is there anyway to recover from this without starting the file copy (a >15-18hr process) all over again. > >Thanks, >Mike Hand >Polaroid Corp >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Hand, Michael T > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _____ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: this drove me crazy!!!
on, 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 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: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora-07445
gt; > >Can anyone out there provide some insights on this? Here is one of our >trace files: > > >Dump file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_4674.trc >Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production >PL/SQL Release 8.0.5.2.0 - Production >ORACLE_HOME = /oracle02/app/oracle/product/8.0.5 >System name:SunOS >Node name: auoracle1 >Release:5.6 >Version:Generic_105181-23 >Machine:sun4u >Instance name: ORTE >Redo thread mounted by this instance: 1 >Oracle process number: 35 >Unix process pid: 4674, image: oracleORTE > > >Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), >addr: 0x626c6568, PC: lxdgetobj()+60 >*** 2001.02.05.09.20.39.000 >ksedmp: internal or fatal error >ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV] >[Address not mapped to object] [1651271016] [] [] >- Call Stack Trace - >calling call entryargument values in hex >location type point(? means dubious value) > > > > >Thanks > > >Ana E. Choto >American University >Washington, DC > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: >INET: [EMAIL PROTECTED] > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > > > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: >INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Mohammad Rafiq > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ora-07445
Did you try re-running catalog and catproc and then recompiling invalid objects? We were getting ora-7445 errors on one of our databases last week, and this fixed it. >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: ora-07445 >Date: Mon, 05 Feb 2001 06:55:26 -0800 > >I posted a question to the list last week regarding this error and didn't >get any responses. I'm trying again. We're on Oracle 8.0.5.2.1, and >Solaris 6. > >A few days ago we started receiving ora-07445 errors in the alert log. >This happened when had to reboot the server. If we shutdown/restart the >database the errors went away. Starting Friday the errors are happening >when shutting down/starting up the db. We shutdown the db at midnight and >start it at 2:15 am every day. We get lots of core dumps and trace files >filling up the file system. We clean up the files and start the db, after >that we don't receive the errors anymore until next stop/start the db. > >I have submitted a tar to Oracle support, but so far they haven't come up >with a solution or a cause for this. We made the changes they suggested >but it didn't help. Sun suggested some changes to the hardware, but it >hasn't help either. > >Can anyone out there provide some insights on this? Here is one of our >trace files: > >Dump file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_4674.trc >Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production >PL/SQL Release 8.0.5.2.0 - Production >ORACLE_HOME = /oracle02/app/oracle/product/8.0.5 >System name:SunOS >Node name: auoracle1 >Release:5.6 >Version:Generic_105181-23 >Machine:sun4u >Instance name: ORTE >Redo thread mounted by this instance: 1 >Oracle process number: 35 >Unix process pid: 4674, image: oracleORTE > >Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), >addr: 0x626c6568, PC: lxdgetobj()+60 >*** 2001.02.05.09.20.39.000 >ksedmp: internal or fatal error >ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV] >[Address not mapped to object] [1651271016] [] [] >- Call Stack Trace - >calling call entryargument values in hex >location type point(? means dubious value) > > > >Thanks > >Ana E. Choto >American University >Washington, DC > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman
I agree. But rman comes in handy if you ever have to backup very large databases. Rman will backup the blocks, not the entire datafile, and you can do incremental backups as well. >From: Kimberly Smith <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: rman >Date: Tue, 30 Jan 2001 08:31:12 -0800 > >Sorry, but I do know RMAN and have no desire to go >to it. At least not yet. I have always said if it >ain't broke, don't fix it. Whoever came up with that >saying was a very smart puppy. > >-Original Message- >Sent: Tuesday, January 30, 2001 7:11 AM >To: Multiple recipients of list ORACLE-L > > >Rman works great. Once you learn it, you will never go back. It is one of >the better tools from oracle. > > > >From: "Kevin Kostyszyn" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: rman > >Date: Mon, 29 Jan 2001 12:25:51 -0800 > > > >Really, so does anyone use it? On what versions is it good work? 8.1.6? > >Doesn't matter, I did figure out what I was doing wrong, but that >certainly > >is interesting. > > > >-Original Message- > >Smith > >Sent: Monday, January 29, 2001 1:41 PM > >To: Multiple recipients of list ORACLE-L > > > > > >I can't tell you why that won't work but I can tell you > >that I took a course where one of the attendees was an > >Oracle Support dude and he told me to stay away from Oracle 8.1.5 > >because RMAN just does not work right. Since I do not > >use RMAN I did not get details from him. > > > >-Original Message- > >Sent: Monday, January 29, 2001 10:00 AM > >To: Multiple recipients of list ORACLE-L > > > > > >Could someone please tell me why this won't work? > > > >connect target sys/pwd@orcl nocatalog > > > >WINNT 8.1.5 > > > >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: 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: 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). > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Mike Killough > INET: [EMAIL PROTECTED] >
RE: rman
Rman works great. Once you learn it, you will never go back. It is one of the better tools from oracle. >From: "Kevin Kostyszyn" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: rman >Date: Mon, 29 Jan 2001 12:25:51 -0800 > >Really, so does anyone use it? On what versions is it good work? 8.1.6? >Doesn't matter, I did figure out what I was doing wrong, but that certainly >is interesting. > >-Original Message- >Smith >Sent: Monday, January 29, 2001 1:41 PM >To: Multiple recipients of list ORACLE-L > > >I can't tell you why that won't work but I can tell you >that I took a course where one of the attendees was an >Oracle Support dude and he told me to stay away from Oracle 8.1.5 >because RMAN just does not work right. Since I do not >use RMAN I did not get details from him. > >-Original Message- >Sent: Monday, January 29, 2001 10:00 AM >To: Multiple recipients of list ORACLE-L > > >Could someone please tell me why this won't work? > >connect target sys/pwd@orcl nocatalog > >WINNT 8.1.5 > >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: 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: 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
