RE: Removing Older version of Oracle on NT Machine
This article provides clean remove. http://allaire.com/Handlers/index.cfm?ID=18374Method=Full -Original Message- Sent: Monday, June 11, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Hi, Is there any white papers for removing one version of Oracle from an NT machine? I have 8.0 and 8i and would like to fully remove all of 8.0 including registry entries etc. I attempted to use Universal Installer, but it won't let me select any of the 8.0 components to remove them. I'm gonna keep working it and see where I get. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sunrise DBA 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: PHU,JULIA (HP-Sunnyvale,ex2) 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: Renaming columns ...
, 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: PHU,JULIA (HP-Sunnyvale,ex2) 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: Regina Harter 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: PHU,JULIA (HP-Sunnyvale,ex2) 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: connect on oracle database
Either MS ODBC or Oracle driver can do the connectivity. I found out that MS ODBC is more user-friendly. Just my $0.02. -Original Message- Sent: Wednesday, May 30, 2001 4:30 AM To: Multiple recipients of list ORACLE-L Hish, Crack out some manuals double quick - get some RDBMS training, and learn a little about what you are playing with here! Sybase and Informix are not actually applications - they are Relational Database Management Systems (RDBMSs) that are competitors to Oracle. To answer the question though - I think - you can probably connect to these databases through some kind of ODBC connectivity - or a Gateway product - though I have never done this.. HTH Mark -Original Message- Hassan Sent: Wednesday, May 30, 2001 11:20 To: Multiple recipients of list ORACLE-L hi DBA Masters: If i have any application (sybase / informex) not oracle tools make it. how to connect from this application on the oracle database?? thank you hish _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hisham Hassan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PHU,JULIA (HP-Sunnyvale,ex2) 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: Problems with CharArrayType after upgrade from 7.3.4 to 8.1.7
VARCHAR is the older version. VARCHAR2 is for 8.0 and above. Changing from VARCHAR to VARCHAR2 for 8.1.7 will solve the problem. -Original Message- Sent: Wednesday, May 30, 2001 11:47 AM To: Multiple recipients of list ORACLE-L 8.1.7.1 Cherie, I have no idea if this could be the case, but I noticed that the type is based on the datatype VARCHAR, not VARCHAR2. According to the docs, this shouldn't make a difference, but they've been warning since the introduction of VARCHAR2 that they may do something different with VARCHAR at some point in the future, so it's best not to use it. From the PL/SQL manual: === VARCHAR2 Subtypes The VARCHAR2 subtypes below have the same range of values as their base type. For example, VARCHAR is just another name for VARCHAR2. STRING VARCHAR You can use these subtypes for compatibility with ANSI/ISO and IBM types. Note: Currently, VARCHAR is synonymous with VARCHAR2. However, in future releases of PL/SQL, to accommodate emerging SQL standards, VARCHAR might become a separate datatype with different comparison semantics. So, it is a good idea to use VARCHAR2 rather than VARCHAR. === Again, I don't see how that could affect the code...just a shot in the dark. Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] Cherie_Machler @gelco.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Fax to: omSubject: Problems with CharArrayType after upgrade from 7.3.4 to 8.1.7.1 05/30/2001 01:40 PM Please respond to ORACLE-L After upgrading from Enterprise Edition 7.3.4 to 8.1.7.1 on Sun Solaris 2.6, we are having problems executing a procedure with CharArrayType as shown below. We don't get any error message. The package simply does not return any rows when there are rows out there that should be returned. The developer is trying to turn on some debug but I thought I would also ask if anyone sees anything that is a no-no now under 8.1.7.1. Is there something that I need to do in order to migrate this code that wasn't done automatically? CREATE OR REPLACE PACKAGE CCFILECD AS TYPE NumArrayType IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; TYPE CharArrayType IS TABLE OF VARCHAR(31) INDEX BY BINARY_INTEGER; PROCEDURE GETFILECODES(file_code OUT CharArrayType, file_prefixOUT CharArrayType, start_pos OUT NumArrayType, length OUT NumArrayType, num_lines_to_skip OUT NumArrayType, record_length OUT NumArrayType, cntry_cd_proc OUT NumArrayType, curr_cd_proc OUT NumArrayType, count OUT NUMBER); END CCFILECD; Thanks for any advice you can give, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PHU,JULIA (HP-Sunnyvale,ex2) 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
RE: ORA-00904
Hi, Joe, 'an upgrade or patch and then forget to run catalog, catproc, catrep(if ur using replication), utlirp.' Do you recommend to run catalog, catproc, catrep, and utlirp? I looked up a doc in Metalink and couldn't resolve my problem. Perhaps I looked up the incorrect one. Please send me info if you will. Thank you. Julia -Original Message- Sent: Saturday, May 26, 2001 6:00 AM To: Multiple recipients of list ORACLE-L dealt with that one this week on aix platform. a couple of things can cause it. 1. an upgrade or patch and then forget to run catalog, catproc, catrep(if ur using replication), utlirp. 2. using a version of export that is not compatible with the database(no one flame me for this, it was on metalink). if you want moer into on the error, let me know, i'll go and get the doc id from metalink so you can look it up. joe PHU,JULIA (HP-Sunnyvale,ex2) wrote: Greetings, I'm lost on the 'ORA-00904: invalid column name' error message. Can someone shed some light on it? It is 8i on NT box with sp6a. Regards, Julia Phu -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PHU,JULIA (HP-Sunnyvale,ex2) 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).
ORA-00904
Greetings, I'm lost on the 'ORA-00904: invalid column name' error message. Can someone shed some light on it? It is 8i on NT box with sp6a. Regards, Julia Phu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PHU,JULIA (HP-Sunnyvale,ex2) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NT Scheduled Restart
Same here, thanks. -Original Message- Sent: Wednesday, May 23, 2001 8:19 AM To: Multiple recipients of list ORACLE-L hi suhen, for some reasons i did'nt recieved the mail with the attachment as exe file. have u sent it. pls confirm. i'm also looking for such utilities. thanks. - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Wednesday, May 23, 2001 2:15 PM That's the best thing I like about this list... You ask for something and you get it, with no delay at all Thanks list and Thanks Suhen... Rajesh -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, May 23, 2001 11:11 AM To: Rajesh Dayal Rajesh, We use a exe called shutdown.exe. It works quite well. I think it is a freeware. I have attached a copy of shutdown.exe. Copy this file to C:/winnt. We pass it arguments shutdown.exe /L /R /T:25 /C /Y HTH Suhen Hi all, I am looking for a utility (preferably freeware), which can perform a scheduled shutdown of NT 4.0 server. This I need because of inconsistent behavior of NT for Oracle Services. I want to do a scheduled restart after every night backup(scheduled). Appreciate your inputs and suggestions. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PHU,JULIA (HP-Sunnyvale,ex2) 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: newbie question
Thank you so much for the info, DC. I have another stupid question. Can I have two different ports for two database in the same tnsname.ora on the same server? Cheers, Julia -Original Message- Sent: Wednesday, May 16, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Hi, Yes, you can modify instance parameters in the initXYZ.ora file. After you change them, they take effect when you bounce the instance (shutdown and startup) Also, there are some parameters that can be modify on the fly, without bouncing the instance. check this. SQL desc v$parameter NameNull?Type --- NUM NUMBER NAME VARCHAR2(64) TYPE NUMBER VALUEVARCHAR2(512) ISDEFAULTVARCHAR2(9) ISSES_MODIFIABLE VARCHAR2(5) ISSYS_MODIFIABLE VARCHAR2(9) ISMODIFIED VARCHAR2(10) ISADJUSTED VARCHAR2(5) DESCRIPTION VARCHAR2(64) SQL column name format a60 SQL column value format a20 SQL column ISSYS_MODIFIABLE format a6 SQL select name,value,ISSYS_MODIFIABLE from v$parameter; NAME VALUE ISSYS_ --- - -- processes50 FALSE sessions 60 FALSE timed_statistics TRUE IMMEDIATE--- You can change timed_statistics value with this command: alter system set timed_statistics=true; Hope it helps DC - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 16, 2001 3:19 PM Hi, guru, After I created a XYZ database using the Database Configuration Assistant, can I modify some parameters in the initXYZ.ora file? What steps should I take after the modification? Please advise. Regards, Julia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PHU,JULIA (HP-Sunnyvale,ex2) 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: Diego Cutrone 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: PHU,JULIA (HP-Sunnyvale,ex2) 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).