Re: Rebuilding Indexes...
Jared, thanks for the asktom article, very interesting reading - I'm not 100% sure I agree with him though.I just recently went through the exercise to rebuild our indexes into locally-managed tablespaces and I saved over 100GB of space through the rebuild process - as an example I had a 51GB unique index that went to 30GB after the rebuild (I'm not implying locally-managed had anything to do with the space savings, that was just for reducing/eliminating fragmentation).The indexes had not been rebuilt in over a year. Our DSS database is next; I expect to save at least that plus more in space.Not to discount Tom's arguments but I was very happy with the space savings and depending on your environment that can be very helpful/worthwhile. Just my opinion - guess it depends on your objectives. This discussion has definitely got me thinking in some different directions which is always a good thing. thanks again, John D. Atlanta, GA Jared Still [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: (bcc: John Dailey/NAC/ING-FSI-NA) Sent by: Subject: Re: Rebuilding Indexes... [EMAIL PROTECTED] 12/26/2002 10:13 PM Please respond to ORACLE-L Though I have published a script for determining indexes that need to be rebuilt, and then rebuilding them, I have to say that this is almost never necessary. Why are you rebuilding indexes? About the only reason for ever doing so is that the BLEVEL = 5. goto asktom.oracle.com, and do a search on 'index rebuild'. Currently, the third article may be of interest. Jared On Thursday 26 December 2002 12:24, Richard Huntley wrote: Anyone have any useful scripts for doing this? TIA, Rich Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 and Peoplesoft
I would agree with Joan - we spend lots of time refreshing databases here. We were responsible for all of the application servers, web servers, process schedulers, etc. until a technical architecture team was formed. That has helped tremendously since my team can concentrate on the Oracle side. We have a very large Peoplesoft Financials environment here (along with HR and budgets) so we have lots to keep busy with and opportunities to use additional Oracle functionality (we have a large replicated environment, use lots of partitioning, etc) . I would also recommend you at least take a PeopleTools course or one of the administration courses mentioned by Joan so you understand how Peoplesoft stores and uses metadata.As far as book recommendations the only decent book that I have is the Peoplesoft Administrator's Guide by Darrell Bilbrey which is good for someone new to Peoplesoft. We really do most of the normal functions that any DBA would do regardless of Peoplesoft. Database still has to be backed up, tuned, and maintained like any other Oracle database - I consider myself to be an Oracle/Peoplesoft DBA, not a Peoplesoft/Oracle DBA if that helps you any. You will also learn to hate PS Query if your users have ad-hoc query access.:-) John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA Joan Hsieh joan.hsieh@tuftsTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .educc: (bcc: John Dailey/NAC/ING-FSI-NA) Sent by: Subject: Re: Oracle and Peoplesoft [EMAIL PROTECTED] 12/19/2002 09:45 AM Please respond to ORACLE-L Hi Sumathy, It is not too much different from oracle peoplesoft and regular dba. Except you have to know more about peoplesoft components, peoplesoft application server, process schedular, web server,weblogic.. there are some peoplesoft courses I am highly recommend you to take, Configuration and Administration Data Management Tools and another one peoplesoft server administration on Unix/Oracle. They has a website just like metlink. you need a customer id to access it. I feel like as long as peoplesoft infrastucture setup correctly in the beginning. It save a lot of time to troubleshoot later. As a oracle/peoplesoft dba, you have to constantly deal with upgrade poeplesoft tools, application, oracle. so clone the production database is major thing to do. we are constantly refresh testing databases from production. so automate those scripts are very helpful. Joan Panicker, Thankam S. wrote: How different is an Oracle Peoplesoft database from a regular database? Or in other words what all extra tasks does an Oracle Peoplesoft DBA do? How easy/difficult is it for a an Oracle DBA to transition into a Peoplesoft environment? Are there any good books/ websites on this subject? I would highly appreciate your comments and suggestions. TIA Sumathy Thankam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Panicker, Thankam S. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
RE: partial restore of a database
Sorry for the late response, you probably are long done with your partial restore - but I'll add my $0.2 cents to the discussion: When I have done these partial restores I have limited my create controlfile script to only system, rollback, and the tablespaces I wanted. I have ONLY had success when I have listed the SYSTEM and ROLLBACK datafiles FIRST in the create controlfile script - I have gotten 600 errors otherwise - just my experience. Roll the database forward, open it, and pull out what you need I usually build a DB link and copy the data to another database rather than exporting it. I don't drop the datafiles I don't need - just let them get marked as missing. This is obviously a *very* temporary database and after I get what I need I blow it up. I'm sure there are other methods of doing this - this works for me. HTH John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA DENNIS WILLIAMS DWILLIAMS@LIFE To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] TOUCH.COMcc: Sent by: Subject: RE: partial restore of a database [EMAIL PROTECTED] m 06/12/2002 06:05 PM Please respond to ORACLE-L Gene I can't think of anything you're missing. I recall that read-only tablespaces if you have any must be offline, but maybe that is only for a database restore, not a tablespace restore. I assume you have a plan to move the tables back to your production system, maybe just export/import if they are small. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 12, 2002 3:59 PM To: Multiple recipients of list ORACLE-L Hi all: I'm doing a partial restore of a database in order to recover two lost tables. I figured I would only need to restore the tablespaces where the tables are stored, SYSTEM and RBS tablespaces. I will also need to restore to a specific point in time (last Friday). I'm a little less clear on what I will have to do after the restore of the datafiles, archived logs and controlfile is done. I will need to recover the datafiles, drop all other datafiles that I don't need and open the database in resetlogs mode. Is that a good plan or am I missing something? thanks Gene __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note
disk subsystem performance question
Hi all, We are running both a Hitachi 7700E and a 9960 disk subsystem here and we are getting ready to move our production DBs from the old(7700E) to the new(9960) Hitachi. We have had trouble in the past on the 7700E due to disk contention and layout, i.e. we weren't striped across the array groups very well this caused pretty poor I/O performance.This has been a learning experience for the DBAs and the SAs here for the logical vs. physical aspects of our disks. Anyway, to make a long story short, we are ordering disk for the move to the 9960 and we have 2 choices in disk sizes - 18GB and 73GB, and 2 choices in RAID - 1+0 and 5. I would like to get the smaller, faster 18GB drives in a RAID 1+0 configuration and stripe our data across the array groups as wide as possible. However, I am running into objections from the Hitachi people that their system is s fast we need not worry about such minor details. I'm having a hard time believing that given our I/O problems on the 7700E. Performance is given a high priority here. What I would like to know is others' experience with disk subsystems - specifically Hitachi but EMC and others as well have you been able to throw the disk in and forget it or have you had success in getting to the dirty details? Have you tested or noticed an improvement with smaller, faster drives in a disk subsystem like the Hitachi or have you traveled that path and found no noticeable improvement? I'm looking for either a) ammunition that my view is correct, or b) I'm wrong and we can get bigger drives which will make Enterprise Planning very happy from a $$$ standpoint because our Hitachi capacity will last longer. We are running Oracle 8.1.7 / AIX 4.3.3 / Peoplesoft Financials version 8. 2 production databases , one 400 GB and the other about 1TB. We've got some other production DBs but these are our big guys. Thanks in advance for any and all input - any help is greatly appreciated. I'd be happy to share any info we have found up to this point and our experiences on the 7700E as well if anyone is interested - despite the fact I will probably bore you to death :-) John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: disk subsystem performance question
Thanks for all the replies. We are determined to lay out the data as well as we can across the disks we are about to purchase - with the goal of striping across array groups and smaller, faster drives. The real argument for us is 18GB vs. 73GB disk drives and how we can stripe. The Hitachi is configured into groups of 4 physical disks called parity groups and you can choose RAID 5 or RAID 1+0 for that 4 disk set.If you have 73GB drives in a 4-disk RAID 5 configuration you get roughly 219GB of usable space in each parity group (this is what we are being told is the best option for us).This means our heavily concurrently accessed 400GB production database goes on 2 parity groups (2 sets of 4 disks). To me, this sounds like a nightmare waiting to happen and we are trying to stop it.The 18GB drives are less capacity but we can get ourselves spread over more parity groups for better concurrency. We do have about 10GB of cache but it is being shared across the enterprise with various other applications. We as a DBA group are really trying to sell the 18GB RAID 1+0 drive solution especially after reading the groups' experiences - unfortunately we are fighting a lot of marketing hype. If anyone has additional experiences or feedback with Hitachi or EMC they would like to share or comments (agree/disagree) with my thoughts, I'd love to hear them. I'm open for learning! Thanks, John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA Don GranamanTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] granaman@coxcc: .netSubject: Re: disk subsystem performance question Sent by: root@fatcity. com 04/10/2002 01:08 PM Please respond to ORACLE-L Short answer - NO! Nobody's disk subsystem is so fast that no intelligence is required in the layout. This is common vendor blather and one of the most popular myths. I have been hearing it for at least six years - and it still isn't true. Layout still makes a huge difference. RAID levels still make a huge difference. Cache won't solve all your problems (it does help though). I've redone the disk layout on some of the biggest, fastest fully-loaded with cache EMC Syms available that had some don't worry about it layout and seen database throughput go up by as much as 8x. See Gaja's whitepaper on RAID at http://www.quest.com/whitepapers/Raid1.pdf . Don Granaman [certifiable oraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 10:38 AM Hi all, We are running both a Hitachi 7700E and a 9960 disk subsystem here and we are getting ready to move our production DBs from the old(7700E) to the new(9960) Hitachi. We have had trouble in the past on the 7700E due to disk contention and layout, i.e. we weren't striped across the array groups very well this caused pretty poor I/O performance.This has been a learning experience for the DBAs and the SAs here for the logical vs. physical aspects of our disks. Anyway, to make a long story short, we are ordering disk for the move to the 9960 and we have 2 choices in disk sizes - 18GB and 73GB, and 2 choices in RAID - 1+0
recovery scenario - partial database - help
OK we had some data deleted from our production database and reporting database that shouldn't have been deleted. We want to take from the most recent backup the 3 tablespaces affected by the delete and the system tablespace and restore those files to a temporary database with a backup controlfile so we can pull the data we need out. We have stripped the other files from the controlfile creation script. We are getting a 600 error when we attempt to create the controlfile - we have 2 DBAs here who have successfully completed this scenario in the past but we are stifled by the 600 error this time around. Oracle Support is saying we can't do this anymore in 8.1.7 we aren't so sure. Can anyone think of something we are missing?Anyone performed this operation before? Restoring from the full backup is an option but it is our last one due to the size and time required to do this. Oracle 8.1.7.0 AIX 4.3.3 Any and all help is welcomed - thanks! John Dailey Corporate Systems DBA ING Americas Atlanta, GA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: job opportunity - huh?
Dear Colleagues, Brains-r-us Consulting is currently recruiting for test subjects to assist with the implementation and development of brain transplantation surgery techniques for a New York State agency. Brains-r-us Consulting custom tailors all brain transplant surgeries to meet the individual requirements of our patients and delivers the best possible results on time and within budget. Surgery is generally located in or near the head region of the body (lower for some in-duh-viduals). For more information please contact Howie Doin and Will Yagoaway at 800-555-1212 or email [EMAIL PROTECTED] Please note candidates who are outside the range of 175-175.4 pounds, cannot recite the Cyrillic alphabet backwards while intoxicated or live more than 150 feet from our offices will not be considered. All in good fun. Have a good weekend everyone! John Dailey Oracle DBA Atlanta, GA Ginger Mejia info@palladianconsuTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] lting.com cc: Sent by:Subject: job opportunity [EMAIL PROTECTED] 09/21/2001 06:24 PM Please respond to ORACLE-L Dear Colleagues, Palladian Consulting is currently recruiting SQL Server Application Developers to assist with the implementation and development of SQL Server applications for a New York State agency. Palladian Consulting custom tailors all employee packages to meet the individual requirements of our consultants and delivers the best possible results on time and within budget. Project is located in Albany, N.Y.. For more information please contact Ginger Mejia or Charlene Saunders at 800-750-1777 or email [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ginger Mejia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Perf tuning OPTIMIZER_INDEX_COST_ADJ
Rich, It sounds like you just started your instance up not too long ago the statistics in v$system_event are going to be badly skewed. I'd definitely wait for some period of time to allow for more usable statistics to build.Remember, each time you bounce the instance you are going to reset the wait stats. Since your scattered read time is so high I'd look to the actual # of waits compared to the rest of your events it is probably very low. If this database HAS been up for a while and you do a lot of full table scans, you probably have an I/O throughput or data distribution problem causing such high average times. It's hard to make much of a determination based off a newly started instance. On a related note, I read the same white paper a while back and messed around with the parameters a little and took some timings it didn't help us too much here (marginal improvement for a few major queries I tested it against). I can give you more details if you are interested. I really didn't give it a full workout though; I'm sure it is useful in the right environment. We are on 8.0.5 and AIX 4.3.3. I'd say tune the SQL as best as you can before you touch these parameters. You'll get more bang for your buck and I'm sure there's lots of queries that ran good under RBO that are suddenly going to be dogs in CBO and vice-versa. Good old-fashioned tuning fun! HTH and YMMV John Dailey Oracle DBA Atlanta, GA All opinions are my own yadda yadda Jesse, Rich Rich.Jesse@qtiTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] world.com cc: Sent by: Subject: Perf tuning OPTIMIZER_INDEX_COST_ADJ [EMAIL PROTECTED] m 08/09/2001 12:55 PM Please respond to ORACLE-L After just migrating from 8.0.6 to 8.1.7 and RBO to CBO, I've been researching about perf tuning and have come across the init.ora parameter OPTIMIZER_INDEX_COST_ADJ. The guide, by Tim Gorman of evdbt.com, explained that it's default value is 100 (percent), but should probably be in the 10-50 range for OLTP systems. It recommended using the following query as a guideline to set this: SELECT event, average_wait FROM v$system_event WHERE event LIKE 'db file s%read'; ...and to take the ratio of db file sequential read to db file scattered read as a value for OPTIMIZER_INDEX_COST_ADJ. That may be fine for most systems, but our ratio is around .08%. No, it's not 8% -- and it's not a decimal problem. I'm getting this: db file sequential read1.83687542789106 db file scattered read 2151.12743289383 I'm reasonably certain that the seemingly outrageous 2151.127 is due to our use of HP's AutoRAID (SLOWW!) -- we won't be getting one in our next box. So, I'm a little skiddish about changing the default value from 100 to 1 or even 10, based on the above query alone. The scattered read average wait seems to be dropping steadily (it's now down to ~1900 over a period of 14 hours), so I'm trying to provide a good value for this parm without adversely affecting the optimizer. Anyone have any ideas? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538
RE: Dangerous AIX Bug!
Ross, we are also running AIX 4.3.3 with a mix of 8.0.5.2.1 and 8.1.7 databases, headed to all 8.1.7. We are mostly running S80s here. Just shoot me a note and we'll talk. John D. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: get rid of carriage return in vi
Sorry if I'm taking this too far, but I sometimes get those ^M characters in files when I FTP in the wrong mode (ascii vs. binary). If this file has been recently transferred to your Unix box, try re-FTPing it in a different mode and those ^M characters may go away. If this doesn't apply to you, just ignore my ramblings and use one of the many good solutions provided to remove the offending character. HTH, John D. Sairlao, Chark SairlaoC@transfieTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ld.com.aucc: Sent by: Subject: get rid of carriage return in vi [EMAIL PROTECTED] 07/12/2001 03:35 AM Please respond to ORACLE-L all, I got this file which conntans ^M in the middle of the line, how do I get rid of it in vi thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sairlao, Chark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Batch updates
Sean, perhaps I am missing something from your question, but this sounds like a job for Oracle Lite (whatever name the marketing folks call it now, it used to be Oracle Lite anyway). I had an environment similar to your scenario engineers in the field would use their laptops all day scanning assets, etc. and then upload at night. They had a custom application on their machine and it used the Oracle Lite platform with a small database. This db was then synched over dialup each night with the enterprise DB, then in the morning they dialed up and got the work orders for the day.There were PL/SQL packages to check for integrity, etc. Obviously, the next logical extension to this project could have been using the Oracle Lite DB for Palms. In any case, look at the Oracle Lite product for this functionality... it may be just what you need. BTW, if you get a chance and have the time (hard to get I know), load the Oracle Lite DB for Palms and play around w/ it it is really a neat tool. It even has a little SQL interface to write queries on.Don't know how well it scales but it is fun to mess around with. HTH John D. Thater, William To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ThaterW@telecc: rgy.net Subject: Re: Batch updates Sent by: root@fatcity. com 07/06/2001 12:06 PM Please respond to ORACLE-L O'Neill, Sean wrote: I'd appreciate hearing from folk what solutions there are for the following scenario. Users with laptops want to be able to input data whilst not connected to database for subsequent upload to database. Apart from developing PL/SQL code to realise this functionality with associated integrity checks etc. are there other possible (3rd party) solutions? replication to/from personal ORACLE? can you even do that? some 3rd party software i've had experience with used sqlbase [i think] to move stuff to/from a users laptop. [vantive for one.] -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ one ping to rule them all, one ping to find them, one ping to bring them all, and in the darkness bind them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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
Re: initsid.ora problem
Hey Ron I believe the name of that init parameter is LOG_CHECKPOINTS_TO_ALERT (notice the S) and it will record checkpoints in the alert file. Someone correct me if I'm wrong. Another way to get some ideas about your checkpoints is v$sysstat. Keep in mind however a checkpoint can occur without a log switch but not vice-versa.A log switch has an implicit checkpoint within it, but if you have checkpoints between log switches you will get more checkpoints in your alert file than log switches. HTH, John Dailey Corporate Systems DBA All-Around Nice Guy Ron Perrie ron.perrie@mTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ci.co.ukcc: Sent by: Subject: initsid.ora problem root@fatcity. com 06/07/2001 10:07 AM Please respond to ORACLE-L --Boundary-00=_TQ9KG6G0 Content-Type: Text/Plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi List, (SunOS 5.7, Oracle 8.1.6,Newbie DBA) I have been reading Oracle DBA 101 and have come accross an initsid.ora= parameter log_checkpoint_to_alert. I believe that once this parameter is set, the= alert log will be fed with information about log switches. I have applied this parameter (log_checkpoint_to_alert =3D true ) and bou= nced our database but it will now not startup unless I remove this parame= ter. The error message I get is LRM-00101: unknown parameter name 'log_checkp= oint_to_alert'. Could any kind soul please enlighten me ? Thanks, Ron --Boundary-00=_TQ9KG6G0 Content-Type: Text/HTML; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable meta http-equiv=3DContent-Type content=3Dtext/html; charset=3Diso-885= 9-1html head meta name=3DGENERATOR content=3DIncrediMail 1.0 /head BODY background=3D bgColor=3D#ff style=3DBACKGROUND-POSITION: 0px= 0px; FONT-SIZE: 10pt; MARGIN: 1px; FONT-FAMILY: Arial scroll=3Dyes ORGY= POS=3D0 TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 id=3DINCREDIMAINTABLE w= idth=3D95% TR TD id=3DINCREDITEXTREGION width=3D100% style=3DPADDING-RIGHT: 7px; PA= DDING-LEFT: 7px; FONT-SIZE: 10pt; FONT-FAMILY: Arial=20 DIVHi List,/DIV DIVnbsp;/DIV DIV(SunOS 5.7, Oracle 8.1.6,Newbie DBA)/DIV DIVnbsp;/DIV DIVI have been reading Oracle DBA 101 and have come accross an=20 initlt;sidgt;.ora parameter/DIV DIVlog_checkpoint_to_alert. I believe that once this parameter = is set,=20 the alert log will be fed with/DIV DIVinformation about log switches./DIV DIVI have applied this parameter (log_checkpoint_to_alert =3D tru= e ) and=20 bounced our database but it will now not startup unless I remove th= is=20 parameter./DIV DIVThe error message I get is LRM-00101: unknown parameter name=20 'log_checkpoint_to_alert'./DIV DIVnbsp;/DIV DIVCould any kind soul please enlighten me ?/DIV DIVnbsp;/DIV DIVThanks,/DIV DIVnbsp;/DIV DIVRon/DIV/TD /TR TR TD id=3DINCREDIFOOTER width=3D100% =09TABLE cellPadding=3D0 cellSpacing=3D0 width=3D100% =09TR =09TD width=3D100%/TD =09TD align=3Dmiddle id=3DINCREDISOUND vAlign=3Dbottom/TD =09TD align=3Dmiddle id=3DINCREDIANIM vAlign=3Dbottom/TD =09/TR =09/TABLE /TD /TR /TABLESPAN=20 id=3DIncrediStamp P align=3DleftFONT face=3DArial, Helvetica, sans-serif=20 size=3D2__BRFONT
OPTIMIZER_INDEX_COST_ADJ OPTIMIZER_INDEX_CACHING
Oracle 8.0.5.2.1 -- yeah, I know I know... we are going to 8.1.7 eventually AIX 4.3.3 Hey allLooking at our init parameters today after reading Tim Gorman's White Paper The Search for Intelligent Life in the Cost Based Optimizer and these 2 stood out like a sore thumb. Both are at the default values: OPTIMIZER_INDEX_COST_ADJ = 100 OPTIMIZER_INDEX_CACHING = 0 We have an OLTP and a DSS database and I am looking at changing the OPTIMIZER_INDEX_CACHING = 90 for both and setting the OPTIMIZER_INDEX_COST_ADJ to a reasonable value based on db sequential reads vs. db scattered reads as a guideline any suggestions/recommendations/words of warning/flogging?There is some scattered info on this on Metalink but I'm looking for some real-world improvements or headaches. Thanks to all in advance and hopefully I won't have to type HELP so someone can ask me if I'm an idiot :-) John D. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: friday fun early, vote for favorites / Re: COLLECTION ITERATOR PICKLER
Eric, I'm torn between 2: A RICOCHET FRITTER KELP -- nothing like kelp fritters! yummy! and A CORRECT ETHER FLIP KIT -- what Oracle needs to install to get Metalink to work properly That's my 2 pesos for today :-) John Dailey ING Corporate Systems DBA Atlanta, GA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: changing passwords - Boneheads at MetaStink
Doug, not to butt in on this thread, but you can do this by placing a "wrapper" around the jobs w/ another dbms_job. Create a table called PERFORMANCE_STATS or something and create a new procedure for each job that inserts the sysdate (begin time) into the table, runs the job you want to run, then inserts the sysdate again (end time) into the table. I've used this before w/ great success. Sorry, I'm about ot leave for the day, so I couldn't be more precise. Let me know if you have any questions and I'll be more specific. John Dailey Consultant Concept Solutions, LLC -Original Message- [EMAIL PROTECTED] Sent: Friday, March 16, 2001 5:20 PM To: Multiple recipients of list ORACLE-L Rodd, What else is new! I've sent many a query to Oracle, along similar lines, and gotten a 'boneheaded' reply, even on TARs. You then have to get down and specific to finally get through the haze those guys work in, maybe it's a hang-over (hung over from what I do not want to know). Anyway I sent them a query on saving how long a job running under DBMS_JOB takes. All I got for a reply was that "they don't keep that data in the database". Duh, I knew that, the question was how do I catch keep it. Basically I replied that I wanted to put a on update trigger on sys.job$ as "PL/SQL stuff". Finally someone replied that you could not do that due to startup issues. That's where it got left, real smart. I'm now working on a package to do it for me. Looks like I'll have to modify a lot of snapshot jobs. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dailey 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 Lite and Palm Synchronization
Dave, we played around w/ this setup for a while here at my client, but they ultimately decided to go in a different direction (complexity, cost issues). We were trying to push sales and pricing data out to the field. I would have liked to have implemented this just for the hell of it. Anyway, it was my experience w/ Metalink and several other sources that the documentation for Oracle Lite is incorrect and they are no longer supporting HotSync methods of replication in the latest version of Oracle Lite. However, I'd check more if I were you; even Oracle seemed confused about this (not a good sign IMHO as I got conflicting answers).I think you will have to setup a RAS server and use the HTTP transport method w/ Oracle Application Server or Web-to-Go. When the client made the decision I didn't explore further due to time restraints. Since I am by no means an expert on this, perhaps someone else can shed some more light on the subject. HTH and HAND! John Dailey Consultant Concept Solutions, LLC -Original Message- Dave Sent: Monday, March 12, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Has anyone got this to work? I'm using the latest oracle Lite I could find (4.0.1.2). When I follow the instructions to setup Iconnect for Palm sync, the step that says to runregset cnshscnd.dll results in the error: C:\ORACLE\OLITE\BINregset cnshscnd.dll Error : HotSync is not installed! Any ideas? Thanks Dave Miller DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dailey 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).
list of common ORA errors users get
Hi again List... hope everyone is having a pleasant afternoon/evening/morning: I'm looking for a list of common questions about Oracle errors that end-users might encounter. For example, basic stuff like "no listener", "Archiver error", "Oracle not available", "max # of extents reached", etc, etc. What I'm looking for is a decent list I can use to help me set up a help desk support site for my client. We are pretty much building the DBA group from the ground up here.If I had a nice list, I could put that in their current help desk support software so the users could route their specific requests and error messages to the DBA group (So we can ignore them properly) :-) . Does anyone know of or can point me to such a list? I know I could put on my thinking cap and make a list, but I'm really pressed for time (who isn't) and don't want to re-invent the wheel if I don't have to. Besides, I'm enjoying the hilarious commentary on Metalink's woes too much. I'd eventually like to have an auto-response email that says: "don't bother me, I'm busy... open up FDISK in a DOS Window and delete all your partitions" sent out to answer each request, but I'll save that functionality for later :-) TIA John Dailey, MCSE/MCP+I Consultant Concept Solutions, LLC *Your Business Intelligence Partner* www.concept-solutions.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dailey 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-00059: maximum number of DB_FILES exceeded
Hi Charlie... the parameter DB_FILES is set in the init file... you have to bounce the instance after you increase it. The parameter you are thinking of is MAXDATAFILES which is in the control file. And you are correct; you would need to ALTER DATABASE BACKUP CONTROLFILE TO TRACE, edit that MAXDATAFILES parameter, and recreate the controlfile if it were exceeded. Sounds like you just need to change DB_FILES though considering your error. DB_FILES and MAXDATAFILES can be different; might generate the trace file anyway just to check that the MAXDATAFILES setting is ok. I don't know of any other way to check it; somebody else may have a better method. BTW... is San Diego still as sunny as ever? I'm still hooking and jabbing here in DC... send me some more pictures of the Pacific. :-) John Dailey, MCSE/MCP+I Consultant Concept Solutions, LLC *Your Business Intelligence Partner* www.concept-solutions.com -Original Message- Mengler Sent: Tuesday, February 27, 2001 10:50 PM To: Multiple recipients of list ORACLE-L I just got the following - SYS: DBW.WORLDALTER TABLESPACE DAILY_SALES_TBL 2 ADD DATAFILE '/db19/oracle/DBW/daily_sales_tbl.dbf' SIZE 1802272768 3 / ALTER TABLESPACE DAILY_SALES_TBL * ERROR at line 1: ORA-00059: maximum number of DB_FILES exceeded I fixed a similar problem about 4-5 years ago I have a vague recollection of what to do. I need to do - ALTER DATABASE BACKUP CONTROLFILE TO TRACE; I then find the trace file edit it. Besides increasing the line where the number of datafiles is specified; what else do I need to do? The exactly how do I use this file to start the instance? If anyone can point me at some softcopy or hardcopy documentation on this whole process, I'd appreciate it. TIA! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dailey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Mailing frm Oracle
Yes, and dbms_ijob will allow you to manage jobs that are not owned by you. I had to do the same thing as Regs... those jobs can be very persistent little guys. Break them first, then kill the session ID running the job. This will stop them. John Dailey Consultant Concept Solutions, LLC - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, February 25, 2001 2:10 AM I also had same problem before, but dbms_job.broken procedure takes care of it. I first broke the job and then removed it. It works. Regs, - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, February 23, 2001 5:11 AM one caution: If you're using Oracle 8.1.x on NT (NT4 - W2K) you will have some serious issues with killing dba_jobs. okay - its very easy to kill a dbms_job. shutdown abort takes care of it - no problem. I had a dbms_job emptying a mail queue that opened 3976 connections to a Sendmail server last night - it stopped at port 4999 (testing code). The mail server didn't even blink. I could not kill a dbms_job - as it deferred the kill session. 7.3 use to have a parameter that allowed you to not keep the connection alive. That parameter isn't available in 8.1.6. So once again, less ways to get at the OS - less ways to maintain processes. If you actually have users that don't want to have their instance shutdown, better test that code very well ... Paul Original Message Date: Thu, 22 Feb 2001 14:40:27 -0800 Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] On 8.1.6+ you can use UTL_SMTP. Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, February 22, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Hi Everybody, I wanted to forward a mail to a particular Id thru an Oracle Procedure , can anybody tell me whether I can do that thru an Oralce Procedure if so pls inform how to do the same. I dont want to mail to a Unix Login id , I want to mail to a mail server For e-g [EMAIL PROTECTED] Thanks In Advance, Shankar Swamy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shankar Shanmugaswamy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjali R 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: UNSU
RE: peoplesoft
Unfortunately, I think that's it Eric... and last I remember, Informix was hanging by a thread. (Pun intended) John Dailey Consultant Concept Solutions, LLC *Your Business Intelligence Partner* www.concept-solutions.com -Original Message- Pierce Sent: Friday, February 23, 2001 12:51 PM To: Multiple recipients of list ORACLE-L besides DB2?/Informix?/Oracle?/SQL-server?/, what other RDBMS products does PeopleSoft support (large mainframe)? thanks, ep -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dailey 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: Shell scripting question
Yep... that's what I get for taking someone's word. I got handed this problem after everybody else gave up on it... all I heard was "man pages didn't tell us anything"... HAHAHAHAHA -- my insane laughter now Anyway, thanks to all who responded to my query... Bill, Ganti, and the user below were all very helpful (especially Bill for putting up with me twice). BTW, before I saw this note, I got the .netrc file suggested by Ganti to work... fixed the problem nicely. Will probably just stay with that solution out of pride/embarrassment. Just had to insure the .netrc file had 0 bits for group and other permissions in the user's home directory. Thanks again to the list. John Dailey -Original Message- Sent: Friday, February 23, 2001 3:26 PM To: Multiple recipients of list ORACLE-L check out this link for some info www.datafocus.com/docs/man1/rexec.1.asp -Original Message- Sent: Thursday, February 22, 2001 7:36 PM To: Multiple recipients of list ORACLE-L Forgive me if this a stupid question and unrelated to Oracle but it pulls data from an Oracle database and i hope one of you scripting gurus can help me out ;-) It's on HP-UX 10.20. I need to find a way within a script to handle a system generated prompt. I'm trying to use the REXEC command to run a batch script on an NT machine from UNIX. I've got the NT side set up with REXECD. When I run the REXEC command from the UNIX prompt, it prompts me for a password (for authentication on the NT machine I suppose). How do I script this process so I do not have to manually type in the password? Here's the command: rexec nt_machine -l user e:\\top_dir\\ev00_07\\run\\batch_script.bat after I run it, it prompts for a password; if I type the NT password in for the user, it works fine, so the syntax of the command is correct. I just want to automate this so I can schedule it instead of typing in the password manually. I know I can use RSH instead and not worry about authentication, but the administrative overhead to get that implemented (security worries, etc) would carry me through to retirement age. I'm sure there is a simple way to do this, but I'm not seeing it. I try not to bother the list with questions if I can help it, but I'm stuck on this one and don't want to throw in the towel. Thanks! John Dailey Consultant Concept Solutions, LLC *Your Business Intelligence Partner* www.concept-solutions.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dailey 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: hp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dailey 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).
Shell scripting question
Forgive me if this a stupid question and unrelated to Oracle but it pulls data from an Oracle database and i hope one of you scripting gurus can help me out ;-) It's on HP-UX 10.20. I need to find a way within a script to handle a system generated prompt. I'm trying to use the REXEC command to run a batch script on an NT machine from UNIX. I've got the NT side set up with REXECD. When I run the REXEC command from the UNIX prompt, it prompts me for a password (for authentication on the NT machine I suppose). How do I script this process so I do not have to manually type in the password? Here's the command: rexec nt_machine -l user e:\\top_dir\\ev00_07\\run\\batch_script.bat after I run it, it prompts for a password; if I type the NT password in for the user, it works fine, so the syntax of the command is correct. I just want to automate this so I can schedule it instead of typing in the password manually. I know I can use RSH instead and not worry about authentication, but the administrative overhead to get that implemented (security worries, etc) would carry me through to retirement age. I'm sure there is a simple way to do this, but I'm not seeing it. I try not to bother the list with questions if I can help it, but I'm stuck on this one and don't want to throw in the towel. Thanks! John Dailey Consultant Concept Solutions, LLC *Your Business Intelligence Partner* www.concept-solutions.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dailey 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).