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: OEM can't seem to discover 1 instance
-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
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
-- 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
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_temp/ctrl3.ctl Finished restore at 17-SEP-02 released channel: ci RMAN 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 allocated channel: c1 channel c1: sid=10 devtype=DISK allocated channel: c2 channel c2: sid=11 devtype=DISK allocated channel: c3 channel c3: sid=12 devtype=DISK executing command: SET NEWNAME executing command: SET NEWNAME === message truncated === __ Do you Yahoo!? Yahoo! News - Today's headlines http://news.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil 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). _ 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 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: 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: {RET=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
) 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).
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).
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).
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 tbsname begin backup; !cp datafile1 alter tablespace tbsname 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: {RET=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).
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 table_name 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 temp_table_name as select * from table_name where rowid in (select head_rowid from chained_rows where table_name = 'table_name' and owner_name = 'owner_name'); Then delete the chained rows from the main table in the following way : delete from table_name where rowid in (select head_rowid from chained_rows where table_name = 'table_name' and owner_name = 'owner_name'); Next, re-insert the chained rows into the table : insert into table_name select * from temp_table_name; 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: 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 file 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 file 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: Hot Backup Recovery Scenario
You can find out what the current logfile is and then apply the previous ones: MIKEK:system select a.group#,a.member,a.status,b.status,b.bytes 2 from v$logfile a, v$log b 3 where a.group# = b.group# 4 / GROUP# MEMBER STATUSSTATUS BYTES -- - - 1 C:\ORACLE\ORADATA\MIKEK\REDO01A.LOGACTIVE 1,048,576 1 C:\ORACLE\ORADATA\MIKEK\REDO01B.LOGACTIVE 1,048,576 2 C:\ORACLE\ORADATA\MIKEK\REDO02A.LOGACTIVE 1,048,576 2 C:\ORACLE\ORADATA\MIKEK\REDO02B.LOGACTIVE 1,048,576 3 C:\ORACLE\ORADATA\MIKEK\REDO03A.LOGCURRENT 1,048,576 3 C:\ORACLE\ORADATA\MIKEK\REDO03B.LOGCURRENT 1,048,576 4 C:\ORACLE\ORADATA\MIKEK\REDO04A.LOGACTIVE 1,048,576 4 C:\ORACLE\ORADATA\MIKEK\REDO04B.LOGACTIVE 1,048,576 recover database until cancel; apply logfiles C:\ORACLE\ORADATA\MIKEK\REDO01A.LOG and C:\ORACLE\ORADATA\MIKEK\REDO02A.LOG. alter database open resetlogs; Mike From: Kimberly Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Hot Backup Recovery Scenario Date: Thu, 20 Dec 2001 13:05:40 -0800 I have not specifically tried what you are trying to do recently, however, I did implement a standby database using Trusted Oracle 7 in which you had to do it manually. So it should work. You really do need redo logs though. Although you do not specifically need the ones from your other database they need to be in the same location and have the same file name, unless you specifically alter that. What I would do is move over the redo logs as well and open with resetlogs after recovery. But that is cause I am lazy and don't want to recreate them over there. -Original Message- Sent: Thursday, December 20, 2001 12:42 PM To: Multiple recipients of list ORACLE-L List, I am in the middle of testing my backup procedures and have come across something that I'm stuck on. I've read through Velpuri's ver8 book and the Oracle docs but am still having difficulties. I need to restore an entire db from a hot backup, to another server. The above mentioned book and docs address restoring pieces/parts, but not the whole thing. I am backing up datafiles, archived log files and control file to file and trace. No online redo logs. 1. I restore datafiles and archived redo logs. 2. Edit init file, startup nomount 3. Create control file resetlogs (I tried the binary one too) 4. recover database until cancel using backup controlfile. It just keeps asking for log files. If I cancel and open with resetlogs its says my system file still needs media recovery. So, is a hot backup an appropriate means of recovering a database to another server? My cold backups are only every quarter, so rolling forward would be doable but tedious. Any ideas or suggestions? Thanks Joe __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Hatchel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). _ 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
Re: Performance problem .... HELP :-(
(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] BurtonL@prism cc: plus.comSubject: 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: 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).
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).
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
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: Common Oracle RDBMS Misconceptions - standby db?
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
message BODY, include a line containing: UNSUB ORACLE-L (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: Kevin Tsay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 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, Death, the Universe, and Everything
lling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OFFTOPIC: Spam.
cess / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).