Error during the Start Instance phase (system copy)

[Former Member]

Hello,

This is a distributed installation (heterogeneous system copy). I´m facing an error during the phase "Start Instance" in the SAP SRM 7.0 / NW 7.01 during the heterogeneous copy system activity (central instance installation). I already installed the ASCS instance (in Windows Server 2012 (R2)) and the database instance (in a Linux - Suse 11 (SP3) on an Oracle DB 11.2.0.4). Now during the Central Instance installation (in the same windows server 2012 (R2) where is installed the ASCS instance) the SWPM show the following error during the phase "Start Instance":

I checked the log file dev_w0 and I found the following log:

- dev_w0:

...

M Tue Mar 24 23:05:11 2015

M  ThInit: running on host sapwinci

M 

M Tue Mar 24 23:05:13 2015

M  calling db_connect ...

B  Loading DB library 'C:\usr\sap\LOD\DVEBMGS01\exe\dboraslib.dll' ...

B  Library 'C:\usr\sap\LOD\DVEBMGS01\exe\dboraslib.dll' loaded

B  Version of 'C:\usr\sap\LOD\DVEBMGS01\exe\dboraslib.dll' is "721.02", patchlevel (0.331)

C  Register application info.

C  Oracle client version: 11.2.0.4.0, (dbsl 721 231014, UNICODE[2])

C  Detailed Oracle client (patch) info not available.

C 

C Tue Mar 24 23:05:17 2015

C  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

C  Logon as OPS$-user to get SAPSR3's password

C  Connecting as /@LOD on connection 0 (nls 0) ... (dbsl 721 231014, UNICODE[2])

C  OCIServerAttach(con=0, svc=03873D60) srv=038746B0 attached to 'LOD'

C  OCISessionBegin(con=0, svc=03873D60, srv=038746B0='LOD'): start session of usr=03883970='/', rc=0

C  Now '/@LOD' is connected: con=0, nls=0, session=161, time='2015-03-24 23:05:17'

C     OCIStmtExecute() failed with -1=OCI_ERROR

C     SQL error 942:

C  *** ERROR => ORA-942 when accessing table SAPUSER

[dbsloci.c    16930]

C  Disconnecting con=0

C  OCISessionEnd(con=0, svc=03873D60, srv=038746B0='LOD'): Close session usr=03883970, rc=0

C  Info: 99=DBSL_ERR_DB, oerr=942, try to connect with default password.

C  Connecting as SAPSR3/<pwd>@LOD on connection 0 (nls 0) ... (dbsl 721 231014, UNICODE[2])

C 

C Tue Mar 24 23:06:36 2015

C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

C     ORA-01017: invalid username/password; logon denied                                                                           

C  OCISessionBegin(con=0, svc=03873D60, srv=038746B0='LOD'): start session of usr=03883970='SAPSR3', rc=1017

C  OCIHandleFree(con=0, svc=03873D60): Free session hdl usr=03883970

C  OCIServerDetach(stale(2) con=0, svc=03873D60): Server srv=038746B0='LOD' detached

C  rc=1017 -> Trying to reattach to server 'LOD'

C  OCIServerAttach(con=0, svc=03873D60) srv=038746B0 attached to 'LOD'

C 

C Tue Mar 24 23:07:36 2015

C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 3135:

C     ORA-03135: connection lost contact

C  Process ID: 0

C  Session ID: 0 Serial number: 0                                              

C  OCISessionBegin(con=0, svc=03873D60, srv=038746B0='LOD'): start session of usr=03883970='SAPSR3', rc=3135

C  OCIHandleFree(con=0, svc=03873D60): Free session hdl usr=03883970

C  OCIHandleFree(con=0): Service handle svc=03873D60 freed.

C  *** ERROR => CONNECT failed with SQL error '3135'

[dbsloci.c    15943]

B  ***LOG BV3=> severe db error 3135; work process is stopped [dbsh         1241]

B  ***LOG BY2=> sql error 3135   performing CON [dblink       544]

B  ***LOG BY0=> ORA-03135: connection lost contact

Process ID: 0

Session ID: 0 Serial number: 0 [dblink       544]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1525]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   11560]

...

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP

M  ThCallHooks: hook >ThrBtcCallLgCl< o.k.

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M  *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c   867]

M  *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c  303]

M  ThIErrHandle: entering ThSetStatError

M  ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M  Entering ThReadDetachMode

M  call ThrShutDown (1)...

M  ***LOG Q02=> wp_halt, WPStop (Workp. 0 3064) [dpnttool.c   339]

Can you help me please? How can I solve this problem?

Thank you,

samid raif

[Former Member]

Hi Armenio,

As suggested by Gaurav & Regan, Have you checked the SAP USER table and oss note  1576837 - ORA-01017: invalid username/password;.

As you have mentioned its a distributed environment and CI runs on windows and DB on linux correct me if i am wrong you can follow below process if you have not migrated to SSFS.

for OPS$ with SAPUSER Table.

'create user OPS$<SAPSID>ADM default tablespace psapuser1d
temporary tablespace psaptemp identified externally;'

'grant connect, resource to OPS$<SAPSID>ADM;'

'connect /'

'create table SAPUSER
( USERID VARCHAR2(256), PASSWD VARCHAR2 (256));'

'insert into SAPUSER values ('SAPR3', '<password>');'

'connect internal'

'alter user sapr3 identified by <password>;'

How to create user SAPSERVICE<SAPSID>

1. Log on as user <SAPSID>ADM to the host on which the R/3 database for the SAP System is running.

2. Start sqldba72 (or svrmgr23, svrmgr30) and log on to the database with 'connect internal'.

3. Execute the following commands in the database one after the other: Replace <SAPSID> with the corresponding SAP system ID for your system:

          
'create user OPS$SAPSERVICE<SAPSID> default tablespace psapuser1d
temporary tablespace psaptemp identified externally;'

'grant connect, resource to OPS$SAPSERVICE<SAPSID>;'

'create public synonym sapuser for OPS$<SAPSID>ADM.SAPUSER;'

'connect /'

'grant select on sapuser to OPS$SAPSERVICE<SAPSID>;'

Do keep in mind to create public synonyms and SAP Service user too.

Also in mixed enviorments below are the steps

1. Log on to the database server as user <SID>adm.

2. Start sqlplus:

    sqlplus /nolog

    sqlplus> connect / as sysdba

• If the database server runs on a Unix computer:
      sqlplus> create user "OPS$<DOMAIN>\SAPSERVICE<SID>" identified
              externally;
      sqlplus> grant connect, resource to
              "OPS$<DOMAIN>\SAPSERVICE<SID>";
      sqlplus> connect /
      sqlplus> grant select, insert, update on sapuser to
              "OPS$<DOMAIN>\SAPSERVICE<SID>"
      sqlplus> exit
• If the database server runs on a Windows computer:
      sqlplus> create user OPS$<SID>ADM identified externally;
      sqlplus> grant connect, resource to OPS$<SID>ADM;
      sqlplus> connect /
      sqlplus> grant select, insert, update on sapuser to
               OPS$<SID>ADM;

You can further refer to OSS note  50088 - Creating OPS$ users on Windows NT/Oracle

Also You can check the SSFS settings if you had migrated then as per the below scn document:-

Let us know if this helped and your status of the issue.

Regards,

Ram

[Johan_sapbasis]

HI,

Check your environment variables set for the user that you used to launch the sapinst/swpm process.

i.e. oracle_home .e.t.c.

J

[former_member206857]

http://scn.sap.com/thread/3447030

My issues with a similar problem.

[former_member182657]

Hi Samid,

Hope you followed previous recommended SAP KBA  1576837 - ORA-01017: invalid username/password;

Regards,

[Former Member]

Hi,

Check this note. Easy way to fix OPS$ and SAPUSER table issue is to execute the oradbusr. sql. It will recreate OPS$ user and SAPUSER table. Also it provides necessary grants.

361641 - Creating OPS$ users on UNIX

After executing this sql script, try changing the SAPSR3 password once from brtools and then try R3trans -d.

Good luck,

Karthik

[Former Member]

Hello Karthik,

As I wrote above, the problem is not that! I have all the OPS$ users in the oracle database, as you can see bellow and none of them is locked:

Please read my previous message regarding the SAPUSER table that seems to me that it doesn't exist in my oracle database!

Can you help me please to understand which values I need to put in <sapowner> and <password> fields in the following statement (sap note 400241):

CREATE TABLE "OPS$<sid>ADM".SAPUSER
  (USERID VARCHAR2(256), PASSWD VARCHAR2(256));
INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>', '<password>');

Best regards,

samid raif

[Former Member]

Hi samid raif,

Generally SAPUSER table should be there already. As it was missing, I recommended

oradbusr.sql script as everything will get recreated properly.

For your direct query, <sapowner> is schema user, in your case it is SAPSR3.

<password> use default password 'sap'.

Try R3trans -d after creating the SAPUSER table, it will try with default password 'sap' if initial attempt fails.

If still issue exists, try changing the password from brconnect/brtools.

brconnect -u system/<syst_pwd> -f chpass -o SAPSR3 -p <new_sap_pwd>

Best Regards,

Karthik

[Reagan]

If the table SAPUSER is not present at the DB level then create it. The owner of the table should be OPS$<sid>ADM. In your case it should be OPS$LODADM.

After creating the table change the password of the schema user using BR*Tools.

brconnect -u / -f chpass -o SAPSR3 -p pass

Also what are the values of the parameters os_authent_prefix and remote_os_authent?

[srinivasan_vinayagam]

Hi Armenio,

You can check in Database level SAPSR3 is whether locked or expired password.

Regards,

V Srinivasan

[Former Member]

Hello Armenio,

For this issue go for

1504627:Database error: ORA-01017: invalid username / password; logon denied

Regards,

Himanshu

[Former Member]

Hi,

Also check whether the schema name is same as like in source system. As per the error logs password of schema user SAPSR3 is not correct in SAPUSER table.

Try changing the password of SAPSR3 from brtools and try R3trans -d for connectivity check.

If still you face the error, run R3trans -d with increased trace level and paste the error logs.

Best Regards,

Karthik

[Former Member]

Hi,

Make sure that the firewall is disabled on both the machines. Do check the following KBA's.

1902517 - ORA-03135 general trouble shooting steps

2064591 - work processes reconnect to Oracle database with error ORA-03135

regards,

pavan

[former_member182657]

Hi Samid,

For the issue you could follow SAP KBA   1576837 - ORA-01017: invalid username/password;

& can refer scenario C resolution.

Hope this would resolve your issue.

Good luck !!

[JamesZ]

Hi samid,

We can see error ORA-942 in the trace, so please refer to SAP note 400241 for the special section.
If it does not work, then you should go through the whole note. I am confident the note will solve this
problem.

Best regards,
James

[Former Member]

Hello

ERROR => ORA-942 when accessing table SAPUSER

I believe you´re right because if fact when I search for the table SAPUSER (as it describe in sap note 400241 - Problems with ops$ or sapr3 connect to Oracle):

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

no rows selected

So I believe there is no SAPUSER table. It´s very weird because I installed the database instance (with the Oracle database 11.2.0.4 installation) and it didn´t show me any errors during that activities! Strange...

Therefore I need to create the SAPUSER table like it is describe in the same sap note (400241):

CREATE TABLE "OPS$<sid>ADM".SAPUSER
  (USERID VARCHAR2(256), PASSWD VARCHAR2(256));
INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>', '<password>');

The problem is... what I must put in <sapowner> and <password> fields? I don´t understand...

Can you help me please?

Thank you,

samid raif

[Former Member]

Hi Armenio

The log has the error - ORA-01017: Invalid username/Password; logon denied

App is unable to connect to the DB

you can change the SAP<SID> password using brtools

You can find various SCN posts on this issue

check this link

http://scn.sap.com/thread/1263676

Cheers

Arun

[Former Member]

Hello Arun Nair,

This error: "ORA-01017: Invalid username/Password; logon denied" is very strange because I don´t have the SAPSR3 account locked in oracle database as you can see bellow, that is OPEN:

I ran the R3trans -x and this is the output in trans.log file:

4 ETW000 r3trans version 6.24 (release 721 - 14.10.14 - 20:14:08).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 25.03.2015 - 10:27:25

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]  Wed Mar 25 10:27:26 2015                                                3601  0.003601

4 ETW000  [     dev trc,00000]  db_con_init called                                                        27  0.003628

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        91  0.003719

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  19  0.003738

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

4 ETW000  [dbcon.c     ,00000]  *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

4 ETW000                                                                                                 398  0.004145

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

Any tip?

Thank you,

samid raif

[former_member186845]

Hello Arménio,

According to the R3trans -x output, the database issue is happening due to the following issue:

** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library
no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

Please make sure the parameter "dbms/type=ORA" is properly set in the central instance profile.

Additionally, set environment variable "dbms_type=ORA" to <sid>adm user.

Also, in the R3trans output I noticed you are using SAP Kernel 7.21. Please, just confirm you are using SAP Kernel 7.21 EXT. If not, please apply it to your system. As described in PAM page, the combination SRM 7.0 / Windows 2012 / Oracle 11.2 is only supported with SAP Kernel 7.21 EXT (UC).

After checking the points above, run R3trans -d command. Is the output code still different than 0000? If so, please provide the output for my reference. However, if the output is 0000, then run the SWPM tool once again.

In case of starting up issue by running the SWPM, please check again issue in the log files from instance work directory.

Thanks in advance.

Regards,

Henrique Girardi

SAP Active Global Support

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

#2081285 - How to enter good search terms to an SAP search?

https://service.sap.com/sap/support/notes/2081285

SWPM Troubleshooting documents:

http://scn.sap.com/docs/DOC-62646

[Former Member]

Hello Armenio

There are a couple of things you should test

1: Check if you can login with the password for SAPSR3 on the DB

2: if you are sure of the password I recommend to change the password of SAPSR3 using BRTOOLS and then run R3trans -d

3: As mentioned in the posts - ensure your environment variables are setup correctly

Let me know how you go

Cheers,

Arun