checkdb job failed

[Former Member]

Hi,

We have done the new hardware migration for testing system(PSS) and PSS refresh from the production data. CheckDB job has been scheduled from DB13. here the job is getting failed. still it is referring the path of production <b>"Function stat() failed for '/oracle/PRD/sapdata7'</b>".

Could you please advise me in which file I need to make the changes so that this job executes successfully.

Thanks,

[Former Member]

Hello, I got the same erros as Mudukana posted. Could someone please advise on how we can resolve the error message?

BR970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPR3./SDF/CMO_T_13A

BR970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPR3./SDF/CMO_T_13B

BR970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPR3./SDF/CMO_T_13C

BR970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPR3./SDF/CMO_T_18

BR970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPR3./SDF/CMO_T_19

BR970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPR3./SDF/CMO_T_21

BR970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPR3./SDF/CMO_T_22

BR970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPR3./SDF/CMO_T_36A

Much Appreciated

MN

[Former Member]

Can you collect the following information?

- Output of "select file_name from dba_data_files;"

- Output of "select file_name from dba_temp_files;"

- Environment settings for ora<sid> and <sid>adm

[Former Member]

with the following selects you can see which data files to which tablespaces belong:

select FILE_NAME, TABLESPACE_NAME, STATUS from dba_data_files order by tablespace_name;

select FILE_NAME, TABLESPACE_NAME, STATUS from dba_temp_files order by tablespace_name;

[Former Member]

Can you paste the complete BRCONNECT log file here? Or at least the section with the error message?

[Former Member]

BR0801I BRCONNECT 6.40 (20)

BR0805I Start of BRCONNECT processing: cdwepzof.chk 2007-09-20 01.00.13

BR0101I Parameters

Name Value

oracle_sid PSS

oracle_home /oracle/PSS/920_64

oracle_profile /oracle/PSS/920_64/dbs/initPSS.ora

sapdata_home /oracle/PSS

sap_profile /oracle/PSS/920_64/dbs/initPSS.sap

system_info pssadm/orapss sscpssd1 SunOS 5.8 Generic_117350-47 sun4u

oracle_info PSS 9.2.0.6.0 8192 67 3264303913

sap_info 46C SAPPRD PSS H0672314936 R3_ORA 0020118403

make_info sun_64 OCI_920 Dec 14 2004

command_line brconnect -u / -c -f check

alert_log /oracle/PSS/saptrace/background/alert_PSS.log

BR0280I BRCONNECT time stamp: 2007-09-20 01.00.17

BR0813I Schema owners found in database PSS:

DBSNMP, OPS$ORAPRD, OPS$PRDADM, OPS$PSSADM, OPS$UNIXADM, OUTLN, SAPPRD*, SAPR3, SC_FM, SYS,

SYSTEM, TMP_$_$

BR0118I Tablespaces and data files

Tablespace Status File Status Id. Size Device Type Link

PSAPPRD ONLINE+ /oracle/PSS/sapdata1/prd_1/prd.data1 ONLINE+ 2 10485768192 7733256 FILE NOLINK

PSAPPRD ONLINE+ /oracle/PSS/sapdata1/prd_2/prd.data2 ONLINE+ 3 10485768192 7733256 FILE NOLINK

PSAPPRD ONLINE+ /oracle/PSS/sapdata1/prd_3/prd.data3 ONLINE+ 4 10485768192 7733256 FILE NOLINK

PSAPPRD ONLINE+ /oracle/PSS/sapdata1/prd_4/prd.data4 ONLINE+ 5 10485768192 7733256 FILE NOLINK

PSAPPRD ONLINE+ /oracle/PSS/sapdata1/prd_5/prd.data5 ONLINE+ 6 10485768192 7733256 FILE NOLINK

PSAPPRD ONLINE+ /oracle/PSS/sapdata1/prd_6/prd.data6 ONLINE 17 2139095040 7733256 FILE NOLINK

PSAPPRD ONLINE+ /oracle/PSS/sapdata1/prd_7/prd.data7 ONLINE 19 2139095040 7733256 FILE NOLINK

PSAPPRD ONLINE+ /oracle/PSS/sapdata1/prd_8/prd.data8 ONLINE 20 2139095040 7733256 FILE NOLINK

<b>BR0252E Function stat() failed for '/oracle/PRD/sapdata7' at location BrDiskStatGet-1

BR0253E errno 2: No such file or directory

BR0277E Determination of disk volume status for /oracle/PRD/sapdata7 failed</b>

BR0970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPPRD.ICRC00_TEMPL_TXT

BR0970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPPRD.SGOSSUBT

BR0970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPPRD.SORTSUBF

BR0970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPPRD.ZACCOM_AUDIT_REP

BR0970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPPRD.ZAPPRKST

BR0970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPPRD.ZIORDERTYPE

BR0970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPPRD.ZITOURCCONTROL

BR0970W Database administration alert - level: ERROR, type: NO_OPT_STATS, object: (table) SAPPRD.ZSREPORTS<b></b>

[former_member204746]

check environment variables:

you might still have a variable called SAPDATA7. if so, delete it.

[Former Member]

Hi,

Will you pl run the Check and update optimizer statistics and then try Check db.

In case of any errors or warnings with Check and update optimizer statistics pl revert back.

Regards