STARTSAP Fails after Upgrade from 4.7 to ECC 6.0
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