on 04-04-2013 9:10 AM
Hello All,
We have ECC 6.0 IDES System in Oracle 11g as Database we have unix as Operating System.
We can not start SAP after restart DB.
sapux24:risadm 35> R3trans -d
This is R3trans version 6.14 (release 700 - 24.07.12 - 20:12:04 ).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'RIS'"
R3trans finished (0012).
Oracle database is Up, Listener is Up , SAPOSCOL is running
We have change SAPR3 user password with BRTOOLS,
but still the same problem
I think there is problem with Authentication as it is seen in the log file.
Her is trans.log file
4 ETW000 R3trans version 6.14 (release 700 - 24.07.12 - 20:12:04 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 04.04.2013 - 09:01:44
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [ dev trc,00000] Thu Apr 4 09:01:44 2013 427 0.000427
4 ETW000 [ dev trc,00000] db_con_init called 16 0.000443
4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 75 0.000518
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/RIS/SYS/exe/run/dboraslib.so' ... 29 0.000547
4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/RIS/SYS/exe/run/dboraslib.so"), hdl 0
4 ETW000 34053 0.034600
4 ETW000 [ dev trc,00000] Library '/usr/sap/RIS/SYS/exe/run/dboraslib.so' loaded 29 0.034629
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/RIS/SYS/exe/run/dboraslib.so
4 ETW000 40 0.034669
4 ETW000 [ dev trc,00000] Version of '/usr/sap/RIS/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.342)
4 ETW000 345 0.035014
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/RIS/SYS/exe/run/dboraslib.so
4 ETW000 30 0.035044
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/RIS/SYS/exe/run/dboraslib.so
4 ETW000 76 0.035120
4 ETW000 [ dev trc,00000] New connection 0 created 58 0.035178
4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 182 0.035360
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 39 0.035399
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection for reuse: 14 0.035413
4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 37 0.035450
4 ETW000 [ dev trc,00000] -->oci_init1 322 0.035772
4 ETW000 [ dev trc,00000] Oracle Client Version: '11.2.0.3.0', (dbsl 700 110412, UNICODE[2]) 163 0.035935
4 ETW000 [ dev trc,00000] Default connection: tnsname ='RIS' 17 0.035952
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', uc_ln=2) 30 0.035982
4 ETW000 [ dev trc,00000] Application info callback registered. 16 0.035998
4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)
4 ETW000 13699 0.049697
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=0x6000000001139588) 109 0.049806
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=0x600000000113a628) 41 0.049847
4 ETW000 [ dev trc,00000] NLS env.: lang=0041004D00450052004900430041004E 337 0.050184
4 ETW000 [ dev trc,00000] terr=0041004D00450052004900430041 22 0.050206
4 ETW000 [ dev trc,00000] char=00550054004600310036 18 0.050224
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo): con=0, 'AMERICAN_AMERICA.UTF16'
4 ETW000 23 0.050247
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 15 0.050262
4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPR3's password 45 0.050307
4 ETW000 [ dev trc,00000] Connecting as /@RIS on connection 0 (nls 0) ... (dbsl 700 110412, UNICODE[2])
4 ETW000 26 0.050333
4 ETW000 [ dev trc,00000] Allocating service context handle for con=0 48 0.050381
4 ETW000 [ dev trc,00000] Allocating server context handle 19 0.050400
4 ETW000 [ dev trc,00000] Attaching to DB Server RIS (con=0,svchp=0x600000000113a548,srvhp=0x600000000113d6b0)
4 ETW000 167 0.050567
4 ETW000 [ dev trc,00000] Assigning server context 0x600000000113d6b0 to service context 0x600000000113a548
4 ETW000 94781 0.145348
4 ETW000 [ dev trc,00000] Allocating user session handle 120 0.145468
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='/',svchp=0x600000000113a548, srvhp=0x600000000113d6b0, usrhp=0x60000000011c1be0)
4 ETW000 56 0.145524
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 8781 0.154305
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 446 0.154751
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 36 0.154787
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017' 60 0.154847
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017 16 0.154863
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 16 0.154879
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017 87 0.154966
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 27 0.154993
4 ETW000 [ dev trc,00000] Info: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password.
4 ETW000 49 0.155042
4 ETW000 [ dev trc,00000] Connecting as SAPR3/<pwd>@RIS on connection 0 (nls 0) ... (dbsl 700 110412, UNICODE[2])
4 ETW000 28 0.155070
4 ETW000 [ dev trc,00000] Assigning username to user session: con=0, usrhp=0x60000000011c1be0 18 0.155088
4 ETW000 [ dev trc,00000] Assigning password to user session: con=0, usrhp=0x60000000011c1be0 143 0.155231
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr=SAPR3/<pwd>, svchp=0x600000000113a548, srvhp=0x600000000113d6b0, usrhp=0x60000000011c1be0)
4 ETW000 641 0.155872
4 ETW000 [ dev trc,00000] Thu Apr 4 09:01:50 2013 6011089 6.166961
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 37 6.166998
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 131 6.167129
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 31 6.167160
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017' 24 6.167184
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017 16 6.167200
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 16 6.167216
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017 86 6.167302
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 27 6.167329
4 ETW000 [ dblink ,00433] ***LOG BY2=>sql error 1017 performing CON [dblink#8 @ 433] 237 6.167566
4 ETW000 [ dblink ,00433] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#8 @ 433]
4 ETW000 28 6.167594
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'RIS'"
Thanks for any help.
R3trans -d giving error:2EETW169 no connect possible: "DBMS = ORACLE--- dbs_ora_tnsname = 'DEV'"
Hello Ejersbo,
on Apr 5, 2013 4:16 PM you wrote:
However, because of the high risks, and possibilities for an inexperienced DBA
to inadvertently expose their database, the
remote_os_authent parameter has been deprecated in Oracle 11g, and a
safer method is used.
My crystal ball is showing me that you quoted Don Burleson here, and you tried to follow his suggestions:
http://www.dba-oracle.com/t_remote_os_authent.htm
What did you do before you restarted your database?
Did you try to implement this new safer method, right?
Did you also read the SAP note regarding this new safer method?
Did you check the prerequisites needed for SAP systems?
For example SAP kernel 7.20 or above?
My crystal ball seems to indicate that you didn't...
https://service.sap.com/~form/handler?_APP=01100107900000000342_EVENT=REDIR&_NNUM=1622837&_NLANG=E
regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Joe,
Thanks for reply,
We are planning to upgrade this installation to EHP6 By SUM.
During upgrde we had some problem with DB server, after rester DB server we could not start this installation.
Oracle is runing and we have Kernel Patch number : 351 install.
Any idea what is the problem, Every thing was working befor restart.
Thanks
Reza
hi
please make sure the parameter is set,
remote_os_authent TRUE
please make sure the OS user is part of the correct groups
sapsys oper dba sdba sapinst
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.
Her is log file after run R3trans -d
Thanks for help.
sapux24:risadm 80> R3trans -d
This is R3trans version 6.14 (release 700 - 24.07.12 - 20:12:04 ).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'RIS'"
R3trans finished (0012).
sapux24:risadm 81>ll
-rw-r--r-- 1 risadm sapsys 10743 Apr 8 11:23 trans.log
sapux24:risadm 82> more
sapux24:risadm 82>
sapux24:risadm 82> trans.log
/home/risadm/trans.log: Syntax error at line 1 : `(' is not expected.
sapux24:risadm 83> more trans.log
4 ETW000 R3trans version 6.14 (release 700 - 24.07.12 - 20:12:04 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 08.04.2013 - 11:22:52
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [ dev trc,00000] Mon Apr 8 11:22:52 2013
13175 0.013175
4 ETW000 [ dev trc,00000] db_con_init called
18 0.013193
4 ETW000 [ dev trc,00000] create_con (con_name=R/3)
91 0.013284
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/RIS/SYS/exe/run/dboraslib.so' ...
31 0.013315
4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/RIS/SYS/exe/run/dboraslib.so"), h
dl 0
4 ETW000 5
41000 0.554315
4 ETW000 [ dev trc,00000] Library '/usr/sap/RIS/SYS/exe/run/dboraslib.so' loaded
29 0.554344
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/RIS/SYS/exe/run/dbora
slib.so
4 ETW000
40 0.554384
4 ETW000 [ dev trc,00000] Version of '/usr/sap/RIS/SYS/exe/run/dboraslib.so' is "700.08", patchle
vel (0.342)
4 ETW000
1321 0.555705
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/RIS/SYS/exe/run/dbor
aslib.so
4 ETW000
31 0.555736
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/RIS/SYS/exe/run/dbo
raslib.so
4 ETW000
14819 0.570555
4 ETW000 [ dev trc,00000] New connection 0 created
794 0.571349
4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , h
c = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 25
5, occ = NO
4 ETW000
183 0.571532
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3)
34 0.571566
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection for reuse:
14 0.571580
4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc
= NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 25
5, occ = NO
4 ETW000
37 0.571617
4 ETW000 [ dev trc,00000] -->oci_init1
3107 0.574724
4 ETW000 [ dev trc,00000] Oracle Client Version: '11.2.0.3.0', (dbsl 700 110412, UNICODE[2])
3830 0.578554
4 ETW000 [ dev trc,00000] Default connection: tnsname ='RIS'
17 0.578571
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', uc_ln=2)
29 0.578600
4 ETW000 [ dev trc,00000] Application info callback registered.
16 0.578616
4 ETW000 [ dev trc,00000] Mon Apr 8 11:22:54 2013 12
47030 1.825646
4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS hand
le)
4 ETW000
48 1.825694
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=0x6000000001139588)
6074 1.831768
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=0x600000000113a628)
21 1.831789
4 ETW000 [ dev trc,00000] NLS env.: lang=0041004D00450052004900430041004E
26355 1.858144
4 ETW000 [ dev trc,00000] terr=0041004D00450052004900430041
22 1.858166
4 ETW000 [ dev trc,00000] char=00550054004600310036
18 1.858184
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo): con=0, 'AMERICAN_AMERICA.UTF16'
4 ETW000
24 1.858208
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE
15 1.858223
4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPR3's password
1492 1.859715
4 ETW000 [ dev trc,00000] Connecting as /@RIS on connection 0 (nls 0) ... (dbsl 700 110412, UNICO
DE[2])
4 ETW000
28 1.859743
4 ETW000 [ dev trc,00000] Allocating service context handle for con=0
55 1.859798
4 ETW000 [ dev trc,00000] Allocating server context handle
20 1.859818
4 ETW000 [ dev trc,00000] Attaching to DB Server RIS (con=0,svchp=0x600000000113a548,srvhp=0x6000
00000113d6b0)
4 ETW000
173 1.859991
4 ETW000 [ dev trc,00000] Mon Apr 8 11:23:01 2013 69
56305 8.816296
4 ETW000 [ dev trc,00000] Assigning server context 0x600000000113d6b0 to service context 0x600000
000113a548
4 ETW000
50 8.816346
4 ETW000 [ dev trc,00000] Allocating user session handle
2203 8.818549
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='/',svchp=0x600000000
113a548, srvhp=0x600000000113d6b0, usrhp=0x60000000011c1be0)
4 ETW000
55 8.818604
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 1
63453 8.982057
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:
3415 8.985472
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000
34 8.985506
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017'
65 8.985571
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017
16 8.985587
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017)
16 8.985603
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017
87 8.985690
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000
25 8.985715
4 ETW000 [ dev trc,00000] Info: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password.
4 ETW000
457 8.986172
4 ETW000 [ dev trc,00000] Connecting as SAPR3/<pwd>@RIS on connection 0 (nls 0) ... (dbsl 700 110
412, UNICODE[2])
4 ETW000
118 8.986290
4 ETW000 [ dev trc,00000] Assigning username to user session: con=0, usrhp=0x60000000011c1be0
20 8.986310
4 ETW000 [ dev trc,00000] Assigning password to user session: con=0, usrhp=0x60000000011c1be0
1659 8.987969
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr=SAPR3/<pwd>, svchp=0x
600000000113a548, srvhp=0x600000000113d6b0, usrhp=0x60000000011c1be0)
4 ETW000
75131 9.063100
4 ETW000 [ dev trc,00000] Mon Apr 8 11:23:11 2013 10
047853 19.110953
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR
66 19.111019
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:
140 19.111159
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000
32 19.111191
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017'
24 19.111215
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017
17 19.111232
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017)
16 19.111248
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017
87 19.111335
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000
26 19.111361
4 ETW000 [ dblink ,00433] ***LOG BY2=>sql error 1017 performing CON [dblink#8 @ 433]
25720 19.137081
4 ETW000 [ dblink ,00433] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#
8 @ 433]
4 ETW000
29 19.137110
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'RIS'"
sapux24:risadm 84>
sapux24:risadm 84>
Hi,
please follow the belos steps and hopefully it should fix your issue. Login in as orasid and execute the below command
brconnect -u system/<password> -f chpass -o <sapowner> -p <password>
Example
brconnect -u system/<system user password> -f chpass -o SAPSR3 -P <SAPSR3 Password>
It will synchorize all the password accordingly.
As well as please make sure that you have implemented the following note
Note 1519872 - SAP Database User Profile SAPUPROF
Thanks and Regards,
Vimal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please go to /oracle/client/11x_64 and check whether you have maintained the symbolic link correctly.
Please see the attached screenshot for your reference.
If yes, please share your environmental variables as well as please share your contents of your oracle client.
This should fix your issue.
Thanks and Regards,
Vimal
Hello again,
Thanks for help,
Here is ENV:
sapux24:oraris 10> env
HOME=/oracle/RIS
PATH=/oracle/RIS/112_64/bin:.:/oracle/RIS:/usr/sap/RIS/SYS/exe/run:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/gvsd/bin:/opt/ipf/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/sas/bin:/opt/graphics/common/bin:/opt/atok/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/sec_mgmt/bastille/bin:/opt/caliper/bin:/opt/drd/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/resmon/bin:/opt/firefox:/opt/gnome/bin:/opt/perf/bin:/opt/propplus/bin:/usr/contrib/kwdb/bin:/opt/perl_32/bin:/opt/perl_64/bin:/opt/prm/bin:/opt/sfm/bin:/opt/swm/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/swa/bin:/opt/hpsmh/bin:/opt/thunderbird:/opt/sentinel/bin:/opt/langtools/bin:/opt/wlm/bin:/opt/gwlm/bin:/opt/hpnpl//bin:/opt/ignite/bin:/usr/local/bin
LOGNAME=oraris
SHELL=/bin/csh
TERM=xterm
COLUMNS=93
LINES=34
MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/VRTS/vxfs5.0/man:/opt/ldapux/share/man/%L:/opt/ldapux/share/man:/opt/ipf/man:/opt/ldapux/ypldapd/man:/opt/samba/man:/opt/samba/WTEC_Support_Tools/man:/opt/samba/cfsm_man:/opt/cifsclient/share/man:/opt/openssl/man:/opt/openssl/prngd/man:/opt/wbem/share/man:/opt/graphics/common/man:/opt/amgr/man/%L:/opt/amgr/man:/opt/sec_mgmt/share/man:/usr/dt/share/man:/opt/caliper/man/%L:/opt/caliper/man:/opt/drd/share/man/%L:/opt/drd/share/man:/opt/dsau/man:/opt/resmon/share/man/%L:/opt/gnome/man:/opt/perf/man/%L:/opt/perf/man:/opt/propplus/share/man:/usr/contrib/kwdb/share/man:/opt/perl_32/man:/opt/perl_64/man:/opt/prm/man/%L:/opt/prm/man:/opt/psb/healthtest/share/man:/opt/sfm/share/man:/opt/swm/share/man/%L:/opt/swm/share/man:/opt/swa/share/man/%L:/opt/swa/share/man:/opt/ssh/share/man:/opt/sentinel/man/%L:/opt/sentinel/man:/opt/langtools/share/man/%L:/opt/langtools/share/man:/opt/wlm/share/man/%L:/opt/wlm/share/man:/opt/openssl/fips/0.9.7/man:/opt/openssl/fips/0.9.8/man:/opt/gwlm/man/%L:/opt/gwlm/man:/opt/icod/man/%L:/opt/icod/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/hpnpl//man:/opt/resmon/share/man
TZ=MET-1METDST
SAPSYSTEMNAME=RIS
DIR_LIBRARY=/usr/sap/RIS/SYS/exe/run
SHLIB_PATH=/usr/sap/RIS/SYS/exe/run:/oracle/RIS/112_64/lib
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=RIS
dbs_ora_schema=SAPR3
ORACLE_SID=RIS
DB_SID=RIS
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/RIS/112_64
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/RIS
sapux24:oraris 11>
Thanks
Reza
Dear Deepak,
I have seen this note, The OPS$ORARIS user is exist and open.
My problem is not SAPinst, the problem is Ican not start sap witl startsap r3.
SQL> select username, account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
OPS$ORARIS OPEN
OPS$RISADM OPEN
SAPR3SHD OPEN
----------------------------------
sapux24:risadm 50> startsap R3
Checking RIS Database
------------------------------
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
------------------------------
***********************************************************************
* This is Saposcol Version COLL 20.95 700 - V2.7.1 2008-08-11 HP-UX IA64
* 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 10017) is already running .....
************************************************************************
saposcol already running
ABAP Database RIS must be started first
sapux24:risadm 51>
Thanks
Hi.
I hope you can use this part.
-rrwsrwsrwt 1 oraris dba 2685150 May 14 2010 libagent10.a
lrwxr-xr-x 1 oraris dba 38 Feb 5 10:25 libagtsh.so -> /oracle/RIS/102_64/lib/libagtsh.so.1.0
-rwsrwsrwt 1 oraris dba 0 Dec 5 13:18 libclntsh.sl
lrwxr-xr-x 1 oraris dba 17 Feb 5 10:25 libclntsh.so -> libclntsh.so.10.1
-rwsrwsrwt 1 oraris dba 51670920 Feb 5 10:25 libclntsh.so.10.1
-rwsrwsrwt 1 oraris dba 8207072 Feb 5 10:22 libn10.a
lrwxrwx--- 1 oraris dba 36 Dec 5 13:12 libnavhoa.a -> /oracle/RIS/102_64/lib32/libnavhoa.a
-rwsrwsrwt 1 oraris dba 114876 Apr 16 2010 libnbeq10.a
-srwsrwt 1 oraris dba 170976 May 4 2010 libocrutl10.so
lrwxrwx--- 1 oraris dba 12 Dec 5 13:12 libodm10.so -> libodmd10.so
-rwsrwsrwt 1 oraris dba 67696 May 14 2010 libodmd10.so
-rwsrwsrwt 1 oraris dba 28385860 May 14 2010 liboraolap10.a
lrwxr-xr-x 1 oraris dba 40 Feb 5 10:25 liborasdk.so -> /oracle/RIS/102_64/lib/liborasdk.so.10.2
-rwsrwsrwt 1 oraris dba 45355888 Feb 5 10:25 liborasdk.so.10.2
lrwxr-xr-x 1 oraris dba 44 Feb 5 10:25 liborasdkbase.so -> /oracle/RIS/102_64/lib/liborasdkbase.so.10.2
-rwsrwsrwt 1 oraris dba 9034800 Feb 5 10:25 liborasdkbase.so.10.2
-rwsrwsrwt 1 oraris dba 1919780 Apr 28 2010 libordim10.a
Thanks
Hi again,
Her is fuld screenshut .
Thanks again
ora.so
lrwxrwx--- 1 oraris dba 36 Dec 5 13:12 hsdb_syb.so -> /oracle/RIS/102_64/lib32/hsdb_syb.so
-rwsrwsrwt 1 oraris dba 232488 May 23 2005 http_client.jar
-rwsrwsrwt 1 oraris dba 56899 Sep 25 2000 jdev-rt.zip
-rwsrwsrwt 1 oraris dba 463863 Sep 11 2002 jsse.jar
-rwsrwsrwt 1 oraris dba 244785 Apr 13 2010 lclasses12.zip
-rwsrwsrwt 1 oraris dba 131 Feb 5 10:25 ldflags
-rwsrwsrwt 1 oraris dba 131 Feb 5 10:22 ldflagsO
-rwsrwsrwt 1 oraris dba 67992 Apr 23 2010 libOsUtils.so
-rwsrwsrwt 1 oraris dba 2685150 May 14 2010 libagent10.a
lrwxr-xr-x 1 oraris dba 38 Feb 5 10:25 libagtsh.so -> /oracle/RIS/102_64/lib/libagtsh.so.1.0
-rwsrwsrwt 1 oraris dba 9533568 Feb 5 10:25 libagtsh.so.1.0
-rwsrwsrwt 1 oraris dba 34972 May 14 2010 libavstub10.a
-rwsrwsrwt 1 oraris dba 13347560 May 14 2010 libclient10.a
-rwsrwsrwt 1 oraris dba 0 Dec 5 13:18 libclntsh.sl
lrwxr-xr-x 1 oraris dba 17 Feb 5 10:25 libclntsh.so -> libclntsh.so.10.1
-rwsrwsrwt 1 oraris dba 51670920 Feb 5 10:25 libclntsh.so.10.1
-rwsrwsrwt 1 oraris dba 51670920 Feb 5 10:24 libclntsh_nopthread.so
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libclntst10.a
-rwsrwsrwt 1 oraris dba 2288764 May 4 2010 libclsr10.a
-rwsrwsrwt 1 oraris dba 2868848 May 4 2010 libclsra10.so
-rwsrwsrwt 1 oraris dba 29614 May 4 2010 libclsrx10.a
-rwsrwsrwt 1 oraris dba 4575228 May 14 2010 libcommon10.a
-rwsrwsrwt 1 oraris dba 8224706 Apr 23 2010 libcore10.a
-rwsrwsrwt 1 oraris dba 3124416 Apr 23 2010 libcorejava.so
-rwsrwsrwt 1 oraris dba 4015088 Apr 23 2010 libcoresh10.so
-rwsrwsrwt 1 oraris dba 6385288 May 14 2010 libctx10.a
-rwsrwsrwt 1 oraris dba 1607718 May 14 2010 libctxc10.a
-rwsrwsrwt 1 oraris dba 276170 May 14 2010 libctxs10.a
-rwsrwsrwt 1 oraris dba 241125 Jun 13 2005 libcxa.so.3
-rwsrwsrwt 1 oraris dba 231336 May 4 2010 libdbcfg10.a
-rwsrwsrwt 1 oraris dba 199296 May 4 2010 libdbcfg10.so
-rwsrwsrwt 1 oraris dba 12758010 Apr 6 2006 libdbtools10.a
-rwsrwsrwt 1 oraris dba 68344 May 4 2010 libemmas10.so
-rwsrwsrwt 1 oraris dba 805338 Jun 5 2007 libexpat.a
-rwsrwsrwt 1 oraris dba 744 Jun 5 2007 libexpat.la
-rwsrwsrwt 1 oraris dba 588424 Jun 10 2007 libexpat.so
-rwsrwsrwt 1 oraris dba 588424 Jun 10 2007 libexpat.so.0
-rwsrwsrwt 1 oraris dba 588424 Jun 10 2007 libexpat.so.0.5.0
-rwsrwsrwt 1 oraris dba 588424 Jun 10 2007 libexpat.so.5
-rwsrwsrwt 1 oraris dba 33333560 May 14 2010 libgeneric10.a
-rwsrwsrwt 1 oraris dba 808734 May 14 2010 libgx10.a
-rwsrwsrwt 1 oraris dba 1826448 May 4 2010 libhasgen10.so
-rwsrwsrwt 1 oraris dba 68536 Apr 21 2010 libheteroxa10.so
-rwsrwsrwt 1 oraris dba 2809884 May 14 2010 libhsbase.so
-rwsrwsrwt 1 oraris dba 2594467 May 14 2010 libhsnav.so
-rwsrwsrwt 1 oraris dba 169720 Apr 23 2010 libisqlplus.so
-rwsrwsrwt 1 oraris dba 56262776 Apr 16 2010 libjmisc.so
-rwsrwsrwt 1 oraris dba 20196840 May 14 2010 libjox10.so
-rwsrwsrwt 1 oraris dba 8241256 May 14 2010 libjox10oraawt.so
-rwsrwsrwt 1 oraris dba 2889934 Apr 21 2010 libldapclnt10.a
-rwsrwsrwt 1 oraris dba 63288 Apr 21 2010 libldapjclnt10.a
-rwsrwsrwt 1 oraris dba 135816 Apr 21 2010 libldapjclnt10.so
-rwsrwsrwt 1 oraris dba 256338 Apr 21 2010 liblxled.a
-rwsrwsrwt 1 oraris dba 69128 Apr 23 2010 libmgwagent.so
-rwsrwsrwt 1 oraris dba 8276 May 14 2010 libmm.a
-rwsrwsrwt 1 oraris dba 8207072 Feb 5 10:22 libn10.a
lrwxrwx--- 1 oraris dba 36 Dec 5 13:12 libnavhoa.a -> /oracle/RIS/102_64/lib32/libnavhoa.a
-rwsrwsrwt 1 oraris dba 114876 Apr 16 2010 libnbeq10.a
-rwsrwsrwt 1 oraris dba 504518 Apr 16 2010 libncrypt10.a
-rwsrwsrwt 1 oraris dba 29500 Apr 16 2010 libnhost10.a
-rwsrwsrwt 1 oraris dba 160602 May 14 2010 libnid.a
-rwsrwsrwt 1 oraris dba 217552 Apr 16 2010 libnjni10.so
-rwsrwsrwt 1 oraris dba 3465896 Apr 16 2010 libnjssl10.so
-rwsrwsrwt 1 oraris dba 1674560 Apr 16 2010 libnl10.a
-rwsrwsrwt 1 oraris dba 228232 Apr 16 2010 libnldap10.a
-rwsrwsrwt 1 oraris dba 4861560 Apr 21 2010 libnls10.a
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmadbg.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmadbg.so.0
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmadm.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmadm.so.0
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmalk.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmalk.so.0
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmarl.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmarl.so.0
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmasf.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmasf.so.0
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmastk.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmastk.so.0
-rwsrwsrwt 1 oraris dba 69008 Apr 20 2010 libnmcfhc.so
-rwsrwsrwt 1 oraris dba 135060 Apr 20 2010 libnmcfsga.so
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmefos.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmefos.so.0
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmefsql.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmefsql.so.0
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmefud.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmefud.so.0
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmefut.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmefut.so.0
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmefvr.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmefvr.so.0
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmefw.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmefw.so.0
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmemso.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmemso.so.0
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmeoci.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmeoci.so.0
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmevq.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmevq.so.0
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmuc.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmuc.so.0
-rwsrwsrwt 1 oraris dba 0 Feb 4 2006 libnmuk.so
-rwsrwsrwt 1 oraris dba 0 May 12 2005 libnmuk.so.0
-rwsrwsrwt 1 oraris dba 47654 May 14 2010 libnnet10.a
-rwsrwsrwt 1 oraris dba 47654 May 14 2010 libnnetd10.a
-rwsrwsrwt 1 oraris dba 59892 Apr 16 2010 libnnis10.a
-rwsrwsrwt 1 oraris dba 16926540 Apr 16 2010 libnnz10.a
-rwsrwsrwt 1 oraris dba 5337360 Apr 16 2010 libnnz10.so
-rwsrwsrwt 1 oraris dba 18330 Apr 16 2010 libnoname10.a
-rwsrwsrwt 1 oraris dba 0 Dec 21 2005 libnque10.so
-rwsrwsrwt 1 oraris dba 1761366 Apr 16 2010 libnro10.a
-rwsrwsrwt 1 oraris dba 189458 Apr 16 2010 libnsgr10.a
-rwsrwsrwt 1 oraris dba 189458 Apr 16 2010 libnsgrsh10.a
-rwsrwsrwt 1 oraris dba 3642 Apr 16 2010 libnsslb10.a
-rwsrwsrwt 1 oraris dba 168650 Apr 16 2010 libntcp10.a
-rwsrwsrwt 1 oraris dba 0 Dec 21 2005 libntcpaio10.so
-rwsrwsrwt 1 oraris dba 188498 Apr 16 2010 libntcps10.a
-rwsrwsrwt 1 oraris dba 4472 Apr 16 2010 libntcps10_std.a.dbl
-rwsrwsrwt 1 oraris dba 27506 Apr 16 2010 libntns10.a
-rwsrwsrwt 1 oraris dba 107498 Apr 16 2010 libnus10.a
-rwsrwsrwt 1 oraris dba 21230 Apr 16 2010 libnzjs10.a
lrwxr-xr-x 1 oraris dba 15 Feb 5 10:15 libocci.so -> libocci.so.10.1
-rwsrwsrwt 1 oraris dba 3317152 May 14 2010 libocci.so.10.1
-rwsrwsrwt 1 oraris dba 10203900 May 14 2010 libocci10.a
-rwsrwsrwt 1 oraris dba 0 Dec 22 2005 libocci10_296.a
-rwsrwsrwt 1 oraris dba 0 Dec 22 2005 libocci10_296.so.10.1
-rwsrwsrwt 1 oraris dba 334380 Apr 21 2010 libocijdbc10.a
-rwsrwsrwt 1 oraris dba 266632 Apr 21 2010 libocijdbc10.so
-rwsrwsrwt 1 oraris dba 334380 Apr 21 2010 libocijdbcst10.a
-rwsrwsrwt 1 oraris dba 1503082 May 4 2010 libocr10.a
-rwsrwsrwt 1 oraris dba 912048 May 4 2010 libocr10.so
-rwsrwsrwt 1 oraris dba 1650798 May 4 2010 libocrb10.a
-rwsrwsrwt 1 oraris dba 748400 May 4 2010 libocrb10.so
-rwsrwsrwt 1 oraris dba 179330 May 4 2010 libocrutl10.a
-rwsrwsrwt 1 oraris dba 170976 May 4 2010 libocrutl10.so
lrwxrwx--- 1 oraris dba 12 Dec 5 13:12 libodm10.so -> libodmd10.so
-rwsrwsrwt 1 oraris dba 67696 May 14 2010 libodmd10.so
-rwsrwsrwt 1 oraris dba 3065266 May 4 2010 liboevm.a
-rwsrwsrwt 1 oraris dba 45581280 May 14 2010 libolapapi10.so
-rwsrwsrwt 1 oraris dba 262592 May 14 2010 libons.so
-rwsrwsrwt 1 oraris dba 80608 Apr 27 2010 liboraioser.so
-rwsrwsrwt 1 oraris dba 71752 Apr 27 2010 liborajaas.so
-rwsrwsrwt 1 oraris dba 28385860 May 14 2010 liboraolap10.a
lrwxr-xr-x 1 oraris dba 40 Feb 5 10:25 liborasdk.so -> /oracle/RIS/102_64/lib/liborasdk.so.10.2
-rwsrwsrwt 1 oraris dba 45355888 Feb 5 10:25 liborasdk.so.10.2
lrwxr-xr-x 1 oraris dba 44 Feb 5 10:25 liborasdkbase.so -> /oracle/RIS/102_64/lib/liborasdkbase.so.10.2
-rwsrwsrwt 1 oraris dba 9034800 Feb 5 10:25 liborasdkbase.so.10.2
-rwsrwsrwt 1 oraris dba 1919780 Apr 28 2010 libordim10.a
-rwsrwsrwt 1 oraris dba 999504 Apr 28 2010 libordim10.so
-rwsrwsrwt 1 oraris dba 0 Jun 22 2005 libordim10.soO
-rwsrwsrwt 1 oraris dba 550302 Apr 28 2010 libordimt10.a
-rwsrwsrwt 1 oraris dba 12745108 May 14 2010 libordsdo10.a
-rwsrwsrwt 1 oraris dba 208048 Apr 16 2010 libowm2.so
-rwsrwsrwt 1 oraris dba 361446 May 14 2010 libplc10.a
-rwsrwsrwt 1 oraris dba 12954544 May 14 2010 libplp10.a
-rwsrwsrwt 1 oraris dba 20883994 May 14 2010 libpls10.a
-rwsrwsrwt 1 oraris dba 564186 May 14 2010 libpsa10.a
-rwsrwsrwt 1 oraris dba 529664 May 14 2010 libqsmashr.so
-rwsrwsrwt 1 oraris dba 252764240 May 14 2010 libserver10.a
-rwsrwsrwt 1 oraris dba 10352 Feb 4 2006 libskgxn2.so
-rwsrwsrwt 1 oraris dba 67696 May 14 2010 libskgxns.so
-rwsrwsrwt 1 oraris dba 28424 May 14 2010 libskgxp10.a
-rwsrwsrwt 1 oraris dba 396928 Feb 5 10:19 libskgxp10.so
-rwsrwsrwt 1 oraris dba 487194 Dec 21 2005 libskgxp9.a
-rwsrwsrwt 1 oraris dba 31136 Feb 4 2006 libskgxpd.a
-rwsrwsrwt 1 oraris dba 67760 May 14 2010 libskgxpd.so
-rwsrwsrwt 1 oraris dba 444152 Apr 25 2006 libskgxpg.a
-rwsrwsrwt 1 oraris dba 396928 May 14 2010 libskgxpg.so
-rwsrwsrwt 1 oraris dba 505362 May 14 2010 libskgxpu.a
-rwsrwsrwt 1 oraris dba 42792 Apr 23 2010 libslax10.a
-rwsrwsrwt 1 oraris dba 672532 Apr 21 2010 libsnls10.a
-rwsrwsrwt 1 oraris dba 1765510 May 14 2010 libsql10.a
-rwsrwsrwt 1 oraris dba 3468302 Apr 23 2010 libsqlplus.a
-rwsrwsrwt 1 oraris dba 1744624 Apr 23 2010 libsqlplus.so
-rwsrwsrwt 1 oraris dba 68520 Feb 5 10:25 libsrvm10.so
-rwsrwsrwt 1 oraris dba 68520 Feb 5 10:23 libsrvm10.so0
-rwsrwsrwt 1 oraris dba 200920 Feb 5 10:23 libsrvmhas10.so
-rwsrwsrwt 1 oraris dba 1085224 May 4 2010 libsrvmhas10.so0
-rwsrwsrwt 1 oraris dba 134016 Feb 5 10:23 libsrvmocr10.so
-rwsrwsrwt 1 oraris dba 134016 May 4 2010 libsrvmocr10.so0
-rwsrwsrwt 1 oraris dba 0 Apr 24 2006 libtgO
-rwsrwsrwt 1 oraris dba 53276096 Feb 5 10:24 libttsh10.so
-rwsrwsrwt 1 oraris dba 14000 May 4 2010 libuini10.a
-rwsrwsrwt 1 oraris dba 67608 May 4 2010 libuini10.so
-rwsrwsrwt 1 oraris dba 414286 Apr 21 2010 libunls10.a
-rwsrwsrwt 1 oraris dba 5830 May 14 2010 libvsn10.a
-rwsrwsrwt 1 oraris dba 5806 May 14 2010 libvsn10_std.a.dbl
-rwsrwsrwt 1 oraris dba 704132 Apr 9 2010 libwwg.a
-rwsrwsrwt 1 oraris dba 415744 May 14 2010 libxdb.so
-rwsrwsrwt 1 oraris dba 10611206 Apr 21 2010 libxml10.a
-rwsrwsrwt 1 oraris dba 433238 May 14 2010 libzx10.a
-rwsrwsrwt 1 oraris dba 280984 Oct 23 2001 mail.jar
-rwsrwsrwt 1 oraris dba 4208 Apr 16 2010 naect.o
-rwsrwsrwt 1 oraris dba 2400 May 16 2010 naect_std.o.dbl
-rwsrwsrwt 1 oraris dba 3480 Apr 16 2010 naedhs.o
-rwsrwsrwt 1 oraris dba 13664 Apr 16 2010 naeet.o
-rwsrwsrwt 1 oraris dba 6944 May 16 2010 naeet_std.o.dbl
-rwsrwsrwt 1 oraris dba 2464 Apr 16 2010 nautab.o
-rwsrwsrwt 1 oraris dba 2200 Apr 16 2010 nautab_std.o.dbl
-rwsrwsrwt 1 oraris dba 21200 Apr 16 2010 nigcon.o
-rwsrwsrwt 1 oraris dba 3272 Apr 16 2010 nigtab.o
-rwsrwsrwt 1 oraris dba 2744 Feb 5 10:25 nnfgt.o
-rwsrwsrwt 1 oraris dba 2704 Feb 5 10:22 ntcontab.o
-rwsrwsrwt 1 oraris dba 148377 Apr 8 2010 oraclexsql.jar
-rwsrwsrwt 1 oraris dba 3336 Apr 16 2010 osntabst.o
-rwsrwsrwt 1 oraris dba 105 Jan 12 2004 recvlets.reg
-rwsrwsrwt 1 oraris dba 6344 Apr 23 2010 s0main.o
-rwsrwsrwt 1 oraris dba 2352 Apr 23 2010 scorept.o
-rwsrwsrwt 1 oraris dba 39857 Sep 11 2002 servlet.jar
-rwsrwsrwt 1 oraris dba 0 Dec 21 2005 sltsstub.o
drwsrwsrwt 2 oraris dba 96 Dec 5 13:11 socket_stub
-rwsrwsrwt 1 oraris dba 2080 Apr 23 2010 sscoreed.o
drwsrwsrwt 2 oraris dba 8192 Feb 5 10:14 stubs
-rwsrwsrwt 1 oraris dba 74 Apr 23 2010 sysliblist
-rwsrwsrwt 1 oraris dba 103557 Apr 8 2010 transx.zip
-rwsrwsrwt 1 oraris dba 24136 Feb 5 10:24 ttsh.def
-rwsrwsrwt 1 oraris dba 544511 Apr 8 2010 xml.jar
-rwsrwsrwt 1 oraris dba 93107 Apr 8 2010 xmlcomp.jar
-rwsrwsrwt 1 oraris dba 11527 Apr 8 2010 xmlcomp2.jar
-rwsrwsrwt 1 oraris dba 631893 Apr 8 2010 xmlmesg.jar
-rwsrwsrwt 1 oraris dba 1218122 Apr 8 2010 xmlparserv2.jar
-rwsrwsrwt 1 oraris dba 13584 May 16 2010 xnetstubs.o
-rwsrwsrwt 1 oraris dba 129799 Apr 8 2010 xschema.jar
-rwsrwsrwt 1 oraris dba 3565 Apr 8 2010 xsqlserializers.jar
-rwsrwsrwt 1 oraris dba 193137 Apr 8 2010 xsu12.jar
sapux24:oraris 3> -rwsrwsrwt 1 oraris dba 504518 Apr 16 2010 libncrypt10.a^?^?^?^?^?^?^?^?^?^?^?^?^?^?^?^?
-rwsrwsrwt: Command not found.
sapux24:oraris 4>
Hello again,
I did tried run command:
brconnect -u system/gammon12 -f chpass -o SAPR3 -P sap
the user name is SAPR3 and not SAPSR3.
sapux24:oraris 9> brconnect -u system/gammon12 -f chpass -o SAPR3 -P sap
BR0801I BRCONNECT 7.20 (30)
BR0280I BRCONNECT time stamp: 2013-04-04 14.07.48
BR0828I Changing password for database user SAPR3 ...
BR0280I BRCONNECT time stamp: 2013-04-04 14.07.48
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT:
c
BR0280I BRCONNECT time stamp: 2013-04-04 14.07.56
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0280I BRCONNECT time stamp: 2013-04-04 14.07.56
BR0829I Password changed successfully in database for user SAPR3
BR0830I Password changed successfully in table OPS$RISADM.SAPUSER for user SAPR3
BR0280I BRCONNECT time stamp: 2013-04-04 14.07.56
BR0802I BRCONNECT completed successfully
sapux24:oraris 10>
I have done this befor too. Still the same problem.
Thanks again for help,
Her is trans log file:
sapux24:risadm 21> R3trans -d
This is R3trans version 6.14 (release 700 - 24.07.12 - 20:12:04 ).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'RIS'"
R3trans finished (0012).
sapux24:risadm 25> more trans.log
4 ETW000 R3trans version 6.14 (release 700 - 24.07.12 - 20:12:04 ).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 04.04.2013 - 16:01:27
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [ dev trc,00000] Thu Apr 4 16:01:27 2013
467 0.000467
4 ETW000 [ dev trc,00000] db_con_init called
15 0.000482
4 ETW000 [ dev trc,00000] create_con (con_name=R/3)
84 0.000566
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/RIS/SYS/exe/run/dboraslib.so' ...
30 0.000596
4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/RIS/SYS/exe/run/dboraslib.so"), h
dl 0
4 ETW000
34943 0.035539
4 ETW000 [ dev trc,00000] Library '/usr/sap/RIS/SYS/exe/run/dboraslib.so' loaded
29 0.035568
4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/RIS/SYS/exe/run/dbora
slib.so
4 ETW000
39 0.035607
4 ETW000 [ dev trc,00000] Version of '/usr/sap/RIS/SYS/exe/run/dboraslib.so' is "700.08", patchle
vel (0.342)
4 ETW000
351 0.035958
4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/RIS/SYS/exe/run/dbor
aslib.so
4 ETW000
31 0.035989
4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/RIS/SYS/exe/run/dbo
raslib.so
4 ETW000
85 0.036074
4 ETW000 [ dev trc,00000] New connection 0 created
67 0.036141
4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , h
c = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 25
5, occ = NO
4 ETW000
171 0.036312
4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3)
39 0.036351
4 ETW000 [ dev trc,00000] find_con_by_name found the following connection for reuse:
15 0.036366
4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc
= NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 25
5, occ = NO
4 ETW000
36 0.036402
4 ETW000 [ dev trc,00000] -->oci_init1
331 0.036733
4 ETW000 [ dev trc,00000] Oracle Client Version: '11.2.0.3.0', (dbsl 700 110412, UNICODE[2])
164 0.036897
4 ETW000 [ dev trc,00000] Default connection: tnsname ='RIS'
17 0.036914
4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', uc_ln=2)
33 0.036947
4 ETW000 [ dev trc,00000] Application info callback registered.
16 0.036963
4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS hand
le)
4 ETW000
13632 0.050595
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=0x6000000001139588)
100 0.050695
4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=0x600000000113a628)
43 0.050738
4 ETW000 [ dev trc,00000] NLS env.: lang=0041004D00450052004900430041004E
322 0.051060
4 ETW000 [ dev trc,00000] terr=0041004D00450052004900430041
22 0.051082
4 ETW000 [ dev trc,00000] char=00550054004600310036
18 0.051100
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo): con=0, 'AMERICAN_AMERICA.UTF16'
4 ETW000
24 0.051124
4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE
15 0.051139
4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPR3's password
42 0.051181
4 ETW000 [ dev trc,00000] Connecting as /@RIS on connection 0 (nls 0) ... (dbsl 700 110412, UNICO
DE[2])
4 ETW000
26 0.051207
4 ETW000 [ dev trc,00000] Allocating service context handle for con=0
57 0.051264
4 ETW000 [ dev trc,00000] Allocating server context handle
20 0.051284
4 ETW000 [ dev trc,00000] Attaching to DB Server RIS (con=0,svchp=0x600000000113a548,srvhp=0x6000
00000113d6b0)
4 ETW000
168 0.051452
4 ETW000 [ dev trc,00000] Assigning server context 0x600000000113d6b0 to service context 0x600000
000113a548
4 ETW000 1
16788 0.168240
4 ETW000 [ dev trc,00000] Allocating user session handle
106 0.168346
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='/',svchp=0x600000000
113a548, srvhp=0x600000000113d6b0, usrhp=0x60000000011c1be0)
4 ETW000
48 0.168394
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR
8566 0.176960
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:
262 0.177222
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000
34 0.177256
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017'
59 0.177315
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017
17 0.177332
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017)
16 0.177348
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017
87 0.177435
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000
26 0.177461
4 ETW000 [ dev trc,00000] Info: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password.
4 ETW000
48 0.177509
4 ETW000 [ dev trc,00000] Connecting as SAPR3/<pwd>@RIS on connection 0 (nls 0) ... (dbsl 700 110
412, UNICODE[2])
4 ETW000
27 0.177536
4 ETW000 [ dev trc,00000] Assigning username to user session: con=0, usrhp=0x60000000011c1be0
18 0.177554
4 ETW000 [ dev trc,00000] Assigning password to user session: con=0, usrhp=0x60000000011c1be0
146 0.177700
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr=SAPR3/<pwd>, svchp=0x
600000000113a548, srvhp=0x600000000113d6b0, usrhp=0x60000000011c1be0)
4 ETW000
618 0.178318
4 ETW000 [ dev trc,00000] Thu Apr 4 16:01:29 2013 20
06859 2.185177
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR
59 2.185236
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:
157 2.185393
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000
34 2.185427
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017'
27 2.185454
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017
17 2.185471
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017)
17 2.185488
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017
88 2.185576
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000
26 2.185602
4 ETW000 [ dblink ,00433] ***LOG BY2=>sql error 1017 performing CON [dblink#8 @ 433]
252 2.185854
4 ETW000 [ dblink ,00433] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#
8 @ 433]
4 ETW000
29 2.185883
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'RIS'"
Hi,
Please try to check the below note...
Note 400241 - Problems with ops$ or sapr3 connect to Oracle
Did you apply the note which I gave you before ?? I mean Note 1519872 - SAP Database User Profile SAPUPROF
If not, please apply and check once.
Thanks and regards,
Vimal
Hi Reza,
Please provide the output of the following command
1. SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';
Then run
2. SELECT * FROM "OWNER".SAPUSER; (OWNER will be name which you get in the first sql command)
select username, account_status from dba_users;
With Regards
Ashutosh Chaturvedi
Hi Ashutosh,
Thanks for help,
Her is result:
SQL> select username, account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SYSTEM OPEN
SYS OPEN
OPS$SAPSERVICEVIP OPEN
OPS$ORARIS OPEN
OPS$RISADM OPEN
SAPR3SHD OPEN
OPS$SAPSERVICERST OPEN
OPS$SAPSERVICERIS OPEN
SAPR3 OPEN
STKPRODA OPEN
OUTLN LOCKED
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
DIP EXPIRED & LOCKED
ORACLE_OCM EXPIRED & LOCKED
DBSNMP EXPIRED & LOCKED
APPQOSSYS EXPIRED & LOCKED
15 rows selected.
SQL>
Thanks
Hi Reza,
OPS$SAPSERVICERST & OPS$SAPSERVICEVIP
Do you have any other system with RST and VIP.
Please provide the output of this two sql statement :
1. SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';
Then run
2. SELECT * FROM "OWNER".SAPUSER; (OWNER will be name which you get in the first sql command)
With Regards
Ashutosh Chaturvedi
Hi Reza,
owner is different over here
owner should be
OPS$RISADM as your database is RIS.
to change the owner :
1. DROP TABLE "OPS$RSTADM".SAPUSER;
2. CREATE TABLE "OPS$RISADM".SAPUSER
(USERID VARCHAR2(256), PASSWD VARCHAR2(256));
INSERT INTO "OPS$RISADM".SAPUSER VALUES ('SAPR3', 'pass');
3. ALTER USER SAPR3 IDENTIFIED BY pass;
Then start the sap system.
With Regards
Ashutosh Chaturvedi
Hello,
I had done it;
I have no problem there:
sapux24:oraris 9> brconnect -u system/gammon12 -f chpass -o SAPR3
-P
sapBR0801I BRCONNECT 7.20 (30)
BR0280I BRCONNECT time stamp:
2013-04-04 14.07.48
BR0828I Changing password for database user SAPR3
...
BR0280I BRCONNECT time stamp: 2013-04-04 14.07.48
BR0256I Enter
'c[ont]' to continue, 's[top]' to cancel BRCONNECT:
c
BR0280I BRCONNECT
time stamp: 2013-04-04 14.07.56
BR0257I Your reply: 'c'
BR0259I Program
execution will be continued...
BR0280I BRCONNECT time stamp: 2013-04-04
14.07.56
BR0829I Password changed successfully in database for user
SAPR3
BR0830I Password changed successfully in table OPS$RISADM.SAPUSER for
user SAPR3
BR0280I BRCONNECT time stamp: 2013-04-04
14.07.56
BR0802I BRCONNECT completed successfully
sapux24:oraris
10>
Thanks
Hello,
I had done this but there is no result result,
SQL> INSERT INTO "OPS$RISADM".SAPUSER VALUES 'SAPR3', 'xxxxxxxx';
SQL>
And run
sapux24:risadm 32> R3trans -d
This is R3trans version 6.14 (release 700 - 24.07.12 - 20:12:04 ).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'RIS'"
R3trans finished (0012).
sapux24:risadm 33>
thanks
Reza
Ok, this is not that complicated.
Detailed info on how to set OPS$ users is available in SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle
Theres is a simple way to correct issues with OPS$ user and its by running the oradbusr.sql script as suggested on,
Note 361641 - Creating OPS$ users on UNIX
The script can be downloaded from
Note 50088 - Creating OPS$ users on Windows NT/Oracle
To supply the users with the right authorisations you can use sapconn_role.sql and sapdba_role.sql provided on the kernel directory.
Regards, Juan
Dear Juan,
Thanks for reply,
I have seen this note and done alle sugisten,
The user is correctI can logon ORACLE with this user. I had run:
brconnect -u system/gammon12 -f chpass -o SAPR3 -P
BR0829I Password changed successfully in database for user
SAPR3
BR0830I Password changed successfully in table OPS$RISADM.SAPUSER for
user SAPR3
BR0280I BRCONNECT time stamp: 2013-04-04
14.07.56
BR0802I BRCONNECT completed successfully
The problem is R3tans. And I can not start sap.
Thanks
Here is result
SQL> SELECT * FROM DBA_USERS WHERE USERNAME = 'OPS$RISADM';
USERNAME USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE
-------------------------------- --------------- ---------------
DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED
------------------------------ ------------------------------ ---------------
PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
OPS$RISADM 49 EXTERNAL
USERNAME USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE
-------------------------------- --------------- ---------------
DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED
------------------------------ ------------------------------ ---------------
PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
OPEN 02-OCT-13
USERNAME USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE
-------------------------------- --------------- ---------------
DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED
------------------------------ ------------------------------ ---------------
PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
SYSTEM PSAPTEMP 05-APR-13
USERNAME USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE
-------------------------------- --------------- ---------------
DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED
------------------------------ ------------------------------ ---------------
PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
DEFAULT DEFAULT_CONSUMER_GROUP
USERNAME USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE
-------------------------------- --------------- ---------------
DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED
------------------------------ ------------------------------ ---------------
PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
USERNAME USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE
-------------------------------- --------------- ---------------
DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED
------------------------------ ------------------------------ ---------------
PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
11G N EXTERNAL
USERNAME USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE
-------------------------------- --------------- ---------------
DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED
------------------------------ ------------------------------ ---------------
PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
SQL>
Thanks
Hi Ejersbo,
As per the logs
ORA-01017: invalid username/password; logon
Could you check whether SAPschema user is not locked and active. use the command
SQL> select username, account_status from dba_users;
Paste the output of this command.
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 Deepak,
thanks for help,
Her is result:
SQL> select username, account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SYSTEM OPEN
SYS OPEN
OPS$SAPSERVICEVIP OPEN
OPS$ORARIS OPEN
OPS$RISADM OPEN
SAPR3SHD OPEN
OPS$SAPSERVICERST OPEN
OPS$SAPSERVICERIS OPEN
SAPR3 OPEN
STKPRODA OPEN
OUTLN LOCKED
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
DIP EXPIRED & LOCKED
ORACLE_OCM EXPIRED & LOCKED
DBSNMP EXPIRED & LOCKED
APPQOSSYS EXPIRED & LOCKED
15 rows selected.
SQL>
Thanks
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.