What errors do you get? Have you checked the logs? Probably sqlplus path is not defined and also, make sure that the ORACLE_HOME path is defined.
Define this in your script.
Code:
export ORACLE_HOME=/path/to/oracle/home
$ORACLE_HOME/bin/sqlplus ..... #rest of the stuff
Hi Guys, how do I connect to a Oracle Database from my machines running on Solaris 5 and 9. Do I need a Oracle client installed or is there any other way to connect to the Oracle Db without using the oracle client?
Any inputs will be highly appreciated. (2 Replies)
if;
sql="select username from dba_users where username = '$FromUser';"
check_FromUser=`ExecSql "$sql"`
I want to connect to Oracle database & check the users in the database, store the value in check_FromUser.
First how to connect to Oracle database from the shell script ?
Appreciate your... (4 Replies)
Hi :),
I have installed CA Autosys in my Unix system. It contains 3 ( .pm ) files namely AutoSys.pm, Job.pm, Status.pm ....... in a directory CA.
Am trying to work with autosys for first time. Please guide in how do i connect autosys to oracle DB in my system. My oracle db name is XE..
Thank... (0 Replies)
Hi :),
Am new to work with Autosys. I have Oracle installed in my computer. Please guide me how to configure and connect autosys with oracle database.
thank you..!:) (0 Replies)
Hi,
I am trying to connect to oracle database (9.2.0.7.0) through Sun solaris.
But I am unable to do so.
The content of my script is as follows:
Shell Sript:
RESULT=`$ORACLE_HOME/bin/sqlplus schema/'pwd'@db << EOF
set echo on;
set feedback on;
@/home/count/qry.sql`
echo... (10 Replies)
Hi,
I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following:
1. Connect to oracle database hosted on a different server
2. fire a query on the oracle db
3. store the output in a variable
4. use this variable for further logic... (1 Reply)
Hi,
I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following:
1. Connect to oracle database hosted on a different server
2. fire a query on the oracle db
3. store the output in a variable
4. use this variable for further logic... (26 Replies)
Hai
i want to connect to oracle database from user input and create a view.
${ECHO} "Debut Creating View"
${ECHO} "Please Enter the User Name:"
read user_name
${ECHO} "Please Enter the Connection String:"
read con_string
${ECHO} "Please Enter the Password:"
read pwd... (3 Replies)
I have a table called CLARIFICATION in one of my schema in Oracle Data Base. I have to connect to oracle Data Base from Unix and compare the one of the column(Exec_Date) in CLARIFICATION table with Sysdate.If Exec_Date = Sysdate go head and run rest of the script otherwise exit out with out... (2 Replies)
Hi guys, long time no typing :D
I have problems when I try to connect to Oracle database from SQL Developer which is located on my Windows box.
Server is running Solaris 11/11 and Oracle 11 enterprise. I can log in locally with sys account to database, start it up and shut it down but when I... (2 Replies)
Discussion started by: solaris_user
2 Replies
LEARN ABOUT DEBIAN
ttyrec
TTYREC(1) General Commands Manual TTYREC(1)NAME
ttyrec - a tty recorder
SYNOPSIS
ttyrec [-a] [-u] [-e command] [file]
DESCRIPTION
Ttyrec is a tty recorder. It is a derivative of script(1) command for recording timing information with microsecond accuracy as well. It
can record emacs -nw, vi, lynx, or any programs running on tty.
Ttyrec invokes a shell and records the session until the shell exits. Recorded data can be played back with ttyplay(1). If the argument
file is given, the session will be recorded in that file. Otherwise, ttyrecord is used as default.
OPTIONS -a Append the output to file or ttyrecord, rather than overwriting it.
-u With this option, ttyrec automatically calls uudecode(1) and saves its output when uuencoded data appear on the session. It allow
you to transfer files from remote host. You can call ttyrec with this option, login to the remote host and invoke uuencode(1) on it
for the file you want to transfer.
-e command
Invoke command when ttyrec starts.
ENVIRONMENT
SHELL If the variable SHELL exists, the shell forked by ttyrec will be that shell. If it's not set, the Bourne shell is assumed. (Most
shells set this variable automatically).
SEE ALSO script(1), ttyplay(1), ttytime(1), uuencode(1), uudecode(1)TTYREC(1)