SQL 4.7 Installation Error CJS-00084 SQL Statement or Script failed

[Former Member]

Dear SAP Gurus,

pl do let me know hoe to resolve this error.......

"""CJS-00084 SQL Statement or Script failed"""

my ora_sql_results file is like that..

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

2008-10-25, 16:14:44 SAPINST ORACLE start logging for

connect / as sysdba ;

@@"C:\SAPinstORACLEKERNEL/oradbusr.sql"

exit;

Output of SQL executing program:

SQL*Plus: Release 9.2.0.2.0 - Production on Sat Oct 25 16:14:44 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected.

Connected.

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

new 3: if substr(upper('SAPERP'),1,5) = 'SAPR3' then

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

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

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

new 13: :sDomain := upper('ERP');

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

new 17: :sSchema := upper('SAPERP');

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

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

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

new 25: :sDomain := upper('ERP');

using following Parameters:

.

. Oracle SID: ERP

. Oracle Version: 9.2.0.2.1

. Parametervalue os_authent_prefix: OPS$

. Database User (Schema): SAPERP

. SAP R/3 Administrator: OPS$ERP\ERPADM

. SAP R/3 Serviceuser: OPS$ERP\SAPSERVICEERP

.

O/S Message: No such file or directory

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.2.0 - Production

SAPINST: End of output of SQL executing program F:\oracle\ora92/bin/sqlplus.exe.

SAPINST found errors.

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

2008-10-25, 16:14:44 SAPINST ORACLE stop logging

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

My SAPINST_ORA_ENVIRONMENT FIle is like that

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

2008-10-25, 16:10:43 SAPINST Current process environment:

=::=::\

=C:=C:\SAPinstORACLEKERNEL

ALLUSERSPROFILE=C:\Documents and Settings\All Users

APPDATA=C:\Documents and Settings\tanya\Application Data

CLIENTNAME=Console

CommonProgramFiles=C:\Program Files\Common Files

COMPUTERNAME=ERP

ComSpec=C:\WINDOWS\system32\cmd.exe

DBMS_TYPE=ORA

DBS_ORA_SCHEMA=SAPERP

dbs_ora_tnsname=ERP

FP_NO_HOST_CHECK=NO

HOMEDRIVE=C:

HOMEPATH=\Documents and Settings\tanya

JAVA_HOME=C:\j2sdk1.4.2_09

JSERV=F:\oracle\ora92/Apache/Jserv/conf

LOGONSERVER=
ERP

NLS_LANG=AMERICAN_AMERICA.WE8DEC

NUMBER_OF_PROCESSORS=2

ORACLE_HOME=F:\oracle\ora92

ORACLE_SID=ERP

OS=Windows_NT

Path=F:\oracle\ora92\bin;$PATH$

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

PROCESSOR_ARCHITECTURE=x86

PROCESSOR_IDENTIFIER=x86 Family 6 Model 23 Stepping 6, GenuineIntel

PROCESSOR_LEVEL=6

PROCESSOR_REVISION=1706

ProgramFiles=C:\Program Files

SAPDATA_HOME=F:\oracle\ERP

SAPEXE=F:\usr\sap\ERP\SYS\exe\run

SAPLOCALHOST=ERP

SAPSYSTEMNAME=ERP

SESSIONNAME=Console

SystemDrive=C:

SystemRoot=C:\WINDOWS

TEMP=C:\WINDOWS\TEMP

TMP=C:\WINDOWS\TEMP

USERDOMAIN=ERP

USERNAME=tanya

USERPROFILE=C:\Documents and Settings\tanya

windir=C:\WINDOWS

WV_GATEWAY_CFG=F:\oracle\ora92\Apache\modplsql\cfg\wdbsvr.app

SAPINST: End of current process environment.

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

REgards,

Abhishek

[Former Member]

thanks

[markus_doehr2]

> SQL*Plus: Release 9.2.0.2.0 - Production on Sat Oct 25 16:14:44 2008

Read the installation guide.

It tells you to install the latest patchset and the latest interim patch before starting the installation. The version you use 9.2.0.2 is VERY VERY old. Update to 9.2.0.8 + latest patches.

Markus

[Former Member]

Dear Markus,

Thanks, but most of the people in the industry are still using the same, and it is working on their Machine.

why it is not working on my machine?

might be there may be some other solution, which we have to extratct out.

secondly from where i will get the latest patches, as told by you. pl do let me know any website from where i can down load them

Regards,

Abhishek

[Former Member]

https://websmp202.sap-ag.de/swdc --> download --> database patches --> select yor database.

[markus_doehr2]

Thanks, but most of the people in the industry are still using the same, and it is working on their Machine

As far as I remember 9.2.0.2 was never released, one needed to install at least 9.2.0.4 (or .5). That´s why the official installation guides tell you to install the latest patches PLUS the latest interim patches for the database.

On top of that, Oracle 9.2 is out of extended support already, I would get a new installation CD set with Oracle 10g and use that for a new installation.

why it is not working on my machine?

Because those old database versions have many bugs that are fixed with patches - so why do you want to run such an old version if one KNOWS that it´s buggy and there are patches to fix those errors?

secondly from where i will get the latest patches, as told by you. pl do let me know any website from where i can down load them

Check

Note 938986 - Oracle Database 9.2: Patches for 9.2.0

Markus