06-12-2015
Moderator's Comments:
|
|
This member has repeatedly ignored requests to use CODE tags as required by forum rules and is now placed in read-only mode for two weeks. Future infractions may results in a permanent ban for this user.
|
|
This User Gave Thanks to Don Cragun For This Post:
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I am having problem with a shell script. I have a couple of csv files. The shell script will do some operation on them, create a sql file which will then be called by sqlplus. The problem is to gracefully exit sqlplus at the end of every operation as I do not want to hang on to the... (4 Replies)
Discussion started by: nattynatty
4 Replies
2. Shell Programming and Scripting
Hi
when i am calling the shell script with two parameter like id and date it works fine.But the same shell script is call by java application it gives the error as shown below
Thu Jan 8 04:13:22 EST 2009|The Get Segment Process Failed: SP2-0306:
Invalid option.
Usage: CONN where <logon>... (1 Reply)
Discussion started by: ravi214u
1 Replies
3. Shell Programming and Scripting
Hi,
For connecting to oracle my script is using the command
sqlplus username/password@db_instance_name.For this to work i am setting ORACLE_HOME,TNS_ADMIN and ORACLE_SID in a seperate script.My question is,could we make a connection to oracle just by the command
sqlplus... (4 Replies)
Discussion started by: DILEEP410
4 Replies
4. Shell Programming and Scripting
Hi all,
I am satyakiran , i am new to the forum. i never done shell scripts for connecting to the data base (oracle) and fetching the data from the database( thru sql select statements ) i want to know
1. how to connect to the data base(oracle) using shell script
2. how to retrieve data... (8 Replies)
Discussion started by: satyakiran
8 Replies
5. Shell Programming and Scripting
Hi,
Oracle 9.2
Solaris 10
From the shell script ........How can we verify whether oracle connection is successful or not ?
Shell script will prompt the user to enter the oracle schema username, password and tns name.
So, *how to verify whether oracle connection has been established or... (14 Replies)
Discussion started by: milink
14 Replies
6. Shell Programming and Scripting
Hi Unix Gurus,
I have a requirement to write a script, Oracle DB gets referesh every 6hrs, hence we need write a script to connect to the database , if it connects it should generate a file to proceed the next job application or when an error when connectiong to DB it should not generate any... (8 Replies)
Discussion started by: bshivali
8 Replies
7. Shell Programming and Scripting
Hi All,
I am newbie to unix shell scripting. I want to connect to oracle database using shell script. I know how to connect DB using user name and password but my question is if my password is having '@' sign then how to connect.
I have tried like below,
cnt=`sqlplus -s /nolog << EOFSQL
... (3 Replies)
Discussion started by: pmotewar
3 Replies
8. Shell Programming and Scripting
Hi,
We have Oracle Connection parameters set up in file name "TESTDB" at location /abc/etc.When I try to run my shell script it does not connect to Oracle database. Please let me know how "TESTDB" file can be called inside script.
####################### Setting the directories... (2 Replies)
Discussion started by: sandy162
2 Replies
9. Shell Programming and Scripting
Hi I have a question regarding Oracle connection using the below code
${ORACLE_HOME}/bin/sqlplus -s $user/$pwd@$sid <<!EOF 1>> $v_log_dir/$v_job_log.out 2>> $v_log_dir/$v_job_log.err
/
prompt stored procedure beginning . . .
exec xx_interface_pkg.pr_xx_clms_out($datayears,$keepmonths);
... (3 Replies)
Discussion started by: smilingraja
3 Replies
strace(1M) strace(1M)
NAME
strace - write STREAMS event trace messages to standard output
SYNOPSIS
mod sub pri
DESCRIPTION
gets STREAMS event trace messages from STREAMS drivers and modules via the STREAMS log driver and writes these messages to standard output.
By default, without arguments writes all STREAMS trace messages from all drivers and modules. with command-line arguments limits the trace
messages received.
The arguments, which must be specified in groups of three, are:
mod Specifies the STREAMS module identification number from the streamtab entry.
sub Specifies a subidentification number (often corresponding to a minor device).
pri Specifies a tracing priority level. gets messages of a level equal to or less than the value specified by pri. Only posi-
tive integer values are allowed.
The value can be used for any argument in the command line to indicate that there are no restrictions for that argument.
Multiple sets of the three arguments can be specified to obtain the messages from more than one driver or module.
Only one process can open the STREAMS log driver at a time.
When is invoked, the log driver compares the sets of command line arguments with actual trace messages, returning only messages that sat-
isfy the specified criteria.
STREAMS event trace messages have the following format:
seq time tick pri ind mod sub text
Components are interpreted as follows:
seq Trace event sequence number.
time Time the message was sent expressed in hh:mm:ss.
tick Time the message was sent expressed in machine ticks since the last boot.
pri Tracing priority level as defined by the STREAMS driver or module that originates the messages.
ind Can be any combination of the following three message indicators:
The message has also been saved in the error log.
The message signaled a fatal error.
The message has also been mailed to the system administrator.
mod Module identification number of the trace message source.
sub Subidentification number of the trace message source.
text Trace message text.
runs until terminated by the user.
EXAMPLES
Display all trace messages received from the driver or module identified by mod
Display trace messages of any tracing priority level from the driver or module identified by mod and its minor devices identified by the
sub or
Display the trace messages from the same driver or module and subs but limit the priority levels to 0 for subs 2 and 3; 1 for sub 4, driver
or module
WARNINGS
Running with several sets of arguments can impair STREAMS performance, particularly for those modules and drivers that are sending the mes-
sages.
Also be aware that may not be able to handle a large number of messages. If drivers and modules return messages to too quickly, some may
be lost.
FILES
NLS catalog for
SEE ALSO
strclean(1M), strerr(1M), strlog(7).
strace(1M)