Even with W2k, I would still go talk to the network folks.
Look this up on MetaLink, that's where I found it.
Jared
On Sunday 26 January 2003 22:28, Walid Alkaakati wrote:
> Hi Jared,
>
>
> No the server is running on windows 2000,and this error is too annoying
> every three days approximatlly
If that were the case, he would not have seen 88640 rows
from sqlplus, as he reported.
Jared
On Monday 27 January 2003 16:43, Tim Gorman wrote:
> Case of the Missing RowsMy guess is that SQL*Loader didn't really load
> 88,640 rows, but rejected or discarded about 1400 of them?
>
> - Origi
Yes, but you would be required to rebuild the entire database
via export. Oracle will not support a database opened with
_allow_resetlogs_corruption for anything other than export.
Jared
On Monday 27 January 2003 17:43, Sujatha Madan wrote:
> Ok... I have the tapes now so I don't have to bother
Sujatha,
There is never, ever, ever, ever, a perfect time to use
_allow_resetlogs_corruption.
Never ever. The results of such an operation may not be known for hours,
days or weeks.
Look which datafile it is that needs recovery, system01.dbf... which means
that if you
force open the database you c
Title: Case of the Missing Rows
I
think so too, perhpas you want to include the bad record to capture those
bad records
make
the nesassary changes then load that bad file
repeat
until all loaded into your db
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: 28
Hi,
shared memory realm does not exist
This must be your /etc/system semaphores setting incomplete.
Your oracle is not there yet
No such file or directory
This must be your environment not set properly
your
$ORACLE_HOME
library
may be also your system administrator don't like you.
Sinardy
The last time I went through the documentation from Oracle on doing an
upgrade. Planning for one of my 8.1.6.3 to be upgraded to 8.1.7 the
installation manual and Metalink's articles on upgrading specifically called
for the migration to be done (for all instances that were to be migrated)
first, th
If you use _allow_resetlogs_corruption, I believe that Oracle support
will require you to rebuild the entire database if you wish to have
support in the future. See MetaLink Doc 166181.1 for that.
They will not support your database for anything other than an export
used to rebuild the database.
Ok... I have the tapes now so I don't have to bother...but would this
scenario have been fixed by using the _allow_resetlogs_corruption parameter
and following the associated steps
Sorry for the bother
Sujatha
-Original Message-
Sent: Tuesday, 28 January 2003 11:14 AM
To: Multiple
Title: Case of the Missing Rows
My guess is that SQL*Loader didn't really load
88,640 rows, but rejected or discarded about 1400 of them?
- Original Message -
From:
Weiss, Rick
To: Multiple recipients of list ORACLE-L
Sent: Monday, January 27, 2003 4:53
PM
Su
Connor McDonald,
Hi, for IO balance , I think in most case, we put datafiles on raid so
it is not a problem? Or you can use multiple datafiles, which will give you solution
when no raid or multiple raid is used and you want to balance io?
I used AUM too in my rac s
Hi,
DB: 8.1.5.0.0
O/S: Solaris 2.7
This database is the recovery catalog database. It is in noarchivelog mode
and is backed up cold.
Unfortunately, something happened on Thursday and the database does not
startup. I receive the following errors:
SQL> startup
ORACLE instance started.
Total Syste
DBWR_IO_SLAVES > 0. This is a bad thing. The IO slaves functionality
really stinks and the alternative of DB_WRITER_PROCESSES > 1 is a much
better mechanism, especially from 8i onwards. Both mechanisms are Oracle's
own version of asynchronous I/O; is that enabled? If so, you might not
need eit
Smith, Ron L.,
hi, did you set up db_io_slave process? check metalink note about
db_io_slaves:)
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)
=== 2003-01-27 14:33:00 ,you wrote£º===
>I just notice these ora_ixxx_sid pro
Title: Case of the Missing Rows
I have a recurring, repeatable problem I was wondering about its cause.
Oracle 9.2.0.1 on W2K Professional (SP2) Dell Optiplex workstation Pentium 4
Step 1 - I do an SQLLDR process that loads 88640 rows to a table
Step 2 - SQL*Plus session - SELEC COUNT(*) f
Maybe I'm just a cynic but I view AUM as being akin
the SAME disk layout policy. That is, (and this is
subjective figures) it gives 90% optimal performance
in about 90% of databases out there.
Since going to aum on a "significant" (read:
reasonable number of users and workload) database I
used to
Hi,
These are dbwr_io_slaves processes. Search in 'Metalink' (or Manuals) to learn more about these processes.Regards,
Quamrul
From: "Smith, Ron L." <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Strange processes showing up
In case anyone cares--it looks like it is *not* possible to set a role in an
after logon trigger. Had I only looked at metalink:
AFTER LOGON Triggers Don't Allow DBMS_SESSION.SET_ROLE to Keep Roles Enabled
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOT&p_i
I just notice these ora_ixxx_sid processes on my server. Does anyone have
an idea what they are? They didn't used to be there.
oracle 18249 1 0 16:07:35 ?0:00 ora_i106_cdwprd
oracle 10664 1 0 15:36:38 ?0:00 ora_snp3_cdwprd
oracle 10650 1 0 15:36:37 ?0
I’ve been reading the 9iR2 docs on partitioning, along with Tom Kyte’s
excellent chapter on the subject. It
seems that a Global index or unique, local indexes could be used effectively in
an OLTP system, but both have their caveats.
This is a hybrid system- it’s part OLTP but is also u
Chaim - I agree with your note, but isn't that basic replication? Robert
asked about advanced (multimaster) replication.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 2:12 PM
To: Multiple recipi
Thanks!
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 2:12 PM
To: M
It's basically a Microsoft version of Cygwin. I like
possibility of using NIS authentication. That would be
really helpful.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 27, 2003 12:50 PM
> To: Multiple recipients of list ORACLE-L
> Subj
from metalink note: 28018.1
5.14 Symmetric Replication
---
The stats output for your sql shows no physical reads.
This means either the whole table is cached or simply since you ran the test
many times you got all the blocks you're interested in cached.
Since all the needed blocks are cached, I do not think fetching the rows
using the rowid would be any
Jared,
I needed that, LOL!!!
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 1/27/2003 9:49 AM
.. for Unix Services. :)
http://www.linuxworldexpo.com/linuxworldny03/V33/press.cvn?id=11&p_id=12
--
Please see the official ORACLE-
See
http://www.puschitz.com/OracleOnLinux.shtml
http://otn.oracle.com/tech/linux/pdf/installtips_final.pdf
Chris
-Original Message-
Sent: Monday, 27 January 2003 6:59 p.m.
To: Multiple recipients of list ORACLE-L
hi all,
I need your help, because I had try to install oracle 9.2.0 on re
Any of you Oracle history buffs remember what version of Oracle that
advanced replication was first available in?
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Ama
I have a java question so I figured I'd tap into some of the non-Oracle
expertise on this list. I'm doing a PeopleSoft install (basically setup.aix
calls a setup.jar file). This worked on one AIX (4.3.3) box, but is dying
(with no useful error messages or log files) on another box. Checking the
jav
Thanks,
Thanks for this information. I am more understanding of
the underlying causes for what was going on now.
I was the one that probably caused you to misinterpret
the what my real issue was. Sorry for that.
I am swamped here and have to brief. Thank You for
your time.
I enjoy refer
Jonathan Lewis,
You are really oracle expert!Can you interpret more about this
statistics? And how did you think about this statistics that is seldom used?
The following is the test result:
--sql1:
00:00:
The "ora817" have goup "oinstall" setup.
From: "Tim Gorman" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: [Q] create seperate DBA account on 8.1.7 but does NOT work?
Date: Mon, 27 Jan 2003 09:18:57 -0800
Aye, it is
There is no fixed cost for a logical I/O. The cost of a LIO will change
depending on many factors.
Anjo.
On Monday 27 January 2003 06:59, chao_ping wrote:
> hi, friends:
> I hit some strange performance problem on my 9.2.0.2 on redhat linux.
> I want to show developer/manager why
.. for Unix Services. :)
http://www.linuxworldexpo.com/linuxworldny03/V33/press.cvn?id=11&p_id=12
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Very possible to do. It's a bit involved but it is documented in my
Oracle9i RMAN Backup and Recovery book and it will work for 8i.
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books y
Tim - Good catch, and on a Monday yet!
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 27, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L
Aye, it is there, but look at the ownership...
You were able to operate under the "o
This guy gets around, doesn't he?
You would think someone would have something
better to do with their time
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amaz
Ok, thanks for the test. you've right.
- Original Message -
From:
Tim Gorman
To: Multiple recipients of list ORACLE-L
Sent: Monday, January 27, 2003 5:13
PM
Subject: Re: Slow running query
Looks to me like that hurts more than it
helps...
SQL> declar
Title: Message
Nobody
can. As with just about anything, it will depend on what size the app will be,
what the access pattern will be, and how available it has to
be.
-Original Message-From: Amos KABORE
[mailto:[EMAIL PROTECTED]] Sent: Saturday, January 25, 2003 9:04
AMTo:
When you bring up a database, a combination of the
ORACLE_SID and ORACLE_HOME environment variables are
hashed to a key and stored in memory. When you
attempt to connect to the database, this hash key is
verified.
Therefore your current environment for ORACLE_SID and
ORACLE_HOME must match EXACTL
Tim,
As you
said, a count(column_name) has to query the table (if there is no index on the
column) to see if the column is populated. only non-null columns are
counted. if an index exists on that column, then all entries of the index
are counted.
a
count (*) will simply count the PK e
Title: Message
In
many cases, if you create a CSV file (comma-delimited) Excel will execute and
read it properly. Excel generally sets itself as the default editor for .csv
files.
I
don't know of any way to do this for Access.
-Original Message-From: Boivin, Patrice
J [mai
Title: RE: OEM 4
As
long as it's not Bartok.
Pat.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 27, 2003
12:49 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: OEM 4
And there will be one patch to match each of the orig
We are using AUM on all databases(9014). Works
great and we manipulate retention time as needed. Had one encounter with
flashback query when got a call in lunch hour that someone updated wrong data in
production. Flashback worked like a charm and data was restored within 15
minutes.
-Shale
Aye, it is there, but look at the ownership...
You were able to operate under the "oracle" account because it owns the
executable, but now under "ora817" you are neither owner nor part of the
"oinstall" group.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECT
Thanks. I notice you've got the sticky bit set, which is what you want.
However, you mentioned that you were using the "dba" group, yet I notice
your binary's group is "oinstall". You might change that group, bounce your
instance and see if that fixes the problem.
Other than that, I couldn't fol
Looks to me like that hurts more than it
helps...
SQL> declare
2
v_cnt
number; 3 begin
4 for i in 1..1
loop
5
select count(*) into v_cnt from x$dual;
6 end loop;
7 end; 8 /
PL/SQL procedure
Repeat the tests, but take a snapshot of v$sesstat
for the session on each test. I would guess that you
will find that there is a more than balancing difference
in the statistic "buffer is pinned count" which also
records accesses to buffered block, but uses a
different buffer access mechanism.
I've never used it, but Oracle Reports server (part of 9iAS) is supposed to
have caching functionality, where you can defne a completed report to be
cached for a period of time. Such cached reports are identfiied by report
name and parameter values...
- Original Message -
To: "Multiple re
Dan,
We are using AUM on ALL our PROD/DEVL/TEST environments, no problems so
far. Haven't used much of flashback though ... Are you looking for anything
specific? The DB versions are 9012 and 9202 ...
Raj
__
Rajendra
Jamadagni
Title: RE: OEM 4
And there will be one patch to match each of the original Mozart Symphonies too ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and do
it is their.
%ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle oinstall 34260904 Dec 26 2001
/home/app/ora817/product/8.1.7/bin/oracle
From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: [Q] cr
It works here for both 9iAS R1 & R2!
"Amos KABORE"
Getting slightly off-topic now, I never said ls's output wasn't
POSIX-compliant. I stated that the output itself is inconsistent, similar
to the output generated from grep'ing one file versus several files. And
this is highly undesirable in shells that rely on the output of one program
to be the
Djordje,
Thanks for the information. I'll have to correct my statements about the
Oracle9i Epoch. If the values you listed below were microsecond times
that used 1/1/70 as the Epoch, then these numbers would represent times
in February 1970:
Your data:
21/01/2003 22:46:50 4655566135078
22/01/20
It's an in memory database. I have evaluated it a little bit.
Dependes on what you are trying to do, it might be useful in some
situations.
-Original Message-
Sent: Monday, January 27, 2003 5:54 AM
To: Multiple recipients of list ORACLE-L
Has anyone heard of or used a product called Tim
dist cash
Do an "ls -l" on $ORACLE_HOME/bin/oracle.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 27, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L
we plan to upgrade ORACLE 8.1.7 to 9.2 on SUN Solaris server. I plan
We are using automatic undo management (version
9.2) - no problems so far.
Not using flashback query - so, no opinion on
that.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Fink, Dan
To: Multiple recipients of list ORACLE-L
Sent: Monday, Jan
we plan to upgrade ORACLE 8.1.7 to 9.2 on SUN Solaris server. I plan to
upgade to 9.2 use "oracle" account and keep 8.1.7 on "ora817" account. I
create user "ora817" and assign it to "dba" group. I also setup ORACLE
environment similiar to "oracle" account. I tried to startup
"sqlplus" but fa
first thing to do, try to use count(a_column_name) instead of count(*)
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 27, 2003 2:29 PM
> First thought,
>
> Count(*) and FIRST_ROWS are self contradictory. If you want to count a
Is F1.AMTLICHESKENNZEICHEN indexed as this seems to be the main filter?
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 27 January 2003 13:04
To: Multiple recipients of list ORACLE-L
Hi List:
I have the below query which is taking 5 min. 20 sec. to fetch the
records.
As far as having the 32blt client, just create a new home for it. You can use
another SID for the /etc/oratab file so that oraenv/coraenv works as it should.
Now as far as this application owner having to shutdown & restart the instance,
well that is just a pile of BULL. I haven't found the appl
Ranganath,
Is the OR NOT EXISTS
(SELECT /*+INDEX_FFS(HISTORIE, I_MYTECHOBJEKT) */ ZPAB.FAHRZEUG.OID
FROM ZPAB.FAHRZEUG,ZPAB.HISTORIE
WHERE ZPAB.FAHRZEUG.OID = ZPAB.HISTORIE.MYTECHOBJEKT and
ZPAB.FAHRZEUG.oid=F1.oid)
not just wishing to
hi, friends:
I hit some strange performance problem on my 9.2.0.2 on redhat linux.
I want to show developer/manager why delete data for archiving history data is
not a good idear, and I did a test:
There is some big table in our app, and currently we use cron to delete ro
This is more of a
survey than a question about problems.
For those of you
using automatic undo management, what have been your experiences, both good and
bad. Are you also using flashback query and what are your
experiences?
Thank you for all
the responses,
Dan
Fink
Patch first then upgrade.
Dick Goulet
[EMAIL PROTECTED] wrote on 1/25/03 8:38 pm:
Im doing an upgrade from 8.1.6. to 8.1.7.4. Is there any benfit of doing the
upgrade from 8.1.6 to 8.1.7, using ODMA then patching to 8.1.7.4
or
installing 8.1.7, patch it to 8.1.7.4, then ODMA the database from
Patrice,
Use the utility Tom Kyte has on his site called 'owa_sylk'. It will generate
SLK files that Excel opens automatically. We use it for lots of end user
reports.
See the following link:
http://asktom.oracle.com/pls/ask/f?p=4950:8:1962318::NO::F4950_P8_DISPLAYID,
F4950_P8_CRITERIA:76942
hi all
I just want to know if Oracle 9iAS can connect
to Oracle 7.3.4.
If yes, is it recommended ?
thanks in advance.
Amos K
Access path would be helpfull. Alternatively, you can publish
password for the user "SYSTEM", hostname, port and SID so that
we can help you over the internet.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 8:04 AM
To: Multiple recipients of list ORACLE-L
First thought,
Count(*) and FIRST_ROWS are self contradictory. If you want to count all the
records, how will first_rows help?
Regards
Naveen
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 6:34 PM
To: Multiple recipients of list ORACLE-L
Hi List:
Save flat file output with column delimiters \tab as .csv
and Excel will it open by default.
JP
On Monday 27 January 2003 13:28, you wrote:
> I would like the ability to create a file which, when double-clicked upon,
> will open in Access or Excel automatically.
>
> (I know that Access can import
Title: Checklist - Ken Janusz??
Lisa:
Here you go. It's located on Thomas Cox's web
site. The latest release is 1.5 generic.
http://www.geocities.com/tbcox23/
Ken Janusz, CPIM
- Original Message -
From:
Koivu, Lisa
To: Multiple recipients of list ORACLE-L
Sent:
Title: RE: Producing .mdb output from sqlplus or SQL or PL/SQL
Patrice,
You
can certainly spool a file that Excel will open automatically. Simply
create a tab-delimited output file, and make sure the extension is .xls .
Excel will open it and automatically have everything in the correct
Hi List:
I have the below query which is taking 5 min. 20 sec. to fetch the
records. Can you please let me know as to how do I reduce the responste
time?I have created indexes on Fahrzeug.FZGBRIEF and
Historie.mytechobjekt and also the Oid column is uniquely indexed. I
repla
Yes, RMAN is included with 9i and YES the OEM console uses rman.
John
[EMAIL PROTECTED] wrote:
It's already done, but error message isn't disappears. More question please,
Does back up via Oracle Management Console is equivalent with RMAN ? Is RMAN
include in Oracle 9i ?
Rgrds,
Sony
Title: RE: Producing .mdb output from sqlplus or SQL or PL/SQL
I
would like the ability to create a file which, when double-clicked upon, will
open in Access or Excel automatically.
(I
know that Access can import other formats, I just want it to be automatic for
users who don't know / don'
Title: RE: Producing .mdb output from sqlplus or SQL or PL/SQL
Thank
you.
Pat.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 24, 2003
5:34 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Producing .mdb output from sqlplu
Has anyone heard of or used a product called TimesTen ? It's a mid-tier
cache tool. Would it be a worthwhile thing to use with Oracle, or does
Oracle already have the same features built in?
Thanks,
Maria
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Maria Quinn
IN
It was actually released at Oracle World recently, and has a short paragraph
on page 11 of Oracle Magazine.
You can find the release here:
http://www.oracle.com/features/ow02/index.html?_ow_oem.html
And the new product page is already up here, with a few streaming demos:
http://www.oracle.c
Title: Error extensions in the alrtXXX.log
Thanks
for your input.
-Original Message-From: Robert Freeman
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 24, 2003
3:12 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Error extensions in the alrtXXX.log
Look
in
Hi
Thanks to all who help me.
We install Oracle 8.1.7 and the query tooks 50 seconds only !!!
(30 min. in 9.2)
I will post more...
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Tim Gorman
Enviado el: miércoles, 22 de enero de 2003 14:39
Para: Multip
81 matches
Mail list logo