Homogeneous system copy problem with ECC6

[Former Member]

I am creating a QAC ( Oracle /HPUX ) system from the backup of PRD with the following steps,

Created a vanilla System as QAC with sapinst ( it was running fine)

Deleted the datafiles and control files,

Restored the Database as QAC from PRD backup,

Restored the control files

Database ( QAC ) is up and running,

When I try to start SAP, it doesn’t start and I get the following error :

This is R3trans version 6.14 (release 700-15.06.07- 15:50:00).

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

R3trans finished (0012).

Please help

[Former Member · Accepted solution]

Hi AL MAMUM,

Check your trans.log file and post the message.

Best Wishes.

Kumar

[Former Member · Accepted solution]

Hi Kumar,

Here is part of trans.log

4 ETW000 41 0.145133

4 ETW000 [dev trc ,00000] Assigning user session 6000000000a4c748 to service context 6000000000a4f808

4 ETW000 12472 0.157605

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

4 ETW000 155 0.157760

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

4 ETW000 337 0.158097

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

4 ETW000 1735 0.159832

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

4 ETW000 33 0.159865

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

4 ETW000 332 0.160197

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

4 ETW000 767 0.160964

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1403 14 0.160978

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 128 0.161106

4 ETW000 [dev trc ,00000] Rolling back transaction ... 49 0.161155

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=6000000000a4f808,usrhp=6000000000a4c748)

4 ETW000 186 0.161341

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 538 0.161879

4 ETW000 [dev trc ,00000] Try to connect with default password 29 0.161908

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

4 ETW000 24 0.161932

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

4 ETW000 24 0.161956

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 6000000000a44600 6000000000a4bf30 6000000000a4f8d8

4 ETW000 23 0.161979

4 ETW000 [dev trc ,00000] Assigning username to user session 6000000000a4c748

4 ETW000 21 0.162000

4 ETW000 [dev trc ,00000] Assigning password to user session 6000000000a4c748

4 ETW000 127 0.162127

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=6000000000a4f808,srvhp=6000000000a51b18,usrhp=6000000000a4c748)

4 ETW000 24 0.162151

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

4 ETW000 3072 0.165223

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

4 ETW000 24 0.165247

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 14 0.165261

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

4 ETW000 142 0.165403

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

4 ETW000 22 0.165425

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

[JPReyes · Accepted solution]

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

That should solve your problem

Regards

Juan

[Former Member · Accepted solution]

Thanks Juan

Your reply solved the problem , I have applied note 400241 and it worked,

Best Regards, Al Mamun

[Former Member · Accepted solution]

hi Al Mamun,

I just get the same problem as you, and find this thread..

I want to apply the note that suggested by Juan, but I have no clue what to put in <sapowner> in this line :

INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>', '<password>');

I have inserted the SAPR3 and SAPPRD for <sapowner>, then i restarted the database (oracle), and then i try to run the R3trans -x. but still error.

Need your help..

Thanks in advance,

[Former Member · Accepted solution]

I have applied following part of the note 400241 at page 8

ORA-01403: No data found

Log entries: Logon as OPS$-user to get <sapowner>'s password

Connecting as /@<sid> on connection 0 ...

Now I'm connected to ORACLE

• ERROR => ORA-1403 when accessing table SAPUSER

The main cause for the ORA-01403 message is that table SAPUSER does not

contain any entries. Proceed as follows:

o Set the password consistently in SAPUSER and the Oracle Dictionary

using the following BRCONNECT call (BRCONNECT >= 6.10):

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

<password>

o Alternatively, you can add it to SAPUSER manually.

INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>',

'<password>');

Another possible cause is that incorrect entries are contained in SAPUSER.

Selection from SAPUSER is always made using the user name. For this reason,

make sure that the user name is always written in uppercase (SAPR3 or

SAP<sid>) and that it exactly corresponds to the value of the environment

variable dbs_ora_schema if SAP<sid> is used.

o If the ORA-01403 still occurs, check once more the above-mentioned

section "General checks".

[Former Member]

Hi..

Check if in the Listener file. You might need to make changes as per your DB SID..

Let us know if it works.

Regards,

Prashant

*Award points for All Helpful answers.

[Former Member]

Hi,

Did you check your environment variables? Or logged on by sidadm user correctly?

If you are using op$ mechanism, you need to check grants, also.

Best regards,

[Former Member]

Thanks Orkun,

Your reply was very helpful with the suggestion of another forum member i have applied note 400241 and it worked,

Best Regards, Al Mamun

Edited by: AL MAMUN on Mar 30, 2008 5:32 PM