Sponsored Content
Top Forums Shell Programming and Scripting alias to a shell script - tablespace size Post 302487749 by methyl on Thursday 13th of January 2011 11:59:31 AM
Old 01-13-2011
Some lines with obvious syntax issues. Nothing to do with alias.

Quote:
if [$# -eq 1]
(Space characters missing after [ and before ]).

if [${wild} != 0]
(Space characters missing after [ and before ])
(Wrong operator for comparing numbers).

sqlplus -s / <<eof &2>/dev/null
(The & is throwing your script into background !)

<<eof
(The << should not be there)
Probably should be:
Code:
if [ $# -eq 1 ]
if [ ${wild} -ne 0 ]
sqlplus -s / <<eof 2>/dev/null
eof

This User Gave Thanks to methyl For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get file size in c shell script?

Hi, I want to use an 'if statement' that will check if a certian file is greater in size than a certain value given by the user, but cannot get it to work. Do you have any ideas how this can be done? Your help is appreciated! (6 Replies)
Discussion started by: Dado
6 Replies

2. Shell Programming and Scripting

Bourne: How to invoke an alias from within a shell script

Bourne: How to invoke an alias from within a shell script If I type in the alias in the command line, it runs If I insert that same alias into my shell script and run the shell script, the alias is not invoked. Help please. (2 Replies)
Discussion started by: techshots
2 Replies

3. Shell Programming and Scripting

Size of an array in sh shell script

Is there a way to find out the size of an array in sh shell script? Thanks. (1 Reply)
Discussion started by: trivektor
1 Replies

4. 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

5. 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

6. 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

7. Shell Programming and Scripting

Global alias does not work in shell script

Hi Linux Set up - alias ls='ls -l' Then run script #! /bin/ksh sub() { ls } sub Is there any way to get it working. I don't want to define alias inside of the program Thank you (2 Replies)
Discussion started by: zam
2 Replies

8. Shell Programming and Scripting

tablespace monitoring script

I have prepared the below script to monitor the tablespace and alert the users whenever it reaches a threshold limit. #!/bin/sh . /home/.profile sqlplus -s $LOGON << .eof > $scripts/check_tablespace.temp set pages 0 select tablespace_name, free_percent from ( SELECT... (4 Replies)
Discussion started by: svajhala
4 Replies

9. 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

10. Shell Programming and Scripting

shell script for getting the file size

Hi can some one please help me how i can get the output i require: My text file "sample.txt" contains the text like below Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_fedora-lv_root 15G 2.6G 12G 19% /hari Filesystem Size ... (3 Replies)
Discussion started by: harimhkr
3 Replies
alias(1)						      General Commands Manual							  alias(1)

NAME
alias - Defines or displays aliases SYNOPSIS
alias [-tx] [alias-name[=string...]] Note The C shell has a built-in version of the alias command. If you are using the C shell, and want to guarantee that you are using the com- mand described here, you must specify the full path /usr/bin/alias. See the csh(1) reference page for a description of the built-in com- mand. STANDARDS
Interfaces documented on this reference page conform to industry standards as follows: alias: XCU5.0 Refer to the standards(5) reference page for more information about industry standards and associated tags. OPTIONS
[Tru64 UNIX] Sets or lists tracked aliases. [Tru64 UNIX] Sets or lists exported aliases. Note See the ksh(1) reference page for a description of tracked and exported aliases. OPERANDS
Prints the alias definition on standard output. Assigns the value of string to the alias alias-name. If no options and no operands are specified, all alias definitions are printed on standard output. DESCRIPTION
The alias utility creates or redefines alias definitions or writes the values of existing alias definitions to standard output. An alias definition provides a string value that replaces a command name when it is encountered. An alias definition affects the current shell execution environment and the execution environments of the subshells of the current shell. When used as described, the alias definition will not affect the parent process of the current shell nor any utility environment invoked by the shell. NOTES
[Tru64 UNIX] This reference page describes the creation and maintenance of aliases. See the Command Aliasing section of the ksh(1) or sh(1p) reference pages for the description of alias substitution. RESTRICTIONS
[Tru64 UNIX] If you use either the -t option or the -x option, you must use at least one alias-name or alias-name=string operand. [Tru64 UNIX] Aliasing is performed when scripts are read, not while they are executed. Therefore, for an alias to take effect, the alias definition command has to be executed before the command that references the alias is read. [Tru64 UNIX] Aliases can be used to redefine special built-in commands but cannot be used to redefine the reserved words listed in the ksh(1) reference page. EXIT STATUS
The following exit values are returned: Successful completion. One of the name operands specified did not have an alias definition, or an error occurred. EXAMPLES
Change ls to give annotated output in columns: alias ls="ls -CF" Create a simple redo command to repeat previous entries in the command history file: alias r='fc -s' Cause du to use 1K units instead of the default 512-bytes: alias du=du -k Set up nohup so that it can deal with an argument that is itself an alias name: alias nohup="nohup " ENVIRONMENT VARIABLES
The following environment variables affect the execution of alias: Provides a default value for the internationalization variables that are unset or null. If LANG is unset or null, the corresponding value from the default locale is used. If any of the internationalization vari- ables contain an invalid setting, the utility behaves as if none of the variables had been defined. If set to a non-empty string value, override the values of all the other internationalization variables. Determines the locale for the interpretation of sequences of bytes of text data as characters (for example, single-byte as opposed to multibyte characters in arguments). Determines the locale for the format and contents of diagnostic messages written to standard error. Determines the location of message catalogues for the processing of LC_MES- SAGES. SEE ALSO
Commands: csh(1), ksh(1), Bourne shell sh(1b), POSIX shell sh(1p), unalias(1) Standards: standards(5) alias(1)
All times are GMT -4. The time now is 11:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy