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

[Former Member]

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'"

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[former_member206552]

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

[Former Member]

Hello Marius,

We have oracle 11, and

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. 

Thanks

Reza

[Former Member]

What value you have for os_authent_prefix parameter?

SQL> select value from v$parameter where name = 'os_authent_prefix';

[Former Member]

Hello Roman.

I have this value:

SQL> select value from v$parameter where name = 'os_authent_prefix';

VALUE
--------------------------------------------------------------------------------
ops$

Thanks

[Former Member]

Can you run R3trans -d now and provide trans.log file again.

[Former Member]

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>

[Former Member]

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

[Former Member]

Hi Vimal,

Thanks for reply,

When I try to run  brconnect: I get this massage?

sapux24:oraris 10> brconnect -u system/gammon12 -f chpass -o SAPSR3 -P sap

/usr/lib/pa20_64/dld.sl: Unable to find library 'libclntsh.sl.11.1'.

Killed

Do you knowwhat is the problem?

Thanks

[Former Member]

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

[Former Member]

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

[former_member188883]

Hi Ejersbo,

Could you checkout solutions mentioned in these SAP notes for ORA-01017.

169775	ORA-01017 with BRARCHIVE/BRBACKUP in a run
717677	BRCONNECT call of SAPInst fails with ORA-01017
776505	BR*Tools fail with ORA-01017 / ORA-01031 on Linux

Regards,

Deepak Kori

[Former Member]

And added scrrenshut

Thanks

[Former Member]

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

[Former Member]

Hi,

Can you please provide the complete list of oracle client and its contents?

Your screenshot is very blurred.

Thanks and Regards,

Vimal

[Former Member]

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

[Former Member]

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>

[Former Member]

Try this.

please go to /oracle/client/11x_64

type ln -s libclntsh.so.10.1  libclntsh.sl.11.1

and check.

Thanks and Regards,

Vimal

[Former Member]

First of all, usually you start brtools commands as <sid>adm user. It's affect the path where to find required libraries.

[former_member185239]

Hi Reza,

Run the below command ,

sqlplus /nolog

connect sapsr3/<password> if you can connect

then

set this parameter

dbs/ora/tnsname = RIS in your default parameter.

Start the sap system with startsap <virtual host name> and don't use r3 option.

With Regards

ashutosh chaturvedi

[Former Member]

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.

[former_member185239]

Hi Reza,

Alter user sapsr3 identified by sap.

Then try to start.

if not started ,

let me know.

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi Ashutosh,

I can connect with sapr3 user in sqlplus, and the the parameter

dbs/ora/tnsname = RIS it is set already.

Thanks again

[Former Member]

Hi Ashutosh,

Still the same problem with R3trans.

Thanks

[Former Member]

Hi,

Can you please attach the trans.log updated one?

Thanks and Regards,

Vimal

[Former Member]

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'"

[Former Member]

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

[former_member185239]

Hi Reza,

what error it is giving?

With Regards

Ashutosh Chaturvedi

[former_member185239]

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

[Former Member]

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

[former_member185239]

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

[Former Member]

Her is result , thanks again,

SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

OWNER

------------------------------

OPS$RSTADM

SQL> SELECT * FROM "OPS$RSTADM".SAPUSER;

SQL>

[former_member185239]

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

[Former Member]

Hi Ashutosh,

I have tried again to run this in RIS,

When I run this :

SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

OWNER
------------------------------
OPS$RISADM

But when  run this one I get no result.?

SQL> SELECT * FROM "OPS$RISADM".SAPUSER;

SQL>

Any Idea?

Thanks

[Former Member]

Run brconnect -u system/<password> -f chpass -o <sapowner> -p <password>.

[former_member185239]

Hi Reza,

Run the below command :

INSERT INTO "OPS$RISADM".SAPUSER VALUES ('SAPR3', 'pass');

Tell me the output.

With Regards

Ashutosh

[Former Member]

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

[Former Member]

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

[former_member185239]

Hi Reza,

Can you please provide the status of

Select * from "OPS$RISADM".SAPUSER;

With Regards

Ashutosh

[Former Member]

Hi Ashutosh,

The  OPS$RISADM".SAPUSER is not  table or view, is it+

Thanks

[JPReyes]

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

[Former Member]

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

[JPReyes]

Did you use the oradbusr.sql script to recreate the OPS$ users?

Regards, Juan

[Former Member]

Yes I did,

[JPReyes]

Did you run the sapconn and sapdba_role scripts?

Regards, Juan

[Former Member]

Yes I did.

And I done it again, no problem der.

We have this problem after restart the DB sever.

Thanks

Reza

[JPReyes]

Are you using the standard SAP<schema> password?

Regards, Juan

[Former Member]

Yes we do

Thanks

Reza

[JPReyes]

Try to change the password for SAPR3 directly

alter user SAPR3 identified by sap;

An run R3trans -d again

Regards, Juan

[Former Member]

Hi Juan,

I did it now again. Stil the same,

Thanks

Reza

[JPReyes]

Whats your OS?

[Former Member]

I push the wrong button

OS is

Unix

HP-UX on IA64 64bit

Thanks

[JPReyes]

Can you post result of...

SELECT * FROM DBA_USERS WHERE USERNAME = 'OPS$<os_user>';

Regards, Juan

[Former Member]

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

[former_member188883]

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

[former_member185239]

Hi Reza,

Sql command:

Alter user sapsr3 account unlock;

Then Run the R3trans -d command , if it returns 0000 ,

start your SAP System.

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi Ashutosh,

Thanks for reply,

The user is not locked.

Thanks again.

[Former Member]

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