Sponsored Content
Full Discussion: tablespace monitoring script
Top Forums Shell Programming and Scripting tablespace monitoring script Post 302491014 by svajhala on Wednesday 26th of January 2011 12:05:22 PM
Old 01-26-2011
Quote:
Originally Posted by scottn
Hi.

What is the value of "scripts"?

If it's not set, the file will go into the root directory, and the cd will go to your home directory.

i.e
Code:
$scripts/check_tablespace.temp

becomes
Code:
/check_tablespace.temp

and
Code:
cd $scripts

becomes
Code:
cd

Thanks for the reply. The value of $scripts is set at .profile which i am sourcing it during the initial part of the script

Code:
. /home/.profile

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script to find the tablespace size in oracle.

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

Need help in a shell script to edit a tablespace creation script.

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

error in script path for tablespace usage

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

Monitoring script

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

alias to a shell script - tablespace size

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

Script to check Oracle tablespace

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

ldapsearch in monitoring script without bind password written in script

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

Help with a monitoring script

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

Error in Scripting to monitor tablespace in Oracle DB

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

Tablespace growth trend

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
Locale::Script(3pm)					 Perl Programmers Reference Guide				       Locale::Script(3pm)

NAME
Locale::Script - ISO codes for script identification (ISO 15924) SYNOPSIS
use Locale::Script; use Locale::Constants; $script = code2script('ph'); # 'Phoenician' $code = script2code('Tibetan'); # 'bo' $code3 = script2code('Tibetan', LOCALE_CODE_ALPHA_3); # 'bod' $codeN = script2code('Tibetan', LOCALE_CODE_ALPHA_NUMERIC); # 330 @codes = all_script_codes(); @scripts = all_script_names(); DESCRIPTION
The "Locale::Script" module provides access to the ISO codes for identifying scripts, as defined in ISO 15924. For example, Egyptian hieroglyphs are denoted by the two-letter code 'eg', the three-letter code 'egy', and the numeric code 050. You can either access the codes via the conversion routines (described below), or with the two functions which return lists of all script codes or all script names. There are three different code sets you can use for identifying scripts: alpha-2 Two letter codes, such as 'bo' for Tibetan. This code set is identified with the symbol "LOCALE_CODE_ALPHA_2". alpha-3 Three letter codes, such as 'ell' for Greek. This code set is identified with the symbol "LOCALE_CODE_ALPHA_3". numeric Numeric codes, such as 410 for Hiragana. This code set is identified with the symbol "LOCALE_CODE_NUMERIC". All of the routines take an optional additional argument which specifies the code set to use. If not specified, it defaults to the two- letter codes. This is partly for backwards compatibility (previous versions of Locale modules only supported the alpha-2 codes), and partly because they are the most widely used codes. The alpha-2 and alpha-3 codes are not case-dependent, so you can use 'BO', 'Bo', 'bO' or 'bo' for Tibetan. When a code is returned by one of the functions in this module, it will always be lower-case. SPECIAL CODES The standard defines various special codes. o The standard reserves codes in the ranges qa - qt, qaa - qat, and 900 - 919, for private use. o zx, zxx, and 997, are the codes for unwritten languages. o zy, zyy, and 998, are the codes for an undetermined script. o zz, zzz, and 999, are the codes for an uncoded script. The private codes are not recognised by Locale::Script, but the others are. CONVERSION ROUTINES
There are three conversion routines: "code2script()", "script2code()", and "script_code2code()". code2script( CODE, [ CODESET ] ) This function takes a script code and returns a string which contains the name of the script identified. If the code is not a valid script code, as defined by ISO 15924, then "undef" will be returned: $script = code2script('cy'); # Cyrillic script2code( STRING, [ CODESET ] ) This function takes a script name and returns the corresponding script code, if such exists. If the argument could not be identified as a script name, then "undef" will be returned: $code = script2code('Gothic', LOCALE_CODE_ALPHA_3); # $code will now be 'gth' The case of the script name is not important. See the section "KNOWN BUGS AND LIMITATIONS" below. script_code2code( CODE, CODESET, CODESET ) This function takes a script code from one code set, and returns the corresponding code from another code set. $alpha2 = script_code2code('jwi', LOCALE_CODE_ALPHA_3 => LOCALE_CODE_ALPHA_2); # $alpha2 will now be 'jw' (Javanese) If the code passed is not a valid script code in the first code set, or if there isn't a code for the corresponding script in the second code set, then "undef" will be returned. QUERY ROUTINES
There are two function which can be used to obtain a list of all codes, or all script names: "all_script_codes ( [ CODESET ] )" Returns a list of all two-letter script codes. The codes are guaranteed to be all lower-case, and not in any particular order. "all_script_names ( [ CODESET ] )" Returns a list of all script names for which there is a corresponding script code in the specified code set. The names are capitalised, and not returned in any particular order. EXAMPLES
The following example illustrates use of the "code2script()" function. The user is prompted for a script code, and then told the corresponding script name: $| = 1; # turn off buffering print "Enter script code: "; chop($code = <STDIN>); $script = code2script($code, LOCALE_CODE_ALPHA_2); if (defined $script) { print "$code = $script "; } else { print "'$code' is not a valid script code! "; } KNOWN BUGS AND LIMITATIONS
o When using "script2code()", the script name must currently appear exactly as it does in the source of the module. For example, script2code('Egyptian hieroglyphs') will return eg, as expected. But the following will all return "undef": script2code('hieroglyphs') script2code('Egyptian Hieroglypics') If there's need for it, a future version could have variants for script names. o In the current implementation, all data is read in when the module is loaded, and then held in memory. A lazy implementation would be more memory friendly. SEE ALSO
Locale::Language ISO two letter codes for identification of language (ISO 639). Locale::Currency ISO three letter codes for identification of currencies and funds (ISO 4217). Locale::Country ISO three letter codes for identification of countries (ISO 3166) ISO 15924 The ISO standard which defines these codes. http://www.evertype.com/standards/iso15924/ Home page for ISO 15924. AUTHOR
Neil Bowers <neil@bowers.com> COPYRIGHT
Copyright (c) 2002-2004 Neil Bowers. This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.12.5 2012-11-03 Locale::Script(3pm)
All times are GMT -4. The time now is 05:28 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy