need to Run csscan in Background ?
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Dec 2006 12:30:07 +0530
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***
Other related posts:
