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
