Could not read detail log *.chk

[Former Member]

Hi.

I planed checkdb in db13 and after ending i can't read log. In db13 i get message

"Could not read detail log cdvazznq.chk". We use oracle 10.2 on Hp-ux.

is there any idea?

regards/

Denis

[Former Member · Accepted solution]

Hello Denis,

Login with ora<sid> user and create a file at /oracle/<SID>/sapcheck.

you will notice that this file doesn't have enough permissions, this is because for the incorrect umask value.

To correct it execute the following from OS level:

**Login to the database host with ora<sid>

**Add line ( <b>umask 022</b> ) into .profile & .login files

**logoff and login again with ora<sid> user and again create a file at /oracle/<SID>/sapcheck. now you will notice the file permission as correct.

**Since SAP is already running, yopu need to restart the SAP system for the change to take effect

The new files will then have enough permissions so that they can be read from SAP level

Regards,

Ammey Kesarkar

<i>'Award points for useful info'</i>

[Former Member · Accepted solution]

where are the profile & .login files?

regrads

Denis

[Former Member · Accepted solution]

Hello Denis,

Login to Database host as ora<sid> user

You will be navigated to ora<sid>'s home directory, you ought to find those files there...

execute command ls -altr | grep -i .login

excute command ls -altr | grep -i .profile

Alternatively, you can also execute a ' find ' command to search for the files

Regards,

Ammey Kesarkar

[Former Member · Accepted solution]

i find login and profile files.

how to change them?

[andreas_herzog · Accepted solution]

use an editor like VI

or...use SAM for user administration

to just change the umask, type umask 022 at the command prompt...will be lost the next time you logout ;-(

GreetZ, AH

[Former Member · Accepted solution]

I change profile and login, but after restart sap instance db13 not working

[Former Member · Accepted solution]

when i login

message appear:

Improper mask

[Former Member · Accepted solution]

is there anybody who show me how to set umask in .login/.profile files.

for example when i create:

<b>umask 022</b>

and when relogin? i see message:

Improper umask

[andreas_herzog · Accepted solution]

waht do you get when you type

> umask

??? use SAM to set umask 022...

GreetZ, AH

[Former Member · Accepted solution]

when i type umask i get 077

i don't now where set umask by SAM

what must i do in SAM? Do I run user and group? But i can't find umask there.

[Former Member · Accepted solution]

i changed umask. it doesn't work

current value of mask - 022, but db13 couldn't read log files.

is any idea?

[Former Member · Accepted solution]

Denis,

Has your problem solved?

Are you still getting value as 077 even after setting the umask value to 022?

executinf command 'umask' should return 022 as output.

Setting the value of umask to 022 in .login & .profile MUST solve your problem. I wonder why you are having problems with DB13. ( We have the umask value set as 022 on all our systems, and no problems with DB13 )

Following is for your informatoin:

umask 077 - Assigns permissions so that only you have read/write access for files, and read/write/search for directories you own. All others have no access permissions to your files or directories.

umask 022 - Assigns permissions so that only you have read/write access for files, and read/write/search for directories you own. All others have read access only to your files, and read/search access to your directories.

umask 002 - Assigns permissions so that only you and members of your group have read/write access to files, and read/write/search access to directories you own. All others have read access only to your files, and read/search to your directories

Regards,

Ammey Kesarkar

<i>'Award points for useful info'</i>

[andreas_herzog]

-> does the logfile exist on os level? check /oracle/<SID>/sapcheck

GreetZ, AH

[Former Member]

yes, it does.

i login in hp-ux with root privileges and change property's of lof file - set 777. After this working. But when i run next checkdb or update statistic i can't read new log in db13 again.

regards,

Denis

[Former Member]

this is problem with permission.

could you please check who is the owner/group of the log directory? it should be <SID>adm:sapsys

cheers,

-Sunil

[Former Member]

see this:

-rw------- 1 oradbw sapsys 19484 Apr 16 14:41 cdvazznq.chk

[andreas_herzog]

well it should be:

-rw-<b>r</b><b>r</b> 1 oradbw <b>dba</b>

so at least group/world can read the file...did you check <b>umask</b> for oradbw?

GreetZ, AH

[Former Member]

how to check umask for oradbw?