RE: need to Run csscan in Background ? ................SOLVED

From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
To: "Mark J. Bobak" <mark.bobak@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 27 Dec 2006 15:59:41 +0530

Set O7_DICTIONARY_ACCESSIBILITY=true in respective init.ora



Thereafter csscan running successfully in background as follows:-



$ nohup csscan USERID=system/pnb123 FULL=Y FROMCHAR=US7ASCII
TOCHAR=AL32UTF8 ARRAY=10240000 LOG=chrchk CAPTURE=Y PROCESS=32 &



________________________________

From: VIVEK_SHARMA
Sent: Wednesday, December 27, 2006 3:00 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: 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@xxxxxxxxxxxxxxx]
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







**************** 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***

RE: need to Run csscan in Background ? ................SOLVED

Other related posts: