Author Topic: arsdb -rtv fails when creating db (10.5 + oracle)  (Read 1269 times)

jsquizz

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 576
    • View Profile
arsdb -rtv fails when creating db (10.5 + oracle)
« 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>



#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE #GCP #EVERYTHING

jsquizz

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 576
    • View Profile
Re: arsdb -rtv fails when creating db (10.5 + oracle)
« Reply #1 on: December 30, 2020, 10:55:01 AM »
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!
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE #GCP #EVERYTHING

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: arsdb -rtv fails when creating db (10.5 + oracle)
« Reply #2 on: December 31, 2020, 01:54:37 PM »
Yeah, I wasn't sure if you had substituted these values for anonymized versions, or if you'd overlooked configuring them.

Code: [Select]
HOST=server.hostname
SRVR_INSTANCE=database

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR