Problem with start instance SAP DEV.

[Former Member]

Hi, Good Morning,

I try start my server SAP Dev but not work, i try start it for  three days, but i not have solutions.

Below has the log file dev_w0.  I can't find the solution , the oracle work all services, I rebooted the server, i checked the services, i checked de listerner, and not start the instance.

In this server , I have two instance , PRD and DEV, the system PRD works normally.

My company is small because this have only one server, we have 15 employees working together.

---------------------------------------------------

trc file: "dev_w0", trc level: 1, release: "700"

M Mon Mar 26 16:41:19 2012

M  calling db_connect ...

C  Prepending D:\usr\sap\CSD\DVEBMGS00\exe to Path.

C  Oracle Client Version: '10.2.0.2.0'

C  Client NLS settings: AMERICAN_AMERICA.UTF8

C  Logon as OPS$-user to get SAPSR3's password

C  Connecting as /@CSD on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      1 0000000012AB20C0 000000000A9DB360 000000000A9E0B88

C  Attaching to DB Server CSD (con_hdl=0,svchp=000000000A9E0A48,srvhp=0000000012AD1118)

C  Starting user session (con_hdl=0,svchp=000000000A9E0A48,srvhp=0000000012AD1118,usrhp=000000000A9DBB78)

C  *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034

[dboci.c      4532]

C  Detaching from DB Server (con_hdl=0,svchp=000000000A9E0A48,srvhp=0000000012AD1118)

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

[dbsloci.c    11145]

C  Try to connect with default password

C  Connecting as SAPSR3/<pwd>@CSD on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      1 0000000012AB20C0 000000000A9DB360 000000000A9E0B88

C  Attaching to DB Server CSD (con_hdl=0,svchp=000000000A9E0A48,srvhp=0000000012AD1118)

C  Starting user session (con_hdl=0,svchp=000000000A9E0A48,srvhp=0000000012AD1118,usrhp=000000000A9DBB78)

C  *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034

[dboci.c      4532]

C  Detaching from DB Server (con_hdl=0,svchp=000000000A9E0A48,srvhp=0000000012AD1118)

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

[dbsloci.c    11145]

B  ***LOG BV3=> severe db error 1034      ; work process is stopped [dbsh#2 @ 1199] [dbsh    1199 ]

B  ***LOG BY2=> sql error 1034   performing CON [dblink#5 @ 431] [dblink  0431 ]

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

ORA-27101: shared memory realm does not exist [dblink#5 @ 431] [dblink  0431 ]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1449]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   10524]

[Former Member]

Thank you Juan,

I solved the problem...

I try start de data with command line and recice this menssagem.

net start OracleServiceSID
net start SAPSID_00
net start SAPSID_01

sqlplus /nolog

conn /as sysdba

startup

ORA-02778: Name given for the log directory is invalid

the data went started but no mount, because de folders of log was deleted (i think of de network administrator deleted in the backup.)

i only fixed the location directory into this two files into D:\oracle\SID\SID

SPFILESID.ORA
initSID.ora

this link help me to solved.

https://forums.oracle.com/forums/thread.jspa?threadID=553054

[Former Member]

Is your DB started?.... what have you done so far to fix the problem?...

Yes , my DB is started,

What I have done so far fiz the problem, ok.

1) try to restart al services, not work
2) try to restart ther server, not work
3) in this server the capacity is very small, so, i down the PRD system and start the DEV server. not Work.

obs. My sap is NW 7 ABAP + Java, the capacity of my server is P4 wtih 8 GB of memory, we have little user logged daily..

the environment variables i didn't do changes, the swap is 25 GB, all disc have space,  I changed the parameter of memory on profile PHYS_MEMSIZE = 1024, on the production server is work very best... bebore the change my server during 20 minutis to start ABAP and JAVA, but now start in 4 minutes.

[Former Member]

This is log Listener.

LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 27-MAR-2012 11:58:46

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

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=CSD.WORLD))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Production
Start Date                26-MAR-2012 16:32:43
Uptime                    0 days 19 hr. 26 min. 3 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\oracle\CSD\102\network\admin\listener.ora
Listener Log File         D:\oracle\CSD\102\network\log\listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\CSD.WORLDipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\CSDipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cssap)(PORT=1527)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\CSP.WORLDipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\CSPipc)))
Services Summary...
Service "CSD" has 1 instance(s).
  Instance "CSD", status UNKNOWN, has 1 handler(s) for this service...
Service "CSP" has 1 instance(s).
  Instance "CSP", status UNKNOWN, has 2 handler(s) for this service...
The command completed successfully

[JPReyes]

I think you could potentially have a "bottleneck"

If the last time that it worked was before you change the memory parameter for your production system then undo the changes.

But having your whole environment in a single box with very low resources doesnt leave you much space for performance tunning.

Hardware is very cheap this days so I recommend you to at least get a second box and move you DEV and QAS system to a separate box.

Regards, Juan

[JPReyes]

B  ***LOG BY0=> ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist [dblink#5 @ 431] [dblink  0431 ]

Is your DB started?.... what have you done so far to fix the problem?...

Refer to SAP Note 491174 - Composite SAP note for ORA-01034

Regards, Juan