I always call sqlplus command in the following way and it has always worked.
Also, by seeing your error it is obvious that you are trying to connect as sys user without having the correct privileges to do so.
As far as possible, avoid connecting as sys user in scripts. Try using system user instead.
I have a script which connects to different database servers using sqlplus. Is there a way by which I can run a shell command on that host from sqlplus?
I know about 'host' command but it runs script on the local machine where the original script is running. Is there a way to run command on the... (9 Replies)
Hi,
Currently i have a .sql file 1.sql.
I need to pass that as a parameter through a shell script to the sqlplus inside the same shell script.
How I should I do.can anyone help me pls.
I have an req where I need to send the .sql file and the place where the script has to create a .csv... (9 Replies)
hi,
I am using a shell script from where i will be conecting to sqlplus..
i am having a problem in passing a variable to sqlplus query..
i will be assigning the variable in the unix environment..whenever i am trying to pass a variable having the contents greater than 2500 characters, i am... (3 Replies)
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... (2 Replies)
cron job not running the sqlplus command in shell script but the shell script works fine from command line..
Cronjob:
5 * * * * /home/dreg/script.sh
script.sh:
#!/bin/ksh
/oracle/u000/app/oracle/product/10204/GEN/bin/sqlplus -s <user>/<pass>@<sid/home/dreg/sqlscript.sh
... (18 Replies)
Hi all,
I am using the below given sqlplus command in my unix script to invoke a stored procedure which returns a value .It works fine.
RET_CODE=$(/opt/oracle/product/10.2.0.4.CL/bin/sqlplus -S $USER/$PASSWD@$DB_NAME <<EOF
EXEC MY_PKG.MY_SP (:COUNT);
PRINT COUNT;
commit;
... (6 Replies)
Hi all,
on AIX 6.1 I want to run the following but for 5 DB. How should I do that ? Using FOR, WHILE ???? How ?
export ORACLE_SID=DB1
sqlplus / as sysdba << EOF
whenever sqlerror exit sql.sqlcode;
whenever oserror exit FAILURE
set define off
set head off
set feedback off
set echo off... (1 Reply)
I am using following code to connect to oracle database from solaris shell script. which will try thrice to connect the database ...at the 4rth atempt it will exir=t.
count=0
while ; do
sqlplus -s $usrname/$password@dbSID <<-EOF | tee $logfile
WHENEVER OSERROR EXIT 9;
WHENEVER SQLERROR... (4 Replies)
Hello All,
Good Afternoon.
I am new to this platform and I need one small help regarding running a SQL file from Bat file. Below is what I am doing,
1. I placed the below command in one Bat file.
start putty.exe -ssh user@host -pw pwd -m C:\2.txt
2. In 2.txt, I have below command.
... (3 Replies)
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}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
LEARN ABOUT V7
login
LOGIN(1) General Commands Manual LOGIN(1)NAME
login - sign on
SYNOPSIS
login [ username ]
DESCRIPTION
The login command is used when a user initially signs on, or it may be used at any time to change from one user to another. The latter
case is the one summarized above and described here. See `How to Get Started' for how to dial up initially.
If login is invoked without an argument, it asks for a user name, and, if appropriate, a password. Echoing is turned off (if possible)
during the typing of the password, so it will not appear on the written record of the session.
After a successful login, accounting files are updated and the user is informed of the existence of .mail and message-of-the-day files.
Login initializes the user and group IDs and the working directory, then executes a command interpreter (usually sh(1)) according to speci-
fications found in a password file. Argument 0 of the command interpreter is `-sh.
Login is recognized by sh(1) and executed directly (without forking).
FILES
/etc/utmp accounting
/usr/adm/wtmp accounting
/usr/mail/* mail
/etc/motd message-of-the-day
/etc/passwd password file
SEE ALSO init(8), newgrp(1), getty(8), mail(1), passwd(1), passwd(5)DIAGNOSTICS
`Login incorrect,' if the name or the password is bad.
`No Shell', `cannot open password file', `no directory': consult a programming counselor.
LOGIN(1)