Hi veeresh_15,
The "complete" script you provided shows us why you are having problems using getopts, but it doesn't explain what you're really trying to do. You have shown us four sample command lines used to test your option handling capabilities, but to understand how to best help you, what we really need is the Synopsis lines from the man page for your utility (or better yet, the complete man page) so we can understand what options (with and without option arguments) and what operands your script will need to process for your utility.

It is unusual to need an option for "defaults". If you're setting up a utility to create databases, what you're describing as defaults (the database ID, version, and type) don't seem like defaults; they seem like something that would be required to set up any database and they would be different for each database you create. If that is the case here, these three items should be mandatory operands; not options.

I can easily see having default values for database block size and character sets that would apply to most databases you create. And, having options (with option arguments) to override those defaults is perfectly reasonable.

So, if I have guessed correctly, your Synopsis would be something like:

Code:

createdb [-b block_size] [-c character_set] sid version type

and your code should be something more like:

Code:

#!/bin/ksh
# createdb [-b block_size] [-c character_set] sid version type

# Initialize variables
BLK_SIZE=4096
CHAR_SET="AL32UTF8"
IAm=${0##*/}
USAGE='Usage: %s [-b block_size] [-c character_set] sid version type\n'

# Process options:
while getopts "b:c:h" opt
do	case $opt in
	(b)	BLK_SIZE="$OPTARG";;

	(c)	CHAR_SET="$OPTARG";;

	(h)	printf "$USAGE" "$IAm"
		exit 0;;

	(?)	printf "$USAGE" "$IAm" >&2
		exit 1;;
	esac
done
shift $((OPTIND - 1))

# Verify operands:
if [ $# -ne 3 ]
then	printf '%s: 3 operands are required, %d found.\n' "$IAm" >&2
	printf "$USAGE" "$IAm" >&2
	exit 2
fi
ORACLE_SID="$1"
ORACLE_VER="$2"
ENV_TYPE="$3"

# Create the database:
printf 'Create database with these attributes:
	block size:	%d
	character set:	%s
	SID:		%s
	version:	%s
	type:		%s
' "$BLK_SIZE" "$CHAR_SET" "$ORACLE_SID" "$ORACLE_VER" "$ENV_TYPE"
# Add code to acutally create the database here...

And, then you could successfully invoke it with command lines like:

Code:

createdb -b2048 MyDatabase 1 MyType
createdb -c USASCII MyDatabase 1 MyType
createdb -b 20480 -c"UTF-8" MyDatabase 1 MyType

PS
If you're using a 1993 or later version of ksh, you'll get bad option diagnostics consistent with the rest of the diagnostics produced by the above script if you change:

Code:

while getopts "b:c:h" opt

to:

Code:

while getopts -a "$IAm" "b:c:h" opt