SQLoader & SQLplus error ?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need Script to ZIP/SAVE & then DELETE Log file & send a mail conformation for any error

ENVIROMENT Linux: RHEL 6.4 Log Path: /usr/iplanet/servers/https-company/logs Log Format: user.log.03-15-2015 I have log4j log rotation enabled rotating files on a daily basis. The rotated logs are NOT compressed & are taking up too much space. I need a script that will run daily that...

2. Shell Programming and Scripting

Sqlplus error - sqlplus -s <login/password@dbname> : No such file or directory

i am using bash shell Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127. IFS="," declare -a Arr=($Variable1); SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE} echo "set head off ; " > ${SQLCMD} echo "set PAGESIZE 0 ;" >> ${SQLCMD}...

3. Shell Programming and Scripting

SQLPLUS Error Capturing

This is my .sh file sqlplus -s my_user/my_pswd@mydb @my_sql.sql ret_code=$? if then echo "return code is $ret_code " echo "Failed" else echo "return code is $ret_code " echo "Success" fi ===================================================== and my_sql.sql is whenever...

4. Shell Programming and Scripting

sqlplus error output to different error log file

HELLO, I am using such a command to write oracle sqlplus query result to text file: sqlplus -S xxx/xxx@xxxxxxx @\tmp\2.sql>\tmp\123.txt Is it possible to script that: If command succesfull write in \tmp\log.txt: timestamp and "succeded" and create 123.txt with results else If error...

5. Linux

Kernal panic error& setuproot:error mounting /proc&/sys

Hi all, I am new to redhat/fedora linux. In fedora linux 6,we created one file system(hda3 - /fs). in this mount poing we were installed mounta vista os. while booting we are getting below error messages. 1) Booting 'mountaVisat(2.6.18_pro 500_pc_target-x86_586 smp)' root(hd0,1)...

6. Shell Programming and Scripting

error running sqlplus from shell file

I am running a shell file following script on bash shell in solaris 10 ( echo abc@orcl echo abc echo "set feedback off" echo "truncate table SIndexDataTypeHst1_changes;" ) | sqlplus -s but getting the following error ERROR: ORA-01005: null password given; logon denied ...

7. Shell Programming and Scripting

SQLPLUS error

I am running a script that invokes SQLPLUS. During the execution I get the following: SQL*Plus: Release 9.2.0.8.0 - Production on Mon Jun 11 16:12:50 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 -...

8. Shell Programming and Scripting

shell script & sqlplus "plzz help"

hi friends, i m tryin to load data from one set of table to other i have sql procedure al ready for it..! i m going to load the procedure only if data in one of my table for example table "landing " have 10 records each attribute of this table is file_name status date ...

9. UNIX for Dummies Questions & Answers

error connecting to sqlplus

Hi, I wrote a shell script to call oracle procedure. But when i am trying to connet sqlplus with the fallowing statement It is giving me error " callproce.sh : sqlplus: not found". What could be the problem. sqlplus -s $CONNECT_STRING >$LOGFILE <<!! thank u all papachi

10. Shell Programming and Scripting

sqlplus -s error capture

Hi folks a wee problem that requires some help. I am writing a script that allows me to automate the changing of a password in sqlplus the problem i encounter is that the code contains a case statement that allows the helpdesk to select whether to allow or deny access by switching the...

LEARN ABOUT OSF1

pthread_attr_setinheritsched

pthread_attr_setinheritsched(3) 			     Library Functions Manual				   pthread_attr_setinheritsched(3)

NAME

       pthread_attr_setinheritsched - Changes the inherit scheduling attribute of the specified thread attributes object.

LIBRARY

       DECthreads POSIX 1003.1c Library (libpthread.so)

SYNOPSIS

       #include <pthread.h>

       int pthread_attr_setinheritsched(
		     pthread_attr_t  *attr,
		     int	     inheritsched);

STANDARDS

       Interfaces documented on this reference page conform to industry standards as follows:

       IEEE Std 1003.1c-1995, POSIX System Application Program Interface

PARAMETERS

       Thread attributes object whose inherit scheduling attribute is to be modified.  New value for the inherit scheduling attribute.	Valid val-
       ues are as follows: The created thread inherits	the  scheduling  policy  and  associated  scheduling  attributes  of  the  thread  calling
       pthread_create(3).   Any scheduling attributes in the attributes object specified by the pthread_create(3) attr argument are ignored during
       thread creation.  This is the default value.  The scheduling policy and associated scheduling attributes of the created thread are  set	to
       the corresponding values from the attribute object specified by the pthread_create(3) attr argument.

DESCRIPTION

       This routine changes the inherit scheduling attribute of the thread attributes object specified by the attr argument.  The inherit schedul-
       ing attribute specifies whether a thread created using the specified attributes object inherits the scheduling attributes of  the  creating
       thread, or uses the scheduling attributes stored in the attributes object specified by the pthread_create(3) attr argument.

       The   first   thread   in   an	application   has   a  scheduling  policy  of  SCHED_OTHER.   See  the	pthread_attr_setschedparam(3)  and
       pthread_attr_setschedpolicy(3) routines for more information on valid priority values and valid scheduling policy values, respectively.

       Inheriting scheduling attributes (instead of using the scheduling attributes stored in the attributes object) is useful when  a	thread	is
       creating  several  helper  threads--that  is, threads that are intended to work closely with the creating thread to cooperatively solve the
       same problem.  For example, inherited scheduling attributes ensure that helper threads created in a sort routine execute with the same pri-
       ority as the calling thread.

RETURN VALUES

       If  an  error condition occurs, this routine returns an integer value indicating the type of error.  Possible return values are as follows:
       Successful completion.  The value specified by the attr argument is not a valid thread attributes object, or the inheritsched argument con-
       tains an invalid value.	An attempt was made to set the attribute to an unsupported value.

ERRORS

       None

RELATED INFORMATION

       Functions:    pthread_attr_init(3),    pthread_attr_getinheritsched(3),	  pthread_attr_setschedpolicy(3),   pthread_attr_setschedparam(3),
       pthread_create(3)

       Manuals: Guide to DECthreads and Programmer's Guide

       delim off

														   pthread_attr_setinheritsched(3)

AIX