Home
All Oracle Error Codes
Oracle DBA Forum

Frequent Oracle Errors

TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated

Re: need to Run csscan in Background ?

Bobak, Mark

2006-12-27

Replies:
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