RE: Question re. Oracle clustering on Red Hat Advanced Server
Hi All I know is that we used to completely different machines to set up a windows test RAC. The requirement seems to be that the OS must be the same. Jack -Original Message- Sent: Wednesday, January 28, 2004 4:24 PM To: Multiple recipients of list ORACLE-L When running on a clustered environment, do all the servers have to be identical? Oracle says that the beauty of using blade servers is you buy what you need now, then add later. What if later is two years later? You might not be able to buy the same machines, only more powerful ones. Does that mess up Oracle RAC? Can RHAS cluster different hardware together successfully? 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!
Looking at the source (list owner) I'd say it is. Jack -Original Message- Sent: Thursday, January 22, 2004 9:29 AM To: Multiple recipients of list ORACLE-L Is this a genuine mail...? I'm a part of the list. -Original Message- Sent: Thursday, January 22, 2004 1:56 PM To: [EMAIL PROTECTED] Dear Oracle-L subscriber, Due to changing circumstances, the Oracle-L mailing list has found a new home. Fatcity.com has graciously hosted Oracle-L for several years, and I thank Bruce Bergman for his hard work on our behalf, but the time has come to move to a new host. Oracle-L will be hosted by freelists.org, effective immediately. In the past when this list has moved, I used a list of subscribers to automatically subscribe people to the new address, thinking I was providing a service. To avoid dealing with irate users that forgot they had subscribed (where does their mail go?) and their attorneys (don't care to hear from them again ) this new list will be 100% opt in. What this means is that you will need to subscribe to the new address if you wish to remain on the Oracle-L mailing list. This email is being sent to you once individually, and will also appear in the regular Oracle-L traffic. After a period of time (2 weeks or so) [EMAIL PROTECTED] will be shut down. At this time, I don't know for how long the Oracle-L archives at fatcity.com will be available. Instruction for subscribing to the new list are at the end of the message. I look forward to seeing you all at [EMAIL PROTECTED] Jared Still -- to subscribe: send email to [EMAIL PROTECTED] with 'subscribe' in the Subject field OR Subscribe via the web site - http://www.freelists.org/login.html To send email to the list, use this address: [EMAIL PROTECTED] You can unsubscribe from [EMAIL PROTECTED] by: send email to [EMAIL PROTECTED] with 'unsubscribe' in the Subject field OR Unsubscribe via the web site - http://www.freelists.org/login.html Documentation - http://www.freelists.org/help/ Searchable archives - http://www.freelists.org/archives/oracle-l Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Venu Gopal 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: Jack van Zanen 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: PERL?
Hi I tend to use PHP (and present the results in a browser or via email) for scripts that fall outside the scope of (PL/)SQL. I have never had a serious look at Perl, is there any website(s) that can give a clear explanation of the pro's con's of both? The reason I choose PHP was the ease of learning and availability of resources/examples. Jack -Original Message- Sent: Monday, December 08, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Perl is a full flege programming language, it can do almost anything such as Java or C++ can do. SQL*Plus or Shell is very limited in terms of functionalities. Besides, Perl is portable language. Perl code runs on almost any platforms. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Sunday, December 07, 2003 22:34 I've read a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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).
Anyone downloaded Oracle 9i for Solaris64 lately (Technet)
Title: Anyone downloaded Oracle 9i for Solaris64 lately (Technet) Hi All, I'm trying to download Oracle 9i for Solaris64 and have done so from two locations both yesterday and the day before and keep getting cpio: Can't read input: end of file encountered prior to expected end of archive. error while cpio file number 1(disk1). File 2 3 work fine. It is not finished because at the end I miss files (like runInstaller). So it looks like a corrupt file on technet. Anybody been succesful doing the same lately?? TIA Jack
RE: Multi-threaded server - will it help in this case
I thought setting server=dedicated in the tnsnames.ora was the setting to change this -Original Message- Sent: Tuesday, November 11, 2003 4:29 PM To: Multiple recipients of list ORACLE-L Tim, This bit: accomodate this application. Please be aware that you can mix dedicated and MTS by setting up different TNS names on different ports for each, so it is not an all-or-nothing seems to imply that MTS and Dedicated will each require their own listener ( different ports). Been awhile since I messed with MTS, but I don't recall that as being necessary. Is that what you meant? Jared On Tue, 2003-11-11 at 07:04, Tim Gorman wrote: Peter, MTS (or SS in 9i onwards) is an excellent choice to accomodate this application. Please be aware that you can mix dedicated and MTS by setting up different TNS names on different ports for each, so it is not an all-or-nothing situation. Most connections to the database outside of this CAE app will likely be better served with dedicated connections, so just dole out TNS names accordingly. Also, please be sure to estimate the size of your UGA by tracking values (i.e. name like '%uga%') in V$SESSTAT at peak periods then sizing the Large Pool to accomodate, before you enable MTS. Unless you're really constrained for memory, don't be shy about this; double the highest value you sum from V$SESSSTAT to be safe. After enabling MTS, monitor the value of free memory where POOL = 'large pool' in V$SGASTAT. If you've oversized, you can start backing down on LARGE_POOL_SIZE gently, if you need the memory elsewhere... Hope this helps... -Tim Environment: AIX 4.3 Oracle 8.1.7 The application is a CAE tool which stores metadata for a hierarchy of 3D engineering design models. When a user opens a model at a given level in the design, the application retrieves data about that model and all of the models below it in the design try. This often involves as many as 100 or more models. Unfortunately, the way the application is written, it opens a new connection to the database for each model. Thus, in the process of retrieving metadata, it may open and close as many as 100 connections to the database. Obviously, this causes some performance problems, especially for remote users. The number of users when the system goes fully into production is going to be in the low 100's. The vendor is not interested in changing the way the software works. Will use of the mult-threaded server improve performance in this situation, for example, by eliminating the overhead of starting a dedicated server for each connection? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: Jared Still 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: Jack van Zanen 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).
Avoiding full table scan
Title: Avoiding full table scan Hi All, I wish to avoid a full tablescan on the following data V. Zanen Zanen Van Zanen ... ... ... Lot's more data Select * from table where upper(name) like '%ZANEN%' I could create a function based index on upper(name) but this does not take care of the % and like operator. Oracle has this (I believe it's called) context stuff that you can index varchar fields etc. Is this the (only possible?) way to go?? TIA Jack
RE: Temp Tablespace
message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Gaja Krishna Vaidyanatha Principal Technical Product Manager, Application Performance Management, Veritas Corporation E-mail : [EMAIL PROTECTED] Phone: (650)-527-3180 Website: http://www.veritas.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Hau 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: vikas kawatra 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: Jack van Zanen 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: Strange Request
Dbms_system.ksdwrt(2,'ORA-600: This is a test error message') Writes a message to the alert log Change the 2 into a 1 writes to trace file and 3 (I think writes to both) Jack -Original Message- Sent: Wednesday, October 08, 2003 10:25 AM To: Multiple recipients of list ORACLE-L How about... declare ora600 exception; pragma exception_init(ora600, -600); begin raise ora600; end; / show errors; HTH -- David Lord -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 02:14 To: Multiple recipients of list ORACLE-L Subject: Strange Request Ok...strange request time. I want to test a script that I found on the DBA Village web site. It's supposed to capture some information whenever there's a DB error. Does anybody know how to trigger a 'benign' ORA-600 so I can test this functionality? Thanks, Mike --- == = Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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 and its attachments are intended for the author's addressee only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. Steps have been taken to ensure this e-mail and attachments are free from any virus, but advise the recipient to ensure they are actually virus free. The views, opinions and judgments expressed in this message are solely those of the author. The message contents have not been reviewed or approved by Iron Mountain. *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lord David 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: Jack van Zanen 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: logg error line in unix
Bad records go to bad file Logfile can be turned on with log parameter Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: mailto:[EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -Original Message- Sent: Thursday, October 02, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Hallo again, I would like to get some help on this. I have a script called let us say test.sh and that script runs an sqlloader script, which loads semicolonseparated data into an oracle table. I would like to have an example on how to log an error when trying to insert the data intothe table. I want the error to be both the error message and also tell me which line that is wrong in the file. So both errormessage and also complete line which is the error line. Thanks in advance Roland -- 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: Jack van Zanen 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).
Oracle 9i Rac scripts
Hi All Since I'm new to 9iRAC (as are a lot of people I guess) I need some help. I'm working my way through the (tuning) docs and have compiled this set of sql's for monitoring the Cluster. Could the people that have experience with the 9i RAC cluster look at it and tell me what is missing or what is absolute garbage. TIA Jack 9iRAC.sql Description: Binary data
RE: logg error line in unix
Sqlldr help=y from the command line. or D:\oracle\ora92\rdbms\demo Lookup the ulcase*.ctl files jack -Original Message- Sent: Thursday, October 02, 2003 4:45 PM To: Multiple recipients of list ORACLE-L Please give me an example on this. Roland Jack van Zanen [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] S.NLcc: Sent by: Subject: RE: logg error line in unix [EMAIL PROTECTED] .com 2003-10-02 15:54 Please respond to ORACLE-L Bad records go to bad file Logfile can be turned on with log parameter Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: mailto:[EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -Original Message- Sent: Thursday, October 02, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Hallo again, I would like to get some help on this. I have a script called let us say test.sh and that script runs an sqlloader script, which loads semicolonseparated data into an oracle table. I would like to have an example on how to log an error when trying to insert the data intothe table. I want the error to be both the error message and also tell me which line that is wrong in the file. So both errormessage and also complete line which is the error line. Thanks in advance Roland -- 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: Jack van Zanen 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: Jack van Zanen 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).
9i RAC Scripts.// LONG
Hi All, I am trying to figure out what and why to monitor in a 9i RAC environment. Could any of you guys please comment on the following: V$FALSE_PING is an Oracle9i Real Application Clusters view. This view displays buffers that may be getting false pings. That is, buffers pinged more than 10 times that are protected by the same lock as another buffer that pinged more than 10 times. Buffers identified as getting false pings can be remapped in GC_FILES_TO_LOCKS to reduce lock collisions. Note: Setting this parameter to any value other than the default will disable Cache Fusion processing in Oracle9i Real Application Clusters. !Does this mean we should not temper with this??? I guess the number OF ROWS returned BY this query should be AS close to zero AS possible, Right? From the rows returned I guess the forced_reads/writes should be as close to zero as possible, Right ? Select name , partition_name , kind , file# , block# , status , xnc , forced_reads , forced_writes From GV$FALSE_PING V$CACHE_TRANSFER This is an Oracle9i Real Application Clusters view. The V$CACHE_TRANSFER view is identical to the V$CACHE view but only displays blocks that have been pinged at least once. This view contains information from the block header of each block in the SGA of the current instance as related to particular database objects. I guess the number OF ROWS returned BY this query should be AS close to zero AS possible, Right? From the rows returned I guess the forced_reads/writes should be as close to zero as possible, Right ? select name , partition_name , kind , file# , block# , status , xnc , forced_reads , forced_writes fromgv$cache_transfer; There are many views based on global cache etc.. That are not really clear to me what I can use to figure out cache fusion problems. I did find in the documentation that information could be collected from v$sysstat about global cache/locks that can be used to calculate certain response times etc.. TIA Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i RAC Scripts.// LONG
I hope not, This is from the Oracle documentation (quite a lot is about RAC so to get the general idea is OK but details are difficult to grasp). Since the note: said setting that parameter to anything else but the default would disable cache fusion in Oracle 9i RAC clusters, My question was if we should temper with this setting. My gut feeling tells me no. Also if anybody has links to sites that have useful scripts to monitor the RAC portion of the database, please let me know. TIA Jack -Original Message- Sent: Wednesday, October 01, 2003 1:39 PM To: Multiple recipients of list ORACLE-L GC_FILES_TO_LOCKS? Sounds familiar from some other times. Why do you use hashed (static) locks? I thought that releasable locks are default in 9i? Is there a reason to revert to the Oracle 7 OPS behvior? On 2003.10.01 06:13, Jack van Zanen wrote: Hi All, I am trying to figure out what and why to monitor in a 9i RAC environment. Could any of you guys please comment on the following: ** ** V$FALSE_PING is an Oracle9i Real Application Clusters view. This view displays buffers that may be getting false pings. That is, buffers pinged more than 10 times that are protected by the same lock as another buffer that pinged more than 10 times. Buffers identified as getting false pings can be remapped in GC_FILES_TO_LOCKS to reduce lock collisions. -- -- Note: Setting this parameter to any value other than the default will disable Cache Fusion processing in Oracle9i Real Application Clusters. !Does this mean we should not temper with this??? -- -- I guess the number OF ROWS returned BY this query should be AS close to zero AS possible, Right? From the rows returned I guess the forced_reads/writes should be as close to zero as possible, Right ? Select name , partition_name , kind , file# , block# , status , xnc , forced_reads , forced_writes From GV$FALSE_PING ** ** V$CACHE_TRANSFER This is an Oracle9i Real Application Clusters view. The V$CACHE_TRANSFER view is identical to the V$CACHE view but only displays blocks that have been pinged at least once. This view contains information from the block header of each block in the SGA of the current instance as related to particular database objects. I guess the number OF ROWS returned BY this query should be AS close to zero AS possible, Right? From the rows returned I guess the forced_reads/writes should be as close to zero as possible, Right ? select name , partition_name , kind , file# , block# , status , xnc , forced_reads , forced_writes from gv$cache_transfer; ** ** There are many views based on global cache etc.. That are not really clear to me what I can use to figure out cache fusion problems. I did find in the documentation that information could be collected from v$sysstat about global cache/locks that can be used to calculate certain response times etc.. TIA Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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
OT: Linux VPN and routing HOWTO
Title: OT: Linux VPN and routing HOWTO Hi I'm Sorry to put this way OT subject here, but you guys usually come up with the answer anyway. I'm trying to setup my linux at home so that I can VPN into it. Now I can connect already but can't ping or connect any of the machines in my network. I huess I have to setup some sort of routing now, but I can't find any a-z documentation on this topic. I used the PPtP VPN sever that came with United linux Once again sorry. Jack
RE: [Q] need help on SQLplus select distinct !!
Select distinct employee_id||lname|fname|mi||hiredate as employee from emp -Original Message- Sent: Tuesday, September 23, 2003 5:00 PM To: Multiple recipients of list ORACLE-L I plan to select distinct data from table. anyone has suggestion? Thanks. select distinct employee from (select employee_id, lname, fname, mi, hiredate , as employee from emp) SQL SQL / from (select employee_id, lname, fname, mi, hiredate , as employee from emp) * ERROR at line 2: ORA-00936: missing expression __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon 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: Jack van Zanen 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: two instances on same box (Suse Linux ES 8)
What are the error messages?? Should be able to run w/o problems Jack -Original Message- Sent: Monday, September 22, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Hi! We are running 2 Oracle instances on one Suse Linux box (under the same Unix oracle user). We have two oracle homes 9.0.1 (/opt/oracle/iasdb) and 9.2.0 (/opt/oracle/loga) The first instance starts up fine, but the second one fails. It seems to me that switching the environments fails. How do I switch between environments? ORAENV and dbhome don't work too well. oratab looks fine. Does anybody have experience with multiple instance on Linux (especially Suse). not sure whether Red Hat is similar... This is 9i on Suse Linux Enterprise Server 8. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: two instances on same box (Suse Linux ES 8)
Have you ever succeded in starting the 9.2.0 database? jack -Original Message- Sent: Monday, September 22, 2003 12:40 PM To: Multiple recipients of list ORACLE-L Hello Jack, The problem is that the NLS environment does not get reset when using oraenv. It resets ORACLE_HOME and ORACLE_SID, but ORA_NLS33 always has the values of the first instance. I had a look at the oraenv script, and there is no NLS string in there... So when you try to switch to the second instance and start it, you get th error message that missing or wrong value for NLS variable. Any idea? Thanks, Helmut -Ursprüngliche Nachricht- Von: Jack van Zanen [mailto:[EMAIL PROTECTED] Gesendet: Montag, 22. September 2003 12:20 An: Multiple recipients of list ORACLE-L Betreff: RE: two instances on same box (Suse Linux ES 8) What are the error messages?? Should be able to run w/o problems Jack -Original Message- Sent: Monday, September 22, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Hi! We are running 2 Oracle instances on one Suse Linux box (under the same Unix oracle user). We have two oracle homes 9.0.1 (/opt/oracle/iasdb) and 9.2.0 (/opt/oracle/loga) The first instance starts up fine, but the second one fails. It seems to me that switching the environments fails. How do I switch between environments? ORAENV and dbhome don't work too well. oratab looks fine. Does anybody have experience with multiple instance on Linux (especially Suse). not sure whether Red Hat is similar... This is 9i on Suse Linux Enterprise Server 8. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: Jack van Zanen 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).
Connect sys/password@database as sysdba E-Business suite
Title: Connect sys/[EMAIL PROTECTED] as sysdba E-Business suite Hi All, I have seen some weird behaviour and must have been searching in the wrong places. When logging in to a 9i RAC environment using the syntax sys/[EMAIL PROTECTED] as sysdba it works fine at the primary instance but reports invalid username/password at the secondary instance. Is this normal behaviour? When connecting to an e-business suite(11.5.9?) database I noticed that my sessions (ODBC SQL*Plus) were executing the suites portal login procedure.In fact all connections did this. Also my ODBC connection timed out on tables owned by a none suite schema. Is there a database logon trigger on e-business suite that forces every connection through the suites security mechanism or something? (I have never worked with e-business so I know nothing about it, I just installed some monitor tools repository in this database and could not get to the data) TIA Jack
RE: Connect sys/password@database as sysdba E-Business suite
Hi Tanel I did not mention that w/o the connect string it works Will look at the password file. I have not tried to run a query in SQL*Plus, will ask the cst to do so. I use a new user for the repository (not apps) Jack -Original Message- Sent: Friday, September 12, 2003 1:49 PM To: Multiple recipients of list ORACLE-L Hi! Are you sure that you have correct password file in second instance? Maybe you're using wrong password (or do not have pwdfile) buf on first instance you just belong to os DBA group, thus you can log on using whatever password you provide. If you access your data using ODBC, which username do you use? Is it APPS? Afaik there is no restricting logon trigger in apps, at least up to 11.5.7 there isn't. Try to execute the exact query manually under same user first, to see whether the timeout problem comes from database or ODBC driver. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Friday, September 12, 2003 11:29 AM Hi All, I have seen some weird behaviour and must have been searching in the wrong places. When logging in to a 9i RAC environment using the syntax sys/[EMAIL PROTECTED] as sysdba it works fine at the primary instance but reports invalid username/password at the secondary instance. Is this normal behaviour? When connecting to an e-business suite(11.5.9?) database I noticed that my sessions (ODBC SQL*Plus) were executing the suites portal login procedure.In fact all connections did this. Also my ODBC connection timed out on tables owned by a none suite schema. Is there a database logon trigger on e-business suite that forces every connection through the suites security mechanism or something? (I have never worked with e-business so I know nothing about it, I just installed some monitor tools repository in this database and could not get to the data) TIA Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: making me crazy
Maybe copying isn't an option, but if on NIX how about putting a symbolic link in or tnsnames in the /etc (checked before $ORACLE_HOME/network) directory and not set TNS_ADMIN Jack -Original Message- Sent: Wednesday, September 10, 2003 4:45 PM To: Multiple recipients of list ORACLE-L Dealing with 2 Oracle Homes - one if which I need to run the listener from and one in which I need to use the tnsnames.ora definitions from and no I can't just copy the tnsnames.ora to the 1st Oracle Home. Even when I set the oracle home from which to run lsnrctl it tries to use the listener.ora from the TNS_ADMIN home. How can I make sure to explicitly start the correct listener.ora? Thanks, Paula -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: Jobs and OEM... how to
How about a shell script, scheduled with AT or CRON? -Original Message- Sent: Tuesday, September 09, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Hi to everybody!! I would like to create a job that EXPort my database, but... I *do not* want to use OEM. OEM uses tcl and the intelligent agent to schedule its jobs... how can I create a job that can export my database? (no problem if I have to program with tcl files) Any ideas? any sample (would be better :-) TIA JL __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.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: Jack van Zanen 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 9i Rel. 2 on Red Hat Advanced Server 2.1
I have been led to believe that AS2.1 has been optimized on for instance I/O and is therefore a lot faster on the I/O side (I believe it is async I/O that was worked on) Probably some other issues as well but this one stuck. I have no experience with it though. -Original Message- Sent: Thursday, September 04, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi! Is anybody using Oracle 9i on Red Hat Advanced Server? I just installed RAS 2.1 and did not notice much difference to a regular Red Hat Installation... What is the beig difference between Advanced Server and regular Red Har Linux? Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: Error Log
Can't you tell your trigger to ignore this error as well. -Original Message- Sent: Saturday, August 30, 2003 7:19 AM To: Multiple recipients of list ORACLE-L Use a Database Trigger AFTER SERVERRROR. [careful, the table might fill up pretty quickly -- e.g at my site a load job ignores ORA-0001 errors but this table gets a lot of ORA-0001 errors !!] Try this : drop table system.oracle_errors; create table system.oracle_errors (db_username varchar2(30), db_session_id number, db_process_id number, unix_process_id varchar2(9), client_process_id varchar2(9), client_program varchar2(48), client_machine varchar2(64), client_terminal varchar2(30), client_os_user varchar2(30), appl_user_name varchar2(100), -- exclude if not using Oracle Apps appl_responsibility_name varchar2(100), -- exclude if not using Oracle Apps appl_form_name varchar2(80),-- exclude if not using Oracle Apps err_timestamp date, error_msg varchar2(2000)) tablespace customd -- or any other TBS storage (initial 4M next 1M maxextents 500 pctincrease 0) / create index system.oracle_errors_ndx1 on system.oracle_errors(appl_login_name,err_timestamp) tablespace customx -- or any other TBS storage (initial 256K next 256K maxextents 500 pctincrease 0) / create index system.oracle_errors_ndx2 on system.oracle_errors(err_timestamp) tablespace customx -- or any other TBS storage (initial 256K next 256K maxextents 500 pctincrease 0) / create index system.oracle_errors_ndx3 on system.oracle_errors(error_msg) tablespace customx -- or any other TBS storage (initial 1M next 1M maxextents 500 pctincrease 0) / drop trigger system.oracle_errors_trg; create or replace trigger system.oracle_errors_trg after servererror on database begin insert into system.oracle_errors select s.username, s.sid, p.pid, p.spid, s.process, s.program, s.machine, s.terminal, s.osuser, f.user_name, f.responsibility_name, f.user_form_name, -- exclude all three if not using Oracle Apps sysdate, dbms_utility.format_error_stack from apps.fnd_signon_audit_view f, v$session s, v$process p -- exclude apps.fnd_signon_audit_view where s.audsid = userenv( 'sessionid' ) and s.paddr=p.addr and p.pid=f.pid(+); -- exclude this join if not using Oracle Apps end; / At 06:19 PM 29-08-03 -0800, you wrote: Is there anyway to setup oracle on the server side to log all fail and error transaction in a file or something? I mean, error/fail transaction due to, eg: Integrity Contraint violation, Check constraint, Not Null constraint, any other error. It would simply debugging since then we don't have to output / catch and send error and SQL statement on the application level. System: ORACLE 9i on Redhat Linux 7.3 Thanks. RDB -- Reuben D. Budiardja -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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: Jack van Zanen 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
RE: Question about Constraint
Hi I think the only way to do this is by using a (before insert) trigger. Jack -Original Message- Sent: Friday, August 29, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Hallo, I would like to gets ome help on this: I have this table IdCompanynumber First Name LastNameType 1 123 Jim Andersson 1 2 234 Tom Perkins 2 3 565 Henry Ford1 I would like to have a constraint so when I try to add and the same companynumber that already exists(for instance 234) I am not allowed to do this if the filed Type has the value 1. So if I add a companynumber which already exists and the Type is 2, then I should be allowed to add this companynumber. Maybe this is simple but woul dreally appreciate some help onhow to write this. Roland -- 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: Jack van Zanen 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: [Q] SQLPLUS help on distinct
Select distinct employee From (select rpad(employee_id,6,' ')) ||';'||ssn as employee from EMP order by employee_id) Jack -Original Message- Sent: Friday, August 29, 2003 4:45 PM To: Multiple recipients of list ORACLE-L I have problem to use distinct with Function on select statement. Can anyone give me a hint? Thanks. SQL select distinct (rpad(employee_id,6,' ')) ||';'|| ssn from EMP 2 order by employee_id; select distinct (rpad(employee_id,6,' ')) ||';'|| ssn from EMP * ERROR at line 1: ORA-01791: not a SELECTed expression __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon 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: Jack van Zanen 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: Hey Jared!!
-- Author: Jack van Zanen 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: upgrade 7.3.4 to 9.0.10
Title: Message AFAIK, Migrate can't go directly from 7 to 9 you'll need an Oracle 8 in between. I'd do export/import if it's at all possible. Jack -Original Message-From: Jeroen van Sluisdam [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 1:10 PMTo: Multiple recipients of list ORACLE-LSubject: upgrade 7.3.4 to 9.0.10 Hi, We have the task of finally upgrading our 7.3.4 db We have a new test-bix with HP-UX 11.11 and our old development-bix is on HP-UX 10.20 I have found several docs stating that in order to migrate at same time also upgrading OS at different machines we need to install 7.3.4 on HP-UX 11 before we can use the migration utility. Is this true ? Is this still available at Oracle? Any tips and trics on these kinds of migration ? Is it quicker to use export and import for these kind of migrations? Thanks in advance, Jeroen
RE: Query results to .csv
That can be achieved by setting colsep in sql*plus as well and than select * from table (less typing) :-) Does not help when a text field also contains comma's Jack -Original Message- Sent: Monday, August 25, 2003 3:07 PM To: Multiple recipients of list ORACLE-L Imran, Select COL1 ||','|| COL2||','||COL3 from table... will create a comma delimited file that you can SPOOL to an OS file. Or you could use a third patry product. Ron [EMAIL PROTECTED] 08/25/03 08:39AM Hi, Whats the best way to write the results of a SQL query to a CSV file? Thanks. _ Hotmail messages direct to your mobile phone http://www.msn.co.uk/msnmobile -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Imran Ashraf 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: Ron Rogers 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: Jack van Zanen 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).
OT: Mysql PHP list
Title: OT: Mysql PHP list Hi, Does anybody know a good list for questions about PHP in combination with Mysql (and oracle) TIA Jack
RE: Exact fetch
What does the load procedure look like? AFAIK this means that a select into returns more than one row in the subquery, which would indicate use of PL/SQL Any triggers etc..?? Jack -Original Message- Sent: Friday, August 22, 2003 4:45 PM To: Multiple recipients of list ORACLE-L Hallo, anyon who can tell me whatthis mean`? I get it while I am trying to load some data in some tables? ORA-01422: exact fetch re turns more than requested number of rows Thanks in advance Roland S -- 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: Jack van Zanen 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: dbca and finish button
Click to save and it'll continue Jack -Original Message- Sent: Tuesday, August 19, 2003 11:24 AM To: Multiple recipients of list ORACLE-L Have just installed Oracle 9.2 and am trying to use dbca to create a database. Even though I select to create a database it just displays the template with the option to save as HTML, but does not create the database! Am I missing something here? 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT: Trying to duplicate database from cold backup - auxi
Title: Message Hi Paula Another issue you may encounter is that duplicate in 8.1.7may not work w/o a "set until" clause see bug 2329702 Jack -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT: Trying to duplicate database from cold backup - auxi This is the type of script I am using: rman EOFconnect target rman/[EMAIL PROTECTED]connect catalog rman/[EMAIL PROTECTED]connect auxiliary sys/[EMAIL PROTECTED]run {resync catalog;allocate auxiliary channel d1 type disk;allocate auxiliary channel d2 type disk;set newname for datafile '/data/oracle8/TEST2/systemTEST2.dbf' TO '/data/oracle8/TEST3/systemTEST3.dbf';set newname for datafile '/data/oracle8/TEST2/rbsTEST2.dbf' TO '/data/oracle8/TEST3/rbsTEST3.dbf';set newname for datafile '/data/oracle8/TEST2/tempTEST2.dbf' TO '/data/oracle8/TEST3/tempTEST3.dbf';set newname for datafile '/data/oracle8/TEST2/dataTEST2.dbf' TO '/data/oracle8/TEST3/dataTEST3.dbf';sql 'alter system switch logfile';duplicate target database to test3LOGFILE'/data/oracle8/TEST3/redoTEST301.log' size 1M,'/data/oracle8/TEST3/redoTEST302.log' size 1M,'/data/oracle8/TEST3/redoTEST303.log' size 1M;}EOF -Original Message-From: Stankus, Paula G Sent: Monday, August 04, 2003 4:12 PMTo: '[EMAIL PROTECTED]'Subject: RE: URGENT: Trying to duplicate database from cold backup - auxiliary database not mounted error!!! Guys, When trying to duplicate database with this script I have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to create new logfiles. Get error: RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounte d
RE: How to take sql*loader trace/ AFTER LOGON SCHEMA TRIGGER
Yes I tried granting alter session first -Original Message- Sent: Tuesday, August 12, 2003 11:24 PM To: Multiple recipients of list ORACLE-L Does the user whom you created the trigger have alter session privilege? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 4:39 PM As system (8.1.7.3): create or replace trigger TRIGGER_NAME after logon on SCHEMA.schema begin Execute immediate 'alter session set events=''10046 trace name context forever, level 12'''; end; When I logon after creating this trigger as the user SCHEMA I get the error message insufficient privileges. If I grant DBA it seems to work but that is a bit much for privileges. Which privileges are neccesary to run this?? Just alter session won't work. Jack -Original Message- Sent: Monday, August 11, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Create or replace database trigger turn_tracing_on after logon on schema.scott Begin Execute immediate 'alter session set events=''10046 trace name context forever, level 8'''; End; / That should give you more then enough info to trace, especially on 9i. -- Mladen Gogala Oracle DBA -Original Message- Senthil Kumar Sent: Monday, August 11, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Hi All, I'm loading a set of data into one of my schema. And wanted to take the trace files also. I tried the follwoing. 1. Identified the sid,serila# for the sql*loader session. 2. used the follwoing, exec sys.dbms_system.set_sql_trace_in_session(19,11250,TRUE); but this is not generation any trace files. But if I trun my system to sql_trace=TRUE, I'm able to collect the trace details. I don't want to do this. I want to take the trace only for the sql*loader session. How do i do that. TIA, Senthil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Jack van Zanen 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
RE: How to take sql*loader trace/ AFTER LOGON SCHEMA TRIGGER
As system (8.1.7.3): create or replace trigger TRIGGER_NAME after logon on SCHEMA.schema begin Execute immediate 'alter session set events=''10046 trace name context forever, level 12'''; end; When I logon after creating this trigger as the user SCHEMA I get the error message insufficient privileges. If I grant DBA it seems to work but that is a bit much for privileges. Which privileges are neccesary to run this?? Just alter session won't work. Jack -Original Message- Sent: Monday, August 11, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Create or replace database trigger turn_tracing_on after logon on schema.scott Begin Execute immediate 'alter session set events=''10046 trace name context forever, level 8'''; End; / That should give you more then enough info to trace, especially on 9i. -- Mladen Gogala Oracle DBA -Original Message- Senthil Kumar Sent: Monday, August 11, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Hi All, I'm loading a set of data into one of my schema. And wanted to take the trace files also. I tried the follwoing. 1. Identified the sid,serila# for the sql*loader session. 2. used the follwoing, exec sys.dbms_system.set_sql_trace_in_session(19,11250,TRUE); but this is not generation any trace files. But if I trun my system to sql_trace=TRUE, I'm able to collect the trace details. I don't want to do this. I want to take the trace only for the sql*loader session. How do i do that. TIA, Senthil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Jack van Zanen 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).
FW: ORA-27101 RH linux 9 Oracle 9.2.0.3
, in the 'oracle' or client user's environment, only ora-1034 was reported e.g.: ORA-01034 ORACLE not available With 8.1.7, error ORA-27101 reports that the shared memory key generated by the client does not match any currently existing keys. This is to be expected if the ORACLE_HOME used by the client is not the same as that used to startup the database or when the ORACLE_SID value is not correctly referencing the right instance. Additional Search Words --- listener, tnslsnr, parameter, hashing algorithm, attach, SGA . (Embedded image moved Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices (Embedded image to file: pic32095.gif) and Terms of Use. moved to file: pic06932.gif) - Forwarded by Charlie Mengler/THD on 07/31/2003 01:01 PM - Jack van Zanen [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] s.nlcc: Sent by: Subject: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3 [EMAIL PROTECTED] .com 07/31/2003 08:54 AM Please respond to ORACLE-L I set the value to 2147483648 and it still does the same thing. Oracle database is open but when trying to connect through sqlnet I get ORA-27101. I do shutdown immediate and startup and the problem is gone for a while. I now stopped the archiver again and see if that gives me problems. BTW: Is it normal 9i behaviour to write logswitches to trace TIA Jack -Original Message- From: Jack van Zanen [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3 Damn your right, I need new glasses :-) Thx -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 3:14 PM To: Multiple recipients of list ORACLE-L Subject: RES: ORA-27101 RH linux 9 Oracle 9.2.0.3 The parameter shmmax (Shared Memory) is lower than the sugested. Please check: Yours: 536870912 Sugested: 2147483648 Sandro Augusto da Silva Technology Services Support NLA Technology Services Phone: +55 11 3398-8438 Fax: +55 11 3398-7522 -Mensagem original- De: Jack van Zanen [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 30 de julho de 2003 09:59 Para: Multiple recipients of list ORACLE-L Assunto: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3 Hi, Have tried to reconnect and get the error message 27101 (when using @sid logon) ** [EMAIL PROTECTED] admin]# cd /proc/sys/kernel [EMAIL PROTECTED] kernel]# cat sem 250 32000 100 128 [EMAIL PROTECTED] kernel]# cat shmmax 536870912 [EMAIL PROTECTED] kernel]# cat shmmni 4096 [EMAIL PROTECTED] kernel]# cat shmall 2097152 [EMAIL PROTECTED] kernel]# ulimit -u 4095 [EMAIL PROTECTED] kernel]# cat /proc/sys/net/ipv4/ip_local_port_range 102465000 [EMAIL PROTECTED] kernel]# cat /proc/sys/fs/file-max 65536 [EMAIL PROTECTED] kernel]# Only difference is that I set my semaphores higher than recommended (cat sem, cat shmmax) Thx -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:39 PM To: Multiple recipients of list ORACLE-L Subject: RES: ORA-27101 RH linux 9 Oracle 9.2.0.3 Have you tried to reconnect to the instance? Does the instance shuts down or your connection? Try changing the following parameters: Oracle9i Installation Guide
RE: ORA-27101 RH linux 9 Oracle 9.2.0.3
Title: Message I set the value to 2147483648 and it still does the same thing. Oracle database is open but when trying to connect through sqlnet I get ORA-27101. I do shutdown immediate and startup and the problem is gone for a while. I now stopped the archiver again and see if that gives me problems. BTW: Is it normal 9i behaviour to write logswitches to trace TIA Jack -Original Message-From: Jack van Zanen [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 4:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3 Damn your right, I need new glasses :-) Thx -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 3:14 PMTo: Multiple recipients of list ORACLE-LSubject: RES: ORA-27101 RH linux 9 Oracle 9.2.0.3 The parameter shmmax (Shared Memory) is lower than the sugested. Please check: Yours: 536870912 Sugested: 2147483648 Sandro Augusto da SilvaTechnology Services SupportNLA Technology ServicesPhone: +55 11 3398-8438Fax: +55 11 3398-7522 -Mensagem original-De: Jack van Zanen [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 30 de julho de 2003 09:59Para: Multiple recipients of list ORACLE-LAssunto: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3 Hi, Have tried to reconnect and get the error message 27101 (when using @sid logon) ** [EMAIL PROTECTED] admin]# cd /proc/sys/kernel[EMAIL PROTECTED] kernel]# cat sem250 32000 100 128[EMAIL PROTECTED] kernel]# cat shmmax536870912[EMAIL PROTECTED] kernel]# cat shmmni4096[EMAIL PROTECTED] kernel]# cat shmall2097152[EMAIL PROTECTED] kernel]# ulimit -u4095[EMAIL PROTECTED] kernel]# cat /proc/sys/net/ipv4/ip_local_port_range1024 65000[EMAIL PROTECTED] kernel]# cat /proc/sys/fs/file-max65536[EMAIL PROTECTED] kernel]# Only difference is that I set my semaphores higher than recommended (cat sem, cat shmmax) Thx -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:39 PMTo: Multiple recipients of list ORACLE-LSubject: RES: ORA-27101 RH linux 9 Oracle 9.2.0.3 Have you tried to reconnect to the instance? Does the instance shuts down or your connection? Try changing the following parameters: Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris 2-20 Installation Guide Perform the following steps to modify the kernel parameters by using the /proc file system. 1. Log in as the root user. 2. Change to the /proc/sys/kernel directory. 3. Review the current semaphore parameter values in the sem file by using the cat or more utility. For example, using the cat utility, enter the following command: # cat sem The output lists, in order, the values for the SEMMSL, SEMMNS, SEMOPM, and SEMMNI parameters. The following example shows how the output appears: 250 32000 32 128 In the preceding output example, 250 is the value of the SEMMSL parameter, 32000 is the value of the SEMMNS parameter, 32 is the value of the SEMOPM parameter, and 128 is the value of the SEMMNI parameter. 4. Modify the parameter values by using the following command syntax: # echo SEMMSL_value SEMMNS_value SEMOPM_value SEMMNI_value sem Replace the parameter variables with the values for your system in the order that they are entered in the preceding example. For example: # echo 100 32000 100 100 sem 5. Review the current shared memory parameters by using the cat or more utility. For example, using the cat utility, enter the following command: # cat shared_memory_parameter In the preceding example, the variable shared_memory_parameter is either the SHMMAX or SHMMNI parameter. The parameter name must be entered in lowercase letters. 6. Modify the shared memory parameter by using the echo utility. For example, to modify
ORA-27101 RH linux 9 Oracle 9.2.0.3
Title: ORA-27101 RH linux 9 Oracle 9.2.0.3 Hi, I have above setup on my homebox. Every now and then I get Oracle error 27101, and have to restart the database. I can connect / as sysdba and select * from v$database though. Has anybody seen this happen before and may be able to help me with this.?? The only thing that I can see is a trace file (I don't know if this is from the same time as when the database stopped serving requests) from the archiver. There is nothing in the alert log whatsoever. Is it normal behaviour that logswitches are recorded to trace files?? I have stopped the archiver process to see if that makes the problem go away. * [EMAIL PROTECTED] bdump]$ ls alert_Ora92.log ora92_arc0_2583.trc ora92_arc0_2674.trc ora92_arc0_10031.trc ora92_arc0_2597.trc ora92_arc0_2710.trc ora92_arc0_10498.trc ora92_arc0_2629.trc ora92_arc0_2842.trc ora92_arc0_10533.trc ora92_arc0_2634.trc ora92_arc0_5115.trc ora92_arc0_10557.trc ora92_arc0_2651.trc ora92_arc0_8432.trc ora92_arc0_14874.trc ora92_arc0_2657.trc ora92_arc0_8607.trc [EMAIL PROTECTED] bdump]$ cat *14874* /oracle/oradata/admin/Ora92/bdump/ora92_arc0_14874.trc Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production ORACLE_HOME = /oracle/app/product/9.2.0 System name: Linux Node name: Linux Release: 2.4.20-18.9 Version: #1 Thu May 29 07:08:16 EDT 2003 Machine: i686 Instance name: Ora92 Redo thread mounted by this instance: 1 Oracle process number: 8 Unix process pid: 14874, image: [EMAIL PROTECTED] (ARC0) *** SESSION ID:(7.1) 2003-07-30 09:24:33.995 - Created archivelog as '/data/oradata/Ora92/archive/1_57.dbf' [EMAIL PROTECTED] bdump]$ df -k Filesystem 1K-blocks Used Available Use% Mounted on /dev/hdc2 10078852 7872268 1694596 83% / /dev/hdc1 99043 14310 79619 16% /boot none 256892 0 256892 0% /dev/shm /dev/hdc4 66542832 6880604 56282028 11% /data [EMAIL PROTECTED] bdump]$ ls -l /data//oradata/Ora92/archive/ total 8124 -rw-r- 1 oracle dba 452096 Jul 27 13:33 1_55.dbf -rw-r- 1 oracle dba 1085952 Jul 28 08:56 1_56.dbf -rw-r- 1 oracle dba 6752256 Jul 30 09:24 1_57.dbf [EMAIL PROTECTED] bdump]$ PARAMETER SETTINGS: *.background_dump_dest='/oracle/oradata/admin/Ora92/bdump' *.compatible='9.2.0.0.0' *.control_files='/oracle/oradata/Ora92/control01.ctl','/oracle/oradata/Ora92/control02.ctl','/oracle/oradata/Ora92/control03.ctl' *.core_dump_dest='/oracle/oradata/admin/Ora92/cdump' *.db_block_size=8192 *.db_cache_size=8388608 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='Ora92' *.fast_start_mttr_target=300 *.hash_join_enabled=TRUE *.instance_name='Ora92' *.java_pool_size=0 *.large_pool_size=8388608 *.log_archive_dest_1='LOCATION=/data/oradata/Ora92/archive' *.log_archive_format='%t_%s.dbf' *.log_archive_start=true *.nls_date_language='DUTCH' *.nls_language='DUTCH' *.nls_numeric_characters=',.' *.open_cursors=300 *.pga_aggregate_target=25165824 *.processes=150 *.query_rewrite_enabled='FALSE' *.remote_login_passwordfile='EXCLUSIVE' *.shared_pool_reserved_size=4194304 *.shared_pool_size=8388608 *.sort_area_size=2097152 *.star_transformation_enabled='FALSE' *.timed_statistics=TRUE *.undo_management='AUTO' *.undo_retention=10800 *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/oracle/oradata/admin/Ora92/udump' *** TIA Jack
RE: ORA-27101 RH linux 9 Oracle 9.2.0.3
Title: Message 512Mb RAM 2Gb Swap space 10:44:37 up 2 days, 21:15, 4 users, load average: 0.00, 0.05, 0.03119 processes: 115 sleeping, 4 running, 0 zombie, 0 stoppedCPU states: 0.3% user 0.0% system 0.0% nice 0.0% iowait 99.6% idleMem: 513788k av, 506088k used, 7700k free, 0k shrd, 117192k buff 386908k actv, 39520k in_d, 9728k in_cSwap: 2097136k av, 22708k used, 2074428k free 257980k cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND15439 root 15 0 1164 1164 864 R 0.3 0.2 0:00 0 top 1 root 15 0 104 88 52 S 0.0 0.0 0:06 0 init 2 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 keventd 3 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kapmd 4 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd_CPU 9 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 bdflush 5 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kswapd 6 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kscand/DMA 7 root 15 0 0 0 0 SW 0.0 0.0 5:18 0 kscand/Normal 8 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kscand/HighMe 10 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kupdated 11 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd 15 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald ** Strange indeed. Jack Original Message-From: Suhen Pather [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:09 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3 Jack, ORA-27101: shared memory realm does not exist Oracle probably been aborted for some reason. Strangehow you can do a select * from v$database. How much memory and swap space you have configured. Regards Suhen -Original Message-From: Jack van Zanen [mailto:[EMAIL PROTECTED]Sent: Wednesday, 30 July 2003 6:44 PMTo: Multiple recipients of list ORACLE-LSubject: ORA-27101 RH linux 9 Oracle 9.2.0.3 Hi, I have above setup on my homebox. Every now and then I get Oracle error 27101, and have to restart the database. I can connect / as sysdba and select * from v$database though. Has anybody seen this happen before and may be able to help me with this.?? The only thing that I can see is a trace file (I don't know if this is from the same time as when the database stopped serving requests) from the archiver. There is nothing in the alert log whatsoever. Is it normal behaviour that logswitches are recorded to trace files?? I have stopped the archiver process to see if that makes the problem go away. * [EMAIL PROTECTED] bdump]$ ls alert_Ora92.log ora92_arc0_2583.trc ora92_arc0_2674.trc ora92_arc0_10031.trc ora92_arc0_2597.trc ora92_arc0_2710.trc ora92_arc0_10498.trc ora92_arc0_2629.trc ora92_arc0_2842.trc ora92_arc0_10533.trc ora92_arc0_2634.trc ora92_arc0_5115.trc ora92_arc0_10557.trc ora92_arc0_2651.trc ora92_arc0_8432.trc ora92_arc0_14874.trc ora92_arc0_2657.trc ora92_arc0_8607.trc [EMAIL PROTECTED] bdump]$ cat *14874* /oracle/oradata/admin/Ora92/bdump/ora92_arc0_14874.trc Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production ORACLE_HOME = /oracle/app/product/9.2.0 System name: Linux Node name: Linux Release: 2.4.20-18.9 Version: #1 Thu May 29 07:08:16 EDT 2003 Machine: i686 Instance name: Ora92 Redo thread mounted by this instance: 1 Oracle process number: 8 Unix process pid: 14874, image: [EMAIL PROTECTED] (ARC0) *** SESSION ID:(7.1) 2003-07-30 09:24:33.995 - Created archivelog as '/data/oradata/Ora92/archive/1_57.dbf' [EMAIL PROTECTED] bdump]$ df -k Filesystem 1K-blocks Used Available Use% Mounted on /dev/hdc2 10078852 7872268 1694596 83% / /dev/hdc1 99043 14310 79619 16% /boot none 256892 0 256892 0% /dev/shm /dev/hdc4 66542832 6880604 56282028 11% /data [EMAIL PROTECTED] bdump]$ ls -l /data//oradata/Ora92/archive/ total 8124 -rw-r- 1 oracle dba 452096 Jul 27 13:33 1_55.dbf -rw-r- 1 oracle dba 1085952 Jul 28 08:56 1_56.dbf -rw-r- 1 oracle dba 6752256 Jul 30 09:24 1_57.dbf [EMAIL PROTECTED] bdump]$ PARAMETER SETTINGS: *.background_dump_dest='/oracle/oradata/admin/Ora92/bdump' *.compatible='9.2.0.0.0' *.control_files='/oracle/oradata/Ora92/control01.ctl','/oracle/oradata/Ora92/control02.ctl','/oracle/oradata/Ora92/control03.ctl' *.core_dump_dest='/oracle/oradata/admin/Ora92/cdump' *.db_block_size=8192 *.db_cache_size=8388608 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='Ora92' *.fast_start_mttr_target=300 *.hash_join_enabled=TRUE *.instance_name='Ora92' *.java_pool_size=0 *.large_pool_size=8388608
RE: ORA-27101 RH linux 9 Oracle 9.2.0.3
Title: Message Hi, Have tried to reconnect and get the error message 27101 (when using @sid logon) ** [EMAIL PROTECTED] admin]# cd /proc/sys/kernel[EMAIL PROTECTED] kernel]# cat sem250 32000 100 128[EMAIL PROTECTED] kernel]# cat shmmax536870912[EMAIL PROTECTED] kernel]# cat shmmni4096[EMAIL PROTECTED] kernel]# cat shmall2097152[EMAIL PROTECTED] kernel]# ulimit -u4095[EMAIL PROTECTED] kernel]# cat /proc/sys/net/ipv4/ip_local_port_range1024 65000[EMAIL PROTECTED] kernel]# cat /proc/sys/fs/file-max65536[EMAIL PROTECTED] kernel]# Only difference is that I set my semaphores higher than recommended (cat sem, cat shmmax) Thx -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:39 PMTo: Multiple recipients of list ORACLE-LSubject: RES: ORA-27101 RH linux 9 Oracle 9.2.0.3 Have you tried to reconnect to the instance? Does the instance shuts down or your connection? Try changing the following parameters: Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris 2-20 Installation Guide Perform the following steps to modify the kernel parameters by using the /proc file system. 1. Log in as the root user. 2. Change to the /proc/sys/kernel directory. 3. Review the current semaphore parameter values in the sem file by using the cat or more utility. For example, using the cat utility, enter the following command: # cat sem The output lists, in order, the values for the SEMMSL, SEMMNS, SEMOPM, and SEMMNI parameters. The following example shows how the output appears: 250 32000 32 128 In the preceding output example, 250 is the value of the SEMMSL parameter, 32000 is the value of the SEMMNS parameter, 32 is the value of the SEMOPM parameter, and 128 is the value of the SEMMNI parameter. 4. Modify the parameter values by using the following command syntax: # echo SEMMSL_value SEMMNS_value SEMOPM_value SEMMNI_value sem Replace the parameter variables with the values for your system in the order that they are entered in the preceding example. For example: # echo 100 32000 100 100 sem 5. Review the current shared memory parameters by using the cat or more utility. For example, using the cat utility, enter the following command: # cat shared_memory_parameter In the preceding example, the variable shared_memory_parameter is either the SHMMAX or SHMMNI parameter. The parameter name must be entered in lowercase letters. 6. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMMAX parameter, enter the following command: # echo 2147483648 shmmax 7. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMMNI parameter, enter the following command: Setup Tasks to Perform as root User # echo 4096 shmmni 8. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMALL parameter, enter the following command: # echo 2097152 shmall 9. Write a script to initialize these values during system startup, and include the script in your system init files. 10. Set the File Handles by using ulimit -n and /proc/sys/fs/file-max. # echo 65536 /proc/sys/fs/file-max ulimit -n 65536 11. Set the Sockets to /proc/sys/net/ipv4/ip_local_port_range # echo 1024 65000 /proc/sys/net/ipv4/ip_local_port_change 12. Set the Process limit by using ulimit -u. This will give you the number of processes per user. ulimit -u 16384 The parameters in the following table are the minimum values required to run Oracle9i with a single-database instance on Linux. See Also: Your system vendor's documentation for more information on script files and init files. Sandro Augusto da SilvaTechnology Services SupportNLA Technology ServicesPhone: +55 11 3398-8438Fax: +55 11 3398-7522 -Mensagem original-De: Jack van Zanen [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 30 de julho de 2003 06:39Para: Multiple recipients of list ORACLE-LAssunto: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3 512Mb RAM 2Gb Swap space 10:44:37 up 2 days, 21:15, 4 users, load average: 0.00, 0.05, 0.03119 processes: 115 sleeping, 4 running, 0 zombie, 0 stoppedCPU states: 0.3% user 0.0% system 0.0% nice 0.0% iowait 99.6% idleMem: 513788k av, 506088k used, 7700k free, 0k shrd
RE: ORA-27101 RH linux 9 Oracle 9.2.0.3
Title: Message Damn your right, I need new glasses :-) Thx -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 3:14 PMTo: Multiple recipients of list ORACLE-LSubject: RES: ORA-27101 RH linux 9 Oracle 9.2.0.3 The parameter shmmax (Shared Memory) is lower than the sugested. Please check: Yours: 536870912 Sugested: 2147483648 Sandro Augusto da SilvaTechnology Services SupportNLA Technology ServicesPhone: +55 11 3398-8438Fax: +55 11 3398-7522 -Mensagem original-De: Jack van Zanen [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 30 de julho de 2003 09:59Para: Multiple recipients of list ORACLE-LAssunto: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3 Hi, Have tried to reconnect and get the error message 27101 (when using @sid logon) ** [EMAIL PROTECTED] admin]# cd /proc/sys/kernel[EMAIL PROTECTED] kernel]# cat sem250 32000 100 128[EMAIL PROTECTED] kernel]# cat shmmax536870912[EMAIL PROTECTED] kernel]# cat shmmni4096[EMAIL PROTECTED] kernel]# cat shmall2097152[EMAIL PROTECTED] kernel]# ulimit -u4095[EMAIL PROTECTED] kernel]# cat /proc/sys/net/ipv4/ip_local_port_range1024 65000[EMAIL PROTECTED] kernel]# cat /proc/sys/fs/file-max65536[EMAIL PROTECTED] kernel]# Only difference is that I set my semaphores higher than recommended (cat sem, cat shmmax) Thx -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:39 PMTo: Multiple recipients of list ORACLE-LSubject: RES: ORA-27101 RH linux 9 Oracle 9.2.0.3 Have you tried to reconnect to the instance? Does the instance shuts down or your connection? Try changing the following parameters: Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris 2-20 Installation Guide Perform the following steps to modify the kernel parameters by using the /proc file system. 1. Log in as the root user. 2. Change to the /proc/sys/kernel directory. 3. Review the current semaphore parameter values in the sem file by using the cat or more utility. For example, using the cat utility, enter the following command: # cat sem The output lists, in order, the values for the SEMMSL, SEMMNS, SEMOPM, and SEMMNI parameters. The following example shows how the output appears: 250 32000 32 128 In the preceding output example, 250 is the value of the SEMMSL parameter, 32000 is the value of the SEMMNS parameter, 32 is the value of the SEMOPM parameter, and 128 is the value of the SEMMNI parameter. 4. Modify the parameter values by using the following command syntax: # echo SEMMSL_value SEMMNS_value SEMOPM_value SEMMNI_value sem Replace the parameter variables with the values for your system in the order that they are entered in the preceding example. For example: # echo 100 32000 100 100 sem 5. Review the current shared memory parameters by using the cat or more utility. For example, using the cat utility, enter the following command: # cat shared_memory_parameter In the preceding example, the variable shared_memory_parameter is either the SHMMAX or SHMMNI parameter. The parameter name must be entered in lowercase letters. 6. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMMAX parameter, enter the following command: # echo 2147483648 shmmax 7. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMMNI parameter, enter the following command: Setup Tasks to Perform as root User # echo 4096 shmmni 8. Modify the shared memory parameter by using the echo utility. For example, to modify the SHMALL parameter, enter the following command: # echo 2097152 shmall 9. Write a script to initialize these values during system startup, and include the script in your system init files. 10. Set the File Handles by using ulimit -n and /proc/sys/fs/file-max. # echo 65536 /proc/sys/fs/file-max ulimit -n 65536 11. Set the Sockets to /proc/sys/net/ipv4/ip_local_port_range # echo 1024 65000 /proc/sys
RE: 8.1.7 instance on Solaris periodically goes sluggish, then ha
Plus if you are on 8.1.7.3 you have several bugs that can cause hangs w/o alert log messages. (check metalink) Jack -Original Message- Sent: Monday, July 28, 2003 4:04 PM To: Multiple recipients of list ORACLE-L hangs... run statspack and check your top 5 wait events. you have some kind of bottleneck flairing up. From: Paul Vincent [EMAIL PROTECTED] Date: 2003/07/28 Mon AM 09:39:30 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: 8.1.7 instance on Solaris periodically goes sluggish, then hangs... Hi, rather vague, this one, I'm afraid, but we're stumped for ideas. We have an Oracle 8.1.7 instance on a Sun Solaris setup, which we're currently testing prior to going live. Every so often - 2 or 3 times a week - the users phone to say the application has stopped responding. They're waiting several minutes with no response. We find we can usually fire up one or two tuning apps, such as TOAD or Quest's Spotlight, but within a few minutes, these also stop responding. By this time, even trying to fire up a SQL*Plus session from my PC just hangs and hangs, without the login ever completing. We always end up having to get the sysadmin to abort-shutdown Oracle and then restart it. After which everything's fine - until the next time. I've checked the PROCESSES parameter, and this is set to 150 - way above the maximum number of connections we've seen (around 40 or so). Likewise SESSIONS and TRANSACTIONS parameters seem generously adequate. The sysadmin says the server itself doesn't seem to be having any problems. He can log in and run UNIX commands with no apparent performance problems. Any ideas at all would be very welcome! Paul Vincent Oracle DBA University of Central England -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Vincent INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: Extproc setup Q?
Hi, Thought I had followed that but obviously not exact enough. Now it works. Thanx jack -Original Message- Sent: Thursday, July 24, 2003 6:09 PM To: Multiple recipients of list ORACLE-L Jack, This is a post from a few weeks ago that gives a setup TNSNAMES: extproc_connection_data.world = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = extproc_agent) --- Key1 ) (CONNECT_DATA = (SID = 11) --- Key2 (server=dedicated)) ) Listener: EXTPROC_LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = extproc_agent) Key1 ) ) SID_LIST_EXTPROC_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = 11) Key2 (ORACLE_HOME = /ora1/81764) (PROGRAM = extproc) ) ) BTW: Oracle's recommendation is to use a seperate listener for extproc calls. -Original Message- Sent: 24 July 2003 15:10 To: Multiple recipients of list ORACLE-L http://www.quantsystems.nl/ Tried that still the same error message. Any other hints tips for me to try? Just curious though ,why is it DLLS if I'm working on LINUX Jack -Original Message- Sent: Thursday, July 24, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Please add the line in red to your listener.ora file. Extproc has been made secure in Oracle 9i. The following line has to be added to execute your own external procedures. LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = plsextproc) (ORACLE_HOME = /oracle/app/product/9.2.0) (PROGRAM = extproc) (ENVS=EXTPROC_DLLS=ANY) ) (SID_DESC = (GLOBAL_DBNAME = Ora92) (ORACLE_HOME = /oracle/app/product/9.2.0) (SID_NAME = ora92) ) ) Regards Munish Bajaj -Original Message- Sent: Thursday, July 24, 2003 16:24 To: Multiple recipients of list ORACLE-L Hi All, I am trying to setup EXTPROC but keep getting ORA-28575 (Check your tnsnames.ora listener.ora) Attached are my files that look OK to me Anybody?? [EMAIL PROTECTED] admin]$ cat tnsnames.ora # TNSNAMES.ORA Network Configuration File: /oracle/app/product/9.2.0/network/admin/tnsnames.ora ORA92 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = Ora92) ) ) extproc_connection_data = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent)) (CONNECT_DATA = (SID = plsextproc)) ) ) [EMAIL PROTECTED] admin]$ cat listener.ora # LISTENER.ORA Network Configuration File: /oracle/app/product/9.2.0/network/admin/listener.ora LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = plsextproc) (ORACLE_HOME = /oracle/app/product/9.2.0) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = Ora92) (ORACLE_HOME = /oracle/app/product/9.2.0) (SID_NAME = ora92) ) ) TIA Jack van Zanen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev 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: Jack van Zanen 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 9i refuses to allow client connection -- I need some h
Title: Message What is the error message (if any) Can you connect thru SQL*Plus (/ as sysdba) -Original Message-From: Wolfe Stephen S GS-11 6 MDSS/SGSI [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle 9i refuses to allow client connection -- I need some help. I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974
Extproc setup Q?
Title: Extproc setup Q? Hi All, I am trying to setup EXTPROC but keep getting ORA-28575 (Check your tnsnames.ora listener.ora) Attached are my files that look OK to me Anybody?? [EMAIL PROTECTED] admin]$ cat tnsnames.ora # TNSNAMES.ORA Network Configuration File: /oracle/app/product/9.2.0/network/admin/tnsnames.ora ORA92 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = Ora92) ) ) extproc_connection_data = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent)) (CONNECT_DATA = (SID = plsextproc)) ) ) [EMAIL PROTECTED] admin]$ cat listener.ora # LISTENER.ORA Network Configuration File: /oracle/app/product/9.2.0/network/admin/listener.ora LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = plsextproc) (ORACLE_HOME = /oracle/app/product/9.2.0) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = Ora92) (ORACLE_HOME = /oracle/app/product/9.2.0) (SID_NAME = ora92) ) ) TIA Jack van Zanen
RE: Extproc setup Q?
Title: Message Tried that still the same error message. Any other hints tips for me to try? Just curious though ,why is it DLLS if I'm working on LINUX Jack -Original Message- From: Munish Bajaj [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2003 2:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Extproc setup Q? Please add the line in red to your listener.ora file. Extproc has been made secure in Oracle 9i. The following line has to be added to execute your own external procedures. LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = plsextproc) (ORACLE_HOME = /oracle/app/product/9.2.0) (PROGRAM = extproc) (ENVS="EXTPROC_DLLS=ANY") ) (SID_DESC = (GLOBAL_DBNAME = Ora92) (ORACLE_HOME = /oracle/app/product/9.2.0) (SID_NAME = ora92) ) ) Regards Munish Bajaj -Original Message-From: Jack van Zanen [mailto:[EMAIL PROTECTED]Sent: Thursday, July 24, 2003 16:24To: Multiple recipients of list ORACLE-LSubject: Extproc setup Q? Hi All, I am trying to setup EXTPROC but keep getting ORA-28575 (Check your tnsnames.ora listener.ora) Attached are my files that look OK to me Anybody?? [EMAIL PROTECTED] admin]$ cat tnsnames.ora # TNSNAMES.ORA Network Configuration File: /oracle/app/product/9.2.0/network/admin/tnsnames.ora ORA92 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = Ora92) ) ) extproc_connection_data = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent)) (CONNECT_DATA = (SID = plsextproc)) ) ) [EMAIL PROTECTED] admin]$ cat listener.ora # LISTENER.ORA Network Configuration File: /oracle/app/product/9.2.0/network/admin/listener.ora LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = plsextproc) (ORACLE_HOME = /oracle/app/product/9.2.0) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = Ora92) (ORACLE_HOME = /oracle/app/product/9.2.0) (SID_NAME = ora92) ) ) TIA Jack van Zanen
RE: How to make SPFILE in sync with INIT.ORA ?
') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Molina, Gerardo 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Molina, Gerardo 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: Multiple addreses in tns
I think this is used in Parallel server environments. I have seen something similar (maybe not exactly) so it could well be valid. My understanding is that it should be working it's way down the list or pick a random address depending on (not much experience with OPS/RAC) Jack -Original Message- Sent: Thursday, July 10, 2003 4:19 PM To: Multiple recipients of list ORACLE-L Is having multiple addresses valid for a tns entry? A client provided this to me and initailly looked invalid alias = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1526)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1526)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1526)) ) (CONNECT_DATA = (SID = name)(SERVER = DEDICATED)) ) From initial testing, if the first server is not avaliable the entire connect fails. Personally Ive never seen this and from checking my reference, this does NOT seem to be valid Any input would be most welcome 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: Sybase to Oracle
Title: Message Not Sure, but isn't that what transparent gateways form oracle are for? Build an interface using something like sqr or something -Original Message-From: Jay Krishnan R [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 12:39 PMTo: Multiple recipients of list ORACLE-LSubject: Sybase to OracleDear All I have a small doubt regarding Sybase-Oracle data transfer. Is it possible to transfer data online from Sybase to Oracle. Any info on the same would be highly appreciated. Thanks in advance. Best RegardsJay
RE: Oracle 9 on redhat 9...kernal settings
Hi Jared, I ventured into my first red hat install not to long ago, but these parameters do do need a kernel rebuild (afaik) Jack -Original Message- Sent: Thursday, July 03, 2003 7:21 PM To: Multiple recipients of list ORACLE-L Unless you've run into errors requiring adjustment of these parameters, don't bother with them. I've run 4 databases on a 2Gig RAM RH 7.1 box without ever touching these. Modifying them requires rebuilding the kernel, which can be quite a hassle. It also invalidates Oracle support on linux. Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 01:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle 9 on redhat 9...kernal settings I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- 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). -- 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: Jack van Zanen 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 9 on redhat 9...kernal settings
Hi Jared, The link I send earlier this thread explains in detail how to set this Happy Holidays Jacob A. van Zanen -Original Message- Sent: Friday, July 04, 2003 7:39 PM To: Multiple recipients of list ORACLE-L Nice. I haven't even looked at setting these parms in linux in a couple years, didn't know this was available. So, how do you set SHMMAX, etc on linux using sysctl? The man pages weren't much help. Jared On Friday 04 July 2003 03:24, Markus Reger wrote: standard kernel : no rebuild. just use sysctl -p after writing yr preeferred settings into /etc/sysctl.conf for advanced linux guys: they can be set directly - but the previous way is more convinient. in case you don't set them yr installation might hnag when creating the database instance. in this case just install the database later. means start dbassiost fter setting the kernel params. doesn't need a complete re-install. kr [EMAIL PROTECTED] 07/04/03 10:34 AM Hi Jared, I ventured into my first red hat install not to long ago, but these parameters do do need a kernel rebuild (afaik) Jack -Original Message- Sent: Thursday, July 03, 2003 7:21 PM To: Multiple recipients of list ORACLE-L Unless you've run into errors requiring adjustment of these parameters, don't bother with them. I've run 4 databases on a 2Gig RAM RH 7.1 box without ever touching these. Modifying them requires rebuilding the kernel, which can be quite a hassle. It also invalidates Oracle support on linux. Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 01:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle 9 on redhat 9...kernal settings I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Jack van Zanen 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 9 on redhat 9...kernal settings
http://codah.net/install-oracle9iR2-on-redhat9.html -Original Message- Sent: Friday, July 04, 2003 7:39 PM To: Multiple recipients of list ORACLE-L Nice. I haven't even looked at setting these parms in linux in a couple years, didn't know this was available. So, how do you set SHMMAX, etc on linux using sysctl? The man pages weren't much help. Jared On Friday 04 July 2003 03:24, Markus Reger wrote: standard kernel : no rebuild. just use sysctl -p after writing yr preeferred settings into /etc/sysctl.conf for advanced linux guys: they can be set directly - but the previous way is more convinient. in case you don't set them yr installation might hnag when creating the database instance. in this case just install the database later. means start dbassiost fter setting the kernel params. doesn't need a complete re-install. kr [EMAIL PROTECTED] 07/04/03 10:34 AM Hi Jared, I ventured into my first red hat install not to long ago, but these parameters do do need a kernel rebuild (afaik) Jack -Original Message- Sent: Thursday, July 03, 2003 7:21 PM To: Multiple recipients of list ORACLE-L Unless you've run into errors requiring adjustment of these parameters, don't bother with them. I've run 4 databases on a 2Gig RAM RH 7.1 box without ever touching these. Modifying them requires rebuilding the kernel, which can be quite a hassle. It also invalidates Oracle support on linux. Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 01:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle 9 on redhat 9...kernal settings I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Jack van Zanen 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 9 on redhat 9...kernal settings
Follow this link and it will work (did for me and a friend of mine and we have 512Mb memory also) http://codah.net/install-oracle9iR2-on-redhat9.html Jack -Original Message- Sent: Thursday, July 03, 2003 10:54 AM To: Multiple recipients of list ORACLE-L I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: SQL need help
select 'CustomerNo '||a.custno||' Total Order for this month = '||nvl(c.totalorder,0) from all_customer a, (SELECT b.custno as custno, sum(b.totalorder) as totalorder from orders b group by b.custno,to_char(b.dateorder,'mm') having to_char(b.dateorder,'mm')='06') c where c.custno(+)=a.custno Jack -Original Message- Sent: Thursday, July 03, 2003 11:06 AM To: Multiple recipients of list ORACLE-L Hi, I have two tables 1. ALL_CUSTOMER CustNo: 1 to 100 OtherDetail: bla bla bla 2. ORDER CustNo TotalOrder DateOrder I want to display like this CustomerNo 1Total Order For This month = 101 or CustomerNo 1 Total Order For This month = 0 My SQL statement is like this SELECT a.custno, sum(b.total_order) from all_customer a, order b where b.custno (+) = a.custno and to_char(dateorder, 'month') = 'JUNE' (PROBLEM is HERE) group by a.custno When I run this statement for those customer that never order anything, my statement return No row returns How to get something like this CustomerNo 1 Total Order For This month = 0 I tried this nvl(to_char(dateorder, 'month'), 'JUNE') = 'JUNE' Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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: Jack van Zanen 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: Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K
I have a few databases in Home0 and a few in Home1 and need to move one from Home0 to Home1 So if I understand correct I can do: Oradim -delete -sid SID Remove the entries that look like ORA_SID_AUTOSTART ORA_SID_SHUTDOWN ORA_SID_SHUTDOWNTYPE ORA_SID_SHUTDOWN_TIMEOUT From Home0(if not done by oradim) Put the initSID.ora file in the new home location Create a new service NEW_HOME\bin\oradim.exe -new -sid SID -startmode m NEW_HOME\bin\oradim.exe -edit -sid SID -startmode a NEW_HOME\bin\orapwd.exe file=d:\oracle\ora90\database\PWDSID.ora password=password (Or can I just copy the password file?) Change the listener.ora Start the database Run catalog/catproc/catexp etc Is this Correct??? TIA Jack -Original Message- Sent: Tuesday, July 01, 2003 11:07 PM To: Multiple recipients of list ORACLE-L Assuming that you are changing the second Oracle Home, ie. Home1. Change the following entries in the registry: HKLM\Software\Oracle\ALL_HOMES\ID1\PATH HKLM\Software\Oracle\HOME1\ORACLE_HOME Depending on how you've located init and dump files, etc., you may see other entries in HKLM\Software\Oracle\HOME1 that need to be changed as well. You then need to remove and re-create the service. oradim -delete -sid SID oradim -new -sid SID -pfile path to init.ora type oradmin on a command line to get all options. Then check HKLM\System\CurrentControlSet\Services\OracleServiceSID to ensure that the correct binary is in use. Edit your tnsnames.ora/names registry or whatever you use for name resolution. That should about do it. Jared Jack van Zanen [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/01/2003 08:55 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K Hi All, We have a test machine with both the 81730 and 81741 software in their own oracle homes. We now want to move a database from the 81730 home to 81741 I know I have to run the catalog.sql, catproc.sql from the new home etc... But how do I tell the registry that the database moved homes?? TiA Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: [EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -- 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: Jack van Zanen 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).
Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K
Title: Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K Hi All, We have a test machine with both the 81730 and 81741 software in their own oracle homes. We now want to move a database from the 81730 home to 81741 I know I have to run the catalog.sql, catproc.sql from the new home etc... But how do I tell the registry that the database moved homes?? TiA Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: [EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/
RE: Help Needed regarding partitioning
Hi, I'm currently looking into the same. My idea is to create a new table with the partitions I need, insert the data from the old table, drop the old table and rename the new table to the old name. This will invalidate a lot of stuff, which I still have to find out exactly what, so if somebody has a script to find all the dependencies already.? Anybody have a different/better idea, because the insert may take a long time? Jack -Original Message-From: Munish Bajaj [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 11:54 AMTo: Multiple recipients of list ORACLE-LSubject: Help Needed regarding partitioning Hi Listers, Please let me know whether I can convert an existing heavy table into a partitioned table and how? I need this to improve my query performance. Thanks and Best Regards Munish Bajaj
RE: Help Needed regarding partitioning
Thanks for mentioning it Just tried a little test and worked like a charm. alter table part2 exchange partition JUNE2003 with table test_part1 Jacob A. van Zanen -Original Message- Sent: Wednesday, June 25, 2003 4:14 PM To: Multiple recipients of list ORACLE-L Jack, Munish First, verify that you have licensed partitioning. Additional cost item. Second, learn about EXCHANGE PARTITION. This is a highly useful command that can be used for a multitude of uses. Create a partitioned table and then exchange your table into it. Extremely fast since it just involves dictionary manipulations. It can be used for other purposes like renaming columns, changing the owner of a table, etc. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 25, 2003 6:15 AM To: Multiple recipients of list ORACLE-L Hi, I'm currently looking into the same. My idea is to create a new table with the partitions I need, insert the data from the old table, drop the old table and rename the new table to the old name. This will invalidate a lot of stuff, which I still have to find out exactly what, so if somebody has a script to find all the dependencies already.? Anybody have a different/better idea, because the insert may take a long time? Jack -Original Message- Sent: Wednesday, June 25, 2003 11:54 AM To: Multiple recipients of list ORACLE-L Hi Listers, Please let me know whether I can convert an existing heavy table into a partitioned table and how? I need this to improve my query performance. Thanks and Best Regards Munish Bajaj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jack van Zanen 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 7.3.4 on Win2000
Title: Message My understanding is that it will install and work but Oracle 7 wants to be the first Oracle Home installed on the machine if my memory does not let me down. I once installed 7.3.4 on my laptop after I had installed 8 8i. This required some registry hacking to get it to work properly. Jack -Original Message-From: Smith, Ron L. [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 10:00 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle 7.3.4 on Win2000 I need to load SQL Loader 7.3.4 on a Win2000 server. All I have is ORacle 7.3.4 for NT. Does anyone know if it will load and run ok without messing up something? Is there a CD for 7.3.4 on Win2000? Thanks! Ron If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
RE: Oracle on Linux
Hi, I just installed RH9 and Oracle 9i R2 on my home PC and it installs fine if you follow the instructions in the following URL http://codah.net/install-oracle9iR2-on-redhat9.html (was my first venture into RH also) I choose the server version. Mind you Oracle is only certified on RH AS/ES 2.1 Jack -Original Message- Sent: Monday, June 23, 2003 12:55 PM To: Multiple recipients of list ORACLE-L OK, I am about to venture into the world of Red Hat Linuxand then install Oracle on it. I have a question re the Linux install options. Do I need to do a Server installation (as opposed to a Personal Desktop installation or a Workstation installation), to be able to later install Oracle 9? 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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).
OT: SQL Server Q?
Title: OT: SQL Server Q? Hi All I'm mainly into Oracle but in a SQLserver database we encountered this error maximum number of DBPROCESSes already exist In oracle I would look at the processes parameter but what would I be looking at in SQL server??? TIA Jacob A. van Zanen
Partitions of table read only
Title: Partitions of table read only Hi, I would like to know if it is possible and what the pitfalls are if I do the following. Partition a large table into partitions based on date. Data is only entered and read and never altered, so I would like to move older partitions to read only tablespaces and possible read only devices so the backup will be made quicker. Is it possible to have parttions of the same table spread across read only and read/write tablespaces? Am I correct in assuming that once you backup a read only tablespace there is no need to backup the same again. (provided you don't make it read/write add data and make it read only again).? Does anybody have a procedure already that automatically creates the new partitions let say every month? TIA Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: [EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/
RE: recreating a create database file
Maybe not exactly what you are looking for, but Start the GUI DBCA (NO don't shoot), go through the all the motions and at the end choose generate scripts only. Jack -Original Message- Sent: Tuesday, June 17, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a script or trick or something to recreate these files? I could recreate them manually but I am somewhat of a time crunch. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini 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: Jack van Zanen 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 Service on Win2k
Maybe the obvious But Is the registry key ORA_SID_AUTOSTART set to true?? Jack -Original Message- Sent: Friday, June 06, 2003 1:29 PM To: Multiple recipients of list ORACLE-L Hi list On Oracle 9.2.0.3.0 (patched from 9.2.0.1.0 ): When i start JUST the service OracleServiceSID, most of the times, the database will also be mounted and opened ! Doesn't matter wether I start the service via gui or via net start OracleServiceSID or oradim -STARTUP -SID SID -USRPWD PWD -STARTTYPE srvc, the database will be opened right away. I definitely don't want that. That sh%%($t can sc%$/w up my instance. Does anybody encounter the same problems ? Couldn't find anything relevant on metaling, though. Help, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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: Jack van Zanen 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).
Upgrade 8.1.7.0 to 8.1.7.4.x Tru64 Parallel Server
Hi All, I have my first upgrade of parallel server coming up and am wondering what the major differences are between a normal upgrade and this one. Am I correct in assuming that the installer will detect both nodes and install the upgrade on both nodes? Is it correct that I only need to run the datadictionary upgrade script once on one of the instances? I'm now off to find more info on this on Metlink as well, but if someone has done this already and could share the steps involved I'd be thankful. TIA Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: mailto:[EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: buffer busy due to global cache/more...
Hi This client has Oracle 8.1.7 OPS with 2 nodes. Every now and then sessions hang with this event being the only one that accumulates more time. How long can this downgrade/upgrade take? There is a bug in 8.1.7 related to this? Has anybody experienced it (Bug 1916409) and how can be proven w/o a doubt that this is customers problem? I will open a TAR on this as well to get input from WWS as well. -Original Message- Sent: woensdag 19 maart 2003 21:02 To: Multiple recipients of list ORACLE-L Because the instance locks are now called Global Cache Services .. ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 7:59 PM This can also happen during creating a consisten version of the block with cache fusion enabled. -Original Message- Sent: Wednesday, March 19, 2003 11:09 AM To: Multiple recipients of list ORACLE-L An instance lock that protects a buffer is being downgraded or upgrade, while that is in process the buffer can't be accessed so sessions have to wait on this event. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 3:38 PM Jack I did a quick search on Google and this seems to be related to using RAC. Do you have that implemented? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 19, 2003 8:14 AM To: Multiple recipients of list ORACLE-L Hi All, Anybody knows what this wait event is casued by?? TIA Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: mailto:[EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Anjo Kolk 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjo Kolk 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
buffer busy due to global cache
Hi All, Anybody knows what this wait event is casued by?? TIA Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: mailto:[EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: Backup Strategy
Good one. :-) Jack -Original Message- Sent: maandag 17 maart 2003 11:29 To: Multiple recipients of list ORACLE-L So what are you doing this afternoon after you have mastered the SQL Server gui this morning? -Original Message- Sent: 15 March 2003 09:44 To: Multiple recipients of list ORACLE-L I put them on http://www.vanzanen.com/rman.zip They are oracle 8.0 (if memory serves me right) so they won't work with 9i. I'll see if I can find the time to do the same for 9i one of these days (have to learn SQL Server first) Jack -Original Message- Sent: vrijdag 14 maart 2003 20:24 To: Multiple recipients of list ORACLE-L I have found Joe Testa's site has a good set of RMAN scripts (I think they came from Jack van Zanen off this list), quite simple but they give the syntax for most of the commands you will want The link was http://www.oracle-dba.com but that is no longer working Where have you put them Joe?? John -Original Message- Sent: 14 March 2003 16:34 To: Multiple recipients of list ORACLE-L Jay If you want a good book to get up to speed on RMAN, buy Oracle9i RMAN Backup Recovery by Robert Freeman and Matthew Hart If you want to compare the steps for various recovery scenarios between RMAN and user-managed recovery, get Oracle Backup Recovery 101 by Smith and Haisley. It has you create a small test database and then run various backup and recovery steps for various types of failures and recoveries. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 14, 2003 2:54 AM To: Multiple recipients of list ORACLE-L Dear All, Iam entitled the responsibility to come out with a plan for Backup (using RMAN) for our forthcoming data centre operations. Could someone help me on this? I would also like to know the steps for Recovery in the case of a Redo Log member failure, using RMAN and the traditional Recovery commands from SQLPLUS. TIA . Best Regards Jai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hallas, John, Tech Dev 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: Jack van Zanen 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: Hallas, John, Tech Dev 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: Jack van Zanen 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
RE: Backup Strategy
I put them on http://www.vanzanen.com/rman.zip They are oracle 8.0 (if memory serves me right) so they won't work with 9i. I'll see if I can find the time to do the same for 9i one of these days (have to learn SQL Server first) Jack -Original Message- Sent: vrijdag 14 maart 2003 20:24 To: Multiple recipients of list ORACLE-L I have found Joe Testa's site has a good set of RMAN scripts (I think they came from Jack van Zanen off this list), quite simple but they give the syntax for most of the commands you will want The link was http://www.oracle-dba.com but that is no longer working Where have you put them Joe?? John -Original Message- Sent: 14 March 2003 16:34 To: Multiple recipients of list ORACLE-L Jay If you want a good book to get up to speed on RMAN, buy Oracle9i RMAN Backup Recovery by Robert Freeman and Matthew Hart If you want to compare the steps for various recovery scenarios between RMAN and user-managed recovery, get Oracle Backup Recovery 101 by Smith and Haisley. It has you create a small test database and then run various backup and recovery steps for various types of failures and recoveries. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 14, 2003 2:54 AM To: Multiple recipients of list ORACLE-L Dear All, Iam entitled the responsibility to come out with a plan for Backup (using RMAN) for our forthcoming data centre operations. Could someone help me on this? I would also like to know the steps for Recovery in the case of a Redo Log member failure, using RMAN and the traditional Recovery commands from SQLPLUS. TIA . Best Regards Jai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hallas, John, Tech Dev 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: Jack van Zanen 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: Backup Strategy
1. I suggest U buy the book on RMAN by I believe O'Reilly Backup Recovery by Rama Velpuri 2. Come up with a list of all possible failures/crashes 3. Document a recovery scenario for all points 4. TEST Them. Redo log member failure. How do you see that?? It should be OK because it is just a member of a group so you have at least one more that is OK. Jack -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: vrijdag 14 maart 2003 9:54To: Multiple recipients of list ORACLE-LSubject: Backup StrategyDear All, Iam entitled the responsibility to come out with a plan for Backup (using RMAN) for our forthcoming data centre operations. Could someone help me on this? I would also like to know the steps for Recovery in the case of a Redo Log member failure, using RMAN and the traditional Recovery commands from SQLPLUS. TIA . Best RegardsJai
RE: Perl Book
I have heard some raving reviews for the book Perl for Oracle DBAs By AndyDuncan,JaredStillAugust 2002 0-596-00210-6, Order Number: 2106 [Jack van Zanen] -Original Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]Sent: donderdag 13 maart 2003 15:04To: Multiple recipients of list ORACLE-LSubject: OTC: Perl Book Looks like I have a need write a Perl program to access a database. Any suggestions on a good book. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: Excessive SQL*Net message from client waits
anything in the trace data that would lead you to suggest anything (init.ora parameter changes for example)? I've tried everything I can think of and am at wits end but still have a screaming client who's highly upset with the excessive response times. And one last thing which is kinda relatedwe changed the optimizer_index_cost_adj and optimizer_index_caching parameters from their defaults to 50 (both of them) and saw in our testing that it did make significant improvements in some cases (the trace profile I've shown you doesn't really have examples of this). But...since the client didn't want to bounce the database, we attempted to make these changes temporarily in a logon trigger by using execute immediate to do alter session commands to set the parameters per session logon. It seemed to work wonderfully but one application (one out of four) started hanging on startup right after we put in the trigger. When the trigger was dropped, the application was OK again. What the heck is up with that? I've never seen anything like that and can't for the life of me figure out what the app could be doing that a logon trigger would cause to freak out. Any ideas on that one? Many thanks in advance for your assistance, Karen PS If you could send me direct replies to this post at [EMAIL PROTECTED] as well as replying to the list I'd appreciate it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karen Morton 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: Jack van Zanen 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: DB Cloning from 8.1.6 to 9.0.1 ?
Hi (B (BI think I did try this with 8.0.5 to 8.1.7 and remember it worked OK. You (Bwill have to upgrade the database afterwards. (BJust try on test and see if it bites. (B (B (BJack (B-Original Message- (BSent: donderdag 13 maart 2003 3:19 (BTo: Multiple recipients of list ORACLE-L (B (B (BGuys, (B (Bi cloned ORADB1 on 8.1.6.0/win2k to ORADB2 (8.1.6.0/win2k) on another (Bmachine. (Bcan i do the same from (BORADB1 on 8.1.6.0/win2k to ORADB2 (9.0.1./win2k) on another machine. (Bis this possible ? (B (BTIA. (BJp. (B (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Prem Khanna J (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing). (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Jack van Zanen (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing).
RE: Running multiple instances on a [large] server
I have run/am running multiple oracle databases on a single server on AIX/Linux/W2K/NT although not with sga's in the GB area.Just make sure you get away with your I/O requirements We only had seperate homes for seperate oracle versions, so all 817 databases were in one home and 8.0.5 databases were grouped in one home etc.etc. I did not have to deal with licensing so can't give you a comment there. -Original Message- Sent: dinsdag 11 maart 2003 9:49 To: Multiple recipients of list ORACLE-L One of the teams here is planning to run anything from 8 to 16 database instances [no indication on sizing yet, but gut-feel SGAs are 200MB to 1GB and DB sizes 500MB to 40GB] on a large server, something like a Sun E6800 or an equivalent HP or Fujitsu server. 1. How many of you do run, and are comfortable running, multiple databases on the same server, whether it is partitioned or not ? 2. Do you create a seperate ORACLE_HOME for each instance ? 3. Do you just buy the Oracle DB CPU license on the total number of CPUs on the server ? My positioning is a. We might not be able to create 8 partitions but partition such that we have a max of 2 or 3 instances in one partition. Hopefully, I can dynamically change CPU partitioning to reallocate CPU to another group of instances. b. Each instance should have it's own ORACLE_HOME. [Disk space is not a constraint]. c. Just add up the number of CPUs on the server, across all partitions, and buy a CPU license. Also, a CPU license is much preferable to Named-User as some of these databases would host Portals for 1,000+ end-users. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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: Jack van Zanen 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: Slow query
two functions versus one maybe -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: woensdag 5 maart 2003 7:34To: Multiple recipients of list ORACLE-LSubject: Slow queryDear all, Please find below the 2 queries : select dep_date from test_date1 where to_char(dep_date,'dd-mon-') = '12-jan-2002' select dep_date from test_date1 where TRUNC(dep_date) = to_DATE( '12-jan-2002','dd-mon-') The execution plan for both the queries shows a FTS on test_date1. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'TEST_DATE1' The number of rows to be retrieved are 120010. The first query took 10msec to execute whereas the second took about 2 secs. Could anyone help me figure out what the problem would be. TIA Best RegardsJai
Oracle 9i RAC on Windows using firewire
Hi We are not a Unix shop and would like to build a test setup of 9iRAC on windows at the cheapest price. I have a document that explains how to do it using SCSI disks but the parts here are very expensive. I have heard that it is also possible to use firewire disks to achieve the same. Does anybody have a document detailing this setup? Technet mentions this only for LINUX and not for Windowz TIA Jacob A. van Zanen Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: Access Internet Web pages from SQL or PL/SQL
Works for me. -Original Message-From: Santosh Varma [mailto:[EMAIL PROTECTED]Sent: woensdag 5 maart 2003 13:05To: Multiple recipients of list ORACLE-LSubject: Access Internet Web pages from SQL or PL/SQL i am getting the following error when i give the select statement.. what could be the reason ? SQL select utl_http.request('http://www.orafaq.net/') from dual;select utl_http.request('http://www.orafaq.net/') from dual *ERROR at line 1:ORA-06510: PL/SQL: unhandled user-defined exceptionORA-06512: at "SYS.UTL_HTTP", line 174ORA-06512: at line 1 Thanks and Regards, Santosh Varma
RE: Oracle 9i RAC on Windows using firewire
Hi Mark, Yes They did not have the expertise for firewire at the time (and still don't). I'll figue it out somehow and inform him when it works. Cheers Jack -Original Message- Sent: woensdag 5 maart 2003 15:51 To: Multiple recipients of list ORACLE-L Jack, Have you had a chat with Tom to see if they have upgraded the current $1000 RAC paper for windows? I think it was mentioned in the paper that they planned to.. Mark -Original Message- Sent: 05 March 2003 14:06 To: Multiple recipients of list ORACLE-L Jack, www.tusc.com has a white paper that created a RAC with firewire and RedHat8.0 /w kernell upgrade for under $1500.00. Authored by M.Ault and presented at the SEOUG Conference last month. Ron [EMAIL PROTECTED] 03/05/03 06:34AM Hi We are not a Unix shop and would like to build a test setup of 9iRAC on windows at the cheapest price. I have a document that explains how to do it using SCSI disks but the parts here are very expensive. I have heard that it is also possible to use firewire disks to achieve the same. Does anybody have a document detailing this setup? Technet mentions this only for LINUX and not for Windowz TIA Jacob A. van Zanen Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: Ron Rogers 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: Mark Leith 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: Jack van Zanen 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: Duplicate online Database
Use the Rman duplicate command Example test script for Oracle 8i: sqlplus /nolog EOFconnect sys/oracledba as sysdbashutdown abortstartup nomountexitEOFrm /data/oracle8/TEST3/*rman EOFconnect target rman/[EMAIL PROTECTED]connect catalog rman/[EMAIL PROTECTED]connect auxiliary sys/[EMAIL PROTECTED]run {resync catalog;allocate auxiliary channel d1 type disk;allocate auxiliary channel d2 type disk;# set until time "to_date('2002-01-29:15:16:53','-mm-dd:hh24:mi:ss')"# set until time "to_date('30-JAN-2002 10:50:00','dd-mon- HH24:MI:SS')"# set until time '31-JAN-2002 10:51:00'# set until time 'sysdate-1/96';# set until scn = 155534set newname for datafile '/data/oracle8/TEST2/systemTEST2.dbf' TO '/data/oracle8/TEST3/systemTEST3.dbf';set newname for datafile '/data/oracle8/TEST2/rbsTEST2.dbf' TO '/data/oracle8/TEST3/rbsTEST3.dbf';set newname for datafile '/data/oracle8/TEST2/tempTEST2.dbf' TO '/data/oracle8/TEST3/tempTEST3.dbf';set newname for datafile '/data/oracle8/TEST2/dataTEST2.dbf' TO '/data/oracle8/TEST3/dataTEST3.dbf';sql 'alter system switch logfile';duplicate target database to test3LOGFILE'/data/oracle8/TEST3/redoTEST301.log' size 1M,'/data/oracle8/TEST3/redoTEST302.log' size 1M,'/data/oracle8/TEST3/redoTEST303.log' size 1M;}EOF -Original Message-From: Edouard Dormidontov [mailto:[EMAIL PROTECTED]Sent: dinsdag 4 maart 2003 11:39To: Multiple recipients of list ORACLE-LSubject: Duplicate online Database I need to duplicate online database Oracle 8.1.7. It is not possible to shutdown the primary database. Can I do online backup this primary database by RMAN, and + using archivelogs create duplicate database? Inconsistent backups of RMAN + archivelogs = duplicate database?? Thanks Edouard Dormidontov
RE: Upgrade to AIX 5.2
If you can get away with export import (no huge databases), I'd go for the second option. 1. Saver 2. Not all apps need to be upgraded to oracle 9i database 3. More breathing time when murphy strikes Jack -Original Message-From: Gene Sais [mailto:[EMAIL PROTECTED]Sent: vrijdag 28 februari 2003 15:04To: Multiple recipients of list ORACLE-LSubject: RE: Upgrade to AIX 5.2 So it appears that Oracle 8.1.7 databases and 9.2 databases can not co-exist on the same server, i.e. AIX 4.3.3 32 bit. If this is the case, then all databases on the server must be upgraded at the same time? Current Env: AIX 4.3.3 32 bit Oracle 8.1.7 Proposed Env: AIX 5.2 64 bit Oracle 9.2 Plan to get there: - Boot AIX 4.3.3 server to 64 bit - Install Oracle 9.2 64 bit Patch for AIX 4.3.3 - Change env scripts to point to Oracle 9.2 - Migrate/upgrade all databases from 8.1.7 to 9.2 - Upgrade AIX to 5.2 - Install Oracle 9.2 64 bit binaries Then there is the alternate plan: - Free up a server - Upgrade AIX 4.3.3 to 5.2 64 bit on this new server - Install Oracle 9.2 64 bit - Export 8.1.7 database and import to new 9.2 database - Continue this process on a per database basis, no rush to do all databases on server Any thoughts, experiences, opinions are appreciated. Thanks, Gene [EMAIL PROTECTED] 02/27/03 03:19PM Tracy,We are still debating this issue with our preferred App Vendor... Since there is no 64-bit 8.1.7.4 on AIX 5L, upgrading to 9i is what we will pursue. Testing the Vendor App on 9i/AIX 4.3.3 should not take considerable amount of time, as *none* of the new features of 9i would be used by the Vendor. Sad but true. There will be more testing time allocated to 9i/AIX 5L update, as several other software pieces would be tested for the first time with that combination. We will need to install 9i for AIX 5L after the OS upgrade. We may choose to install it in the same ORACLE_HOME as before. These are just my initial thoughts, no concrete plans, yet. If Oracle would have supported 64-bit 8.1.7.4 on AIX 5L, this would have been a bit simpler... Regards,- Kirti -Original Message-Sent: Thursday, February 27, 2003 1:36 PMTo: Multiple recipients of list ORACLE-LJohn/Kirti,We are in the same boat with you. However, we were looking to first upgrade toAIX 5L first and leave our existing 8.1.7 32-bit databases (booting the serverin 32 bit mode). In a subsequent phase we would upgrade 8.1.7 32-bit to 9.264-bit. The downside to this is that it will affect all databases on theserver. We would need to test the complexity/timing/risk to determine if thisis the appropriate choice. Kirti, with the option that you are leaningtowards, as I see it, you need to upgrade to 5L and then install 9.2 for 5L(there is also a 9.2 for 4.3.3) and then migrate the databases from 9.2/4.3.3to 9.2/5L. Do you know what effort is involved in that transition? Is itcomplex/time consuming or just pointing to a new oracle_home? Thanks 02/27/2003 05:43 AM PSTPlease respond to [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]cc:It appears that way. We are also pondering on this upgrade as well.But if one takes this route, that is, running 5L in 32-bit mode, one can notinstall 9i on the same server. And Oracle has not certified 8.1.7 64-bit on AIX5L. It is not planned to be available, either.So, we are leaning towards upgrading to 9i first on AIX 4.3.3. Next upgrade OSto AIX 5L 5.1 and then 5.2 (some of the apps will become available on 5.2 laterthis year)..- Kirti-Original Message-Sent: Thursday, February 27, 2003 7:09 AMTo: Multiple recipients of list ORACLE-LSo 8.1.7 is supported on AIX 5L provided AIX is booted in 32 bit mode???John-Original Message-Sent: 27 February 2003 12:24To: Multiple recipients of list ORACLE-LCertify - Additional Info Oracle Server - Enterprise Edition Version 8.1.7(8i) On IBM AIX -Based SystemsOperating System: IBM AIX -Based Systems Version 5.2 (5L)Oracle Server - Enterprise Edition Version 8.1.7 (8i)N/A Version N/AStatus: CertifiedProduct Version Note:Terminal Oracle8i releaseTo obtain Patch Sets from MetaLink, click the "Patches" button to the left.Certification Note:Existing patch sets: 8.1.7.1.0 (without JDBC), 8.1.7.1.0b (includes JAVAVM, Context and JDBC), 8.1.7.2.0 8.1.7.3.0 8.1.7.4.0Oracle 8i 32-bit on AIX 5L (5.1 5.2)Kernel modes AIX 5L introduces the option to run the AIX kernel in 64-bitmode. This mode is not supported, as Oracle 8i uses at least one 32-bitkernel extension. AIX-based systems must be booted with kernels in 32-bitmode.Warning about missing "crash" during installation of Oracle 8i.The error message "crash: not
How to load pictures/documents in oracle
Hi, I have never had to insert pictures/documents in the oracle database before and would like to give it a go. Does anybody have some scripts that I can tear apart to look at how to do it (examples I find more usefull than books). I tried finding useful info on the net but did not find any concrete answers. TIA Jack Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: mailto:[EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: Upgrade to AIX 5.2
Hi It's been a while since I talked about this with the Unix guy at my previous assignment, but I think you MUST upgrade to 9i. Jack -Original Message- Sent: donderdag 27 februari 2003 11:45 To: Multiple recipients of list ORACLE-L As AIX 4.3.3 goes out of service this year, we need to upgrade our AIX box to AIX 5.2 We have both Oracle 8.1.7(32 bit) and Oracle 9i Release 2(9.2.0.1.0) (64 bit) installed on that box. Will upgrading to AIX 5.2 cause any problems for Oracle? Any issues etc?? 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: Basic RMAN question
Hi I don't think you need to have 'as sysdba' in your connect string. (But it's been a while) Jack -Original Message- Sent: woensdag 26 februari 2003 14:29 To: Multiple recipients of list ORACLE-L Hi All, I am starting to play with rman in a test environment, however I seem to be hitting a really basic problem starting rman. I have oracle 9.2.0.1.0 installed on Redhat AS 2.1 When i issue the command: rman target='backup_admin/backup as [EMAIL PROTECTED]' nocatalog log=test.log rman: can't open target=backup_manager/backup as [EMAIL PROTECTED] So i tested the connect string i had used as shown below: Enter user-name: opcenter : foobar: /home/oracle: $ sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 26 13:04:56 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL connect backup_admin/backup as sysdba Connected. So I thought id start simple: rman nocatalog rman: can't open nocatalog rman this just hangs So what have i missed? Thanks Ceri -- Ceri Townsend Database Admin mailto:[EMAIL PROTECTED] ICQ:153010767 I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ceri Townsend 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: Jack van Zanen 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: OS Kill
It's one of those oracle processes that for instance takes care of jobs in the job queue. They can be killed on oracle level w/o problems (8.0.5 at least). Test it first in test environment Jack -Original Message- Sent: dinsdag 25 februari 2003 8:04 To: Multiple recipients of list ORACLE-L hi list one session in our database is in ACTIVE state since long. it is doing no activity at all. it has locked one table also. because of this other sessions are also in ACTIVE state. so it is required for us to kill the session. i got the corresponding spid for that session from v$process. i checked the following:: $ps -ef | grep spid oracle 21556 1 0 Feb 20 ?0:09 ora_snp3_TRADEDB1 isn't this the OS process/thread for the oracle background process? i want to kill the process at OS level if it is not working at DB level TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan 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: Jack van Zanen 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).
alertlog naming
Hi, On one of our customers site (WINDOWS) we have databases that have alertlogs with the name sidALRT.LOGsidALRT.LOG (double the normal name) and oracle keeps on writing to it. I thought if a file is renamed oracle will create a new alertlog when needed. I have a php script that reads the alrtlogs and reports the errors in web browser and than renames the current alertlog to sidALRT.LOG.mmdd Can it be that when there is writing action in the file oracle will get confused and screw up the renaming bit? (I thought windows did not allow changing filenames of open files) One of the databases on this customers site every now and than hangs with no messages in the alert logs and does not allow any connections anymore(No errors reported back to client). This database needs to be up and running asap so when it happens we don't get much time to investigate and restart the service. We can still connect with svrmgrl and internal (wasn't this supposed to go in 8.1.7). What would be the best course of action to quickly gather the releavnt data next time this happens. Has anybody seen this before and knows the solution? W2K Oracle 8.1.7.0.0 EE Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: mailto:[EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: DSS tools?
vendor hat on 1.To perform what you mention you have to query Oracle you have to query SQL Server and then joint the two result set and then use any statiscal function to have average, top5, ... 2.Multiple datasources can be connected at a time 3. Brio Intelligence server is a Multitiers/multithreaded product where you can mixed the platform ( Windows / Unix to take the better avantage of each one) This explainwhy they have reference with 1000s ofweb users in production since1999. /vendor hat on -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: woensdag 19 februari 2003 13:49To: Multiple recipients of list ORACLE-LSubject: DSS tools? A customer of mine has recently decided to purchase BRIO but the process of checking references on the producthas been(ahem!)pretty discouraging. Specifically, they have gathered the following comments: 1. There are no aggregate functions available on the BRIO client. For example, if we pull some product pricing from Oracle and some from SQL Server, we will not be able to calculate an average price on the client (local PC) where we build the report. 2. Only one data source can be connected at a time. This forces a user to save result sets from different cubes locally first and then compare them also locally. 3. On Demand server(web-based middle-tier)is single-threaded; only one client at a time is working. My guess is that this is changed in v8, but it would be nice to get a confirmation. Has anyone had experience with this? What are your experiences? Also, what other DSS tools are you using and how do you like them? Thanks in advance...
RE: installing oracle 8i on Solaris 9
Hi Just give the mount points names you are happy with The examples you normally see use U01,U02. It basically means that your software should be installed on different mount point/disk than your db files. -Original Message- Sent: woensdag 19 februari 2003 8:49 To: Multiple recipients of list ORACLE-L I'm stuck in the mount section of the tutorial. I'm only trying to setup one DB and I don't get how I should setup a mount point for the software and one for each db file using /pm pattern. P is the string constant and m is the fixed length key to distinguish between mount points. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 8:23 PM I've been trying to *prepare* my sol box to install Oracle... The freakin' install guide is 202 pages long...Is there an easier method to install oracle than reading 200+ pages? Anyone know any good tutorials or websites where I can get some newbie info on installing oracle? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo 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: Les Ayudo 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: Jack van Zanen 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: Programming languages that make DBA's lives easier
AFAIK NOT shell scripts NOT batchscript anything else probably works for you Jack -Original Message-From: Robson, Peter [mailto:[EMAIL PROTECTED]]Sent: woensdag 19 februari 2003 12:34To: Multiple recipients of list ORACLE-LSubject: RE: Programming languages that make DBA's lives easier I wonder if I can throw in a further caveat to the choices people would make? If you had to choose a programming language in which to write a program orapplication in which you wished to conceal your intellectual property, which would you use? peter edinburgh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Les AyudoSent: Tuesday, February 18, 2003 10:56 AMTo: Multiple recipients of list ORACLE-LSubject: Programming languages that make DBA's lives easier On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used?*This e-mail message, and any files transmitted with it, areconfidential and intended solely for the use of the addressee. Ifthis message was not addressed to you, you have received it in errorand any copying, distribution or other use of any part of it isstrictly prohibited. Any views or opinions presented are solely thoseof the sender and do not necessarily represent those of the BritishGeological Survey. The security of e-mail communication cannot beguaranteed and the BGS accepts no liability for claims arising as aresult of the use of this medium to transmit messages from or to theBGS. The BGS cannot accept any responsibility for viruses, so pleasescan all attachments. http://www.bgs.ac.uk*
RE: No redo or archived log files
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: Jack van Zanen 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).
Oracle7 based delphi apps using BDE working with new 9i Clients
Hi, Has anybody yet upgraded from Oracle 7.2 clients to 9.2 clients and get their delphi/BDE apps to work. If so could you please tell me more or less how, so I can pretend to be smart with the application people :-) Does a 7.2 client communicate with 9.2 database anyway?? According to Oracle it is not supported and my test here from 7.1 to 9.2 results in ORA-3113 end of file on communication channel Connecting from 9.2 to 7.1 leaves me with windows error message. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: hmm...
Hi Set global_names = false in init.ora file and try again -Original Message- Sent: vrijdag 6 december 2002 17:41 To: Multiple recipients of list ORACLE-L Don't ask how we got into this situation, but I have two instances with the same global_name and need to be able to create a link between them. Is this doable? Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donahue, Adam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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).
Oracle 9iR2 on Red Hat 8.0/Kernel settings
Hi, I'm to install Oracle9i R2 on RH linux soon as well. I have read the install guide about the kernel settings but they seem to only mention the correct settings for a single instance on LINUX. I have not had the privilege before to work on systems I had to set the kernel parameters (not needed on AIX) so I could use a little help on this. RH linux 8.0 Oracle 9i R2 2 instances on one machine (about 25 concurrent users per db) buffer cache approx. 300MB (based on the old databases that is migrating plus some extra for upgrade) Shared pool 25-35Mb (based on the old databases that is migrating plus some extra for upgrade) What would my kernel settings be looking like, or could anybody point me to ocumentation that explains this??? TIA Jack -Original Message- Sent: donderdag 5 december 2002 10:44 To: Multiple recipients of list ORACLE-L installed O92010 on rh 8.0. went fine so far until I tried to connect via oemapp console - whatever connectdescripter I chose it resulted in the error connection string not properly terminated. same connect descriptors in the CLI worked fine - made them available in the oemapp console and got the error message. didn't investigate any further into this - experienced it twice on two different machines. changed back to rh7.2 and things were fine again. don't forget to make the kernel settings for memory - otherwise the database installation will fail - maybe you have to correct the entry in the ORACLE_HOME/ctx/lib/env_ctx.mk file for INSO_LINK and add $(LINKLDLIBS) at the end. installing the patch to make 9.2.0.2.0 out of it may require some tweaking. or if this is a new installation just drop the typical database and create a new one after applying the patch to the other files. be careful with oid - experienced you cannot install it after applying the patch. in general the same hints and points as on SunOS apply on RH 7.2/7.3/8.0. have a lot of fun thats all I can contribute. kr [EMAIL PROTECTED] 12/04/02 23:52 PM Thanks Sean. I installed 9iR2 on both my laptop and a desktop, both running RH 8.0. Pretty straightforward, except for the usual failure in linking intermedia. I would have thought they would fix that by now. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/04/2002 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Oracle 9iR2 on Red Hat 8.0 If you've installed Oracle 9i on RH 8.0, please let me know. Also, please let me know of any difficulties and workarounds you may have encountered. Just put a new 40Gig HD in my laptop, and wondering if I can install RH 8.0, or should use 7.2. Jared: I put together some notes when I installed 9.2.0 on RH7.3. I think that RH8 is probably similar. http://iheavy.com/~shull/files/ora9i_inst_notes.txt HTH, Sean -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
oracle temp files
Hi If I create a temporary tablespace using temp files, how is it possible to check the space usage of that tablespace. They do not show up in dba_free_space nor dba_data_files. DBA_TEMP_FILES gives me user_bytes and blocks. is this the opposite of the info in dba_free_space?? TIA Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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: question: about table(s) ?
Hi, I think you could use different schema's to distinguish between different companies. Jack -Original Message- Sent: vrijdag 29 november 2002 2:44 To: Multiple recipients of list ORACLE-L can we arrange tables in a heirarchy form, just like we have folders and under folders we have files. so this way we sort of divide workspace. say for company_A i create folder A and in it we can place files for that company. and similarly we can create a folder for company_B. Hence we can separate workspaces for better organization and management etc. so how can we accomplish as above, when we work with database ? is there a way we can arrange tables (of the database) in a heirarchy similar to folders and files ? say i have one installation of oracle on a particular computer. so how does one create separate table spaces, say for two different company or projects ? (say company_A and company_B are unrelated to each other) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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: Problem doing RMAN backup of Clone?
Create the clone using RMAN duplicate command. Than it gets new ID -Original Message- Sent: maandag 25 november 2002 4:14 To: Multiple recipients of list ORACLE-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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: A way to restore a DB
How about doing the inserts in a seperate database and synch using replication or home cooked scripts into your warehouse. -Original Message- Sent: zondag 24 november 2002 18:24 To: Multiple recipients of list ORACLE-L Dear gurus! We are evaluating a strange way to recover a production DB. This is a 3.7 TB database, still growing, with LOTS of data inserted every 5 minutes (and several partitions belonging to several tables get dropped each day - we keep historical data for 90 days back), which we used to backup with RMAN to HP Omniback controlled tapes. We had a failure, and it took almost 48 hours to restore/recover the DB (in addition to backed DB files, I had to restore thousands of archived logs from tapes and apply them to the DB). We can not afford to have the DB down for 2 days. Now, we decided to give up RMAN hot backup, actually to give up backup (in it's classic meaning) at all. I'll explain why: It's very important for us to get the DB up running ASAP after a crash. We want the DB operating much more than we care about historical data that reside in our DB. Our goal is to enable the inserts (which run every 5 minutes, as I have stated) ASAP. So, we plan to do the following backup/recovery procedures: 1) We want to generate a script that will build the basics of the DB - create the DB and the instance, build tablespaces, users, grants, roles etc... 2) We want to create a daily export of small (but the most important) configuration tables, which can be imported very quickly after the crash and rebuild of DB. At this point the DB is operational. 3) We can now import the large data tables - partition by partition. And I don't care if THIS step will take 2 weeks. What do you say? Any reviews of my steps and the idea in general? And, do you have a script that can re-engineer a DB (as in my step 1)? Thanks a lot in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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: What makes Oracle DB shutdown automatically?
Hi, A good place to start is your alert log and see if there are any trace files from the time of crash. Jack -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: maandag 25 november 2002 9:29To: Multiple recipients of list ORACLE-LSubject: What makes Oracle DB shutdown automatically? Dear all DBAs, I wonder what're the possible reasons that make Oracle DBshutdown automatically? Linux is running well. It first running very slow andsuddenly shutdown. Running Oracle 8.0.5 on Linux. Can you guys please tell me what should i check? Would you mind to explain in detail? 'Cos I'm just a junior DBA. Thanks in advance.
RE:
Get rid of your virus please -Original Message-From: sfaroult [mailto:[EMAIL PROTECTED]]Sent: maandag 25 november 2002 14:54To: Multiple recipients of list ORACLE-LSubject:
RE: Storing of number datatype in table
I believe that one position is used for positive/negative value. So it wouldn't fit otherwise -Original Message- [mailto:[EMAIL PROTECTED]] Sent: vrijdag 22 november 2002 12:24 To: Multiple recipients of list ORACLE-L Dear List Have a look at the sql !!! SQL create table trnid 2 ( trn_id number(10)); Table created. SQL insert into trnid(trn_id) values('11');/* 10 1's inserted*/ 1 row created. SQL insert into trnid(trn_id) values('1');/* 9 1's inserted*/ 1 row created. SQL commit; Commit complete. SQL select trn_id from trnid; TRN_ID - 1.111E+09 1 can anyone tell why the number(10) is stored in exp format Regards, Sathyanarayanan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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: Ltrim?
0 6 * * 1 script_name -Original Message- Sent: vrijdag 22 november 2002 15:19 To: Multiple recipients of list ORACLE-L Hallo, Anyone whom could help me how to write in cron when scheduling the start of a unixprogram. I would like that the unix script will run every monday on 6 am. I have tried but it fails. Any suggestions, please help Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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: Installing 8.1.7 on a machine with an existing 9.0.1 installa
Hi, I copied the entire CD to disk (so that I can always install additional features as needed) and installed using the 9.0.1 installer w/o problems on W2K off the top of my head: If you have a Pentium 4 there are issues to resolve with the java environment and one of them was to copy the entire cd to disk rename symcjit.dll to symcjit.old and start using the installation from the install win32 directory. I renamed the files and used the 9i installer instead and that worked also Jack -Original Message- Sent: donderdag 14 november 2002 12:14 To: Multiple recipients of list ORACLE-L installation Hi everybody I'm about to throw my laptop out of the window (I'm on Win2k). I have an existing 9.0.1 installation (server and developer tools like designer and jedevelop). That works. Now I need to install an additional 8.1.7. If I run the installer from 8.1.7, it tells me that the component oracle.swd.jre 1.1.8.10.0 is missing while checking the dependencies (after you decide the installation type, before the list of available products/options is displayed). Checking the components in the stage directory, it shows that it is really missing. Next try was to install 8.1.7 using the 9.0.1 installer. Installation works, but hangs at the end ... great. Next try was to take the oracle.swd.jre 1.1.8.10.0 component from 9.0.1 (where it exists) and copy it to the 8.1.7 stage and to create the property files. No success. Any ideas, or do I have to remove everything, then install 8.1.7 first, folowed by 9.0.1 and the developer tools. That would be very diappointing. Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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).