Disp+work - Stopped

[Former Member]

hi,

Please let me know the exact reason behind the problem. I am putting some added info down:

> Disp+work developer trace file contents:

• WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 5233]

MtxInit: 30000 0 0

• ERROR => DpSysAdmExtCreate: ShmCreate (CREATE) [dpxxtool2.c 607]

• ERROR => dispatcher already running ???? [dpxxtool2.c 608]

• ERROR => I better EXIT before I do any (more) damage [dpxxtool2.c 610]

> dev_w0 log:

C Starting user session (con_hdl=0,svchp=062A3D08,srvhp=062B55D4,usrhp=06300CD8)

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

[dboci.c 4345]

C Detaching from DB Server (con_hdl=0,svchp=062A3D08,srvhp=062B55D4)

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

[dbsloci.c 10704]

C Try to connect with default password

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

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 0629EF98 062A4534 062A3DBC

C Attaching to DB Server SAI (con_hdl=0,svchp=062A3D08,svrhp=062B55D4)

C Starting user session (con_hdl=0,svchp=062A3D08,srvhp=062B55D4,usrhp=06300CD8)

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

[dboci.c 4345]

C Detaching from DB Server (con_hdl=0,svchp=062A3D08,srvhp=062B55D4)

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

[dbsloci.c 10704]

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#3 @ 431] [dblink 0431 ]

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

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

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

M in_ThErrHandle: 1

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

> alert_SID log:

Specified value of sga_max_size is too small, bumping to 557842432

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

Please let me know the exact reason and help me out to resolve the problem. i am new to it...

Thanks & Regards

[Former Member]

hi,

Got solved my problem via Ashok's and Markus answer. Your answer was a big clue for checking the path. Also took help of my senior consultant as well.

Thanks a lot!!!

Edited by: P.S.P on Aug 24, 2009 2:35 PM

[markus_doehr2]

What did you do prior to this error?

Markus

[Former Member]

hi,

Yesterday i installled SAP ...but someone restarted the PC directly without stopping the database...Before this it was working, but later after restarting the database is not getiing up...i am trying to this via sap console...I am not gud at sql, so dunno how to get rid of it..

Please guide me....

Regards

P.S.P.

[markus_doehr2]

The problem is, that your database is not coming up.

Try the following:

- login as <sid>adm

- open a cmd.exe

- enter "sqlplus / as sysdba"

- enter "shutdown immediate" (ignore any error messages)

- enter "startup"

What's the output?

Markus

[Former Member]

hi,

Its showing message " Unable to find file "up.sql" "

what to do now??

Thanks a lot for your time...

Regards

[anindya_bose]

when you get the SQL prompt after login in as SYSDBA ( from the command "sqlplus /as sysdba").you will get an SQL prompt.

in the sql prompt type "startup" and press enter...see below.

>SQL>startup

Let us know the message you are getting. If oracle starts up successfully , you will get lots of message like, SGA allocated, control file open , database open etc ..Then you can assume that your database is started properly..... if you are getting any error message paste the whole error message.

[markus_doehr2]

No offense but: I HIGHLY suggest you take an Oracle class.. you're trying to fiddle with software you don't even have a clue of.. if you need to recover because you system crashed this can be a very frustrating experience.

And: don't use the quotes when you enter commands, they were just to make clear what to type.

Markus

[Former Member]

hi,

Sorry, but later i updated my last thread...please check it out...

Its showing the message: " Unable to find file "up.sql" "

What could i do now??

Regards

[markus_doehr2]

No clue what this error message means and where you saw it...

Please copy and paste what you entered and what the system put out.

Markus

[Former Member]

hi,

sorry, i think i worte the wrong command last time...

But when i again tried its showing at each step as follows:

login as <sid>adm

- open a cmd.exe

-

enter "sqlplus / as sysdba" : shows connected to idle instance

-

enter "shutdown immediate" (ignore any error messages) : shows ORA : 01034 oracle not available and other message

ORA - 27101 : shared memory realm does not exists..

- enter "startup" : ORA - 16032 : parameter LOG_ARCHIVE_DEST destination string can't be translated

ORA - 09291 : sksachk : invalid device specified for archive destination

OSD - 04018 : unable to access the specified directory or device

o/s - error : <OS 3> The system can't find the path specified.

Thanks

[markus_doehr2]

It seems your installation is somwhat hosed...

Check the alert<SID>.log. You find it in

...oracle\saptrace\background

Markus

[Former Member]

hi

With todays date at the end its showing the message at the end as :

Mon Aug 24 13:07:07 2009

Starting ORACLE instance (normal)

Mon Aug 24 13:07:07 2009

Specified value of sga_max_size is too small, bumping to 557842432

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

What could be done now??

Regards

[markus_doehr2]

Is that the last entry? If yes, then I can't help you.

Something went wrong during the installation.

Markus

[Former Member]

Hi,

You check in the file init<SID>.ora for the parameter LOG_ARCHIVE_DEST and the physical existance of the path.

Regards

Ashok Dalai

Edited by: Ashok Dalai on Aug 24, 2009 9:57 AM

[Former Member]

hi

Yes this is the last entry

What do you suggest to do now??

I am using the oracle 10g for installation...

I hope nothing goes wrong with this version...

For ECC 6.0, is 10g compatible...

Regards

[Former Member]

hi,

In this for which path i have to look for??

Tell me some more details please..

Regards

[markus_doehr2]

> What do you suggest to do now??

> I am using the oracle 10g for installation...

I hope nothing goes wrong with this version...

If you do the installation according to the installation guide it will work.

Did you

- install Oracle using sapserver.cmd on the Oracle DVD? (do not use setup.exe on the DVD).

- install the latest patchset (10.2.0.4)?

- install the latest interim patch?

If you haven't done that then your installation most likely not to work.

Markus

[Former Member]

hi,

One more query please...

But when i installed the sap, at that time at the console, the dispatcher was working...But suddenly after restarting its not working....why is it so??

Also is the normal oracle software which we use for practising at home, is it same as what we install for SAP installation??

Regards

Edited by: P.S.P on Aug 24, 2009 10:06 AM

[markus_doehr2]

> But when i installed the sap, at that time at the console, the dispatcher was working...But suddenly after restarting its not working....why is it so??

I don't know - since I don't know your system. If you e. g. use external harddisks which different drive letters etc...

> Also is the normal oracle software which we use for practising at home, is it same as what we install for SAP installation??

The Oracle DVD downloadable from the Oracle site does not work by default. SAP has a special response file to set default paths and other options automatically, that's why they deliver the DVD with their software.

And just if you didn't know this:

IDES (and SAP software) - especially the normal DVDs - is not for home use. You need a license to install and run the software.

Markus

[anindya_bose]

Is your Oracle database up? If not first startup database.

Did you recently Change sga_max_size parameter?

You can also have a look at https://service.sap.com/sap/support/notes/491174

Regarding Warning messages in the last few line of your post you can check

http://www.wangz.net/sessionl.php