the errors seen above are encountered because the NLS_LENGTH_SEMANTICS initialisation parameter has been set to CHAR. This is not a supported setting for this parameter in an Oracle Fusion Middle ware installation. This is documented in the Release Notes for each platform.
To remove the ORA-01450 errors when creating the MDS and SOAINFRA components ensure that the requirement for NLS_LENGTH_SEMANTICS=BYTE is met.
To check the current setting of NLS_LENGTH_SEMANTICS, login to the target database as SYSDBA and issue the following command:
SQL> show parameter NLS_LENGTH_SEMANTICS
NAME TYPE VALUE
———————— ———– ——-
nls_length_semantics string CHAR
SQL> alter system set nls_length_semantics=BYTE;
System altered.
SQL> show parameter NLS_LENGTH_SEMANTICS
NAME TYPE VALUE
———————— ———– ——-
nls_length_semantics string BYTE
After resetting the parameter you should restart your database for the change to take effect.
linux01(oracle:orcl1)/home/oracle: lsnrctl start LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-SEP-2015 03:43:02 Copyright (c) 1991, 2013, Oracle. All rights reserved. Starting /opt/oracle/product/11.2.0.4.RAC/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is /opt/oracle/product/11.2.0.4.RAC/network/admin/listener.ora Log messages written to /opt/oracle/diag/tnslsnr/linux01/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA NL-00303: syntax error in NV string Listener failed to start. See the error message(s) above...
In the listener.ora file there were blank lines under the section SID_LIST_LISTENER. We removed the blank line entries and brought up the listener. (please note that this may be one of the scenarios)
Erroneous listener.ora file excerpts below:
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL1) (ORACLE_HOME = /opt/oracle/product/11.2.0.4.RAC) (SID_NAME = ORCL1) ) <<<<< blank line (SID_DESC = (GLOBAL_DBNAME = ORCL2) (ORACLE_HOME = /opt/oracle/product/11.2.0.4.RAC) (SID_NAME = ORCL2) ) <<<<< blank line )
Query # 1 :
desc v$license Name Null? Type ----------------------------------------- -------- ---------------- SESSIONS_MAX NUMBER SESSIONS_WARNING NUMBER SESSIONS_CURRENT NUMBER SESSIONS_HIGHWATER NUMBER USERS_MAX NUMBER CPU_COUNT_CURRENT NUMBER CPU_CORE_COUNT_CURRENT NUMBER CPU_SOCKET_COUNT_CURRENT NUMBER CPU_COUNT_HIGHWATER NUMBER CPU_CORE_COUNT_HIGHWATER NUMBER CPU_SOCKET_COUNT_HIGHWATER NUMBER
Query # 2 :
select sessions_current from v$license;
Query # 3 :
select SESSIONS_CURRENT,SESSIONS_HIGHWATER,CPU_COUNT_CURRENT,CPU_COUNT_HIGHWATER from v$license;
Query # 4 :
SELECT USERNAME FROM DBA_USERS
Query # 5 :
SELECT distinct user_id from FND_LOGINS
Query # 6 :
SELECT distinct user_id from icx_sessions
Query # 7 :
SELECT distinct user_id from FND_USER
Query #8:
select application_name,responsibility_name,
security_group_name, user_name,
greatest(u.start_date, ur.start_date, r.start_date) start_date,
least(nvl(u.end_date, nvl(ur.end_date, r.end_date)),
nvl(ur.end_date, nvl(u.end_date, r.end_date)),
nvl(r.end_date, nvl(u.end_date, ur.end_date))) end_date
from fnd_user u,fnd_user_resp_groups ur,
fnd_responsibility_vl r,fnd_application_vl a,
fnd_security_groups_vl s
where a.application_id = r.application_id
and u.user_id = ur.user_id
and r.application_id = ur.responsibility_application_id
and r.responsibility_id = ur.responsibility_id
and ur.start_date sysdate
and u.start_date sysdate
and r.start_date sysdate
and ur.security_group_id = s.security_group_id
order by application_name,responsibility_name,security_group_name, user_name
Query # 9 :
select application_name,responsibility_name,
security_group_name, user_name,
greatest(u.start_date, ur.start_date, r.start_date) start_date,
least(nvl(u.end_date, nvl(ur.end_date, r.end_date)),
nvl(ur.end_date, nvl(u.end_date, r.end_date)),
nvl(r.end_date, nvl(u.end_date, ur.end_date))) end_date
from fnd_user u,fnd_user_resp_groups ur,
fnd_responsibility_vl r,fnd_application_vl a,
fnd_security_groups_vl s
where a.application_id = r.application_id
and u.user_id = ur.user_id
and r.application_id = ur.responsibility_application_id
and r.responsibility_id = ur.responsibility_id
and ur.start_date sysdate
and u.start_date sysdate
and r.start_date sysdate
and ur.security_group_id = s.security_group_id
order by application_name,responsibility_name,security_group_name, user_name