RE: High Number of Disk Reads ?
John, Thanks for the input. It eventually helped me find me problem. In the words of Pogo, We have met the enemy and they is us. The high disk reads were not from the users app at all, but rather from the audit table, AUD$. I moved it from the SYSTEM tablespace over a year ago and failed to recreate the proper indexes. The table grew enough that the resulting table scans slowed down their logon process. Lesson to myself. Thanks, Mike Michael Bond OC-ALC\TILC Oracle DBA 405 736-3840 DSN 336-3840 -Original Message- Sent: Monday, August 05, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Michael, As you don't give the avg. row size for t2, are we to assume that table has not been analysed? Could be the source of your problem. If not, in SQL*Plus, do SET AUTOTRACE ON or better still set TIMED_STATISTICS=TRUE and either set an event to generate a trace for the user, or ALTER SESSION SET SQL_TRACE=TRUE. Use TKPROF to analyse the trace file and it might give you a handle on what'sgoing on. Cheers, John Thomas In message [EMAIL PROTECTED], Bond Mike A Contr OC-ALC/TILC [EMAIL PROTECTED] writes Hi, I have a performance question.v8.1.6.3.8 NT4.0 The following query performs 3335 disk reads. All tables are in a 64K Locally managed tablespace. Upon connection, the users app executes this once per user in table t2 and cause over 100K disk reads. What am I missing/misunderstanding?? Is this normal? It seems terribly high, even if no blocks are in the buffer when the query is executed. TIA. Mike Table t0 has 1 row with an avg row len of 31 Table t1 has 13 rows with an avg row len of 13 Table t2 has 39 rows SELECT t0.sftwr_evnt_grp_desc_tx, t0.sftwr_evnt_grp_key_id, t0.sftwr_evnt_grp_nm FROM gimms_admin.inf_sys_usr t2, gimms_admin.inf_sys_usr_evt_grp_rl t1, gimms_admin.sftwr_evnt_grp t0 WHERE t2.inf_sys_usr_key_id = 25 AND t1.inf_sys_usr_key_id = t2.inf_sys_usr_key_id AND t0.sftwr_evnt_grp_key_id = t1.sftwr_evnt_grp_key_id Query to get # of disk reads ... SELECT SQL_TEXT, SORTS, EXECUTIONS, DISK_READS, BUFFER_GETS, ROWS_PROCESSED, OPTIMIZER_MODE FROM V$SQLAREA Michael Bond OC-ALC\LPCC Oracle DBA 405 736-3840 DSN 336-3840 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- John Thomas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Thomas 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: Bond Mike A Contr OC-ALC/TILC 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).
Connection create time is long
Hi, I am seeing a relatively large difference in the time it takes to create a database connection. There are two instances (8.1.6.3.8) running on our NT 4.0 server. When my users complained, one instance had 20 sessions and connect time took 2-3 seconds while the other, busier prod instance had over 40 sessions and took ~10 seconds. Any ideas what I can look at to find the cause? Can database activity (some stored procs were running at the time) cause a slowdown in creating a connection? Thanks. Michael Bond OC-ALC\TILC Oracle DBA 405 736-3840 DSN 336-3840 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bond Mike A Contr OC-ALC/TILC 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).
Capacity Planning
Good morning, I am trying determine whether a proposed 8-way Intel (Unisys ES7000) system running Windows 2000 will support our anticipated work load. I know this question has a LOT of variables but I don't even have a feel for some of the numbers. Two things: One - just to get an idea of the scale of things, is 300 concurrent users a 'lot' on such a system? Like I said, I KNOW there are many other variables - specifically, what the users are doing at the time, tunning, ... but I am wondering (assuming well written queries, apps, database design, ...) if this number is in the range of 'THIS SYSTEM IS OVERKILL' 'PROBABLY OK' 'HMM BETTER LOOK OUT' 'YOU ARE INSANE AND WILL BE JOB HUNTING SOON' Does anyone have a similar system running with say ... 1000 concurrent users? 100? 5000??? Two - Can anyone point me to resources (other than the vendors) that might help. I don't know why I have such distrust for someone who wants my money. Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bond Mike A Contr OC-ALC/TILC 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).
Unisys Unixware vs W2000
Hi, For a couple of years we have been running Oracle on NT on a Unisys server. We are in the process of acquiring a new server (ES7000) and I am pushing for the move to Unix. Now, out of the blue, the Unisys rep is now trying to move us to W2000 instead of Unixware. His claim is that Oracle is starting to pay more attention to Intel machines and W2000 and is improving the performance of Oracle on such platforms. I'll spare you all the prattle ... It seems to me to be a big red flag when the vender tries to steer us away from one of their own products, saying that they are 'focusing on W2000 rather than Unixware'. Question: Is Oracle really increasing the effort it puts into the W2000 platform? I am tired of being at the bottom of the list for patches. Question: If we are locked into a Unisys machine (which we are) would W2000 truly be a better choice than Unixware ? Question: Do I smell a rat? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bond Mike A Contr OC-ALC/TILC 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: Database shut itself down
Perhaps another program tied up the file - virus scan, backup software. My Oracle on NT is easier killed that way - so I scream at the SA. Mine usually restarts and recovers fine afterward though. Mike -Original Message- Sent: Tuesday, April 02, 2002 1:03 PM To: Multiple recipients of list ORACLE-L I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? 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: Bond Mike A Contr OC-ALC/TILC 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: Database Query Tool
Dennis, You are absolutely correct. These users know nothing of SQL and will probably never be able (due to lack of interest) to do more than change search parameters in queries that I write and provide to them. They need access to Oracle to validate the transfer of data from IMS on the mainframe (their home planet) to Oracle. We are very sensitive to keeping this thing simple and may wind up creating custom forms for them to use (with one big button). You last comment was interesting though, but I am already on the hook to make the recommendation AND to train them. Thanks, Mike -Original Message- Sent: Tuesday, February 26, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Mike - One critical question - Will you be creating reports for the users or will they be creating the reports by themselves? We have had a lot of trouble where IS would buy a query or reporting tool with the idea that the users would be self-sufficient. Then it turns out that IS uses the tool. Actually SQL was originally created as a user query interface. How many users do you see today creating their own SQL statements? Sorry to be cynical, but we've gotten bitten on that one before. This last time IS stayed out of it, let the users pick their own tool, the users got the training and no IS people were trained. It seems to be working pretty good. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 26, 2002 8:13 AM To: Multiple recipients of list ORACLE-L Mike, There are a lot of tools like that on the market. My favorite for several years was Discoverer or Oracle Browser as it was then known. Recently though I've switched camps to Brio One from Brio Technology. Reason, Discoverer is part parcel with 9IAS Enterprise that product is an unstable pig (CPU Disk). Had it here for a month late last year. Even the Oracle consultant could not get it installed working. Took a long night ton of reading plus help from OTS then we could only get it to work on Netscape. Dick Goulet Reply Separator Author: Bond Mike A Contr OC-ALC/TILC [EMAIL PROTECTED] Date: 2/25/2002 2:48 PM Hi, I was asked to recommend a Query Tool for some of our end users. I have used Q+E aka DataDirect Explorer for years. Now I can't find it on the internet. It has changed owners many times and may not even be available now. Does any one have a recommendation for a COTS product that allows the user with minimum knowledge of SQL to create SQL queries, views tables, store/recall queries, ... Is there an Oracle product that does that? Discoverer seems to be a bit heavy handed. Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bond Mike A Contr OC-ALC/TILC 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: DENNIS WILLIAMS 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: Bond Mike A Contr OC-ALC/TILC INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Database Query Tool
Hi, I was asked to recommend a Query Tool for some of our end users. I have used Q+E aka DataDirect Explorer for years. Now I can't find it on the internet. It has changed owners many times and may not even be available now. Does any one have a recommendation for a COTS product that allows the user with minimum knowledge of SQL to create SQL queries, views tables, store/recall queries, ... Is there an Oracle product that does that? Discoverer seems to be a bit heavy handed. Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bond Mike A Contr OC-ALC/TILC 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).
MQ Series
Title: RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000 Hi, Has anyone used MQ Series to get data to an Oracle database? If so I have a few questions. How? Documentation? ... Thanks, Mike -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 03, 2001 9:25 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000 I did 8.1.7.1 then did 8.1.7.5 "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 6:26 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000 From reading the instructions with 8.1.7.2.1 I had the impression that you had to move to 8.1.7.1.1 first and then 8.1.7.2 ? In any case, I had previously installed the Oracle Universal Installer that came with 8.1.7.0.0, and so I used that to apply the patch, because, like you, I was unable to run the "setup.exe" that came with the patchset. (Windows 2000 server) -Original Message- From: Don Granaman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 11:29 AM I have Oracle 8.1.7.0.0 running on a Windows 2000 Pro (sp2). I tried to install the 8.1.7.2.1 patchset according to the "readme" directions (shutdown all Oracle* services first, etc.), but when I try to run "setup.exe", nothing happens. The icon flashes momentarily after being double-clicked, but nothing ever actually runs. I tried it a number of times. Then I tried it with an older 8.1.7.1.1 patchset - and the exactly same thing happened. These patchsets are for "Windows NT", but I assumed they would work for 2000 as well. (Am I wrong in this assumption?) Does anyone have any experience with this and/or workarounds?
Resources for Gateway to MQ Series
Good morning, I am investigating Procedural Gateway for IBM's MQ Series. Documentation seems to be hard to find.Can anyone suggest a resource (links, books, etc) that would help in this area? Thanks, Mike
RE: Problem with DBMS_SQL
Hi,
I found this in metalink. I was able to duplicate your problem and even
though I have DBA role, I could not execut ethe proc until i granted myself
'create table' directly.
If a user is trying to create a table using DBMS_SQL, the user must have
create table privilege granted directly and not via a role.
Mike
-Original Message-
Sent: Friday, August 31, 2001 7:27 AM
To: Multiple recipients of list ORACLE-L
Daft question but do you have the priviliges to create tables? Silly I
know...
hit any user to continue
__
Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com
-Original Message-
Sent: 31 August 2001 13:01
To: Multiple recipients of list ORACLE-L
Dear All
Every time when I try to create table with the DBMS_SQL I get error
---
ORA-01031: insufficient privileges
ORA-06512: at SYS.DBMS_SYS_SQL, line 782
ORA-06512: at SYS.DBMS_SQL, line 32
ORA-06512: at DL.SP_CR, line 6
ORA-06512: at line 2
---
The procedure code is trivial and I call it as
begin
sp_cr('CREATE TABLE XTTBL(a NUMBER)');
end;
/
CREATE OR REPLACE procedure SP_CR(pvi_str VARCHAR2) AS
cid INTEGER;
err_code INTEGER;
begin
cid := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(cid, pvi_str, DBMS_SQL.native);
err_code:=DBMS_SQL.EXECUTE(cid);
DBMS_SQL.CLOSE_CURSOR(cid);
END;
/
What might be wrong here?
Yes, I can try native SQL (I'm running 8i) but code has to be portable to
the 8.05
Cheers,
Dimitri
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dmitriy M. Labutin
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: Thomas, Kevin
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: Bond Mike A Contr OC-ALC/TILC
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: Converting EBCDIC to ASCII
We do not pull data directly from IMS but load it in batch jobs. Our mainframe guy either dumps the data report-style (ASCII) or copies records in native EBCDIC to files on the mainframe. We ftp them to the Oracle side (binary mode to EBCDIC files) and use sql loader to move into Oracle. On the files that come over in EBCDIC, I use sqlloader with the following in the control file. There are a few bugs with loading EBCDIC (search metalink) but we manage to get it loaded. LOAD DATA CHARACTERSET WE8EBCDIC500 INFILE 'e:\filename.dat' fix 688 ... -Original Message- Sent: Friday, August 17, 2001 9:37 AM To: Multiple recipients of list ORACLE-L I may be moving data from an IMS db which is stored in EBCDIC. Oracle stores data in ASCII format. How do I go about converting EBCDIC to ASCII to store the data in Oracle (8.1.?)? Thanks, Ken Janusz, CPIM -- 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: Bond Mike A Contr OC-ALC/TILC 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: Database using 100% of CPU
WHat type of processors are in the server. We have a bug - i think in 8.1.5 or 8.1.6.0 that caused this very problem. Only upgrading the RDBMS fixed it. -Original Message- Sent: Friday, August 17, 2001 11:41 AM To: Multiple recipients of list ORACLE-L We are having a problem with our database - it is using 100% of the CPU. This has only started happening recently, and restarting the database temporarily stops it happening - it usually recurrs a few hours later. There are no jobs running, and at the moment there are no active connections. Obviously something has kicked this off, can anyone shed any light on this or suggest how to find out what is running on the db? Thanks in advance, Steven H. (Oracle 8.1.6.0.0 EE on NT 4 SP5) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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: Bond Mike A Contr OC-ALC/TILC 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: Converting EBCDIC to ASCII
yes, if you set the character set to ebcdic (CHARACTERSET WE8EBCDIC500) so that it can read the incoming file -Original Message- Sent: Friday, August 17, 2001 11:50 AM To: Multiple recipients of list ORACLE-L Thanks for the information. The IMS data will have to be cleansed before it is loaded into Oracle (8.1.? on W/2000). So there will be some intermediate files/tables that will be used for this purpose. Will sqloader convert EBCDIC to ASCII? Thanks, Ken Janusz, CPIM We do not pull data directly from IMS but load it in batch jobs. Our mainframe guy either dumps the data report-style (ASCII) or copies records in native EBCDIC to files on the mainframe. We ftp them to the Oracle side (binary mode to EBCDIC files) and use sql loader to move into Oracle. On the files that come over in EBCDIC, I use sqlloader with the following in the control file. There are a few bugs with loading EBCDIC (search metalink) but we manage to get it loaded. LOAD DATA CHARACTERSET WE8EBCDIC500 INFILE 'e:\filename.dat' fix 688 ... -Original Message- Sent: Friday, August 17, 2001 9:37 AM To: Multiple recipients of list ORACLE-L I may be moving data from an IMS db which is stored in EBCDIC. Oracle stores data in ASCII format. How do I go about converting EBCDIC to ASCII to store the data in Oracle (8.1.?)? Thanks, Ken Janusz, CPIM -- 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: Bond Mike A Contr OC-ALC/TILC 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: Bond Mike A Contr OC-ALC/TILC 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: books on data modelling
Take a look at Data MOdeling Essentials by Simsion Coriolis -Original Message- Sent: Tuesday, July 24, 2001 11:57 AM To: Multiple recipients of list ORACLE-L Hello All, I have been in the lookout for a good and comprehensive book on data modelling so that I can enhance my knowledge in this area. I am not finding anything related in online Oracle documentation. Please suggest me.. Thanks in Advance, Suren -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra 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: Bond Mike A Contr OC-ALC/TILC 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: 24 x 7 on NT?
We are running Oracle on a clustered Unisys Aquanta system and have had very few problems. I can only think of one time this year that I had unplanned downtime. The database files are on shared drives and the database software is installed on two nodes, allowing us to switch to node B in the event of node A's failure. I did not pick NT but it has worked out so far. Mike -Original Message- Sent: Tuesday, June 26, 2001 9:06 AM To: Multiple recipients of list ORACLE-L Can you explain redundant server/databases? Ron -Original Message- Sent: Monday, June 25, 2001 8:21 PM To: Multiple recipients of list ORACLE-L Believe it or not we do run two mission critical 7x24 databases on NT with few problems. The one system that is 'life and death' critical we run redundant servers/databases just in case. Debbie -Original Message- Sent: Monday, June 25, 2001 2:07 PM To: Multiple recipients of list ORACLE-L I have a treasury application that needs to be up 24 x 7 except for scheduled downtime. Is there any way to guarantee an app will be available 24 x 7 on NT? Is anyone faced with this? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: IT - Database (Do Not Use) 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: Smith, Ron L. 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: Bond Mike A Contr OC-ALC/TILC 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).
No Subject
Hi, I currently have OWS 3.0.4 and RDBMS 8.0.5 running on the same NT 4.0 machine. I need to upgrade the DB to 8.1.6. Has anyone experienced any problems running that version of OWS (we will upgrade that later) with RDBMS 8.1.6 (on the same machine)?? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bond Mike A Contr OC-ALC/TILC 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).
