Print Page - DB Error STARTUP

Title: DB Error STARTUP - Test System
Post by: Gordon R on March 12, 2013, 06:37:31 PM

Good Afternoon;
We are now having a new issue with our Test environment.
The CMOD system does not want to start. Has anyone come across this error before?

arssockd (ARST): 03/07/13 13:58:51 0 ARSSOCKD 2 13 DB Error: STARTUP -- SQLSTATE=HENV=0, SQLCODE=-1, File=arssys.c, Line=214

CMOD = 8.4.1
AIX = 6.1
Oracle = 11g r2

Since this is our Test system, we should get this resolved before going to 8.5.x..

Thanks in advance,
Gord

Title: Re: DB Error STARTUP - Test System
Post by: pankaj.puranik on March 13, 2013, 03:36:05 AM

Hi Gordon

Could you please post the command that you used?

Thanks
Pankaj.

Title: Re: DB Error STARTUP - Test System
Post by: Gordon R on March 13, 2013, 03:57:23 PM

Hi Pankaj;
The command we are using is,
Arssockd archive

Title: Re: DB Error STARTUP - Test System
Post by: Alessandro Perucchi on March 14, 2013, 09:59:53 PM

Hello,

If I'm not wrong that is because of Oracle 11G R2.
Oracle with its R2 release introduced a bug.
As long as you don't correct your Oracle installation, you won't be able to start CMOD (8.4.X or later).

In addition Oracle 11GR2 is supported officially only with V8.5.0.2 and not before.

You can check this link in order to correct your problem:

http://www-304.ibm.com/support/docview.wss?uid=swg21496629 (http://www-304.ibm.com/support/docview.wss?uid=swg21496629)

My advice is first upgrade to 8.5, then upgrade to Oracle 11G R2, correct the Oracle bug, and then start CMOD.

Sincerely yours,
Alessandro

Title: Re: DB Error STARTUP - Test System
Post by: Paul on April 08, 2013, 02:09:56 PM

You also need to install the GSKit or you will not be able to start CMOD.

Title: Re: DB Error STARTUP - Test System
Post by: Paul on April 12, 2013, 06:07:44 PM

I found this to be a very well written article for our upgrade.

http://www-01.ibm.com/support/docview.wss?rs=0&uid=swg21446135

Title: Re: DB Error STARTUP - Test System
Post by: n.prelhaz on January 18, 2017, 10:10:41 AM

Hello,

Sorry to bring back this old post but I'm experiencing this error.
I'm migrating CMOD 8.5 to the latest version 9.5.0.7, on Windows, using also a remote Oracle DB 11gR2.

First, I had successfully configured CMOD 8.5 to connect to the DB, start CMOD and search with the client.
However, I was still having this problem with the TSM Archive (with 8.5):

http://ODUG.net/index.php?topic=1903.0

In which seemed to be a bug on the directory structure inside TSM to look/search for the file.
It was suggested to upgrade to the 9.5 (I'm not sure if it was also just the client, to lower to 9.5.0.3 and not the server, however I need to put the latest version working) , in which I installed and setup again the instance, etc.

But it seems that now I have a problem connecting to the DB in order to run the updates on the tables and indexes:

D:\Program Files\IBM\OnDemand\V9.5\bin>arsdb -I DBOD1 -efv
ARS4054E DB Error: STARTUP -- SQLSTATE=HENV=0, SQLCODE=-1
arsdb: ARS4023E Unable to connect to ORACLE DBOD1 database

I suggested the DBA, the following note: http://www-304.ibm.com/support/docview.wss?uid=swg21496629
But it didn't solve the problem.

Does anyone had already experienced this problem?

Thanks!

Title: Re: DB Error STARTUP - Test System
Post by: Justin Derrick on January 19, 2017, 02:06:27 PM

I happened across this article while looking for something else, but thought it might provide some help:

https://www-01.ibm.com/support/docview.wss?uid=swg21984239

-JD.

Title: Re: DB Error STARTUP - Test System
Post by: n.prelhaz on January 25, 2017, 01:27:18 PM

Hello,

Thank you for your answer but I don't see how it can help.

Thanks

Edit: I've been also hearing that it's usually related to the ARS_ORACLE_HOME directory but I believe I have this set fine: C:\Oracle11gR2\product\11.2.0\client_1

OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: Gordon R on March 12, 2013, 06:37:31 PM