I concur about the software prices on big machines. We work with IBM
mainframes and the last upgrade cost us a lot in SOFTWARE licenses, since we
moved into a higher performance group.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Just a thought. A big company (you mentioned 900 user
logged in) probably has inventory of all the machines used. Get a list of the
machine and try to find someone who can match it, or send you inventory records
and you can do the matching yourself.
Yechiel AdarMehish
- Original
short question:
if i fix a corrupted block using dbms_repair to mark block software corrupt, will I be able to access data contained in that block?
thanks in advance...
Regards,
Rhojel
Thanks Paul.
I did a check this week with out Win2000 tech support and
was told that it come with 3GB process size while WNT was limited to 2GB
(without special parameters).
What is this pslist command? Is it something from
Unix?
Yechiel AdarMehish
- Original Message -
From:
ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set],
[], [], [], [], [], [], []
on 9.2.0.4 64 bit; Solaris 2.8
mvg/regards
Jo
Prem Khanna J [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/05/2003 03:14
Please respond to ORACLE-L
To: Multiple recipients
IIRC - no. The block will be marked as corrupted and you
can not access it.
Maybe you can dump the block using OS tools and see what
data is in there.
Yechiel AdarMehish
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent:
Jared,
I think what you've discovered is just a repeat
of the fact that different functionality is appropriate
in different circumstances.
Imagine replacing your v$sql_workarea_histogram
with a chunky SQL statement that crunched through
a massive table producing a small result set.
In those
Fixed in 10.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
Three-day seminar:
see
Hi!
Does anybody out there have any experience with the setup and administration
of Oracle Internet Directory (OID)?
Do you have any white papers or presentations on how to do so?
This is 9.2 on HP-UX.
Thanks,
Helmut
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
Also add the library cache load and pin events to that.
Anjo.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 05, 2003 5:19 AM
1. latch free for the shared pool latch (a shared pool latch in 9i).
2. Indirectly, SQL*Net message
Hi all,
I have installed oracle 9.2 server and managemenst server on windows.
I have perform full installation.
But there is no DBA Studio in oracle tools.
Any comment.
Rgds.
Arslan.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL
The functionality is now integrated in the console.
mvg/regards
Jo
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/05/2003 11:29
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:dba studio in oracle9.2
Title: Message
winternalssoftware runs a website called sysinternals which has a
bunch of useful free utilities for windows (and IIRC Linux now as well). pslist
is one of those utilities.
www.sysinternals.com
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL
Bahar , i think it's only OEM with 9iR2.
... and perhaps u have everything there .
Regards,
Jp.
-Original Message-
On Behalf Of [EMAIL PROTECTED]
Hi all,
I have installed oracle 9.2 server and managemenst
server on windows.
I have perform full installation.
Thanks for all the replies...I'm wading through them!
One more question...Do I always need to specify the full path of a Unix
command e.g /usr/bin/mv rather then just mv
That is something I don't currently need to do when using an external
procedure.
John
-Original Message-
Sent: 04
Hello @all,
maybe this is a newbie question (at least I am)
I've got an Oracle 8.1.7 installation on Sun Solaris 8 (sparc). We use some
database management software which gegerates several select-statements going
over ten database users. After some seconds (everytime in another db-user and
Our Unix guys create 'safe' versions of normal utilities and installed them in a
special folder. So, we use the full path to invoke them from *that* folder. Some
commands get logged to audit files. I'd say, yeah, specify full path, you don't loose
much (well some electrons, but who cares).
Raj
works on 9202 but that's not what you wanted to hear ... right?
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having
Is it possible there are stuck memory segments (using ipcs -m when instance is
shutdown) ??
Any other errors in alert log, etc ?
- Babette
-Original Message-
Sent: 2003-12-04 9:34 AM
To: Multiple recipients of list ORACLE-L
Anyone know what might be causing this error? Oracle 8.1.7
Tanel,
I know, we are not what we would like to be, so I am trying to find some middle point.
We can't make drastic changes to app, ESPN's daily business including on-air scores
and programming gets affected by that (not to mention the huge calculators that run to
estimate how much money we
The
same thing occurs on OpenVMS on version 9.2.0.4 of Oracle.
Nelson
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday, December 04, 2003
7:29 PMTo: Multiple recipients of list ORACLE-LSubject:
Analytic bug in 9.2.0.4While playing around
Simon, what is your CPU consumption? Are CPUs executing oracle
processes (top) or sitting idle? If CPUs are executing oracle
processes, you may have a problem with parsing. If they're sitting
idle and doing nothing, your client program(s) may be to blame
or you may have a network problem. Have
No, it couldn't. That is the problem. They are telling me to hack up
my own makefile. So far, I've been unsuccessful, that is precisely why I'm asking.
On 12/04/2003 04:49:30 PM, Jesse, Rich wrote:
Perhaps the homepage on http://www.selfsoft.com/progs/mod_plsql/ could help?
Rich
Rich Jesse
Do you know when will this fabulous version 10 be available for download?
On 12/05/2003 04:14:34 AM, Jonathan Lewis wrote:
Fixed in 10.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who
It wasnt fixed in my version of 9.2.0.3:
ERROR at line 11:
ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [],
[],
[], [], [], [], []
9.2.0.3, 32-bit. Solaris 8.
Brian
-
| Brian McGraw -+- Senior DBA |
| mailto:[EMAIL PROTECTED] |
My favorite SF computer is Holly, from the Red Dwarf. Add a
hologram like Rimmer and who needs anything else? I believe
that Holly was running MS-Windows.
On 12/04/2003 04:44:26 PM, Bellow, Bambi wrote:
I know I've posted this before, but it's been many years, so here we go
again.
NT was
Hi
Oracle 9.2.0.3
AIX 5L
anyone fail to start an instance after upgrading to 9.2.0.4
Everytime I try to start my instance which was working before the patch, I
receive 07445 errors.
Got the usual call raised but thought I would ask in case anyone had similar
issues.
Regards
Lee
It works fine for me - 9.2.0.3, 64-bit, Solaris 9
-Debbie
-Original Message-
Brian McGraw
Sent: Friday, December 05, 2003 8:09 AM
To: Multiple recipients of list ORACLE-L
It wasn't fixed in my version of 9.2.0.3:
ERROR at line 11:
ORA-00600: internal error code, arguments:
Hadrons are a class of elementary particles. A large hadron collider is
a device for smashing them together at extremely high energies and
seeing what happens. It is a very expensive, and very effective, way of
finding out what matter is made of.
Niall
-Original Message-
From: [EMAIL
Title: RE: java package to run OS command
Take a look at metalink doc 222079.1
-Original Message-
From: John Dunn [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 04, 2003 7:49 AM
To: Multiple recipients of list ORACLE-L
Subject: java package to run OS command
I need a java
Hi Faan,
Thanks Faan for this effectively critical point. Like
you I have faced this problem after applying some
patch (FND patches on 11.5.7) and since I have standby
database as emergency environment. It was big problem.
I wrote a scripts to detect such events and I read
some metalink docs
Good analogy to this methodology is to take a watch, wrap it in a towel, smash
it with a hammer, then try to figure out how it worked by looking at the pieces.
Henry --who stayed away from any area in physics where the author list was
longer than the paper abstract
-Original Message-
Running dbua to upgrade 8.1.7 to 9.2.0 database produces:
ORA-12545: Connect failed because target host or object does not exist.
Very annoying because looking at logs under .../assistants subdirectories and
../admin/upgrade/logs or the alert log - directories doesn't show what the missing
too funny.
It was 'fixed' in 9203.
According to Jonathan, it has actually been fixed in 10.
Jared
Jamadagni, Rajendra [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/05/2003 04:19 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Paula,
Just follow the steps for manually upgrading in the upgrade guide
as you have stated. The dbua doesn't really give you a lot of
information when things go wrong.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/05/2003 07:54 AM
Please respond to ORACLE-L
To:
With a couple of exceptions, it appears that it is consistently
buggy on several platforms.
iTar time I guess.
Thanks,
Jared
Hrncirik, Debbie [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/05/2003 06:29 AM
Please respond to ORACLE-L
To:Multiple recipients of list
Paule, you have TWO_TASK environment variable set
and dbua is trying to connect to host it cannot find.
Unset TWO_TASK and everything will be OK.
On 12/05/2003 10:54:25 AM, [EMAIL PROTECTED] wrote:
Running dbua to upgrade 8.1.7 to 9.2.0 database produces:
ORA-12545: Connect failed because
Hi John!
When I've run into this problem it was because there was a memory segment
being forced open. If you have the same issue, I can hep. First, assuming
that you're on Unix (if you're not, please ignore the rest of this email and
just have a lovely day), and that your database is down
Thanks Jonathan.
Lack of some decent docs and my inexperience with analytics led
me to the (partition by 1). Someone mentioned that Tom Kyte's book
has a good chapter on them, so I'll go look that up.
You're right, the group by is unnecessary in that query, it's an artifact
of an earlier
In regards to Bambi's comments about having a single instance on the server,
this situation gets more complex if you have several instances on a server.
There's also the possibility that the instance(s) shared memory is in more
than one segment.
You can use ipcs and oradebug to decipher which
I can almost guarantee that the issue will go away if you reboot the machine.
I cannot fathom how would shared memory segments survive reboot.
On 12/05/2003 11:49:24 AM, [EMAIL PROTECTED] wrote:
In regards to Bambi's comments about having a single instance on the
server,
this situation gets
Hmmm, ignore my post. For an unconnected reason we had to reboot the server
and I can start the instance no problems.
-Original Message-
Robertson Lee - lerobe
Sent: 05 December 2003 14:30
To: Multiple recipients of list ORACLE-L
Hi
Oracle 9.2.0.3
AIX 5L
anyone fail to start an
Hi,
I have a apps 11.0 table that we have been importing with no problem but
when we upgraded to apps 11.i the import takes 10 times as long. Upon
inspection I found two of the columns have been converted to LOBS. I found
a few articles on metalinks that referenced the slow import of LOBS but
also
'sysresv' will show which shared memory segments
and
semaphore sets belong to an instance.
Matt Adams - GE Appliances -
[EMAIL PROTECTED]Their fundamental design flaws are
completelyhidden by their superficial design
flaws. - Douglas
Adams
-Original Message-From:
database 8.1.7.2 Solaris 64 bit
exp 9.2.0.1/8.1.7
same user, same database, schema export, same command line options
exp user/[EMAIL PROTECTED] compress=n rows=y file=export.dmp log=log.txt
8.1.7 exports fine. 9.2.0.1 gives an ORA 942.
OK so what am i missing here? which FM do i RT? i
I had a similar question a while back. Specifically my question was,
is it faster to join on a numeric-based index or a varchar(2) based index.
After much research, and a discussion with an Oracle PT friend of mine,
the answer was/is: It depends. There is no right answer; your results
will vary
Bill, why are you trying to export an 8i database with 9i exp?
The export views are different, it shouldn't be expected to work.
I don't believe there is any equivalent of catexp7 for 8i/9i.
Jared
On Fri, 2003-12-05 at 09:29, Thater, William wrote:
database 8.1.7.2 Solaris 64 bit
exp
Title: Message
Just
to add to the list
Tru64/Trucluster 5.1b - 9.2.0.4 rac
from
v$pga_target_advice_histogram *ERROR at line
11:ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set],
[], [],[], [], [], [], []
-Original Message-From:
[EMAIL PROTECTED]
Rebooting is not always an option.
On Fri, 2003-12-05 at 09:04, Mladen Gogala wrote:
I can almost guarantee that the issue will go away if you reboot the machine.
I cannot fathom how would shared memory segments survive reboot.
On 12/05/2003 11:49:24 AM, [EMAIL PROTECTED] wrote:
In regards
No, but in this case, it's exactly what they did. Good, old ctrlaltdel
saved the day. I just thought I might suggest it. After all, they did
have an oracle version of BSOD.
On 12/05/2003 12:59:25 PM, Jared Still wrote:
Rebooting is not always an option.
On Fri, 2003-12-05 at 09:04, Mladen
Jared Still scribbled on the wall in glitter crayon:
Bill, why are you trying to export an 8i database with 9i exp?
because i thought i read somewhere that it would work. maybe i'm confusing
it with imp? will 9i imp read an 81 exp file?
it's either that, or i've experienced an ORA 99 -
Usual rule of thumb - export using the oldest RDBMS version in the transfer, import
using the imp for the database to which you are importing. So export with your 8.1.7
version of exp, and if you are moving to 9.2 import with the 9.2 version of imp.
-Original Message-
Sent: Friday,
9i imp handles 8i dmp files. 9i exp does not like to connect to 8i databases though.
At least that has been my experience migrating one of our 3rd party DBs.
John P Weatherman
Oracle Database Administrator
Replacements, Ltd.
-Original Message-
Sent: Friday, December 05, 2003 1:34 PM
ahhh shouldn't you use the exp from 9.2 for 9.2 and the exp for 8.1.7 for
8.1.7...??
-Original Message-
Sent: Friday, December 05, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L
database 8.1.7.2 Solaris 64 bit
exp 9.2.0.1/8.1.7
same user, same database, schema export, same
What's the CACHE and LOGGING values for these LOBs (from dba_lobs view).
If you have NOCACHE LOBs, then import has to write these immediately to disk
using direct writes (and to redologs, depending on LOGGING setting). When
you have CACHE LOBs, these don't have to be written to datafiles
We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on
windows. I also have development responsibilities, so I dont have time for a
checklist.
you need to automate tasks. You cant spend your time reading the alert log. you should
poll it and get an email when
Well said, Ryan!
I have about the same number of instances, all on Sun. Development
responsibilities also. One DBA. Time off is difficult.
Excellent advice on emailing results. I have found the tools cause you
about as much maintenance as they might save, so I favor simple scripts with
emailed
So your approach is to write a series of custom scripts, add them to (I
assume) oracle's crontab for periodic execution. Do you have one single
machine (or pair of machines) that monitor remote databases? Or do you
install these scripts on each database server? Do you leverage dbms_jobs?
Dear List,
We have TXN processing system with as many as 900 users log
in at any point of time. We have the necessity to find what OS type the client
is using (Windows 95, NT 2000 etc). I tried thru V$SESSION,
V$SESSION_CONNECT_INFO and V$PROCESS, but couldn't find any useful info
to
When exporting, use native (8.1) Export utility.
When importing into 9.2 native Import utility (9.2) will perfectly well
read 8.1 export files.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Thater, William
Sent: Friday, December 05, 2003 1:34 PM
To: Multiple recipients of
Hi...
I have Oracle 9.2
DBA Studio comes embedded with the Management Console.
Just conect to your Management Console and that's all.
Regards.
HTH
JL
--- Prem Khanna J [EMAIL PROTECTED] wrote:
Bahar , i think it's only OEM with 9iR2.
... and perhaps u have everything there .
Regards,
When I had only one instance to baby sit doing the script thing was OK, but it also
missed things like the listener not being up and lost of other problems. Besides it
was a pain to add it to each new server as they came along. Therefore I re-wrote
those scripts into one C language program
At 01:14 PM 12/4/2003, you wrote:
Hi Justin
Didn't know you were on the list
I'm usually about a week behind, so I don't get to participate very
often...
A properly formed hint will
cause the CBO to consider the
hinted path to be
less costly than it would otherwise consider it, but hints
Tanel,
I think you're saying a query almost always runs faster right after the index
rebuild and there's no point in finding the criterion whether to rebuild an
index. (What is 42?)
Some time ago I posted a message somewhere else showing a case where rebuilding
or coalescing an index may be
Man...
it's just a bit difficult to find that you want only
in Oracle...
but can try this:
1.- There is an utility on Windows 2000 Resource Kit
called: gettype.exe, it can help you to determine your
OS Type (it works with the errorlevel), you need to be
logged in your domain to make this works,
Adam --
I've done this more times than I can count. The answer is it depends on
your environment, your desired results, and, more often than not, your
corporate structure. Here's some examples:
1) Monitoring script pages DBA group if X happens, Unix group if Y happens,
Network group if Z
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 05, 2003 2:44 PM
So your approach is to write a series of custom scripts, add them to (I
assume) oracle's crontab for periodic execution. Do you have one single
machine (or pair of
one more point. Sorry for all the emails. I found that when writing scripts
for monitoring you really should follow an abstraction philosohpy similiar
to what you see in Object Oriented programming. Write utility scripts, use
data files, then have utility scripts that 'echo' out data from them
i think instead of doing lists myself, I say Can I teach this guy how to do
it and is he willing to learn. If he is willing to learn its great,
if not, its a pain. Learning DBA skills is very advantage to any developers
career, so if their smart they will want to learn. The key is to not give
them
Dear All
My application uses connection pooling. I do not want
to end a connection con.close() because this will
end the connection from db but just want to release
the connection. In my app , i specify
releaseconnection . But how come all the cursor still
open when i query this :
select
Ryan, have you tried PDBA toolkit? The address is:
http://www.oreilly.com/catalog/oracleperl/pdbatoolkit/
This toolkit has a plethora of very useful scripts. I seem to
recollect an ugly looking O'Reilly book with moth on an orange
overtone cover, which does a very good job on documenting it.
The
Hi.
tar already opened - awaiting feedback.
W2K Adv Svr Sp4
Oracle 9i R2 Std Ed 9.2.0.4
NTFS 5.0 filesystem
Dell 2650, PERC3/Di controller, writeback caching enabled
qa database, not a huge deal at the moment.
I have a backup controlfile, but would rather not open resetlogs, as there is a remote
Bill,
There are several bugs out there in exp.exe land.
my current favorite is the ORA-00907 that shows up when importing (8.1.7.4 - just hit this one again last night).
my second favorite is the ORA-00942 that appears when exporting (9.2.0.3 - fixed in 9.2.0.4).
neither of these seem to be what
Actually TWO_TASK is not set - I signed in as oracle user and echoed it. Sooo I
think my hope that finally after the many versions I have migrated - Oracle's
assistant is finally ready to rock - is not correct. Mainly, do not get complete
information running the migration that way. I
Title: Message
I could notget Outlook to prefix your message properly -
grrr. Comments are at the top which may make reading them hard.I have
tried to setup a simple demo that hints are not 'suggestions' sorry if this
becomes long - this is all 9.2 but should apply to 8i and later versions
I guess the impetus here is my Occamian approach to technology problems. I
abstract to the point of maximum flexibility with minimal complexity,
which often also requires maximum time and effort. Reality of course
dictates that a solution that ends up in common ground.
So it's not that I'm
Adam --
Generally, my approach is X *and* Y *and* Z, and I have found that maximum
flexibility with a decent level of functionality will be of at least
moderate complexity.
And I have never seen Occam's name turned into an adjective like that. Is
that standard?
Bambi.
-Original
Title: Message
Goal: To restore the database
from RMAN backup on a different server by means of moving the backup pieces and
logs over to the new machine and use Rman to unpack the database
files.
Strategy: To restore the
database from the RMAN backup pieces into a new directory locations
Jacinta - What language is the app written in? Java? How are you doing
connection pooling? With Oracle?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, December 05, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
Dear All
My application
Brian - First, congratulations on performing what seems pretty close to a
disaster recovery test. I don't know the specific answer to your problem, so
I'll ask a couple of questions related to hard points I encountered, and
maybe that will strike a cord.
1. You say you connected to your
We just had a major issue with a
materialized view (aka snapshot) job running for over two months without end.
This actually caused a loss of revenue for
our company, as this job generated data which reported customer service usage.
I can remember an old 8.1.5 but where an
network
Perhaps it should have said Occam's razorian ;)
Bellow, Bambi [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/05/2003 01:59 PM
Please respond to
[EMAIL PROTECTED]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
RE: Database management techniques and frameworks
How did you expect the restore to work w/o first restoring the
controlfile? or am i missing something here?
joe
Spears, Brian wrote:
*Goal:* To restore the database from RMAN backup on a different
server by means of moving the backup pieces and logs over to the new
machine and use Rman to
Title: Message
By default RMAN restores the backup to the
machine from where it is backedup. If you need to restore the backup on to
alternate client, your netbackup admin has to setup the access. You have not mentioned
whether you are using Netbackup or legato or something else. Once the
Title: Message
I am sorry, I thought you are restoring
from Tape. In either case, you connect to target and catalog database on the
new server and see if you can access the backups that were backed up on the
original server.
-- Janardhana
-Original Message-
From: Spears,
Title: Message
May be you try the following:
If you get errors restoring controlfile, You
may ftp the controlfiles manually to the new server and startup mount the
database first. Then, Try your restore database.
-- Janardhana
-Original Message-
From: Spears, Brian
Janardhana - That's a good point.
Brian - were you expecting RMAN to extract your controlfile from the RMAN
backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in
8i. I couldn't get that to work myself.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
It's on www.baarf.com and there are some pretty good articles there.
Best regards,
Mogens
[EMAIL PROTECTED] wrote:
anyone got the articles about why raid 5 is bad for databases?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
Good stuff. Thanks.
So what you're saying below is this:
Before: 2 16-cpu Sun's: $600K for HW and OS plus 32 x $40K for Oracle,
ie a total of $1.680K? Is that correct?
After: 5 4-cpu Intel boxes: $100K for HW and OS plus 20 x $60K for
Oracle, ie a total of 1.300K?
What confuses me, I think,
89 matches
Mail list logo