Two Instances at one oracle Server
Guru's In my test oracle server, i created two different database with SID 'orclsvr' and 'ora817'. Is't possisle to create two oracle database instances on the same server?. Presently am able to create only one instance at a time either for the sid 'orclsvr' or 'ora817'. Oracle Server 817 on Win NT4 based. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Renaming GLOBAL_NAME
Yes, i too tried still am getting the same result, meaning that, i'm not able to remove the db_domain name in GLOBAL_NAME. Any one have any solutions for this. Nirmal, -Original Message- From: Mario Alberto Ramos Arellano [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 5:25 AM To: Multiple recipients of list ORACLE-L Subject: Re: Renaming GLOBAL_NAME I tried all the suggestions and the only one that worked was updating the global name directly to the table. Mario Alberto Ramos [EMAIL PROTECTED] 17/09/01 16:35 Thank you all for your replies. I bounced the database and still it has the same problem. Regards, Prasad Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] carmichr@hotcc: mail.comSubject: Re: Renaming GLOBAL_NAME Sent by: root@fatcity. com 09/17/2001 03:30 PM Please respond to ORACLE-L you need to reboot your database, changing the init.ora parameter to global_name to false: SQL select value from v$parameter where name like 'global_name%'; VALUE -- FALSE SQL select * from global_name; GLOBAL_NAME -- UREGPROD From: Paul Baumgartel [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Renaming GLOBAL_NAME Date: Mon, 17 Sep 2001 10:05:20 -0800 I don't think you can do this. GLOBAL_NAME by definition consists of the database name and database domain, which defaults to WORLD. Paul Baumgartel --- [EMAIL PROTECTED] wrote: Hi All, I am trying to rename the global_name from SIMSNT7B.WORLD to SIMSNT7B. I issued the following command to change the global_name. ALTER DATABASE RENAME GLOBAL_NAME TO SIMSNT7B; Still it is showing SIMSNT7B.WORLD when I query the global_name view. SQL select * from global_name; GLOBAL_NAME -- SIMSNT7B.WORLD Values for the following parameters in v$parameter view, GLOBAL_NAMES parameter value is FALSE and DB_DOMAIN parameter value is NULL. We are not using Oracle Names server. I renamed SQLNET.ORA file in network\admin location. Init.ora file has global_names set to false. How do I change to SIMSNT7B? This database is on Windows NT and it is 8.1.6. Thanks in advance for your help. Best regards Prasad -- 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). __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- 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). _ 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: 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
Re: Lots and lots of redo logs
I guess this test was in response to a claim that 'you have to put your log files on the inner/outer/middle section of the disc for best response time.' I think this demonstrates that there are never any easy answers - and rarely any conclusive tests other than real-life. One thing you might want to check is whether the average 'redo write size' increases as the writes move through the redo logs (in the second case). You MIGHT be demonstrating that the original hypothesis is true, you MIGHT be demonstrating that in this case LGWR becomes self-balancing - as the disc access speed increases because it buffers more data and does bigger writes, so that the slower seek time is hidden by a side-effect of a larger write. BTW - this is not a fair test of normal OLTP activity - some experiments I've been doing recently suggest that inside a PL/SQL loop the COMMIT does not cause a log file sync - if you check your redo synch writes and redo writes statistics, you may find that redo synch writes is extremely small (possibly 1, possibly 1 per log file) and you redo writes will almost certainly be less than the 15,000,000 commits you issued. I'm still working on the 'commit is not a sync' thing, but it really does seem that in pl/sql a 'commit is complete' BEFORE lgwr has written to disc. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases Screen saver or Life saver: http://www.ud.com Use spare CPU to assist in cancer research. -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 18 September 2001 23:11 | |Out of curiosity and as a test I scrubbed my 16Mb RAID1 array and set it up |again with 5 x 50Mb redo groups. I ran the following script to generate |lots of redo: | |begin | for i in 1..1500 loop | insert into test_table values (mod(i,10)); | delete from test_table where anumber = (mod(i+1,10)); | commit; | end loop; |end; | |ARCHIVELOG mode was on and the archive destination (on another disk) was |initially empty. |There were 239 log switches and the test completed in 2 hours 56 minutes. | |I then added a further 250 50Mb redo groups, cleared the archive |destination and ran the test again. Again it completed in exactly 2 hours |56 minutes, this time 240 log switches (difference of 1, I guess due to |whereabouts in the first log it was when the test started). | |v$session_wait shows permanent log file parallel write for LGWR while the |test runs. | |Any suggestions why I failed to see any slow down when I (almost) filled |the disk with redo groups? (This server wasn't doing anything else and the |time of the test). The RAID1 array had a Linux ext2 filesystem on it and I |had disabled the write cache. | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Two Instances at one oracle Server
Hi, I think you can do that ? Just start up both of them together Sinardy -Original Message- Kumar Muthu Kumaran Sent: Wednesday, 19 September 2001 3:55 PM To: Multiple recipients of list ORACLE-L Guru's In my test oracle server, i created two different database with SID 'orclsvr' and 'ora817'. Is't possisle to create two oracle database instances on the same server?. Presently am able to create only one instance at a time either for the sid 'orclsvr' or 'ora817'. Oracle Server 817 on Win NT4 based. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Error in creating tablespace
Hello list, I'm using Personal Oracle8 Database and Win98 Platform I issued this command from Sqlplus8.0 : CREATE TABLESPACE PAYROLL DATAFILE 'C:\PAYROL.ORA' SIZE 10M SQL / I am trying to create new tablespace Payroll but I have got this error! CREATE TABLESPACE PAYROLL * ERROR at line 1: ORA-19502: write error on file C:\PAYROL.ORA, blockno 1 (blocksize=2048) ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file OSD-04026: Invalid parameter passed. O/S-Error: (OS 64) The specified network name is no longer available. The strange is you can see the PAYROLL.ORA under C:\ Directory After the error is displayed. But when you query : SQL select tablespace_name from dba_data_files; you can find nothing, no tablespace is created at all... I wish someone can help me to solve this problem. Best Regards, Ashraf Salaymeh __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Names in multiple oracle installs
You CANN'T(if not anyone correct me). Even if oracle home, version are different, their SID name should be different. I tested. I'm able to create two databases on one oracle server with different SID, but at a time i can startup only one database. REgards, Nirmal. -Original Message- From: Sujatha Madan [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 4:05 AM To: Multiple recipients of list ORACLE-L Subject: DB Names in multiple oracle installs Hi, Is it possible to call two databases the same name if they are residing on the same machine, in different oracle homes? ... One database is version 8.0.6 and the other is 8.1.7. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sqlplus tunning
Create a single index (index_a) on the two columns in ITEM (no, custsold). Create a second index (index_b on two columns in RTNITEM (no, custrtn). See how the query does once these indexes are created. Then try adding these hints to see if it's any faster: select /*+ index_ffs(i, index_a) index_ffs(r, index_b) */ item.no ... ... from ITEM i, RTNITEM r ... ... Without the indexes you are forcing Oracle to do a full table scan, which is why the query is taking so long. In SQL*Plus, use SET AUTOTRACE ON so you can see the plan and confirm this. With these indexes you will see steps in the plan for the indexes that read, either INDEX (FULL SCAN) or INDEX (FAST FULL SCAN). If your goal is to have the first rows of the query pop up quickly for the user, you want a FULL SCAN of the indexes. If your goal is to have the entire query complete in the shortest amount of time, you want a FAST FULL SCAN of the indexes (which is what the above hints are designed to make happen). Use autotrace and if it still isn't working as fast as you want, copy the explain plan and post it to this list. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 7:40 PM Hi, I have 2 big tables, ITEM (is about 1 million rows) and RTNITEM (is about 20K rows) When I do: SELECT ITEM.no, NVL(SUM(ITEM.CUSTSOLD), 0), NVL(SUM(RTNITEM.CUSTRTN) FROM ITEM, RTNITEM WHERE ITEM.no=RTNITEM.no GROUP BY ITEM.no; Time to execute above query is to long. I tried CREATE OR REPLACE VIEW proc_view_itemsold AS SELECT no, NVL(SUM(custsold, 0)) AS sold FROM item GROUP BY no; CREATE OR REPLACE VIEW proc_view_itemrtn AS SELECT no, NVL(SUM(custrtn, 0)) as return FROM rtnitem GROUP BY no; SELECT i.no, i.sold r.return FROM proc_view_itemsold, proc_view_itemrtn WHERE i.no = r.no; DROP VIEW proc_view_itemsold; DROP VIEW proc_view_itemrtn; The result is the same, it took more than 25 minutes. Do I have to create a temporary tables instead of view to prevent these two giant tables producing a cardinality product ? In this situation is that possible using inner query with where clause again to prevent those giant tables combined? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Two Instances at one oracle Server
How? I started first one, then i try to startup 2nd, it says, Cann't start - already started, shut it down first. Nirmal. -Original Message- From: Sinardy [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Two Instances at one oracle Server Hi, I think you can do that ? Just start up both of them together Sinardy -Original Message- Kumar Muthu Kumaran Sent: Wednesday, 19 September 2001 3:55 PM To: Multiple recipients of list ORACLE-L Guru's In my test oracle server, i created two different database with SID 'orclsvr' and 'ora817'. Is't possisle to create two oracle database instances on the same server?. Presently am able to create only one instance at a time either for the sid 'orclsvr' or 'ora817'. Oracle Server 817 on Win NT4 based. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Looking for 24 X 7 Design Considerations
From: Tracy Rahmlow [EMAIL PROTECTED] Date: Mon, 17 Sep 2001 08:37:30 -0500 Subject: Looking for 24 X 7 Design Considerations We currently have 15+ databases (7.3.4 8i using IBM AIX and HACMP) that do not have a 24x7 restriction. Now, management is looking to bring in new products that will need to be 24X7. They are looking for costs to determine the viability of such a decision. I have no 24x7 experience and am looking for ideas or options to consider. [At least initially they are stating there can be no downtime for maintenance (upgrades/reorgs)] Tracy some other possible sources of info are: Oracle 24x7 Tips and Techniques 0-07-211999-3 High availability Tips, Trick and Techniques for E-Commerce and other mission... from http://www.speakeasy.org/~jwilton/oracle.html Some other papers at: http://www.evdbt.com/library.htm HTH, Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Error in creating tablespace
Hi ... Might be your disk drive currpted, so that oracle unable to create the datafile on that drive, Try do create with some other drive. If not contact oracle support. Nirmal. -Original Message- From: ASHRAF SALAYMEH [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 1:15 PM To: Multiple recipients of list ORACLE-L Subject: Error in creating tablespace Hello list, I'm using Personal Oracle8 Database and Win98 Platform I issued this command from Sqlplus8.0 : CREATE TABLESPACE PAYROLL DATAFILE 'C:\PAYROL.ORA' SIZE 10M SQL / I am trying to create new tablespace Payroll but I have got this error! CREATE TABLESPACE PAYROLL * ERROR at line 1: ORA-19502: write error on file C:\PAYROL.ORA, blockno 1 (blocksize=2048) ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file OSD-04026: Invalid parameter passed. O/S-Error: (OS 64) The specified network name is no longer available. The strange is you can see the PAYROLL.ORA under C:\ Directory After the error is displayed. But when you query : SQL select tablespace_name from dba_data_files; you can find nothing, no tablespace is created at all... I wish someone can help me to solve this problem. Best Regards, Ashraf Salaymeh __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 zip email?
Hi Andrea, What I have is a separate PST file for the Oracle stuff. I have a folder in my main mailbox, and a filter to place all ORACLE-L email in there. Then I have an autoarchive on that to clear out things older than a few days to the separate PST. You can create another PST using the New option in the File menu, then you open it and it will appear alongside the Outlook Today folder at the top level. You can drag and drop messages between PSTs. So, all the Oracle email is eventually stored elsewhere, and I can just unmount that file and move it around, even to another Outlook, just like a transportable tablespace. And in response to the other poster, it's only all in one file by default, you can have many PSTs if you want. I find it always helps to know what you're talking about before blaming other people for your own ignorance. g -Original Message- Sent: Monday, September 17, 2001 6:15 PM To: Multiple recipients of list ORACLE-L Hi all, This is not an Oracle question, but thought peoele on this list might know: I saved many emails about Oracle, Unix in the Microsoft Outlook, and I like to send these information esle where. I'd like to know where are these emails stored in the local or network directory, so I can make a zip. (NT 4.0, Microsoft Outlook 97). Thank you! Andrea __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Error in creating tablespace
Is there enough space on C:? Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: ASHRAF SALAYMEH [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 19. September 2001 12:15 An: Multiple recipients of list ORACLE-L Betreff: Error in creating tablespace Hello list, I'm using Personal Oracle8 Database and Win98 Platform I issued this command from Sqlplus8.0 : CREATE TABLESPACE PAYROLL DATAFILE 'C:\PAYROL.ORA' SIZE 10M SQL / I am trying to create new tablespace Payroll but I have got this error! CREATE TABLESPACE PAYROLL * ERROR at line 1: ORA-19502: write error on file C:\PAYROL.ORA, blockno 1 (blocksize=2048) ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file OSD-04026: Invalid parameter passed. O/S-Error: (OS 64) The specified network name is no longer available. The strange is you can see the PAYROLL.ORA under C:\ Directory After the error is displayed. But when you query : SQL select tablespace_name from dba_data_files; you can find nothing, no tablespace is created at all... I wish someone can help me to solve this problem. Best Regards, Ashraf Salaymeh __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 views in RBO
Title: Materialized views in RBO Our production database runs in RBO. We are evaluating the option of using Materialized views. Oracle manuals says that even if the parameter OPTIMIZER_MODE is set to RULE, the use of these features enables the CBO. Has anyone used this feature in RBO? We tried out materialized views in test area. The are working well in RBO, but this was just basic testing. rgds amar
RE: Accept statement
Sure, Here it is: set serveroutput on; spool d:\temp.sql; accept var_a char prompt 'Enter new location:' declare temp varchar2(520); i number; startpos number; cursor cur1 is select name from v_$datafile; local_var varchar2(100) := var_a; begin DBMS_OUTPUT.ENABLE(1); open cur1; loop fetch cur1 into temp; i:= instr(temp,'\'); startpos:= 0; while i0 loop startpos:= i+1; i:= instr(temp,'\',startpos); end loop; dbms_output.put_line('alter database rename file ' || temp || local_var ||substr(temp,startpos) ||';'); exit when cur1%notfound; end loop; close cur1; end; / spool off; Steven H. -Original Message- Gennick Sent: 18 September 2001 19:25 To: Multiple recipients of list ORACLE-L Tuesday, September 18, 2001, 1:30:17 PM, you wrote: SH I'm am trying to use an accept statement to grab some info from the user in SH an SQL script, SH and then use that in a subsequent PL/SQL block. I can do the Accept ok, but SH can't sem to SH access the variable onside the block. Can anyone point me in the right SH direction? Can you post the part of your script in which you are doing this? Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Where to put your redo logs
Interestingly I had the luxury of playing with a out-of-the-box Solaris server the other day, so (whilst I was meant to be configuring it :-) ), I played around with raw volumes under plain old disk partitions (no veritas, no sds etc). Using straight 'dd' to copy 100m or so, partitions starting at cylinder 1 ran about 20-25% faster than starting at cylinder 7000 (I think) on an 18G 1rpm. So I smacked some redo logs on the low cylinders , then the high ones, and crunched away as hard as I could (in noachivelog). I got about 8-10% improvement in performance - I didn't bother to do any further analysis, I'm guessing the reduction in gain was due to other work the db had to do other then just lgwr. The box is gone now - so I can't repeat the test. Still, for an high update db, it does reinforce the ol' log files on dedicated disks on the outer bits argument. Cheers Connor --- Jonathan Lewis [EMAIL PROTECTED] wrote: I guess this test was in response to a claim that 'you have to put your log files on the inner/outer/middle section of the disc for best response time.' I think this demonstrates that there are never any easy answers - and rarely any conclusive tests other than real-life. One thing you might want to check is whether the average 'redo write size' increases as the writes move through the redo logs (in the second case). You MIGHT be demonstrating that the original hypothesis is true, you MIGHT be demonstrating that in this case LGWR becomes self-balancing - as the disc access speed increases because it buffers more data and does bigger writes, so that the slower seek time is hidden by a side-effect of a larger write. BTW - this is not a fair test of normal OLTP activity - some experiments I've been doing recently suggest that inside a PL/SQL loop the COMMIT does not cause a log file sync - if you check your redo synch writes and redo writes statistics, you may find that redo synch writes is extremely small (possibly 1, possibly 1 per log file) and you redo writes will almost certainly be less than the 15,000,000 commits you issued. I'm still working on the 'commit is not a sync' thing, but it really does seem that in pl/sql a 'commit is complete' BEFORE lgwr has written to disc. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases Screen saver or Life saver: http://www.ud.com Use spare CPU to assist in cancer research. -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 18 September 2001 23:11 | |Out of curiosity and as a test I scrubbed my 16Mb RAID1 array and set it up |again with 5 x 50Mb redo groups. I ran the following script to generate |lots of redo: | |begin | for i in 1..1500 loop | insert into test_table values (mod(i,10)); | delete from test_table where anumber = (mod(i+1,10)); | commit; | end loop; |end; | |ARCHIVELOG mode was on and the archive destination (on another disk) was |initially empty. |There were 239 log switches and the test completed in 2 hours 56 minutes. | |I then added a further 250 50Mb redo groups, cleared the archive |destination and ran the test again. Again it completed in exactly 2 hours |56 minutes, this time 240 log switches (difference of 1, I guess due to |whereabouts in the first log it was when the test started). | |v$session_wait shows permanent log file parallel write for LGWR while the |test runs. | |Any suggestions why I failed to see any slow down when I (almost) filled |the disk with redo groups? (This server wasn't doing anything else and the |time of the test). The RAID1 array had a Linux ext2 filesystem on it and I |had disabled the write cache. | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at
RE: Two Instances at one oracle Server
Hi, I think you must do something like startup pfile=... pfile is your parameter file for 2nd db(your initSID.ora) That error message mean that Oracle try to start db1 again... Sinardy -Original Message- Kumar Muthu Kumaran Sent: Wednesday, 19 September 2001 7:30 PM To: Multiple recipients of list ORACLE-L How? I started first one, then i try to startup 2nd, it says, Cann't start - already started, shut it down first. Nirmal. -Original Message- From: Sinardy [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Two Instances at one oracle Server Hi, I think you can do that ? Just start up both of them together Sinardy -Original Message- Kumar Muthu Kumaran Sent: Wednesday, 19 September 2001 3:55 PM To: Multiple recipients of list ORACLE-L Guru's In my test oracle server, i created two different database with SID 'orclsvr' and 'ora817'. Is't possisle to create two oracle database instances on the same server?. Presently am able to create only one instance at a time either for the sid 'orclsvr' or 'ora817'. Oracle Server 817 on Win NT4 based. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Error in creating tablespace
Title: RE: Error in creating tablespace Is there sufficient space on the C: drive. How big is the file that has been created. If it is less than 10M that may be your problem John -Original Message- From: ASHRAF SALAYMEH [mailto:[EMAIL PROTECTED]] Sent: 19 September 01 11:15 To: Multiple recipients of list ORACLE-L Subject: Error in creating tablespace Hello list, I'm using Personal Oracle8 Database and Win98 Platform I issued this command from Sqlplus8.0 : CREATE TABLESPACE PAYROLL DATAFILE 'C:\PAYROL.ORA' SIZE 10M SQL / I am trying to create new tablespace Payroll but I have got this error! CREATE TABLESPACE PAYROLL * ERROR at line 1: ORA-19502: write error on file C:\PAYROL.ORA, blockno 1 (blocksize=2048) ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file OSD-04026: Invalid parameter passed. O/S-Error: (OS 64) The specified network name is no longer available. The strange is you can see the PAYROLL.ORA under C:\ Directory After the error is displayed. But when you query : SQL select tablespace_name from dba_data_files; you can find nothing, no tablespace is created at all... I wish someone can help me to solve this problem. Best Regards, Ashraf Salaymeh __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
RE: Two Instances at one oracle Server
how do you start the database ? with the servermanager ?? If you do so, so you have to set the variable for the SID value on the value of the other instance. On Unix-maschines it looks like: ORACLE_SID=new_sid export ORACLE_SID Then you are able to start the second instance. Wolfgang Ludewig Nirmal Kumar Muthu Kumaran To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: om.qa Subject: RE: Two Instances at one oracle Server Sent by: [EMAIL PROTECTED] m 19.09.01 13:30 Please respond to ORACLE-L How? I started first one, then i try to startup 2nd, it says, Cann't start - already started, shut it down first. Nirmal. -Original Message- From: Sinardy [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Two Instances at one oracle Server Hi, I think you can do that ? Just start up both of them together Sinardy -Original Message- Kumar Muthu Kumaran Sent: Wednesday, 19 September 2001 3:55 PM To: Multiple recipients of list ORACLE-L Guru's In my test oracle server, i created two different database with SID 'orclsvr' and 'ora817'. Is't possisle to create two oracle database instances on the same server?. Presently am able to create only one instance at a time either for the sid 'orclsvr' or 'ora817'. Oracle Server 817 on Win NT4 based. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also
RE: Two Instances at one oracle Server
Nirmal, Change your Oracle_Sid environmental. Like (from the DOS prompt): *** Starting the first instance set oracle_sid=sid1 sqlplus internal/pwd startup exit; *** Starting the second instance set oracle_sid=sid2 sqlplus internal/pwd startup exit; Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 19, 2001 7:30 AM To: Multiple recipients of list ORACLE-L How? I started first one, then i try to startup 2nd, it says, Cann't start - already started, shut it down first. Nirmal. -Original Message- From: Sinardy [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Two Instances at one oracle Server Hi, I think you can do that ? Just start up both of them together Sinardy -Original Message- Kumar Muthu Kumaran Sent: Wednesday, 19 September 2001 3:55 PM To: Multiple recipients of list ORACLE-L Guru's In my test oracle server, i created two different database with SID 'orclsvr' and 'ora817'. Is't possisle to create two oracle database instances on the same server?. Presently am able to create only one instance at a time either for the sid 'orclsvr' or 'ora817'. Oracle Server 817 on Win NT4 based. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Two Instances at one oracle Server
are you changing your oracle_sid between each startup? --i know an obvious question. joe [EMAIL PROTECTED] 09/19/01 07:30AM How?I started first one, then i try to startup 2nd, it says, "Cann't start -already started, shut it down first".Nirmal. -Original Message- From: Sinardy [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Two Instances at one oracle Server Hi, I think you can do that ? Just start up both of them together Sinardy -Original Message- Kumar Muthu Kumaran Sent: Wednesday, 19 September 2001 3:55 PM To: Multiple recipients of list ORACLE-L Guru's In my test oracle server, i created two different database with SID 'orclsvr' and 'ora817'. Is't possisle to create two oracle database instances on the same server?. Presently am able to create only one instance at a time either for the sid 'orclsvr' or 'ora817'. Oracle Server 817 on Win NT4 based. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: List of changed objects in the DB
Thanks Nick, but this is one time activity so I am looking for simpler solutions. Thanks Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! -Original Message- Sent: Tuesday, September 18, 2001 8:25 PM To: Multiple recipients of list ORACLE-L you might want to take a look at Schema Manager from Quest Software (www.quest.com)... it will not only show you what has changed since the last time you used it... but also build you the code to apply and rollback those changes to different systems... for use when migrating changes from dev to test to pilot and then on to production. It's a great product for change management. Nick *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Two Instances at one oracle Server
Hi, It looks as though you are trying to start the instance from svrmgrl? In that case, use the SET ORACLE_SID=SIDNAME, to force the oracle name before you start svrmgrl. Or try in svrmgrl: connect internal @SIDNAME Another way of doing this is re-create the services using oradim and set starttype to srv,inst. e.g. C:\ ORADIM - STARTUP -SID SID -USERPWD PASSWORD -STARTTYPE SRV,INST That way all you have to do is start the service from service manager and both the service and the instance will start. I hope that helps Denham :) -Original Message- Sent: Wednesday, September 19, 2001 1:30 PM To: Multiple recipients of list ORACLE-L How? I started first one, then i try to startup 2nd, it says, Cann't start - already started, shut it down first. Nirmal. -Original Message- From: Sinardy [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Two Instances at one oracle Server Hi, I think you can do that ? Just start up both of them together Sinardy -Original Message- Kumar Muthu Kumaran Sent: Wednesday, 19 September 2001 3:55 PM To: Multiple recipients of list ORACLE-L Guru's In my test oracle server, i created two different database with SID 'orclsvr' and 'ora817'. Is't possisle to create two oracle database instances on the same server?. Presently am able to create only one instance at a time either for the sid 'orclsvr' or 'ora817'. Oracle Server 817 on Win NT4 based. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Two Instances at one oracle Server
--Boundary-00=_RLTWG6G0 Content-Type: Text/Plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Have u set your ORACLE_SID ?=0D =0D ---Original Message---=0D =0D Date: Wednesday, September 19, 2001 17:35:41=0D To: Multiple recipients of list ORACLE-L=0D =0D How?=0D =0D I started first one, then i try to startup 2nd, it says, Cann't start -=0D already started, shut it down first.=0D =0D Nirmal.=0D =0D -Original Message-=0D From: Sinardy [SMTP:[EMAIL PROTECTED]]=0D Sent: Wednesday, September 19, 2001 12:40 PM=0D To: Multiple recipients of list ORACLE-L=0D Subject: RE: Two Instances at one oracle Server=0D =0D Hi,=0D =0D I think you can do that ?=0D =0D Just start up both of them together=0D =0D =0D =0D Sinardy=0D =0D =0D -Original Message-=0D Kumar Muthu Kumaran=0D Sent: Wednesday, 19 September 2001 3:55 PM=0D To: Multiple recipients of list ORACLE-L=0D =0D =0D Guru's=0D =0D In my test oracle server, i created two different database with SID=0D 'orclsvr' and 'ora817'.=0D =0D Is't possisle to create two oracle database instances on the same serve= r?.=0D =0D =0D Presently am able to create only one instance at a time either for the = sid=0D 'orclsvr' or 'ora817'.=0D =0D Oracle Server 817 on Win NT4 based.=0D =0D Regards,=0D Nirmal.=0D -- =0D Please see the official ORACLE-L FAQ: http://www.orafaq.com=0D -- =0D Author: Nirmal Kumar Muthu Kumaran=0D INET: [EMAIL PROTECTED]=0D =0D Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051=0D San Diego, California -- Public Internet access / Mailing Lists=0D =0D To REMOVE yourself from this mailing list, send an E-Mail message=0D to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in=0D the message BODY, include a line containing: UNSUB ORACLE-L=0D (or the name of mailing list you want to be removed from). You may=0D also send the HELP command for other information (like subscribing).=0D =0D -- =0D Please see the official ORACLE-L FAQ: http://www.orafaq.com=0D -- =0D Author: Sinardy=0D INET: [EMAIL PROTECTED]=0D =0D Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051=0D San Diego, California -- Public Internet access / Mailing Lists=0D =0D To REMOVE yourself from this mailing list, send an E-Mail message=0D to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in=0D the message BODY, include a line containing: UNSUB ORACLE-L=0D (or the name of mailing list you want to be removed from). You may=0D also send the HELP command for other information (like subscribing).=0D -- =0D Please see the official ORACLE-L FAQ: http://www.orafaq.com=0D -- =0D Author: Nirmal Kumar Muthu Kumaran=0D INET: [EMAIL PROTECTED]=0D =0D Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051=0D San Diego, California -- Public Internet access / Mailing Lists=0D =0D To REMOVE yourself from this mailing list, send an E-Mail message=0D to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in=0D the message BODY, include a line containing: UNSUB ORACLE-L=0D (or the name of mailing list you want to be removed from). You may=0D also send the HELP command for other information (like subscribing). --Boundary-00=_RLTWG6G0 Content-Type: Text/HTML; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable meta http-equiv=3DContent-Type content=3Dtext/html; charset=3Diso-885= 9-1html head meta name=3DGENERATOR content=3DIncrediMail 1.0 /head BODY background=3D bgColor=3D#ff style=3DBACKGROUND-POSITION: 0px= 0px; FONT-SIZE: 10pt; MARGIN: 1px; FONT-FAMILY: Arial scroll=3Dyes ORGY= POS=3D0 TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 id=3DINCREDIMAINTABLE w= idth=3D95% TR TD id=3DINCREDITEXTREGION width=3D100% style=3DPADDING-RIGHT: 7px; PA= DDING-LEFT: 7px; FONT-SIZE: 10pt; FONT-FAMILY: Arial=20 DIVHave u set your ORACLE_SID ?/DIV DIVnbsp;/DIV DIV id=3DIncrediOriginalMessageI---Original Message---= /I/DIV DIVnbsp;/DIV DIV id=3Dreceivestrings DIV dir=3Dltr style=3DFONT-SIZE: 11pt iBFrom:/B/I A=20 href=3Dmailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/A/DIV DIV dir=3Dltr style=3DFONT-SIZE: 11pt iBDate:/B/I Wednes= day,=20 September 19, 2001 17:35:41/DIV DIV dir=3Dltr style=3DFONT-SIZE: 11pt iBTo:/B/I A=20 href=3Dmailto:[EMAIL PROTECTED];Multiple recipients of list=20 ORACLE-L/A/DIV DIV dir=3Dltr style=3DFONT-SIZE: 11pt iBSubject:/B/I RE:= Two=20 Instances at one oracle Server/DIV/DIV DIVnbsp;/DIVHow?BRBRI started first one, then i try to sta= rtup=20 2nd, it says, Cann't start -BRalready started, shut it down=20 first.BRBRNirmal.BRBRgt; -Original Message-BRg=
Temp extent sizes and Strange performance problem
I posted earlier about my SQL statement that overnight went from less than 2 minutes to about 25 minutes on our nightly data warehouse loads. We used RMAN to move an exact copy of the database from before the process started running long to a different unix box. After running sql_trace and tkprof on the SQL statement in question (see below) on both the current and pre-problem database, the execution times were similar and the explain plans were identical except for minor differences in the number of rows returned. I then looked at all of the initialization parameters and they look the same except that we created the rman copy with a smaller shared pool (due to resource constraints on the box we moved the copy to). One thing that I noticed was that the extent sizes for the TEMP tablespace is different. The day that we started having this problem, we had a disk failure. The TEMP tablespace was on the failed disk. Another DBA dropped the TEMP tablespace and recreated it on a different disk (apparently with a larger extent size). The current next_extent size is 4194304. The next_extent size on the pre-problem TEMP tablespace is 40960. Is it possible that this difference in extent size in the TEMP tablespace could cause a ten-fold degradation in performance? Cherie Richard Ji [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] m cc: Sent by: Subject: Re: Strange performance problem [EMAIL PROTECTED] om 09/14/01 02:46 PM Please respond to ORACLE-L !! Please do not post Off Topic to this List !! Did you check to see if there is anything else running on the server that might take resource away from Oracle? It has happened to me once that the SA was running something that he shouldn't and it's using a lot of system resources. HTH [EMAIL PROTECTED] 09/14/01 03:05PM !! Please do not post Off Topic to this List !! I have a nightly load job that was being tracked by our developers. According to their nightly logs (going back months), a query was running as far back as they can record with a sub-second response time. Then on a particular date (Aug. 23rd), the query started taking more than 20 minutes to complete. It has taken that long to complete ever since. I looked at the explain plan and it looks o.k. Indexes are being used and there are no suspicious full table scans. The init.ora file has not changed since then. We restored a full copy of the database to an alternate host using rman. It should be an exact copy as of Aug. 16th. I ran the query on the copy and on the current production database and the resulting explain plans were identical except for the number of rows returned. Total execution time and cpu times were similar. I looked through our change documentation and I do not see any record of data structure changes or any data changes at all in the database in question. I am sort of at a loss for what to try next. What sort of changes might cause such an extreme degradation in performance as this? This is an 8.1.7 database on Sun Solaris 2.8. The optimization is rule-based. No partitioning. Database is about 80 Gig in size. Following is the explain plan, if anyone is interested: SELECT ACTV_EAS_PERS_RPT_PROF_VIEW.LOGIN_ID, ACTV_EAS_PERS_RPT_PROF_VIEW.ACCT_GRP_ID, ACTV_EAS_PERS_RPT_PROF_VIEW.RPT_PROF_ID, ACTV_EAS_PERS_RPT_PROF_VIEW.INS_DT_TM, ACTV_EAS_PERS_RPT_PROF_VIEW.UPD_DT_TM FROM GELCO.ACTV_EAS_PERS_RPT_PROF_VIEW call
RE: Lots and lots of redo logs
BTW - this is not a fair test of normal OLTP activity - some experiments I've been doing recently suggest that inside a PL/SQL loop the COMMIT does not cause a log file sync - if you check your redo synch writes and redo writes statistics, you may find that redo synch writes is extremely small (possibly 1, possibly 1 per log file) and you redo writes will almost certainly be less than the 15,000,000 commits you issued. I'm still working on the 'commit is not a sync' thing, but it really does seem that in pl/sql a 'commit is complete' BEFORE lgwr has written to disc. Jonathan, please, keep us in touch with the results (if any) Regards, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Good/Cheap Backup Agent?
Walter, Ruth's suggestion is still a good one. You can use Rman to backup to disk, and then simply copy the Rman files to tape. You get all of the recoverability using RMan, without having to purchase the 3rd party tape interface product (like Legato, Edm etc.). Your costs are : probably an additional disk drive to hold Rman backups Your time to develop and test Rman scripts. Developing Rman scripts will be very easy - there are only a couple of hundred people on this list using Rman, and we all share! Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 18, 2001 6:40 PM To: Multiple recipients of list ORACLE-L I neglected to mention that we're trying to backup to tape. I'm not sure what is involved with configuring a media manager for Oracle that will allow Rman to work with a tape drive but it would seem to me at that point I'm into a 3rd party solution anyway. Yes? No? What does it take to get a tape drive to work with RMAN? If a 3rd party solution is better, then I'm back to inquiring about an inexpensive, but useful, solution. Thanks. -w --- Ruth Gramolini [EMAIL PROTECTED] wrote: Go for it! Rman is cheap (free with Oracle) and works well. You can either run it from OEM (Backup Manager) or directly from the rman prompt or using shell scripts. Good luck, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 3:05 PM Hi, We're looking for an inexpensive backup agent for our databases. The databases are 8i and are on Sun boxes but we're looking to have the agent/client hosted from an NT box (because it appears to be cheaper that way). What are your recommendations? Do all of the agents work through RMAN these days? Are there any features or caveats I should look for? Thanks! -w __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Two Instances at one oracle Server
How are you starting them? Nirmal Kumar Muthu KumaranTo: Multiple recipients of list ORACLE-L NIRMALK@qtel[EMAIL PROTECTED] .com.qa cc: Sent by: Subject: RE: Two Instances at one oracle root@fatcity.Server com 09/19/2001 07:30 AM Please respond to ORACLE-L How? I started first one, then i try to startup 2nd, it says, Cann't start - already started, shut it down first. Nirmal. -Original Message- From: Sinardy [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Two Instances at one oracle Server Hi, I think you can do that ? Just start up both of them together Sinardy -Original Message- Kumar Muthu Kumaran Sent: Wednesday, 19 September 2001 3:55 PM To: Multiple recipients of list ORACLE-L Guru's In my test oracle server, i created two different database with SID 'orclsvr' and 'ora817'. Is't possisle to create two oracle database instances on the same server?. Presently am able to create only one instance at a time either for the sid 'orclsvr' or 'ora817'. Oracle Server 817 on Win NT4 based. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: Need assistance with a 'VIEW'.
Hi, Someone posted the past week the solution of something like that. He referred to create package and pass the date as a parameter to it and have a procedure, inside the package, that create the view using the parameter date. That what I can recall. Good luck, Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de William Rogge Enviado el: Tuesday, 18 September, 2001 10:47 AM Para: Multiple recipients of list ORACLE-L Asunto: Need assistance with a 'VIEW'. I have been given the nice task of creating a view of some data in our database. This doesn't seem like a major task, but after 2 days of work, I am stumped. Given table 'table1' code1, code2, date, value1, value2 I need to produce a view showing code1, code2, sum(value1), sum(value2) where date 'user input date' I have not been able to get the view to prompt for the date to limit the sum by. Specifics: Oracle RDMBS 7.3.4 Server: Unix What else can I say, but I am totally stumped. HELP! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Rogge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ramon Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Determining Oracle status - thanks!
Hi all, I did have a look for oiconnect, but it doesn't seem to there with 8.1.7 - But you've given me more than enough to go with! Thanks for all of your replies they're very much appreciated. Best Regards, Barry. -Original Message- From: Nick Wagner [SMTP:[EMAIL PROTECTED]] Sent: 18 September 2001 19:45 To: Multiple recipients of list ORACLE-L Subject: RE: Determining Oracle status tnsping $ORACLE_SID works pretty well... Nick -Original Message- From: Barry Deevey [ mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 8:46 AM To: Multiple recipients of list ORACLE-L Subject: Determining Oracle status Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem is that when it isn't up, the script hangs and does not return anything - I think that this is because sqlplus by default gives you 3 attempts to logon, so even though the logon attempt failed, it is waiting for you to try again, so unfortunately I'm not getting a failed return code. If anybody could tell me how to change this so that it only allows 1 login attempt before 'kicking you out' or whether there is a better method to finding out the status of an instance, I would be extremely grateful to hear from you. TIA for any responses. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Compiling package
Did he try the SQL*Plus on your machine or his? Perhaps try SQL*Plus on the same machine if you have not already. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 18, 2001 11:00 PM To: Multiple recipients of list ORACLE-L Hello guru I need help on this , I got 2 database reside in 2 server , 1 is a AIX -server , another is a winnt server , everything go smooth when I compile my package( which consist of 10 procedure , 10 function inside)in the winnt server , but when I move my package to another testing server , once I open the package my TOAD slow for a while ,and further when I compile the whole package ..it look stop for 5-10 minute and refresh back to normal status. When I ask my DBA , he compile it straight from sqlplus and under Enterprise manage console , directly w/o any delay . I ask him to try on my user name also the same...fast... He said it might be my TOAD problem , I try to install again my TOAD..it still work back the same ? Any idea how can I troubleshoot it ? Best Regard Raymond Lee ' If you are given an open-book exam, you will forget your book.' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Internal troublemaker
Use the WRAP command. g -Original Message- Sent: Tuesday, September 18, 2001 4:46 PM To: Multiple recipients of list ORACLE-L Hi all, How to ensure our scripts are not changeable by other user, unix and sql script. I remember some unix guru said I need Pro C Can I use embedded Java Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sizeiof table!!!
Select sum(bytes) / 1048576 Size in Mb From dba_extents Where owner = upper('owner') and segment_name = upper('tablename'); Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 18, 2001 1:05 PM To: Multiple recipients of list ORACLE-L Hi gurus, I need get the size in bytes of any table!!! thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i D/l
Mark, Perhaps Oracle have an A and B list. The A list are told as soon as its out, so they can download it quickly. Then the larger B list is told, and they struggle to download it due to demand :-) I too registered to be told when 9i was available for W2k; as soon as I heard about it on the list yesterday morining I started GetRight to download it. When I came in at Lunchtime today it was all downloaded - I was amazed ! Good luck and I hope someone else pays your phone bill! Steve Parker Technical Consultant LIS -- E Mail: [EMAIL PROTECTED] -- Mark Leith mark@cool-too To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ls.co.ukcc: Sent by: Subject: RE: 9i D/l [EMAIL PROTECTED] om 18/09/2001 16:45 Please respond to ORACLE-L You know, this list is the greatest! I specifically submitted my name to the OTN site, to be told *apparently* as soon as the version I am interested in is released - which was 9i for Win2K. Guess what? The first I hear of this being released was HERE!! Still haven't heard anything from Oracle!! Now all I have to do is log on for 3 weeks to try and download it over my 56k modem :) RANT I can't believe that that the download is over a GIG in size!! 8.1.7 was only close to 600 or so meg! We can't get Broadband services here either! In a CITY! Though I hear of people all around the country (even residencies) and small TOWNS etc. that can get ADSL, but here we are in a CITY and a BUSINESS wanting to get the service, and BT can't supply it to us!! Neither can NTL, because BT haven't installed it in our exchange!! Did I mention we are in a CITY?!?! Grumble grumble, moan, grumble, humph... /RANT Mark -Original Message- Gerardo Sent: Tuesday, September 18, 2001 08:05 To: Multiple recipients of list ORACLE-L I think you just have to keep trying. Maybe at different times. I experienced the same as you but with the 9i for Linux download. HTH Gerardo -Original Message- Sent: Monday, September 17, 2001 11:15 PM To: Multiple recipients of list ORACLE-L Hi List Have any of you been successful in d/lng 9i for NT from technet ?? I am getting Server not found. Is there any other mirror fromwhich I can d/l ?? TIA Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VeniVas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing:
RE: DB Names in multiple oracle installs
They could have the same database name but different SIDs. But I think that you're right. I think that he means SID. They can have a different ORACLE_HOME in the listner.ora file and a different connect siring in the TNSNAMES.ORA file (along with a different ORACLE_HOME). I'm not sure if that would be enough to differentiate them though. If you're in a UNIX environment there's still the question of ORACLE_SID. Nirmal Kumar Muthu KumaranTo: Multiple recipients of list ORACLE-L NIRMALK@qtel[EMAIL PROTECTED] .com.qa cc: Sent by: Subject: RE: DB Names in multiple oracle root@fatcity.installs com 09/19/2001 07:18 AM Please respond to ORACLE-L You CANN'T(if not anyone correct me). Even if oracle home, version are different, their SID name should be different. I tested. I'm able to create two databases on one oracle server with different SID, but at a time i can startup only one database. REgards, Nirmal. -Original Message- From: Sujatha Madan [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 4:05 AM To: Multiple recipients of list ORACLE-L Subject: DB Names in multiple oracle installs Hi, Is it possible to call two databases the same name if they are residing on the same machine, in different oracle homes? ... One database is version 8.0.6 and the other is 8.1.7. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sizeiof table!!!
Does anyone have a script that gives actual space used instead of size of extents allocated? Thanks Rick -Original Message- Sent: Wednesday, September 19, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Select sum(bytes) / 1048576 Size in Mb From dba_extents Where owner = upper('owner') and segment_name = upper('tablename'); Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 18, 2001 1:05 PM To: Multiple recipients of list ORACLE-L Hi gurus, I need get the size in bytes of any table!!! thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sqlplus tunning
If you are on 8i, then use, parallel option. If this option is not set, then, you need to put the following parameter in your init.ora and then bounce the db. The parameter is --- PARALLEL_MIN_SERVERS. Give a value of 30 initially. Then, give a hint in your statement for parallel (Please see the manual for exact syntax. Off hand, could not tell you). Then try your query. If you observe significant time difference, then, set other PARALLEL parameters in init.ora to optimize your system. Rao, Maheswara Rao Oracle DBA -Original Message- Sent: Wednesday, September 19, 2001 2:25 AM To: Multiple recipients of list ORACLE-L try nested query in place of sort join method... - Original Message - Date: Wednesday, September 19, 2001 11:10 am Try to use Index for big table ITEM To avoid full table scan. Create index item_index on item(no); This will speed the process... --- Sinardy [EMAIL PROTECTED] wrote: Hi, I have 2 big tables, ITEM (is about 1 million rows) and RTNITEM (is about 20K rows) When I do: SELECT ITEM.no, NVL(SUM(ITEM.CUSTSOLD), 0), NVL(SUM(RTNITEM.CUSTRTN) FROM ITEM, RTNITEM WHERE ITEM.no=RTNITEM.no GROUP BY ITEM.no; Time to execute above query is to long. I tried CREATE OR REPLACE VIEW proc_view_itemsold AS SELECT no, NVL(SUM(custsold, 0)) AS sold FROM item GROUP BY no; CREATE OR REPLACE VIEW proc_view_itemrtn AS SELECT no, NVL(SUM(custrtn, 0)) as return FROM rtnitem GROUP BY no; SELECT i.no, i.sold r.return FROM proc_view_itemsold, proc_view_itemrtn WHERE i.no = r.no; DROP VIEW proc_view_itemsold; DROP VIEW proc_view_itemrtn; The result is the same, it took more than 25 minutes. Do I have to create a temporary tables instead of view to prevent these two giant tables producing a cardinality product ? In this situation is that possible using inner query with where clause again to prevent those giant tables combined? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [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).
Re: Temp extent sizes and Strange performance problem
Its unlikely - but is it possible you had a tempfile before and now a datafile for TEMP? hth connor --- [EMAIL PROTECTED] wrote: I posted earlier about my SQL statement that overnight went from less than 2 minutes to about 25 minutes on our nightly data warehouse loads. We used RMAN to move an exact copy of the database from before the process started running long to a different unix box. After running sql_trace and tkprof on the SQL statement in question (see below) on both the current and pre-problem database, the execution times were similar and the explain plans were identical except for minor differences in the number of rows returned. I then looked at all of the initialization parameters and they look the same except that we created the rman copy with a smaller shared pool (due to resource constraints on the box we moved the copy to). One thing that I noticed was that the extent sizes for the TEMP tablespace is different. The day that we started having this problem, we had a disk failure. The TEMP tablespace was on the failed disk. Another DBA dropped the TEMP tablespace and recreated it on a different disk (apparently with a larger extent size). The current next_extent size is 4194304. The next_extent size on the pre-problem TEMP tablespace is 40960. Is it possible that this difference in extent size in the TEMP tablespace could cause a ten-fold degradation in performance? Cherie Richard Ji [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] m cc: Sent by: Subject: Re: Strange performance problem [EMAIL PROTECTED] om 09/14/01 02:46 PM Please respond to ORACLE-L !! Please do not post Off Topic to this List !! Did you check to see if there is anything else running on the server that might take resource away from Oracle? It has happened to me once that the SA was running something that he shouldn't and it's using a lot of system resources. HTH [EMAIL PROTECTED] 09/14/01 03:05PM !! Please do not post Off Topic to this List !! I have a nightly load job that was being tracked by our developers. According to their nightly logs (going back months), a query was running as far back as they can record with a sub-second response time. Then on a particular date (Aug. 23rd), the query started taking more than 20 minutes to complete. It has taken that long to complete ever since. I looked at the explain plan and it looks o.k. Indexes are being used and there are no suspicious full table scans. The init.ora file has not changed since then. We restored a full copy of the database to an alternate host using rman. It should be an exact copy as of Aug. 16th. I ran the query on the copy and on the current production database and the resulting explain plans were identical except for the number of rows returned. Total execution time and cpu times were similar. I looked through our change documentation and I do not see any record of data structure changes or any data changes at all in the database in question. I am sort of at a loss for what to try next. What sort of changes might cause such an extreme degradation in performance as this? This is an 8.1.7 database on Sun Solaris 2.8. The optimization is rule-based. No partitioning. Database is about 80 Gig in size. Following is the explain plan, if
RE: sizeiof table!!!
Rick Lex, Have you tried the: DBMS_SPACE.unused_space package? It gives used and unused number of bytes and blocks for an item. Below is the syntax: PROCEDURE unused_space(segment_owner IN VARCHAR2, segment_name IN VARCHAR2, segment_type IN VARCHAR2, total_blocks OUT NUMBER, total_bytes OUT NUMBER, unused_blocks OUT NUMBER, unused_bytes OUT NUMBER, last_used_extent_file_id OUT NUMBER, last_used_extent_block_id OUT NUMBER, last_used_block OUT NUMBER, partition_name IN VARCHAR2 DEFAULT NULL ); PRAGMA RESTRICT_REFERENCES(unused_space,WNDS); -- Returns information about unused space in an object (table, index, --or cluster). -- Input arguments: -- segment_owner -- schema name of the segment to be analyzed -- segment_name -- object name of the segment to be analyzed -- partition_name -- partition name of the segment to be analyzed -- segment_type -- type of the segment to be analyzed (TABLE, INDEX, or CLUSTER) -- Output arguments: -- total_blocks -- total number of blocks in the segment -- total_bytes -- the same as above, expressed in bytes -- unused_blocks -- number of blocks which are not used -- unused_bytes -- the same as above, expressed in bytes -- last_used_extent_file_id -- the file ID of the last extent which contains data -- last_used_extent_block_id -- the block ID of the last extent which contains data -- last_used_block -- the last block within this extent which contains data Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 19, 2001 11:05 AM To: Multiple recipients of list ORACLE-L Does anyone have a script that gives actual space used instead of size of extents allocated? Thanks Rick -Original Message- Sent: Wednesday, September 19, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Select sum(bytes) / 1048576 Size in Mb From dba_extents Where owner = upper('owner') and segment_name = upper('tablename'); Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 18, 2001 1:05 PM To: Multiple recipients of list ORACLE-L Hi gurus, I need get the size in bytes of any table!!! thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED]
RE: sizeiof table!!!
Title: RE: sizeiof table!!! Here's a modification of one that I use 1 select 2 tablespace_name, MB_FREE, MB_TOTAL,mb_total-mb_free mb_used, 3 round((MB_TOTAL-MB_FREE)/MB_TOTAL*1000)/10 pct_used 4 from 5 (select tablespace_name, trunc(sum(free_bytes/1024)) MB_FREE , sum(total_bytes/1024) MB_TOTAL 6 from 7 ( 8 (select tablespace_name, sum(bytes)/1024 free_bytes, 9 00 total_bytes 10 from dba_free_space 11 group by tablespace_name) 12 union 13 (select t.tablespace_name tablespace_name, 14 00 free_bytes, 15 sum(d.bytes)/1024 total_bytes 16 from 17 dba_tablespaces t, dba_data_files d 18 where t.tablespace_name = d.tablespace_name 19 group by t.tablespace_name) 20 ) 21 group by tablespace_name) 22 --where mb_free 200 23* order by 1 -Original Message- From: Cale, Rick T (Richard) [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 11:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: sizeiof table!!! Does anyone have a script that gives actual space used instead of size of extents allocated? Thanks Rick -Original Message- Sent: Wednesday, September 19, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Select sum(bytes) / 1048576 Size in Mb From dba_extents Where owner = upper('owner') and segment_name = upper('tablename'); Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 18, 2001 1:05 PM To: Multiple recipients of list ORACLE-L Hi gurus, I need get the size in bytes of any table!!! thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED] Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: List of changed objects in the DB
Raj, If this is the case, then why not take a look at the column in front of last_ddl_timestamp - created - assuming you are getting this from the all_objects view..? Just select * from all_objects where object type = ... and created = whatever.. Will this work for you? Mark -Original Message- Rajendra Sent: Tuesday, September 18, 2001 18:15 To: Multiple recipients of list ORACLE-L Hi all, is it possible to identify only those objects that have changed since a given date? Wait ... I know last_ddl_timestamp but we would like to EXCLUDE stored code which has been recompiled and INCLUDE only those procedures/ functions/ packages that were created. any ideas? TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i D/l
Well, that's gotta be right!! I must be on the B or C list :( (:)) The last time we downloaded (8.1.7) the 580mb file took us two days to download :( Due to the line dropping and having to be restarted etc. So I can't imagine how long it would take for 1.1gig! Luckily an EXTREMELY gracious list member (they know who they are) has downloaded from a high speed line they have available to them, and is going to ship the cds over to me! THANKS AGAIN!! :) Mark -Original Message- [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 15:30 To: Multiple recipients of list ORACLE-L Mark, Perhaps Oracle have an A and B list. The A list are told as soon as its out, so they can download it quickly. Then the larger B list is told, and they struggle to download it due to demand :-) I too registered to be told when 9i was available for W2k; as soon as I heard about it on the list yesterday morining I started GetRight to download it. When I came in at Lunchtime today it was all downloaded - I was amazed ! Good luck and I hope someone else pays your phone bill! Steve Parker Technical Consultant LIS -- E Mail: [EMAIL PROTECTED] -- Mark Leith mark@cool-too To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ls.co.ukcc: Sent by: Subject: RE: 9i D/l [EMAIL PROTECTED] om 18/09/2001 16:45 Please respond to ORACLE-L You know, this list is the greatest! I specifically submitted my name to the OTN site, to be told *apparently* as soon as the version I am interested in is released - which was 9i for Win2K. Guess what? The first I hear of this being released was HERE!! Still haven't heard anything from Oracle!! Now all I have to do is log on for 3 weeks to try and download it over my 56k modem :) RANT I can't believe that that the download is over a GIG in size!! 8.1.7 was only close to 600 or so meg! We can't get Broadband services here either! In a CITY! Though I hear of people all around the country (even residencies) and small TOWNS etc. that can get ADSL, but here we are in a CITY and a BUSINESS wanting to get the service, and BT can't supply it to us!! Neither can NTL, because BT haven't installed it in our exchange!! Did I mention we are in a CITY?!?! Grumble grumble, moan, grumble, humph... /RANT Mark -Original Message- Gerardo Sent: Tuesday, September 18, 2001 08:05 To: Multiple recipients of list ORACLE-L I think you just have to keep trying. Maybe at different times. I experienced the same as you but with the 9i for Linux download. HTH Gerardo -Original Message- Sent: Monday, September 17, 2001 11:15 PM To: Multiple recipients of list ORACLE-L Hi List Have any of you been successful in d/lng 9i for NT from technet ?? I am getting Server not found. Is there any other mirror fromwhich I can d/l ?? TIA Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VeniVas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).
RE: List of changed objects in the DB
Mark, doesn't created refers to when the object was created? I am looking for things that have changed but exclude recompiled objects. Maybe I am not clear in describing the problem ... Thanks for the help Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to move a databse from Solaris to Llinux
Hi all, we have to move a 135 GB Oracle 8.0.6 database from Solaris 7 to Linux. We tried a simple restore of the database files from the last offline backup (tape) as we did it many times between equal systems. After creating the new control file on the target system the database could not be started, becaue Oracle thinks that the system data file isn't really a data file! This means i have to do an export/import! I assume an export time of round about 10 hrs. Is there any easier way? TIA Reinhold Wagner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reinhold Wagner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 move a databse from Solaris to Llinux
Reinhold - My sympathy is with you. I would think that Oracle data files are basically binaries, so just moving them wouldn't work between dissimilar systems. A couple of other ideas for you: If you were on a newer Oracle version, you could try transportable tablespaces. I would tune the receiving database for import speed. Turn off archiving. Large log buffers, etc. Full export without the rows, import that in the new system. Create a database link between the two (my studies have shown that to be the fastest, but other people may report better luck with other methods, depending on factors like your network speed) and use SQL*Net COPY to move them, committing as you go. Unfortunately, if it bombs off in the middle of a table, you have to do that table again. For your largest tables, you may want to pick a data key like year and do a year at a time. Good luck. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 19, 2001 11:47 AM To: Multiple recipients of list ORACLE-L Hi all, we have to move a 135 GB Oracle 8.0.6 database from Solaris 7 to Linux. We tried a simple restore of the database files from the last offline backup (tape) as we did it many times between equal systems. After creating the new control file on the target system the database could not be started, becaue Oracle thinks that the system data file isn't really a data file! This means i have to do an export/import! I assume an export time of round about 10 hrs. Is there any easier way? TIA Reinhold Wagner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reinhold Wagner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CLOB trigger problem
Is the transaction committed by the client prior to your using the CLOB PL/SQL? -Original Message- Sent: Wednesday, September 19, 2001 2:15 AM To: Multiple recipients of list ORACLE-L Dear listers, I am trying to copy an updated CLOB from a table in one database (let's call it A) to the equivalent table in another database (called B just to be original). I have written triggers and procedures to do this (one package on each database), and I am passing the contents of the CLOB to the remote update procedure as VARCHAR fields in a PL/SQL table. Everything works perfectly well when I run an update against table A. I am connecting via TOAD and am logged on to Oracle as the schema owner. The contents of the CLOB are retrieved, passed across and used to update the remote table. When the client updates the CLOB in table A, however, the select statement in my package on database A which 'locates' the CLOB, retrieves a CLOB of zero length. No exception occurs in the Select statement. The client's update succeeds on table A, and my package sends an empty PL/SQL table to the remote procedure (and the CLOB on the remote table is duly erased). The client is connecting through an ASP-driven web interface via IIS, which as far as I can tell is also logging on to Oracle as the schema owner. Anyone encountered this sort of behaviour before? I've just about run out of ideas. If I can't solve this by direct means I can probably do something kludgy like launch the remote update as a background process via DBMS_JOB.SUBMIT, but I'd far rather have it under transactional control. Oracle version is 8.1.6.3 on both databases. Can supply contents of triggers etc. if needed. Cheers, James Campbell [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Campbell, James INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Godlewski, Melissa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 move a databse from Solaris to Llinux
You cannot move data files from one OS to a different one due to the differences in how they write to files. Import and Export is generally the accepted way to do this. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, September 19, 2001 12:47 PM To: Multiple recipients of list ORACLE-L Hi all, we have to move a 135 GB Oracle 8.0.6 database from Solaris 7 to Linux. We tried a simple restore of the database files from the last offline backup (tape) as we did it many times between equal systems. After creating the new control file on the target system the database could not be started, becaue Oracle thinks that the system data file isn't really a data file! This means i have to do an export/import! I assume an export time of round about 10 hrs. Is there any easier way? TIA Reinhold Wagner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reinhold Wagner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 move a databse from Solaris to Llinux
EXPORT IMPORT (could be done in parallel: many export import sessions for different schemas or tables). -Original Message- Sent: Wednesday, September 19, 2001 12:47 PM To: Multiple recipients of list ORACLE-L Hi all, we have to move a 135 GB Oracle 8.0.6 database from Solaris 7 to Linux. We tried a simple restore of the database files from the last offline backup (tape) as we did it many times between equal systems. After creating the new control file on the target system the database could not be started, becaue Oracle thinks that the system data file isn't really a data file! This means i have to do an export/import! I assume an export time of round about 10 hrs. Is there any easier way? TIA Reinhold Wagner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reinhold Wagner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Error in creating tablespace
Jared, Can you check that my email is actually getting through to the list. I realise this is a bit dumb, cause if you get this then it is...but I can't actually see any of my mails when and if they hit the list. I used to be able to but no more... :( Cheers, Kev. hit any user to continue __ 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 -- 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).
Re: How to move a databse from Solaris to Llinux
-- Reinhold Wagner [EMAIL PROTECTED] This means i have to do an export/import! Yup. If you have sufficient disk+cpu capacity you can export and import multiple tables at once, if the database is partitioned you may be able to unload multiple partitions at once. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 move a databse from Solaris to Llinux
You can't use backup and restore to move a database between different platforms. A while ago, someone on this list posted a message that he/she was going to make a tool that allows this to happen. But until then, you will have to do export and import. Richard Ji [EMAIL PROTECTED] 09/19/01 12:46PM Hi all, we have to move a 135 GB Oracle 8.0.6 database from Solaris 7 to Linux. We tried a simple restore of the database files from the last offline backup (tape) as we did it many times between equal systems. After creating the new control file on the target system the database could not be started, becaue Oracle thinks that the system data file isn't really a data file! This means i have to do an export/import! I assume an export time of round about 10 hrs. Is there any easier way? TIA Reinhold Wagner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reinhold Wagner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Error in creating tablespace
Title: RE: Error in creating tablespace Kevin, I am replying to the list and to you directly, you are getting through to the list. I think there is a way to set up the subscription such that you don't get your own mails. In any case, you will definitely get one answer. you should get this twice Rachel -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: Error in creating tablespace Jared, Can you check that my email is actually getting through to the list. I realise this is a bit dumb, cause if you get this then it is...but I can't actually see any of my mails when and if they hit the list. I used to be able to but no more... :( Cheers, Kev. hit any user to continue __ 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 -- 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).
export with filesize option, dump file size estimation
Title: export with filesize option, dump file size estimation any idea on how to estimate the export dump file size without doing an actual export (not even to /dev/null)? the idea is to use filesize option of export utility to export db to several files. i am aware of using pipe/split to do large export. thanks, bill
Upgrade Oracle from 8.1.7 Release 3 to 9.0.1
Hello i want to upgrade my database from 8.1.7 to 9.0.1 system: windows 2000 server sp1 2 oracle database instances i've installed the oracle 9i software on the server (seperate home ..) now i want to the update via the oracle data migration assistant i specify my password and my correct path to initxxx.ora file then i click next and become the following error tns-12560 ... my network configuration works because i can connect to my database ! when i start svrmgrl on the command line i become the same error tns-12560 when i do "connect internal/pwd@dbtest" it works ! i've allready set the oracle_sid parameter in the registry ! any ideas ?
Re: How to move a databse from Solaris to Llinux
I don't know if the method of moving data files will work or not. Since you are on Oracle 8.0.x, transportable tablespaces aren't an option. However, there are several other options that I have used. None are particularly easy though! One is to export/import via a named pipe - running multiple jobs of several tables each in parallel with indexes=N and constraints=N on the export, then building the indexes and constraints on the target as the exports finish. This is, in my experience, a lot faster that full export/import and significantly faster that table-level export/import with indexes constraints. It is a lot more work to set up to optimize the process though - users, roles, grants, indexes, constraints, stored code, views, sequences, etc. all have to be handled outside the table exports/imports that just move the data. Another is to use the SQL copy command - again running multiple jobs in parallel and building indexes and constraints as tables are completed on the target. This involves the same kind of considerations as above. Both are much more labor-intensive than normal exports (with indexes and constraints), but are also significantly faster. I have moved several 120-200+ GB databases concurrently from Oracle7 in one data center to Oracle8i in a new data center 200 miles away using these techniques and all were completed and back up in under 12 hours. Timing, coordination and practice are critical. In our case, I had over a month (part-time) to rehearse, refine and tune the migration. Staging, if possible is very beneficial. Sometimes the largest tables are static except during specific batch activity. If so, you might be able to schedule the migration so that these can start during a batch window and well before others - reducing the downtime for the move. In one such case, a 250 GB database with about 75% historical data updated only in batch, total migration time was over 16 hours but downtime was less than an hour. -Don Granaman [OraSaurus - Honk if you remember UFI!] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 11:46 AM Hi all, we have to move a 135 GB Oracle 8.0.6 database from Solaris 7 to Linux. We tried a simple restore of the database files from the last offline backup (tape) as we did it many times between equal systems. After creating the new control file on the target system the database could not be started, becaue Oracle thinks that the system data file isn't really a data file! This means i have to do an export/import! I assume an export time of round about 10 hrs. Is there any easier way? TIA Reinhold Wagner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reinhold Wagner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to move a databse from Solaris to Llinux
On the same lines I think I had seen on the list some time back a script to import from an export into a named pipe. It was supposed to be very fast. I am shell script challenged. Essentially it was exported into a named pipe which was simultaneously imported. Maybe the author can post it again. Khedr, Waleed wrote: EXPORT IMPORT (could be done in parallel: many export import sessions for different schemas or tables). -Original Message- Sent: Wednesday, September 19, 2001 12:47 PM To: Multiple recipients of list ORACLE-L Hi all, we have to move a 135 GB Oracle 8.0.6 database from Solaris 7 to Linux. We tried a simple restore of the database files from the last offline backup (tape) as we did it many times between equal systems. After creating the new control file on the target system the database could not be started, becaue Oracle thinks that the system data file isn't really a data file! This means i have to do an export/import! I assume an export time of round about 10 hrs. Is there any easier way? TIA Reinhold Wagner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reinhold Wagner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sqlplus tunning
I thought that hash_join was supposed to be best where you had one table much smaller than the other. As there are no restrictions on the data being brought back what is wrong with doing a full table scan of each?. -Original Message- Sent: 19 September 2001 07:25 To: Multiple recipients of list ORACLE-L try nested query in place of sort join method... - Original Message - Date: Wednesday, September 19, 2001 11:10 am Try to use Index for big table ITEM To avoid full table scan. Create index item_index on item(no); This will speed the process... --- Sinardy [EMAIL PROTECTED] wrote: Hi, I have 2 big tables, ITEM (is about 1 million rows) and RTNITEM (is about 20K rows) When I do: SELECT ITEM.no, NVL(SUM(ITEM.CUSTSOLD), 0), NVL(SUM(RTNITEM.CUSTRTN) FROM ITEM, RTNITEM WHERE ITEM.no=RTNITEM.no GROUP BY ITEM.no; Time to execute above query is to long. I tried CREATE OR REPLACE VIEW proc_view_itemsold AS SELECT no, NVL(SUM(custsold, 0)) AS sold FROM item GROUP BY no; CREATE OR REPLACE VIEW proc_view_itemrtn AS SELECT no, NVL(SUM(custrtn, 0)) as return FROM rtnitem GROUP BY no; SELECT i.no, i.sold r.return FROM proc_view_itemsold, proc_view_itemrtn WHERE i.no = r.no; DROP VIEW proc_view_itemsold; DROP VIEW proc_view_itemrtn; The result is the same, it took more than 25 minutes. Do I have to create a temporary tables instead of view to prevent these two giant tables producing a cardinality product ? In this situation is that possible using inner query with where clause again to prevent those giant tables combined? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --- - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --- - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sqlplus tunning
Doh!. I guess I should have looked at what the table names suggest the restriction is. Sorry! Iain Nicoll -Original Message- Sent: 19 September 2001 18:30 To: '[EMAIL PROTECTED]' I thought that hash_join was supposed to be best where you had one table much smaller than the other. As there are no restrictions on the data being brought back what is wrong with doing a full table scan of each?. -Original Message- Sent: 19 September 2001 07:25 To: Multiple recipients of list ORACLE-L try nested query in place of sort join method... - Original Message - Date: Wednesday, September 19, 2001 11:10 am Try to use Index for big table ITEM To avoid full table scan. Create index item_index on item(no); This will speed the process... --- Sinardy [EMAIL PROTECTED] wrote: Hi, I have 2 big tables, ITEM (is about 1 million rows) and RTNITEM (is about 20K rows) When I do: SELECT ITEM.no, NVL(SUM(ITEM.CUSTSOLD), 0), NVL(SUM(RTNITEM.CUSTRTN) FROM ITEM, RTNITEM WHERE ITEM.no=RTNITEM.no GROUP BY ITEM.no; Time to execute above query is to long. I tried CREATE OR REPLACE VIEW proc_view_itemsold AS SELECT no, NVL(SUM(custsold, 0)) AS sold FROM item GROUP BY no; CREATE OR REPLACE VIEW proc_view_itemrtn AS SELECT no, NVL(SUM(custrtn, 0)) as return FROM rtnitem GROUP BY no; SELECT i.no, i.sold r.return FROM proc_view_itemsold, proc_view_itemrtn WHERE i.no = r.no; DROP VIEW proc_view_itemsold; DROP VIEW proc_view_itemrtn; The result is the same, it took more than 25 minutes. Do I have to create a temporary tables instead of view to prevent these two giant tables producing a cardinality product ? In this situation is that possible using inner query with where clause again to prevent those giant tables combined? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --- - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --- - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: export with filesize option, dump file size estimation
why not take the size of the tablespaces with data(not indexes, u do have your indexes in separate tablespaces right?), divide by 1.9G and put that many filenames on the command line, you can't have too many, oracle wont use the extra but if you're short, you lose. joe [EMAIL PROTECTED] 09/19/01 02:10PM any idea on how to estimate the export dump file size without doing an actual export (not even to /dev/null)? the idea is to use filesize option of export utility to export db to several files. i am aware of using pipe/split to do large export. thanks, bill
external procedure in Oracle
Title: external procedure in Oracle external procedure is only available after V8.0, right? before V8.0, any way to use C programs in pl/sql or sql code? thank, bill
Re: Upgrade Oracle from 8.1.7 Release 3 to 9.0.1
last i checked the migration guide, there was only a script to run(on linux platform at least), to upgrade from 8.1.x to 9.0.1 it wasrun (at least that) $ORACLE_HOME./rdbms/admin/u0801070.sql joe [EMAIL PROTECTED] 09/19/01 02:20PM Hello i want to upgrade my database from 8.1.7 to 9.0.1 system: windows 2000 server sp1 2 oracle database instances i've installed the oracle 9i software on the server (seperate home ..) now i want to the update via the oracle data migration assistant i specify my password and my correct path to initxxx.ora file then i click next and become the following error tns-12560 ... my network configuration works because i can connect to my database ! when i start svrmgrl on the command line i become the same error tns-12560 when i do "connect internal/pwd@dbtest" it works ! i've allready set the oracle_sid parameter in the registry ! any ideas ?
RE: Copy Oracle's binary.
One more thing, be careful that if you do this that you change the listener.ora file to point to the new hostname. Otherwise you can accidently shut down the listener on the other server. -Original Message- Sent: Monday, September 17, 2001 6:31 PM To: Multiple recipients of list ORACLE-L Hello, I've two machines (with the same unix's configuration on Sun Solaris). On has Oracle 8.1.7. installed and a database. Do you think it's possible to copy Oracle's binary and the database on Unix level to the new serveur instead of installing and cloning the db ? Thank you very much. Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Upgrade Oracle from 8.1.7 Release 3 to 9.0.1
i guess my other comment is "why trust oracle to mess up the upgrade with their tool, when you follow the instructions and do a manual upgrade?" joe [EMAIL PROTECTED] 09/19/01 02:20PM Hello i want to upgrade my database from 8.1.7 to 9.0.1 system: windows 2000 server sp1 2 oracle database instances i've installed the oracle 9i software on the server (seperate home ..) now i want to the update via the oracle data migration assistant i specify my password and my correct path to initxxx.ora file then i click next and become the following error tns-12560 ... my network configuration works because i can connect to my database ! when i start svrmgrl on the command line i become the same error tns-12560 when i do "connect internal/pwd@dbtest" it works ! i've allready set the oracle_sid parameter in the registry ! any ideas ?
RE: time synchronization
Ed, Get your SAs to take a look at NTP (Network Time Protocol). You can setup an NTP server and use NTP clients to sync up to it easily. In the case when an NTP client catches up with the server, it just reduces or increases the 1/100 sec time clicks so that the time is caught up over a period of time and even seconds are not missed. John - you may also be missing cron jobs (and Oracle Apps scheduled concurrent manager jobs in case you are using Apps) in case you take an abrupt jump. John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- Sent: Tuesday, September 18, 2001 4:45 PM To: Multiple recipients of list ORACLE-L Oracle is designed to handle time changes. For example switching to and from daylight savings. This is because the archive logging is not dependent on a date. It has its own sequence. Therefore changing the date and time even while oracle is up is no problem. I have done this many times for testing. The only thing to watch for is if you are using DBMS_JOBS. Changing the time may cause a job not to execute or to run when you don't want it to. Just make sure there is no time conflict with any of these jobs and also 'cron' jobs and go ahead and change the time. I believe your backup strategy is an overkill which I personally would not do but you decide if you would feel safer with the backups, then go ahead with your plan. HTH, John [EMAIL PROTECTED] 09/18/01 08:46AM Hi List, we have about 2 min difference between the time on our db server and the rest boxes in our network. Actually, the time on DB server is 2min slow than the network time.It causes real pain to us. I think about the following order of time synchronization: 1. Normal shutdown the DB and listener 2. immediate cold backup 2. setup time synchronization on the unix level 3. startup the DB and listener 4. Normal shutdown DB and listener 5. immediate cold backup 6. startup DB and listener Is this correct ? Any possible troubles? Any good links? Thanks in advance, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Copy Oracle's binary.
We do it all the time and it works fine. We make sure everything is shutdown first. We also do the copy as root just to make sure we get everything. May not be required but it is safer. Ron -Original Message- Sent: Wednesday, September 19, 2001 1:36 PM To: Multiple recipients of list ORACLE-L One more thing, be careful that if you do this that you change the listener.ora file to point to the new hostname. Otherwise you can accidently shut down the listener on the other server. -Original Message- Sent: Monday, September 17, 2001 6:31 PM To: Multiple recipients of list ORACLE-L Hello, I've two machines (with the same unix's configuration on Sun Solaris). On has Oracle 8.1.7. installed and a database. Do you think it's possible to copy Oracle's binary and the database on Unix level to the new serveur instead of installing and cloning the db ? Thank you very much. Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: export with filesize option, dump file size estimation
Title: export with filesize option, dump file size estimation This came up a few weeks ago and as I recall there was no firm answer. Suggestions included summing the bytes from dba_extents where owner != 'sys' or guessing. I always work on a theory of about 20-25% of the space used (i.e sum of all the datafiles minus sum from dba_free_space) John -Original Message-From: Chen, Bill [mailto:[EMAIL PROTECTED]]Sent: 19 September 01 19:10To: Multiple recipients of list ORACLE-LSubject: export with filesize option, dump file size estimation any idea on how to estimate the export dump file size without doing an actual export (not even to /dev/null)? the idea is to use filesize option of export utility to export db to several files. i am aware of using pipe/split to do large export. thanks, bill ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
Response files for 8.1.7
Anyone have a *working* response file for a minimal install on Linux/Solaris they want to share? The docs are very bare and the error logs are well, not too helpful. TIA john f. lewis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
No Subject
Any idea's folks? I'm running a DEC Alpha 4100, DEC Unix 4.0d. I've just installed 8.1.6 with patch 8.1.6.2 and the sqlnet patch 1399208. When I try to start the listener I get the following errors: Script started on Wed Sep 19 12:04:14 2001 % ln^H ^Hsnrctl LSNRCTL for DEC OSF/1 AXP: Version 8.1.6.0.0 - Production on 19-SEP-2001 12:04:17 (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved. Welcome to LSNRCTL, type help for information. LSNRCTL start Starting /1091/oracle/product/816/bin/tnslsnr: please wait... Internal AIO consistency error: Cannot use libaio_raw with threads. Either relink without -pthread or link -laio, not -laio_raw. Aborting... TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact DEC OSF/1 AXP Error: 32: Broken pipe LSNRCTL exit Here's my listener.ora also: # LISTENER.ORA Configuration File:/1091/oracle/product/816/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = mufasa)(PORT = 1525)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = mufasa)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /1091/oracle/product/816) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = PREP) (ORACLE_HOME = /1091/oracle/product/816) (SID_NAME = PREP) ) ) ADMIN_RESTRICTIONS_LISTENER=ON -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe LaCascio INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 move a databse from Solaris to Llinux
Even transportable tablespaces aren't an option between different OSes From 8.1.7 docs: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76965/c03space.htm#5759 In the current release, you can transport tablespaces only between Oracle databases that use the same data block size and character set, and that run on compatible platforms from the same hardware vendor. -Joe _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Bulk collect error
Hi, The following statment works perfectly: Select F.Fofejezet_Megnevezes_Magyar,F.FOFEJEZET_AZONOSITO2, (Select Count(*) from alfejezet where alfejezet.ALFEJEZET_FOFEJEZET_AZONOSITO2= F.Fofejezet_Azonosito2) From Fofejezet F ; However when I put this very same statement into a Pl/Sql procedure with Bulk Collect, I get PLS-00103 error: Select F.Fofejezet_Megnevezes_Magyar,F.FOFEJEZET_AZONOSITO2, (Select Count(*) from alfejezet where alfejezet.ALFEJEZET_FOFEJEZET_AZONOSITO2= F.Fofejezet_Azonosito2) Bulk Collect Into Vissza.FoFejezetNev,Vissza.FoFejezetKod,Vissza.Darab From Fofejezet F ; Can somebody help me? Thank you Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sqlplus tunning
As there are no restrictions on the data being brought back what is wrong with doing a full table scan of each? True there are no restrictions. The query is not going to return just one row where product number = 443. It's going to cover all of both tables it joins. A simple unrestricted join of two tables will be faster if you just do a full table scan, you avoid the overhead of also looking at the indexes. But when SUM / GROUP BY are added this general rule doesn't apply and indexes will help significantly. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sqlplus tunning
I thought that hash_join was supposed to be best Just tried it both ways, with nested loops and hash join, on tables with the right indexes. Nested loops has elapsed time of 10 seconds, hash join is 5 seconds. However, the hash join spends about 4 seconds building the hash table before any results start to come back. The nested loops starts returning rows right away -- so if you are returning data to a user's screen nested loops would be a better choice even thought it takes longer because they see results right away -- by the time they read the first screen and start scrolling the rest will be there for them. Guess it depends on what your definition of fast is. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Copy Oracle's binary.
Hello, Thank you for all of your advices. I did the copy and it worked fine. Regards, Thanh-truc Nguyen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 8:50 PM We do it all the time and it works fine. We make sure everything is shutdown first. We also do the copy as root just to make sure we get everything. May not be required but it is safer. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thanh-truc Nguyen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
I don't know if this happened to others, but when I installed 8.1.6 (on AIX) I had too many problems with performance, communication, and whatever you can think about... I migrated to 8.1.7 and applied 8.1.7.2 patch and my life is calm for now... it is worth to try. Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -Mensaje original- De: Joe LaCascio [mailto:[EMAIL PROTECTED]] Enviado el: Miércoles, 19 de Septiembre de 2001 02:00 p.m. Para: Multiple recipients of list ORACLE-L Asunto: Any idea's folks? I'm running a DEC Alpha 4100, DEC Unix 4.0d. I've just installed 8.1.6 with patch 8.1.6.2 and the sqlnet patch 1399208. When I try to start the listener I get the following errors: Script started on Wed Sep 19 12:04:14 2001 % ln^H ^Hsnrctl LSNRCTL for DEC OSF/1 AXP: Version 8.1.6.0.0 - Production on 19-SEP-2001 12:04:17 (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved. Welcome to LSNRCTL, type help for information. LSNRCTL start Starting /1091/oracle/product/816/bin/tnslsnr: please wait... Internal AIO consistency error: Cannot use libaio_raw with threads. Either relink without -pthread or link -laio, not -laio_raw. Aborting... TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact DEC OSF/1 AXP Error: 32: Broken pipe LSNRCTL exit Here's my listener.ora also: # LISTENER.ORA Configuration File:/1091/oracle/product/816/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = mufasa)(PORT = 1525)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = mufasa)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /1091/oracle/product/816) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = PREP) (ORACLE_HOME = /1091/oracle/product/816) (SID_NAME = PREP) ) ) ADMIN_RESTRICTIONS_LISTENER=ON -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe LaCascio INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Veronica Levin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Preinstall Oracle on CD
We are doing some product development on oracle and are wondering if we can ship preinstalled oracle ona CD , so that our customer don't have to worry about installing and pre configuring it . Any ideas and thoughts ?? Cheers RK - Original Message - From: Apps Sol To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 25, 2001 4:00 PM Subject: 9i - Linux Rhat 7.1- Error SIGSEGV 11* segmentation violation Did anyone try to install Oracle 9i on Linux 7.1 .. I was trying to install it and running into this error . (when running runInstaller ) SIGSEGV 11* segmentation violation All the prerequisites are in place .. Any thoughts?? Cheers RK
Re: Error in creating tablespace
Salaam Ashraf Jon, It appears that Oracle has a problem writing to the C drive to create the datafile on the very first block. This error is usually the result of a size issue over 4gb for the datafile or a file that has been autoextended. In your case, it appears it doesn't like the command (maybe some character is being passed through the command?). Delete the file and re-try it again. try doing this in svrmgrl80 and put a ; at the end. Good Luck, Satar Naghshineh --- ASHRAF SALAYMEH [EMAIL PROTECTED] wrote: Hello list, I'm using Personal Oracle8 Database and Win98 Platform I issued this command from Sqlplus8.0 : CREATE TABLESPACE PAYROLL DATAFILE 'C:\PAYROL.ORA' SIZE 10M SQL / I am trying to create new tablespace Payroll but I have got this error! CREATE TABLESPACE PAYROLL * ERROR at line 1: ORA-19502: write error on file C:\PAYROL.ORA, blockno 1 (blocksize=2048) ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file OSD-04026: Invalid parameter passed. O/S-Error: (OS 64) The specified network name is no longer available. The strange is you can see the PAYROLL.ORA under C:\ Directory After the error is displayed. But when you query : SQL select tablespace_name from dba_data_files; you can find nothing, no tablespace is created at all... I wish someone can help me to solve this problem. Best Regards, Ashraf Salaymeh __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Names in multiple oracle installs
Hi, Thanks to all that replied!!! Cheers, Sujatha -Original Message- Sent: Wednesday, 19 September 2001 11:55 PM To: Multiple recipients of list ORACLE-L They could have the same database name but different SIDs. But I think that you're right. I think that he means SID. They can have a different ORACLE_HOME in the listner.ora file and a different connect siring in the TNSNAMES.ORA file (along with a different ORACLE_HOME). I'm not sure if that would be enough to differentiate them though. If you're in a UNIX environment there's still the question of ORACLE_SID. Nirmal Kumar Muthu KumaranTo: Multiple recipients of list ORACLE-L NIRMALK@qtel[EMAIL PROTECTED] .com.qa cc: Sent by: Subject: RE: DB Names in multiple oracle root@fatcity.installs com 09/19/2001 07:18 AM Please respond to ORACLE-L You CANN'T(if not anyone correct me). Even if oracle home, version are different, their SID name should be different. I tested. I'm able to create two databases on one oracle server with different SID, but at a time i can startup only one database. REgards, Nirmal. -Original Message- From: Sujatha Madan [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 4:05 AM To: Multiple recipients of list ORACLE-L Subject: DB Names in multiple oracle installs Hi, Is it possible to call two databases the same name if they are residing on the same machine, in different oracle homes? ... One database is version 8.0.6 and the other is 8.1.7. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need assistance with a 'VIEW'.
Create views on the fly? Ugh. Sorry, but that's really ugly IMO. It would be much easier to use a refcursor. Example follows. Jared ref_cursor_test.sql var tables_rc refcursor; prompt Table Owner?: col cowner noprint new_value uowner set term off feed off select upper('1') cowner from dual; set term on feed on begin open :tables_rc for select table_name, tablespace_name from all_tables where owner = 'uowner'; end; / print tables_rc; undef 1 --- Ramon Estevez com.banilejas@codet To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] el.net.do cc: Sent by: Subject: RE: Need assistance with a 'VIEW'. [EMAIL PROTECTED] 09/19/01 07:00 AM Please respond to ORACLE-L Hi, Someone posted the past week the solution of something like that. He referred to create package and pass the date as a parameter to it and have a procedure, inside the package, that create the view using the parameter date. That what I can recall. Good luck, Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de William Rogge Enviado el: Tuesday, 18 September, 2001 10:47 AM Para: Multiple recipients of list ORACLE-L Asunto: Need assistance with a 'VIEW'. I have been given the nice task of creating a view of some data in our database. This doesn't seem like a major task, but after 2 days of work, I am stumped. Given table 'table1' code1, code2, date, value1, value2 I need to produce a view showing code1, code2, sum(value1), sum(value2) where date 'user input date' I have not been able to get the view to prompt for the date to limit the sum by. Specifics: Oracle RDMBS 7.3.4 Server: Unix What else can I say, but I am totally stumped. HELP! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Rogge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ramon Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Re: time synchronization
Eduard, You don't say why the time sync is causing such pain, or how you are syncing up the time. If the synchronization is a problem, check into using ntp or xntp found at www.ntp.org ( network time protocol ) Many shops use this to keep servers in sync. I use it at home on linux boxes, works great. How is this synchronization affecting your Oracle instances? Jared Shevtsov, Eduard To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] EShevtsov@fla cc: gship.ruSubject: time synchronization Sent by: [EMAIL PROTECTED] om 09/18/01 08:46 AM Please respond to ORACLE-L Hi List, we have about 2 min difference between the time on our db server and the rest boxes in our network. Actually, the time on DB server is 2min slow than the network time.It causes real pain to us. I think about the following order of time synchronization: 1. Normal shutdown the DB and listener 2. immediate cold backup 2. setup time synchronization on the unix level 3. startup the DB and listener 4. Normal shutdown DB and listener 5. immediate cold backup 6. startup DB and listener Is this correct ? Any possible troubles? Any good links? Thanks in advance, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: need an 8.0.5 client and an 8.1.7 client on same machine
Thanks.. I will try this.. Is there anything else to be concerned about? Paths etc? I think there's a chance that the respective apps will find the correct dll's in the correct bin directory automatically, but I'm not sure. Any problem anticipated with that? Thanks, Doug On Tue, 18 Sep 2001 19:05:19 -0800, you wrote: Doug, I wrote the below without noticing that it was a winframe server. I haven't used a winframe server before. So, if it was a normal PC I would do what is below. I would probably do the same thing on a winframe server - I would just want to try it on a test server first. 805 on NT is not multiple-home compliant. So, you need to install 805 before you install 817 (install them into separate homes). So what I would do is: Backup Oracle configuration files Do a total remove of Oracle off the client (ie registry, files, icons etc) Install 8.0.5 (eg into \oracle\product\805) Install 8.1.7 into its own home (eg into \oracle\product\817) I would maintain only 1 set of Oracle networking files. eg create d:\oracle\admin\tns_admin Create a system environment variable tns_admin with a value of d:\oracle\admin\tns_admin Put sqlnet.ora and tnsnames.ora into d:\oracle\admin\tns_admin Regards, Bruce Reardon -Original Message- Sent: Wednesday, 19 September 2001 10:49 I need to get an 8.0.5 client and an 8.1.7 client working on the same machine. Currently, the 8.1.7 is the only one installed. This is an NT winframe/metaframe server running NT 4.0. Some apps use the 8.1.7 client and some will require the 8.0.5. Any suggestions before I start the surgery? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: need an 8.0.5 client and an 8.1.7 client on same machine
Doug, There is an Oracle home selector that could be run before starting the appropriate application (alters path possibly does things to registry as well). This should guarantee the application finding the correct dll's etc. However, the home selector is a GUI application and I don't believe it has a command line interface (I remember reading a Metalink article on this but I don't currently have Internet access available). You could use a Windows scripting tool (eg Microsoft scriptit) to pass keystrokes into the home selector but I haven't tried it. Also, you may need to put the tns_admin variable into the registry as well as the environment variable - see Metalink Note:1020336.102 details here. All this said, have you tried using the 817 client with the other application - it might work (but whether the vendor would support it is another questions). HTH, Bruce Reardon -Original Message- Sent: Thursday, 20 September 2001 1:55 Thanks.. I will try this.. Is there anything else to be concerned about? Paths etc? I think there's a chance that the respective apps will find the correct dll's in the correct bin directory automatically, but I'm not sure. Any problem anticipated with that? Thanks, Doug On Tue, 18 Sep 2001 19:05:19 -0800, you wrote: Doug, I wrote the below without noticing that it was a winframe server. I haven't used a winframe server before. So, if it was a normal PC I would do what is below. I would probably do the same thing on a winframe server - I would just want to try it on a test server first. 805 on NT is not multiple-home compliant. So, you need to install 805 before you install 817 (install them into separate homes). So what I would do is: Backup Oracle configuration files Do a total remove of Oracle off the client (ie registry, files, icons etc) Install 8.0.5 (eg into \oracle\product\805) Install 8.1.7 into its own home (eg into \oracle\product\817) I would maintain only 1 set of Oracle networking files. eg create d:\oracle\admin\tns_admin Create a system environment variable tns_admin with a value of d:\oracle\admin\tns_admin Put sqlnet.ora and tnsnames.ora into d:\oracle\admin\tns_admin Regards, Bruce Reardon -Original Message- Sent: Wednesday, 19 September 2001 10:49 I need to get an 8.0.5 client and an 8.1.7 client working on the same machine. Currently, the 8.1.7 is the only one installed. This is an NT winframe/metaframe server running NT 4.0. Some apps use the 8.1.7 client and some will require the 8.0.5. Any suggestions before I start the surgery? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).