Re: Error 0403-027 The parameter list is too long?

From: <v1_0_at_my-deja.com>
Date: Thu, 14 Oct 1999 18:04:48 GMT
Message-ID: <7u55vl$vqu$1@nnrp1.deja.com>

In article <01bf1647$1b472640$03cf34aa_at_TRAY>, "Tom Ray" <tray_at_voicenet.com> wrote:
> Hi all!
> Our DBA just brought a problem to my attemtion. The error he is
> receiving is
> "0403-027 - The parameter list is too long."
> while trying to install a patch to Oracle.
> He clams that this is aa AIX issue. Can anyone shed some light on
> this problem?
>
> Thanks in advance,
>
> Tom

Simplified answer, not precisely correct, but good for basic understanding:

Most likely there are too many matching files in the directory that your DBA is copying/moving the files from. The shell that he is working in interprets the '*' as "list all the files in the directory" so a command such as 'cp *.dat /dir2' would expand into 'cp {file1.dat file2.dat file3.dat file4.dat ...} /dir2' (NOTE: the brackets are just here to simulate an expansion, not a shell scripting construct..)

If you have many files (looks like you do), this expansion exceeds what the copy command can handle, and it gives you the error. Commands other than copy operate this way to (the move command too).

Now, to fix this try one or more of the following:

1) delete files that you don't need.
2) install from a fresh directory.
3) figure out what command is causing this error, do the command file

by file by hand.
4) write a script to do the command on each file

           for filename in `ls`
           do
              if [ $filename  .some test to make sure right file. ]
              then
                    echo "Doing 'command' to $filename"
                    command $filename ....
              fi
           done

5) if this is out of an oracle script - contact them and have them

change their script.. wait... wait... wait.. wait...

-V

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 14 1999 - 13:04:48 CDT