Re: need to Run csscan in Background ?

Try the following:
$ nohup csscan <all your options except for username/password go here>

Do NOT put an & at the end of the line.

Now, all terminal output is being redirected to nohup.out, so, you can't see it, but it's waiting for a username input. Type: / as sysdba
Now, again, you see no prompt, but it's waiting for password input. Just hit return.

Now, csscan should be running, in the foreground, and all terminal output is redirecting to nohup.out.

Hit Ctrl-Z, and when you see a shell prompt, type 'bg'.

Make *sure* you type the 'bg' at the shell after the Ctrl-Z, or the process will remain suspended and will NOT do anything.

Now, since you ran with nohup, if you log out, or if your session is disconnected, the csscan will not catch a SIGHUP, and will continue running. For any output that would normally go to the terminal, see the nohup.out file.

Hope that helps,

-Mark

On Wed, 2006-12-27 at 12:30 +0530, VIVEK_SHARMA wrote:
> 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
>
>
>
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this
> e-mail or its contents to any other person and any such actions are
> unlawful. This e-mail may contain viruses. Infosys has taken every
> reasonable precaution to minimize this risk, but is not liable for any
> damage you may sustain as a result of any virus in this e-mail. You
> should carry out your own virus checks before opening the e-mail or
> attachment. Infosys reserves the right to monitor and review the
> content of all messages sent to or from this e-mail address. Messages
> sent to or from this e-mail address may be stored on the Infosys
> e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>

--
http://www.freelists.org/webpage/oracle-l