ORA-00972: identifier is too long

[arun_ev]

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

[former_member204746 · Accepted solution]

you must use a 12-characters-or-less hostname.

this is a known issue when using Oracle on Windows.

Read SAP note 849423 - Length of hostname for ABAP installation on Windows/Oracle

[markus_doehr2]

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

You are running an unsupported database version...

> C:\oracle\product\10.2.0\db_1/bin/sqlplus.

You did apparently not install the system using the provided script but runInstaller....

Markus

[stefan_koehler]

Hello,

as Markus already mentioned, you are using a not supported oracle version... but i think in your case this is not the problem.

>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

This problem is described in sapnote #314671 and seems to fit to your scenario.

Please check your domain name and implement the solution from the sapnote

Regards

Stefan

[arun_ev]

Hi Markus/Stefan,

Thanks for the quick answer. I know i am using a unsupported version, but that should not be a problem here. Though i have not run the installer from the script, still the DB is a successful installation and i have used it like this a few times.

Stefan, I have seen the note and made the required modification but still the issue persists. Is there anything more that i need to do apart from what is mentioned in the note?

The trouble is we are not in a position to change the host name as suggested and would prefer to continue with the same name.

Thanks,

Arun E V

[Former Member]

Hi Arun,

Please refer this link

You need to change the sPrefix variable instance in SAPDBA_ADDITIONAL.sql file.

This will solve your problem.

Regards

Kedar Kulkarni

[Former Member]

I solved by chaging my Host name of server to a less 12 characters.

Regards,

Shashanka