RE: RAC or Oracle Fail Safe
Thank you to all those who replied and who intend to reply to this one :) We are using Dell PE4600 servers. My concern was that I read it somewhere that if one of the node goes down, then the clients have to restart the application to log in again to the database, is that true? And is it any different on RAC? We have the licensed RAC and Oracle Fail Safe CDs, so that is not an issue. I also believe that setting up RAC is more complex, so we wanted to confirm that if Fail Safe gives us HA, 24x7, and any change in node shifting (when active is down, passive becomes active) is transparent to the user then we should go for Fail safe. By the way, we intend to keep cluster settings of ACTIVE and PASSIVE, is there any issue regarding this? Tanel Poder: you said that, in event of failure you can start up instance on another node that will mount, recover and open the database. Doesn't the second node automatically take over? And this means that the user has to log in again, do I get it right? Best Regards, Hussain -Original Message- Sent: Wednesday, July 16, 2003 10:44 PM To: Multiple recipients of list ORACLE-L Hi! RAC - One database, two (or more) instances servicing it concurrently. If one node crashes, second one starts recovering, your uncommitted transactions and session state variables (package variables) on failed instance are lost. FailSafe - One database, one instance servicing it at any time, in event of failure you can start up instance on another node that will mount, recover and open the database. With RAC you can have some kind of transparent failover which is able to reexecute your queries on survived instance, but AFAIK for uncommitted transaction survivability your app has to be coded to support it. Also, with RAC you may scale your system up to support more users in some cases. RAC is additional $20k per CPU, FailSafe comes with EE, I believe. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 7:44 PM Hello all, We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes, using W2K, and now are in the process of deploying Oracle 9i on it. For the purpose of high availability (HA), we are deliberating on setting up either RAC or Oracle Fail Safe. The confusion is over the fact that if we get HA with oracle Fail Safe, i.e. if one node is down due to any problem, then the other takes over, then can we do without RAC? Which of these two is more transparent to the user, i.e. which will take less time to shift the load from one node (server) to the other node? Can any one explain the benefits of using RAC over Oracle Fail Safe, or vice versa. Regards, Hussain DBA SKMCHRC -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hussain Ahmed Qadri INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hussain Ahmed Qadri INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAC or Oracle Fail Safe
Title: RE: RAC or Oracle Fail Safe Hi Hussain ! RAC can have Active-Active or Active-Passive combination for two nodes. While OFS can't give you Active-Active combination of two nodes. Basically a resource sharing is not possible in Oracle Fail safe so one resource can be used by only one node at one point of time. ( Resource means Hard Disk Space, Oracle Service, Listener etc). RAC can give Transparent Application Failover TAF which is out of consideration in OFS. In case of node failure on RAC System, the user will just need to attempt relogin and he will be connected _immediately_ to another surviving instance ( If tnsnames.ora is configured properly). While there is a significant amount of delay in case of OFS, the Database service has to failover from one node to another node and this may take it's own _sweet_ amount of time based on amount and type of activity being performed on the database. Of course both the systems are screwed when your (shared) storage system is down ;-) Lastly why would someone want to use only 1 out of 2 nodes when it is possible to use both the nodes? One possible answer is that, on one node you configure One server (say 9iAS) and on another node you configure database. Then under normal condition they will run on their respective nodes and when one fails they would switch-over to the surviving node. So your performance may suffer for the time during which any node is down. So you are the best judge to decide now ;-) Just my .2 c Regards, Rajesh -Original Message- HREF="">mailto:[EMAIL PROTECTED]] On Behalf Of Hussain Ahmed Qadri Sent: Wednesday, July 16, 2003 8:44 PM To: Multiple recipients of list ORACLE-L Subject: RAC or Oracle Fail Safe Hello all, We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes, using W2K, and now are in the process of deploying Oracle 9i on it. For the purpose of high availability (HA), we are deliberating on setting up either RAC or Oracle Fail Safe. The confusion is over the fact that if we get HA with oracle Fail Safe, i.e. if one node is down due to any problem, then the other takes over, then can we do without RAC? Which of these two is more transparent to the user, i.e. which will take less time to shift the load from one node (server) to the other node? Can any one explain the benefits of using RAC over Oracle Fail Safe, or vice versa. Regards, Hussain DBA SKMCHRC -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hussain Ahmed Qadri INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Using the 9i version of UTL_HTTP in 8i
Dear all, Database: Oracle 8.1.7.4 Enterprise OS: HP-UX 11 We want to implement a stored proc that would send data to an http:// url using 'POST' method. The UTL_HTTP package in 8i doesn't support the POST method, while that in 9i does. We are now considering two options: 1. Install the 9i version of the package in the 8i database. If it works, this would be good, because we are planning to upgrade before 2004. 2. Use the code provided by Tom Kyte (with some modifications) in 'Oracle Expert one-on-one'. Will the 9i version of UTL_HTTP run without any trouble in 8i? How safe it is to do so? Will licensing be an issue here? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in sync with INIT.ORA ?)
Roy, I imagine its so that it can only be changed by someone who is validated against the database with the correct permissions. Kind Regards, Adrian -Original Message- Sent: 16 July 2003 23:40 To: Multiple recipients of list ORACLE-L sync with INIT.ORA ?) I can definitely appreciate the benefits of dynamic parameters, and of being able to persist the values of those parameters accross shutdown/startup cycles. But I would have guessed that oracle could have gotten both of those features together without going to a binary parameter file--couldn't whatever process writes to the spfile just write to a plain text file instead? Does anybody know what the advantage of having a binary store of params is? Cheers, -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, July 16, 2003 3:00 PM To: Multiple recipients of list ORACLE-L This can be solved by creating the PFILE again from the SPFILE; and this doesn't need the instance to be up. However, you did drive the nail home, Niall, with this example. Part of the problem could be avoided by restricting the ALTER SYSTEM, SYSDBA or SYSOPER privileges; but in a large shop with a lot of production support DBAS!! Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 4:59 PM Not only that but this sort of thing should be avoidable. SQL alter system set db_cache_size=10m scope=both; System altered. time passes SQL alter system set db_block_buffers=1000 scope=spfile; System altered. SQL shutdown; Database closed. Database dismounted. ORACLE instance shut down. SQL startup ORA-00381: cannot use both new and old parameters for buffer cache size specific ation SQL What do you do if you didn't have an old fashioned text file? I'd also like to know how spfile changes get documented, it scares me enough that someone can change parameters on the fly, let alone that that can be done without comment or recording who did it. I'll admit thugh that this last is actually a failure of management and not technology. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Arup Nanda Sent: 16 July 2003 06:09 To: Multiple recipients of list ORACLE-L Subject: Re: How to make SPFILE in sync with INIT.ORA ? Dennis, My understanding is that Oracle felt if it was going to be a 24x7x365 database, it had to have more parameters that could be changed online I couldn't agree more. 9i had more parameters that can be changed online; hope there are more in line. it doesn't make sense to rely on the DBA to remember to also update the init.ora file. You should be able to just make the change once. Absolutely. That's the point I was trying to raise. Oracle did provide the spfile route to make _persistent_ changes on the fly, but for only those parameters that can be changed through alter system set ... The problem was there is a different file that needs to be updated when making those other parameter changes. There should be only one place to change - hopefully spfile - either through the alter system command or othe editing. This editing could be done through a GUI interface, too, if needed; although, call me old-fashioned (and I am old, anyway, at least in IT timeline), personally I prefer the vi editor. And this is not an impossible idea. I gave the example of the listener.ora file. It can be edited (so old fashioned), through the lsntctl SAVE_CONFIG command (so spfile-like) or through Net Assistant (so GUI-friendly). The end result is the same - one file - regardless of how you modify a parameter. The same approach could have been done in pfile-spfile case. I think with the pfile and spfile, Oracle was trying to give us the best of both worlds. Hmm! You think so? I think they just gave us a half-cooked hair-brained split-pea honey-mustard-ketchup-coated germ of a solution - sort of like Oracle 6 _without_ the Transaction Processing Option, if anyone remembers that. After you wipe off all those condiments, you find a Dr. Jekyll Mr. Hyde parameter file(s)! Regards, Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 12:24 AM Arup My understanding is that Oracle felt if it was going to be a 24x7x365 database, it had to have more parameters that could be changed online. Some parameters were made changeable in Oracle9i, with hints of more to come. If the future is online changes, it doesn't make sense to rely on the DBA to remember to also update the init.ora file. You should be able to just make the change once. Also, there is a new generation of I.S. people coming along that doesn't think you can operate a
RE: Using the 9i version of UTL_HTTP in 8i
Okay, I got the answer to the question - I tried compiling the 9i utl_http package in an 8i test database, and it failed conclusively. Any other options for using the HTTP 'POST' method in 8i? Thanks regards, -Original Message- Sent: Thursday, July 17, 2003 12:04 PM To: [EMAIL PROTECTED] Dear all, Database: Oracle 8.1.7.4 Enterprise OS: HP-UX 11 We want to implement a stored proc that would send data to an http:// url using 'POST' method. The UTL_HTTP package in 8i doesn't support the POST method, while that in 9i does. We are now considering two options: 1. Install the 9i version of the package in the 8i database. If it works, this would be good, because we are planning to upgrade before 2004. 2. Use the code provided by Tom Kyte (with some modifications) in 'Oracle Expert one-on-one'. Will the 9i version of UTL_HTTP run without any trouble in 8i? How safe it is to do so? Will licensing be an issue here? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAC or Oracle Fail Safe
Title: RE: RAC or Oracle Fail Safe Answers in line... -- I also believe that setting up RAC is more complex, That's not totally true, For a DBA it shouldn't matter much, whether he is setting up RAC or OFS. But yes relatively RAC is a bit complex to manage. -- and any change in node shifting (when active is down, passive becomes active) is transparent to the user Not true really, user's session will flash error message and he will have to re login. This is true in both the cases(unless you implement TAF Transparent Application Failover logics in your application for RAC. One major difference would be that in RAC user can re-login immediately, while in OFS he has to wait till the other node bring the database up. -- Doesn't the second node automatically take over? Yes other node can be configured to take over automatically base on some simple in-built logic. But a DB recovery might be required depending on specific cases. -- And this means that the user has to log in again, do I get it right? Yes you are right here. HTH, Rajesh -Original Message- HREF="">mailto:[EMAIL PROTECTED]] On Behalf Of Hussain Ahmed Qadri Sent: Thursday, July 17, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: RAC or Oracle Fail Safe Thank you to all those who replied and who intend to reply to this one :) We are using Dell PE4600 servers. My concern was that I read it somewhere that if one of the node goes down, then the clients have to restart the application to log in again to the database, is that true? And is it any different on RAC? We have the licensed RAC and Oracle Fail Safe CDs, so that is not an issue. I also believe that setting up RAC is more complex, so we wanted to confirm that if Fail Safe gives us HA, 24x7, and any change in node shifting (when active is down, passive becomes active) is transparent to the user then we should go for Fail safe. By the way, we intend to keep cluster settings of ACTIVE and PASSIVE, is there any issue regarding this? Tanel Poder: you said that, in event of failure you can start up instance on another node that will mount, recover and open the database. Doesn't the second node automatically take over? And this means that the user has to log in again, do I get it right? Best Regards, Hussain -Original Message- Sent: Wednesday, July 16, 2003 10:44 PM To: Multiple recipients of list ORACLE-L Hi! RAC - One database, two (or more) instances servicing it concurrently. If one node crashes, second one starts recovering, your uncommitted transactions and session state variables (package variables) on failed instance are lost. FailSafe - One database, one instance servicing it at any time, in event of failure you can start up instance on another node that will mount, recover and open the database. With RAC you can have some kind of transparent failover which is able to reexecute your queries on survived instance, but AFAIK for uncommitted transaction survivability your app has to be coded to support it. Also, with RAC you may scale your system up to support more users in some cases. RAC is additional $20k per CPU, FailSafe comes with EE, I believe. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 7:44 PM Hello all, We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes, using W2K, and now are in the process of deploying Oracle 9i on it. For the purpose of high availability (HA), we are deliberating on setting up either RAC or Oracle Fail Safe. The confusion is over the fact that if we get HA with oracle Fail Safe, i.e. if one node is down due to any problem, then the other takes over, then can we do without RAC? Which of these two is more transparent to the user, i.e. which will take less time to shift the load from one node (server) to the other node? Can any one explain the benefits of using RAC over Oracle Fail Safe, or vice versa. Regards, Hussain DBA SKMCHRC -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hussain Ahmed Qadri INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE
sqlldr questions
I'm a sqlldr newbie. Platform is Oracle 9.2. My question is...can I prevent sqlldr loading any data if there is even a single bad record, even if it is, for example, the last record? I am using conventional path load. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to put both OID and Microsoft Active directory working????
HI PEOPLE thanks in advance. I finnally got 9ias release 2 installed and working fine in IBM AIX 4.3.3 but now i have one big problem i'm hopping that you can help: How do i put both OID and Microsoft Active directory working I hope there is way of integrating both so that changes to Microsoft Active Directory are merged to OID and the reverse works the same also. Thanks again Regards PG
unlocking objects
Title: RE: are fast refreshes really fast? Hi Gurus, One of my object is locked. How do I unlock that object explicitly ? The session is already killed, but still the object appears in locked status. Thanks in advance With Warm Regards Siddharth Haldankar Cisco Systems Inc. ODC Zensar Technologies Ltd. # : 4128374 [EMAIL PROTECTED] [EMAIL PROTECTED]
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
it's a fake sort of binary -- try editing it with vi and then try opening your database with the spfile... but first make an init.ora copy of it. There is some sort of checksum going on, even though it looks like ASCII --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: it isn't binary on solaris ... pure text ... Raj -Original Message- Sent: Wednesday, July 16, 2003 6:40 PM To: Multiple recipients of list ORACLE-L sync with INIT.ORA ?) I can definitely appreciate the benefits of dynamic parameters, and of being able to persist the values of those parameters accross shutdown/startup cycles. But I would have guessed that oracle could have gotten both of those features together without going to a binary parameter file--couldn't whatever process writes to the spfile just write to a plain text file instead? Does anybody know what the advantage of having a binary store of params is? Cheers, -Roy 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 __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Another OCP slant...
Hello Folks, I have discovered something *very* disturbing. We have a person(x2) who has earned their MCDBA - Microsoft DBA certifiction. These two don't have any clue, about database issues, when pressed to how they did it, it came out that they used the threads on a website called www.braindumps.com Beyond the ethical implications and all the other issues. Has anyone on this list used the tips/suggestions to study for their OCP exams? Are they any good as an aid? Regards Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Instances not starting up via services
Hi Jose, I've tried twice to send you the information but the mailing list has decided that it contains a 'virus signature' and rejects the email. So can you let me know specially what you are looking for and I will send you those values. Thanks, N. :--Original Message- :-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :-Behalf Of :-Jose Luis Delgado :-Sent: 16 July 2003 16:49 :-To: Multiple recipients of list ORACLE-L :-Subject: RE: Oracle Instances not starting up via services :- :- :-Nuala... :- :-1.- can you send your environment variables? (my_pc - :-properties - advanced - environment variables) :- :-2.- can you send your Oracle registry values? :- :-JL :- : Nuala Cullen [EMAIL PROTECTED] wrote: :- :- Hi Jared, :- :- Thanks for the advice, :- :- I checked out the registry settings :- ORA_WMS_PFILE is set to :- c:\oracle\ora81\database\initwms.ora. :- ORA_WMS_AUTOSTART is set to TRUE. :- :- I'm a bit confused what you mean by using variables. :- I think you mean not to use %oracle_home% etc but :- the error message: :- :- LRM-00109 can not open parameter file :- '%oracle_home%/database/init%oracle_sid%.ora :- is as it appeared on the screen. :- :- N. :- :- :- :--Original Message- :- :-From: Jared Still [mailto:[EMAIL PROTECTED] :- :-Sent: 16 July 2003 14:31 :- :-To: [EMAIL PROTECTED]; Nuala Cullen :- :-Subject: Re: Oracle Instances not starting up via :- services :- :- :- :- :- :- :- :-Check the registry entry ORA_SID_PFILE. Try :- hardcoding :- :-the entire path rather than use variables. :- :- :- :-ie. ORA_WMS_PFILE would be set to :- :-c:\oracle\ora81\database\initwms.ora. :- :- :- :-Be sure ORA_WMS_AUTOSTART is set to TRUE. :- :- :- :-Jared :- :- :- :- :- :-On Wednesday 16 July 2003 04:24, Nuala Cullen :- wrote: :- :- Hi All, :- :- :- :- I have inherited a couple of databases on one :- of the :- :-servers here. The :- :- server was taken down for hardware repairs :- during the week :- :-and when it came :- :- back up the databases did not start. (They are :- set to :- :-start automatically :- :- via the services) :- :- :- :- I have done some research via the internet and :- I deleted :- :-and recreated the :- :- service via the ORADIM utility. :- :- :- :- But this has n't fixed it. I have to manually :- go into and start the :- :- databases (explicitly stating where the :- init.ora file is) :- :- :- :- I am getting this error message when I go in :- via SQLPLUS :- :-/NOLOG (connected :- :- as internal) :- :- :- :- Startup :- :- error message LRM-00109 can not open parameter :- file :- :- '%oracle_home%/database/init%oracle_sid%.ora :- :- :- :- If I do a startup :- :-pfile=c:\oracle\ora81\database\initwms.ora it :- starts as :- :- normal. :- :- :- :- I've checked that the oracle home is defined as :- :-c:\oracle\ora81 so I am :- :- beginning to suspect it has something to do :- with the oracle sid. :- :- In registry the ora_wms_pfile location is set :- to :- :- c:\oracle\ora8\database\initwms.ora :- :- :- :- We have 4 different instances on this box and :- none of them :- :-will start :- :- automatically. :- :- Oracle version 8.1.7 running on a Windows :- Server 2000 box :- :- :- :- Any help appreciated, :- :- :- :- Thanks, :- :- :- :- N. :- :- :- :- :- :- -- :- Please see the official ORACLE-L FAQ: :- http://www.orafaq.net :- -- :- Author: Nuala Cullen :- INET: [EMAIL PROTECTED] :- :- Fat City Network Services-- 858-538-5051 :- http://www.fatcity.com :- San Diego, California-- Mailing list and web :- hosting services :- :-- :- To REMOVE yourself from this mailing list, send an :- E-Mail message :- to: [EMAIL PROTECTED] (note EXACT spelling of :- 'ListGuru') and in :- the message BODY, include a line containing: UNSUB :- ORACLE-L :- (or the name of mailing list you want to be removed :- from). You may :- also send the HELP command for other information :- (like subscribing). :- :- :-__ :-Do you Yahoo!? :-SBC Yahoo! DSL - Now only $29.95 per month! :-http://sbc.yahoo.com :--- :-Please see the official ORACLE-L FAQ: http://www.orafaq.net :--- :-Author: Jose Luis Delgado :- INET: [EMAIL PROTECTED] :- :-Fat City Network Services-- 858-538-5051 http://www.fatcity.com :-San Diego, California-- Mailing list and web hosting services :-- :-To REMOVE yourself from this mailing list, send an E-Mail message :-to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in :-the message BODY, include a line containing: UNSUB ORACLE-L :-(or the name of mailing list you want to be removed from). You may :-also send the HELP command for other information (like subscribing). :- :- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuala Cullen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California
RE: enterprise manager
If this is a new installation... Try in the login dialog box: sysman oem_temp (or the pwd you specified for OEM when you installed it, if it prompted you to change the default) [put the fqdn of your OMS Host here] Patrice. -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 9:04 PM To: Multiple recipients of list ORACLE-L When you say start the enterprise manager console and try to login as sys do you mean that the EM console login box that prompts for username, pwd and management server you enter sys as the user? If so, you need to enter an EM username password rather than a DB username / password. Also, in the Management server prompt you would normally enter a computer name rather than database name. To help us with more information - are you hoping to have the repository, OMS and console all on server As others have said - is the OMS service actually running. Sorry if this is on the wrong track. HTH, Bruce Reardon -Original Message- Sent: Thursday, 17 July 2003 3:45 AM Martin, I am wondering if the OMS is running at all... oemctl status oms on UNIX or check the services applet if you are in Windows. Patrice. -Original Message- Sent: Wednesday, July 16, 2003 1:20 PM the problem is you're trying to use enterprise mangler :P -Original Message- Sent: Wednesday, July 16, 2003 10:50 AM Check: drive:\ORACLE_HOME\sysman\log review the oms.log file... and send the details... HTH JL --- Ruth Gramolini [EMAIL PROTECTED] wrote: Is it an 8.0.x or 8i database? What version of OEM are you running? We need more info to be able to help you. Ruth - Original Message - Sent: Wednesday, July 16, 2003 6:19 AM hi i run ora8 on w2000 server. my problem is i can ping my database mydb without problems i can login with sqlplus as sys and it works fine but if i start the enterprise manager console and try to login as sys a error occours and means please check the management server status and settings. as managementserver i select mydb. what ican be the problem? thx martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:
- Original Message - help aren't you beyond help? :D Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: Object Types in PL/SQL
- Original Message - how does the object features improve performance of the jdbc? its fairly common now to have a java or .net(which we are using) and an Oracle backend. When we started to use JDBC, one of the things I noticed was some very unusual network traffic. Certainly more than I was expecting given the level of statements being executed. A few traces showed a lot of traffic by JDBC driver itself trying to find information about the parameters involved in a ExecutableStatement. I believe this is specific to JDBC 2 and its new MetaData functionality, but I don't know for sure. A little bit of experimentation showed that if we created an object type definition for each table involved in our procedures and used the object type to pass the parameters (each parameter is a column) to the stored procedures, the network traffic dropped dramatically. Now we use a package for each table with an object type matching the table columns used as the single parameter to each function/procedure. Each package has as a minimum a MNG_table and a DEL_table procedure, with the first one handling both INSERT and UPDATE (depending if PK is set to NULL or not). We also write getters to access the data, returning a REF CURSOR typed on the same object type. This is not only blinding fast but the network traffic is negligeable. your comments would be much appreciated. Not really comments, just the experience so far. It might change in the next version. So far it seems to work like a charm, so we're sticking with it. The next step is to get a few of the hierarchical accesses done via O-R views returning a single object with an array for the child object types. First trials seem very promising, but I have to wait for the 9i upgrade: 8i lets me do only one level of hierarchical object. After that, it's XML all the way through! If the customer doesn't kick us all out b4... ;) Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAC or Oracle Fail Safe
One other note is that we have not had to failover due to a Win2K of Oracle problem in 18 months of running failsafe. We have found it to be extremely stable just not scalable froma CPU standpoint. I totally agree with this. I am running FailSafe here also. The *only* failover's I experience is when the morons running the data center install software on the primary server and reboot the box. Failsafe brings the DB up on the other box without any problems. Works great. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 16, 2003 5:59 PM To: Multiple recipients of list ORACLE-L FailSafe comes with EE and works very well. It might even come with SE but I am not sure. Our production environment fails over in less than 2 minutes. It is much simpler to set up ( ie no SAN, raw devices or OCFS) and a heck of a lotr cheaper ( 20K$ / CPU for RAC ). One other note is that we have not had to failover due to a Win2K of Oracle problem in 18 months of running failsafe. We have found it to be extremely stable just not scalable froma CPU standpoint. -Original Message- Sent: Wednesday, July 16, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Hello all, We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes, using W2K, and now are in the process of deploying Oracle 9i on it. For the purpose of high availability (HA), we are deliberating on setting up either RAC or Oracle Fail Safe. The confusion is over the fact that if we get HA with oracle Fail Safe, i.e. if one node is down due to any problem, then the other takes over, then can we do without RAC? Which of these two is more transparent to the user, i.e. which will take less time to shift the load from one node (server) to the other node? Can any one explain the benefits of using RAC over Oracle Fail Safe, or vice versa. Regards, Hussain DBA SKMCHRC -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hussain Ahmed Qadri INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tony Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: unlocking objects
if the session is in 'KILLED' status it is rolling back the transaction. you have to wait for this to finish. it can take a while. From: Siddharth Haldankar [EMAIL PROTECTED] Date: 2003/07/17 Thu AM 06:24:25 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: unlocking objects Hi Gurus, One of my object is locked. How do I unlock that object explicitly ? The session is already killed, but still the object appears in locked status. Thanks in advance With Warm Regards _ Siddharth Haldankar Cisco Systems Inc. ODC Zensar Technologies Ltd. # : 4128374 [EMAIL PROTECTED] [EMAIL PROTECTED] Title: RE: are fast refreshes really fast? Hi Gurus, One of my object is locked. How do I unlock that object explicitly ? The session is already killed, but still the object appears in locked status. Thanks in advance With Warm Regards Siddharth Haldankar Cisco Systems Inc. ODC Zensar Technologies Ltd. # : 4128374 [EMAIL PROTECTED] [EMAIL PROTECTED]
RE: Another OCP slant...
Title: RE: Another OCP slant... No, I sat through thte Oracle Education Classes and studied from the books given in the class. They make for great reference books now as well. -Original Message- From: Denham Eva [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 17, 2003 5:34 AM To: Multiple recipients of list ORACLE-L Subject: Another OCP slant... Hello Folks, I have discovered something *very* disturbing. We have a person(x2) who has earned their MCDBA - Microsoft DBA certifiction. These two don't have any clue, about database issues, when pressed to how they did it, it came out that they used the threads on a website called www.braindumps.com Beyond the ethical implications and all the other issues. Has anyone on this list used the tips/suggestions to study for their OCP exams? Are they any good as an aid? Regards Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another OCP slant...
Title: RE: Another OCP slant... for 8 and 8i, I used the Exam cram books and the Osborne book for 8i.Took all of the 8 OCP tests and the upgradetest in 8 weeks. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message-From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 8:19 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Another OCP slant... No, I sat through thte Oracle Education Classes and studied from the books given in the class. They make for great reference books now as well. -Original Message- From: Denham Eva [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 17, 2003 5:34 AM To: Multiple recipients of list ORACLE-L Subject: Another OCP slant... Hello Folks, I have discovered something *very* disturbing. We have a person(x2) who has earned their MCDBA - Microsoft DBA certifiction. These two don't have any clue, about database issues, when pressed to how they did it, it came out that they used the threads on a website called www.braindumps.com Beyond the ethical implications and all the other issues. Has anyone on this list used the tips/suggestions to study for their OCP exams? Are they any good as an aid? Regards Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
DBMS_REPAIR Package
Title: Message Hasanyone ever used DBMS_REPAIR? If so, what do you think of it, does the DB have to be shutdown to run it. Does it really fix any corrupt blocks in the datafiles? We ran DBVerify andfoundseveral corrupt DB files in one of our DB's. TIA, Scott Stefick MILPDS OCP Oracle DBA [EMAIL PROTECTED]210-565-2540
Re: sqlldr questions
An excellent book for SQL Loader new comers, and experienced users as well, is one by Jonathan Gennick and Sanjay Mishra : Oracle SQL Loader, The definitive Guide, by O'Reilly. Stenphen Andert will agree with me ;) - Kirti --- John Dunn [EMAIL PROTECTED] wrote: I'm a sqlldr newbie. Platform is Oracle 9.2. My question is...can I prevent sqlldr loading any data if there is even a single bad record, even if it is, for example, the last record? I am using conventional path load. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: sqlldr questions
i read this last year. correct me if im wrong, but it didnt seem to have much more than was on otn? just explained slightly differently with a slightly more depth. From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/07/17 Thu AM 09:54:29 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: sqlldr questions An excellent book for SQL Loader new comers, and experienced users as well, is one by Jonathan Gennick and Sanjay Mishra : Oracle SQL Loader, The definitive Guide, by O'Reilly. Stenphen Andert will agree with me ;) - Kirti --- John Dunn [EMAIL PROTECTED] wrote: I'm a sqlldr newbie. Platform is Oracle 9.2. My question is...can I prevent sqlldr loading any data if there is even a single bad record, even if it is, for example, the last record? I am using conventional path load. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OUI download
Is there another location for downloads? (I don't think there is...) I am looking for a simple package that installs the Oracle Universal Installer, nothing fancy. begin rant I don't understand why they don't have that under Software Downloads, they have one page that lists all the ODBC drivers, why not do this for the Installer. /end rand Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
faq broke?
Is it just me, or . . . I have not been able to search the faq archives all week (www.orfaq.net). When I find a match and try to open it, I get a message Our apologies. The page you are looking for might have been removed, had its name changed, or is temporarily unavailable Is it just me, or are others having problems? Barb __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sqlldr questions
Please look the following text, which works fine everyday for loading my data into oracle 9.2 database. $ORACLE_HOME/bin/sqlldr USERID=your_username/[EMAIL PROTECTED] control=link-summary.ctl log=link-summary.log $ more link-summary.ctl options (rows=9297500, errors=2, bindsize=100, readsize=100) LOAD DATA INFILE '/tmp/log_file_parsing_output.dat' truncate INTO TABLE access_summary FIELDS TERMINATED BY ' ' (CLIENT_IP char(100), ACCESS_DATE char(9), URL char(400)) This is my application. You need to change file name, file path, and table name and its column name as well. Hope it can help you. Don Kirtikumar Deshpande wrote: An excellent book for SQL Loader new comers, and experienced users as well, is one by Jonathan Gennick and Sanjay Mishra : Oracle SQL Loader, The definitive Guide, by O'Reilly. Stenphen Andert will agree with me ;) - Kirti --- John Dunn [EMAIL PROTECTED] wrote: I'm a sqlldr newbie. Platform is Oracle 9.2. My question is...can I prevent sqlldr loading any data if there is even a single bad record, even if it is, for example, the last record? I am using conventional path load. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBMS_REPAIR Package
Title: Message I dug a little more and found my answer.I found that Oracle uses DBMS_REPAIR just to put a band-aid on the corrupt blocks. It basically identifies the corrupt block and marks it so oracle skips over it like it's not even there. -Original Message-From: Stefick Ronald S Contr ESC/HRIDD Sent: Thursday, July 17, 2003 8:55 AMTo: Multiple recipients of list ORACLE-LSubject: DBMS_REPAIR Package Hasanyone ever used DBMS_REPAIR? If so, what do you think of it, does the DB have to be shutdown to run it. Does it really fix any corrupt blocks in the datafiles? We ran DBVerify andfoundseveral corrupt DB files in one of our DB's. TIA, Scott Stefick MILPDS OCP Oracle DBA [EMAIL PROTECTED]210-565-2540
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
I wonder if it is something built into the file or something that vi (or whatever editor you are using) does to the file when you save it. I say that because, if you edit the text part of an export file with vi, you get an unusable file. But the text part of an export file can be edited by other means and it will work -- for example, by running it through a C or Perl program and editing the stream as it flows through the program; and I think, if the export file is not too big ( 2 gig I think ) emacs (with certain options??) can be used. The official word in the 9i new features class at the ivory tower in Colorado Springs is that all the new features are wonderful, and you should be using them. -Original Message- it's a fake sort of binary -- try editing it with vi and then try opening your database with the spfile... but first make an init.ora copy of it. There is some sort of checksum going on, even though it looks like ASCII -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
My experience also on Win2K. 9.2.0.1.0 the file is editable. On 9.2.0.3.0 results are unpredictable if you edit the file. I guess that they really don't want us editing it. Kirtikumar DeshpandeTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] kirtikumar_desh cc: pandeSubject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in @yahoo.com Sent by: ml-errors 07/16/2003 11:24 PM Please respond to ORACLE-L Keeping them binary gives them power I guses... On most platforms there is just a hashed value on the first line. In 9i R1 (9.0.1), I was able to replace some param value without changing number of chars on the line, and the changes were taken without any problem (HP-UX 11, it was I think). Could not believe that it worked. No such luck in 9i R2... Binary, text, whatever, I will just stay away from him till pfile really goes away :) - Kirti --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: it isn't binary on solaris ... pure text ... Raj -Original Message- Sent: Wednesday, July 16, 2003 6:40 PM To: Multiple recipients of list ORACLE-L sync with INIT.ORA ?) I can definitely appreciate the benefits of dynamic parameters, and of being able to persist the values of those parameters accross shutdown/startup cycles. But I would have guessed that oracle could have gotten both of those features together without going to a binary parameter file--couldn't whatever process writes to the spfile just write to a plain text file instead? Does anybody know what the advantage of having a binary store of params is? Cheers, -Roy 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 __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services
Re: RE: DBMS_REPAIR Package
are there any practical uses for dbms_repair? or is it just a stop gap measure to use if your not able to do a recovery at that time? From: Stefick Ronald S Contr ESC/HRIDD [EMAIL PROTECTED] Date: 2003/07/17 Thu AM 10:39:24 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: DBMS_REPAIR Package I dug a little more and found my answer. I found that Oracle uses DBMS_REPAIR just to put a band-aid on the corrupt blocks. It basically identifies the corrupt block and marks it so oracle skips over it like it's not even there. -Original Message- Sent: Thursday, July 17, 2003 8:55 AM To: Multiple recipients of list ORACLE-L Has anyone ever used DBMS_REPAIR? If so, what do you think of it, does the DB have to be shutdown to run it. Does it really fix any corrupt blocks in the datafiles? We ran DBVerify and found several corrupt DB files in one of our DB's. TIA, Scott Stefick MILPDS OCP Oracle DBA [EMAIL PROTECTED] 210-565-2540 Title: Message I dug a little more and found my answer.I found that Oracle uses DBMS_REPAIR just to put a band-aid on the corrupt blocks. It basically identifies the corrupt block and marks it so oracle skips over it like it's not even there. -Original Message-From: Stefick Ronald S Contr ESC/HRIDD Sent: Thursday, July 17, 2003 8:55 AMTo: Multiple recipients of list ORACLE-LSubject: DBMS_REPAIR Package Hasanyone ever used DBMS_REPAIR? If so, what do you think of it, does the DB have to be shutdown to run it. Does it really fix any corrupt blocks in the datafiles? We ran DBVerify andfoundseveral corrupt DB files in one of our DB's. TIA, Scott Stefick MILPDS OCP Oracle DBA [EMAIL PROTECTED]210-565-2540
Re: DBMS_REPAIR Package
Title: Message Hi Stefick, Running stored procedures/packages is somewhat difficult with a shutdown database, so the database needs to be opened. Depending on the type of corrupted block in question answers whether or not the block is actually repaired (eg. bitmap block in ASSM segments, freelist blocks...) or simply marked as corrupt and thus could be made "skippable" meaning that your FTS will now work and skip the stuffed buggers. That said, I would recommend restoring you stuffed datafile, perform a database recovery and hope the corruption wasn't duplicated in your backup(s). dbms_repair should be used if all else fails (or you don't really mind losing that "bit" of your database). Good Luck Richard Foote - Original Message - From: Stefick Ronald S Contr ESC/HRIDD To: Multiple recipients of list ORACLE-L Sent: Thursday, July 17, 2003 11:54 PM Subject: DBMS_REPAIR Package Hasanyone ever used DBMS_REPAIR? If so, what do you think of it, does the DB have to be shutdown to run it. Does it really fix any corrupt blocks in the datafiles? We ran DBVerify andfoundseveral corrupt DB files in one of our DB's. TIA, Scott Stefick MILPDS OCP Oracle DBA [EMAIL PROTECTED]210-565-2540
RE: faq broke?
Seems to be Broke -Original Message- Sent: Thursday, July 17, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Is it just me, or . . . I have not been able to search the faq archives all week (www.orfaq.net). When I find a match and try to open it, I get a message Our apologies. The page you are looking for might have been removed, had its name changed, or is temporarily unavailable Is it just me, or are others having problems? Barb __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luis deUrioste INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to make SPFILE in sync with INIT.ORA ?
Hi, I really need some helps to configure my database with audit_trail option. I have tried some but fail so far. My database is Oracle 9.2. I have read all email related to spfile. Can somebody provides simple steps for me to update my specified initialization parameter in init.ora? (1) Manually change the initialization parameter, e.g. audit_trail = db in init.ora. How to sync it when re-start Oracle database? (2) Can I change the audit_trail = db initialization parameters in init.ora on-line? Any comments are appreciated! Many thanks! Don Arup Nanda wrote: The ability to change the system parameters without bouncing the system is not provided by spfile, neither in RAC nor single instance databas. It depends upon the the parameter that can be changed dynamically or not. I guess you wanted to convey the impression that the using spfiles the parameters can be changed and the changes can be persistent across shutdowns. But that is not just in RAC; it's true for single instance DBs, too. Now, suppose you want to set a parameter that can't be changed using ALTER SYSTEM, such as, say, java_pool_size. How do you plan to make the change? You have to open up the old favorite init.ora file and start the database with pfile=init.ora option. At that stage the spfile is not active and your issuing Alter system set db_cache_size = 800m scope = [ memory | spfile | both ] sid = * has no effect. You must create the spfile from the pfile and then use the newly created spfile to use this dynamic parameter persistent. Note the complexity involved - spfile allowed you to make the changes to some parmeters using alter system persistent; but for all other parametrs you are forced to use pfile. What happens if you ommit the pfile=init.ora clause? The database will pickup the spfile, which will _not_ have your changes. To fully appreciate the value of the spfile parameter, Oracle should have allowed editing spfile directly and completely done away with pfile. Splitting functionality across two different implementations adds to difficulties, does not resolve them. I hope future versions of Oracle do offer that functionality. It's not that difficult or unheard of, either. Listener.ora, tnsnames.ora are all editable and also read by Net Assistant. just my .02 Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 8:09 PM Spfile is shared and can be modified dynamically without bouncing the instances. Eg. Alter system set db_cache_size = 800m scope = [ memory | spfile | both ] sid = * Without spfile, you can still make this change dynamically in memory, but you would have to manually update init.ora file to reflect your change. Spfile allows you to automatically capture these dynamic changes. Gerardo -Original Message- Sent: Tuesday, July 15, 2003 4:45 PM To: Multiple recipients of list ORACLE-L And how, exactly? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 7:29 PM You'll appreciate spfiles if you're using RAC. -Original Message- Sent: Tuesday, July 15, 2003 2:09 PM To: Multiple recipients of list ORACLE-L And create pfile from spfile; does a similar job. I'm rapidly beginning to think that spfiles are just not worth it. Now how to reverse the policy decision having mandated them for 9i installs :( Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Arup Nanda Sent: 15 July 2003 04:44 To: Multiple recipients of list ORACLE-L Subject: Re: How to make SPFILE in sync with INIT.ORA ? As user sys, issue CREATE SPFILE FROM PFILE; This will create the spfile. You must have started the database using the pfile to use this command. HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 14, 2003 10:59 PM Guys, i have a 9iR2/win2k test instance. i just renamed CONTROL01.CTL once and tried to start the instance. SQLstartup But it gave a ORA-00205 error. so i removed CONTROL01.CTL from INIT.ORA file and started the instance SQLstartup pfile='d:\oracle\admin\pe92\pfile\init.ora' Now it worked fine. BUT: SQLstartup This is not possible because the SPFILE still has CONTROL01.CTL in it. How do i make my SPFILE in sync with the INIT.ORA ? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
RE: faq broke?
Worked fine for me just now. What are you searching on? Craig Healey -Original Message- From: Barbara Baker [mailto:[EMAIL PROTECTED] Sent: 17 July 2003 15:20 To: Multiple recipients of list ORACLE-L Subject: faq broke? Is it just me, or . . . I have not been able to search the faq archives all week (www.orfaq.net). When I find a match and try to open it, I get a message Our apologies. The page you are looking for might have been removed, had its name changed, or is temporarily unavailable Is it just me, or are others having problems? Barb __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Instances not starting up via services
Hi Nuala...! I'm almost sure that your problem is with environment variables... they usually are taken from the registry or defined on my_pc's properties... That's why I would like to know that values... can you send them to the list? HTH JL --- Nuala Cullen [EMAIL PROTECTED] wrote: Hi Jose, I've tried twice to send you the information but the mailing list has decided that it contains a 'virus signature' and rejects the email. So can you let me know specially what you are looking for and I will send you those values. Thanks, N. :--Original Message- :-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :-Behalf Of :-Jose Luis Delgado :-Sent: 16 July 2003 16:49 :-To: Multiple recipients of list ORACLE-L :-Subject: RE: Oracle Instances not starting up via services :- :- :-Nuala... :- :-1.- can you send your environment variables? (my_pc - :-properties - advanced - environment variables) :- :-2.- can you send your Oracle registry values? :- :-JL :- : Nuala Cullen [EMAIL PROTECTED] wrote: :- :- Hi Jared, :- :- Thanks for the advice, :- :- I checked out the registry settings :- ORA_WMS_PFILE is set to :- c:\oracle\ora81\database\initwms.ora. :- ORA_WMS_AUTOSTART is set to TRUE. :- :- I'm a bit confused what you mean by using variables. :- I think you mean not to use %oracle_home% etc but :- the error message: :- :- LRM-00109 can not open parameter file :- '%oracle_home%/database/init%oracle_sid%.ora :- is as it appeared on the screen. :- :- N. :- :- :- :--Original Message- :- :-From: Jared Still [mailto:[EMAIL PROTECTED] :- :-Sent: 16 July 2003 14:31 :- :-To: [EMAIL PROTECTED]; Nuala Cullen :- :-Subject: Re: Oracle Instances not starting up via :- services :- :- :- :- :- :- :- :-Check the registry entry ORA_SID_PFILE. Try :- hardcoding :- :-the entire path rather than use variables. :- :- :- :-ie. ORA_WMS_PFILE would be set to :- :-c:\oracle\ora81\database\initwms.ora. :- :- :- :-Be sure ORA_WMS_AUTOSTART is set to TRUE. :- :- :- :-Jared :- :- :- :- :- :-On Wednesday 16 July 2003 04:24, Nuala Cullen :- wrote: :- :- Hi All, :- :- :- :- I have inherited a couple of databases on one :- of the :- :-servers here. The :- :- server was taken down for hardware repairs :- during the week :- :-and when it came :- :- back up the databases did not start. (They are :- set to :- :-start automatically :- :- via the services) :- :- :- :- I have done some research via the internet and :- I deleted :- :-and recreated the :- :- service via the ORADIM utility. :- :- :- :- But this has n't fixed it. I have to manually :- go into and start the :- :- databases (explicitly stating where the :- init.ora file is) :- :- :- :- I am getting this error message when I go in :- via SQLPLUS :- :-/NOLOG (connected :- :- as internal) :- :- :- :- Startup :- :- error message LRM-00109 can not open parameter :- file :- :- '%oracle_home%/database/init%oracle_sid%.ora :- :- :- :- If I do a startup :- :-pfile=c:\oracle\ora81\database\initwms.ora it :- starts as :- :- normal. :- :- :- :- I've checked that the oracle home is defined as :- :-c:\oracle\ora81 so I am :- :- beginning to suspect it has something to do :- with the oracle sid. :- :- In registry the ora_wms_pfile location is set :- to :- :- c:\oracle\ora8\database\initwms.ora :- :- :- :- We have 4 different instances on this box and :- none of them :- :-will start :- :- automatically. :- :- Oracle version 8.1.7 running on a Windows :- Server 2000 box :- :- :- :- Any help appreciated, :- :- :- :- Thanks, :- :- :- :- N. :- :- :- :- :- :- -- :- Please see the official ORACLE-L FAQ: :- http://www.orafaq.net :- -- :- Author: Nuala Cullen :- INET: [EMAIL PROTECTED] :- :- Fat City Network Services-- 858-538-5051 :- http://www.fatcity.com :- San Diego, California-- Mailing list and web :- hosting services :- :-- :- To REMOVE yourself from this mailing list, send an :- E-Mail message :- to: [EMAIL PROTECTED] (note EXACT spelling of :- 'ListGuru') and in :- the message BODY, include a line containing: UNSUB :- ORACLE-L :- (or the name of mailing list you want to be removed :- from). You may :- also send the HELP command for other information :- (like subscribing). :- :- :-__ :-Do you Yahoo!? :-SBC Yahoo! DSL - Now only $29.95 per month! :-http://sbc.yahoo.com :--- :-Please see the official ORACLE-L FAQ: http://www.orafaq.net :--- :-Author: Jose Luis Delgado :- INET: [EMAIL PROTECTED] :- :-Fat City Network Services-- 858-538-5051 http://www.fatcity.com :-San Diego, California-- Mailing list and web hosting services :-- :-To REMOVE yourself from this mailing list, send an E-Mail
RE:
Correction: Blessed are the cheesemakers, for they shall be called the sons of God. Blessed are the Greek, for they shall inherit the Earth. Comment: It's obviously deeper then just the cheese makers, it is referring to all manufacturers of the dairy products. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 7:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Blessed are the cheesemakers, because they shall rule the Kingdom of God. Blessed are the Greek, because they shall inherit the Earth. Hope this helps you. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Tom Pall [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 7:39 PMTo: Multiple recipients of list ORACLE-LSubject: help
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in Hey, don't blame oracle for that ... did you complain to Microsoft when they created that Registry hive cr*p ?? Oracle is stepping on the same line ... Lemmings ... g Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Thomas Day [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 17, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in My experience also on Win2K. 9.2.0.1.0 the file is editable. On 9.2.0.3.0 results are unpredictable if you edit the file. I guess that they really don't want us editing it. 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
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
That's a good point. Someone should try a binary editor instead, like bvi and see what happens. -Original Message- Sent: Thursday, July 17, 2003 10:45 AM To: Multiple recipients of list ORACLE-L in I wonder if it is something built into the file or something that vi (or whatever editor you are using) does to the file when you save it. I say that because, if you edit the text part of an export file with vi, you get an unusable file. But the text part of an export file can be edited by other means and it will work -- for example, by running it through a C or Perl program and editing the stream as it flows through the program; and I think, if the export file is not too big ( 2 gig I think ) emacs (with certain options??) can be used. The official word in the 9i new features class at the ivory tower in Colorado Springs is that all the new features are wonderful, and you should be using them. -Original Message- it's a fake sort of binary -- try editing it with vi and then try opening your database with the spfile... but first make an init.ora copy of it. There is some sort of checksum going on, even though it looks like ASCII -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to make SPFILE in sync with INIT.ORA ?
Well, I thought I answered your question earlier. Here are the steps, in more detail. I assume your database instance name is ORCL; replace with the actual. (1) With your database open, issue a command as sys SQL create pfile from spfile. (2) Go to the directory $ORACLE_HOME/dbs and make sue the timestamp of teh file initORCL.ora file is now. (3) Open the file and place the line audit_trail=db, if not already there. (4) Shutdown the database. (5) Restart SQL startup pfile=$ORACLE_HOME/dbs/initORCL.ora (6) Make sure the audit trail is set. SQL show parameter audit_trail. (7) resynch the SPfile. SQL create spfile from pfile; (8) And, please let us know here if they worked. If any error occurs, copy and paste the error here. HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 17, 2003 11:19 AM Hi, I really need some helps to configure my database with audit_trail option. I have tried some but fail so far. My database is Oracle 9.2. I have read all email related to spfile. Can somebody provides simple steps for me to update my specified initialization parameter in init.ora? (1) Manually change the initialization parameter, e.g. audit_trail = db in init.ora. How to sync it when re-start Oracle database? (2) Can I change the audit_trail = db initialization parameters in init.ora on-line? Any comments are appreciated! Many thanks! Don Arup Nanda wrote: The ability to change the system parameters without bouncing the system is not provided by spfile, neither in RAC nor single instance databas. It depends upon the the parameter that can be changed dynamically or not. I guess you wanted to convey the impression that the using spfiles the parameters can be changed and the changes can be persistent across shutdowns. But that is not just in RAC; it's true for single instance DBs, too. Now, suppose you want to set a parameter that can't be changed using ALTER SYSTEM, such as, say, java_pool_size. How do you plan to make the change? You have to open up the old favorite init.ora file and start the database with pfile=init.ora option. At that stage the spfile is not active and your issuing Alter system set db_cache_size = 800m scope = [ memory | spfile | both ] sid = * has no effect. You must create the spfile from the pfile and then use the newly created spfile to use this dynamic parameter persistent. Note the complexity involved - spfile allowed you to make the changes to some parmeters using alter system persistent; but for all other parametrs you are forced to use pfile. What happens if you ommit the pfile=init.ora clause? The database will pickup the spfile, which will _not_ have your changes. To fully appreciate the value of the spfile parameter, Oracle should have allowed editing spfile directly and completely done away with pfile. Splitting functionality across two different implementations adds to difficulties, does not resolve them. I hope future versions of Oracle do offer that functionality. It's not that difficult or unheard of, either. Listener.ora, tnsnames.ora are all editable and also read by Net Assistant. just my .02 Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 8:09 PM Spfile is shared and can be modified dynamically without bouncing the instances. Eg. Alter system set db_cache_size = 800m scope = [ memory | spfile | both ] sid = * Without spfile, you can still make this change dynamically in memory, but you would have to manually update init.ora file to reflect your change. Spfile allows you to automatically capture these dynamic changes. Gerardo -Original Message- Sent: Tuesday, July 15, 2003 4:45 PM To: Multiple recipients of list ORACLE-L And how, exactly? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 7:29 PM You'll appreciate spfiles if you're using RAC. -Original Message- Sent: Tuesday, July 15, 2003 2:09 PM To: Multiple recipients of list ORACLE-L And create pfile from spfile; does a similar job. I'm rapidly beginning to think that spfiles are just not worth it. Now how to reverse the policy decision having mandated them for 9i installs :( Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Arup Nanda Sent: 15 July 2003 04:44 To: Multiple recipients of list ORACLE-L Subject: Re: How to make SPFILE in sync with INIT.ORA ? As user sys, issue CREATE SPFILE FROM PFILE; This will create the spfile. You must have started the database using the pfile to use this command. HTH. Arup Nanda -
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in Questin is why do you want to mess with it? That's not exactly my idea of fun ... I'd still use alter system, alter database commands to change whatever. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Richard Ji [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 17, 2003 12:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in That's a good point. Someone should try a binary editor instead, like bvi and see what happens. -Original Message- Sent: Thursday, July 17, 2003 10:45 AM To: Multiple recipients of list ORACLE-L in I wonder if it is something built into the file or something that vi (or whatever editor you are using) does to the file when you save it. I say that because, if you edit the text part of an export file with vi, you get an unusable file. But the text part of an export file can be edited by other means and it will work -- for example, by running it through a C or Perl program and editing the stream as it flows through the program; and I think, if the export file is not too big ( 2 gig I think ) emacs (with certain options??) can be used. The official word in the 9i new features class at the ivory tower in Colorado Springs is that all the new features are wonderful, and you should be using them. -Original Message- it's a fake sort of binary -- try editing it with vi and then try opening your database with the spfile... but first make an init.ora copy of it. There is some sort of checksum going on, even though it looks like ASCII -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Why would you want to do that? You can always re-create the file from your PFILE. Oracle should have encrypted it. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, July 17, 2003 12:10 PM To: Multiple recipients of list ORACLE-L in That's a good point. Someone should try a binary editor instead, like bvi and see what happens. -Original Message- Sent: Thursday, July 17, 2003 10:45 AM To: Multiple recipients of list ORACLE-L in I wonder if it is something built into the file or something that vi (or whatever editor you are using) does to the file when you save it. I say that because, if you edit the text part of an export file with vi, you get an unusable file. But the text part of an export file can be edited by other means and it will work -- for example, by running it through a C or Perl program and editing the stream as it flows through the program; and I think, if the export file is not too big ( 2 gig I think ) emacs (with certain options??) can be used. The official word in the 9i new features class at the ivory tower in Colorado Springs is that all the new features are wonderful, and you should be using them. -Original Message- it's a fake sort of binary -- try editing it with vi and then try opening your database with the spfile... but first make an init.ora copy of it. There is some sort of checksum going on, even though it looks like ASCII -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: faq broke?
Happens on every query I give it. I'm looking for oraus.msb oci calls translate oci messages lseek error seems to be specific to oracle-l messages; others come up. I've forwarded a message to the webmaster Barb --- Craig Healey [EMAIL PROTECTED] wrote: Worked fine for me just now. What are you searching on? Craig Healey -Original Message- From: Barbara Baker [mailto:[EMAIL PROTECTED] Sent: 17 July 2003 15:20 To: Multiple recipients of list ORACLE-L Subject: faq broke? Is it just me, or . . . I have not been able to search the faq archives all week (www.orfaq.net). When I find a match and try to open it, I get a message Our apologies. The page you are looking for might have been removed, had its name changed, or is temporarily unavailable Is it just me, or are others having problems? Barb __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OUI download
I think it's patch 2878462 for the OUI placeholder for the latest version - Metalink patch search, by patch number. They don't make it easy to find... Cheers Simon Anderson Is there another location for downloads? (I don't think there is...) I am looking for a simple package that installs the Oracle Universal Installer, nothing fancy. begin rant I don't understand why they don't have that under Software Downloads, they have one page that lists all the ODBC drivers, why not do this for the Installer. /end rand Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Oh it's the *Meek*...blessed are the Meek! That's nice, I'm gladthey're getting something, 'cause they have a hell of a time. -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Correction: Blessed are the cheesemakers, for they shall be called the sons of God. Blessed are the Greek, for they shall inherit the Earth. Comment: It's obviously deeper then just the cheese makers, it is referring to all manufacturers of the dairy products.
RE: faq broke?
Worked fine for me just now. OK, now it's stopped working! At least I know I didn't break it :-) Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
IOT
Hi all: I'm condsidering creating an IO table in Oracle9. It is a small table with 2 columns and has a composite index so I thought that an IO table would make sence. Do they have any disadvantages I should be aware of? What I read on OTN site didn't mention any. thanks Gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
x server
is there any free x server (unlimited ) software for windows 2000? -ak
RE: [PMX:#] RE: Find the table's name that using sequences
Title: RE: [PMX:#] RE: Find the table's name that using sequences Very True ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 16, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Subject: [PMX:#] RE: Find the table's name that using sequences this doesn't take into account external code that uses the sequence there is no way to know for certain which sequence is being used to generate values for which table. Even if you have multiple sequences, you can't force a programmer to use the sequence you have designated as the one for that particular table --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: I'd check dependencies of the sequence, you'll know what procedures,functions,packages,triggers that sue the sequence. Raj 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
Log oracle error to Apache log instead of web page
Hi,How can I make those error messages display in the Apache error log instead of displaying them in the end user web. Which config file should I change?Thanks, Jack
RE: x server
check out cygwin. -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 12:49 PMTo: Multiple recipients of list ORACLE-LSubject: x server is there any free x server (unlimited ) software for windows 2000? -ak
RE:
How do you catch a humble individual? You meek up on them... -Original Message-From: Jesse, Rich Sent: Thursday, July 17, 2003 11:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oh it's the *Meek*...blessed are the Meek! That's nice, I'm gladthey're getting something, 'cause they have a hell of a time. -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Correction: Blessed are the cheesemakers, for they shall be called the sons of God. Blessed are the Greek, for they shall inherit the Earth. Comment: It's obviously deeper then just the cheese makers, it is referring to all manufacturers of the dairy products.
Re: Another OCP slant...
Thursday, July 17, 2003, 6:34:26 AM, you wrote: DE Beyond the ethical implications and all the other issues. DE Has anyone on this list used the tips/suggestions to study for their OCP DE exams? Are they any good as an aid? I've never used any of the braindum.com type web sites, nor have I bothered with any of the exam-focused books. Mostly I read manuals and experiment with new features. It helps that I'm often writing about those new features, because writing forces me to learn. The one exception is that at the OracleWorld after 9i was released, Oracle themselves offered an exam-cram class for the Oracle9i upgrade exam. I sat through one or two sessions of that class--I couldn't be there for all of them--and then took the exam. It was a close call. Probably I would not have passed without having attended Oracle's cram-session. Back in the Oracle7 days I put off and put off taking the exams because I never felt ready. (Do you ever really feel ready?) Finally, one day, I kicked myself in the rear and signed up for all four exams in one go. I passed three and flunked one, but while failing that one exam I also picked up a good idea of what it was that I needed to go learn in order to pass it the next time. That's been my basic approach ever since: try an exam, hope I pass, and if I fail at least I know what I need to go and learn. If there is a 10x upgrade exam at OracleWorld this year, you can bet that, unprepared as I am, I'll sit for it and give it a go. Perhaps I can be one of the first to fail! Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Security re: default and non-default roles
Leslie, First make sure they are indeed the default roles. select * from dba_role_privs where grantee = 'SCOTT' See the DEFAULT_ROLE column; it should be NO. Next, after logging in, before SET ROLE, issue select * from session_roles; to see the roles that are active now. Should be only the DEFAULT roles. If you see more, it's possible that one of those roles have default roles. For instance if DBA is a default role, select * from dba_role_privs where grantee = 'DBA'; See if any of these are default roles. I suspect you have a second level role as default which is different from Development. HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 17, 2003 10:24 AM In an attempt to enhance security, we set up one role which is a default and has only select privileges on tables and another role, with is not default, which has update, insert, delete, as well as select privileges. Our application turns on the non-default role via set role. This all works just fine in our development database, but not in the test database (or production). The symptom is that the non-default role is enabled on login to sql*plus, even when it's not supposed to be. Can anybody give me a clue as to where to look to find out what's wrong and fix it? TIA, Leslie -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tierstein, Leslie INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Orbitz issue
There are some vague and brief news articles on the web stating that Orbitz is down and they are blaming Oracle. Anyone with some inside info on what went wrong? just curious. i know its probably due to someone at Orbitz making a mistake. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to make SPFILE in sync with INIT.ORA ?
Arup, Thank you very much. It works fine now. But my Oracle database instance name is bluejayt not ORCL. See the following message: $ ps -ef | grep bluejayt oracle 5796 1 0 13:01:08 ?0:00 ora_s000_bluejayt oracle 5790 1 0 13:01:08 ?0:00 ora_reco_bluejayt oracle 5800 5774 0 13:01:13 ?0:03 oraclebluejayt (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) oracle 5788 1 0 13:01:08 ?0:01 ora_smon_bluejayt oracle 5804 5735 0 13:07:17 pts/20:00 grep bluejayt oracle 5798 1 0 13:01:08 ?0:00 ora_d000_bluejayt oracle 5784 1 0 13:01:08 ?0:00 ora_lgwr_bluejayt oracle 5786 1 0 13:01:08 ?0:00 ora_ckpt_bluejayt oracle 5794 1 0 13:01:08 ?0:02 ora_qmn0_bluejayt oracle 5792 1 0 13:01:08 ?0:00 ora_cjq0_bluejayt oracle 5782 1 0 13:01:07 ?0:00 ora_dbw0_bluejayt oracle 5780 1 0 13:01:07 ?0:00 ora_pmon_bluejayt Thank you very much again! Don Arup Nanda wrote: Well, I thought I answered your question earlier. Here are the steps, in more detail. I assume your database instance name is ORCL; replace with the actual. (1) With your database open, issue a command as sys SQL create pfile from spfile. (2) Go to the directory $ORACLE_HOME/dbs and make sue the timestamp of teh file initORCL.ora file is now. (3) Open the file and place the line audit_trail=db, if not already there. (4) Shutdown the database. (5) Restart SQL startup pfile=$ORACLE_HOME/dbs/initORCL.ora (6) Make sure the audit trail is set. SQL show parameter audit_trail. (7) resynch the SPfile. SQL create spfile from pfile; (8) And, please let us know here if they worked. If any error occurs, copy and paste the error here. HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 17, 2003 11:19 AM Hi, I really need some helps to configure my database with audit_trail option. I have tried some but fail so far. My database is Oracle 9.2. I have read all email related to spfile. Can somebody provides simple steps for me to update my specified initialization parameter in init.ora? (1) Manually change the initialization parameter, e.g. audit_trail = db in init.ora. How to sync it when re-start Oracle database? (2) Can I change the audit_trail = db initialization parameters in init.ora on-line? Any comments are appreciated! Many thanks! Don Arup Nanda wrote: The ability to change the system parameters without bouncing the system is not provided by spfile, neither in RAC nor single instance databas. It depends upon the the parameter that can be changed dynamically or not. I guess you wanted to convey the impression that the using spfiles the parameters can be changed and the changes can be persistent across shutdowns. But that is not just in RAC; it's true for single instance DBs, too. Now, suppose you want to set a parameter that can't be changed using ALTER SYSTEM, such as, say, java_pool_size. How do you plan to make the change? You have to open up the old favorite init.ora file and start the database with pfile=init.ora option. At that stage the spfile is not active and your issuing Alter system set db_cache_size = 800m scope = [ memory | spfile | both ] sid = * has no effect. You must create the spfile from the pfile and then use the newly created spfile to use this dynamic parameter persistent. Note the complexity involved - spfile allowed you to make the changes to some parmeters using alter system persistent; but for all other parametrs you are forced to use pfile. What happens if you ommit the pfile=init.ora clause? The database will pickup the spfile, which will _not_ have your changes. To fully appreciate the value of the spfile parameter, Oracle should have allowed editing spfile directly and completely done away with pfile. Splitting functionality across two different implementations adds to difficulties, does not resolve them. I hope future versions of Oracle do offer that functionality. It's not that difficult or unheard of, either. Listener.ora, tnsnames.ora are all editable and also read by Net Assistant. just my .02 Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 8:09 PM Spfile is shared and can be modified dynamically without bouncing the instances. Eg. Alter system set db_cache_size = 800m scope = [ memory | spfile | both ] sid = * Without spfile, you can still make this change dynamically in memory, but you would have to manually update init.ora file to reflect your change. Spfile allows you to automatically capture these dynamic changes. Gerardo -Original Message- Sent:
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Editing spfile is not supported by Oracle. And I think it is documented as such. You can just view it, copy it and play with the copied version what whatever... One thing to remeber is to always hold on to the init.ora version. No matter what. Or at least until Oracle completely removes init.ora file when the Oracle RDBMS software becomes smarter than human brain ;) - Kirti -Original Message- Sent: Thursday, July 17, 2003 10:54 AM To: Multiple recipients of list ORACLE-L in My experience also on Win2K. 9.2.0.1.0 the file is editable. On 9.2.0.3.0 results are unpredictable if you edit the file. I guess that they really don't want us editing it. 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 __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in Of course you are right that no one should use it as the right way to change parameters. I will admit playing with binary file some times is my idea of fun. Hey, you never know, you might learn something from it. To see the data structure gives me idea of how things work. And it might come in handy some day in a recovery situation. Best regards Richard Ji -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 12:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in Questin is why do you want to mess with it? That's not exactly my idea of fun ... I'd still use alter system, alter database commands to change whatever. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Richard Ji [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 17, 2003 12:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in That's a good point. Someone should try a binary editor instead, like bvi and see what happens. -Original Message- Sent: Thursday, July 17, 2003 10:45 AM To: Multiple recipients of list ORACLE-L in I wonder if it is something built into the file or something that vi (or whatever editor you are using) does to the file when you save it. I say that because, if you edit the text part of an export file with vi, you get an unusable file. But the text part of an export file can be edited by other means and it will work -- for example, by running it through a C or Perl program and editing the stream as it flows through the program; and I think, if the export file is not too big ( 2 gig I think ) emacs (with certain options??) can be used. The official word in the 9i new features class at the ivory tower in Colorado Springs is that all the new features are wonderful, and you should be using them. -Original Message- it's a fake sort of binary -- try editing it with vi and then try opening your database with the spfile... but first make an init.ora copy of it. There is some sort of checksum going on, even though it looks like ASCII -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
alert_sid.log file: Performance statistics empty: data overflow
Hi, I often see this in my alert_sid.log file: Performance statistics empty: data overflow What does this mean, is there anything wrong with the Oracle DB? Thanks, Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Liu, Jack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: Another OCP slant...
i just hope they dont add a requirement to take one of their $2000 classes just to upgrade your certification. though it sure looks like they are heading that way... talk about a scam to get money. The classes are not rigorous, many instructors have little to no experience, and they go right out of the book. btw, if you hire someone just because they are certified its your own fault. Certification is helpful because you will learn stuff you dont normally use and the more material you have in your playbook the easier it is to do your job. if you look at most job ads that want certification they want experience PLUS certification. From: Jonathan Gennick [EMAIL PROTECTED] Date: 2003/07/17 Thu PM 12:09:38 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Another OCP slant... Thursday, July 17, 2003, 6:34:26 AM, you wrote: DE Beyond the ethical implications and all the other issues. DE Has anyone on this list used the tips/suggestions to study for their OCP DE exams? Are they any good as an aid? I've never used any of the braindum.com type web sites, nor have I bothered with any of the exam-focused books. Mostly I read manuals and experiment with new features. It helps that I'm often writing about those new features, because writing forces me to learn. The one exception is that at the OracleWorld after 9i was released, Oracle themselves offered an exam-cram class for the Oracle9i upgrade exam. I sat through one or two sessions of that class--I couldn't be there for all of them--and then took the exam. It was a close call. Probably I would not have passed without having attended Oracle's cram-session. Back in the Oracle7 days I put off and put off taking the exams because I never felt ready. (Do you ever really feel ready?) Finally, one day, I kicked myself in the rear and signed up for all four exams in one go. I passed three and flunked one, but while failing that one exam I also picked up a good idea of what it was that I needed to go learn in order to pass it the next time. That's been my basic approach ever since: try an exam, hope I pass, and if I fail at least I know what I need to go and learn. If there is a 10x upgrade exam at OracleWorld this year, you can bet that, unprepared as I am, I'll sit for it and give it a go. Perhaps I can be one of the first to fail! Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: alert_sid.log file: Performance statistics empty: data overfl
It doesn't mean a thing. This is simply a benign warning message indicating that V$DISPATCHER_RATE performance statistics may no longer be accurate. fix: Ignore the error message. This message is no longer seen with Oracle9i. -Original Message- Sent: Thursday, July 17, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Hi, I often see this in my alert_sid.log file: Performance statistics empty: data overflow What does this mean, is there anything wrong with the Oracle DB? Thanks, Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Liu, Jack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Orbitz issue
Title: RE: Orbitz issue Nah ... it is just that ORacle is Unbreakable ... that's all. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 17, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Subject: Orbitz issue There are some vague and brief news articles on the web stating that Orbitz is down and they are blaming Oracle. Anyone with some inside info on what went wrong? just curious. i know its probably due to someone at Orbitz making a mistake. 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
RE: DBMS_REPAIR Package
If you ran dbverify with the database up, it's very likely that there is nothing wrong with the datafiles. If dbv reads a block in transition, it will appear corrupt. Run it again, and there will either be no errors, or they will appear to be in different blocks. Personally, I think it a colossal waste of time to run dbverify. In 9 years of DBA'ing, I've experienced maybe 3 or 4 instances of a corrupt block, and it was always an index. The solution was to drop/rebuild the index. Jared Stefick Ronald S Contr ESC/HRIDD [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/17/2003 07:39 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: DBMS_REPAIR Package I dug a little more and found my answer. I found that Oracle uses DBMS_REPAIR just to put a band-aid on the corrupt blocks. It basically identifies the corrupt block and marks it so oracle skips over it like it's not even there. -Original Message- Sent: Thursday, July 17, 2003 8:55 AM To: Multiple recipients of list ORACLE-L Has anyone ever used DBMS_REPAIR? If so, what do you think of it, does the DB have to be shutdown to run it. Does it really fix any corrupt blocks in the datafiles? We ran DBVerify and found several corrupt DB files in one of our DB's. TIA, Scott Stefick MILPDS OCP Oracle DBA [EMAIL PROTECTED] 210-565-2540 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to schedule a job every alternate sundays in unix cron
Brilliant. :) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2003 11:29 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: how to schedule a job every alternate sundays in unix cron 0 1 * * 0 /usr/bin/ksh -c [ `date '+\%a'` = 'Sun' -a $((`date '+\%U'` \% 2)) -eq 0 ] /path/myscript.ksh This will run myscript.ksh on even Sundays at 1 a.m. If ?'s, email me direct. kommareddy sreenivasa To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: om Subject: how to schedule a job every alternate sundays in unix cron Sent by: [EMAIL PROTECTED] .com 07/16/2003 06:09 AM Please respond to ORACLE-L Hello All, OS: Solaris 2.8 I have to run a backup script in every alternate Sunday. I cant find a way to submit it in cron. Can somebody help me how to setup a job to run alternate Sundays in unix cron . Thanks and Regards, Srinivas __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: faq broke?
Perhaps you should try orafaq.org? ( notice the spelling ) Or was that just a typo in your original post? Jared Barbara Baker [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/17/2003 08:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: faq broke? Happens on every query I give it. I'm looking for oraus.msb oci calls translate oci messages lseek error seems to be specific to oracle-l messages; others come up. I've forwarded a message to the webmaster Barb --- Craig Healey [EMAIL PROTECTED] wrote: Worked fine for me just now. What are you searching on? Craig Healey -Original Message- From: Barbara Baker [mailto:[EMAIL PROTECTED] Sent: 17 July 2003 15:20 To: Multiple recipients of list ORACLE-L Subject: faq broke? Is it just me, or . . . I have not been able to search the faq archives all week (www.orfaq.net). When I find a match and try to open it, I get a message Our apologies. The page you are looking for might have been removed, had its name changed, or is temporarily unavailable Is it just me, or are others having problems? Barb __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the
RE: how to schedule a job every alternate sundays in unix cron
what a freekin nightmare! I'd hate to be the next poor bloke who has to decifer this... Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 17, 2003 2:35 PM To: Multiple recipients of list ORACLE-L Brilliant. :) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2003 11:29 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: how to schedule a job every alternate sundays in unix cron 0 1 * * 0 /usr/bin/ksh -c [ `date '+\%a'` = 'Sun' -a $((`date '+\%U'` \% 2)) -eq 0 ] /path/myscript.ksh This will run myscript.ksh on even Sundays at 1 a.m. If ?'s, email me direct. kommareddy sreenivasa To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: om Subject: how to schedule a job every alternate sundays in unix cron Sent by: [EMAIL PROTECTED] .com 07/16/2003 06:09 AM Please respond to ORACLE-L Hello All, OS: Solaris 2.8 I have to run a backup script in every alternate Sunday. I cant find a way to submit it in cron. Can somebody help me how to setup a job to run alternate Sundays in unix cron . Thanks and Regards, Srinivas __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to schedule a job every alternate sundays in unix cron
lol, actually makes sense :). wondering how the perl version would look like?Gene [EMAIL PROTECTED] 07/17/03 02:49PM what a freekin nightmare! I'd hate to be the next poor bloke who has todecifer this...Tom MercadanteOracle Certified Professional-Original Message-Sent: Thursday, July 17, 2003 2:35 PMTo: Multiple recipients of list ORACLE-LBrilliant. :)[EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]07/16/2003 11:29 PMPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Re: how to schedule a job every alternate sundays inunix cron0 1 * * 0 /usr/bin/ksh -c "[ `date '+\%a'` = 'Sun' -a $((`date '+\%U'` \%2)) -eq 0 ] /path/myscript.ksh"This will run myscript.ksh on even Sundays at 1 a.m.If ?'s, email me direct. kommareddy sreenivasa To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: om Subject: how to schedule a job every alternate sundays in unix cron Sent by: [EMAIL PROTECTED] .com 07/16/2003 06:09 AM Please respond to ORACLE-L Hello All,OS: Solaris 2.8I have to run a backup script in every alternateSunday.I cant find a way to submit it in cron.Can somebody help me how to setup a job to runalternate Sundays in unix cron .Thanks and Regards,Srinivas__Do you Yahoo!?SBC Yahoo! DSL - Now only $29.95 per month!http://sbc.yahoo.com--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: kommareddy sreenivasa INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Physical Design Question
Title: Physical Design Question Here's my situation: Damagement wants us to move 4 small production DBs to one server to save on licensing costs. Server is a Sun E4500, 4 CPUs, 8 GB RAM. There is a pair of internal disks that are mirrored with enough room for Solaris, swap, and 1 Oracle Home. There are 3 A1000 disk arrays (12 x 18 GB drives each), all set to RAID 1+0 using the S.A.M.E. approach. Questions: 1. Should I use a separate Oracle Home for each DB? Pros: --Allows upgrade/patching of 1 DB at a time without affecting others (some are home-grown, some are 3rd party). Cons: --Takes up more space, but space is not a major concern. --I'll have to put some Oracle Homes on the A1000s with the data files (i.e., concerns about disk contention). --Requires applying multiple upgrades/patches 2. Should I put 1 DB per A1000? (Actually, 1 A1000 would hold 2 of the least active DBs.) Pros: --Easier to determine performance problems b/c each DB is isolated on 1 A1000. --If one controller dies, it only affects 1 DB. Cons: --Only get throughput of 1 controller; could use 3 controllers if data files spread across 3 A1000s. Anyone with experience doing this, please share your tips, tricks, and gotchas! Best regards, David B. Wagoner Database Administrator
Re: DBMS_REPAIR Package
There's a good argument for separating tables/indexes. [EMAIL PROTECTED] wrote: If you ran dbverify with the database up, it's very likely that there is nothing wrong with the datafiles. If dbv reads a block in transition, it will appear corrupt. Run it again, and there will either be no errors, or they will appear to be in different blocks. Personally, I think it a colossal waste of time to run dbverify. In 9 years of DBA'ing, I've experienced maybe 3 or 4 instances of a corrupt block, and it was always an index. The solution was to drop/rebuild the index. Jaredbegin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
shell question
hi all , how can I read a text file and print line by line. Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another OCP slant...
Yipe! Not having taken the OCP route (yet -- or, if ever), how much does the fail-retake-retake method cost in $$$? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jonathan Gennick [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 11:10 AM To: Multiple recipients of list ORACLE-L Subject: Re: Another OCP slant... [snip] Back in the Oracle7 days I put off and put off taking the exams because I never felt ready. (Do you ever really feel ready?) Finally, one day, I kicked myself in the rear and signed up for all four exams in one go. I passed three and flunked one, but while failing that one exam I also picked up a good idea of what it was that I needed to go learn in order to pass it the next time. That's been my basic approach ever since: try an exam, hope I pass, and if I fail at least I know what I need to go and learn. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Physical Design Question
Title: Physical Design Question David, You don't say but, I am assuming that all your databases are at the same Oracle Release level. If this is the case, I would create one Oracle home for now - you can always create a new Oracle Home when you start considering migrating each individual database to a newer release. You didn't say if each DB has different access loads, so assuming all are the same,I would share all disks with all DB's. It will allow you to better blend all db's on the box - provide the best throughput possible. That's what I would do, unless there are some specific business reasons to not do this (like contractual stuff about availabilty for one application that the other does not have). Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message-From: David Wagoner [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 2:59 PMTo: Multiple recipients of list ORACLE-LSubject: Physical Design Question Here's my situation: Damagement wants us to move 4 small production DBs to one server to save on licensing costs. Server is a Sun E4500, 4 CPUs, 8 GB RAM. There is a pair of internal disks that are mirrored with enough room for Solaris, swap, and 1 Oracle Home. There are 3 A1000 disk arrays (12 x 18 GB drives each), all set to RAID 1+0 using the S.A.M.E. approach. Questions: 1. Should I use a separate Oracle Home for each DB? Pros: --Allows upgrade/patching of 1 DB at a time without affecting others (some are home-grown, some are 3rd party). Cons: --Takes up more space, but space is not a major concern. --I'll have to put some Oracle Homes on the A1000s with the data files (i.e., concerns about disk contention). --Requires applying multiple upgrades/patches 2. Should I put 1 DB per A1000? (Actually, 1 A1000 would hold 2 of the least active DBs.) Pros: --Easier to determine performance problems b/c each DB is isolated on 1 A1000. --If one controller dies, it only affects 1 DB. Cons: --Only get throughput of 1 controller; could use 3 controllers if data files spread across 3 A1000s. Anyone with experience doing this, please share your tips, tricks, and gotchas! Best regards, David B. Wagoner Database Administrator
oracle10g
Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
STATSPACK in Oracle 8.1.6.0
Hi, I want to delete all old records of statspack from perfstat schema. What would be best way to do this either by truncating all tables or remove and recreate ? Pl advice. thx -Seema _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Here comes Oracle10G
gotta love it. the marketing people get to spend a whole new set of money to re-brand everything. I'm glad they are doing so well that they got money to burn. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 17, 2003 3:44 PM To: Multiple recipients of list ORACLE-L OracleWorld web sites SFO/PARIS revealing the new name as: Oracle10G Gee, it's not 'i' anymore ? Nope!! It's Capital G. G for God? No. It's Grid :) Enjoy.. - Kirti __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Another OCP slant...
Title: RE: Another OCP slant... Hi! Why did you take 8 + 1 tests for 8 and 8i DBA? 5 + 1 should have been enough? Back in summer of 1999 when I wen't to EOUG yearly conference, Oracle promoted their OCP exams there and let people take their exams free. I thouht, what the heck, let's give it a try - and completed all 5 exams in one day ;) After that I was kind of disappointed that the exams were so easy (I had only about 1,5 yr Oracle experience by then). But now I see guys who spend a month memorizing every word in exam cram books and still pass the exams, without having any skill to maintain actual real life databases... Currently, only thing OCP says to me right now, is that the guy/girl owning it, isn't a complete loser and at least is willing to do someting. Whether getting OCP is the right thing to do fist in Oracle career, is a different issue. Tanel. Previously OCP 8-9i, now Oracle Certified Master. - Original Message - From: April Wells To: Multiple recipients of list ORACLE-L Sent: Thursday, July 17, 2003 4:34 PM Subject: RE: Another OCP slant... for 8 and 8i, I used the Exam cram books and the Osborne book for 8i.Took all of the 8 OCP tests and the upgradetest in 8 weeks. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message-From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 8:19 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Another OCP slant... No, I sat through thte Oracle Education Classes and studied from the books given in the class. They make for great reference books now as well. -Original Message- From: Denham Eva [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 17, 2003 5:34 AM To: Multiple recipients of list ORACLE-L Subject: Another OCP slant... Hello Folks, I have discovered something *very* disturbing. We have a person(x2) who has earned their MCDBA - Microsoft DBA certifiction. These two don't have any clue, about database issues, when pressed to how they did it, it came out that they used the threads on a website called www.braindumps.com Beyond the ethical implications and all the other issues. Has anyone on this list used the tips/suggestions to study for their OCP exams? Are they any good as an aid? Regards Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby
RE: shell question
cat(1) -Original Message- Sent: Thursday, July 17, 2003 3:09 PM To: Multiple recipients of list ORACLE-L hi all , how can I read a text file and print line by line. Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: shell question
cat file sed '' file awk '{print}' file while read LINE; do echo $LINE; done file -Original Message- hi all , how can I read a text file and print line by line. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Here comes Oracle10G
Kirtikumar Deshpande wrote: OracleWorld web sites SFO/PARIS revealing the new name as: Oracle10G Gee, it's not 'i' anymore ? Nope!! It's Capital G. G for God? No. It's Grid :) Enjoy.. - Kirti The first thing that comes to mind (as a commuter) is Grid...lock! I can see it now...New oracle error, I'm sorry, but you can't get there from here.begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
Re: shell question
Sounds to simple so I must be missing a few of the requirements (... cat myfile or #!/bin/ksh cat myfile | while read LINE do print ${LINE} done [EMAIL PROTECTED] onents.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: shell question 07/17/2003 12:09 PM Please respond to ORACLE-L hi all , how can I read a text file and print line by line. Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another OCP slant...
Title: RE: Another OCP slant... I scheduled mine over lunch... without the luxury of being able to take all the time off I need to take tests all day. It is why it took me 2.33 years for my undergrad degree and 4 years to finish my masters... it is all a matter of my setting my priorities, not inbeing able to pass a mess of multiple choice tests in a day. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 2:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Another OCP slant... Hi! Why did you take 8 + 1 tests for 8 and 8i DBA? 5 + 1 should have been enough? Back in summer of 1999 when I wen't to EOUG yearly conference, Oracle promoted their OCP exams there and let people take their exams free. I thouht, what the heck, let's give it a try - and completed all 5 exams in one day ;) After that I was kind of disappointed that the exams were so easy (I had only about 1,5 yr Oracle experience by then). But now I see guys who spend a month memorizing every word in exam cram books and still pass the exams, without having any skill to maintain actual real life databases... Currently, only thing OCP says to me right now, is that the guy/girl owning it, isn't a complete loser and at least is willing to do someting. Whether getting OCP is the right thing to do fist in Oracle career, is a different issue. Tanel. Previously OCP 8-9i, now Oracle Certified Master. - Original Message - From: April Wells To: Multiple recipients of list ORACLE-L Sent: Thursday, July 17, 2003 4:34 PM Subject: RE: Another OCP slant... for 8 and 8i, I used the Exam cram books and the Osborne book for 8i.Took all of the 8 OCP tests and the upgradetest in 8 weeks. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message-From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 8:19 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Another OCP slant... No, I sat through thte Oracle Education Classes and studied from the books given in the class. They make for great reference books now as well. -Original Message- From: Denham Eva [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 17, 2003 5:34 AM To: Multiple recipients of list ORACLE-L Subject: Another OCP slant... Hello Folks, I have discovered something *very* disturbing. We have a person(x2) who has earned their MCDBA - Microsoft DBA certifiction. These two don't have any clue, about database issues, when pressed to how they did it, it came out that they used the threads on a website called www.braindumps.com Beyond the ethical implications and all the other issues. Has anyone on this list used the tips/suggestions to study for their OCP exams? Are they any good as an aid? Regards Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ # Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Thank You. -- Please see the official
Re: STATSPACK in Oracle 8.1.6.0
The latter. Scripts are already supplied. - Kirti --- Seema Singh [EMAIL PROTECTED] wrote: Hi, I want to delete all old records of statspack from perfstat schema. What would be best way to do this either by truncating all tables or remove and recreate ? Pl advice. thx -Seema _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: shell question
Please see the following text, which comes from my shell script: for arg_each_line in `cat $WORKING_DIR/log_file_parsing_temp02.temp | awk '{ pri nt $1===$2===$3 }'` do one_line=`echo $arg_each_line | sed 's/===/ /g'` # debug one line below if enabled #echo $one_line $WORKING_DIR/log_file_parsing_temp03.temp client_ip=`echo $one_line | awk '{ print $1 }' | sed 's/ //g'` org_date=`echo $one_line | awk '{ print $2 }' | sed 's/ //g'` oracle_date=`$SCRIPT_HOME/ldate $org_date` host_ip=`echo $one_line | awk '{ print $3 }' | sed 's/ //g'` # transfer client_ip from alphabet to digital client_addr=`echo $client_ip | egrep -i -e [a-z] | sed 's/ //g'` # get the length of client_addr LENGTH=`expr $client_addr : '.*'` .. done Hope that it is helpful! Don [EMAIL PROTECTED] wrote: hi all , how can I read a text file and print line by line. Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBMS_REPAIR Package
Hi! If dbv reads a block in transition, it will appear corrupt. In 9i, I believe dbv reads a block multiple times, if it doesn't get a consistent (non-corrupted) image first time. If it gets the block ok during next attempts, block isn't reported corrupt. But if several subsequent attempts fail, a dbverify output statistic Total Pages In Flux is incremented (might be that dbv is comparing the block image just read to image of same block read in previous attempt). So that means, 9i can give correct results on open datafiles as well. (I haven't tested or verified it, its based on 9.2 docs: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch13.htm #1006796) Personally, I think it a colossal waste of time to run dbverify. No, it can be useful in several cases: validating backups, verifying restored files etc.. If at all, it can be ore like waste of IO bandwith. Also, in 9i you can do segment level dbverify, that can be quite useful in some cases. In 9 years of DBA'ing, I've experienced maybe 3 or 4 instances of a corrupt block, and it was always an index. The solution was to drop/rebuild the index. Ok, you've been lucky. I've seen them in data, index, rollback, even temp segements. And in few cases the index rebuild was definitely not a solution, because the index was a global index on one billion row table, thus it was definitely easier to restore recover in our case, than allocate huge amounts of temp space and waste a lot of IO and CPU resources for rebuilding. Cheers, Tanel. Jared Stefick Ronald S Contr ESC/HRIDD [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/17/2003 07:39 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: DBMS_REPAIR Package I dug a little more and found my answer. I found that Oracle uses DBMS_REPAIR just to put a band-aid on the corrupt blocks. It basically identifies the corrupt block and marks it so oracle skips over it like it's not even there. -Original Message- Sent: Thursday, July 17, 2003 8:55 AM To: Multiple recipients of list ORACLE-L Has anyone ever used DBMS_REPAIR? If so, what do you think of it, does the DB have to be shutdown to run it. Does it really fix any corrupt blocks in the datafiles? We ran DBVerify and found several corrupt DB files in one of our DB's. TIA, Scott Stefick MILPDS OCP Oracle DBA [EMAIL PROTECTED] 210-565-2540 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Here comes Oracle10G
10G I think that's $/user Henry -Original Message- Kirtikumar Deshpande Sent: Thursday, July 17, 2003 3:44 PM To: Multiple recipients of list ORACLE-L OracleWorld web sites SFO/PARIS revealing the new name as: Oracle10G Gee, it's not 'i' anymore ? Nope!! It's Capital G. G for God? No. It's Grid :) Enjoy.. - Kirti __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Here comes Oracle10G
How about G for Greedy! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 17, 2003 3:44 PM OracleWorld web sites SFO/PARIS revealing the new name as: Oracle10G Gee, it's not 'i' anymore ? Nope!! It's Capital G. G for God? No. It's Grid :) Enjoy.. - Kirti __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Title: Message Are you perhaps of Greek descent and living in Wisconsin? :-) Allan -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Correction: Blessed are the cheesemakers, for they shall be called the sons of God. Blessed are the Greek, for they shall inherit the Earth. Comment: It's obviously deeper then just the cheese makers, it is referring to all manufacturers of the dairy products. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 7:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Blessed are the cheesemakers, because they shall rule the Kingdom of God. Blessed are the Greek, because they shall inherit the Earth. Hope this helps you. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Tom Pall [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 7:39 PMTo: Multiple recipients of list ORACLE-LSubject: help __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]
RE: oracle10g
Think "G" for globally. They are thinking globally. The grid computing page on otn says grid computing is available now for 9i release 2... Patrice. -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 4:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
RE: Physical Design Question
Title: Physical Design Question Thomas, Thanks for the comments. The databases are all different versions (8.1.7.3 to 9.2.0.2.0), at least for the time-being. In your suggestion to use 1 Oracle Home for multiple databases, then maybe later split into multiple Oracle Homes, do you have to relink the database files or anything special, or do you just have to change the Oracle Home environment variable to point to a new Oracle Home? Best regards, David B. Wagoner Database Administrator
RE: oracle10g
10G -- amount of force needed to be applied to one's head to get thru install. 10GI -- special military-strength version. 10BG -- allows instant archiving/retrieval of 70s disco music 10Gee--Wow. That's really neat. 10GB -- new installation on 16 CDs or 3 convenient DVDs. 10G4 -- Mac-only version 10Gentoo -- Linux-only version 10GForce -- Minimum video card needed to install. See also the "1-Rover-1" edition. sigh Back to work now... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 3:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g Think "G" for globally. They are thinking globally. The grid computing page on otn says grid computing is available now for 9i release 2... Patrice. -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 4:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
RE: Here comes Oracle10G
(G for gazillion) 10G - Easy to remember pricing now, 10G (gazillion) per processor! 10G - ID10T The Enterprise Capable Value-Added Synergies With Paradigm Shift Detection and Resource balanced touch points. The database that powers the grid??!! lol crackin' myself up again... -Original Message- Sent: Thursday, July 17, 2003 2:44 PM To: Multiple recipients of list ORACLE-L OracleWorld web sites SFO/PARIS revealing the new name as: Oracle10G Gee, it's not 'i' anymore ? Nope!! It's Capital G. G for God? No. It's Grid :) Enjoy.. - Kirti __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Here comes Oracle10G
Hi! And the booth where they'll be giving away 10G installation CDs at OracleWorld San Francisco, will be named G-spot?! ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 17, 2003 10:44 PM OracleWorld web sites SFO/PARIS revealing the new name as: Oracle10G Gee, it's not 'i' anymore ? Nope!! It's Capital G. G for God? No. It's Grid :) Enjoy.. - Kirti __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Here comes Oracle10G
No, it's G... another ORA-600. Or G... it's down again. JW - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 17, 2003 8:59 PM Kirtikumar Deshpande wrote: OracleWorld web sites SFO/PARIS revealing the new name as: Oracle10G Gee, it's not 'i' anymore ? Nope!! It's Capital G. G for God? No. It's Grid :) Enjoy.. - Kirti The first thing that comes to mind (as a commuter) is Grid...lock! I can see it now...New oracle error, I'm sorry, but you can't get there from here. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle10g
Gridlock computing is available since the dawn of computing, all that is needed is a proper application design. I've seen quite a few applications using oracle RDBMS to implement gridlock computing,producing look and feel quite similar to LIE (I-495 in NY) on Monday 08:15 A.M.. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 4:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g Think "G" for globally. They are thinking globally. The grid computing page on otn says grid computing is available now for 9i release 2... Patrice. -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 4:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
RE:
Title: Message Nope, I am a Croatian and I live in Connecticut. I was just referring to an old movie called "The Life of Brian". Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Nelson, Allan [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 4:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Are you perhaps of Greek descent and living in Wisconsin? :-) Allan -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Correction: Blessed are the cheesemakers, for they shall be called the sons of God. Blessed are the Greek, for they shall inherit the Earth. Comment: It's obviously deeper then just the cheese makers, it is referring to all manufacturers of the dairy products. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 7:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Blessed are the cheesemakers, because they shall rule the Kingdom of God. Blessed are the Greek, because they shall inherit the Earth. Hope this helps you. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Tom Pall [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 7:39 PMTo: Multiple recipients of list ORACLE-LSubject: help __This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]
Re: x server
Are you looking for something like Exceed? If so try WinaXe - From http://www.tucows.com http://www.jcraft.com/weirdx AK [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: Sent by: Subject: x server [EMAIL PROTECTED] .com 07/17/2003 09:49 AM Please respond to ORACLE-L is there any free x server (unlimited ) software for windows 2000 ? -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another OCP slant...
I'm fortunate in having a public sector employer that believes in education (but not so fortunate because education only comes with a company stamp, so the like of the Miracle db forum are out :( ) so I did the classes apart from the network stuff cause I was bored by then. What I did find useful was the selftest software from the eponymous company, that told me what the syllabus was and where I was weak (MTS that'd be the one 0/6 repeatedly). STS stuff is cheap and purports to do some of the education as well. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jesse, Rich Sent: 17 July 2003 20:19 To: Multiple recipients of list ORACLE-L Subject: RE: Another OCP slant... Yipe! Not having taken the OCP route (yet -- or, if ever), how much does the fail-retake-retake method cost in $$$? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jonathan Gennick [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 11:10 AM To: Multiple recipients of list ORACLE-L Subject: Re: Another OCP slant... [snip] Back in the Oracle7 days I put off and put off taking the exams because I never felt ready. (Do you ever really feel ready?) Finally, one day, I kicked myself in the rear and signed up for all four exams in one go. I passed three and flunked one, but while failing that one exam I also picked up a good idea of what it was that I needed to go learn in order to pass it the next time. That's been my basic approach ever since: try an exam, hope I pass, and if I fail at least I know what I need to go and learn. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
install delete_commit procedure
Hi All, I would like to create DELETE_COMMIT procedure (developed and distributed by Oracle support). Does anyone know where I can get the script? Thanks in advance for your help. Anna _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
NNC-00425: meta-data violation -- need sanity check!
All Im setting up a name server on Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production On windows 2000 server Im doing eerything within the namesctl utility as typically I find the gui to be too buggy for my tastes. So I have the service running C:\ namesctl Currently managing name server NS_DB2 Version banner is Oracle Names for 32-bit Windows: Version 9.2.0.1.0 - Product ... My problem is the utility does not like the syntax of my large multi db version tnsnames file 60 dbs. So, I simplify the test and just use 1 entry running on the names server. Tnsnames.ora orcl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = db2)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) When I do a load_tnsnames I get NAMESCTL load_tnsnames Name: orcl Response status: NNC-00425: meta-data violation No records loaded This is the default tnsnames! Ummm... sanity check please!! ;-) Here we have the error definitions whch arent really helpful http://storacle.princeton.edu:9001/oracle8-doc/server.805/a58312/net8nnc 1.htm So I turn to the water walkers on this list grin!! This has to be a bug. I was counting on pulling in the one 9.2 tns entry and then entering the other 60 by hand yecch!! Thanks! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to make SPFILE in sync with INIT.ORA ?
Kirti wrote The other parameters that will get you in the same trouble are related to the special buffer pools.. I ran into this issue with 9iR1 and decided to stay away from SPFILE stuff... The failure of Oracle (programmers) checking for such exclusiveness (?) tells their background. Doesn't it? I forget where I read this (may a post right here), but, someone suggested to create a database trigger (to fire before shutdown) to write out pfile from spfile. Good idea, I think. And keep a backup of the init.ora. Yeah that makes sense, and we mandate that any parameter change goes to both the spfile and the pfile and is documented a trigger would be a good way to do this. Then I got to thinking, well I have to keep the pfile backed up anyway in text form, I have to write cchange documentation for a change, so in fact the pfile saves me , um nothing. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Veritas and Oracle 9i with failsafe
Got a cust who went Oracle 9i with failsafe... Now Veritas is broke and they evidently know it. Anyone else bit by this, and what was the solution if any? I guess the 9i is supposed to work, but when you add failsafe it's broke.. Hearing this 2nd hand you know.. Michael Alan Kline, Sr.PrincipalConsultantBusiness to Business Solutions, LLCPhone: 804-744-1545 Cell: 804-314-6262ICQ: 1009605, 975313Email: [EMAIL PROTECTED] Web: www.b2bsol.com
Distributed Oracle
I have a customer whose long term goal is to have what would probably be close to RAS, but with the servers on a FAST backbone and about 500-800 feet apart... Is there a way to put that together with hardware software? In some ways they may even want to force a splitting of the load perhaps putting AR, AP, and GL users on one box and Inventory on the other box. It's the "distance" thing that I'm not sure about as the servers will be Windows 2000 Server. It's only a 9 gig database, and really needs a lot of tuning, but still, we're not talking terabytes. Thanks. Michael Alan Kline, Sr.PrincipalConsultantBusiness to Business Solutions, LLCPhone: 804-744-1545 Cell: 804-314-6262ICQ: 1009605, 975313Email: [EMAIL PROTECTED] Web: www.b2bsol.com