RE: Any good product / option for Source code control
PVCS is a nice tool, especially when combined with PVCSTracker for change management. VSS (Visual SourceSafe) and PVCS offer similar capabilities when compared side-by-side. PVCS has an (optional) promotion model that VSS doesn't have (although VSS Labels can 'fake' it). Both tools have a command line capability contrary to Steven's note. PVCS has an API that is callable from 'roll-your-own' tools which is fairly cool of you want to write a lot of C/C++ code. VSS on the other hand has an exposed API that is callable from VBScript as an Active-X objectso that you can automate pushes through Active Server Pages and the like (been there..done that!). They're both nice toolsbut they're just _tools_ . You need to figure out how to best use them before you roll them out. HTH Jeff Herrick On Wed, 7 Jan 2004 [EMAIL PROTECTED] wrote: PVCS http://www.softlanding.com/merant/vm.htm I used this back when it was Intersolv that owned it. One useful thing about it was that the command line interface was well implemented so scripts to automate check in, check out, software builds, etc. could be written (and were written). -Original Message- I am looking for any good product/option for centralized source code control. Any pointer or experiences shall be appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Any good product / option for Source code control
Stephen, I stand correctedyour note never said anything about what PVCS could do that VSS could not do; it was only saying that PVCS _had_ a command-line option. I mis-interpreted it as a comparision since my own mind was already comparing the 2 tools =8-/ Cheers JH On Wed, 7 Jan 2004 [EMAIL PROTECTED] wrote: Contrary to what note, Jeph? -Original Message- Both tools have a command line capability contrary to Steven's note. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Writing a delay in PL/SQL?
try DBMS_LOCK.SLEEP() Cheers Jeff Herrick On Sat, 29 Nov 2003, Jonathan Gennick wrote: I know this is going to sound rather crazy, but I want to write an INSERT trigger that imposes an arbitrary delay, say a half second, or maybe a full second, on each and every insert operation. Does anyone know offhand whether there's a built-in PL/SQL procedure to just wait for a specified period of time? Any suggestions on how I can go about implementing this trigger? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: VPN to database?
We're doing it as I write this for a convention taking place half-way across the country. The setup is Client: Browser (IE), Cisco VPN Client, Adobe Acrobat, JInitiator Middle tier: 9iAS rel2 Forms and Reports Server on Win2K Db tier: Oracle 8.1.7 on Win2K All servers are on our private network. The only problem we're experiencing is from sloppy network setup at the convention center...we're dropping packets and the tunnel won't stay up. =8-( But when the tunnel is up, the forms and reports work like a charm since the addresses all resolve to hosts on the internal network. One problem we did run into was printingthey have an IP printer set up on the convenion sub-net and they are not able to print to it while they have the tunnel up (of course). The have to save the .PDF's, shutdown the VPN client and then print. Cheers Jeff Herrick On Fri, 24 Oct 2003, Paul Baumgartel wrote: We are an Application Service Provider--we maintain a set of servers in a colocation facility and our customers use our application via the Web. Security is a paramount concern, of course, and only our Web server has a public IP address, with the application and database servers completely private. We supply a number of standard reports, but most of our customers want some custom reports as well. We would like to give them access to our database, possibly over a VPN, but only if security can be maintained. I'd like to know if anyone has faced such a situation, and what kind of configuration (network/firewall/VPN/Oracle Net) might make such access possible. TIA, = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: BROKEN_PIPE from Weblogic
I don't think it's accurate to say that NET8 isn't involved when you're talking directly to the listener =8-) More correctly you are eliminating the NET8 client DLL's...but you could still have the connections dropping due to transient network failures. I have a particular problem with CISCO switches and TRU64 Alpha boxes in my environment. JDBC thick connections drop but because they are 'thick' I get a SQLNET.LOG file on the client that shows a TNS-12203 (unable to connect to destination) error. Other apps like Maximo report an ORA-3113 but also show the TNS-12203 error in their sqlnet.log files. When I do a level 16 listener trace I can see the connection being closed (read() error) but I've never been able to figure out why =8-( The only thing that moderates the problem is to make sure that the Alpha is set to 100MB/Full Duplex instead of auto-detect as well as hard-coding these values on the switch port. Ditto for the NT app servers. friends don't let friends auto-negotiate =8-) But I still see periodic TNS-12203's just less of them Try doing a level 16 trace from the listner end. Jeff Herrick On Thu, 9 Oct 2003, DENNIS WILLIAMS wrote: Agreed. By the way, since my original posting, this error has occurred several more times. Yes, it is a catch-all error that sounds a lot like an ORA-3113. Since they using the Oracle thin JDBC driver, which talks directly to the listener, Net8 isn't involved. If the server is shut down or crashes, apparently this error is also returned, like an ORA-3113. But the server hasn't crashed or shut down. [snip] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Integration with IBM Mqueue series
It's MQSeries =8-) It's a form of MOM (Message Oriented Middleware). The thing that it most closely resembles in the Oracle world is Oracle Pipes...except that the a queue can be persistent...i.e. survive a reboot. I'm not familiar with Advanced Queue Option so maybe Oracle now has that feature too. Anyway...it makes no sense to 'replicate' to MQ since your data would only be placed on a message queue from the Oracle end. What would be interesting is what is done with the data after it is put on the queue. =8-) MQ ships with an API that allows you to programatically place messages and retrieve messages on to and from the queues. You would need to make these libraries known to the extproc interface to be able to do anything useful with them. More likely you would write some sort of interface (C,C++,VB,java) between inserted/updated data that could then reference these API's Of course, what is written to the queue is highly dependant on what is reading it from the other (Big BLue!) end...so you could be writing data, XML or even SQL to be read and processed from the other end. HTH Jeff Herrick On Fri, 25 Jul 2003, Rakesh Gupta wrote: One of our clients requirement is to replicate data from oracle to IBM mqueue series. We are 100% oracle shop and we do not have any IBM DB experience. Can anyone please shed some light on how this can be done ? Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rakesh Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: calling an external procedure
On Thu, 3 Jul 2003, Foelz.Frank wrote: Hi all, before I smash my head against the wall.. I am trying to execute an external procedure defined in a C .dll. I have set up my tnsnames/listener.ora as following : [snip] Oracle tells me, that it is not able, to loead the dll. Error message is : ORA-06520: PL/SQL: Error loading external library ORA-06522: Unable to load DLL ORA-06512: at SYS.PRINTSTRING, line 0 ORA-06512: at line 2 Problems can arise due to name mangling in the .DLL Use the Depends.exe utility to open the DLL and look at the entry point name for your function. It probably is not what you expect it is. What I have found that works in the past is to declare the fuction as #define ORACMD_API __declspec(dllexport) extern C ORACMD_API void RunCommand(char *); The problem you're going to find is that the 'extern C' syntax is only supported in C++, so you will have to convert it to C++. Alternatively use the 'mangled' name in the Oracle definition and try that route The depends.exe utility comes with Visual Studio and can also be found in the Resource Kit for NT Cheers Jeff Herrick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: calling an external procedure
A couple of other things 1) create library zPrintString as 'c:/newsys/bin/PrintString.dll'; This should be 'C:\newsys\bin\PrintString.dll' in the WinBlows world 2) can you TNSPING your ext_proc service? After re-looking at your note I think that 1) is your problem since it can't find the DLL with the path '/' you gave it...I'm pretty sure the text just gets passed to the LoadLibrary() API. Once it locates the DLL you _might_ have the name mangling issues from my previous note HTH Jeff Herrick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: C++ Issues
Ethan Get him to install the 8.1.7 Client (Programmer) option on the Win2K Visual Studio machines. I noticed some slight source changes needed going from the 7.3.4 Proc*C version...i.e. EXEC SQL DECLARE's are needed everywhere nowbut they should be able to pre-process, compile and link. the question would be whether or not the 8.1.7 NET8 DLL's are backward compatible with the 7.3.4 DLL's that they will be running against...my _guess_ is that they would be ok Cheers Jeff Herrick psIf they are going to switch don't go to OCI or ODBC...get them to use Oracle Objects for OLE On Thu, 29 May 2003, Post, Ethan wrote: I am trying to track this down for a buddy, any ideas, I know nothing about C++. Thanks, Ethan Our application currently has presentation programs written in Microsoft Visual C++ that read Oracle Version 7.3.4 databases. We have Oracle Professional/2000 installed on 1 machine. The Pro*C/C++ pre-compiler provided by Oracle is the method we use to pre-compile our program. This pre-compile converts the EXEC SQL commands into C++ calls to incorporate the Oracle Database functions into the programs. Other methods I have found in research is to use OCI or ODBC calls. However everything I look at indicates that we would need to rewrite our applications to utilize additional include libraries as well as modify our SQL calls to wrap them with the appropriate language elements. We wish to fully utilize the functionality of the Microsoft Visual C++ Professional Edition environment to allow each developer to use their own machine to compile and unit test these programs. However, I am unable to get the pre compile process to work. Pro C will not run on our machines if it is not installed. We get a Incorrect environment variable. Please reinstall Pro*C/C++ message version error if we try to run the copy that is on the compiler machine from our machine. However, I can not install it because Oracle 7.3.4 does not support Windows 2000 and the installation process abends whenever I try to run it. What we are looking for is a method to compile, debug, and unit test using C++ on our machine without getting rid of Pro*C/C++ and yet utilize each developer's machine more to remove the load from our compiler machine. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: nt script
C:\ HELP and C:\ HELP FOR In there you'll find a note that the context variable should have '%%' instead of '%' in front of it when running in a bat file. You were using the bat file syntax from a command linewon't work. The opposite is also true...ask me how I know =8-) Jeff Herrick On Fri, 7 Mar 2003, Jacques Kilchoer wrote: Can anyone recommend a book / website on the DOS batch file language? I usually try to install cygwin and write shell scripts but some of our database servers don't have cygwin. For example, I have no idea what this statement does: FOR /F TOKENS=1,2* %%A IN ('DATE/T') DO SET DATE=%%B and when I tried it I received an error H:\FOR /F TOKENS=1,2* %%A IN ('DATE/T') DO SET DATE=%%B %%A was unexpected at this time. -Original Message- From: Jose Luis Delgado [mailto:[EMAIL PROTECTED] I'll try to help you between lines... i.e. I'll write the corresponding CMD line for your script. Regards! JL in a .CMD file: echo Sending mail!!! echo Sending mail!!! dt=$(date '+%H%M_%m%d%y') FOR /F TOKENS=1,2* %%A IN ('DATE/T') DO SET DATE=%%B export ORACLE_SID=FMRPT SET ORACLE_SID=FMRPT sqlplus / EOF! sqllog in a file: say a.sql put the code of your query and type: sqlplus user/[EMAIL PROTECTED] a.sql sqllog.log set heading off SELECT 'FMRPT PSNTRP02 SCHEDULER DOWN' FROM DUAL WHERE EXISTS (SELECT 'X' FROM PSSERVERSTAT ... ... cat sqllog |egrep 'DOWN' errfilelog type sqllog.log | findstr 'DOWN' errfilelog.log cat sqllog | egrep -q 'DOWN' I apologize for the previous line, I could not find a -q parameter of the egrep command, in my OS. anyway... 'guessing' type sqllog | findstr -look the apropiate cmd 'DOWN' if [ $? -eq 0 ] # found at least one if errorlevel 1 your_mail_program_here -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: storing credit card numbers in a database
Look into the DBMS_OBFUSCAITON package. I used it to encrypt passwords for a system management app and it works well. The only problem is that you need an encryption key for the programs to use. If anybody knows how to read the ALL_SOURCE view they will be able to find your key and decrypt the data. You can use the 'wrap' utility to try to hide it and then protect the un-wrapped source code up the ying-yang but if you use a text variable like I was crazy enough to to, the damn literal gets put into the wrapped source. You can use an expression of some sort but it's going to have to generate the key reliably each time and then what happens if it doesn't some day and all of your data becomes unreadable??? the literal starts looking betterbut you have to hide it well and protect it from being compromised. Not to toally turn you off of the packagebut I was coming at it from the angle that I was trying to protect the information from somebody like me =8-) HTH Jeff Herrick On Fri, 21 Feb 2003, Chris Stephens wrote: I've been asked to find out a way to encrypt credit card numbers and store that encrypted string in the database. ...any oracle functions or functionality to do this? or would we have to encrypt the numbers in the application and then pass that string to the database? We don't want anyone to be able to get to the numbers even if they have access to the table in which it is stored. Thanks for any input chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Set Email alert at NT
Use the NT 'AT' command to schedule a .bat file to skim your alert log and use BLAT (Public Domain SMTP utility) instead of mailx. As mentioned in the last few days batch file scripting is a poor substitute for a real shell but it's all do-able. The other problem is how to get rid of an error from the alert file after it has emailed you onceyou haven't said how you do this on your Unix box...looks like it will keep emailing you the same error every 30 minutes, but I could be missing something =8-) HTH Jeff Herrick On Fri, 21 Feb 2003, Mitchell wrote: Hi The following sh is one I used for monitoring all 20 instances on unix boxes(aix and sun). So I could receive the ora message by palm. Now there are 2 nt box with Oracle 8.17 installed. I have no idea how to do it in windows. Any idea? This is my ksh and run as cron job every 30 min. if [$(cat $ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log | grep 'ORA' | wc -l) -gt 0 ]; then cat $ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log | grep 'ORA' $HOME/alert_me mailx -s Warning: ${ORACLE_SID} Oracle Alert: ORA_error !!! [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] $HOME/alert_me fi Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trolling for ideas
Dennis Is there an sqlnet.log file tossed up on the VB client that has a TNS-12203 (unable to connect to destination) error? If so, make sure that the switch port the Alpha is plugged into has been hard-coded to 100Mb/s full duplex. Friends don't let friends auto-negotiate Known problem with Alpha/Cisco gear... Just a shot in the dark...but this solved a lot of Maximo crash issues for us. Cheers Jeff Herrick On Thu, 6 Feb 2003, DENNIS WILLIAMS wrote: I have a developer that wrote a VB program using ADO, connecting to Oracle 8.1.6 on a Compaq Tru64 server. One program of his runs for hours each night, and sometimes receives an ORA-03113 end-of-file on communication channel. Not consistently, just sporadically, and at varying amounts of time. I have been unable to find anything in the server logs. We have traced the program and the error occurs during different SQL statements. Followed most of the tips I've located on solving ORA-03113 errors. I am coming to the conclusion that maybe the only solution will be to upgrade Oracle and hope that solves the problem. Unfortunately we can only upgrade to Oracle 8.1.7.4. Does anyone have any other ideas? Thanks. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 100% CPU utilization, urgent
On Mon, 20 Jan 2003, Koivu, Lisa wrote: Thomas, thanks for your post. However I don't see where I can match the threads on NT to what I see in Task Manager. Am I missing something? To be more explicit, here's what I've got: Lisa, The point you're missing is that Task Manager shows _processes_ and the view is showing _threads_ . They're 2 distinct constructs. In its simplest sense a thread is an independently executing 'thread of execution' from a main task. This is how you see one process for ORACLE.EXE and its running multiple threads (PMON, SMON etc) if you look at the process using a tool such as PVIEW or PSTAT. Processes are spawned using the CreateProcess() API call and a process then spins off multiple threads using another call such as AfxBeginThread() (in C++). The threads all operate independently of each other and the programmer must be careful when accessing common areas of memory simultaneously by different threads. This is why in a Dr. Watson dump you will see what each thread is doing and one or more of them will usually be running WaitForSingleObject() which is a WIN32 way of serializing access to shared _process_ memory. Contrast this to the multi-process architecture that Oracle uses on Unix. The shared memory stuctures are separate from each individual _process_ and the processes use semaphores or latches to serialize access to the external memory segment. HTH Jeff Herrick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: iAS 903 902 install
Barb, I've been deploying forms over the web since OAS 4.07 and I had Oracle WebServer experience going back to version 2. What I found was that knowing all of that stuff made it worse for trying to figure out 9IAS Rel 2 (9.03). What further complicates it (web forms that is) is that if you read the documents on Metalink regarding the forms listener 'Servlet' implementation then you will be lost trying to set it up using 9.0.3 9IAS Rel 2 uses OC4J (Oracle Container 4 Java) to run the forms listener servlet so most of the config is done for you already. Your point of contact with the app server is the IAS_HOME\forms90\server\formsweb.cfg file which contains most of the variables that I used to hand-code in the static html JInitiator file. What you need to do to get a form up is 1) install the 9IAS Rel2 Infrastructure in its own home 2) intall the 9IAS Rel2 BI Forms and Reports install in its own home 3) install Forms9i/Reports9i in its own home 4) add a section called 'barb' to the IAS_HOME (not the infrastructure or forms home) \forms90\server\formsweb.cfg like the following [barb] form=your_main_menu.fmx separateFrame=True lookandfeel=Generic otherparams=others parms your forms might need 5) Add your forms path to the FORMS90_PATH variable in the file IAS_HOME\forms90\server\default.env 6) bring up the IAS instance in the OEM brower and stop and start the BI_FORMS OC4J instance 7) point your browser at http://yourserver:yourport/forms90/f90servlet?config=barb and your form should come up Note all of the port numbers that the install assigns. On a fresh install I got port=1810 for the OEM console and port=7778 for the first website. In comparison to OAS/OWS it's easy, that's why I say that knowing the earlier architectures can be even more confusing =8-) HTH Jeff Herrick On Fri, 17 Jan 2003, Barbara Baker wrote: List: I'm touching iAS for the first time ever. I don't understand even basic stuff about it. The install I have includes 9.0.2 and 9.0.3. The install says 9.0.3 is the first J2EE 1.3 compatible release of Oracle9iAS. ..blah blah.. Oracle9iAS 9.0.3 contains only the J2EE and Web Cache Installation Type of Oracle9iAS and is compatible with Oracle9iAS 9.0.2 infrastructures for clustering, management, and security. Do I need to install 9.0.2 and then install 9.0.3 on top of it to get everyting I need? We're currently in an evaluation phase. Developers want iAS to deploy forms, portal, and build apps with java. I have 9.0.3 installed, but don't really understand what I have, and we're not able to launch a form. Thanks for any help! (This is the most frustrating, confusing product I've ever seen) Barb __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: lost control files
Wrong...I _think_ :) If he rebuilds them using the correct file placements then it will work. The only problem is that he will have to open RESETLOGS and incomplete recovery will be impossible. But if he has all of his datafiles and is only missing control files then he can startup nomount and create controlfile from there. Jeff Herrick non-OCP DBA On Thu, 9 Jan 2003, David L Phillips wrote: No. It would be like getting amnesia and just using the memories of someone that looks like you. The data stored in the control files is unique to that database. It contains location of files, database name, recovery info etc. David L Phillips Database Consultant (8i OCP) Digital Concepts Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: wrong ELF class: ELFCLASS32
Recompile the 'C' module. The calling formats from the 64Bit external procedure handler don't line up with the 32Bit binary .so file. At least that's my SWAG at it =8-) Jeff Herrick On Wed, 8 Jan 2003, John Dunn wrote: We have a .so C library file containing C routines (Cfunctions.so) which we invoke via the external procedure listener. This file works fine with 32-bit 8.1.7 Oracle However we have now installed 64-bit 9i (9.2.0.1) and we now get the error, using exactly the same .so file ORA-06520: PL/SQL: Error loading external library ORA-06522: ld.so.1: extprocPLSExtProc: fatal: /export/home/opdd4229/lib/Cfunctions.so: wrong ELF class: ELFCLASS32 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9iAS Release2
On Wed, 8 Jan 2003 [EMAIL PROTECTED] wrote: [snip] What do I have to do to get a single code base to successfully run in all three (Dev., Q/A, Prod) environments (WITHOUT any changes to the code)? Charlie, This doesn't answer your question directly because it involves code changes _but_ what I do is pass 2 parameters into the f90servlet (using a custom config section) otherparms item that are picked up as globals within the form. One parameter is the webserver_url the other is the report server name. This limits the change to one file (formsweb.cfg) and also allows me to switch over to SSL by changing the protocol on the webserver variable. Something to think aboutI suppose if you want to do it completely without code changes you could do it by setting up 3 separate networks and using the same hostname within each network. If you isolate each DNS from each other and use host files on the client to resolve each host then it _might_ work =8-0 but YMMV Cheers Jeff Herrick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle.exe , CPU running at near 85%
Rick, Shot in the dark =8-) If Context (a.k.a. InterMedia) is involved I've seen a CPU pegged at 90% with a web app doing a dynamic text query using CONTAINS and a '-' minus operator. They actually didn't know about the '-' query op...they ended up searching the text string input and replacing '-' with '\-' and the problem dis-appeared. This was 8.1.7.0.0 BTW on Win2K. I found the problem using v$session joined to v$sqlarea. Luckily only the suspect query was running at the time. There are also spin problems with Net8 and many OCI multi-threaded connections. Just guessingI just got back from Christmas in Cuba and I'm trying to exercise my brain...it hurts =8-0 HTH Jeff Herrick On Fri, 27 Dec 2002 [EMAIL PROTECTED] wrote: Hi, Oracle 8.1.6 on NT 4.0 Oracle.exe is running at about 85% CPU utilization. What can I check to see why that is the case? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Implementing Continuous Managed Recovery on a Standby Database
Quit whining =8-) The behaviour is the same for any process that inherits it's stdin/stdout and stderr from the parent. Once the parent (your shell) goes away, the file handles are closed and the child has nothing to talk to. You only half-solved the problem with the nohup. You did the right thing by redirecting stdoutstdin was already pointing to the script file. I would go one more paranoid step further and redirect stderr too. Jeff Herrick On Fri, 6 Dec 2002, Orr, Steve wrote: Problem: How to keep a standby database in continuous managed recovery without having to maintain an open terminal session. (Version 8.1.7.2) When you execute the following... -- SQL RECOVER MANAGED STANDBY DATABASE; -- ...SQL*Plus does not return a prompt and the database is in continuous recovery BUT... as soon as you exit the session, recovery discontiues and the logs are nolonger automagically applied. No problem, I said, I'll just wrap it in a shell script and launch it in the background. Doesn't work and it appears SQL*Plus is a misbehaving process. (Linux) So then I tried nohup: -- $ nohup sqlplus / as sysdba @managed_recov.sql [1] 23412 $ nohup: appending output to 'nohup.out' [1]+ Exit 127 nohup sqlplus / as sysdba @managed_recov.sql -- The managed_recov.sql script contains this one line: RECOVER MANAGED STANDBY DATABASE; This works but it does not persist as a background process- it terminates when I hit enter or leave the terminal session. I think it terminates because SQL*Plus is misbehaving. What do you think? So with a little help from a *nix geek I did this... -- sqlplus / as sysdba @managed_recov.sql /dev/null standby.log -- ...presto chango, it works- standard I/O is OK and running in the background. The standby DB is in continuous recovery and I can shutdown my PC and go home and managed recovery just keeps on running. Cool. Is there a better way to do this? I submitted a TAR but OWS hasn't been any help. Doesn't it seem lame that Oracle gives the RECOVER MANAGED STANDBY DATABASE command but is unable to provide a means to implement it without requiring the terminal session to remain open? Whining in Bozeman, Montana Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: io error on alert file
If the W2K box was a converted NT box, I have heard of authentication issues within services. The credentials have to be re-created through the services control panel. The Access-denied error is usually due to a service's logon use not having the proper rights. If you are just using LocalSystem then I'm not sure this would be an issue butI would switch it temporarily to a user account and then back to LocalSystem to regenerate the security identifier. Also...check the NTFS permissions on the D: drive for who has write access. HTH Jeff Herrick On Thu, 5 Dec 2002, Joan Hsieh wrote: Hi Listers, We had a portal database with some other schemas on the win2000 box. we got error so often and needs to recover that datafile. It hits different datafiles each time. We created the tar with oracle, they pointed to Microsoft problem. Our nt group insisted they didn't see any error log. db version is 8.1.7.2 . Since we had the problem so often, I migrated the whole database and portal to UNIX box. I am curious if someone can give me light why this io access denied comes from? Joan Completed: alter database open Wed Dec 04 09:12:12 2002 KCF: write/open error block=0x8ba7 online=1 file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' Automatic datafile offline due to write error on file 14: D:\ORACLE\ORADATA\ORCL\SISDW.DBF KCF: write/open error block=0x8bd6 online=0 file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' KCF: write/open error block=0x8ba6 online=0 file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' KCF: write/open error block=0x8d5c online=0 file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Saving MSTask Scheduler Commands
I just tried this and it seems to work. It looks like you can copy/paste the task scheduler items to a backup folder. When they're pasted they show up as 1K binary files named 'whatever.job'. I looked at the file with a binary editor and it has the source of the script along with other schtuff =8-) To restore just select them from the backup directory and paste them into the scheduled tasks folder. NOTE ... don't try to right-click the task folder...there is no paste option therebut the Edit/Paste menu option will work. Standard warnings apply re: recreation of the user security identifier (SID) if you're moving to a new server. As a minimum I would think that you would have to open each task in the tool and re-authenticate. HTH Jeff Herrick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are There any way of calling NT OS Commands like print, del e
experience =8-0 Alsodon't try to redirect the stdout/stderr of the batfile through the DLL invocation. It won't work :( I fooled around for a while with command line parsing and opening/inheriting file handles from the CreateProcess API but I could not get it working. Anything that tries to use a GUI will also cause it to crash since there's no Desktop window handle. Ohand whatever you do, don't pass a command buffer larger than 1K (1024 bytes)...you'll notice the hard-coded values. It will crash for sure. Via con Dios/Caveat Emptor Jeff Herrick psif you want the .DLL binary (ie you don't have a Visual C++ compiler) then email me off-list for a copy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: To_Number
Did you check it with dump() ? select dump(unit_cost,16) from tablewhatever; for Hex. Check for unprintables that way. Try inserting the bad values into a look-aside table for later analysis i.e. create table look_aside (rownum rowid, bad_val varchar2(20), dump_val varchar2(200)); declare bad_num exception; numval number(10,2); pragma exception_init(bad_num,-1722); Cursor C1 is select rowid,unit_cost from yourtable; begin for x in C1 loop declare -- inner block will allow exception trap begin -- trim and change o's to zeroes numval := to_number(rtrim(replace(x.unit_cost,'O','0'))); exception when bad_num then insert into look_aside values (x.rowid,x.unit_cost, substr(dump(unit_cost,16),1,200)); end; end loop; commit; exception when others then dbms_output.put_line(sqlerrm); end; / You can use the rowids in the look-aside table to zap the bad values later. HTH Jeff Herrick On Thu, 5 Dec 2002, Burton, Laura L. wrote: Since we don't have that many 3rd party software packages I did make the mistake of asking 'Why??' and received 'Because!' so I too am trying to jump in and 'fix it'. As I responded to another email earlier, the RTrim worked because there were spaces after the amount which was causing the problem. The only problem now is I have one record (so far) that has a unit cost that looks like any other unit cost, yet I receive 'invalid number' for it. The only thing I can figure is that there must be an unprintable character in the field that I cannot see and rtrim is not deleting since it isn't a space. Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ora 29540 error
Install the JVM...see MetaLink Note:156477.1 Jeff Herrick On Wed, 4 Dec 2002, Randy Pace wrote: I get the following when trying to use the utl_tcp package on 8.1.7 database. The following error has occurred: ORA-29540: class oracle/plsql/net/TCPConnection does not exist ORA-06512: at SYS.UTL_TCP, line 537 ORA-06512: at SYS.UTL_TCP, line 199 ORA-06512: at SYS.UTL_SMTP, line 102 ORA-06512: at SYS.UTL_SMTP, line 121 ORA-06512: at KIVA.RP_SEND_MAIL, line 51 ORA-06512: at line 5 What is missing from the database in order for that to run? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: instance and database
1) Identify the database you wish to start using an environment variable (good old DOS) c:\ set ORACLE_SID=SID1 c:\ svrmgrl You can also use LOCAL=SID1...It will override ORACLE_SID Both of these variables can also be set in the registry under HKEY_LOCAL_MACHINE\Software\Oracle. LOCAL can be useful to 'hide' a remote database so that you don't have to specify 'connect user/passwd@remotedb' you can just 'connect user/pass' You can also set either at the System environment level using a right-click on My Computer / Properties / Environment using variable names LOCAL or ORACLE_SID It's good form to do a 'select * from V$database' after you connect to make sure you are working on the right database =8-0 2) A database can be opened by multiple instances when it's configured in an OPS (Oracle Parallel Server) environment. Not to sound 'flip' here but I wouldn't worry about OPS until you get your mind around how a single instance works :) OPS is now known as RAC - Real Application Clusters Cheers Jeff Herrick On Sat, 30 Nov 2002, john wrote: Oracle 8i on NT4.0 via the Oracle Database Configuration Assistant create another database. ie create another database with its instance and by default the db name and instance are same. say i proceed forward and create it. so now the box would have 2 separate services... OracleServiceSID1 OracleServiceSID2 is that correct ? question: if yes then next if i would start the svrmgrl and do a startup then which instance would be started ? is there a way to give the startup command to get only a particular instance started ? Next, the docs mention that it is possible to have two or more instance(s) associated with a given database. The above example shows two separate database, each with its one unique database. So how does one implement or have 2 instances for a given database ? can someone explain the difference between the two scenarios ? __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Error on the ORACLE-L list
You think that's bad...I've received 2 bounces from 2 different mail gateways for a suspected virus in my message. The first one was that ASP example you wanted Jared and the second was the ORACLE_SID on NT discussion. I can kinda understand the paranoia with the ASP code if they're using HTML mail agents but I can't see any reason why a couple of example DOS commands would make it barf. =8-0 BTWI'm using PINE thru a Telnet session to a BSD host for all my emails. So I know I'm _clean_ :) Jeff Herrick On Sat, 30 Nov 2002, Jared Still wrote: The error is 'relaying denied'. For some reason, the mail server thought your message was attempting to relay mail through the fatcity server. I'm no mail expert, but that's what it looks like. If it doesn't continue, don't worry about it. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Views Resources (7.3.4 DB)
Maybe the UNION is trying to resolve duplicates that it doesn't have to??? i.e. requiring a sort Have you tried UNION ALL Cheers Jeff Herrick On Sat, 30 Nov 2002, Lisa R. Clary wrote: I have 3 individual views (average #records=76,000) with the exact same variable names and datatypes. There is another view that is the union of the 3 individual views. If I use a count(*) operation (in sqlplus) on the view that is the union (or the individual view), I run out of temp space e.g. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP (108M temp space, ). If I do subsets, selects, whatever, the views are fairly quick with no problems-- I just can't perform count(*) operations Any ideas as to parameters in environment/temp space that would eliminate the extent problem relative to the count function? thanks, lc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle on windows and shadow thread file access
None...only the oracle background processes (threads in Winblows) access the datafiles/logfiles etc. All other communication is done through the SGA. On some Unix variants you _can_ reach a file_open max kernel parameter because each process (in a dedicated server scenario) opens it's own stdin/stdout/stderr. I guess the same could be true of processes running under windows too. So in the limit...you could hit a wall but only due to the per-process overhead. Cheers Jeff Herrick On Fri, 29 Nov 2002, Grant Allen wrote: Saw an interesting post in comp.databases.oracle.server postulating that if a shadow thread needed an open file handle on all files in a instance (or even some of them), the process handle limit in windows could constrain user scalability (e.g. too many users would result in ora-12500 unable to spawn errors and the like). (Let's ignore MTS/shared server mode for the moment) Sounded interesting, but I thought I'd ask if anyone knows whether a shadow thread (or process under unix) does open a handle on each file (control, data, redo), some of them, or none of them? Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle on windows and shadow thread file access
Jeremiah I _did_ say the background oracle 'processes' meaning lgwr,dbwr,ckpt threads on Win32 specifically. My understanding from the question was that he was wondering whether each user's process in a dedicated-server configuration opened all of the datafiles too but I might have mis-understood the question. On Fri, 29 Nov 2002, Jeremiah Wilton wrote: On Fri, 29 Nov 2002, Jeff Herrick wrote: None...only the oracle background processes (threads in Winblows) access the datafiles/logfiles etc. All other communication is done through the SGA. On some Unix variants you _can_ reach a file_open max kernel parameter because each process (in a dedicated server scenario) opens it's own stdin/stdout/stderr. I guess the same could be true of processes running under windows too. So in the limit...you could hit a wall but only due to the per-process overhead. Uh, I'm probably not going to be the only one to point out this isn't true. I don't know about Win32 thread architecture, but in Unix and unix-like operating systems, the shadow (server) processes each open whatever files they need for write. It is true that they also open the shared memory segments in order to write and read from the SGA, but they do the reading from disk. Otherwise, which process do you think is reading from the datafiles? [snip] On Fri, 29 Nov 2002, Grant Allen wrote: Saw an interesting post in comp.databases.oracle.server postulating that if a shadow thread needed an open file handle on all files in a instance (or even some of them), the process handle limit in windows could constrain user scalability (e.g. too many users would result in ora-12500 unable to spawn errors and the like). (Let's ignore MTS/shared server mode for the moment) Sounded interesting, but I thought I'd ask if anyone knows whether a shadow thread (or process under unix) does open a handle on each file (control, data, redo), some of them, or none of them? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle on windows and shadow thread file access
Jared, You're right. There's a cool diagram in the Server Concepts manual. So back to the original issue, scalabilty could be affected in a dedicated server configuration depending on how many files needed to be opened. I guess the problem could be mitigated by fewer/larger datafiles and/or MTS Cheers On Fri, 29 Nov 2002, Jared Still wrote: On Friday 29 November 2002 08:43, Jeff Herrick wrote: My understanding from the question was that he was wondering whether each user's process in a dedicated-server configuration opened all of the datafiles too Maybe not all of the data files, but the users dedicated server process will open datafiles as needed to read data into the block buffer. Now I don't know if I've helped any, or just added to the confusion. Jared but I might have mis-understood the question. On Fri, 29 Nov 2002, Jeremiah Wilton wrote: On Fri, 29 Nov 2002, Jeff Herrick wrote: None...only the oracle background processes (threads in Winblows) access the datafiles/logfiles etc. All other communication is done through the SGA. On some Unix variants you _can_ reach a file_open max kernel parameter because each process (in a dedicated server scenario) opens it's own stdin/stdout/stderr. I guess the same could be true of processes running under windows too. So in the limit...you could hit a wall but only due to the per-process overhead. Uh, I'm probably not going to be the only one to point out this isn't true. I don't know about Win32 thread architecture, but in Unix and unix-like operating systems, the shadow (server) processes each open whatever files they need for write. It is true that they also open the shared memory segments in order to write and read from the SGA, but they do the reading from disk. Otherwise, which process do you think is reading from the datafiles? [snip] On Fri, 29 Nov 2002, Grant Allen wrote: Saw an interesting post in comp.databases.oracle.server postulating that if a shadow thread needed an open file handle on all files in a instance (or even some of them), the process handle limit in windows could constrain user scalability (e.g. too many users would result in ora-12500 unable to spawn errors and the like). (Let's ignore MTS/shared server mode for the moment) Sounded interesting, but I thought I'd ask if anyone knows whether a shadow thread (or process under unix) does open a handle on each file (control, data, redo), some of them, or none of them? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Pro*C for Oracle 817 on Win2000?
Hello Pro*C can be found on the 8.1.7 NT/EE distribution which will run on W2K. It's under application development. The Borland compiled support was dropped a long time ago AFAIK. You can try using the .LIB's for VisualC++ for linking with your other compiler but I think you might be S.O.L. in that department. I think the library formats vary between compilers. Cheers Jeff Herrick On Wed, 27 Nov 2002, Denham Eva wrote: Hello, Apologies if this is the wrong list to write to, but some guidelines would be nice. We have a legacy software which requires changing. I would like to achieve this but as far as I can see there is no pro*c on otn.oracle.com for Win2k? Is it possible to load the libraries from somewhere? I have tried loading the Programmer option of the client, however from the errors received I don't have all the libraries. ie sqlca.h. I am trying to achieve this feat by using Bloodshed's DevC++. Am I being overly optimistic? I see there are libraries for VC++ and Borland, under the c:\oracle\ora81\oci directories. Unfortunately I don't have access to these programs? Any help will appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: is it possible ?
On earlier (Unix) versions the SID was used to hash a value for the shared memory segment identifier. If this still is the case then what you are asking is _NOT_ possible. V7 even had a length of SID restriction...but that is long gone. There were even cases of 2 different SID's hashing to the same ident and causing problemsbut I haven't heard of that one in a long time. HTH Jeff Herrick On Wed, 27 Nov 2002, Stephen Lee wrote: -Original Message- Is it possible For 2 Databases to be Brought up on the SAME machine with the SAME ORACLE_SID from Different ORACLE_HOMEs ? If so , how ? It would seem so. Listener setup might be a bit dicey. I might have to try this. It seems that as long as you had separate environments, it should work ... we're talking Unix here right? -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: calling Oracle stored procedures from ASP/ADO
Hi Jared, The following will work assuming you're using the Oracle OLE DB Provider. Note that this is _not_ the same thing as OO40 - Oracle Objects for OLE or as I like to call it Oracle Oily Objects =8-) I had a little trouble getting it going until I hard-coded the enumerated values for datatype and command type. I'm not an ASP whiz but it seems I'm probably just missing an include for some ADO manifests Cheers Connected to: Oracle8i Personal Edition Release 8.1.7.0.0 - Production JServer Release 8.1.7.0.0 - Production SQL create table test_table (field1 varchar2(2000)); Table created. SQL create or replace procedure test_proc (param in varchar2) as 2 begin 3insert into test_Table values (param); 4 end; 5 / ASP Code - begins html body form action=default.asp method=get Your name: input type=text name=fname size=20 input type=submit value=Submit /form % set objConn = server.createObject(adodb.Connection) ObjConn.ConnectionString=Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=username;Password=password;Data Source=ORCL objConn.open dim fname fname=Request.QueryString(fname) If fname Then set rs = Server.CreateObject(ADODB.command) set para = Server.CreateObject(ADODB.Parameter) para.Type=200 para.Size=20 para.Direction=1 para.Value=fname rs.CommandText = Test_Proc rs.CommandType = 4 rs.ActiveConnection = objConn rs.Parameters.Append para rs.execute set rs = nothing set para = nothing objConn.close set objConn = nothing Response.Write(Hello fname !br /) Response.Write(How are you today?) End If % /body /html HTH Jeff Herrick ps...good site is http://www.w3schools.com/ado/default.asp On Wed, 27 Nov 2002 [EMAIL PROTECTED] wrote: Does anyone have a good example of this? We have a developer here that has been unable to figure out how to do this properly. Numerous examples from support.microsoft.com are apparently no help. A particular problem seems to be declaring the args properly, as he consistently gets and 'invalid type on parameter' error from ODBC. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ole
Umm, The program sets up an ODatabase object and then references ODynaset objects to issue queries e.g. assuming you have a 3 edit control login dialog box with a class name of MYDialog. Somewhere in the InitInstance() member for the application object you should have #include oracl.h #include mydialog.h MYDialog dlg; ODatabase odb; int stat; OStartup(); // Initialize the OLE server if(dlg.DoModal() == IDOK) // run the connection dialog { stat = odb.Open(dlg.m_CSDatabase,dlg.m_CSUser,dlg.m_CSPass); // check for an error and if ok then proceed to use the // ODatabase object in calls to open ODynaset objects or // execute stored procedures etc. } Or if you're running as a service you can stash/retrieve the parameters in the registry through your code. The point is that everything has to be done through YOUR codeit's just an API Think of it as a Windows-only alternative to PRO*C. It's not like ODBC where you setup different connections through another tool. Generally speaking you need to 1) create a new project workspace with Visual Studio 2) copy ORACLM.LIB from the orawin install directory and insert it into the project 3) copy/insert oracl.h from the oracle directory 4) make sure your project starts up OLE (AfxOleInit()) and you call the Oracle supplied function OStartup() 5) compile against ORACLM.LIB and run against ORACLM.DLL Each client running your .exe must have OLE Objects installed and the Oracle data control registered. HTH Jeff Herrick On Fri, 25 Oct 2002, Thomas Day wrote: I've been reading the FM's but ... How do you set it up or change the connection? I've read a lot of nice puffery but where in the Oracle manuals will it tell you what need to be modified to make it work? Environment is Client: Win95 C++ - MS Developer Oracle 7.3.4 client Server: Oracle 8.1.7 database Win2K Is the OLE part of the Oracle software or part of the C++? The Fine Manuals seem to talk all around the actual, hands-on setting up the connection. Or can someone point me to where this is covered. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: off-topic -UNIX question
Hello Processes can test the validity of PID's by signalling the PID with a ZERO signal number. To signal the process you use the kill() system call. When a zero signal number is used error checking is done but no signal is sent so that you don't have to worry about what the process is going to do with a untrapped or ill-defined interrupt handler eg. #include stdio.h #include signal.h main(int argc, char *argv[]) { int pidno = atoi(argv[1]); if(kill(pidno,0) == 0) printf(pid number %d exists\n,pidno); else printf(pid number %d does not exist (or does not belong to you)\n,pidno); exit(0); } The above code will check the pid passed as the first command line argument to the program. Note that you can't signal arbitrary processes unless you are the superuser or the process is owned by your userid. HTH Jeff Herrick On Tue, 3 Sep 2002, Santosh Varma wrote: Hello all, I get a process id by calling getProcessId()..I want to know from program whether that processId exists. Any way to find out how ? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick 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: What is an API?
Beyond what the acronym stands for I would add that it's an interface to the 'guts' of COTS (Commercial Off-The Shelf) packages. Two examples I have worked with personnally are 1) WinFax API - ships as a set of DLL's that allow you to interface directly to the WinFax OLE object so that you can send faxes programmatically...in my case it was faxing purchase orders from Maximo 2) PVCS API - allows you to directly interface to information contained in PVCS archive files Other examples include one that ships with Financials, the Windows API's and others too numerous to mention. They usually ship as header files (.h) library files (.lib) as well as runtime (.DLL) files. The entry points are documented and you 'roll your own' from there. HTH Jeff Herrick On Wed, 28 Aug 2002, Jamadagni, Rajendra wrote: Application Programming Interface ... http://www.acronymfinder.com/af-query.asp?String=exact http://www.acronymfinder.com/af-query.asp?String=exactAcronym=API Acronym=API I have read a lot about the term API. I have searched the web and documentation and cannot find API is an abbreviation for? And, I cannot find a definition of what an API is? If someone could help me on this I would appreciate it. All the documentation I have assumes that the reader knows what an API is. Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick 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: Weird Windoze 'AT' Behavior
In the same veinif it's a system level environment variable that has been added since reboot, then you need a reboot of the server. Simply starting and stopping the Scheduler service is not enough since the scheduler service inherits its environment from the Service Control manager (Services.exe) which only reads its environment at system boottime. Cheers Jeff Herrick On Wed, 17 Jul 2002, Bishop Lewis wrote: The Scheduler is installed with IE5.5 - definitively worth the install. As far as executing some lines but not others - it sounds like a environment variable problem to me - put a set command (to list variables and a pause command in your script (or output a log file) and check that your environmental settings are okay. Lewis Bishop --- Oracle Database Consultant - Barclays Enable/ISS/OpenPlan Email:[EMAIL PROTECTED] -Original Message- Sent: 17 July 2002 16:14 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Dave, I've found AT to be flakey at best. I haven't had your specific problem, but I have had problems where AT would only occasionally run when it was supposed to. I don't remember if it was a specific NT patch or a version of IE explorer, but one of these will install a Scheduler utility, which I've found to be pretty reliable. If you open My Computer (or explorer) you should see a folder called Scheduled Tasks. Double-click and then use the wizard to set up a call to your batch file. HTH, -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 7/17/02, Farnsworth, Dave [EMAIL PROTECTED] wrote: I have Oracle 8.1.7 running on NT. I do cold backups nightly and have a batch file that is called by the NT 'AT' scheduler. I recently changed some lines of commands in the batch file and since then when the batch file is executed by 'AT' only the lines that I did not edit are executed. If I execute the batch file from the command prompt it works fine. I deleted the job from 'AT' and then entered it back in but still getting this odd behavior of only executing the commands that I did not edit. Our SA's know nothing about 'AT' so they are of no help. Has anyone else seen this odd behavior in the 'AT' function in Windoze? I know you find it hard to believe that something can be weird in Windoze. ;o) And yes, I am soon planning on learning RMAN and do hot backups. I have the 8i Backup and Recovery Handbook for my reading pleasure. I see the app that is being used going to a 24X7 schedule. Now it is only used during the day. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Davey 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). The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author
RE: What is the point to use alter database rename file command
Nope, goes back to at least 7.1 =8-) can't speak for 6 and pre 6 as I'm not that old :) (I am but I was too busy with 4 other types of db's!) The point is that you're only affecting 1 tablespace, the rest of the db stays available. Similarly, the window of 'unavailability' is smaller of you're only moving a couple of files versus all files (even with the speed of an 'mv' command) I guess the command would be pointless if you're the only user of the database and hence the only user being disrupted. =8-0 Jeff Herrick On Tue, 9 Jul 2002, Mercadante, Thomas F wrote: Jalil, You have to remember that some of these commands have been around for awhile. The Alter database command was the *only* way we could move data files in earlier versions of Oracle. Rebuilding new control files was only introduced just recently (in 8.0 I believe). I still would not rebuild a control file just to move a data file to a new location. Some of us old codgers are superstitious about these new-fangled-ways! Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 09, 2002 8:48 AM To: Multiple recipients of list ORACLE-L Hi list, What is the point to use alter database rename file command to move datafile? as we will need to update controle file anyway. So why not do the following directly to move datafile: - alter database backup contrlfile to trace and modify the location of datafile. - startup nomount and run the script inorder to update the controlfile. It works fine... So what is the point of alter database rename file command? Thanks in advance. Regards, -Jalil _ Do You Yahoo!? New! SBC http://pa.yahoo.com/*http://rd.yahoo.com/sbcyahoo/consumer/evt=640/*http:// sbc.yahoo.com Yahoo! Dial - 1st Month Free unlimited access -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick 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: Remote execution of pl/sql
Create a dblink to instance B from A and then within your proc on A do proc_on_b@B_INSTANCE(parameter1parameter_n); The schema that you use for the link to B must have execute access to the procedure on B HTH Jeff Herrick Jeff HErrick Associates On Tue, 25 Jun 2002, John Weatherman wrote: I am in the process of writing a pl/sql block to run on instance A. At one point, I need to run a procedure that resides in instance B against instance B's dataset. Is there an easy way to do this? The basic problem is: ### Set up Instance Source for replication ### ... ... dbms_offline_og.begin_instantiation(gname = 'gname', new_site = 'new_site'); ### Execute begin load against target ### dbms_offline_og.begin_load(gname = 'gname', new_site = 'new_site'); ### Return to Instance A to return code if everything is ready ### Is it possible to issue a connect within a PL/Sql block? TIA, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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: Jeff Herrick 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: Off Topic, slightly - Crystal Reports internal format
Jared 1) for the dbname...why not just change the SID in TNSNAMES that the ODBC DSN is using to point to the snap-shotted(?) instance 2) I think private synonyms would be the way to go for the table naming problem. Why did they not just use the same names on the snapshot sitebeen there done that, got the T-shirt HTH...or maybe I didn't understand your requirement =8-) Jeff Herrick Jeff Herrick Associates On Mon, 10 Jun 2002 [EMAIL PROTECTED] wrote: List, I have an 'opportunity' to make some points with end users, if possible. I'm booting the crystal reports users off of my production databases ( including SAP, can you believe that? ). There reports will now run against a reporting server with snapshotted tables. Their reports have been written with Crystal Reports 8 via ODBC. 2 problems: 1) When originally setup, the ODBC DSN matched the name of the database. Not smart I know, but I inherited it. Changing the data source in Crystal basically forces you to rewrite the report. 2) The username has changed. Production is CIMUSER, reporting is CIM_MV. The table names have '_MV' suffix in the reporting database. Any reasonable tool would allow you to change these items without too much fuss. Either CR8 is not reasonable, or I have just not found out how to do it yet. Without reconstructing the report that is. Any tips, resources, what have you are welcome. If you know of any documentation detailing the *.rpt file format, that would be most appreciated, as I could just modify their reports from the command line or with a hex editor. Thanks, Jared -- 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: Jeff Herrick 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: Off Topic, slightly - Crystal Reports internal format
On Mon, 10 Jun 2002 [EMAIL PROTECTED] wrote: 1) for the dbname...why not just change the SID in TNSNAMES that the ODBC DSN is using to point to the snap-shotted(?) instance I'm eliminating tnsnames.ora files on the desktop, so that is out. Sorry...I haven't used onames or OID yet; but does it not still provide the same level of abstraction as TNSNAMES without the file? The ODBC DSN is still separate and will have to resolve whether it is doing so through names or whatever. I still think you would change the logical side (service_name) to point at a different physical db and Bill's fine ODBC software won't care. The risk is that they use the same DSN for updating; then you would have a problem. 2) I think private synonyms would be the way to go for the table naming problem. Why did they not just use the same names on the snapshot sitebeen there done that, got the T-shirt Private synonyms will either: * not work * confuse the user. 'They' is me. The table names reflect the fact that the tables are materialized views. FWIW there are public synonyms for the tables, but Crystal doesn't use them. Jared 'Crystal doesn't use them'??? then the schema must be encoded in the SQR SQL statements. If this is true then you have another problem because you want to rename the schema. If you don't want to modify/recompile the SQR then why not create the schema that SQR expects and front the MV tables with synonyms. Oh...and when did we start caring if the user was confused? =8-) j/k Cheers Jeff H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick 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 make deletes faster.
How'bout 1) add a char(1) column...call it DELETE_ME and allow NULLS 2) index the DELETE_ME column 3) every night run an update like UPDATE yourbigwhackintable SET DELETE_ME = 'Y' WHERE the row satisfies your delete condition 4) DELETE FROM yourbigwhackintable WHERE DELETE_ME = 'Y' This is assuming of course you have free reign over the app as far as adding a column and the index. The index won't store the NULLs of the non-deleteable rows if you were worrying about index size BTW. Note..this technique is not 'mine'...I got it from a book (can't remember which one!) so your mileage may vary! Cheers Jeff Herrick Jeff Herrick Associates On Thu, 21 Feb 2002, sonia pajerowski wrote: Hello All, I have a non-partitioned table with 20 millions records and growing. Every night a pl/sql stored procedures deletes around 1 million rows 10,000 at a time.Currently it is taking aroung 1 hour to delete 1 million messages. Is there any way I can make deletes faster. I need good suggestions. I have already tried all the obvious init.ora parameters like make_delete_faster=true but they do not seem to work.:-) Thanks Sonia __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sonia pajerowski 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: Jeff Herrick 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: Where 1 = 1
Hi Ed It's useful in when generating DML on the fly and you don't have the inclination or the ability to determine if there are any other user-supplied (or otherwise generated) predicates or where/when the last predicate has been found. i.e. 1) Generate first part of Select (select foo from bar) 2) determine if there is at least one predicate and output 'WHERE' 3) loop thru predicates (from another table or a list box construct) 4) tack on the 'AND 1=1;' if you did step 3 5) prepare and execute the DML HTH Jeff Herrick Jeff Herrick Associates On Thu, 25 Oct 2001, Ed Bittel wrote: I was monitoring a load test of my company's new application when I came across something interesting. One of the more monstrous queries had the following as part of its WHERE clause: 'AND 1 = 1' Has anyone seen this used before? What is it supposed to achieve? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick 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).