ValidateStructure: SQL error -14508

[Former Member]

Hi!

After ValidateStructure I get the following errors.

BR0301E SQL error -14508 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SAPSR3"."/BI0/F0CCMAETPH" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-14508: specified VALIDATE INTO table not found

BR0893E Validating structure failed for table/cluster SAPSR3./BI0/F0CCMAETPH

BR0280I BRCONNECT time stamp: 2009-11-04 21.50.09

BR0301E SQL error -14508 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SAPSR3"."/BI0/F0CCMDAHGR" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-14508: specified VALIDATE INTO table not found

BR0893E Validating structure failed for table/cluster SAPSR3./BI0/F0CCMDAHGR

BR0280I BRCONNECT time stamp: 2009-11-04 21.50.20

BR0301E SQL error -14508 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SAPSR3"."/BI0/F0CCMDAHIR" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-14508: specified VALIDATE INTO table not found

BR0893E Validating structure failed for table/cluster SAPSR3./BI0/F0CCMDAHIR

BR0280I BRCONNECT time stamp: 2009-11-04 21.50.31

BR0301E SQL error -14508 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SAPSR3"."/BI0/F0CCMDARTC" VALIDATE STRUCTURE CASCADE ONLINE'

How can I solve these errors?

[stefan_koehler]

Hello Holger,

please check sapnote #514178

Regards

Stefan

[Former Member]

Hi!

Because my Operating system is Linux I applied the following SQL commandos:

> Log on with ora<sid>.

> cd $ORACLE_HOME/rdbms/admin

> sqlplus system/<password>

> SQL> @utlvalid.sql

> SQL> grant all on invalid_rows to public;

> SQL> connect /

> SQL> create synonym invalid_rows for system.invalid_rows;

> SQL> create synonym ops$<sid>adm.invalid_rows for system.invalid_rows;

Now I planned again the Validate Structure job and will see whether the errors will be solved.

Thank you!

[former_member274404]

Hi,

I tried the same. But now I got the message

ERROR at line 1:

ORA-01031: insufficient privileges

What is now the Problem? Does anybody knows this error message in this case?

Thanks and regards

Marina

[former_member264034]

Hi,

I suggest you to have a look at Note 480266 first and adjust the
settings accordingly to see if the issue can be resloved.

Note 480266 - Problems with the SYSDBA/SYSOPER/INTERNAL connect

Generally the ORA-1031 permissions problem is solved by running the
sapdba_role.sql script

134592 -sapdba_role.sql(Script attached to the note )

Regards,

Aidan