Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> need to Run csscan in Background ?
Folks
Need to Run csscan Utility as Background processes because the LAN Network Connecting my PC to the SUN DB Server is somewhat Unstable. Can csscan be Run as a Background Unix Process or NOT?
NOTE - csscan is Running in the foreground ($ csscan FULL=Y FROMCHAR=US7ASCII TOCHAR=AL32UTF8 ARRAY=10240000 LOG=chrchk CAPTURE=Y PROCESS=32). Since my Database is 3 TB, the process usually Fails before completion due to LAN Network Problems.
To my understanding csscan needs to be Run as "/ as sysdba" only
Config
Solaris 10
Oracle RAC 10gR2
Following Attempts Failing with Errors:-
$ csscan FULL=Y FROMCHAR=US7ASCII TOCHAR=AL32UTF8 ARRAY=10240000
LOG=chrchk CAPTURE=Y PROCESS=32 &
Character Set Scanner v2.1 : Release 10.2.0.0.0 - Production on Wed Dec 27 12:28:35 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Username: / as sysdba
ksh: /: cannot execute
[3] + Stopped (SIGTTIN) csscan FULL=Y FROMCHAR=US7ASCII TOCHAR=AL32UTF8 ARRAY=10240000 LOG=chrchk CAPTURE=Y
PROCESS=32 &
$ csscan USERID='/ as sysdba' FULL=Y FROMCHAR=US7ASCII TOCHAR=AL32UTF8
ARRAY=10240000 LOG=chrchk CAPTURE=Y PROCESS=32
LRM-00112: multiple values not allowed for parameter 'userid'
failed to process command line parameters
$ csscan USERID=sys/<passwd> FULL=Y FROMCHAR=US7ASCII TOCHAR=AL32UTF8
ARRAY=10240000 LOG=chrchk CAPTURE=Y PROCESS=32
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
![]() |
![]() |