Skip to Content
0
Apr 28, 2008 at 02:18 PM

ORA-00972: identifier is too long

835 Views

Hi All,

I get the error ORA-00972: identifier is too long during installation of NW2004s SR2 Java system with DI. This error is seen on the step Perform post load activites. i have made the changes as suggested by SAP note: 314671. But the error still persists. Can anyone suggest what further more should be done here?

Oracle is unable to delete : OPS$<14 letter host name>\SAPSERVICESR3 and hence the error.

the output from ora_sql_results.log

=============================================================

2008-04-28, 19:04:56 SAPINST ORACLE start logging for

@@SAPDBA_ADDITIONAL.SQL

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 28 19:04:56 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Connected.

old 3: :sSchemaUser := upper('&&1');

new 3: :sSchemaUser := upper('SAPSR3DB');

old 19: if upper('&&2') = 'NT' then

new 19: if upper('NT') = 'NT' then

old 21: :sDomain := upper('&&3');

new 21: :sDomain := upper('[14 letter Host Name]\SIDadm');

old 32: elsif upper('&&2') = 'UNIX' then

new 32: elsif upper('NT') = 'UNIX' then

old 37: RAISE_APPLICATION_ERROR(-20004,'Invalid OS, must be "NT" or "UNIX": ' || upper('&&2'));

new 37: RAISE_APPLICATION_ERROR(-20004,'Invalid OS, must be "NT" or "UNIX": ' || upper('NT'));

using following Parameters:

.

. Schema User: SAPSR3DB

. Parametervalue os_authent_prefix: OPS$

. OPS$SIDADM: OPS$[14 letter Host Name]\SIDADM

. SAP SID: SR3

. DB SID: SID

. R/3 Service User: OPS$[14 letter Host Name]\SAPSERVICESR3

. Computer or Domain: [14 letter Host Name]\SIDADM

.

old 119: if upper('&&4') = 'SYN' then

new 119: if upper('SYN') = 'SYN' then

old 137: if upper('&&4') = 'SYN' then

new 137: if upper('SYN') = 'SYN' then

create synonym: SAP_SDBAH SAPSR3DB.SDBAH

create synonym: SAP_SDBAH SAPSR3DB.SDBAD

unable to delete user: OPS$[14 letter Host Name]\SAPSERVICESR3

begin

*

ERROR at line 1:

ORA-00972: identifier is too long

ORA-06512: at line 46

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SAPINST: End of output of SQL executing program C:\oracle\product\10.2.0\db_1/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2008-04-28, 19:04:56 SAPINST ORACLE stop logging

Thanks in advance,

Arun E V