John,
By "the DB is the same name" do you mean the ORACLE SID or the database
server hostname?
With Oracle, the Db-name: ar.cfg parameter is used for the tablespace
name if it is not ARSYSTEM.
One thing that worries me about this config is that if the SID's are the
same, the only place they are differentiated is in tnsnames.ora - the
danger of unintended cross communication seems great.
What version of ARS have and are you upgrading from (this last time, and
tracing back?) Check the contents of SERVER_CACHE and see if there are
references to old servers there.
Also, did you copy the file containing the ARS licenses to the dev ARS
server? - try renaming it if you did.
One Oracle instance can have one or many tablespaces. Each tablespace
can contain the objects for one or more accounts/schemas and keep them
separate (even with the same table names).
-Brian Luke
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of John Kelley
Sent: Friday, September 01, 2006 8: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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
