NT Scheduled Restart

Title: Database Down Hi all, I am looking for a utility (preferably freeware), which can perform a scheduled shutdown of NT 4.0 server. This I need because of inconsistent behavior of NT for Oracle Services. I want to do a scheduled restart after every night

Re: ORA-12571: TNS:packet writer failure

Hendra Darmawan wrote: Dear all, Anyone can help me about this error (ORA-12571)? Thanks! probably - if you supply things like Oracle Version, Platform, etc. Did you receive the error on the client or on the server (in the alert log)? In what tool did you receive the error, sql*plus? what

Re: NT Scheduled Restart

Rajesh Dayal wrote: Hi all, I am looking for a utility (preferably freeware), which can perform a scheduled shutdown of NT 4.0 server. This I need because of inconsistent behavior of NT for Oracle Services. I want to do a scheduled restart after every night

Re: Database Down

Burton, Laura L. wrote: I have an Oracle 8.0.5 database residing on a Windows NT operating system which uses Raid5. The 'almost never' has happened; two disks have gone bad at the same time. As fate would have it the 'complete' physical backup performed the day before the disks crashed

RE: recruiters. Aargh. (More on them!)

I wish that I could be like some of U where your job is to solely tune/backup database etc. Although I am a DBA, I feel that I am a 5% DBA and 95% developer. I've just migrated our in-house customized System to the newly acquired Oracle HR System (oracle workflow). In top of that, I am also

RE: Binding a process to a CPU .

I thought it was hope this helps... hth :-) connor --- [EMAIL PROTECTED] wrote: it means happy to help Christopher Brian. Christopher Spence [EMAIL PROTECTED]@fatcity.com on 05/22/2001 04:21:12 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To:

RE: NT Scheduled Restart

Title: Database Down That's the best thing I like about this list... You ask for something and you get it, with no delay at all Thanks list and Thanks Suhen... Rajesh -Original Message-From: Suhen Pather [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001

Deleting Files in NT

DBAs How do I delete files from NT which are older than a week. I need this to organise my backup dump files. Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Mailing lists hosted by fatcity

FYI. Following all are hosted by fatcity.com. Got it by sending email to listguru with message text as LISTS. cheers.. Umesh # ## ## ## -- LIST OF

Re: Database Down

On Wednesday 23 May 2001 01:00, Paul Drake wrote: 0. caffeine. Agreed. 2. You *will* be performing incomplete recovery. Recover until cancel, preferably with a backup controlfile. Did you create a backup controlfile as part of the hot backup on May 11th? Restore with that controlfile.

ULIMIT setting: Urgent Please Help

Hello all, I am trying to install oracle 8.0.5.0.0 on SCO Unix Ware 7.1.1. While trying to install Oracle, the Oracle Installer bombs out, because it says that my ulimit is not high enough. It needs the ulimit to be 2113674. But my hard limit of ulimit is 2097152. This figure is less than

RE: Mailing lists hosted by fatcity

Well now, Knowing that I can get to the Flight Attendants Association of Australia list will help me sleep at night !! Lee -Original Message- Sent: 23 May 2001 16:19 To: Multiple recipients of list ORACLE-L FYI. Following all are hosted by fatcity.com. Got it by sending email to

RE: sum of file size ????

Andrea, You could try: wc * Ron -Original Message- Sent: Tuesday, May 22, 2001 2:39 PM To: Multiple recipients of list ORACLE-L Hi, OK, as you know, I don't know too much about Unix: When you do a ls -l and see the individual file size, is there a command to show the sum of all the

RE: disk information alert

Here's what I use, it alerts me when the specified filesystem is 1G [EMAIL PROTECTED];export mail_id # min freespace is in K 100=1G min_freespace=100;export min_freespace # check to see if running out of filesystem space and page

RV: vni-2015 authentication error

hello I'm running oracle 8.1.7 on WNT. I've set system/manager as the preferred credentials of the DB, and an administrator OS account (with 'run as batch job' priv) as the credentials of the node. I'm getting the vni-2015 authentication failed error while running any job. can anybody help

global lock parameters

Does anyone know the UNITS of the global lock {convert|get|release} time parameters? I am inclined to think it has the same resolution as get_time, butshrug. TIA, - Ross N.B. I am not interested in the global cache * parameters for Cache Fusion instances. -- Please see the official

Re: If statement

Roland, I'm confused about part of this statement. I would like to do an insert into the table errorlog if the vOWNER_NO has an id whichdoesnt exist in vSubOWNER_NO How should I write the if ^^ What exactly do you mean by doesn't exist in. Is vSubOWNER_NO a

RE: (Fwd) Wilber/Shambala interview (transideological social trends)

antidisestablishmentarianism - I know big words too!! :) http://www.straightdope.com/mailbag/mantidis.html Really Eric - where do you get all the time from to collate this extraordinarily extensive yet thoroughly interesting psycho babble? :) Mark (Eric wannabe) -Original Message-

RE: ULIMIT setting: Urgent Please Help

get yer SA to de-shackle you. || -Original Message- || From: Viraj Luthra [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 23, 2001 11:19 AM || To: Multiple recipients of list ORACLE-L || Subject: ULIMIT setting: Urgent Please Help || || || Hello all, || || I am trying to install

Re: NT Scheduled Restart

Title: Database Down hi suhen, for some reasons i did'nt recieved the mail with the attachment as exe file. have u sent it. pls confirm. i'm also looking for such utilities. thanks. - Original Message - From: Rajesh Dayal To: Multiple recipients of list ORACLE-L

Variabel declaration

Hallo you DBAs Is it good to use this form when you declare variables in pl/sql? Then you dont have to be afraid of declaring variabloes into wrong datatype and size. vOWNER_NO OWNER_INFO.OWNER_NO%TYPE; Sincerely Roland Sköldblom -- Please see the official ORACLE-L FAQ:

RE: The good old RAID5 argument...

Thanks to all for your input. I am assuming that there will not be a problem in splitting some disks out of the RAID-5 Array for use as Redo Log storage. Martin -Original Message- Sent: 22 May 2001 15:06 To: Multiple recipients of list ORACLE-L If that is the cause, RAID 5 does not

Re: ULIMIT setting: Urgent Please Help

Raja, I had a similar problem, but when I changed my shell to the posix shell, then it would let me do the ulimit unlimited command. Hope this helps. Lisa On Wed, 23 May 2001, Viraj Luthra wrote: Hello all, I am trying to install oracle 8.0.5.0.0 on SCO Unix Ware 7.1.1. While

RE: Problem with import

FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. Randy I have posted a message about

Create Table performance problem

Does CREATE TABLE AS SELECT . still use indexes or are the indexes disregarded if the select is issued in combination with a create table? Oracle 8.0.5, optimizer is CHOOSE. We are having a performance problem when trying to use create table as select. - Sent using

RE: Database Down

I thought I would have to restore all datafiles and archive logs from the physical backup so that they would be in sync, and then 'recover' the database using the hot backup. This would only incur minimum data loss since Saturday is a non-work day for most employees. After reading the

RE: help me : error on import

It has to do with your NLS environment settings. If you're on unix, make sure the NLS_LANG variable is set to the same value as it was during the export. HTH, Remco -Oorspronkelijk bericht- Van: benajam lhoussain [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 22 mei 2001 19:00 Aan:

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

Hi , Your problem is actually highlighted on the error message "Solaris Error: 12: Not enough space" It is more of an Operating system resource issue. I gather that you are running about 8 instances on this machine ,right? Shutdown couple of unused or low priority instances and see whether you

RE: Database Down

Title: RE: Database Down My database is up and with no data loss!!! I was able to do a complete recovery, not incomplete. After the coca-cola (for caffeine) to calm my nerves I had the sysadmin restore the datafiles and archive logs from the hot backup from Friday. The control files 1 and 2

Components removal - W2K

We have Oracle 8i Rel installed on a W2K server. The Oracle Home is located on the E: drive. Yesterday an accidental deletion occured of files on the C: drive which resulted in files being deleted in the C:\Program Files\Oracle dirs and below. No backup exists of these files :( So I'm

RE: Multiple schema's or multiple databases

In 8.1.x, as long as your schemas have their own tablespaces, you could to TSPITR (Tablespace Point in Time Recovery). Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED]

Reinstall query - NT

We had to install a EE version of 8i Rel 3 onto a server with Win NT because the Standard edition CD had not been shipped to us and a deadline had to be met. I now want to install the Standard Edition of the software on the server for licence compliance reasons. Can I remove the Oracle EE

RE: Mailing lists hosted by fatcity

yes, but i was sad that i didn't see a list for beagle owning transgendered rocket launch console operators from antarctica. On 23 May 2001, at 9:20, Robertson Lee wrote: Knowing that I can get to the Flight Attendants Association of Australia list will help me sleep at night !! --

Reverse engineer tablespaces.

So, I need to re-create a database to prepare for migration. The current DB is 8.0.6, and I need to create an 8.1.7 copy. Does anyone have a script to reverse engineer the CREATE TABLESPACE commands? I started working on one, but surely I can't be the first to invent the wheel. TIA, Rich

Re: Database Down

Paul you leave me NOTHING to add to this. :) Laura. I would do exactly what Paul said, and include what you thought to do (which is backup the good disks before you do anything else). First rule of recovery: ALWAYS have a way to start all over again if you mess up. After that, follow

RE: Oracle Reports coredump

We've had similar problems with the 6i runtime, using patchset3a. Metalink says it's fixed in patchset 4. -Original Message- Sent: Tuesday, May 22, 2001 5:16 PM To: Multiple recipients of list ORACLE-L Hi, I recently installed Oracle Reports and I'll work fine for a while. Then

RE: Oracle Reports coredump

Dan, I have the 6i version on HP-UX 11.0. It's all on one machine. I'm just trying to create some sample reports to familiarize myself with the product. It seems to coredump from time to time for no apparent reason. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED]

8.1.7. and OAS / iAS versions confusion

OK, now I'm puzzled. About 3 weeks ago Oracle mailed me a copy of 8.1.7. at home, along with the 9i iAS. The iAS documentation refers to 8i OAS (version 1.0.1), it says we can migrate from 8i OAS to iAS. Does this mean if I had installed 8i OAS (v. 1.0.1), I could apply a patch to bring it up

RE: Nothing to do with Oracle : But is is very important : Yo

I agree that the link is off topic. I also like the link and intend to send it to many of my American friends. I'd like to see less off-topic discussion here. Funny though - most list members seem to enjoy off-topic discussion - except for this one. ..tom -Original Message- From:

Re: Multiple schema's or multiple databases

If each schema has it's own tablespace, then you can do Point In Time Tablespace Recovery. If all schemas share tablespaces then that would be a problem. Richard Ji [EMAIL PROTECTED] 05/23/01 02:45AM Off the top of my head I can see this problem also. Is there anyone who is expert at

Re: Binding a process to a CPU .

I thought it meant Hope This Helps ---Bill Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 22, 2001 4:33 PM it means happy to help

RE: Maximo

Title: RE: Maximo ON all the maximo installations I have done, the biggest problems have been with maxencrypt a table that holds the encrypted key that allows everyone in the base. There is a script that will reset this if the users cannot get into the system. Make sure that the character set

Re: Database Down

On Wed, 23 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon: -Yell. Scream. And DOCUMENT what went wrong... to everyone you can think of. - -Rachel Including sending copies to yourself at an account off site, then save it there. BCC is your friend.;-) -- Bill Thater

RE: Variabel declaration

Roland, Yes and for exactly the right reason. In fact, I've found over the years that most of my PL/SQL variables end up being records of Table%RowType, since I nearly always need to use more than just one column of a table. Table%RowType records are particularly useful for input arguments to

RE: Binding a process to a CPU .

Hi Steve , Your article was very informative . Thanks a lot. I will have to definitely rethink on these issues. shreepad. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Mailing lists hosted by fatcity

On Wed, 23 May 2001,Eric D. Pierce scribbled on the wall in glitter crayon: -yes, but i was sad that i didn't see a list for beagle -owning transgendered rocket launch console operators -from antarctica. I believe that one is hosted over a lycos.;-) -- Bill Thater Certifiable ORACLE

Re: RV: vni-2015 authentication error

OS or database job? If OS, we just solved this issue. Assuming your target node is not a PDC or BDC, the NT user must be local and the preferred credentials of the node in OEM must be set to the same user. Hope it helps. Todd Carlson Oracle 8i Certified DBA Bunge Corporation

Oracle DBA vs. Oracle Apps DBA - Different? and how?

I would be interested in hearing your opinions on the differences between an Oracle DBA and an Oracle Apps DBA. Are they different? And how? Are they so different that one could not perform the duties of another? Learning curve for each? My interest was sparked when I interviewed with a

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

Title: RE: Sun Solaris 8 - Listener failed to start a dedicated server p Thank you everybody for your suggestions. To recap, I had the following suggestions: - purge listener.log (Shahid Nasir) - check max number of processes vs. max number of processes per user (John Kanagaraj) - swap space

MICROSOFTDTPROPERTIES

I have developers who have created this table. Now they've come to me to find out what the table does. I think it is used by the Microsoft Transaction Server software. Does anyone know for sure the purpose of the MICROSOFTDTPROPERTIES table? Michael Armstead Application Database

RE: Database Down

Laura Document it to even those you CAN'T think of... just to try to CYA! I speak from experience! April Wells Oracle DBA Corporate Systems Amarillo Tx -Original Message- Sent: Wednesday, May 23, 2001 10:27 AM To: Multiple recipients of list ORACLE-L Paul you leave me NOTHING to add

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

Title: RE: Sun Solaris 8 - Listener failed to start a dedicated server p -Original Message- From: Jyoti N [mailto:[EMAIL PROTECTED]] Your problem is actually highlighted on the error message Solaris Error: 12: Not enough space It is more of an Operating system resource issue. Yes,

Automatic password locking

Title: Automatic password locking Hi everyone - I am trying to implement a process on our production servers. If requested for emergencies, an id is automatically unlocked. This id was previously defined with all access (select, insert, update, delete) to all objects in a schema. I want

RE: Database Down

Title: RE: Database Down -Original Message- From: Burton, Laura L. [mailto:[EMAIL PROTECTED]] My database is up and with no data loss!!! Congratulations! I've done the exercises in Rama Velpuri's book, but when it comes to a live situation, it's a little more scary. So where's the

Re: Reverse engineer tablespaces.

I'm not sure if this is what your looking for but take a look: spool db_structure.txt select 'create tablespace ' || a.tablespace_name || ' datafile ' || || b.file_name || ||' size ' || b.bytes/(1024 * 1024) || 'M' || \ ' default storage ( initial ??k next ??k pctincrease ?

Re: Oracle Development Tool

Deepak, Not off topic at all. Personally, I much prefer TOAD, as it has a *much* better interface than SQL Navigator, which translate into less time spent navigating the tool and more time getting work done, leaving more time to answer questions on this list. :) Jared On Wednesday 23 May

(Fwd) Re: Open Source and Capitalism

--- Forwarded message follows --- Date sent: Sun, 20 May 2001 11:20:46 -0400 Seeing the recent interest in discussing the connection (or lack) between open source and capitalism, I thought people might enjoy reading an article that appeared in a special Linux issue of

OT RE: Mailing lists hosted by fatcity

Charlie Brown and Lucy are heading down to you right now in a Mir launch vehicle financed by Dennis Tito, carrying a scalpel and duct tape. Hang in there, Snoopy! || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 23, 2001 2:16 PM || To:

RE: sum of file size ????

Please use du -s directory name. -Seema From: Morton, Ronald D [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: sum of file size Date: Wed, 23 May 2001 07:19:09 -0800 Andrea, You could try: wc * Ron -Original

Re: ORA-12571: TNS:packet writer failure

On Wednesday 23 May 2001 00:00, Hendra Darmawan wrote: Dear all, Anyone can help me about this error (ORA-12571)? Thanks! In addition to Pauls comments, I am guessing that you are on NT. This error is informational only, you have a network error of some type. Go talk to the network admin

OT Wilber/Shambala interview (transideological social trends)

It's actually a pretty cool interviewa lot there || -Original Message- || From: Mark Leith [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 23, 2001 11:19 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: (Fwd) Wilber/Shambala interview || (transideological social

disk information alert

Hi Gurus Does any one having scripts to know disk space once particular partion =75% let assume the below is not exact output of df -k command $df -k /u0168 /u0240 /u0353 /u0476 As the disk partition reach to 75% or more.We need to

Re: Live Free or Die! / Re: OT: Editorial on Corporate use of Open Source Software

yes, the bliss (with the exception of constantly having to dealing with silly political correctness) of life in inefficient academia. and, data janitoriaton is easier (but more dull and less remunerated) than db administration. but really, as I said previously, most of the blah blah is just

Re: Database Down

On Wed, 23 May 2001,Jared Still scribbled on the wall in glitter crayon: -Backup is easy, recovery is not always so. - -Jared - Now there's a quote that should go into Zen and the Art of ORACLE Database Administration... now who's writing that again?;-) -- Bill Thater Certifiable

Forms5 D2KWUTIL under Forms6i

Hello-- We've got a client/server app which currently runs under Forms5, that we're in the process of converting to 6i. We have the existing d2kwutil.dll in our bin directories. Is there any problems staying with this, provided we don't recompile the d2kwutil.pll libraries? Just trying to avoid

Oracle Development Tool

I have a feeling that this is not the most appropriate list for this question, but then I swear by the postings of folks on this list, which means I value their opinions very much, so here goes ... Our organization is evaluating several tools to help us with our Oracle application development

Re: 8.1.7. and OAS / iAS versions confusion

9i iAS == 8i OAS. Oracle renamed 8i 1.0 to 9i 1.0. Version numbers are consistent. Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 23, 2001

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

Title: RE: Sun Solaris 8 - Listener failed to start a dedicated server p i think you should check large pool size parameter in your init.ora file. You can actullay reduce the size and restart the instance. -Nihar -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

Drop 'NOT NULL' Constraint

I created a table with a 'NOT NULL' constraint on a VARCHAR2 column. I would like to remove the NOT NULL constraint. I've tried a couple of 'ALTER TABLE' commands but no luck. How does one do this? Also: How does one figure out which generated constraints (from user_constraints) do what?

Re: Reverse engineer tablespaces.

This mod grabs the current default storage parameters from dba_tablespaces spool db_structure.txt select 'create tablespace '||a.tablespace_name|| ' datafile '||||b.file_name||||' size '||b.bytes/(1024 * 1024)||'M'|| ' default storage ( initial '||a.initial_extent||' next

SQLLDR Question

I am trying to load a file that has the fields comma-delimited, variable length. A sample line from the file looks like this: 503,414081660,Success,Auth,AH9042,z,4555,-,-,-,0,05/01/01,14:21 The problem I am having is putting the date and time together. The control file looks like this:

RE: help me : error on import

Go to metalink and look for Doc ID: Note:60134.1 Note:48644.1 Note:15095.1 Those documents have answers to your question and lot more. -Shantanu Talukder Lead DBA, TRIRIGA, Las Vegas,NV 89103 --- Daemen, Remco [EMAIL PROTECTED] wrote: It has to do with your NLS environment settings. If

RE: Oracle Reports coredump

Well, I can't comment specifically on that hardware. I've got 6.? but not 6i server running on a WinNT server and no problems, then I've had both 2.? and 6.? tools running on a WinNT workstation with no problems. If you have a workstation that you can use, isn't the windows version available at

Re: Database Down

Jared, as I understand it, the original controlfile allows you to recover until the SCN's all match the one in the controlfile. A backup controlfile assumes that you are not certain of what the final SCN is and so allows you to continue recovering past the backup time. I *think* this is the

RE: Oracle DBA vs. Oracle Apps DBA - Different? and how?

Sometimes I think Apps DBA is shorthand for senior developer. I'd like to wholeheartedly disagree. Administering Financials fell onto my lap as just another Oracle-based product. There is much more to knowing this package than meets the eye from DBA prospective. The technology stack alone, with

RE: MICROSOFTDTPROPERTIES

that was great -Original Message- Sent: Wednesday, May 23, 2001 5:36 PM To: Multiple recipients of list ORACLE-L Joking I think we've stumbled on to something... SQL desc MICROSOFTDPROPERTIES; NameNull?Type ---

RE: ULIMIT setting: Urgent Please Help

In IBM-AIX you can set ulimit unlimited. If I remember correctly, go to /etc/security/ and open 'limit' file then you can make an entry like : # -1 is for unlimited. ulimit = -1 Shantanu Talukder Lead DBA, Tririga. Las Vegas,NV 89103 --- Mohan, Ross [EMAIL PROTECTED] wrote: get

RE: disk information alert

Here is mine; NOTE: This is for solaris and reference the /etc/vfstab file for verification, but you can take that out. NOTE2: Change email address. HTH! __ #!/bin/ksh # #-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ # Purpose: # To monitor filesystem

Re: Reverse engineer tablespaces.

from the Annotated Archives: (enter % when asked for the name of the tablespace and it will generate all of them) set echo off term on verify off feedback off pagesize 0 select 'Creating tablespace build script...' from DUAL; accept tablespace_name prompt Enter the name of the tablespace:

troubleshoot broken pipe

Title: troubleshoot broken pipe hi, OS=sol8 ora_ver=8i model=420r what can i do to troubleshoot this problem? Wed May 23 10:40:17 CDT 2001:I JMS java.sql.SQLException: Io exception: Broken pipe at java.lang.Throwable.fillInStackTrace(Native Method) at

RE: Oracle DBA vs. Oracle Apps DBA - Different? and how?

Sometimes I think Apps DBA is shorthand for senior developer. -Original Message- Sent: Wednesday, May 23, 2001 11:28 AM To: Multiple recipients of list ORACLE-L I would be interested in hearing your opinions on the differences between an Oracle DBA and an Oracle Apps DBA. Are they

RE: Drop 'NOT NULL' Constraint

I think that if there is already data in the column you will not be able to do that. -Original Message- Sent: Wednesday, May 23, 2001 5:15 PM To: Multiple recipients of list ORACLE-L I created a table with a 'NOT NULL' constraint on a VARCHAR2 column. I would like to remove the NOT

Re: MICROSOFTDTPROPERTIES

Joking I think we've stumbled on to something... SQL desc MICROSOFTDPROPERTIES; NameNull?Type --- PROPERTY_ID NUMBER(38,0) FIRST_CRASH_DATE

RE:Deleting Files in NT

Raj, If you have the resource kit installed you can use forfiles. forfiles -pp:\zipfiles\hot\ -s -m*.* -d-20052001 -cCMD /C DEL /Q @FILE; Forfiles is helpful for ton's of DB Maintenance, you can pipe the results to any dos command you want. We use a statement like the one below

RE: Deleting Files in NT

Hello, You can use FORFILES from the NT Resource kit or you can download it from Dave Sisk's Web site http://www.ipass.net/~davesisk/oont_download.htm Your command will look like: FOREFILES -ppath -m*.* -cCMD /C del @FILE -d-7 -v C:\forfiles FORFILES v 1.1 - [EMAIL PROTECTED]

Re: 8.1.7. and OAS / iAS versions confusion

Oracle HAD to rename it -- they have consistently changed the name with each release, so they couldn't stop now! A brief history, from what I remember: Oracle Webserver 1.x Oracle Web Application Server 2.x Oracle Web Application Server 3.x? (whoops, I guess they kept it once, anyway I can't

NT-RE: Database Down-Dump and Mail Event Logs

Title: RE: Database Down Here some help from Paul Drake on NT diagnostics tools you can put in place to send yourself event logs. Sample code to email event logs C:\blat -install mail.mydomain.com [EMAIL PROTECTED] Failed to open registry key for Blat profile , using default. SMTP server

Another Database Down

Title: Another Database Down Well, I think the time for jubilation has been short-lived for me. The production database was recovered successfully due to archiving and luck. I also have a small, inhouse, remedy (help desk) database that I haven't done anything with and now recovery is

Re: Oracle DBA vs. Oracle Apps DBA - Different? and how?

I had the opportunity to meet the architect of Quest Software's "Spotlight for Oracle Apps" product in a recent demo. His opinion was that a good Oracle Apps Administrator has a good understanding (and experience) of the business/functional side of the Apps system. That knowledge/experience

RE: Oracle DBA vs. Oracle Apps DBA - Different? and how?

And managing the concurrent managers is an art in itself... Scott Shafer San Antonio, TX 210-581-6217 And no amount of training or preparedness can eliminate the almost certainty that in the middle of your Angry Crane stance, as you transition to your Combative Monkey to administer the Coup de

Re: OT RE: Mailing lists hosted by fatcity

(putting down dust mop momentarily...) well, that sounds just little bit unpleasant (david letterman imitation) http://www.aeroseal.com/ If your duct system needs to be sealed, a patented computer-controlled injection machine sends small dry adhesive particles into the duct system

RE: MICROSOFTDTPROPERTIES

The developer created the table and now doesn't know what is does??? As penance, said developer(s) must write I will document all changes fully and RTFM in their own blood, 10,000 times on the floor without using their hands. Then: 1) export tables=MICROSOFTDTPROPERTIES ...desired options

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

$ sar sar: can't open /var/adm/sa/sa23 No such file or directory I do see a /var/adm/sa/sa16 directory. What does this mean? Jacques, This is the file (not directory?!) that records the system activity information (in binary) via the sadc program. The file is named by day-of-the-month

RE: Database Down

Title: RE: Database Down -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]] Amen Sister!! I am afraid you all will have to be my virtual party people, since I am the only one around here that got excited when the recovery was done...so have a great

RE: MICROSOFTDTPROPERTIES

Is this table residing in an Oracle database ?? This is the special table that MS Access sets up in order to hold 2-3 little properties that it wanted. I don't want to cause Microsoft to drag me to court so I'm not clipping... Please get to www.microsoft.com, see explanation to Q247828 which

RE: Database Down

Title: RE: Database Down Whoopsby all means...LOL -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001 6:31 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database Down -Original

Re: ULIMIT setting: Urgent Please Help

Lisa, What do you mean by changing to posix shell? How does one do that? I know of tcsh, sh, ksh, etc shells, but did not know posix shell existed. well I tried to execute posix any way and it said /bin/posix: Permission denied. I only installed the SCO Unixware 7.1.1, so I can do any

RE: NT Scheduled Restart

Hi, I also use this to reboot a server (not our Oracle one though) but beware of the /C switch - this may not do a clean shutdown of your applications / Oracle. From the help on NT4: C Forces running applications to close. ATTENTION: If you use the /C parameter NT

RE: Another Database Down

Title: Another Database Down No need to panic yet! Check out Metalink note 1034037.6 which has about 4 possible reasons for this -- all pretty simple. -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001 7:27 PMTo: Multiple

RE: NT Scheduled Restart

Bruce, What I tend to do is not shutdown the Oracle database using the shutdown.exe. I execute a script fortnightly that first shuts down Oracle then calls the shutdown.exe to shutdown the box. In this way the database is down before the shutdown.exe executes. Similarly you can write a script

  1   2   >