Running Update Statistic--getting below error message

[Former Member]

Hi All,

I am getting below error message when i run the update statistic in QAS system...DEV and PRD system no issues.We are having ECC 6.0 using oracle ( Linux).

BR0881I Collecting statistics for table SAPSR3.TBTCS with method/sample C ...

BR0280I BRCONNECT time stamp: 2010-06-08 13.25.50

BR0301E SQL error -1114 at location stats_tab_collect-20, SQL statement:

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"TBTCS"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'

ORA-01114: IO error writing block to file 255 (block # 72202)

ORA-27041: unable to open file

Linux-x86_64 Error: 13: Permission denied

Additional information: 3

ORA-06512: at "SYS.DBMS_STATS", line 13437

ORA-06512: at "SYS.DBMS_STATS", line 13457

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for table SAPSR3.TBTCS

Can some one help me out for the solution.

Thanks.

Vel.

[Former Member · Accepted solution]

Hi Mark,

SAP is system is running, Users are logged in and able to their activity. Database check i was able to do, no error messages. Brbackup and Brarchive working no errors, only update statistic having issues...

Thanks.

Vel.

[Former Member · Accepted solution]

Perhaps this is being caused by PSAPTEMP, that it cannot add data to this tablespace.

Can you check if your filesystem is full during this message?

Check note 548221 - Temporary Files are created as sparse files

Have you modified anything in the system? Tablespaces, kernel upgrade, etc.?

Kind regards,

Mark

[Former Member]

Hi Mark,

Issue is solved, As u mentioned about the authorization for the psaptemp data file.System was having root, once we chanegd back to ora<sid> dbd...every thing went fine....

Thanks for helpful information u provided.

Thanks

Vel.

[Former Member]

Hi Mark,

Last week we update the tablespace for psapsr3, apart from that no update to the system wise. We have enough space for data around 350 GB..(u01,u02 and u03)

Pos. Tablespace Files/AuExt. Total[KB] Used[%] Free[KB] MaxSize[KB]

1 PSAPTEMP 1/1 2048000 0.00 2048000 10240000

Thanks.

Vel.

[volker_borowski2]

Hi,

255 as a byte-edge sounds like some max...limit beinig hit.

do you run brconnect as sidadm (DB13) or orasid ?

Please check "ulimit -a" for the user involved.

Please check initSID.ora for the value of db_files.

Linx Kernel settings ok for maximum number of open files ?

Volker

[Former Member]

Hi Mark,

Yes, I did run the update statistic again and having the same issue...

Thanks your quick response.

Vel.

[Former Member]

Weird... Is your database in open mode? And is the SAP system running?

Can you perform a database check with brconnect?

Kind regards,

Mark

[Former Member]

Hi Mark,

I followed up the Note, below are the permission set right now.

-rwxr-xr-x 1 orageq dba 4019588 2008-02-06 19:26 brarchive

-rwsrwxr-x 1 orageq dba 4122171 2008-02-06 19:27 brbackup

-rwsrwxr-x 1 orageq dba 5337376 2008-02-06 19:28 brconnect

-rwxr-xr-x 1 orageq dba 4431991 2008-02-06 19:29 brrecover

-rwxr-xr-x 1 orageq dba 1524502 2008-02-06 19:29 brrestore

-rwxr-xr-x 1 orageq dba 5468507 2008-02-06 19:32 brspace

-rwsrwxr-x 1 orageq dba 2224753 2008-02-06 19:32 brtools

/sapmnt/<SID>/exe-----ora<sid> belongs to the dba group,

Thanks.

vel.

[Former Member]

So have you tried a new run?

Kind regards,

Mark

[Former Member]

Hi Mark,

I did check all file permission for database, it looks fine ( ora<sid> dba group).

Thanks.

Vel.

[Former Member]

Can you check the permissions of the brconnect, according to note 113747 - Permissions for DBA tools BR*Tools and SAPDBA

Kind regards,

Mark

[Former Member]

Can you check the permissions of your database files?

Kind regards,

Mark