[HPADM] SUMMARY Oracle subsystem does not start automatically

From: Paul.Soltermann@vonroll-isola.com
Date: Fri Jun 21 2002 - 10:49:59 EDT


Hi,
The problem was: the OMNIBACK postexec-job was running at the same
time as a other process, who shuld start a save while after the backup has
finished.

The replay from Philip Ladouceur "you may have a lock session hanging"
was very close.

Thanks a lot for your help !

----- Weitergeleitet von Paul Soltermann/ISOLA am 2002/06/21 14:34 -----
                                                                                                         
                    Paul.Soltermann@vonroll
                    -isola.com An: hpux-admin@dutchworks.nl
                    Gesendet von: Kopie:
                    hpux-admin-owner@DutchW Thema: [HPADM] Oracle subsystem does not start
                    orks.nl automatically
                                                                                                         
                                                                                                         
                    2002/06/19 13:56
                                                                                                         
                                                                                                         

Hallo,

After backup of server 'HP-APP' the Oracle subsystem does not start
automatically since several days ..
Involved Modules: HP-UX 10.20 , Oracle 7.3.3 and OMNIMACK II (WinNT)

I checked the following logfiles:
hp-app:/usr/oracle7.3.3/console.out
hp-app:/usr/oracle7.3.3/console.err
hp-app:/var/opt/omni/log/debug.log
/omni/log/RDS.log (I got a newer file only with no errors)

What can I do ?

Eintrag (Ausschnitt) in: hp-app:/usr/oracle7.3.3/console.out
------------------------------------------------------------
Am 18.06.02 Zeit 05.56 (das Fehlerprotokoll console.err ist leer)

SVRMGR> SVRMGR> Connected to an idle instance.
SVRMGR> Connected to an idle instance.
SVRMGR> ORA-07306 (siehe unten): sms1sg: shmget error, unable to get a
shared memory segment.
HP-UX Error: 17: File exists
Additional information: 1
SVRMGR>
Server Manager complete.

Database "bpcs" warm started.
ORA-07264 (siehe unten): spwat: semop error, unable to decrement semaphore.
HP-UX Error: 22: Invalid argument
Additional information: 42001

Eintrag (Ausschnitt) in: hp-app:/var/opt/omni/log/debug.log
-----------------------------------------------------------

06/15/02 02:05:02 INET.24877.0 ["PANSRC/lib/ipc/RCS/ipc.c,v 1.276":6136]
A.03.00 b670
IpcGetPeer: Could not expand ConnectionIP "192.168.232.52"

06/17/02 07:56:55 INET.1588.0 ["PANSRC/lib/ipc/RCS/ipc.c,v 1.276":6130]
A.03.00 b670
[IpcGetPeer] gethostbyaddr(&(hostip=3232294964), 4, AF_INET) failed
(h_errno=1)

06/17/02 07:56:55 INET.1588.0 ["PANSRC/lib/ipc/RCS/ipc.c,v 1.276":6136]
A.03.00 b670
IpcGetPeer: Could not expand ConnectionIP "192.168.232.52"

06/17/02 07:56:57 MMA.1588.0 ["PANSRC/ma/spt/RCS/sctl.c,v 1.69":238]
A.03.00 b670
SCTL_io: ioctl(fd=5, SCTL_IOCTL, cmd) failed. cdb_length=10, {errno=22}
dump:
        4d 00 2e 00 00 00 00 01
        44 00 00 00 00 00 00 00
        [18-Jun-02 12:18:49] Logout for session 3

 Schweizerische I s o l a - W e r
 k e A G
 Paul Soltermann
 Passwangstrasse 20
 CH-4226 Breitenbach
 Phone: +41 61 785 56 47 Natel
 079 4597835
 Email:
 paul.soltermann@vonroll-isola.com

--
             ---> Please post QUESTIONS and SUMMARIES only!! <---
        To subscribe/unsubscribe to this list, contact
majordomo@dutchworks.nl
       Name: hpux-admin@dutchworks.nl     Owner:
owner-hpux-admin@dutchworks.nl
 Archives:  ftp.dutchworks.nl:/pub/digests/hpux-admin       (FTP, browse
only)
            http://www.dutchworks.nl/htbin/hpsysadmin   (Web, browse &
search)
--
             ---> Please post QUESTIONS and SUMMARIES only!! <---
        To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
       Name: hpux-admin@dutchworks.nl     Owner: owner-hpux-admin@dutchworks.nl
 
 Archives:  ftp.dutchworks.nl:/pub/digests/hpux-admin       (FTP, browse only)
            http://www.dutchworks.nl/htbin/hpsysadmin   (Web, browse & search)


This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 11:02:15 EDT