RE: Oracle Version on Unix

2002-09-11 Thread DENNIS WILLIAMS

file $ORACLE_HOME/bin/oracle

-Original Message-
Sent: Wednesday, September 11, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L


I know this was discussed a short time ago, but how do I determine if the
Oracle 817 version installed on a Sun Unix box is 32 or 64 bit?

I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly
migrate a 32bit version to 64 bit.

Thanks

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, September 11, 2002 2:18 PM
To: Multiple recipients of list ORACLE-L


My house is insured and I'm contemplating a ground up redecoration.
As for being an infidel, the God is great and Larry Wall is his prophet.
I'm a true believer.


 -Original Message-
 From: Naveen Nahata [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, September 11, 2002 12:30 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Re: View Locks
 
 
 Please don't use wrong words like these for the Al Qaida 
 members, you risk
 termed an 'infidel' and getting your house attacked by a 
 suicide bomber :-)
 
 -Original Message-
 Sent: Wednesday, September 11, 2002 9:44 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Nope. Developers are not normal users and Al Quaida members are not
 normal members of society. Both are very dangerous.
 
  -Original Message-
  From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, September 11, 2002 11:09 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Re: View Locks
  
  
  
  I have a problem with normal users monitoring
  locks. 
  
  
  Do you consider developers to be normal users? Given the 
  number of locking problems which you can trace back to the 
  code, I would have no problem in that case.
  
  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: 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).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Naveen Nahata
   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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  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 

Re: Oracle Version on Unix

2002-09-11 Thread Glenn Stauffer

file $ORACLE_HOME/bin/oracle


On Wed, 2002-09-11 at 15:03, Mercadante, Thomas F wrote:
 I know this was discussed a short time ago, but how do I determine if the
 Oracle 817 version installed on a Sun Unix box is 32 or 64 bit?
 
 I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly
 migrate a 32bit version to 64 bit.
 
 Thanks
 
 Tom Mercadante
 Oracle Certified Professional
 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Glenn Stauffer
  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 Version on Unix

2002-09-11 Thread Shaw John-P55297

Just login with sqlplus you'll get:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

If it's 64 bit it tells you.

-Original Message-
Sent: Wednesday, September 11, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L


I know this was discussed a short time ago, but how do I determine if the
Oracle 817 version installed on a Sun Unix box is 32 or 64 bit?

I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly
migrate a 32bit version to 64 bit.

Thanks

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, September 11, 2002 2:18 PM
To: Multiple recipients of list ORACLE-L


My house is insured and I'm contemplating a ground up redecoration.
As for being an infidel, the God is great and Larry Wall is his prophet.
I'm a true believer.


 -Original Message-
 From: Naveen Nahata [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, September 11, 2002 12:30 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Re: View Locks
 
 
 Please don't use wrong words like these for the Al Qaida 
 members, you risk
 termed an 'infidel' and getting your house attacked by a 
 suicide bomber :-)
 
 -Original Message-
 Sent: Wednesday, September 11, 2002 9:44 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Nope. Developers are not normal users and Al Quaida members are not
 normal members of society. Both are very dangerous.
 
  -Original Message-
  From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, September 11, 2002 11:09 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Re: View Locks
  
  
  
  I have a problem with normal users monitoring
  locks. 
  
  
  Do you consider developers to be normal users? Given the 
  number of locking problems which you can trace back to the 
  code, I would have no problem in that case.
  
  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: 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).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Naveen Nahata
   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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

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

RE: Oracle Version on Unix

2002-09-11 Thread Ji, Richard

There are couple of methods to determine it.  One is when you
login as sqlplus, it will show the word 64 bit in the banner.

Or if you do file $ORACLE_HOME/bin/oracle
oracle: ELF 64-bit MSB executable SPARCV9 Version 1, dynamically
linked, not stripped

It shows whether is a 32bit or 64bit executable.


-Original Message-
Sent: Wednesday, September 11, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L


I know this was discussed a short time ago, but how do I determine if the
Oracle 817 version installed on a Sun Unix box is 32 or 64 bit?

I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly
migrate a 32bit version to 64 bit.

Thanks

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, September 11, 2002 2:18 PM
To: Multiple recipients of list ORACLE-L


My house is insured and I'm contemplating a ground up redecoration.
As for being an infidel, the God is great and Larry Wall is his prophet.
I'm a true believer.


 -Original Message-
 From: Naveen Nahata [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, September 11, 2002 12:30 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Re: View Locks
 
 
 Please don't use wrong words like these for the Al Qaida 
 members, you risk
 termed an 'infidel' and getting your house attacked by a 
 suicide bomber :-)
 
 -Original Message-
 Sent: Wednesday, September 11, 2002 9:44 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Nope. Developers are not normal users and Al Quaida members are not
 normal members of society. Both are very dangerous.
 
  -Original Message-
  From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, September 11, 2002 11:09 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Re: View Locks
  
  
  
  I have a problem with normal users monitoring
  locks. 
  
  
  Do you consider developers to be normal users? Given the 
  number of locking problems which you can trace back to the 
  code, I would have no problem in that case.
  
  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: 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).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Naveen Nahata
   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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

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

RE: Oracle Version on Unix

2002-09-11 Thread Markham, Richard
Title: RE: Oracle Version on Unix





Chapter 7 Section Changing the Word-Size of your Current Release
within the Oracle 9i Database Migration Manual.


I dont see why you couldn't do: file ${ORACLE_HOME}/bin/oracle to 
determine the word size.


-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L
Subject: Oracle Version on Unix



I know this was discussed a short time ago, but how do I determine if the
Oracle 817 version installed on a Sun Unix box is 32 or 64 bit?


I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly
migrate a 32bit version to 64 bit.


Thanks


Tom Mercadante
Oracle Certified Professional



-Original Message-
Sent: Wednesday, September 11, 2002 2:18 PM
To: Multiple recipients of list ORACLE-L



My house is insured and I'm contemplating a ground up redecoration.
As for being an infidel, the God is great and Larry Wall is his prophet.
I'm a true believer.



 -Original Message-
 From: Naveen Nahata [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, September 11, 2002 12:30 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Re: View Locks
 
 
 Please don't use wrong words like these for the Al Qaida 
 members, you risk
 termed an 'infidel' and getting your house attacked by a 
 suicide bomber :-)
 
 -Original Message-
 Sent: Wednesday, September 11, 2002 9:44 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Nope. Developers are not normal users and Al Quaida members are not
 normal members of society. Both are very dangerous.
 
  -Original Message-
  From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, September 11, 2002 11:09 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Re: View Locks
  
  
  
  I have a problem with normal users monitoring
  locks. 
  
  
  Do you consider developers to be normal users? Given the 
  number of locking problems which you can trace back to the 
  code, I would have no problem in that case.
  
  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: 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).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Naveen Nahata
 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
 INET: [EMAIL PROTECTED]


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

RE: Oracle Version on Unix

2002-09-11 Thread Gogala, Mladen

Go to $ORACLE_HOME/lib and do
nm ibclntsh.so|grep fgetpos64

If your output is nonempty, your oracle is 64 bit.

 -Original Message-
 From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, September 11, 2002 3:04 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Oracle Version on Unix
 
 
 I know this was discussed a short time ago, but how do I 
 determine if the
 Oracle 817 version installed on a Sun Unix box is 32 or 64 bit?
 
 I'm looking at migrating to 9.2/64 bit and noticed that I 
 cannot directly
 migrate a 32bit version to 64 bit.
 
 Thanks
 
 Tom Mercadante
 Oracle Certified Professional
 
 
 -Original Message-
 Sent: Wednesday, September 11, 2002 2:18 PM
 To: Multiple recipients of list ORACLE-L
 
 
 My house is insured and I'm contemplating a ground up redecoration.
 As for being an infidel, the God is great and Larry Wall is 
 his prophet.
 I'm a true believer.
 
 
  -Original Message-
  From: Naveen Nahata [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, September 11, 2002 12:30 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Re: View Locks
  
  
  Please don't use wrong words like these for the Al Qaida 
  members, you risk
  termed an 'infidel' and getting your house attacked by a 
  suicide bomber :-)
  
  -Original Message-
  Sent: Wednesday, September 11, 2002 9:44 PM
  To: Multiple recipients of list ORACLE-L
  
  
  Nope. Developers are not normal users and Al Quaida members are not
  normal members of society. Both are very dangerous.
  
   -Original Message-
   From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
   Sent: Wednesday, September 11, 2002 11:09 AM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: Re: View Locks
   
   
   
   I have a problem with normal users monitoring
   locks. 
   
   
   Do you consider developers to be normal users? Given the 
   number of locking problems which you can trace back to the 
   code, I would have no problem in that case.
   
   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: 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).
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Naveen Nahata
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).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Mercadante, Thomas F
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 

RE: Oracle Version on Unix

2002-09-11 Thread Mercadante, Thomas F

Dennis,

You da'man.  Thank you!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, September 11, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L


file $ORACLE_HOME/bin/oracle

-Original Message-
Sent: Wednesday, September 11, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L


I know this was discussed a short time ago, but how do I determine if the
Oracle 817 version installed on a Sun Unix box is 32 or 64 bit?

I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly
migrate a 32bit version to 64 bit.

Thanks

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, September 11, 2002 2:18 PM
To: Multiple recipients of list ORACLE-L


My house is insured and I'm contemplating a ground up redecoration.
As for being an infidel, the God is great and Larry Wall is his prophet.
I'm a true believer.


 -Original Message-
 From: Naveen Nahata [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, September 11, 2002 12:30 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Re: View Locks
 
 
 Please don't use wrong words like these for the Al Qaida 
 members, you risk
 termed an 'infidel' and getting your house attacked by a 
 suicide bomber :-)
 
 -Original Message-
 Sent: Wednesday, September 11, 2002 9:44 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Nope. Developers are not normal users and Al Quaida members are not
 normal members of society. Both are very dangerous.
 
  -Original Message-
  From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, September 11, 2002 11:09 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Re: View Locks
  
  
  
  I have a problem with normal users monitoring
  locks. 
  
  
  Do you consider developers to be normal users? Given the 
  number of locking problems which you can trace back to the 
  code, I would have no problem in that case.
  
  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: 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).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Naveen Nahata
   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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

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

RE: Oracle Version on Unix

2002-09-11 Thread Molina, Gerardo

If you are using the manual upgrade method, then you can go from 32-bit
8.1.7 to 64-bit 9.2.0.1 directly.  Don't quote me though, because all the
documentation I have seen says that you have to first go from 32-bit 8.1.7
to 32-bit 9.2.0.1 and then to 64-bit 9.2.0.1.  I think Oracle is just being
extra cautious here.

I have recently upgraded (manual upgrade) a dev database from 32-bit 8.1.7
to 64-bit 9.2.0.1 (directly) and so far have not seen anything unusual.

HTH,
Gerardo

-Original Message-
Sent: Wednesday, September 11, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L


Dennis,

You da'man.  Thank you!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, September 11, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L


file $ORACLE_HOME/bin/oracle

-Original Message-
Sent: Wednesday, September 11, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L


I know this was discussed a short time ago, but how do I determine if the
Oracle 817 version installed on a Sun Unix box is 32 or 64 bit?

I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly
migrate a 32bit version to 64 bit.

Thanks

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, September 11, 2002 2:18 PM
To: Multiple recipients of list ORACLE-L


My house is insured and I'm contemplating a ground up redecoration.
As for being an infidel, the God is great and Larry Wall is his prophet.
I'm a true believer.


 -Original Message-
 From: Naveen Nahata [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, September 11, 2002 12:30 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Re: View Locks
 
 
 Please don't use wrong words like these for the Al Qaida 
 members, you risk
 termed an 'infidel' and getting your house attacked by a 
 suicide bomber :-)
 
 -Original Message-
 Sent: Wednesday, September 11, 2002 9:44 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Nope. Developers are not normal users and Al Quaida members are not
 normal members of society. Both are very dangerous.
 
  -Original Message-
  From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, September 11, 2002 11:09 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Re: View Locks
  
  
  
  I have a problem with normal users monitoring
  locks. 
  
  
  Do you consider developers to be normal users? Given the 
  number of locking problems which you can trace back to the 
  code, I would have no problem in that case.
  
  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: 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).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Naveen Nahata
   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,