f



Clone a 10gR2 database running on 64 bit server to 32 bit server

I Have to clone a 10gR2 database running on 64 bit server to 32 bit
server.
Details:
we have HOT backup of last night.
Database running on Red hat Linux 4.
DB version : 10.2.0.2.
Any suggestions are appreciated.
0
9/9/2008 5:17:23 PM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

4 Replies
974 Views

Similar Articles

[PageSpeed] 26

is the oracle binary 32-bit or 64-bit ?
regards
srivenu
0
srivenu (188)
9/9/2008 5:27:51 PM
On Sep 9, 11:27=A0am, sriv...@hotmail.com wrote:
> is the oracle binary 32-bit or 64-bit ?
> regards
> srivenu

The server has 32 bit binaries.
0
9/9/2008 5:32:37 PM
On Sep 9, 12:32=A0pm, amr <maheshn...@gmail.com> wrote:
> On Sep 9, 11:27=A0am, sriv...@hotmail.com wrote:
>
> > is the oracle binary 32-bit or 64-bit ?
> > regards
> > srivenu
>
> The server has 32 bit binaries.

This is on the 64-bit machine?


David Fitzjarrell
0
fitzjarrell (2006)
9/9/2008 8:36:33 PM
On Sep 9, 10:32=A0am, amr <maheshn...@gmail.com> wrote:
> On Sep 9, 11:27=A0am, sriv...@hotmail.com wrote:
>
> > is the oracle binary 32-bit or 64-bit ?
> > regards
> > srivenu
>
> The server has 32 bit binaries.

Well, it could be out of date, but see metalink Note:62290.1 &
467676.1. I think the part about 32-bit not being supported on 64-bit
might be right, judging from the certification matrix.  But with
linux, who knows what evil lurks in the machinations of men?  And I
could be wrong, not actually using linux now.  Platforms that support
both will say 64-bit only if 64-bit, but platforms that only support
64-bit won't say it, AFAIK (Note:119707.1).

So, be explicit in how you know it is 32-bit, we might all learn
something.

jg
--
@home.com is bogus.
"Pacific Surliner (San Diego to San Luis Obispo)" - from Irvine
Transportation Center website.  Yep, some of those conductors are
pretty surly.
0
joel-garry (4553)
9/9/2008 11:33:38 PM
Reply:

Similar Artilces:

Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005
Hello - I have a strange problem when casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005. I got two servers. One has 32-bit SQL server 2005 standard edition (version 9.00.3073.00) on Windows NT 5.2 (3790) with NT INTEL x86. The second server has 64-bit SQL server Enterprise edition (version 9.00.4035.00) on Windows NT 5.2 (3790) with NT AMD64. The problem came when I tried to cast value under 32-bit SQL server 2005, the result gets queried out. But when the same sql got run, it prompted conversion error - "Error converting data type varchar to numeric." ...

Installing 32-bit and 64-bit oracle client on windows 2003 Server
Hi, I am wondering if we could install 32-bit client of 10g release2 and 64-bit client of the same (allowing delphi 32-bit apps and some .net Windows services to connect to the oracle database server hosted on HP- UX running 64-bit mode. has anyone done this before? If so, can you please provide me some documentation of how to configure the same. Thanks in advance. Deepak. ...

Installing 32-bit and 64-bit oracle client on windows 2003 Server
Hi, I am wondering if we could install 32-bit client of 10g release2 and 64-bit client of the same (allowing delphi 32-bit apps and some .net Windows services to connect to the oracle database server hosted on HP- UX running 64-bit mode. has anyone done this before? If so, can you please provide me some documentation of how to configure the same. Thanks in advance. Deepak. On 13 Apr 2007 10:00:52 -0700, deepak.kollipara@gmail.com wrote: >Hi, > >I am wondering if we could install 32-bit client of 10g release2 and >64-bit client of the same (allowing delphi 32-bit apps and some .net >Windows services to connect to the oracle database server hosted on HP- >UX running 64-bit mode. has anyone done this before? > >If so, can you please provide me some documentation of how to >configure the same. > >Thanks in advance. >Deepak. Fact: 32-bit client can communicate with 64-bit server without problem. Fact: if you want to install 2 different clients you need to install them in 2 different Oracle homes Fact: your question is redundant, as this is all outlined in the installation documentation on http://otn.oracle.com or http://tahiti.oracle.com both reachable from http://www.oracle.com Fact: you were even too lazy to type www.oracle.com in your browser and hit the documentation button. -- Sybrand Bakker Senior Oracle DBA On Apr 13, 11:12 am, sybra...@hccnet.nl wrote: > On 13 Apr 2007 10:00:52 -0700, deepak.kollip...@gmail.com wrote: >...

Installing 32-bit and 64-bit oracle client on windows 2003 Server
Hi, I am wondering if we could install 32-bit client of 10g release2 and 64-bit client of the same (allowing delphi 32-bit apps and some .net Windows services to connect to the oracle database server hosted on HP- UX running 64-bit mode. has anyone done this before? If so, can you please provide me some documentation of how to configure the same. Thanks in advance. Deepak. ...

Server to server = Server client to server?
For a server to server connection, is the connecting server considered as a client of the accepting server or is it not? I have the following classes: Connection <--- base class of the following two ClientConnection <--- client ServerConnection <--- server ServerClientConnection <--- server as a client of another server. But then I came across something that states "A client is anything connected to a server that is not another client". Comments please... Just remember! Server ( programm ) is always listening a connections!!! - wrote: &g...

New Instance for Existing Database -- 10gR2 under Win Server 2003 64-bit
I'm a Unix/Linux Oracle developer who needs to ask a Windows-oriented DBA question. For testing purposes, one of the guys in this shop wants a new instance that will access existing database files. Working from home late at night, he copied all the files (control files, DBFs, and everything) and then blew away the instance and installed a new one. Now he wants a new instance that can mount the files that he copied. If someone with Windows DBA knowledge could say to me, "Read Chapter nn of the XYZ Manual, you fool," that would be extremely helpful. I'm just not certain where to start. :-) Thanks to all who've taken the time to read this post. David Clement On Jul 2, 9:24=A0am, DavidClement <dclem...@davidclement.org> wrote: > I'm a Unix/Linux Oracle developer who needs to ask a Windows-oriented > DBA question. > > For testing purposes, one of the guys in this shop wants a new > instance that will access existing database files. Working from home > late at night, he copied all the files (control files, DBFs, and > everything) and then blew away the instance and installed a new one. > Now he wants a new instance that can mount the files that he copied. > > If someone with Windows DBA knowledge could say to me, "Read Chapter > nn of the XYZ Manual, you fool," that would be extremely helpful. I'm > just not certain where to start. :-) > > Thanks to all who've taken the time to read thi...

Matlab 64 bit on 32 bit server
Right now we have Matlab R2007a running on a 32 bit Linux server, which is accessed from our 32 bit workstations. Next week we will be adding a few workstations with 64 bit CPU's, so I have a couple of questions: 1) Can I install the 64 bit version of Matlab on a 32 bit server and run it from a 64 bit workstation? If yes, 2) Can I install both 32 and 64 bit versions of Matlab on the same server, and have the license manager handle both? Or do I need two license managers running? Detailed steps would be greatly appreciated. On Apr 10, 4:22 pm, "Joachim Stahl" <s...@hotmai...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 ----------------------------------------------------------------------- IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit W3KSERVER 12 284 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit Linux IBM DB2 Connect Applic Server Edition V8.1.2 64bit W3KSERVER 12 392 IBM DB2 Spatial Extender v8.1 64Bit Multilanguage 12 610 ---------------------------------------------------------------------- Windows Liberty 64bit No.Of.Disk:1 Format:Cue/Bin Rar Files:9 Type:OS Protection:None Notes:Just another OS but you must have Windows XP to install install it and run it ----------------------------------------------------------------------- Windows Limited Edition 64 Bit Edition Format......: BIN/CUE RAR count........: 47 X 15mb Protection.......: None Date........: May 01, 2002 This is the Windows Limited Edition 64 Bit Edition operating system that will only run on 64 bit processors. It will not work on any others. To Install: No Serial or Crack is Needed for this rele...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit W3KSERVER 12 284 IBM DB2 Connect Applic Server Edition V8.1.2 64bit W3KSERVER 12 392 IBM DB2 Spatial Extender v8.1 64Bit Multilanguage 12 610 If you have Googled your butt off, and haven't come up with anything ...., and for 14,000 more reasons, please send e-mail, tel4@ath.forthnet.gr, tel2003@pathfinder.gr, astra35@pathfinder.gr, TEL wrote: > 64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, > Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - > new ! > > Windows Liberty 64bit 8403 > > Windows Limited Edition 64 Bit Edition 8764 > > Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 > > IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 > > IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 > > IBM DB2 UD...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit W3KSERVER 12 284 IBM DB2 Connect Applic Server Edition V8.1.2 64bit W3KSERVER 12 392 IBM DB2 Spatial Extender v8.1 64Bit Multilanguage 12 610 If you have Googled your butt off, and haven't come up with anything ...., and for 14,000 more reasons, please send e-mail, tel4@ath.forthnet.gr, tel2003@pathfinder.gr, astra35@pathfinder.gr, ...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 ----------------------------------------------------------------------- IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enter...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit W3KSERVER 12 284 IBM DB2 Connect Applic Server Edit...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 ----------------------------------------------------------------------- IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit W3KSERVER 12 284 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit Linux IBM DB2 Connect Applic Server Edition V8.1.2 64bit W3KSERVER 12 392 IBM DB2 Spatial Extender v8.1 64Bit Multilanguage 12 610 ---------------------------------------------------------------------- Windows Liberty 64bit No.Of.Disk:1 Format:Cue/Bin Rar Files:9 Type:OS Protection:None Notes:Just another OS but you must have Windows XP to install install it and run it ----------------------------------------------------------------------- Windows Limited Edition 64 Bit Edition Format......: BIN/CUE RAR count........: 47 X 15mb Protection.......: None Date........: May 01, 2002 This is the Windows Limited Edition 64 Bit Edition operating system that will only run on 64 bit processors. It will not work on any others. To I...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 ----------------------------------------------------------------------- IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enter...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit W3KSERVER 12 284 IBM DB2 Connect Ap...

moving 10GR2 from server 2003 32bit to server 2008 64 bit
IIRC correctly an online (or cold) backup (user managed or rman) can't be restored on a different platform, although I faintly recall before 10G was released hearing that 10G datafiles were going to be platform independent, but perhaps I misunderstood. Anyway, we are upgrading hardware on a 10GR2 database(windows 32b to windows 64b), and am considering different options to move the data. Other than transportable tablespaces (which I have never played with) am I limited to exp/imp? thanks On Jan 22, 4:56=A0pm, GS <g...@gs.com> wrote: > IIRC correctly an online (or cold) backup (user managed or rman) can't > be restored on a different platform, although I faintly recall before > 10G was released hearing that 10G datafiles were going to be platform > independent, but perhaps I misunderstood. > > Anyway, we are upgrading hardware on a 10GR2 database(windows 32b to > windows 64b), and am considering different options to move the data. > Other than transportable tablespaces (which I have never played with) am > I limited to exp/imp? > > thanks IIRC HJR is crazy about oracle support and testing quality on windows 2008 ... On Jan 22, 1:56=A0pm, GS <g...@gs.com> wrote: > IIRC correctly an online (or cold) backup (user managed or rman) can't > be restored on a different platform, although I faintly recall before > 10G was released hearing that 10G datafiles were going to be platform > independent, but per...

oracle 9i database on a aix 4.3.3 server trying to use a 32 bit compiler- error ksms.imp
We are trying to get a new setup to work. We have an Oracle 9.2.0.4 database on AIX 4.3.3. This database is using the 64 bit kernel extension. We have installed Server Express 2.1 for 4.3.3 (MF cobol compiler) which is a 32 bit app. We tried to edit the makefile used for AIX 4.3.3, MF cobol compiler OCDS, Oracle database 8.1.6. We learned about needing to relink rstora32, and the procob32� that has been done. We changed out markefile to point to all the 9i oracle 32 bit directories. We are note experienced with makefiles and not sure our makefile is ok. We are now having problems with the 32 bit version of ksms.imp. At first the file was empty. To resolve that problem we: Generated the ksms.imp as follows.. @ORACLE_HOME/bin/genksms > $ORACLE_HOME/lib32/ksms.imp and relinked the "genksms" binary: make �f $ORACLE_HOME/rdbms/lib32/ins_rdbms.mk $ORACLE_HOME/bin/genksms Do you know if we built this correctly? We do not seem to be able to compile without using the variable ...please note the error with the variable for ksms.imp and without that variable�. I hve included the makefile below Thanks 1. Problem when makefile has commented out line #LIMPEXP=$(LIBHOME)/ksms.imp This error is received for every line of code ld: 0711-418 ERROR: Import or export file /u00/app/oracle/product/9.2.0/lib32/ks ms.imp at line 4219: A symbol name may only be followed by an export attribute or an address. The line is being ignore...

moving oracle database server into a new server
Hi all I will be moving oracle from one Solaris server into another Solaris server, the IP address and box name will be changed. Oracle version is 8.1.7 and O/S is 5.8 on both servers ( just different O/S patch). Does any one know what I need to do in order to get oracle up and running again on the new server. I know that I will need to change the tnsnames.ora and listner.ora, but is there anything else that I need to do? Thanks Teresa Teresa wrote: > Hi all > > I will be moving oracle from one Solaris server into another Solaris > server, the IP address and box name will be changed. Oracle version is > 8.1.7 and O/S is 5.8 on both servers ( just different O/S patch). > Does any one know what I need to do in order to get oracle up and > running again on the new server. I know that I will need to change the > tnsnames.ora and listner.ora, but is there anything else that I need > to do? > > Thanks > Teresa When I do this with windows boxes I either: #1 Install oracle on the new box, create a new database and export/import from old db to new db #2 Copy datafiles, init, sqlnet, tns.. etc over from coldbackup or shutdown old_database, startup nomount and recreate the controlfile to fit new environment. #3 Restore from online backup of old_database and apply redo logs, again recreating the controlfile to fit the new env. (I usually only do this for "practice" and for creating a development copy of a prod db) #2 ...

Problem while accessing 64 bit Server thru 32 bit client
Hi I am using Oracle 10g. In this, I am fcaing probelm in accessing 64 bit Oracle Server thru 32 bit Client. I am not able to get connection from 32bit client to 64bit server. Could you please tell is there some special setting for this ?? Any helo or suggestion in this regard will be highly appriciated. Thanks in advance Ganesh Bansal "Ganesh" <ganesh.bansal@gmail.com> wrote in message news:1153489256.738166.186470@h48g2000cwc.googlegroups.com... > Hi > > I am using Oracle 10g. > > In this, I am fcaing probelm in accessing 64 bit Oracle Server thru 32 > bit Client. > I am not able to get connection from 32bit client to 64bit server. > > Could you please tell is there some special setting for this ?? > > Any helo or suggestion in this regard will be highly appriciated. > > Thanks in advance > > Ganesh Bansal > There isn't any special setting. You have to give us more information. Jim Ganesh schreef: > Hi > > I am using Oracle 10g. > > In this, I am fcaing probelm in accessing 64 bit Oracle Server thru 32 > bit Client. > I am not able to get connection from 32bit client to 64bit server. > > Could you please tell is there some special setting for this ?? > > Any helo or suggestion in this regard will be highly appriciated. > > Thanks in advance Problem? What problem? I do not see a problem! -- Regards, Frank van Bortel Top-posting is one way to shut...

Oracle 9i Database Server on Windows 2003 Server
I am wondering if we can install this Server on Windows 2003 Server without any problems. Is there anybody that did that before? Thanks in advance if someone know the answer. Yvon Bouchard, B. Sc. Computer Science Teacher http://info.cegepat.qc.ca/siteyvon I've installed it on windows 2003 enterprise ed. about 1 month ago without any problem. I've installed the version 9.2.0.1 with the patch to 9.2.0.3. 9.2.0.3 is the only version certified by oracle for win 2003. Ciao "Yvon Bouchard" <yvon.bouchard@cablevision.qc.ca> ha scritto nel messaggio news:QCLvb.21605$ZF1.2102185@news20.bellglobal.com... > I am wondering if we can install this Server on Windows 2003 Server without > any problems. > Is there anybody that did that before? > Thanks in advance if someone know the answer. > > Yvon Bouchard, B. Sc. Computer Science > Teacher > http://info.cegepat.qc.ca/siteyvon > > > Yvon Bouchard wrote: > > I am wondering if we can install this Server on Windows 2003 Server without > any problems. > Is there anybody that did that before? > Thanks in advance if someone know the answer. > Although I have not installed on Windows 2003 myself, I know of several such installations and all occurred without issue. I do note that Oracle has a separate download (CD set) for the WIndows 2003 compared to NT/2000/XP, so I suspect the install for the latter may not be ...

upgrade oracle 32-bit 9204 apps database to 64-bit 9207
I'am in the process of upgrading my 32-bit 9204 apps database to 64-bit 9207. Just wanted to make sure i covered everything. 1) Install 9201 64-bit 2) apply 64bit 9207 on it. 3) Copy init.ora and orapwd file to new Oracle home 4) startup migrate (with _system_trig_enabled = FALSE) 5) run @utlip.sql 6) download patch 1994933 and run rmsro.sql, call rmsro.run(); & invalidate.sql 7) create or replace java system; 8) @catpatch.sql 9) utlrp.sql 10) shutdown and restart (after removing setting _system_trig_enabled = TRUE) 10) copy appsutil from 32-bit 9204 to 64-bit 9207 home and run perl adcfgclone.pl dbTechStack Did i miss any steps ? Any redundant steps in there ? Thanks & regards srivenu srivenu@hotmail.com wrote: > I'am in the process of upgrading my 32-bit 9204 apps database to 64-bit > 9207. > > Just wanted to make sure i covered everything. > > 1) Install 9201 64-bit > 2) apply 64bit 9207 on it. > 3) Copy init.ora and orapwd file to new Oracle home > 4) startup migrate (with _system_trig_enabled = FALSE) > 5) run @utlip.sql > 6) download patch 1994933 and run rmsro.sql, call rmsro.run(); & > invalidate.sql > 7) create or replace java system; > 8) @catpatch.sql > 9) utlrp.sql > 10) shutdown and restart (after removing setting _system_trig_enabled > = TRUE) > 10) copy appsutil from 32-bit 9204 to 64-bit 9207 home and run perl > adcfgclone.pl dbTechStack > > Did i miss any steps ? &g...

32 bit or 64 bit Oracle on 64 bit OS?
Hello, Currently our environment is on 10g Release 2, OS windows 2000/2003 standard edition 32 bit. We use shared server to take advantage of scalability and connecting maximum no of simultaneous connections to the database. Now we take advantage of memory beyond 4GB we are planning to check following. 64 bit Windows 2003 standard edition on AMD64/EM64T Servers. Do we need to install 64 bit Oracle as well? Do we need to reinstall Oracle clients with 64 bit installable if Oracle Server is upgraded to 64 bit? Is 32 bit Oracle is certified on 64 bit OS? Do we need to take care of any other issues? Kindly share your experiences and help me to get the answers of these questions. Thanks & Regards, Shailesh Can migrating to Linux will be better option than 64 bit Windows? Please let me know your opinion on this as well. Thanks & Regards, Shailesh Updated Subject. Comments embedded. Shailesh wrote: > Hello, > > Currently our environment is on 10g Release 2, OS windows 2000/2003 > standard edition 32 bit. We use shared server to take advantage of > scalability and connecting maximum no of simultaneous connections to > the database. Now we take advantage of memory beyond 4GB we are > planning to check following. > > 64 bit Windows 2003 standard edition on AMD64/EM64T Servers. > > Do we need to install 64 bit Oracle as well? Yes, 64 bit Oracle is required on 64 bit Windows. The 32 bit version of Oracle may work, but is not su...

performance problem with fetch using 8.1.7 32-bit client to access a 64-bit server
We are running 8.1.7.4 64-bit Oracle on Solaris 8/sparc3. We have a client which was compiled on a 32-bit sparcII platform. We find that when we run multiple instances of the client we find that it doesn't scale very well, even though the product vendor believes that it should and we have evidence to prove this in different sites. We have already spent a lot of effort tuning the server and we not believe that it is well tuned. The server spends 90% of it's time idle. We have found that the client also spends about 90% of its time sleeping even though it has work to do, and there are plenty of free resources (only 25% of 24 CPUs are utilised, 40% of free memory, and IO is healthy). When we dig deeper into what the client is doing using pstack, we find that that it spend most of its time fetching from various cursor and specifically in the read function. An example stack trace is below: When we dig deeper into what the client is doing using pstack, we find that that it spend most of its time fetching from various cursor and specifically in the read function. An example stack trace is below: Please ignore previous message. We are running 8.1.7.4 64-bit Oracle on Solaris 8/sparc3. We have a client which was compiled on a 32-bit sparcII platform. We find that when we run multiple instances of the client we find that it doesn't scale very well, even though the product vendor believes that it should and we have evidence to prove this...

SqlSpec
Do you wish you had comprehensive, easily navigable documentation for your SQL Server, Oracle, Analysis Server, MySQL, and Access databases? Are you a SQL Developer or DBA that just inherited a huge, complex database with no supporting docs and don't know where to start learning how it's put together? Are you an independent contractor working with SQL Server, Oracle, Analysis Server, MySQL, or Access? Your clients would LOVE you if you could provide comprehensive documentation about the databases you build. Are you a Project Manager who is tired of developers making changes to databases on live servers and not updating the corresponding spec? SqlSpec will make sense of it all and generate easy-to-read docs for you for any database on the following platforms: * SQL Server 2000/2005 * Oracle 9i (and above) * MySQL 5.0 (and above) * Analysis Server 2005 * Access 97/2000/XP/2003 SqlSpec generates documentation in two formats: HTML or CHM. HTML is useful for publishing your documents on the web or an intranet site. CHM is useful if you want a single, compact file containing all your documentation about one or more databases. The CHM is indexed so it is easily searchable for any keyword. This way you can easily determine which objects reference the "EmployeeID" column, for example. You can download a fully featured trial version here: http://www.elsasoft.org ...

Web resources about - Clone a 10gR2 database running on 64 bit server to 32 bit server - comp.databases.oracle.server

Database - Wikipedia, the free encyclopedia
A database is an organized collection of data . The data are typically organized to model aspects of reality in a way that supports processes ...

Database - Wikipedia, the free encyclopedia
... requiring information. For example, modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. Database ...

Fearing no punishment, Denver cops abuse crime databases for personal gain
(credit: Noel Hidalgo ) Denver police officers performed searches on state and federal criminal justice databases that were not work-related ...

Open source database improves protection and performance
Most enterprises rely on databases in some form or another, but they can be vulnerable to attack from people looking to steal information. They ...

Seattle’s Tableau Software snaps up database-computing startup in Germany
Seattle’s Tableau Software has acquired HyPer, a database-computing startup that spun out of research at a university in Munich, Germany. As ...

NTTC's Liquid Products Database making steady progress
NTTC's Liquid Products Database making steady progress Modern Bulk Transporter NTTC is asking carriers to suggest “proprietary blends” for ...

Amazon Web Services Announces that over 1,000 Databases Have Migrated to AWS since January 1, 2016
Amazon Web Services, Inc. (AWS), today announced that the AWS Database Migration Service is now generally available.

Taiwan launches database on areas vulnerable to quake damage
BEIJING (AP) — Earthquake-prone Taiwan is launching a database to inform residents which areas might be susceptible to creating potentially catastrophic ...

Interior Dept Spent $15 Million On A Crime Database That Doesn’t Work
Interior Dept Spent $15 Million On A Crime Database That Doesn’t Work

Microsoft's SQL database software now runs on Linux
Remember when Steve Ballmer likened Linux to cancer, and the notion of Microsoft courting the open source crowd was virtually unimaginable? The ...

Resources last updated: 3/19/2016 10:02:34 PM