oracle issueshttps://gitlab.lakedrops.com/ansible/roles/oracle/-/issues2017-04-06T07:19:06Zhttps://gitlab.lakedrops.com/ansible/roles/oracle/-/issues/1Setup environment2017-04-06T07:19:06ZJürgen Haasjuergen.haas@lakedrops.comSetup environmentWe should make the environment variables available for all admin users:
```
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export ORACLE_BASE=/u01/app/oracl...We should make the environment variables available for all admin users:
```
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH
```
And then we should also install `pip install cx_Oracle` which will allow us to quickly script stuff for the database. See http://www.oracle.com/technetwork/articles/dsl/prez-python-queries-101587.htmlJürgen Haasjuergen.haas@lakedrops.comJürgen Haasjuergen.haas@lakedrops.com