RE: Oracle - 32bit/64bit??

2002-07-23 Thread Adrian Roe

Just log into the database using sqlplus and it will tell you

/u01/app/oraclesqlplus /

SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jul 23 10:16:50 2002

(c) Copyright 2001 Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit Production
With the Partitioning option
JServer Release 9.0.1.2.0 - Production

SQL


-Original Message-
Sent: 23 July 2002 00:09
To: Multiple recipients of list ORACLE-L


Hi,
Does anyone know how I can verify if a database is 32 or 64 bit?

Thanks.

elain



_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

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

--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to which it is 
addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the 
company. Any review, retransmission, dissemination or other use of, or taking of any 
action in reliance upon, this information by persons or entities other than the 
intended recipient is prohibited. If you received this in error, please contact the 
sender immediately and delete the material from any computer.


==

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Adrian Roe
  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 - 32bit/64bit??

2002-07-23 Thread Vikas Khanna

If 64 bit then 
Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit Production
else 
Oracle9i Enterprise Edition Release 9.0.1.2.0
end if;

Vikas Khanna 
-Original Message-
Sent: Tuesday, July 23, 2002 3:54 PM
To: Multiple recipients of list ORACLE-L


Just log into the database using sqlplus and it will tell you

/u01/app/oraclesqlplus /

SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jul 23 10:16:50 2002

(c) Copyright 2001 Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit Production
With the Partitioning option
JServer Release 9.0.1.2.0 - Production

SQL


-Original Message-
Sent: 23 July 2002 00:09
To: Multiple recipients of list ORACLE-L


Hi,
Does anyone know how I can verify if a database is 32 or 64 bit?

Thanks.

elain



_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

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


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Adrian Roe
  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: Vikas Khanna
  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 - 32bit/64bit??

2002-07-22 Thread elain he

Hi,
Does anyone know how I can verify if a database is 32 or 64 bit?

Thanks.

elain



_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: elain he
  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 - 32bit/64bit??

2002-07-22 Thread kkennedy

As someone mentioned on the list, not too recently, use the following command:
file $ORACLE_HOME/bin/oracle

On my machine with 32 bit Oracle, I get:
/keg2/oracle/product/8.1.7/bin/oracle:  ELF 32-bit MSB executable SPARC Version 1, 
dynamically linked, not stripped

HTH
Kevin Kennedy
First Point Energy Corporation 

-Original Message-
Sent: Monday, July 22, 2002 4:09 PM
To: Multiple recipients of list ORACLE-L


Hi,
Does anyone know how I can verify if a database is 32 or 64 bit?

Thanks.

elain



_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: elain he
  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: 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: Further question: Oracle 32bit / 64bit

2001-07-19 Thread paquette stephane

The main problem with Oracle 816 64 bit Solaris is
that is it so late behind in term of patches. 

8163 is not available yet !


 --- [EMAIL PROTECTED] a écrit :  Last time that I
installed Oracle 8.1.6 on a Sun 64
 bit OS I installed the
 64 bit version.  If you pressed me real hard as to
 why I did that, the best
 that I could say is that it seemed like a good idea
 at the time.  Some
 vague idea that the 64 bit version would work better
 (more optimally) with
 the 64 bit OS.  I haven't seen anything to make me
 think that the 32 bit
 version would have been a better choice.
 
 On the other hand, it was a new installation, not a
 migration of an
 existing database.  I don't know if there are any
 problems with migrating a
 32 bit version database to 64 bit.
 
 Finally, the Oracle installation manual seems to
 assume the 32 bit version.
 As I remember we had to tweak the kernel parameters
 to get the database to
 mount and open.  Don't remember which.  Fortunately,
 you don't have to
 reboot to get the changes to take effect.
 
 -- 
 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). 

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Vos albums photos en ligne, 
Yahoo! Photos : http://fr.photos.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  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: Further question: Oracle 32bit / 64bit

2001-07-19 Thread tday6

Good point.



   
  
paquette stephane  
  
stephane_paquette@To: Multiple recipients of list 
ORACLE-L  
yahoo.com [EMAIL PROTECTED]  
  
Sent by:   cc: 
  
[EMAIL PROTECTED]   Subject: Re: Further question: 
Oracle 32bit / 
   64bit   
  
   
  
07/19/2001 10:05 AM
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




The main problem with Oracle 816 64 bit Solaris is
that is it so late behind in term of patches.

8163 is not available yet !


 --- [EMAIL PROTECTED] a écrit :  Last time that I
installed Oracle 8.1.6 on a Sun 64
 bit OS I installed the
 64 bit version.  If you pressed me real hard as to
 why I did that, the best
 that I could say is that it seemed like a good idea
 at the time.  Some
 vague idea that the 64 bit version would work better
 (more optimally) with
 the 64 bit OS.  I haven't seen anything to make me
 think that the 32 bit
 version would have been a better choice.

 On the other hand, it was a new installation, not a
 migration of an
 existing database.  I don't know if there are any
 problems with migrating a
 32 bit version database to 64 bit.

 Finally, the Oracle installation manual seems to
 assume the 32 bit version.
 As I remember we had to tweak the kernel parameters
 to get the database to
 mount and open.  Don't remember which.  Fortunately,
 you don't have to
 reboot to get the changes to take effect.

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

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Vos albums photos en ligne,
Yahoo! Photos : http://fr.photos.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
  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: Further question: Oracle 32bit / 64bit

2001-07-18 Thread tday6

Last time that I installed Oracle 8.1.6 on a Sun 64 bit OS I installed the
64 bit version.  If you pressed me real hard as to why I did that, the best
that I could say is that it seemed like a good idea at the time.  Some
vague idea that the 64 bit version would work better (more optimally) with
the 64 bit OS.  I haven't seen anything to make me think that the 32 bit
version would have been a better choice.

On the other hand, it was a new installation, not a migration of an
existing database.  I don't know if there are any problems with migrating a
32 bit version database to 64 bit.

Finally, the Oracle installation manual seems to assume the 32 bit version.
As I remember we had to tweak the kernel parameters to get the database to
mount and open.  Don't remember which.  Fortunately, you don't have to
reboot to get the changes to take effect.

-- 
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 32bit / 64bit

2001-07-17 Thread Mitchell

Dear DBAs

How can I know  my Oracle running on 32 or 64bit ?
I am considering change configuration of SGA. Currently OS is updated to 8g
memory on aix 4.3.3.
The limit is 2gb for 32bit ?

I only know if you switch  from 32bit to 64bit or vice-a-versa, then  you
also need to run UTLIRP.SQL script which recompiles all PL/SQL modules and
alters certain dictionary tables.


Mitchell



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mitchell
  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 32bit / 64bit

2001-07-17 Thread Christopher Spence

Easiest way I know is do a select * from v$session, if the session id is 8
digits your running 32 bit, if it is 16 your running 64 bit.

Walking on water and developing software from a specification are easy if
both are frozen.

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Tuesday, July 17, 2001 3:38 PM
To: Multiple recipients of list ORACLE-L


Dear DBAs

How can I know  my Oracle running on 32 or 64bit ?
I am considering change configuration of SGA. Currently OS is updated to 8g
memory on aix 4.3.3. The limit is 2gb for 32bit ?

I only know if you switch  from 32bit to 64bit or vice-a-versa, then  you
also need to run UTLIRP.SQL script which recompiles all PL/SQL modules and
alters certain dictionary tables.


Mitchell



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mitchell
  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: Christopher Spence
  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 32bit / 64bit

2001-07-17 Thread Deshpande, Kirti

The SQL*Plus banner will display if using 64bit. If it does not say '64bit'
then it's 32bit. 

Here is what I get with 9.0.1 64-bit on HP-UX:

Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - 64bit Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production

I do not have 8.1.x in 64-bit but I think the same thing would be true there
as well.

HTH,

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

 -Original Message-
 From: Mitchell [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, July 17, 2001 2:38 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: Oracle 32bit / 64bit
 
 Dear DBAs
 
 How can I know  my Oracle running on 32 or 64bit ?
 I am considering change configuration of SGA. Currently OS is updated to
 8g
 memory on aix 4.3.3.
 The limit is 2gb for 32bit ?
 
 I only know if you switch  from 32bit to 64bit or vice-a-versa, then  you
 also need to run UTLIRP.SQL script which recompiles all PL/SQL modules and
 alters certain dictionary tables.
 
 
 Mitchell
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Mitchell
   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: Deshpande, Kirti
  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 32bit / 64bit

2001-07-17 Thread Kimberly Smith

Actually, as soon as you sign onto SQL*Plus is good enough.
Oracle8i Enterprise Edition Release 8.1.5.0.0, 64 bit - Production
Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production
Note the difference between the two.

-Original Message-
Sent: Tuesday, July 17, 2001 1:00 PM
To: Multiple recipients of list ORACLE-L


Easiest way I know is do a select * from v$session, if the session id is 8
digits your running 32 bit, if it is 16 your running 64 bit.

Walking on water and developing software from a specification are easy if
both are frozen.

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Tuesday, July 17, 2001 3:38 PM
To: Multiple recipients of list ORACLE-L


Dear DBAs

How can I know  my Oracle running on 32 or 64bit ?
I am considering change configuration of SGA. Currently OS is updated to 8g
memory on aix 4.3.3. The limit is 2gb for 32bit ?

I only know if you switch  from 32bit to 64bit or vice-a-versa, then  you
also need to run UTLIRP.SQL script which recompiles all PL/SQL modules and
alters certain dictionary tables.


Mitchell



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mitchell
  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: Christopher Spence
  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: Kimberly Smith
  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).



Further question: Oracle 32bit / 64bit

2001-07-17 Thread Dan . Hubler


OK help me out here...

We are contemplating moving up to the new Sun/Solaris  sunfire
architecture,
which is a 64-bit platform.
We would be moving from multiple Solaris 32-bit machines.

What are my options as far as running Oracle 8.1.6.x?

Upgrade?
Re-install and move data?
Run Oracle 32-bit on the 64-bit platform?

Thanks.





-- Forwarded by Dan Hubler/DS/MICORP on 07/17/2001
03:33 PM ---


Rao, Maheswara [EMAIL PROTECTED]@fatcity.com on 07/17/2001
04:10:46 PM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:


Mitchell,

We have both 32 bit and 64 bit Oracle 817 running on Solaris 7.

The easiest way is --- When you log onto SQL, then you would get a message
similar to following:

Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64 bit production

Now, if you are running 32 bit version, you get the following message

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production

Please observe that the above message is not telling whether it is 32 or
64.
But for 64 bit, the message specifically tells you.


Thanks,

Rao

-Original Message-
Sent: Tuesday, July 17, 2001 3:38 PM
To: Multiple recipients of list ORACLE-L


Dear DBAs

How can I know  my Oracle running on 32 or 64bit ?
I am considering change configuration of SGA. Currently OS is updated to 8g
memory on aix 4.3.3.
The limit is 2gb for 32bit ?

I only know if you switch  from 32bit to 64bit or vice-a-versa, then  you
also need to run UTLIRP.SQL script which recompiles all PL/SQL modules and
alters certain dictionary tables.


Mitchell



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