Oracle database doesn't start with startsap.

[Former Member]

Hello guys,

i have the following problem:

i have an XI instance (kernel 6.40), Oracle 11. i guess that after Oracle upgrade the database doesn't start anymore with startsap db or startsap (we have aliases, so it is not necessary to write a virual hostname afterwards). I get the message:

w003060:x37adm> startsap

Checking X37 Database

-

---

ABAP Database is not available via R3trans

Starting SAP Instance SCS77

-

---

Startup-Log is written to /export/home/x37adm/startsap_SCS77.log

Instance on host w003060 started

Starting SAP-Collector Daemon

-

---

***********************************************************************

• This is Saposcol Version COLL 20.95 640 - V3.73 64Bit

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 3676) is already running .....

************************************************************************

saposcol already running

ABAP Database X37 must be started on remote server

But the database locates on the same server.

If i start the database first with sqlplus and startup, then afterwards startsap r3 works properly and SAP instance startes.

R3trans -d brings the following logs:

...

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 25155 0.088289

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPDAT's password 115 0.088404

4 ETW000 [dev trc ,00000] Connecting as /@X37 on connection 0 (nls_hdl 0) ... (dbsl 640 130111, UNICODE[2])

4 ETW000 84 0.088488

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalChar C EnvHp ErrHp ErrBt

4 ETW000 53 0.088541

4 ETW000 [dev trc ,00000] 0 (UTF8) 1 0x101ae5790 0x101af0ba8 0x101b15668

4 ETW000 52 0.088593

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 79 0.088672

4 ETW000 [dev trc ,00000] Allocating server context handle 32 0.088704

4 ETW000 [dev trc ,00000] Attaching to DB Server X37 (con_hdl=0,svchp=0x101af0ac8,srvhp=0x101b16bb0)

4 ETW000 141 0.088845

4 ETW000 [dev trc ,00000] Assigning server context 0x101b16bb0 to service context 0x101af0ac8

4 ETW000 59274 0.148119

4 ETW000 [dev trc ,00000] Allocating user session handle 87 0.148206

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x101af0ac8,srvhp=0x101b16bb0,usrhp=0x101b479a0)

4 ETW000 80 0.148286

4 ETW000 [dboci.c ,00000] **** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034*

4 ETW000 6913 0.155199

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 39 0.156053

4 ETW000 [dev trc ,00000] SAPUSER or connect error rc=99, oerr=1034. 177 0.156230

4 ETW000 [dblink ,00430] ***LOG BY2=>sql error 1034 performing CON [dblink#6 @ 430]

4 ETW000 198 0.156428

4 ETW000 [dblink ,00430] ***LOG BY0=>ORA-01034: ORACLE not available 37 0.156465

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

4 ETW000 SVR4 Error: 2: No such file or directory [dblink#6 @ 430]

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

I have checked tnsnames.ora, listener.ora and environment files ( i have Solaris sparc OS on this server) .dbenv.sh, sapenv.sh, .profile, but couldn't find anything yet.

-

---

disp+work information

-

---

kernel release 640

kernel make variant 640_EX2

compiled on SunOS 5.9 Generic_122300-13 sun4u for "sun_64"

compiled for 64 BIT

compilation mode UNICODE

compile time Mar 6 2011 21:15:59

update level 0

patch number 368

...

Thanks in advance for any good advices!

regards,

Polina

[former_member509448]

Hello

I have the same issue. How did you solve it?

Thanks and regards

[Former Member]

Hi,

Please copy the tnsname.ora and listener.ora to both the locations I spefied earlier, if its not existing please create the same

/oracle/SID/112_64/network/admin

/sapmnt/SID/profile/oracle

Also please check the contents of tnsnames.ora it should be having the entry like below

LISTENER_SID.WORLD =

(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = hostname)(PORT = 1527))

and listener.ora should have following entry

ADR_BASE_LISTENER=/oracle/SID/saptrace

You can also set the environment variable TNS_ADMIN to the path where your tnsnames.ora file is existing.

Regards,

Sarita

[Former Member]

Please check tnsnames.ora and listener.ora at two locations, while starting SAP & DB through startsap it checks both the locations.

/oracle/SID/102_64/network/admin

/sapmnt/SID/profile/oracle

[Former Member]

Hi Sarita,

it seems that XI 3.0 (Netweaver 04) doesn't have this "oracle" directory in /sapmnt/SID/profile/ yet. i have checked tnsnames.ora and listener.ora at the standard location (in my case in /oracle/SID/112_64/network/admin ) and haven't found anything strange

regards,

Polina

[Former Member]

Hi,

Please follow the note 361641 & execute the sql scripty oradbusr.sql attached in 50088

UNIX: sqlplus /NOLOG @oradbusr.sql SCHEMAOWNER UNIX SAP_SID x

NT: sqlplus /nolog @oradbusr.sql SCHEMAOWNER NT COMPUTER|DOMAIN SAP_SID

Use your schema owner "SAPDAT" in the parameter SCHEMAOWNER.

[Former Member]

Hi Mrinal,

why do you suggest me to create the user OPS$? i think it exist already in th edatabase. I can check.

thanks and regards,

Polina

[former_member311580]

Dear Polina,

I think that R3trans -D showing ORA-1034 and ORA-27101 errors is because really the database is not started, or your environment is configured incorrectly.

First ensure that your database is started. Second, perhaps there are wrong environment variables defined. If you have an incorrect ORACLE_HOME/ORACLE_SID combination, the database won't be found and the ORA-1034 error is raised.Check SAP note

491174 - Composite SAP note for ORA-01034

Regarding error ORA-27101: shared memory realm does not exist, please also refer to the note

546006 - Problems with Oracle due to operating system error

Please, execute R3trans -x and provide the log trans.log.

Also, see startsap_SCS77.log, and startdb.log

Regards,

Rafa

[former_member185031]

Can you please post the Oracle environemnt log. usually this error represents that Oracle environemnt variable does not set correctly.

Regards,

Subhash

[Former Member]

Hi Subhash,

sure:

w003060:orax37> env

_=/usr/bin/env

MANPATH=:/opt/VRTS/man:/usr/sfw/man:/usr/sfw/share/man:/usr/symcli/man:/opt/VRTS/man:/usr/sfw/man:/usr/sfw/share/man:/usr/symcli/man:/opt/SMAW/man:/opt/nsr/man

THREAD=NOPS

HZ=

PAGER=pg

ORACLE_PSRV=X37

PATH=/oracle/X37/112_64/bin:.:/export/home/orax37:/usr/sap/X37/SYS/exe/run:/usr/bin::/usr/local/bin:/oi4tools2/scripts:/usr/ucb:/usr/symcli/bin:/usr/symcli/bin:/opt/SMAW/bin:/opt/SMAW/sbin:/opt/nsr:/usr/ccs/bin

NLS_LANG=AMERICAN_AMERICA.UTF8

ORACLE_BASE=/oracle

EDITOR=vi

HISTFILE=/export/home/orax37/.sh_history_dev_pts_2

LOGNAME=orax37

MAIL=/usr/mail/orax37

dbs_ora_tnsname=X37

ORACLE_SID=X37

PS1=w003060:orax37>

DB_SID=X37

PS2=w003060>

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

dbs_ora_schema=SAPDAT

SHELL=/bin/ksh

SAPDATA_HOME=/oracle/X37

HOME=/export/home/orax37

FCEDIT=vi

LD_LIBRARY_PATH=/opt/SMAW/lib:/usr/sap/X37/SYS/exe/run:/usr/sap/X37/SYS/exe/runU:/oracle/X37/112_64/lib

TERM=dtterm

ORACLE_HOME=/oracle/X37/112_64

PWD=/X37ENV/export/home/orax37

TZ=MET

dbms_type=ORA

SAPSYSTEMNAME=X37

regards & thanks in advance!

Polina

[former_member185031]

Hi Polina,

This Seems wrong to me .

dbs_ora_schema=SAPDAT

Regards,

Subhash

[Former Member]

Hello

I do concur with Subhash, dbs_ora_schema should be SAPSR3 not SAPDATA.

Also check dbs_ora_tnsname pointing to SID.

I didn't see that in the env log of yours. Kindly ensure that is also having proper value in environment variables.

Kindly set that and restart the system it should work.

Regards

Vivek

[Former Member]

Hi Subhash,

the dbs_ora_schema is correct like that, we really have SAPDAT.

regards,

Polina

[Former Member]

You posted the environment of user orax37; but what about the environment of user x37adm?

Another idea: For users orax37 and x37adm compare the output of:

tnsping X37

regards

[Former Member]

Hi Vivek,

dbs_ora_tnsname=X37 in both env of x37adm and orax37.

dbs_ora_schema=SAPDAT - that is correct in my case.

Something else seems to be wrong.

regards,

Polina

[Former Member]

Hi Joe,

ok, here the environment of x37adm:

w003060:x37adm> env

_=/bin/env

MANPATH=:/opt/VRTS/man:/usr/sfw/man:/usr/sfw/share/man:/usr/symcli/man:/opt/VRTS/man:/usr/sfw/man:/usr/sfw/share/man:/usr/symcli/man:/opt/SMAW/man:/opt/nsr/man

THREAD=NOPS

HZ=

PAGER=pg

ORACLE_PSRV=X37

PATH=/oracle/X37/112_64/bin:/usr/j2sdk1.4.2_27/bin:/export/home/x37adm:/usr/sap/X37/SYS/exe/run:/bin:/usr/bin:/usr/local/bin:.:/usr/ccs/bin:/usr/ucb:/oi4tools2/scripts

NLS_LANG=AMERICAN_AMERICA.UTF8

ORACLE_BASE=/oracle

EDITOR=vi

HISTFILE=/export/home/x37adm/.sh_history_dev_pts_2

LOGNAME=x37adm

RFCEXEC_SEC_FILE_PATH=/usr/sap/X37/SYS/global/security/data

MAIL=/var/mail/x37adm

dbs_ora_tnsname=X37

ORACLE_SID=X37

PS1=w003060:x37adm>

DB_SID=X37

PS2=w003060>

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

USER=x37adm

DIR_EXECUTABLE=/usr/sap/X37/SYS/exe/run

dbs_ora_schema=SAPDAT

SHELL=/bin/ksh

JAVA_HOME=/usr/j2sdk1.4.2_27

SECUDIR=/usr/sap/X37/DVEBMGS37/sec

SAPDATA_HOME=/oracle/X37

HOME=/export/home/x37adm

FCEDIT=vi

LD_LIBRARY_PATH=/usr/sap/X37/SYS/exe/run:/oracle/client/11x_64/instantclient

TERM=dtterm

ORACLE_HOME=/oracle/X37/112_64

PWD=/X37ENV/export/home/x37adm

TZ=MET

dbms_type=ORA

SAPSYSTEMNAME=X37

It seems that both outputs are same:

:orax37> tnsping X37

TNS Ping Utility for Solaris: Version 11.2.0.2.0 - Production on 26-MAY-2011 14:13:42

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:

/oracle/X37/112_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = sapx37p)(PORT = 1562)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = X37)))

OK (50 msec)

w003060:x37adm> tnsping X37

TNS Ping Utility for Solaris: Version 11.2.0.2.0 - Production on 26-MAY-2011 14:14:15

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:

/oracle/X37/112_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = sapx37p)(PORT = 1562)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = X37)))

OK (20 msec)

regards,

Polina

[Former Member]

Thanks, nothing suspicious in the output.

Yet another try, as user x37adm:

ls -l $ORACLE_HOME/bin/oracle

There should be a "-rwsr-s--x" or similar.

regards

[Former Member]

Hi Joe,

it seems to be ok:

w003060:x37adm> ls -l $ORACLE_HOME/bin/oracle

-rwsr-s--x 1 orax37 dba 231564584 May 4 11:41 /oracle/X37/112_64/bin/oracle

regards,

Polina

[Former Member]

What is your version of R3trans?

Try a newer one perhaps?

[Former Member]

Polina,

I had the same issue some weeks ago with one of our systems.

I took a look in the startsap script and found that it gets the location of the database server from the default and start profile.

And the name of the db host was there and looked fine in the extended view, the list of the parameters. However the hostname was full qualified and long with the domain name, and in the other view in rz10 it was cut of. So I cut off the domain name and used the normal short hostname and after that the startsap script worked fine.

Kind regards,

Gerd