How to connect to Database (Postgres/Oracle) from TSCO App Server? |
Watch this video to see how to connect TSCO AS to DB: To connect Oracle DB from AS: 1 - Verify DB SID by giving below command: cat <tnsnames.ora file location>2 - su - cpit 3 - cd TSCO_HOME Directory 4 - . env.sh 5 - sqlplus bco_own/<Password>@SID Example: su - cpit cd /opt/bmc/BCO . env.sh sqlplus $DBUSR/BmcCapac1ty_OWN@$ORACLE_SID To connect Postgres DB from AS: 1 - su - cpit 2 - cd TSCO_HOME Directory 3 - . env.sh 4 - psql postgresql://$DBHOST:$DBPORT/$DBUSR -U $DBUSR Example: su - cpit cd /opt/bmc/BCO . env.sh psql postgresql://$DBHOST:$DBPORT/$DBUSR -U $DBUSR |