on 04-17-2013 3:15 AM
Hi All,
My OS is Solaris 10, I have upgrade the database 10.2 to 11.2 and the upgrade completed successfully. Then installed the oracle client 11.2 as per note 819829 and updated the new kernel 7.20 and changed the DB parameter and client parameters. these are the kernel files i updated in the following order
SAPEXE_300-20006802.SAR; SAPEXE_402-20006802.SAR; DBATL720O10_31-20005217.SAR; lib_dbsl_421-20005217.sar; tp_420-20005216.sar; dw_423-20005216.sar and run the script saproot.sh also. When check the R3trans -x it got failed and giving the error
R3trans -d
This is R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/FQC/SYS/exe/run') or dbms_type ('ORA')"
R3trans finished (0012).
Then i checked the BRconnect that is also failed.
brconnect: fatal: relocation error: file /oracle/client/10x_64/instantclient/libnnz10.so: symbol nzdacvalue: referenced symbol not found.
Dew_w0 log below
root@filqua # more dev_w0
---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "700"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
M sysno 00
M sid FQC
M systemid 370 (Solaris on SPARCV9 CPU)
M relno 7000
M patchlevel 0
M patchno 278
M intno 20050900
M make: single threaded, ASCII, 64 bit, optimized
M pid 3401
M
M
M Tue Apr 16 10:18:45 2013
M kernel runs with dp version 245(ext=110) (@(#) DPLIB-INT-VERSION-245)
M length of sys_adm_ext is 364 bytes
M ThInit: rdisp/cleanup_after_crash = 1
M ***LOG Q01=> ThInit, WPStart (Workproc 0 1 3401) [thxxhead.c 1344]
M ThInit: running on host filqua
M calling db_connect ...
B Loading DB library '/usr/sap/FQC/SYS/exe/run/dboraslib.so' ...
B
B Tue Apr 16 10:18:46 2013
B Library '/usr/sap/FQC/SYS/exe/run/dboraslib.so' loaded
B Version of '/usr/sap/FQC/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.290)
C Oracle Client Version: '10.2.0.2.0', (dbsl 700 150211, non-unicode)
C Application info callback registered.
C Client NLS setting (OCINlsGetInfo): con=0, 'AMERICAN_AMERICA.WE8DEC'
C Logon as OPS$-user to get SAPR3's password
C Connecting as /@FQC on connection 0 (nls 0) ... (dbsl 700 150211, non-unicode)
C Attaching to DB Server FQC (con_hdl=0,svchp=105de2068,srvhp=105de47b8)
C Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=105de2068, srvhp=105de47b8, usrhp=105ddefa8)
C CbApplInfoGet() failed (ignored 1).
C Connected to session 72.
C Now '/@FQC' is connected: con_hdl=0, nls_hdl=0, session_id=72.
C Got SAPR3's password from OPS$-user
C Disconnecting from connection 0 ...
C Closing user session (con_hdl=0,svchp=105de2068,usrhp=105ddefa8)
C Now I'm disconnected from ORACLE
C Connecting as SAPR3/<pwd>@FQC on connection 0 (nls 0) ... (dbsl 700 150211, non-unicode)
C Starting user session: OCISessionBegin(con_hdl=0, usr=SAPR3/<pwd>, svchp=105de2068, srvhp=105de47b8, usrhp=105ddefa8)
C Connected to session 72.
C Now 'SAPR3/<pwd>@FQC' is connected: con_hdl=0, nls_hdl=0, session_id=72.
C con=0, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.WE8DEC, NLS_NCHAR_CHARACTERSET=AL16UTF16, UNI_NON=FALSE
C Nls CharacterSet (Env./V$NLS) NatioCharSet (Env./V$NLS) EnvHp ErrHp ErrBt
C 0 (WE8DEC) WE8DEC (AL16UTF16) AL16UTF16 105dd6cf0 105dde790 105de2138
C DB instance FQC is running on filqua with ORACLE version 10.2.0.2.0 since APR 16, 2013, 10:18:13
B Connection 0 opened (DBSL handle 0)
Can anyone help me to solve this issue.
Regards
Jose H.
Hi Jose,
I have recently faced this issue. Please don't rename or delete 10X_64 dir . Keep both dir just make delte old soft like & create in new client i.e 11X_64. Please change env for new cliet. I am sure this will resolve your issue.
Regards
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Jose,
Check below.
1) Check if /oracle/client" is available and you are using correct client version.
2) Give full permission to profile directory.
3) For your case keep both 10x_64 & 11x_64 Clients and retry .
This worked for me.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
bad news, obviously you did not update anything at all according to you trace file:
B Version of '/usr/sap/FQC/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.290)
C Oracle Client Version: '10.2.0.2.0', (dbsl 700 150211, non-unicode)
C DB instance FQC is running on filqua with ORACLE version 10.2.0.2.0 since APR 16, 2013, 10:18:13
So your kernel is on Version 7.0
You client is on 10.2.0.2
Your DB is on 10.2.0.2
Volker
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jose,
There is nothing to do with DIR_LIBRARY environment variable.
This is because of your client version compatibility with current OS patch set. Just compare the oslevel and it's ML/TL level with the system where it is working fine.
It looks like, pre-requsites related to OS patch set were ignored while perorming oracle upgrade.
solution is to change the path of oracle client and point it to earlier oracle client version till you get your OS patch upgraded to the recommended patch level.This is tested workaround.
Do let me know if you still face same problem after changing client path ..
Cheers !!!
Ashish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jose,
Refer SAP
Create the missing soft link manually using the user ora<sid>:
> cd $ORACLE_HOME/lib
> ln -s libnnz11.so libnnz10.so
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi jose,
can you please post the trans.log
and also double check the env
DIR_LIBRARY=/usr/sap/SID/SYS/exe/run
LD_LIBRARY_PATH=/usr/sap/SID/SYS/exe/run:/oracle/client/11x_64/instantclient
dbms_type=ORA
dbs_ora_tnsname=SID
dbs_ora_schema=SAPSR3
ORACLE_SID=SID
DB_SID=SID
ORACLE_BASE=/oracle
TNS_ADMIN=/usr/sap/SID/SYS/profile/oracle
ORACLE_HOME=/oracle/SID/112_64
best regards
marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.