RE: need to Run csscan in Background ?

Thanks Mark, Folks

Ctrl(^)Z is NOT RETURNING CONTROL BACK TO SHELL PROMPT. Any Advice on this please?

Also any Parameters for Speeding UP the CSScan as DB Size is 3 TB?

Am using PROCESS=32, ARRAY=10MB

Should Array Value be Further increased?

Usually Each of the 32 Scanning processes take up only 1 % CPU adding to approz 32% CPU Consumed.

M/c Config:-

8 CPUS 32 GB RAM Cheers

-----Original Message-----

From: Mark J. Bobak [mailto:mark.bobak_at_il.proquest.com] Sent: Wednesday, December 27, 2006 1:44 PM

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

From: VIVEK_SHARMA
Sent: Wednesday, December 27, 2006 12:30 PM

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

• 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