My Oracle Support Banner

ORA-01034, ORA-27123, HP-UX Error 22 Connecting Via Oracle Net (Doc ID 384262.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Net Services - Version: 9.2.0.1.0 to 10.2.0.5 - Release: 9.2 to 10.2
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.5   [Release: 9.2 to 10.2]
Information in this document applies to any platform.

Symptoms

Environment:
Server: Oracle9i R2 (9207) w/ CPUJul2006 on HP-UX 11.11
Client: Oracle9i or 10g client.

Customer reports the following error every time they try to connect to the Oracle9i R2
(9.2.0.7) database using Oracle Net, either locally on the server or from a remote client using
Sqlplus:

ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
HP-UX Error: 22: Invalid argument
Additional information: 1
Additional information: 2063


The server trace shows the following:
....
[03-AUG-2006 15:26:16:351] nttwr: socket 13 had bytes written=216
[03-AUG-2006 15:26:16:351] nttwr: exit
[03-AUG-2006 15:26:16:351] nspsend: 216 bytes to transport
[03-AUG-2006 15:26:16:351] nspsend: packet dump
[03-AUG-2006 15:26:16:351] nspsend: 00 D8 00 00 06 00 00 00 |........|
[03-AUG-2006 15:26:16:351] nspsend: 00 00 04 01 01 00 02 04 |........|
[03-AUG-2006 15:26:16:351] nspsend: 0A 00 00 00 00 00 00 00 |........|
[03-AUG-2006 15:26:16:351] nspsend: 00 00 00 00 00 00 00 00 |........|
[03-AUG-2006 15:26:16:351] nspsend: 00 00 02 00 00 00 00 00 |........|
[03-AUG-2006 15:26:16:352] nspsend: 00 AE 4F 52 41 2D 30 31 |..ORA-01|
[03-AUG-2006 15:26:16:352] nspsend: 30 33 34 3A 20 4F 52 41 |034:.ORA|
[03-AUG-2006 15:26:16:352] nspsend: 43 4C 45 20 6E 6F 74 20 |CLE.not.|
[03-AUG-2006 15:26:16:352] nspsend: 61 76 61 69 6C 61 62 6C |availabl|
[03-AUG-2006 15:26:16:352] nspsend: 65 0A 4F 52 41 2D 32 37 |e.ORA-27|
[03-AUG-2006 15:26:16:352] nspsend: 31 32 33 3A 20 75 6E 61 |123:.una|
[03-AUG-2006 15:26:16:352] nspsend: 62 6C 65 20 74 6F 20 61 |ble.to.a|
[03-AUG-2006 15:26:16:352] nspsend: 74 74 61 63 68 20 74 6F |ttach.to|
[03-AUG-2006 15:26:16:352] nspsend: 20 73 68 61 72 65 64 20 |.shared.|
[03-AUG-2006 15:26:16:352] nspsend: 6D 65 6D 6F 72 79 20 73 |memory.s|
[03-AUG-2006 15:26:16:352] nspsend: 65 67 6D 65 6E 74 0A 48 |egment.H|
[03-AUG-2006 15:26:16:352] nspsend: 50 2D 55 58 20 45 72 72 |P-UX.Err|
[03-AUG-2006 15:26:16:352] nspsend: 6F 72 3A 20 32 32 3A 20 |or:.22:.|
[03-AUG-2006 15:26:16:352] nspsend: 49 6E 76 61 6C 69 64 20 |Invalid.|
[03-AUG-2006 15:26:16:353] nspsend: 61 72 67 75 6D 65 6E 74 |argument|
[03-AUG-2006 15:26:16:353] nspsend: 0A 41 64 64 69 74 69 6F |.Additio|
[03-AUG-2006 15:26:16:353] nspsend: 6E 61 6C 20 69 6E 66 6F |nal.info|
[03-AUG-2006 15:26:16:353] nspsend: 72 6D 61 74 69 6F 6E 3A |rmation:|
[03-AUG-2006 15:26:16:353] nspsend: 20 31 0A 41 64 64 69 74 |.1.Addit|
[03-AUG-2006 15:26:16:353] nspsend: 69 6F 6E 61 6C 20 69 6E |ional.in|
[03-AUG-2006 15:26:16:353] nspsend: 66 6F 72 6D 61 74 69 6F |formatio|
[03-AUG-2006 15:26:16:353] nspsend: 6E 3A 20 32 30 36 33 0A |n:.2063.|
[03-AUG-2006 15:26:16:353] nspsend: normal exit
[03-AUG-2006 15:26:16:353] nsdofls: exit (0)
[03-AUG-2006 15:26:16:353] nsdo: nsctxrnk=0
....

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.