whether i should use csh or not, but 1 thing is sure that by removing ` sign from sqlplus, it has stopped writting in the output file.
Code:
sqlplus -s $ORACLE_USER/$ORACLE_PASS@$ORACLE_SID << EOF > sql_output.txt
select count(*) from bravo_statistics
where trunc(time_stamp)=trunc(sysdate)
and description in ('BEGIN NIT','END MR');
EOF
If you're running this through cron you need to ensure that your environment is properly configured (usually by sourcing your ~/.profile and setting up your Oracle environment, etc.).
I've already given you my suggestion: Stop using the C-Shell.
Hi,
Unable to make tape backup, please help.
/opt/ignite/bin/make_tape_recovery -a /dev/rmt/?mn -I -v -m tar -x inc_entire=vg00
* Creating local directories for configuration files and archive.
======= 04/25/16 16:28:08 IST Started /opt/ignite/bin/make_tape_recovery.
(Mon... (4 Replies)
I need to add a printer with Ethernet to my local network. The default IP address in the printer is 0.0.0.0 and I need to change it to a 192.168.0.x address. I have previously temporarily changed the IP address of a computer (with ifconfig) to an address similar to the new device and changed the... (8 Replies)
Hi All,
Could anyone please help to resolve the below problem.
I installed RHEL5.5 in my desktop.But when i try to activate the ethernet connection then it gives me the error.
I spent 2 days for the above and go through with several suggestion found by googling. But no luck.
... (0 Replies)
Hello,
i am using Solaris 10, The sar running in my system might be corrupted, but not sure why as there has been no updates to it ( to the best of my knowledge) and it was working fine until few days back. If i try to get sar reports using sar -o <filename> 60 180
there is no error but the... (2 Replies)
I'm trying to install FreeBSD 7.0 from CDs I made a few months ago on a brand new system with parts I just got in from NewEgg. I select the default option from the Boot Loader and it goes into the device probe. Several devices are recognized, but then it freezes at:
mskc0: <Marvell Yukon... (2 Replies)
/dev/rmt/0: No such device or address
I get this when I do a "mt -f /dev/rmt/0 rewind"
This is on a Solaris 7 system.
I tried
devfsadm -c tape
and
drvconfig ; tape
and both didn't work.
Help please....... :confused: (4 Replies)
I encoutered the error "stty: : No such device or address" in the korn shell script log. I added STTY EARSE ^H in profile. why iam i getting that error in Korn shell
Thanks
nandinisagar (6 Replies)
08-07-2013
