Question:
I have patched SAP kernel...SAPEXEDB AND SAPEXE...
SAPCAR -xvf saved off old kernel moved the uncar files into
sapmnt/SID/exe.....
and now oracle start but SAP will not and I get
saposcol already running
Running /usr/sap/DR1/SYS/exe/run/startdb
Trying to start DR1 database ...
Log file: /home/dr1adm/startdb.log
/usr/sap/DR1/SYS/exe/run/startdb: Terminating with error code 12
DB startup failed
The logs tell me nothing zero and all I did was upgrae to patch 71 on WAS 620....can anyone help..? any clues to look at?
Thanks
Mike
Answer:
oracle client version?
old kernel version?
new kernel version?
oracle version?
os and its version?
_________________
NOT certified but stayed at holiday inn.
Answer:
I did a R3trans X and got this:
oracle 92. 9205 client
kernel 44 neww kernel 71
ETW000 [dev trc ,00000] Assigning password to user session 100f13478
108 0.239051
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=100f08d88
,srvhp=100f09a98,usrhp=100f13478)
4 ETW000
55 0.239106
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed:
rc = 12705
4 ETW000
15051 0.254157
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=100f09a98)
4 ETW000
47 0.254204
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=100f08
d88,srvhp=100f09a98)
4 ETW000
44 0.254248
4 ETW000 [dev trc ,00000] Deallocating server context handle 100f09a98
649 0.254897
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1270
5'
4 ETW000
77 0.254974
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 12705 performing CON [dbl
ink#2 @ 419]
4 ETW000
345 0.255319
4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12705: invalid or unknown NLS pa
rameter value specified [dblink#2 @ 419]
4 ETW000
48 0.255367
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o
ra_tnsname = 'DR1'"
Answer:
Post the contents of startdb.log
Prime
Answer:
Hi Mike,
Look carefully at the logs:
usr/sap/DR1/SYS/exe/run/startdb: Terminating with error code 12
DB startup failed
Oracle did not start. Try to start is manually...
su - orasid
sqlplus /nolog
connect / as sysdba
startup
if you get an error when you su as orasid (you might get the ora_nls error)....set the parameter correcty.
To ensure oracle is started, check : ps -ef | grep ora.
Once oracle is started start listener....as orasid user....
then login as sidadm and execute R3trans -d.....if return code is zero start sap.
If you have any further problems...post message here. Good luck
Answer:
use oracle client 817.
Answer:
here is where I am at:
upgraded kernel to 71 running SM3.2 on UNIX and now SAP will not start and downgraded and SAP will come up but will not stay up...so I am trying to get it up with patch 71....it should be a no brainer....
Ok Oracle is up and running when I startsap...I can sqlplus and start and shutdown natively no issue, oracle is clean...
but via SAP when I start sap I get the rc 12....so I do a ps -ef grep ora and ora processes are running but no sap....
So I do an R3trans -X and here is the results of the trans.log:
Any other logs you folks need?
4 ETW000 R3trans version 6.13 (release 640 - 20.04.05 - 14:00:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 27.08.2005 - 10:18:14
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] Sat Aug 27 10:18:14 2005
424 0.000424
4 ETW000 [dev trc ,00000] db_con_init called
39 0.000463
4 ETW000 [dev trc ,00000] create_con (con_name=R/3)
269 0.000732
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/DR1/SYS/exe/run/dbo
raslib.so' ...
4 ETW000
108 0.000840
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/DR1/SYS/exe/run/db
oraslib.so), hdl 0
4 ETW000
70964 0.071804
4 ETW000 [dev trc ,00000] Library '/usr/sap/DR1/SYS/exe/run/dboraslib.so'
loaded
4 ETW000
135 0.071939
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sa
p/DR1/SYS/exe/run/dboraslib.so
4 ETW000
80 0.072019
4 ETW000 [dev trc ,00000] Version of '/usr/sap/DR1/SYS/exe/run/dboraslib.s
o' is "640.00", patchlevel (0.55)
4 ETW000
453 0.072472
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/s
ap/DR1/SYS/exe/run/dboraslib.so
4 ETW000
55 0.072527
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/
sap/DR1/SYS/exe/run/dboraslib.so
4 ETW000
129 0.072656
4 ETW000 [dev trc ,00000] New connection 0 created
72 0.072728
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCO
NNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, oc
c = NO
4 ETW000
86 0.072814
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3)
87 0.072901
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection
for reuse:
4 ETW000
47 0.072948
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCON
NECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ
= NO
4 ETW000
47 0.072995
4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/DR1/920_64 from environm
ent
4 ETW000
1227 0.074222
4 ETW000 [dev trc ,00000] -->oci_init1
89 0.074311
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0)
47 0.074358
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII
6832 0.081190
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPDR1's password
54 0.081244
4 ETW000 [dev trc ,00000] Connecting as /@DR1 on connection 0 (nls_hdl 0)
...
4 ETW000
48 0.081292
4 ETW000 [dev trc ,00000] Nls Characterset Natcharacterset
C EnvHp ErrHp ErrHpBatch
4 ETW000
47 0.081339
4 ETW000 [dev trc ,00000] 0
1 100f01c40 100f09448 100f08e58
4 ETW000
46 0.081385
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0
161 0.081546
4 ETW000 [dev trc ,00000] Allocating server context handle
43 0.081589
4 ETW000 [dev trc ,00000] Attaching to DB Server DR1 (con_hdl=0,svchp=100f
08d88,svrhp=100f09a98)
4 ETW000
222 0.081811
4 ETW000 [dev trc ,00000] Assigning server context 100f09a98 to service co
ntext 100f08d88
4 ETW000
67879 0.149690
4 ETW000 [dev trc ,00000] Allocating user session handle
149 0.149839
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=100f08d88
,srvhp=100f09a98,usrhp=100f13478)
4 ETW000
66 0.149905
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed:
rc = 12705
4 ETW000
6358 0.156263
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=100f09a98)
4 ETW000
52 0.156315
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=100f08
d88,srvhp=100f09a98)
4 ETW000
43 0.156358
4 ETW000 [dev trc ,00000] Deallocating server context handle 100f09a98
931 0.157289
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1270
5'
4 ETW000
147 0.157436
4 ETW000 [dev trc ,00000] Try to connect with default password
78 0.157514
4 ETW000 [dev trc ,00000] Connecting as SAPDR1/<pwd>@DR1 on connection 0 (
nls_hdl 0) ...
4 ETW000
49 0.157563
4 ETW000 [dev trc ,00000] Nls Characterset Natcharacterset
C EnvHp ErrHp ErrHpBatch
4 ETW000
76 0.157639
4 ETW000 [dev trc ,00000] 0
1 100f01c40 100f09448 100f08e58
4 ETW000
46 0.157685
4 ETW000 [dev trc ,00000] Allocating server context handle
27 0.157712
4 ETW000 [dev trc ,00000] Attaching to DB Server DR1 (con_hdl=0,svchp=100f
08d88,svrhp=100f09a98)
4 ETW000
64 0.157776
4 ETW000 [dev trc ,00000] Assigning server context 100f09a98 to service co
ntext 100f08d88
4 ETW000
54656 0.212432
4 ETW000 [dev trc ,00000] Assigning username to user session 100f13478
116 0.212548
4 ETW000 [dev trc ,00000] Assigning password to user session 100f13478
106 0.212654
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=100f08d88
,srvhp=100f09a98,usrhp=100f13478)
4 ETW000
56 0.212710
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed:
rc = 12705
4 ETW000
15058 0.227768
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=100f09a98)
4 ETW000
46 0.227814
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=100f08
d88,srvhp=100f09a98)
4 ETW000
45 0.227859
4 ETW000 [dev trc ,00000] Deallocating server context handle 100f09a98
476 0.228335
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1270
5'
4 ETW000
209 0.228544
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 12705 performing CON [dbl
ink#2 @ 419]
4 ETW000
342 0.228886
4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12705: invalid or unknown NLS pa
rameter value specified [dblink#2 @ 419]
4 ETW000
49 0.228935
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o
ra_tnsname = 'DR1'"
Answer:
Here is another clue: from dpmon:
Thu Apr 15 15:23:41 2004
systemid 370 (relno 6200
patchlevel 0
patchno 1422
intno 20020600
make: single threaded, ASCII, 64 bit
pid 15114
*** ERROR => DpSysAdmExtCreate: ShmCreate (ATTACH) failed (3) [dpxxtool2.c 555]
*** ERROR => DpIPCInit: DpSysAdmExtCreate [dpxxtool2.c 332]
*** ERROR => DpMonInit: DpIPCInit [dpxxmon.c 794]
*** ERROR => main: DpMonInit [dpxxmon.c 417]
Thanks
Mike
Answer:
>>>4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12705: invalid or unknown NLS pa
rameter value specified [dblink#2 @ 419]
Check NLS_LANG environment variable. Also, I still would like to see what startdb.log says.
Prime