OnDemand User Group
Support Forums => MP Server => Topic started by: jsquizz on December 30, 2020, 08:38:22 AM
-
We are trying to configure a CMOD 10.5 instance using oracle. We are getting -
[archive@server bin]$ ./arsdb -I u7edp1d1 -rtv
ARS4013E Unable to determine the database engine
[archive@server bin]$
We have tried all troubleshooting methods within the cmod.wiki/documentation with no luck.
CMOD Configs:
archive@server bin]$ more ../config/ars.cfg | grep ORA
# 5622-662 (C) COPYRIGHT IBM CORPORATION 2020
ARS_DB_ENGINE=ORACLE
# ORACLE Parameters (Library Server Only) #
#ARS_ORACLE_HOME=/home/oracle
ARS_ORACLE_HOME=/u01/app/oracle/product/19.7.0
ARS_STORAGE_MANAGER=NO_TSM
[archive@server bin]$
[archive@server bin]$ more ../config/ars.ini
[@SRV@_ARCHIVE]
HOST=server.hostname
PROTOCOL=2
PORT=0
SRVR_INSTANCE=database
SRVR_INSTANCE_OWNER=archive
SRVR_OD_CFG=/opt/ibm/ondemand/V10.5/config/ars.cfg
SRVR_DB_CFG=/opt/ibm/ondemand/V10.5/config/ars.dbfs
SRVR_SM_CFG=/opt/ibm/ondemand/V10.5/config/ars.cache
Environment Variables-
# User specific environment and startup programs
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.7.0
DATABASE=u7edp1d1
PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin
export PATH
export ORACLE_BASE
export DATABASE
connection strings-
archive@server ~]$ sqlplus archive/welcome123@u7edp1d1
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 29 18:53:36 2020
Version 19.7.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.7.0.0.0
ARCHIVE@server:SQL>
-
Fix-
[@SRV@_ARCHIVE] was not set to the right database name
After this-
arsstash -c -s ars.stash -a 9 -u archive
arsdb ran like a champ, arssockd started up!
-
Yeah, I wasn't sure if you had substituted these values for anonymized versions, or if you'd overlooked configuring them.
HOST=server.hostname
SRVR_INSTANCE=database
-JD.