CJS-00084 SQL statement or script failed.

[Former Member]

Can any body help me i have this error "CJS-00084" mentioned in sapinst.log

where it pointed to ora_sql_results.log

when i checked the oracle log file the last few lines looks like this

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

2012-10-30, 20:46:40 SAPINST ORACLE start logging for

@@ORADBUSR.SQL

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 30 20:46:40 2012

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   6:   if length('&&1') = 5 then

new   6:   if length('SAPSR3') = 5 then

old   7:     if substr(upper('&&1'),1,5) = 'SAPR3' then

new   7:     if substr(upper('SAPSR3'),1,5) = 'SAPR3' then

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

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

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

new  18:           :sDomain := upper('lordes-d96b62b4');

old  19:           :sSapSid := upper('&&4');

new  19:           :sSapSid := upper('DAN');

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

new  21:           :sSapSid := upper('lordes-d96b62b4');

old  37:     :sSchema := upper('&&1');

new  37:     :sSchema := upper('SAPSR3');

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

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

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

new  46:       :sDomain := upper('lordes-d96b62b4');

old  47:       :sSapSid := upper('&&4');

new  47:       :sSapSid := upper('DAN');

old  49:       :sSapSid := upper('&&3');

new  49:       :sSapSid := upper('lordes-d96b62b4');

Service username too long: max length is 30

O$LORDES-D96B62B4\SAPSERVICEDAN

begin

*

ERROR at line 1:

ORA-20000: Service username too long: max length is 30

ORA-06512: at line 23

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 D:\oracle\product\10.2.0\db_2/bin/sqlplus.

SAPINST found errors.

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

2012-10-30, 20:46:42 SAPINST ORACLE stop logging

what is the solution please help me and thanks in advance

[paul_power · Accepted solution]

Hello Vivian,

For the error

ERROR at line 1:

ORA-20000: Service username too long: max length is 30

ORA-06512: at line 23

Please see SAP Note  314671

this should work as it would reduce the user name to less than 30
characters.

ALTER SYSTEM SET OS_AUTHENT_PREFIX = " " scope=spfile;

then restart your database

this should be returned:

SQL> ALTER SYSTEM SET OS_AUTHENT_PREFIX = " " scope=spfile;

System altered.

SQL> show parameter OS_AUTHENT_PREFIX

reagrds,

Paul