01-26-2011
Yes thats a good catch. I removed the dot (.eof) from eof and added ';' in the if statement. It worked.
Thanks much
Sam
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I need to execute a script to find the tablespace size in oracle.But i get an error.:confused:
Script Executed:-
#!/bin/ksh
ORACLE_SID= oracelinstance
ORACLE_HOME= oracle path
PATH=$ORACLE_HOME/bin
export ORACLE_SID ORACLE_HOME PATH
sqlplus... (4 Replies)
Discussion started by: vighna
4 Replies
2. Shell Programming and Scripting
Hi,
CREATE TABLESPACE aps_blob_large01
DATAFILE '/c2r6u13/u03/oradata/qnoldv01/aps_blob_large0101.dbf' SIZE X 270532608
REUSE
DEFAULT STORAGE (INITIAL 134217728 NEXT... (2 Replies)
Discussion started by: rparavastu
2 Replies
3. Shell Programming and Scripting
Hi ,
I am trying to run this script in crontab but I get errors. When I run it explicitly like ./monitor_tblsp from another location then it runs fine . I am messing somewhere with paths but I don't know where and how . Please help .
Here is the error part
./monitor_tblsp: touch: not... (2 Replies)
Discussion started by: capri_drm
2 Replies
4. Shell Programming and Scripting
Hi,
I want to write script that monitors particular ports in a server.
I completed the script but.... If the server is restarted i need manually start the script..
Is there any way i can make the script start by it self after the server reboot........
Thanks,
Firestar (4 Replies)
Discussion started by: firestar
4 Replies
5. Shell Programming and Scripting
I have developed the following shell script. The idea was to create an alias to execute it and return the tablespaces and their sizes from an oracle database. When I execute is via the alias, I have issues.
So, here is the script first:
> cat ts_size.sh
#!/bin/ksh
xwhere=" "
xwild=" "... (8 Replies)
Discussion started by: desibabu
8 Replies
6. Shell Programming and Scripting
I'm new to unix script, and I need to check the tablespaces daily, here is the script(quite simple), but it does not work. Did I missed something ?
Please guide me, Many thanks !
#!/bin/sh
echo "ORA TABLEASPACE:"
sqlplus system/oracle as sysdba;
set pagesize 9999;
set linesize 132;
... (5 Replies)
Discussion started by: dehetoxic
5 Replies
7. UNIX for Advanced & Expert Users
Hi
I do a very simple monitoring of our OpenLDAP (runs in cronjob and generate alerts if unsuccessfull)
$ ldapsearch -h hostname.domain -D "cn=monitor_user,ou=People,dc=organisation" -w "password" -b "dc=organisation" -x "(&(cn=monitor_user)(ou=People))" dn | grep -v version
dn:... (4 Replies)
Discussion started by: slashdotweenie
4 Replies
8. Shell Programming and Scripting
I currently have a shellscript to check the size of a filesystem and email me if the size is over a certain percentage (80%). I have this script on crontab and executes the shell every 10 mins.
I have the above in place on 8 servers. It so happens that a file system on one of the servers is... (1 Reply)
Discussion started by: goddevil
1 Replies
9. Shell Programming and Scripting
Buddies, I am writing the below script 'tab.sh' to monitor the tablespaces in Database:-
-------------------------------
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=orcl
sqlplus system/oracle as sysdba <<EOF
spool... (5 Replies)
Discussion started by: sandip250382
5 Replies
10. Programming
Hi experts,
I have the below details with me.How to calculate the tablespace growth between two dates.
sample data(have data upto 1 year):
INSTANCE_NAME DATE TABLESPACE_NAME MB_ALLOC MB_FREE MB_USED PCT_FREE PCT_USED MAX
---------------- ---------... (1 Reply)
Discussion started by: navsan420
1 Replies
LEARN ABOUT DEBIAN
zzip_disk_feof
ZZIP_DISK_FOPEN(3) zziplib Function List ZZIP_DISK_FOPEN(3)
NAME
zzip_disk_fopen, zzip_disk_entry_fopen, zzip_disk_fread, zzip_disk_fclose, zzip_disk_feof - openening a file part wrapped within a
(mmapped) zip archive
SYNOPSIS
#include <zzip/mmapped.h>
zzip__new__ ZZIP_DISK_FILE * zzip_disk_fopen(( ZZIP_DISK * disk, char *filename));
zzip__new__ ZZIP_DISK_FILE * zzip_disk_entry_fopen(( ZZIP_DISK * disk, ZZIP_DISK_ENTRY *entry));
zzip_size_t zzip_disk_fread((void *ptr, zzip_size_t sized, zzip_size_t nmemb, ZZIP_DISK_FILE *file));
int zzip_disk_fclose((ZZIP_DISK_FILE * file));
int zzip_disk_feof((ZZIP_DISK_FILE * file));
DESCRIPTION
The zzip_disk_fopen function opens a file found by name, so it does a search into the zip central directory with zzip_disk_findfile and
whatever is found first is given to zzip_disk_entry_fopen
the ZZIP_DISK_FILE* is rather simple in just encapsulating the arguments given to the zzip_disk_entry_fopen function plus a zlib deflate
buffer. Note that the ZZIP_DISK pointer does already contain the full mmapped file area of a zip disk, so open()ing a file part within that
area happens to be a lookup of its bounds and encoding. That information is memorized on the ZZIP_DISK_FILE so that subsequent _read()
operations will be able to get the next data portion or return an eof condition for that file part wrapped in the zip archive.
The zzip_disk_fread function reads more bytes into the output buffer specified as arguments. The return value is null on eof or error, the
stdio-like interface can not distinguish between these so you need to check with zzip_disk_feof for the difference.
The zzip_disk_fclose function releases any zlib decoder info needed for decompression and dumps the ZZIP_DISK_FILE* then.
The zzip_disk_feof function allows to distinguish an error from an eof condition. Actually, if we found an error but we did already reach
eof then we just keep on saying that it was an eof, so the app can just continue.
AUTHOR
o Guido Draheim <guidod@gmx.de>
COPYRIGHT
Copyright (c) 2003,2004,2006 Guido Draheim All rights reserved, use under the restrictions of the Lesser GNU General Public License or
alternatively the restrictions of the Mozilla Public License 1.1
zziplib 0.13.56 ZZIP_DISK_FOPEN(3)