Error msg: “ORACLE may not be functioning properly” error message when starting sqlplus.
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.
echo “$ORACLE_HOME $LD_LIBRARY_PATH”
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