Issue: While trying to create repository schema using rcu, we were getting the following error
Repository Creation Utility - Warning | ORA-01450: maximum key length (6398) exceed
Solution: The NLS_LENGTH_SEMANTICS parameter was set to a value of CHAR. Change the value to BYTE and again invoke the rcu, it will go through.
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
Note: Though this parameter is system modifiable, in one of the scenario, after setting this parameter still it was not working, when I bounced the database.. it worked.
Environment Details:
OS: Linux 5.8
Database Version: 11.2.0.3.0
Oracle Home: /u01/app/oracle/product/11.2.0.3.0
Issue: While running dbca/dbua the installer was not able to create the log file and we were getting the below error.
Resolution: I verified that the ORACLE_HOME & PATH variables were set properly. Then I checked for the other environment variables and came to conclusion that there were other environment variables from where the installer was picking a wrong ORACLE_HOME, hence unset the variable of the incorrect location and again set the ORACLE_HOME variable. It started working.
[oracle@linux01 ~]$ export
declare -x BASH_ENV="/home/oracle/.bashrc"
declare -x CVS_RSH="ssh"
declare -x DISPLAY="localhost:13.0"
declare -x EDITOR="vi"
declare -x G_BROKEN_FILENAMES="1"
declare -x HISTSIZE="1000"
declare -x HOME="/home/oracle"
declare -x HOSTNAME="linux01.us.oracle.com"
declare -x INPUTRC="/etc/inputrc"
declare -x JAVA_HOME="/usr/java/jdk1.7.0_40"
declare -x LD_LIBRARY_PATH="/scratch/oracle/product/12.1.0/dbhome_1/lib"
declare -x LOGNAME="oracle"
declare -x MAIL="/var/spool/mail/oracle"
declare -x OH_PATH="/scratch/oracle/product/12.1.0/dbhome_1/OPatch:/scratch/oracle/product/12.1.0/dbhome_1/bin"
declare -x ORACLE_BASE="/scratch/oracle"
declare -x ORACLE_HOME="/u01/app/oracle/product/11.2.0.3.0"
declare -x ORACLE_INSTANCE="/scratch/oracle/product/instances/WT11gR1_UCM"
declare -x PATH="/usr/lib64/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin"
declare -x PWD="/home/oracle"
declare -x QTDIR="/usr/lib64/qt-3.3"
declare -x QTINC="/usr/lib64/qt-3.3/include"
declare -x QTLIB="/usr/lib64/qt-3.3/lib"
declare -x SHELL="/bin/bash"
declare -x SSH_TTY="/dev/pts/5"
declare -x TERM="xterm"
declare -x USER="oracle"
[oracle@linux01 ~]$ export |grep scratch
declare -x LD_LIBRARY_PATH="/scratch/oracle/product/12.1.0/dbhome_1/lib"
declare -x OH_PATH="/scratch/oracle/product/12.1.0/dbhome_1/OPatch:/scratch/oracle/product/12.1.0/dbhome_1/bin"
declare -x ORACLE_BASE="/scratch/oracle"
declare -x ORACLE_INSTANCE="/scratch/oracle/product/instances/WT11gR1_UCM"
[oracle@linux01 ~]$ unset LD_LIBRARY_PATH OH_PATH ORACLE_BASE ORACLE_INSTANCE
[oracle@linux01 ~]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3.0
[oracle@linux01 ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@linux01 ~]$ dbua
