STARTSAP Fails after Upgrade from 4.7 to ECC 6.0

[Former Member]

Hello,

I am Upgrading from SAP 4.7 to ECC 6.0. Oracle is upgraded from 9i to 10g & solaris is upgraded from 9 to 10 sparc.

SAPup tool is Sucessfully completed(in SCROLL mode) but now SAP startup is failing. The error details are as below.

Pls see below details and guide me:

Oracle and Listener are properly started too.

su - prdadm

bash-3.00$ export PATH=/oracle/PRD/102_64/bin:/oracle/PRD:/usr/sap/PRD/SYS/exe/runU:/usr/sap/PRD/SYS/exe/run:/usr/bin:.:/usr/ccs/bin:/usr/ucb

bash-3.00$ export dbms_type=ORA

bash-3.00$ export dbs_ora_tnsname=PRD

bash-3.00$ startsap

Starting SAP-Collector Daemon

-

---

open logfile '/usr/sap/tmp/dev_coll.tmp' failed... use stderri

11:16:31 11.06.2007 ERROR: cannot open log file /usr/sap/tmp/dev_coll.tmp

11:16:31 11.06.2007 ERROR: Make sure directory /usr/sap/tmp exists or specify DIR_PERF

11:16:31 11.06.2007 ERROR: in profile and run saposcol pf=<profile>

saposcol already running

Running /usr/sap/PRD/SYS/exe/run/startdb

Trying to start database ...

Log file: /home/prdadm/startdb.log

Can not find executable sqlplus

DB startup failed

bash-3.00$ R3trans -x

This is R3trans version 6.14 (release 700 - 20.07.06 - 17:34:00).

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

R3trans finished (0012).

bash-3.00$ more trans.log

4 ETW000 R3trans version 6.14 (release 700 - 20.07.06 - 17:34:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 11.06.2007 - 11:16:38

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Mon Jun 11 11:16:38 2007 143 0.000143

4 ETW000 [dev trc ,00000] db_con_init called 31 0.000174

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 75 0.000249

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' ...

4 ETW000 76 0.000325

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/PRD/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 151353 0.151678

4 ETW000 [dev trc ,00000] Library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' loaded

4 ETW000 157 0.151835

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so

4 ETW000 55 0.151890

4 ETW000 [dev trc ,00000] Version of '/usr/sap/PRD/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.73)

4 ETW000 12574 0.164464

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so

4 ETW000 47 0.164511

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so

4 ETW000 185 0.164696

4 ETW000 [dev trc ,00000] New connection 0 created 95 0.164791

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 25

5, con_opt = 255, occ = NO

4 ETW000 65 0.164856

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 31 0.164887

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 34 0.164921

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255

, con_opt = 255, occ = NO

4 ETW000 35 0.164956

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 8576 0.173532

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 60 0.173592

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 23733 0.197325

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 141 0.197466

4 ETW000 [dev trc ,00000] Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

4 ETW000 101 0.197567

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 54 0.197621

4 ETW000 [dev trc ,00000] 0 US7ASCII 1 1011bf230 1011c6c80 1011ca7f8

4 ETW000 36 0.197657

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

4 ETW000 [dev trc ,00000] Allocating server context handle 65 0.197759

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=1011ca728,svrhp=1011caec8)

4 ETW000 93 0.197852

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

4 ETW000 18826 0.216678

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

4 ETW000 44 0.216722

4 ETW000 [dev trc ,00000] Try to connect with default password 819 0.217541

4 ETW000 [dev trc ,00000] Connecting as SAPR3/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

4 ETW000 67 0.217608

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 62 0.217670

4 ETW000 [dev trc ,00000] 0 US7ASCII 1 1011bf230 1011c6c80 1011ca7f8

4 ETW000 38 0.217708

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=1011caec8)

4 ETW000 33 0.217741

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=1011ca728,srvhp=1011caec8)

4 ETW000 33 0.217774

4 ETW000 [dev trc ,00000] Deallocating server context handle 1011caec8 92 0.217866

4 ETW000 [dev trc ,00000] Allocating server context handle 134 0.218000

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=1011ca728,svrhp=1011caec8)

4 ETW000 74 0.218074

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

4 ETW000 595 0.218669

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

4 ETW000 40 0.218709

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12154 performing CON [dblink#3 @ 431]

4 ETW000 4954 0.223663

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12154: TNS:could not resolve the connect identifier specified [dblink#3 @ 431]

4 ETW000 36 0.223699

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

Regards & Thanks,

Ankita

[markus_doehr2 · Accepted solution]

You seem to have a problem with your environment. Usually it´s not necessary to set environment variables manually.

Did you change your shell?

--

Markus

[Former Member · Accepted solution]

Dear Markus,

I did changes to envt variable to resolve this error but still stuck up. And i had installed Oracle client 10 too so it needed envt changes for LD_LIBRARY_PATH etc.

Can u tell me one thing why is shoeing below error in trans.log:

********

• ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154

4 ETW000 18826 0.216678

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

*******

Regards,

Ankita.

[markus_doehr2 · Accepted solution]

You seem to have more severe problems than this one, you whole environment does not fit. It´s not enough to have just ORACLE_HOME and ORACLE_SID.

Login as adm and execute

ls -lisa

do yo usee any .db_env* and .sapen_* files there?

--

Markus

[Former Member · Accepted solution]

Dear Markus,

After logging as user "prdadm"

su - prdadm

bssltests% bash-3.00$ ls -a

. .dbenv_bssltests.sh-old .sapenv_bssltests.sh startdb.log

.. .dbenv_bssltests.sh-old10 .sapenv_bssltests.sh-new startsap_.log

.bash_history .dbsrc_bssltests.csh .sapenv_bssltests.sh-old10 startsap_DVEBMGS00.log

.cshrc .dbsrc_bssltests.sh .sapsrc_bssltests.csh startsap_DVEBMGS01.log

.dbenv_bssltests.csh .login .sapsrc_bssltests.sh stopdb.log

.dbenv_bssltests.csh-new .profile dev_sapstart stopsap_.log

.dbenv_bssltests.csh-old .sapenv_bssltests.csh local.cshrc stopsap_DVEBMGS00.log

.dbenv_bssltests.csh-old10 .sapenv_bssltests.csh-new local.login stopsap_DVEBMGS01.log

.dbenv_bssltests.sh .sapenv_bssltests.csh-old local.profile trans.log

.dbenv_bssltests.sh-new .sapenv_bssltests.csh-old10 sqlnet.log

bash-3.00$

bash-3.00$

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

I have changed envt settings in .dbenv_bssltests.csh & .dbenv_bssltests.sh

.sapenv_bssltests.sh & .sapenv_bssltests.csh [4 files]

Regards,

Ankita

[markus_doehr2 · Accepted solution]

Don´t execute "bash", your environment will become overwritten.

su - prdadm

then give a "startsap"

--

Markus

[Former Member · Accepted solution]

Hello,

root@bssltests # su - prdadm

bssltests% startsap

Starting SAP-Collector Daemon

-

---

open logfile '/usr/sap/tmp/dev_coll.tmp' failed... use stderri

12:21:25 11.06.2007 ERROR: cannot open log file /usr/sap/tmp/dev_coll.tmp

12:21:25 11.06.2007 ERROR: Make sure directory /usr/sap/tmp exists or specify DIR_PERF

12:21:25 11.06.2007 ERROR: in profile and run saposcol pf=<profile>

saposcol already running

Running /usr/sap/PRD/SYS/exe/run/startdb

Trying to start database ...

Log file: /home/prdadm/startdb.log

Can not find executable sqlplus

DB startup failed

bssltests% more startdb.log

-

---

Mon Jun 11 12:21:25 IST 2007

LOGFILE FOR STARTING ORACLE

Trying to start database ...

Can not find executable sqlplus

Regards,

Ankita

[markus_doehr2 · Accepted solution]

All your paths and your environment are not set correctly

did you change your shell during the upgrade? Usually the R3up/SAPup deals with those changes, something did go wrong.

What do the following commands put out:

echo $ORACLE_HOME

echo $PATH

--

Markus

[Former Member · Accepted solution]

Hey Markus,

No i did not change the shell during upgrade. Its only after "startsap" failed after upgrade that i tried to modify it manually.

bssltests% echo $PATH

/home/prdadm:/usr/sap/PRD/SYS/exe/run:/usr/bin:.:/usr/ccs/bin:/usr/ucb

bssltests% echo $ORACLE_HOME

ORACLE_HOME: Undefined variable

bssltests% env

HOME=/home/prdadm

PATH=/home/prdadm:/usr/sap/PRD/SYS/exe/run:/usr/bin:.:/usr/ccs/bin:/usr/ucb

LOGNAME=prdadm

HZ=

TERM=dtterm

SHELL=/bin/csh

MAIL=/var/mail/prdadm

LANG=C

TZ=Asia/Calcutta

PWD=/home/prdadm

USER=prdadm

SAPSYSTEMNAME=PRD

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

LD_LIBRARY_PATH=/usr/sap/PRD/SYS/exe/run:/oracle/client/10x_64/instantclient

bssltests%

**********

Now wat to do??

Regards,

Ankita

[markus_doehr2 · Accepted solution]

Your main problem seems to me, that your ORACLE_HOME is not set - and all subsequent variables set using $ORACLE_HOME are not set also.

try the following

su - prdadm

%> source .dbsrc_<hostname>.csh

%> source .sapsrc_<hostname>.csh

echo $PATH

--

Markus

[Former Member · Accepted solution]

THANKS Marqus!!

My problem got resolved and now SAP is also starting.

Actually there are 4 files .dbenv_bssltests.csh & .dbenv_bssltests.sh

.sapenv_bssltests.sh & sapenv_bssltests.csh SAP was not reading the contents hence not displaying it in ENV of PRDADM so i have now copied .sapenv_bssltests.sh & sapenv_bssltests.csh from ORAPRD and now its OK.

Don't know why it was nota ble to read all Oracle related Parameters from the original files but now its working fine......Thanks for ur suggestions.

Regards,

Ankita.

[markus_doehr2 · Accepted solution]

I'd also suggest executing

saproot.sh <SID>

in /usr/sap/<SID>/exe

because saposcol and icmbnd has the's'-bit not set and thus will not start correctly.

--

Markus