Error during the SAP installation in phase Start Instance

[Former Member]

Hello,

I´m doing an installation of SAP SCM 7.0 EHP3 SR1 in Suse Linux (SLES 11) with Oracle DB 11.2 (11.2.0.3).

The server has 2Gb of RAM memory with 6Gb of SWAP file.

I´m facing an error during this installation in the phase Start instance.

I checked some log files in work directory:

- dev_w0:

...

C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034:

C     ORA-01034: ORACLE not available

C  ORA-27101: shared memory realm does not exist

C  Linux-x86_64 Error: 2: No such file or directory

C  Server handle (con=0,svchp=6eb65a8,srvhp=6eb9d30) detached

C  *** ERROR => CONNECT failed with SQL error '1034'

[dbsloci.c    15546]

B Sun Mar 23 16:44:52 2014

B  ***LOG BV3=> severe db error 1034; work process is stopped [dbsh         1247]

B  ***LOG BY2=> sql error 1034   performing CON [dblink       550]

B  ***LOG BY0=> ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory [dblink       550]

M Sun Mar 23 16:44:53 2014

M  ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 000256) [thDatabase.c 75]

M Sun Mar 23 16:44:55 2014

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c   2195]

M 

M  Info for wp 0

M 

M    pid = 14485

M    severity = 0

M    status = 0

M    stat = WP_NEW

M    waiting_for = NO_WAITING

M    workerType = DP_WORKER_DIAWP

M    act_cs_count = 0

M    csTrack = 0

M    csTrackRwExcl = 0

M    csTrackRwShrd = 0

M    mode_cleaned_counter = 0

M    control_flag = 0

M    report = >                                        <

M    action = 0

M    tab_name = >                              <

M 

M  ThIErrHandle: no current incoming request

M 

M  PfRejectStatistic: clear statistic record

M  PfClearAllRec: clear statistic area

M  PfClearAllRec: statRecordAction = STAT_RECORD_ACTION_REJECT

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hooks for event BEFORE_DUMP

M  ThIErrHandle: entering ThSetStatError

M  ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M  call ThrShutDown (1)...

M  SigIUnblock: signal SIGALRM was in UNBLOCKED mode

M  ThAlarmActivateDuringAlarmHandler: set alarm to 60 sec

M  ***LOG Q02=> wp_halt, WPStop (Workp. 0 14485) [dpuxtool.c   318]

M  Good Bye (-1).....

Then I tried other thing... I manually started the oracle listener service (with ora<sid> user) using the lsnrctl start command and I also started the oracle database using the SQL plus:

SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area  463536128 bytes
Fixed Size      2229264 bytes
Variable Size    239078384 bytes
Database Buffers   213909504 bytes
Redo Buffers      8318976 bytes
Database mounted.
Database opened.

So I retried the installation but again it stopped in the same phase Start Instance. I checked again the dev_w0 log file and I see in there the following log:

...

C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 3135:

C Sun Mar 23 16:20:18 2014

C     ORA-03135: connection lost contact                                                                                           

C  Server handle (con=0,svchp=6e8f7b8,srvhp=6e92f40) detached

C Sun Mar 23 16:20:23 2014

C  *** ERROR => CONNECT failed with SQL error '3135'

[dbsloci.c    15546]

B Sun Mar 23 16:20:41 2014

B  ***LOG BY2=> sql error 3135   performing CON [dbsh         1252]

B  ***LOG BY0=> ORA-03135: connection lost contact [dbsh         1252]

B  ***LOG BY2=> sql error 3135   performing CON [dblink       550]

B  ***LOG BY0=> ORA-03135: connection lost contact [dblink       550]

M  ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 000256) [thDatabase.c 75]

M  in_ThErrHandle: 1

M Sun Mar 23 16:20:46 2014

M  *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c   2195]

M Sun Mar 23 16:20:54 2014

...

...

C  Attaching to database server S1O (con=0, svchp=6eb65a8, srvhp=6eb9d30)

C Sun Mar 23 16:44:48 2014

C  Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=6eb65a8, srv=6eb9d30, usr=6ee86b0)

C Sun Mar 23 16:44:50 2014

C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034:

C     ORA-01034: ORACLE not available

C  ORA-27101: shared memory realm does not exist

C  Linux-x86_64 Error: 2: No such file or directory

C  Server handle (con=0,svchp=6eb65a8,srvhp=6eb9d30) detached

C  *** ERROR => CONNECT failed with SQL error '1034'

[dbsloci.c    15546]

B Sun Mar 23 16:44:52 2014

B  ***LOG BV3=> severe db error 1034; work process is stopped [dbsh         1247]

B  ***LOG BY2=> sql error 1034   performing CON [dblink       550]

B  ***LOG BY0=> ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory [dblink       550]

M Sun Mar 23 16:44:53 2014

M  ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 000256) [thDatabase.c 75]

M Sun Mar 23 16:44:55 2014

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c   2195]

M 

M  Info for wp 0

M 

M    pid = 14485

M    severity = 0

M    status = 0

M    stat = WP_NEW

M    waiting_for = NO_WAITING

M    workerType = DP_WORKER_DIAWP

M    act_cs_count = 0

M    csTrack = 0

M    csTrackRwExcl = 0

M    csTrackRwShrd = 0

M    mode_cleaned_counter = 0

M    control_flag = 0

M    report = >                                        <

M    action = 0

M    tab_name = >                              <

M 

M  ThIErrHandle: no current incoming request

M 

M  PfRejectStatistic: clear statistic record

M  PfClearAllRec: clear statistic area

M  PfClearAllRec: statRecordAction = STAT_RECORD_ACTION_REJECT

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hooks for event BEFORE_DUMP

M  ThIErrHandle: entering ThSetStatError

M  ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M  call ThrShutDown (1)...

M  SigIUnblock: signal SIGALRM was in UNBLOCKED mode

M  ThAlarmActivateDuringAlarmHandler: set alarm to 60 sec

M  ***LOG Q02=> wp_halt, WPStop (Workp. 0 14485) [dpuxtool.c   318]

M  Good Bye (-1).....

Can you help me please to solve this error?

Kind regards,

samid raif

[former_member188883 · Accepted solution]

Hi Samid,

 You mentioned
The server has 2Gb of RAM memory with 6Gb of SWAP file.
 I´m facing an error during this installation in the phase Start instance.

Is the server having only 2 GB RAM ??

If yes, I do not expect this installation to complete. Oracle may not be able to start properly and even if it starts with some adjustment, SAP application will not start.

Suggestion would be to make the RAM atleast 6 GB to have the installation completed.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hello Deepak Kori,

You´re right! Definitely the cause for this error was the RAM memory.

I increased the server memory (to 6Gb) and now it is already possible to start the instance. I retry this installation from the error phase and the error was overcome.

Thank you very much to all of you for try to help me!

samid raif

[Sriram2009]

Hi Samid

Check this SAP Notes

491174 - Composite SAP note for ORA-01034

131561 - Work processes sometimes abend during database connect

  403004 - Database connect using R3trans fails

491174 - Composite SAP note for ORA-01034

BR

SS

[former_member182657]

Hi Samid,

1.Try to check about your database & listener services are running or not You can use command

ps -ef |grep ora & share the result with us also.

2.It could be issue with ORACLE_HOME .Share value for this parameter with command echo $ORACLE_HOME .

(e.g  /oracle/<SID>/112_64  >>correct value)

To start database first need to set one parameter as like below:

ora<sid> setenv DISABLE_HUGETLBFS 1

>sqlplus "/as sysdba"

> startup

After that retry the phase,if still issue persists share the log file from /tmp/sapinst_instdir/.....

Thanks,

Gaurav