I'm writting a shell script and at the begining I login to sqlplus by
sqlplus -l user_name/password@instance
what I would like is to check if the database is down or not , and if the database has started moved to the next step else sleep for a certain time and then check again .
I know how to do the sleep part, but I don't know how to check if the database is not down.
[...]
For quick and "dirty" check you can use something like this:
i would like to learn how to integrate my little knowledge in shell scripting with sqlplus. well... i know how to make basic query in sqlplus but i dont know how i can integrate it with shell script. can someone :) please help me on this? can you give me some basic example on how to do this kind of... (10 Replies)
Hi All,
I am executing the following code :-
sqlplus -s ${DATABASE_USER} |&
print -p -- 'set feed off pause off pages 0 head off veri off line 500'
print -p -- 'set term off time off serveroutput on size 1000000'
print -p -- "set sqlprompt ''"
print -p -- "SELECT run_command from... (2 Replies)
Hi,
I want to write a script, in which I will connect to sqlplus and do a quary and then exit
sqlplus user/pwd@database
select count(*) from table
exit.
and write the result in a log file.
How to write it ?
Many thanks before. (1 Reply)
hi,
I have this basic query.
I have created a new user on unix.
I have given home directory and permission through chmod to create directory stucture.
Now need to connect sqlplus. What permissions should we give, so that this works?
Any help is appreciated.
Thanks,
Neha (1 Reply)
Hi,
I am trying to execute the update statment in shell sqlplus.But nothing prompts.if i do ctrl+c i got the below error.
SQL> update table set enabled='N' where type_code='xx';
^C update table set enabled='N' where type_code='xx'
*
ERROR at line 1:
ORA-01013: user requested... (2 Replies)
Hi,
I have been trying to connect to sqlplus the same way I used to do in my earlier company but I get these error messages , please suggest way out -
user name - xyzuser
schema name - xyzschema
$ sqlplus xyzuser@xyzschema
ksh: sqlplus: not found.
$ sqlplus -s xyzuser@xyzschema... (5 Replies)
friends because when calling a sqlplus from a shell it brings me the following message
sqlplus -s $BDDUSER/$BDDPASS@$BDDHOST @$DIR_SQL/prueba.sql
echo "bandera 3 " $?
STATUS=$?
if ;then
echo "bandera 4 " $?
#log_info "La ejecucion de... (1 Reply)
Discussion started by: tricampeon81
1 Replies
LEARN ABOUT SUNOS
sleep
sleep(1) User Commands sleep(1)NAME
sleep - suspend execution for an interval
SYNOPSIS
sleep time
DESCRIPTION
The sleep utility will suspend execution for at least the integral number of seconds specified by the time operand.
OPERANDS
The following operands are supported:
time A non-negative decimal integer specifying the number of seconds for which to suspend execution.
EXAMPLES
Example 1: Suspending command execution for a time
To execute a command after a certain amount of time:
example% (sleep 105; command)&
Example 2: Executing a command every so often
example% while true
do
command
sleep 37
done
ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables that affect the execution of sleep: LANG, LC_ALL, LC_CTYPE, LC_MES-
SAGES, and NLSPATH.
EXIT STATUS
The following exit values are returned:
0 The execution was successfully suspended for at least time seconds, or a SIGALRM signal was received (see NOTES).
>0 An error has occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
|Interface Stability |Standard |
+-----------------------------+-----------------------------+
SEE ALSO wait(1), alarm(2), sleep(3C), wait(3UCB), attributes(5), environ(5), standards(5)NOTES
If the sleep utility receives a SIGALRM signal, one of the following actions will be taken:
o Terminate normally with a zero exit status.
o Effectively ignore the signal.
The sleep utility will take the standard action for all other signals.
SunOS 5.10 1 Feb 1995 sleep(1)