R3trans finished 0012 / cannot recover data file 1 file is in use or recove

[Former Member]

Hi

After a system Cloning from PRD to SandBox, SAP doesn't start any more :

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

DB startup failed

On the other hand, I can start the database manually, but SAP still doesn't connect to the DB.

The R3trans -d returns the following :

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SID/SYS/exe/run') or dbms_type ('ORA')"

R3trans finished (0012).

DIR_LIBRARY is correctly set.

I tought may be the databse is inconsistent, so I tried to recover the it.

The recover command doesn't work too :

ORA-00283: recovery session canceled due to errors

ORA-01124: cannot recover data file 1 - file is in use or recovery

ORA-01110: data file 1: '/oracle/SID/sapdata1/system_1/system.data1'

I shall be very grateful to you for any help !

Regards

[Former Member]

Thanks

Question has been answered.

[Former Member]

Hi the problem was resolved set the league in the foder of the oracle client "/oracle/client/10x_64"

the league created was.

Instantclient -> instantclient_10201 with the comand "ln -s".

This not help me Note 538849 - UNIX: DLENOACCESS when loading dboraslib and libclntsh.

This works for me.

Edited by: Miguel Jiménez on Oct 18, 2011 11:20 PM

[Former Member]

Hi,

Many thanks to all of you.

@Markus,

The cause of the problem was indeed the oracle client.

I created a symbolic link pointing to the client, strated the listener, and then started sap.

It works

Kind regards

[Former Member]

Hi,

DB was started with "startup"

trans.log

4 ETW000 R3trans version 6.14 (release 701 - 23.07.10 - 09:23:00).

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

4 ETW000

4 ETW000 date&time : 24.08.2011 - 14:15:28

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

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

4 ETW000 [dev trc ,00000] wed aug 24 14:15:28 2011 106 0.000106

4 ETW000 [dev trc ,00000] db_con_init called 11 0.000117

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

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SID/SYS/exe/run/dboraslib.o' ... 37 0.000184

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/SID/SYS/exe/run/dboraslib.o") FAILED

4 ETW000 " 0509-022 Cannot load module /usr/sap/SID/SYS/exe/run/dboraslib.o.

4 ETW000 0509-150 Dependent module libclntsh.a(shr.o) could not be loaded.

4 ETW000 0509-022 Cannot load module libclntsh.a(shr.o). 1360 0.001544

4 ETW000 0509-026 Syste" (errno=2,No such file or directory)

4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/SID/SYS/exe/run/dboraslib.o'

4 ETW000 69 0.001613

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SID/SYS/exe/run') or dbms_type ('ORA')"

Thanks

[markus_doehr2]

> 4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/SID/SYS/exe/run/dboraslib.o") FAILED

> 4 ETW000 " 0509-022 Cannot load module /usr/sap/SID/SYS/exe/run/dboraslib.o.

> 4 ETW000 0509-150 Dependent module libclntsh.a(shr.o) could not be loaded.

> 4 ETW000 0509-022 Cannot load module libclntsh.a(shr.o). 1360 0.001544

> 4 ETW000 0509-026 Syste" (errno=2,No such file or directory)

> 4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/SID/SYS/exe/run/dboraslib.o'

You have the Oracle instantclient installed for that system?

Markus

[Former Member]

Hi,

Please check the environment variables of <sid>adm.

Ensure DIR_LIBRARY path is correctly set. Also, could you please post the output of ldd dboraslib.o

Also, ensure you have correct kernel and libraries in place.

Check the version of the Oracle client being used.

Br,

Venky.

[markus_doehr2]

> The R3trans -d returns the following :

> 2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SID/SYS/exe/run') or dbms_type ('ORA')"

> R3trans finished (0012).

Please check the resulting "trans.log" logfile.

> The recover command doesn't work too :

So the database was started with "startup mount"?

Markus