Error while installing NW 7.0 sr3( Windows + oracle)

[Former Member]

Hi All,

i am getting the following error while installing NW 7.0 SR3 at step 15 Create database schema.

Error Log

ERROR 2009-08-14 18:01:47

FJS-00003 ReferenceError: createscript is not defined (in script NW_Onehost|ind|ind|ind|ind, line 65036: ???)

ERROR 2009-08-14 18:01:47

FCO-00011 The step createABAPSchemaUser with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbSchema|ind|ind|ind|ind|9|0|createABAPSchemaUser was executed with status ERROR .

the below are the logs of sapinst_dev.log

65001: var nw = this.getNW();

65002: var nwusers = nw.getUsers();

65003:

65004: var sqlContext = this.getOraSqlContext();

65005: var value = new Array();

65006:

65007: var stateMan = new OraDbStateManager3(sqlContext);

65008:

65009: // set os_authen_prefix to "O$" instead of "OPS$"

65010: if ( installer.onWindows() && nw.getSAPDomain().length > 12 )

65018:

65019: stateMan.ensureDbIsAvailable();

65020:

65021: var ad;

65022:

65023: ad = nwusers.getAccountData(NWUsers.roles.SAPSID);

65024: NW.trace("NW(SchemaABAP: ",ad.name,")");

65025: gui.update("Create schema user " + ad.name + " ...");

65026:

65027: var createScript = new OraSqlScript3("ORADBUSR.SQL", sqlContext, "FILENAME");

65028: if ( installer.onUnix() ) else

65033: installer.writeTrace("createSchemaAbap: " + arg);

65034: NW.trace("OraCom(createSchemaAbap: ", arg);

65035: createScript.setArguments(arg);

65036: createscript.execute();

65037:

65038: // set password for OBR to standart because user is available but password not known

65039: if ( nw.getLoadType() == "OBR" )

65046:

65047:

65048:

65049: // update exists=true also in keydb table t_NW_accounts

65050: ad.exists = true;

65051: nwusers.changeAccountData(NWUsers.roles.SAPSID, ad);

65052:

65053: NW.trace("NW(createABAPSchema done)");

65054: }

65055:

65056: NWDBora.prototype.createJavaSchema = function()

65095:

65096: NWDBora.prototype.createSysmanSchema = function() {

65097: NW.trace("NW(createSysmanSchema start)");

65098:

65099: var rc = true;

65100: var nw = this.getNW();

65101: var fileMgt = new FileMgt();

65102:

65103:

65104: sqlContext = this.getOraSqlContext();

65105:

65106: var stateMan = new OraDbStateManager3(sqlContext);

65107: stateMan.ensureDbIsAvailable();

65108:

65109: gui.update("Drop schema SYSMAN cascade ...");

65110: // drop sysman if already exists in database

Please help in resolving this issue.

Thanks in advance,

Satish

[markus_doehr2 · Accepted solution]

> Please help in resolving this issue.

Please check the output of ora_sql_result.log

Markus

[Former Member · Accepted solution]

Hi Markus,

thanks for your repli, please find the log found.

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

2009-08-14, 16:29:03 SAPINST ORACLE start logging for

SHUTDOWN ABORT;

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Aug 14 16:29:04 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:

ORA-12560: TNS:protocol adapter error

SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus

SAPINST: End of output of SQL executing program C:\oracle\AI1\102/bin/sqlplus.

SAPINST found errors.

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

2009-08-14, 16:29:05 SAPINST ORACLE stop logging

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

2009-08-14, 16:29:23 SAPINST ORACLE start logging for

SHUTDOWN IMMEDIATE;

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Aug 14 16:29:23 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Disconnected

SAPINST: End of output of SQL executing program C:\oracle\AI1\102/bin/sqlplus.

SAPINST found errors.

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

2009-08-14, 16:29:25 SAPINST ORACLE stop logging

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

2009-08-14, 16:29:25 SAPINST ORACLE start logging for

STARTUP NOMOUNT;

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Aug 14 16:29:25 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 515899392 bytes

Fixed Size 1297628 bytes

Variable Size 268436260 bytes

Database Buffers 243269632 bytes

Redo Buffers 2895872 bytes

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

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SAPINST: End of output of SQL executing program C:\oracle\AI1\102/bin/sqlplus.

2009-08-14, 16:29:47 SAPINST ORACLE stop logging

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

2009-08-14, 16:29:47 SAPINST ORACLE start logging for

CREATE DATABASE AI1 CONTROLFILE REUSE MAXLOGFILES 255 MAXLOGMEMBERS 3 MAXLOGHISTORY 1000 MAXDATAFILES 254 MAXINSTANCES 50 NOARCHIVELOG CHARACTER SET UTF8 NATIONAL CHARACTER SET UTF8 DATAFILE 'E:\oracle\AI1\sapdata1\system_1\system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPACE PSAPTEMP TEMPFILE 'E:\oracle\AI1\sapdata1\temp_1\temp.data1' SIZE 300M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M UNDO TABLESPACE PSAPUNDO DATAFILE 'E:\oracle\AI1\sapdata1\undo_1\undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M SYSAUX DATAFILE 'E:\oracle\AI1\sapdata1\sysaux_1\sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

LOGFILE GROUP 1 ('E:\oracle\AI1/origlogA/log_g11m1.dbf',

'C:\oracle\AI1/mirrlogA/log_g11m2.dbf') SIZE 50M REUSE ,

GROUP 2 ('E:\oracle\AI1/origlogB/log_g12m1.dbf',

'C:\oracle\AI1/mirrlogB/log_g12m2.dbf') SIZE 50M REUSE ,

GROUP 3 ('E:\oracle\AI1/origlogA/log_g13m1.dbf',

'C:\oracle\AI1/mirrlogA/log_g13m2.dbf') SIZE 50M REUSE ,

GROUP 4 ('E:\oracle\AI1/origlogB/log_g14m1.dbf',

'C:\oracle\AI1/mirrlogB/log_g14m2.dbf') SIZE 50M REUSE

;

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Aug 14 16:29:47 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Database created.

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

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SAPINST: End of output of SQL executing program C:\oracle\AI1\102/bin/sqlplus.

2009-08-14, 16:30:48 SAPINST ORACLE stop logging

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

2009-08-14, 16:30:49 SAPINST ORACLE start logging for

set newpage 0

set space 0

set pagesize 0

set linesize 32767

set markup HTML off

set heading off

set verify off

set feedback off

set trimspool on

set sqlprompt SQL>

set termout on

set verify off

set echo off

spool ora_query3_tmp0_1.res

SELECT STATUS FROM V$INSTANCE;

spool off

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Aug 14 16:30:49 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

OPEN

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

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SAPINST: End of output of SQL executing program C:\oracle\AI1\102/bin/sqlplus.

2009-08-14, 16:30:51 SAPINST ORACLE stop logging

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

2009-08-14, 16:30:51 SAPINST ORACLE start logging for

@@C:\oracle\AI1\102/rdbms/admin/catalog.sql

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Aug 14 16:30:51 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

DOC>######################################################################

DOC>######################################################################

DOC> The following statement will cause an "ORA-01722: invalid number"

DOC> error and terminate the SQLPLUS session if the user is not SYS.

DOC> Disconnect and reconnect with AS SYSDBA.

DOC>######################################################################

DOC>######################################################################

DOC>#

Thanks and regards,

Satish

[markus_doehr2 · Accepted solution]

> @@C:\oracle\AI1\102/rdbms/admin/catalog.sql

> exit;

it seems that catalog.sql did not run through correctly.

Did you apply the latest interim-/minipatch for 10.2.0.4?

Markus

[Former Member · Accepted solution]

Hi Markus,

Earlier i got the following error while running catproc.sql .

i have rectified it by editing the control.xml in following manner.

Edit file control.xml in your installation directory (default sapinst_instdir).

2. Search for "this.runCatproc = "

3. Go to "script.execute_AbortOnFailure();" some lines below.

4. Replace "script.execute_AbortOnFailure();" with "script.execute();".

5. Restart sapinst and choose Continue with the Old Installation.

I have nt applied interim minipatch.

is there any solution to error, please help...

thanks and regards,

satish

[markus_doehr2 · Accepted solution]

> I have nt applied interim minipatch.

You should (read the installation guide!)

> is there any solution to error, please help...

I have done an installation on 10.2.0.4 with the minipatch and I haven't seen this error.

Markus