f



Copy Database From Ora 10.1.0.5 to 10.2.0.2

Hi,

We have a database named, say, DB1 running on a Win2003 server with
Ora 10.1.0.5.
We need to copy DB1 to another server running on Win2003 with Ora
10.2.0.2.
(Neither are production databases).

I know how to copy the database, recreate the control file, etc..

My question is what subsequent steps I need to take after the database
has been copied,
the control file created, and the database opened, given that I am
copying a database from
an Ora 10.1.0.5 server to an Ora 10.2.0.2 one.



Thanks,
DF
0
6/6/2008 9:53:07 PM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

3 Replies
958 Views

Similar Articles

[PageSpeed] 23

copy all db file... datafile, controlfile, redo and upgrade.... (read 
the manual...) I don't athink you need to recreate controlfile
if_investor@yahoo.com ha scritto:
> Hi,
> 
> We have a database named, say, DB1 running on a Win2003 server with
> Ora 10.1.0.5.
> We need to copy DB1 to another server running on Win2003 with Ora
> 10.2.0.2.
> (Neither are production databases).
> 
> I know how to copy the database, recreate the control file, etc..
> 
> My question is what subsequent steps I need to take after the database
> has been copied,
> the control file created, and the database opened, given that I am
> copying a database from
> an Ora 10.1.0.5 server to an Ora 10.2.0.2 one.
> 
> 
> 
> Thanks,
> DF
0
pierbrun (2)
6/6/2008 10:07:42 PM
"if_investor@yahoo.com" <basis_consultant@hotmail.com> wrote in 
news:97ca144b-9c19-4cf5-9c07-d5089b0a4954@d1g2000hsg.googlegroups.com:

> Hi,
> 
> We have a database named, say, DB1 running on a Win2003 server with
> Ora 10.1.0.5.
> We need to copy DB1 to another server running on Win2003 with Ora
> 10.2.0.2.
> (Neither are production databases).
> 
> I know how to copy the database, recreate the control file, etc..
> 
> My question is what subsequent steps I need to take after the database
> has been copied,
> the control file created, and the database opened, given that I am
> copying a database from
> an Ora 10.1.0.5 server to an Ora 10.2.0.2 one.
> 
> 
> 
> Thanks,
> DF

Follow the same steps that are required to be taken to actually upgrade 
a V10.1.0.5 DB to V10.2.0.2 software. 
0
anacedent (475)
6/7/2008 1:08:06 AM
if_investor@yahoo.com wrote:
> Hi,
> 
> We have a database named, say, DB1 running on a Win2003 server with
> Ora 10.1.0.5.
> We need to copy DB1 to another server running on Win2003 with Ora
> 10.2.0.2.
> (Neither are production databases).
> 
> I know how to copy the database, recreate the control file, etc..
> 
> My question is what subsequent steps I need to take after the database
> has been copied,
> the control file created, and the database opened, given that I am
> copying a database from
> an Ora 10.1.0.5 server to an Ora 10.2.0.2 one.
> 
> 
> 
> Thanks,
> DF


I would have to ask why are you upgrading to something that old? 
10.2.0.4 is now available and contains all of the latest security 
patches. - There were several critical patches for 10.2.0.2 and 10.2.0.3 
where the problems were "remotely exploitable withOUT authentication".

0
maustin (1437)
6/8/2008 2:17:15 AM
Reply:

Similar Artilces:

Problems installing 10.2.0.2 patchset to a 10.2.0.1 database
I am trying to install the latest patchset to my 10gR2 database. When i double click on setup.exe nothing visable happens. The process is launched and according to Windows Task manager is taking up 50% of my CPU. The process just sits there spinning away and nothing happens. I have shutdown, using Service Control Manager, all Oracle services including databases, listeners and DBConsoles Any ideas? <kevin.aide@intergraph.com> schreef in bericht news:1159977988.501508.164590@b28g2000cwb.googlegroups.com... >I am trying to install the latest patchset to my 10gR2 database. When > i double click on setup.exe nothing visable happens. The process is > launched and according to Windows Task manager is taking up 50% of my > CPU. The process just sits there spinning away and nothing happens. > > I have shutdown, using Service Control Manager, all Oracle services > including databases, listeners and DBConsoles > > Any ideas? > Sometimes it helps when you do not use the setup.exe in the root of your installation, but the one in the install directory. Reboot before patching might help too. Has to do with conflicting javaw.exe versions or something like that. You're not on VMWare, are you? Robbert van der Hoorn OSA it BV The Netherlands Robbert, I only have one setup.exe and there is no install directory. At the top level I have a stage directory and three html files and the setup.exe. I am not using VMWare and I have tried reb...

Copy Oracle 10.2.0.4 Database from Sun Sparc 5.9 to Sun Sparc 5.10?
Hi, We would like to copy a cold backup of an Oracle 10.2.0.4 database running on Sun Sparc 5.9 to a Sun Sparc 5.10 server. We intend to use a standard copy procedure (Copy datafiles, use "Create controlfile..." etc..). Will this work? Any links to Oracle documentation on this will be appreciated. Thanks, QZ ...

Upgrading oracle db 10.1.0.5 to 10.2.0.2 java issues
Hi all, We are upgrading our oracle database from 10.1.0.5 to 10.2.0.2. has anyone had previous experience with this that they can point out potential pitfalls? I am talking more on the java side than actually the installation. We have a java system talking to the oracle database. One system is using hibernate, the other is using a DAO pattern with direct JDBC calls. Does anyone know if this change will effect the application and what changes we must do to accomadate? For example I know that oracle 10.2.0.2 has a different timestamp (oracle.timestamp) than that of it predecesor (sql.timestam...

after upgrade 10.2.0.1 to 10.2.0.2
I had 10.2.0.1 RAC installation in Redhat EL4. Everything run fine. I did upgrade from 10.2.0.1 to 10.2.0.2 today. I did clusterware first and RAC second. Both are successful. After that, I run catupgrd.sql in my database. Afterward, my database won't start. If I used srvctl start database -d name, then I got CRS-0215: Could not start resource 'ora.....inst' error. If I use sqlplus, I can do startup mount, but not open. Please help! Happy On Mar 22, 1:32 pm, "Happy" <Haibin.T...@gmail.com> wrote: > I had 10.2.0.1 RAC installation in Redhat EL4. Everything run fine. I > did upgrade from 10.2.0.1 to 10.2.0.2 today. I did clusterware first > and RAC second. Both are successful. After that, I run catupgrd.sql in > my database. Afterward, my database won't start. If I used srvctl > start database -d name, then I got CRS-0215: Could not start resource > 'ora.....inst' error. If I use sqlplus, I can do startup mount, but > not open. Please help! > > Happy You should not have tried to 'upgrade' from 10.2.0.1 to 10.2.0.2 as an upgrade changes the *base* release and you did nothing of the sort. You should have run catpatch.sql, as that is all you accomplished, *patching* your 10.2 database to the latest patch level. I hope you have a backup as you'll need it. David Fitzjarrell On Mar 22, 2:38 pm, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote: > On Mar 22, 1:32 pm, "Happy...

OEM Upgrade from 10.2.0.1 to 10.2.0.5
Hi all, I am doing a fresh install of Oracle Enterprise manager on Linux 32 bit using OLE5.3 using How to Install Grid Control 10.2.0.5.0 on Enterprise Linux 5 Using the Existing Database (11g) Option Doc ID: 784963.1 As per the Metalink note I am doing software only install of 10.2.0.1 and then 10.2.0.5 with no config. Then I manually run the follwoing ConfigureGC.pl script: where I get this error ..../oms10g/perl/bin/perl .../oms10g/sysman/install/ConfigureGC.pl /u01/app/gc Any ideas/suggestions to solve this ? This is not related to sys/ sysman password I think Oc4jDeploy tool completed, but with errors. ' INFO: oracle.sysman.top.oms:PerformSecureCommand:runCmd:Command Output stderr: 'java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at oracle.j2ee.tools.deploy.Oc4jDeploy.doDeploy(Unknown Source) at oracle.j2ee.tools.deploy.Oc4jDeploy.execute(Unknown Source) at oracle.j2ee.tools.deploy.Oc4jDeploy.deploy(Unknown Source) at oracle.j2ee.tools.deploy.Oc4jDeploy.main(Unknown Source) Caused by: java.lang.NoClassDefFoundError at com.evermind.server.rmi.RMIConnection.EXCEPTION_ORIGINATES_FROM_TH...

Oracle server 9.2.0.1.0, Client 9.2.0.4.0, Red Hat Linux enterprise advanced server 2.1
Hi Everybody, My Database server is running on Red Hat Linux enterprise advanced server 2.1, And my Oracle version is 9.2.0.1.0. My Client mechine also Red Hat Linux enterprise advanced server 2.1 , Oracle client version is 9.2.0.4.0. I am running a web application. Our application is in Magic edeveloper. I connect to Oracle using oracle gateway to my application. My Problem is my application is is becoming slow. I am not able to trace where the problem is. Before our application was running fine. recently i upgraded Oracle client version to 9.2.0.4.0. My Oracle client & server versions are different. I am getting error on my client mechine, it showing all memory address on the screen and the part of error is, arg register addr=83498cc .... Dump of memory from 0x83988c to 0x83499cc .... -- End of Call stack trace -- I am not able to trace where the problem is.Any insight please... Thanks, Ssreddy. ...

Firefox 2.0.0.2, 1.5.0.10 contrib. builds on Solaris10, Solaris8/9 are available #2
Please do NOT reply to this address. If you have any problems, feel free to send email to desktop dash discuss at opensolaris dot org Firefox 2.0.0.2, 1.5.0.10 contrib. builds on Solaris10, Solaris8/9 are now available on www.mozilla.com It's now much easier to get the latest contributed build on Solaris, just go to http://www.mozilla.com and click "Free Download" which would point you to the download page. Download Page ============== Firefox 2.0.0.2 http://www.mozilla.com (Click "Free Download") http://www.mozilla.com/en-US/firefox/2.0.0.2/releasenotes/#contribute...

Copying Oracle 10.2.0.4 Database to 11.2
Hi, We have an SAP system (ECC6.0) running on Oracle 10.2.0.4 on Solaris 5.9 in, say, servera. We are looking to copy it, and rename its Oracle SID, to a Solaris 5.10 server (serverb) running Oracle 11.2. The tentative plan is as follows: (i) Install SAP/Oracle 11.2 on serverb. (ii) Copy a cold backup of the servera database from tapes to serverb. (iii) Rename the database to the new SID using "Create controlfile set database....". (iv) Run the SAP tool that upgrades Oracle to 11.2 so that the database is upgraded (Skip the part that install the Oracle binaries). SAP documentation indicates that this step works. My question is on step #(iii). On 11.2, will the "Create controlfile" command work if the database is 10g? Thanks, QZ In article <2e5d62d9-0155-4ab2-9c55-dff6c8ecc0f2@k3g2000vbz.googlegroups.com>, if_investor@yahoo.com <basis_consultant@hotmail.com> wrote: >We have an SAP system (ECC6.0) running on Oracle 10.2.0.4 on Solaris >5.9 in, say, servera. > >We are looking to copy it, and rename its Oracle SID, to a Solaris >5.10 server (serverb) >running Oracle 11.2. Why rename the SID? >The tentative plan is as follows: > >(i) Install SAP/Oracle 11.2 on serverb. >(ii) Copy a cold backup of the servera database from tapes to serverb. >(iii) Rename the database to the new SID using "Create controlfile set >database....". >(iv) Run the SAP tool that upgrades Oracle to 11.2 so that th...

New Option Packs after Update from 10.2.0.1 to 10.2.0.2 ???
Hello, i have a little understanding problem how Oracle handles his Patch Sets. First i have installed a Oracle 10.1.0.1 Enterprise Edition Database on my Solaris 9 Sparc Server. Explicitly i have selected only one Option Pack: The Partitioning Option. Then i istalled the actually Patch Set 10.2.0.2. At next i begin create a database. After creation the new database works fine. But when i get a Database-Report in the Enterprise Manager, it says i have installed the following options: * Data Mining * Intermedia * OLAP * Spatial * Text * XML DB The Install overview in the Oracle Installer says, basicly i have installed only the partitioning option. In the Patchset-Installation i can't see what exactly is patched. But from my understanding - Patch sets should only patch installed Programs/Features - not Features where are not installed. Did anyone see the same effects while patching Oracle? What can i do to solve that little problem? Many thanks for helping and solly my bad english. Karl Karl Bach wrote: > Hello, > > i have a little understanding problem how Oracle handles his Patch Sets. > > First i have installed a Oracle 10.1.0.1 Enterprise Edition Database on my > Solaris 9 Sparc Server. Explicitly i have selected only one Option Pack: > The Partitioning Option. > > Then i istalled the actually Patch Set 10.2.0.2. > > At next i begin create a database. After creation the new database works > fine. > But when i get a D...

"Ora-01000 maximum open cursors exceeded" after update from 10.2.0.1 to 10.2.0.3
Hi all! After updating our Database from 10.2.0.1 to 10.2.0.3 I get the error Ora-01000 in our application (we use the proC precompiler). When I look at the v$open_cursor, I see the number of cursors increasing all the time. In our application we have a lot of select statements and every statement is a cursor. But the cursor is always closed after the statement. And we also have a lot of transactions. And after a rollback the cursors should be closed automatic (am I right?). It seams that neither a "EXEC SQL CLOSE ..." nor a "rollback" close the cursors any more! The parameter session_cached_cursors is 20, the parameter open_cursors is set to 300. With 10.2.0.1 we have no problems. Has anyone an idea whats running wrong? Is there a new parameter? Thanks in advance On Jun 4, 10:25 am, poschma <marti...@utanet.at> wrote: > Hi all! > > After updating our Database from 10.2.0.1 to 10.2.0.3 I get the error > Ora-01000 in our application (we use the proC precompiler). > > When I look at the v$open_cursor, I see the number of cursors > increasing all the time. > In our application we have a lot of select statements and every > statement is a cursor. But the cursor is always closed after the > statement. And we also have a lot of transactions. And after a > rollback the cursors should be closed automatic (am I right?). > > It seams that neither a "EXEC SQL CLOSE ..." nor a "rollback" close &g...

Connection from Oracle Developer Suite 10g 9.0.4.0.1 to Oracle DB 10g Release 10.1.0.2.0
Hi, I have installed Oracle DB 10g Release 10.1.0.2.0 on Windows XP. START->ALL PROGS->oracle-OraDb10g_home3 Location of TNSNAMES FILE: C:\oracle\product\10.1.0\db_3\NETWORK\ADMIN\TNSNAMES.ORA with two alias: 1)ORCL3 2) EXTPROC_CONNECTION_DATA I can logon to database via SQL*PLUS and I can log on to EM on the web as well using ORCL3. After that I installed Oracle Developer Suite 10g 9.0.4.0.1 to my the same computer. During installation it was not allowing me to install this suite to the same ORACLE home. I installed this in the following home: START->ALL PROGS->...

upgrade from oracle 9.2.0.1.0 to 9.2.0.5.0
Hi, I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for window version 32 bits, does anyone can provide the node document information of step by step doing it. many thanks leehi leehi wrote: > I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for > window version 32 bits, Windows NT4? W2k? W2K3? W2K3 - Release 2? Why stop ot 9.2.0.5? > does anyone can provide the node document information of step by step > doing it. leehi wrote: > Hi, > > I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for > window version 32 bits, > > does anyone can provide the node document information of step by step > doing it. > > many thanks > > leehi Go to metalink.oracle.com (registration and Oracle support CSI required). Click on Patches and Updates tab. Wait for the whole screen to load. Use one of the search functions to find your patch (note the Quick Links if you are getting something common, like 9206 or 9207). When you finally get to your patch download, click on the readme (the piece-of-paper icon next to the download icon). Read all the instructions. It's a good idea to read the instructions every time you do it, even (or perhaps especially) when you are comfortable doing it. The readme is usually also included with the patch. Download and unzip the patch. Look at what is there in the patch, perhaps there are additional release notes. Look around on metalink for addition...

SW: Firefox 10.0.12ESR, SeaMonkey 2.7.2 10.0.12ESR, Thunderbird 10.0.12ESR
++ From the VOICE OS/2-eCS News Service http://www.os2voice.org ++ From: madodelDESPAM@DESPAMptdprolog.net Firefox 10.0.12esr, SeaMonkey 2.7.2 based on 10.0.12ESR and Thunderbird 10.0.12ESR have been uploaded to Netlabs by Dave Yeo. Firefox is the Web Browser based on the open source Mozilla project. SeaMonkey is the Web Browser/Mail reader/News reader based on the open source Mozilla project. ESR stands for Extended Support. Thunderbird is the Mail reader/News reader based on the open source Mozilla project. If anyone is interested in continuing to see development of the Mozi...

Connecting to 8.1.7 Database from Developer Suite 10.1.2.0.2, also have 10g Client R2 installed.
Hi, Can anyone help, I install the 10g Client R2 ( 10.2.0.1.0 ), this lets me logon to our 8.1.7.0.0 Oracle Database server without any issues, from TOAD, SQLWorksheet SQLPLUS etc, I then downloaded and in stall the ORACLE Developer Suite 10.1.2.0.2, but can't get any of the development software forms/reports etc to connect to the 8.1.7.0.0 database, all the other stuff above still works as it uses the 10.2 Client path. Is there anyway to make the Developer Suite use the 10.2 client path for it's connectivity/middleware stuff, or do I need to do something else to the developer suite ?? Regards, Sean. <seancwatson@googlemail.com> schreef in bericht news:1159966104.761991.287140@k70g2000cwa.googlegroups.com... > Hi, > > Can anyone help, > > I install the 10g Client R2 ( 10.2.0.1.0 ), this lets me logon to > our 8.1.7.0.0 Oracle Database server without any issues, from TOAD, > SQLWorksheet SQLPLUS etc, > > I then downloaded and in stall the ORACLE Developer Suite 10.1.2.0.2, > but can't get any of the development software forms/reports etc to > connect to the 8.1.7.0.0 > database, all the other stuff above still works as it uses the 10.2 > Client path. > > Is there anyway to make the Developer Suite use the 10.2 client path > for it's connectivity/middleware stuff, or do I need to do something > else to the developer suite ?? > > Regards, > Sean. > Exactly what part of Dev. Sui...

int((9.2-9.0)*10) is 1, int((9.21-9.0)*10) is 2, why?
Python 2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit (Intel)] on win32 The following line of code describes an funny question・3校 >>> int((9.2-9.0)*10) 1 >>> int((9.21-9.0)*10) 2 >>> int((9.1-9.0)*10) 0 >>> int((9.11-9.0)*10) 1 >>> int((8.2-8.0)*10) 1 >>> int((8.23-8.0)*10) 2 why? anybody can explain it? On Sep 5, 11:12 pm, bcm <bluecrysta...@gmail.com> wrote: > Python 2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit > (Intel)] on win32 > The following line of code describes an funny que...

Rolling upgrade from oracle RAC 10.2.0.4 to 11.2.0.1
Has anyone done a rolling upgrade of oracle RAC 10.2.0.4 to 11.2.0.1. Recently I was trying to upgrade a 2 node RAC using logical standby database and evertime it is failing at upgrade of cluster. Hven't found any useful doc in metalink or internet. Will be very helpful if someone who has done this can provide a direction to me. Thanks ...

TNS-12537 after starting listener after upgrade from 10.2.0.2. 10.2.0.4
Hello, I have upgraded 7 Unix Solaris 5.10 Boxes from 10.2.0.2 to 10.2.0.4 and applied recommend patches. All upgrades worked with the exception of one server. One server won't start the listener. I get the following: 35% lsnrctl start LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 11-AUG-2008 10:17:31 Copyright (c) 1991, 2007, Oracle. All rights reserved. Starting /oracle/BWD/102_64/bin/tnslsnr: please wait... TNS-12537: TNS:connection closed TNS-12560: TNS:protocol adapter error TNS-00507: Connection closed Solaris Error: 29: Illegal seek I have searched google.com and the only thing I can find is related to Oracle 8 and Windows: add 127.0.0.1 localhost.(domain) localhost to /etc/hosts. I did this with no luck. I have two instances of Oracle on this one machine. One listener works, the other doesn't. I have done the following : cd $ORACLE_HOME/bin ../relink all then: cd $ORACLE_HOME/network/lib make -f ins_network.mk install make: Fatal error: Can't find `ins_network.mk': No such file or directory The port used by the listener is 1521 and netstat -an |grep 1521 reports port not in use. I've changed listener.ora with tracing and nothing seems obvious. trace_level_listener = 16 trace_file_listener = listener trace_timestamp_listener = on trace_filelen_listener = 100 trace_fileno_listener = 2 log_file_listener=listener -- Steve Comments embedded. On Aug 11, 9:34=A0am, sfa...@gmail.com wrote: > Hello, I have upgraded 7 ...

[ANN] Unicorn 2.0.0, 1.1.5, 1.0.2 released!
Unicorn is an HTTP server for Rack applications designed to only serve fast clients on low-latency, high-bandwidth connections and take advantage of features in Unix/Unix-like kernels. Slow clients should only be served by placing a reverse proxy capable of fully buffering both the the request and response in between Unicorn and slow clients. * http://unicorn.bogomips.org/ * mongrel-unicorn@rubyforge.org * git://git.bogomips.org/unicorn.git tldr change summaries: 2.0.0 - cleanups for Rainbows!, but should be ready for general use barring portability issues 1.1.5 - bug f...

ERROR OUI-10091:Updation from oracle10gR2(10.2.0.1)xe to oracle10gR2(10.2.0.3) in linux 4
Hello everone, I am using patch p53370104_10203_Linux.zip to update my oracle 10gR2(10.2.01) Express Edition into Oracle 10gR2(10.2.0.3). In installation i got the following error: OUI-10091:There are no patches that need to be applied from the patchset Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0 . And its log file i find : INFO: Unable to read /usr/lib/oracle/xe/app/oracle/product/10.2.0/ server/inventory/ContentsXML/comps.xml. Some inventory information may be lost. INFO: OUI-10070:The patch oracle.ons 10.2.0.3.0, which is part of patch set Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0 , has not been selected for installation. please help me .. Thanks in Advance! On Aug 6, 8:43=A0am, sagar.maheshw...@daffodilsw.com wrote: > Hello everone, > I am using patch p53370104_10203_Linux.zip to update my oracle > 10gR2(10.2.01) Express Edition into Oracle 10gR2(10.2.0.3). > In installation =A0i got the following error: > OUI-10091:There are no patches that need to be applied from the > patchset Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0 . > > =A0And its log file i find : > > INFO: Unable to read /usr/lib/oracle/xe/app/oracle/product/10.2.0/ > server/inventory/ContentsXML/comps.xml. Some inventory information may > be lost. > INFO: OUI-10070:The patch oracle.ons 10.2.0.3.0, which is part of > patch set Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0 , has > not been selected for installation. > =A0pl...

Pythonutils 0.2.2 , ConfigObj 4.0.0 Beta 5, odict 0.1.1
The response to pythonutils__ was very good. Especially the odict__ module (ordered dictionary) - it's had over one hundred and fifty downloads already. Thanks to some useful user feedback, Nicola Larosa has updated and improved it. More embarassingly we've done a bugfix release of ConfigObj__ - now up to beta 5. This fixes another couple of bugs - we aim to get out of beta someday...... All this is my way of saying that *odict 0.1.2*, *pythonutils 0.2.2*, and *ConfigObj beta 5*, are all available from the `Voidspace Modules`__ page. __ http://www.voidspace.org.uk/python/pythonutils...

LaTex equation numbering like 2.1, 2.2, also 2.0.1, 2.0,2, 2.1.1, etc
David Roach wrote: > Is there a simple command to have latex number > the equations by the section numbers automatically. > > David From the LaTeX Companion (what a wonderful book!) %%%%%%%%%%%%%%%%%%%%%% % number equations within sections % In preamble \makeatletter \@addtoreset{equation}{section} \makeatother \renewcommand{\theequation}{\thesection.\arabic{equation}} %%%%%%%%%%%%%%%%%%%%%% Numbers within sections...I use this all the time in articles. Even works with ******************* ******************* Brilliant. And then I got numbering within subsections by repeating and editing (not replacing), so I now have:- (Just after the documentClass command) \makeatletter \@addtoreset{equation}{section} \makeatother \renewcommand{\theequation}{\thesection.\arabic{equation}} \makeatletter \@addtoreset{equation}{subsection} \makeatother \renewcommand{\theequation}{\thesubsection.\arabic{equation}} Bob Bob Marlow schrieb: > David Roach wrote: > >> Is there a simple command to have latex number >> the equations by the section numbers automatically. >> >> David > > From the LaTeX Companion (what a wonderful book!) > > %%%%%%%%%%%%%%%%%%%%%% > > % number equations within sections > % In preamble > > \makeatletter > \@addtoreset{equation}{section} > \makeatother > \renewcommand{\theequation}{\thesection.\arabic{equation}} > > %%%%%%%%%%%%%%%%%%%%%% [more code] > Hi! I th...

Upgrading to 10.2.0.4 from 10.2.0.3
My Oracle Database Server is running 10.2.0.3.0. I would like to upgrade to 10.2.0.4.x When I check metalink the patch sets for 10.2.0.4 says it must be applied to a database already running 10.2.0.4. Am I reading this correctly? Which patch set do I use? On Nov 6, 3:41=A0pm, jhavero <jhav...@gmail.com> wrote: > My Oracle Database Server is running =A010.2.0.3.0. I would like to > upgrade to 10.2.0.4.x When I check metalink the patch sets for > 10.2.0.4 says it must be applied to a database already running > 10.2.0.4. Am I reading this correctly? Which patch set do I use? What are you looking at, exactly? The patch set depends. For me it's 6810189 Personally, I found issues with TZ (as the fix extends beyond Oracle) and dbconsole components. YMMV. jg -- @home.com is bogus. From the people who make spam palatable: http://googleblog.blogspot.com/2009/11/transparency-choice-and-control-now.= html On Nov 6, 6:41=A0pm, jhavero <jhav...@gmail.com> wrote: > My Oracle Database Server is running =A010.2.0.3.0. I would like to > upgrade to 10.2.0.4.x When I check metalink the patchsets for > 10.2.0.4 says it must be applied to a database already running > 10.2.0.4. Am I reading this correctly? Which patchset do I use? One that is almost 1 Gigabyte. Seriously. Its like 986 MB. Apply the 10.2.0.4 patchset using OUI (p6810189 for MS Win 32). After that has been completed, apply the one off patch using opatch. I'm guessing that you'...

Best Way to Access remote Oracle 10.2.0.1.0 DB from a Linux server
I want to use a perl or unix script running on a linux server to access an Oracle v. 10.2.0.1.0 database on a remote machine, and process the output with the script. What is the best way to do this? I'm thinking some possible options are: install Oracle 11 cllient (assume it is backwards compatible), install the entire Oracle database v.11, or install Oracle express. Appreciate your comments. Johan Johan <johango99@yahoo.com> wrote in news:db01b8d1-577b-4310-89af- 97465a3623c3@w28g2000hsf.googlegroups.com: > I want to use a perl or unix script running on a linux server to > access an Oracle v. 10.2.0.1.0 database on a remote machine, and > process the output with the script. What is the best way to do this? > I'm thinking some possible options are: install Oracle 11 cllient > (assume it is backwards compatible), install the entire Oracle > database v.11, or install Oracle express. Appreciate your comments. > > Johan > I vote for Oracle client & PERL On Nov 17, 3:13 pm, "Ana C. Dent" <anaced...@hotmail.com> wrote: > Johan <johang...@yahoo.com> wrote in news:db01b8d1-577b-4310-89af- > 97465a362...@w28g2000hsf.googlegroups.com: > > > I want to use a perl or unix script running on a linux server to > > access an Oracle v. 10.2.0.1.0 database on a remote machine, and > > process the output with the script. What is the best way to do this? > > I'm thinking some possib...

Oracle 10.1.0.3 -> 10.1.0.5 patching problem
HELO, I've got Oracle 10.1.0.3 on SuSE 9 (2.6.5-7.252-smp x86_64) and problem with patching to 10.1.0.5 (and 10.1.0.4 too). System packages: --- # rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' gcc gcc-c++ glibc libaio libaio-devel make openmotif openmotif-libs gcc-3.3.3-43.41 (x86_64) gcc-c++-3.3.3-43.41 (x86_64) glibc-2.3.3-98.61 (x86_64) libaio-0.3.102-1.2 (x86_64) libaio-devel-0.3.102-1.2 (x86_64) make-3.80-184.1 (x86_64) openmotif-2.2.2-519.4 (x86_64) openmotif-libs-2.2.2-519.4 (x86_64) --- Linking 'Pro*C/C++ Patch 10.1.0.5' operation: Error in invoking target 'relink' of makefile '/home/oracle/ora10g/precomp/lib/ins_precomp.mk' installActions.log: --- [...] Start output from spawned process: ---------------------------------- Linking /home/oracle/ora10g/precomp/lib/proc /usr/lib64/gcc-lib/x86_64-suse-linux/3.3.3/../../../../x86_64-suse-linux/bin/ld: cannot find -lclntsh collect2: ld returned 1 exit status /bin/chmod: cannot access `/home/oracle/ora10g/precomp/lib/proc': No such file or directory make: *** [/home/oracle/ora10g/precomp/lib/proc] Error 1 End output from spawned process. ---------------------------------- Exception thrown from action: make Exception Name: MakefileException Exception String: Error in invoking target 'relink' of makefile '/home/oracle/ora10g/precomp/lib/ins_precomp.mk'. See '/home/oracle/oraInventory/logs/installActions2006-04-25_02-34-17AM.log' for details. ...

Web resources about - Copy Database From Ora 10.1.0.5 to 10.2.0.2 - 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 ...

Seattles Tableau Software snaps up database-computing startup in Germany
Seattles 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 Doesnt Work
Interior Dept Spent $15 Million On A Crime Database That Doesnt 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:19:46 PM