RE: Archive log full

[sam d]

thx a lot all ,
for the info.

(I'll look out for book Oracle9i for Windows
2000 Tips  Techniques)

-Original Message-
From:   Michael P Sale [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, May 31, 2002 7:43 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Archive log full

You absolutely need to keep the log archive
destination disk space free
to create new logs. You NEED to keep these archives
for at least the
time of the last beginning of a hot backup, or, if
you're doing cold
backups (with the database service stopped) then you
need the archives
from at least the time of the last cold backup.

I would strongly suggest that you stop by your
favorite bookstore and
read the at least the first 2 chapters of my book
Oracle9i for Windows
2000 Tips  Techniques. This will give you a great
background to avoid
these kinds of problems in the future. The advantage
of this book over
the typical (and VERY good) books is that it is
directed to the windows
user. 

Regards,

Michael Sale
Author: Oracle9i for Windows(R) 2000 Tips  Techniques
http://www.amazon.com/exec/obidos/ASIN/0072194626


-Original Message-
Sent: Friday, May 31, 2002 6:23 AM
To: Multiple recipients of list ORACLE-L


Hi List,
I am new to oracle,
Archive Log has filledup the entire hard disk.
(No error thrown by the Oracle)
Can I move those(zip) files safely to other location.
(win2k,Oracle
8.1.6) (I did went thru the manual)

thx
Sam




__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: sam d
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rollback Segment tuning

[Stephane Faroult]

Hi all,=0D
=0D
How to find out the smallest (minimal) transaction
size from Dictionary vie=
w or base tables =0D
I try to set my OPTIMAL rollback segment base on
smallest transaction size =
to prevent ora-1555. since shrinking rollback
segments may cause ora-1555.=
=0D
=0D
=0D
Thanks =0D
=0D
Sinardy=0D
--=0D

Smallest ? Are you sure that you do not mean greatest ? Opinions diverge about 
OPTIMAL. As far as I am concerned I like it on databases where you may have 
occasionally very big changes. Look at V$ROLLSTAT. You have there the average amount 
of rollback segment used, as well as the high-water mark. You can use those values to 
derive something looking common-sensical. Alternatively, I think that there is in the 
'X-rated' section of the Oriole site (http://www.oriole.com) something to set OPTIMAL 
automatically (don't worry, even with this name it contains nothing illegal in 
Singapore :-)). Even if you do not run the script as is, looking at what it does - and 
possibly questioning it - may give you the answer you are looking for. 

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 grant privileges on all the tables of owner1 to owner2?

[farkasb]

If you don't want to grant select any table to owner2, try this :

select 'grant select on '||table_name from all_tables where owner = 'OWNER1'

It selects all grant statements, you have to execute them. For this, you may
write a pl/sql block or just execute it as script.

Balazs Farkas


On 2002.05.31 11:33 Mandal, Ashoke wrote:
 Greetings,

 Here is the scenario.
 I have 2 users(owner1, owner2) in an oracle database.
 owner1 owns 150 tables.
 owner2 needs select,insert,update,delete privilege on all the tables
 owned by owner1.

 One option is : login as owner1 and

 grant select,insert,update,delete on owner1.table1 to owner2;
 .
 .
 .
 grant select,insert,update,delete on owner1.table150 to owner2;

 I was wondering if there is any way I can perform the same work using
 one sql statement instead of using 150 statements.

Yes, it is possible to do that:

  grant dba,sysdba to owner2;

Now, owner2 will have select/insert/delete access to all tables owned
by owner1.

--
Mladen Gogala
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: farkasb
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Pkg Body variables

[cosltemp-g . manoj]

BDY.RTF
Description: RTF file

RE: Rollback Segment tuning

[Sinardy Xing]

Thanks man,

I mean the minimum optimal size base on the maximum transaction size, So the HWM is 
the answer ?


Sinardy

-Original Message-
Sent: 03 June 2002 16:53
To: Multiple recipients of list ORACLE-L



Hi all,=0D
=0D
How to find out the smallest (minimal) transaction
size from Dictionary vie=
w or base tables =0D
I try to set my OPTIMAL rollback segment base on
smallest transaction size =
to prevent ora-1555. since shrinking rollback
segments may cause ora-1555.=
=0D
=0D
=0D
Thanks =0D
=0D
Sinardy=0D
--=0D

Smallest ? Are you sure that you do not mean greatest ? Opinions diverge about 
OPTIMAL. As far as I am concerned I like it on databases where you may have 
occasionally very big changes. Look at V$ROLLSTAT. You have there the average amount 
of rollback segment used, as well as the high-water mark. You can use those values to 
derive something looking common-sensical. Alternatively, I think that there is in the 
'X-rated' section of the Oriole site (http://www.oriole.com) something to set OPTIMAL 
automatically (don't worry, even with this name it contains nothing illegal in 
Singapore :-)). Even if you do not run the script as is, looking at what it does - and 
possibly questioning it - may give you the answer you are looking for. 

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Sinardy Xing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Pkg Body variables

[Ganesh Raja]

Pkg Variables are Presistent for the session. They Get Deallocated once the
session dies.

So It will not be available for the next SQLLDR Run.

HTH

Best Regards,
Ganesh R
Tel  : +971 (4)  397 3337  Ext 420
Fax  : +971 (4)  397 6262
HP   : +971 (50) 745 6019

Live to learn... forget... and learn again. 




-Original Message-
[mailto:[EMAIL PROTECTED]] 
Sent: Monday, June 03, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L


Hi,
 I am calling a packaged function in sql loader control file. I 've
declared a variable in pkg body to hold old value . I am comparing this with
current value obtained from sql ldr and also storing last value in the old
value variable.

My question is will the package variable declared above retain its value
after each run of sqlldr. if yes then how to reset this value before the
next run.

Note : userid remains same for each sqlldr run.


Thanks
Manoj.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ganesh Raja
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Pkg Body variables

[Alexandre Gorbatchev]

Package is initialized when user first time access it on the session level.
Think about it like each session has a copy of package. Does not matter
which user access it.

Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 03, 2002 11:28 AM


 Hi,
  I am calling a packaged function in sql loader control file.
 I 've declared a variable in pkg body to hold old value . I am comparing
 this with current value obtained from sql ldr
 and also storing last value in the old value variable.

 My question is will the package variable declared above retain its value
 after each run of sqlldr.
 if yes then how to reset this value before the next run.

 Note : userid remains same for each sqlldr run.


 Thanks
 Manoj.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alexandre Gorbatchev
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rollback Segment tuning

[Sinardy Xing]

Hi Stephane,

I run the script and I have 

OPTIMAL = 5 * ceil(max(v$rollstat.aveactive) / 4 / sys.ts$.blocksize)* 
sys.ts$.blocksize / 1024 

the result is 0 K for my optimal. : )

regards,
Sinardy




-Original Message-
Sent: 03 June 2002 16:53
To: Multiple recipients of list ORACLE-L



Hi all,=0D
=0D
How to find out the smallest (minimal) transaction
size from Dictionary vie=
w or base tables =0D
I try to set my OPTIMAL rollback segment base on
smallest transaction size =
to prevent ora-1555. since shrinking rollback
segments may cause ora-1555.=
=0D
=0D
=0D
Thanks =0D
=0D
Sinardy=0D
--=0D

Smallest ? Are you sure that you do not mean greatest ? Opinions diverge about 
OPTIMAL. As far as I am concerned I like it on databases where you may have 
occasionally very big changes. Look at V$ROLLSTAT. You have there the average amount 
of rollback segment used, as well as the high-water mark. You can use those values to 
derive something looking common-sensical. Alternatively, I think that there is in the 
'X-rated' section of the Oriole site (http://www.oriole.com) something to set OPTIMAL 
automatically (don't worry, even with this name it contains nothing illegal in 
Singapore :-)). Even if you do not run the script as is, looking at what it does - and 
possibly questioning it - may give you the answer you are looking for. 

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Sinardy Xing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Pkg Body variables

[Stephane Faroult]

Hi,
 I am calling a packaged function in sql loader
control file.
I 've declared a variable in pkg body to hold old
value . I am comparing
this with current value obtained from sql ldr
and also storing last value in the old value
variable.

My question is will the package variable declared
above retain its value
after each run of sqlldr.
if yes then how to reset this value before the next
run.

Note : userid remains same for each sqlldr run.


Thanks
Manoj.

Manoj,

  Package variables retain their value for the duration of the _session_. Each 
SQL*Loader run is a new connection, therefore a new session (same user or not, it 
doesn't matter). The only way to have persistence between sessions is to store your 
values, well, in one of those good old relational tables. Read the value in the 
initialization section of your package (executed once per session), and let SQL*Loader 
roll.

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rollback Segment tuning

[Stephane Faroult]

Thanks man,=0D
=0D
I mean the minimum optimal size base on the maximum
transaction size, So th=
e HWM is the answer ?=0D
=0D
=0D
Sinardy=0D
=0D

Depends. If activity was 'normal', yes (if HWM is about the same for all RS, you can 
be fairly confident with the value). If somebody has run a big imp without 'COMMIT=Y', 
no. And beware that these values refer to the latest startup, so do not check it first 
thing in the morning if you shut your databases down every night.

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: * Certified Oracle DBAs Needed in the Dallas area..

[Yechiel Adar]

So, If I am working a long time why should I now quit and move to work with
them?

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, May 31, 2002 4:19 PM


 Great Company located in Greater Dallas, Texas area (Richardson) needs 2
 CERTIFIED (OCP)
 Oracle DBAs for full time staff positions.

 PLEASE Do Not send your resume for this position UNLESS you are fully
 certified and
 have the skills outlined below for this position.

 Please Do Not send your resume unless you have a stable work history.
 Candidates whose work history includes frequent job changes cannot be
 considered.
 If you are employed by a consulting company you should have a long term
 project history.

 These are full time staff positions so no sub-contractors or third parties
 please.

 No H-1B candidates please.

 Position #1- Oracle OCP DBA
 Salary: 75-90K/yr
 Start Date: immediately

 Position # 2- Oracle OCP DBA Consultant..permanent position
 Salary: 75-90K/yr
 Start Date: immediately
 * This position will be up to 100% travel (limited to TX, OK, LA, and
Arkansas
 only). All expenses will be reimbursable.

 The overview of qualifications for both of the above listed OCP's are as
 follows:

 REQUIRED: Oracle OCP certification, 3+ yrs. OCP DBA experience, Oracle
 Database 8.x, 8I

 DESIRED: Oracle PL/SQL, SQL, JDeveloper, Developer 6I, OEM, Java, C++,
 Windows NT/2000, Unix, HP

 JOB DESCRIPTION: This technical consultant position will be required to
 support many clients, with a broad range of disciplines. Must be a
 self-starter, excellent communication skills along with a strong technical
 expertise. This position requires strong consulting skills (i.e. some
 project management, technical leadership, background with multiple
 methodologies), complete development life cycle experience as well as a
 proven expert level in the following Oracle disciplines:

 Database Administration, Performance Tuning, Backup/Recovery Strategies,
 Installation/Upgrades, PL/SQL development (stored procedures, packages,
 database triggers, etc..), Oracle Networking (SQL*Net, Net8)

 For  immediate consideration, please send your resume as a Word attachment
to:
 OraStaff, Inc.
 Email: [EMAIL PROTECTED]
 Please use job code: One/Dallas/OCP DBA/B. Law (along with the # of the
 position interested in)
 ph: 1-800 -549-8502

 All Submissions are handled in confidence.

 *We pay referral fees.
 So please contact me if you know of anyone who would be
qualified/interested
 in the posiition described above- if it is not a match for your skills.
 Thanks,
 Bill Law





 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: OraStaff
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Problem on shadow process

[Frédéric MAJOR]

Hi,

OS : AIX 4.3.3.0
RDBMS : 8.0.6.2.0

We have a Unix daemon write in Pro*C that wake up every X minutes (I think
it's about 1)
to look at one table on an AS400 via dblinks and transparent gateway from
the AIX server.

Our problem is that the shadow process constantly increase his consomation
of memory
when we look at via the ps command at the os level.
Our only solution is to stop/start the daemon when it has reached a certain
level
of memory and before the server could not do anything :-).

Anyone has an idea ? Could you resfresh my memory of what is in the memory
of a shadow process ?
Has we have others choice for isolating the problem ?

Thanks.

Frédéric Major
DBA, Oracle 8i OCP.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?Q?Fr=E9d=E9ric_MAJOR?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Pkg Body variables

[cosltemp-g . manoj]

BDY.RTF
Description: RTF file

Re: Jr.DBA, Mid level DBA, Sr.DBA

[Yechiel Adar]

Hello Itiu

You wrote: Most people use it : 

We have a saying: zillions flies can not be wrong, eat shit.

BTW - We use NT servers.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, June 02, 2002 2:43 AM


 What's wrong with M$FT. Most people use it :  The majority cannot be
wrong.
 What's wrong with you guys. If it works, then use it. If you can make it
 work, then use it. If you can pretend that it works, then use it too.

 ltiu

 On Saturday 01 June 2002 14:53, you wrote:
  I beg to differ.
 
  All Real DBA's should be platform independent.
  (and if that platform comes from M$FT, they should probably be
undergoing
  intense therapy).
 
  -- James


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: ltiu
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rollback Segment tuning

[Stephane Faroult]

Hi Stephane,=0D
=0D
I run the script and I have =0D
=0D
OPTIMAL =3D 5 * ceil(max(v$rollstat.aveactive) / 4
/ sys.ts$.blocksize)* sy=
s.ts$.blocksize / 1024 =0D
=0D
the result is 0 K for my optimal. : )=0D
=0D
regards,=0D
Sinardy=0D

Probably not enough significant activity. It tries to set OPTIMAL to the 'average 
active' plus a security margin of 20% (to avoid too many shrinks). If you have a very 
small transaction from time to time, it can be a very low value indeed. In that case, 
you probably do not have to worry anyway ... 

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Problem on shadow process

[Stephane Faroult]

Hi,

OS : AIX 4.3.3.0
RDBMS : 8.0.6.2.0

We have a Unix daemon write in Pro*C that wake up
every X minutes (I think
it's about 1)
to look at one table on an AS400 via dblinks and
transparent gateway from
the AIX server.

Our problem is that the shadow process constantly
increase his consomation
of memory
when we look at via the ps command at the os
level.
Our only solution is to stop/start the daemon when
it has reached a certain
level
of memory and before the server could not do
anything :-).

Anyone has an idea ? Could you resfresh my memory
of what is in the memory
of a shadow process ?
Has we have others choice for isolating the problem
?

Thanks.

Frédéric Major
DBA, Oracle 8i OCP.


Packaged variables mentioned in another thread. The problem is likely to come from 
packaged procedures. Check that you do not use PL/SQL tables which you would never 
empty. FYI there is in the dbms_utility package a number of routines for relasing 
memory but they come with a number of health warnings. Do not jump on them before 
having performed a thorough PL/SQL code review.

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Problem on shadow process

[Tim Gorman]

Frederic,

Please ask the PRO*C programmer if they are making any use of the C
malloc() library at all in that program, or anything similar.  If so, then
the most likely problem is that they are not properly freeing memory after
grabbing some more.  This is a very common mistake when writing daemons in
C.  Bad habits that were disguised when writing short-running batch
programs become evident after writing long-lived daemon processes.  It's
like camping in the back country -- you have to carry out everything you
bring in, which isn't like camping in a campground...

Of course, it is possible that something inside the Oracle-managed portion
of PRO*C is doing the same, but if there is any presence of malloc() in
their code, it is almost certainly self-inflicted.  It is the first thing to
check before blaming PRO*C or Oracle...

Hope this helps...

-Tim

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 03, 2002 5:08 AM


 Hi,

 OS : AIX 4.3.3.0
 RDBMS : 8.0.6.2.0

 We have a Unix daemon write in Pro*C that wake up every X minutes (I think
 it's about 1)
 to look at one table on an AS400 via dblinks and transparent gateway from
 the AIX server.

 Our problem is that the shadow process constantly increase his consomation
 of memory
 when we look at via the ps command at the os level.
 Our only solution is to stop/start the daemon when it has reached a
certain
 level
 of memory and before the server could not do anything :-).

 Anyone has an idea ? Could you resfresh my memory of what is in the memory
 of a shadow process ?
 Has we have others choice for isolating the problem ?

 Thanks.

 Frédéric Major
 DBA, Oracle 8i OCP.

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-1?Q?Fr=E9d=E9ric_MAJOR?=
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Jr.DBA, Mid level DBA, Sr.DBA

[Tim Gorman]

...and what makes you think that we all don't?  Do you know anything about
how wine and beer are made?

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 03, 2002 5:43 AM


 Hello Itiu

 You wrote: Most people use it : 

 We have a saying: zillions flies can not be wrong, eat shit.

 BTW - We use NT servers.

 Yechiel Adar
 Mehish
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Sunday, June 02, 2002 2:43 AM


  What's wrong with M$FT. Most people use it :  The majority cannot be
 wrong.
  What's wrong with you guys. If it works, then use it. If you can make it
  work, then use it. If you can pretend that it works, then use it too.
 
  ltiu
 
  On Saturday 01 June 2002 14:53, you wrote:
   I beg to differ.
  
   All Real DBA's should be platform independent.
   (and if that platform comes from M$FT, they should probably be
 undergoing
   intense therapy).
  
   -- James
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: ltiu
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  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: Yechiel Adar
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Functions

[Sherrie . Kubis]

Hello all.  I am seeking opinions of experienced database folks on this
issue:

I am implementing a replication environment between IBM DB2 and UNIX Oracle
using DataMirror's Transformation Server (TS) product.   TS replicates and
transforms data between disparate databases.  (Right now I am using
Oracle's
snapshot with Transparent Gateway to do this, but must do a total refresh
each
night.  Using TS gives me net change.)   One requirement for a simple
transformation
of data is to convert the columns LATITUDE NUMBER(8,2) into LATDEG NUMBER,
LATMIN NUMBER and LATSEC NUMBER.  At the onset of this product I planned to
us TS to perform the translation.  I have this working just fine.

Our DB2 and Oracle groups are 'culturally' different in their thinking.
The DB2 DBA
is pushing to create a DB2 user-defined function that accepts the LATITUDE
value
and returns the three LATDEG LATMIN and LATSEC values, rather than use TS.
At
this point it is unclear to me on the reasoning for this.  However, my
reasons for wanting
to do this function within my tool are:
 1) Easier administration.  By keeping all replication processes within
one
 area, it is easier to support.
 2) The DEG, MIN and SEC columns are ultimately used on the
Oracle side.
   Seems unnecessary to put more into the DB2 side when
we're moving
   to the direction of Oracle.

I'd like to say performance is a reason, but I'm not sure this is a valid
reason.  Seems that
using a DB2 function or TS derived expression in terms of performance will
be comparable.

Do you have any insights or thoughts to share that may help me in this
decision?
My appreciation in advance.


---
Sherrie Kubis
Southwest Florida Water Management District
2379 Broad Street
Brooksville FL 34604-6899

Phone:  (352) 796-7211, Ext. 4033
Fax: (352) 754-6776
Email:  Mailto:[EMAIL PROTECTED]




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Setting Up EXTPROC

[John Weatherman]

Hi all,

I've recently been asked to set up an extproc listener and as this is the
first non-apps one I have had to deal with, I was hopping somebody could
give some pointers.  I have RTFM, and sarcasm it's oh so clear /sarcasm.
Anyway, how does one go about figuring out the LISTENER_KEY?  Is the
EXTPROC_SID really a SID, or a program name (like FNDFS or OEORPC in the
Apps)?  Is the ORACLE_HOME really the ORACLE_HOME or the directory the
program name is in (again, like the apps).   Any real examples would be
greatly appreciated.

Thanks, 

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Setting Up EXTPROC

[Igor Neyman]

In address_list to listen for extproc connection through IPC protocol use
EXTPROC0 as a KEY.
SID_NAME for extproc is always PLSExtProc.
ORACLE_HOME is your regular oracle_home directory.

Here is an example:

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  )
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
  )
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = PLNT))
  )
)
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = d:\OraNT)
  (PROGRAM = extproc)
)
(SID_DESC =
  (GLOBAL_DBNAME = PLNT)
  (ORACLE_HOME = d:\OraNT)
  (SID_NAME = PLNT)
)
  )



Igor Neyman, OCP DBA
[EMAIL PROTECTED]

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 03, 2002 9:28 AM


 Hi all,

 I've recently been asked to set up an extproc listener and as this is the
 first non-apps one I have had to deal with, I was hopping somebody could
 give some pointers.  I have RTFM, and sarcasm it's oh so clear
/sarcasm.
 Anyway, how does one go about figuring out the LISTENER_KEY?  Is the
 EXTPROC_SID really a SID, or a program name (like FNDFS or OEORPC in the
 Apps)?  Is the ORACLE_HOME really the ORACLE_HOME or the directory the
 program name is in (again, like the apps).   Any real examples would be
 greatly appreciated.

 Thanks,

 John P Weatherman
 Database Administrator
 Replacements Ltd.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: John Weatherman
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: dblink mysql to oracle

[Igor Neyman]

Read on Oracle's Heterogeneous Services, allows to connect (through db-link)
to foreign databases using ODBC.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, June 02, 2002 8:08 PM



 i want to be able to select mysql data from oracle simular (in some way)
 to how i do via dblinks 'select * from table@otherdb'

 is there a way to do something like this?

 ---
 Gabriel C. Millerd |  Eternal nothingness is fine if you happen to be
  Super Plumber |  dressed for it. -- Woody Allen
|

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Gabriel C Millerd
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 and Tru64

[Hemant K Chitale]

I'd never heard that Oracle has stopped 
or is stopping support for Tru64.
We have more than 35 production databases
on Tru64 and have no intention of moving
out of Alpha-Tru64 in a hurry.  We're even
looking at upgrading a mission critical
8iOPS cluster on Tru64 to 9iRAC on Tru64.

Hemant K Chitale

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, 02 June, 2002 9:28 PM


 Stephane Faroult wrote:
 
  ...Historically, Oracle was a port to
  Digital (remember this brand?)
 
 Interesting.  I'm reading this list because of a recent
 project to retire the Digital-Alpha workstations.
 The main reason that these machines must be de-commissioned is
 because Oracle stopped supporting Tru64.
 (Although it needs to be done EVENTUALLY, since Alpha
   is basicly dead anyway.)
 
 The Alphas were bought to retire the VMS from 4-7 years ago!
 
 Talk about unfortunate planning!
 -- 
 Aaron Birenboim | The top three attributes of a good programmer:
 Albuquerque, NM |Laziness, Impatience, and Hubris
 [EMAIL PROTECTED]  |
 boim.com/~aaron | -- Randall Schwartz, author of perl references
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Aaron Birenboim
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: RMAN - Disk vs Tape backups

[DENNIS WILLIAMS]

Pat 
Excellent summary. I have only a few points to add. I must point out
that I am an RMAN novice, just getting brief spurts of time between other
people's priorities. 
  - If you use RMAN to back up to disk, I haven't figured an advantage to
backing archive logs up with RMAN. If anyone knows an advantage, I would
appreciate hearing it. Obviously if you are using RMAN to write to the MML,
it makes excellent sense to back up the archive logs, but writing to disk,
you just create an extra copy of your archive logs on disk, which eventually
gets copied to tape. RMAN will apply the archive logs, whether you've given
it charge of them or not. Since you are probably doing RMAN incremental
backups each day, you probably only need today's archive logs anyway.
  - I appreciate your points on disaster recovery. This topic rarely seems
to come up with RMAN. We are into what might be termed poor man's disaster
recovery. This isn't where you have a duplicate computer room in another
city (how do I apply to be the DBA at one of those facilities), but where
you take backup tapes offsite and your hardware vendor promises to find you
a replacement server somewhere to load your tapes into.
  - The disaster recovery scenario our systems manager insists on is your
server just burned to the floor, go get your backup tape from the offsite
vendor and go to a another location and get your system going. The key is
making sure that everything you need gets on that tape. I agree with you,
that when you rely on an MML, that is one more layer of uncertainty. How can
you make sure there isn't some key disk file the MML relies on, unless you
test the scenario.
  - Someone on this list gave me the advice that it is easier to learn RMAN
by backing up to disk.
  - A lot will depend on your site. I would expect that the larger the site,
the more benefit would be derived from and MML. And the more chance to get
payback from the training and learning.
  - More disk space - when my system administrator realized by backing up to
disk he wouldn't need to learn how to interface Veritas to Oracle, he was
most enthusiastic about finding more disk space.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, May 31, 2002 4:05 PM
To: Multiple recipients of list ORACLE-L


I am currently wrestling with whether to implement 'rman disk backups' or
'rman tape backups'.
I have put together the following PRO's and CON's list so that I can weigh
my options.
I am putting this out to those on the list that are working with RMAN and
care to add to the points i have made. 
It is open for discussion - I look forward to reading your responses.

PS : Either CC me on all question responses or I will get back to you on
Monday  - I am currently in Oracle-L digest mode.

Thanks


TAPE 
With this option rman directs the rman backup directly to tape.

PROs

- Disk Maintenance issues are not applicable ;
You do not have to be concerned about whether you have enough disk space for
your backups.
You do not have to setup, maintain and monitor daily cleanup jobs.
- Rman will be able to automate the recovery process for you ;
Rman knows where the backups reside (tape) and will recover them to disk -
as needed by the recovery process.
- Setting up a hourly remote copies of any new archive logs is easy - just
setup a tape archive copy.


CONs

- Recovery is slower (disk verse tape).
- When duplicating your database to a different server or in a true
disaster, where you have lost a server and you need to rebuild the instance
on a new server - You will have the added task (and time) of installing and
configuring the Media Management Layer (ie; Legato).  Since your backups
reside on tape, the Media Management layer on the Oracle Server needs to be
installed and configured before you can talk with the backup server.
- You have to concern yourself about tape resource issues ;
A 'CROSSCHECK' or 'VERIFY'  of your backup may keep the tape subsystem busy
loading, unloading and positioning tapes.  If your tape subsystem is used
for other purposes other then your backup - then you could run into
resourcing issues around when and if you should be running these jobs.
- Also the submitting and scheduling of these tape backup jobs will probably
move out of the dba's control (cron) and into the tape management scheduling
group's control. 
- With this option you must be use rman Backups.  Rman Image copies can
not be directed to tape. 


DISK 

With this option rman directs the rman backup directly to disk.
All of the Disk Pro's and Con's that I came up with were just the mirror
image of the Tape Con's and Pro's.

The catch with this option is you probably do not have enough disk space to
store all of your backups on disk, therefore you will need to put into place
a procedure that backs up your rman backup files to tape and then deletes
them from disk.  Note that rman will still think that all of these backups
still reside on disk therefore 

Re[2]: Oracle and Tru64

[dgoulet]

Well, from a browse of Metalink, if your on a version of TRU64 = 5.0 you are
desupported.

Dick Goulet

Reply Separator
Author: Hemant K Chitale [EMAIL PROTECTED]
Date:   6/3/2002 6:53 AM


I'd never heard that Oracle has stopped 
or is stopping support for Tru64.
We have more than 35 production databases
on Tru64 and have no intention of moving
out of Alpha-Tru64 in a hurry.  We're even
looking at upgrading a mission critical
8iOPS cluster on Tru64 to 9iRAC on Tru64.

Hemant K Chitale

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, 02 June, 2002 9:28 PM


 Stephane Faroult wrote:
 
  ...Historically, Oracle was a port to
  Digital (remember this brand?)
 
 Interesting.  I'm reading this list because of a recent
 project to retire the Digital-Alpha workstations.
 The main reason that these machines must be de-commissioned is
 because Oracle stopped supporting Tru64.
 (Although it needs to be done EVENTUALLY, since Alpha
   is basicly dead anyway.)
 
 The Alphas were bought to retire the VMS from 4-7 years ago!
 
 Talk about unfortunate planning!
 -- 
 Aaron Birenboim | The top three attributes of a good programmer:
 Albuquerque, NM |Laziness, Impatience, and Hubris
 [EMAIL PROTECTED]  |
 boim.com/~aaron | -- Randall Schwartz, author of perl references
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Aaron Birenboim
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 and Tru64

[DENNIS WILLIAMS]

Stephane, Hemant
Below is the official word that I pulled off HP's website. It is
straight PR material, so read between the words as you choose. As I recall,
Compaq had already decided not to build the next-generation Alpha chip
before the merger arose. If you are interested, I would suggest that you
attend the HP roadshow when it comes to a city near you and ask them the
hard questions yourself. Having worked for a computer manufacturer in the
past, I can assure you that the manufacturer would appreciate it if you
bought the last system to come off the production line, then never called
them for support. My company plans to continue operating our Tru64 systems
for several years to come, and they have provided wonderful service. But
we're purchasing new Sun systems.

In this session, an HP Executive will highlight the important current and
future role HP's business critical and high performance AlphaServer(tm)
products play. We will also discuss the latest advancements across the hp
AlphaServer product family, the latest on the future Itanium® processor
family, and provide an update on the related operating systems strategy. In
particular, we will share the updated OpenVMS(tm) roadmap for continued
development and support on the AlphaServer platform as well as a review of
the progress to date for porting OpenVMS to Itanium®-based systems.
Discussion will also include the most up-to-the-minute plans for integrating
Tru64(tm) UNIX® into HP-UX on the Itanium® architecture and the continued
development and support of Tru64 UNIX on the AlphaServer platform.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, June 03, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L



I'd never heard that Oracle has stopped 
or is stopping support for Tru64.
We have more than 35 production databases
on Tru64 and have no intention of moving
out of Alpha-Tru64 in a hurry.  We're even
looking at upgrading a mission critical
8iOPS cluster on Tru64 to 9iRAC on Tru64.

Hemant K Chitale

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, 02 June, 2002 9:28 PM


 Stephane Faroult wrote:
 
  ...Historically, Oracle was a port to
  Digital (remember this brand?)
 
 Interesting.  I'm reading this list because of a recent
 project to retire the Digital-Alpha workstations.
 The main reason that these machines must be de-commissioned is
 because Oracle stopped supporting Tru64.
 (Although it needs to be done EVENTUALLY, since Alpha
   is basicly dead anyway.)
 
 The Alphas were bought to retire the VMS from 4-7 years ago!
 
 Talk about unfortunate planning!
 -- 
 Aaron Birenboim | The top three attributes of a good programmer:
 Albuquerque, NM |Laziness, Impatience, and Hubris
 [EMAIL PROTECTED]  |
 boim.com/~aaron | -- Randall Schwartz, author of perl references
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Aaron Birenboim
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: dblink mysql to oracle

[Gogala, Mladen]

I dunno about MySQL, but from oracle you can have external procedures
accessing MySQL and returning data into oracle. There is also a TNS API
which allows you to write your very own transparent gateway and select
data from MySQL.

 -Original Message-
 From: Gabriel C Millerd [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, June 02, 2002 8:08 PM
 To: Multiple recipients of list ORACLE-L
 Subject: dblink mysql to oracle
 
 
 
 i want to be able to select mysql data from oracle simular 
 (in some way)
 to how i do via dblinks 'select * from table@otherdb'
 
 is there a way to do something like this?
 
 ---
 Gabriel C. Millerd |  Eternal nothingness is fine if you 
 happen to be
  Super Plumber |  dressed for it. -- Woody Allen
|
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Gabriel C Millerd
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 and Tru64

[Michael P Sale]

I can confirm that Tru64 is quite alive and well at Oracle, no desupport
seen in the future. In fact there are new efforts going into Tru64 RAC.
Even when the alpha goes away there is an effort to port Tru64 to the
intel platform, but who knows where that is going with the merger :)

Regards,

Michael Sale
Author: Oracle9i for Windows(R) 2000 Tips  Techniques
http://www.amazon.com/exec/obidos/ASIN/0072194626


-Original Message-
Chitale
Sent: Monday, June 03, 2002 8:53 AM
To: Multiple recipients of list ORACLE-L



I'd never heard that Oracle has stopped 
or is stopping support for Tru64.
We have more than 35 production databases
on Tru64 and have no intention of moving
out of Alpha-Tru64 in a hurry.  We're even
looking at upgrading a mission critical
8iOPS cluster on Tru64 to 9iRAC on Tru64.

Hemant K Chitale

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, 02 June, 2002 9:28 PM


 Stephane Faroult wrote:
 
  ...Historically, Oracle was a port to
  Digital (remember this brand?)
 
 Interesting.  I'm reading this list because of a recent project to 
 retire the Digital-Alpha workstations. The main reason that these 
 machines must be de-commissioned is because Oracle stopped supporting 
 Tru64. (Although it needs to be done EVENTUALLY, since Alpha
   is basicly dead anyway.)
 
 The Alphas were bought to retire the VMS from 4-7 years ago!
 
 Talk about unfortunate planning!
 --
 Aaron Birenboim | The top three attributes of a good programmer:
 Albuquerque, NM |Laziness, Impatience, and Hubris
 [EMAIL PROTECTED]  |
 boim.com/~aaron | -- Randall Schwartz, author of perl references
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Aaron Birenboim
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Michael P Sale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Upgrade Question

[Hamid Alavi]

Hi List,

Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to
8.1.7.4 but after few minutes I got the following message:
There are no Patches need to be applied from the patch set oracle 8i patch
set 8.1.7.4.0 and doesn't go thru at all,  My question is for installing
any patch do I have to install the previous patch first or what?
Is there any Prepatch to Install for any patching or NOT?
We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better 
safer??
If I want to go for Patch 4,is there any comments or recommendation 
Really appreciate



Hamid Alavi
Office 818 737-0526
Cell818 402-1987






=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Solution to Microsoft Transaction Server/Standby database problem

[Miller, Jay]

Some of you may recall a question I posted on a problem with MTS connection
pooling.  MTS continued to try to connect to our old IP address after
switching between production and standby.  This happened even though we
switched the IP address the DNS Name was pointing to.

Well, we finally managed to replicate the problem in our test environment
through using a loadrunner script so it is a load related issue.  Even
better, using a TAF entry in the tnsnames.ora resolves most of the problem,
although it takes several (i.e., app. 2-3) minutes for the switchover to
take effect for all connections.  Still not certain what's happening in that
time period, but it works!

If we ever manage to figure out why the problem is happening I'll post
again, but wanted to post this now in case anyone else has similar issues.

Jay Miller
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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-L Digest -- Volume 2002, Number 152

[chris blais]

All,
For what its worth, I believe Rachel has the best approach to the SA / DBA relations dilemma. -). 

Another approach, I developed, consists of a matrix that helps delineate SA, DBA, lead and Architect responsibilities.  

Please feel free to download it and use at will.  The on-line version is located at
http://www.blazingpathways.com/DBAresp_mtrx1_hilevel_ver.PDF  (sorry about the lack of a hyperlink)

I first used it at a large Mutual Fund Co in Boston 6 yrs ago and have used it at most if not at all of my client's since with great success. 
(Dir's and VP's have tended to implement it since it also tends to make there life easier...-).  

The important part is that it facilitates communication and buy-in ...

Please feel free to email me at the link below for the detailed version or if you have any questions.

HTH's,
Thanks,

A. Chris Blais
Principal DBA
www.blazingpathways.com
[EMAIL PROTECTED]

--- Rachel Carmichael wrote:
>see, this is why I always bribe my SAs. chocolate >seems to work well,
>beers after work as necessary :)


--- Joe LaCascio  wrote:
> 
> For what it's worth I'll add my .02 cents worth to this.  I've been
> in IT now for 14 years, started with Informix for my first 3 or 4
> years,
> the rest with Oracle.  I've seen my share of duhvelopers but get the
> best giggles from the "fights" that happen between DBA's and System
> Admins.  You know the type I'm talking about, the DBA says the
> semaphores
> need to be tweaked and the System Admin knows nothing about Oracle
> and
> doesn't want a lowly DBA to poke around ;-)
> 
> In my humble opinion, perfect path to DBA enlightenment:
> 
> A couple or three years as a developer,
> a few as a System Admin
> a year as a junior DBA learning the Job
> 
> Joe

--- Oracle RDBMS Community Forum <[EMAIL PROTECTED]> wrote:
> ORACLE-L Digest Sat, 01 Jun 2002
> Volume 2002, Number 152
> 
> In This Issue:
> 
>   Subject 
> Author
>   --- 
> 
>   Re: Jr.DBA, Mid level DBA, Sr.DBA   
> "Yechiel Adar" <[EMAIL PROTECTED]
>   RE: For real Gurus only 
> "Sinardy Xing"    RE: RE: Advice needed please
> "Stephane Faroult"   ORA-600 
> =?iso-8859-1?q?Nalla=20Ravi?=Archive log full sam d
> <[EMAIL PROTECTED]>
>   Re: RMAN error registering database 
> [EMAIL PROTECTED]
>   Re: RMAN error registering database 
> "MICHAEL.SALE"    Re: So, What is a 'Production DBA'?  Joe
> LaCascio    RE: Archive log full
> Clinton Naude <[EMAIL PROTECTED]
>   Re: Archive log full "Jack
> van Zanen" <[EMAIL PROTECTED]
>   RE: Urgent: Prodution database recovery  "Jack
> van Zanen" <[EMAIL PROTECTED]
>   RE: problem using ROWNUM and ORDER BY claus 
> "Mercadante, Thomas F"    RE: Archive log full
> "Mercadante, Thomas F"    Re:RE: partition tables 
> [EMAIL PROTECTED]
>   Re: RMAN error registering database - solve 
> "Danny Hughes"    RE: ORA-600 
> "Michael P Sale"    RE: Archive log full
> "Michael P Sale"    RE: So, What is a 'Production DBA'? 
> Hately Mike    Re: So, What is a 'Production DBA'? 
> Rachel Carmichael    * Certified Oracle DBAs Needed in the Dalla 
> OraStaff <[EMAIL PROTECTED]
>   Re:RE: partition tables 
> Rachel Carmichael    Re: partition tables
> =?iso-8859-1?q?paquette=20stepha
>   RE: partition tables
> DENNIS WILLIAMS    RE: So, What is a 'Production DBA'? 
> DENNIS WILLIAMS    MySQL versus Oracle  Joe
> Testa <[EMAIL PROTECTED]>   
>   Re: * Certified Oracle DBAs Needed in the D  Joe
> Testa <[EMAIL PROTECTED]>   
>   Re: partition tables
> Steven Lembark    Re:MySQL versus Oracle  
> [EMAIL PROTECTED]
>   Re[2]: So, What is a 'Production DBA'?  
> [EMAIL PROTECTED]
>   RE: partition tables Jack
> Silvey <[EMAIL PROTECTED]
>   RE: RE: partition tables
> "Michael P Sale"    RE: partition tables "Ron
> Rogers"    RE: MySQL versus Oracle 
> "Weaver, Walt"    RE: * Certified Oracle DBAs Needed in the D 
> "Mercadante, Thomas F"    RE: * Certified Oracle DBAs Needed in the D 
> "Whittle Jerome Contr NCI"Design 

RE: Upgrade Question

[Hamid Alavi]

Ron,
Thanks for replay, But still don't know what I have to do to solve the
problem, do I have to change some thing or what?
Can you please explain more?
Thanks allot

-Original Message-
Sent: Monday, June 03, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L



You generally get this error if the conents of the file
/var/opt/oracle/oraInst.loc points to the
wrong OraInventory directory.

We just went to 8.1.7.4 to resolve some issues with .2.  So far, so good.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're
sober.  --William Butler
Yeats.


 

  hamid.alavi@quova

  dx.com   To:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  Upgrade Question

 

 

  06/03/02 09:18 AM

  Please respond to

  ORACLE-L

 

 





Hi List,

Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to
8.1.7.4 but after few minutes I got the following message:
There are no Patches need to be applied from the patch set oracle 8i patch
set 8.1.7.4.0 and doesn't go thru at all,  My question is for installing
any patch do I have to install the previous patch first or what?
Is there any Prepatch to Install for any patching or NOT?
We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better 
safer??
If I want to go for Patch 4,is there any comments or recommendation
Really appreciate



Hamid Alavi
Office 818 737-0526
Cell818 402-1987






=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the individual or entity to which it is
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
and exempt from disclosure under applicable law.  If you have received
this message in error, you are prohibited from copying, distributing, or
using the information.  Please contact the sender immediately by return
e-mail and delete the original message from your system.
= End Confidentiality Statement =


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Ron Thomas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).





=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Upgrade Question

[Ray Stell]

Oracle database patchsets for UNIX are cumulative. Applying the latest
patchset will include all of the fixes in previous patchsets for the
same baseline version. (i.e. The 8.1.7.4.0 will include the fixes in
8.1.7.3). Unless otherwise noted, you can apply the latest patchset
with out applying lower patchsets first.  Read the readme associated
with the patch to see if anything is otherwise noted.


On Mon, Jun 03, 2002 at 08:18:22AM -0800, Hamid Alavi wrote:
 My question is for installing
 any patch do I have to install the previous patch first or what?
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Upgrade Question

[Ron Thomas]

You generally get this error if the conents of the file /var/opt/oracle/oraInst.loc 
points to the
wrong OraInventory directory.

We just went to 8.1.7.4 to resolve some issues with .2.  So far, so good.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're sober.  
--William Butler
Yeats.


   
   
  hamid.alavi@quova
   
  dx.com   To:   [EMAIL PROTECTED]  
   
  Sent by: cc: 
   
  [EMAIL PROTECTED] Subject:  Upgrade Question  
   
   
   
   
   
  06/03/02 09:18 AM
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




Hi List,

Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to
8.1.7.4 but after few minutes I got the following message:
There are no Patches need to be applied from the patch set oracle 8i patch
set 8.1.7.4.0 and doesn't go thru at all,  My question is for installing
any patch do I have to install the previous patch first or what?
Is there any Prepatch to Install for any patching or NOT?
We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better 
safer??
If I want to go for Patch 4,is there any comments or recommendation
Really appreciate



Hamid Alavi
Office 818 737-0526
Cell818 402-1987






=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the individual or entity to which it is
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
and exempt from disclosure under applicable law.  If you have received
this message in error, you are prohibited from copying, distributing, or
using the information.  Please contact the sender immediately by return
e-mail and delete the original message from your system.
= End Confidentiality Statement =


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Ron Thomas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Upgrade Question

[Hamid Alavi]

I have also two other instances running on 8.1.6.2, This upgrade may be
effected from these version of Oracle or not, or this upgrade can be totaly
independent from 8.1.6.2
I am a bit confused, Need your advise guy
Thanks allot

-Original Message-
Sent: Monday, June 03, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L



You generally get this error if the conents of the file
/var/opt/oracle/oraInst.loc points to the
wrong OraInventory directory.

We just went to 8.1.7.4 to resolve some issues with .2.  So far, so good.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're
sober.  --William Butler
Yeats.


 

  hamid.alavi@quova

  dx.com   To:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  Upgrade Question

 

 

  06/03/02 09:18 AM

  Please respond to

  ORACLE-L

 

 





Hi List,

Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to
8.1.7.4 but after few minutes I got the following message:
There are no Patches need to be applied from the patch set oracle 8i patch
set 8.1.7.4.0 and doesn't go thru at all,  My question is for installing
any patch do I have to install the previous patch first or what?
Is there any Prepatch to Install for any patching or NOT?
We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better 
safer??
If I want to go for Patch 4,is there any comments or recommendation
Really appreciate



Hamid Alavi
Office 818 737-0526
Cell818 402-1987






=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the individual or entity to which it is
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
and exempt from disclosure under applicable law.  If you have received
this message in error, you are prohibited from copying, distributing, or
using the information.  Please contact the sender immediately by return
e-mail and delete the original message from your system.
= End Confidentiality Statement =


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Ron Thomas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).





=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: rman duplicate dbid? AND rman catalog config options

[Pat Brenda Howe]

Dennis :

Good point.  It was not clear in my note - but yes we are going with a 
server that is dedicated to RMAN and OEM.
Instead of using the 'cross-mount architecture' we decide to backup the 
Oracle Database (RMAN and OEM) that reside on this server using a manual 
script based hot backup method.
I monitor these backups closely as they are critical to the integrity of my 
backup plan.

In thinking about it - the options I listed are probably more centered on 
just the option that I am considering.  RMAN is very flexible - thus the 
configuration options are unlimited ;
- as you specified a 'cross-mount' configuration
- the no catalog option
- rman catalog split into environments ; 'rman-prod' where all your prod 
databases are cataloged (prod1, prod2, etc), 'rman-qa' where all your qa 
databases are cataloged (qa1,q2, etc) and 'rman-dev' where all your dev 
databases are cataloged.
- etc

PS ; Sorry about not getting your name right  just a case of fat fingers 
and a desire to get the note out the door quickly - my apologies!  I 
appreciate your input into this issue.

Patrick J. Howe
Oracle DBA
Illuminet.  A Verisign Company.
4501 Intelco Loop SE
Olympia, WA 98507
Email  : [EMAIL PROTECTED]


--

Date: Fri, 31 May 2002 12:06:32 -0500

Pat - I think you've pretty well covered the pros/cons from what I
understand. I haven't implemented in production, so hopefully some people
with some experience of living with RMAN will respond. How about it guys?
One point bothered me. You didn't explicitly say that you were
keeping your RMAN catalog on a system separate from the production system it
is backing up. The nightmare situation is where you have only one system and
you store the RMAN tablespace on the same disk as some production tables.
Then the disk goes bad and you can't use RMAN to recover the tables. That is
the sort of thing that has you waking up in the middle of the night in a
cold sweat.
You were probably considering this, but I just thought I should
bring it out explicitly.
We have gone back and forth on this issue. At first, I was going to
use our test system so I could use RMAN to back up all production systems.
The system administrator didn't like that idea. He preferred a valuable
production resource to reside on a production system. I have put the RMAN
catalog on a production system we don't plan to use RMAN to back up.
I have heard some people cross-mount their RMAN catalogs. Say you
have two production systems, A and B. Put the RMAN catalog for A on system
B, and the RMAN catalog for B on system A.

Oh yeah, I don't mind you mis-spelling my name, but let's just keep the
gender consistent. It's Dennis, not Denise.

And have a good weekend.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, May 31, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L


Bill :
I have currently been wrestling with the same issues as you are : How best
to configure RMAN.
I have put together an 'RMAN Configuration Doc' with 'PROs and CONs' from
information that I have scrapped together from this list, papers and books.
Like anything in Oracle - no one configuration is right for all situations -
you have to look at your system needs and choose the best approach.
Hopefully this paper will help you in arriving at the right configuration
for your company.

Denise :
I have incorporated your thoughts into a document I have been assembling on
RMAN configuration.
I originally was leaning towards going with OPTION1 just for the KISS law
(keep it simple stupid) - but a lot of what you said made sense and the PROs
list is growing for OPTION2.
Since I am still just playing around with the product I have the option of
going with what ever path I see fit.

All :
If anyone has anything to add - I would be glad to hear from you - this is a
work in progress.

Thanks


RMAN CATALOG CONFIGURATION OPTIONS


--

From a RMAN catalog perspective we have many configuration options ;

Configuration OPTION 1
Create one RMAN database with one RMAN catalog for all the databases that
you are backing up.
IE; If you had two databases PROD and DEV then create one RMAN database
with one RMAN Catalog in one RMAN tablespace to manage all database recovery
info.

PROS
- Simple to setup and to Simple to understand

CONS
- When using SQL to query the RMAN catalog views you will have to isolate
the database (join db key).
- You will need to manually backup (script-backup) the RMAN database.



Configuration OPTION 2
Create one RMAN database with one RMAN catalog per database that you are
backing up.
IE: If you had two databases PROD and DEV then setup one RMAN database
with an RMAN-PROD catalog and an RMAN-DEV catalog in the same RMAN
tablespace to manage each database's recovery info.

PROS
- When using SQL to query the RMAN catalog views you do not have to isolate
the database (join dbkey) because in this 

RE: RMAN - Disk vs Tape backups

[Pat Brenda Howe]

Dennis ;

You are absolutely right - the DISK option has a big down side that I did 
not catch :
In a disaster (computer room fire) the daily archive logs would be lost 
leaving you without the ability to roll forward your database - and thus the 
loss of data.  Therefore if you were to go with the DISK option - you would 
need to manually implement an remote disk or tape backup procedure for your 
daily archive logs (not an easy task) - that is if your clients could not 
live with the loss of any data.

The RMAN tape management option (as long as they are promptly stored in a 
fire resistant safe) definitely has its advantages.

Good point !



As a side note on disaster recovery ; We perform a 'disaster recovery' test 
here every 6 months.
This is a great sanity check - as it tests out our procedures and ability to 
recover from a disaster.
In our last test we simulated a loss of a production server (computer room 
lost due to fire) - and together with the SA's we rebuilt the box from the 
ground up using the backups that we had in the fireproof safe.  This 
exercise also made it very clear to our clients that given our current 
backup configuration - they would loose at most one days worth of 
transactions (the archive logs).
It also confirmed the 'assumptions' that both the DBAs and SAs were making 
about 'who was backing up and responsible for what'.
I highly recommend going thru this procedure at least once a year.



Your comment about implemented RMAN on disk first before implementing RMAN 
with a MML - We took the following approach ;
If you plan on routing your backups directly to tape - take one step back 
and begin by configuring RMAN to backup to disk first.  Thus you will 
eliminate the (major) problems associated with configuring the tape 
interface.  Once you have RMAN up and running on disk then implement the 
tape interface.   ie; Don't bite off to much at a time.

Thanks and good luck in your RMAN rollout!

_
Patrick J. Howe
Oracle DBA
Illuminet.  A Verisign Company.
4501 Intelco Loop SE
Olympia, WA 98507
Email  : [EMAIL PROTECTED]



-Original Message-

Sent: Monday, June 03, 2002 8:48 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


Pat
Excellent summary. I have only a few points to add. I must point out
that I am an RMAN novice, just getting brief spurts of time between other
people's priorities.
  - If you use RMAN to back up to disk, I haven't figured an advantage to
backing archive logs up with RMAN. If anyone knows an advantage, I would
appreciate hearing it. Obviously if you are using RMAN to write to the MML,
it makes excellent sense to back up the archive logs, but writing to disk,
you just create an extra copy of your archive logs on disk, which eventually
gets copied to tape. RMAN will apply the archive logs, whether you've given
it charge of them or not. Since you are probably doing RMAN incremental
backups each day, you probably only need today's archive logs anyway.
  - I appreciate your points on disaster recovery. This topic rarely seems
to come up with RMAN. We are into what might be termed poor man's disaster
recovery. This isn't where you have a duplicate computer room in another
city (how do I apply to be the DBA at one of those facilities), but where
you take backup tapes offsite and your hardware vendor promises to find you
a replacement server somewhere to load your tapes into.
  - The disaster recovery scenario our systems manager insists on is your
server just burned to the floor, go get your backup tape from the offsite
vendor and go to a another location and get your system going. The key is
making sure that everything you need gets on that tape. I agree with you,
that when you rely on an MML, that is one more layer of uncertainty. How can
you make sure there isn't some key disk file the MML relies on, unless you
test the scenario.
  - Someone on this list gave me the advice that it is easier to learn RMAN
by backing up to disk.
  - A lot will depend on your site. I would expect that the larger the site,
the more benefit would be derived from and MML. And the more chance to get
payback from the training and learning.
  - More disk space - when my system administrator realized by backing up to
disk he wouldn't need to learn how to interface Veritas to Oracle, he was
most enthusiastic about finding more disk space.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, May 31, 2002 4:05 PM
To: Multiple recipients of list ORACLE-L


I am currently wrestling with whether to implement 'rman disk backups' or
'rman tape backups'.
I have put together the following PRO's and CON's list so that I can weigh
my options.
I am putting this out to those on the list that are working with RMAN and
care to add to the points i have made.
It is open for discussion - I look forward to reading your responses.

PS : Either CC me on all question responses or I will get back to you 

RE: Stubborn Table Resolution

[kkennedy]

Thanks for all the helpful suggestions.  Here is what worked:

Query:
SELECT Record_Type, Archive_Input_File
FROM MDMA_Input_File
GROUP BY Record_Type, Archive_Input_File

I modified the record_type column to not null.  This allowed an index FFS which the 
optimizer wisely selected.

The update statement was more difficult.  Here is the original and my workaround:

UPDATE MDMA_INPUT_FILE
 SET Partial_Day_Hold = :b1
   , OK_To_Process = :b2
   , VEE_Usage_End = to_date(:b3)
WHERE Rowid IN ( SELECT MDMA_Rowid
FROM ST_VEE_Input_File );

Replaced by (declarations omitted):

SELECT MDMA_Rowid
  BULK COLLECT INTO T_Rowids
  FROM ST_VEE_Input_File;
FORALL V_Rowid IN T_Rowids.FIRST..T_Rowids.LAST
  UPDATE MDMA_INPUT_FILE
   SET Partial_Day_Hold = :b1
 , OK_To_Process = :b2
 , VEE_Usage_End = to_date(:b3)
  WHERE Rowid = T_Rowids(V_Rowid);

Note that the original statement I show here is what I originally coded and not the 
one I sent to the list.  The IN construction and the correlated subquery yielded 
identical performance (bad).  The bulk collect followed by the forall update 
accomplished what I had hoped the optimizer would do.  Readability suffers, but I need 
performance to dig out of the hole my predecessors and damagement have buried me in.

Kevin Kennedy
First Point Energy Corporation 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: kkennedy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Upgrade Question

[Hamid Alavi]

I couldn't find/var/opt/oracle/oraInst.loc  I am on solaris which
directory I have to look for looking at this file

-Original Message-
Sent: Monday, June 03, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L



You generally get this error if the conents of the file
/var/opt/oracle/oraInst.loc points to the
wrong OraInventory directory.

We just went to 8.1.7.4 to resolve some issues with .2.  So far, so good.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're
sober.  --William Butler
Yeats.


 

  hamid.alavi@quova

  dx.com   To:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  Upgrade Question

 

 

  06/03/02 09:18 AM

  Please respond to

  ORACLE-L

 

 





Hi List,

Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to
8.1.7.4 but after few minutes I got the following message:
There are no Patches need to be applied from the patch set oracle 8i patch
set 8.1.7.4.0 and doesn't go thru at all,  My question is for installing
any patch do I have to install the previous patch first or what?
Is there any Prepatch to Install for any patching or NOT?
We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better 
safer??
If I want to go for Patch 4,is there any comments or recommendation
Really appreciate



Hamid Alavi
Office 818 737-0526
Cell818 402-1987






=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the individual or entity to which it is
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
and exempt from disclosure under applicable law.  If you have received
this message in error, you are prohibited from copying, distributing, or
using the information.  Please contact the sender immediately by return
e-mail and delete the original message from your system.
= End Confidentiality Statement =


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Ron Thomas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).





=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 8i on Terminal server

[Streeter, Lerone A LBX]

http://metalink.oracle.com/oracleinstall/oracle8i/windows.html

this and a couple other links i've read, give the impression that oracle
with  terminal server/services is not supported.  is there a work around to
allow you to user terminal services and oracle?

i'd like to use sqlplus and connect using internal or some other
oracle-based credentials, can this be done using a thin-client connection?
=-=-=-=-=-=-=-=-=-=-=
lerone
=-=-=-=-=-=-=-=-=-=-=
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Streeter, Lerone  A LBX
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Upgrade Question

[Ron Thomas]

This is why we:
1. Use a separate tech stack (oracle home) for each instance.
1a. Use a separate unix account for each oracle home for total isolation.  The DBA 
here is real
anal.  (BTW, that's me).
1b. I've also found that it is easier to use one listener for each instance instead of 
one listener
for all instances.
1c. We go so far as to give Oracle Names its own tech stack.
2. For each tech stack install, use a separate OraInventory directory.  See metastink 
for details on
this.
3. Back up the OraInventory directory before and after an install/upgrade.  If this 
directory get
hammered, there is no way to recreate it except to re-install (Thank You Oracle! all 
the sarcasm in
the world implied here).

For those on the list that dissagree, flame away.  This is what I've found works the 
best in this
environment.

In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance upgrade 
will not effect
it.  Since the patch says that there is nothing to upgrade, the 
/var/opt/oracle/oraInst.loc file
probably points to the 8.1.6 OraInventory instead of the 8.1.7 OraInventory.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're sober.  
--William Butler
Yeats.


   
   
  hamid.alavi@quova
   
  dx.com   To:   [EMAIL PROTECTED]  
   
  Sent by: cc: 
   
  [EMAIL PROTECTED] Subject:  RE: Upgrade Question  
   
   
   
   
   
  06/03/02 10:23 AM
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




I have also two other instances running on 8.1.6.2, This upgrade may be
effected from these version of Oracle or not, or this upgrade can be totaly
independent from 8.1.6.2
I am a bit confused, Need your advise guy
Thanks allot

-Original Message-
Sent: Monday, June 03, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L



You generally get this error if the conents of the file
/var/opt/oracle/oraInst.loc points to the
wrong OraInventory directory.

We just went to 8.1.7.4 to resolve some issues with .2.  So far, so good.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're
sober.  --William Butler
Yeats.




  hamid.alavi@quova

  dx.com   To:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  Upgrade Question





  06/03/02 09:18 AM

  Please respond to

  ORACLE-L









Hi List,

Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to
8.1.7.4 but after few minutes I got the following message:
There are no Patches need to be applied from the patch set oracle 8i patch
set 8.1.7.4.0 and doesn't go thru at all,  My question is for installing
any patch do I have to install the previous patch first or what?
Is there any Prepatch to Install for any patching or NOT?
We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better 
safer??
If I want to go for Patch 4,is there any comments or recommendation
Really appreciate



Hamid Alavi
Office 818 737-0526
Cell818 402-1987






=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the individual or entity to which it is
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
and exempt from disclosure under applicable law.  If you have received
this message in 

RE: Oracle 8i on Terminal server

[Jamadagni, Rajendra]

It works fine ... the problem is when you go in for support. But if you can
reproduce the error in normal environment (i.e. without terminal server)
they will support you.

YMMV
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!



*2

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.

*2

RE: Oracle 8i on Terminal server

[Seefelt, Beth]

Yes, there is a workaround.  I use terminal services for everything,
including installs and have not had any issues.

You have to force everything to go through sqlnet by using @sidname, and
never use the bequeath adapter.

SVRMGRL connect internal@yoursid

SQLPLUS username/pwd@yoursid

or

c:\ sqlplus
Username: user@yoursid

hth,

Beth


-Original Message-
Sent: Monday, June 03, 2002 2:03 PM
To: Multiple recipients of list ORACLE-L


http://metalink.oracle.com/oracleinstall/oracle8i/windows.html

this and a couple other links i've read, give the impression that oracle
with  terminal server/services is not supported.  is there a work around
to
allow you to user terminal services and oracle?

i'd like to use sqlplus and connect using internal or some other
oracle-based credentials, can this be done using a thin-client
connection?
=-=-=-=-=-=-=-=-=-=-=
lerone
=-=-=-=-=-=-=-=-=-=-=
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Streeter, Lerone  A LBX
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Seefelt, Beth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Upgrade Question

[Ron Thomas]

Someone from the list will need to respond.  I work on HPs here and I haven't done a 
Sun install in
a few years.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're sober.  
--William Butler
Yeats.


   
   
  hamid.alavi@quova
   
  dx.com   To:   [EMAIL PROTECTED]  
   
  Sent by: cc: 
   
  [EMAIL PROTECTED] Subject:  RE: Upgrade Question  
   
   
   
   
   
  06/03/02 11:10 AM
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




I couldn't find/var/opt/oracle/oraInst.loc  I am on solaris which
directory I have to look for looking at this file

-Original Message-
Sent: Monday, June 03, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L



You generally get this error if the conents of the file
/var/opt/oracle/oraInst.loc points to the
wrong OraInventory directory.

We just went to 8.1.7.4 to resolve some issues with .2.  So far, so good.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're
sober.  --William Butler
Yeats.




  hamid.alavi@quova

  dx.com   To:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  Upgrade Question





  06/03/02 09:18 AM

  Please respond to

  ORACLE-L









Hi List,

Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to
8.1.7.4 but after few minutes I got the following message:
There are no Patches need to be applied from the patch set oracle 8i patch
set 8.1.7.4.0 and doesn't go thru at all,  My question is for installing
any patch do I have to install the previous patch first or what?
Is there any Prepatch to Install for any patching or NOT?
We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better 
safer??
If I want to go for Patch 4,is there any comments or recommendation
Really appreciate



Hamid Alavi
Office 818 737-0526
Cell818 402-1987






=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the individual or entity to which it is
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
and exempt from disclosure under applicable law.  If you have received
this message in error, you are prohibited from copying, distributing, or
using the information.  Please contact the sender immediately by return
e-mail and delete the original message from your system.
= End Confidentiality Statement =


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Ron Thomas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San 

RE: RMAN - Disk vs Tape backups

[Orr, Steve]

You mentioned disk management issues... A problem with disk is that you
are probably limited to only doing level 0 backups. If your recovery spans
multiple RMAN backups then it could be a real bear trying get everything 
you need to recover if you're staging from disk to tape. You'd have to be
very careful about keep track of your tapes.



-Original Message-
Sent: Monday, June 03, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L


Dennis ;

You are absolutely right - the DISK option has a big down side that I did 
not catch :
In a disaster (computer room fire) the daily archive logs would be lost 
leaving you without the ability to roll forward your database - and thus the

loss of data.  Therefore if you were to go with the DISK option - you would 
need to manually implement an remote disk or tape backup procedure for your 
daily archive logs (not an easy task) - that is if your clients could not 
live with the loss of any data.

The RMAN tape management option (as long as they are promptly stored in a 
fire resistant safe) definitely has its advantages.

Good point !



As a side note on disaster recovery ; We perform a 'disaster recovery' test 
here every 6 months.
This is a great sanity check - as it tests out our procedures and ability to

recover from a disaster.
In our last test we simulated a loss of a production server (computer room 
lost due to fire) - and together with the SA's we rebuilt the box from the 
ground up using the backups that we had in the fireproof safe.  This 
exercise also made it very clear to our clients that given our current 
backup configuration - they would loose at most one days worth of 
transactions (the archive logs).
It also confirmed the 'assumptions' that both the DBAs and SAs were making 
about 'who was backing up and responsible for what'.
I highly recommend going thru this procedure at least once a year.



Your comment about implemented RMAN on disk first before implementing RMAN 
with a MML - We took the following approach ;
If you plan on routing your backups directly to tape - take one step back 
and begin by configuring RMAN to backup to disk first.  Thus you will 
eliminate the (major) problems associated with configuring the tape 
interface.  Once you have RMAN up and running on disk then implement the 
tape interface.   ie; Don't bite off to much at a time.

Thanks and good luck in your RMAN rollout!

_
Patrick J. Howe
Oracle DBA
Illuminet.  A Verisign Company.
4501 Intelco Loop SE
Olympia, WA 98507
Email  : [EMAIL PROTECTED]



-Original Message-

Sent: Monday, June 03, 2002 8:48 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


Pat
Excellent summary. I have only a few points to add. I must point out
that I am an RMAN novice, just getting brief spurts of time between other
people's priorities.
  - If you use RMAN to back up to disk, I haven't figured an advantage to
backing archive logs up with RMAN. If anyone knows an advantage, I would
appreciate hearing it. Obviously if you are using RMAN to write to the MML,
it makes excellent sense to back up the archive logs, but writing to disk,
you just create an extra copy of your archive logs on disk, which eventually
gets copied to tape. RMAN will apply the archive logs, whether you've given
it charge of them or not. Since you are probably doing RMAN incremental
backups each day, you probably only need today's archive logs anyway.
  - I appreciate your points on disaster recovery. This topic rarely seems
to come up with RMAN. We are into what might be termed poor man's disaster
recovery. This isn't where you have a duplicate computer room in another
city (how do I apply to be the DBA at one of those facilities), but where
you take backup tapes offsite and your hardware vendor promises to find you
a replacement server somewhere to load your tapes into.
  - The disaster recovery scenario our systems manager insists on is your
server just burned to the floor, go get your backup tape from the offsite
vendor and go to a another location and get your system going. The key is
making sure that everything you need gets on that tape. I agree with you,
that when you rely on an MML, that is one more layer of uncertainty. How can
you make sure there isn't some key disk file the MML relies on, unless you
test the scenario.
  - Someone on this list gave me the advice that it is easier to learn RMAN
by backing up to disk.
  - A lot will depend on your site. I would expect that the larger the site,
the more benefit would be derived from and MML. And the more chance to get
payback from the training and learning.
  - More disk space - when my system administrator realized by backing up to
disk he wouldn't need to learn how to interface Veritas to Oracle, he was
most enthusiastic about finding more disk space.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, May 31, 2002 4:05 PM
To: Multiple recipients of 

RE: Upgrade Question

[Gogala, Mladen]

That file is the pointer for the installer to know where to look
for things. It's usually in the same place as oratab. As for the SUN 
install, let me quote the girl from the original Jurassic Park: It's a Unix
system! I know how to use that!

 -Original Message-
 From: Ron Thomas [mailto:[EMAIL PROTECTED]]
 Sent: Monday, June 03, 2002 2:40 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Upgrade Question
 
 
 
 Someone from the list will need to respond.  I work on HPs 
 here and I haven't done a Sun install in
 a few years.
 
 Ron Thomas
 Hypercom, Inc
 [EMAIL PROTECTED]
 The problem with some people is that when they aren't drunk, 
 they're sober.  --William Butler
 Yeats.
 
 
   
   
   
   hamid.alavi@quova   
   
   
   dx.com   To:   
 [EMAIL PROTECTED]  

   Sent by: cc:
   
   
   [EMAIL PROTECTED] Subject:  RE: 
 Upgrade Question  

   
   
   
   
   
   
   06/03/02 11:10 AM   
   
   
   Please respond to   
   
   
   ORACLE-L
   
   
   
   
   
   
   
   
 
 
 
 
 I couldn't find/var/opt/oracle/oraInst.loc  I am on 
 solaris which
 directory I have to look for looking at this file
 
 -Original Message-
 Sent: Monday, June 03, 2002 9:59 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 You generally get this error if the conents of the file
 /var/opt/oracle/oraInst.loc points to the
 wrong OraInventory directory.
 
 We just went to 8.1.7.4 to resolve some issues with .2.  So 
 far, so good.
 
 Ron Thomas
 Hypercom, Inc
 [EMAIL PROTECTED]
 The problem with some people is that when they aren't drunk, they're
 sober.  --William Butler
 Yeats.
 
 
 
 
   hamid.alavi@quova
 
   dx.com   To:
 [EMAIL PROTECTED]
 
   Sent by: cc:
 
   [EMAIL PROTECTED] Subject:  
 Upgrade Question
 
 
 
 
 
   06/03/02 09:18 AM
 
   Please respond to
 
   ORACLE-L
 
 
 
 
 
 
 
 
 
 Hi List,
 
 Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to
 8.1.7.4 but after few minutes I got the following message:
 There are no Patches need to be applied from the patch set 
 oracle 8i patch
 set 8.1.7.4.0 and doesn't go thru at all,  My question is 
 for installing
 any patch do I have to install the previous patch first or what?
 Is there any Prepatch to Install for any patching or NOT?
 We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which 
 one is better 
 safer??
 If I want to go for Patch 4,is there any comments or recommendation
 Really appreciate
 
 
 
 Hamid Alavi
 Office 818 737-0526
 Cell818 402-1987
 
 
 
 
 
 
 === Confidentiality Statement 
 ===
 The information contained in this message and any attachments is
 intended only for the use of the individual or entity to which it is
 addressed, and may contain information that is PRIVILEGED, 
 CONFIDENTIAL
 and exempt from disclosure under applicable law.  If you have received
 this message in error, you are prohibited from copying, 
 distributing, or
 using the information.  Please contact the sender immediately 
 by return
 e-mail and delete the original message from your system.
 = End Confidentiality Statement 
 =
 
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Hamid Alavi
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public 

RE: RMAN - Disk vs Tape backups

[Jay Hostetter]

Where is your tape during the computer room fire?  We have a script that copies 
archivelogs to a remote server.  This way, when the computer rooms burns, we can 
recover up to the last log switch (which we also force via a script a few times a 
day).  We only keep 1 day's worth of archive logs on the remote server, which is 
enough to protect us from total disasters between backups.

We have specific disks designated for our backups.  We use rman to backup our 
databases to these disks, including the archivelogs.  That way we only have to go to 
one place to find our backup files.  We don't have to keep track of archivelog 
destinations for each database.  

Jay

 [EMAIL PROTECTED] 06/03/02 01:43PM 
Dennis ;

You are absolutely right - the DISK option has a big down side that I did
not catch :
In a disaster (computer room fire) the daily archive logs would be lost 
leaving you without the ability to roll forward your database - and thus the 
loss of data.  Therefore if you were to go with the DISK option - you would 
need to manually implement an remote disk or tape backup procedure for your 
daily archive logs (not an easy task) - that is if your clients could not
live with the loss of any data.

The RMAN tape management option (as long as they are promptly stored in a
fire resistant safe) definitely has its advantages.

Good point !



As a side note on disaster recovery ; We perform a 'disaster recovery' test 
here every 6 months.
This is a great sanity check - as it tests out our procedures and ability to 
recover from a disaster.
In our last test we simulated a loss of a production server (computer room
lost due to fire) - and together with the SA's we rebuilt the box from the
ground up using the backups that we had in the fireproof safe.  This 
exercise also made it very clear to our clients that given our current 
backup configuration - they would loose at most one days worth of 
transactions (the archive logs).
It also confirmed the 'assumptions' that both the DBAs and SAs were making
about 'who was backing up and responsible for what'.
I highly recommend going thru this procedure at least once a year.



Your comment about implemented RMAN on disk first before implementing RMAN
with a MML - We took the following approach ;
If you plan on routing your backups directly to tape - take one step back
and begin by configuring RMAN to backup to disk first.  Thus you will 
eliminate the (major) problems associated with configuring the tape 
interface.  Once you have RMAN up and running on disk then implement the
tape interface.   ie; Don't bite off to much at a time.

Thanks and good luck in your RMAN rollout!

_
Patrick J. Howe
Oracle DBA
Illuminet.  A Verisign Company.
4501 Intelco Loop SE
Olympia, WA 98507
Email  : [EMAIL PROTECTED] 



-Original Message-

Sent: Monday, June 03, 2002 8:48 AM
To: '[EMAIL PROTECTED]' 
Cc: '[EMAIL PROTECTED]' 


Pat
Excellent summary. I have only a few points to add. I must point out
that I am an RMAN novice, just getting brief spurts of time between other
people's priorities.
  - If you use RMAN to back up to disk, I haven't figured an advantage to
backing archive logs up with RMAN. If anyone knows an advantage, I would
appreciate hearing it. Obviously if you are using RMAN to write to the MML,
it makes excellent sense to back up the archive logs, but writing to disk,
you just create an extra copy of your archive logs on disk, which eventually
gets copied to tape. RMAN will apply the archive logs, whether you've given
it charge of them or not. Since you are probably doing RMAN incremental
backups each day, you probably only need today's archive logs anyway.
  - I appreciate your points on disaster recovery. This topic rarely seems
to come up with RMAN. We are into what might be termed poor man's disaster
recovery. This isn't where you have a duplicate computer room in another
city (how do I apply to be the DBA at one of those facilities), but where
you take backup tapes offsite and your hardware vendor promises to find you
a replacement server somewhere to load your tapes into.
  - The disaster recovery scenario our systems manager insists on is your
server just burned to the floor, go get your backup tape from the offsite
vendor and go to a another location and get your system going. The key is
making sure that everything you need gets on that tape. I agree with you,
that when you rely on an MML, that is one more layer of uncertainty. How can
you make sure there isn't some key disk file the MML relies on, unless you
test the scenario.
  - Someone on this list gave me the advice that it is easier to learn RMAN
by backing up to disk.
  - A lot will depend on your site. I would expect that the larger the site,
the more benefit would be derived from and MML. And the more chance to get
payback from the training and learning.
  - More disk space - when my system administrator realized by backing up to
disk he wouldn't 

How to successfully execute dmesg command from Oracle account??

[Janardhana Babu Donga]

Dear List,

When I run dmesg command from oracle account on HP-UX 11.0, it responds as
can't read kernel memory. The dmesg has the permissions: -r-xr-xr-x.
Could someone tell me what needs to be done in order to execute dmesg
command successfully from oracle account. 

Thanks,
--Babu

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janardhana Babu Donga
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rollback Segment tuning

[Jared . Still]

I find that not setting OPTIMAL seems to be optimal.

Jared





Sinardy Xing [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/02/2002 09:53 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Rollback Segment tuning


Hi all,

How to find out the smallest (minimal) transaction size from Dictionary 
view or base tables 
I try to set my OPTIMAL rollback segment base on smallest transaction size 
to prevent ora-1555. since shrinking rollback segments may cause ora-1555.


Thanks 

Sinardy
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy Xing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Upgrade Question

[Hamid Alavi]

Hello All Again,
I just find the OraInst.loc and here is the content of the file: 

inventory_loc = /opt/home/rcosme   ...don't know what's this mean?
inst_group=   

This is all about this file, Is any body know what contenet this file must
have, Do I have to put Oracle userID address here or some thing else.
Can some body send me a sample of this file please???

Oracle 8.1.7.0 on sun solaris.

Thanks allot

-Original Message-
Sent: Monday, June 03, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L



This is why we:
1. Use a separate tech stack (oracle home) for each instance.
1a. Use a separate unix account for each oracle home for total isolation.
The DBA here is real
anal.  (BTW, that's me).
1b. I've also found that it is easier to use one listener for each instance
instead of one listener
for all instances.
1c. We go so far as to give Oracle Names its own tech stack.
2. For each tech stack install, use a separate OraInventory directory.  See
metastink for details on
this.
3. Back up the OraInventory directory before and after an install/upgrade.
If this directory get
hammered, there is no way to recreate it except to re-install (Thank You
Oracle! all the sarcasm in
the world implied here).

For those on the list that dissagree, flame away.  This is what I've found
works the best in this
environment.

In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance
upgrade will not effect
it.  Since the patch says that there is nothing to upgrade, the
/var/opt/oracle/oraInst.loc file
probably points to the 8.1.6 OraInventory instead of the 8.1.7 OraInventory.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're
sober.  --William Butler
Yeats.


 

  hamid.alavi@quova

  dx.com   To:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  RE: Upgrade
Question 
 

 

  06/03/02 10:23 AM

  Please respond to

  ORACLE-L

 

 





I have also two other instances running on 8.1.6.2, This upgrade may be
effected from these version of Oracle or not, or this upgrade can be totaly
independent from 8.1.6.2
I am a bit confused, Need your advise guy
Thanks allot

-Original Message-
Sent: Monday, June 03, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L



You generally get this error if the conents of the file
/var/opt/oracle/oraInst.loc points to the
wrong OraInventory directory.

We just went to 8.1.7.4 to resolve some issues with .2.  So far, so good.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're
sober.  --William Butler
Yeats.




  hamid.alavi@quova

  dx.com   To:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  Upgrade Question





  06/03/02 09:18 AM

  Please respond to

  ORACLE-L









Hi List,

Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to
8.1.7.4 but after few minutes I got the following message:
There are no Patches need to be applied from the patch set oracle 8i patch
set 8.1.7.4.0 and doesn't go thru at all,  My question is for installing
any patch do I have to install the previous patch first or what?
Is there any Prepatch to Install for any patching or NOT?
We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better 
safer??
If I want to go for Patch 4,is there any comments or recommendation
Really appreciate



Hamid Alavi
Office 818 737-0526
Cell818 402-1987






=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the individual or entity to which it is
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
and exempt from disclosure under applicable law.  If you have received
this message in error, you are prohibited from copying, distributing, or
using the information.  Please contact the sender immediately by return
e-mail and delete the original message from your system.
= End Confidentiality Statement =


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 

RE: RMAN - Disk vs Tape backups

[DENNIS WILLIAMS]

Steve, Pat
  In our experiments so far, we had enough space to leave the level 0 backup
on disk. The other incremental backups are so small compared with the level
0, that they aren't a problem. We keep a couple of weeks of archives on
another disk anyway. All these can be backed up to tape nightly. And the
tape is taken off-site daily.
  The MML vendors seem to charge a healthy price for the Oracle client. I
don't know how much that is, but my sys admin indicated that it would buy
quite a bit of disk.
  Generally, under true disaster circumstances, losing a few days of data
wouldn't be the end of the world. Not being able to get the data back at all
because we started using some slick tool like RMAN and there is some sort of
gotcha or some file on the server didn't get considered, well . . . Not
being able to recover for a few days would be understandable. If those
critera aren't acceptable they need to start building that backup computer
room.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, June 03, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L


You mentioned disk management issues... A problem with disk is that you
are probably limited to only doing level 0 backups. If your recovery spans
multiple RMAN backups then it could be a real bear trying get everything 
you need to recover if you're staging from disk to tape. You'd have to be
very careful about keep track of your tapes.



-Original Message-
Sent: Monday, June 03, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L


Dennis ;

You are absolutely right - the DISK option has a big down side that I did 
not catch :
In a disaster (computer room fire) the daily archive logs would be lost 
leaving you without the ability to roll forward your database - and thus the

loss of data.  Therefore if you were to go with the DISK option - you would 
need to manually implement an remote disk or tape backup procedure for your 
daily archive logs (not an easy task) - that is if your clients could not 
live with the loss of any data.

The RMAN tape management option (as long as they are promptly stored in a 
fire resistant safe) definitely has its advantages.

Good point !



As a side note on disaster recovery ; We perform a 'disaster recovery' test 
here every 6 months.
This is a great sanity check - as it tests out our procedures and ability to

recover from a disaster.
In our last test we simulated a loss of a production server (computer room 
lost due to fire) - and together with the SA's we rebuilt the box from the 
ground up using the backups that we had in the fireproof safe.  This 
exercise also made it very clear to our clients that given our current 
backup configuration - they would loose at most one days worth of 
transactions (the archive logs).
It also confirmed the 'assumptions' that both the DBAs and SAs were making 
about 'who was backing up and responsible for what'.
I highly recommend going thru this procedure at least once a year.



Your comment about implemented RMAN on disk first before implementing RMAN 
with a MML - We took the following approach ;
If you plan on routing your backups directly to tape - take one step back 
and begin by configuring RMAN to backup to disk first.  Thus you will 
eliminate the (major) problems associated with configuring the tape 
interface.  Once you have RMAN up and running on disk then implement the 
tape interface.   ie; Don't bite off to much at a time.

Thanks and good luck in your RMAN rollout!

_
Patrick J. Howe
Oracle DBA
Illuminet.  A Verisign Company.
4501 Intelco Loop SE
Olympia, WA 98507
Email  : [EMAIL PROTECTED]



-Original Message-

Sent: Monday, June 03, 2002 8:48 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


Pat
Excellent summary. I have only a few points to add. I must point out
that I am an RMAN novice, just getting brief spurts of time between other
people's priorities.
  - If you use RMAN to back up to disk, I haven't figured an advantage to
backing archive logs up with RMAN. If anyone knows an advantage, I would
appreciate hearing it. Obviously if you are using RMAN to write to the MML,
it makes excellent sense to back up the archive logs, but writing to disk,
you just create an extra copy of your archive logs on disk, which eventually
gets copied to tape. RMAN will apply the archive logs, whether you've given
it charge of them or not. Since you are probably doing RMAN incremental
backups each day, you probably only need today's archive logs anyway.
  - I appreciate your points on disaster recovery. This topic rarely seems
to come up with RMAN. We are into what might be termed poor man's disaster
recovery. This isn't where you have a duplicate computer room in another
city (how do I apply to be the DBA at one of those facilities), but where
you take backup tapes offsite and your hardware vendor promises to find you
a replacement server somewhere to load 

Re: How to successfully execute dmesg command from Oracle account??

[Suzy Vordos]

To read kernel memory requires root privs, so don't think there is a way
to do that from the oracle account without some undesirable hack.

Janardhana Babu Donga wrote:
 
 Dear List,
 
 When I run dmesg command from oracle account on HP-UX 11.0, it responds as
 can't read kernel memory. The dmesg has the permissions: -r-xr-xr-x.
 Could someone tell me what needs to be done in order to execute dmesg
 command successfully from oracle account.
 
 Thanks,
 --Babu
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Janardhana Babu Donga
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 successfully execute dmesg command from Oracle accou

[Sherman, Edward]

/etc/dmesg: 'can't read kernel memory' - must be root   



  http://welcome.hp-ww.com/country/img/arrows/a_ff9900.gifprintable
http://support2.itrc.hp.com/service/cki/docDisplay.do?printable=truef_Pass
word=beige02f_RememberMe=falseTargetPage=http://support2.itrc.hp.com/servi
ce/cki/docDisplay.do?docId=20006454298docId=20006454298y=0x=0f_U
serID=CA254010 version 
path: Home
http://support2.itrc.hp.com/service/cki/enterService.do?category=c0 



  http://welcome.hp-ww.com/country/img/corners/tl_corner_10.gif
http://welcome.hp-ww.com/country/img/corners/tr_corner_10.gif 

date:8/12/94
document description:/etc/dmesg: 'can't read kernel memory' - must be
root
document id: A3413700   

  http://welcome.hp-ww.com/country/img/corners/bl_corner_10.gif
http://welcome.hp-ww.com/country/img/corners/br_corner_10.gif 


You may provide
http://support2.itrc.hp.com/service/ciss/doLogin.do?TargetPage=http://suppo
rt2.itrc.hp.com/service/cki/docDisplay.do?docId=20006454298#feedbackform
 feedback on this document 


   _  

Problem1Problem Description



What does this error mean, from /etc/dmesg ?



   'Can't read kernel memory'



Solution2Solution



You will get this message if you are not logged in as root when you

run /etc/dmesg.



Alternative3Alternative Keywords



workstation

dmesg







-Original Message-
mailto:[EMAIL PROTECTED] ]
Sent: Monday, June 03, 2002 3:05 PM
To: Multiple recipients of list ORACLE-L
account??


Dear List,

When I run dmesg command from oracle account on HP-UX 11.0, it responds as
can't read kernel memory. The dmesg has the permissions: -r-xr-xr-x.
Could someone tell me what needs to be done in order to execute dmesg
command successfully from oracle account.

Thanks,
--Babu

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
http://www.orafaq.com 
--
Author: Janardhana Babu Donga
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).




* * * * * Freedom of Information Act Notice * * * * * 
The information in this email is subject to the record protection mandated
by 5 United States Code 552 (b) (4) and relevant judicial opinions.
  



a_ff9900.gif
Description: GIF image

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.



tl_corner_10.gif
Description: GIF image

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.



tr_corner_10.gif
Description: GIF image

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.



bl_corner_10.gif
Description: GIF image

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.



br_corner_10.gif
Description: GIF image

RE: How to successfully execute dmesg command from Oracle accou

[John Kanagaraj]

Babu,

This should be possible if your SysAdmin sets the SUID bit for dmesg. I see
no harm in doing this, but it is essentially upto your SYsAdmin.

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

The manuals for Oracle are here: http://tahiti.oracle.com
The manual for Life is here: http://www.gospelcom.net

** The opinions and statements above are entirely my own and not those of my
employer or clients **


 -Original Message-
 From: Suzy Vordos [mailto:[EMAIL PROTECTED]]
 Sent: Monday, June 03, 2002 12:39 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: How to successfully execute dmesg command from Oracle
 account??
 
 
 
 To read kernel memory requires root privs, so don't think 
 there is a way
 to do that from the oracle account without some undesirable hack.
 
 Janardhana Babu Donga wrote:
  
  Dear List,
  
  When I run dmesg command from oracle account on HP-UX 
 11.0, it responds as
  can't read kernel memory. The dmesg has the 
 permissions: -r-xr-xr-x.
  Could someone tell me what needs to be done in order to 
 execute dmesg
  command successfully from oracle account.
  
  Thanks,
  --Babu
  
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Janardhana Babu Donga
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / 
 Mailing Lists
  
  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: Suzy Vordos
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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: John Kanagaraj
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

General RMAN Configuration Recommendations

[Pat Howe]

I have compiled a list of 'rman configuration recommendations' that I have
based my RMAN deployment on.
I am sending this out to the list for general discussion.
If you have anything to add let me know - I am learning as I go.

PS : Either CC me on all question responses or I will get back to you on
Tuesday - I am currently in Oracle-L digest mode.

THANKS

=

Configuration Recommendation 1

Use BACKSETS instead of IMAGE COPIES.

PROS
BackupSets can be written to tape or disk.  ImageCopies can only be written
to disk.
BackupSets only backup used Oracle blocks.  ImageCopies backup all blocks
(used or unused).
BackupSets can use incremental backups.  ImageCopies are always full
database backups.

Both perform logical and physical block checking.  
With BackupSets logical and physical block checking is always performed.  
With ImageCopies you need to include the CHECK LOGIC option in the COPY
command in order to detect logical corruption 

CONS
Backupsets requires RMAN for recovery - backups are stored in an Oracle
proprietary format.



Configuration Recommendation 2
Like everything else : Keep it simple!
Don't over complicate your backup and recovery strategy.
If you can get away with it perform a FULL backup nightly.  
Don't get into incrementals unless the database dictates that it is
required.



Configuration Recommendation 3
Use FULL instead of INCREMENTAL level 0 if you are not using an INCREMENTAL
strategy.
A INCREMENTAL level 0 is identical to the FULL but it writes additional
incremental info to the backup database set.  Therefore if you are not using
INCREMENTAL backups use the FULL - this way you are not writing unnecessary
information to the RMAN dictionary.



Configuration Recommendation 4
Resync RMAN-Catalog and the Target-Database-Control-File at least once per
day.  I actually resync hourly.



Configuration Recommendation 5
As part of our backup schedule, perform an RMAN restore database validate;
after each backup.  This reads all of the files required to restore the
database, and does everything except apply the data to disk.  This is a
major sanity check.



Configuration Recommendation 6
If you plan on routing your backups directly to tape - take one step back
and begin by configuring RMAN to backup to disk first.  Thus you will
eliminate the (major) problems associated with configuring the tape
interface.  Once you have RMAN up and running on disk then implement the
tape interface.   ie; Don't bite off to much at a time. 



Configuration Recommendation 7
Monitor the target database's alert.log for any ORA- error messages.  Any
corrupt blocks found during a backup are reported in the alert.log -
therefore you want to know as soon as possible if there is a problem with
your backup.



_ 
 Patrick J. Howe 
 Oracle DBA 
 VeriSign, Inc. 
 4501 Intelco Loop SE 
 Olympia, WA 98507 
 Email  : [EMAIL PROTECTED]  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Pat Howe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Upgrade Question

[Freeman, Robert]

 1. Use a separate tech stack (oracle home) for each instance.
In general I like the idea, but it gets a bit pricey on disk space if you
are running say 20-30 instances on a given box doesn't it?? 

 1a. Use a separate unix account for each oracle home for total isolation.
The DBA here is 
 real anal.  (BTW, that's me).
I tend to be a bit anal too, but this is perhaps overkill :-)

 3. Back up the OraInventory directory before and after an
install/upgrade.  If this 
 directory get hammered, there is no way to recreate it except to
re-install (Thank 
 You Oracle! all the sarcasm in the world implied here).
100% agree with this one. 

 I've also found that it is easier to use one listener for each instance
instead of one 
 listener for all instances.
While I like different listeners for different versions, one per instance
seems like a bit
of overkill. Again, 20 different listeners is expensive from a memory POV
and I've got to find
20 unused ports.

 For those on the list that disagree, flame away. 
No flames here, just seems like overkill to me The number of failures I
have gotten
that would have been saved by this amount of overkill would fit on maybe 2
or 3 fingers
in about 12 years of DBA'ing, and I can't remember a production problem in
any event that
would have been saved cost benefit isn't there based on that.

But hey, I'm all for high availability!!

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i    

-Original Message-
Sent: Monday, June 03, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L



This is why we:
1. Use a separate tech stack (oracle home) for each instance.
1a. Use a separate unix account for each oracle home for total isolation.
The DBA here is real
anal.  (BTW, that's me).
1b. I've also found that it is easier to use one listener for each instance
instead of one listener
for all instances.
1c. We go so far as to give Oracle Names its own tech stack.
2. For each tech stack install, use a separate OraInventory directory.  See
metastink for details on
this.
3. Back up the OraInventory directory before and after an install/upgrade.
If this directory get
hammered, there is no way to recreate it except to re-install (Thank You
Oracle! all the sarcasm in
the world implied here).

For those on the list that dissagree, flame away.  This is what I've found
works the best in this
environment.

In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance
upgrade will not effect
it.  Since the patch says that there is nothing to upgrade, the
/var/opt/oracle/oraInst.loc file
probably points to the 8.1.6 OraInventory instead of the 8.1.7 OraInventory.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're
sober.  --William Butler
Yeats.


 

  hamid.alavi@quova

  dx.com   To:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  RE: Upgrade
Question 
 

 

  06/03/02 10:23 AM

  Please respond to

  ORACLE-L

 

 





I have also two other instances running on 8.1.6.2, This upgrade may be
effected from these version of Oracle or not, or this upgrade can be totaly
independent from 8.1.6.2
I am a bit confused, Need your advise guy
Thanks allot

-Original Message-
Sent: Monday, June 03, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L



You generally get this error if the conents of the file
/var/opt/oracle/oraInst.loc points to the
wrong OraInventory directory.

We just went to 8.1.7.4 to resolve some issues with .2.  So far, so good.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're
sober.  --William Butler
Yeats.




  hamid.alavi@quova

  dx.com   To:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  Upgrade Question





  06/03/02 09:18 AM

  Please respond to

  ORACLE-L









Hi List,

Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to
8.1.7.4 but after few minutes I got the following message:
There are no Patches need to be applied from the patch set oracle 8i patch
set 8.1.7.4.0 and doesn't go thru at all,  My question is for installing
any patch do I have to install the previous patch first or what?
Is there any Prepatch to Install for any patching or NOT?
We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better 
safer??
If I want to go for Patch 4,is there any comments or recommendation
Really appreciate



Hamid Alavi

RE: How to successfully execute dmesg command from Oracle accou

[Janardhana Babu Donga]

Suzy,

Thanks for your reply. I needed it because Oracle has supplied a script:
InstallPrep.sh on Metalink which check the server to ensure that it has
adequate resources to successfully install Oracle9i database software. It
should be run as oracle user only, but it executes dmesg command. It is
unable to execute dmesg and so Iam not getting proper output. Someone has
replied and advised me to have the SUID bit set on dmesg. I would try that
and see if it works. The script can't be run as root either.

-- Babu

-Original Message-
Sent: Monday, June 03, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L
account??



To read kernel memory requires root privs, so don't think there is a way
to do that from the oracle account without some undesirable hack.

Janardhana Babu Donga wrote:
 
 Dear List,
 
 When I run dmesg command from oracle account on HP-UX 11.0, it responds
as
 can't read kernel memory. The dmesg has the permissions: -r-xr-xr-x.
 Could someone tell me what needs to be done in order to execute dmesg
 command successfully from oracle account.
 
 Thanks,
 --Babu
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Janardhana Babu Donga
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Janardhana Babu Donga
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: 9iR2 Install Problem

[Toepke, Kevin M]

All:

Remember this? Well, after losing an support analyst, we finally got the
java stuff to work with 9iR2...the problem was the inventory_loc=/opt/oracle
entry in /var/opt/oracle/oraInst.loc. it should have been
inventory_loc=/opt/oracle/oraInventory

The installer did not complain that it could not create an oraInventory
directory under /opt/oracle!

The solution was to delete the oraInst.loc file and re-install oracle.

Kevin

-Original Message-
Sent: Wednesday, May 22, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L


Hello!

I am having a little difficulty with the 9iR2 install on a SUN Sparc
(Solaris 8) box. The installer completes normally, but when I try to run
anything java (e.g. dbca) I get the following message
Could not locate Java runtime
It looks to me that Oracle's provided jre did not get installed properly

Any suggestions on what I can do to correct this error? 

Kevin Toepke
[EMAIL PROTECTED]



The information in this electronic mail message is Trilegiant Confidential
and may be legally privileged. It is intended solely for the addressee(s).
Access to this Internet electronic mail message by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or action taken or omitted to be taken in reliance on
it is prohibited and may be unlawful.



The sender believes that this E-mail and any attachments were free of any
virus, worm, Trojan horse, and/or malicious code when sent. This message and
its attachments could have been infected during transmission. By reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses and
other defects. Trilegiant Corporation is not liable for any loss or damage
arising in any way from this message or its attachments.




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Jr.DBA, Mid level DBA, Sr.DBA

[Freeman, Robert]

 but many (and especially older hands) Oracle DBAs consider M$ systems to
be for wimps, 
 just good for running Access and possibly SQL Server.

Yea... and I'm sure that there are those older hands that would prefer the
days of the 
card punching return  :-)) Old habits and ways are hard to change. While
I'm not a M$
fan. I'm thankful that I can run a copy of Oracle on it to develop and
test with at
home on my ownI might even run a production system on it... a very
unimportant
production system.

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i    
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: RMAN - Disk vs Tape backups

[Freeman, Robert]

There are several solutions to this that I can think of besides just going
to tape...
Duplexing the backups to different disks in different physical locations is
one,
or using some sort of remote mirroring strategy is another. If you have an
offsite
DR location that you can duplex to (on disk) then this might be the best
solution
for a number of reasons.

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i    




-Original Message-
Sent: Monday, June 03, 2002 1:43 PM
To: Multiple recipients of list ORACLE-L


Dennis ;

You are absolutely right - the DISK option has a big down side that I did 
not catch :
In a disaster (computer room fire) the daily archive logs would be lost 
leaving you without the ability to roll forward your database - and thus the

loss of data.  Therefore if you were to go with the DISK option - you would 
need to manually implement an remote disk or tape backup procedure for your 
daily archive logs (not an easy task) - that is if your clients could not 
live with the loss of any data.

The RMAN tape management option (as long as they are promptly stored in a 
fire resistant safe) definitely has its advantages.

Good point !



As a side note on disaster recovery ; We perform a 'disaster recovery' test 
here every 6 months.
This is a great sanity check - as it tests out our procedures and ability to

recover from a disaster.
In our last test we simulated a loss of a production server (computer room 
lost due to fire) - and together with the SA's we rebuilt the box from the 
ground up using the backups that we had in the fireproof safe.  This 
exercise also made it very clear to our clients that given our current 
backup configuration - they would loose at most one days worth of 
transactions (the archive logs).
It also confirmed the 'assumptions' that both the DBAs and SAs were making 
about 'who was backing up and responsible for what'.
I highly recommend going thru this procedure at least once a year.



Your comment about implemented RMAN on disk first before implementing RMAN 
with a MML - We took the following approach ;
If you plan on routing your backups directly to tape - take one step back 
and begin by configuring RMAN to backup to disk first.  Thus you will 
eliminate the (major) problems associated with configuring the tape 
interface.  Once you have RMAN up and running on disk then implement the 
tape interface.   ie; Don't bite off to much at a time.

Thanks and good luck in your RMAN rollout!

_
Patrick J. Howe
Oracle DBA
Illuminet.  A Verisign Company.
4501 Intelco Loop SE
Olympia, WA 98507
Email  : [EMAIL PROTECTED]



-Original Message-

Sent: Monday, June 03, 2002 8:48 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


Pat
Excellent summary. I have only a few points to add. I must point out
that I am an RMAN novice, just getting brief spurts of time between other
people's priorities.
  - If you use RMAN to back up to disk, I haven't figured an advantage to
backing archive logs up with RMAN. If anyone knows an advantage, I would
appreciate hearing it. Obviously if you are using RMAN to write to the MML,
it makes excellent sense to back up the archive logs, but writing to disk,
you just create an extra copy of your archive logs on disk, which eventually
gets copied to tape. RMAN will apply the archive logs, whether you've given
it charge of them or not. Since you are probably doing RMAN incremental
backups each day, you probably only need today's archive logs anyway.
  - I appreciate your points on disaster recovery. This topic rarely seems
to come up with RMAN. We are into what might be termed poor man's disaster
recovery. This isn't where you have a duplicate computer room in another
city (how do I apply to be the DBA at one of those facilities), but where
you take backup tapes offsite and your hardware vendor promises to find you
a replacement server somewhere to load your tapes into.
  - The disaster recovery scenario our systems manager insists on is your
server just burned to the floor, go get your backup tape from the offsite
vendor and go to a another location and get your system going. The key is
making sure that everything you need gets on that tape. I agree with you,
that when you rely on an MML, that is one more layer of uncertainty. How can
you make sure there isn't some key disk file the MML relies on, unless you
test the scenario.
  - Someone on this list gave me the advice that it is easier to learn RMAN
by backing up to disk.
  - A lot will depend on your site. I would expect that the larger the site,
the more benefit would be derived from and MML. And the more chance to get
payback from the training and learning.
  - More disk space - when my system administrator realized by backing up to
disk he wouldn't need to learn how to interface Veritas to Oracle, he was
most 

RE: RMAN - Disk vs Tape backups

[Jared . Still]

Dennis,

Which MML and how much $$?

The Oracle client for Veritas is about $3500.  Small change
for a piece of a backup system.

Jared






DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/03/2002 12:33 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: RMAN - Disk vs Tape backups


Steve, Pat
  In our experiments so far, we had enough space to leave the level 0 
backup
on disk. The other incremental backups are so small compared with the 
level
0, that they aren't a problem. We keep a couple of weeks of archives on
another disk anyway. All these can be backed up to tape nightly. And the
tape is taken off-site daily.
  The MML vendors seem to charge a healthy price for the Oracle client. 
I
don't know how much that is, but my sys admin indicated that it would buy
quite a bit of disk.
  Generally, under true disaster circumstances, losing a few days of data
wouldn't be the end of the world. Not being able to get the data back at 
all
because we started using some slick tool like RMAN and there is some sort 
of
gotcha or some file on the server didn't get considered, well . . . Not
being able to recover for a few days would be understandable. If those
critera aren't acceptable they need to start building that backup computer
room.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, June 03, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L


You mentioned disk management issues... A problem with disk is that you
are probably limited to only doing level 0 backups. If your recovery spans
multiple RMAN backups then it could be a real bear trying get everything 
you need to recover if you're staging from disk to tape. You'd have to be
very careful about keep track of your tapes.



-Original Message-
Sent: Monday, June 03, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L


Dennis ;

You are absolutely right - the DISK option has a big down side that I did 
not catch :
In a disaster (computer room fire) the daily archive logs would be lost 
leaving you without the ability to roll forward your database - and thus 
the

loss of data.  Therefore if you were to go with the DISK option - you 
would 
need to manually implement an remote disk or tape backup procedure for 
your 
daily archive logs (not an easy task) - that is if your clients could not 
live with the loss of any data.

The RMAN tape management option (as long as they are promptly stored in a 
fire resistant safe) definitely has its advantages.

Good point !



As a side note on disaster recovery ; We perform a 'disaster recovery' 
test 
here every 6 months.
This is a great sanity check - as it tests out our procedures and ability 
to

recover from a disaster.
In our last test we simulated a loss of a production server (computer room 

lost due to fire) - and together with the SA's we rebuilt the box from the 

ground up using the backups that we had in the fireproof safe.  This 
exercise also made it very clear to our clients that given our current 
backup configuration - they would loose at most one days worth of 
transactions (the archive logs).
It also confirmed the 'assumptions' that both the DBAs and SAs were making 

about 'who was backing up and responsible for what'.
I highly recommend going thru this procedure at least once a year.



Your comment about implemented RMAN on disk first before implementing RMAN 

with a MML - We took the following approach ;
If you plan on routing your backups directly to tape - take one step back 
and begin by configuring RMAN to backup to disk first.  Thus you will 
eliminate the (major) problems associated with configuring the tape 
interface.  Once you have RMAN up and running on disk then implement the 
tape interface.   ie; Don't bite off to much at a time.

Thanks and good luck in your RMAN rollout!

_
Patrick J. Howe
Oracle DBA
Illuminet.  A Verisign Company.
4501 Intelco Loop SE
Olympia, WA 98507
Email  : [EMAIL PROTECTED]



-Original Message-

Sent: Monday, June 03, 2002 8:48 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


Pat
 Excellent summary. I have only a few points to add. I 
must point out
that I am an RMAN novice, just getting brief spurts of time between other
people's priorities.
  - If you use RMAN to back up to disk, I haven't figured an advantage to
backing archive logs up with RMAN. If anyone knows an advantage, I would
appreciate hearing it. Obviously if you are using RMAN to write to the 
MML,
it makes excellent sense to back up the archive logs, but writing to disk,
you just create an extra copy of your archive logs on disk, which 
eventually
gets copied to tape. RMAN will apply the archive logs, whether you've 
given
it charge of them or not. Since you are probably doing RMAN incremental
backups each day, you probably only need today's archive 

Re: How to successfully execute dmesg command from Oracle account??

[Stephane Faroult]

Janardhana Babu Donga wrote:
 
 Dear List,
 
 When I run dmesg command from oracle account on HP-UX 11.0, it responds as
 can't read kernel memory. The dmesg has the permissions: -r-xr-xr-x.
 Could someone tell me what needs to be done in order to execute dmesg
 command successfully from oracle account.
 
 Thanks,
 --Babu
 

I guess that chmod u+s dmesg run as 'root' would fix the problem but
programs with root setuid are everybody's favorite Unix security issue.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Jr.DBA, Mid level DBA, Sr.DBA

[dgoulet]

Ban M$, run Linux.

Dick Goulet

Reply Separator
Author: Freeman; Robert [EMAIL PROTECTED]
Date:   6/3/2002 12:08 PM

 but many (and especially older hands) Oracle DBAs consider M$ systems to
be for wimps, 
 just good for running Access and possibly SQL Server.

Yea... and I'm sure that there are those older hands that would prefer the
days of the 
card punching return  :-)) Old habits and ways are hard to change. While
I'm not a M$
fan. I'm thankful that I can run a copy of Oracle on it to develop and
test with at
home on my ownI might even run a production system on it... a very
unimportant
production system.

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i    
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: General RMAN Configuration Recommendations

[Orr, Steve]

 this way you are not writing unnecessary information to the RMAN
dictionary.
Isn't the data that goes to the RMAN repository so small that this is moot?

 take one step back and begin by configuring RMAN to backup to disk first. 
I've used the sbttest utility that comes with Oracle to test the MML
integration several times. Using sbttest is quick and easy and once it works
then your tape backup scripts should work. I used to test the RMAN-to-disk
technique first but now I find it unnecessary with sbttest. I also have a
parameter driven script which I can toggle between tape and disk backups
without modification. I find this quite handy. I can use the same script on
lots of machines and I don't have to roll out new scripts for each RMAN
implementation.


Steve Orr
It's a beautiful day in Bozeman, Montana...


-Original Message-
Sent: Monday, June 03, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L


I have compiled a list of 'rman configuration recommendations' that I have
based my RMAN deployment on.
I am sending this out to the list for general discussion.
If you have anything to add let me know - I am learning as I go.

PS : Either CC me on all question responses or I will get back to you on
Tuesday - I am currently in Oracle-L digest mode.

THANKS

=

Configuration Recommendation 1

Use BACKSETS instead of IMAGE COPIES.

PROS
BackupSets can be written to tape or disk.  ImageCopies can only be written
to disk.
BackupSets only backup used Oracle blocks.  ImageCopies backup all blocks
(used or unused).
BackupSets can use incremental backups.  ImageCopies are always full
database backups.

Both perform logical and physical block checking.  
With BackupSets logical and physical block checking is always performed.  
With ImageCopies you need to include the CHECK LOGIC option in the COPY
command in order to detect logical corruption 

CONS
Backupsets requires RMAN for recovery - backups are stored in an Oracle
proprietary format.



Configuration Recommendation 2
Like everything else : Keep it simple!
Don't over complicate your backup and recovery strategy.
If you can get away with it perform a FULL backup nightly.  
Don't get into incrementals unless the database dictates that it is
required.



Configuration Recommendation 3
Use FULL instead of INCREMENTAL level 0 if you are not using an INCREMENTAL
strategy.
A INCREMENTAL level 0 is identical to the FULL but it writes additional
incremental info to the backup database set.  Therefore if you are not using
INCREMENTAL backups use the FULL - this way you are not writing unnecessary
information to the RMAN dictionary.



Configuration Recommendation 4
Resync RMAN-Catalog and the Target-Database-Control-File at least once per
day.  I actually resync hourly.



Configuration Recommendation 5
As part of our backup schedule, perform an RMAN restore database validate;
after each backup.  This reads all of the files required to restore the
database, and does everything except apply the data to disk.  This is a
major sanity check.



Configuration Recommendation 6
If you plan on routing your backups directly to tape - take one step back
and begin by configuring RMAN to backup to disk first.  Thus you will
eliminate the (major) problems associated with configuring the tape
interface.  Once you have RMAN up and running on disk then implement the
tape interface.   ie; Don't bite off to much at a time. 



Configuration Recommendation 7
Monitor the target database's alert.log for any ORA- error messages.  Any
corrupt blocks found during a backup are reported in the alert.log -
therefore you want to know as soon as possible if there is a problem with
your backup.



_ 
 Patrick J. Howe 
 Oracle DBA 
 VeriSign, Inc. 
 4501 Intelco Loop SE 
 Olympia, WA 98507 
 Email  : [EMAIL PROTECTED]  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: 9iR2 Install Problem

[Miller, Jay]

Oracle really seems to have messed up considerably with the oraInventory
directory.  I've had several problems and from reading various threads it
seems that I'm far from the only one.

-Original Message-
Sent: Monday, June 03, 2002 3:59 PM
To: Multiple recipients of list ORACLE-L


All:

Remember this? Well, after losing an support analyst, we finally got the
java stuff to work with 9iR2...the problem was the inventory_loc=/opt/oracle
entry in /var/opt/oracle/oraInst.loc. it should have been
inventory_loc=/opt/oracle/oraInventory

The installer did not complain that it could not create an oraInventory
directory under /opt/oracle!

The solution was to delete the oraInst.loc file and re-install oracle.

Kevin

-Original Message-
Sent: Wednesday, May 22, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L


Hello!

I am having a little difficulty with the 9iR2 install on a SUN Sparc
(Solaris 8) box. The installer completes normally, but when I try to run
anything java (e.g. dbca) I get the following message
Could not locate Java runtime
It looks to me that Oracle's provided jre did not get installed properly

Any suggestions on what I can do to correct this error? 

Kevin Toepke
[EMAIL PROTECTED]



The information in this electronic mail message is Trilegiant Confidential
and may be legally privileged. It is intended solely for the addressee(s).
Access to this Internet electronic mail message by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or action taken or omitted to be taken in reliance on
it is prohibited and may be unlawful.



The sender believes that this E-mail and any attachments were free of any
virus, worm, Trojan horse, and/or malicious code when sent. This message and
its attachments could have been infected during transmission. By reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses and
other defects. Trilegiant Corporation is not liable for any loss or damage
arising in any way from this message or its attachments.




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

trial version of Oracle Financial ??

[Leslie Lu]

Hi,

Does anyone know where to get a trial version of
Oracle Financial, or other components of 11i?

Thank you!

Leslie

__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Upgrade Question

[Hamid Alavi]

List,

Can some body tell me what's the usage of oratab  orainst.loc files (sun
solaris OS), I am getteing confused because I have two diffrent Oracle_home
but just one one Orainventory Directory, It shouldn,'t be for each
oracle_home own Orainventory directory???
Appreciate your HELP.
Thanks,

-Original Message-
Sent: Monday, June 03, 2002 12:58 PM
To: Multiple recipients of list ORACLE-L


 1. Use a separate tech stack (oracle home) for each instance.
In general I like the idea, but it gets a bit pricey on disk space if you
are running say 20-30 instances on a given box doesn't it?? 

 1a. Use a separate unix account for each oracle home for total isolation.
The DBA here is 
 real anal.  (BTW, that's me).
I tend to be a bit anal too, but this is perhaps overkill :-)

 3. Back up the OraInventory directory before and after an
install/upgrade.  If this 
 directory get hammered, there is no way to recreate it except to
re-install (Thank 
 You Oracle! all the sarcasm in the world implied here).
100% agree with this one. 

 I've also found that it is easier to use one listener for each instance
instead of one 
 listener for all instances.
While I like different listeners for different versions, one per instance
seems like a bit
of overkill. Again, 20 different listeners is expensive from a memory POV
and I've got to find
20 unused ports.

 For those on the list that disagree, flame away. 
No flames here, just seems like overkill to me The number of failures I
have gotten
that would have been saved by this amount of overkill would fit on maybe 2
or 3 fingers
in about 12 years of DBA'ing, and I can't remember a production problem in
any event that
would have been saved cost benefit isn't there based on that.

But hey, I'm all for high availability!!

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i    

-Original Message-
Sent: Monday, June 03, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L



This is why we:
1. Use a separate tech stack (oracle home) for each instance.
1a. Use a separate unix account for each oracle home for total isolation.
The DBA here is real
anal.  (BTW, that's me).
1b. I've also found that it is easier to use one listener for each instance
instead of one listener
for all instances.
1c. We go so far as to give Oracle Names its own tech stack.
2. For each tech stack install, use a separate OraInventory directory.  See
metastink for details on
this.
3. Back up the OraInventory directory before and after an install/upgrade.
If this directory get
hammered, there is no way to recreate it except to re-install (Thank You
Oracle! all the sarcasm in
the world implied here).

For those on the list that dissagree, flame away.  This is what I've found
works the best in this
environment.

In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance
upgrade will not effect
it.  Since the patch says that there is nothing to upgrade, the
/var/opt/oracle/oraInst.loc file
probably points to the 8.1.6 OraInventory instead of the 8.1.7 OraInventory.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're
sober.  --William Butler
Yeats.


 

  hamid.alavi@quova

  dx.com   To:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  RE: Upgrade
Question 
 

 

  06/03/02 10:23 AM

  Please respond to

  ORACLE-L

 

 





I have also two other instances running on 8.1.6.2, This upgrade may be
effected from these version of Oracle or not, or this upgrade can be totaly
independent from 8.1.6.2
I am a bit confused, Need your advise guy
Thanks allot

-Original Message-
Sent: Monday, June 03, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L



You generally get this error if the conents of the file
/var/opt/oracle/oraInst.loc points to the
wrong OraInventory directory.

We just went to 8.1.7.4 to resolve some issues with .2.  So far, so good.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're
sober.  --William Butler
Yeats.




  hamid.alavi@quova

  dx.com   To:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  Upgrade Question





  06/03/02 09:18 AM

  Please respond to

  ORACLE-L









Hi List,

Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to
8.1.7.4 but after few minutes I got the following message:
There are no Patches need to be applied from the 

Re: trial version of Oracle Financial ??

[Ron Rogers]

Leslie,
 Go to the Oracle web site and click on the store icon and check out
the CDPACKS for $40 each. You can get anything for your own play
evaluation purposes.
Ron
ROR mô¿ôm
 [EMAIL PROTECTED] 06/03/02 04:58PM 
Hi,

Does anyone know where to get a trial version of
Oracle Financial, or other components of 11i?

Thank you!

Leslie

__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: trial version of Oracle Financial ??

[Murray, Margaret]

Ron,
That's fine for everything BUT E-Business Applications (and isn't that
what most people want?) from the web page - * We do not offer trial
licenses for our E-Business Suite Applications.
Leslie,
Be prepared to spend at least $40 and LOTS of learning time to install to
try. I don't think trial versions come with support - and I'm not sure it
can be done without patches and many (sometimes hundreds, depending on how
many and which modules) iTars.  The Vision database is the seeded database
with somewhat useful data.
Margaret

 -Original Message-
 From: Ron Rogers [mailto:[EMAIL PROTECTED]]
 Sent: Monday, June 03, 2002 5:29 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: trial version of Oracle Financial ??
 
 
 Leslie,
  Go to the Oracle web site and click on the store icon and check out
 the CDPACKS for $40 each. You can get anything for your own play
 evaluation purposes.
 Ron
 ROR mô¿ôm
  [EMAIL PROTECTED] 06/03/02 04:58PM 
 Hi,
 
 Does anyone know where to get a trial version of
 Oracle Financial, or other components of 11i?
 
 Thank you!
 
 Leslie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Murray, Margaret
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: So, What is a 'Production DBA'?

[Paula_Stankus]

Title: RE: So, What is a 'Production DBA'?





Guys,


In my experience there are so many issues that come up in design that eventually affect the quality of life for a production dba that I have real concerns splitting the role. In my world as much as possible I do both starting with design I look at the various tradeoffs between performance (at various levels), maintenance and assist in architectural and design issues that later translate into how the database is made physical and therefore how much heartburn I might have with things like backups and recoveries, performance tuning and options. I work with developers in assisting in tuning SQL and this helps again in determining the best database design and understanding the tradeoffs necessary. If you do break these roles apart what is to keep an application DBA from doing the quick and dirty or neglecting long-term maintenance issues. They would necessarily have to deal with the beeps in the middle-of-the night that could have been averted due to a better initial design/architecture. To me these roles are done better if combined or at the least if the productional DBA type is at some level part of design along with the application DBA type. 

RE: foreign key what???? help!!

[Paula_Stankus]

Title: RE:  foreign key what help!!





Okay guys,


Have foreign keys defined on large dw tables. When loading get foreign key errors. However, after load (w/o change in data and supposedly data it was barking on) could create fk's just fine on the same data elements involving the same data - I SWEAR. This does not make sense to me. Any ideas?

Re: Upgrade Question

[Suzy Vordos]

There isn't a separate orainventory for each ORACLE_HOME.  A single
orainst.loc file defines where orainventory is located, and the
orainventory contains info about what is installed for all versions of
Oracle on the system (8i and above).   

A single oratab file is used by all versions of Oracle to set
ORACLE_HOME and ORACLE_SID in the dbshut/dbstart scripts.  

In most cases both the oratab and orainventory files are found under
/var/opt/oracle.

Hamid Alavi wrote:
 
 List,
 
 Can some body tell me what's the usage of oratab  orainst.loc files (sun
 solaris OS), I am getteing confused because I have two diffrent Oracle_home
 but just one one Orainventory Directory, It shouldn,'t be for each
 oracle_home own Orainventory directory???
 Appreciate your HELP.
 Thanks,
 
 -Original Message-
 Sent: Monday, June 03, 2002 12:58 PM
 To: Multiple recipients of list ORACLE-L
 
  1. Use a separate tech stack (oracle home) for each instance.
 In general I like the idea, but it gets a bit pricey on disk space if you
 are running say 20-30 instances on a given box doesn't it??
 
  1a. Use a separate unix account for each oracle home for total isolation.
 The DBA here is
  real anal.  (BTW, that's me).
 I tend to be a bit anal too, but this is perhaps overkill :-)
 
  3. Back up the OraInventory directory before and after an
 install/upgrade.  If this
  directory get hammered, there is no way to recreate it except to
 re-install (Thank
  You Oracle! all the sarcasm in the world implied here).
 100% agree with this one.
 
  I've also found that it is easier to use one listener for each instance
 instead of one
  listener for all instances.
 While I like different listeners for different versions, one per instance
 seems like a bit
 of overkill. Again, 20 different listeners is expensive from a memory POV
 and I've got to find
 20 unused ports.
 
  For those on the list that disagree, flame away.
 No flames here, just seems like overkill to me The number of failures I
 have gotten
 that would have been saved by this amount of overkill would fit on maybe 2
 or 3 fingers
 in about 12 years of DBA'ing, and I can't remember a production problem in
 any event that
 would have been saved cost benefit isn't there based on that.
 
 But hey, I'm all for high availability!!
 
 RF
 
 Robert G. Freeman - Oracle8i OCP
 Oracle DBA Technical Lead
 CSX Midtier Database Administration
 Author: Oracle9i New Features
 Mastering Oracle8i
 
 -Original Message-
 Sent: Monday, June 03, 2002 2:14 PM
 To: Multiple recipients of list ORACLE-L
 
 This is why we:
 1. Use a separate tech stack (oracle home) for each instance.
 1a. Use a separate unix account for each oracle home for total isolation.
 The DBA here is real
 anal.  (BTW, that's me).
 1b. I've also found that it is easier to use one listener for each instance
 instead of one listener
 for all instances.
 1c. We go so far as to give Oracle Names its own tech stack.
 2. For each tech stack install, use a separate OraInventory directory.  See
 metastink for details on
 this.
 3. Back up the OraInventory directory before and after an install/upgrade.
 If this directory get
 hammered, there is no way to recreate it except to re-install (Thank You
 Oracle! all the sarcasm in
 the world implied here).
 
 For those on the list that dissagree, flame away.  This is what I've found
 works the best in this
 environment.
 
 In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance
 upgrade will not effect
 it.  Since the patch says that there is nothing to upgrade, the
 /var/opt/oracle/oraInst.loc file
 probably points to the 8.1.6 OraInventory instead of the 8.1.7 OraInventory.
 
 Ron Thomas
 Hypercom, Inc
 [EMAIL PROTECTED]
 The problem with some people is that when they aren't drunk, they're
 sober.  --William Butler
 Yeats.
 
 
 
   hamid.alavi@quova
 
   dx.com   To:
 [EMAIL PROTECTED]
 
   Sent by: cc:
 
   [EMAIL PROTECTED] Subject:  RE: Upgrade
 Question
 
 
 
 
   06/03/02 10:23 AM
 
   Please respond to
 
   ORACLE-L
 
 
 
 
 
 I have also two other instances running on 8.1.6.2, This upgrade may be
 effected from these version of Oracle or not, or this upgrade can be totaly
 independent from 8.1.6.2
 I am a bit confused, Need your advise guy
 Thanks allot
 
 -Original Message-
 Sent: Monday, June 03, 2002 9:59 AM
 To: Multiple recipients of list ORACLE-L
 
 You generally get this error if the conents of the file
 /var/opt/oracle/oraInst.loc points to the
 wrong OraInventory directory.
 
 We just went to 8.1.7.4 to resolve some issues with .2.  So far, so good.
 
 Ron Thomas
 Hypercom, Inc
 [EMAIL PROTECTED]
 The problem with some people is that when they aren't drunk, they're
 sober.  --William Butler
 Yeats.
 
   hamid.alavi@quova
 
 

RE: Upgrade Question

[Hamid Alavi]

Thanks,
So why when I try to Upgrade from 8.1.7.0 to 8.1.7.4 installer get confused
and looking for a installed patch?
What the content of oratab should be?
I have the following values in my oratab:

STAR:/u01/app/oracle:Y   8.1.6
CQST:/u01/app/oracle:Y   8.1.6
HMS:/u01/app/oracle:N8.1.6
DEVL:/u04/app/oracle:N   8.1.7.0 
REPO:/u04/app/oracle:N   8.1.7.0
PROD:/u04/app/oracle:N   8.1.7.0

Actualy I don't know those Y or N infront of each instance name, Do I
have to change it to Y for 8.1.7 instances or NOT?
Appreciate.


-Original Message-
Sent: Monday, June 03, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L



There isn't a separate orainventory for each ORACLE_HOME.  A single
orainst.loc file defines where orainventory is located, and the
orainventory contains info about what is installed for all versions of
Oracle on the system (8i and above).   

A single oratab file is used by all versions of Oracle to set
ORACLE_HOME and ORACLE_SID in the dbshut/dbstart scripts.  

In most cases both the oratab and orainventory files are found under
/var/opt/oracle.

Hamid Alavi wrote:
 
 List,
 
 Can some body tell me what's the usage of oratab  orainst.loc files (sun
 solaris OS), I am getteing confused because I have two diffrent
Oracle_home
 but just one one Orainventory Directory, It shouldn,'t be for each
 oracle_home own Orainventory directory???
 Appreciate your HELP.
 Thanks,
 
 -Original Message-
 Sent: Monday, June 03, 2002 12:58 PM
 To: Multiple recipients of list ORACLE-L
 
  1. Use a separate tech stack (oracle home) for each instance.
 In general I like the idea, but it gets a bit pricey on disk space if you
 are running say 20-30 instances on a given box doesn't it??
 
  1a. Use a separate unix account for each oracle home for total
isolation.
 The DBA here is
  real anal.  (BTW, that's me).
 I tend to be a bit anal too, but this is perhaps overkill :-)
 
  3. Back up the OraInventory directory before and after an
 install/upgrade.  If this
  directory get hammered, there is no way to recreate it except to
 re-install (Thank
  You Oracle! all the sarcasm in the world implied here).
 100% agree with this one.
 
  I've also found that it is easier to use one listener for each instance
 instead of one
  listener for all instances.
 While I like different listeners for different versions, one per instance
 seems like a bit
 of overkill. Again, 20 different listeners is expensive from a memory POV
 and I've got to find
 20 unused ports.
 
  For those on the list that disagree, flame away.
 No flames here, just seems like overkill to me The number of failures
I
 have gotten
 that would have been saved by this amount of overkill would fit on maybe 2
 or 3 fingers
 in about 12 years of DBA'ing, and I can't remember a production problem in
 any event that
 would have been saved cost benefit isn't there based on that.
 
 But hey, I'm all for high availability!!
 
 RF
 
 Robert G. Freeman - Oracle8i OCP
 Oracle DBA Technical Lead
 CSX Midtier Database Administration
 Author: Oracle9i New Features
 Mastering Oracle8i
 
 -Original Message-
 Sent: Monday, June 03, 2002 2:14 PM
 To: Multiple recipients of list ORACLE-L
 
 This is why we:
 1. Use a separate tech stack (oracle home) for each instance.
 1a. Use a separate unix account for each oracle home for total isolation.
 The DBA here is real
 anal.  (BTW, that's me).
 1b. I've also found that it is easier to use one listener for each
instance
 instead of one listener
 for all instances.
 1c. We go so far as to give Oracle Names its own tech stack.
 2. For each tech stack install, use a separate OraInventory directory.
See
 metastink for details on
 this.
 3. Back up the OraInventory directory before and after an install/upgrade.
 If this directory get
 hammered, there is no way to recreate it except to re-install (Thank You
 Oracle! all the sarcasm in
 the world implied here).
 
 For those on the list that dissagree, flame away.  This is what I've found
 works the best in this
 environment.
 
 In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance
 upgrade will not effect
 it.  Since the patch says that there is nothing to upgrade, the
 /var/opt/oracle/oraInst.loc file
 probably points to the 8.1.6 OraInventory instead of the 8.1.7
OraInventory.
 
 Ron Thomas
 Hypercom, Inc
 [EMAIL PROTECTED]
 The problem with some people is that when they aren't drunk, they're
 sober.  --William Butler
 Yeats.
 
 
 
   hamid.alavi@quova
 
   dx.com   To:
 [EMAIL PROTECTED]
 
   Sent by: cc:
 
   [EMAIL PROTECTED] Subject:  RE: Upgrade
 Question
 
 
 
 
   06/03/02 10:23 AM
 
   Please respond to
 
   ORACLE-L
 
 
 
 
 
 I have also two other instances running on 8.1.6.2, This upgrade may be
 effected from these version of Oracle or not, 

linux vs any other os

[Bill Conner]

Hi All,

Anyone have any sites where they are doing performance compares of linux vs 
solaris  or any other OS.

TiA,

-bill


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Conner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: foreign key what???? help!!

[Magaliff, Bill]

Title: RE: foreign key what help!!



are 
you loading more than one table? could you be loading child records b4 the 
parents are inserted?

-bill

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, June 03, 2002 
  6:13 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: foreign key what help!!
  Okay guys, 
  Have foreign keys defined on large dw tables. When 
  loading get foreign key errors. However, after load (w/o change in data 
  and supposedly data it was barking on) could create fk's just fine on the same 
  data elements involving the same data - I SWEAR. This does not make 
  sense to me. Any ideas?

RE: Upgrade Question

[kkennedy]

Hello Hamid,

I don't think your problem with the patch has anything to do with the oratab file.  I 
had an identical problem upgrading a server from 8.1.7.0 to 8.1.7.3 where the 
installer insisted that no patch was needed.  I had this happen on two different 
servers.

In my case, predecessors had installed 8.1.7.0 on one machine then copied the Oracle 
home to the other servers using different software mount points on each machine.  I'm 
not sure why they attempted this approach but I am sure that they did not have 
sufficient knowledge.  I tried manually copying and modifying the oraInst.loc file and 
the oraInventory directory but nothing helped with the patch problem.

Eventually, I bit the bullet and did a fresh install of 8.1.7.0 on each of these 
servers.  After the fresh install, the 8.1.7.3 patch worked perfectly.  This would be 
my advice to you.

Kevin Kennedy
First Point Energy Corporation 

-Original Message-
Sent: Monday, June 03, 2002 3:59 PM
To: Multiple recipients of list ORACLE-L


Thanks,
So why when I try to Upgrade from 8.1.7.0 to 8.1.7.4 installer get confused
and looking for a installed patch?
What the content of oratab should be?
I have the following values in my oratab:

STAR:/u01/app/oracle:Y   8.1.6
CQST:/u01/app/oracle:Y   8.1.6
HMS:/u01/app/oracle:N8.1.6
DEVL:/u04/app/oracle:N   8.1.7.0 
REPO:/u04/app/oracle:N   8.1.7.0
PROD:/u04/app/oracle:N   8.1.7.0

Actualy I don't know those Y or N infront of each instance name, Do I
have to change it to Y for 8.1.7 instances or NOT?
Appreciate.


-Original Message-
Sent: Monday, June 03, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L



There isn't a separate orainventory for each ORACLE_HOME.  A single
orainst.loc file defines where orainventory is located, and the
orainventory contains info about what is installed for all versions of
Oracle on the system (8i and above).   

A single oratab file is used by all versions of Oracle to set
ORACLE_HOME and ORACLE_SID in the dbshut/dbstart scripts.  

In most cases both the oratab and orainventory files are found under
/var/opt/oracle.

Hamid Alavi wrote:
 
 List,
 
 Can some body tell me what's the usage of oratab  orainst.loc files (sun
 solaris OS), I am getteing confused because I have two diffrent
Oracle_home
 but just one one Orainventory Directory, It shouldn,'t be for each
 oracle_home own Orainventory directory???
 Appreciate your HELP.
 Thanks,
 
 -Original Message-
 Sent: Monday, June 03, 2002 12:58 PM
 To: Multiple recipients of list ORACLE-L
 
  1. Use a separate tech stack (oracle home) for each instance.
 In general I like the idea, but it gets a bit pricey on disk space if you
 are running say 20-30 instances on a given box doesn't it??
 
  1a. Use a separate unix account for each oracle home for total
isolation.
 The DBA here is
  real anal.  (BTW, that's me).
 I tend to be a bit anal too, but this is perhaps overkill :-)
 
  3. Back up the OraInventory directory before and after an
 install/upgrade.  If this
  directory get hammered, there is no way to recreate it except to
 re-install (Thank
  You Oracle! all the sarcasm in the world implied here).
 100% agree with this one.
 
  I've also found that it is easier to use one listener for each instance
 instead of one
  listener for all instances.
 While I like different listeners for different versions, one per instance
 seems like a bit
 of overkill. Again, 20 different listeners is expensive from a memory POV
 and I've got to find
 20 unused ports.
 
  For those on the list that disagree, flame away.
 No flames here, just seems like overkill to me The number of failures
I
 have gotten
 that would have been saved by this amount of overkill would fit on maybe 2
 or 3 fingers
 in about 12 years of DBA'ing, and I can't remember a production problem in
 any event that
 would have been saved cost benefit isn't there based on that.
 
 But hey, I'm all for high availability!!
 
 RF
 
 Robert G. Freeman - Oracle8i OCP
 Oracle DBA Technical Lead
 CSX Midtier Database Administration
 Author: Oracle9i New Features
 Mastering Oracle8i
 
 -Original Message-
 Sent: Monday, June 03, 2002 2:14 PM
 To: Multiple recipients of list ORACLE-L
 
 This is why we:
 1. Use a separate tech stack (oracle home) for each instance.
 1a. Use a separate unix account for each oracle home for total isolation.
 The DBA here is real
 anal.  (BTW, that's me).
 1b. I've also found that it is easier to use one listener for each
instance
 instead of one listener
 for all instances.
 1c. We go so far as to give Oracle Names its own tech stack.
 2. For each tech stack install, use a separate OraInventory directory.
See
 metastink for details on
 this.
 3. Back up the OraInventory directory before and after an install/upgrade.
 If this directory get
 hammered, there is no way to recreate it except to re-install (Thank You
 Oracle! all the sarcasm in
 the world implied here).
 
 For those on the list that 

RE: Upgrade Question

[Hamid Alavi]

Hi List,

I just find this on Metalink:

If an inadvertent attempt is made to apply this Patch Set to a non-8.1.7
release, then a warning dialog box entitled Dependencies is displayed which
contains the following error message:
There are no patches that need to be applied from the patch set Oracle8i
Patchset 8.1.7.4.0.  
The installer will not allow the installation to proceed. Just acknowledge
the error and click on the Exit button to end the installation session. 

This means I am trying to upgrade another version of oracle(8.1.6), but when
I check the user which I use all point to the 8.1.7 home  base.
Any Idea? what else I have to check?

I am realy confused with this Upgrade

Thanks all for HELP.

-Original Message-
Sent: Monday, June 03, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L



There isn't a separate orainventory for each ORACLE_HOME.  A single
orainst.loc file defines where orainventory is located, and the
orainventory contains info about what is installed for all versions of
Oracle on the system (8i and above).   

A single oratab file is used by all versions of Oracle to set
ORACLE_HOME and ORACLE_SID in the dbshut/dbstart scripts.  

In most cases both the oratab and orainventory files are found under
/var/opt/oracle.

Hamid Alavi wrote:
 
 List,
 
 Can some body tell me what's the usage of oratab  orainst.loc files (sun
 solaris OS), I am getteing confused because I have two diffrent
Oracle_home
 but just one one Orainventory Directory, It shouldn,'t be for each
 oracle_home own Orainventory directory???
 Appreciate your HELP.
 Thanks,
 
 -Original Message-
 Sent: Monday, June 03, 2002 12:58 PM
 To: Multiple recipients of list ORACLE-L
 
  1. Use a separate tech stack (oracle home) for each instance.
 In general I like the idea, but it gets a bit pricey on disk space if you
 are running say 20-30 instances on a given box doesn't it??
 
  1a. Use a separate unix account for each oracle home for total
isolation.
 The DBA here is
  real anal.  (BTW, that's me).
 I tend to be a bit anal too, but this is perhaps overkill :-)
 
  3. Back up the OraInventory directory before and after an
 install/upgrade.  If this
  directory get hammered, there is no way to recreate it except to
 re-install (Thank
  You Oracle! all the sarcasm in the world implied here).
 100% agree with this one.
 
  I've also found that it is easier to use one listener for each instance
 instead of one
  listener for all instances.
 While I like different listeners for different versions, one per instance
 seems like a bit
 of overkill. Again, 20 different listeners is expensive from a memory POV
 and I've got to find
 20 unused ports.
 
  For those on the list that disagree, flame away.
 No flames here, just seems like overkill to me The number of failures
I
 have gotten
 that would have been saved by this amount of overkill would fit on maybe 2
 or 3 fingers
 in about 12 years of DBA'ing, and I can't remember a production problem in
 any event that
 would have been saved cost benefit isn't there based on that.
 
 But hey, I'm all for high availability!!
 
 RF
 
 Robert G. Freeman - Oracle8i OCP
 Oracle DBA Technical Lead
 CSX Midtier Database Administration
 Author: Oracle9i New Features
 Mastering Oracle8i
 
 -Original Message-
 Sent: Monday, June 03, 2002 2:14 PM
 To: Multiple recipients of list ORACLE-L
 
 This is why we:
 1. Use a separate tech stack (oracle home) for each instance.
 1a. Use a separate unix account for each oracle home for total isolation.
 The DBA here is real
 anal.  (BTW, that's me).
 1b. I've also found that it is easier to use one listener for each
instance
 instead of one listener
 for all instances.
 1c. We go so far as to give Oracle Names its own tech stack.
 2. For each tech stack install, use a separate OraInventory directory.
See
 metastink for details on
 this.
 3. Back up the OraInventory directory before and after an install/upgrade.
 If this directory get
 hammered, there is no way to recreate it except to re-install (Thank You
 Oracle! all the sarcasm in
 the world implied here).
 
 For those on the list that dissagree, flame away.  This is what I've found
 works the best in this
 environment.
 
 In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance
 upgrade will not effect
 it.  Since the patch says that there is nothing to upgrade, the
 /var/opt/oracle/oraInst.loc file
 probably points to the 8.1.6 OraInventory instead of the 8.1.7
OraInventory.
 
 Ron Thomas
 Hypercom, Inc
 [EMAIL PROTECTED]
 The problem with some people is that when they aren't drunk, they're
 sober.  --William Butler
 Yeats.
 
 
 
   hamid.alavi@quova
 
   dx.com   To:
 [EMAIL PROTECTED]
 
   Sent by: cc:
 
   [EMAIL PROTECTED] Subject:  RE: Upgrade
 Question
 
 
 
 
   06/03/02 10:23 AM
 
  

RE: foreign key what???? help!!

[Fink, Dan]

Title: RE: foreign key what help!!



It is 
probably a question of timing when Child records are loaded before Parents. It 
can be a question of table order or even record order (self referencing 
relationship). Once the data is loaded, enforcement of the constraint is easy 
because all of the data exists.

Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, June 03, 2002 
  4:13 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: foreign key what help!!
  Okay guys, 
  Have foreign keys defined on large dw tables. When 
  loading get foreign key errors. However, after load (w/o change in data 
  and supposedly data it was barking on) could create fk's just fine on the same 
  data elements involving the same data - I SWEAR. This does not make 
  sense to me. Any ideas?

RE: Upgrade Question

[John Hallas]

The Y or N indicate to the dbstart program whether each database will be
started on system startup or not
I do not think the installer will take any note of these settings. It only
uses the oratab file to determine the Oracle_home settings (as well as using
the environment/registry settings)

HTH

John

-Original Message-
Sent: 03 June 2002 23:59
To: Multiple recipients of list ORACLE-L

Thanks,
So why when I try to Upgrade from 8.1.7.0 to 8.1.7.4 installer get confused
and looking for a installed patch?
What the content of oratab should be?
I have the following values in my oratab:

STAR:/u01/app/oracle:Y   8.1.6
CQST:/u01/app/oracle:Y   8.1.6
HMS:/u01/app/oracle:N8.1.6
DEVL:/u04/app/oracle:N   8.1.7.0
REPO:/u04/app/oracle:N   8.1.7.0
PROD:/u04/app/oracle:N   8.1.7.0

Actualy I don't know those Y or N infront of each instance name, Do I
have to change it to Y for 8.1.7 instances or NOT?
Appreciate.


-Original Message-
Sent: Monday, June 03, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L



There isn't a separate orainventory for each ORACLE_HOME.  A single
orainst.loc file defines where orainventory is located, and the
orainventory contains info about what is installed for all versions of
Oracle on the system (8i and above).

A single oratab file is used by all versions of Oracle to set
ORACLE_HOME and ORACLE_SID in the dbshut/dbstart scripts.

In most cases both the oratab and orainventory files are found under
/var/opt/oracle.

Hamid Alavi wrote:

 List,

 Can some body tell me what's the usage of oratab  orainst.loc files (sun
 solaris OS), I am getteing confused because I have two diffrent
Oracle_home
 but just one one Orainventory Directory, It shouldn,'t be for each
 oracle_home own Orainventory directory???
 Appreciate your HELP.
 Thanks,

 -Original Message-
 Sent: Monday, June 03, 2002 12:58 PM
 To: Multiple recipients of list ORACLE-L

  1. Use a separate tech stack (oracle home) for each instance.
 In general I like the idea, but it gets a bit pricey on disk space if you
 are running say 20-30 instances on a given box doesn't it??

  1a. Use a separate unix account for each oracle home for total
isolation.
 The DBA here is
  real anal.  (BTW, that's me).
 I tend to be a bit anal too, but this is perhaps overkill :-)

  3. Back up the OraInventory directory before and after an
 install/upgrade.  If this
  directory get hammered, there is no way to recreate it except to
 re-install (Thank
  You Oracle! all the sarcasm in the world implied here).
 100% agree with this one.

  I've also found that it is easier to use one listener for each instance
 instead of one
  listener for all instances.
 While I like different listeners for different versions, one per instance
 seems like a bit
 of overkill. Again, 20 different listeners is expensive from a memory POV
 and I've got to find
 20 unused ports.

  For those on the list that disagree, flame away.
 No flames here, just seems like overkill to me The number of failures
I
 have gotten
 that would have been saved by this amount of overkill would fit on maybe 2
 or 3 fingers
 in about 12 years of DBA'ing, and I can't remember a production problem in
 any event that
 would have been saved cost benefit isn't there based on that.

 But hey, I'm all for high availability!!

 RF

 Robert G. Freeman - Oracle8i OCP
 Oracle DBA Technical Lead
 CSX Midtier Database Administration
 Author: Oracle9i New Features
 Mastering Oracle8i

 -Original Message-
 Sent: Monday, June 03, 2002 2:14 PM
 To: Multiple recipients of list ORACLE-L

 This is why we:
 1. Use a separate tech stack (oracle home) for each instance.
 1a. Use a separate unix account for each oracle home for total isolation.
 The DBA here is real
 anal.  (BTW, that's me).
 1b. I've also found that it is easier to use one listener for each
instance
 instead of one listener
 for all instances.
 1c. We go so far as to give Oracle Names its own tech stack.
 2. For each tech stack install, use a separate OraInventory directory.
See
 metastink for details on
 this.
 3. Back up the OraInventory directory before and after an install/upgrade.
 If this directory get
 hammered, there is no way to recreate it except to re-install (Thank You
 Oracle! all the sarcasm in
 the world implied here).

 For those on the list that dissagree, flame away.  This is what I've found
 works the best in this
 environment.

 In any case, if the 8.1.6.2 is in a separate home, then the 8.1.7 instance
 upgrade will not effect
 it.  Since the patch says that there is nothing to upgrade, the
 /var/opt/oracle/oraInst.loc file
 probably points to the 8.1.6 OraInventory instead of the 8.1.7
OraInventory.

 Ron Thomas
 Hypercom, Inc
 [EMAIL PROTECTED]
 The problem with some people is that when they aren't drunk, they're
 sober.  --William Butler
 Yeats.



   hamid.alavi@quova

   dx.com   To:
 [EMAIL PROTECTED]

   

Re: Upgrade Question

[Suzy Vordos]

The oratab doesn't look right to me.  The second token should have the
full path to ORACLE_HOME for each version.  Unless of course Oracle is
*really* installed under /u01/app/oracle instead of
/u01/app/oracle/8.1.6, in which case that doesn't follow OFA standards.

STAR:/u01/app/oracle/8.1.6:Y  

The Y or N says whether to start/shutdown the database when
dbstart/dbshut are executed.   

Installing software of patches is driven by oraInst.loc and proper
setting of dependent env variables ORACLE_BASE, ORACLE_ADMIN and
ORACLE_HOME.  Is it possible one or more env variables isn't set? 
Here's an example of what is needed (the actual values would differ for
your environment).  

ORACLE_BASE=/opt/app/oracle
ORACLE_ADMIN=/opt/app/oracle/admin
ORACLE_HOME=/opt/app/oracle/product/8.1.7

Note that ORACLE_BASE is generally where the orainventory resides (which
should also match the value of inventory_loc in the
/var/opt/oracle/oraInst.loc file).  Under ORACLE_BASE you should see the
following directories: jre OraInventory oui product.


Hamid Alavi wrote:
 
 Thanks,
 So why when I try to Upgrade from 8.1.7.0 to 8.1.7.4 installer get confused
 and looking for a installed patch?
 What the content of oratab should be?
 I have the following values in my oratab:
 
 STAR:/u01/app/oracle:Y   8.1.6
 CQST:/u01/app/oracle:Y   8.1.6
 HMS:/u01/app/oracle:N8.1.6
 DEVL:/u04/app/oracle:N   8.1.7.0
 REPO:/u04/app/oracle:N   8.1.7.0
 PROD:/u04/app/oracle:N   8.1.7.0
 
 Actualy I don't know those Y or N infront of each instance name, Do I
 have to change it to Y for 8.1.7 instances or NOT?
 Appreciate.
 
 -Original Message-
 Sent: Monday, June 03, 2002 3:23 PM
 To: Multiple recipients of list ORACLE-L
 
 There isn't a separate orainventory for each ORACLE_HOME.  A single
 orainst.loc file defines where orainventory is located, and the
 orainventory contains info about what is installed for all versions of
 Oracle on the system (8i and above).
 
 A single oratab file is used by all versions of Oracle to set
 ORACLE_HOME and ORACLE_SID in the dbshut/dbstart scripts.
 
 In most cases both the oratab and orainventory files are found under
 /var/opt/oracle.
 
 Hamid Alavi wrote:
 
  List,
 
  Can some body tell me what's the usage of oratab  orainst.loc files (sun
  solaris OS), I am getteing confused because I have two diffrent
 Oracle_home
  but just one one Orainventory Directory, It shouldn,'t be for each
  oracle_home own Orainventory directory???
  Appreciate your HELP.
  Thanks,
 
  -Original Message-
  Sent: Monday, June 03, 2002 12:58 PM
  To: Multiple recipients of list ORACLE-L
 
   1. Use a separate tech stack (oracle home) for each instance.
  In general I like the idea, but it gets a bit pricey on disk space if you
  are running say 20-30 instances on a given box doesn't it??
 
   1a. Use a separate unix account for each oracle home for total
 isolation.
  The DBA here is
   real anal.  (BTW, that's me).
  I tend to be a bit anal too, but this is perhaps overkill :-)
 
   3. Back up the OraInventory directory before and after an
  install/upgrade.  If this
   directory get hammered, there is no way to recreate it except to
  re-install (Thank
   You Oracle! all the sarcasm in the world implied here).
  100% agree with this one.
 
   I've also found that it is easier to use one listener for each instance
  instead of one
   listener for all instances.
  While I like different listeners for different versions, one per instance
  seems like a bit
  of overkill. Again, 20 different listeners is expensive from a memory POV
  and I've got to find
  20 unused ports.
 
   For those on the list that disagree, flame away.
  No flames here, just seems like overkill to me The number of failures
 I
  have gotten
  that would have been saved by this amount of overkill would fit on maybe 2
  or 3 fingers
  in about 12 years of DBA'ing, and I can't remember a production problem in
  any event that
  would have been saved cost benefit isn't there based on that.
 
  But hey, I'm all for high availability!!
 
  RF
 
  Robert G. Freeman - Oracle8i OCP
  Oracle DBA Technical Lead
  CSX Midtier Database Administration
  Author: Oracle9i New Features
  Mastering Oracle8i
 
  -Original Message-
  Sent: Monday, June 03, 2002 2:14 PM
  To: Multiple recipients of list ORACLE-L
 
  This is why we:
  1. Use a separate tech stack (oracle home) for each instance.
  1a. Use a separate unix account for each oracle home for total isolation.
  The DBA here is real
  anal.  (BTW, that's me).
  1b. I've also found that it is easier to use one listener for each
 instance
  instead of one listener
  for all instances.
  1c. We go so far as to give Oracle Names its own tech stack.
  2. For each tech stack install, use a separate OraInventory directory.
 See
  metastink for details on
  this.
  3. Back up the OraInventory directory before and after an install/upgrade.
  If this directory get
  hammered, there is no way to 

Re: Upgrade Question

[Ron Thomas]

You said:
There isn't a separate orainventory for each ORACLE_HOME.  A single
orainst.loc file defines where orainventory is located, and the

Not necessarily (and not recommended).  It is very easy to setup an orainventory file 
for each
installation.  Check metalink for details.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're sober.  
--William Butler
Yeats.


   
   
  [EMAIL PROTECTED]
   
  Sent by: To:   [EMAIL PROTECTED]  
   
  [EMAIL PROTECTED] cc: 
   
   Subject:  Re: Upgrade Question  
   
   
   
  06/03/02 03:23 PM
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   





There isn't a separate orainventory for each ORACLE_HOME.  A single
orainst.loc file defines where orainventory is located, and the
orainventory contains info about what is installed for all versions of
Oracle on the system (8i and above).

A single oratab file is used by all versions of Oracle to set
ORACLE_HOME and ORACLE_SID in the dbshut/dbstart scripts.

In most cases both the oratab and orainventory files are found under
/var/opt/oracle.

Hamid Alavi wrote:

 List,

 Can some body tell me what's the usage of oratab  orainst.loc files (sun
 solaris OS), I am getteing confused because I have two diffrent Oracle_home
 but just one one Orainventory Directory, It shouldn,'t be for each
 oracle_home own Orainventory directory???
 Appreciate your HELP.
 Thanks,

 -Original Message-
 Sent: Monday, June 03, 2002 12:58 PM
 To: Multiple recipients of list ORACLE-L

  1. Use a separate tech stack (oracle home) for each instance.
 In general I like the idea, but it gets a bit pricey on disk space if you
 are running say 20-30 instances on a given box doesn't it??

  1a. Use a separate unix account for each oracle home for total isolation.
 The DBA here is
  real anal.  (BTW, that's me).
 I tend to be a bit anal too, but this is perhaps overkill :-)

  3. Back up the OraInventory directory before and after an
 install/upgrade.  If this
  directory get hammered, there is no way to recreate it except to
 re-install (Thank
  You Oracle! all the sarcasm in the world implied here).
 100% agree with this one.

  I've also found that it is easier to use one listener for each instance
 instead of one
  listener for all instances.
 While I like different listeners for different versions, one per instance
 seems like a bit
 of overkill. Again, 20 different listeners is expensive from a memory POV
 and I've got to find
 20 unused ports.

  For those on the list that disagree, flame away.
 No flames here, just seems like overkill to me The number of failures I
 have gotten
 that would have been saved by this amount of overkill would fit on maybe 2
 or 3 fingers
 in about 12 years of DBA'ing, and I can't remember a production problem in
 any event that
 would have been saved cost benefit isn't there based on that.

 But hey, I'm all for high availability!!

 RF

 Robert G. Freeman - Oracle8i OCP
 Oracle DBA Technical Lead
 CSX Midtier Database Administration
 Author: Oracle9i New Features
 Mastering Oracle8i

 -Original Message-
 Sent: Monday, June 03, 2002 2:14 PM
 To: Multiple recipients of list ORACLE-L

 This is why we:
 1. Use a separate tech stack (oracle home) for each instance.
 1a. Use a separate unix account for each oracle home for total isolation.
 The DBA here is real
 anal.  (BTW, that's me).
 1b. I've also found that it is easier to use one listener for each instance
 instead of one listener
 for all instances.
 1c. We go so far as to give Oracle Names its own tech stack.
 2. For each tech stack install, use a separate OraInventory directory.  See

Re: Where is Oracle9i Release README shipped with 9.2.0.1

[Joe Testa]

Debi, did you happen to go to technet.oracle.com and see if want you 
need is there?

joe


[EMAIL PROTECTED] wrote:

I can't find the generic rdbms README anywhere on my server for 9iR2.  
There are 42 readme.txt files on the server in a variety of formats/cases 
making it difficult to find: README.txt, readme.txt, Readme.txt, and even 
readmeXX.txt where XX is a one or more character code. Some are in 
specific product doc subdirectories, but not all...others are in a 
higher doc directory. 

Where is the RDBMS server readme that must have been installed with 9iR2 
software? 

Thanks,

Debi



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: dblink mysql to oracle

[Gabriel C Millerd]

On Mon, 3 Jun 2002, Gogala, Mladen wrote:

 I dunno about MySQL, but from oracle you can have external procedures
 accessing MySQL and returning data into oracle. There is also a TNS API
 which allows you to write your very own transparent gateway and select
 data from MySQL.

   is this the 'enabling net8 enhancements for programmers' stuff such as
the tftp and finger examples? such as mentioned here:

http://technet.oracle.com/doc/oracle8i_816/network.816/a76933/net8open.htm

   or am i missing something?

---
Gabriel C. Millerd | Go not to the elves for counsel, for they will say
Sith Admin | both yes and no. -- J.R.R. Tolkien
   |

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gabriel C Millerd
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: dblink mysql to oracle

[Gabriel C Millerd]

On Mon, 3 Jun 2002, Igor Neyman wrote:

 Read on Oracle's Heterogeneous Services, allows to connect (through db-link)
 to foreign databases using ODBC.

  this seems more like the way to go .. i didnt expect to have to program
anything rather configure oracle, a mysql driver, and transport
mechanism.

---
Gabriel C. Millerd |  The ability to destory a planet is insignificant
 Script Monkey | next to the power of the force... I find your lack
   |  of faith disturbing. -Lord Vader

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gabriel C Millerd
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Where is Oracle9i Release README shipped with 9.2.0.1

[Lyubomir Petrov]

What about $ORACLE_HOME/rdbms/doc/README_rdbms.htm?

HTH
Lyubomir Petrov


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 03, 2002 4:48 PM



 I can't find the generic rdbms README anywhere on my server for 9iR2.
 There are 42 readme.txt files on the server in a variety of formats/cases
 making it difficult to find: README.txt, readme.txt, Readme.txt, and even
 readmeXX.txt where XX is a one or more character code. Some are in
 specific product doc subdirectories, but not all...others are in a
 higher doc directory.

 Where is the RDBMS server readme that must have been installed with 9iR2
 software?

 Thanks,

 Debi
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author:
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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: Lyubomir Petrov
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Where is Oracle9i Release README shipped with 9.2.0.1

[Debi]

I did find the readme on MetaLink but I need to give the location to others 
in our office who don't have access...and the readme says it was installed 
on the server!  If I don't find it I will just copy the file from MetaLink, 
convert it to ascii text, and put it on the server myself.  I suspect it is 
now an html file and not one of the txt files (but the others don't have 
the ability to run html either).  It used to be so easy.

At 05:13 PM 6/3/2002 -0800, you wrote:
Debi, did you happen to go to technet.oracle.com and see if want you need 
is there?

joe


[EMAIL PROTECTED] wrote:

I can't find the generic rdbms README anywhere on my server for 9iR2.
There are 42 readme.txt files on the server in a variety of formats/cases 
making it difficult to find: README.txt, readme.txt, Readme.txt, and even 
readmeXX.txt where XX is a one or more character code. Some are in 
specific product doc subdirectories, but not all...others are in a 
higher doc directory.
Where is the RDBMS server readme that must have been installed with 9iR2 
software?
Thanks,

Debi


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Debi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: trial version of Oracle Financial ??

[MICHAEL.SALE]

There is no Trial version of the E-Business suite. Check with your Oracle 
salesperson to see if you can work something out.

Mike

 
 Hi,
 
 Does anyone know where to get a trial version of
 Oracle Financial, or other components of 11i?
 
 Thank you!
 
 Leslie
 
 __
 Do You Yahoo!?
 Yahoo! - Official partner of 2002 FIFA World Cup
 http://fifaworldcup.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Leslie Lu
  INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing 
 Lists 
  
 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: MICHAEL.SALE
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Where is Oracle9i Release README shipped with 9.2.0.1

[Mladen Gogala]

Whaddya mean by run html? HTML files are not run, they are viewed in 
Galeon,
Mozilla or, pardon my French, IE.



On 2002.06.03 22:38 Debi wrote:
 I did find the readme on MetaLink but I need to give the location to 
 others in our office who don't have access...and the readme says it 
 was installed on the server!  If I don't find it I will just copy the 
 file from MetaLink, convert it to ascii text, and put it on the 
 server myself.  I suspect it is now an html file and not one of the 
 txt files (but the others don't have the ability to run html 
 either).  It used to be so easy.
 
 At 05:13 PM 6/3/2002 -0800, you wrote:
 Debi, did you happen to go to technet.oracle.com and see if want you 
 need is there?
 
 joe
 
 
 [EMAIL PROTECTED] wrote:
 
 I can't find the generic rdbms README anywhere on my server for 
 9iR2.
 There are 42 readme.txt files on the server in a variety of 
 formats/cases making it difficult to find: README.txt, readme.txt, 
 Readme.txt, and even readmeXX.txt where XX is a one or more 
 character code. Some are in specific product doc subdirectories, 
 but not all...others are in a higher doc directory.
 Where is the RDBMS server readme that must have been installed with 
 9iR2 software?
 Thanks,
 
 Debi
 
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Joe Testa
  INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing 
 Lists
 
 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: Debi
  INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Where is Oracle9i Release README shipped with 9.2.0.1

[Mladen Gogala]

$ ls -l $ORACLE_HOME/rdbms/doc
total 236
rw-r--r--1 oracle   dba239804 Jun  2 18:50 README_rdbms.html

$ sqlplus scott/tiger
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Jun 4 00:16:33 2002

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning and OLAP options
JServer Release 9.2.0.1.0 - Production

SQL 



On 2002.06.03 21:13 Joe Testa wrote:
 Debi, did you happen to go to technet.oracle.com and see if want you 
 need is there?
 
 joe
 
 
 [EMAIL PROTECTED] wrote:
 
 I can't find the generic rdbms README anywhere on my server for 
 9iR2.  There are 42 readme.txt files on the server in a variety of 
 formats/cases making it difficult to find: README.txt, readme.txt, 
 Readme.txt, and even readmeXX.txt where XX is a one or more 
 character code. Some are in specific product doc subdirectories, 
 but not all...others are in a higher doc directory. Where is the 
 RDBMS server readme that must have been installed with 9iR2 
 software? Thanks,
 
 Debi
 
 
 
-- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
 Author: Joe Testa
  INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 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).

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).