Re: wat kind of data can be keep in blob,clob,nclob
grace wrote: hi gurus, wat kind of data can be keep in a blob, clob or nclob? eg. picture image must be kept using clob only... pls give examples and some sample programs(forms or report) that actually use them. Best regards, Grace Lim Suy Sing Comm'l Corp. 632-2474134 LOBs are used to store values which are bigger than the 4,000 character limit of varchars and raws. I think that a good criterion would be how you would transfer the data using ftp; BLOB (Binary LOB) is for anything which reaches the other end corrupted when you have forgotten to say 'binary' - images, typically, which should not be stored as CLOBs, but also say Word documents. CLOBs are for anything you would transfer as 'ASCII'. NCLOBs are chiefly for text which uses multibyte characters - If you have to store text in Chinese or Tamil (I guess Malay would be OK in CLOBs), a NCLOB is probably what you need. Do not forget BFILEs, externally stored LOBs (in plain English, references to files). For many applications, they may be more appropriate than the full-blown, Oracle-stored LOB. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Data warehousing Resources
Dear All, Would greatly appreciate any advice on books/resources on designing and implementing data warehouse (on Oracle 7-8i) from a less technical and more functional perspective. Cheers, Pete _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pete Wang 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).
Problem with 9i import
Hi, I have recently installed 9i on my computer and wanted to import my exdat.dmp file from my Oracel 8i. I got nowhere with the enterprise manager console so after trying with no success through Oracle support I decided to try doing the import from a command prompt. Well, I must have done something wrong because it imported the file but it put it in the OEM repository instead of the ORCL and so my developer 6.0 does not have access to any of the tables or data that I imported. Does anyone know the correct syntax to do the import that I want to do and also how do I get it out of the OEM now? Have I totally messed everything up? Thanks -- 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).
Correct OCI Version
hi to all! it's ages now that i'm looking for a good method for determining the exact oci version installed and/or used and i'm still looking. is there someone out there who has found the solution on how to correctly determine the used oci version and want to share this information with us ? do make it a little more clear what i'm looking for: since oracle 7.3 (i believe) the oracle oci dll's do no longer need to be linked with the exact version name but a generic dll (ociw32.dll) looks for the most current oci version that can be found on the workstation. this process is quite nicely described in the oracle note 43972.1. so far so good but by doing so, the application using the ociw32.dll does no longer know what the exact version of oci is. even if dynamically (LoadLibrary) loading the low-level oracle dll called by ociw32.dll (e.g.. ora805.dll for oci version 8.0.5) it would be possible to know that we are running 8.0.5 but this would no longer work with 8i where all 8i oci versions call the same dll named oraclient8.dll. thank you for your help -do -- 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).
init.ora (un documented) parameters
Hei all, Hope that there are totally 504 init.ora parameters in ORacle8i. Out of that only 203 parameters only documents, remaining are undocumented. This i read on a white paper. Where should i get information about these parameters? Just i want to know. Here is my Q. the init.ora parameter sql_trace=true, creates trace files in the server folder specified in USER_DUMP_DEST parameter. As a user, am running a SQL statement at client side, So how can i get the trace information for my sql statement. On the same white paper i read, the parameter _trace_files_public=true will do my request. Any Help highly appriciated. Rgds, Nirmal. application/ms-tnef
Re: init.ora (un documented) parameters
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 14:10 Hope that there are totally 504 init.ora parameters in ORacle8i. Out of that only 203 parameters only documents, remaining are undocumented. This i read on a white paper. Where should i get information about these parameters? Just i want to know. the only place (outdated now) I'm aware of is http://www.fortunecity.com/skyscraper/oracle/699/orahtml/misc/undoc.html also a good place to start is downloading OraSnap from http://www.stewartmc.com/oracle/orasnap/ and playing with the Undoc'd Init.ora Params section in the reports produced On the same white paper i read, the parameter _trace_files_public=true will do my request. take a look at http://www.ixora.com.au/q+a/0009/15165340.htm hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Installation Problems
here you go, save it, i'm sure you'll need it in the future, i dont do oracle database on windoze but support the clients. ---cut here--- Introduction Removing or deinstalling Oracle software from an 95/98/NT operating system requires several steps to completely creating a 'clean' machine. This document explains what must be done to remove all Oracle software from the system. Warning --- 1) Backup Be careful, because these steps remove all Oracle software, Oracle services, and Oracle registry entries from the system. So it is advisable that you first perform a backup, if required, of certain files like: SQL*Nnet configuration files Database files Self-written scripts that are stored under the oracle home directory, etc. 2) The following procedures require the editing of Windows registry, which is a potentially dangerous operation. There is no undo option in the Registry Editor. Content --- A. 32-bit on Windows NT B. 32-bit on Win95/Win98 C. 16-bit A. 32-bit on Windows NT --- 1. Ensure that you are logged in as a user with Administrator privileges. 2. Stop all Oracle-related services and all Oracle programs. 3. Remove the database services via the oradim command. This can be done via ORADIMXX -DELETE -SID SID or via the 'SC' tool of the resource kit. For a full explanation on using the ORADIM command, see NOTE:61621.1 gt;. As from 8.1.6, the method for deinstalling is to first run Net8CA in Deinstall mode, then run DBCA to delete a database, then run OUI to deinstall the products. At this point, all services should be removed. 4. Start the ODBC administrator applet, if installed, and remove any Oracle DSN definitions. 5. Remove the Oracle software via the Oracle installer or the Universal Installer (8.1.5 and onwards). Make sure that all services related to Oracle are stopped first. Note that you cannot remove the installer itself. If Legato Storage Manager is installed on the system, then remove it via the uninstaller executable that is shipped with Legato. Start-Programs-Networker-Uninstall Networker Caution: If Legato Storage Manager was installed independently of Oracle, DO NOT REMOVE LSM, because your system's backup environment may be adversely affected. 6. Start the Event Viewer, Log-Application, and clean up the application logs for Oracle. 7. Start the registry editor. This can be done via regedit or regedt32. a) If the Oracle Universal Installer (OUI) was used, go to HKEY_LOCAL_MACHINE\Software\Oracle and write down the value of the INST_LOC variable. This shows you where the OUI software is installed. This can then be used to remove the OUI from the machine afterwards. b) Go to HKEY_LOCAL_MACHINE\Software and remove the ORACLE key, look into the ODBC key for any 'leftovers' of Oracle. If they exist, then remove them as well. c) Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and verify that all services that start with 'Oracle' are removed. If this is not the case, then remove the services starting with 'Oracle' (database related) and the ones that start with 'OraWeb' (Oracle Application Server related). No entries will not be removed from the services dialog box until you reboot. d) Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\ Application and look for keys that start with 'Oracle'. Normally, they should have been removed in Step 5. e) Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion \Uninsta. ll and remove all entries related to Oracle Typical entries to found there are: Oracle JInitiator 1.1.x.x f) Close the registry editor. 8. Remove any Oracle related .INI files that may exist in the Windows NT Boot directory. The Windows NT boot directory may be found by entering SET WINDIR from a command prompt. Typical Oracle .INI files include ORADIM73.INI, ORADIM80.INI, ORACLE.INI, ORAODBC.INI 9. Go to Start-Settings-control Panel-System-Environment. * Select in the 'System Variables' window the PATH variable and remove the %ORACLE_HOME%\BIN directory. If JRE was installed by Oracle, then remove the JRE path as well. (For example: ...;C:\Orant\Bin;C:\Program Files\Oracle\jre\1. 1.7\bin;...) * Check the ¿User Variables for user xxx¿ section also for Oracle entries to remove. * Check as well the ¿System Variables¿ as ¿User
Re: The OCP bar is being raised
John, the thing that scares me about OCP is not that the technical interviews won't catch people who don't know anything. If I can't tech someone and find out that they just know what they studied for OCP, I shouldn't be doing tech interviews. What I find disturbing is when the HR department makes the rule that unless a candidate has OCP on their resume, you can't hire them. It's the people who don't understand what is behind those initials who then make rules based on them that are worrisome. As an example, I have a FANTASTIC associate DBA. He's smart, quick to learn, motivated to learn on his own, curious and willing to ask for help. He doesn't have OCP. He doesn't have a college degree (he's ex-military and got his computer training there). If HR had had a policy that I could only hire someone with a college degree or someone with OCP, I would have lost one of the best assistants I've ever had. I have OCP through 8i. I took chauncey, took the additional tests to convert it OCP7, took the two upgrades for 8 and 8i respectively. I never studied for the tests, in fact, I took them on the spur of the moment each time. I had never worked with 8 or 8i when I took those upgrades. so what does that tell you? That I take standardized tests well, and can eliminate enough choices to be able to guess the correct answer more often than not. That pretty much qualifies me for Do You Want to Be a Millionaire but not for Oracle work. Do I list the OCP on my resume? Yes, because I am smart enough to know that it will open some doors. It's at the very end of a 4 page resume, so I don't know how often it actually gets seen. And that's my intention. I am very anxious to see just what the practicum test involves. I do wish you didn't have to take additional classes before you could qualify for it, but I understand that Oracle does try to make a profit. I'd like to see them accept an equivalent exam from somewhere else as well. If they are going to mimic what the colleges do for higher degrees they should do it properly. Rachel --- orantdba [EMAIL PROTECTED] wrote: Hi Rachel, Now we are to the point, is it valuable? I say yes and I have studied for and passed the ocp for 7, upgraded to 8 and to 8i and will soon take the 9i upgrade test. I also hold the Oracle 7 certification that was offered by Chauncey before the Oracle came out with the OCP. Others say it is not. It is their dollar, and they can spend it as they wish. Ultimately the market decides value, I don't believe that any sane manager of DBA's would hire someone just because they are ocp's. Managers would tend to value relevant experience, the interview process, and degrees well before looking at ocp's. So why do I think it is important? The first person who sees your resume is usually in the HR department. They cannot hire you but they can file your resume in the circular file. Cute little designations like OCA, OCP, OCM, MCP, MCSE, CNE, etc help get you past those people and on to the people who can actually understand you when you talke about performing block dumps and interrogating the itl. Those people can say yes and will because of my experience and interview presence. They will probably not care one bit about the cute little designations, but it is irrevelant if I don't get to talk to them. I have had the discussion at oow, etc with more than a few people (perhaps even you) asking if you had two candidates with exactly the same criterias but one had OCP and one didn't which would you hire? This is a little like the If god is all powerful can he make a rock so big that he himself cannot pick it up question. In the case described above I would probably go to things like Which is cheaper?, Which had experience that most matched my project?, Which had the best personality match for my group?. I don't think OCP would make that much of a difference. John [EMAIL PROTECTED] wrote: John, I have no objection to Oracle trying to make money (heck, I own stock, I WANT and expect them to make money!) The problem is not that they are trying to make money, but that this is becoming something you HAVE to do/have to get a job working with Oracle. And they haven't convinced me of the value of that piece of paper. I know way too many certified DBAs who I wouldn't trust to even query my databases. Rachel --- orantdba [EMAIL PROTECTED] wrote: Hmmm, Imagine that, a publicly traded company that it trying to make money, I am shocked dismayed, I don't believe I will be able to sleep tonight. Chris, could you provide me with the list of companies that are not trying to make money? I want to make sure that I don't go to work for them, or learn their products. John :-) [EMAIL PROTECTED] wrote: I'd say the cost is being raised. Look at the requirements for each. You can't just take the OCM exam. No we
How to prevent Oracle 9i for Windows from starting?
Hi, How can I prevent Oracle 9i (for Windows) to start automatically at Windows startup? I want Oracle to start _only_ when I want to ( as the Oracle under Linux). Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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 prevent Oracle 9i for Windows from starting?
Go into Administrative Tools | Services and check the startup type for the 9i service -- it is probably set to automatic. Change to manual and you're done. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Csillag Zsolt Sent: Saturday, January 12, 2002 9:05 AM To: Multiple recipients of list ORACLE-L Subject: How to prevent Oracle 9i for Windows from starting? Hi, How can I prevent Oracle 9i (for Windows) to start automatically at Windows startup? I want Oracle to start _only_ when I want to ( as the Oracle under Linux). Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Installation Problems
Hi Paul, The CD installation program is not working (it just won't run) -- that's 90% of my problem. I'm going to have to do a manual de-install. I am completely unfamiliar with Oracle (I'm about to take a class and start learning it), so I haven't any idea where it places files, i.e., whether it places files in folders other than obviously-named Oracle files. Do you know? Thanks, JoJo -Original Message- Paul R. Sent: Friday, January 11, 2002 10:00 PM To: Multiple recipients of list ORACLE-L The proper way to back out almost all Oracle installations on a PC is as follows: 1. De-install the Oracle application using the CD that you used to do the installation 2. Delete the folder under which you installed the Oracle application 3. Delete all Oracle folders and files referencing that Oracle application from the registry under hkey_local_machine\software 4. Delete all Oracle folders and files referencing that Oracle application from the registry under hkey_local_machine\system, any/all controlset, including currentcontrolset 5. Reboot your PC - this should clear the other areas of the registry, i.e., hkey_local_user, et al 6. Depending on the Oracle application, you may need to delete/modify some of the environmental i.e., system variables, if/where applicable to the operating system; a check never hurts 7. You may not be able to delete the folder in step 2; if so, after the reboot, you should be able to; if not, you more than likely still have something referencing a file in that folder. Paul DBA Elcom, Inc. -Original Message- Sent: Saturday, January 12, 2002 12:05 AM To: Multiple recipients of list ORACLE-L I backed up my registry before I installed it. Do you suppose if restored that registry and just deleted any Oracle directories (and then rebooted), that would do it? Does Oracle place files in any Windows directories (dlls, etc.)? Thanks, JoJo -Original Message- Kirti Sent: Friday, January 11, 2002 8:25 PM To: Multiple recipients of list ORACLE-L Darn Windoze !! Looks like you need to manually get rid of the entire Oracle directory structure, and remove the registry entries (after saving current registry:), and then rebooting to start afresh. Good Luck, - Kirti -Original Message- Sent: Friday, January 11, 2002 8:05 PM To: Multiple recipients of list ORACLE-L Hi all, I just tried to install Oracle 9i personal edition for Win98 on my Win98 PC. After quite a bit of installation, it got to a part where it was creating some database or something, and I got an error: The program encountered an invalid page exception. Fault location: 0028:0022 Interrupts in service: None And it advised me to reboot, which I did. Now I cannot get the installation program to re-start, no matter what I do, from the CD-ROM, from the computer, from running various programs on the CD-ROM, what have you. I can't un-install it because (a) it doesn't show up on Windows' uninstall list and (b) the Oracle installer won't run. It starts to run (a brief flash of the installer graphic), then the CD-ROM quits and nothing happens. Any ideas? Thanks, JoJo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JoJo Al-Zawawi 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 prevent Oracle 9i for Windows from starting?
check out services, thats about my extent on knowledge on oracle/windoze. joe Csillag Zsolt wrote: Hi, How can I prevent Oracle 9i (for Windows) to start automatically at Windows startup? I want Oracle to start _only_ when I want to ( as the Oracle under Linux). Thank you in advance Zsolt Csillag, Hungary -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Installation Problems
Thanks a lot, Joe. Since I backed up my registry before I installed Oracle, I can probably just import the backed-up registry and save myself some time. We'll see how it goes! Cheers, JoJo -Original Message- Sent: Saturday, January 12, 2002 5:45 AM To: Multiple recipients of list ORACLE-L here you go, save it, i'm sure you'll need it in the future, i dont do oracle database on windoze but support the clients. ---cut here--- Introduction Removing or deinstalling Oracle software from an 95/98/NT operating system requires several steps to completely creating a 'clean' machine. This document explains what must be done to remove all Oracle software from the system. Warning --- 1) Backup Be careful, because these steps remove all Oracle software, Oracle services, and Oracle registry entries from the system. So it is advisable that you first perform a backup, if required, of certain files like: SQL*Nnet configuration files Database files Self-written scripts that are stored under the oracle home directory, etc. 2) The following procedures require the editing of Windows registry, which is a potentially dangerous operation. There is no undo option in the Registry Editor. Content --- A. 32-bit on Windows NT B. 32-bit on Win95/Win98 C. 16-bit A. 32-bit on Windows NT --- 1. Ensure that you are logged in as a user with Administrator privileges. 2. Stop all Oracle-related services and all Oracle programs. 3. Remove the database services via the oradim command. This can be done via ORADIMXX -DELETE -SID SID or via the 'SC' tool of the resource kit. For a full explanation on using the ORADIM command, see NOTE:61621.1 gt;. As from 8.1.6, the method for deinstalling is to first run Net8CA in Deinstall mode, then run DBCA to delete a database, then run OUI to deinstall the products. At this point, all services should be removed. 4. Start the ODBC administrator applet, if installed, and remove any Oracle DSN definitions. 5. Remove the Oracle software via the Oracle installer or the Universal Installer (8.1.5 and onwards). Make sure that all services related to Oracle are stopped first. Note that you cannot remove the installer itself. If Legato Storage Manager is installed on the system, then remove it via the uninstaller executable that is shipped with Legato. Start-Programs-Networker-Uninstall Networker Caution: If Legato Storage Manager was installed independently of Oracle, DO NOT REMOVE LSM, because your system's backup environment may be adversely affected. 6. Start the Event Viewer, Log-Application, and clean up the application logs for Oracle. 7. Start the registry editor. This can be done via regedit or regedt32. a) If the Oracle Universal Installer (OUI) was used, go to HKEY_LOCAL_MACHINE\Software\Oracle and write down the value of the INST_LOC variable. This shows you where the OUI software is installed. This can then be used to remove the OUI from the machine afterwards. b) Go to HKEY_LOCAL_MACHINE\Software and remove the ORACLE key, look into the ODBC key for any 'leftovers' of Oracle. If they exist, then remove them as well. c) Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and verify that all services that start with 'Oracle' are removed. If this is not the case, then remove the services starting with 'Oracle' (database related) and the ones that start with 'OraWeb' (Oracle Application Server related). No entries will not be removed from the services dialog box until you reboot. d) Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\ Application and look for keys that start with 'Oracle'. Normally, they should have been removed in Step 5. e) Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion \Uninsta. ll and remove all entries related to Oracle Typical entries to found there are: Oracle JInitiator 1.1.x.x f) Close the registry editor. 8. Remove any Oracle related .INI files that may exist in the Windows NT Boot directory. The Windows NT boot directory may be found by entering SET WINDIR from a command prompt. Typical Oracle .INI files include ORADIM73.INI, ORADIM80.INI, ORACLE.INI, ORAODBC.INI 9. Go to Start-Settings-control Panel-System-Environment. * Select in the 'System Variables' window the PATH variable and remove the %ORACLE_HOME%\BIN directory. If JRE was
Re: How to prevent Oracle 9i for Windows from starting?
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 17:05 How can I prevent Oracle 9i (for Windows) to start automatically at Windows startup? in the registry set HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOMExx/ORA_sid_AUTOSTART to 'FALSE' (HOMExx is the entry for the ORACLE_HOME the instance uses, sid is the instance SID) hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Installation Problems
good luck with it, and be ready to reinstall windows if it all goes to heck. joe JoJo Al-Zawawi wrote: Thanks a lot, Joe. Since I backed up my registry before I installed Oracle, I can probably just import the backed-up registry and save myself some time. We'll see how it goes! Cheers, JoJo -Original Message- Sent: Saturday, January 12, 2002 5:45 AM To: Multiple recipients of list ORACLE-L here you go, save it, i'm sure you'll need it in the future, i dont do oracle database on windoze but support the clients. ---cut here--- Introduction Removing or deinstalling Oracle software from an 95/98/NT operating system requires several steps to completely creating a 'clean' machine. This document explains what must be done to remove all Oracle software from the system. Warning --- 1) Backup Be careful, because these steps remove all Oracle software, Oracle services, and Oracle registry entries from the system. So it is advisable that you first perform a backup, if required, of certain files like: SQL*Nnet configuration files Database files Self-written scripts that are stored under the oracle home directory, etc. 2) The following procedures require the editing of Windows registry, which is a potentially dangerous operation. There is no undo option in the Registry Editor. Content --- A. 32-bit on Windows NT B. 32-bit on Win95/Win98 C. 16-bit A. 32-bit on Windows NT --- 1. Ensure that you are logged in as a user with Administrator privileges. 2. Stop all Oracle-related services and all Oracle programs. 3. Remove the database services via the oradim command. This can be done via ORADIMXX -DELETE -SID SID or via the 'SC' tool of the resource kit. For a full explanation on using the ORADIM command, see NOTE:61621.1 gt;. As from 8.1.6, the method for deinstalling is to first run Net8CA in Deinstall mode, then run DBCA to delete a database, then run OUI to deinstall the products. At this point, all services should be removed. 4. Start the ODBC administrator applet, if installed, and remove any Oracle DSN definitions. 5. Remove the Oracle software via the Oracle installer or the Universal Installer (8.1.5 and onwards). Make sure that all services related to Oracle are stopped first. Note that you cannot remove the installer itself. If Legato Storage Manager is installed on the system, then remove it via the uninstaller executable that is shipped with Legato. Start-Programs-Networker-Uninstall Networker Caution: If Legato Storage Manager was installed independently of Oracle, DO NOT REMOVE LSM, because your system's backup environment may be adversely affected. 6. Start the Event Viewer, Log-Application, and clean up the application logs for Oracle. 7. Start the registry editor. This can be done via regedit or regedt32. a) If the Oracle Universal Installer (OUI) was used, go to HKEY_LOCAL_MACHINE\Software\Oracle and write down the value of the INST_LOC variable. This shows you where the OUI software is installed. This can then be used to remove the OUI from the machine afterwards. b) Go to HKEY_LOCAL_MACHINE\Software and remove the ORACLE key, look into the ODBC key for any 'leftovers' of Oracle. If they exist, then remove them as well. c) Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and verify that all services that start with 'Oracle' are removed. If this is not the case, then remove the services starting with 'Oracle' (database related) and the ones that start with 'OraWeb' (Oracle Application Server related). No entries will not be removed from the services dialog box until you reboot. d) Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\ Application and look for keys that start with 'Oracle'. Normally, they should have been removed in Step 5. e) Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion \Uninsta. ll and remove all entries related to Oracle Typical entries to found there are: Oracle JInitiator 1.1.x.x f) Close the registry editor. 8. Remove any Oracle related .INI files that may exist in the Windows NT Boot directory. The Windows NT boot directory may be found by entering SET WINDIR from a command prompt. Typical Oracle .INI files include ORADIM73.INI,
Re: Data warehousing Resources
Hi, try http://www.stewartmc.com/oracle http://www.dwinfocenter.org/ oli On Sat, 2002-01-12 at 06:27, [EMAIL PROTECTED] wrote: Dear All, Would greatly appreciate any advice on books/resources on designing and implementing data warehouse (on Oracle 7-8i) from a less technical and more functional perspective. Cheers, Pete _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pete Wang 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: Oliver Artelt 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: Centralized Alert Log Monitoring
While the script approach is excellent, and you have gotten several good answers on how to use it, might I suggest looking into event triggers? If you are running 8i or above (not 8.1.5, it's buggy on this), you can create a database level trigger ON ERROR. If you have Java turned on for your system you can have Oracle email you the error directly. Otherwise you can use a daemon on the system to pick up the email duties. There are a few errors that are ignored, but they are the kind of thing that should be ignored (like programs passing characters to number parameters). The only errors this is going to miss are catastrophic, i.e. when you get a core dump that kills SMON the trigger won't fire because the instance is already down. For that kind of thing only OS scripts will help. Regards, Chris Gait -- 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).
RMAN
Can RMAN be used to backup a V7.3.4.5 instance? In addition to the obsolete version, which I'm forced to continue to support, I'm supporting both 8i 9i instances. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
parallel_server parallel_min_servers
Dear listers, Could someone shed some light on the following question? I can not figure out by myself because I am really a new bee on this:) In my application, I need to query a IOT that is not partitioned.I was getting bad performance. It is running on Sun E3000 with oracle 8.1.5 and Solaris 5.8. The machine has four cpus. The application itself is multithreaded to query different tables. One thread is querying the IOT. While all other threads terminate, the thread querying the IOT still need to run for a long time. From the explain plan it is using index range scan. My questions is in this knid of situation could I use parallel query to improve performance? If I could how shoud I set the values for parallel_server and parallel_min_servers? Thanks a lot. Shu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: shuli 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: RMAN
Unfortunately NO. John [EMAIL PROTECTED] wrote: Can RMAN be used to backup a V7.3.4.5 instance? In addition to the obsolete version, which I'm forced to continue to support, I'm supporting both 8i 9i instances. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba 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: RMAN
I believe not. Part of the reason is that the control files are used to store some of the information for RMAN. The formats of 7.* and 8.* are not compatible in that there's 17 added sections in the O8 controlfile. You've probably noticed the increased size between 7.* and 8.*. Velpuri covers quite a bit of of this in his book. See pages 250 - 252 and chapter 6 of his O8 backup and recovery book. If you don't have the book, get it. -Original Message- Mengler Sent: Saturday, January 12, 2002 2:50 PM To: Multiple recipients of list ORACLE-L Can RMAN be used to backup a V7.3.4.5 instance? In addition to the obsolete version, which I'm forced to continue to support, I'm supporting both 8i 9i instances. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Fries 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: Correct OCI Version
Can't you just right click on the dll and choose 'properties' to get the info? Jared On Saturday 12 January 2002 03:35, [EMAIL PROTECTED] wrote: hi to all! it's ages now that i'm looking for a good method for determining the exact oci version installed and/or used and i'm still looking. is there someone out there who has found the solution on how to correctly determine the used oci version and want to share this information with us ? do make it a little more clear what i'm looking for: since oracle 7.3 (i believe) the oracle oci dll's do no longer need to be linked with the exact version name but a generic dll (ociw32.dll) looks for the most current oci version that can be found on the workstation. this process is quite nicely described in the oracle note 43972.1. so far so good but by doing so, the application using the ociw32.dll does no longer know what the exact version of oci is. even if dynamically (LoadLibrary) loading the low-level oracle dll called by ociw32.dll (e.g.. ora805.dll for oci version 8.0.5) it would be possible to know that we are running 8.0.5 but this would no longer work with 8i where all 8i oci versions call the same dll named oraclient8.dll. thank you for your help -do -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).