Hello Mike
We are working on using LDAP to store global userid and connect to Oracle
using the correct user name without having to define 1000's of user in each
database.
I talked this morning with a technical person in Oracle and she told me that
LDAP can use AD to check the password (if this is
Guys,
I need a parse alert log and mail me if there is any error.
Hope u guys would have some script for the same.
i have 8i and 9i instances spread across windows 2000 network.
even if u guys have script for unix,just pass it on to me.
let me modify and try it.
Thanks and Regards,
Jp.
--
sorry guys...there was some TYPO in my previous mail.
I need to parse alert log and mail me if there is any error.
Hope u guys would have some script for the same.
i have 8i and 9i instances spread across windows 2000 network.
even if u guys have script for unix,just pass it on to me.
let me
This was posted by David Hill on 21/3/3. Hope it helps
John
Here a fast little script I wrote that can be ran every minute
Emails only when it finds a new message
And pages if it finds a new message between 6pm and 5am
FPATH=/prod/dba/scr
autoload f_xmail
logfile=/prod/dba/logs/`cat
Try this (Solaris):
(B
(Bgrep ^ 'alert.txt' /usr/ucb/mail -s "ALERT - " fred
(B'alert.txt'
(B
(BThe file 'alert.txt' is a spool file generated from an Oracle SQL script.
(BIf a non-null result arises, an alert condition exists, therefore (with
(Bheading turned on of course) there
I need a parse alert log and mail me if there is any error.
I know Mogens (pronounced moans) and the guys at Miracle are working on GAPALPART
(Generic All-Powerful Alert Log Parser And Reporting Tool). That could be something
that you could use. I also know of a tool called MONO which is
Check out the Canadian results...
http://www.payscale.com/salary-survey/aid-10747/raname-SALARY/fid-7031/
I have never been able to figure this out, salaries are typically lower in
Canada than in the U.S., for no apparent reason that I can think of.
Patrice.
-Original Message-
Sent:
How can I found a trial version of erwin
Danke...
Arslan.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
Phil,
At first thought -- where does Windows build the trace file before it
plunks it into the destination directory for that file.
Could it be in TEMP? If yes, exclude TEMP as well.
Any change when you excluded all the drives?
NetShield 7 exists now.
Patrice.
-Original Message-
Title: RE: Any Collaboration Suite or 9iAS listservers?
no,
but I notice this morning that OCS v2 is out.
Patrice.
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003
3:50 PMTo: Multiple recipients of list ORACLE-LSubject:
RE:
Title: RE: salary question
If it is in USD, maybe the exchange rate.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need.
~ Jerry
Check out the Canadian results...
I have never been able to figure this out, salaries
are typically lower in
Canada than in the U.S., for no apparent reason
that I can think of.
Patrice.
Might the reason be the total cost to the employer? Differences in the full coverage
of health insurance
Frank,
Now that you've gotten it to work a word of caution. First off, don't expose a
database with en extproc listener to the net directly. Second, don't allow developers
to create generic functions therein. Both of these, alone or in combination, can
allow a hacker to execute rogue
Would like recommendations on the top two
books for building Oracle data warehouses.
TIA,
Ken Janusz,
CPIM
The problem was explained clearly but the context in which it had to
be used was obscure. Rajendra Jamadagni had suggested a solution
using functions which could be called from SQL and you had
mentioned that it could NOT be used in a CURSOR (!). The 'simplest'
way to calculate the financial
hello:
The below has info about the product:
http://www3.ca.com/Solutions/Product.asp?ID=260
The below has the download link:
http://www3.ca.com/Solutions/Collateral.asp?CID=33655ID=260
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
I wonder if some of the social/ecconomic differences (such as socilized
medicine) make some of the difference.
Also, Canadians are a more irritable bunch, so to preserve this nature they
are probably paid less. If you paid them more you'd have a happy Canadian
and then they wouldn't know what to
Amazingly enough, I attended the Oracle class 'Managing Oracle on Linux'
in May and they went over this is some detail. Even though I had
installed Oracle on Linux several times (SuSE and Red Hat flavors), I
attended the class in hopes of picking up some tips. I was not
disappointed.
The beer is cheaper in Canada...
-Original Message-
Sent: Monday, July 07, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L
Check out the Canadian results...
http://www.payscale.com/salary-survey/aid-10747/raname-SALARY/fid-7031/
Hei all,
My database is Oracle 801 running on windowsNT with
NOARCHIVELOG mode. I got the memory problem and it has
been end with one of RBS datafile currption. The DB
does not allowed me either drop the datafile or
tablespace. So what i have done the following steps.
1)created control file
Thanks Patrice,
I've check for the Montreal city and by experience, I find the average a
little lower than what I would expect. On the other side, the difference
between the lowest and highest salary is huge.
Also, this is for all DBA (sql server included... I suppose that cheaper
product =
I just started getting hundreds of the following messages:
/ora_archive/ptxor01/arch_log/ptxor01_1_17484.arc: -- file unchanged
It appears to only come from a failed attempt to compress an archive log
which is
-rw-r- 1 oracle dba 104858112 Jul 3 04:07 ptxor01_1_17484.arc
over
I see, thanks for the info.
-Original Message-
Sent: Thursday, July 03, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L
Richard,
I'm not totally sure, but the one site that I saw that tried it got a memory
error, memory cannot be written, when they started it.
Dick
So THAT'S where that is! I've been wondering why my K scripts don't run.
But, after talking with a co-worker, wouldn't it be better to just touch
/var/lock/subsys/oracle in the startup and conditionally remove it (using
-f) in the stop of the oracle script in /etc/init.d ? That way, you won't
be
we don't have watered down beer though, so we really get our money's worth!
I don't drink alcohol much though, I fall asleep when I do.
Pat.
-Original Message-
Sent: Monday, July 07, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L
The beer is cheaper in Canada...
-Original
Burke, William F (Bill) wrote:
I just started getting hundreds of the following messages:
/ora_archive/ptxor01/arch_log/ptxor01_1_17484.arc: -- file unchanged
It appears to only come from a failed attempt to compress an archive log
which is
-rw-r- 1 oracle dba 104858112
Title: RE: ORA-00600: internal error code, arguments: [19944], [], [], [], [], [], [], []
Your solution is described in details here ... http://tinyurl.com/g8eu
HTH
Raj
Rajendra dot Jamadagni at nospamespn dot
20030707 10:45:17
SYS DBMS_SHARED_POOL VALID 20030704 16:36:26
SYS DBMS_SHARED_POOL VALID 20030704 16:36:14
SYS DBMS_STATS VALID 20030704 18:14:02
SYS DBMS_UTILITY VALID
If it's not a prod. Database which it doesn't seem to be and you can bear the loss of
one week's data. Use the create controlfile, create a new controlfile and open the
database with resetlogs.
Thanks,
Inder
-Original Message-
Sent: Monday, July 07, 2003 11:59 AM
To: Multiple
Hi!!
What is the better why toreturn resultsets from Oracle
to Visual Basic?
healthcare is largely paid by the government in Canada... not paid by
employers. Provincial governments pay physicians fee for service (mostly,
some exceptions exist) and hospitals / facilities are paid by government,
not by patients directly.
Healthcare is mostly free to Canadians, and total $
Henry,
These locks should normally occur when dependent objects needs to be
compiled (internally by the kernel or externally by scripts) on account of
invalidations. This problem is magnified in large ERP packages which
exhibits lots of dependencies and objects. Since you mention that this is
Tanel,
Thanks for elaborate information , I really liked
it . Still why do u need to provide db name in tnsnames, all one should know is
which instance to connect . Instance know , which db to connect .
why do net8 bother about dbname ?
-ak
- Original Message -
From:
Tanel
Hi,
I created a unique index on a table called REGISTRATION_K, but no unique
constraint. Last week when the application tried to insert a record into
the table, we got following error in the log file:
Oracle::st execute failed: ORA-1: unique constraint (REGISTRATION_K)
violated
However,
use gzip and see. Much better than compress. I never observed any problem.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Mon, 07 Jul 2003 05:49:26 -0800
I just started getting hundreds of the following messages:
Title: Message
Due to
budget constraints, we shutdown last week, and everyone who works here was given
four days off without pay. This was done instead of laying people
off. It was a great vacation, and the family will need to eat beans for a
few days. Anyway, I was just catching up on my
You can try this script and see if it works for your situation. We had an
elusive problem like this that we were able to gain more information about
using this query:
-- FILE: libcache_lock.sql
--
-- AUTHOR: Andy Rivenes
--
-- DATE: 01/22/2003
--
-- DESCRIPTION:
-- Query to
Thank you.
Surendra
-Original Message-
Sent: Monday, July 07, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L
The problem was explained clearly but the context in which it had to
be used was obscure. Rajendra Jamadagni had suggested a solution
using functions which could be
Anyone care to ballpark a $$$ on the registered version of ERwin? I'm
guessing it's expensive, and Computer ASSociates doesn't exactly trip my
trigger.
I'm trying to find a low-cost ER tool in order to get some simple data
modeling done. So far, this is what I've found (VERY briefly):
1)
I'm new to sqlldr and here is my control file:
LOAD DATA
INFILE '/home/oracle/116.csv'
BADFILE '/home/oracle/116.bad'
DISCARDFILE '/home/oracle/116.rej'
APPEND INTO TABLE LC_F
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(lc_rid,loc,loc_type,loc_size,sku,pkg,lot,uc1,uc2,uc3,zone,area,loc_stt,
AK,
You can make it as simple or complicated as you want.
Personally I prefer the KISS principle. It's easier to troubleshoot when
the fecal matter hits the rotary oscillator.
Dick GouletSenior Oracle DBAOracle Certified 8i DBA
-Original Message-From: AK
[mailto:[EMAIL
Last time we purchased ERWin (a number of years ago in a previous life)
it was around $4k, IIRC.
You might want to check out ER Studio by Embarcadero, although it's not
cheap either.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]
Sent:
Anna,
A unique constraint is a unique index and vice-versa which will explain your
error message. Also, no there will be no duplicate records because you defined the
index as unique. I would doubt your statement about the record being inserted
although the application may have
...when the fecal matter hits the rotary
oscillator.
Politically correct
Stephane Paquette
Administrateur
de bases de donnees
Database
Administrator
Standard
Life
www.standardlife.ca
Tel.
(514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]
-Original
There was a Tool I used in the past, Sdesigner, simple to use. Also if all you need is
an older version of Designer, what you could always do is buy one of the books that
bundle with a copy of developer 2.1 or 6i.
-Original Message-
Sent: Monday, July 07, 2003 1:29 PM
To: Multiple
Stanford is currently contracting with Books24X7 http://library.books24x7.com/home.asp
to provide this service. I'm sure there is a fee, but as the university takes care of
it, I don't know how much.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original
Hi,
I created a unique index on a table called REGISTRATION_K, but no unique
constraint. Last week when the application tried to insert a record into
the table, we got following error in the log file:
Oracle::st execute failed: ORA-1: unique constraint (REGISTRATION_K)
violated
However,
This is awfully difficult to answer in the abstract--particularly so without
knowing which version of vb you're using, or the app or environment
(client/server, ASP).
You're probably better off putting the question to a vb list--I recommend
visbas-l:
The Canadian taxmen take it all away anyway so it doesn't matter what you make :)
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, July 07, 2003 4:54 AM
To: Multiple recipients of list ORACLE-L
Check out the Canadian results...
Agree though earlier versions of Gzip have 2GB problems...
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 7/7/2003 2:19 PM
use gzip and see. Much better than compress. I never observed any
problem.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple
Anna Li wrote:
Hi,
I created a unique index on a table called REGISTRATION_K, but no unique
constraint. Last week when the application tried to insert a record into
the table, we got following error in the log file:
Oracle::st execute failed: ORA-1: unique constraint
The
laughof the day
.
the fecal matter hits the rotary oscillator.
-Original Message-From: Goulet, Dick
[mailto:[EMAIL PROTECTED]Sent: Monday, July 07, 2003 2:00
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
service name, sid ..
AK,
You can make
My explanation would be that the record was NOT inserted successfully into the table.
Proof of that would be that there are no duplicate records in the table.
-Original Message-
From: Anna Li [mailto:[EMAIL PROTECTED]
I created a unique index on a table called REGISTRATION_K,
but
I asked CA a sales rep couple of months ago regarding the pricing for ERwin. If memory
serves me correctly, it was in the neighborhood of 3 to 5k per user license.
Also, I worked briefly with Sybase Power Designer and think it is fairly impressive.
Or maybe it has been incorporated into
Embarcadero ERStudio
--- Jesse, Rich [EMAIL PROTECTED] wrote:
Anyone care to ballpark a $$$ on the registered version of ERwin?
I'm
guessing it's expensive, and Computer ASSociates doesn't exactly trip
my
trigger.
I'm trying to find a low-cost ER tool in order to get some simple
data
That's a good definition of Canada :-(
Stephane
-Original Message-
MacGregor, Ian A.
Sent: Monday, July 07, 2003 4:39 PM
To: Multiple recipients of list ORACLE-L
The Canadian taxmen take it all away anyway so it doesn't matter what you
make :)
Ian MacGregor
Stanford Linear
Hello everyone,
We have an 8.1.7.4 on HP-UX 11.0 OPS database that uses 200mb archive logs
with 3 archive log destinations, the first destination is local to the
machine which is mandatory, the second destination is a filesystem
accessible via nfs which is optional and the third destination is a
Thanks Roy!!
I am alredy subscribed to that list and another more, I will
ask them too.
http://peach.ease.lsoft.com/archives/vbdata-l.html
[EMAIL PROTECTED] 07/07/03 03:24PM This is awfully difficult
to answer in the abstract--particularly so withoutknowing which version of
vb you're using,
You're welcome.
You don't have to provide db_name in tnsnames, it's
instance (init.ora) parameter.
Tanel.
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Monday, July 07, 2003 10:34
PM
Subject: Re: service name, sid ..
Tanel,
Anyone there in oracle land running both 32 bit and 64 bit oracle and
using rman w/legato. I assume i need 64 bit libs for 64 bit oracle and
32 bit libs for 32 bit oracle of the legato software?, the unix admin
says legato wont install the 64 bit since it says its already installed.
Any
Robert,
Fortunately I never tried gzip on any greater than 2GB. I am using it since
1999.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Mon, 07 Jul 2003 12:49:24 -0800
Agree though earlier versions of Gzip have 2GB problems...
RF
Naw, Just trying to get through all of the e-mail
filters.
Dick GouletSenior Oracle DBAOracle Certified 8i DBA
-Original Message-From: Stephane Paquette
[mailto:[EMAIL PROTECTED]Sent: Monday, July 07, 2003
5:14 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: service name,
Hi All
We have a process that is trying to create a huge
flat file for a marketing export on a windows 2000 server host, and the file
size seems to be constraining us. If I put a constraint (where clause) on the
result set, it generates fine, but without it, I think I am exceeding some
hi.
I'm trying to enable a FK on a table. when I execute
aler table t1 enable constraint c1;
everything works fine; when I execute
alter table t1 enable constraint c1 exceptions into
exceptions;
I'm getting ora 2445 - exceptions table not found.
when I do desc exceptions, the table is right
I had a similar problem on 9.2 and, just as you describe, I could watch the file on
the remote location and the byte count would show the whole file was there but the
alert log file would not show the archive complete for as long an one hour. When it
did finally complete, the byte count on the
I work for quest so obviously my recommendation should be taken with a grain of salt
but Qdesigner is available for trial download and the purchase price can be seen
online.
http://quest.com/qdesigner/
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]
Sent: lundi, 7.
Hi John,
Were you also using optional on the secondary, nfs mounted destination?
Did your DB eventually grind to a stop waiting for the secondary to complete
(I'm assuming yes)? I'm considering this sort of thing for a DR setup to
eliminate the traffic jam effect that might be caused by an
I've had files that80 gb, but
this saysyou can go up
to 2tb.
http://www.ntfs.com/ntfs_vs_fat.htm
Steve
- Original Message -
From:
Ferenc Mantfeld
To: Multiple recipients of list ORACLE-L
Sent: Monday, July 07, 2003 5:04 PM
Subject: Windows server max file
size
Ferenc,
From what (little) I know of Win2K, the file size is only limited by the Volume Size
(max vol
size is 2TB). However, NTFS5 allows Disk Quotas. You may be running into quota
limitations. Check
under Properties dialog box for the Volume in question. There is a Quota tab and
then..
list, i created a new instance of 8.1.7 on Hp-UX and because some of the
front end programs use
utl package to write the log files to the server, i did this.
UTL_FILE_DIR = /u1/app/oracle/admin/BIS/utl_dir/
note the slash in the end in the front end programs.. we are also using
directory
Dear all,
I have a basic doubt. I grew up (in Oracle) believing that for the
concatenated indexes to be used by a query the ordering of the columns in
the where clause was very important. But now I have doubts
I have a table test and a composite index on it.
CREATE TABLE TEST (
A
The order of the where clause is not important. Including the leading
(first) columns in the index is. If you remove the a = ? element from
any of the queries then it may stop using the index. Oracle is smart
enough to look at the entire where clause and work out what it can do to
achieve the
Hi
SQL select /*+ RULE */
2 A,B,C,D
3 from test
4 where b=113
5 and c=114
6 and a= 112
7 /
A B C D
-- -- -- --
112113114 test
Execution Plan
I didn't mean that including RULE will prevent the index from being used -
I should have explained myself better. When using the RULE based optimisor
the order of joins in the where clause becomes significant, I don't believe
the order of selection criteria is significant (although I have very
Mark,
You are wrong about the RBO. It takes conditions in the order it
finds them in the WHERE clause, but it has always been more subtle than
that - there is some weighting of conditions (column = constant better
than column = other_column, unique_index_column = other_column better
than
Title: RE: ORA-00600: internal error code, arguments: [19944], [], [], [], [],
[], [], []
Good
solution ;-)
-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni,
Rajendra
Sent: Monday, July 07, 2003 10:30
PM
To: Multiple recipients of list
Canadians are amateurs when it comes to taxation. Here are some ideas from
Denmark:
Top tax: 62% - and it hits even lowly paid teachers.
VAT 25% on everything.
180% on cars. After adding that, you add the 25% VAT. So $10K becomes $35K.
Then of course there are the special taxes on chocolate,
Tim Gorman's old green one (along with Gary X - forgot this name just now)
is not half bad all day long.
KENNETH JANUSZ wrote:
Would like recommendations on
the top two books for building Oracle data warehouses.
TIA,
Ken Janusz, CPIM
78 matches
Mail list logo