Re: Help ! ORA-00600 : internal error code

2001-07-26 Thread sheisey
John, You haven't indicated what version of Oracle you are running or what application you where running when you got this error message. These kinds of error messages are best resolved by logging a tar with Oracle support. I am no expert at 600 error messages, but I believe this error is

Re: RAC/OPS changes

2001-07-26 Thread sheisey
Well you asked for this. Don't read this if you are faint of heart and weak of mind. Oracle9i Real Application Clusters is the next evolutionary step up from Oracle Parallel Server, and is the result of more than 6 years of development, 9 patents, and 18 additional patents pending. Oracle9i Real

RE: 9i On Linux

2001-06-18 Thread sheisey
Roger, I don't believe that Oracle9i is certified on Redhat at the moment. There had been a lag in certification between Redhat and Oracle in the last few months. This situation has been resolved and certification has been restarted between Redhat an Oracle. I think you will have to wait for

Re: Re[2]: About parallel server

2001-05-31 Thread sheisey
Dick, I am not sure which platform you where using for OPS, but you have to use raw device's. Unless you are using OpenVMS or Compaq TRU64 v5.1 you have to use raw devices for datafiles, controlfiles and online redo logs. Archive logs have to go to a file system. Now there are some

RE: About parallel server

2001-05-31 Thread sheisey
Rachel, OPS or in 9i RAC (Hate name changes confuses everyone) raw devices are a requirement of the OS not Oracle. So whether you are using 7, 8, 8i, 9i you can use filesystems for OPS (RAC) if the OS supports multiple concurrent mounts on the same filesystem from multiple nodes. This is the

Re: About parallel server

2001-05-31 Thread sheisey
Ray, Oracle9i RAC (Real Application Clusters) is or was (depending on your perspective) Oracle Parallel Server. Compaq is working with Oracle to pre-install and ship Oracle9i on there NT boxes (not sure about TRU64 or OpenVMS platforms), so you just turn it on and it works. Oracle9i

RE: About parallel server

2001-05-31 Thread sheisey
Fernando, If your current resources are limited and the app is partitioned, you should have very few problems implementing the App in OPS (famous last words). If HA is a requirement and fast failover times OPS is a good pick. Just make sure the ends justify the means. Some people have good

Re: How do I corrupt a block

2001-05-31 Thread sheisey
Jared, BBED is available on UNIX, you just have to make it with the make command. cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed The bbed command can allow you to soft corrupt a block and you can use the dd command to hard corrupt the block. The bbed command does

Re: About parallel server

2001-05-30 Thread sheisey
Fernando, You will need cluster manager and shared disk drives to build this cluster. You need at least Oracle 8.1.6 or 8.1.7 Solaris 2.6 Sun Cluster Manager 2.2 Some volume manager preferably Veritas 2.2.1+ or 3.0.4+ Solaris 8 (2.8) Sun Cluster Manager 2.2 or 3.0 ( If you use SC 3.0 then

RE: Oracle 9i Articles - self tuning, launch delayed to

2001-05-11 Thread sheisey
Eric, Sales and marketing have 1 job and that is to sell and market. These marketing things are teasers not necessarily giving detailed information. I have not checked but there may be some Oracle9i stuff on OLN. I think OLN has a trial membership (for 30 days?). However I am not sure of the

Re: 9i Real Application Clusters

2001-05-11 Thread sheisey
Rajnedra, Oracle9i RAC is what we now call Oracle Parallel Server. Oracle9i RAC is still BETA, so there may not be any white papers at the moment. I have looked and have not found any white papers on RAC. Scott Dear Friends Does anyone have any knowledge or experience with Oracle 9i

Re: Oracle9i block structures

2001-05-11 Thread sheisey
Unal, What part of the block sturcture? Segment Header, Datablock Header? There are things in the blocks that are no different than they where in 6,7,8 or 8i. However with some of the new features such bitmap freelists, low highwater mark, high high waterwater, and changes to pctfree. There

Re: Rollback Segments

2001-05-11 Thread sheisey
Don, I hate to be a stick in the mud but there are some things I think need to clarified. I can think of no practical(?) use except for parallel server. In parallel server an instance will aquire private rollback segments specified in init.ora. If none (or too few) are specified, it