Skip to Content
0
Former Member
Nov 30, 2011 at 08:39 AM

ORA-01034: ORACLE not available ORA-27101 and HPUX-ia64 Error: 2:

1394 Views

Hello,

I did Oracle upgrade from 10.2.0.4 to 11.2.0.2 on HP-UX 11.31.

Everything went smooth except the last comand : startsap.

- I start listener every thing is OK. (I've checked there is no listener and tnsnames in /etc/ just in /oracle/TST/112_64/network/admin)

- tnsping TST is workingfor both users oratst and tstadm.

- I cheked the sqlplus SAPR3/passwd@TST it is OK

The DB can be started from sqlplus with user oratst, but then if I try to star the sap instance

4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 10068 0.233465

4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034: 172 0.233637

4 ETW000 [ dev trc,00000] ORA-01034: ORACLE not available 24 0.233661

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 HPUX-ia64 Error: 2: No such file or director

4 ETW000 [ dev trc,00000] y

4 ETW000 46 0.233707

4 ETW000 [ dev trc,00000] server_detach(con=0,stale=1,svrhp=6000000000aac730) 20 0.233727

4 ETW000 [ dev trc,00000] Detaching from DB Server (con=0,svchp=6000000000aaaec8,srvhp=6000000000aac730)

4 ETW000 29 0.233756

4 ETW000 [ dev trc,00000] Deallocating server context handle 6000000000aac730 from con=0 891 0.234647

4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1034' 358 0.235005

4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1034 33 0.235038

4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1034) 19 0.235057

4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1034 26 0.235083

4 ETW000 [ dev trc,00000] ORA-01034: ORACLE not available 21 0.235104

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 HPUX-ia64 Error: 2: No such file or director

4 ETW000 [ dev trc,00000] y

4 ETW000 115 0.235219

4 ETW000 [ dev trc,00000] SAPUSER or connect error 99=DBSL_ERR_DB, oerr=1034. 71 0.235290

4 ETW000 [ dblink ,00433] ***LOG BY2=>sql error 1034 performing CON [dblink#8 @ 433] 173 0.235463

4 ETW000 [ dblink ,00433] **LOG BY0=>ORA-01034: ORACLE not available* 30 0.235493

4 ETW000 ORA-27101: shared memory realm does not exist4 ETW000 HPUX-ia64 Error: 2: No such file or directory [dblink#8 @ 433]

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'TST'"

I've check the Note 491174 - Composite SAP note for ORA-01034 and everything seams to me ok.

Does anyone knows why I can't startsap?

Thank you in advance.

BR,

Ruzica