RE: Bumoer Stickers [RE: Rebuilding indexes]
Don't worry - NT crashes more then I DO! -Original Message- Carmichael Sent: Saturday, June 02, 2001 02:56 To: Multiple recipients of list ORACLE-L THAT one I'll put on my car :) and my desk. and the developer's face From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Bumoer Stickers [RE: Rebuilding indexes] Date: Fri, 01 Jun 2001 13:32:25 -0800 On Fri, 1 Jun 2001, Kevin Kostyszyn wrote: What does RTFM mean? Beautiful. That's our bumper sticker. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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 FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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).
Oracle Standards Document Sought
Hi All I've recently been tasked with writing the Oracle Standards Documentat work. You know the sort of thing I mean - naming conventions fortables, columns, datafiles, tablespaces etc, mount points, init.orastandards et al. Would anybody be willing to send me the standards document you workfrom to use as a template? It would be much appreciated. The O/S is AIX - but any doc would be appreciated. Thanks in advanceDale Edgar
Re: Steps for removing jobs
Good stuff Anita, thanks! Jared On Saturday 02 June 2001 09:30, A. Bardeen wrote: Hi all! There have been several posts lately regarding how to kill or remove jobs from the job queue once they're running, so here are the steps. Background -- ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: to list administrator
On Saturday 02 June 2001 11:15, Arslan Bahar wrote: i have been receiving each mail two times No problem at this end. That means that the problem is in one of the mail relays between the list server and you ( we have no control over that ) or is a problem with the mail setup at your site ( we can't control that either :). Talk to your mail admin, I bet something has been changed recently. Jared ( list owner ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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 Standards Document Sought
Dale Edgar wrote: Hi All I've recently been tasked with writing the Oracle Standards Document at work. You know the sort of thing I mean - naming conventions for tables, columns, datafiles, tablespaces etc, mount points, init.ora standards et al. Would anybody be willing to send me the standards document you work from to use as a template? It would be much appreciated. The O/S is AIX - but any doc would be appreciated. Thanks in advance Dale Edgar There are some standards available in the 'Standards' section of the Oriole Web site - not a lot of things, we optimistically relied on external contributions to thicken the section a bit, but ... If you happen to find more interesting things to publish, don't forget us ... -- 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 ([EMAIL PROTECTED]) 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: OT: Is Linux A Cancer ? well M$ thinks so ...
On Saturday 02 June 2001 18:14, Paul Drake wrote: To Balmer - if Microsoft cannot own it - it is evil - and should not be funded. As not all Open Source work is licensed under the GPL, his statement is overly broad and therefore false. -- speaking of bumper stickers: http://www.vcnet.com/bms/sales/sticker.shtml === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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 SQLServer archivingq
Your friend is Not a MSSQL/NT/2000 expert, apparently! the answer is just the opposite. I like Oracle better too, but what you just said is not SQL server's weakness. -Original Message- Sent: Friday, June 01, 2001 11:07 AM To: Multiple recipients of list ORACLE-L This was actually one of the reason's I left my last employer. The decision was made to go to MSSQL and I was given the same specs as with Oracle, ie: no lost transactions no matter what. I hired a friend who is a MSSQL/NT/2000 expert to train me. No mirrored redo/transaction logs. Hardware RAID does not help when a LUSER like me does a del * There were other issues that made me uncomfortable but robustness was the primary one. SQLServer is an excellent workgroup product, it is not suitable for enterprise/realtime/CAD-CAM systems. IMHO Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: James Xing 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 SQLServer archivingq
Your friend is Not a MSSQL/NT/2000 expert, apparently! the answer is just the opposite. I like Oracle better too, but what you just said is not SQL server's weakness. -Original Message- Sent: Friday, June 01, 2001 11:07 AM To: Multiple recipients of list ORACLE-L This was actually one of the reason's I left my last employer. The decision was made to go to MSSQL and I was given the same specs as with Oracle, ie: no lost transactions no matter what. I hired a friend who is a MSSQL/NT/2000 expert to train me. No mirrored redo/transaction logs. Hardware RAID does not help when a LUSER like me does a del * There were other issues that made me uncomfortable but robustness was the primary one. SQLServer is an excellent workgroup product, it is not suitable for enterprise/realtime/CAD-CAM systems. IMHO Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: James Xing 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 Standards Document Sought
I think the OFA would be a great place to start, you can find that on my website under Articles/Standards. www.vampired.net -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/3/01 2:25 PM Dale Edgar wrote: Hi All I've recently been tasked with writing the Oracle Standards Document at work. You know the sort of thing I mean - naming conventions for tables, columns, datafiles, tablespaces etc, mount points, init.ora standards et al. Would anybody be willing to send me the standards document you work from to use as a template? It would be much appreciated. The O/S is AIX - but any doc would be appreciated. Thanks in advance Dale Edgar There are some standards available in the 'Standards' section of the Oriole Web site - not a lot of things, we optimistically relied on external contributions to thicken the section a bit, but ... If you happen to find more interesting things to publish, don't forget us ... -- 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 ([EMAIL PROTECTED]) 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).
RE: NT - Re: one more question about NT bat script
Andrea, Another generic way to do this that will work for those commands where Microsoft did not include a /y? option: echo y | del *.* This used to be what was required in pre-NT days. Regards, Bruce -Original Message- Sent: Sunday, 3 June 2001 2:26 Andrea Oracle wrote: Hi, one more question about bat script in NT 4.0: when I put del c:\test\*.* in the bat file, and run it, I got Are you sure (Y/N)?, how to surpress this question? Thank you. del /Y Paul C:\del /? Deletes one or more files. DEL [/P] [/F] [/S] [/Q] [/A[[:]attributes]] names ERASE [/P] [/F] [/S] [/Q] [/A[[:]attributes]] names names Specifies a list of one or more files or directories. Wildcards may be used to delete multiple files. If a directory is specified, all files within the directory will be deleted. /PPrompts for confirmation before deleting each file. /FForce deleting of read-only files. /SDelete specified files from all subdirectories. /QQuiet mode, do not ask if ok to delete on global wildcard /ASelects files to delete based on attributes attributesR Read-only filesS System files H Hidden files A Files ready for archiving - Prefix meaning not If Command Extensions are enabled DEL and ERASE change as follows: The display semantics of the /S switch are reversed in that it shows you only the files that are deleted, not the ones it could not find. -- 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: NT script question ???
Andrew,
Batch parameters are referred to as %1, %2 etc
%0 is the name of the calling command.
%* refers to all parameters
You can use the shift command to move parameters (do help shift)
As an example:
C:\batchtype param_test.bat
@echo off
echo %1
echo %2
echo %0
echo %*
C:\batch
C:\batch
C:\batchparam_test.bat one two three four five
one
two
param_test.bat
one two three four five
C:\batch
To append the date / time, use the for command to split up the output of
time and date commands.
For example:
C:\batch test_time.bat
[08504789]
[0604Mon]
---
@echo off
rem test_time.bat
call :get_timestamp
call :get_datestamp
goto :EOF
:::
:get_timestamp
:: get the time in format hhmmssxx, where 'xx' is hundredths of a
second
:: because want ssxx can not use time/t
for /f tokens=1-8 delims=:. %%a in ('echo.^| time ^| find current')
do (
set zhh=%%e
set zmm=%%f
set zss=%%g
set zxx=%%h
)
if 10 GTR %zhh% set zhh=0%zhh%
:: assign the values to ztimefull
set ztimefull=%zhh%%zmm%%zss%%zxx%
echo [%ztimefull%]
rem cleanup
set zhh=
set zmm=
set zss=
set zxx=
goto :EOF
:::
:get_datestamp
:: get the time in format mmdd
for /f tokens=1-8 delims=:.-/ %%a in ('echo.^| date ^| find
current') do (
set z=%%h
set zmm=%%g
set zdd=%%f
)
:: assign the values to zdatefull
set zdatefull=%z%%zmm%%zdd%
echo [%zdatefull%]
rem cleanup
set z=
set zmm=
set zdd=
goto :EOF
:::
---
A more useful example of parameters might be:
@echo off
rem PURPOSE
remdelete_oldfiles.bat
remdeletes files greater than or equal to x days old
rem Note - directories are not deleted.
rem does not delete read only, hidden or system files
rem 18-Apr-2000 , Bruce Reardon : Creation.
rem USEAGE
rem Parameters - %1 = path , %2 = file mask ,
rem %3 = how many days old , %4 (optional) - recurse
rem ASSUMPTIONS
rem none.
rem REQUIRES
rem forfiles.exe - distributed with NT Resource kit
rem that forfiles.exe be located at c:\nt4reskit
rem SIDE EFFECTS
rem envdelold env variable will be overwritten and deleted if it exists.
rem MODIFICATIONS
::
rem Parameter validation.
IF %3== goto param_problem :: not enough params
IF NOT %5== goto param_problem :: too many params
rem check parameter 3 is a valid number
set envdelold=
IF %3==0 goto param3_ok
set /a envdelold = 1*%3 2 nul:
IF %envdelold%==0 goto param3_problem
IF %envdelold%== goto param3_problem
:param3_ok
IF NOT %4== IF NOT %4==-s goto param4_problem :: invalid param 4
IF NOT EXIST %1. goto param1_problem
rem we now have 3 (possibly 4) parameters and they have been
validated.
echo %1 %2 %3 %4
rem the actual command - put quotes around to allow for names with
spaces.
c:\nt4reskit\forfiles -p%1 -m%2 %4 -d-%3 -ccmd /c if @ISDIR==FALSE del
0x22@FILE0x22
goto end
:param_problem
echo %0
echo ERROR - Must pass in 3 parameters (4 max)
echo Param 1 is the path
echo Param 2 is file mask
echo Param 3 is number of days
echo Param 4 (optional) : if -s then recurse subdir's.
echo.
echo eg %0 c:\temp *.* 5 would delete ALL files in c:\temp directory 5
or more days old
goto end
:param1_problem
echo %0 [--[%1]--] %2 %3 %4
echo ERROR - 1st parameter invalid
echo Param 1 is the path and it must exist.
echo.
echo eg %0 c:\temp *.* 5 would delete ALL files
echo in c:\temp directory 5 or more days old
goto end
:param3_problem
echo %0 %1 %2 [--[%3]--] %4
echo ERROR - 3rd parameter invalid
echo Param 3 is the number of days and it must be a valid number
echo.
echo eg %0 c:\temp *.* 5 would delete ALL files
echo in c:\temp directory 5 or more days old
goto end
:param4_problem
echo %0 %1 %2 %3 [--[%4]--]
echo ERROR - 4th parameter invalid
echo Param 4 (optional) : must be -s (to recurse subdir's) or be
blank.
echo.
echo eg %0 c:\temp *.* 5 -s would delete ALL files
echo in c:\temp directory (incl subdirs) 5 or more days old
goto end
:end
rem - batch file finished
set envdelold=
---
-Original Message-
Sent: Sunday, 3 June 2001 9:15
Hi,
I have couple of questions about bat file in NT 4.0
for Oracle 8.1.5.
1. how to make bat file take parameters. I had a
backup.bat, and like to pass in Oracle SID, so the
script can backup any database.
2. in the bat file, how to dynamically append
date/time into a
No Subject
I have the following in a blob column:
18 21:20:48 CDT 2001: Customer notified of: Order
Accepted
Wed Apr 18 22:11:09
CDT 2001: Order cancelled: demo
Wed Apr 18 22:11:09 CDT 2001: Flagged for
Review.
When I run the following via SQL*Plus:
select
dbms_lob.instr(order_text,utl_raw.cast_to_raw('Customer'),1,1)
from order_help where order_id=5944108;
I get the answer: 103
What's up with that? :) Shouldn't I be getting back a
result of 23 (give or take 1)?
The contents of the BLOB column (order_text) were
converted from a LONG RAW using the TO_LOB( )
function, prior to the above query.
Thanks again!
-w
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Walter K
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).
PRO*C problems (sqlcode 2)
List, We seem to have a problem with one of our PRO*C programs that we execute. We are using Oracle 8.1.6.3.4 on Windows NT 4.0 SP 6a. We use MKS Toolkit to run our korn shell scripts. Last night we got an sqlcode 2 in our error logs for the pro*c program. I am not a C programmer, as the DBA I am trying to establish were this error came from. This caused our nightly job to abort unsuccessfully. What I know is that when a the programs exit with an sqlcode 0, it means that the job completed successfully. But sqlcode 2, not really sure. This pro*c program used to run successully previously, but last night we ended up with problems. Nothing changed from a db version, or in the korn shell, or in the parameter file.. No errors were logged in the alert log, or trace files. It makes it difficult huh. Since we are using MKS Toolkit. Will the pro*c be run from MKS or from Oracle. I have looked the docs, and logged a TAR with Oracle but still waiting for a response. I also see that with PRO*C there are lots of bugs and fixes in previous releases. So I would have hoped it would be stable in 8.1.6.3. If you have an insight. Let me know Thanks and Regards Suhen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather 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).
Oracle 9i is on technet (NT)
-- 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).
Re: Oracle 9i is on technet (NT)
for NT? I just went there, they had Solaris, not NT... did I miss something? From: Christopher Spence [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Oracle 9i is on technet (NT) Date: Sun, 03 Jun 2001 18:05:23 -0800 -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i is on technet (NT)
What is NT? :) -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/3/01 10:40 PM for NT? I just went there, they had Solaris, not NT... did I miss something? From: Christopher Spence [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Oracle 9i is on technet (NT) Date: Sun, 03 Jun 2001 18:05:23 -0800 -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Oracle 9i is on technet (NT)
Oh heheh, (NT) means no text, not Nice try, I mean Windows NT. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/3/01 10:40 PM for NT? I just went there, they had Solaris, not NT... did I miss something? From: Christopher Spence [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Oracle 9i is on technet (NT) Date: Sun, 03 Jun 2001 18:05:23 -0800 -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Oracle 9i is on technet (NT)
Did *I* miss something? I got mine in the mail well over a month ago... -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/3/2001 10:40 PM for NT? I just went there, they had Solaris, not NT... did I miss something? From: Christopher Spence [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Oracle 9i is on technet (NT) Date: Sun, 03 Jun 2001 18:05:23 -0800 -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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).
NT script
Hi, Thank you all very much for answering my NT batch script question. Do you mind I ask another one? I pass in SID as a parameter, if they don't pass it in, I'd like to echo out an error message. So how to check whether the parameter is passed in or not? I never write bat file before. Are there some good ways, web site/book/doc that I can do some research by my own, so I don't have to bug people whenever I got a question. Thank you! Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! 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).
Re: Check/Remove stray shared_memory_segment and semaphore
Yep. That's what I meant :-) In fact, if you select parallel server option, relink fails. There is a flag missing and not documented anywhere other than one metalink post..:-) Took two weeks just to install the software and talk about fire all your DBAs crap.. Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Jared Still [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/02/01 05:56 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Check/Remove stray shared_memory_segment and semaphore Not necessary to use glibc-2.1, Oracle has a patch for using with glibc-2.2. It's on the download page for linux Oracle, it's at technet.oracle.com. It is a set of stubs that point 2.1 calls to 2.2 functions. It requires relinking Oracle and includes instructions. Jared On Friday 01 June 2001 19:15, [EMAIL PROTECTED] wrote: Hi Look under $ORACLE_HOME/bin for oracle executable. Do you see the file ? There was an installation bug and the relink fails with out creating the executable. If you do see the file then, check under $ORACLE_HOME/rdbms/log for any alert messages or traces. Also, Did you follow the procedure to use glibc-2.1 instead of glibc-2.2 ? Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Apps Sol [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/01/01 11:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Check/Remove stray shared_memory_segment and semaphore Folks, I am trying to start a new db on one of my new Linux box Dell 2450 , RHAT 7.0 and 8.1.6 .. 1GB ram and huge disk space .. but I get a error at SVRMGR ORA-03113: end-of-file on communication channel when I further checked and changed my SID to a new one .. no luck I even tried DBASSIST (Hate to do it though) no luck .. there is no error in my alert log Can any one tell me what are the things i need to look into .. Cheers RK Content-Type: text/html; charset=us-ascii; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: PRO*C problems (sqlcode 2)
Send the source for the proC program. At 05:45 PM 6/3/01 -0800, you wrote: List, We seem to have a problem with one of our PRO*C programs that we execute. We are using Oracle 8.1.6.3.4 on Windows NT 4.0 SP 6a. We use MKS Toolkit to run our korn shell scripts. Last night we got an sqlcode 2 in our error logs for the pro*c program. I am not a C programmer, as the DBA I am trying to establish were this error came from. This caused our nightly job to abort unsuccessfully. What I know is that when a the programs exit with an sqlcode 0, it means that the job completed successfully. But sqlcode 2, not really sure. This pro*c program used to run successully previously, but last night we ended up with problems. Nothing changed from a db version, or in the korn shell, or in the parameter file.. No errors were logged in the alert log, or trace files. It makes it difficult huh. Since we are using MKS Toolkit. Will the pro*c be run from MKS or from Oracle. I have looked the docs, and logged a TAR with Oracle but still waiting for a response. I also see that with PRO*C there are lots of bugs and fixes in previous releases. So I would have hoped it would be stable in 8.1.6.3. If you have an insight. Let me know Thanks and Regards Suhen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather 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: Hal Wigoda 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).
Which SQL is executing
Hi All, From v$open_cursor, I know every SQL opened and parsed in one session. Is there any way to know which SQL is running. Or put another way, canall the SQLs in one session be sorted in timing order dynamically? Any clue would be much appreciated. Chuan
Fw: OFA New Installation
I'm setting up an 8i solaris installation on ha-cluster with disk array and veritas vol manger. I've only got 10 18gb disks (mirrored) for my prod/test/dev environments. I will OFA the Prod only. Data + Index Approx 30GB I'll use RAID 1 for disks 1-5 RAID 1+0 for Disks 6-10. my disk config - any comments greatly appreciated Disk1 - Control01.ctl system01 temp01 rbs01 /prodbinaries DIsk2 - Control02.ctl Redo01a Redo02a Redo03a Disk3 - Control03.ctl Redo01b Redo02b Redo03b Disk4 - /devRedo01c Redo02c Redo03c tools Disk5 - /arch /test1 Disk6 - data Disk7 - data Disk8 - data Disk9 - index Disk10 - index issues - temp and rbs on same - ive guess its okay if sorts mainly in memory - redo01 02 03 on same drive - I know contention when arching but .. - I have to find room for at least 1 clone of production pref 2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Roberts 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).
OCP Model Questions
Hi All, I have compiled some model questions for OCP DBA Test at http://www.oraref.com (mirrored at http://smart_and_handsome.tripod.com/oracle.html). If you have more, I will be happy to add them to the Web Page. -- Krishna _ 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: Krishna Kakatur 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: NT script and NT Script resources
Andrea, See the delete_oldfiles.bat I posted for an example of checking for a parameter. Do something like IF %1== echo No parameter 1 passed. Books I haven't tried these but some have suggested: Windows Admin Scripting Little Black Book By Jesse Torres Windows NT Shell Scripting Macmillan Technical Publishing ISBN 1-57870-047-7 Resources NT batch specific news:alt.msdos.batch.nt http://groups.google.com/groups?oi=djqas_ugroup=alt.msdos.batch.nt UltraTech knowledge base http://www.ultratech-llc.com/Personal/Files/?File=ResKit.TXT JSI Windows NT/2000 Tips, Tricks, Registry Hacks and more... http://www.jsiinc.com/Reghack.htm#Tip%20Index NT/Win2k scripting - good on bat differences between NT and DOS http://www.seanet.com/~shardy/ntscript.html Resources batch general: Batfiles: The DOS batch file programming handbook and tutorial - good examples and hints / tricks http://home7.inet.tele.dk/batfiles/ DOS Batch Language: A personal view by Ted Davis - good intro for beginners http://131.151.112.77/~batch/batchtoc.htm news:alt.msdos.batch http://groups.google.com/groups?oi=djqas_ugroup=alt.msdos.batch Multilingual Batch Programs http://gearbox.maem.umr.edu/~batch/multilingual.html Programs by Prof. Timo Salmi - THE author of the alt.msdos.batch FAQ http://garbo.uwasa.fi/pc/ts.html and then search for tsbat67.zip 184193 Mar 8 11:16 A collection of useful batch files and tricks, T.Salmi Have fun, Bruce -Original Message- Sent: Monday, 4 June 2001 2:35 Hi, Thank you all very much for answering my NT batch script question. Do you mind I ask another one? I pass in SID as a parameter, if they don't pass it in, I'd like to echo out an error message. So how to check whether the parameter is passed in or not? I never write bat file before. Are there some good ways, web site/book/doc that I can do some research by my own, so I don't have to bug people whenever I got a question. Thank you! Andrea -- 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).
