Oracle: Check User Locks

sqlplus system/******** <<ENDSQL> /dev/null
clear buffer
set feedback off
set pause off
column USERID FORMAT A9;
column SID FORMAT 6;
column USER_B FORMAT A9;
column SID_B FORMAT 6;
spool $HOME/userlocks
SELECT rtrim(DECODE(request,0,'Holder: ','Waiter: ')|| v1.sid ||' - ' ||V2.USERNAME) "Session",
       lmode,
       v1.request,
       v2.STATUS,
       v2.COMMAND,
       v2.PROCESS "OS PROCESS",
       v1.type
  FROM V\$LOCK V1,
       V\$SESSION V2
 WHERE (V1.id1, V1.id2, V1.type) IN (SELECT id1, id2, type
                                       FROM V\$LOCK
                                      WHERE request>0)
   AND V1.SID = V2.SID
 ORDER BY v1.id1, v1.request;
/

spool off
ENDSQL

ORA-01858: a non-numeric character was found where a numeric was expected

OS: Solaris 10
JVM Container: WAS 8.0

Problem:

[16/07/15 8:59:58:235 EDT] 00000016 BusinessExcep E   CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "init" on bean "BeanId". Exception data: <openjpa-2.1.2-SNAPSHOT-r422266:1333100 fatal general error> org.apache.openjpa.persistence.PersistenceException: ORA-01858: a non-numeric character was found where a numeric was expected

Solution:

Set Environment Variable LC_ALL to en_US.UTF-8
echo "Set Locale to use en_US.UTF-8"

LC_ALL=en_US.UTF-8; export LC_ALL

locale

WebSphere: French Character Problem in created file

# cat start_was.sh
#!/bin/sh

echo "Set Locale to use en_US.UTF-8"

LC_ALL=en_US.UTF-8; export LC_ALL

locale

cd /opt/IBM/WebSphere/AppServer/bin
echo "Starting IBM Deployment Manager"
./startManager.sh -profileName $1

echo "Starting NodeAgent"
./startNode.sh -profileName $2

echo "Starting WAS"
./startServer.sh -profileName $2 server1

locale