R3trans not connection to oracle database.

[Former Member]

Hi,

Hi,

I have been trying to activate our DR server and while starting sap R3trans is not able to connect to the database.

R3trans -d

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

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'BPS'"

R3trans finished (0012).

Please find below the content of the trans.log file which has been generated by

executing R3trans -x command.

_______________________________________________

4 ETW000 R3trans version 6.13 (release 700 - 20.02.06 - 16:15:00).

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

4 ETW000

4 ETW000 date&time : 02.06.2008 - 19:58:39

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] Mon Jun 2 19:58:39 2008

71 0.000071

4 ETW000 [dev trc ,00000] db_con_init called

12 0.000083

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

36 0.000119

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/BPS/SYS/exe/run/dbo

raslib.o' ...

4 ETW000

36 0.000155

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/BPS/SYS/exe/run/db

oraslib.o), hdl 0

4 ETW000

5259 0.005414

4 ETW000 [dev trc ,00000] Library '/usr/sap/BPS/SYS/exe/run/dboraslib.o' l

oaded

4 ETW000

18 0.005432

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sa

p/BPS/SYS/exe/run/dboraslib.o

4 ETW000

21 0.005453

4 ETW000 [dev trc ,00000] Version of '/usr/sap/BPS/SYS/exe/run/dboraslib.o

' is "700.08", patchlevel (0.46)

4 ETW000

117 0.005570

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/s

ap/BPS/SYS/exe/run/dboraslib.o

4 ETW000

19 0.005589

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/

sap/BPS/SYS/exe/run/dboraslib.o

4 ETW000

47 0.005636

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

17 0.005653

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCO

NNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, oc

c = NO

4 ETW000

23 0.005676

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

29 0.005705

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

for reuse:

4 ETW000

18 0.005723

= NO

20 0.005743

un:/oracle/client/10x_64/instantclient from environment

262 0.006005

33 0.006038

1740 0.007778

22 0.007800

... (dbsl 700 240106)

19 0.007819

C EnvHp ErrHp ErrHpBatch

20 0.007839

1 110969200 110974898 110974148

19 0.007858

22 0.007880

14 0.007894

71bd8,svrhp=110976bb8)

56 0.007950

ntext 110971bd8

61048 0.068998

25 0.069023

,srvhp=110976bb8,usrhp=110970fe0)

30 0.069053

ext 110971bd8

10823 0.079876

756 0.080632

1030 0.081662

17 0.081679

19 0.081698

usrhp=110970fe0)

150 0.081848

470 0.082318

nls_hdl 0) ... (dbsl 700 240106)

23 0.082341

C EnvHp ErrHp ErrHpBatch

20 0.082361

1 110969200 110974898 110974148

19 0.082380

11 0.082391

14 0.082405

,srvhp=110976bb8,usrhp=110970fe0)

20 0.082425

3440 0.085865

rc = 28000

27 0.085892

17 0.085909

bd8,srvhp=110976bb8)

18 0.085927

145 0.086072

0'

24 0.086096

ink#3 @ 431]

54 0.086150

link#3 @ 431]

32 0.086182

ra_tnsname = 'BPS'"

-

---

Kindly suggest.

Thanks and Regards,

Amit Jana.

[Former Member]

Hi Syam,

unlock the user SAPSR3 as follows:

In SQL:

ALTER USER <username> ACCOUNT UNLOCK;

You can refer the below notes for details:

Note 951167 - ORA-28000: the account is locked

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

Thanks and Regards,

Amit Jana.

[Former Member]

thanx buddy this worked for me as well thanx a lot

when i executed R3trans -d the following is the error from trans.log........

ETW000 [dblink ,00431] ***LOG BY2=>sql error 28000 performing CON [dbl

ink#5 @ 431]

4 ETW000

211 0.142848

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

link#5 @ 431]

4 ETW000

60 0.142908

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'QLY'"

athomedev:qlyadm 12>

ALTER USER SAPR3 ACCOUNT UNLOCK;

[Syamkriz]

Hi Amit,

Could you throw light on how to unlock SAPSR3?

Thx

Syam

[Former Member]

Hi,

This problem is solved.

I was viewing the trans.log file with command "more trans.log" and the below lines were not shown. Later tried with "cat trans.log" and got the below logs which indicated the actual error.

-

---

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

0'

4 ETW000

25 0.086999

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 28000 performing CON [dbl

ink#5 @ 431]

4 ETW000

49 0.087048

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

link#5 @ 431]

4 ETW000

32 0.087080

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'BPS'"

-

---

The user SAPSR3 has been unlocked and that has solved the problem.

Thanks and Regards,

Amit Jana.

[Former Member]

Hi,

Yes, I am able to login to the datadbase using SQLplus. I am facing problem while starting sap. R3trans is not connecting to the database.

[Former Member]

Hi Friends,

Thanks for the suggestions. I have tried with 'cleanipc <sys number> remove' and also with new R3trans. But still the problem persists.

Any suggestion?

Thanks and Regards,

Amit Jana.

[Former Member]

what's the Database status now?

are u able to login to the database over the sqlplus?

[Syamkriz]

Hi Amit,

Congrats on detecting shared memory problem from dev_disp.

Try Sri's solution.

Use under AIX if necessarily the system command /usr/sbin/slibclean (as

roots) around old versions of the Shared LIBRARIES from main storage to

remove (see also note 162843).

Please award points.

Thx

Syam

[Syamkriz]

FYI -shared memory error in dev_disp/dev_w0 will look something like below

• ERROR => DpRqIQRemove: ShmDelete [dpxxqueu.c 431]

Thx

Syam

[Syamkriz]

Hi Guys,

If there is any problem with shared memory,it would throw error messages in dev_disp and dev_w*.Please check these log files and proceed with Sri's solution of cleanipc.

Since the file permissions and ownerships are okay,please try copying R3trans from production to DR system.Make sure that you use "binary" mode while doing FTP-This would avoid any damage to system file while copying.

Please award points if this helps you.

Thax

Syam

[Former Member]

Hi Amit,

It seems that some of the R/3 processes were left allocated in shared

memory.

Use the command 'cleanipc <sys number> remove' to remove the shared memory segment

Please refer notes below for more information:

17108 Shared memory still present, startup fails

00589 R/3 instance cannot be started

02033 Startup fails, sapstart.sem, startsap, sapstart

And Kill all the Sap Processes. Then shut down the oracle and listener.

Then start the listener and oracle and SAP.

Let me know in case of clarification.

Regards,

Sriram.S

[Former Member]

stop the listener and Shutdown oracle database.

kill all hanging processes, Use ipcrm u2013m or ipcrm u2013s to remove memory segments

start the listener then oracle database.

Then it should work. Otherwise check the permission of the oracle directory.