1837503 - SAP system could not connect to DB

Symptom

• SAP system could not be started, work process not able to connect to database
• In trans.log, see the following error:
   *** ERROR => Env. NLS_LANG='AMERICAN_AMERICA.UTF16' not compatible to V$NLS_PARAMETERS: 'AMERICAN_.UTF8', connection refused.
• The NLS_LANG was set correctly, still got the same issue.
• Also see ORA-00942 error in the trans.log: 
  ORA-00942: table or view does not exist

Environment

Oracle DB

Reproducing the Issue

Start SAP system

Cause

The NLS_LANG error was misleading, in the trans.log there're also some ORA-00942 errors when try to select on DB views such as V$instance, V$database, which means the SAP DB user is not able to access any tables on the system. Checked on the DB level, the SAP DB user doesn't have the default role assigned.

Resolution

1. Check if the SAP DB user have the correct default DB role assigned, run the following SQL:
   SQL> select grantee, granted_role, default_role from dba_role_privs
   where grantee='SAP<SID>';
2. Check if SAPCONN ROLE was assigned to the SAP DB user as the default role, if not, change it by:
   SQL> alter user SAP<SID> default role SAPCONN;
3. Try to restart the SAP system again.

Header Data

Released On	24.05.2013 22:22:42
Release Status	Released to Customer
Component	BC-DB-ORA Oracle
Priority	Normal
Category	Problem