RE: UNIX
Joe, Chris uh, yeah Joe, I guess that's what I'm asking...I'm just trying to map the tablespaces/datafiles to the disk and "df -k" gives me something like Filesystem Mounted on/dev/dsk/c0t3d0s0 //proc /procfd /dev/fd/dev/dsk/c0t3d0s1/tmp/dev/dsk/c0t0d0s0/u01/dev/dsk/c0t0d0s1/u02/dev/dsk/c0t0d0s3/u03/dev/dsk/c0t1d0s0/u04/dev/dsk/c0t1d0s1/u05/dev/dsk/c0t1d0s3/u06/dev/dsk/c0t2d0s0/u07/dev/dsk/c0t2d0s1/u08/dev/dsk/c0t2d0s3/u09 I'm expecting that to correspond to something like (c)ontroller, (t)arget, (d)isk and (s)lice. However, I know thereare at least 4 disks while everything is displaying as d0 andit's a test box so no RAID. However, I do have a box that uses RAID 5 and the same info would be helpful, however, the person that did the original configuration is gone bye-bye, that's why I was wondering if there were any sys admin commands or a filie in the /etc or some other standard UNIX directory that would tell me this info. Richard Huntley -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 3:28 PMTo: Multiple recipients of list ORACLE-LSubject: Re: UNIX Richard, are you asking about how to see the underlying striping/slicing? I thought only the unix/sysadmin could tell you for sure, or the person who did the original slicing. joe [EMAIL PROTECTED] 07/10/01 01:51PM Does anyone know of a command or file that would display the available diskson a Solaris 2.6 box and/or the corresponding disks for each mount point???TIA,Richard Huntley-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Richard Huntley INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: UNIX
Richard, df -k will show you what slices of a disk have an entry in /etc/vfstab AND have been mounted using the mount command in Solaris. Whoever has root privileges to the system (or have been given the right permissions) can use the format command to see all disks attached to the machine, no matter if they have been mounted or not - no matter if they have an entry in /etc/vfstab or not. HTH, Julie Julie Fisher Sandia National Laboratories Oracle 8i DBA - OCP8i Solaris 2.6,7/HP-UX 11.0 System Administrator Web Server Administrator -Original Message- Sent: July 10, 2001 1:23 PM To: Multiple recipients of list ORACLE-L Df -k This does not cover raid volumes, that would depend which volume manager your using. -Original Message- Sent: Tuesday, July 10, 2001 1:52 PM To: Multiple recipients of list ORACLE-L Does anyone know of a command or file that would display the available disks on a Solaris 2.6 box and/or the corresponding disks for each mount point??? TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley 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: Christopher Spence 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: Fisher, Julie 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: Installation oracle through responsefile
With WWS help, we have tried the non-interactive installation. We have NEVER gotten it to succeed. Terry Brijesh Lal wrote: Hi All I am trying to install oracle 8.16 in non-interactive mode(silent) mode. However installation does not proceed and fails I am giving following command runInstaller -silent -responsefile /oracle/response/ ee_typical.rsp However in /tmp/silentInstall.log I get following error No forced value specified for the variable ORACLE_HOME, associated with property ToLocation, in dialog oracle.sysman.oii.oiif.oiifw.OiifwInstLocWCDE This silent installation was unsuccessful. Warning :*** Alert: Do you really want to exit? *** I have done following setting in ee_typical.rsp UNIX_GROUP_NAME=dba #FROM_LOCATION;String;Used in Dialog #Full path for the products.jar file. FROM_LOCATION=/data1/cdrom1/stage/products.jar #ORACLE_HOME;String;Used in Dialog ORACLE_HOME=/oracle/product/8.1.5 Can anyone please help in solving this problem Thanks for the help in advance Regards Brijesh __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal 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: Terry Ball 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: need to recreate database
Lyuda, My guess is that if your networking folks performed the copy for you and now all you have to do is get it up and running, you're probably better off starting over. If the database wasn't shutdown when the controlfiles were copied, you're hosed. I have no idea what you mean by copying the datafiles - if the whole thing was shut down when the copies were made, then why would you have to do an import/export? - the data is already there. Let's suppose that the networking guys knew about Oracle, and had shut everything down before copying it (and copied) everything they needed to. Safest bet is to move all the stuff to someplace else on your server or another server, and follow this advice from Note #1080849.6 : 1. Install the Oracle software on server B. You cannot simply copy the orant folder to the new machine. Registry entries must be modified, file dependencies between Oracle and the Operating system, and between multiple Oracle homes (if applicable) must be checked, services must be created, etc. 2. Shut down the instance on server A. 3. Move all the data files, redologs, archive logs, control files, listener.ora, tnsnames.ora, initSID.ora and configSID.ora to server B. 4. On server B, open a Command Window and execute the following command: oradim80 -new -sid sidname -intpwd password -pfile path_to_init_file -startmode auto 5. Change the listener.ora to reflect server B's hostname. 6. Change all the tnsnames.ora files on the clients to reflect server B's hostname. 7. Restart the listener. 8. Edit the initSID.ora dna configSID.ora files to reflect the correct directory paths on server B for your
Re: UNIX
Not to be pedantic, but df -k shows all mounted partitions, regardless of whether they are in /etc/vfstab or not. It requires read permisions on /etc/mnttab (whihc should be readable by everyone, but I suppose some sick SA could change it so that only root could read it. The system would function normally, but non-root users wouldn't be able to use df functionally. George - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 4:29 PM Richard, df -k will show you what slices of a disk have an entry in /etc/vfstab AND have been mounted using the mount command in Solaris. Whoever has root privileges to the system (or have been given the right permissions) can use the format command to see all disks attached to the machine, no matter if they have been mounted or not - no matter if they have an entry in /etc/vfstab or not. HTH, Julie Julie Fisher Sandia National Laboratories Oracle 8i DBA - OCP8i Solaris 2.6,7/HP-UX 11.0 System Administrator Web Server Administrator -Original Message- Sent: July 10, 2001 1:23 PM To: Multiple recipients of list ORACLE-L Df -k This does not cover raid volumes, that would depend which volume manager your using. -Original Message- Sent: Tuesday, July 10, 2001 1:52 PM To: Multiple recipients of list ORACLE-L Does anyone know of a command or file that would display the available disks on a Solaris 2.6 box and/or the corresponding disks for each mount point??? TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley 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: Christopher Spence 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: Fisher, Julie 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: George Schlossnagle 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
Somebody posted this url here a while back. It's a pretty neat tool, but you gotta have root access to run it. http://members.tripod.com/rose_swe/cfg/cfg.html --- === Michael P. Vergara | Ive got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -Original Message-From: Richard Huntley [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 1:21 PMTo: Multiple recipients of list ORACLE-LSubject: RE: UNIX Joe, Chris uh, yeah Joe, I guess that's what I'm asking...I'm just trying to map the tablespaces/datafiles to the disk and "df -k" gives me something like Filesystem Mounted on/dev/dsk/c0t3d0s0 //proc /procfd /dev/fd/dev/dsk/c0t3d0s1/tmp/dev/dsk/c0t0d0s0/u01/dev/dsk/c0t0d0s1/u02/dev/dsk/c0t0d0s3/u03/dev/dsk/c0t1d0s0/u04/dev/dsk/c0t1d0s1/u05/dev/dsk/c0t1d0s3/u06/dev/dsk/c0t2d0s0/u07/dev/dsk/c0t2d0s1/u08/dev/dsk/c0t2d0s3/u09 I'm expecting that to correspond to something like (c)ontroller, (t)arget, (d)isk and (s)lice. However, I know thereare at least 4 disks while everything is displaying as d0 andit's a test box so no RAID. However, I do have a box that uses RAID 5 and the same info would be helpful, however, the person that did the original configuration is gone bye-bye, that's why I was wondering if there were any sys admin commands or a filie in the /etc or some other standard UNIX directory that would tell me this info. Richard Huntley -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 3:28 PMTo: Multiple recipients of list ORACLE-LSubject: Re: UNIX Richard, are you asking about how to see the underlying striping/slicing? I thought only the unix/sysadmin could tell you for sure, or the person who did the original slicing. joe [EMAIL PROTECTED] 07/10/01 01:51PM Does anyone know of a command or file that would display the available diskson a Solaris 2.6 box and/or the corresponding disks for each mount point???TIA,Richard Huntley-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Richard Huntley INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: UNIX
You do have 4 disks, it's t0, t1, t2 and t3. Each target is a separate disk. You can use the format command to see the disks and it's partitions. [EMAIL PROTECTED] 07/10/01 04:20PM Joe, Chris uh, yeah Joe, I guess that's what I'm asking...I'm just trying to map the tablespaces/datafiles to the disk and df -k gives me something like FilesystemMounted on /dev/dsk/c0t3d0s0 / /proc /proc fd /dev/fd /dev/dsk/c0t3d0s1/tmp /dev/dsk/c0t0d0s0/u01 /dev/dsk/c0t0d0s1/u02 /dev/dsk/c0t0d0s3/u03 /dev/dsk/c0t1d0s0/u04 /dev/dsk/c0t1d0s1/u05 /dev/dsk/c0t1d0s3/u06 /dev/dsk/c0t2d0s0/u07 /dev/dsk/c0t2d0s1/u08 /dev/dsk/c0t2d0s3/u09 I'm expecting that to correspond to something like (c)ontroller, (t)arget, (d)isk and (s)lice. However, I know there are at least 4 disks while everything is displaying as d0 and it's a test box so no RAID. However, I do have a box that uses RAID 5 and the same info would be helpful, however, the person that did the original configuration is gone bye-bye, that's why I was wondering if there were any sys admin commands or a filie in the /etc or some other standard UNIX directory that would tell me this info. Richard Huntley -Original Message- Sent: Tuesday, July 10, 2001 3:28 PM To: Multiple recipients of list ORACLE-L Richard, are you asking about how to see the underlying striping/slicing? I thought only the unix/sysadmin could tell you for sure, or the person who did the original slicing. joe [EMAIL PROTECTED] 07/10/01 01:51PM Does anyone know of a command or file that would display the available disks on a Solaris 2.6 box and/or the corresponding disks for each mount point??? TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Richard Huntley 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: Richard Ji 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: oradim
Lyuda, Besides a brief mention in the Oracle8i for Windows 2000 Release Notes, all I've found (and needed, for that matter) is via executing oradim -help at the command line. Oradim doesn't do very much and oradim -help lays it all out for you. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 2:23 PM To: Multiple recipients of list ORACLE-L Can anyone point to oradim utility documentation? I am having a little hard time finding it. Thank you. Lyuda Hoska -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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
Shoot, had to look up pedantic... Ok, I agree that df looks at /etc/mnttab to see mounted file systems, but in order for an SA to mount a slice of a disk, that slice information must be present in /etc/vfstab. At least that's the way I learned. It's possible to have a mounted file system without having an entry in /etc/vfstab?? How do you do that? I guess I've never heard of this or tried to mount a slice without putting an entry in /etc/vfstab first. Can you manually manipulate /etc/mnttab? Thanks, Julie Julie Fisher Sandia National Laboratories Oracle 8i DBA - OCP8i Solaris 2.6,7/HP-UX 11.0 System Administrator Web Server Administrator -Original Message- Sent: July 10, 2001 2:50 PM To: Multiple recipients of list ORACLE-L Not to be pedantic, but df -k shows all mounted partitions, regardless of whether they are in /etc/vfstab or not. It requires read permisions on /etc/mnttab (whihc should be readable by everyone, but I suppose some sick SA could change it so that only root could read it. The system would function normally, but non-root users wouldn't be able to use df functionally. George - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 4:29 PM Richard, df -k will show you what slices of a disk have an entry in /etc/vfstab AND have been mounted using the mount command in Solaris. Whoever has root privileges to the system (or have been given the right permissions) can use the format command to see all disks attached to the machine, no matter if they have been mounted or not - no matter if they have an entry in /etc/vfstab or not. HTH, Julie Julie Fisher Sandia National Laboratories Oracle 8i DBA - OCP8i Solaris 2.6,7/HP-UX 11.0 System Administrator Web Server Administrator -Original Message- Sent: July 10, 2001 1:23 PM To: Multiple recipients of list ORACLE-L Df -k This does not cover raid volumes, that would depend which volume manager your using. -Original Message- Sent: Tuesday, July 10, 2001 1:52 PM To: Multiple recipients of list ORACLE-L Does anyone know of a command or file that would display the available disks on a Solaris 2.6 box and/or the corresponding disks for each mount point??? TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley 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: Christopher Spence 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: Fisher, Julie 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: George Schlossnagle 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
lock problem
Hi, we need to create a index on hot table(lot of updates r going on) but we r getting error: ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified when i use create indexonline it just hangs there... Is there any option to create index while not stopping the batch updates. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh 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
Richard, I think I know what you want. If you are trying to determine the actual physical disks that your datafiles are layed out on, and you're on Solaris, you probably need to use the 'vxprint' command. This assuming you have Veritas volume manager, which many Solaris sites use. What you find may surprise you. I know I was when I discovered the TEMP file system mapped onto the spare space on 156 physical disks. Jared - #!/bin/ksh # # Script to convert a File System mount point to a list of disks in ssdxx form # # jkstill 02/24/2000 - some mods to make this much faster PROG=$(print $0 | sed -e 's,.*/,,g') # Name of this program USAGE_MESSAGE=Usage: $PROG filesystem if (( $# != 1 )); then print $USAGE_MESSAGE exit 1 fi VX_TMP_FILE=/tmp/vxprint.out.$$ DFOUT=$( df -k $1 | grep -v Filesystem | awk '{ print $1 }' ) VXDG=`echo $DFOUT | cut -f5 -d/` VXVOL=`echo $DFOUT | cut -f6 -d/` #print DFOUT = $DFOUT #print VXDG = $VXDG #print VXVOL = $VXVOL vxprint -tsg $VXDG | grep $VXVOL | cut -c67-74 | $VX_TMP_FILE #print 1 = $1 while read device do #print $device Y=$( /bin/ls -lL /dev/dsk/${device}s0 | /bin/cut -f2 -d, | /bin/awk '{ print $1 }' ) #print $Y ((Z = Y / 8)) print ssd${Z} done $VX_TMP_FILE - Richard Huntley rhuntley@mindle To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] aders.com cc: Sent by: Subject: UNIX [EMAIL PROTECTED] 07/10/01 10:51 AM Please respond to ORACLE-L Does anyone know of a command or file that would display the available disks on a Solaris 2.6 box and/or the corresponding disks for each mount point??? TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley 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: need to recreate database
Tuesday, July 10, 2001, 1:26:38 PM, Lyuda wrote: lcc I have not done it before and if I was doing it I would probably do lcc export/import type of thing but the higher ups would like to have it done lcc this way. Uh oh. Damagement at work again. Let the higher ups do it themselves if they are that picky. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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
Nope, you don't need an entry in the /etc/vfstab. You can just do a mount options block_device mount_point and you're set. Of course that won't be remounted when you reboot unless you put it in the vfstab. This is a classic blunder (you mount a new fs by hand, add datafiles and forget to add it to the vfstab. Low and behold, when the box is rebooted, all your file 'disapear') Best, George p.s. I believe that manually altering mnttab is very very bad. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 5:36 PM Shoot, had to look up pedantic... Ok, I agree that df looks at /etc/mnttab to see mounted file systems, but in order for an SA to mount a slice of a disk, that slice information must be present in /etc/vfstab. At least that's the way I learned. It's possible to have a mounted file system without having an entry in /etc/vfstab?? How do you do that? I guess I've never heard of this or tried to mount a slice without putting an entry in /etc/vfstab first. Can you manually manipulate /etc/mnttab? Thanks, Julie Julie Fisher Sandia National Laboratories Oracle 8i DBA - OCP8i Solaris 2.6,7/HP-UX 11.0 System Administrator Web Server Administrator -Original Message- Sent: July 10, 2001 2:50 PM To: Multiple recipients of list ORACLE-L Not to be pedantic, but df -k shows all mounted partitions, regardless of whether they are in /etc/vfstab or not. It requires read permisions on /etc/mnttab (whihc should be readable by everyone, but I suppose some sick SA could change it so that only root could read it. The system would function normally, but non-root users wouldn't be able to use df functionally. George - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 4:29 PM Richard, df -k will show you what slices of a disk have an entry in /etc/vfstab AND have been mounted using the mount command in Solaris. Whoever has root privileges to the system (or have been given the right permissions) can use the format command to see all disks attached to the machine, no matter if they have been mounted or not - no matter if they have an entry in /etc/vfstab or not. HTH, Julie Julie Fisher Sandia National Laboratories Oracle 8i DBA - OCP8i Solaris 2.6,7/HP-UX 11.0 System Administrator Web Server Administrator -Original Message- Sent: July 10, 2001 1:23 PM To: Multiple recipients of list ORACLE-L Df -k This does not cover raid volumes, that would depend which volume manager your using. -Original Message- Sent: Tuesday, July 10, 2001 1:52 PM To: Multiple recipients of list ORACLE-L Does anyone know of a command or file that would display the available disks on a Solaris 2.6 box and/or the corresponding disks for each mount point??? TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley 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: Christopher Spence 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: Fisher, Julie 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
Re: oradim
when you create the bat file using the db assist you should see in that bat file like below set ORACLE_SID=orcl e:\orant\bin\oradim80 -new -sid orcl -intpwd oracle -startmode auto -pfile e:\orant\database\initorcl.ora e:\orant\bin\oradim80 -startup -sid orcl -starttype srvc,inst -usrpwd oracle -pfile e:\orant\database\initorcl.ora As you must be knowing the first command of oradim is used for creating the service and the second is used for starting the database automatic. there is no compulsary thing that the second command should run , but the first is a must otherwise NT will not allow you to start the database. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: oradim Date: Tue, 10 Jul 2001 11:23:24 -0800 Can anyone point to oradim utility documentation? I am having a little hard time finding it. Thank you. Lyuda Hoska -- 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). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C 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).
DBMS_STATS
Steve You mentioned about dbms_stats having some teething problem on version 8.1.6. Can you provide some more details? I was planning to implement on version 8.1.6.2 on Compaq Tru64 unix 5.1. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash 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 execute Unix Command/program within a pl/sql block.
Unless I disrember, you can create a PL/SQL wrapper for your Java stored procedure, and call OS commands from that. Another way is to create an external library to do it for you. This can also be in in Java, or in C. Jared MHately@etech- uk.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: How to execute Unix Command/program within a pl/sql omblock. 07/10/01 02:37 AM Please respond to ORACLE-L Hi, you can't do this from PL/SQL but you can do it from Java and it's fairly easy too. I'm not able to check the name of the class tht does it but armed with the phrase java os command and either the Metalink or Ask Tom web site you should be able to track it down. Regards, Mike |+--- || Stephane | || Faroult | || sfaroult@ori| || ole.com | || | || 07/10/01 | || 12:20 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: Multiple recipients of list | | ORACLE-L [EMAIL PROTECTED] | | cc: (bcc: Mike Hately/ETECH) | | Subject: Re: How to execute Unix | | Command/program within a pl/sql block. | | Seema Singh wrote: Hi How to execute unix command in PL/SQL ? Thanks in advance. -Seema You can't. The nearest you can get is to write a daemon program which waits for commands on a (dbms) pipe, executes them (popen(), while(fgets()) {}, pclose() in C) and feeds the output back to the pipe. Needless to say, it can be a serious security gap if you do not screen the commands, since you are likely to execute them with the privileges of the user under which the said program is run. Many moons ago, there used to be something named 'flex' developed by Oracle consultants and freely available on the web which was more or less doing that. It may or may not still be around. I have had a look at it after having developed my own (in Pro*Fortran and under VMS, nothing stops me - no pipe, but a /OUTPUT=... was appended to the command and I was reading and sending back the ouput file) and I can tell you that Flex was unnecessarily complicated. To make simple seems very difficult to many people. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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
RE: Email/Paging/Mobile Phone alerts
Does anyone have a similiar script for doing the same on Windows NT. Thanks Ravindra -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of John CarlsonSent: Thursday, February 22, 2001 5:30 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Email/Paging/Mobile Phone alerts I will make the assumption this is on unix and you can write a shell script. Here is a skeleton of the code. You can put your own checks it. EXAMPLE #!/bin/ksh tail -1f alert_x.log | while read linedo any other code you want here. echo $line | grep ORA- if [ $? -eq 0 ] ; then ( error=`echo $line | sed 's=:.*=='` echo "To: [EMAIL PROTECTED]" echo "Subject: `uname -n` $error" echo "`uname -n` alert_log" echo $prevline | sed 's=:=-=' echo $line | sed 's=:=-=' ) | mail [EMAIL PROTECTED] fi prevline=$line done This will run perpetually and check every line the alert log writes. You can test for any messages you want and send messages to whatever. Note the sed command changes ':' to '-' because mail has a problem with colons in the text body sometimes. Also, some mail servers cannot handle it properly without the extra "To:". Obviously, this is just a snippet of code. You need to customize it for your own needs. You may need to write other scripts to query the database to get number of connections and active connections if you need that. HTH, John Carlson http://www.cj.com [EMAIL PROTECTED] 02/22/01 03:15PM I am looking at a solution of sending a email/paging/Mobilephone alertsin case of a problem on the database that is reported in the alert.logfile. like tablespace full,no. of processes exceeded,instance going downetc.I want a solution other than OEM.What are the other ways of sending suchalert to notify the person who takes care of the database.Thanks-Ravindra-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED]
Privilege problem ?????
Hi all, I wrote a script for developers to run. I have svrmgrl, connect internal in the script. The developer got error since he doesn't have privileges. So how to make the script runnable by non dbas??? Thanks. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
Why default domain?
The O'Reilly Net8 book states: It's possible to run a Net8 network without using domains at all. If this is true, why create net service names that are qualified by a domain name, why define a default domain in sqlnet.ora, etc.? What benefit do you get by setting things up to use a domain? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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).
HASH_MULTIBLOCK_IO_COUNT
Jared - we were wrong, there are worse applications than Remedy out there. I may be involved with one now. The application uses massive sql statements generated from a VB front-end connecting to COBOL on the server via ODBC that runs against the database. Some of our power users have been receiving intermittent ORA-03232 errors. From the manual: ORA-03232 unable to allocate an extent of string blocks from tablespace string Cause: An attempt was made to specify a HASH_MULTIBLOCK_IO_COUNT value that is greater than the tablespace's NEXT value. Action: Increase the value of NEXT for the tablespace using ALTER TABLESPACE DEFAULT STORAGE or decrease the value of HASH_MULTIBLOCK_IO_COUNT. HASH_MULTIBLOCK_IO_COUNT specifies how many sequential blocks a hash join reads and writes in one IO. When operating in multi-threaded server mode, however, this parameter is ignored (a value of 1 is used even if you set the parameter to another value). Because Oracle computes the value for this parameter based on the query, you need not set the value for this parameter. The maximum value for HASH_MULTIBLOCK_IO_COUNT varies by operating system. It is always less than the operating system's maximum I/O size expressed as Oracle blocks (max_IO_size/DB_BLOCK_SIZE). This parameter strongly affects performance because it controls the number of partitions into which the input is divided. If you change the parameter value, try to make sure that the following formula remains true: R / M = Po2(M/C) where: R = size of(left input to the join) M = HASH_AREA_SIZE * 0.9 Po2(n) = largest power of 2 that is smaller than n C = HASH_MULTIBLOCK_IO_COUNT * DB_BLOCK_SIZE Right now, I don't want to alter the value of next, as this beast is barely under control as it is. So I thought I might change the value of HASH_MULTIBLOCK_IO_COUNT. Problem is, I can't seem to determine a value for R. v$sqlarea and v$sqltext don't seem to be of much help outside of being able to see the actual sql. Ditto with a few others I've tried. Any takers? Oracle 8.1.7/HPUX 11(64 bit) David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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: oradim
Try the Oracle 8i Admin guide for NT Here's the ORADIM part: http://www-wnt.gsi.de/oragsidoc/doc_817/win.817/a73008/ch5.htm#1027981 Jared lhoska@calibre sys.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: oradim om 07/10/01 12:23 PM Please respond to ORACLE-L Can anyone point to oradim utility documentation? I am having a little hard time finding it. Thank you. Lyuda Hoska -- 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: 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: Sizing a new server
Hi Lisa, I also have good feelings for VMS so don't see the problem with an Alpha. As for the disk farms, the RAID 7000 gave very good performance on VMS so 2 of the es10K should be excellent. You and your company are of course aware that Compaq is planning to stop Alpha chip development in 2-3 years and will port Tru64, VMS and NonStop Kernel OS to Itanium processor family. (if not see http://www.compaq.com/newsroom/pr/2001/pr2001062501.html and http://www.compaq.com/hps/ipf-enterprise/ceo_letter.html as starting points). Regards, Bruce Reardon -Original Message- Sent: Wednesday, 11 July 2001 2:11 To: Multiple recipients of list ORACLE-L Hi Lisa, That doesn't sound too bad, the 8400 is a solid piece of kit. 64-bit, up to 14 CPUs and 28G of memory. They have seriously good I/O bandwidth. Needs a three-phase power supply and weighs, literally, half a tonne. And best of all, you can run VMS on them! g -Original Message- Sent: Tuesday, July 10, 2001 2:46 PM To: Multiple recipients of list ORACLE-L Bruce, It's going to be Unix, tru64. Unfortunately I will be stuck with some old hardware to start with - an Alpha, 8400, I believe maxes out at 8 cpu's, along with two old disk farms (compaq esa10k). I'm slapping together a bunch of old pieces of hardware, upgrading where needed, obtaining software licensing where needed, compaq hardware/software support, and with some duct tape, political brown-nosing done by others and a few users screaming for their data, I'll hopefully end up with some sort of reporting tool hitting this. (BizObj or Cogno$). Man Cognos is expensive. I wish I could choose AIX here. It's not an option. See doesn't this sound like a director's job?? Say it again: I LOVE MY JOB Lisa -Original Message- [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 8:50 PM To: Multiple recipients of list ORACLE-L Lisa, Some may laugh at the question but what OS - NT, Unix, VMS or ? Regards, Bruce Reardon -Original Message- Sent: Tuesday, 10 July 2001 4:36 To: Multiple recipients of list ORACLE-L Thanks Kimberly, I wish it was that way. I have to justify my request with hard numbers or they are going to laugh at me when I say, Because that's what I want. :) They don't yet know how I'd react to that, it would be a knee-jerk type of reaction involving creative expletives... not pretty. Good for you. At least you have some real hardware and true HA. I wish I did Lisa -Original Message- Sent: Monday, July 09, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Get the biggest, kick ass server they will let you buy. If your site is anything like mine they just keep asking for more and more databases. So no matter what I have now I know its not enough. I am really happy with the nice new N-class HP cluster I have sitting next door running Service Guard. I am also getting a A-class database cluster for some important but not fab critical databases. Now if I can only get ride of the 5 K-class database servers. Its kind of like when you go from a fast to a slow PC. Drives me crazy. Not that there are issues with performance from the databases. It would only be me, while playing (which of course means working) on the server, that would notice. -Original Message- Sent: Monday, July 09, 2001 8:30 AM To: Multiple recipients of list ORACLE-L Good morning everyone, Lucky me, I get to choose the size of the server this company should consider purchasing. I have been poking around on the net for any guidelines - I can make guesses based upon my gut feel and how strapped the current unix server is, but I want to be able to back this up with hard numbers. This is for a dw application. Can anyone point me to a website, book, or anything in particular that can help me justify sizing a machine? It's so fun working for a company that doesn't have a sysadmin on staff... Thanks Lisa Koivu Oracle Data Bored Administrator Ft. Lauderdale, FL, USA 954-935-4117 -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: Rename alert log
Hi, I have just found the email I posted earlier about this in the List archives. To find it search for when it will need to delete the alert log file I can't comment on the accuracy with respect to Unix as don't use it. Under NT as others have said you can just rename the alert logfile and a new one will be created. The note summary is: Deleting the alert.log when the database is up Type: Note Doc ID: 122401.1 Modified Date: 14-MAY-2001 Status: PUBLISHED Platform: Unix Generic issue Product: Oracle Server - Enterprise Edition V7 Regards, Bruce Reardon On Sunday 27 May 2001 18:10, Reardon, Bruce (CALBBAY) wrote: Hi, For information. At various times there has been a lot of discussion about deleting = the alert.log. Looking through Metalink I found the following note which describes = the behaviour change between 7.3.4 and 805 and above. Hope it is of help. Regards, Bruce Doc ID: Note:122401.1 Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 18-OCT-2000 Last Revision Date: 14-MAY-2001 Problem Description --- The Oracle background processes has an open file descriptor on the alert.log. When the database is up and running it continually holds this file descriptor open. This was not the case in 7.3.4, but is true for 8.0.5 to 8.1.7. This poses the question: What if the database is up and the alert.log gets too large. Do I have to shutdown the database to release the = open file descriptor on the alert.log, then deal with the large alert.log? Solution Description You are able to copy the alert.log while the database is up and = running. 1) Create an empty file: (example: touch nullfile.log) 2) Replace the old alert.log with the new empty file: (example: mv nullfile.log alert.log) The running database experiences no affects when doing this. Explanation --- Having the continual open file descriptor on the alert.log is = intended behaviour for the database. References -- [BUG:1388186] OPEN FILE DESCRIPTORS HELD BY ORACLE BACKGROUND = PROCESSES ON ALERT.LOG FILE Additional Search Words --- delete alert -Original Message- Sent: Wednesday, 11 July 2001 5:06 To: Multiple recipients of list ORACLE-L dunno about NT, I do know that it changed on Unix.. as per a thread here in the not too distant past. I believe Anita had posted something on it.. and that it WAS a change from prior versions. I am an Oracle on NT ignoramus :) From: Mercadante, Thomas F [EMAIL PROTECTED] Date: Tue, 10 Jul 2001 10:00:34 -0800 In 816 on NT, you can rename it any time you want. is this changing in 817 Rachel? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 10, 2001 1:27 PM depends on the version of the database you are running.. it used to be that yes, you could just rename it and Oracle would open a new one of the original name when it needed to write to it. In 8.? and above, you can no longer just rename it, Oracle now maintains an open file pointer to it, similar to the way it handles the listener log file. So you will need to do the same sort of tricks to the alert log as you have to do to the listener log (make a copy then copy /dev/null to the original) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: Why default domain?
In short, I don't. I use local resolution (as our ONS is frequently down and unreliable) and none of my aliases have domain names attached to them. In my sqlnet.ora, the entries about default domain, etc. are all commented out. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 8:35 PM The O'Reilly Net8 book states: It's possible to run a Net8 network without using domains at all. If this is true, why create net service names that are qualified by a domain name, why define a default domain in sqlnet.ora, etc.? What benefit do you get by setting things up to use a domain? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: Jon Walthour 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).
Setting event 10032
hi all, this is an excerpt from Steve Adams site http://www.ixora.com.au/newsletter/2000_12.htm First you need to determine the largest disk sort that is performed by the batch process. This can be done by setting event 10032 at level 1 in the session and then examining the process trace file. I wanted to know how to set the event at level I use 8.1.5,8.1.6,8.1.7 on Windows NT 4.0 8.1.6,8.1.7 on RedHat Linux 7.0 thanks in advance cozI am anoviceOracle Certifiable DBBS
Bored!!!
Dear Audrey, Change your employer, go some place where you have N number of platforms and N types of DB's. I am sure u will soon say the opposite. Regards __ Visit us at www.singaporeair.com. __ -- 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).