RE: tnsnames.ora not working ?

[Scott Canaan]

Are you using Oracle Services?  I've seen this happen before and we
change SERVICE_NAME to SID and everything works fine.

Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.


-Original Message-
Reuben D. Budiardja
Sent: Tuesday, January 20, 2004 10:49 AM
To: Multiple recipients of list ORACLE-L


Hello,
I'm trying to add description in my
$ORACLE_HOME/network/admin/tnsnames.ora, 
but it seems that the client (ie. sqlplus) wont use it. Whenever I try
to 
connect to the service using sqlplus, I got :

$> sqlplus
Enter user-name: [EMAIL PROTECTED]
Enter password: * 
ORA-12154: TNS:could not resolve service name

I tried to add the description to my ~/.tnsnames.ora too with no luck.
The 
entry in the tnsnames.ora is:

DEV_DB =
   (DESCRIPTION =
 (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
 )
 (CONNECT_DATA =
   (SERVICE_NAME = dev_db)
 )
   )

(note: I removed the real hostname for privacy/security reason of
course)

However, when I use sqlplus using the following way:

$> sqlplus

Enter user-name: 
developer@(description=(address=(protocol=tcp)(host=hostname)(PORT = 
1521))(CONNECT_DATA =(SERVICE_NAME = dev_db)))
Enter password: * 

It would work, where all the information from the description is just a 
copy-paste from the tnsnames.ora file.

Is there anything I overlook? Sorry if this is kinda a newbie question.
I'm 
still learning my way around this. I'm using Oracle9i on Redhat Linux.

Thanks for any help.

Reuben D. Budiardja
-- 
Reuben D. Budiardja
Department of Physics and Astronomy
The University of Tennessee, Knoxville, TN
-
"To be a nemesis, you have to actively try to destroy 
something, don't you? Really, I'm not out to destroy 
Microsoft. That will just be a completely unintentional 
side effect."
 - Linus Torvalds -

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Reuben D. Budiardja
  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 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Canaan
  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 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).

Re: Cold Fusion and Bind Variables

[Scott Behrens]

Jared,
  Try this link.  It still worked for me this morning.
 
http://www.macromedia.com/devnet/server_archive/articles/cfqueryparam_oracle_databases.html 
Scott
>>> [EMAIL PROTECTED] 1/12/04 8:49:25 PM >>>
Dear List, We have a developer here that is pretty good with the web stuff, but his strong suit is not databases, or at least not Oracle. He develops primarily in Cold Fusion, which I know little about. I'm trying to teach him the difference between literal and bind variables, and the importance of knowing the difference.  While it is easy to demonstrate this in PL/SQL or Perl, I have no idea how to do so in CF. A few minutes of googling didn't really turn up anything useful. I'm looking for some examples of using bind variables in SQL as used in Cold Fusion that connects to Oracle 8i.  If you have one, the virtual beer is on me.  :) Jared 

RE: Risk of knowing password hash value (Was: OEM permissions)

[Scott Canaan]

This is what I got, Oracle 8.1.7.4 on Sun Solaris (I dropped the user):

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

SQL> create user scott identified by tiger;

User created.

SQL> select password
  2  from dba_users
  3  where username = 'SCOTT'; 

PASSWORD
--
F894844C34402B67

SQL>

Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.


-Original Message-
rahul sharma
Sent: Tuesday, December 23, 2003 1:14 AM
To: Multiple recipients of list ORACLE-L

8.1.7 on win2000

SQL> select password
  2  from dba_users
  3  where username = 'SCOTT';

PASSWORD
--
F894844C34402B67




- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 23, 2003 11:44 AM


> Hi,
> 
> Okay. I'm almost a believer of this as a problem. How
> about 9.2.0.4 on RH9.3.
> 
> 1) What does anyone/everyone get for my this query (my
> results shown):
> 
> connect system/[EMAIL PROTECTED];
> alter user scott identified by tiger;
> --
> select password
> from dba_users
> where username = 'SCOTT';
> 
> PASSWORD
> 
> F894844C34402B67
> 
> 2) If you all get the same, then I'm concerned.
> 
> Regards,
> 
> Mike Thomas
> 
> --- Yong Huang <[EMAIL PROTECTED]> wrote:
> > Jared,
> > 
> > I see you log out and log back in as SYSTEM to DB2.
> > But how do you know the
> > password for SYSTEM to log back in with after you
> > change it?
> > 
> > What if you don't log out? When I tried that (i.e.
> > not logging out), I got
> > ORA-1017.
> > 
> > Yong Huang
> > 
> > --- Jared Still <[EMAIL PROTECTED]> wrote:
> > > Environment:
> > > 
> > > DB1: RH 8.0 with Oracle EE 9.2.0.4
> > > 
> > > DB2: Win2k SP3 with Oracle EE 9.2.0.1
> > > 
> > > SYSTEM user on each database initially have
> > different passwords.
> > > 
> 
> 
> __
> Do you Yahoo!?
> Protect your identity with Yahoo! Mail AddressGuard
> http://antispam.yahoo.com/whatsnewfree
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Michael Thomas
>   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 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).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: rahul sharma
  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 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Canaan
  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 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).

RE: Misbehaving query

[Scott Canaan]

That's what I was thinking, too.  I tried it on 8.1.7.4 and it works the
same way, as I expected.  You would need an outer join to get something
back.

Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.


-Original Message-
Carol Bristow
Sent: Friday, December 12, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L

Junk minus junk2 results in no rows, and when you do the implied
cartesian join between view a and view b, joining no rows with  one row
gives no rows.

Makes sense to me.

Carol Bristow
DPRA Inc.
1300 N 17th St Suite 950
Rosslyn, VA 22209
Work: 703-841-8025
Fax: 703-524-9415

-Original Message-
Sent: Friday, December 12, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L

Hi!

I have a query that I think is behaving oddly; and, it may just be that
I'm
blind and am doing something silly (*there's* a first!), or it may be
environment specific, but, I'm thinkin it may just be a bug.  I have
filed a
TAR with Oracle, and they keep sending workarounds, when I told them
from
the start that I've got one, this is only a question of why this query
isn't
working.  So, two parts, really... is this query really not working, and
if
so, does anyone have a clue as to why?

We're on 9.2.0.2 on SunOS.  The overall issue is easy.  I have two
tables.
I want to find the difference in the contents.  This is easily
accomplished
by doing

A MINUS B
UNION
B MINUS A

*That's* not the issue.  The issue is that if I do this through inlines,
the
query fails.  I'll put everything out there so you can just cut and
paste
iffen you wanna...

SQL> create table junk (test char(1));

Table created.

SQL> insert into junk values ('A');

1 row created.

SQL> insert into junk values ('B');

1 row created.

SQL> insert into junk values ('C');

1 row created.

SQL> create table junk2 as select * from junk;

Table created.

SQL> insert into junk2 values ('X');

1 row created.

SQL> select * from junk;

T
-
A
B
C

SQL> select * from junk2;

T
-
A
B
C
X

SQL> select * from junk minus select * from junk2
  2  union
  3  select * from junk2 minus select * from junk;

T
-
X

SQL> select a.* 
  2  from
  3  ( select * from junk2 minus select * from junk ) a;

T
-
X

SQL> select a.*, b.*
  2  from
  3  ( select * from junk2 minus select * from junk ) a,
  4  ( select * from junk2 minus select * from junk ) b;

T T
- -
X X

SQL> select a.*, b.*
  2  from
  3  ( select * from junk minus select * from junk2 ) a,
  4  ( select * from junk2 minus select * from junk ) b;

no rows selected


Anyone?
Bambi.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bellow, Bambi
  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 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carol Bristow
  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 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Canaan
  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 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).

Re: Re: Little competition

[Scott Behrens]

Hey Richard,
   One of my desktop treasures is an autographed copy of 
Jonathan Lewis' book, Practical Oracle8i.  The humorous, 
self-deprecating caption in the author's own hand:  
'Never believe all you read.'
 
Scott
>>> [EMAIL PROTECTED] 12/12/03 7:24:24 AM >>>
Hi Jonathan,SQL> create tablespace bowie_test  2  datafile 'c:/bowie/bowie_test01.dbf' size 100m  3  extent management local uniform size 1m  4  segment space management auto;Tablespace created.SQL> create table bowie_assm (ziggy number)  2  tablespace bowie_test  3  storage (initial 1m next 2m pctincrease 100 minextents 3);Table created.SQL> select owner, segment_name, blocks from dba_extents  2  where segment_name = 'BOWIE_ASSM';OWNER  SEGMENT_NAME BLOCKS--  --BOWIE  BOWIE_ASSM  128BOWIE  BOWIE_ASSM  128BOWIE  BOWIE_ASSM  128BOWIE  BOWIE_ASSM  128BOWIE  BOWIE_ASSM  128BOWIE  BOWIE_ASSM  128BOWIE  BOWIE_ASSM  1287 rows selected.3 minextents = 1 initial + 2 next + (2 next + (2 * 1.0 pctincrease) = 7 * 1MextentsIt's actually quite a common misconception that NEXT, PCTINCREASE andMINEXTENTS are ignored for locally managed tablespaces when in fact they'reused to determine the initial size of the object and hence the number ofextents initially allocated.This was all a bit of fun but I think it did prove my little (mischievous)point. That it's really quite easy to base ones belief and certainty on a"fact" that turns out to be totally false because the basis on why youbelieve something also turns out to be false. On the surface it appeared tobe quite a reasonable conclusion, that pctfree is not permitted with ASSMobjects because the "evidence" strongly supported such a claim.Unfortunately the evidence was somewhat erroneous in that it stupidly reliedon incorrect syntax and so an incorrect conclusion resulted. This incorrectconclusion can then result in inappropriate behaviour and curses from DBAsas they experience all these "unavoidable" migrated rows. Before you knowit, other Oracle myth is born ...Of course everyone makes mistakes but to publish them does come with it'sown set of responsibilities. I can't stress enough that one be careful of"what" you read and be careful of "who" you read.The truth IS out there ;)CheersRichard> > This could be a serious issue for the Oracle professional unless they> remember that locally-managed tablespaces with automatic space management> ignore any specified values for NEXT and FREELISTS.>> >> There is another error here.> For a bonus 10 points can anyone spot it ?>> Hint - try the following in a tablespace> which is locallally managed, with automatic> space management, and either system managed> or uniform sized extents of no more than 1 M.>> create table test2(n1 number)> storage (initial 1M next 2M pctincrease 100 minextents 3);>> Regards>> Jonathan Lewis-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Richard Foote  INET: [EMAIL PROTECTED]Fat City Network Services    -- 858-538-5051 http://www.fatcity.comSan Diego, California    -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).

RE: what is oracle rdb?

[Scott Graves]

Same opinion here, my company is in the process of migrating our software to
run on Oracle 9iR2.  Currently, we have over 325 production sites that have
RDB databases running.  RDB is a single schema database so each customer
site has multiple databases running.   Very easy to manage, backup and yes
recover.  RDB has always had the cost based optimizer.  Logminer has been
around for a long time and the backup utility (RMU) supposedly has links to
RMAN.  As with everything Digital, great technology, crappy marketing, sold
to someone who wants the technologies.

If it weren't limited to the VMS platform (no flames, I love VMS) it would
have a much bigger installation base.

Back to the grind...(What was that Unix/Oracle command to...)



Scott Graves
Sr. Systems Programmer
NISC RDQ-STP
Email: [EMAIL PROTECTED]
Phone: 636-922-9122 x7616
Fax: 636-922-2080

-Original Message-
Jonathan Gennick
Sent: Monday, November 24, 2003 6:59 PM
To: Multiple recipients of list ORACLE-L

Monday, November 24, 2003, 3:49:26 PM, [EMAIL PROTECTED]
([EMAIL PROTECTED]) wrote:
rcn> I see it referred to on metalink alot. I know its seperate from the
rdbms.

Rdb was the database I cut my teeth on. So easy to use. As I
recall, you could create a database with just the following:

CREATE DATABASE;

Everything, including the database name, would default. It
was great, especially for learning on.

Digital's online help was unsurpassed too. I learned a lot
from that, and from their Rdb manual set. All Rdb's commands
worked consistently and logically, and everything was so
orthogonal. Heck, if you wanted to see what a table looked
like, you just issued commands such as:

SHOW TABLE

SHOW TABLE /CONSTRAINTS (to see constraints too)

SHOW TABLE /INDEXES /CONSTRAINTS

SHOW TABLE /ALL (to see everything)

I recall beginning my database education by tying HELP RDB
at the operating system, and then progressing from there.
Typing HELP from within RDB's interactive-SQL utility was
sheer joy.

One of the first things I did when I made the move to Oracle
was to fire up SQL*Plus and issue the SHOW TABLE command to
see the structure of a table I was trying to insert into. I
was baffled that there was no such command. HELP SHOW didn't
help much either, because I discovered that SHOW seemed to
show a whole bunch of things I didn't care about and nothing
that I did care about. I was even more astounded when I
discovered DISPLAY, which didn't, and still doesn't, even
begin to give you the information you needed in order to be
able to get work done with a table. It took me over a day,
as I recall, before I managed to find someone who could show
me how to look at constraints on a table. I'd heard all
these great and wonderful things about Oracle, that it was
*the* database to learn. Well, from a career standpoint
that's probably true, Oracle was the database to learn, but
certainly not from a usability standpoint.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article,
or send email to [EMAIL PROTECTED] and
include the word "subscribe" in either the subject or body.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Gennick
  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 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Graves
  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 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).

RE: Oracle 10g Migration

[Scott Canaan]

According to the presentation by Dave Foster of Oracle at the last
UNYOUG meeting, there will be a direct upgrade from 8.1.7 and 9.2.
Also, the new dbassistant has an undo feature, to rollback the upgrade.

Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.


-Original Message-
Sent: Friday, November 21, 2003 9:49 AM
To: Multiple recipients of list ORACLE-L

Mladen,

Direct 8i(as in 8.1.7.4) to 10 or do you HAVE to go through 9.x
first?

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Friday, November 21, 2003 9:39 AM
To: Multiple recipients of list ORACLE-L


Yes.

On 11/21/2003 09:29:31 AM, Tracy Rahmlow wrote:
> Does anybody know whether or not Oracle will support and upgrade of an
8i 
> database to 10?  Thanks
> American Express made the following
>  annotations on 11/21/2003 07:28:27 AM
>

--
>

**
> 
>  "This message and any attachments are solely for the intended
recipient and may contain confidential or privileged information. If you
are not the intended recipient, any disclosure, copying, use, or
distribution of the information included in this message and any
attachments is prohibited.  If you have received this communication in
error, please notify us by reply e-mail and immediately and permanently
delete this message and any attachments.  Thank you."
> 
>

**
> 
> 
>

==
> 

Mladen Gogala
Oracle DBA



Note:
This message is for the named person's use only.  It may contain
confidential, proprietary or legally privileged information.  No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this message in error, please immediately delete it and
all copies of it from your system, destroy any hard copies of it and
notify the sender.  You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the
intended recipient. Wang Trading LLC and any of its subsidiaries each
reserve the right to monitor all e-mail communications through its
networks.
Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized
to state them to be the views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  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 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  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 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Canaan
  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 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).

RE: New Virus alert from paypal

[Scott Canaan]

Since, I believe, Paypal is owned by eBay, has any that's received this
sent a message to safeharbor?  I would think they should be made aware
of it.

Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.


-Original Message-
Sent: Wednesday, November 19, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L

List,
Any one else get word of this new virus?
Ron

>>> Mar-D Greer 11/19/2003 9:34:44 AM >>>
There is a new virus that has surfaced since last week.  This virus
reports that users need to update their PayPal accounts.  Do not open
this, delete the e-mail as PayPal has not issued this e-mail and the
e-mail itself contains a virus.

The actual e-mail reads as follows:
(Found virus WORM_MIMAIL.J in file www.paypal.com.pif)
**


Dear PayPal member,

We regret to inform you that your account is about to be expired in
next five business days. To avoid suspension of your account you have
to reactivate it by providing us with your personal information.

To update your personal profile and continue using PayPal services
you have to run the attached application to this email. Just run it
and follow the instructions.

IMPORTANT! If you ignore this alert, your account will be suspended
in next five business days and you will not be able to use PayPal
anymore.

Thank you for using PayPal.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  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 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Canaan
  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 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).

RE: Point-In-Time recovery question, Non-RMAN solution

[Scott Canaan]

Have you looked into using logminer?  Even if it can't restore your
table, it can give you the exact time that it was dropped.

Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.


-Original Message-
Sent: Thursday, November 06, 2003 8:45 AM
To: Multiple recipients of list ORACLE-L





Hi DBAs,

Oracle 8i, ArchiveLog, No RMAN
Testing Point-In-Time Recovery

I am confused on what time to substitute in the RECOVER DATABASE UNTIL
TIME
'timestamp';

For example 2 days ago 11/04/2003 approximately 17:00 I drop a table.
Today I decide I want that table back. I want to do an incomplete
recovery
to get the table back.
How do I know what timestamp to use?  I have an idea the I dropped the
table but not exact.


1. SHUTDOWN Normal
2. BACKUP current database
3. Restore datafile that has the table in it.
4. connect internal
5. startup mount
6. recover database until time 'timestamp??';
7. Alter database open resetlogs;
8. BACKUP current database

Step 5 is my confusion.

Also I assume all data is now lost  since last archive restored to the
present.
The only way I know to get that data back is to
1. Export the table that was dropped.
2. Restore database from step2
3. Import table from step1

Is there better ways.

Thanks
Rick


-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Canaan
  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 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).

RE: RE: dba interview questions

[Scott Canaan]

What do you need the stmt for?  Just do:

begin
for a in (select username from dba_users
  where username not in ('SYS','SYSTEM',...))
loop
execute immediate 'alter user '||a.username||' account
lock';
    end loop;
end;
/

Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.


-Original Message-
Sent: Friday, October 24, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L

Sure do, here's my favorite:

You have a database with 3000 registered users, you need to lock
all accounts except for a list of 20.  How would you do it?

Obviously there's several correct answers.  But the one I'm looking for
is the "anonymous PL/SQL block" defined like:

declare 
stmt varchar2(200);
begin
for a in (select username from dba_users
  where username not in ('SYS','SYSTEM',...))
loop
stmt := 'alter user '||a.username||' account lock';
execute immediate stmt;
end loop;
end;
/


Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Friday, October 24, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L


do any of you ask dbas pl/sql questions? I think its important for DBAs
to be good developers as well. especially if they are part of a
development team. I dont think the skill sets should be seperate. they
overlap. 
> 
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/10/24 Fri AM 11:39:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: dba interview questions
> 
> We prefer to ask their experiences and then throw a curve ball and ask
them to defend it. Small issues like "Why would/wouldn't an index help?"
etc ... 
> 
> Another question that I *always* ask is "what do you or have you read
in last 3 months outside of Oracle manuals?" or "Do you know any other
sites that give you lot of oracle related information?" I expect to hear
at-least couple form following list ... ixora, hotsos, jlcomp,
oracle-dba, oraperf, orapub. If they mention that they have read YAPP,
that's a bonus too.
> 
> But if someone says they haven't read anything other than manuals
questions become a little steep.
> 
> Raj
> 
> -Original Message-
> Sent: Friday, October 24, 2003 9:49 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> The problem with such lists is that the prospects also have those...
> A few years ago Mike Ault published one. We used it to screen
candidates via phone interviews. 
> Two out of four I talked to gave me perfect answers: word to word from
Mike's list. 
> 
> Use Conner's approach: Give the candidate a white/black board, and ask
him/her to draw the SGA
> with all it interal structures, all background processes, and explain
how all this works
> together. 
> 
> - Kirti 
> 
>

**
> This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged,
attorney work product or exempt from disclosure under applicable law. If
you have received this message in error, or are not the named
recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank you.
>

**4
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jamadagni, Rajendra
>   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 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).
> 

-- 
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 and web hosting services
-
To REMOVE yourself fro

RE: Question about sql

[Scott Canaan]

How about:

insert into table3(company_id,lev_id,vare_id)
(select table2.company_id,lev_id,vare_id 
  from table1, table2
 where table1.company_id = table2.company_id);


Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it." - Tom 
Lehrer.


-Original Message-
Sent: Thursday, October 16, 2003 10:20 AM
To: Multiple recipients of list ORACLE-L

Hallo,

Anyone whom could gíve me some good help on this.

I have a table with one field, called Company_id
Like this

   Company_id

  16
  45
  50


In table 2 I have this field and values:

Company_id  Lev_idVare_id

  16  45  56
  34  10  20
  67  10  20
  45  15  30
  50  12  12

I would like to from table 2 do a select and find the Company_ids from table1 and find 
out the responding lev_id and vare_id in table2and then insert them into a new 
table(table3) so it would look like this:

Company_idLev_idVare_id
1645  56




Anyone whom could give me some help on this how to write the sql- query.

I have tried with this sql query. What is wrong?

insert into table3(company_id,lev_id,vare_id)
select company_id,lev_id,vare_id from table2 where vare_id = 56
(where exists select  company_id  from table1)


Thanks in advance



Roland















-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Canaan
  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 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).

RE: FIRST_ROWS hints

[Scott Canaan]

Did you remember to cut the db_file_multiblock_read_count
in half, since you doubled the blocksize?  I would assume that you also started
seeing more full table scans, as well.

 

 



Scott Canaan ([EMAIL PROTECTED])

(585) 475-7886

"Life is like a sewer, what you get
out of it depends on what you put into it." - Tom Lehrer.



 

-Original Message-
From: Sai Selvaganesan
[mailto:[EMAIL PROTECTED] 
Sent: Wednesday,
 October 08, 2003 2:54 PM
To: Multiple recipients of list
ORACLE-L
Subject: FIRST_ROWS hints

 



hi





 





i had a migration from 9.2.0.3 to 9.2.0.4 of a
database and here are a couple of observations. please help me
in understanding this.





 





i changed the db block size from 8k to 16k and all sql
queires which were using nested loops earlier moved to sort merge joins. i ran
10053 and form whatever i could understand the 9204 db has fewer number of
blocks compared to the existing 9203 (db size changed to 16k) and sort merge
join turned out to be less costlier than nested loops (i
couldnt understand the sort statistics). no  parameter other than db
block size was changed.





 





after breaking my head i changed the optimizer mode
from choose to first rows and the query is back to the old explain plans.





 





please clarify





1. whether this is a expected behaviour





2. what is first_rows hint and whether it is good move
to go to first_rows to fix this problem.





 





thanks





sai





 





 

Re: Basic question about controlfile recovery

[scott]

Thankz Mladen & Govindan.

I do have Velpuri's book besides me.
let me go thro' it once again.

Regards,
Scott.

__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: scott
  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 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).

Basic question about controlfile recovery

[scott scott]

Listers,

sorry for this basic questionnare.

..was reading the RMAN B&R docs (9iR2).got these
doubts and thought of claryfying it with u experts.

Q1.after a controlfile recovery from backup,is "open
resetlogs" always necessary ?

Q2.is there any scenario,where "open resetlogs" is not
necessary after controlfile recovery ?

Q3.i have backup ( one day old ) of all my
datafiles/archivelogs/controlfile.now,when all my
controlfiles are lost with online redologs intact,
is complete recovery possible ? if so, is "open
resetlogs" reqd. & why ?

Please enlighten me.
i'll continue RTF(ine)M.

Regards,
Scott.




__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: scott scott
  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 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).

RE: Using dimensions

[Scott Canaan]

Title: Using dimensions









Dimensions are data warehouse constructs. 
They are implemented as tables in the database, but have the characteristic of
a hierarchy that can be traversed.  For example:  a time dimension can have the
hierarchy of date, day, week, month, quarter, year, decade, century.  This is
used for rollup reporting within the data mart.  I don’t see any good use
of it in an OLTP environment, but I may be wrong.

 



Scott Canaan ([EMAIL PROTECTED])

(585) 475-7886

"Life is like a sewer, what you get
out of it depends on what you put into it." - Tom Lehrer.



 

-Original Message-
From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED] 
Sent: Monday, September 29, 2003
10:55 AM
To: Multiple recipients of list
ORACLE-L
Subject: Using dimensions

 

I have tried, but haven't
found a good example of how to _use_ a dimension in 9ir2. I defined one, but
then sat clueless on what to do with it. Is it any good in an OLTP environment?
(I smell the answer is a NO, but still) ...

Any notes from your
experience? 

TIA 
Raj



Rajendra
dot Jamadagni at nospamespn dot com 
All
Views expressed in this email are strictly personal. 
QOTD:
Any clod can have facts, having an opinion is an art ! 

RE: Sqlloader question

[David Scott]

Roland,

There are 2 techniques you can use. The first is what I call a 'dynamic
control file' - other posters have given you examples of that one, using
sed.

The next is create a 'loop loader'; essentially a script file that fires off
sqlldr for each loadable file. Here's an overly simple example:
export FILESPEC=/d31/datafiler/sema/incoming/konkurrenter.*
for FILENAME in $( ls ${FILESPEC} )
do
  sqlldr ${USER-PW} control=${CTL} data=${FILENAME}
log=${LOGPATH}/${FILENAME}.log
done

Both techniques are explained in my IOUG paper "SQL*Loader CAN Do That!". A
Windows example is also given. If you can't get to the IOUG web site and
would like a copy of the paper, send me an email.

David Scott
[EMAIL PROTECTED]

>  From: [EMAIL PROTECTED]
>  Date: Thu, 11 Sep 2003 14:12:49 +0200
>  Subject: Sqlloader question

> Hallo,

> Anyone whom could tell me if it is in an sqlloader possible to write for
instance this if you dont know the exactly name of file.
> infile '/d31/datafiler/sema/incoming/konkurrenter.*'

> If there are going to be files with different extensions fo rinstance the
first time a file is going to be inserted will be konkurrenter.txt.1
> and the next time the file will have the name konkurrenter.txt.2 etc.

> How should I handle this?

> Thanksin advance

> Roland
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: David Scott
  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 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).

RE: Sqlloader question

[Scott Canaan]

The way I handled a similar situation was to create a default SQL*Loader
file with something recognizable in the place that you want to do the
substitution (in your case, the infile filename).  Then, I wrote a shell
script that created the correct filename and copied the default
SQL*Loader file to the one that was going to be run, substituting the
created name for the default name.  In my case, I used it to determine
which partition should be loaded, but the concept should still work.  I
used sed to do that: 

sed "6s/partition()/partition(`echo $IN_DATE_FMT`)/g"
em_contact_hist_ld.orig
 > em_contact_hist_ld.ctl

In the script, this was followed by a call to sqlldr with the control
file em_contact_hist_ld.ctl.

Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.


-Original Message-
Sent: Thursday, September 11, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L

Hallo,

Anyone whom could tell me if it is in an sqlloader possible to write for
instance this if you dont know the exactly name of file.
infile '/d31/datafiler/sema/incoming/konkurrenter.*'

If there are going to be files with different extensions fo rinstance
the first time a file is going to be inserted will be konkurrenter.txt.1
and the next time the file will have the name konkurrenter.txt.2 etc.

How should I handle this?

Thanksin advance

Roland



-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Canaan
  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 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).

RE: How to send an email from unix command line?

[Scott Canaan]

Have you tried mailx?  That's what we use here.

Scott Canaan ([EMAIL PROTECTED])

-Original Message-
Sent: Tuesday, September 09, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L

Hi List

I tried the following stuff but it says "Service
Unavailable". 

$mail -s "Test Subject" [EMAIL PROTECTED]
body line1
body line2
Ctrl-D

What should i do to make email stuff work?

Thanks in advance
Sami

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  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 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Canaan
  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 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).

Re: ADMIN: Warning about virus threats this week

[Scott Lamb]

Bruce A. Bergman wrote:
Hello everyone --

As you undoubtedly know, the Internet has been slammed this week and last week with mass mailings, intrusions, worms and viruses.  More are on their way.  Fat City has seen a huge increase in the number of spoofed messages coming into our systems.  In fact, more than three times the normal load, and this could potentially cause some problems for all of our mailing lists.

In order to mitigate this potential problem, I have decided to turn off many of the auto-repsonses that ListGuru sends.  Because of the way viruses like SoBig and Klez spoof addresses, and because there are so many fatcity.com addresses in your address books and inboxes, this results in a large number of spoofed messages that ListGuru tries to reply to.  Not only is that useless, but it's also annoying for those whose addresses have been spoofed.  By shutting off those responses which aren't considered valid, this will reduce the amount of back and forth traffic between our servers and you.
This is very much appreciated. I can filter the actual worms out, but 
I'm getting walloped by responses to spoofed worm emails. It's nice to 
know there's at least one place deliberately not sending them.

Thanks,
Scott Lamb
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Lamb
 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 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).

Re: Forms - as sysdba

[Scott Lamb]

Robo wrote:

Hi all,
I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There 
are 3 boxes for username, password and database.

Does anyone know if/how is it possible?
Yes, you could do this by creating an ON-LOGON trigger. But this is a 
really, really bad idea.

Scott Lamb

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Lamb
 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 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).

Re: select strings with '_' in it

[Scott Lamb]

Tanel Poder wrote:

Hi!
 
I think translate is overkill here.
 
Use:
 
select col from tab where col like 'v\_lan' escape '\';
vs

> Select col1 from table
> where translate(col1,'_','#') like 'v#lan%'
> /
Not only is the escape method cleaner, it's much more efficient. Unless 
you have an index on translate(col1,'_','#') (unlikely), that query will 
always result in a sequential scan. Ugh.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Lamb
 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 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).

Re: Tracing a user session with multiple database connections

[Scott Lamb]

Schauss, Peter wrote:
Is there any way to trace all of the connections
for a given sid without setting sql_trace for the entire instance?
You could try creating a trigger to do it. "create trigger foo after 
login on database ..."

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Lamb
 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 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).

Auth via Active Directory

[Scott Lamb]

Is there any way to get Oracle 8i (or 9i; we're planning to upgrade) 
Enterprise Edition to authenticate against Active Directory, short of 
buying Oracle Advanced Security?

My goal is to remove the need to maintain a separate database of 
passwords. Ideally, we could do also do away with having the database 
users enter passwords by handling Kerberos tickets, but I'd be happy 
with them just entering the same password they enter to login to 
Windows. And if we still need to manually add/remove users, that's okay, 
too. (We'd probably want to, anyway; not everyone in the domain should 
have an Oracle account.)

In my fantasy world, authentication would all be done through a function 
that I could modify. Then I could just create my users with something like:

create user "DOMAIN\USER" identified externally;

as you would for OS$ authentication and then do something vaguely like:

create or replace function system.my_authenticate_user (
p_username  in varchar,
p_password  in varchar
) return boolean as
v_usertype  varchar2(30);
v_session   dbms_ldap.session;
begin
selectauthtype
from  dba_users
where username = p_username;
if authtype = 'EXTERNAL' then
v_session := dbms_ldap.init('my-domain-controller', 389);
return dbms_ldap.simple_bind_s(v_session, p_username,
   p_password);
end if;
return standard_authenticate_user(p_username, p_password);

exception
when no_data_found
return false;
end;
/
show errors
but I'm not aware of any such hook. There are logon triggers, but just 
of the after type, not "instead of". ("create trigger ... after logon on 
database" or something, for audit trails, I think.)

Does anything like this exist? Or is there another way, however convoluted?

Thanks,
Scott Lamb
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Lamb
 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 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).

RE: what happens if a remove a job that is running?

[Scott . Shafer]

Yes.  If you really want to kill the job, the graceful way is to break it
first (dbms_job.broken) and then remove it (dbms_job.remove).

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]
> Sent: Thursday, August 14, 2003 10:00 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  what happens if a remove a job that is running?
> 
> If I run dbms_job.remove on a job that is in dba_jobs_running it remains
> in that table.
> 
> it runs to completion correct? 
> 
> -- 
> 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 and web hosting services
> -
> To REMOVE 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).
-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).

RE: Oracle SCN Question

[Scott . Shafer]

I thought "Bass" and "Rap" were synonymous?  Or am I out of touch with the
current music scene?

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: Nick Wagner [SMTP:[EMAIL PROTECTED]
> Sent: Thursday, July 31, 2003 4:24 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Oracle SCN Question
> 
> Thanks...   I think...  except I'm not sure how to calculate that?  
> 
> 
> 
> Nick
> 
> -Original Message-
> Sent: Thursday, July 31, 2003 2:00 PM
> To: Multiple recipients of list ORACLE-L
> 
> Hi,
> 
> It is just combination of Base and Wrap. So your number will be
> 8589934593
> 
> KG
> 
> 
-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).

RE: Recent reports on outages caused by DB2 and 9iRAC issues

[Scott . Shafer]

That's funny, I thought SAC's motto was "SAC eats it's young". 

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: Goulet, Dick [SMTP:[EMAIL PROTECTED]
> Sent: Friday, July 18, 2003 1:35 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Recent reports on outages caused by DB2 and 9iRAC issues
> 
> Raj,
>  
> My previous boss's attitude was:
>  
> To error is Human.
> To forgive is not SAC policy.
>  
> SAC= Starategic Air Command.
>  
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA 
> 
> -Original Message-
> From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 18, 2003 2:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Recent reports on outages caused by DB2 and 9iRAC issues
> 
> 
> 
> Dick, 
> 
> we don't share the same boss ... do we? 
> Raj 
> --
> -- 
> Rajendra dot Jamadagni at nospamespn dot com 
> All Views expressed in this email are strictly personal. 
> QOTD: Any clod can have facts, having an opinion is an art ! 
> 
> 
> -Original Message- 
> From: Goulet, Dick [ <mailto:[EMAIL PROTECTED]>] 
> Sent: Friday, July 18, 2003 1:39 PM 
> To: Multiple recipients of list ORACLE-L 
> Subject: RE: Recent reports on outages caused by DB2 and 9iRAC issues 
> 
> 
> I prefer my bosses attitude on the subject of mistakes: 
> Admit that you did it & then go fix it.  We'll crucify you later, if we
> have the time. 
> For some reason, known only to the Devil himself, they never find the
> time. 
> 
-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).

RE: STATSPACK in Oracle 8.1.6.0

[Scott . Shafer]

Metalink, Technet, Google, or at the scripts themselves (which all have
explanatory headers).

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: Richard Foote [SMTP:[EMAIL PROTECTED]
> Sent: Friday, July 18, 2003 5:34 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: STATSPACK in Oracle 8.1.6.0
> 
> Hi Scott,
> 
> Although the recommendation of RTFM often has it's merits, where precisely
> do you suggest Seema should look for the above mentioned FM within the
> *8.1.6* doco set for the sp* statspack scripts ?
> 
> Cheers
> 
> Richard Foote
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, July 18, 2003 5:59 AM
> 
> 
> > RTFM, which will point you to the sp*.sql scripts in the "?/rdbms/admin"
> > directory.
> >
> > Scott Shafer
> > San Antonio, TX
> > 210.581.6217
> >
> >
> > > -Original Message-
> > > From: Seema Singh [SMTP:[EMAIL PROTECTED]
> > > Sent: Thursday, July 17, 2003 2:49 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: STATSPACK in Oracle 8.1.6.0
> > >
> > > Hi,
> > > I want to delete all old records of statspack from perfstat schema.
> > > What would be best way to do this either by truncating all tables or
> > > remove
> > > and recreate ?
> > > Pl advice.
> > > thx
> > > -Seema
> > >
> > > _
> > > Add photos to your e-mail with MSN 8. Get 2 months FREE*.
> > > http://join.msn.com/?page=features/featuredemail
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Seema Singh
> > >   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 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).
> > --
> > 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-- Mailing list and web hosting services
> > -
> > To REMOVE 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).
> >
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Richard Foote
>   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 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).
-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).

RE: STATSPACK in Oracle 8.1.6.0

[Scott . Shafer]

RTFM, which will point you to the sp*.sql scripts in the "?/rdbms/admin"
directory.

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: Seema Singh [SMTP:[EMAIL PROTECTED]
> Sent: Thursday, July 17, 2003 2:49 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  STATSPACK in Oracle 8.1.6.0
> 
> Hi,
> I want to delete all old records of statspack from perfstat schema.
> What would be best way to do this either by truncating all tables or
> remove 
> and recreate ?
> Pl advice.
> thx
> -Seema
> 
> _
> Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
> http://join.msn.com/?page=features/featuredemail
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Seema Singh
>   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 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).
-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).

RE: Interview Questions for a Unix Solaris System Admin

[Scott . Shafer]

You only spend time on the technical stuff if they pass this round.

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: M.Godlewski [SMTP:[EMAIL PROTECTED]
> Sent: Tuesday, July 15, 2003 2:20 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Interview Questions for a Unix Solaris System Admin
> 
> These are nice questions.  I'm not sure how I would identify if they are
> technical enough to handle the job though.
> 
> [EMAIL PROTECTED] wrote: 
> 
>   question #1: Do you realize that your DBA is a God, and you will
> obey
>   his/her edicts without question?
>   
>   question #2: Are you aware of the daily offering of food/beer
> required to
>   keep in your God's (DBA's) good graces?
>   
>   etc...
>   
>   Scott Shafer
>   San Antonio, TX
>   210.581.6217
>   
>   
>   > -Original Message-
>   > From: M.Godlewski [SMTP:[EMAIL PROTECTED]
>   > Sent: Tuesday, July 15, 2003 1:30 PM
>   > To: Multiple recipients of list ORACLE-L
>   > Subject: Interview Questions for a Unix Solaris System Admin
>   > 
>   > I've been asked to interview a system admin candidate for our
> Solaris
>   > shop. I've search Google and altavista, but haven't come up with
> any
>   > after 1999 interview questions. Does anyone have a list of
> interview
>   > question or a link to some?
>   > 
>   > 
>   > 
>   > tia
>   > 
>   ! > M
>   > 
>   > _ 
>   > 
>   > Do you Yahoo!?
>   > The New Yahoo! Search
>   > - Faster.
>   > Easier. Bingo.
>   -- 
>   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 -- Mailing list and web hosting services
>   
> -
>   To REMOVE 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).
> 
>   _  
> 
> Do you Yahoo!?
> The New Yahoo! Search
> <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com> - Faster.
> Easier. Bingo.
-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).

RE: Interview Questions for a Unix Solaris System Admin

[Scott . Shafer]

question #1:  Do you realize that your DBA is a God, and you will obey
his/her edicts without question?

question #2:  Are you aware of the daily offering of food/beer required to
keep in your God's (DBA's) good graces?

etc...

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: M.Godlewski [SMTP:[EMAIL PROTECTED]
> Sent: Tuesday, July 15, 2003 1:30 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Interview Questions for a Unix Solaris System Admin
> 
> I've been asked to interview a system admin candidate for our Solaris
> shop.  I've search Google and altavista, but haven't come up with any
> after 1999 interview questions.  Does anyone have a list of interview
> question or a link to some?
> 
>  
> 
> tia
> 
> M
> 
>   _  
> 
> Do you Yahoo!?
> The New Yahoo! Search
> <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com> - Faster.
> Easier. Bingo.
-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).

RE: log for transaction

[Scott . Shafer]

We use a similiar method which involves inserting periodic rows into a log
table, which is dumped to a file at end-of-job.

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: Kirtikumar Deshpande [SMTP:[EMAIL PROTECTED]
> Sent: Tuesday, June 24, 2003 2:05 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: log for transaction
> 
> Oracle does not have any ready-made logging process to assist you. 
> Some of our developers have utilized 'utl_file' to track the progress of
> their long running jobs.
> Entries are made to the job log file at proper intervals to tell them what
> happened in case the
> job aborted. 
> 
> - Kirti 
> 
> --- [EMAIL PROTECTED] wrote:
> > Hi there,
> > 
> > I got a question on log. If my program crashes, can I check some log to
> see what
> > recent transaction is? It will give me a big help on trouble shooting.
> > 
> > Thanks,
> > Jin
> 
-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).

RE: copy a datafile to a raw device

[Scott . Shafer]

You left out, "...and why is there a goat in the corner?" 

Sounds like a fun way to have at my duhvelopers (not the good ones).


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/19/03 4:49 PM


Concerning my speculation about error messages in the Oracle kernel, the
following is an actual error message in an app here.  Of course, the
error
is never supposed to occur -- so says the programmer when I asked about
it.

SERROR_MESSAGE := 'How did I Get Here? Where is my car? Who is that
laying
next to me? Oh my God is that a marriage license?!';

Just in case you developers out there have any creative urges.
-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).

RE: Re: Passwords and authentication

[Scott . Shafer]

"HIPAA Auditing for Oracle Database Security"  Nice.

Well, Arup, Get to publishing!

;-)

--Scott


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/19/03 3:19 PM


http://www.dba-oracle.com/bp/bp_titles.htm

Look about in the middle of the page.

> -Original Message-
> what will be the name of your book? when will it be out? you 
> have an extract of what it will cover yet? 
-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).

RE: World premier performance of the BAARF party logo

[Scott . Shafer]

And the satanic "redeye" is a nice effect for a dba.  Could this be the
start of oracle pr0n?


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/12/03 6:19 PM

Hey, 

Who cares about that RAID thing.  Whose the cutie in the pictures -
hehe. 

-Original Message- 
 ] 
Sent: Thursday, June 12, 2003 2:50 PM 
To: Multiple recipients of list ORACLE-L 


Here are pics if interested. 

http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_1.jpg
  
http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_2.jpg
  

I too do not understand why vendors push RAID 5 when 
RAID 10 is clearly more profitable.  I speculate that they 
may be afraid of being accused of overselling when 
PHB's discover the RAID 10's they just purchased could 
have been RAID 5's for less money. 


Jared 





"Niall Litchfield" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 
 06/12/2003 10:04 AM 
 Please respond to ORACLE-L 

  
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]> 
cc: 
Subject:RE: World premier performance of the BAARF party
logo 


Jared writes 
> At the meeting last week I wore my 'No RAID 5' hat. 
> 
> Those of you at IOUG 99 in Denver may have seen it, I 
> wore it every day there.  ;) 

I'm curious now. Pictures required. 

Meanwhile I have never understood why storage vendors would prefer 
selling RAID5 over RAID10. More disks=more profit surely? Also 10 > 5 
therefore self evidently twice as good for all applications. Meanwhile 
we have this strange situation where performance consultants are 
publicising the fact that you have less need for performance consultants

with RAID10 than with RAID5. 

Niall 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
  
-- 
Author: Niall Litchfield 
  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 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). 



-- 
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-- Mailing list and web hosting services 
- 
To REMOVE 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). 

-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).

RE: Anyone installed Oracle 9.2 RAC on solaris 9

[Scott]

Matt, Actually the Oracle note is correct and
Veritas's note is incorrect. Veritas is aware of that
the note you mention is incorrect. I believe the
problem is the 4 nodes where not supported until
Veritas released Maintenance Pack 1 (MP1) last
December. Veritas has also indicated to me that they
have successrully tested a 8 and 16 node Veritas
cluster with 9i RAC and they are working with Oracle
to get this certified.

So, yes Veritas DBE/AC 3.5 is currently supported up
to 4 nodes with MP1 installed.

Scott


--- Matthew Zito <[EMAIL PROTECTED]> wrote:
>  
> Pete's absolutely right - I didn't mean to give the
> impression that it
> was entirely Oracle's nefarious doings to conspire
> to prevent people
> from running RAC on their lovely Sun enterprise
> servers.   It's just the
> combination of factors that are involved in these
> type of configurations
> where you have multiple vendors, each with highly
> critical components
> they're responsible for having to agree on something
> they're all happy
> with.  So, in this particular example, its Veritas
> that dictates the use
> of EMC or HDS storage, not Oracle.  I bet you could
> run Veritas AC on
> any storage that supports SCSI-3 persistent
> reservation and it would
> work at least reasonably well.  The problem is, what
> happens when you
> have a problem and call Veritas?
>  
> This sort of comes back to the classic question: is
> the "supported" or
> "certified" configuration always the "right" and
> "only" configuration?
> It varies wildly by company.  In the storage space,
> it runs from one
> extreme - Netapp, which I have never ever heard say
> that a config was
> unsupported when there was a problem to be solved,
> to the other extreme
> - EMC (who I used to work for), who has a multi-meg
> PDF describing every
> single supported config down to things like
> patchlevels of cluster
> software.  The flip side, of course, is that there's
> a certain
> confidence you're supposed to be able to have when
> you're running a
> "certified" configuration. 
>  
> With regards to RAC on Sun, there's a Metalink doc
> that lays out the
> compatible technologies (and as I look at it now, I
> see that the oracle
> docs claim 4 nodes on veritas AC 3.5 and the veritas
> release notes say 2
> - interesting), and they're pretty explicit about
> the technologies that
> are certified.  There's actually more options for
> Sun than for Linux -
> two cluster products instead of one on Linux.  It's
> just that the cost
> and complexity of the Sun clustering options,
> coupled with the higher
> cost for Sun servers, seems to outweight the
> benefits.  Like Pete said,
> RAC is mostly not about HA - I would argue its about
> getting
> cost-effective scalability and performance out of
> databases
> traditionally run on more expensive/larger
> monolithic SMP machines.
>  
> Pete's also right about raw - its really not _that_
> bad.  I just prefer,
> as it seems most people do, filesystem semantics for
> management.  My
> full preference is actually for NAS, but that's just
> the stingy person
> in me not wanting to shell out the money for fibre
> channel ports. 
>  
> Thanks,
> Matt
> --
> Matthew Zito
> GridApp Systems
> Email: [EMAIL PROTECTED]
> Cell: 646-220-3551
> Phone: 212-358-8211 x 359 
> -Original Message-
> Pete Sharman
> Sent: Thursday, June 05, 2003 3:01 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> From an Oracle perspective, we're fairly agnostic
> about the cluster RAC
> runs on.  There was a major change in the
> certification some time back
> where we no longer certify the hardware.  If it's a
> cluster that's
> supported by the OS vendor, then RAC should work on
> it (and if it
> doesn't then a bug needs to be logged).  Here's a
> couple of comments
> from my personal perspective though (SELECT
> standard_disclaimer FROM
> company_requirements;) - none specifically aimed at
> you personally:
>  
> 1.I always find it difficult to
> see why people have
> so much difficulty with raw.  I mean, really, come
> on guys.  If raw is
> too hard, then how are you gonna cope with all the
> other requirements of
> HA (not just the Oracle ones but all the other
> things like solid change
> management and so on)?
> 2.   The problems with the Sun CFS
> aren't so much with
> the support of it as they are with the fact that the
> performance of the
> Sun CFS isn't good enough yet.  CFS's are fine if
>

Re: Anyone installed Oracle 9.2 RAC on solaris 9

[Scott]

Lizz,

Here are a couple of things you will need if you want
to implement RAC on Solaris 9 with Veritas DBE/AC 3.5.

Veritas only certifies Storage arrays that support
SCSI-III persistent reservations so that leaves
XIOtech out as the storage array using Veritas DBE/AC
3.5.

If you use Solaris 9 and Veritas DBE/AC 3.5 you will
have to use update 3 or apply a patch (which I am not
sure of at this time) to fix a problem with the
/dev/sd driver and SCSI-III persistent reservations.

Hope this helps,

Scott

--- laura pena <[EMAIL PROTECTED]> wrote:
> We have been given the funding to install a
> production Oracle RAC environment. I am wondering if
> Solaris 9 has any bugs we should know about. 
>  
> Looks like we will be installing the following: 
> Oracle 9.2 (64-bit)RAC 
> Solaris 9 (64-bit)
>  
> Veritas DBE/AC version 3.5 - Veritas has a advanced
> cluster for Oracle9i Real Application software.
>  
> Our storag media is on a SAN solution using XIOtech
> and we will need to order an HBA. 
>  
>  
> Any information on bad ideas/gotchas would be most
> welcomed.
>  
> Many Thanks,
> -Lizz
>  
> 
> 
> -
> Do you Yahoo!?
> Free online calendar with sync to Outlook(TM).


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott
  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 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).

RE: cannot allocate new log

[Scott Stefick]

Nuala,

It looks like the DB is waiting for you to manually archive the
logs.  Like Lisa suggested, could you do an archive log list from
the sqlplus prompt and post the results?  There are two steps in
setting up archiving.  You have to set the proper parameters in the
init.ora file, and then bring the db up in mount mode to start the
archiver before you open the database.  

-Scott





At 08:24 AM 6/2/03 -0800, you wrote:

Hi Denis,

Thanks for the quick reply,

We're not getting an oracle error no: This is the message in the alert
log
Mon Jun 02 08:19:19 2003
Thread 1 cannot allocate new log, sequence 711
All online logs needed archiving
  Current log# 2 seq# 710 mem# 0:
D:\ORACLE\ORADATA\GDA\GDA_21.LOG
  Current log# 2 seq# 710 mem# 1:
E:\ORACLE\ORADATA\GDA\GDA_22.LOG

The event log has a similar message.

Our database is in archivelogmode 
log_archive_start   = True

Space is not an issue on the drive - there's at least 10 gigs free.
Disk access and write permissions are ok as it seems to write some of
the
logs but then stops!
I checked this by doing an alter system switch logfile - to force a write
-
which was successful.

Any other suggestions are appreciated,

N.

:->-Original Message-
:->From: DENNIS WILLIAMS
[mailto:[EMAIL PROTECTED]]
:->Sent: 02 June 2003 15:37
:->To: '[EMAIL PROTECTED]'
:->Cc: '[EMAIL PROTECTED]'
:->Subject: RE: cannot allocate new log
:->
:->
:->Nuala - You didn't include your error number, so the 
:->following are some
:->guesses: Is your database in archivelogmode? Check the path 
:->to the archive
:->logs and make sure that drive hasn't filled. For the logs 
:->themselves, check
:->the paths and permissions.
:->
:->Dennis Williams
:->DBA, 80%OCP, 100% DBA
:->Lifetouch, Inc.
:->[EMAIL PROTECTED] 
:->
:->
:->-Original Message-
:->From: Nuala Cullen
[mailto:[EMAIL PROTECTED]]
:->Sent: Monday, June 02, 2003 9:20 AM
:->To: Multiple recipients of list ORACLE-L
:->Subject: cannot allocate new log
:->
:->
:->
:->Hi All,
:->
:->I keep getting a cannot allocate new log in the alert log. 
:->This freezes the
:->entire application and I am unable to connect to oracle in 
:->order to do a
:->statspack snap shot.
:->
:->This is an upgrade to Version 8.1.7.4 set up on a WK2000 
:->(NEW) Server with 2
:->gigs of memory.
:->
:->We are writing to 3 separate disks
:->
:->Our D&E drives are RAID 0+1. The log files (including 
:->application logs) are
:->written to these drives
:->The F drive is raid 5 - this is where our data resides. (No 
:->logs are written
:->to the F drive)
:->
:->Currently we have 4 groups of redo log files
:->
:-> group 1 
('d:\oracle\oradata\gda\gda_11.log',
:->  
'e:\oracle\oradata\gda\gda_12.log')    
:->size  20M reuse,
:-> group 2 
('d:\oracle\oradata\gda\gda_21.log',
:->  
'e:\oracle\oradata\gda\gda_22.log')    
:->size  20M reuse,
:-> group 3 
('d:\oracle\oradata\gda\gda_31.log',
:->  
'e:\oracle\oradata\gda\gda_32.log')    
:->size  20M reuse,
:-> group 4 
('d:\oracle\oradata\gda\gda_41.log',
:->  
'e:\oracle\oradata\gda\gda_42.log')    
:->size  20M reuse
:->
:->and we archive to e:\oracle\arc\gda
:->
:->These are our log settings from the init.ora
:->log_buffer 
= 131072 
:->log_checkpoint_interval
= 1
:->log_checkpoint_timeout 
= 0
:->
:->I have the performance monitor running the whole time and 
:->when this happens
:->the CPU, DISK QUE LENGTH all look normal.
:->I have read the archive files regarding this error but 
:->thought that the
:->above set-up was sufficient.
:->Can anybody *please* give me some idea of what other areas I 
:->should be
:->looking at in order to prevent the error from occurring.
:->Would writing smaller files help? Disk space is not an issue.
:->
:->Thanks - all advice appreciated,
:->
:->N.
:->(developer/part-time DBA)
:->
:->___
:->Nuala Cullen
:->Catlogic 
:->30 Park
Gate 
:->Milton Park
:->Abingdon
:->Oxfordshire
:->OX14 4SH
:->
:->Phone: +44 (0) 1235
838151
:->Fax:   
+44 (0) 1235 838160  
:->Direct Line: +44 (0) 1235 838147
:->___
:->
:->
:->


**
Scott Stefick
Systems / Oracle Certified DBA
Wm. Rainey Harper College
[EMAIL PROTECTED]
847.925.6130
**

RE: Importing Schema getting compilation errors on some

[Scott Stefick]

Rick,

I agree with having to celebrate, since I was able to accomplish my task
before I left for the weekend.  That's always a good thing. 
Have a good weekend as well and good luck with the weather and the
fishing.

-Scott


At 03:43 PM 4/4/03 -0800, you wrote:
Scott-
 
Wow - what a way to finish a
week, I actually got something right. I may have to celebrate - looks
like it's time to pull out my fly rod and attack some trout - if it
doesn't snow again tonight. ( The challenges of living in MT
)
 
Here's a picture for the rest
of the world to see - I love it here.
http://www.nps.gov/glac/whatsnew/cam2_mcdonald.htm
 
Have an excellent weekend
folks
 
Rick Weiss 
Helena, MT

-Original Message-
From: Scott Stefick
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, April 04, 2003 16:26
To: Multiple recipients of list ORACLE-L
Subject: RE: Importing Schema getting compilation errors on
some


To answer the previous questions:


1. No (That was the problem)
2. Yes
3. Yes


Thanks so much.  It's working now.  granted execute on
dbms_office to famis and that did it.  


Maybe it's the fact that I'm a newbie, but I assumed the grants would
come over with the import.  I think I understand what happened
now.  The grants on the objects that "famis" owns come
over with the import, not any of the grants for objects outside of that
schema.  I think about it now and I'm like "Damn that makes
total sense!"  I don't know why I assumed that famis would get
the grants from all of the other objects, that "doesn't make sense
to me now".


Rick, if you're ever in the Chicago area, I'll have to buy you a beer
(or whatever you prefer).


Also, thanks to everyone who helped me.
Rick Weiss
Darrell Landrum
Stephane Faroult
Gary Kirsh
Charlie Mengler


Thanks!
-Scott










At 02:53 PM 4/4/03 -0800, you wrote:
Do you have execute privs set for MAILER.DBMS_OFFICE?? 
Does it exist on the second database??
Is the MAILER schema on the database?


(I'm climbing my ladder of thoughts as I'd check them)


Just a thought 


Rick Weiss
Helena, MT USA


-Original Message-
Sent: Friday, April 04, 2003 15:24
To: Multiple recipients of list ORACLE-L






Here is the output of the show errors command (which I didn't know
about... 
Thanks).


==
SQL> show errors trigger famis_pr_status_insert
Errors for TRIGGER FAMIS_PR_STATUS_INSERT:


LINE/COL ERROR

-
106/32   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be
declared
106/32   PL/SQL: Statement ignored
180/32   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be
declared
180/32   PL/SQL: Statement ignored
SQL>




SQL> show errors trigger famis_req_insert
Errors for TRIGGER FAMIS_REQ_INSERT:


LINE/COL ERROR

-
187/21   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be
declared
187/21   PL/SQL: Statement ignored
264/25   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be
declared
264/25   PL/SQL: Statement ignored
339/25   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be
declared
339/25   PL/SQL: Statement ignored
416/24   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be
declared
416/24   PL/SQL: Statement ignored
SQL>
=====


I'm guessing it's a problem with DBMS_OFFICE and not with the trigger
after 
seeing this.


-Scott






At 01:43 PM 4/4/03 -0800, you wrote:
>Scott, can you run this command in sqlplus and e-mail the results
out 
>to us...
>
>show errors trigger triggername
>
> >>> [EMAIL PROTECTED] 04/04/03 02:14PM
>>>
>Hello,
>
>Oracle 8.1.7.4
>HPUX 11.11
>App is Famis Maintenance Management System
>
>I have 3 instances TEST, TRAIN, PROD and I am trying to refresh
the 
>whole "famis" schema on TRAIN with the
"famis" schema on TEST.
>Every time I try to do the import, I get compilation errors for
4
>triggers
>(out of 75).  I tried to re-compile them in the TRAIN
instance after
>the
>import and get the same compilation errors.  I try to
re-compile them
>in
>TEST which is where they came from and they compile without a
problem.
>  I
>don't understand why this would happen when I exported the whole
schema
>
>from TEST and imported the whole .dmp file into TRAIN.
>
>Any Thoughts?
>
>-Scott
>
>
>**
>Scott Stefick
>Systems / Oracle Certified DBA
>Wm. Rainey Harper College
>847.925.6130
>**
>--
>Please see the official ORACLE-L FAQ:
http://www.orafaq.net
>--
>Author: Scott Stefick
>   INET

RE: Importing Schema getting compilation errors on some

[Scott Stefick]

To answer the previous questions:

1. No (That was the problem)
2. Yes
3. Yes

Thanks so much.  It's working now.  granted execute on
dbms_office to famis and that did it.  

Maybe it's the fact that I'm a newbie, but I assumed the grants would
come over with the import.  I think I understand what happened
now.  The grants on the objects that "famis" owns come
over with the import, not any of the grants for objects outside of that
schema.  I think about it now and I'm like "Damn that makes
total sense!"  I don't know why I assumed that famis would get
the grants from all of the other objects, that "doesn't make sense
to me now".

Rick, if you're ever in the Chicago area, I'll have to buy you a beer (or
whatever you prefer).

Also, thanks to everyone who helped me.
Rick Weiss
Darrell Landrum
Stephane Faroult
Gary Kirsh
Charlie Mengler

Thanks!
-Scott





At 02:53 PM 4/4/03 -0800, you wrote:
Do you have execute privs set for
MAILER.DBMS_OFFICE?? 
Does it exist on the second database??
Is the MAILER schema on the database?

(I'm climbing my ladder of thoughts as I'd check them)

Just a thought 

Rick Weiss
Helena, MT USA

-Original Message-
Sent: Friday, April 04, 2003 15:24
To: Multiple recipients of list ORACLE-L



Here is the output of the show errors command (which I didn't know
about... 
Thanks).

==
SQL> show errors trigger famis_pr_status_insert
Errors for TRIGGER FAMIS_PR_STATUS_INSERT:

LINE/COL ERROR

-
106/32   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be
declared
106/32   PL/SQL: Statement ignored
180/32   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be
declared
180/32   PL/SQL: Statement ignored
SQL>


SQL> show errors trigger famis_req_insert
Errors for TRIGGER FAMIS_REQ_INSERT:

LINE/COL ERROR

-
187/21   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be
declared
187/21   PL/SQL: Statement ignored
264/25   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be
declared
264/25   PL/SQL: Statement ignored
339/25   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be
declared
339/25   PL/SQL: Statement ignored
416/24   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be
declared
416/24   PL/SQL: Statement ignored
SQL>
=========

I'm guessing it's a problem with DBMS_OFFICE and not with the trigger
after 
seeing this.

-Scott



At 01:43 PM 4/4/03 -0800, you wrote:
>Scott, can you run this command in sqlplus and e-mail the results out

>to us...
>
>show errors trigger triggername
>
> >>> [EMAIL PROTECTED] 04/04/03 02:14PM
>>>
>Hello,
>
>Oracle 8.1.7.4
>HPUX 11.11
>App is Famis Maintenance Management System
>
>I have 3 instances TEST, TRAIN, PROD and I am trying to refresh the

>whole "famis" schema on TRAIN with the "famis"
schema on TEST.
>Every time I try to do the import, I get compilation errors for
4
>triggers
>(out of 75).  I tried to re-compile them in the TRAIN instance
after
>the
>import and get the same compilation errors.  I try to re-compile
them
>in
>TEST which is where they came from and they compile without a
problem.
>  I
>don't understand why this would happen when I exported the whole
schema
>
>from TEST and imported the whole .dmp file into TRAIN.
>
>Any Thoughts?
>
>-Scott
>
>
>**
>Scott Stefick
>Systems / Oracle Certified DBA
>Wm. Rainey Harper College
>847.925.6130
>**
>--
>Please see the official ORACLE-L FAQ:
http://www.orafaq.net
>--
>Author: Scott Stefick
>   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 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).
>
>--
>Please see the official ORACLE-L FAQ:
http://www.orafaq.net
>--
>Author: Darrell Landrum
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- 858-538-5051
http://www.fatcity.com
>San Diego, California    --
Mailing list and web hosting services
>

RE: Importing Schema getting compilation errors on some

[Scott Stefick]

No, both instances were built the same way and they both worked before 
this.  I noticed that when I did a "show errors trigger trigger_name"
I saw:
=
106/32 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared
106/32 PL/SQL: Statement ignored
=
I'm checking why this would have happened.  So far I've checked the 
synonyms and the dba_objects view and they look ok.

-Scott



At 01:59 PM 4/4/03 -0800, you wrote:
Scott:

My first thought is to ask if there are any external references (other
schemas, SYS packages, etc.) in the triggers that may not exist in TRAIN
that do exist in TEST
Rick Weiss

-Original Message-
Sent: Friday, April 04, 2003 13:14
To: Multiple recipients of list ORACLE-L
Hello,

Oracle 8.1.7.4
HPUX 11.11
App is Famis Maintenance Management System
I have 3 instances TEST, TRAIN, PROD and I am trying to refresh the whole
"famis" schema on TRAIN with the "famis" schema on TEST.
Every time I try to do the import, I get compilation errors for 4 triggers
(out of 75).  I tried to re-compile them in the TRAIN instance after the
import and get the same compilation errors.  I try to re-compile them in
TEST which is where they came from and they compile without a problem.   I
don't understand why this would happen when I exported the whole schema
from TEST and imported the whole .dmp file into TRAIN.
Any Thoughts?

-Scott

**
Scott Stefick
Systems / Oracle Certified DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
  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 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Weiss, Rick
  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 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).


**
Scott Stefick
Systems / Oracle Certified DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

Re: Importing Schema getting compilation errors on some

[Scott Stefick]

Here is the output of the show errors command (which I didn't know about... 
Thanks).

==
SQL> show errors trigger famis_pr_status_insert
Errors for TRIGGER FAMIS_PR_STATUS_INSERT:
LINE/COL ERROR
 -
106/32   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared
106/32   PL/SQL: Statement ignored
180/32   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared
180/32   PL/SQL: Statement ignored
SQL>
SQL> show errors trigger famis_req_insert
Errors for TRIGGER FAMIS_REQ_INSERT:
LINE/COL ERROR
 -
187/21   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared
187/21   PL/SQL: Statement ignored
264/25   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared
264/25   PL/SQL: Statement ignored
339/25   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared
339/25   PL/SQL: Statement ignored
416/24   PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared
416/24   PL/SQL: Statement ignored
SQL>
=
I'm guessing it's a problem with DBMS_OFFICE and not with the trigger after 
seeing this.

-Scott



At 01:43 PM 4/4/03 -0800, you wrote:
Scott, can you run this command in sqlplus and e-mail the results out to
us...
show errors trigger triggername

>>> [EMAIL PROTECTED] 04/04/03 02:14PM >>>
Hello,
Oracle 8.1.7.4
HPUX 11.11
App is Famis Maintenance Management System
I have 3 instances TEST, TRAIN, PROD and I am trying to refresh the
whole
"famis" schema on TRAIN with the "famis" schema on TEST.
Every time I try to do the import, I get compilation errors for 4
triggers
(out of 75).  I tried to re-compile them in the TRAIN instance after
the
import and get the same compilation errors.  I try to re-compile them
in
TEST which is where they came from and they compile without a problem.
 I
don't understand why this would happen when I exported the whole schema
from TEST and imported the whole .dmp file into TRAIN.

Any Thoughts?

-Scott

**
Scott Stefick
Systems / Oracle Certified DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
  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 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Darrell Landrum
  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 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).


**
Scott Stefick
Systems / Oracle Certified DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

Importing Schema getting compilation errors on some triggers

[Scott Stefick]

Hello,

Oracle 8.1.7.4
HPUX 11.11
App is Famis Maintenance Management System
I have 3 instances TEST, TRAIN, PROD and I am trying to refresh the whole 
"famis" schema on TRAIN with the "famis" schema on TEST.
Every time I try to do the import, I get compilation errors for 4 triggers 
(out of 75).  I tried to re-compile them in the TRAIN instance after the 
import and get the same compilation errors.  I try to re-compile them in 
TEST which is where they came from and they compile without a problem.   I 
don't understand why this would happen when I exported the whole schema 
from TEST and imported the whole .dmp file into TRAIN.

Any Thoughts?

-Scott

******
Scott Stefick
Systems / Oracle Certified DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

Re: SunCluster 3. 0 Veritas File system RAC

[Scott]

Vladimir,

You can either use Sun Cluster 3.0 using raw devices
only with Veritas's Cluster Volume manager to manage
the devices.

or

You can use Veritas's DBE/AC 3.5 edition and use the
Veritas Cluster manager and Cluster File Systems
(includes Cluster Volume Manager by Default) or raw
devices.

You can't Veritas's CFS on SC3.0.

Hope this helps,

Scott



--- Vladimir Barac <[EMAIL PROTECTED]> wrote:
> Anyone using this configuration?
> 
> Since I would like to avoid raw partitions, I was
> thinking of recomending Veritas File system...
> 
> Is it certified / working? Anyone working with such
> combo?
> 
> I will fire metalink page soon, but would like to
> have some input from listers!
> 
> Thanks,
> Vladimir Barac


__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott
  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 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).

Re: Sun HA Monitoring and Oracle 9

[Scott Canaan]

Barb,
    This isn't an Oracle limitation.  It's a Sun HA limitation.  Oracle 9i
will run on Sun Solaris HA 2.2, with no problem.  We've installed it and
built an instance and run it.  The problem comes in when you want to HA monitor
the database.  HA 2.2 won't even run when it gets to the Oracle 9i instance.
 The problem is so bad that the program just exits as soon as it hits that
instance, so it ends up not monitoring anything, not even the 8i instances.
    Our SA called Sun and was told that HA 2.2 only works with Oracle through
8i.  If we want to use it with Oracle 9i, then we have to buy HA 3.0 (it's
not an upgrade, they consider it a new product).  They did say that HA 3.0
will support Oracle 8i and 9i, but nothing before Oracle 8i.  Unfortunately,
the changeover means that we would have to do a complete rebuild of the Sun
Cluster, which is not possible.  We can't have that much downtime (about
1 week).  If we get the funding, our plan is to buy 2 more Sun machines,
build a 2-node cluster with HA 3.0, migrate the applications to that cluster,
then bring 2 of the original Sun machines into that cluster, making it a
4-node cluster again.

Barbara Baker wrote:

  Scott (or anyone runing HA 2.2 wishing to upgrade to
9i):  I noticed you did not receive a response from
this message a couple of months back.

We're in same situation (Sun Cluster 2.2, wishing to
upgrade to Oracle 9i).  It's not clear from the Oracle
certification matrix if this is supported.  (Clearly
not supported if you're running RAC, but we're not)
We're not convinced we want to upgrade to Sun cluster
3.0 (and certainly not clear we want to pay for it.)

I'm wondering if there are others with this
configuration, and if so what you decided to do.
Thanks in advance for any information.

Barb



  
  
-Original Message-
Sent: Monday, January 06, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L


Here's a little background.  We are currently
running Oracle
8.1.6.0, 8.1.7.0, and 8.1.7.4 on a Sun cluster.  We
use HA monitoring
for failover, in case there is a problem with any of
the nodes.  The
version of HA is 2.2.  We installed Oracle 9.2.0.1
on the cluster and
created a new database using it.  When the SA tried
to start the HA
monitoring, it wouldn't run.  We ended up recreating
the database in
8.1.7.4.  When the SA contacted Sun, he was told
that HA version 2.2
only supports up to Oracle 8.1.7.  In order to
monitor Oracle 9, we had
to buy (not upgrade to) HA 3.0, which would require
a rebuild of the
entire cluster.

Has anyone else run into this problem?  If so,
what have you done to
get around it?  Let me know if I forgot any
important piece of
information.

Thank you.

--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it
depends on what you put
into it." - Tom Lehrer.


  
  

__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://platinum.yahoo.com
  


-- 
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.

Where to set LD_LIBRARY_PATH in Database for 3rd Party Utilities

[Scott Graves]

I hope someone on the list can help.

 

Environment:

    Oracle
9.2.0.1

    Red Hat Linux

 

I’m in the process of trying to connect to a Progress database via Java
Stored Procedures in Oracle 9.2.0.1. 
The Progress JDBC driver is a type 2 driver, which means that it has shared
libraries that it must access.  

 

The java test code works outside of the database.  The connection to the Progress database
is successful.  The library path
for the Progress JDBC driver was added to the LD_LIBRARY_PATH variable.

 

The Progress JDBC driver was loaded into the database via the loadjava
utility.  When I run the test
program though the database, I get an error indicating that the library files
could not be found.  The Oracle
user’s profile has the additions to the LD_LIBRARY_PATH for the Progress JDBC
driver, but this didn’t help.

 

I was able to find one forum note on Metalink where someone got this to
work, but no details.  Where should
I set the LD_LIBRARY_PATH variable for the database to be able to find this 3rd
party library files?  Any ideas
would be appreciated.   As you
can probably tell, I’m new to Unix/Linux.

 

 

Thanks in Advance,

 

Scott Graves

Sr. Systems Programmer

NISC RDQ-STP

Email: [EMAIL PROTECTED]

Phone: 636-922-9122 x7616

Fax: 636-922-2080

 

RE: Oracle Job Task Analysis

[Scott]

John, That is a good question. What is the purpose of
this task Analysis?

I am trying to see what most DBA's perceive as what is
the most important things to learn so you can manage
an Oracle Database.

An example would be Learning Oracle Architecture. If
you are a small, medium or large company, Architecture
is probably the most important.

Within the Oracle Architecture what is the most
important for me to learn to job.

Learning the SGA structures and how to size them.
Learning the physical structures of the database and
how to manage them.

So if you wanted to be a DBA with Oracle what major
Oracle components do think you need know to accomplish
that job and what sub-components are important?

If I was a DBA in a company that does a lot of interne
t activity what do I need to know? If I run a 7X24
shop what do I need to know and so on.

Small, medium and Large companies will require a base
knowledge and as you get more niche you will need to
understand other components of Oracle. We also need to
look at what is niche. RAC is niche but becoming more
mainstream. What do I need to know to run a HA shop,
however Context, XML and Spatial are in the database,
while these are niche they are as common as RAC.

So what I am looking for is what people perceive to be
the most common components needed to do their Job.
Another interesting question is do I need to learn how
to create the database and other database objects
using manual methods or do I use DBCA and EM to do my
job. Is knowing the GUI sufficient for me to be a DBA?

These are why I am asking these questions. I really
want to know what you really need to know right down
to you only need to know it if you implement the
option.

Does this help?

Scott

--- "Hallas, John, Tech Dev"
<[EMAIL PROTECTED]> wrote:
> Scott,
> Is this job task analysis menat to be specific to
> what you do/ will do at your current site or to
> cover general activities thta a DBA may come across.
> 
> If it is the first option it appears that you are
> covering almost every Oracle feature available so
> you must be very busy.
> If it is the second option then I suspect very few
> DBAs could honestly say that they have worked and
> know well every task on the list and indeed would
> not get chance to use them all at any one site.
> 
> However a key word in the list is *understand*. That
> means different things to different people. These
> could be grouped by
> 1) Deeply understand , have used extensively, raised
> bugs on the product etc
> 2) Have read up on and not all about in principle
> and would expect to implement with no great
> difficulty
> 3) Have heard of and not much else
> 4) Those who can talk bulls* and are at stage 3 but
> are at level 1 at the CV stage.
> 
> Overall I think I am asking 'what is the purpose of
> this task list'
> 
> John
> 
> -Original Message-
> Sent: 01 April 2003 22:14
> To: Multiple recipients of list ORACLE-L
> 
> 
> I am putting together a prelimanary job task
> analysis
> for Oracle DBA's and would like some input from you
> hardworking DBA's on this list.
> 
> Here is what I have so far for core competencies and
> I
> would like to add or subtract from this list based
> on
> your input. 
> 
> A. Oracle Architecture And Options
> B. Security and Network Access
> C. Application Design and Modelling
> D. Backup And Recovery
> E. Software Maintenance And Operation
> F. SEGMENT and DATA MANAGEMENT
> G. Tuning And Troubleshooting
> 
> My Recommendations for slightly more advanced
> competencies that are still quite important
> For many installations.
> 
> H. Scalability
> I. High Availability
> J. Business Intelligence
> 
> Here is what I have as sub-components for the core
> competencies.
> 
> A.  ORACLE ARCHITECTURE AND OPTIONS 
>  
>  
> 1.  Demonstrate an understanding of memory
> structures
> and processes which make up an Oracle instance
> 2.  Demonstrate an understanding of the logical and
> physical structures associated with an Oracle
> database
> 3.  Demonstrate an understanding of PL/SQL
> constructs
> (triggers, functions, packages, procedures) and
> their
> processing
> 4.  Demonstrate an understanding of distributed
> architecture and client server and 3 tier
> architectures
> 5.  Demonstrate an understanding of Oracle
> Globalisation
> 
> 
> 
> 
> B.  SECURITY and NETWORK ACCESS
> 1.  Create, alter, and drop database users
> 2.  Develop and implement a strategy for managing
> security  using roles, privileges, authentication,
> 3. Demonstrate an Appreciation of  implementing row
> level security using Application Contexts and Fine
> Grain access control
> 4. Demonstrate an Appr

Oracle Job Task Analysis

[Scott]

nstrate an appreciation of parallel execution
(Parallel Query,DML, DDL, and Recovery)
4. Understand  Scaleup using Oracle Net Connection
Pooling, Connecton Multiplexing 


I. HIGH AVAILABILITY
1.  Demonstrate an appreciation of Real Application
Clusters Architecture High availability capabilities
Including RAC Guard
2. Understand Connect time Failover and Load Balancing
3. Understand Transparent Application Failover
4. Understand Data Guard Architecture and Physical and
Logical Standby Databases
5. Understand Replication using Advanced Replication
and Oracle Streams



J. BUSINESS INTELLIGENCE
1. Understand and Use Oracles Extranction,
Transformation, and Load facilities including External
Tables, and  Incremental Change Data Capture
2. Understand the use of Star Schemas, Bitmap Indexes
and Bitmap Join Indexes
3. Understand Summary Management using Materialised
Views, and Oracle Dimensions for Realtional OLAP
processing
4. Understand Oracles implementation of Analytic
Workspaces for Multidimensional OLAP processing

Thanks in advance for your help,

Scott



__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott
  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 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).

Re: alert log file

[Scott Stefick]

If you move the alert log to another directory, Oracle will create a new
one in its place.  There is no need to bounce the DB.

-Scott


At 07:54 AM 3/31/03 -0800, you wrote:
for  one of the
db over here  alert log is biggg .Looks like its never been
truncated or backup .
Is it a problem if i just move this alert log file to another directory ,
will oracle create a new alert log file ?
Do I need to bounce db ?
 
btw its 8.1.6 ( hp-ux )
-ak
 

**
Scott Stefick
Systems / Oracle Certified DBA
Wm. Rainey Harper College
847.925.6130
**

Re: Hotsos Clinic 101 Feedback

[Scott Stefick]

I haven't taken it yet, but I am signed up for the Chicago Clinic on April 
8-10Can't Wait!  I've heard really good things about it.

At 08:04 AM 3/26/03 -0800, you wrote:
Anybody take this course before.  Any comments, good or bad.  Thanks

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy Rahmlow
  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 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).


******
Scott Stefick
Oracle Certified DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

Test

[Scott Stefick]

This is a test, I have not received any messages in the last couple of days.

-Scott

**
Scott Stefick
Oracle Certified DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

Urgent - ORA-03001 Error While creating BLOB in 9.0.1 ?!

[Scott Nealy]

Guys,

CREATE TABLE "NAO"."MSG" ( 
"MEMNO" NUMBER(10, 0), 
"PROFNO" NUMBER(10, 0), 
"NAME" VARCHAR2(20), 
"AGE" VARCHAR2(10), 
"SEX" NUMBER(1, 0), 
"JANLNO" NUMBER(5, 0), 
"SUBJECT" VARCHAR2(50), 
"CONTENT" VARCHAR2(500), 
"DELFLAG" NUMBER(1, 0) DEFAULT 0, 
"POSTDATE" DATE DEFAULT SYSDATE, 
"EXPDATE" DATE, 
"POSTNO" NUMBER(10, 0), 
"REFCNT" NUMBER(5, 0) DEFAULT 0, 
"PREF" VARCHAR2(10), 
"AREA" NUMBER(2, 0), 
"SBSTCNT" NUMBER(5, 0) DEFAULT 0, 
"SENDFLG" NUMBER(1, 0) DEFAULT 0, 
"REPLYCNT" NUMBER(5, 0) DEFAULT 0, 
"CHKFLG" NUMBER(1, 0) DEFAULT 0, 
"ENTPC" VARCHAR2(10), 
"STOPFLG" NUMBER(5, 0) DEFAULT 0, 
"PARENT" NUMBER(10, 0), 
"PIC" BLOB, 
"PICUPFLG" NUMBER(1, 0) DEFAULT 0
) TABLESPACE "CANDY03"

When i create this table on machine A,i get the error below:
ORA-03001: unimplemented feature

if i remove the BLOB column from the SQL , it works fine on machine A.

whereas,
this works on another machine B with the same o/s and oracle set up.

i wonder why ?

Can you let me know the reason ?




_____
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Nealy
  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 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).

Re: Thanx: how to get metalink user name

[Scott Nealy]

Thanx guys.
my next call is to Oracle Customer Support.



_
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Nealy
  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 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).

Re: Thanx: how to get metalink user name

[Scott Nealy]

Thanx guys.
my next call is to Oracle Customer Support.



_
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Nealy
  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 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).

RE: RE: why SAN ? why not external storage ?

[Scott . Shafer]

All of the places I've worked its been sysadmins fat-fingering that has
hosed or cross mounted disks.  Then again, we've never had EMC...  HP arrays
are enough trouble.

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]
> Sent: Friday, March 14, 2003 12:36 PM
> To:   [EMAIL PROTECTED]; Multiple recipients of list
> ORACLE-L
> Subject:  Re:RE: why SAN ? why not external storage ?
> 
> Humm, must of missed this one on the rebound.  Anyway, here Disk space is
> an
> admin nightmare.  Each time we want to reassign disks from one server to
> another
> here comes EMC to re-program the Symmetrix array otherwise the SA has the
> possibility of assigning 2 servers to the same disk.  OOPS I really did
> not wnat
> to do a newfs on that disk!!!?!??!  And at $4000 per disk (72GB) I would
> not say
> that their cheap.  IDE drives have gotten real cheap, when will SCSI
> follow
> suit??
> 
> Dick Goulet
> 
> Reply Separator
> Subject:RE: why SAN ? why not external storage ?
> Author: [EMAIL PROTECTED]
> Date:   3/14/2003 10:03 AM
> 
> Oh, Gods forbid the sysadmins would have to  do their job...
> 
> HAHAHAHAHA!!!
> 
> Scott Shafer
> San Antonio, TX
> 210.581.6217
> 
> 
> > -Original Message-
> > From: Mogens Norgaard [SMTP:[EMAIL PROTECTED]
> > Sent: Thursday, March 13, 2003 5:25 PM
> > To:   Multiple recipients of list ORACLE-L
> > Subject:  Re: why SAN ? why not external storage ?
> > 
> > There are many things I don't get in this life. One of them is the 
> > statements about disk storage being an admin nightmare and way too 
> > expensive. Aren't disks very cheap these days?!
> > 
> > Mogens
> > 
> > [EMAIL PROTECTED] wrote:
> > 
> > >Rahul,
> > >
> > >This is personal opinion, but it looks to me like your concerned
> > about the
> > >database your creating for the client and may not have the total or
> > corporate
> > >wide view your client has.  We're heading down the SAN road not because
> > of any
> > >specific database requirements but because disk storage has become an
> > >administrative nightmare as well as way too expensive.
> > >
> > >Dick Goulet
> > >
> > >Reply Separator
> > >Author: "Arun Annamalai" <[EMAIL PROTECTED]>
> > >Date:   3/13/2003 12:24 PM
> > >
> > >Usaually SAN and NAS is used for several good reasons...the two main
> > are...
> > >1) High availability - When you have your database files on SAN/NAS
> then
> > you can
> > >bring ur database on another server when the primary goes down.
> Obviously
> > you
> > >have to use a cluster or Big IP (F5) on the front.
> > >2) reduce redundancy -A unix userid with home directory attached to a
> > paticular
> > >NFS drive on NAS/SAN, will  able to see all his files when he logs into
> > other
> > >servers.
> > >
> > >so far I heard "Net App" is low cost including with Raid 5.
> > >
> > >-Arun.
> > >Sr oracle dba
> > >  - Original Message - 
> > >  From: Rahul 
> > >  To: Multiple recipients of list ORACLE-L 
> > >  Sent: Wednesday, March 12, 2003 9:38 PM
> > >  Subject: Re: why SAN ? why not external storage ?
> > >
> > >
> > >  my reasons to recommend an external storage was..
> > >  1) the database size is 36GB, and according to many documents i have
> > read, SAN
> > >is not cost effevtive unless populated 
> > >  by a large numbers of drives !!, now for the client the cost is not
> the
> > >factor.. given the situation.. wouldnt a SAN be an overkill ? 
> > >
> > >  2) NO DBA or SYS ADMIN skills to manage the SAN !! 
> > >
> > >- Original Message - 
> > >From: Tim Gorman 
> > >To: Multiple recipients of list ORACLE-L 
> > >Sent: Wednesday, March 12, 2003 8:33 PM
> > >Subject: Re: why SAN ? why not external storage ?
> > >
> > >
> > >Can you share some of the reasons related to your decision in
> > choosing a
> > >direct-attach storage (DAS) instead of a SAN?  In general, a SAN is a
> > much
> > >smarter choice than DAS.
> > >  - Original Message - 
> > >  From: Rahul 
> > >  To: Multiple recipients of list ORACLE-L 
&g

RE: why SAN ? why not external storage ?

[Scott . Shafer]

Oh, Gods forbid the sysadmins would have to  do their job...

HAHAHAHAHA!!!

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: Mogens Nørgaard [SMTP:[EMAIL PROTECTED]
> Sent: Thursday, March 13, 2003 5:25 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: why SAN ? why not external storage ?
> 
> There are many things I don't get in this life. One of them is the 
> statements about disk storage being an admin nightmare and way too 
> expensive. Aren't disks very cheap these days?!
> 
> Mogens
> 
> [EMAIL PROTECTED] wrote:
> 
> >Rahul,
> >
> >This is personal opinion, but it looks to me like your concerned
> about the
> >database your creating for the client and may not have the total or
> corporate
> >wide view your client has.  We're heading down the SAN road not because
> of any
> >specific database requirements but because disk storage has become an
> >administrative nightmare as well as way too expensive.
> >
> >Dick Goulet
> >
> >Reply Separator
> >Author: "Arun Annamalai" <[EMAIL PROTECTED]>
> >Date:   3/13/2003 12:24 PM
> >
> >Usaually SAN and NAS is used for several good reasons...the two main
> are...
> >1) High availability - When you have your database files on SAN/NAS then
> you can
> >bring ur database on another server when the primary goes down. Obviously
> you
> >have to use a cluster or Big IP (F5) on the front.
> >2) reduce redundancy -A unix userid with home directory attached to a
> paticular
> >NFS drive on NAS/SAN, will  able to see all his files when he logs into
> other
> >servers.
> >
> >so far I heard "Net App" is low cost including with Raid 5.
> >
> >-Arun.
> >Sr oracle dba
> >  - Original Message - 
> >  From: Rahul 
> >  To: Multiple recipients of list ORACLE-L 
> >  Sent: Wednesday, March 12, 2003 9:38 PM
> >  Subject: Re: why SAN ? why not external storage ?
> >
> >
> >  my reasons to recommend an external storage was..
> >  1) the database size is 36GB, and according to many documents i have
> read, SAN
> >is not cost effevtive unless populated 
> >  by a large numbers of drives !!, now for the client the cost is not the
> >factor.. given the situation.. wouldnt a SAN be an overkill ? 
> >
> >  2) NO DBA or SYS ADMIN skills to manage the SAN !! 
> >
> >- Original Message - 
> >From: Tim Gorman 
> >To: Multiple recipients of list ORACLE-L 
> >Sent: Wednesday, March 12, 2003 8:33 PM
> >Subject: Re: why SAN ? why not external storage ?
> >
> >
> >Can you share some of the reasons related to your decision in
> choosing a
> >direct-attach storage (DAS) instead of a SAN?  In general, a SAN is a
> much
> >smarter choice than DAS.
> >  - Original Message - 
> >  From: Rahul 
> >  To: Multiple recipients of list ORACLE-L 
> >  Sent: Wednesday, March 12, 2003 1:33 AM
> >  Subject: why SAN ? why not external storage ?
> >
> >
> >  list, one of our clietns are going to by SAN, the current oracle
> databases
> >take around 
> >  36GB of storage i dnt understand there reason to go for SAN, i
> >sugguested to buy an external storage 
> >  box instead. How can i justify my desicion ? (cost of not the
> factor) 
> >
> >  TIA
> >  rahul
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >Usaually SAN and NAS is used for several
> good 
> >reasons...the two main are...
> >1) High availability - When you have your
> database 
> >files on SAN/NAS then you can bring ur database on another server when
> the 
> >primary goes down. Obviously you have to use a cluster or Big IP (F5) on
> the 
> >front.
> >2) reduce redundancy - face=Arial 
> >size=2>A unix userid with home directory attached to a
> paticular 
> >NFS drive on NAS/SAN, will  able to see all his files
> when 
> >he logs into other servers.
> > 
> >so far I heard "Net App" is low cost
> including with
> >
> >Raid 5.
> > 
> >-Arun.
> >Sr oracle dba
> > >style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
> BORDER-LEFT:
> >#00 2px solid; MARGIN-RIGHT: 0px">
> >  - Original Message - 
> >   >  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color:
> black">From: 
> > 

RE: DBV Cannot Load Module LIBDCE.A

[Scott Behrens]

Sam,
    I've never worked in a DCE environment, but here's a 
couple of
things to verify:
 
1.  If libdce.a is not installed in the first place, is your 
environment
using DCE?  I think this is an LPP (a separately licensed 
product)
from IBM for AIX.   Try the following from a unix prompt:
 
$ lslpp -L |grep -i dce
 
I think you should get hits like 
 
dce.client.rte.pthreads
 
If you don't, then I wonder why dbv thinks it needs it...
Try the following just to make sure you're running the dbv 
you think you are:
 
$ which dbv
 
It should return $ORACLE_HOME/bin/dbv, for example:
$ which dbv /u01/app/oracle/product/8.1.7/bin/dbv
If it returns the Oracle 'dbv', then you might check the
$ORACLE_HOME/rdbms/lib/sysliblist to see if it 
has an entry for libdce.  If so, the product was linked
at some point with the DCE Advanced Networking Option
(see MetaLink Note 1043700.6  
This doc notes the following:
 
NOTE: You may have to manually remove the library 
reference from "sysliblist".  In Oracle 7.3.4, the Installer 
did not remove the library reference  during a deinstallation.) 

 
In any case, I would be slow to add PTFs or relink or make 
other changes in a production environment just for the sake 
of dbv (if the rest of the environment is stable) until I had
a better understanding of the opsys environment and
the Oracle installation history.  
HTH,
  Scott
 
>>> [EMAIL PROTECTED] 3/12/03 5:15:58 PM 
>>>Hi all,First, thanks Jared for the info.The 
libdce.a file does not exist on any of our AIX servers.  It justAINT 
there!I typed libdce.a into google and from there downloaded PTF2,3, and 
4that are supposed contain DCE fixes to this file.  Instructions say 
torename the old file and replace it with this new file.  After 
the download, I was not able to uncompress the files on my 
XPworkstation.  So I ftp'd the file (in binary mode) to our AIX server 
andused uncompress to expand the files to libdce2.exe, 
libdce3.exe,libdce4.exe (originally the files were named libdce2.exe.Z, 
etc.).  The.exe extension confused me (I am told .exe is Windows only, 
not UNIX).  I ftp'd the files back to my workstation, and tried 
running it from DOS.I get an error message "Program too big to fit in 
memory".  However, theexe is only 217,856 bytes (not kilobytes).  
My next step was to ask myneighbour if he could unzip the original 
libdce2.exe.Z on his W2Kworkstation - he was successful!  However, he 
received the same messagewhen he attempted to run the resultant .exe on his 
workstation.  I am relatively new to UNIX (took a course, and did 
some reading, butnot much hands-on).  I am told by a more experience 
colleague that.exe's do not run on UNIX.  So now I am at a loss on what 
to try next.  Any ideas?Thanks,Sam 
BootsmaGeorge Brown College[EMAIL PROTECTED]416-415-5000 
x4933-Original Message-Sent: March 11, 2003 7:14 PMTo: 
Multiple recipients of list ORACLE-LJust found it:  on AIX ( 4.3 at 
least ) it's 
LIBPATH[EMAIL PROTECTED]Sent by: 
[EMAIL PROTECTED]03/11/2003 03:23 PMPlease respond to 
ORACLE-L    
To: Multiple recipients of list 
ORACLE-L<[EMAIL PROTECTED]>    
cc:     
Subject:    Re: DBV Cannot Load Module 
LIBDCE.AMake sure LD_LIBRARY_PATH includes /usr/lib.At 
least, I think it's LD_LIBRARY_PATH, been awhilesince doing anything on 
AIX.  In any case, libdce.ashould be in 
/usr/lib.JaredPS. Google is your 
friend"Sam Bootsma" 
<[EMAIL PROTECTED]>Sent by: [EMAIL PROTECTED]03/11/2003 01:44 
PMPlease respond to 
ORACLE-L    
To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>    
cc:     
Subject:    DBV Cannot Load Module 
LIBDCE.AWe are running Oracle 7.3.4.5.0 on an IBM/AIX RISC 
System/6000: Version 2.3.4.0.0. When I attempt to run DBV I get the 
following error messages$ dbv help=yexec(): 0509-036 Cannot load 
program dbv because of the 
followingerrors:    
0509-150   Dependent module libdce.a(shr.o) could not be 
loaded.    0509-022 Cannot load 
module libdce.a(shr.o).    0509-026 
System error: A file or directory in the path name doesnot 
exist.$I do not want to play around with a custom installation to 
try toinstall missing components because this is a production database 
and because Iam new here.  The regular DBA is on holidays and not 
available. I did a search for file "libdce" on the original CD for 
"Oracle7.3.4.0.0 for AIX based systems", but did not find it 
there.  I considered installing Oracle 7.3.4 on my workstation and 
ftp'ing the files over thenetwork to my workstation.  Then doing 
the database verify.  But total size of the data files is 25 GB, and 
this would unnecessarily clog upour network (even at night).Any 
ideas on how I can resolve the DBV problem not loading problem?  
Theshort answer is to find the module libdce.a file and any 
modulesdependent on this, but how do I do 
this?Thanks,Sam 
[EMAIL PROTECTED]

RE: POLL: Database to DBA ratio

[Scott . Shafer]

139 remote production servers/instances (30 are large to VLDB, the rest
small), 5 development instances, 1 9iAS test instance, 3 dba's.  Mostly
reporting with batch ETL jobs run nightly.

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: Robin Ilardi [SMTP:[EMAIL PROTECTED]
> Sent: Tuesday, March 11, 2003 12:10 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: POLL: Database to DBA ratio
> 
> I currently have 5 development databases and 1 "beta" production database
> that I administer, so that's 6:1, but I'm also the Sys Admin for these
> servers as well.   These are also very small databases.
> 
> robin
> 
> 
> -Original Message-
> Sent: Tuesday, March 11, 2003 11:44 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> We have 10 development databases that I support directly plus 5
> implementation/testing databases that I support as second level and one
> production snapshot datamart.
> 
> 16:1
> 
> However, there are also DBAs who support each project.  That would make
> the
> ratio closer to 4:1 or 3:1.
> 
> 
> 
> 
>   "Chuck Hamilton"
>recipients
> of list ORACLE-L <[EMAIL PROTECTED]>
>   @softhome.net>   cc:
>   Sent by: rootSubject: POLL: Database to
> DBA ratio
> 
> 
>   03/11/2003 09:59
>   AM
>   Please respond
>   to ORACLE-L
> 
> 
> 
> 
> 
> 
> I'm trying to build a case for management that we need additional DBAs so
> I'd like to take a quick poll if I may. What is the ratio of Oracle
> databases to DBAs in your shop? This includes development and production
> databases. At our shop it's 33:1.
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Chuck Hamilton
>   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 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).
> 
> 
> 
> 
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Thomas Day
>   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 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).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Robin Ilardi
>   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 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).
-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).

RE: Anyone looking fora Developer/DBA in Wash DC area?

[Scott Stefick]

/www.orafaq.net
--
Author: Sherman, Paul R.
  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 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).


**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

[Scott Stefick]

That's great!  Thanks a ton.

-Scott

At 10:44 AM 3/7/03 -0800, you wrote:
I'm pretty sure I only recieved a hard copy (I'm not in the office to 
check), but they publish a lot of pdf documents on their site.  I'll see 
if I can locate it there and send a URL.

>>> [EMAIL PROTECTED] 03/07/03 10:55AM >>>
Darrell,
Could I have a copy of that white paper if you still have it?

Thanks,
Scott
At 08:19 AM 3/7/03 -0800, you wrote:
>Amen!  For several years we heard from EMC reps, don't worry about it,
>don't worry about it, then recently we we're given a white paper from EMC
>on striping for Oracle.
>
>
> >>> [EMAIL PROTECTED] 03/07/03 09:43AM >>>
>SAN is fine as long as you keep track of what's mapping to what physical
>disks. I for one don't believe the SAN vendors that say their caching takes
>care of performance for you and you don't need to worry about where data is
>stored physically. Place datafiles the same way you would for local storage
>and you will do well - striped, with data, indexes, temp, and rollback
>physically separated.
>
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Thursday, March 06, 2003 4:39 PM
>
>
> > Hello,
> >
> > We are currently spec'ing out hardware for our new ERP system.  It is
> > either going to be Peoplesoft or Oracle.  We are also debating on using a
> > SAN rather than attached storage.  I'm just looking for any
> > positives/negatives/rules of thumb I should be aware of when running
>Oracle
> > on a SAN architecture provided that management goes that way.  The 
SAN box
> > we are looking at right now is the EVA3000 from HP (although this isn't a
> > definite) not sure if this matters.
> >
> > TIA,
> > -Scott Stefick
> >
> > **
> > Scott Stefick
> > UNIX Systems Administrator
> > Oracle Certified Professional DBA
> > Wm. Rainey Harper College
> > 847.925.6130
> > **
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Scott Stefick
> >   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 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).
> >
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Chuck Hamilton
>   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 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).
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Darrell Landrum
>   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 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).

**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
---

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

[Scott Stefick]

Darrell,

Could I have a copy of that white paper if you still have it?

Thanks,
Scott
At 08:19 AM 3/7/03 -0800, you wrote:
Amen!  For several years we heard from EMC reps, don't worry about it, 
don't worry about it, then recently we we're given a white paper from EMC 
on striping for Oracle.

>>> [EMAIL PROTECTED] 03/07/03 09:43AM >>>
SAN is fine as long as you keep track of what's mapping to what physical
disks. I for one don't believe the SAN vendors that say their caching takes
care of performance for you and you don't need to worry about where data is
stored physically. Place datafiles the same way you would for local storage
and you will do well - striped, with data, indexes, temp, and rollback
physically separated.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 06, 2003 4:39 PM
> Hello,
>
> We are currently spec'ing out hardware for our new ERP system.  It is
> either going to be Peoplesoft or Oracle.  We are also debating on using a
> SAN rather than attached storage.  I'm just looking for any
> positives/negatives/rules of thumb I should be aware of when running
Oracle
> on a SAN architecture provided that management goes that way.  The SAN box
> we are looking at right now is the EVA3000 from HP (although this isn't a
> definite) not sure if this matters.
>
> TIA,
> -Scott Stefick
>
> **
> Scott Stefick
> UNIX Systems Administrator
> Oracle Certified Professional DBA
> Wm. Rainey Harper College
> 847.925.6130
> **
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Scott Stefick
>   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 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
  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 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Darrell Landrum
  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 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).


**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

Oracle on a SAN.... Good, Bad or Proceed with caution?

[Scott Stefick]

Hello,

We are currently spec'ing out hardware for our new ERP system.  It is 
either going to be Peoplesoft or Oracle.  We are also debating on using a 
SAN rather than attached storage.  I'm just looking for any 
positives/negatives/rules of thumb I should be aware of when running Oracle 
on a SAN architecture provided that management goes that way.  The SAN box 
we are looking at right now is the EVA3000 from HP (although this isn't a 
definite) not sure if this matters.

TIA,
-Scott Stefick
**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

Re:

[Scott Stefick]

Anyone? ... Anyone?

At 11:50 AM 3/4/03 -0800, you wrote:
HELP

**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**

Import Problem

[Scott Canaan]

I ran into a problem yesterday afternoon.  I had exported a
production database, via a full database export, and ftp'd it to another
machine to import it there and make that the new production machine.  It
was a long import (about 8 hours) and about 2/3 through it, my network
connection was dropped.  I was running it in a ssh shell.  When the
connection disappeared, the import died.  Since I had to get the job
done by morning, I chose to drop the database, rebuild it, then
re-import.  That worked.
What I am wondering is:  Is there a way to resume an import, once it
has been interrupted?  I have been looking in metalink and on the net
and haven't found anything that says how to do it.  I tried technet, but
it was way too slow.  Any thoughts would be greatly appreciated.

Thank you,

--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Canaan
  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 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).

Re: Purely for your amusement

[Scott Behrens]

Thanks!   I especially liked:
 
TABLE...FULL OF 'WOE'
 
That seems to be how the day is going for several of 
us.
 Scott
>>> [EMAIL PROTECTED] 2/27/03 1:23:55 PM 
>>>And you thought your job was bad . . .(Yes, this IS a 
production 
job)--
 

   22   
21   TABLE ACCESS 
(FULL) OF 'WOE'

Re: UPDATE...REPLACE...'...apostrophe...

[Scott Canaan]

chr(44)
"Gorden-Ozgul, Patricia E" wrote:

I'm
running Oracle on Solaris 2.6.I
successfully inserted data from a composite file by replacing apostrophes
with ' by way of sed...s/'/\'/g...beforehand.Now
I need to perform an UPDATE, REPLACE...UPDATE
tbl SET col = REPLACE(col, ''', ...with what?)Please
advise.Pat 

-Original
Message-
From: Saira Somani [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 25,
2003 3:24 PM
To: Multiple recipients of
list ORACLE-L
Subject: RE: SQL struggle
 


Thank
you for your assistance - it works - and
I have one more question:




How
can I also get the SELECT to show me the original item number - i.e
with the '-OR'?



Thanks,

Saira



-Original
Message-
From:
Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
Sent:
February 25, 2003 1:57 PM
To:
'[EMAIL PROTECTED]'
Cc:
'[EMAIL PROTECTED]'
Subject:
RE: SQL struggle



(see
answer below)

>
-Original Message-
> From: Saira Somani [mailto:[EMAIL PROTECTED]]
> 
> Oracle 8.1.7 on AIX 4.3
> 
> Here is what my data
looks like in a table called item_w:
> 
> WHSE_CODE   
ITEM_NUM  
LAST_COST
>  --
--
> HL1 
111230  
1.12
> CPD-TWH 
111230-OR  
0
> CPD-TGH 
111230-OR  
0
> HL1 
50034
.91
> MSH-CDS 
50034  
0
> CPD-TGH 
50034-OR   
0
> HL1 
650300 
4.789
> TWH-STAT
650300 
0
> CPD-TWH 
650300-OR  
0
> CPD-TGH 
650300-OR  
0
> 
> If you'll notice, only
the items with WHSE_CODE='HL1' have a cost
> associated with them.
> 
> What I need to is:
> 
> Parse ITEM_NUM for those
items which have a suffix of -OR in order to
> compare with an ITEM_NUM
without -OR so that I can take the last cost
> from there and display
it beside the one that has -OR. Also 
> note, there
> are some $0 cost items
that don't have a suffix of -OR; I 
> would need to
> match those up with
a cost as well. 
> 
> So in the end, I suppose,
this is the result I'm looking for:
> 
> WHSE_CODE   
ITEM_NUM  LAST_COST  LAST_COST_REV
>  -
-  -
> HL1 
111230  
1.12  
1.12
> CPD-TWH 
111230-OR   
0 
1.12
> CPD-TGH 
111230-OR   
0 
1.12
> HL1 
50034   
0.91  
0.91
> MSH-CDS 
50034   
0 
0.91
> CPD-TGH 
50034-OR
0 
0.91
> HL1 
650300  
4.789 
4.789
> TWH-STAT
650300  
0 
4.789
> CPD-TWH 
650300-OR   
0 
4.789
> CPD-TGH 
650300-OR   
0 
>    4.789 
> 
> And if any of you
out there use Cognos Impromptu, perhaps you 
> could tell
> me how I can achieve
these results in a report.



Would
this work?
 select
    a.whse_code,
a.item_num, a.last_cost,
    b.last_cost
as last_cost_rev
 from
    item_w
a, item_w b
 where
    a.last_cost
= 0
    and
replace (a.item_num, '-OR') = b.item_num
    and
b.last_cost > 0
union
 select
    c.whse_code,
c.item_num, c.last_cost,
    c.last_cost
as last_cost_rev
 from
    item_w
c
 where
    c.last_cost
> 0 ;



--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
 

RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??

[Scott]

Greg, Sorry to be picky but you can still use raw
Devices with Veritas DBE/AC 3.5 if you don't want to
use thier CFS.

If you use SC then your only choice is raw and you
probably will need Veritas to manage you LVM's anyway.

Scott


--- "Loughmiller, Greg"
<[EMAIL PROTECTED]> wrote:
> news to me... Just had a conversation with several
> folks yesterday.. The
> requirements that we have been told are:
> 1. File systems-use veritas Cluster manager
> 2. Raw Devices - Gotta use the SUN Cluster 3.x
> 
> So I assume these guys would be on top of it since
> the mtg we had was this
> past week.. Our POC was with Veritas; and the
> options for implementation are
> listed above...
> 
> Hope this helps-and please, if you have confirmation
> otherwise-it would be
> very interesting info to obtain.
> 
> Thanks!
> Greg
> 
> -Original Message-
> Sent: Friday, February 21, 2003 11:16 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> I heard from ORACLe sales person "the ORACLE 9ir2
> RAC come with ORACLE
> cluster and we don't need SUN cluster".  I don't
> know is it true or NOT?
> anyone implement that?
> 
> Thanks.
> 
> 
> 
> 
>
_
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: dist cash
>   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 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).
> 


__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott
  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 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).

Re: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??

[Scott]

Your Oracle sales person is incorrect. I would ask him
to see if he can actually prove it. 

Oracle provides clustering components for Linux and NT
only at this time. Oracle does provide a RACpatch for
SC2.2 and 3.0 with 9iR2 and that patch needs to be
installed after you install SC and before install RAC.

Hope this helps,

Scott


--- dist cash <[EMAIL PROTECTED]> wrote:
> 
> I heard from ORACLe sales person "the ORACLE 9ir2
> RAC come with ORACLE
> cluster and we don't need SUN cluster".  I don't
> know is it true or NOT?
> anyone implement that?
> 
> Thanks.
> 
> 
> 
> 
>
_
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: dist cash
>   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 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).
> 


__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott
  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 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).

RE: Teradata baned from IOUG???

[Scott . Shafer]

Soon you too will be assimilated.  The TUSC Collective will add your
distinctiveness to its own.

--Seven of Nine-Hundred Ninety-Nine



> -Original Message-
> From: Daniel W. Fink [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, February 18, 2003 12:59 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Teradata baned from IOUG???
> 
> I know Stan Yellott is not a TUSC employee. He is the President of RMOUG
> and a great guy who has worked behind the scenes at many IOUG conferences.
> He is a tremendous calming influence (as many of us recall from San
> Diego).
> 
> I don't think Ian, Mark, Bill, Stephen or Steve are TUSC Employees, unless
> they have changed jobs recently.
> 
> Henry Poras wrote:
> 
> 
>   Anyone know if any of the 10 people running for the Board of
> Directors for
>   IOUG is a TUSC employee? Noone claims it in their statements.
>   
>   Henry
>   
>   
>   -Original Message-
>   Sent: Tuesday, February 18, 2003 12:24 PM
>   To: Multiple recipients of list ORACLE-L
>   
>   
>   me too...
>   
>   Igor Neyman, OCP DBA
>   [EMAIL PROTECTED] 
>   
>   
>   
>   - Original Message -
>   To: "Multiple recipients of list ORACLE-L"  <[EMAIL PROTECTED]>
> 
>   Sent: Tuesday, February 18, 2003 11:11 AM
>   
>   
> 
> 
>   evidently i'm not the only one who thinks that, interesting.
>   
>   joe
>   
>   
>   
> 
>   It seems to me that IOUG has become a wholly owned
>   subsidiary of TUSC.  TUSC in turn has an incestuous
>   relationship with Oracle.  All very cozy.
>   
>   No real complaint about the arrangements.  Someone
> has
>   to step up to the plate if IOUG is going to continue
>   to be a viable organization and in this economic
>   climate few can afford to do it.
>   
>   Should IOUG be able to survive without Oracle?
>   Probably.  Will it be able to survive without
> Oracle?
>   I doubt it.
>   
>   
>   --- Jonathan Lewis  <[EMAIL PROTECTED]>
> 
>   wrote:
> 
> 
>   It should be possible for the IOUG to live without
>   Oracle's support.  Obviously it would be better
>   for all concerned if there is some measure of
>   co-operation, and there's clearly no need for
>   bloody-minded conflict.  But if the IOUG just
>   keeps doing things that the users want, then
>   the users should be able to support it in the
>   complete absence of any input from Oracle.
>   
>   
>   Regards
>   
>   Jonathan Lewis
>   
>   
>   Coming soon one-day tutorials:
>   Cost Based Optimisation
>   Trouble-shooting and Tuning
>   Indexing Strategies
>   (see  
> )
>   
>   UK___March 19th
>   USA_(FL)_May 2nd
>   
>   
>   Next Seminar dates:
>   (see   )
>   
>   USA_(CA, TX)_August
>   
>   
>   The Co-operative Oracle Users' FAQ
>   
>   
>   
>   MacGregor, Ian A. wrote:
>   
> 
>   The IOUG cannot live without Oracle's support, but
> 
> 
>   Oracle can survive
>   without the IOUG.
>   
> 
>   --
>   Please see the official ORACLE-L FAQ:
>   
>   --
>   Author: Jonathan Lewis
> INET:  [EMAIL PROTECTED]
> 
>   
>   Fat City Network Services-- 858-538-5051
>   
>   Sa

Re: lsnrctl status

[Scott Stefick]

I do set the ORACLE_HOME and export the variable upon login.

What is the "ORACLE_HOME_SELECTOR"?





At 10:44 AM 2/19/03 -0800, you wrote:


You need to change your ORACLE_HOME for the 8.1.7.4 environment.  Look for
the ORACLE_HOME_SELECTOR.  Mine is under ORACLE_INSTALLED_PRODUCTS.





>
  Scott 
Stefick 

  
  @harpercollege.e cc: 
>
  du>  Subject: lsnrctl 
status
  Sent by: 
root 
>




  02/19/2003 
12:04 

  PM 

  Please 
respond 

  to 
ORACLE-L 









Hello all,

HPUX 11.11 Oracle 8174, 9201 and 9iAS 90201

I have all three versions in their own homes and I have a login script that

asks what I want the environment to be set as upon login (ORACLE_HOME,
ORACLE_SID, etc) but I always set
TNS_ADMIN=/u01/app/oracle/product/9201/network/admin for all three
environments.

When I do a $lsnrctl status while in the 9201 or 90201 environments, I see
all of the services.  But when I'm using the 8174 environment setup and do
the same, for the services, I get:

/*
Message 1411 not found;  product=network;  facility=TNS
   Message 1408 not found;  product=network;  facility=TNS
Message 1411 not found;  product=network;  facility=TNS
   Message 1408 not found;  product=network;  facility=TNS
Message 1411 not found;  product=network;  facility=TNS
   Message 1408 not found;  product=network;  facility=TNS
*/

Does anyone have any ideas why this could be happening?  I want to be able
to be in any one of the environments and see the services.

TIA,
-Scott


**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
  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 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).






--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Day
  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 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).



**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

RE: lsnrctl status

[Scott Stefick]

The ORACLE_HOME is being exported.
Here is the contents of the script that I call to set the 8174 environment 
upon login:

/*
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/817
ORACLE_SID=FPRD
LD_LIBRARY_PATH=$ORACLE_HOME/lib
TNS_ADMIN=/u01/app/oracle/product/9201/network/admin
export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH TNS_ADMIN
PATH=$ORACL_HOME/bin:$PATH
export PATH
*/

The 9i login environment script look the same except for:
ORACLE_HOME=u01/app/oracle/product/9201
ORACLE_SID=REGENTDB

Thanks,
Scott



At 11:24 AM 2/19/03 -0800, you wrote:
You forgot to export new ORACLE_HOME.

> -Original Message-
> From: Scott Stefick [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 19, 2003 12:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: lsnrctl status
>
>
> Hello all,
>
> HPUX 11.11 Oracle 8174, 9201 and 9iAS 90201
>
> I have all three versions in their own homes and I have a
> login script that
> asks what I want the environment to be set as upon login
> (ORACLE_HOME,
> ORACLE_SID, etc) but I always set
> TNS_ADMIN=/u01/app/oracle/product/9201/network/admin for all three
> environments.
>
> When I do a $lsnrctl status while in the 9201 or 90201
> environments, I see
> all of the services.  But when I'm using the 8174 environment
> setup and do
> the same, for the services, I get:
>
> /*
> Message 1411 not found;  product=network;  facility=TNS
>Message 1408 not found;  product=network;  facility=TNS
> Message 1411 not found;  product=network;  facility=TNS
>Message 1408 not found;  product=network;  facility=TNS
> Message 1411 not found;  product=network;  facility=TNS
>Message 1408 not found;  product=network;  facility=TNS
> */
>
> Does anyone have any ideas why this could be happening?  I
> want to be able
> to be in any one of the environments and see the services.
>
> TIA,
> -Scott
>
>
> **
> Scott Stefick
> UNIX Systems Administrator
> Oracle Certified Professional DBA
> Wm. Rainey Harper College
> 847.925.6130
> **
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Scott Stefick
>   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 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gogala, Mladen
  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 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).



**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

lsnrctl status

[Scott Stefick]

Hello all,

HPUX 11.11 Oracle 8174, 9201 and 9iAS 90201

I have all three versions in their own homes and I have a login script that 
asks what I want the environment to be set as upon login (ORACLE_HOME, 
ORACLE_SID, etc) but I always set 
TNS_ADMIN=/u01/app/oracle/product/9201/network/admin for all three 
environments.

When I do a $lsnrctl status while in the 9201 or 90201 environments, I see 
all of the services.  But when I'm using the 8174 environment setup and do 
the same, for the services, I get:

/*
Message 1411 not found;  product=network;  facility=TNS
  Message 1408 not found;  product=network;  facility=TNS
Message 1411 not found;  product=network;  facility=TNS
  Message 1408 not found;  product=network;  facility=TNS
Message 1411 not found;  product=network;  facility=TNS
  Message 1408 not found;  product=network;  facility=TNS
*/

Does anyone have any ideas why this could be happening?  I want to be able 
to be in any one of the environments and see the services.

TIA,
-Scott


**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

Re: Programming languages that make DBA's lives easier

[Scott Stefick]

I tend to agree here.  I would say:
1. PL/SQL
2. korn shell (or sh, bash, whatever you choose).
3. Perl

These are 3 necessities.

-Scott


At 09:59 AM 2/18/03 -0800, you wrote:


You need to know PL/SQL if you're going to be effective with Oracle.

Java is interesting, but not nearly as useful to a DBA as Perl.

Jared

On Tuesday 18 February 2003 08:56, Les Ayudo wrote:
> On top of learning Oracle, which programming languages would also benefit
> some1 learning Oracle?  Perl? Java?  How would these languages be used?


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description:

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
  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 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).



******
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

Re: Oracle 8i or 9i ?

[Scott Stefick]

 of going to school to get Oracle certified.
There
> >are
> > > > > > > 2 schools in my area that are offering Oracle certs but one
> >offers
> > > > > > > Oracle 8i courses w/ an upgrade to 9i, while the other offers
> >all
> > > > > > > 9i courses.  If i go to the schools who offers 9i courses,
would
> >I
> > > > > > > miss out on valuable 8i knowledge?  Which school should I
> >attend?
> > > > > > > The courses will last about 7 or 8 months.  Also, is this a
good
> > > > > > > "in demand" field to get into?  What chances am I looking at
to
> > > > > > > getting hired as a newbie DBA once I graduate?
> > > > > > >
> > > > > > > I want to get into the Ecommerce side of Oracle (connecting
DBs
> >to
> > > > > > > websites/portals?).  Which certification/path should I be
> > > > > > > following?  Thanks in advance!!
> > > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > > > <http://www.orafaq.net>
> > > > > > --
> > > > > > Author: Lyndon Tiu
> > > > > >   INET: [EMAIL PROTECTED]
> > > > > >
> > > > > > Fat City Network Services-- 858-538-5051
> >http://www.fatcity.com
> > > > > > <http://www.fatcity.com>
> > > > > > San Diego, California-- Mailing list and web hosting
> >services
> > > > >
> > > -
> > > > > > To REMOVE 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).
> > > > > >
> > > > > > --
> > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > > > --
> > > > > > Author: DENNIS WILLIAMS
> > > > > >   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 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).
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > > --
> > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > > --
> > > > > Author: Les Ayudo
> > > > >   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 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).
> > > > > --
> > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > > --
> > > > > Author: DENNIS WILLIAMS
> > > > >   INE

Re: URL for Oracle 9i entry level email lists

[Scott Stefick]

Les,

I definitely think its worth sticking around here.  I'm still
considered a newbie here and I've learned tons from everyones
posts.  It's a great group of people who really know their stuff and
as long as you do your basic research on your own (RTFM), most questions
are answered very sufficiently.  I've been extremely happy with this
list.  Not to mention you will get some really good tips on books
and websites to check out.  Oh yeah, and there are several authors
of some really good books on the list as well.  I've seen questions
from all levels of DBA's on this list, so don't give up if you really
want to work with Oracle.  

-Scott

At 08:44 AM 2/14/03 -0800, you wrote:
This list seems at
like it's a little too advanced for a beginner.  Do you think I
should just stick with it for a while to get familiar w/ some of the
Oracle stuff?

- Original Message - 
From: Jamadagni,
Rajendra 
To: Multiple recipients of
list ORACLE-L 
Sent: Friday, February 14, 2003 7:34 AM
Subject: RE: URL for Oracle 9i entry level email lists


This list deals with ALL oracle related issues ... so why you want
another one? 
Raj 
__

Rajendra Jamadagni  MIS, ESPN Inc. 
Rajendra dot Jamadagni at ESPN dot com 
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art! 


-Original Message- 
From: Les Ayudo [mailto:[EMAIL PROTECTED]] 
Sent: Friday, February 14, 2003 10:19 AM 
To: Multiple recipients of list ORACLE-L 
Subject: URL for Oracle 9i entry level email lists 


I want to subscribe to an entry level Oracle mailing list.  Do any of you 
know any good ones? 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Les Ayudo 
  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 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). 


**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**

Re: Oracle 8i or 9i ?

[Scott Stefick]

Les,

It depends on what version of Oracle Databases you will be working
with.  You won't miss out on information going through the 9i Class
because they will go over features from 8i as well.  They are
conclusive of features that have been available before 9i (as long as
they are still in 9i).  The only way you would miss out on 8i
features is if you took the 9i New Features class, because that is
strictly 9i.  If you are doing it for a career change and you have
not worked with Oracle at all before, I suggest that you not only take
the classes, but download a version of Oracle at home and run through all
kinds of examples from your classes, including backup and recovery
scenerios, putting a load on your database and tuning performance,
creating and deleting users, objects, stored procedures, sql and pl/sql
scripts and Oracle networking.  

So back to your question.  I would probably suggest taking the 9i
courses.  I took the 8i courses because they were the "New
Version" when I started.

This helped me a lot in my learning process and I would recommend it to
anyone.  So far I think it's a great field and I think its the best
career decision I've made to this point.

Good luck,
-Scott


At 07:23 AM 2/14/03 -0800, you wrote:
Hello,
 
I'm thinking of going to school to get Oracle
certified.  There are 2 schools in my area that are offering Oracle
certs but one offers Oracle 8i courses w/ an upgrade to 9i, while the
other offers all 9i courses.  If i go to the schools who offers 9i
courses, would I miss out on valuable 8i knowledge?  Which school
should I attend?  The courses will last about 7 or 8 months. 
Also, is this a good "in demand" field to get into?  What
chances am I looking at to getting hired as a newbie DBA once I
graduate?  
 
I want to get into the Ecommerce side of Oracle
(connecting DBs to websites/portals?).  Which certification/path
should I be following?  Thanks in 
advance!!

******
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**

Re: No redo or archived log files

[Scott Stefick]

The last cold backup.

At 12:09 PM 2/13/03 -0800, you wrote:

Hi All,

One of my friends has a database crash.  He has no backup of  online redo
and archived log files. His question is
How do you recover the database if all the online redologfiles and all
archived files are lost ?

Don't ask me why he did not have any backups or mirror online redo.

Thanks
Rick

--
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-- Mailing list and web hosting services
-
To REMOVE 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).



**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

RE: AIX & Oracle 9.2

[Scott . Shafer]

How about "relink all" from the $OH/bin directory?  Or is this utility gone
in 9i?

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: Tim Gorman [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 10:14 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: AIX & Oracle 9.2
> 
> At least you're going to want to relink everything in Oracle on the
> server.
> Go to $OH/rdbms/lib and "make -f ins_rdbms.mk install".  Also go to
> "$OH/network/lib" and "make -f ins_netserver.mk install".  In fact, do a
> find for all files named "ins_*.mk" and consider whether to do similar
> steps...
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, February 13, 2003 8:03 AM
> 
> 
> >
> > If I have Oracle 9.2 on AIX 4.3.3 and we upgrade to AIX 5.1, do I need
> to
> re-install the Oracle 9.2 software or will it all just work after the
> upgrade?  Anybody know?
> >
> > Keith H.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Henry, Keith
> >   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 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).
> >
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Tim Gorman
>   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 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).
-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).

Re: rootpre.sh

[Scott Behrens]

David,
   I haven't installed Oracle 8.1.7 or 9.2 to AIX 
5.1 yet, but thanks 
to a data storage interrupt kernel panic on a 5.1 box, I do 
know 
that 'crash' has been replaced by 'kdb' for examining crash 
dumps.  
So, rootpre.sh is going to break on the 
line 
  'PKEXT_PATH='echo le | crash | blah blah 
blah...'
I think the question is - do you need the post-wait kernel
extension at AIX 5.1?   
 
I don't know about Oracle 8.1.7, but the 9.2 Installation Guide
(p. 2-35) says:  "For Oracle9i 9.2.0.1.0 on AIX 5L, the functon
and performance benefits of the Oracle post-wait kernel 
extension are incorporated into the AIX kernel.  Oracle 9i
9.2.0.1.0 on AIX 5L does not require the Oracle post-wait 
kernel extension to be loaded."
 
(This begs the question as to whether I still would need to run 
rootpre.sh for asyncronous I/O configuration.  Presumably, I 
could use smit to configure async I/O.) 
 
It seems to me I read somewhere that 8.1.7 still requires a
32-bit kernel extension and therefore, you may not be able
to run a 64-bit AIX kernel with 8.1.7.  
  
Scott
>>> [EMAIL PROTECTED] 2/11/03 12:59:53 PM 
>>>I am trying to run rootpre.sh.  My admin just upgrade the 
kernel to 64-bit.We were running 32-bit on this box and everything was 
fine.  No Oraclesoftware is running.  I am going to install 64-bit 
8.1.7 Ent Ed for AIX 5.1Lwhen I got this trying to run rootpre.sh.This 
is what I get when I run:#./rootpre.sh Installing kernel extension... 
Oracle Kernel Ext... Copyright Kernel 
Extension Version: 3 nkext ver: 3 ./rootpre.sh[199]: crash: not 
found. is not loaded : 1 No post-wait kernel is loaded on the 
machine. Copying new kernel extension. Oracle Kernel Extension 
Loader for AIX Copyright. Kernel Extension Version: 3 
SYS_SINGLELOAD: Exec format error kmid: 0 (0x0) path 
'/etc/pw-syscall' libpath:'' Configuring Asynchronous I/O... 
Asynchronous I/O is already defined thanks,David 
Ehresmann    -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: 
Ehresmann, David  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- 858-538-5051 http://www.fatcity.comSan Diego, 
California    -- Mailing list and web 
hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: multiple oracle homes

[Scott Stefick]

I tend to agree also, just because of confusion.  We are running on one 
server, 817 (1 instance), 9201 (1 instance), 9iASRel 2 (1 instance) and on 
the second server we have 817 (2 instances), 9201 (1 instance), 9iAS Ver 
102 (1 instance).  So at first we tried different user names:
oracle8i (817 instances)
oracle9i (9201 instances)
oraias (9iAS Ver 102)
ora9ias (9iAS Rel 2)

This just got too confusing, so I wrote a script and placed it in the 
"oracle" .profile which creates a menu for the Admin logging in to choose 
(by number) which instances environment variables they want set.  Then it 
calls another script depending on the choice to set those variables and 
echo them to verify by using:

env | grep ORA
env | grep TNS

This has been working ok so far, but if anyone has any better suggestions, 
let me know.

-Scott


At 10:34 AM 2/7/03 -0800, you wrote:
I agree with Dennis.  We tried this several years ago and decided it was 
best to stick with one username. I forget what the exact issues were - it 
might have been file privileges when you are upgrading a database.

Jay

>>> [EMAIL PROTECTED] 02/07/03 10:54AM >>>
Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had
a bad experience :-)

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, February 07, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L


On Thu, Feb 06, 2003 at 05:08:55AM -0800, Ray Stell wrote:
>
> Where is it well documented how to install multiple server versions,
> 8i and 9i, on the same unix server?
--

Thanks for you replies.  I've never tried this before and it seems like
there are two different approaches on the surface:

1. use two different userids, ora817 and ora920, to do the install.  This
seems stupid, since it replicates the product directory structure and
oraInventory stuff under different ownership.  This might be safer since
it is like running one version in that everything is seperate, but
maybe there are operational issues to not using the oracle userid.
Seems like there may be a gotcha waiting in the wings.  Like maybe you
can't run the same listener for both, or worse.

2. use the same oracle userid for both installs and change the environment
vars as needed.  Seems like you could damage the first install if you
made a mistake.  Also, it seems like in a stressful failure situation
you don't want to have to think about who's on first?  I don't know,
third base.

Are both paths valid?






**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the 
use of the individual or entity to which they are addressed and may 
contain information that is privileged, proprietary and confidential. If 
you are not the intended recipient, you may not use, copy or disclose to 
anyone the message or any information contained in the message. If you 
have received this communication in error, please notify the sender and 
delete this e-mail message. The contents do not represent the opinion of 
D&E except to the extent that it relates to their official business.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jay Hostetter
  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 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).


**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

RE: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question

[Scott Stefick]

Lisa,

Try oslevel -r at the command promt.  It should tell you.

-Scott

At 09:49 AM 2/6/03 -0800, you wrote:
Hi
Ethan, 
 
Thanks so much for your
reply.  I'll have to check which patch level we are on. 

 
Have a great day!
Lisa

-Original Message-
From: Post, Ethan
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 11:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: AIX 4.3.3 / 8.1.7 & Timed Statistics &
Tuning Question


No problems here AIX 4.3.3 ML9 Oracle 8.1.7 64 bit.
 
Lisa,
 
Be aware that there are some issues with ML9 as I am finding out with
swap.  We are planning on going to ML10 which should fix the problem
as well as using vmtune command to change the system to use less OS Cache
for files, I forgot the exact syntax.  Happily the problem on these
boxes is rare and no one complains so I am not rushing to make the
changes but if you are running app servers on the same host you could see
this a lot possibly.  Search the AIX group on google for
"vmtune oracle" and also check out the new Database Tuning book
at IBM Redbooks, it was released in the past couple of weeks so it should
be easy to find.  It talks about all the vmtune settings.  Also
we are seeing issues with some of the psoft processes (Solaris app
server) using up all the memory on the box when one of the jobs is run
(not sure which one), appears to be a memory leak of some sort, we are
working on it (just a note, the peoplesoft environment is not the AIX
environment I spoke about).
 
- Ethan
-Original Message-
From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L
Subject: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning
Question


Good morning everyone - 
Quick poll for those of you on 8.1.7 and AIX 4.3.3:  
Do you have TIMED_STATISTICS = true?  Have you encountered any
problems with it? 
The databases I inherited have this set false all over the place,
hence my tuning efforts are really limited.  However I don't want to
change it without checking around first. 
And a tuning question: 


This environment (peoplesoft) is very very low on memory.  When
the app servers and databases are up there's less than 50MB of memory
free.  Adding hardware is not a choice here. 
The databases have 100MB set for the SGA.  It really looks like
not much thought went into some of the parm settings.  
What I've read about tuning says that you must have a goal in
mind.  Well, afaik nothing is "broken", nothing is
suffering - then again, no one really paid much attention to
Oracle.  It was up, fine, move on.  Am I on the wrong path if
my goal for tuning is to figure out if I can reduce the size of the SGA
and redo logs without adversely affecting performance? 
Any comments are appreciated.  Thanks everyone

Lisa Koivu 
Oracle Dingbat Administrator 
Fairfield Resorts, Inc. 
5259 Coconut Creek Parkway 
Ft. Lauderdale, FL, USA  33063

Office: 954-935-4117  
Fax:    954-935-3639 
Cell:    954-683-4459 


**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**

RE: Update NT to 2000 Server

[Hayes, Scott]

First off I am an NT/Win2k admin and I fully agree with you Jared. Blow the
partition and start from zero, you'll be happy you did.

Scott





First off, I am not an NT/Win2k admin, and don't even play one on TV.

The advice from every SA I've asked about this, and from searching the 
web,
is don't do it.  Rebuild the box.  There are remnants of NT left if you do 
an
upgrade, and you don't really want that, do you?

Jared





"Breno A. K. Magnago" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 02/06/2003 08:54 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Update NT to 2000 Server


Hello,

I'd like to update my server (Windows NT) to Windows 2000 Server.
I have a Oracle Database 9i in this machine.
Does anyone know any kind of problem in this operation (database
compatible) ?

Thank.
-- 
Breno A. K. Magnago   mailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Breno A. K. Magnago
  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 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).




-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hayes, Scott
  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 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).

Re: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question

[Scott Behrens]

Lisa,
   I have had TIMED_STATISTICS set to true on 5 different 8.1.7 
databases 
(4 at 8.1.7.4 (64-bit), one at 8.1.7.0 (32-bit)) on 3 different servers 

for some time with no perceived problems.   
These servers are either at AIX maintenance level 9 or 10. 
 
I have struggled with swap space consistently growing until memory is 
exhausted on 
one of these servers.  It is at AIX 4.3.3 maintenance level 9.  
There is a memory leak
in fclose() at this level that I think is causing the problem.  Refer 
to APAR IY22308.
 
You don't mention whether the databases are on jfs file systems or 
not.  If so, be
aware that the 'fre' column of the 'vmstat' command will typically be 
small, since
some real memory is used as a cache for file system data.  (And 
the virtual memory
management page stealer takes a lazy approach, only stealing to keep 
the free
list above the 'minfree' value.) 
 
IBM has a white paper on paging space that may help:
http://www-1.ibm.com/servers/aix/products/aixos/whitepapers/pagingspace.pdf
Also, the following commands with give the top 5 users of memory and 
paging space, respectively:
 
  svmon -Put 5
  svmon -Pgt 5
 
Haven't worked with PeopleSoft, so I can't speak to its effect.
 
Hope this was relevant,
Scott 
>>> [EMAIL PROTECTED] 2/6/03 9:23:58 AM 
>>>Good morning everyone - 
Quick poll for those of you on 8.1.7 and AIX 
4.3.3:  
Do you have TIMED_STATISTICS = true?  Have you 
encountered any problems with it? 
The databases I inherited have this set false all 
over the place, hence my tuning efforts are really limited.  However I 
don't want to change it without checking around first. 
And a tuning question: 
This environment (peoplesoft) is very very low on 
memory.  When the app servers and databases are up there's less than 50MB 
of memory free.  Adding hardware is not a choice here. 
The databases have 100MB set for the SGA.  It 
really looks like not much thought went into some of the parm settings.  

What I've read about tuning says that you must have a 
goal in mind.  Well, afaik nothing is "broken", nothing is suffering - then 
again, no one really paid much attention to Oracle.  It was up, fine, move 
on.  Am I on the wrong path if my goal for tuning is to figure out if I can 
reduce the size of the SGA and redo logs without adversely affecting 
performance? 
Any comments are appreciated.  Thanks everyone 

export/import

[Scott Stefick]

Never mind.  After I posted, I found a good website that included all of 
what I was looking for.

Just incase anyone else wants that kind of info, here is the link:

http://www.csis.gvsu.edu/GeneralInfo/Oracle/server.920/a96652/part1.htm

Thanks,
-Scott

**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

Export / Import

[Scott Stefick]

Hello,

OS Version: HP-UX 11i
DB Version: Oracle 8.1.7.4 and 9.2.0.1

I've been looking around and I cannot seem to find a difinitive guide 
online about Oracle's Export and Import.  I'm looking for all of the 
parameters and what they do.  Could anyone point me in the right direction.

Thanks,
-Scott

**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Stefick
 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 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).

RE: STATSPACK

[Scott . Shafer]

See:

http://www.oracle.com/oramag/oracle/00-Mar/index.html?statspack-other.html

and related articles.

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: Stephen Andert [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, January 29, 2003 3:49 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: STATSPACK
> 
> Ruth, 
> 
> I've heard people talk about "downgrading" the statspack scripts to
> earlier versions, but I've never done it.  Try searching "downgrade
> STATSPACK" on Metalink and OTN for starters.
> 
> Good luck
> Stephen
> 
> >>> [EMAIL PROTECTED] 01/29/03 12:59PM >>>
> I believe that an 8.1.7 statspack can run on an Oracle8 or higher
> database.
> 
> Dave
> 
> -Original Message-
> Sent: Wednesday, January 29, 2003 12:54 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
>  Hello everyone,
> 
> I hope this is a quick question.  Can you run 8.1.7 Statspack on an
> 8.0.6.3
> instance?
> 
> Thanks in advance,
> Ruth
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> -- 
> Author: Ruth Gramolini
>   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 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).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net 
> -- 
> Author: Farnsworth, Dave
>   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 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).
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Stephen Andert
>   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 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).
-- 
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-- Mailing list and web hosting services
-
To REMOVE 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).

RE: Perl - Was Unix time conversion function

[Scott Stefick]

What's the title of Jared's book?

-Scott

At 05:03 AM 1/28/03 -0800, you wrote:

I used to be, but I finally bit
the bullet ... I ordered my copy of Jared's book from Amazon.com
yesterday !! 

Raj 
__

Rajendra Jamadagni  MIS, ESPN Inc. 
Rajendra dot Jamadagni at ESPN dot com 
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. 
QOTD: Any clod can have facts, but having an opinion is an art! 

-Original Message- 
From: Robert Freeman [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 28, 2003 1:40 AM 
To: Multiple recipients of list ORACLE-L 
Subject: Perl - Was Unix time conversion function 

Cary I once thought I wanted to do some Perl coding... So I bought a book and started to play with it. It made my head bleed... literally I had little droplets of blood emerging from my head They rushed me to the hospital and put me in the Perl ward where I languished for days on IV's of Mountain Dew and pulverized Ritz crackers. it was close.

In my mind there is nothing obvious about Perl, this coming from and old C coder who did pointers and linked lists in his sleep years ago. I don't know, maybe I was having a bad day and it's time to get my "learning Perl" book out again

Anyone else feel that way about Perl or am I a lone wolf in a Perl world? 

RF 


******
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**

RE: AUTORAID and VA7100 disk arrays for rp7400

[Scott . Shafer]

We are using the VA7100's and VA7400's.  They are several orders of
magnitude faster than the old 12H AutoRAID arrays if configured properly.
I'm no expert, but I know the VA7X00's combine some caching technology with
faster IO channels.

Scott Shafer
San Antonio, TX
210.581.6217


> -Original Message-
> From: david hill [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, January 23, 2003 4:56 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: AUTORAID and VA7100 disk arrays for rp7400
> 
> Yep I have same thing to say 
> We have a HP N class with 3 HP AutoRaid's 
> I recently did a test to import our 50 gig database 
> On the HP it took 4 hours to do a Full export of DB and 12+ hours to
> import 
> I then proceeded to import the exact same dump file on a little Linux Xeon
> test box with IDE HD's just 2 120 Gig mirrored yes that right IDE.
> 
> And to import the full DB took 4 Hours!!! 
> Those IDE HD's cost $300 each 
> And those AutoRaids are costing us $1000 a month in support alone. 
> So we will soon changing out IO subsystem that  cost's a lot less, has
> more storage, and better performance. 
> 
> 
> 
> -Original Message- 
> From: Vergara, Michael (TEM) [ <mailto:[EMAIL PROTECTED]>] 
> Sent: Thursday, January 23, 2003 4:40 PM 
> To: Multiple recipients of list ORACLE-L 
> Subject: RE: AUTORAID and VA7100 disk arrays for rp7400 
> 
> I'm not sure what a VA7100 is, so I don't want to tell you 
> to avoid it.  The AutoRaid I used just said "AutoRaid" on the 
> front.  It had 12 disks...I think they were 9G or 18G each. 
> It had only 96M of cache, not expandable.  Only 2 SCSI 
> channels - not expandable. 
> 
> What happened was that our whole database was on this array. 
> Yes, even on-line and archived redo logs.  The array did so 
> much internal thrashing that the disk response times were 
> abysmal. 
> 
>  
> The boss got it cause he didn't want to pay the extra $$$ 
> for a 'real' array from EMC, Hitachi, or IBM.  It had the 
> magic word 'Raid' in the name so he went for it, and then 
> was all over me because the system was so slow.  I should'a 
> known what was up when a JBOD D-370 2-way did stuff faster 
> than our K570 6-way and the AutoRaid. 
>  
> 
> Take my advice - don't go with an AutoRaid. 
> 
> Cheers, 
> Mike 
> 
> -Original Message- 
> Sent: Thursday, January 23, 2003 12:45 PM 
> To: Multiple recipients of list ORACLE-L 
> 
> 
> Michael, 
> 
> a dumb question. does this stops me from using VA7100 with 0+1 or are u
> talking about going some other disk array product?
> 
> Thanks 
> Mandar 
> 
> > -Original Message- 
> > From: Vergara, Michael (TEM) [ <mailto:[EMAIL PROTECTED]>] 
> > Sent: Thursday, January 23, 2003 12:00 PM 
> > To: Multiple recipients of list ORACLE-L 
> > Subject: RE: AUTORAID and VA7100 disk arrays for rp7400 
> > 
> > 
> > Apologies to all for shouting, but ... 
> > 
> > DO NOT USE AUTORAID! 
> > ** *** *** * 
> > 
> > I used an AutoRaid system when I was at Petco.  Performance was 
> > el-sucko.  There was more I/Os happening in the disk array 
> > (by observing the disk lights) than was being caused by the 
> > application and database. 
> > 
> > Plus, when the AR system Raid 0+1/5 mode, where some blocks are 
> > kept in a RAID 0+1 area and some are kept in a RAID 5 area, the 
> > array got so busy swapping one for another that it was virtually 
> > useless. 
> > 
> > Fiber channel (FC-10) works ok, Clariion (by EMC) works Ok, 
> > heck, even JBOD works better than AutoRaid. 
> > 
> > Just my 2¢ worth. 
> > 
> > Cheers, 
> > Mike 
> > 
> > 
> > -Original Message- 
> > Sent: Thursday, January 23, 2003 11:35 AM 
> > To: Multiple recipients of list ORACLE-L 
> > 
> > 
> > Hi, 
> > 
> > i am in the process of defining the specs for a rp7400. a lil 
> > overwhelmed by the storage offerings from HP. 
> > i wanted to know if any of ull hv any inputs regarding a disk array. 
> > we currently hv a Model 30/FC disk array with 9gig drives. 
> > I am looking for a similar or the next higher configuration 
> > disk array from HP. 
> > 
> > Any inputs regarding VA7100 disk array or corresponding 
> > competetive disk aray from HP/competitor? 
> > 
> > cache size 256/512/1024 MB? dont know which to go. 
> > thinking of going for 18GB 15k rpm rather than 36GB 15K rpm. 
> > faster smaller drives. 
> > 
> &g

Re: ORA-29702: error occurred in Cluster Group Service operation

[Scott]

Sean, Have you installed the hang-check-timer RPM? If
you have installed hangcheck are you loading the
hangcheck module?

insmod hangcheck-timer hangcheck_tick=TICK
hangcheck_margin=MARGIN

Scott


--- From <[EMAIL PROTECTED]> wrote:
> 
> Hello all...
> 
> I'm running 9iRAC 9.2.0.2 on Linux 2.4.20 kernel. 
> This is based on the 
> Oracle Linux+Firewire project:
> http://otn.oracle.com/tech/linux/open_source.html
> 
> I'm getting the ORA-29702 during database create.
> 
> Any ideas?
> Sean
> 
> 
> -- sqlplus, create database --
> SQL> onnect / as sysdba;
> Connected to an idle instance.
> SQL> startup nomount;
> ORACLE instance started.
> 
> Total System Global Area  135336428 bytes
> Fixed Size   451052 bytes
> Variable Size  96468992 bytes
> Database Buffers   37748736 bytes
> Redo Buffers 667648 bytes
> SQL> create database EASTWEST
>maxinstances 5
>maxlogfiles 10
>character set "we8iso8859p1"
>datafile
> '/ocfs/oradata/EASTWEST/sysEASTWEST01.dbf' size 500m
> reuse
>default temporary tablespace tempts tempfile 
> '/ocfs/oradata/EASTWEST/tmpEASTWEST01.dbf'
>size 50m reuse
>undo tablespace UNDO_WEST datafile 
> '/ocfs/oradata/EASTWEST/undEASTWEST01.dbf' size 50m
> reuse
>logfile
>
> '/ocfs/oradata/EASTWEST/logEASTWEST01a.dbf' size 25m
> 
> reuse,
>
> '/ocfs/oradata/EASTWEST/logEASTWEST01b.dbf' size 25m
> 
> reuse;
>   23456789   10   11 
> create database EASTWEST
> *
> ERROR at line 1:
> ORA-01501: CREATE DATABASE failed
> ORA-29702: error occurred in Cluster Group Service
> operation
> 
> -- cm.log output --
> oracm, version[ 9.2.0.2.0.41 ] started {Wed Jan  8
> 02:39:05 2003 }
> OemNodeConfig(): Network Address of node0:
> 192.168.0.9 (port 9998)
>  {Wed Jan  8 02:39:05 2003 }
> OemNodeConfig(): Network Address of node1:
> 192.168.0.8 (port 9998)
>  {Wed Jan  8 02:39:05 2003 }
> >WARNING:  OemInit2: Opened file(/ocfs/oradata/foo
> 8), tid = main:8192 
> file = oem.c, line = 491 {Wed Jan  8 02:39:05 2003 }
> InitializeCM: ModuleName = iofence-timer  {Wed Jan 
> 8 02:39:05 2003 }
> InitializeCM: Kernel module iofence-timer is not
> loaded, try to 
> load(/sbin/insmod iofence-timer) {Wed Jan  8
> 02:39:05 2003 }
> ClusterListener (pid=13717, tid=24580): Registered
> with watchdog daemon. 
> {Wed Jan  8 02:39:05 2003 }
> >WARNING:  InitializeCM: Kernel module iofence-timer
> cannot be loaded, 
> please check if the module is in system lib path.,
> tid = main:8192 file = 
> cmstartup.c, line = 311 {Wed Jan  8 02:39:08 2003 }
> CreateLocalEndpoint(): Network Address: 192.168.0.9
>  {Wed Jan  8 02:39:08 2003 }
> NMEVENT_SUSPEND [00][00][00][00][00][00][00][01]
> {Wed Jan  8 02:39:13 2003 
> }
> HandleUpdate(): SYNC(0) from node(0) completed {Wed
> Jan  8 02:39:15 2003 }
> HandleUpdate(): NODE(0) IS ACTIVE MEMBER OF CLUSTER
> {Wed Jan  8 02:39:15 
> 2003 }
> NMEVENT_RECONFIG [00][00][00][00][00][00][00][01]
> {Wed Jan  8 02:39:15 
> 2003 }
> Successful reconfiguration,  1 active node(s) node 0
> is the master, my 
> node num is 0 (reconfig 1) {Wed Jan  8 02:39:15 2003
> }
> oracm, version[ 9.2.0.2.0.41 ] started {Wed Jan  8
> 02:44:00 2003 }
> OemNodeConfig(): Network Address of node0:
> 192.168.0.9 (port 9998)
>  {Wed Jan  8 02:44:00 2003 }
> OemNodeConfig(): Network Address of node1:
> 192.168.0.8 (port 9998)
>  {Wed Jan  8 02:44:00 2003 }
> >WARNING:  OemInit2: Opened file(/ocfs/oradata/foo
> 8), tid = main:8192 
> file = oem.c, line = 491 {Wed Jan  8 02:44:00 2003 }
> InitializeCM: ModuleName = iofence-timer  {Wed Jan 
> 8 02:44:00 2003 }
> InitializeCM: Kernel module iofence-timer is not
> loaded, try to 
> load(/sbin/insmod iofence-timer) {Wed Jan  8
> 02:44:00 2003 }
> ClusterListener (pid=13800, tid=24580): Registered
> with watchdog daemon. 
> {Wed Jan  8 02:44:00 2003 }
> >WARNING:  InitializeCM: Kernel module iofence-timer
> cannot be loaded, 
> please check if the module is in system lib path.,
> tid = main:8192 file = 
> cmstartup.c, line = 311 {Wed Jan  8 02:44:00 2003 }
> CreateLocalEndpoint(): Network Address: 192.168.0.9
>  {Wed Jan  8 02:44:00 2003 }
> NMEVENT_SUSPEND [00][00][00][00][00][00][00][01]
> {Wed Jan  8 02:44:05 2003 
> }
> HandleUpdate(): SYNC(0) from node(0) completed {Wed
> Jan  8 02:44:07 2003 }
> HandleUpdate(): NODE(0) IS ACTIVE MEMBER OF CLUSTER
> {Wed Jan  8 02:44:07 
> 2003 }
> NMEVENT_RECONFIG [00][00

Sun HA Monitoring and Oracle 9

[Scott Canaan]

Here's a little background.  We are currently running Oracle
8.1.6.0, 8.1.7.0, and 8.1.7.4 on a Sun cluster.  We use HA monitoring
for failover, in case there is a problem with any of the nodes.  The
version of HA is 2.2.  We installed Oracle 9.2.0.1 on the cluster and
created a new database using it.  When the SA tried to start the HA
monitoring, it wouldn't run.  We ended up recreating the database in
8.1.7.4.  When the SA contacted Sun, he was told that HA version 2.2
only supports up to Oracle 8.1.7.  In order to monitor Oracle 9, we had
to buy (not upgrade to) HA 3.0, which would require a rebuild of the
entire cluster.

Has anyone else run into this problem?  If so, what have you done to
get around it?  Let me know if I forgot any important piece of
information.

Thank you.

--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Canaan
  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 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).

Re: Hotsos Clinic

[Scott Behrens]

Keith,
   I had the great good fortune to be able to attend the Hotsos 
Clinic in 
March, 2002 and then, in November, to attend Jonathan Lewis' 
seminar. 
Best investments in Oracle I ever made.  

 
Scott Behrens>>> [EMAIL PROTECTED] 1/2/03 1:41:45 PM 
>>>I have an opportunity to attend a Hotsos Clinic.  It 
seems I have heard good
 things about them on this list, but I thought I might 
double-check.  Is this 3-day class worthwhile or is it an expensive way 
to sell their product?  Will this class 
be beneficial, even if we don't buy their product?Keith-- 

Re: warehouse builder's dependance on oem job system.

[Scott Canaan]

I run the jobs via cron, without any parameters and we don't have any problems.  If 
you look at the parameter list, you'll find that most (if not all) have default values 
anyway.  I have been running them via cron for months without any issues, other than 
the fact that we can't multitask.

"Mandar A. Ghosalkar" wrote:

> Chris,
>
> the parameters 3,2,50,1000,50,wb,10 are used inside the oem-owb job tcl script as
> set p_oper_mode [lindex $parList [incr parList_i]]
> set p_audit_level [lindex $parList [incr parList_i]]
> set p_num_errors [lindex $parList [incr parList_i]]
> set p_commit_frequency [lindex $parList [incr parList_i]]
> set p_bulk_size [lindex $parList [incr parList_i]]
> set p_purge_group [lindex $parList [incr parList_i]]
> set p_percentage [lindex $parList [incr parList_i]]
>
> and then the package.main is called
>
> try the following. i would recommend testing this on the test server before putting 
>it on prod :-)
>
> sql>exec C40_ADMIN_CUSTOMER_MAP.Main(p_operating_mode => 3, p_audit_level => 2, 
>p_max_errors => 50, p_commit_frequency => 1000,
>  p_bulk_size => 50, p_job => 'wb');
>
> -Mandar
>
> Original Message-
> Sent: Thursday, December 12, 2002 1:09 PM
> To: Multiple recipients of list ORACLE-L
>
> here is the tcl that was generated:
>
> "-r" "3,2,50,1000,50,wb,10" "-c" "WE8MSWIN1252"
>
> the package that is generated is quite long.
> i have absolutely no idea how to read the tcl.
> if you could point me somewhere, i could try and figure it out myself.
> any help is appreciated.
>
> attached is the package code if you are willing to take a look...
>
> (for some reason my computer associates .pls extensions with real audio)
>
>
>
>
> -Original Message-
> Sent: Tuesday, December 10, 2002 1:11 PM
> To: Multiple recipients of list ORACLE-L
>
> Chris,
>
> All the owb etl jobs are packages and if you have configured it right, then you 
>could the execute the package_name.main procedure to run the etl process. your best 
>best would be to read the tcl script and the associated parameters for the owb-oem 
>job.
>
> You could paste the tcl and the parameters here to help u more.
>
> -Mandar
>
> -Original Message-
> Sent: Tuesday, December 10, 2002 9:31 AM
> To: Multiple recipients of list ORACLE-L
>
> ok, here's the situation:  we are loading our warehouse via etl processes generated 
>by warehouse builder (owb).  we went live with this a little over a week ago.  up to 
>this point we have been running the jobs manually through owb.  for obvious reasons 
>we need to be able to schedule these jobs.  the only way (that i know of) to schedule 
>the owb jobs is to deploy them to entreprise manager.  the problem is that our oem is 
>VERY unreliable and seems to be related to bugs.  we are running oem v9.2 and oracle 
>ee v9.2.  when jobs are scheduled through oem, they run sometimes and hang others.  
>this is unexceptable.
>
> so my question is:  does anyone know of a way to trap the commands that oem sends to 
>the database?  the obvious solution would be to just cron execution of the packages 
>owb generates inside the database.  this doesn't work though because owb generates 
>funky code that takes parameters, whose values i don't know, for logging purposes.
>
> hopefully i explained the situation well enough.
>
> any ideas??i'd like to get rid of the dependance on oem.
>
> oem sucks
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mandar A. Ghosalkar
>   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 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).

--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it." - Tom 
Lehrer.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  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 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).

RE: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0],

[Scott Graves]

Satish,


Use the JDBC driver from the 9.0.1 database.  The 8i JDBC driver causes this
error.


Scott
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of SATISH P
> Sent: Thursday, December 12, 2002 8:34 AM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0],
>
>
> Hi ,
>we are getting the error ORA-00600: internal error code, arguments:
> [ttcgcshnd-1], [0],
> [], [], [], [], [], []  when trying to retrieve a result set from Java
> EJB.
>
> Searched metalink giving arguments for ORA-00600 but couldn't get any
> solution.
> I am being told that Weblogic 6.1 with oracle 9i is giving some
> problems. Any info on this ?
>
> Setup is mentioned Below:
> Oracle database 9.0.1.1.0 on sunsolaris
> Weblogic Applications Server 6.1 on Sunsolaris (different Unix box).
> JDBC driver thin - Classes12.jar
>
> In fact , If an Insert from the Application is working fine. But when we
> try a query it is displaying the above mentioned error.
>
> From udump trace file of oracle  below is the error message :
>
> /usr/gsci/OraHome1/admin/GMODC/udump/gmodc_ora_1182.trc
> Oracle9i Enterprise Edition Release 9.0.1.1.0 - 64bit Production
> With the Partitioning option
> JServer Release 9.0.1.1.0 - Production
> ORACLE_HOME = /usr/gsci/OraHome1
> System name:  SunOS
> Node name:lotus
> Release:  5.8
> Version:  Generic
> Machine:  sun4u
> Redo thread mounted by this instance: 1
> Oracle process number: 19
> Unix process pid: 1182, image: oracle@lotus (TNS V1-V3)
>
> *** SESSION ID:(19.2868) 2002-12-11 10:41:43.563
> *** 2002-12-11 10:41:43.563
> ksedmp: internal or fatal error
> ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [],
> [], [], [], []
> Current SQL statement for this session:
> SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER
> ='NLS_DATE_FORMAT'
> ----- Call Stack Trace -
>
>
> Is there any  solution for this problem?
> TIA
> Satish
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Graves
  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 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).

RE: hmm...

[Scott]

Adam, If you need keep the global_name the Create the
database link with "@" symbol.

The online documentation
http://download-west.oracle.com/docs/cd/A97630_01/server.920/a96521/ds_admin.htm#13803
gives you some examples.

I am not sure if this is what you are looking for but
it may help.

Scott




--- "Donahue, Adam" <[EMAIL PROTECTED]> wrote:
> Thanks for the suggestions, all.  I knew about these
> workarounds, but apparently the answer to my
> original question is "no".
> 
> Adam
> 
> -Original Message-
> Sent: Friday, December 06, 2002 5:39 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> There is: Alter database rename global_name
> 
> Waleed
> 
> -Original Message-
> Sent: Friday, December 06, 2002 5:14 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> You can update the global_name by using sqlplus or
> svrmgrl (internal or "/
> as
> sysdba" or sys):
> 
> update global_name
> set global_name = newname;
> commit;
> 
> I do this every time I clone a database.  If you
> don't change it, then the
> database links won't work.
> 
> DENNIS WILLIAMS wrote:
> 
> > Adam - Someone posted a better "hidden?" parameter
> awhile back. Jared, was
> > that you?
> >
> > Dennis Williams
> > DBA, 40%OCP
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> > -Original Message-
> > Sent: Friday, December 06, 2002 11:29 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > I was afraid that'd be the only way.  Thanks.
> >
> > Adam
> >
> > -Original Message-
> > Sent: Friday, December 06, 2002 12:05 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Hi
> >
> > Set global_names = false in init.ora file and try
> again
> >
> > -Original Message-
> > Sent: vrijdag 6 december 2002 17:41
> > To: Multiple recipients of list ORACLE-L
> >
> > Don't ask how we got into this situation, but I
> have two instances with
> the
> > same global_name and need to be able to create a
> link between them.  Is
> this
> > doable?
> >
> > Adam
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Donahue, Adam
> >   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 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).
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Jack van Zanen
> >   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 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).
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Donahue, Adam
> >   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 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).
> > --
> > Please see the official ORACLE-L F

Re: hmm...

[Scott Canaan]

You can update the global_name by using sqlplus or svrmgrl (internal or "/ as
sysdba" or sys):

update global_name
set global_name = newname;
commit;

I do this every time I clone a database.  If you don't change it, then the
database links won't work.

DENNIS WILLIAMS wrote:

> Adam - Someone posted a better "hidden?" parameter awhile back. Jared, was
> that you?
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Friday, December 06, 2002 11:29 AM
> To: Multiple recipients of list ORACLE-L
>
> I was afraid that'd be the only way.  Thanks.
>
> Adam
>
> -Original Message-
> Sent: Friday, December 06, 2002 12:05 PM
> To: Multiple recipients of list ORACLE-L
>
> Hi
>
> Set global_names = false in init.ora file and try again
>
> -Original Message-
> Sent: vrijdag 6 december 2002 17:41
> To: Multiple recipients of list ORACLE-L
>
> Don't ask how we got into this situation, but I have two instances with the
> same global_name and need to be able to create a link between them.  Is this
> doable?
>
> Adam
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Donahue, Adam
>   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 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jack van Zanen
>   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 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Donahue, Adam
>   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 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
>   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 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).

--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it."
- Tom Lehrer.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  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 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).

RE: Recipe for application design to run on RAC

[Scott]

Dennis, I hate to see do all this jumping up and down
but the dynamic re-mastering feature was not
implemented in 9i. 

There is a view called V$GCSPFMASTER_INFO that is
supposed to show which node was the master, which node
is currently the master and how many times the
resource has been re-mastered, but the view is never
populated.

This is one those if it's in the Doc. it may have been
true in the past, It may be true now or it may true in
the future. This one of those in the future features.

Scott



--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> I know I know (he says jumping up and down) Just did
> the 9i New Features
> class.
>  
> The answer is "lazy dynamic remastering". Over time,
> resources are gradually
> moved to the instance that is using them.
>  
> More quotes from the manual:
>Should an instance leave the group, the
> background processes only
> remaster resources from the departing instance.
>Similarly, when a new instance joins the group,
> the resources are
> gradually remastered, adapting to the cluster
> workload.
> 
> 
> Dennis Williams 
> DBA, 40%OCP 
> Lifetouch, Inc. 
> [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>  
> 
> -Original Message-
> Sent: Wednesday, December 04, 2002 2:30 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> So when I access the fantasy football league on the
> espn web site-I go to
> schema2 because my team(s) are losing :-)   I
> guess thats what I get
> when I picked a group of guys that are all on the
> injured reserve
>  
>  
> Seriously though--What if 50% of the blocks of data
> for schema1 are "owned"
> by db2? do you eventually see where ownership is
> transferred to the "active"
> node, reduced cache fusion activity and then
> transfer of blocks?  Do the
> users on schema1 have to use the data on schema2 at
> all? I'm trying to see
> if not only are the users logically partitioned-but
> if your schemas offer
> any data partitioning to align with the schema1 and
> schema2
>  
> thanks!
> Greg
>  
> 
> -Original Message-
> Sent: Wednesday, December 04, 2002 2:05 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> H... it is probably not an good example but we
> too have a (couple of)
> mission critical app (affects on air production)
> running on 9i RAC. One of
> which has two major schema. We logically partitioned
> the application such
> that, for two groups of people 9accessing one schema
> each) we gave them a
> preference. 
> 
> Schema1 users have tns entry for db1 and fail over
> to db2 
> Schema2 users have a preference for db2 with a fail
> over to db1 
> 
> This effectively allows us to do load balance, they
> don't share too much
> data, so traffic through interconnect is manageable.
> If need be, we just
> shutoff listener on one side, and everyone fails
> over to the other side
> while we can perform maintenance. All their
> applications are written in VB,
> JAVA so they handle fail over from within
> application.
> 
> None of the people involved in the design worried
> about which side of RAC
> they will be on and how the DML activity affects etc
> etc. They designed a
> plain application with a good design and it is
> working fine.
> 
> Like I mentioned this is not a good example ... but
> this is how we did it in
> one of our major application. 
> Raj 
>
__
> 
> Rajendra Jamadagni  MIS, ESPN Inc. 
> Rajendra dot Jamadagni at ESPN dot com 
> Any opinion expressed here is personal and doesn't
> reflect that of ESPN Inc.
> 
> QOTD: Any clod can have facts, but having an opinion
> is an art! 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   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 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).
> 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: htt

RE: Are Oracle courses required for Oracle Certification now?

[Scott Stefick]

Are you getting a sheet after each exam showing how many you got correct 
for each section and your overall score?  I received that  sheet at the 
testing center after each exam.  Other than that, you won't get anything 
from Oracle until you finish your final exam.  It took me about a month to 
get my packet.

At 01:13 PM 12/4/02 -0800, you wrote:
Lyndon - I have completed 2 of the 5 Oracle8i exams.

Hey - when I took each exam, the testing organization says that I should
receive something from Oracle within a couple of weeks. Got nothing. Should
I be worried?

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, December 04, 2002 1:10 PM
To: Multiple recipients of list ORACLE-L


Hey William,

Why are you 40% OCP - does this mean you are an OCA? When did you take your
very
first 9i certification exam? If you took it before Sept. 1, 2002, the you're
a
50% OCP.

--
Lyndon Tiu


Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:

> My instructor in a recent Oracle Education class said that there were a
> couple of smart alecs that caused quite a stir within Oracle. After
> receiving their OCP, they couldn't log into a database, and claimed it was
> because they had never actually used Oracle. The instructor indicated that
> the new requirement (9i I believe) would require you to take at least one
> class. I asked "do you mean everyone that takes a class from you will be
> logging on". He just grinned.
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Wednesday, December 04, 2002 11:25 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hey people!
>
> A friend of mine was just asking me about getting Oracle certified (I
> completed the Oracle 8i cerfication exams last year),
> he told me that to his knowledge Oracle requires that you've done Oracle
> courses before you can be certified now.
> I knew nothing about this, but can't believe Oracle would so blatantly
make
> you take their over-priced courses.
>
> But maybe I'm just naive.
>
> Cheers,
> Kieran Murray
> CardBASE Technologies Limited®
> BIM House
> Crofton Road
> Dun Laoghaire
> Co Dublin
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kieran Murray
>   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 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
>   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 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).
>
>


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Lyndon Tiu
  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 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
  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 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 conta

Re: [Q] ORACLE 9.2 "SGA_MAX_size" cause SUN server crash ????

[Scott]

I have not used this feature but there is a note on
metalink that you may find useful regarding dynamic
SGA issues on Solaris 8.

It is note 151222.1

Scott


--- dist cash <[EMAIL PROTECTED]> wrote:
> 
> 
> 
> We are doing ORACLE 9.2.0.2 Enterprise Edition
> testing on SUN server
> (Solaris 8).  Currently one problem happen.  If I
> put "SGA_MAX_size" entry
> on init.ora file and restart database, the SUN
> server will crash and
> following messages on /var/adm/message file:
> 
> 
> Dec  3 13:34:59 ISS unix: [ID 253085 kern.notice]
> NOTICE: hat_memload: unsupported flags 256
> Dec  3 13:35:00 ISS unix: [ID 253085 kern.notice]
> NOTICE: hat_memload: unsupported flags 256
> Dec  3 13:35:02 ISS last message repeated 9618 times
> Dec  3 13:35:03 ISS unix: [ID 836849 kern.notice]
> Dec  3 13:35:03 ISS ^Mpanic[cpu3]/thread=ffba0ac0:
> Dec  3 13:35:03 ISS unix: [ID 977504 kern.notice]
> invalid shared memory
> l1 ptp
> Dec  3 13:35:03 ISS unix: [ID 10 kern.notice]
> Dec  3 13:35:03 ISS genunix: [ID 872817 kern.notice]
> e166ba40
> unix:srmmu_share+130 (0, 0, ff61af38, 0, 8,
> ff619c20)
> Dec  3 13:35:03 ISS genunix: [ID 645206 kern.notice]
>   %l0-7: 0800
> ff61a998 2100 0001 ffc77004 ff0982c0
> ffc77484 01629b
> 31
> Dec  3 13:35:03 ISS genunix: [ID 872817 kern.notice]
> e166bab0
> genunix:as_dup+dc (0, ffba14a0, ff61a9b4, ffbe2c28,
> ffbe2c44, ff61a99
> 8)
> Dec  3 13:35:03 ISS genunix: [ID 645206 kern.notice]
>   %l0-7: e00e94f0
> ffc8f760 f0a2981c ff385908 e166bb7c ff385908
>  df13a0
> 00
> Dec  3 13:35:03 ISS genunix: [ID 872817 kern.notice]
> e166bb10
> genunix:cfork+10c (0, 0, ff876768, 1e, 0, 0)
> Dec  3 13:35:03 ISS genunix: [ID 645206 kern.notice]
>   %l0-7: 40401085
> df119740 df119744 e006  ffba0ac0
> ff577c10 e166bb
> 80
> Dec  3 13:35:03 ISS unix: [ID 10 kern.notice]
> Dec  3 13:35:03 ISS genunix: [ID 672855 kern.notice]
> syncing file
> systems...
> Dec  3 13:35:03 ISS genunix: [ID 733762 kern.notice]
>  2
> Dec  3 13:35:03 ISS genunix: [ID 733762 kern.notice]
>  1
> Dec  3 13:35:03 ISS last message repeated 19 times
> Dec  3 13:35:03 ISS genunix: [ID 616637 kern.notice]
>  cannot sync --
> giving up
> Dec  3 13:35:03 ISS genunix: [ID 353387 kern.notice]
> dumping to
> /dev/dsk/c0t0d0s1, offset 83886080
> Dec  3 13:35:03 ISS genunix: [ID 409368 kern.notice]
> ^M100% done: 10698
> pages dumped, compression ratio 2.95,
> Dec  3 13:35:03 ISS genunix: [ID 851671 kern.notice]
> dump succeeded
> 
> 
> 
> If I take out "SGA_MAX_size" entry from init.ora,
> the database run
> correctly.  Does anyone knoe why SUN server crash?
> 
> 
> Thanks.
> 
> 
> 
> 
> 
> 
>
_
> Add photos to your e-mail with MSN 8. Get 2 months
> FREE*. 
> http://join.msn.com/?page=features/featuredemail
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: dist cash
>   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 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).
> 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott
  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 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).

RE: Best practice for backing out of Application Patches

[Scott Stefick]

Thanks to Thomas Mercadante, Stephen Lee and Rick Cale for their 
responses.  I think it's pretty unanimous that if this needs to be done,  I 
would just restore to the point in time taken right before the patches were 
installed.  Either I could do an export/restore/import or refresh from the 
production Database (As long as the problem was caught before getting put 
on the production Database).   I just want to be covered from all angles 
before this application goes into production.

Thanks again!

-Scott Stefick

At 12:14 PM 12/3/02 -0800, you wrote:
Scott,

Of course, the answer is "It depends".

It all depends on the kind of software patches that are being applied.

Are you talking about adding a column to a table that allows nulls?  There
might not be a need to back this patch out - the column might be able to
stay depending on how it is used during an insert or select statment.  If
the application does not use the column, then removing it from the table
might need to be done.  On the other hand, if you are using version 8.1.7,
you can always drop the column from the table.

If your patches are just updates to schema views, you can always simply
e-apply the prior version of the views to back the updates out of the
database.

see, it all depends on the kind of schema update that was performed.  and it
can get very complicated when you are talking about foreign keys - literally
hundreds of tables could be involved - and you probably do not want to be
trying to figure out what got touched by an update.

probably the best answer is - to back all database changes out of a schema,
perform a database point-in-time restore back to before you applied the
patches.  if I had your job, and this was a purchased application, this is
what I would do.

hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, December 03, 2002 2:25 PM
To: Multiple recipients of list ORACLE-L



>Sorry, I forgot a Subject title!
>
>Gurus,
>
>I was just given a project to maintain a Computerized Maintenance
>Management System.  When I asked the companies support staff how to roll
>back patches in the backend Oracle Database (Ver. 8174), they said that
>there was no way to do this.  I'm guessing I could use logminer just
>incase a patch doesn't work.  Would this be a good solution, or are there
>other (better) ways of safeguarding myself when it comes to
>patching?  Obviously, I will be applying the patches to a test instance
>first, but I don't want to have to go back to restore from a backup if the
>patch causes unexpected issues.
>
>TIA!

-Scott Stefick


**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Stefick
  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 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
  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 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).



**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
******
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Stefick
 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 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).

[no subject]

[Scott Stefick]

Gurus,

I was just given a project to maintain a Computerized Maintenance 
Management System.  When I asked the companies support staff how to roll 
back patches in the backend Oracle Database (Ver. 8174), they said that 
there was no way to do this.  I'm guessing I could use logminer just incase 
a patch doesn't work.  Would this be a good solution, or are there other 
(better) ways of safeguarding myself when it comes to patching?  Obviously, 
I will be applying the patches to a test instance first, but I don't want 
to have to go back to restore from a backup if the patch causes unexpected 
issues.

TIA!


**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Stefick
 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 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).

Best practice for backing out of Application Patches

[Scott Stefick]

Sorry, I forgot a Subject title!

Gurus,

I was just given a project to maintain a Computerized Maintenance 
Management System.  When I asked the companies support staff how to roll 
back patches in the backend Oracle Database (Ver. 8174), they said that 
there was no way to do this.  I'm guessing I could use logminer just 
incase a patch doesn't work.  Would this be a good solution, or are there 
other (better) ways of safeguarding myself when it comes to 
patching?  Obviously, I will be applying the patches to a test instance 
first, but I don't want to have to go back to restore from a backup if the 
patch causes unexpected issues.

TIA!

-Scott Stefick


**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Stefick
 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 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).