Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> need to Run csscan in Background ?

need to Run csscan in Background ?

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Wed, 27 Dec 2006 12:30:07 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF30200253319B@BLRKECMSG11.ad.infosys.com>

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

Received on Wed Dec 27 2006 - 01:00:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US