Hi,
Can any one kindly help me with process of OnDemand Application Migration from DB2 to Oracle. What are scripts need to be modified to point OnDemand application from DB2 to Oracle(I have modified two scripts ARS.CFG, ARS.INI). Database is already migrated by DBA's. Now only need to route the OnDemand Application from DB2 to Oracle.
Below are the environment details
1. CMOD 8.5.0.0.6
2. IBM DB2 9.5
3. Oracle 11g
4. RHEL
What were the results of the migration you did in your development and test environments? ;D
If I were at your point, I'd try starting CMOD, resolve any error messages, and begin your QA testing.
-JD.
JD,
I have done the same thing initially i got issue with Oracle TNS file after resolving the issue i started the OnDemand services and got below error message
|0|ARSMSG||2|147 Unable to initialize server environment. The return code is 1
based on the error message i gone through the Message code and verified the ars.ini and ars.cfg file. But i am not able to get the error is exactly.
Hello Rajesh,
How did the DBA migrate DB2 to Oracle?
I've done it many times in the past, and from Oracle to DB2 and DB2 to Oracle.
Do you know that some of the tables are not equals? That you need to map nearly tables per tables? The data type needs to be adapted?
etc... etc...
If you do the DB migration correctly, then the configuration is trivial. The database is the difficult part.
And sorry, but I don't trust the DBAs...
So what did they do exactly?
Alessandro
Thank Alessandro,
DB Migration was happened in 2013 i will gather the information and process from DBA and get back to you with details. Mean time can you let me what are the files that need to be modified a part from which i have mentioned.
I have gone through you post about the DB migration process. Hope the same process has implemented and same was shared with me.
Below is the error which i am facing now. I have already modified ARS_ORIGINAL_CODEPAGE based on the OnDemand troubleshoot guide eventhough i face same issue. Request you to kindly suggest.
DB Error: STARTUP -- SQLSTATE=1. ARS_ORIGINAL_CODEPAGE is not defined in ars.cfg. Run arsdb -u -I archived to determine setting of ARS_ORIGINAL_CODEPAGE, SQLCODE=0, File=arssrvr.c, Line=8457
/opt/ondemand/appbin/arslog_log.ksh[69]: cannot create /opt/ondemand/logs/arslog.log: Permission denied
/bin/chgrp: changing group of `/opt/ondemand/logs/arslog.log': Operation not permitted
The command >arssockd< can only be run by the owner of the command
/opt/ondemand/appbin/arslog_log.ksh[69]: cannot create /opt/ondemand/logs/arslog.log: Permission denied
/bin/chgrp: changing group of `/opt/ondemand/logs/arslog.log': Operation not permitted
Rajesh,
I am not sure to understand what you want...
The DB migration was done in 2013, and now 2 years later, you want to do it again? Or you are still doing it?
To your question, if you have done ARS.CFG you should be fine. You probably need to remove all entries from ARS.DBFS.
Is Oracle DB local or remote?
Do you have a "tnsnames.ora", Have you modified the tnsnames.ora to reflect what you have in ars.ini?
Why did you modify ARS.INI ??? Normally there is no need to modify anything there.
Alessandro
Quote from: rajesh on August 13, 2015, 12:38:28 PM
Below is the error which i am facing now. I have already modified ARS_ORIGINAL_CODEPAGE based on the OnDemand troubleshoot guide eventhough i face same issue. Request you to kindly suggest.
DB Error: STARTUP -- SQLSTATE=1. ARS_ORIGINAL_CODEPAGE is not defined in ars.cfg. Run arsdb -u -I archived to determine setting of ARS_ORIGINAL_CODEPAGE, SQLCODE=0, File=arssrvr.c, Line=8457
/opt/ondemand/appbin/arslog_log.ksh[69]: cannot create /opt/ondemand/logs/arslog.log: Permission denied
/bin/chgrp: changing group of `/opt/ondemand/logs/arslog.log': Operation not permitted
The command >arssockd< can only be run by the owner of the command
/opt/ondemand/appbin/arslog_log.ksh[69]: cannot create /opt/ondemand/logs/arslog.log: Permission denied
/bin/chgrp: changing group of `/opt/ondemand/logs/arslog.log': Operation not permitted
Hello Rajesh,
You have several errors that doesn't fit the CMOD upgrade procedure, maybe you did it in a script, without the correct permissions, without using the correct user (CMOD instance user).
Please check that your script "/opt/ondemand/appbin/arslog_log.ksh" is used correctly, and please check with the people in your company that has created it.
He should help you to use it correctly.
Concerning the error:
DB Error: STARTUP -- SQLSTATE=1. ARS_ORIGINAL_CODEPAGE is not defined in ars.cfg. Run arsdb -u -I archived to determine setting of ARS_ORIGINAL_CODEPAGE, SQLCODE=0, File=arssrvr.c, Line=8457Apparently, even if you have setup the ARS_ORIGINAL_CODEPAGE, you didn't do it correctly.
So please run the following command:
arsdb -u -I <CMOD_Instance>
And paste the result in this forum, and we will help you do this configuration.