Re: Urgent!!! ora-01115 ora-01110 ora-27069

2002-10-23 Thread Yechiel Adar
I now this thing. Had it two weeks ago. Call Oracle and ask them to come with the DUL (database unload) utility. Your database is OUT. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 8:58 AM OS:WIN2K

RE: Oracle Real Application Clusters

2002-10-23 Thread Jamadagni, Rajendra
IMHO, the main requirement is that you have to have a systemthat needs to be up 24x7 on a cluster and your ability to fork enough money to Oracle and your server vendor (to get two identical machines) and your networking vendor (for redundant network connections). Rest everything is easy

What is select all doing?

2002-10-23 Thread dist cash
We have ORACLE 8.1.7 running on server. My question is what difference on following select statement: select col1 form table1; select all col1 form table1; Look like output are the same. Thanks. _ Surf the Web without

Re: oracle or mssql

2002-10-23 Thread Igor Neyman
Because your boss is wrong on both issues: features and price. As for references, check this site: http://www.itsystems.lv/gints/compare_db.htm Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday,

Re: What is select all doing?

2002-10-23 Thread Michael Ivanov
We have ORACLE 8.1.7 running on server. My question is what difference on following select statement: select col1 form table1; select all col1 form table1; compare select distinct ... Look like output are the same. Thanks.

Re: Oracle Real Application Clusters

2002-10-23 Thread Tim Gorman
Aye to that, but you'll need at least two, possibly three, identical clusters, not just one. One clusterfor production and an identicalcluster for QA/Test, and possibly one for development (though that last is often regarded as unnecessary). Skimping on the QA/Test environment is the

RE: What is select all doing?

2002-10-23 Thread Naveen Nahata
there is no difference regards naveen -Original Message- Sent: Wednesday, October 23, 2002 6:59 PM To: Multiple recipients of list ORACLE-L We have ORACLE 8.1.7 running on server. My question is what difference on following select statement: select col1 form table1; select

ORA-02070: database does not support operator SYS_CONTEXT in this

2002-10-23 Thread Mirsky, Greg
For what it is worth... I've been battling this problem on Oracle 9i Release 2 and finally got it into Oracle as a bug. ORA-02070: database does not support operator SYS_CONTEXT in this context. (Oracle BUG Reference 2624342) when using an object that contains SYS_CONTEXT. I don't know if anyone

Re: What is select all doing?

2002-10-23 Thread Tim Gorman
SELECT ALL is the default behavior. SELECT DISTINCT is the other option. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 7:28 AM We have ORACLE 8.1.7 running on server. My question is what difference on following

RE: Website that contains materials about performance tuning of S

2002-10-23 Thread Farnsworth, Dave
You might be able to find what you need at this site. http://web.singnet.com.sg/~petermag/oracle.html Dave -Original Message- Sent: Tuesday, October 22, 2002 8:39 PM To: Multiple recipients of list ORACLE-L S Hi, Does anyone know of any web site that contains materials about

RE: Oracle Real Application Clusters

2002-10-23 Thread Jamadagni, Rajendra
You are right Tim (now you may ask "what's new in that?") We have a production cluster, development cluster and (possible a standby cluster) all identical. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com

Re: oracle or mssql

2002-10-23 Thread Alex
It depends on your companies needs. On Tue, 22 Oct 2002 [EMAIL PROTECTED] wrote: Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So why he

RE: oracle or mssql

2002-10-23 Thread Weaver, Walt
No it doesn't. MicroSoft is a card-carrying member of the Axis Of Evil. Last I heard they were developing nuclear weapons, probably in a huge bunker under Bill Gates' house. --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, October 23, 2002 8:54 AM To: Multiple

Opinions on BR scenarios

2002-10-23 Thread Rick_Cale
Hi DBAs, A co-worker and I disagree on impact of slightly different BR scenarios and I would like your thoughts. Environment for both scenarios: Oracle 8.1.6, WinNt, Archivelog mode, not using RMAN Scenario 1: I do standard Hot Backup using BEGIN BACKUP OCOPY ... END

RE: oracle or mssql

2002-10-23 Thread Mirsky, Greg
If he really wants to go cheap tell him to go with mySQL! At least it will be an open solution. Greg -Original Message- Sent: Wednesday, October 23, 2002 11:09 AM To: Multiple recipients of list ORACLE-L No it doesn't. MicroSoft is a card-carrying member of the Axis Of Evil. Last I

RE: Website that contains materials about performance tuning of S

2002-10-23 Thread Baker, Barbara
Wow. Thanks, Dave! I dropped this msg in the wastebasket, then for some reason went back and gave it a second look. Glad I did. Nicely organized. Barb -- From: Farnsworth, Dave[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, October 23,

Re: UPDATE

2002-10-23 Thread PK_Deepa/VGIL
Try this update x z set id2 = (select id2 from a where z.id1=id1 and id20) where id2=0; Deepa |+--- || Imran Ashraf | || imran9a@yaho| || o.com | || | ||

Re:oracle or mssql

2002-10-23 Thread dgoulet
In reality your boss does not have to invest in either. Flat files are still viable options for limited scope and usage applications. But in the real world most applications need a database of some type to run in a multi user environment. That being the case, why would one want to use either.

RE: oracle or mssql

2002-10-23 Thread Kevin Lange
Its been a while since I used MS SQL but one of the downsides that I experienced was the fact that MSSQL could not support the user loads we needed right out of the box. We had to cluster servers together to get the throughput that we got out of Oracle. MSSQL might be cheaper at the database

RE: CA's AutoSys

2002-10-23 Thread Tracy Rahmlow
We purchased Autosys when it was owned by Platinum and continue to use it today for all of our production jobs. The server and clients are running on AIX 4.3.3. and we have had no problems with the product. @fatcity.com on 10/18/2002 08:19 AM PST Please respond to [EMAIL PROTECTED]

RE: oracle or mssql

2002-10-23 Thread DENNIS WILLIAMS
G - Actually, Oracle may not be more expensive. First, of all, you must do a little digging into what is included in licensing fees. There are some extras you must pay for with MS that aren't obvious at first glance, like the right to upgrade. If you compare list prices, both Oracle and MS

Re: Opinions on BR scenarios

2002-10-23 Thread Rachel Carmichael
both scenarios potentially lose the online redo logs. actually, since you don't include the backup of the archived redo logs in either scenario, you can't do recovery without a resetlogs for both scenarios. In order not to lose the contents of the online logs, you have to archive them and back

How to check total space a user allocate on ORACLE?

2002-10-23 Thread dist cash
We have ORACLE 8.1.7 on SUN server. Does anyone has script that can ckeck how many total space a user allocate on oracle? Thanks. _ Internet access plans that fit your lifestyle -- join MSN.

Re: oracle or mssql

2002-10-23 Thread Rachna Vaidya
Is MSSQL server available on UNIX? -Rachna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 11:25 AM Its been a while since I used MS SQL but one of the downsides that I experienced was the fact that MSSQL could not

RE: Physical read too large

2002-10-23 Thread Ofer Harel
This is HP True64Unix with Oracle 8.1.7 I found nothing in metalink Ofer -Original Message- Sent: Tuesday, October 22, 2002 4:14 PM To: Multiple recipients of list ORACLE-L What version and platform you are on? Sounds like a bug... There have been a few related to huge values

Linux

2002-10-23 Thread Turner, Christine
Greetings ALL! Have a question for anyone who has infoI'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will soon. Does anyone have any information on Linux? Whether or not Oracle can run on it? Info on the

RE: oracle or mssql

2002-10-23 Thread Gogala, Mladen
I've heard that, too. We must be afraid because Microsoft ICBM's will be running Win2k/sp3 and .net. Knowing the security of that particular peace of software, I wouldn't be surprised if they blow the world up before their next release. -Original Message- From: Weaver, Walt

standby database question.

2002-10-23 Thread Joe Testa
I'm back on 8i for a different client who wants to implement standby database. other than the whole possibility of losing data during a failover, i've not been able to find anything about doing managed recovery with out having a dedicated session to put the database in managed recovery mode.

RE: Opinions on BR scenarios

2002-10-23 Thread Fink, Dan
Rick, I will assume that all logs are properly backed up. The only difference in the recoverability of the 2 scenarios is that an incomplete recovery cannot be done to a time while any tablespace in the database is in hot backup mode. So, there is a window of exposure in Scenario

Re:Opinions on BR scenarios

2002-10-23 Thread dgoulet
Rick, I'm going to make the following assumptions about both scenarios, namely that both instances are in 'archive log mode' and that your handling the archived redo logs separately. That being said, both scenario's are viable for recovery up to the point of failure assuming that in the

RE: oracle or mssql

2002-10-23 Thread Farnsworth, Dave
-Is MSSQL server available on UNIX? Hahahahahahahahaha. ROTFLMAO :o) No. Only on windows. Dave -Original Message- Sent: Wednesday, October 23, 2002 10:59 AM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -- Please see the official ORACLE-L FAQ:

Re[2]: oracle or mssql

2002-10-23 Thread dgoulet
ARE YOU AN IDIOT?? Otherwise, pass some of whatever your smoking this way because it must be good!! Dick Goulet Reply Separator Author: Rachna Vaidya [EMAIL PROTECTED] Date: 10/23/2002 7:59 AM Is MSSQL server available on UNIX? -Rachna -

RE: Oracle Real Application Clusters

2002-10-23 Thread Loughmiller, Greg
We are performing a rather detailed POC of RAC within a SUN environment... Be glad to share some details once we complete this to those interestedI'm hoping for a detailed document with detailed use cases... But that does assume those who are in the separate areas will accomplish that as

RE: Oracle Real Application Clusters

2002-10-23 Thread DENNIS WILLIAMS
Tim - Gee, during the original presentation I attended, RAC was presented as a cost-saving feature. Something about being able to use a lot of cheap Linux servers. This stuck me as a little odd at the time. Just now, I looked at the white papers that Oracle posts on the subject, and I didn't see

Insert too slow...

2002-10-23 Thread sat0789
Hello All, We are running oracle 9.2 on a sun box in a DW env. Data loads are thorugh informatica. During one such load of fact table, the load time per sec is about 300 rows per sec. The table is suppose to load about 5 mil rows. During the load i happen to do

Re: Linux

2002-10-23 Thread ltiu
Run it on Linux like you would run it on Windows. You do need some Unix skills for any OS level work though. Otherwise, Oracle is the same (mostly) on both platforms. Download Oracle for Linux., It's free for evaluation, education and development use from http://www.oracle.com -- Lyndon Tiu

RE: oracle or mssql

2002-10-23 Thread Gogala, Mladen
It will be open, not necessarily a solution. -Original Message- From: Mirsky, Greg [mailto:gmirsky;Estee.com] Sent: Wednesday, October 23, 2002 11:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: oracle or mssql If he really wants to go cheap tell him to go with

Re: Website that contains materials about performance tuning of S

2002-10-23 Thread Tim Gorman
same here! thanks Dave! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 9:15 AM Wow. Thanks, Dave! I dropped this msg in the wastebasket, then for some reason went back and gave it a second look. Glad I did.

RE: Physical read too large

2002-10-23 Thread tim
This is your opportunity to contribute to the body of knowledge; log a TAR... This is HP True64Unix with Oracle 8.1.7 I found nothing in metalink Ofer -Original Message- Sent: Tuesday, October 22, 2002 4:14 PM To: Multiple recipients of list ORACLE-L What version and

RE: linux

2002-10-23 Thread Joe Testa
It run beautifully. i've been running oracle(not so much production but up thru testing/QA) on linux platform since 8.0. I love it. You know that the datafiles format is not compatible, so the only choice to migrate to linux is exp/imp. It runs on linux like it runs on any other *nix(except

Re: How to check total space a user allocate on ORACLE?

2002-10-23 Thread Tim Gorman
query SUM(BYTES) from USER_SEGMENTS, or query DBA_SEGMENTS where OWNER = username - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 9:54 AM We have ORACLE 8.1.7 on SUN server. Does anyone has script that can ckeck how

RE: DW setup

2002-10-23 Thread Kawatra V (Vikas) at Aera
Its interesting to me what you guys are attempting -we're setting up a large DWH as well and use a similar technology BC copy to backup the dbs etc . In the process you outlined - I do question the need for two copies of the DWH - a dbs for writing ETL's to and another for read-only .Why do

RE: oracle or mssql

2002-10-23 Thread Boivin, Patrice J
Re. the trial, does anyone know when the judge is expected to rule? Not a peep re. expected timeline in the media that I can find. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services

Re:Linux

2002-10-23 Thread dgoulet
Christine, Runs fine, but you'll have to use the export/import conversion route. OH, and get use to a different OS. Dick Goulet Reply Separator Author: Turner; Christine [EMAIL PROTECTED] Date: 10/23/2002 8:14 AM Greetings ALL! Have a

Re: standby database question.

2002-10-23 Thread Tim Gorman
Correct. ...though you can achieve the same thing in 8i by running the SQL*Plus or SvrMgr process in a backgrounded script. Stopping the backgrounded script is easy using the RECOVER CANCEL command from any other session... - Original Message - To: Multiple recipients of list ORACLE-L

Re: standby database question.

2002-10-23 Thread Rachel Carmichael
Windows? I used to do this with a 7.3.4 instance on Unix, I had a shell script that would run every x minutes, and would first check to see it if was already running. If not, it would do the recover automatic. It would fail when it ran out of archived logs to apply, but the cron would restart it

RE: Linux

2002-10-23 Thread Jim Hawkins
We have Oracle 8.1.7 and 9.2.0 running on Red Hat Linux 7.2 - and love it. It is not a production box though. We are still in test mode. Jim Hawkins Oracle Database Administrator St. Louis, MO Turner, Christine [EMAIL PROTECTED] wrote: Greetings ALL! Have a question for anyone who

Rollback segment space usage

2002-10-23 Thread Leonard, George
Hi all, Trying here now since have tried to find it online and build the query myself. I need to figure out how much space a user/session is using of a rollback segment. I got the queries to show which segment the user is attached to but need to know how much is being used (something like a

RE: oracle or mssql

2002-10-23 Thread Boivin, Patrice J
XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des

RE: Insert too slow...

2002-10-23 Thread Whittle Jerome Contr NCI
Title: RE: Insert too slow... How may indexes are on DM_TRANS_PYMT_HIST? If there are a lot, you might want to drop the indexes, except for the primary key or unique constraints, insert the records, rebuild the dropped indexes, and analyze those indexes. Jerry Whittle ACIFICS DBA NCI

Re: Linux

2002-10-23 Thread Joe Raube
See http://otn.oracle.com/tech/linux/content.html It runs very well. Moving a database from NT to Linux is as easy as export/import. Other methods exist too. --- Turner, Christine [EMAIL PROTECTED] wrote: Greetings ALL! Have a question for anyone who has infoI'm researching what it

Re: Reduce parse call for stored procedure?

2002-10-23 Thread mkb
How about using bind variables in your execute immediate statement. Please see doc id 34433.1 and 366753.999 on Metalink as I followed 34433.1 for what I tested below. 366753.999 is a forum question which relates very well to doc id 34433.1. create table t (col1 number, col2 varchar2(10));

Now: Kudos - Peer-to-Peer in Oramag Was: Oracle Real Application

2002-10-23 Thread John Kanagaraj
First of all: Kudos to List members Murali Vallath and K 'X$' Gopalakrishnan who appear in the current Oramag issues's Peer-to-Peer column! The reason I mutated this particular thread was on account of something I saw in this column. Murali Vallath apparently is writing a book on RAC. Maybe we

Re: standby database question.

2002-10-23 Thread Joe Testa
nope its unix(solaris flavor). thanks for the idea, thats probably what I'll do versus trying to setup data guard on the nodes. joe Rachel Carmichael wrote: Windows? I used to do this with a 7.3.4 instance on Unix, I had a shell script that would run every x minutes, and would first check

Re: oracle or mssql

2002-10-23 Thread Joe Testa
Xenix, now there an OS i've not heard about since '89. joe Boivin, Patrice J wrote: XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics

Re: Opinions on BR scenarios

2002-10-23 Thread Ray Stell
On Wed, Oct 23, 2002 at 08:14:07AM -0800, Fink, Dan wrote: Rick, I will assume that all logs are properly backed up. The only difference in the recoverability of the 2 scenarios is that an incomplete recovery cannot be done to a time while any tablespace in the database is in hot

Re: Linux

2002-10-23 Thread Ray Stell
Define Linux. Check the support matrix. I liked running on Redhat, but Oracle seemed to drop support for the free versions after 7.1 or so. Anyway, you may want support and so you may want to purchase some of the enterprise releases of linux, such as from RedHat or SuSE that are included in

RE: linux

2002-10-23 Thread Phil Wilson (DBA)
What distribution/version of Linux would you recommend (RedHat, Suse, etc.)? Thanks Phil Wilson ([EMAIL PROTECTED]) DBA, Operations Group SkillSoft, Learning Solutions for the Human Enterprise 506.462.1124(w) 506.447.0334(c) -Original Message- Sent: Wednesday, October 23, 2002 1:50

RE: Website that contains materials about performance tuning of S

2002-10-23 Thread DENNIS WILLIAMS
New Bee If I understand your question, you are looking for information on how to tune SQL statements. Actually, I've been searching for something like this for quite a while. I glanced at the web link in Dave's reply, but I didn't see anything that directly addressed SQL statement tuning. If I

RE: Rollback segment space usage

2002-10-23 Thread Fink, Dan
Use used_ublk, used_urec from v$transaction. You will need to join to v$session to get the session info. USED_UBLK USED_UREC -- -- 12918 -Original Message- Sent: Wednesday, October 23, 2002 11:02 AM To: Multiple recipients of list ORACLE-L Hi all,

RE: Rollback segment space usage

2002-10-23 Thread Kevin Lange
SELECT r.NAME, -- rbs name s.sid, s.serial#, s.username, s.machine, t.status, t.cr_get, -- consistent gets t.phy_io, -- physical IO t.used_ublk, -- Undo blocks used t.noundo, -- Is a noundo transaction SUBSTR (s.program, 1, 78) COMMAND, s.username DB User,

RE: Insert too slow...

2002-10-23 Thread sat0789
Except for primay key constraint we dont have any other constraints or indexes present during the load. What does the sql * net wait events signify. Is there cause for concern when we see those events. ?? Thanks, Sathish. On Wed, 23 Oct 2002 09:02:21 -0800, Whittle Jerome Contr NCI [EMAIL

Re: Rollback segment space usage

2002-10-23 Thread Mohammad Rafiq
George, Try this query and check for average_active select ud.name, sg.extents ext, round(sg.blocks * ts.blocksize / 1048576, 2) MB, round(s.optsize / 1048576, 1) optsize, round(s.aveactive / 1048576, 1) AVEACT, round(s.hwmsize / 1048576, 1) HWMSIZE,

Theory v Practice

2002-10-23 Thread Craig Healey
The developers working on our new VB app are also responsible for setting up the Oracle DB behind it. The app is for an order entry/despatch/warehouse system with 5 million customers and 1000 orders per day. We have nearly 400 tables. They are not planning on using primary keys/secondary keys, as

RE: Insert too slow...

2002-10-23 Thread DENNIS WILLIAMS
Sathish Given that your high wait times relate not to the actual Oracle insert process but to communication with the client, the first place I would look is the connection between Oracle and Informatica. Are you going through ODBC? There are options in SQL*Net and in the ODBC driver. I would

RE: Opinions on BR scenarios

2002-10-23 Thread Fink, Dan
It provides a window for an incomplete recovery during the time that the backup is being performed. For example 02:00 1st tablespace begins backup 04:00 last tablespace ends backup with no time gaps in between It is not possible to perform an incomplete recovery from 02:00 to 04:00. 02:00 1st

RE: Linux

2002-10-23 Thread Turner, Christine
Kewlness! Thanks everyone for your input. Totally off the dba subject...does anyone know of any C++ developers that have information regarding converting to UNIX. My developers are going stir crazy trying to find any steps to follow when converting C++ applications for Linux. If not, that's cool,

Re: standby database question.

2002-10-23 Thread Ray Stell
On Wed, Oct 23, 2002 at 08:49:49AM -0800, Tim Gorman wrote: Correct. ...though you can achieve the same thing in 8i by running the SQL*Plus or SvrMgr process in a backgrounded script. Stopping the backgrounded script is easy using the RECOVER CANCEL command from any other session... I

Re: linux

2002-10-23 Thread Joe Testa
Well technically, only the advanced version of RH( are supported, i think most if not all(some please clarify) of Suse are supported. go here: http://www.redhat.com/oracle_cert/ for the scoop of versions of oracle on which versions of RH are certified. Joe Phil Wilson (DBA) wrote: What

Re: Opinions on BR scenarios

2002-10-23 Thread Rajesh . Rao
If the database crash causes media failure of your archive destination or your online log destination, then you can only recover the database upto the last archivelog availability, and you would need to open the database with resetlogs. This is true for both scenarios. Assuming no media

Re: standby database question.

2002-10-23 Thread Rajesh . Rao
That would be the manual mode. Recover standby database. With 8i, and the multiple archive destinations, you have the sustained recovery mode. Recover managed standby database. A sustained recovery mode will lock your telnet window, and will be dedicated to doing just the recovery. But then, one

RE: Theory v Practice

2002-10-23 Thread Mercadante, Thomas F
Craig, No, this is not normal. They have purchased a Caddy so they can push their grandma to the beauty parlor to get her blue-hair done - they will never start the car. Why in the hell did they purchase Oracle in the first place? Talk about a waste of money! If you cannot stop them now, then

Re:Theory v Practice

2002-10-23 Thread dgoulet
Craig, Your right, Oracle is just being used as an expensive file system. Get them to use MySql instead, it's far cheaper. Now from a practical point of view, who are these duhvelopers that they dictate setting up the database? If they were in our shop they would not have gotten onto

Re: Theory v Practice

2002-10-23 Thread Joe Testa
Craig, i dont know jack about VB but M$ Access wont let you do updates(according to my sources) unless there is PK or Unique index on the tables. joe Craig Healey wrote: The developers working on our new VB app are also responsible for setting up the Oracle DB behind it. The app is for an

Re: Theory v Practice

2002-10-23 Thread Rodd Holman
Craig, Unfortuneatly this happens alot. Many developers have an over inflated view of their abilities and think they can write their code good enough to handle this. Every time I have seen this in place I have seen data integrity problems. Some major application vendors do this to provide the

RE: Opinions on BR scenarios

2002-10-23 Thread Rajesh . Rao
Dont you mean complete recovery? You could then perform an incomplete recovery until 02:10:01 - 02:10:59 or 02:21:01 - 02:21:59, etc. Fink, Dan

RAC on the cheap

2002-10-23 Thread Steve Rospo
If I wanted to put together a cheap RAC for play purposes what sort of HW/SW would I need? I'm not talking about a production-level solution here, just taking some older-HW I might have laying around and turning it into a RAC with a minimal investment for sandbox purposes. Could I do it with 2+

Ora-600 Lookup on Metalink

2002-10-23 Thread Steve Perry
I'm sure some of you are aware of this, but it was news to me. I had to open a tar because of ORA-0600 [4000] and while creating an itar found that I could lookup ORA-600's directly. My ora 600 wasn't published, but it may help others

Re: Theory v Practice

2002-10-23 Thread Rachel Carmichael
it's not common and you should insist on primary and foreign key constraints. all you need is ONE user to hack into the database outside the app and insert/delete/update rows that violate the integrity constraints and your app stops working. --- Craig Healey [EMAIL PROTECTED] wrote: The

Re: Linux

2002-10-23 Thread Ron Rogers
Christine, I found it easier ( because I had the OS disks) to load the PC with RedHat6.2 and then install Oracle 8.1.7. That eliminated the glib and java problems encountered with the RedHat 7.0 and 7.1 versions. Then I upgraded the OS to 7.0 and finally 7.1 after I found things ran perfectly.

Re: Theory v Practice

2002-10-23 Thread Jay Hostetter
When code is developed to be database generic, developers will steer away from code for a specific database. However, foreign key and check constraints hardly fall into this category. I don't use Sqlserver or DB2, but I would guess that they implement FKs and constraints. Your developers

RE: Linux

2002-10-23 Thread Daniel Harron
We have experience numerous problems with high transaction load databases. The i/o drivers and memory drivers have proven to be unstable. The largest problem seems to occur with the memory drivers. Try running a linux database with and SGA over 1GB. We have been able to duplicate these

RE: oracle or mssql

2002-10-23 Thread Mohammad Rafiq
Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin

RE: Theory v Practice

2002-10-23 Thread STEVE OLLIG
Craig - I've seen large/busy databases run with RI handled outside the db. Most common with package apps like Peoplesoft. They do that because they want to run on many DBMSs and each handles RI differently. To reduce development cost, they code once to the least common denominator. Thus no RI

RE: Website that contains materials about performance tuning of S

2002-10-23 Thread Jacques Kilchoer
Title: RE: Website that contains materials about performance tuning of S -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] For Oracle, the best resource I've found is a book (not free, but pretty inexpensive) Oracle SQL Tuning Pocket Reference by Mark Gurry

RE: Theory v Practice

2002-10-23 Thread Mirsky, Greg
Wow, Life is stranger than fiction! First of all buy stock in your hardware vendors since every query will result in a table scan of every table and if you get more than an intermittant workload on the system, it may very well come down onto its knee's. indeed they are making it a very expensive

Re: Theory v Practice

2002-10-23 Thread Yechiel Adar
This is VERY wrong. I know they are perfect, but one bug in the code will cause data loss, order entries without a correct customer code etc. Lets say that a year from now one customer complain. They print a report and see that two entries are missing. You check for orders with incorrect

RE: Theory v Practice

2002-10-23 Thread Karniotis, Stephen
OK. For everyone's benefit, this is commonly known as the Developer's Paradox. Essentially, it means that developers write more code so they are brought back to maintain the stuff. Your developers have tragically forced you into this. Instruct them on proper database/application/system

RE: Theory v Practice

2002-10-23 Thread Karniotis, Stephen
Oops, for got Ladies on my last email. Rachel definitely has some good opinions on this. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent:

RE: Rollback segment space usage

2002-10-23 Thread Leonard, George
Hi Kevin, Fantastic, thx, just what I was looking for, will event tell the oracle support person that could not even assist. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575

RE: Theory v Practice

2002-10-23 Thread Gogala, Mladen
Can you send them to oracle training in Bethesda, MD or Reston, VA? Benefits could be multiple, especially for you. Make sure that they wear clothing in bright colors. -Original Message- From: Craig Healey [mailto:C.Healey;hhsuk.com] Sent: Wednesday, October 23, 2002 1:45 PM To:

ORA-600

2002-10-23 Thread Seema Singh
Hi I am having following error message in alert log on standby database at time of recovery. ORA-00600: internal error code, arguments: [3020], [46191421], [1], [8439], [18903], [16], [], [] Metalink say its BUG.Does any one faced such error? If yes how to fix that. Thx -Seema

RE: Theory v Practice

2002-10-23 Thread Mandar A. Ghosalkar
3 yrs after ur developers code the VB app, the original team vanishes(they start working on .net .. or maybe java) The new team even after going through the docs and vb application libraries, forget the right joins and insert invalid data/update rows in the master without taking care of the

RE: linux

2002-10-23 Thread Gogala, Mladen
I'll be able to tell you more about 9.2.0.2 on RH 8.0 after this weekend. I don't expect any trouble. -Original Message- From: Joe Testa [mailto:jtesta;dmc-it.com] Sent: Wednesday, October 23, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: linux Well

RE: OEM can't seem to discover 1 instance

2002-10-23 Thread Phil Wilson (DBA)
Did you ever discover the rogue instance? I would be interested in learning why it wasn't being discovered. Phil Wilson ([EMAIL PROTECTED]) DBA, Operations Group SkillSoft, Learning Solutions for the Human Enterprise 506.462.1124(w) 506.447.0334(c) -Original Message- Sent: Friday,

Re: Re: oraperf comment

2002-10-23 Thread Connor McDonald
The main problem as I see it is that you might be lucky in getting IO balance with a tables-here-indexes-there approach in rule based databases, where pretty much the only thing Oracle can do is table scan and single block index read. But since 7.3, and even more so with the more recent releases,

RE: Theory v Practice

2002-10-23 Thread Rachel Carmichael
here's my standard answer to developers who try to tell me how the database should be designed: which part of the word No don't you understand? The DBA should know best how to use the abilities of the database. I can understand that with 3rd party applications, which have been coded to be

RE: Theory v Practice

2002-10-23 Thread Kevin Lange
-- Make sure that they wear clothing in bright colors. Not exactly a nice comment Gogala I have friends in that area who are dealing with the sniper every day I am sure there are others as well. -Original Message- Sent: Wednesday, October 23, 2002 2:33 PM To: Multiple

RE: ORA-600

2002-10-23 Thread DENNIS WILLIAMS
Seema - I used the ORA-600 lookup function on metalink, but it said nothing had yet been published on this error. Your best choice may be to file a TAR. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 2:33 PM To:

RE: Linux

2002-10-23 Thread Gogala, Mladen
There are tons of IDE software like Anjuta, CodeWarrior, CodeCrusader, Grasp and alike which can ease up transition. The following URL is, however, worth looking if you have to deal with hard core Micros*t guys: http://www.bristol.com/windu/index.html -Original Message- From: Turner,

  1   2   >