John:
You can create as many tablespaces in one Oracle DB as you need. I would not, if possible, install the production and development tablespaces into the same Oracle DB instance.
I have two different versions of ARS installed on the same Oracle DB instance, however.
James Mckenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley
Sent: Friday, September 01, 2006 10:53 AM
To: arslist@ARSLIST.ORG
Subject: Re: Setup Dev Server
I can SQL plus on the Dev box to the DB.
I log in as ARAdmin default password. Here is another catch. If I leave the tables space name the default (ARSYSTEM) it then goes to the Next Screen to Upgrade. I also tried to change the table space name to TABS and suprisingly it allows me to the next screen also. Shouldn't the DB only have one Tablespace name?
Oh -- the Production server has the same version or Oracle.
John
Julie Rockwood
<[EMAIL PROTECTED]
V> To
Sent by: "Action arslist@ARSLIST.ORG
Request System cc
discussion
list(ARSList)" Subject
<[EMAIL PROTECTED] Re: Setup Dev Server
ORG>
09/01/2006 01:38
PM
Please respond to
[EMAIL PROTECTED]
RG
John,
Did you also see: DLL function call crashed:UPORACL.UpgradeDatabaseOR ?
I had exactly that problem when I upgraded from ARS 5.1.2 on a Windows 2000 box to ARS 6.3 on Windows 2003 box. The Oracle 9.2.0.4.0 64 bit was on an AIX box. Remedy Support was pretty sure
that it had something to do with the Oracle client. Recently I
noticed a note on the compatibility matrix that may provide a clue:
"Requires 32-bit Oracle 9iR2 database client for connecting to the Oracle database". I'm not sure what I have.
I ended up upgrading the database from the old Win 2000 box, then connecting to the upgraded database from the 2003 box. I then tested everything and have now been in production with it since May with no problems.
I do not know if I'll have a problem when it comes time to upgrade again, so I would love to hear if you find out what causes it.
Julie
At 09:30 AM 9/1/2006, you wrote:
>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
-------------------------------------------------------
Julie Rockwood
Los Alamos National Laboratory
IST-AUBAD Remedy Technical Lead
(505) 667-9846
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
