). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
-
| Brian McGraw -+- Senior DBA |
| mailto:[EMAIL PROTECTED]
|
-
I would opt to separate them.
I ran into some problems with a Collaboration Suite install, where I wanted to use the
OID database, to store my files data as well. It failed in a spectacular fashion. An
Oracle support analyst said that was a bad idea. When I asked him if I could just
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
I would suggest the $ORACLE_HOME/rdbms/admin/utlrp.sql script, which
recompiles any invalid objects, or the $ORACLE_HOME/rdbms/admin/utlirp.sql
script, which will invalidate and recompile objects for you.
-
| Brian McGraw -+- Senior DBA |
| mailto:[EMAIL
I actually sat for the beta of that exam, the week before OracleWorld. I
haven't received my scores yet, so I doubt that it is actually being offered
to the general public yet. But that *is* the plan.
Brian
-
| Brian McGraw -+- Senior DBA |
| mailto:[EMAIL
McGraw -+- Senior DBA |
| mailto:[EMAIL PROTECTED] |
-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
I think you might be referring to this footnote, from the same document:
NOTE: Although triggers of different types are fired in a specific order, triggers of
the same type for the same statement are not guaranteed to fire in any specific order.
For example, all BEFORE row triggers for a
Affirmative. I used SQL*Plus during one of the Hands-On 10G Database sessions at
OracleWorld.
Brian
- Original Message -
Date: Monday, September 22, 2003 11:19 am
Hello:
Was watching Larry Ellison's key note and he mentioned that they
still have
SQL Plus in 10g.
I heard rumor
Title: Message
I believe the official publication date is
09/17.
Tomorrow, Tomorrow Youre
only a Day Away
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mladen
Gogala
Sent: Tuesday, September 16, 2003
10:05 AM
To: Multiple
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
Is anyone attending the 9i Cram Session on Sunday? If so,
could you please email me off-list?
Thanks,
Brian
[EMAIL PROTECTED]
I'll be there! And judging from all of the responses you've gotten,
looks like I'll finally get to meet some of my favorite posters from the
list.
Brian
-
| Brian McGraw -+- Senior DBA |
| mailto:[EMAIL PROTECTED
Title: RE: 9ias install - automatic creation of database
Paula
To quote a former President, I feel your
pain.
I have been trying to get iAS installed
for *weeks* with only limited
success. I installed it once, only to find out later that I needed the
Portal option. To get the
Rachel -
Do you actually have the error text from the alert log?
Looks like I have something to add to my Perl script... :)
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED
Jared -
I assume you're attempting fast refreshes - Is it feasible to attempt a full refresh?
I remember problems w/ snapshots (in the 8.0.4 days) where the snapshot logs would
just stop working. I had to perform a full refresh of the snapshots, then drop and
recreate the snapshot logs.
.
2. That's a little more difficult. My first instinct would be to check
your path and make sure that the Oracle binaries are in it. Are you
able to successfully connect to the database via SQL*Plus? Can you
TNSPING it?
Brian
--
| Brian McGraw
tnsnames.ora files. I think youd have a lot more fun with the .tnsnames.ora
file, if youre on Solaris. J
Hope that information is useful to someone out there
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance
|
| mailto:[EMAIL PROTECTED]
|
--
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Kanagaraj
INET: [EMAIL PROTECTED]
Fat City Network Services
.
Enjoy... Feel free to improve on it or point out any errors...
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED
strategists, if I recall correctly.
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED]
|
--
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf
Rick -
Are all of the sqlnet.ora files resolving hostnames in the same order
i.e., NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES, HOSTNAME)? I'd also
check for a rogue tnsnames.ora file in the same path as the executable.
Brian
--
| Brian McGraw /* DBA
: http://www.orafaq.com
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself
Absolutely. Which is why none of my 8i OPS databases have gone to 9i
RAC yet. And from the recent article that was posted here (on Grid
Computing), I'm not alone.
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:Brian.McGraw;Infinity
With or without the *really fine* compression flag?? (-rf)
: )
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED]
|
--
-Original Message-
From: [EMAIL
. It honestly sounds
like youre trying to do a cold backup while the database is still up,
but thats just a guess.
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED
Title: RE: Oracle and Informix on one server memory issues
In the past, we ran an older incarnation of
Informix SE here, on a Solaris 2.6 box along with 8.1.6 and 8.1.7. There were no
issues / problems.
Brian
--
| Brian McGraw /* DBA
that I need to be aware of??
Thanks In Advance,
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED]
|
--
Rahul -
What error messages are you getting??
I had similar problems a while back w/ OEM 2.2, but followed the steps
laid out in Oracle Enterprise Manager 101 (Oracle Press), and it worked
like a champ.
Brian
--
| Brian McGraw /* DBA */ Infinity
Not all Oracle API's support TAF. I know that the JDBC thin driver does
not support TAF, while the JDBC OCI driver does.
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED
:)
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Message-
Robert
Sent: Friday, August 30, 2002 3:43 PM
To: Multiple recipients of list ORACLE-L
They are going to have iSQL*Plus (or however it's spelled) and you
may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
-bit version.
HTH -
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Message-
Carmichael
Sent: Wednesday, July 17, 2002 12:09 PM
To: Multiple
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Message-
Robert
Sent: Monday, July 08, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L
First of all, apologies to those I have talked
Sorry, all... That was obviously a message meant only for Robert...
Stupid hotkeys...
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Message-
Robert
Sent
Are there any DBAs out there supporting Saleslogix?
If so, could you email me privately? I have some questions
that Id like to bounce off of someone more familiar with this
application.
Thanks,
Brian
--
| Brian McGraw /* DBA
Would that be more unbreakable ???
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Message-
Gorbatchev
Sent: Wednesday, June 26, 2002 5:24 AM
To: Multiple
Hmmm. Maybe that's changed, but we were actually advised to move the
objects when we set them up in v8.
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original
Can I get an Amen??? :)
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Message-
Sent: Monday, June 17, 2002 9:38 PM
To: Multiple recipients of list
That explains it.
We're just paying the license fees for the test software. :)
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Message-
Sent: Monday
to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
would bet that it has some information that you would find beneficial.
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Message-
L.
Sent: Wednesday, June
see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
MSRP. Of course, the actual price depends on which part of the fiscal
year you catch the sales weasels in... :)
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED
If set to YES indicates the piece is deleted
START_TIME The starting time.
COMPLETION_TIMEThe completion time.
ELAPSED_SECONDSThe number of elapsed seconds.
HTH -
Brian
--
| Brian McGraw /* DBA */ Infinity
the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
also send the HELP command for other information (like subscribing).
--
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
--
Please see the official ORACLE-L FAQ: http
]
--
--
| Brian McGraw -- Oracle
DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com |
--
Which docs? I looked at the init.ora file, and it had:
processes=530
and MTS enabled.
Brian
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
--
Rachel Carmichael wrote:
they lie
command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com
running OPS come across a similar
issue??
Thanks.
Brian
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com
).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com |
--
--
Please see the official ORACLE-L FAQ: http
') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You
may
also send the HELP command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle
DBA |
| Central Alabama Oracle Users
the HELP command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] |
| http
information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com
may
also send the HELP command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http
subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com |
--
--
Please see
).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com |
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com
, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group
a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group
). You may
also send the HELP command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http
a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group
this, just to get a patch for a bug that I apparently do not have
access to on Metalink.
/RANT
I'm so irritated that I could pull my hair out, but I like all 5 that
are left...
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group
of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL
handled the exception perfectly. Of
course, you'd want to code the exception more accurately, but
I think this example proves that it is possible.
Brian
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group
).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com |
--
--
Please see the official
yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You
may
also send the HELP command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle
DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com |
--
a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group
Hmmm
SQL select to_char(sysdate,'SSDD') from dual;
TO_C
3903
: )
Brian
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http
') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central
send the HELP command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com
(like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com
subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com |
--
--
Please see
Most of the high-volume replicated sites that I have heard of over the past few years
use Quest's Shareplex. I've had no experience with Clustra.
Brian
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group
80 matches
Mail list logo