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

[Former Member]

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

[former_member189725 · Accepted solution]

Please ensure ORACLE_HOME and ORACLE_SID are set correctly for user <sid>adm.

[Former Member · Accepted solution]

sapds:tstadm 22> env

HOME=/home/tstadm

PATH=/oracle/TST/112_64/bin:.:/home/tstadm:/usr/sap/TST/SYS/exe/run:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/ipf/bin:/opt/gvsd/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/sas/bin:/opt/ssh/bin:/opt/mx/bin:/opt/graphics/common/bin:/opt/atok/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/sec_mgmt/bastille/bin:/opt/caliper/bin:/opt/drd/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/resmon/bin:/opt/firefox:/opt/gnome/bin:/opt/perf/bin:/opt/ignite/bin:/usr/contrib/kwdb/bin:/opt/mozilla:/opt/perl_32/bin:/opt/perl_64/bin:/opt/prm/bin:/opt/sfm/bin:/opt/swm/bin:/opt/sec_mgmt/spc/bin:/opt/sentinel/bin:/opt/swa/bin:/opt/hpsmh/bin:/opt/thunderbird:/opt/langtools/bin:/opt/wlm/bin:/opt/gwlm/bin:/opt/hp-gcc/bin:/opt/hpvm/bin

LOGNAME=tstadm

SHELL=/usr/bin/csh

TERM=xterm

COLUMNS=157

LINES=62

MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/ldapux/share/man/%L:/opt/ldapux/share/man:/opt/ipf/man:/opt/ldapux/ypldapd/man:/opt/samba/man:/opt/samba/WTEC_Support_Tools/man:/opt/samba/cfsm_man:/opt/cifsclient/share/man:/opt/openssl/man:/opt/openssl/prngd/man:/opt/wbem/share/man:/opt/hpsmdb/pgsql/man:/opt/ssh/share/man:/opt/mx/share/man/%L:/opt/mx/share/man:/opt/graphics/common/man:/opt/amgr/man:/opt/amgr/man/%L:/opt/sec_mgmt/share/man:/opt/caliper/man/%L:/opt/caliper/man:/opt/drd/share/man/%L:/opt/drd/share/man:/opt/dsau/man:/opt/resmon/share/man/%L:/opt/resmon/share/man:/opt/gnome/man:/opt/perf/man/%L:/opt/perf/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/usr/contrib/kwdb/share/man:/opt/perl_32/man:/opt/perl_64/man:/opt/prm/man/%L:/opt/prm/man:/opt/sfmdb/pgsql/man:/opt/sfm/share/man:/opt/swm/share/man/%L:/opt/swm/share/man:/opt/swa/share/man/%L:/opt/swa/share/man:/opt/sentinel/man/%L:/opt/sentinel/man:/opt/langtools/share/man/%L:/opt/langtools/share/man:/opt/wlm/share/man/%L:/opt/wlm/share/man:/opt/openssl/fips/0.9.7/man:/opt/gwlm/man/%L:/opt/gwlm/man:/opt/icod/man/%L:/opt/icod/man:/opt/EMCpower/share:/usr/dt/share/man:/opt/hp-gcc/man:/opt/hpvm/share/man/%L

TZ=MET-1METDST

SAPSYSTEMNAME=TST

DIR_LIBRARY=/usr/sap/TST/SYS/exe/run

SHLIB_PATH=/usr/sap/TST/SYS/exe/run:/oracle/client/11x_64/instantclient

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=TST

ORACLE_PSRV=TST

ORACLE_SID=TST

ORACLE_HOME=/oracle/TST/112_64

ORACLE_BASE=/oracle

NLS_LANG=AMERICAN_AMERICA.WE8DEC

SAPDATA_HOME=/oracle/TST

LD_LIBRARY_PATH=/oracle/TST/112_64/lib64

-

---

I think the environment is OK.

I can also do tnsping with tstadm user without any problems

But still startsap is no working

Ruzica

[Former Member]

What about SAP profiles?

adapted with correct parameters?

DIR_CLIENT_ORAHOME and DIR_SERVER_ORAHOME ?

R3trans u2013d

should give:

R3trans finished (0000).

I assume your listerner.ora and tnsnames.ora are adapted according upgrade guide

Regards

Stanislav

[Former Member]

I've removed the proposed line from tnsnames :

LISTENER_TST.WORLD = (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = sapds)(PORT =3430))

Now it is OK

Tnx,

Ruzica

[Former Member]

I believe that R3trans -d gives you same error like posted?

I see you have oracle client 11, has your kernel meet prerequisities for this client?

Note 819829 - Oracle Instant Client Installation and Configuration on Unix

When you replace the 10.2 instant client on the SAP application server with the 11.2 instant client you have to ensure that the software requirements for the new instant client version are met. Check the software requirements in the Database Client Installation Guide for your platform in the Oracle Database Documentation Library for Release 11.2 [http://www.oracle.com/pls/db112/homepage]

For minimum SAP kernel version required with Instant Client 11.2 see SAP note 1331586. If you have an too old SAP kernel installed, you get 'ORA-24315: illegal attribute type'.

Regard

Stanislav

[Former Member]

When I've installed the oracle client 11 before the upgrade I checked the Oracle and SAP instance, everything was working fine.

That's why i don't assume the oracle client is the problem

BR,

Ruzica