Solution Manager 7.1 Step 19 Import Java Dump stopped.

[former_member391562]

Hi collegues, we are installing SolMan 7.1 under Solaris 10, Oracle 11.2.0.2.

Sapinst in step 19 Import Java Dump stop, it seems that can't connect with DB, DB it's started and also listener.

Dec 28, 2011 2:26:29 AM com.sap.inst.dbtools [Thread[main,5,main]] Info: Executing batch. Rows inserted : 64, lob size : 94915222

Dec 28, 2011 2:27:15 AM com.sap.inst.dbtools [Thread[main,5,main]] Info: Executing batch. Rows inserted : 3, lob size : 106195204

Dec 28, 2011 2:28:04 AM com.sap.inst.dbtools [Thread[main,5,main]] Error: DB Error during import of J2EE_CONFIGENTRY

As the problem is just after import J2EE_CONFIGENTRY, I just applied recommendations of Sapnote:

Note 1173398 - jload export fails with OutOfMemoryException

If the problem occurs during a sapinst run (systemcopy for example), stop the sapinst, and edit control.xml.

Search for the line

var jloadHeap = "-Xmx1024m";

and replace it by

var jloadHeap = "-Xmx1540m";

(In my case fixed to -Xmx2048m)

Save control.xml.

Restart sapinst.

It doesn't work, the same error occurs.

R3trans -d also it's wrong, the same error occurs:

4 ETW000 [dev trc ,00000] Assigning server context 102aa6b28 to service context 102aa3398 35711 0.092247

4 ETW000 [dev trc ,00000] OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=102b04bc0) 151 0.092398

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con=0, usr='/',svc=102aa3398, srv=102aa6b28, usr=102b04bc0)

4 ETW000 40 0.092438

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 3765 0.096203

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034: 137 0.096340

4 ETW000 [dev trc ,00000] ORA-01034: ORACLE not available 34 0.096374

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 SVR4 Error: 2: No such file or directory

4 ETW000 [dev trc ,00000] server_detach(con=0,stale=1,srvhp=102aa6b28) 46 0.096420

4 ETW000 [dev trc ,00000] Detaching from DB Server (con=0,svchp=102aa3398,srvhp=102aa6b28) 30 0.096450

4 ETW000 [dev trc ,00000] Deallocating server context handle 102aa6b28 from con=0 216 0.096666

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034' 65 0.096731

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1034 17066 0.113797

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con=0, rc=1034) 41 0.113838

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1034 101 0.113939

4 ETW000 [dev trc ,00000] ORA-01034: ORACLE not available 36 0.113975

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 SVR4 Error: 2: No such file or directory

4 ETW000 [dev trc ,00000] SAPUSER or connect error 99=DBSL_ERR_DB, oerr=1034. 51 0.114026

4 ETW000 [dev trc ,00000] DbSlConnect(con=-1) -> orc=0, 99=DBSL_ERR_DB 30 0.114056

4 ETW000 [dblink ,00000] ***LOG BY2=>sql error 1034 performing CON 7411 0.121467

4 ETW000 [dblink ,00000] ***LOG BY0=>ORA-01034: ORACLE not available 61 0.121528

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 SVR4 Error: 2: No such file or directory

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SMP'"

jload.log

WARNING 2011-12-28 13:02:06.671

CJSlibModule::writeWarning_impl()

Execution of the command "/usr/j2sdk/bin/java -classpath /tmp/sapinst_instdir/SOLMAN71/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/launcher.jar -showversion -Xmx1024m -d64 com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload /tmp/sapinst_instdir/SOLMAN71/SYSTEM/ORA/CENTRAL/AS/install/lib/iaik_jce.jar:/tmp/sapinst_instdir/SOLMAN71/SYSTEM/ORA/CENTRAL/AS/install/sharedlib:/oracle/client/10x_64/instantclient/ojdbc14.jar -sec SMP,jdbc/pool/SMP,/usr/sap/SMP/SYS/global/security/data/SecStore.properties,/usr/sap/SMP/SYS/global/security/data/SecStore.key -dataDir /net/nashville2/vol/volSAP/SAP_SW/Instalaciones/SolutionManager71/D51040039_SolutionManager_71_JavaBasedSWComp/DATA_UNITS/SOLMAN_JAVA_EXPORT_JDMP -job /tmp/sapinst_instdir/SOLMAN71/SYSTEM/ORA/CENTRAL/AS/IMPORT.XML -log jload.log" finished with return code 1. Output:

java version "1.4.2_32"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_32-b03)

Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_32-b03, mixed mode)

Jload R 7.12 V 0 A 0

Jload -sec SMP,jdbc/pool/SMP,/usr/sap/SMP/SYS/global/security/data/SecStore.properties,/usr/sap/SMP/SYS/global/security/data/SecStore.key -dataDir /net/nashville2/vol/volSAP/SAP_SW/Instalaciones/SolutionManager71/D51040039_SolutionManager_71_JavaBasedSWComp/DATA_UNITS/SOLMAN_JAVA_EXPORT_JDMP -job /tmp/sapinst_instdir/SOLMAN71/SYSTEM/ORA/CENTRAL/AS/IMPORT.XML -log jload.log

Connecting to database

Couldn't connect to DB

com.sap.inst.common.exception.DBConnectionException: java.sql.SQLException: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

SVR4 Error: 2: No such file or directory

at com.sap.inst.common.db.DBConnection.connect(DBConnection.java:157)

at com.sap.inst.jload.Jload.main(Jload.java:222)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:331)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Caused by: java.sql.SQLException: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

SVR4 Error: 2: No such file or directory

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)

at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:294)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:358)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:166)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createConnection(OpenSQLDataSourceImpl.java:522)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:276)

at com.sap.inst.common.db.DBConnection.connectViaSecureStore(DBConnection.java:111)

at com.sap.inst.common.db.DBConnection.connect(DBConnection.java:151)

... 6 more

An error occured during execution. Please consult SAP note 942766 for first steps on troubleshooting the problem.

Any idea?

Best regards.

Jose Angel Herranz

[former_member391562]

Just I think is FS sapdata1 full:

/dev/vx/dsk/SMP/volD00

20G 20G 0K 100% /oracle/SMP/sapdata1

/dev/vx/dsk/SMP/volD01

20G 16G 3,3G 84% /oracle/SMP/sapdata2

/dev/vx/dsk/SMP/volD02

20G 10G 8,9G 55% /oracle/SMP/sapdata3

/dev/vx/dsk/SMP/volD03

40G 18G 20G 48% /oracle/SMP/sapdata4

/dev/vx/dsk/SMP/volD04

20G 70M 19G 1% /oracle/SMP/sapdata5

/dev/vx/dsk/SMP/volD05

20G 70M 19G 1% /oracle/SMP/sapdata6

There is another way to distribute the storage in another way to avoid this errors? We have a lot of space in another sapdata almost empty......

I'm waiting for increse it and try again....

Thanks all.

[former_member391562]

Thanks collegues, there was a problem with link to listner, I retry and continue, but know there is another problem:

28-dic-2011 17:08:45 com.sap.inst.common.size.provider.OraObjectSizeProvider getTableSizesFromDb

INFO: Calculated size for table J2EE_CONFIGENTRY : 1744830464

Trying to create table JCS_MONMESSAGE0

com.sap.dictionary.database.dbs.JddRuntimeException: Table JCS_MONMESSAGE0 could not be created in database.

Version: dev 19.03.2010 19:30:00

Protocol:

17:08:45 2011-12-28 dbs-Info: <<< Begin of phase: Analysis

17:08:45 2011-12-28 dbs-Info: <<< Analyze table JCS_MONMESSAGE0 >>>

17:08:45 2011-12-28 ora-Info: Table JCS_MONMESSAGE0 not found on DB

17:08:45 2011-12-28 dbs-Info: Action: CREATE

17:08:45 2011-12-28 dbs-Info: <<< End of phase: Analysis

17:08:45 2011-12-28 dbs-Info: <<< Begin of phase: Execution of statements

17:08:45 2011-12-28 dbs-Info: <<< Modify JCS_MONMESSAGE0 >>>

E R R O R ******* (DbSqlStatement dev 19.03.2010 19:30:00)

17:08:46 2011-12-28 dbs-Error: Exception caught during SQL execution ORA-00604: se ha producido un error a nivel 1 de SQL recursivo

ORA-01655: no se ha podido ampliar el cluster SYS.C_COBJ# con 128 en el tablespace SYSTEM

CREATE TABLE "JCS_MONMESSAGE0"

(

"A_UNIQUEID" NUMBER(19) NOT NULL,

"A_TYPE" NUMBER(19) NOT NULL,

"A_OBJECTID" NUMBER(19) NOT NULL,

"A_OBJTYPEHASH" NUMBER(19) NOT NULL,

"A_FIELDNAMEHASH" NUMBER(19) ,

"A_STRINGVALUE" NVARCHAR2(1024) ,

"A_NUMBERVALUE" DECIMAL(31,7) ,

"A_LONGVALUE" NUMBER(19) ,

"A_OBJDELETED" NVARCHAR2(1) DEFAULT 'f' NOT NULL,

"A_MONOBJID" NUMBER(19) ,

"A_PARENTID" NUMBER(19) ,

"A_CREATEDTS" NUMBER(19) DEFAULT 0 NOT NULL,

"A_LASTMODIFTS" NUMBER(19) ,

"F_CRTIMEZONE" NUMBER(19) ,

"F_LASTMODSUB" NUMBER(19) ,

"A_LLPVERSION" NUMBER(19) DEFAULT 0 NOT NULL,

"A_BEHAVIOUR" NUMBER(19) DEFAULT 0 NOT NULL

)

E R R O R ******* (DbModifier dev 19.03.2010 19:30:00)

17:08:46 2011-12-28 dbs-Error: Statements could not be executed

17:08:46 2011-12-28 dbs-Info: <<< End of phase: Execution of statements

17:08:46 2011-12-28 dbs-Info: Analysis and adjustment of tables finished with errors

at com.sap.dictionary.database.opentools.DbTableOpenTools.createTable(DbTableOpenTools.java:90)

at com.sap.dictionary.database.opentools.DbTableOpenTools.createTable(DbTableOpenTools.java:69)

at com.sap.inst.jload.db.opentools.DbTableOpenTools.createTable(DbTableOpenTools.java:21)

at com.sap.inst.jload.db.DBTable.createObject(DBTable.java:61)

at com.sap.inst.jload.db.AbstractDBObject.create(AbstractDBObject.java:101)

at com.sap.inst.jload.executor.JobExecutor.dbImport(JobExecutor.java:327)

at com.sap.inst.jload.executor.JobExecutor.executeJob(JobExecutor.java:766)

at com.sap.inst.jload.Jload.main(Jload.java:273)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:331)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

An error occured during execution. Please consult SAP note 942766 for first steps on troubleshooting the problem.

root@napa #

[sunny_pahuja2]

Hi,

It looks like that SYSTEM tablespace does not have space. Please check.

Add datafile to SYSTEM tablespace to some other file system that has space.

Thanks

Sunny

[mateus_pedroso]

Maintain your focus on these errors below. They're the cause to this issue.

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

-> check the authorizations of the Oracle executables as per oss note #583861

-> check if there are any incorrect settings in the net files (listener.ora, tnsnames.ora, sqlnet.ora)

-> the environment variables are correctly set for both <SID>adm and ora<SID> users.

-> refer note #491174 Composite SAP note for ORA-01034

[Former Member]

Hi Jose Angel

First of all, try to connect to your database as user smpadm using sqlplus / as sysdba. If this works, apply sapconn_role.sql and sapdba_role.sql again (sapdba_role.sql for both SAPSR3 and SAPSR3DB (or whatever you called them)).

If this works fine and R3trans -x still doesn't exit fine, check if sequence DDLOG_SEC exists (follow SAP Note 185821).

Next thingy to check is Oracle Instant Client (installed in /oracle/client/10x_64 or 11x_64) by invoking:

- sqlplus SAPSR3/<password>@SMP # schema of AS ABAP

- sqlplus SAPSR3DB/<password>@SMP # schema of AS Java

If they fail, correct your listener configurations (either /usr/sap/SMP/SYS/profile/oracle or /oracle/SMP/112_64/network/admin). Hint: if there is no 112_64 in your installation, create it (according to installation guide for Oracle 11g) as link from /oracle/SMP/11202 (ln -s /oracle/SMP/11202 /oracle/SMP/112_64), change all pathes in ~orasmp/.*_<hostname>.csh, relogin as orasmp, goto /oracle/SMP/112_64 and execute "relink all".

Last to check for AS Java is in Configtool. Check, that the value of the jdbc/pool/SMP/Url is pointing to your database.

Hope, I could help you any further.

Regards, Michael