Hi James , Axton and everyone that responded. Thanks to all for the information. Here is what I ended up doing. During the setup of my DEV box. I selected the overwrite option Which would overwrite the DB. I Actually had a copy of the Original DB which later would replace the DB original install. Then reapply the license.
FYI. The Dev DB is on B unix server with the same Table space name and same DB name as Production A server. As long as the TNSnames.ora file specifies the Instance correctly it will go to the proper spot. For eveyone, "Please make sure tnsname is correct" Thanks John Kelley * Axton: Definitely the way to copy a tablespace from one server to another. I had forgotten about copying the LOB space, too. I tend to use Export/Import from Remedy rather than do this at the DB level. However, this does not scale well if you are working with Direct SQL and reference tables by name. James McKenzie L-3 GSI -----Original Message----- From: Action Request System discussion list(ARSList) [ mailto:[EMAIL PROTECTED] On Behalf Of Axton Grams Sent: Friday, September 01, 2006 12:53 PM To: arslist@ARSLIST.ORG Subject: Re: Setup Dev Server I duplicate databases infrequently. The metadata (actlink_open, email mailbox, etc.) are fairly easy to clean with pl/sql. Copying between different tablespaces is a little tricky due to LOB storage, but not impossible. You have to manually create the tables with modified DDL (specifying lob storage) that have LOBs prior to running the imp of the dmp file to ensure the LOBS go to the right tablespace during import. http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:378418239571#16075038165527 The main reason we do it this way is because this method puts the margin for error/reliability and the time required to complete are in our favor. Axton Grams McKenzie, James J C-E LCMC HQISEC/L3 wrote: > ** > Fred: > > (Wacking self on head). Thanks. > > Now the next question is how did they duplicate the database? There > are variables in the Remedy metadata that will error out if they did a > physical vice ARExport/ARImport move of data. This may be causing the > problem. I tried a physical move from one tablespace to another on > the same server and Oracle would not let me. > > James Mckenzie > L-3 GSI > > ---------------------------------------------------------------------- > -- > *From:* Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] *On Behalf Of *Grooms, Frederick W > *Sent:* Friday, September 01, 2006 12:12 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Setup Dev Server > > ** > He said they were on 2 different servers > > ---------------------------------------------------------------------- > -- > *From:* Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] *On Behalf Of *McKenzie, James J C-E LCMC > HQISEC/L3 > *Sent:* Friday, September 01, 2006 1:41 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Setup Dev Server > > ** > > Fred: > > I think the problem may be that the production and dev servers are > pointing to the same Oracle DB Instance and that they are installed in > two different tablespaces. This can lead to disaster of major proportions. > > Solution: > > Have DBA create a second instance on the Oracle DB for development. > Or install Oracle on a second server (this is LEGAL per Oracle.) > > James McKenzie > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W > Sent: Friday, September 01, 2006 11:17 AM > To: arslist@ARSLIST.ORG > Subject: Re: Setup Dev Server > > Do you have the environment variables set up correctly? > > The 32 bit Oracle 9iR2 client in the path before your 64 bit Oracle > 9iR2 client. > ORACLE_HOME pointing to your 32 bit Oracle 9iR2 client. > ORACLE_SID and TWO_TASK set for your dev database. > TNS_ADMIN pointing to your tnsnames.ora file. > > Fred > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of John Kelley > Sent: Friday, September 01, 2006 10:31 AM > To: arslist@ARSLIST.ORG > Subject: Setup Dev Server > > Hi List: First time emailer. Long time reader. > > I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having > errors upgrading an existing DB. > We took a copy of production DB, and placed it on a different oracle > Server. Oracle 9.2.0.4.0 64bit. > My tnsnames is set correctly to Dev Server and connection to remedb > listener. > The name of the DB is the same for Production and Dev. Which is OK. > They are on different servers. > When I'm setting up the Dev server running server.exe, Its asks for > SID name and what type of install. Upgrade, Overwrite or Shared. I > select Upgrade because the DB out there is an exact copy of the > Production having all the Data - I want the data in tact just to install the Server. > > Here is the Error > 15:40:39 An error was encountered during the upgrade of the AR System > database. > 15:40:39 Installation terminating ... Original database server is > intact and accessible > 15:40:39 Resolve the problem that causes the error (contact Technical > Support, if necessary) 15:40:40 ****->[ShowMsg]: Setup is rolling back > directories.... > > 15:40:40 Setup is rolling back the directories. > 15:40:41 ServiceName not found. Using Default: Remedy Action Request > System Server > 15:40:41 ****->[ERROR]: AR System Database upgrade error. The original > database is intact and accessible. > > Anyboby have something similar. Or suggestion. > > John Kelley > Help Desk Analyst > 130 Royall Street > Canton, MA 02021 > Mail Center 1W > 781-737-3564 > > ______________________________________________________________________ > _________ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > __20060125_______________________This posting was submitted with HTML > in it___ __20060125_______________________This posting was submitted > with HTML in it___ __20060125_______________________This posting was > submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
