We planned to do out of place upgrade from soa suite 126.96.36.199 to 188.8.131.52. As part of this, we planned to automate end to end provisioning. While executing domain configuration using ansible and python scripts, we got following error in domain creation step.
Got exception when auto configuring the schema component(s) with data obtained from shadow table. Failed to build JDBC Connection object: com.oracle.cie.domain.script.jython.CommandExceptionHandler.
Quick internet search gave few solutions like deleting domain-registry.xml file, verifying dehydration store password supplied to script etc. But none of them helped. After trying several options, I thought I might have done some stupid error prior to domain creation step. To track down the issue, though of checking what getDatabaseDefaults actually doing. I tried to grep for the getDatabaseDefaults function call inside oracle home. But couldn’t find the source code for the python function.
As a final resort, thought of capturing what is happening while connecting to DB through strace linux tool. Ran following command to capture the syscall details:
strace -s 400 -ftTy -e ‘trace=!futex,getdents,clock_gettime,gettimeofday,ioctl’ -o trace.out bash $FMW_HOME/oracle_common/common/bin/wlst.sh ./createSOADomain.py
Basically, I was looking for the username and connection details that above function is using to connect to DB. Luckily, found below entry in the strace output.
write(951, “\0\0\0\255\6\0\0\0\1DEV_STB\1\r\rAUTH_TERMINAL\1\7\7unknown\0\1\17\17AUTH_PROGRAM_NM\1\20\20JDBC Thin Client\0\1\f\fAUTH_MACHINE\1\21\21orasoa-dev-app1\0\1\10\10AUTH_PID\1\4\004\10\10AUTH_SID\1\6\6oracle\0″, 173) = 173 <0.000067>
As highlighted in above error, the script was trying to connect DEV_STB schema. Quickly I realized my mistake. While creating RCU in silent mode, I missed to STB as component. So, connection to database using above user was failing. So, I dropped the repository and recreate by adding DEV_STB component as well. Domain was successfully created post that. Sample rcu creation command:
./rcu -silent -createRepository -databaseType ORACLE -connectString db-hostname:1521:SID -dbUser sys -dbRole SYSDBA -schemaPrefix DEV -useSamePasswordForAllSchemaUsers true -component MDS -component IAU -component IAU_APPEND -component IAU_VIEWER -component OPSS -component UCSUMS -component WLS -component STB -component SOAINFRA
- 2023.05.23rabbitmqRabbitmq Connection Error: javax.net.ssl.SSLHandshakeException: Invalid ECDH ServerKeyExchange signature
- 2023.03.24rcuSOA Suite 184.108.40.206 installation: Got exception when auto configuring the schema component(s) with data obtained from shadow table
- 2023.03.09rabbitmqNot able to start Rabbitmq Cluster: Cannot declare a queue ‘~s’ on node ‘~s’: ~255p
- 2023.03.084lw commandsTelegraf agent not able to monitor zookeeper