When trying to start sap with startsap command

[Former Member]

We are doing new installation.After patching ORACLE 10 G ,the problem is coming .

Oracle is running fine but when we are trying to start SAP with STARTSAP getting following error.

-

---

sd2n1v5:yc5adm> startsap

Checking YC5 Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

13:49:11 23.09.2007 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.89 700 - v2.02 for HP-UX - 24.1.2006

• 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 2777) is already running .....

************************************************************************

saposcol already running

Running /usr/sap/YC5/SYS/exe/run/startdb

Trying to start YC5 database ...

Log file: /home/yc5adm/startdb.log

/usr/sap/YC5/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

sd2n1v5:yc5adm>

-

---

trans.logf file.

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x6000000001071cb8,srvhp=0x6000000001073fc8,usrhp=0x6000000001061e28)

4 ETW000 48 0.404349

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

4 ETW000 3135 0.407484

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

4 ETW000 45 0.407529

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x6000000001071cb8,srvhp=0x6000000001073fc8)

4 ETW000 47 0.407576

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x6000000001073fc8

4 ETW000 745 0.408321

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

4 ETW000 151 0.408472

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

4 ETW000 452 0.408924

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-28000: the account is locked [dblink#3 @ 431]

4 ETW000 46 0.408970

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

[Former Member · Accepted solution]

below trans.log error ,after I did what you told in the earlier reply

-

---

ERROR => ORA-942 when accessing table SAPUSER

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

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

no rows selected

[fidel_vales · Accepted solution]

Hi,

Not sure what do you mean.

I assume you still get the errors: ORA-942 and ORA-01017.

Then you have not read the note properly.

The ORA-942 menas that the SAPUSER table <b>DOES NOT EXIST</b>

This is confirmed by yourself:

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

no rows selected</i>

Then you have not read properly the note 400241

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

<b><i>ORA-00942: Table or view does not exist

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-942 when accessing table SAPUSER

Message ORA-00942 is issued when table SAPUSER does not exist. Proceed

as follows:

o Create the SAPUSER table as <sid>adm using the following command:

CREATE TABLE "OPS$<sid>ADM".SAPUSER

(USERID VARCHAR2(256), PASSWD VARCHAR2(256));

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

'<password>');

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

section "General checks".

</i></b>

The note I told you to follow indicates to create the table SAPUSER, you said that you have followed the note but you tell me that the table is not create.

I'm sorry but I do not understand.

Lets try to make it easier:

1) change the password for the user SAPSR3 to the default one ( sap )

you will solve the second point and at least you can connect

2) create the ops$ user ( and SAPUSER table ). You have an explanation on the note 361641. The script is on the note 50088 ( this is also indicated on the note, just in case you miss it )

3) ( also indicated on the note 361641 ) now you can change the password for the user SAPSR3. This can <b>ONLY</b> be done IF the point 2 is properly done.

The note 400241 has a detailed explanation on how to perform individual checks, but it seems it is too complicated.

[Former Member · Accepted solution]

Can you login on the database with SAP DB User /pw?

sqlplus /nolog

connect sap<sid>/pw ( or sapr3/pw)

If not, you should change the password for the SAP Database user with BR*Tools.

e.g. like that

brconnect -u system/pw -f chpass -o sap<SID> (or SAP DB User. e.g SAPR3) -p <new password)

and try again.

Which OPS$ Users do you have? If you don't OPS$ Users, you should create them.

select username from dba_users where username like '%OPS%'

You can create SAPUSER Table according to the SAP Note.

400241 - Problems with ops$ or sapr3 connect to Oracle

On UNIX you get the following result, if the table SAPUSER exists.

SQL> select table_name, owner from dba_tables where table_name like '%SAPUSER%';

TABLE_NAME OWNER

-

---

-

---

SAPUSER OPS$<SID>ADM

Best regards>

[Former Member]

Thanks a lot.

I only change SAPSR3 password ,remaining things will do one by one.

I have some other problem how I will I put that ,in this message or new one.If it is a new message please pick up .

Thanks once again.

[Former Member]

open please a new message. It is better.

Best regards

Baran

[Former Member]

I am trying right now and update ,what is the result.

[Former Member]

Hello,

you should set to unlimited, otherwise you will have often the same problem:

SELECT LIMIT FROM DBA_PROFILES

WHERE PROFILE = 'DEFAULT' AND RESOURCE_NAME = 'FAILED_LOGIN_ATTEMPTS'

and you set it to unlimited.

ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED

[Former Member]

see also please the SAP Note:

951167 - ORA-28000: the account is locked

best regards

[Former Member]

You are right the user is SAPSR3 .I have unlocak the user and after that I execute R3trans -k and got the following information.

-

---

sd2n1v5:yc5adm> R3trans -x

This is R3trans version 6.13 (release 700 - 20.02.06 - 16:15:00).

unicode enabled version

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

R3trans finished (0012).

-

---

trans.log file error.

-

---

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

4 ETW000 1586 0.416081

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

4 ETW000 1736 0.417817

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 133 0.417950

4 ETW000 [dev trc ,00000] Rolling back transaction ... 66 0.418016

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x6000000001071cb8,usrhp=0x6000000001061e28)

4 ETW000 216 0.418232

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

4 ETW000 [dev trc ,00000] Try to connect with default password 34 0.418859

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

4 ETW000 47 0.418906

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

4 ETW000 49 0.418955

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x6000000001059ce0 0x6000000001061610 0x6000000001071d88

4 ETW000 49 0.419004

4 ETW000 [dev trc ,00000] Assigning username to user session 0x6000000001061e28

4 ETW000 43 0.419047

4 ETW000 [dev trc ,00000] Assigning password to user session 0x6000000001061e28

4 ETW000 53 0.419100

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x6000000001071cb8,srvhp=0x6000000001073fc8,usrhp=0x6000000001061e28)

4 ETW000 48 0.419148

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

4 ETW000 5456 0.424604

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

4 ETW000 46 0.424650

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

4 ETW000 439 0.425089

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

4 ETW000 45 0.425134

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

[fidel_vales]

Hi,

I'm pretty sure this is answered on the forum a couple of times ( or more )

You have changed the default password for the user SAPSR3 at database level ( ORA-01017 ) without enabling first the OPS$ mechanism ( ORA-942 when accessing table SAPUSER )

so, I did a little search on the SAP Notes ( it only takes a couple of minutes ) and Iget only 4 results back:

662644 Composite SAP Note: ORA-00942

400241 Problems with ops$ or sapr3 connect to Oracle

623242 ORA-1017 opening a secondary link

700548 FAQ: Oracle authorizations

Except the 3rd one, the other 3 are relevant for your exact problem.

The soultion is:

1 - Use the search functionality in SAP Service Marketplace

2 - Use the search functionality in SAP developer Network

3 - Read the mentioned notes and apply the solution indicated on the note 400241

[Former Member]

When try to execute ,getting following error

SQL> alter user sapyc5 account unlock ;

alter user sapyc5 account unlock

*

ERROR at line 1:

ORA-01918: user 'SAPYC5' does not exist

[fidel_vales]

Then your user is not <b>sapyc5</b>

on the trans.log it is indicated the user SAP tries to connect to.

It is also on the environment variable dbs_ora_schema

check that user

[fidel_vales]

hi,

I think the error is clear:<br>

<br>

<i><b>ORA-28000: the account is locked</b></i> <img src="http://i66.photobucket.com/albums/h276/DianneOnly/blink.gif" alt="Blinking" /><br>

<br>

Check the account status ( should be SAP<DBSID> ) an unlock it.

<br>

Afterwards, run R3trans -x and check the trans.log.

You should not get the same error but I think you will get an ora-1017.<br>

I think you have changed the default password for SAP<DBSID> using sqlplus instead of BRCONNECT