dear sir

i give oracle permission to folder this way

[root@srvr1 ~]# chown -R oracleinstall /oracle/*
[root@srvr1 ~]# chmod -R 775 /oracle/*

so what it did each every file, it attached filename* (asteric * in last)

now each file shown under /oracle directory looks with *

can someone give me solution to avoid this

or return back

regards

Executable permissions have been given to all files and directories under /oracle, so it is normal that every file is marked like that. The reason is that most likely the ls command for root is aliased to something containing option -F (please see man ls for details). If this is the case you can simply change the alias to avoid the marks, however I feel like changing permissions like that is not a good idea: you don't really need every file in a database to be executable, don't you?!

1 members found this post helpful.

no i am afraid as i did this by mistake and expected result was not there...

since some folder i copy from window machine to /oracle folder where i used root user via winscp

then i give bulk permission oracle user to take control like scripts, database, and oracle related files. when i notice is shown asterick with every file attached.

even when i try mv filename*.sh filename.sh, it give me error says same file

plz give me more idea explanation of this highly apprecaited
regards

Well... the asterisks should not really be part of the file names. They will be shown from the ls command if the -F option is in action and the files have the executable permission. To confirm, please show us some lines of the output from:
followed by the same lines from the following:
as you can see, the second command is the same, except for the backslash in front of ls: this forces the command to be executed without aliases (that is a plain ls without colors or other stuff).

An historical note: the -F option of the ls command was really useful when terminals were "black & white": the only way to distinguish files from directories at a first sight using a plain ls was by means of a symbol appended at the end of the file/directory name. Hence you see a slash for directories, an asterisk for executable files, a @ for links, and so on. This symbol is only the result (output) of ls and it doesn't affect the real name of the files.

Now let's see if this is actually your issue, looking at the output of the suggested commands.