Axton:
What I seen was that the tablespace was the same name, which with two servers is not a problem. I've delt with one admin, here on the list, that had installed the production and development to the same server, same tablespace. Disaster was the result.
As far as running two or more servers against the same instance. No problem. However, you will need to size the PGA and SGA to accomidate the additional load.
I prefer what John has done. Two servers, two instances and never the two shall meet.
And if you are covered by SarbOx, you may have to do things this way.
James McKenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Grams
Sent: Friday, September 01, 2006 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Setup Dev Server
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:arslist@ARSLIST.ORG] *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:arslist@ARSLIST.ORG] 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:arslist@ARSLIST.ORG] 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___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
