Troubleshooting
Error msg: “ORACLE may not be functioning properly” error message when starting sqlplus.
Answer:
There are some environment variables that has to be set to be able to use a client tool:
Be careful about setting nls_lang. It affects how the oracle client talks to the database and character conversion.
export NLS_LANG=_.UTF8
echo “$ORACLE_HOME $LD_LIBRARY_PATH”
export ORACLE_HOME=/u00/app/oracle/10.2
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=oracle_sid
ORACLE_SID is the instance name, check init.ora for instance_name parameter or /etc/oratab, /var/opt/oracle/oratab.
Error msg: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
Answer: you must tell the app that you want to connect as sysdba by escaping “.
Example: csscan \”sys@oracle_sid AS SYSDBA\” FULL=y TOCHAR=al32utf8 LOG=dbscan
