I think you pointed out the reason why this is not working.... The db version (database version ) refers to the version of the AR System data dictionary. The dbversion is usually transparent to the end user or customer unless they experience an error such as, "ARERROR 36 The database is not the expected version". This is most frequently seen after an attempted upgrade or reinstallation. It is important to know this because you cannot downgrade AR Server once the data dictionary has been upgraded to the newer version. In some cases an upgrade attempt may have failed and you cannot reinstall the previous version of AR Server if the dbversion has changed. In order to do so, the reinstall would have to be done as an overwrite, thus wiping out all the existing data or a restore of the database would be required.
For each release of AR Server, the dbversion can be different depending on the changes made to the data dictionary. It is important to note that the dbversion may not be consecutive to the next release of the AR Server version. The various dbversions and corresponding AR Server versions are as follows: AR Server version 3.02.01 = dbversion of 9 (commonly referred to as 3.2.1) AR Server version 4.00.00 = dbversion of 10 (commonly referred to as 4.0) AR Server version 4.00.01 = dbversion 11 (commonly referred to as 4.0.1) AR Server version 4.00.02 = dbversion 11 (commonly referred to as 4.0.2) AR Server version 4.00.03 = dbversion of 11 (commonly referred to as 4.0.3) AR Server version 4.05.00 = dbversion of 12 (commonly referred to as 4.5) AR Server version 4.05.01 = dbversion of 13 (commonly referred to as 4.5.1) AR Server version 4.05.02 = dbversion of 15 (commonly referred to as 4.5.2) AR Server version 5.00.00 = dbversion of 16 (commonly referred to as 5.0) AR Server version 5.00.01 = dbversion of 17 (commonly referred to as 5.0.1) AR Server version 5.01.00 = dbversion of 18 (commonly referred to as 5.1) AR Server version 5.01.01 = dbversion of 18 (commonly referred to as 5.1.1) AR Server version 5.01.02 = dbversion of 18 (commonly referred to as 5.1.2) AR Server version 6.00.00 = dbversion of 19 (commonly referred to as 6.0) AR Server version 6.00.01 = dbversion of 20 (commonly referred to as 6.0.1) AR Server version 6.03.00 = dbversion of 21 (commonly referred to as 6.3) AR Server version 7.00.00 = dbversion of 22 (commonly referred to as 7.0) AR Server version 7.00.01 = dbversion of 22 (commonly referred to as 7.0.1) My DB version is 22 and this come from the fact, I guess, that weeks ago I have used a different temporary test server to simulate the migration from 5.1.2 to 6.3 and finally to 7.0.1 were from this temporary server I was remotely connected to the DB I'm using. So, now I would like to upgrade my server from version 5.1.2 to version 6.3 with the same DB but the data dictionary has already been upgraded last time to the version 7.0.1. So I guess that this is recognized as a downgrade and this is why he produce me this error. The only solution seems to restore the database, we will then remove this oracle instance (running dbversion 22) a recreate a new one with the views from a previous instance which is working with ARS 5.1.2 (dbversion 18). And hope that I can restart the installation of Remedy 6.3 at this point and that everything will work fine... I will see... Thanks Regards Pascal -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Patel, Kamlesh Sent: Wednesday, September 05, 2007 3:33 PM To: arslist@ARSLIST.ORG Subject: Re: Upgrade from Remedy ARS version 5.1.2 to version 6.3 failed I had seen a thread a while back that had remedy version and corresponding dbversion value. Does anyone have that? If so, it may help Pascal. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jarl Grøneng Sent: Wednesday, September 05, 2007 3:27 AM To: arslist@ARSLIST.ORG Subject: Re: Upgrade from Remedy ARS version 5.1.2 to version 6.3 failed Log into the database and perform the following sql: select dbversion from control; On 6.03 the result should be 21 -- Jarl On 9/5/07, Tournier, Pascal <[EMAIL PROTECTED]> wrote: > Hi, > > I've been informed by our DB people that the new oracle instance seems > to be correctly configured and running so I have requested to stop the > old instance and have retried a new installation but I still get the > same error... > > ------------------------------------------------------------------------ > --- > Starting the AR System Server: Tue Sep 4 09:14:15 METDST 2007 > > (ARNOTE 0) > AR Monitor version 6.03.00 started. > > (ARNOTE 0) > AR Monitor started. > > Action Request System(R) Server Version 6.03.00 > Remedy, a BMC Software company. > Copyright (c) 1991 - 2005 BMC Software, Inc. > All rights reserved. > > 390600 : This version of the Action Request System(R) is ready for use > or evaluation without purchasing or activating an authorization key. > For unlimited capabilities, contact your sales representative. (ARNOTE > 27) > > 390600 : The database is not the expected version (may need to run > upgrade program) (ARERR 36) > > 390600 : AR System server terminated -- fatal error encountered (ARNOTE > 21) > > (ARNOTE 0) > Unable to receive indication that server is up. > > > (ARNOTE 0) > Server (pid:7351) died with 65280. > > > Terminating AR System install on signal as user requested ... > ------------------------------------------------------------------------ > --- > > Furthermore, as few Remedy process are working I get the following error > message to the console prompt every, let say, 30 mn : > > ------------------------------------------------------------------------ > --- > Cannot establish a network connection to the AR System server (nespolo > (0) : RPC: Program not registered) ARERR - 90 > > AR System Application server terminated -- fatal error encountered > (ARAPPNOTE 4501) > > (ARNOTE 0) > Server (pid:19887) died with 65280. > > > Action Request System(R) AR System Application Command Dispatcher > Version 6.03.00 > Remedy, a BMC Software company. > Copyright (c) 1998 - 2005 BMC Software, Inc. > All rights reserved. > ------------------------------------------------------------------------ > --- > > Any other idea ? > > Regards > Pascal > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 > CS/SCCE > Sent: Tuesday, September 04, 2007 5:11 PM > To: arslist@ARSLIST.ORG > Subject: Re: Upgrade from Remedy ARS version 5.1.2 to version 6.3 failed > > How about stopping the old instance of Oracle and then restarting the > Remedy server. Then check the ARERR log again the way you did before. > If my theory holds up, the error in the log won't be that the database > needs to be upgraded, but rather that the Remedy server can't contact > the database at all. If that's the case, you know the Remedy server is > talking to the old database. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Tournier, Pascal > Sent: Tuesday, September 04, 2007 10:05 AM > To: arslist@ARSLIST.ORG > Subject: Re: Upgrade from Remedy ARS version 5.1.2 to version 6.3 failed > > And how can I proceed to check that this is the case and that Remedy is > still looking at the old instance of Oracle rather than the new one ? > any suggestion on what has to be checked ? > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 > CS/SCCE > Sent: Tuesday, September 04, 2007 4:54 PM > To: arslist@ARSLIST.ORG > Subject: Re: Upgrade from Remedy ARS version 5.1.2 to version 6.3 failed > > Well, to me it clearly sounds like your new instance of Remedy is still > looking at the old instance of Oracle rather than the new one. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Tournier, Pascal > Sent: Tuesday, September 04, 2007 9:47 AM > To: arslist@ARSLIST.ORG > Subject: Re: Upgrade from Remedy ARS version 5.1.2 to version 6.3 failed > > With the new install, I'm not using this remote DB option anymore > because the Remedy server is now on the same machine as Oracle... > > Thanks for your time > Regards > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 > CS/SCCE > Sent: Tuesday, September 04, 2007 4:28 PM > To: arslist@ARSLIST.ORG > Subject: Re: Upgrade from Remedy ARS version 5.1.2 to version 6.3 failed > > OK, in your test you say you used the remote DB option. With the new > install/upgrade that you just did, are you still in that remote DB > configuration, or is the Remedy server now on the same machine as > Oracle? > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Tournier, Pascal > Sent: Tuesday, September 04, 2007 9:22 AM > To: arslist@ARSLIST.ORG > Subject: Re: Upgrade from Remedy ARS version 5.1.2 to version 6.3 failed > > What I've done is a Remedy upgrade (not a new install) but instead of > pointing to the old instance, I point to the new one (running oracle 9). > > Before doing that I copied all the view from the old instance to the new > one... the point is that I previously tested this instance, which mean I > installed Remedy version 6.3 on a completely different test server and > used the "Remote database" option and pointed to this new DB instance > and everything was fine.... > > But now I'm blocked and don't know how to proceed.... > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 > CS/SCCE > Sent: Tuesday, September 04, 2007 4:03 PM > To: arslist@ARSLIST.ORG > Subject: Re: Upgrade from Remedy ARS version 5.1.2 to version 6.3 failed > > You mean you did a fresh install of 6.3 (not an upgrade) by pointing to > the new instance of Oracle? You can't do a Remedy upgrade by pointing it > to a new, fresh database instance that doesn't contain an existing > Remedy (arsystem) database. > > It SOUNDS like the new instance of Remedy (6.3) is still looking at the > old 8.1 instance of Oracle, based on the error log. > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Tournier, Pascal > Sent: Tuesday, September 04, 2007 8:58 AM > To: arslist@ARSLIST.ORG > Subject: Re: Upgrade from Remedy ARS version 5.1.2 to version 6.3 failed > > Hi, > > I have two separate instance on my Remedy server, I had remedy 5.1.2 > which was connected to the first instance (Oracle 8.1) and I have tried > to upgrade to Remedy ARS version 6.3 by connecting to the second > instance (Oracle 9 release 2i) > > Thanks > Regards > Pascal > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 > CS/SCCE > Sent: Tuesday, September 04, 2007 3:34 PM > To: arslist@ARSLIST.ORG > Subject: Re: Upgrade from Remedy ARS version 5.1.2 to version 6.3 failed > > Pascal: > > When you say you created a new instance of Oracle, do you mean you > upgraded the existing instance? Or you literally created a new instance > all together? > > Norm > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter > Sent: Tuesday, September 04, 2007 8:21 AM > To: arslist@ARSLIST.ORG > Subject: Re: Upgrade from Remedy ARS version 5.1.2 to version 6.3 failed > > ** > > Pascal, > > > > If the server is not licensed and you have more then 1k records, which > could be causing the error you are seeing > > > > I think you need to get that new 6.3 server licensed. > > > > Howard > > > > > On 9/4/07, Tournier, Pascal <[EMAIL PROTECTED]> wrote: > > ** > > Hi, > > I'm currently running Remedy ARS version 5.0 1.0 2 on oracle > database 8.1 based on HP UX 11.11. I 've created a new Oracle instance > version 9 release 2i and tried to upgr ade R emedy ARS version 6.3 but > during the Remedy installation everything was working fine until the > script tried to restart the remedy application were I get the following > error : > > Starting /opt/REMEDY/ars/nespolo/bin/armonitor > > Starting the AR System Server: Tue Sep 4 09:14:15 METDST 2007 > > (ARNOTE 0) > > AR Monitor version 6.03.00 started. > > (ARNOTE 0) > > AR Monitor started. > > Action Request System(R) Server Version 6.03.00 > > Remedy, a BMC Software company. > > Copyright (c) 1991 - 2005 BMC Software, Inc. > > All rights reserved. > > 390600 : This version of the Action Request System(R) is ready > for use or evaluation without p urchasing or activating an authorization > key. > > For unlimited capabilities, contact your sales representative. > (ARNOTE 27) > > 390600 : The database is not the expected version (may need to > run upgrade program) (ARERR 36) > > 390600 : AR System server terminated -- fatal error encountered > (ARNOTE 21) > > (ARNOTE 0) > > Unable to receive indication that server is up. > > (ARNOTE 0) > > Server (pid:7351) died with 65280. > > Terminating AR System install on signal as user requested ... > > > > And now, nothing is working anymore... furthermore it seems > that several process are working and he tries to connect to the database > , so I get sometimes the following error at the prompt : > > > > Cannot establish a network connection to the AR System server > (nespolo (0) : RPC: Program not registered) ARERR - 90 > > AR System Application server terminated -- fatal error > encountered (ARAPPNOTE 4501) > > (ARNOTE 0) > > Server (pid:19887) died with 65280. > > Action Request System(R) AR System Application Command > Dispatcher Version 6.03.00 > > Remedy, a BMC Software company. > > Copyright (c) 1998 - 2005 BMC Software, Inc. > > All rights reserved. > > > > Thanks > > Regards > > Pascal > > __20060125_______________________This posting was submitted with > HTML in it___ > > > > > -- > Howard Richter > > Remedy ServiceDesk Manager > CedarCrestone Managed Services Center > > [EMAIL PROTECTED] __20060125_______________________This > posting was submitted with HTML in it___ > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
