SAPinst: Create database schema / SAP Solution Manager

[Former Member]

Hello everybody,<br /><br />

installation went fine so far. But it doesn solve to go further than this.

I try and install the SAP Solution Manager 4.0 SR2 on SLES 9 with Oracle.

While SAPinst tries to create the DB-schema it stops here:

<br /><br />

SAPinst log:

<br /><br />

ERROR 2007-05-11 18:04:17 [iaxxinscbk.cpp:282]<br />

abortInstallation<br />

CJS-00084 SQL statement or script failed.<br>DIAGNOSIS: Error message:<br />

Executable /oracle/ACO/102_32/bin/sqlplus returns 41..<br>SOLUTION: See

ora_sql_results.log and the Oracle documentation for details.<br />

<br />

ERROR 2007-05-11 18:04:18<br />

CJSlibModule::writeError_impl()<br />

MUT-03025 Caught ESAPinstException in Modulecall: ESAPinstException: error

text undefined.<br />

<br />

ERROR 2007-05-11 18:04:18 [iaxxgenimp.cpp:731]<br />

showDialog()<br />

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 .<br />

<br />

-

---

<br />

<br />

ora_sql_results.log tells me:<br />

<br />

==============================================================<br />

2007-05-11, 18:04:16 SAPINST ORACLE start logging for<br />

<br />

@@ORADBUSR.SQL<br />

exit;<br />

<br />

Output of SQL executing program:<br />

<br />

<br />

<br />

SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 11 18:04:16 2007<br />

<br />

Copyright (c) 1982, 2005, Oracle. All rights reserved.<br />

<br />

Connected to:<br />

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br />

With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring

Engine options<br />

<br />

Connected.<br />

old 6: if length('&&1') = 5 then<br />

new 6: if length('SAPSR3') = 5 then<br />

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

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

old 11: if upper('&&2') = 'NT' then<br />

new 11: if upper('UNIX') = 'NT' then<br />

old 18: :sDomain := upper('&&3');<br />

new 18: :sDomain := upper('ACA');<br />

old 19: :sSapSid := upper('&&4');<br />

new 19: :sSapSid := upper('x');<br />

old 21: :sSapSid := upper('&&3');<br />

new 21: :sSapSid := upper('ACA');<br />

old 37: :sSchema := upper('&&1');<br />

new 37: :sSchema := upper('SAPSR3');<br />

old 39: if upper('&&2') = 'NT' then<br />

new 39: if upper('UNIX') = 'NT' then<br />

old 46: :sDomain := upper('&&3');<br />

new 46: :sDomain := upper('ACA');<br />

old 47: :sSapSid := upper('&&4');<br />

new 47: :sSapSid := upper('x');<br />

old 49: :sSapSid := upper('&&3');<br />

new 49: :sSapSid := upper('ACA');<br />

using following Parameters:<br />

.<br />

. Oracle Version: 10.2.0.1.0<br />

. Parametervalue os_authent_prefix: OPS$<br />

. Schema Id: SR3<br />

. Database User (Schema): SAPSR3<br />

. SAP R/3 Administrator: OPS$ACAADM<br />

. SAP R/3 Serviceuser: OPS$SAPSERVICEACA<br />

.<br />

Connected.<br />

Connected.<br />

begin<br />

*<br />

ERROR at line 1:<br />

ORA-03113: end-of-file on communication channel<br />

<br />

<br />

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

- Production<br />

With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring

Engine options<br />

<br />

<br />

SAPINST: End of output of SQL executing program

/oracle/ACO/102_32/bin/sqlplus.<br />

<br />

SAPINST found errors.<br />

SAPINST The current process environment may be found in<br />

sapinst_ora_environment.log.<br />

<br />

2007-05-11, 18:04:17 SAPINST ORACLE stop logging<br />

<br />

-

---

<br />

<br />

Any hint were very appreciated. I already tried with Oracle patched during

the normal database-installation-process to level 10.2.0.2. That made no

difference.<br /><br />

Thanks in advance,<br />

Sven

[Former Member · Accepted solution]

Oracle / listener seem to be up.


ps auxf (only the relevant part) and lsnrctl status:


oraaco 4341 0.0 0.6 691536 13308 ? Ss 11:31 0:00 ora_pmon_ACO

oraaco 4343 0.0 0.5 690892 10532 ? Ss 11:31 0:00 ora_psp0_ACO

oraaco 4345 0.0 0.8 690892 18528 ? Ss 11:31 0:00 ora_mman_ACO

oraaco 4347 0.0 0.8 695172 16920 ? Ss 11:31 0:00 ora_dbw0_ACO

oraaco 4349 0.0 0.7 706476 15380 ? Ss 11:31 0:00 ora_lgwr_ACO

oraaco 4351 0.0 0.7 691080 16392 ? Ss 11:31 0:00 ora_ckpt_ACO

oraaco 4353 0.0 1.9 691492 41032 ? Ss 11:31 0:00 ora_smon_ACO

oraaco 4355 0.0 0.7 690948 16496 ? Ss 11:31 0:00 ora_reco_ACO

oraaco 4357 0.0 1.1 692528 24360 ? Ss 11:31 0:00 ora_cjq0_ACO

oraaco 4359 0.0 1.9 693612 40612 ? Ss 11:31 0:00 ora_mmon_ACO

oraaco 4361 0.0 0.7 690928 16020 ? Ss 11:31 0:00 ora_mmnl_ACO

oraaco 4365 0.0 0.5 690896 11792 ? Ss 11:31 0:00 ora_qmnc_ACO

oraaco 4376 0.0 0.6 690920 13120 ? Ss 11:31 0:00 ora_q000_ACO

oraaco 4378 0.0 0.5 690920 11048 ? Ss 11:31 0:00 ora_q001_ACO

oraaco 4592 0.0 0.2 25308 5628 ? Ss 11:45 0:00 /oracle/ACO/102_32/bin/tnslsnr LISTENER -inherit


sap01:oraaco 32> lsnrctl status


LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-MAY-2007 11:46:45


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


Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ACO.WORLD))

STATUS of the LISTENER

-

-

---

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 14-MAY-2007 11:45:09

Uptime 0 days 0 hr. 1 min. 35 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oracle/ACO/102_32/network/admin/listener.ora

Listener Log File /oracle/ACO/102_32/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=ACO.WORLD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=ACO)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sap01.localdomain)(PORT=1527)))

Services Summary...

Service "ACO" has 1 instance(s).

Instance "ACO", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully




Check environment variables? Shouldn´ t sapinst set them correctly?

[Former Member · Accepted solution]

Hi,

<b>oraaco 4341 0.0 0.6 691536 13308 ? Ss 11:31 0:00 ora_pmon_ACO</b>

<b>new 49: :sSapSid := upper('ACA');</b>

Your DB instance is "ACO" and your SAP SID is "ACA"? ...Or there's an error at the installation parameters input?

Regards,

JC Llanes.

[Former Member]

OK, I´m stupid. Thanks, the last post solved the problem.

[Former Member]

> Your DB instance is "ACO" and your SAP SID is "ACA"?

Do you want to say this is not a good idea?

[former_member204746]

make sure that Oracle is up

make sure that Oracle listener is up

check environment variables.