ECC 6 system refresh

[Former Member]

Hi all

I am trying to do the system refresh of ECC 6 for the first time. The database part is done and database is up and running but the CI dies after sometime stating that the J2EE status info unavilable.

When I dig deep in it it feels like something is wrong with the SAPUSER table in the database thats having the sapecc user and the password for it. I did the R3TRANS -X and it created the log file that tells me that its not able to connect to the database.

Can anyone tell me the correct way to do the system refresh or how can I rectify this issue now.

Thanks in advance.

[Former Member · Accepted solution]

Hi Khan,

Please check the link

http://www.cryer.co.uk/brian/oracle/ORA01017.htm

Cheers,

Shyam

[Former Member · Accepted solution]

I am running Oracle 10.2 G and most of the registry settings defined here I cannot even see in my server. I am running ECC 6 on windows 64bit OS.

Thanks for your help.

[Former Member · Accepted solution]

I am trying to do the system refresh since the last 5 days and I am not able to do it. Here is what I did last night:

1) I restored the backup of the target server and make sure that everything is working the way its supposed to work before the refresh.

2) I exported SAPUSER table and other users who are database owners.

3) I refreshed the database of the target server with source server.

4) Bring up the Oracle database.

5) Imported the users and tables.

6) Now I dont see problem with the SAPUSER table but still I am not able to start the CI. When I execute the R3trans -X following is the log file generated. I am running ECC 6 with Oracle 10 G with ABAP and Java.

Thanks for all your help.

4 ETW000 r3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 11.03.2007 - 15:52:03

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Sun Mar 11 15:52:05 2007 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0.000000

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0.000000

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0.000000

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 5068 0.005068

4 ETW000 [dev trc ,00000] using "E:\usr\sap\ECX\SYS\exe\uc\NTAMD64\dboraslib.dll"

4 ETW000 35 0.005103

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 11 0.005114

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 17 0.005131

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.73)

4 ETW000 93 0.005224

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 15 0.005239

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 24 0.005263

4 ETW000 [dev trc ,00000] New connection 0 created 17 0.005280

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 29 0.005309

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 15 0.005324

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 14 0.005338

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 19 0.005357

4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or

4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.

4 ETW000 assuming using instant client with unspecified location.

4 ETW000 198 0.005555

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 6567 0.012122

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 26 0.012148

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 2394 0.014542

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPECC's password 30 0.014572

4 ETW000 [dev trc ,00000] Connecting as /@ECX on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

4 ETW000 20 0.014592

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 19 0.014611

4 ETW000 [dev trc ,00000] 0 UTF8 1 0000000005524090 0000000004FB41C0 0000000004FB9988

4 ETW000 111 0.014722

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 18 0.014740

4 ETW000 [dev trc ,00000] Allocating server context handle 14 0.014754

4 ETW000 [dev trc ,00000] Attaching to DB Server ECX (con_hdl=0,svchp=0000000004FB9848,svrhp=00000000055430E8)

4 ETW000 38 0.014792

4 ETW000 [dev trc ,00000] Sun Mar 11 15:52:06 2007 19562 0.034354

4 ETW000 [dev trc ,00000] Assigning server context 00000000055430E8 to service context 0000000004FB9848

4 ETW000 27 0.034381

4 ETW000 [dev trc ,00000] Allocating user session handle 29 0.034410

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000004FB9848,srvhp=00000000055430E8,usrhp=0000000004FB49D8)

4 ETW000 26 0.034436

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1045

4 ETW000 46843 0.081279

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=00000000055430E8)

4 ETW000 17 0.081296

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0000000004FB9848,srvhp=00000000055430E8)

4 ETW000 17 0.081313

4 ETW000 [dev trc ,00000] Deallocating server context handle 00000000055430E8

4 ETW000 415 0.081728

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1045'

4 ETW000 26 0.081754

4 ETW000 [dev trc ,00000] Try to connect with default password 68 0.081822

4 ETW000 [dev trc ,00000] Connecting as SAPECC/<pwd>@ECX on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

4 ETW000 16 0.081838

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 18 0.081856

4 ETW000 [dev trc ,00000] 0 UTF8 1 0000000005524090 0000000004FB41C0 0000000004FB9988

4 ETW000 21 0.081877

4 ETW000 [dev trc ,00000] Allocating server context handle 9 0.081886

4 ETW000 [dev trc ,00000] Attaching to DB Server ECX (con_hdl=0,svchp=0000000004FB9848,svrhp=00000000055430E8)

4 ETW000 29 0.081915

4 ETW000 [dev trc ,00000] Assigning server context 00000000055430E8 to service context 0000000004FB9848

4 ETW000 13391 0.095306

4 ETW000 [dev trc ,00000] Assigning username to user session 0000000004FB49D8

4 ETW000 21 0.095327

4 ETW000 [dev trc ,00000] Assigning password to user session 0000000004FB49D8

4 ETW000 28 0.095355

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000004FB9848,srvhp=00000000055430E8,usrhp=0000000004FB49D8)

4 ETW000 20 0.095375

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

4 ETW000 20919 0.116294

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 17 0.116311

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1017 performing CON [dblink#3 @ 431]

4 ETW000 100 0.116411

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#3 @ 431]

4 ETW000 15 0.116426

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

[Former Member · Accepted solution]

have a look to SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Cheers,

-Sunil

[Former Member · Accepted solution]

Sunil,

Thanks a lot for your response. I read the notes and found that if we change the SAPECC password to sap(default password) then it directly connects to the database. Its now connected. I cannot tell how happy I am. I was working on this issue since about a week.

Now second problem is that microsoft MMC is showing J2EE status info unavailable. I dont know what do with it. Anybody has any idea.

Thanks again dude.

[Former Member · Accepted solution]

Would you please tell us which notes helped?

Thanks!

[Former Member · Accepted solution]

400241

[Former Member]

Hello Shafquat,

Which Database? I consider your database to be ORACLE.

Please check the OSS notes:

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

The note would solve your problem for sure.

Regards,

Ammey Kesarkar

[Former Member]

It didn't help either. Instead of SAPR3 its using SAPECC user.

Thanks again.

[Former Member]

Hi,

Do the following.

1. Connect & startup as sysdba through ora<sid> user.

2. Reset the SAP<SID> / SAPR3 and OPS$<SID>adm user passwords.

SQL> alter user SAP<SID> identified by <password>;

SQL> commit;

Then shutdown the database & startup again.

after issuing this command you can try once R3trans -x using <sid>adm user, if not worked then

3. change the OPS$<SID>adm user password.

Hope this will help you.

Thanks & Regards

Balkrishna

"Award Points for useful information"

[Former Member]

I tried everything u stated here. Its still not working. See the logs from Trans.log file below. Apparently this is the problem with the SAPUSER table. I did the data refresh easily but the CI is not coming online stating that "J2EE inf status unavailable". I am running ECC6.0 , Oracle 10.2 G with Java and ABAP.

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPECC's password 29 0.015017

4 ETW000 [dev trc ,00000] Connecting as /@ECX on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

4 ETW000 20 0.015037

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 19 0.015056

4 ETW000 [dev trc ,00000] 0 UTF8 1 0000000007404090 0000000004FB41C0 0000000004FB9988

4 ETW000 106 0.015162

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 19 0.015181

4 ETW000 [dev trc ,00000] Allocating server context handle 13 0.015194

4 ETW000 [dev trc ,00000] Attaching to DB Server ECX (con_hdl=0,svchp=0000000004FB9848,svrhp=00000000074230E8)

4 ETW000 38 0.015232

4 ETW000 [dev trc ,00000] Assigning server context 00000000074230E8 to service context 0000000004FB9848

4 ETW000 19914 0.035146

4 ETW000 [dev trc ,00000] Allocating user session handle 27 0.035173

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000004FB9848,srvhp=00000000074230E8,usrhp=0000000004FB49D8)

4 ETW000 26 0.035199

4 ETW000 [dev trc ,00000] Assigning user session 0000000004FB49D8 to service context 0000000004FB9848

4 ETW000 69980 0.105179

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;

4 ETW000 50 0.105229

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;

4 ETW000 92 0.105321

4 ETW000 [dev trc ,00000] Now '/@ECX' is connected (con_hdl 0, nls_hdl 0).

4 ETW000 50606 0.155927

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 31 0.155958

4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)

4 ETW000 827 0.156785

4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-942 when accessing table SAPUSER

4 ETW000 983 0.157768

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 64 0.157832

4 ETW000 [dev trc ,00000] Rolling back transaction ... 14 0.157846

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0000000004FB9848,usrhp=0000000004FB49D8)

4 ETW000 201 0.158047

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 593 0.158640

4 ETW000 [dev trc ,00000] Try to connect with default password 14 0.158654

4 ETW000 [dev trc ,00000] Connecting as SAPECC/<pwd>@ECX on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

4 ETW000 15 0.158669

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 18 0.158687

4 ETW000 [dev trc ,00000] 0 UTF8 1 0000000007404090 0000000004FB41C0 0000000004FB9988

4 ETW000 20 0.158707

4 ETW000 [dev trc ,00000] Assigning username to user session 0000000004FB49D8

4 ETW000 22 0.158729

4 ETW000 [dev trc ,00000] Assigning password to user session 0000000004FB49D8

4 ETW000 22 0.158751

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000004FB9848,srvhp=00000000074230E8,usrhp=0000000004FB49D8)

4 ETW000 20 0.158771

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

4 ETW000 3780 0.162551

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 16 0.162567

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1017 performing CON [dblink#3 @ 431]

4 ETW000 99 0.162666

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#3 @ 431]

4 ETW000 15 0.162681

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