What problem is there with using the same instance with different schemas? We have one server with 4 arsystem schemas in a single instance, not to mention that are dozens of other schemas in the instance not being used for Remedy.
Using the same tablespace will be a problem if you try and do a fresh install because the arserver installer is flawed in the sense that it drops whatever tablespace you install arserver to and recreates it. Creating another instance has a lot of overhead associated with it (two sets of processes, two sga's, etc.) If the db server has enough hardware to fulfill the software's requests you should not have a problem sharing an instance. Axton Grams Grooms, Frederick W wrote: > ** > 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:* [email protected] > *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: [email protected] > 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: [email protected] > 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
