winders email client.
have you tried firebird? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The box said I needed to have windows 98 or better...So I installed linux. [EMAIL PROTECTED] ier.utc.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: !!Please Read - Oracle-L is moving!! om 01/23/2004 07:09 AM Please respond to ORACLE-L -Original Message- Sent: Friday, January 23, 2004 9:00 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Bill The line breaks get removed from *incoming* mail, so I don't think it matters what your default new mail format is. I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office' in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch that, sir, is an understatement.;-) just wish i could fine an email client that would deal with MAPI other than Outlook. here at work we don't have IMAP enabled so i don't seem to have much choice.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents. - Nathaniel Borenstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: winders email client.
Yup. Answered this without drinking coffee first... Firebird, aka phoenix- one of the best browsers out there. I use it exclusively. Thunderbird- email client. I read IMAP not MAPI in your email. Slithering back to my hole... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The box said I needed to have windows 98 or better...So I installed linux. [EMAIL PROTECTED] ier.utc.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: winders email client. om 01/23/2004 01:29 PM Please respond to ORACLE-L - -Original Message- - From: Ron Thomas [mailto:[EMAIL PROTECTED] - Sent: Friday, January 23, 2004 11:49 AM - To: Multiple recipients of list ORACLE-L - Subject: winders email client. - - - - have you tried firebird? firebird is a web browser without an email client. thunderbird is the email client and it doesn't gork MAPI. i use firebird for all my browsing.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Time is an illusion, lunchtime doubly so. - Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: winders email client.
email client- http://texturizer.net/thunderbird/ browser- http://texturizer.net/firebird/ Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The box said I needed to have windows 98 or better...So I installed linux. [EMAIL PROTECTED] pmorgan.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: winders email client. om 01/23/2004 01:59 PM Please respond to ORACLE-L Where can you get this firebird browser? Reginald W. Bailey IBM Global Services JPMC Account - DCI ETS Database Management Your Friendly Neighborhood DBA [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] er.utc.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: winders email client. m 01/23/2004 02:29 PM Please respond to ORACLE-L - -Original Message- - From: Ron Thomas [mailto:[EMAIL PROTECTED] - Sent: Friday, January 23, 2004 11:49 AM - To: Multiple recipients of list ORACLE-L - Subject: winders email client. - - - - have you tried firebird? firebird is a web browser without an email client. thunderbird is the email client and it doesn't gork MAPI. i use firebird for all my browsing.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Time is an illusion, lunchtime doubly so. - Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Re: !!Please Read - Oracle-L is moving!!
The list members must be really hammering their servers now. I've tried to sign up using both the web and email methods and have yet to receive a conformation/response. I can see the headlines now, oracle-l slashdots freelists.org ;-) Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The box said I needed to have windows 98 or better...So I installed linux. [EMAIL PROTECTED] mTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: !!Please Read - Oracle-L is moving!! .com 01/21/2004 11:49 PM Please respond to ORACLE-L 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 -- 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
RE: Oracle 817 client on Windows 2003?
From metlink, it looks like the 8.1.7 client is not certified for Windows 2003 server. You should probably install the 9.2 client on the workstations. It should ahve no problems connecting to the 8.1.7 database on unix. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The box said I needed to have windows 98 or better...So I installed linux. shreepadx.m.vaidy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: Oracle 817 client on Windows 2003? .com 01/21/2004 09:59 AM Please respond to ORACLE-L Hi Michael, 1) You need to ensure that the listener is configured properly. 2) Your tnsnames.ora or namesserver is configured properly. 3) There are no problems in installation of Oracle client,server and database . If the above conditions are satisfied , you should have no problems in connecting from client to server (database) . I am not sure whether it is certified . Thanks and regards Shreepad -Original Message- Michael Milligan Sent: Wednesday, January 21, 2004 9:35 AM To: Multiple recipients of list ORACLE-L The database is on Unix, but we want to run client (OEM, SQL*Plus, etc.) on Windows 2003. Do you know if it is certified to, or will it do it? Thanks This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Vaidya, ShreepadX M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
Re: Apps 11.5.9 D.R. Site -- MetaLink Note 216212.1 ??
Looks fairly close. I'll be doing this over the next couple of weeks. If interested,
I'll let you
know how it all turns out.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
[EMAIL PROTECTED]
com.sg To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED]Subject: Re: Apps 11.5.9 D.R. Site --
MetaLink Note 216212.1 ??
.com
01/04/2004 02:29
AM
Please respond to
ORACLE-L
There seems to be Note 216212.1 titled Disaster Recovery and the
E-business Suite
Has anyone used this note ?
{Although I am familiar with 11.5.3, the last time I worked on 11i was more
than two years ago,
so I am not in touch with 11i , although I do manage an 11.0.3 instance now}
Hemant
At 03:34 PM 30-12-03 -0800, you wrote:
I've been charged with bringing up a disaster recovery site, so time to
hit the books again as a lot
has changed since the last time I did this. Looking for resource
recommendations (FM to read, white
papers, etc).
Sticky part of this is it is an Applications 11.5.9 installation. The
database end of it should not
be too difficult (8.1.7.4, soon to be 9.2.0.4), but the applications file
system is modified by the
adpatch utility which adpatch requires a database connection to
function. I can think of 2 ways to
get around this requirement.
1. set the two_task to point to a live test system, and run adpatch force
using the c and g drivers.
The d driver would not need to be run since the changes will come over via
the archive logs.
2. ignore adpatch utility completely and use rsync.
Suggestion, comments?
Thanks,.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Thomas
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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
Re: Apps 11.5.9 Disater Recovery Site
Hi Tanel- I've been doing 11.5 cloning for several years and think I've found most (but I'm sure not all) of the database and filesystem changes required. adpatch is what concerns me the most since it requires a database connection to function. It can't connect to the DR database since it will be in a recovery mode. I'm thinking that setting the two_task to a service that points back to the production system would work. You bring up an interesting question though. c, d, and g drivers are very specific in the functions they perform. Now that Oracle is moving to the u driver, I'll need to look into this. I was looking at rsync as an alternative to the above. rsync would also be used to transfer the concurrent reports (/.../common/out) to the DR system (don't know if management want this yet or not). Time for coffee not sure if I'm making sence yet. Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] ail.ee To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: Apps 11.5.9 Disater Recovery Site .com 12/30/2003 05:44 PM Please respond to ORACLE-L One issue popped into my mind with patching disaster recovery: When you're patching your primary system, have applied all c g and d drivers (or an u driver) and a disaster occurs, then your secondary site might remain in inconsistent state e.g. database objects have the new version, but corresponding $APPL_TOP ones are old, because they're not rsynced yet. Or the opposite - when rsync has been done, but you have to do a point in time recovery to the point before d-patch application in secondary site. And of course, don't forget to simulate and test the disaster, several times, if possible. Without warning, if possible ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 1:34 AM I've been charged with bringing up a disaster recovery site, so time to hit the books again as a lot has changed since the last time I did this. Looking for resource recommendations (FM to read, white papers, etc). Sticky part of this is it is an Applications 11.5.9 installation. The database end of it should not be too difficult (8.1.7.4, soon to be 9.2.0.4), but the applications file system is modified by the adpatch utility which adpatch requires a database connection to function. I can think of 2 ways to get around this requirement. 1. set the two_task to point to a live test system, and run adpatch force using the c and g drivers. The d driver would not need to be run since the changes will come over via the archive logs. 2. ignore adpatch utility completely and use rsync. Suggestion, comments? Thanks,. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan -- Please see
Re: Apps 11.5.9 Disater Recovery Site
Hi again- Why do you want to patch anything at disaster recovery site at all? When you apply any d-patches in primary, their changes will be transferred to secondary via redologs. When you apply any cg-patches in primary, you just use rsync to synchronize all changes to secondary site file system as well. There is no need for running adpatch in secondary site at all. This is what I was thinking as well. Just wondering if anyone had done this. Have a good New Years Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 OID and Production Databases Sharing the same
I'll agree that you can run multiple instance out of 1 oracle home, however, I've found it to be simpler to use a dedicated oracle home per instance. Disk space is cheap (relatively speeking). Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] .org To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: Oracle OID and Production Databases Sharing the same .com 12/30/2003 12:59 PM Please respond to ORACLE-L Tom, I see no problem that would prevent you from having multiple instances in the Oracle home. You would need multiple Oracle homes if you had different version of Oracle. With one Oracle home and multiple instances you have to be sure to include all instances in the shutdown and start up scripts or at least have a check list to insure all instances are down or up. Adding the java stuff should not effect the other instance if the init parameters are set correctly. It will make life easier to keep the Oracle software up to date with only one home. I like the KISS syndrome. Ron [EMAIL PROTECTED] 12/30/2003 1:34:49 PM All, We have a AIX 5.2 box serving a new 9.2 database. We also installed the OID software on this box. Oid requires it's own database. So we have two instances on this machine. We received notice from Oracle that a security patch (#62) was required. We were applying the patch and it failed because some Java stuff needed to be installed separatly first. Now I'm wondering if we should have created two Oracle Homes - one for the production database and one for the OID database. I'm worried that we will always have problems keeping these two instances sharing the same Oracle home. Anybody got an opinion? Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
Apps 11.5.9 Disater Recovery Site
I've been charged with bringing up a disaster recovery site, so time to hit the books again as a lot has changed since the last time I did this. Looking for resource recommendations (FM to read, white papers, etc). Sticky part of this is it is an Applications 11.5.9 installation. The database end of it should not be too difficult (8.1.7.4, soon to be 9.2.0.4), but the applications file system is modified by the adpatch utility which adpatch requires a database connection to function. I can think of 2 ways to get around this requirement. 1. set the two_task to point to a live test system, and run adpatch force using the c and g drivers. The d driver would not need to be run since the changes will come over via the archive logs. 2. ignore adpatch utility completely and use rsync. Suggestion, comments? Thanks,. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 reports
This was true even for 6i after about patchset 6, IIRC. Many notes on metalink concerning this. In a nutshell.. 1. install VNC 2. start a vnc server at a specific screen address, such as 11 3. add a export DISPLAY=host:11 to the .profile of the reports server. 4. go have a beer. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] o.uk To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Oracle 9i reports .com 12/17/2003 02:24 PM Please respond to ORACLE-L Hi All, Can you please clarify me the following. We have been using reports 6i on Solaries, Now We would like to migrate to Reports 9i, We are told that (As Character set was depricated in 9i ) we need to keep one xterm console open and ruuning every time we execute rwrun. is this true? are there any work-around? thanks for your help, Ravi. BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st December 2003. The way the internet was meant to be. http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Query
Be aware that this script does not include autoexted info Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: RE: SQL Query 11/14/2003 01:19 PM Please respond to ORACLE-L Below is a very nice tablespace script, followed by some sample output. Thought you might like it. I found in somewhere. REM name: freespace.sql REM This script is used to list database freespace, total database REM space, largest extent, fragments and percent freespace. REM REM Usage sqlplus system/passwd @freespace REM REM Date CreateDescription REM 30-Oct-96Fan Zhang Initial creation REM REM dba tool key: freespace.sql -- list database freespace, total space and percent free REM set pau off set pages 35 set lines 120 col tablespace heading 'Tablespace' col freeheading 'Free|(Mb)' format 9.9 col total heading 'Total|(Mb)'format 99.9 col usedheading 'Used|(Mb)' format 9.9 col pct_freeheading 'Pct|Free' format 9.9 col pct_nextheading 'Pct|Next' format 9.9 col largest heading 'Largest|(Mb)' format 9.9 col nextheading 'Next|Ext(Mb)' format 9.9 col fragmentheading 'Fragment' format 999 col extents heading 'Max.|Ext.' format 999 spool freespace.txt compute sum of total on report compute sum of free on report compute sum of used on report break on report select substr(a.tablespace_name,1,13) tablespace, round(sum(a.total1)/(1024*1024), 1) Total, round(sum(a.total1)/(1024*1024), 1)-round(sum(a.sum1)/(1024*1024), 1) used, round(sum(a.sum1)/(1024*1024), 1) free, round(sum(a.sum1)/(1024*1024), 1)*100/round(sum(a.total1)/(1024*1024), 1) pct_free, round(sum(a.maxb)/(1024*1024), 1) largest, round(sum(a.next1)/(1024*1024), 1) Next, round(sum(a.next1)/(1024*1024), 1)*100/round(sum(a.maxb)/(1024*1024), 1) pct_next, max(a.max_ext) extents, max(a.cnt) fragment from (select tablespace_name, 0 total1, sum(bytes) sum1, max(bytes) MAXB, count(bytes) cnt, 0 next1, 0 max_ext fromdba_free_space group by tablespace_name union select tablespace_name, sum(bytes) total1, 0, 0, 0, 0, 0 fromdba_data_files group by tablespace_name union select tablespace_name, 0, 0, 0, 0, max(next_extent) next1, max(extents) max_ext from dba_segments group by tablespace_name) a group
Re: sqlplus prompt question in 9i
As a further FYI- We do not allow anything to be placed in glogin.sql. It can screw up anything supplied by oracle, ie, upgrade scripts. A local login.sql is the best way to go. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] ys.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: sqlplus prompt question in 9i .com 10/29/2003 10:14 AM Please respond to ORACLE-L You could just use login.sql instead, on a per user basis. If you don't want login.sql to be used, just edit or unset SQLPATH. Maybe other options available for this in 9i. A perusal of the sqlplus manual may prove useful. Jared Guang Mei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/29/2003 08:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:sqlplus prompt question in 9i Hi: With Oracle 8i, I always modified $ORACLE_HOME/sqlplus/admin/glogin.sql, and added set termout off col site_name noprint new_value site_name_new select 'SQL ' site_name from dual; selectuser || substr(proc.program, instr(proc.program,'@'), instr(proc.program,' ') - instr(proc.program,'@')) || '-SQL ' site_name from v$process proc where proc.pid = 2; set sqlprompt 'site_name_new' set termout on so that when a user launches sqlplus, it would show something at prompt like [EMAIL PROTECTED] instead of SQL I found that doing this in 9i will prevent me starting up my instance, when I use sqlplus '/as sysdba' In 8i, I always used svrmgrl to bounce db so there was no problem with modified glogin.sql. Has anyone found a work-around in 9i so that sqlplus prompt displays username and hostname when launched? I know there is a new _CONNECT_IDENTIFIER in 9i, but that's not good enough. TIA. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
Re: how is it possible
I see this from time to time on our HP systems. The terminal emulator on the client gets out of sync with the host, especially in regards to CTL-H and the Backspace key. I've seen this caused by applications that set the emulator into raw mode (Oracle Applications 10.7 character) and then back as well as su - user ... exit. That CTL-H trick embedded in a filename is how I test our Jr admins. Yes... I can be a tad evil at times... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: how is it possible .com 10/24/2003 10:24 AM Please respond to ORACLE-L Thanks Ron , This worked . But do you know why it happens . As I said its happening third time with me . My unix screen behaves weired sometimes it doesn't print any character I type and some time it prints characters which I never type ( in this particular case ). Thanks, -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 5:04 PM This generally happens when there is a CTL-H embedded in the filename. Try mv *m* anotherfilename You should be able to get at it after that. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: how is it possible .com 10/23/2003 04:49 PM Please respond to ORACLE-L This happening with me 3 rd time on this hp box . When I do ls -alt I can see a file in current directory but when I try to open it (vi/cat ) it says no such file or directory . I am same user who created the file .. ( no permission problem ) Any idea ?? -ak /home/ak/myscripts/shell_scr $ ls -alt total 4 drwxrwxrwx 2 ak dba 96 Oct 23 14:40 . -rwxrwxrwx 1 ak dba412 Oct 23 14:40 mon_scr drwxr-x--- 10 ak dba 1024 Oct 13 16:07 .. /home/ak/myscripts/shell_scr $ cat mon_scr cat: Cannot open mon_scr: No such file or directory /home/ak/myscripts/shell_scr $ cat ./mon_scr cat: Cannot open ./mon_scr: No such file or directory /home/ak/myscripts/shell_scr $ /home/ak/shell_scr $ whoami ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY
RE: dba interview questions
African or European? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Bellow, Bambi [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ech.com cc: Sent by: Subject: RE: dba interview questions [EMAIL PROTECTED] .com 10/23/2003 03:39 PM Please respond to ORACLE-L Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 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
Re: how is it possible
This generally happens when there is a CTL-H embedded in the filename. Try mv *m* anotherfilename You should be able to get at it after that. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: how is it possible .com 10/23/2003 04:49 PM Please respond to ORACLE-L This happening with me 3 rd time on this hp box . When I do ls -alt I can see a file in current directory but when I try to open it (vi/cat ) it says no such file or directory . I am same user who created the file .. ( no permission problem ) Any idea ?? -ak /home/ak/myscripts/shell_scr $ ls -alt total 4 drwxrwxrwx 2 ak dba 96 Oct 23 14:40 . -rwxrwxrwx 1 ak dba412 Oct 23 14:40 mon_scr drwxr-x--- 10 ak dba 1024 Oct 13 16:07 .. /home/ak/myscripts/shell_scr $ cat mon_scr cat: Cannot open mon_scr: No such file or directory /home/ak/myscripts/shell_scr $ cat ./mon_scr cat: Cannot open ./mon_scr: No such file or directory /home/ak/myscripts/shell_scr $ /home/ak/shell_scr $ whoami ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to add ' (comma) at the begining and end of each line? Ei
Let's not forget about ed ed your_file EOF ,s!^!'!g ,s!\$!',!g w q EOF if memory serves correctly. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: How to add ' (comma) at the begining and end of each line? Ei .com 10/16/2003 09:04 AM Please respond to ORACLE-L Since there has been an AWK reply, there should be a SED reply too. (Perl? What's Perl?) sed s/^/'/; s/\$/'/ your_file sed 's/^/'\''/; s/$/'\''/' your_file -Original Message- Hi List I have 1000 lines in my data file. I want to add '(comma) at the begining and end of each line. For example, abf jd djkhk jd3 Shold be convrted to 'abf', 'jd', 'djkhk', 'jd3', Any help will be really appreciated. Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Cary's Book - new topic
John- Just got back from a vacation and saw this... Our jr DBA is in the process of doing this. Care to share your code??? Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] s.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: RE: Cary's Book - new topic .com 10/08/2003 02:04 PM Please respond to ORACLE-L Raj (and all who use Oracle's Trace analyzer, I 'converted' the trace analzyer tables to GTTs, and no longer had the space issues with large trace files. This is because the data is stored 'temporarily' and is used for reporting in a subsequent SQL in the same session stream, and not reused elsewhere. Haven't really measured performance improvement, but this should ride on all the advantages that GTT provides. FWIW! John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- Sent: Wednesday, October 08, 2003 7:19 AM To: Multiple recipients of list ORACLE-L Thanks, I have been using that tool for a long time now, it needs a big tablespace (cause everything is loaded in tables) and puts a load on the server. It is good for smaller files, but takes too long on larger files. Nevertheless it is a great utility. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, October 08, 2003 9:50 AM To: Multiple recipients of list ORACLE-L go to metalink and check out trace analyzer. ITs a new tool for analyzing 10046 traces. Has ALOT more detail than tkprof. Major improvement. Its on metalink. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 REPORTS
You can't. As of about a year or so ago, there must be a buffer available for reports. vnc works nicley for this. Many notes/articles on Metalink concerning this. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] state.fl.us To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: URGENT REPORTS com 09/24/2003 01:54 PM Please respond to ORACLE-L Never mind. Was a bad rep_mdmdmd.conf file. However, does anyone know if there is a way to run reports services without have a DISPLAY variable set? We don't have a dedicated machine for this one purpose. -Original Message- Sent: Wednesday, September 24, 2003 1:56 PM To: '[EMAIL PROTECTED]' REP-110: Unable to open file 'alc4.rep'. REP-1070: Error while opening or saving a document. REP-0110: Unable to open file 'alc4.rep'. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Apps 11.5.8 and 9i
Step 1: have your head examined! Step 2: All components of Oracle Applications comes on the 22+ CD pack, ie, you don't need to order the DB or iAS. Have fun! Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] -drhc.gc.ca To: [EMAIL PROTECTED] Sent by:cc: [EMAIL PROTECTED] Subject: RE: Apps 11.5.8 and 9i 09/23/2003 11:54 AM Please respond to ORACLE-L 22 CDs huh? Any one know where to get free trial software for Apps? Anyone want to burn me 22 CDs? Just kidding... I haven't work with Financials since 10.7 and feel like I am rapidly losing my financials skills. I want to set this up at home. I figure I would use it for my personal accounting (I know overkill) but I need SOME reason to use it. It looks like I can order this from the Oracle store for a nominal price, however, I need some help in figuring out what to order. Based on the URL: http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=11536 , Here are the things I think I require: Oracle 9i Database (9.2.0.1) CD Pack for MS Windows $0 (downloaded this software previously) $55.93 Oracle Applications 11i Release 9 CD Pack for MS Windows $13.93 Oracle Applications 11i Release 9 Update CD Pack for MS windows And probably one of (but which one?): - Oracle 9i Application Server, Release 2 (9.2.0.1) CD Pack for MS Windows - Oracle 9i Application Server, Version 1.0.2.2.2a CD Pack for MS Windows Does this look right or are there other components I will also need? Thanks in Advance - Babette Also at home at: [EMAIL PROTECTED] -Original Message- Sent: 2003-09-20 3:45 PM To: Multiple recipients of list ORACLE-L Tanel, You're absolutely right. I had really meant to say that the 8.0.6 software stack finally goes away, but stated it poorly. Unfortunately, I was wrong even there, as the 8.0.6 software stack remains, as you've indicated. All I can say is that I was in the db-tier environment when looking for it, not in the app-tier as I should have been. Sloppy work and sloppy assumptions. Unskyld! But the Jinitiator is still nowhere to be seen, at least the stuff I've played with (i.e. Conc Mgr forms, SYSADMIN stuff, etc). I've not seen any documentation to confirm this though... 11.5.9 installs the db-tier in v9.2.0.3, but (not unexpectedly) the database that is scraped out of the 22-CD set of installation CDs is not set up very intelligently. For example, the locally-managed tablespaces have all been migrated from dictionary-managed instead of created as UNIFORM or AUTOALLOCATE, which leaves some interesting anomalies for the conscientious DBA, such as NEXT_EXTENT settings which are larger than any of the non-autoextend-enabled datafiles. Yay! for using locally-managed, boo! for migrating instead of doing it right. Kind of like asking kids to pick up their clothes -- they just move them from the floor to and place them under the bed, making the floor clean but not improving the process of getting clean clothes back into the closet and drawers. Anyway, this is the case in some 70-odd tablespaces. I'm sure this situation has always been present, but it makes one wonder whether Oracle ever consulted a practicing Apps DBA when burning its pre-installed databases onto the CDs. Still, 2 steps forward, 1 step back... Maybe
Re: Re[2]: 10g: SQL Plus
Cut and paste works just fine using the command line sql*plus and an X window manager. I suppose if you are using the Windows window manager, your milage varies... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re[2]: 10g: SQL Plus .com 09/22/2003 04:39 PM Please respond to ORACLE-L Monday, September 22, 2003, 5:49:48 PM, you wrote: PB Losing the pseudo-GUI version would be a a drag, because it's so easy PB to copy and paste text in it (not so easy in a Windows command prompt). Yeah, I have to admit, I probably execute more scripts via cut paste than I do using the @ command. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Apps 11.5.8 and 9i
I doubt it the jinitiator will ever go away for forms. It is Oracle's method of insuring an appropriate JVM on the client machine. FWIW, Sun's JVM 1.4.2 works out of the box for linux systems. No tweeks in the appsweb.cfg file at all! Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] ail.ee To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: Apps 11.5.8 and 9i .com 09/20/2003 03:59 AM Please respond to ORACLE-L Tim, The FormsReports are still there, the main part of Apps will continue using them long time. I've not touched 11.5.9 yet, maybe they've modified new installation config that way it doesn't require jinitiator on Windows platforms anymore, but the java forms you see, are still generated using Oracle Forms (with the exception of SSF, self service framework, which is HTMLjsp) and reports are still run using Oracle Reports. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, September 20, 2003 8:34 AM Plus, no more jinitiator in 11.5.9! Finally, the removal of SQL*Form/Oracle*Forms/Forms is complete... on 9/19/03 4:24 PM, Ron Thomas at [EMAIL PROTECTED] wrote: John, Thanks for the info. You may want to skip 11.5.8 and go to 11.5.9. There are major patches (the family pack variety) to apply subsequent to 11.5.8 Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] s.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: Apps 11.5.8 and 9i .com 09/19/2003 04:54 PM Please respond to ORACLE-L Ron, We are 'in the process' of moving from 11.5.7/8.1.7.4 to 11.5.8/9.2.0.4 - planning/testing starts after approval. We went ahead and installed a test db in any case. Make sure that you start out with 9.2.0.4 - the older 9.2.0.3 is buggy and Oracle seems to have ratified .4 recently. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Ron Thomas [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 2:50 PM To: Multiple recipients of list ORACLE-L Subject: Apps 11.5.8 and 9i Has anyone upgraded Oracle Applications 11.5.8 from database version 8.1.7 to 9i? Was it good, bad, indifferent in regards to performance? I'd like to because of some of the database enhancements, but the CIO asked the performance
RE: Re: max parallel query
To counter that... If our network admin had our NAS traffic on the same backbone as our internet/itranet traffic, they would very quickly be looking for employment elsewhere... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: RE: Re: max parallel query 09/19/2003 11:49 AM Please respond to ORACLE-L Matt, Question: What else do you have running on your Fiber Channel? Answer: Nothing Question: What do you have running on your TCP/IP network? Answer: Everything. For this one can see that a SAN's fiber channel is dedicated to handling data from one server to it's storage. Sure you can attach part of your SAN to the network to act as a NAS file system, but the SAN switch handles that separately from the servers so that one does not get in the way of the other. Therefore when some lummox decides to download that 1GB MPG file from the internet, his traffic does not get in the way of your database working with it's files. Divide Conquer still has it's place. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, September 19, 2003 1:35 PM To: Multiple recipients of list ORACLE-L The real differences between NAS and SAN is how data is accessed - NAS is file-based (open this file, read that file, lock this other file) while SAN, like direct-attached, is block based (read block 45345 from disk 7, write block 2442 from disk 3). SAN runs over Fibre Channel, which is a network protocol that sits under SCSI, while NAS uses NFS (or CIFS, but for Oracle just NFS) over TCP/IP to talk to the storage. From a pricing standpoint, its generally true that NAS is cheaper than SAN, though I can show you a million-dollar NAS box and a 10k SAN. Ditto with performance - while SAN is often faster than NAS, your mileage can vary wildly. Most of the perceived performance gap between SAN and NAS is due to the fact that people have lower standards for their networks than they do their SANs. I've seen people/organizations who would never ever consider using an off-brand Fibre Channel card cheerfully put their performance-sensitive NAS traffic over a $50 Gigabit ethernet card. Intelligent design and careful tuning (plus sizing your storage properly) for your NAS will yield comparable performance to a SAN. Beyond that, management of NAS vs. SAN is totally different, though I can't get into that in detail here. Finally, the world just changed again with the introduction of iSCSI - SCSI over IP. It's block-based access over traditional IP networks...very exciting stuff. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DENNIS WILLIAMS Sent: Friday, September 19, 2003 11:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: max parallel query Ryan NetApp is in another class of devices labeled NAS for Network Attached Storage. Because its connection with your
RE: PL/SQL Question:Eliminate duplicate rows
except your too_many_rows exception should be dup_val_on_index... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] e.ny.us To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: PL/SQL Question:Eliminate duplicate rows .com 09/19/2003 01:54 PM Please respond to ORACLE-L Johann, how about the following. what this does is, using the inner begin/end block, catches when an insert would fail because of the PK failure and ignores the error. This is very quick and dirty - it will work fine if you are not working with a huge amount of data. declare cursor c1 is select col1, col2 from some_table; begin for c1_rec in c1 loop begin insert into new_table(col1, col2) values (c1_rec.col1, c1_rec.col2); exception when too_many_rows then null; end; end loop; end; / If you are talking about lots and lots of data, you could easily query the table you are inserting into, testing for the existence of the value you are attempting to insert. If you find it, skip the insert. Like this: declare rec_count number; cursor c1 is select col1, col2 from some_table; begin for c1_rec in c1 loop begin select count(*) into rec_count from new_table where col1 = c1_rec.col1; -- this assumes that col1 is the pk! if rec_count = 0 then insert into new_table(col1, col2) values (c1_rec.col1, c1_rec.col2); end if; exception when too_many_rows then null; end; end loop; end; / Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, September 19, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Looking for an a sample cursor routine to load a PK enabled table to eliminate any dupes from the load table. __ 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: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: PL/SQL Question:Eliminate duplicate rows
Hi Tom- Submitting to a listserve is like living in a small town. Make 1 little oops and everybody knows about it. Do I need to look over my shoulder on the way to my car tonight??? ;) Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] e.ny.us To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: PL/SQL Question:Eliminate duplicate rows .com 09/19/2003 02:29 PM Please respond to ORACLE-L You know, I never use that exception, so I can't remember it correctly. You are correct, of course - thanks for embarrasing me in front of thousands and thousands and thousands (how many Jared??) of people! :) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, September 19, 2003 4:10 PM To: Multiple recipients of list ORACLE-L except your too_many_rows exception should be dup_val_on_index... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] e.ny.us To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: PL/SQL Question:Eliminate duplicate rows .com 09/19/2003 01:54 PM Please respond to ORACLE-L Johann, how about the following. what this does is, using the inner begin/end block, catches when an insert would fail because of the PK failure and ignores the error. This is very quick and dirty - it will work fine if you are not working with a huge amount of data. declare cursor c1 is select col1, col2 from some_table; begin for c1_rec in c1 loop begin insert into new_table(col1, col2) values (c1_rec.col1, c1_rec.col2); exception when too_many_rows then null; end; end loop; end; / If you are talking about lots and lots of data, you could easily query the table you are inserting into, testing for the existence of the value you are attempting to insert. If you find it, skip the insert. Like this: declare rec_count number; cursor c1 is select col1, col2 from some_table; begin for c1_rec in c1 loop begin select count(*) into rec_count from new_table where col1 = c1_rec.col1; -- this assumes that col1 is the pk! if rec_count = 0 then insert into new_table(col1, col2) values (c1_rec.col1, c1_rec.col2); end if; exception when too_many_rows then null; end; end loop; end; / Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, September 19, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Looking for an a sample cursor routine to load a PK enabled table to eliminate any dupes from the load table. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http
RE: Apps 11.5.8 and 9i
John, Thanks for the info. You may want to skip 11.5.8 and go to 11.5.9. There are major patches (the family pack variety) to apply subsequent to 11.5.8 Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] s.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: Apps 11.5.8 and 9i .com 09/19/2003 04:54 PM Please respond to ORACLE-L Ron, We are 'in the process' of moving from 11.5.7/8.1.7.4 to 11.5.8/9.2.0.4 - planning/testing starts after approval. We went ahead and installed a test db in any case. Make sure that you start out with 9.2.0.4 - the older 9.2.0.3 is buggy and Oracle seems to have ratified .4 recently. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Ron Thomas [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 2:50 PM To: Multiple recipients of list ORACLE-L Subject: Apps 11.5.8 and 9i Has anyone upgraded Oracle Applications 11.5.8 from database version 8.1.7 to 9i? Was it good, bad, indifferent in regards to performance? I'd like to because of some of the database enhancements, but the CIO asked the performance question. Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http
Apps 11.5.8 and 9i
Has anyone upgraded Oracle Applications 11.5.8 from database version 8.1.7 to 9i? Was it good, bad, indifferent in regards to performance? I'd like to because of some of the database enhancements, but the CIO asked the performance question. Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Is Cary's new book shipping now?
OK, call me senile, but I've been following this thread for so long I can't remember the titles for Cary's and Tom's books. Anyone wanna lend a hand with the ISBN number or title? Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] .com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: Is Cary's new book shipping now? .com 09/17/2003 12:14 PM Please respond to ORACLE-L Tom has a NEW, different book out, from Oracle Press. That is the one Cary is referring to. Which means you'll have to buy a new book. As for Cary's book, I have it on order at Amazon as well, but according to the site today, it's still not released. :( --- Dwayne Cox [EMAIL PROTECTED] wrote: Why oh why did I not wait? I tracked down and purchased Tom's previous Expert One-on-One Oracle a couple months ago. I even checked to make sure a new edition was not forthcoming. *sigh* Did not check enough I guess. I'll have to compare the two to see if I want to 'upgrade'. I am waiting, impatiently, for Cary's book (preordered on Amazon). I just attended the Oracle9i Performance Tuning Class and am quite pumped about tuning. Especially since we have recently experienced some performance issues. Dwayne -- Dwayne Cox Info Tech, Inc. Gainesville, FL Cary Millsap wrote: Tom's book, by the way, is spectacular. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic http://www.hotsos.com/training/clinic101 101 in Sydney - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Jamadagni, Rajendra Sent: Tuesday, September 16, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Thanks Cary I have your new book and Tom's new book on order .. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, September 16, 2003 12:05 PM To: Multiple recipients of list ORACLE-L Raj, The book will be in the O'Reilly warehouses tomorrow (9/17), presumably outbound to stores on the same or next day. I'd expect preorders to arrive at customers' homes on or near this weekend. Cary Millsap -- Dwayne Cox Corporate DBA Info Tech, Inc. 5700 SW 34th Street, Suite 1235 Gainesville, FL 32608 email: [EMAIL PROTECTED] phone: 352.381.4521 fax: 352.381. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from
Re: Unix- How to remove the first few lines(N) in a file without
Lets not forget about the vernerable ed...
#
# strip of the header of the input file
#
ed $data_filename EOF
1,5d
w
q
EOF
#
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
[EMAIL PROTECTED]
ail.ee To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED]Subject: Re: Unix- How to remove the
first few lines(N) in a file without
.com
09/16/2003 05:54
AM
Please respond to
ORACLE-L
(reposting)
Afaik, vi can run in non-interactive, batch mode too.
But I'd go with tail +6
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, September 14, 2003 10:49 PM
Mladen ,I want to automate this thing. So don't want
to go with :1,5d stuff
--- Mladen Gogala [EMAIL PROTECTED] wrote:
The best thing to do would be something like:
vi filename
:1,5d
:x!
That would do the trick.
Also this:
*
#!/usr/bin/perl -w
use strict
my $ind=1;
open FILE1,/file1/path||die Cannot open
file1:$!\n;
open FILE2,/file2/path||die Cannot open
file2:$!\n;
# Skip 5 lines
for($ind=1;$ind=5;$ind++) { FILE1; }
# copy files
while (FILE1) { print FILE2 $_; }
print I'm all done\n;
On 2003.09.14 12:14, Tim Gorman wrote:
sed '6,$p' filename new-filename
on 9/14/03 7:49 AM, Oracle DBA at
[EMAIL PROTECTED] wrote:
Hi List,
I want to remove the first 5 lines of the text
from
unix text file. Is there a command to do it
without
opening a file manually? (I don't want to use
(DD
command)
For example,
==
1 to be removed
2 to be removed
3 to be removed
4 to be removed
5 to be removed
a
s
==
Any help would be really appreciated.
TIA
Sami
__
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: 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).
--
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
Re: Database Cloning
Your belief was wrong. Actually, the belief was correct for some versions of oracle and some platforms. Case in point was Oracle 7 on an HP server. The source must be down in order to bring up the clone and recreate the control file. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] om To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: Database Cloning .com 09/15/2003 02:39 PM Please respond to ORACLE-L Smith, Ron L. wrote: Whenever we clone a database on the same server we have always had the understanding that the original database must be down until the new database is renamed by running the control file script. I am going through the Oracle Recovery 101 book in an effort to understand RMAN and one chapters in the book is cloning a database on the same server. I just went through the steps to create a clone of a hot database. I created the new database on the same server with a new name while the original database was up and running. I had no problems. Was our belief that the original database had to be down, incorrect, or was this just a restriction of older version like 7.3.4? Thanks! Ron Smith Ron, When you clone a database, you start with : 1) changing db_name in the init.ora file and most paths 2) defining a new ORACLE_SID and renaming init.ora accordingly 3) starting the instance without mounting it - your init.ora file is opened and read. Where do you want anything to interact (badly) with an existing database? You have allocated some shared memory, have started a few processes and read a file. Big deal. Your belief was wrong. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to send an email from unix command line?
Or check out mpack Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Madhusudana.Reddy@ bestbuy.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: How to send an email from unix command line? com 09/09/2003 04:24 PM Please respond to ORACLE-L If you wanted to send as an attachment use 'elm' Madhu Reddy -Original Message- Sent: Tuesday, September 09, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? Thanks in advance Sami __ 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: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-OCP Question
I've seen some of that research many moons ago. One of the conclusions was to always be in the same state of mind when you take the test as you were in when you studied. Now, where the did I put that bottle! Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: 9i-OCP Question .com 08/05/2003 08:09 AM Please respond to ORACLE-L There is scientific research that shows that moderate consumption of alcohol while learning and while testing improves scores. NOW you have a good excuse! -Original Message- In high school, I took the SAT exams and got a great score, enough to be satisfied with. My guidance counselor insisted I gild the lily and take the exams again. I showed up that morning with no sleep, a throbbing hangover, and eyes looking like fried eggs pasted to my head... ...scored 60 points better... on 8/4/03 11:49 AM, Stephen Lee at [EMAIL PROTECTED] wrote: An invaluable aid for test taking is -- I learned this when I took Organic Chemistry -- bourbon in water with ice in your favorite convenience drink cup. Everyone at the test site is sure you have a soft drink. -Original Message- Experience with various flavors of storage technology plus a decade of DBA experience can't possibly prepare me for what I haven't read (i.e. Oracle's recommendations). In a multiple-choice test format, unlike real life, I can't possibly argue with what Oracle has recommended... No wonder I failed my first try at the 9iOCP upgrade exam. Yes, I'll try again, once the lobotomy scars heal... -- 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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official
Re: Off Topic Question - Update.inf file
Yup. Been chortling with glee. Everytime this happens, I get a few more linux converts. Ron Thomas Linux Advocate (this sounds soo much better than bigot). Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: Re: Off Topic Question - Update.inf file 08/13/2003 10:54 AM Please respond to ORACLE-L fdisk, load linux. computers running m$ are saps, linux rulz, no virus worries here, hey wait why is root password toor, j/k. Linux Bigot KENNETH JANUSZ wrote: Yesterday I got hit with the Blaster Bug. To make a long story short I cannot apply the MS fix to my XP Prof. since I don't have the Update.inf file. Would like some feedback on where I can locate it and what directory it belongs in. I'm on XP Prof. SP1. I tried apply SP1a and it errored out saying it needed this file also. TIA, Ken Janusz, CPIM -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to tell Oracle the directories of script files
COOL! I've learned something new today. Can I go home Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] ail.ee To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: How to tell Oracle the directories of script files .com 08/14/2003 05:24 PM Please respond to ORACLE-L Btw, did you know that you can use: @http://www.servername.com/script.sql and @ftp://ftp.servername.com/dir/script.sql in 9i sqlplus :) It can be nice in environment where you continously have to work with random different servers and cant copy your script set over every time.. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 14, 2003 10:34 PM RDB, It is always best to include the path for the script that you want to execute. That way you make sure that you execute your script and not someone else's. There can be many scripts of the same name in the directory path. Ron [EMAIL PROTECTED] 08/14/03 03:19PM Yes there is a way. In UNIX environments (I think this works in NT/2000 as well) you can set the environment variable SQLPATH to a list of directories that contain SQL files. SQLPlus will search this path if the file is not found in the current directory. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] ys.utk.eduTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: How to tell Oracle the directories of script files om 08/14/2003 01:09 PM Please respond to ORACLE-L Hello, Suppose I have some SQL scripts in my /home/user directories, /usr/local/bin directories, etc. If I start 'sqlplus' from console in /home/user directories, I can load/execute the script by doing: SQL @scriptname But what if I don't start sqlplus from that directories? How do I tell Oracle to find the scripts in /home/user, then if it's not there in /usr/local/bin, for example? So that I can be anywhere in the filesystem when starting sqlplus and can execute my SQL script. Just like the $PATH environment variables in *nix system that tell the shell where to find executables, is there a similar thing for Oracle? Thanks for any help. RDB -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - /\ ASCII Ribbon Campaign against HTML \ / email and proprietary format X
Re: OT: [stupid] vi question
You have opened a file saved in dos mode. :%s/^M//g works wonders. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] o.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: OT: [stupid] vi question .com 08/06/2003 11:09 AM Please respond to ORACLE-L Suddenly my vi editor is showing ^M at the end of each line. How do I get rid of it? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 then 8i Installs
This is why you setup an orainventory file specific to each oracle home. YMMV. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] pmorgan.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: 9i then 8i Installs om 08/01/2003 03:59 PM Please respond to ORACLE-L Jay: When you do the install, insure that you use the 9i installer to install the 8i software. If you don't , the 8i installer will write to the inventory file and that would be bad. The 8i installer would not be able to read the file and would not know that 9i is already installed. Believe me, you do not want this to happen. So, as long as you use the resident installer, 9i, then you should not have a problem installing the 8i software. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] il.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: 9i then 8i Installs ity.com 08/01/2003 03:34 PM Please respond to ORACLE-L Hello: I got an odd request today to install 8.1.7 on an existing server which is running 9.2 (Windows 2000). Has anyone successfully been able to install Oracle 8.1.7 on the same Windows Server that already has 9.2 running? I know that if you install 8.1.7 then 9.2 both in different homes it will work, but I have never seen it work where 9.2 was installed first. I have not been able to locate a test box yet and was wondering if it is possible and if so if there are any pitfalls I should watchout for, other then the standard Windows stuff Thanks In advance, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Re: Any German here ? Character set
Just cover all bases and use UTF8 Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] etelem.frTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Any German here ? Character set .com 07/30/2003 08:04 AM Please respond to ORACLE-L Hi List, could you please tell me wich Character Set you are using in your database ? Thank in advance! Philippe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Anyone using onames on win2k server + 8.1.7 ?
We don't do windows here... but the 9.2 names server works just fine with all our 8.1.7.4 databases under unix. 9.2 names also does seam to be more stable than the 8.1.7 version. Just food for thought... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] om To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Anyone using onames on win2k server + 8.1.7 ? .com 07/25/2003 01:54 PM Please respond to ORACLE-L All Ive gone round and round with a new install of 8.17 and getting names to work. Initially when a name server was greated and upi opend the NET8 config, it would crash Searching metalink provided the needed patches 1,2,3,4 Aplied all in sequence without errors Import large tnsfile into names, save config and exit All the instances can be querried through the name server both locally (on the machine) and remotely However When the service restarts, or machine reboots all configuration is lost Searched metalnk and diddnt comeup with too much. I opned a TAR and was suggested to move to 9.x Well, Ive spent so much time on this and I need to maintain the 8.1.x version for this particullar server So, my question is anyone using onames on win2k server 8.1.7 My banner is as follows SQL*Plus: Release 8.1.7.0.0 - Production on Fri Jul 25 13:37:17 2003 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production With the Partitioning option JServer Release 8.1.7.4.1 - Production Input truncated to 14 characters [EMAIL PROTECTED] - Thanks and have a good weekend 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: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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] how to make Develper 6i talk to ORACLE 8i client??
The 8.0.6 client works just fine with 8.1.7 databases. Why do you want to make developer 6i use 8.1.7? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: [Q] how to make Develper 6i talk to ORACLE 8i client?? 07/25/2003 01:39 PM Please respond to ORACLE-L ORACLE Developer 6i come with ORACLE 8.0.6 client sql*net. Does their has way to make Developer 6i use ORACLE 8i (8.1.7) sql*net or NOT? Thanks. __ 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: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: backwards export
and 7.3.4 clients won't talk to a 9.2 database, False This is sort-a false. If the 9.2 database is in a new characterset such as UTF8, the old sqlnet clients will have difficulties if the client machine is also not in UTF8. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] E.COMTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: backwards export .com 07/24/2003 10:14 AM Please respond to ORACLE-L I'm not sure of the export compatibility, but you should know that 9i clients won't talk to a 7.3.4 database, True and 7.3.4 clients won't talk to a 9.2 database, False A Oracle7 client can, will, and does talk to a 9.2.0 database with no problem. which could be a problem. At least, they're not certified to talk to each other, which isn't quite the same thing. See note 172179.1 on Metalink. To quote: In short, any version of SQL*Net's version 2 Client (2.3.x) and up to Net 9.0.x, will be able to connect to any version of Oracle Database version 7.3.x and up to 9.2.x, with certain compatibility issues that are explained below Matt Adams Matt Adams - GE Appliances - [EMAIL PROTECTED] It will make sense when you stop thinking logically, and start thinking Oracle-ly - Jim Droppa -Original Message- Sent: Wednesday, July 23, 2003 8:55 AM To: Multiple recipients of list ORACLE-L I'm not sure of the export compatibility, but you should know that 9i clients won't talk to a 7.3.4 database, and 7.3.4 clients won't talk to a 9.2 database, which could be a problem. At least, they're not certified to talk to each other, which isn't quite the same thing. Cheers Simon Anderson Jeroen van Sluisdam [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 23/07/2003 12:49 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:backwards export Hi, We are investigating possibilities for migration of an oracle 7.3.4 to oracle 9i. We want to separate our production DB from the app-logic such that we can migrate from oracle 7.3.4 on hp-ux 10.20 to oracle 9i on hp-ux 11. Problem is our development and test-environment because we cannot separate the logic at the same time here also from the db (costs). Does anyone have any experience with exporting from oracle 9i to oracle 7.3.4 ? I found the underlying note on metalink about the same problem but with oracle 8. I have limited experience on oracle8 and none on oracle 9. So I hope you can give some tips. .. You need to run the 7.3 version of export against your 8.0 database via sqlnet/net8. Beforehand, you need to run rdbms/admin/catexp7.sql against your 8.0 database. This creates the 7.3 export views required. Note that if you have used any 8.0 specific features (e.g. objects) these will not be exported for obvious reasons. Tia, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net
Re: dba age
42. And missing a few experience fingers... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: dba age .com 07/23/2003 09:54 AM Please respond to ORACLE-L Now this one is difficult folks ... what is average age of an experienced oracle dba ? -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Recent reports on outages caused by DB2 and 9iRAC issues
I typically will not work for a boss who isn't like that. If I screw up, I'm the first to admit it (generally by a blood curdling scream). You can rake my sorry a. over the coals once the problem has been resolved. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: RE: Recent reports on outages caused by DB2 and 9iRAC issues 07/18/2003 11:39 AM Please respond to ORACLE-L I prefer my bosses attitude on the subject of mistakes: Admit that you did it then go fix it. We'll crucify you later, if we have the time. For some reason, known only to the Devil himself, they never find the time. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 18, 2003 1:14 PM To: Multiple recipients of list ORACLE-L This reminds of watching the Indy 500 a couple of years ago. One of the drivers managed to spin in turn 4 of the first lap of the race, and subsequently was unable to finish the race. Before continuing, you need to know that when in a corner, one thing you should *never* do is take your foot off of the gas pedal. The resulting weight transfer will greatly reduce the amount of weight on the rear tires, and could easily cause you to spin. Back to the story: The driver was interviewed shortly afterward in the pits, and put the blame squarely on the car. It was something with the car. Technology in the form of an onboard camera told another story. He let off the gas twice in turn 4. The first time the rear of the car squirmed a bit and he recovered. The second time it sounded like he completely released the accelerator, and the spin came shortly afterwards. He could have been a smart guy too, if he had remembered the camera. Too bad there wasn't a camera on the smart guys at Orbitz, maybe it would tell a different story. ;) None of us are immune to making mistakes, and about the time you start feeling invincible, watch out. Jared Goulet, Dick [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/18/2003 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Recent reports on outages caused by DB2 and 9iRAC issues Interesting quote in eWeek. We may all be smart guys, but how often do we like to admit to causing a problem. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 18, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Reports on Bugs in IBM's DB2 which led to a critical operational situation http://theregister.co.uk/content/archive/30095.html and http://www.danskebank.com/link/ITreport20030403uk/$file/ITreport20030403uk.pdf Report on Orbitz blaming an outage on Oracle's 9iRAC [and Orbitz going out of 9iRAC] http://www.eweek.com/article2/0,3959,1196879,00.asp and http://www.computerworld.com/databasetopics/data/software/story/0,10801,83186,00.html 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
RE: Physical Design Question
my 2cents...
Every instance get it's own oracle home, user id and group id. Total isolation and
separation. It
makes our auditors happy too!
Then again, I may be an extremist...
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
[EMAIL PROTECTED]
Com To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED]Subject: RE: Physical Design Question
.com
07/17/2003 05:14
PM
Please respond to
ORACLE-L
Well, since nobody else has jumped on this...
-Original Message-
Here's my situation:
1. Should I use a separate Oracle Home for each DB?
Not unless you have some peculiar situation there. Use separate ORACLE_HOME
for each version of Oracle but not each database.
Pros: --Allows upgrade/patching of 1 DB at a
time without affecting others (some are home-grown,
some are 3rd party).
The separate ORACLE_HOME for each version takes care of this. You just
change the ORACLE_HOME in the oratab when you upgrade the database. If you
use environment setting scripts, have them grab the correct ORACLE_HOME from
the oratab.
something like:
export ORACLE_HOME=`/usr/bin/nawk -F: '$1 == SID {print $2}'
SID=$ORACLE_SID $ORATAB`
where ORATAB is the path to your oratab file.
Sorry, I got no opinions on your storage arrangement.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Thomas
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: MicroSlop DTC
I've seen this happen with older versions of the sqlnet client (Different application, same symptom). What version of the client are you using? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: MicroSlop DTC 07/14/2003 11:19 AM Please respond to ORACLE-L To All, especially any WEB developers out there. We've a WEB based application that uses MS DTC. OK, so we turned on XA in the database, but the web servers do not want to play with our normal ONmase setup. Instead they only want to work with a TNSNAMES.ORA file in the appriopriate place. I've been all over MicroSlop Technet and Metalink as well as several other IIS sites with no results. Therefore anyone know why this is?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: MicroSlop DTC
Hum, does tnsping resolve the service correctly? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: RE: MicroSlop DTC 07/14/2003 12:44 PM Please respond to ORACLE-L 9.2.0.1.0 On Win 2K. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, July 14, 2003 1:54 PM To: Multiple recipients of list ORACLE-L I've seen this happen with older versions of the sqlnet client (Different application, same symptom). What version of the client are you using? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: MicroSlop DTC 07/14/2003 11:19 AM Please respond to ORACLE-L To All, especially any WEB developers out there. We've a WEB based application that uses MS DTC. OK, so we turned on XA in the database, but the web servers do not want to play with our normal ONmase setup. Instead they only want to work with a TNSNAMES.ORA file in the appriopriate place. I've been all over MicroSlop Technet and Metalink as well as several other IIS sites with no results. Therefore anyone know why this is?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: COMMIT's within cursor for loops
Thou Shalt Not Fetch Across Commits was ingrained in me many, many moons ago. It is poor practice and can cause multitudes of problems. Just my 2 cents. YMMV. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] .com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: COMMIT's within cursor for loops .com 06/26/2003 01:49 PM Please respond to ORACLE-L I prefer to create an inner block using BEGIN and END inside the loop. This isolates the DML statements. The COMMIT is issued inside the BEGIN and END block. RWB That allows you to avoid invalidating the cursor established for update? I dont' see how the two are related. You just created an exception block within the cursor loop. Or am i misunderstanding what you are saying here? Regarding the original question commiting within a cursor for loop. It is allowable if you do not create the cursor for update. If you created the cursor using for update, you will not only NOT retain a lock on the record set, you will get an error indicating an invalid cursor. Steve McClure -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 26, 2003 11:45 AM To: Multiple recipients of list ORACLE-L I prefer to create an inner block using BEGIN and END inside the loop. This isolates the DML statements. The COMMIT is issued inside the BEGIN and END block. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] ic.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: COMMIT's within cursor for loops ity.com 06/25/2003 12:40 PM Please respond to ORACLE-L Hi All, Can somebody please clear up some issues about issuing commits during CURSOR FOR LOOPS I have done some research within Metalink and the ORACLE-L FAQ but am still a tad bit confused. Are the following statements regarding cursors TRUE 1. If you issue a commit within a for cursor loop you release all locks regardless of whether you're cursor statement has a FOR UPDATE statement in it or there is a WHERE CURRENT statement within the loop. 2. If you are using OPEN CURSOR...FETCH INTO statements to get the data the same rule applies. Thanks, N. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuala Cullen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Want to BAARF - Recommendations for 10 36G Drive config
Mogens- Can you register me with id 42? It is my age (in a few weeks) and of course the meaning of life, the universe, and everything. Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: Re: Want to BAARF - Recommendations for 10 36G Drive config 06/14/2003 12:59 AM Please respond to ORACLE-L David - I just registered you as Party member # 30. You obviously have the right attitudes :-). Mogens Dave Phillips wrote: A client runs our app with the following layout. Since their intial 6 drive config they have procured more drives for a total of 10 36Gig Drives. They have also upgraded memory from 1 to 4 gig. I have the opportunity to recommend changes to the current structure to improve performance. So, any recommendations from the BAARF committee are welcome. Current System Ora 8.1.7 Win 2k Size 30Gig Logical Array 1 - Raid 1 - OS and Oracle Logical Array 2 - Raid 1 - App and Index TS Logical Array 3 - Raid 5 - The rest (Data,Rbs,redo,etc) David Phillips Support DBA BAARF member wanna-be -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Upgradation Question on APPS 11i
There are major tech stack and schema differences between 11.5.4 and 11.5.8. All I can say is follow the maintainence pack release notes and pull all the info you can from metalink. Depending on the size of your installation, plan on at least a two day effort, more if you have multiple languages installed, a UTF8 character set database, on a Windows platoform, etc. Never do this on a production system without performing this migration on a test instance (on a separate server) several (many) times. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] itworks.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: Upgradation Question on APPS 11i com 06/12/2003 09:34 AM Please respond to ORACLE-L Oh...God...any other short 'n' sweet's r there. Senthil -Original Message- Ganesh Raja Sent: Wednesday, June 11, 2003 10:39 PM To: Multiple recipients of list ORACLE-L It is a Big Procedure ;) Sorry ... Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- Senthil Kumar D Sent: Wednesday, June 11, 2003 7:00 PM To: Multiple recipients of list ORACLE-L Dear Group, One of our customer is using apps 11.5.4 on WIN2K. For a demo, they wanted to upgrade to 11.5.5, then 11.5.8. How do I do that in a short way. In the metalink doc's they are giving a big procedure. Any help??? TIA Senthil -Original Message- Gogala Sent: Saturday, May 31, 2003 9:30 AM To: Multiple recipients of list ORACLE-L Oracle 13? Probably nicknamed something like Jason is back version? It would be appropriate to have such a presentation on Friday the 13th. On 2003.05.30 23:09 Babette Turner-Underwood wrote: Don't worry about the lid being off of 10i. We will be doing an overview presentation of Oracle 13 this fall at the local user group. :-) - Babette -Original Message- Thomas F Sent: Friday, May 30, 2003 9:05 AM To: Multiple recipients of list ORACLE-L who promoted you to traffic cop? this is the only way I'm able to hear about the new green gui button. -Original Message- Sent: Thursday, May 29, 2003 5:10 PM To: Multiple recipients of list ORACLE-L OK everyone. Traffic cop time. Everyone that is a beta partner for 10i MUST KEEP THEIR MOUTH SHUT. Don't get anyone in trouble, please. We as partners pushed Oracle for these beta programs. Conversations like this only hurt the process. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- Sent:Thursday, May 29, 2003 11:55 AM To:Multiple recipients of list ORACLE-L Subject: 10i Got my first look at the 10i beta last night. I can't tell you much about it except to say
Re: Oracle 9IAS
Are you trying to install on a P4 system? If so, check metalink for installer crashes on P4 systems. It's a symjit.dll issue. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] do To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Oracle 9IAS 05/31/2003 02:19 PM Please respond to ORACLE-L Hi list, I'm trying to install 9IAS 1.0.2.2 in a W2000 SP3 but nothing comes up when clicking the setup button. Checked in metalink and nothing related to it. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 10i
TEASE! Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: 10i 05/29/2003 09:54 AM Please respond to ORACLE-L Got my first look at the 10i beta last night. I can't tell you much about it except to say that looking at some of the new stuff h ;-) While I'm certain many of the new features will not work perfectly for several releases afterwards, they look very cool! RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: would imp speed affect by setting indexes to NOLOGGING?
Have you considered dropping the indexes before import, then rebuilding parallel nologging? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: would imp speed affect by setting indexes to NOLOGGING? 05/27/2003 11:19 AM Please respond to ORACLE-L Hi, Would the imp speed increase by setting all indexes to NOLOGGING? I have a schema with 249 tables and 442 indexes and I have a weekly schema refresh program running as this: exp schema from Server A (Oracle 8173 on Sun Solaris box) ftp dump file from Server A to Server B, the dump file size is 1.9GB after compression imp schema on Server B (also Oracle 8173 on Sun Solaris box), the imp usually take about 7 hours. With everything elase the same, last week I changed all indexes in the schema on Server A to NOLOGGING (they were all set to logging before), hoping to increase the speed of imp on Server B. Because I thought the create index ... nologging would reduce redo log writing, therefore increase the imp speed quite a bit (there are some big indexes there!). But this morning I found the imp still took about the same time as before, although I was told that the system I/O seems to be lower. Does anyone have similar experience? TIA. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: gmei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 full table scan
Did you look at them... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] .com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: oracle full table scan 04/03/2003 02:08 PM Please respond to ORACLE-L I got the attachments... --- [EMAIL PROTECTED] wrote: Sorry, the attachments didn't make it, though they were only text. I can put them some accessible via the web if anyone wants them. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/03/2003 11:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: oracle full table scan If you can change it to an IOT, it may be beneficial. There's no blanket clause to be used that says 'Always do this'. I higly encourage folks on this list to setup and use the run_stats method of comparing different access methods. This is something Tom Kyte put together. It is very simple to use. URL: http://osi.oracle.com/~tkyte/runstats.html I've attached my versions of the scripts for your convenience. You can use these to easily compare unindexed vs indexed reads on small tables, indexed vs IOT, etc. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/03/2003 10:05 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: oracle full table scan Thanks Jared, What if my developer is selecting all or most of the records from the table and not all the columns in the select list are in the index that should have been used? I understand your point, in fact to use Jonathan's words .. should a small lookup table BE an index (IOT)? ... I am testing this approach here and have found some performance benefit out of it. Cheers Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, April 03, 2003 1:01 PM To: [EMAIL PROTECTED] Cc: Jamadagni, Rajendra Importance: High Raj, Indexing small tables is a good thing if you are doing single row lookups. An index read and lookup by rowid is much more scalable than doing an FTS, even if the table is only 2 blocks. Jared The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists
RE: Large Export Problem ......
I go even one step further here. Each object is required to have it's own creation script. A package will have two scripts, one for the header and one for the body. Also the script name has the package revision included in it as well. For example: hyp_packages.115.00.sql hyp_packageb.115.00.sql hyp_packageb.115.01.sql etc... This makes reverting code and tracking changes much easier. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] .org To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Large Export Problem .. 03/26/2003 11:39 AM Please respond to ORACLE-L Babu, It may not be THE correct answer but I keep all of the packages created by the development community on a disk as the txt or sql statemants used to create them. It helps to have them handy when they need to be modified because of a table structure change, etc. I just give them back to the deveopers to fix and then I recompile on the production server. Also it help to keep them up to date as we are currently migration to a newer version of Oracle while changing the structure of some tables. With the current sql used to create the package that was distroyed you can recreate it easily. Ron [EMAIL PROTECTED] 03/25/03 07:33PM Thanks for the caution. Does any one know if I export with owner=schema Name rows=N, then drop a package and import from the export file with IGNORE=N (which is default), will it restore the dropped package and error out on all other objects as they are already exist? Is this the right way of restoring the dropped package or will it have any problems? There are plenty of the tables in the database and error list will be too long in this case. Any side effects? or Is there any other way to import a dropped pakage? A little bit uncomfortable seeing big error list for restoring one package. Any ideas or will I have to live with this in case the need arises? Iam afraid of any side effects. --Babu -Original Message- Sent: Tuesday, March 25, 2003 3:54 PM To: Multiple recipients of list ORACLE-L The problem with direct=y is that imports done from these dumps are then very version dependent. Jared Govindan K [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/25/2003 02:49 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Large Export Problem .. Babu Why not try 'direct=y' option. This has limitations regarding the platform. Not 100% sure of it. Check with Documentation. It does export very fast. HTH GovindanK --- Janardhana Babu Donga [EMAIL PROTECTED] wrote: Dear List, I have a large unarchived decission support database of size 270gig. We do take coldbackup of database files every sunday. We also take export backup to suplement the coldbackup. Export is taking too much time which we can't afford now. I need to reduce the export time to fit the weekend schedule. In the last few weeks it is failing as the database is down for coldbackups while the export is running. The database structure is as follows: Partitioned tables size
RE: Large Export Problem ......
FWIR, CVS doesn't handle binaries tho. We do the same thing for rdf's (report files) and fmb's (forms files) too. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] ys.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Large Export Problem .. 03/26/2003 12:48 PM Please respond to ORACLE-L I like RCS for this. Any version you need can be retrieved. If a large number of packages are used for an app, you could take it a step further and use CVS. This would allow app level releases as well. Jared Ron Thomas [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/26/2003 11:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Large Export Problem .. I go even one step further here. Each object is required to have it's own creation script. A package will have two scripts, one for the header and one for the body. Also the script name has the package revision included in it as well. For example: hyp_packages.115.00.sql hyp_packageb.115.00.sql hyp_packageb.115.01.sql etc... This makes reverting code and tracking changes much easier. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] .org To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Large Export Problem .. 03/26/2003 11:39 AM Please respond to ORACLE-L Babu, It may not be THE correct answer but I keep all of the packages created by the development community on a disk as the txt or sql statemants used to create them. It helps to have them handy when they need to be modified because of a table structure change, etc. I just give them back to the deveopers to fix and then I recompile on the production server. Also it help to keep them up to date as we are currently migration to a newer version of Oracle while changing the structure of some tables. With the current sql used to create the package that was distroyed you can recreate it easily. Ron [EMAIL PROTECTED] 03/25/03 07:33PM Thanks for the caution. Does any one know if I export with owner=schema Name rows=N, then drop a package and import from the export file with IGNORE=N (which is default), will it restore the dropped package and error out on all other objects as they are already exist? Is this the right way of restoring the dropped package or will it have any problems? There are plenty of the tables in the database and error list will be too long in this case. Any side effects? or Is there any other way to import a dropped pakage? A little bit uncomfortable seeing big error list for restoring one package. Any ideas or will I have to live with this in case the need arises? Iam afraid of any side effects. --Babu -Original Message- Sent: Tuesday, March 25, 2003 3:54 PM To: Multiple recipients
Re: Autoallocate (was Re: LMT monitoring)
Which is followed by: Absolute power corrupts absolutely. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] emon.co.uk To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Autoallocate (was Re: LMT monitoring) 03/17/2003 01:28 PM Please respond to ORACLE-L No.. that should be: With great power comes great responsibility. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Now available One-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___April 8th UK___April 22nd Denmark May 21-23rd USA_(FL)_May 2nd Next dates for the 3-day seminar: (see http://www.jlcomp.demon.co.uk/seminar.html ) UK_(Manchester)_May USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: 17 March 2003 19:34 With power comes complexity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: can't create database
Another reason to have a unique oracle ID/home for each instance. It makes this much easier... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] ys.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: can't create database 03/12/2003 01:44 PM Please respond to ORACLE-L I run into this every time I stop 9.2 on Linux. No need to reboot. Just use ipcrm to remove the offending SHM segments. If you don't know which ones, use ORADEBUG to find the segments you shouldn't remove from other running databases. Or just shutdown all instances and remove any SHM owned by Oracle. Probably a bug, but I haven't checked into it yet. Jared Boyle Candi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/12/2003 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: can't create database I've had this problem on linux. Best and fastest solution: reboot the server. There is a memory issue preventing you from starting oracle. I just had it happen about 2 minutes ago on an upgrade to 9i. Reboot, and now I can start the db. -Candi On Wed, 2003-03-12 at 12:07, Schwerdtfeger, Christoph wrote: Am Mit, 2003-03-12 um 17.20 schrieb Ray Stell: On Wed, Mar 12, 2003 at 07:19:53AM -0800, Schwerdtfeger, Christoph wrote: Am Mit, 2003-03-12 um 10.28 schrieb Christoph Schwerdtfeger: Am Die, 2003-03-11 um 19.47 schrieb Alan Davey: I had the same error message on NT with Oracle 9.2 recently. The first problem was that the init_sid.ora file was created a directory different from where the db create scripts were looking for it. The second problem was that one of the init parameters was for Enterprise Edition and I was installing Standard Edition. Both problems resulted in the message of 'not connected to oracle'. Come to think of it, I don't think I've ever had a version of the DB Creation wizard work without getting some error. -- Alan Davey [EMAIL PROTECTED] 718-482-4200 x106 -- 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: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
RE: LMT monitoring
Was this a fresh tablespace or were there swiss cheese holes available to fill? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] t.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: LMT monitoring 03/10/2003 02:02 PM Please respond to ORACLE-L As mydata load continues, the saga continues. The simplistic algorithm does not hold Can anyone explain these results? PARTITION_NAME EXTENT_ID BYTES/1024 BYTES/1024/1024 -- -- -- --- FINS_FM_DATA_CLOSED_200207 84 6144 6 FINS_FM_DATA_CLOSED_200207 85 5120 5 FINS_FM_DATA_CLOSED_200207 86 6144 6 FINS_FM_DATA_CLOSED_200207 87 5120 5 FINS_FM_DATA_CLOSED_200207 88 5120 5 FINS_FM_DATA_CLOSED_200207 89 4096 4 FINS_FM_DATA_CLOSED_200207 90 5120 5 FINS_FM_DATA_CLOSED_200207 91 4096 4 FINS_FM_DATA_CLOSED_200207 92 4096 4 FINS_FM_DATA_CLOSED_200207 93 4096 4 FINS_FM_DATA_CLOSED_200207 94 4096 4 FINS_FM_DATA_CLOSED_200207 95 3072 3 FINS_FM_DATA_CLOSED_200207 96 4096 4 FINS_FM_DATA_CLOSED_200207 97 3072 3 FINS_FM_DATA_CLOSED_200207 98 3072 3 FINS_FM_DATA_CLOSED_200207 99 3072 3 FINS_FM_DATA_CLOSED_200207100 3072 3 FINS_FM_DATA_CLOSED_200207101 3072 3 FINS_FM_DATA_CLOSED_200207102 3072 3 FINS_FM_DATA_CLOSED_200207103 3072 3 FINS_FM_DATA_CLOSED_200207104 3072 3 FINS_FM_DATA_CLOSED_200207105 3072 3 FINS_FM_DATA_CLOSED_200207106 3072 3 FINS_FM_DATA_CLOSED_200207107 3072 3 FINS_FM_DATA_CLOSED_200207108 3072 3 FINS_FM_DATA_CLOSED_200207109 3072 3 FINS_FM_DATA_CLOSED_200207110 3072 3 FINS_FM_DATA_CLOSED_200207111 2048 2 FINS_FM_DATA_CLOSED_200207112 2048 2 FINS_FM_DATA_CLOSED_200207113 2048 2 FINS_FM_DATA_CLOSED_200207114 2048 2 FINS_FM_DATA_CLOSED_200207115 2048 2 -Original Message- Sent: Monday, March 10, 2003 3:36 PM To: '[EMAIL PROTECTED]' According to a good email from Dan Fink (which I've since checked to 83 extents), the size of the extents is based soley on extent counts #extents next extent size 1-1564k 16-79 1m 80
Re: shared tnsnames.ora
Nope. namectl, names, et al binaries are still there and functional at 9.2 Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] et To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: shared tnsnames.ora 03/03/2003 11:04 AM Please respond to ORACLE-L My understanding was that ONAMES was removed from 9i and that they provided some sort of wrapper that goes around OID to make it look like a names server until you can covert all your clients. Can anyone confirm? I am not running 9i on any of my servers yet. -- Chuck - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 03, 2003 11:54 AM hello to everybody we tried oracle OID. it works fine. check it out, it's worthwhile. btw.:afaik oracle names is deprecated and will be withdrawn (... ok somewhen). pls fogive if i'm wrong about that, but i read it somewhere in the docu that comens with 9i. Apologies for any typing mistakes I failed to notice. Markus Reger Oracle Applications DBA Webmaster MBC University for Music and Performing Art Vienna [EMAIL PROTECTED] 02/27/03 21:48 PM I am looking for info on how you support a large number of PCs (200+) and keep each ones tnsnames.ora file in sync. It seems that most people do not touch them. Some try to modify them and when new databases are created, the tnsnames.ora files must be changes as well. It seems to be that a shared tnsnames.ora file on a network drive may work. I remember a thread awhile back about the order of resolution (home directory, then OH/network/admin .). Again, I am asking about people using the Oracle client to connect to 15+ databases (v7.3.4 - 9.0.x) on 10+ different servers. I have just started to think about this and posted here before I started my MetaLink search. TIA for any info. JF John Fedock K Line America, Inc. www.kline.com * 804.327. * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want
Re: Import Problem
If all you need is tty (character based), then screen should work. If you need a full GUI environment, then check out vnc. I use this alot for those 5 hour Oracle Application Installs. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] ys.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Import Problem 03/03/2003 02:14 PM Please respond to ORACLE-L Scott, Try using screen. It is a piece of software using virtual tty 's. I began using it in 1994 to avoid just such problems. It gives you some unique capabilities. Start a process from one client, goto another client, detach and re-attach there. eg. start a job at home in a terminal window, goto work, and attach the screen there. And since it is running on the server itself, losing the network connection, your PC crashing, etc, does not interrupt your job. It is installed by default on some versions of Linux. http://www.gnu.org/directory/GNU/screen.html HTH Jared Scott Canaan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/03/2003 09:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Import Problem I ran into a problem yesterday afternoon. I had exported a production database, via a full database export, and ftp'd it to another machine to import it there and make that the new production machine. It was a long import (about 8 hours) and about 2/3 through it, my network connection was dropped. I was running it in a ssh shell. When the connection disappeared, the import died. Since I had to get the job done by morning, I chose to drop the database, rebuild it, then re-import. That worked. What I am wondering is: Is there a way to resume an import, once it has been interrupted? I have been looking in metalink and on the net and haven't found anything that says how to do it. I tried technet, but it was way too slow. Any thoughts would be greatly appreciated. Thank you, -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Re: shared tnsnames.ora
Use Oracle Names. Easy to setup/maintain. never touch a client config again. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] ine.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: shared tnsnames.ora 02/27/2003 12:56 PM Please respond to ORACLE-L I am looking for info on how you support a large number of PCs (200+) and keep each ones tnsnames.ora file in sync. It seems that most people do not touch them. Some try to modify them and when new databases are created, the tnsnames.ora files must be changes as well. It seems to be that a shared tnsnames.ora file on a network drive may work. I remember a thread awhile back about the order of resolution (home directory, then OH/network/admin .). Again, I am asking about people using the Oracle client to connect to 15+ databases (v7.3.4 - 9.0.x) on 10+ different servers. I have just started to think about this and posted here before I started my MetaLink search. TIA for any info. JF John Fedock K Line America, Inc. www.kline.com ( 804.327. * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Upgrading from 8.1.5 to 8.1.6
OK, I'll make one comment: If this is unix, bounce all oracle services after you rename the directory. Unix has a habit of tracking the file/directory moves if the inode does not change. In other words, if a file is open when you move it, the process will merrily keep accessing the moved file until the file handle is closed. Been bit by this once or twice. Moved a couple of directories around and a month later bounced the services. Went Oh S... when things didn't come back up. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: RE: Upgrading from 8.1.5 to 8.1.6 02/24/2003 01:54 PM Please respond to ORACLE-L What we do is rename the 8.1.5 directory to indicate it is the old directory (i.e, 8.1.5_old). If nothing breaks after a week or two, then the directory and its contents are removed. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Monday, February 24, 2003 9:34 AM To: Multiple recipients of list ORACLE-L After upgrading oracle database from V8.1.5 to V8.1.6, a new directory is created to store new version's files and the old directory of old version 8.1.5 is still there. Is is safe to remove the old directory to save disk spaces on the disk? Is there any files being linked to the old version after upgrading? Regards, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
RE: Oracle Names Server 8.1.7 on HP 11
I'd also add that we had nothing but problems with names on HP prior to version 8.1.7.4. Versions 8.1.7.4 and 9.2.0.2 have worked flawlessly. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan john.kanagaraj@hd s.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Oracle Names Server 8.1.7 on HP 11 02/20/2003 12:19 PM Please respond to ORACLE-L Zabair, In addition to the excellent replies you have recieved, be aware that the Name Server will keep an open connection to the Repository, but will check the local cache (in the names directory) to resolve any queries. (Performing a DB query for every name resolution can be expensive!) I have had situations where both our nameservers (no ddo, both on Solaris, 8.1.7) lost connection to the repository (due to DB going down) and the NS continued to work. if you restart them and they cannot find the repository, they will use the caches. Of course, you should build monitoring scripts that check both the repository as well as response from the NS for highly available servers. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 I don't know what the future holds for me, but I do know who holds my future! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Thursday, February 20, 2003 10:39 AM To: Multiple recipients of list ORACLE-L You may also want to add these 2 parameters to your sqlnet.ora. Speeds up the switch to another nameserver. NAMES.INITIAL_RETRY_TIMEOUT = 5 # Wait num seconds before going to next nameserver, default=15 NAMES.REQUEST_RETRIES = 2 # Number of retries for nameserver, default=5 Gene [EMAIL PROTECTED] 02/20/03 12:19PM We've currently got Names Server running on 4 host boxes. If one Names server is down, the client is configured to automatically attempt to connect to the next one in the list. We had a problem recently were, if we issued a tnsping from any of the clients we got the following message. TNS-03505 - Failed to resolve name This implies that our client PC is unable to resolve the name and hence was not able to connect to the database. Usually this implies that something is wrong with all our Oracle Names servers. Inorder to resolve this problem, I had to kill the Names Server on each of the 4 boxes and restart it. The Names servers had somehow lost connection to the Oracle Names repository database, although the servers appear to be attached to the database. I reckon we can reduce the chances of this problem occuring again, by adding a second Oracle Names database repository in our database cluster. This means, that if the NAMES servers lose connection to one repository, they can fall back on the second database without any loss of service. What have other people done with their Names Server and respository and do they see any draw backs with the above. Sorry for the long email. TIA _ http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_storag e.html With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs -- Please see the official ORACLE-L FAQ: http
Re: slow update and db trigger
It could also be a dynamic recompile issue. Make sure the triggers and proc. are valid before each test. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan mrichard@transurb an.com.auTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: slow update and db trigger 02/19/2003 05:28 PM Please respond to ORACLE-L It sounds like the triggers / procedures may have different logic depending on the row being updated. Or possibly the same logic results in a large number of rows being queried / modified by one of the procedures. Have you looked at the trigger and procedures to understand what they are doing? There may be opportunities to tune them. Perhaps you could trace the session to see what is happening, but it might be easier to look at the code. Regards, Mark. Basavaraja, Ravindra Ravindra.Basavaraja@T-M To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] obile.com cc: Sent by: Subject: slow update and db trigger [EMAIL PROTECTED] 20/02/2003 10:41 Please respond to ORACLE-L I have an update statement executed by a procedure.This update statements fires a trigger which has a set of update statements and also executes 2 procedures. If i execute the parent update statement which will affect a single row from a table which has significantly less number of rows.This statement sometimes is executed very fast and sometimes it takes upto 50 seconds.Does this slowness got to do anything with the triggers that get fired automatically .For me this update is a single piece of transaction.Why do i see the delay in this update statements. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business
Re: Programming languages that make DBA's lives easier
Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Programming languages that make DBA's lives easier 02/18/2003 09:56 AM Please respond to ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
No offense taken. Depending on the shop, java may be more critical than perl. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Paula_Stankus@doh. state.fl.us To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Programming languages that make DBA's lives easier 02/18/2003 01:23 PM Please respond to ORACLE-L No offense but I have noticed in the various Unix/Oracle shops I have worked that more sys. admins. and Unix types knew korn shell prog. and Java then Perl. -Original Message- Sent: Tuesday, February 18, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Programming languages that make DBA's lives easier 02/18/2003 09:56 AM Please respond to ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 oracle homes
That is why each oracle home has its own oraInventory directory. I have 10 different instances across 2 machines. Each instance has its own user id and group. There have been no problems at all with this setup for 8.1.7.4 and 9.2.0 Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] edu To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: multiple oracle homes 02/07/2003 01:49 PM Please respond to ORACLE-L maybe multi-user oracle homes would be a problem for stuff that's in oracle base such as the inventory. during an install/upgrade this common data needs to be updated. i suppose i would work ok if u were careful with permissions, but it would be just one more thing to go wrong. thanks, steve Ray Stell [EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject:Re: multiple oracle homes 02/07/2003 01:19 PM Please respond to ORACLE-L On Fri, Feb 07, 2003 at 07:54:24AM -0800, DENNIS WILLIAMS wrote: Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had a bad experience :-) Would you mind expanding on that, other people say the multiple userid idea works for them. They may be surprised one day, I can imagine. I can imagine blowing one's foot off the other way, also. Thanks. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from
Re: OT: unix script quetion: to replace $ with \$
Problem here is that sed treats $ as a special characer meaning end of line as well as the korn shell meaning variable replacement. To avoid the shell evaluation, use ' not . to avoid the sed special charater, escape it. echo '123$45$678' | sed 's/\$/\\\$/g' Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: OT: unix script quetion: to replace $ with \$ 02/03/2003 11:39 AM Please respond to ORACLE-L Hi: I have a quick question about replacing $ with \$ on unix. I need to convert string 123$45$678 to 123\$45\$678 through a pipe. I tried with sed command, but could not get it to work: essex$ echo 123$45$678 | sed s/$/\$/g 123578$ essex$ echo 123$45$678 | sed s/$/\\$/g 123578$ Maybe there is another syntax that I should use? TIA. Guang Mei _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: fnd_global user_id
This package is auth current user. You will need to either run this as APPS or place an auth definer package around it. Off to get my first pot of coffee... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Sony@polyfincangg ih.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: fnd_global user_id 01/09/2003 06:08 PM Please respond to ORACLE-L Check your previllege ! -Original Message- From:Kader Ben [SMTP:[EMAIL PROTECTED]] Sent:Friday, January 10, 2003 5:56 AM To:Multiple recipients of list ORACLE-L Subject: fnd_global user_id Hi Listers, I'm running concurrent program to create user (that's call fnd_user_pkg.CreateUser procedure) on 11i but the program fails because the fnd_global.user_id return -1! Can someone help me how resolve this problem? Thanks you so much, Ben __ 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.net -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 issue with setting transaction
Any commits in the script that you run? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] mTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: strange issue with setting transaction 01/03/2003 12:49 PM Please respond to ORACLE-L I am running 8.1.6 on solaris 2.8. Before running a large update, I tried to set a specific rollback segment by: Set transaction use rollback segment RBIG20; The transaction runs for a while and fails with: ORA-01555: snapshot too old: rollback segment number 29 with name R27 too Small Any idea? Thank you Sergei -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sergei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Application Server on .net
Metalink shows certification only for Oracle Server 9.2 on .net, so keep spinning those wheels... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan barbarabbaker@yah oo.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Oracle Application Server on .net 12/17/2002 04:34 PM Please respond to ORACLE-L List: I have a developer trying to install Oracle9i Application Server Release 2 (9.0.3) on a .net server. He's using the install disk for Windows NT and 2000. Needless to say, it gives him an error and throws up. He considers .net just another operating system like np or 2000. I think of it more like a competitor for OAS. At any rate, I can't find any mention of .net on either Metalink or OTN (except how much better OAS is than .net) Does anyone know if Oracle has an application server installation for .net? If so, do you know how I might get it? Is this a silly question? Should I be hanging my head in shame?? Thanks in advance for any information. Barb Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Help Urgent Where is Tablespace Manager??
For those that require a GUI interface, look into Tora. Runs very nicely on linux, and I believe there is a Winders version too. BTW, yes I am a command line guy, but sometimes the boss wants to see pretty pictures. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Paula_Stankus@doh. state.fl.us To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Help Urgent Where is Tablespace Manager?? 12/10/2002 10:19 AM Please respond to ORACLE-L Back to my roots. -Original Message- Sent: Tuesday, December 10, 2002 10:40 AM To: Multiple recipients of list ORACLE-L We stopped using it for the same reasons, plus the fact that we had multiple Oracle Homes on our cluster - which confused OEM. Where is tablespace manager - just type sqlplus Jay [EMAIL PROTECTED] 12/10/02 09:04AM Paula, I am using DBA Studio as a stand-alone product - not using the OMS service part of the product. I gave up on that because it could not discover all of the databases at my current site. We tried to figure out why it didn't work but gave up when I started looking at the network/firewall issues we have here. We also use either Cron or Maestro to schedule all of the backup jobs. Soo, what did that leave for OEM to do? It ended up being just another software product to support that was just not worth the effort to get to work properly. So, we don't use it. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 10, 2002 7:54 AM To: Multiple recipients of list ORACLE-L Well I installed Version 2.2 of OEM and 9i OEM until I can figure this out in separate homes. I understand that some of the functionality (from Metalink threads) seems to have been gone and that there is issues about which version of OEM and support which version of database and how well the newest version of OEM works in some basic functionality (like discovering services). So has everyone stopped using OEM? -Original Message- Sent: Monday, December 09, 2002 10:11 AM To: '[EMAIL PROTECTED]' This is driving me crazy. Can't seem to find the tablespace manager which I used to pull up from DBA Studio - now I have a different version which doesn't have DBA Studio - where has it been moved or is there a replacement? Help! **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: SLA Trigger/Procedure
Yes, but can I get it signed... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Jared.Still@radis ys.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: SLA Trigger/Procedure 12/03/2002 10:34 AM Please respond to ORACLE-L Ahem... OK, I can not resist any longer. The tools exist: http://www.amazon.com/exec/obidos/tg/detail/-/0596002106 The 'dbup' script logs all connections attempts. Use sed, perl, or whatever to parse the logfile, or modify to create logs more to your liking. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 06:32 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SLA Trigger/Procedure Go buy a tool? Here is an idea instead ... Write a small Perl (pick your favorite language here) script that looks at /etc/oratab followed by a check to see if each of the instances listed in /etc/oratab is up on the side where it is checking. It then log in as a schema (we call it) called heartbeat, insert a row into a table with sysdate. Wait 3 seconds, retrieve the row and checks the time difference. If it is more than 5 seconds, you have a potential delay somewhere and have it alert appropriate people. (If it is night, page your VP with This is your heartbeat calling ... we have a problem ...) Life is great with cron ... HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! (See attached file: ESPN_Disclaimer.txt) ESPN_Disclaimer.txt Description: Binary data
RE: ORA-1653: unable to extend table - Why?
Hum. My last thought would are there triggers or snapshots defined on the table? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/03/2002 08:18 AM Please respond to ORACLE-L Ron, Good idea, but DEGREE=1 There are two indexes, but they are in a different tablespace (which has plenty of free space available and did not give an error). Next extent size is 25M but, as mentioned, it shouldn't have needed a new extent. I'm still at a loss... Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when pctincrease != 0, or has that changed? My understand could be outdated. With LMT one doesn't have to worry about it. Have a Happy Thanksgiving. PS, I am in New York too, would love to meet you
RE: ORA-1653: unable to extend table - Why?
One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when pctincrease != 0, or has that changed? My understand could be outdated. With LMT one doesn't have to worry about it. Have a Happy Thanksgiving. PS, I am in New York too, would love to meet you in person some time. Have you talked to Priscilla lately? Richard Ji -Original Message- Sent: Friday, November 29, 2002 5:29 PM To: Multiple recipients of list ORACLE-L how would coalescing help even if there were a lot of smaller free extents? Oracle would do the coalesce automatically, there would be no difference between manually coalescing or allowing Oracle to do it when a new extent was needed. --- Richard Ji [EMAIL PROTECTED] wrote: Coalescing might help if there are many smaller free extents that can be coalesced. But that still doesn't solve Jay's problem. Because he doesn't want the table to extent at all since he just deleted 2 million rows so there are plenty of space within the segment itself. Those free blocks should be used, unless he is doing a direct path insert which will only use space above the HWM. Richard Ji -Original Message- Sent: Friday, November 29, 2002 2:05 PM To: Multiple recipients of list ORACLE
Re: What is wrong with this package? Pls. help
Easy one. The function declaration does not match between the spec and the body. function check_OK (n1 in number) function check_ok (nn in number) Argument names must be the same. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To: [EMAIL PROTECTED] 10/21/2002 01:43 cc: PM Subject: What is wrong with this package? Pls. help Please respond to ORACLE-L When we compile this package body, we are getting the error - PLS - 00323. Please help. Platform: Solaris 7. Oracle 8.1.6. Package is getting created without any errors. When we try to compile package body we are getting the error 3/12 PLS-00323: subprogram or cursor 'CHECK_OK' is declared in a package specification and must be defined in the package body Package: CREATE OR REPLACE PACKAGE P1 is msg_g number(3); function check_OK (n1 in number) return number; procedure test; end p1; create or replace package body p1 as function check_ok (nn in number) return number IS KK number; BEGIN KK := msg_g * nn; return KK; end check_ok; procedure test as v1 number; begin null; end test; end p1; / Thanks, Rao -- 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: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cache hit ratio?
There is a script available (search the archives) that will set the ratio to anything you want... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To: [EMAIL PROTECTED] 10/09/02 02:13 PMcc: Please respond toSubject: Cache hit ratio? ORACLE-L Hi One of my database Cache Hit Ratio is low.I adjusted db_block_buffer and I have noticed after week again cache hit ratio became low. Can u please suggest what other things I can do to fix this problem? Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reports
make sure you also copy a good sqlnet.ora file. This file has you default domain, etc. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To: [EMAIL PROTECTED] 10/08/02 10:33 AMcc: Please respond toSubject: Reports ORACLE-L I don't work with Oracle Reports but one of my co-workers does. His problem --- TNS can't find the database. He has three Oracle homes. I've copied the good tnsnames.ora to all of his homes (I know about the NETWORK and NET80 directories). It's Report 6i on a Win2K machine trying to connect to an 8.1.6 Oracle. He has Reports 6i installed on two of his Oracle homes and Reports 6.0 on the other. Don't ask me why --- I don't know. I used the Oracle home changer and cycled through all 3 homes. The error is ORA-12154: TNS could not resolve service name. Is there anything special about having multiple copies of Reports on Win2K? Thanks (IA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to retrieve numeric values only from a varchar2?
You don't need the ltrim if you use to_char( i, 'FM099') Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To: [EMAIL PROTECTED] 10/07/02 03:38 AMcc: Please respond toSubject: RE: how to retrieve numeric values only from a varchar2? ORACLE-L I think if you try ltrim(to_char(i,'099')); it will remove a leading blank. There is I'm sure a way of doing it explicitly with the format of the to_char but I can't remember what it is. Iain Nicoll -Original Message- Sent: Monday, October 07, 2002 10:13 AM To: Multiple recipients of list ORACLE-L Hi, Can anyone point me in the right direction. In my table I have a varchar2 column that contains a label that could be either text or numeric data. I need to update another column in the same table based only on the rows in the first column that are numeric. The values are in the range 001 to 999 only. I have tried the following piece of pl/sql, unsuccessfully declare begin for i in 1..999 loop update tdcr set features=db_connect.e_features(132) where label = to_char(i,'099'); end loop; end; / Would anyone be able to tell me where I am going wrong or suggest an efficient piece of sql to perform the task. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicoll, Iain \(Calanais\) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: logon trigger
FWIW, do not place the terminating semicolon in the execute string, ie, begin execute immediate 'Alter session set OPTIMIZER_MODE = choose' ; end ; / Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To: [EMAIL PROTECTED] 10/03/02 02:43 AMcc: Please respond toSubject: RE: logon trigger ORACLE-L Hi all Ok if I execute these commands/SQL in sqlplus it works. When I add to the trigger for after logon it does not work. I get the feeling it is only valid for the current block, begin - End. Any ideas to work around this. grant alter session to smload; drop trigger olap_logon_trigger; create or replace trigger olapl_logon_trigger after logon on smload.schema begin execute immediate 'Alter session enable parallel query;'; execute immediate 'Alter session set SORT_AREA_SIZE = 10485760;'; execute immediate 'Alter session set OPTIMIZER_MODE = choose;'; execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;'; execute immediate 'SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;'; end; / George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- From: George Leonard (ZA) [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 09:03 AM To: Multiple recipients of list ORACLE-L Subject: RE: logon trigger Thx, I also found this last night. I will wait for the developers so arrive so that they can test their process. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: 02 October 2002 19:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: logon trigger Altering current_schema, you will not see anything in user_tables, but you should be able to reference tables in this new schema without using siebel prefix. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: George Leonard (ZA) To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 02, 2002 12:18 PM Subject: RE: logon trigger Hi all Ok the trigger has been changed to this, It compiles. The problem now is that all the objects that need to be access is owner by the siebel user. I do not want to create synonyms. The tool being used can not append the siebel schema name in front of the objects, and it is expecting to log in as siebel. Any idea why the 'Alter session set CURRENT_SCHEMA = SIEBEL;' is not changing my current schema. I have tried executing Alter session set CURRENT_SCHEMA = SIEBEL; in a standard sqlplus window and then looking at the user_tables table
Re: svrmgrl echo v$database in script
Sounds like you svrmgrl commands are in a where document. You need to escape the $,
ie
select name from v\$database ;
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
10/02/02 04:28 PMcc:
Please respond toSubject: svrmgrl echo v$database in
script
ORACLE-L
Oracle 8.0.5
Solaris 2.6
List:
I've created a script (ksh) called from elsewhere that shuts down the
database. I REALLY want to echo the name of the database into my log file
before I shut down.While select name from v$database works fine from
svrmgrl interactively, it throws up in the script. I'd guess the $ sign is
screwing it up. (I can get other commands to work within the script.)
However, I don't know what to do about it.
Any ideas?
Thx!!!
Barb
$ svrmgrl
SVRMGR connect internal
Connected.
SVRMGR select name from v$database;
NAME
-
TADENT
1 row selected.
#!/usr/bin/ksh
# $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
# Name: stop_db.sh
# Author: Barb Baker
# Purpose: execute shutdown immediate on current database
# (i.e., database pointed to by current value of ORACLE_SID)
echo Stop oracle instance \${ORACLE_SID}\ at `date`
${ORACLE_HOME}/bin/svrmgrl EOF
connect internal
select name from v_$database;
EOF
$ ./stop_db.sh
Stop oracle instance tadent at Wed Oct 2 16:24:59 MDT 2002
SVRMGR Connected.
SVRMGRselect name from v_
*
ORA-00942: table or view does not exist
SVRMGR
Server Manager complete.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Baker, Barbara
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Thomas
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
linux and Oracle Apps jinit
Has anyone found a way to use linux as a client to Oracle Applications? The self service stuff runs just fine but the Oracle Forms requires that damnable jinit. This is the only problem left before I can give MS the big Heave Ho. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Help on Effect of changing NLS_LANGUAGE to maerican_america.utf8
What version of the database? What version of forms/reports? What platform? What is the current characterset of the database? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To: [EMAIL PROTECTED] 09/25/02 10:03 AMcc: Please respond toSubject: Help on Effect of changing NLS_LANGUAGE to ORACLE-L maerican_america.utf8 Hi Gurus We customize pharmaceutical processing industry applications. One of our client is going global. The client needs to change NLS_LANGUAGE setting to NLS_LANG=american_america.utf8. I would like to know how to change this and what impacts will it have on reports and forms already custom developed for this client? There are some barcode checksum calculation procedures for some reports. Will they get impacted by changing the NLS_LANG? A input on this is highly appreciated Regards Shiva Baswannappa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Web forms via PL/SQL
I need to write a pl/sql procedure to produce a form via the pl-sql cartridge. Not a problem- been doing this kinda thing now for a couple of years. Now I need to handle a INPUT TYPE=FILE tag in the form. Anyone know how to process the result via pl/sql or am I going to need to write a cgi script to handle it. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Help on Effect of changing NLS_LANGUAGE to maerican_america.u
the scripts to make table columns long enough and create the new schemas - If you do not have the scripts, export the old database with ROWS=N, import it and use ALTER TABLE to make the necessary length changes - Export the old database with ROWS=Y; make sure to set NLS_LANG to .WE8ISO8859P1 before the export - Import the old database data with IGNORE=Y; make sure the NLS_LANG is still .WE8ISO8859P1 This basic steps may need refinement due to possible non-NLS related issues with full export/import but this would be out of scope of my answer. ## What should be the NLS_LANG , NLS_CHARACTERSET parameters? NLS_CHARACTERSET is the database character set, i.e. it would be UTF8. NLS_LANG would depend on the way you implement multiple language support in your application. See http://otn.oracle.com/tech/globalization/content.html for some interesting white papers. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To: [EMAIL PROTECTED] 09/25/02 01:13 PMcc: Please respond toSubject: RE: Help on Effect of changing NLS_LANGUAGE to ORACLE-L maerican_america.u Sorry Gurus The database version is: 8.1.6.0.0 Reports: 6.0.5.28.0 Forms: 6.0.5.2 Current NLS_LANGUAGE: AMERICAN
Re: dbms_job.remove
dbms_ijob allows you to remove any job. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To: [EMAIL PROTECTED] 09/23/02 02:15 PMcc: Please respond toSubject: dbms_job.remove ORACLE-L Oracle 8.1.7 docs state you have to own a job to remove it. I would like to remove another users job. Is the only way to do by doing the old swap user pw trick? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: PL/SQL help
David- I've thought of both dbms_sql and dummy conditions too. Oracle Application reports use the dummy conditions all the time. I'm off to see if you can set cursor_sharing at the session level and not use bind params. I'm assuming no one else has figured this out either due to the lack of response. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To: [EMAIL PROTECTED] 09/20/02 01:28 AMcc: Please respond toSubject: RE: PL/SQL help ORACLE-L Ron We've run into this problem and haven't really found a satisfactory answer. It sounds like a job for dbms_sql, but the docs say its slower than native dynamic sql. Has anyone tested this? One other alternative I can think of (but have never tried) is to use dummy conditions in the sql; something like: - c_sql := 'select col1 from atable where col2 = :1 and :2 is null and :3 is null'; -- David Lord -Original Message- From: Ron Thomas [mailto:[EMAIL PROTECTED]] Sent: 19 September 2002 19:53 To: Multiple recipients of list ORACLE-L Subject: PL/SQL help I am building a dynamic sql statement which will contain varying number of bind variables depending on user selection criteria. As an example, the sql statement may be: c_sql := 'select col1 from atable where col2 = :1' ; or it may be c_sql := 'select col1 from atable where col2 = :1 and col2 between :2 and :3' ; or it may be ... etc. I am trying to avoid ugly code such as: IF case1 THEN OPEN csr FOR c_sql USING var1 ; ELSIF case2 THEN OPEN csr FOR c_sql USING var1, var2, var3 ; ELSIF . END IF ; Once the sql statement is created, it will be opened/closed multiple times, so I want to use bind variables to avoid parsing. So I thought, hum, sounds like a job for EXECUTE IMMEDIATE, but in the various incarnations I tried, could not get it to work. The FM have not been much help (still looking tho). What am I missing? Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name
RE: How can I change Oracle as well as NT Domain passwords
If you are Oracle Applications 11.5, look at the FNDCPASS utility. This allows you to change application user passwords from the command line. They have also exposed password change functionality in the FND_USER_PK (I think thats the name). You would need to roll your own interface into whatever single sign-on mechanism you use. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To: [EMAIL PROTECTED] 09/20/02 03:33 PMcc: Please respond toSubject: RE: How can I change Oracle as well as NT Domain ORACLE-L passwords Thanks for responding I need to change oracle application user's password from within application. I also need to change same user's W2K/NT domain account password whenever that user changes their password in oracle application. Hope I am clear here. Appreciate your response and Thanks a ton in advance Shiva B --- -Original Message- Sent: Friday, September 20, 2002 4:58 PM To: Multiple recipients of list ORACLE-L Are you trying to change the Oracle and NT Domain accounts which are the same and you want the same password ??? If not, write a script or request that one be sent to you. -Original Message- Sent: Friday, September 20, 2002 10:31 AM To: Multiple recipients of list ORACLE-L Hi All How can I change passwords of a user of Oracle application as well as W2K/NT Login? Any utility in 8/8i can do this form me? Thanks in Advance Shiva B -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baswannappa, Shiva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Baswannappa, Shiva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PL/SQL help
I am building a dynamic sql statement which will contain varying number of bind variables depending on user selection criteria. As an example, the sql statement may be: c_sql := 'select col1 from atable where col2 = :1' ; or it may be c_sql := 'select col1 from atable where col2 = :1 and col2 between :2 and :3' ; or it may be ... etc. I am trying to avoid ugly code such as: IF case1 THEN OPEN csr FOR c_sql USING var1 ; ELSIF case2 THEN OPEN csr FOR c_sql USING var1, var2, var3 ; ELSIF . END IF ; Once the sql statement is created, it will be opened/closed multiple times, so I want to use bind variables to avoid parsing. So I thought, hum, sounds like a job for EXECUTE IMMEDIATE, but in the various incarnations I tried, could not get it to work. The FM have not been much help (still looking tho). What am I missing? Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 controlfile to trace
If you want to do this method without a log file... your_file=$( sqlplus -s EOF | tail -1 / as sysdba oradebug setmypid alter database backup controlfile to trace; oradebug tracefile_name exit EOF ) echo $your_file Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To: [EMAIL PROTECTED] 09/18/02 09:08 AMcc: Please respond toSubject: Re: backup controlfile to trace ORACLE-L Yes, you can certainly do that -- I was just disappointed that the script would have to be a shell script instead of just a sql script. I usually do it without creating an intermediate logfile at all by using ksh's bidirectional pipe feature. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 10:23 AM What about: sqlplus -s EOF logfile / as sysdba oradebug setmypid alter database backup controlfile to trace; oradebug tracefile_name exit EOF your_file=`tail -1 logfile` echo $your_file Regards, Waleed -Original Message- Sent: Tuesday, September 17, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Wow. I had no idea it was so easy! I just tried it out on 8.0.5.1 (svrmgrl) and 8.1.7.2 (SQL*Plus) and it worked like a charm! Only problem is I can't figure out an elegant way to capture that information in a variable so that I can (for example) do: host mv trcfile /backups/ -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 17, 2002 5:03 PM SQL oradebug setmypid Statement processed. SQL alter database backup controlfile to trace; Database altered. SQL oradebug tracefile_name /webstat/oracle/admin/wbs2/udump/wbs2_ora_22958.trc Waleed -Original Message- Sent: Tuesday, September 17, 2002 2:13 PM To: Multiple recipients of list ORACLE-L 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Philip Douglass INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: backup controlfile to trace
Snippet of code I use:
ls -t ${UDUMP} | while read line ; do
${GREP} -q 'CREATE CONTROLFILE' ${UDUMP}/${line}
if [ $? -eq 0 ] ; then
echo Processing file ${ORACLE_SID}.ccf
cp ${UDUMP}/${line} ${ORACLE_SID}.ccf
break
fi
done
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
09/17/02 12:14 PMcc:
Please respond toSubject: RE: backup controlfile to
trace
ORACLE-L
The way we do it is not 100% but it seems close enough. We run the backup
command and then do a descending order listing by date from the trace
directory. The first file is the one containing the trace.
If anyone has a beter idea, I am all ears.
Kevin
-Original Message-
Sent: Tuesday, September 17, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L
8.1.7
For scripting purposes, what is the logic for finding the trc file from
alter database backup controlfile to trace cmd? This seems really
stupid not being able to direct the output.
===
Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ray Stell
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Thomas
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Followup: Apache core dumps after IP address change (solution)
The one thing to learn from all of this is to always bounce your services before performing an upgrade. It's the one thing we tend to forget about in a unix env since this services can be up for extended periods of time. FLAME BAITOf course, those on a windows env bounce more routinely and would have discovered this library mismatch /FLAME BAIT Ron Thomas Hypercom, Inc [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 09/17/02 03:13 PMcc: Please respond toSubject: Followup: Apache core dumps after IP address ORACLE-L change (solution) Thanks to everyone who suggested ideas for my emergency yesterday. The problem only became obvious after a complete reinstall of Oracle on my server. I took this approach after finding a thread on the ODTUG-JAVA-L mailing list that talked about how 9iAS Rel 2 has hardcoded values for the IP address. The thread indicated that there was no way of changing the IP address of a server short of a complete Oracle reinstall. After literally exhausting all other ideas of my own (and needing to get the server back up asap), I reinstalled Oracle 8.1.7 last night on a new partition. Once the default installation finished, everything worked fine. After restoring my schemas and other configurations, things still continued to work fine. Apache continued to start without core dumping and life was good. The moment I moved my old httpd.conf file back into place, Apache core dumped. Clearly, it was no longer an issue of hardcoded IP addresses, so I started taking the httpd.conf file apart into small pieces. The culprit was an upgrade RedHat Network passed along to PHP4 and glibc about a month ago. I allowed the PHP4 upgrade and glibc library upgrades to be installed. Apache continued to run using the old libphp4.so module without problem, but the moment I would have had to either reboot the server or restart Apache, it would have died because the libraries had changed. Adding PHP4, BTW, is a custom enhancement I made to the stock 8.1.7 Apache config as I need it on several parts of my server. I found the latest libphp4.so file, moved it into the /u01/.../libexec directory, restarted Apache and all was well with the world again. 17 hours of work later, I believe I have things as they should be once again. Lesson learned: if Apache core dumps (something I haven't seen it do in years) when restarting after a long period of uptime, then suspect a module/library problem. Side note: if anyone wants to know every nook and cranny where Oracle stores your IP address and domain names, I can tell you that now. :-) Thanks again! bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Migration Assistant Speeds
Also keep in mind that if you use the assistant to go from 7.x to 8.x, the system tablespace will grow at least 2x. During the migration process, both the 7.x and 8.x data dictionary exists. For our Oracle Applications 10.7 instances with 55,000 objects, this was not acceptable. We instead exported/imported. This also gave us the apportunity to move to LMTs. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 09/11/02 10:53 AMcc: Please respond toSubject: Re: Migration Assistant Speeds ORACLE-L Keep in mind that the actual change to DB internal header blocks does not occur until they are actually read into the DB. Therefore I launched an ANALYZE to build statistics which ran 12 - 14 hours. -- I shall go for full export with direct=y recordlength-65535 and file=/dev/null which may be much faster then analyzemay be 5-6 hours . Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 11 Sep 2002 09:24:46 -0800 I did a 150GB V7.3.4.5 upgrade to V9.2 in less than 2 hours. Keep in mind that the actual change to DB internal header blocks does not occur until they are actually read into the DB. Therefore I launched an ANALYZE to build statistics which ran 12 - 14 hours. THT YMMV! Post, Ethan [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] t cc: Sent by: Subject: Migration Assistant Speeds [EMAIL PROTECTED] 09/11/2002 09:23 AM Please respond to ORACLE-L Can anyone share experience with running database migration assistant against a 150 GB database (7.3.4) and how long it takes? Don't have the box specs yet but I think it is a 3 CPU HPUX with 2 GB Ram and a couple of unmirrored disks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
Re: 9ir2 Install on Linux
Did you delete the OraInventory directory? It's location is specified in /var/opt/oracle/oraInst.loc file. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 09/10/02 09:18 AMcc: Please respond toSubject: 9ir2 Install on Linux ORACLE-L I am attempting to install 9ir2 on a Red Hat 7.2 Linux box. Part way through the first attempt I decided to changed the Oracle home value. I stopped the install, deleted the previous Oracle home directory tree, built the new directory and restarted the install. Oracle has stored the value of the old Oracle home somewhere. The install is now crashing because the old Oracle home does not exist. Any idea where it is store and who owns the file? I have already deleted the install files in /tmp. The .bash_profile has the correct Oracle home. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Yahoo! - We Remember 9-11: A tribute to the more than 3,000 lives lost http://dir.remember.yahoo.com/tribute -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to increase maxextents of ROLLBACK segment_type?
FYI- FWIR, it is no longer required to create a second rollback segment in SYSTEM at database creation. This requirement was removed at version 8 (or possibly even 7.3.4). Ron Thomas Hypercom, Inc [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/28/02 11:53 AMcc: Please respond toSubject: RE: How to increase maxextents of ROLLBACK segment_type? ORACLE-L hm, it might be that I was thinking of the second rollback segment you had to create in the system tablespace before you could create any other tablespaces remove that might, that sounds more along the lines of what I was thinking. sorry for the confusion. I bow to the redo/undo/rollback expert --- Fink, Dan [EMAIL PROTECTED] wrote: Before taking the system rbs offline, contact tech support. I recall (perhaps incorrectly...I don't remember whether or not I have tested this) that the system rbs is used by the kernel for normal operations and by other transactions if the other rbs are too full. The system rbs should never be specifically allocated to a transaction by a user. Always create additional rollback segments in a separate tablespace. If you fill up the rbs tablespace, the transaction fails. If you fill up the system tablespace, the database fails. -Original Message- Sent: Wednesday, August 28, 2002 7:23 AM To: Multiple recipients of list ORACLE-L create a rollback tablespace, create new rollback segments IN the rollback tablespace and take the rollback segment named SYSTEM offline. Do NOT use it. Having an active rollback segment in your system tablespace is like allowing users to create objects there. Especially listen to Stephane and READ the manuals. You should not be increasing the allowable size of that segment, it should be tiny and unused. --- Jonny Delmont [EMAIL PROTECTED] wrote: Mark, Thanks, your command doesn't help. To answer your question, Database was setup'd by previous DBA. Still i've never seen this type of segment... SQL alter rollback SEGMENT sys.system storage (maxextents 1024); alter rollback SEGMENT sys.system storage (maxextents 1024) * ERROR at line 1: ORA-02244: invalid ALTER ROLLBACK SEGMENT option Jonny Mark Leith [EMAIL PROTECTED] wrote: Do you mind if I ask why? Do you have any other rollback segments in place other than the SYSTEM one? In answer to your question though, look at the error message.. You missed out the word segment. alter rollback SEGMENT sys.system storage (maxextents 1024); HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Sent: 28 August 2002 10:53 To: Multiple recipients of list ORACLE-L Dear Gurus, Could you please help me out with this - I want to increase the maxextents of below segment. TIA, SQL select OWNER,SEGMENT_NAME,SEGMENT_TYPE,EXTENTS,MAX_EXTENTS 2 from dba_segments 3 where ((max_extents-extents)/max_extents)*100 40 and max_extents != 0 4 / OWNER SEGMENT_NAME SEGMENT_TYPE EXTENTS MAX_EXTENTS -- --- -- -- --- SYS SYSTEM ROLLBACK 505 505 SQL connect sys Enter password: Connected. SQL alter ROLLBACK sys.system storage (maxextents 1024); alter ROLLBACK sys.system storage (maxextents 1024) * ERROR at line 1: ORA-01902: SEGMENT keyword expected TIA Jonny Get a bigger mailbox -- choose a size that fits your needs. http://uk.docs.yahoo.com/mail_storage.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego
Re: sql loader control file help
Make sure your environment NLS_LANG matches how the data is encoded in your flat file. Also, does the database characterset handle whatever special characters you are trying to import? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/26/02 02:41 PMcc: Please respond toSubject: sql loader control file help ORACLE-L I am not, by any means, a SQL*Loader expert (Jonathan, I keep meaning to get your book!) Here's the thing: I have a flat file with character data that includes special characters (like accents and diacritical marks over letters). When I load the data in using SQL*Loader, the special characters disappear and are replaced by the letter (so Dvorák goes on as Dvorak). How can I get the data in as it should be? I've been reading and will continue to read the fine manual, but I'm not finding this... Help! Rachel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix scripting need help
Blimey! Doesn't anyone know korn shell out there any more.
AMEN!
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
08/26/02 02:41 PMcc:
Please respond toSubject: RE: Unix scripting need help
ORACLE-L
Blimey! Doesn't anyone know korn shell out there any more. Perl perl perl -- that's
all I ever
hear anymore. It gets old... (I'm gonna have to buy Jared's book one of these days).
x=${file1%.log}
file_tag1=${x#mylogfile}
Kevin Kennedy
First Point Energy Corporation
If you take RAC out of Oracle you get OLE! What can this mean?
-Original Message-
Sent: Monday, August 26, 2002 6:58 AM
To: Multiple recipients of list ORACLE-L
For example, my files are like these
mylogfile001.log
mylogfile002.log
I want to initialize my variables with those number, like this
i=1
for all_file in `ls -1 /tmp`
do
file$i=all_file
i=i+1
done
file_tag1=`unix_command $file1 ` --- help me here
when I do
echo $file_tag1
it should give me 001
Is your purpose to simply display the numbers or to
generate the maximum in order to start naming new files?
If the latter seriously consider using a timestamp:
i=$(date +%Y%m%d%H%M%S);
this solves all of the math for you automaticlly. A one-
second sleep at the start of your program guarantees that
you will not re-use the names.
To get the digit strings out you could use sed or perl:
i=$( echo $file | sed -e 's/[^0-9]*//g' )
or use perl for the code instead of shell:
for( @ARGV )
{
my ($i ) = /(\d+)/;
Print File and number: $_, $i\n;
}
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Lembark
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: kkennedy
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Thomas
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 Linking
Don't forget about the relink script in $ORACLE_HOME/bin. This is new starting with 8.1.7 (I think). From the script... #!/bin/sh # #NAME # relink # #DESCRIPTION # performs manual relinking of Oracle product executables based # on what has been installed in the ORACLE_HOME. # script calls appropriate makefile targets for the following # accepted script parameters: # all -- everything which has been installed # oracle -- oracle database executable only # network -- net_client, net_server, cman, names # client -- net_client, otrace, plsql # client_sharedlib # interMedia -- ctx # precomp -- all precompilers which have been installed # utilities -- utilities # oemagent -- oemagent, odg # Ron Thomas Hypercom, Inc [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/18/02 11:18 AMcc: Please respond toSubject: Re: Oracle Linking ORACLE-L If linking is stuck at genclntsh, 100% cpu utilization, no disk activity, what could be the possible reasons for this? Thanks. ltiu On Sunday 18 August 2002 10:18, ltiu wrote: There is apparently two stages to the Oracle installation on Unix. A file copying installation where all the required binaries are copied from cdrom to hard disk and a linking install where the binary/object files are linked. If the first stage succeeds but the second stage does not. How do I start the linking install without having to go through the first stage copying install again? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Dba tools on NT
Actually I like this little text editor: http://www.fixedsys.com/context/ One of its advantages is its syntax highlighting. And it's free! Disadvantage is it's windows only... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/13/02 05:08 PMcc: Please respond toSubject: RE: Dba tools on NT ORACLE-L -Original Message- [EMAIL PROTECTED] Scripting: Perl, because it can do anything you ask of it. Editor: Vim - www.vim.org - same reason Actually I like this little text editor: http://www.fixedsys.com/context/ One of its advantages is its syntax highlighting. And it's free! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1658 even though there is enough contig free (SOLVED)
FYI, you do have the choice of running server partitioned. I'm running 10.7 character with 8.1.7.4 with no problems. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. rafiq9857@hotmail .com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1658 even though there is enough contig free (SOLVED) 07/31/02 03:03 PM Please respond to ORACLE-L Waleed, We are running different versions from 7.3.4.5 to 9i. Ver 7.3.4.5 is for Oracle Financials 10.7 Char and company not yet decided to go for Application 11i so we have to support it for a while and face all such limitations ver 7.3.4. Sorry no choice but to live with it. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 31 Jul 2002 11:39:50 -0800 Any plans for Oracle upgrade? :) Waleed -Original Message- Sent: Wednesday, July 31, 2002 3:17 PM To: Multiple recipients of list ORACLE-L Rich, Thanks for reply and your explanation. For ver 7.3.4 dba_free_space specify large extent available but when using initial extent of around that size , it never creates initial extent of that size and generate error so I am not relying it and instead using this query. However I am not using any partitioning as 7.3.4 don't have this option Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 31 Jul 2002 10:50:59 -0800 Hi Rafiq, Right, PARALLEL does do that, which is why I had stated in the original post that I had tried the CREATE without PARALLEL after coalescing the TS. In the meantime, I have figured out what the problem is. My problem is on a test system. This test system's MYCOOLTBL happens to be partitioned and the index was being created LOCAL. So, with 4 partitions, the CREATE needed 4 extents of 140MB each. Thus, a single 140MB free extent wasn't enough. Once I fixed the partitioned table, the index created fine in 140MB. Your query, however, still only returns a max value of 36MB, which is not true for me. After quickly looking thru your query, I'd say it has to do with going after max(block_id) in the subquery. The maximum block_id for freespace in this TS probably points to a 36MB extent, but it is not the largest free extent. Use DBA_FREE_SPACE. :) Thanks! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Mohammad Rafiq [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 12:56 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-1658 even though there is enough contig free That query give u perfect size in shape of FAT_MB and that's the maximun size of intitial extent... I never relied on DBA_FREE_SPACE Have you coalesed yr tablespace before and after running this query? Besides using parallel 2 , it requires 2 extents of 140M instead of one extent of 140M so u may reduce yr initial extent size to start with 20M for initial and next... If u have any specific question, please let me know Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 31 Jul 2002 09:26:08 -0800 Hmmm...I'm confused. Your query returns the second biggest chunk from DBA_FREE_SPACE on that TS
RE: Why DB_Name 4 chars only.
This relates back to the dos days (break out that chisel). 8.3 filename format requires a sid less than 5 characters, eg, init.ora Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: RE: Why DB_Name 4 chars only. 07/30/02 01:22 PM Please respond to ORACLE-L We have SIDs 9 chars long! Ron SMith -Original Message- Sent: Tuesday, July 30, 2002 3:08 PM To: Multiple recipients of list ORACLE-L Hi, What is the reason behind DB_Name/SID usually 4 chars length only. I have a customer who is asking us to create instance/db with 6 chars length. We usually keep instance name and db_name parameters same in .ora file. Can someone please explain the reason behind db_name 4 chars only. Is it a common practice to keep SID/db_name/instance name parameters same (for example PBDS). thanks Srinivas __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srinivas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
