Solved: Login problem after SAP system copy

Dear All,

I tried to resotore my SAP database on another machine for testing purpose. My test machine was low end ie SUN v440 as compared to production . I followed these steps

I Installed SAP ERP 4.7 complete with default database installation ..

I named DB SID and SAPSID same as my production

then I restored production databasefiles and backup control file on exact locations

and successfully resotred database and easily opened it from SQLPLUS without any error.

I successfully started SAP startsap without any error too.

now problem is when i tried to login into SAP form my user on SAP it gives me licnese error which is rightly so, but when I tried to login from 000 SAP* it is giving me error on SAP login screen's botton bar as below

X>>>>>>>> DB-Error - 0

I checked R3trans -d it worked well

init ora also looking good.

IS that due to difference of kernel or oracle patches in production SAP and test SAP I installed. Production SAP was updated to Kernel 640 and to Oracle 9.2.0.5 with higher SAP support packages

test machine has 9.2.0.2 i think and 620 kernel

Please tell me what to do

Best Regards

Waqas

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Check the files

dev_ms

dev_disp

dev_w0

for errors and post them here.

Kernel 6.20 is out of maintenance, upgrade to Kernel 6.40.

Markus

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

dear Markus,

I copied sapmnt/exe folder from a similar machine having SAP and 6.40 kernel to this test machine, now i m not able to do startsap giving me error as below

Should I restore old kernel or should we investigate this error or I upgrade kernel in original way.

==========================================================

SAPAPP:lt1adm 1% R3trans -d

This is R3trans version 6.13 (release 640 - 20.04.05 - 14:00:00).

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

ra_tnsname = 'SD1'"

R3trans finished (0012).

SAPAPP:lt1adm 2% startsap

Checking SD1 Database

ABAP Database is not available via R3trans

Checking SD1 Database

Starting SAP-Collector Daemon

open logfile '/usr/sap/tmp/dev_coll.tmp' failed... use stderri

16:13:07 30.10.2007 ERROR: cannot open log file /usr/sap/tmp/dev_coll.tmp

16:13:07 30.10.2007 ERROR: Make sure directory /usr/sap/tmp exists or specify D

IR_PERF

16:13:07 30.10.2007 ERROR: in profile and run saposcol pf=<profile>

saposcol already running

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

Trying to start SD1 database ...

Log file: /home/lt1adm/startdb.log

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

DB startup failed

Have you checked your enviornment variables ?

Thanks

Prince Jose

actually in this test system I named DBSID SAPSID exaclty same as source machine

what special env variable u are talking abt..

As I told u I successfully installed SAP R3 enterprise first complete (ie with DB instance) then then worked purel on oracle and able to restore data and able to startup oracle successfully

The thing coming to my mind is on source there was kernel 640 and oracle 9.2.0.5

target is new fresh SAP 620 and oracle 9.2.0 something earlier than 9.2.0.4

Regards

Waqas

Markus,

I again reverted exe folder to original installed 620 kernel and again tried to logon.

now i am pasting errors from workprocesses.

=======================================

dev_ms

============================

[Thr 01] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 12944) [msxxserv_mt. 1533]

[Thr 01] SigISetDefaultAction : default handling for signal 18

[Thr 01] MsHttpPortInsert: set HTTP state to LISTEN

[Thr 01] *** I listen to port sapmsLT1 (3600) ***

[Thr 01] *** HTTP port 8100 state LISTEN ***

[Thr 01] CUSTOMER KEY: >L0314475341<

[Thr 01] Tue Oct 30 19:14:04 2007

[Thr 01] MsHttpReadUrl: H-1 url = /sap/public/icf_info/logon_groups (403 Forbidd

en)

[Thr 01] MsHttpReadUrl: H-1 url = /sap/public/icf_info/urlprefix (403 Forbidden)

=======================================================

dev_w0

==============

SAPAPP:lt1adm 12% tail -50 dev_w0

N ===...SSF trace level is 0 .

N ===...SSF library is /usr/sap/LT1/SYS/exe/run/libsapsecu.so .

N ===...SSF hash algorithm is SHA1 .

N ===...SSF symmetric encryption algorithm is DES-CBC .

N ===...sucessfully completed.

N =================================================

N MskiInitLogonTicketCacheHandle: Logon Ticket cache pointer retrieved from sha

red memory.

N MskiInitLogonTicketCacheHandle: Workprocess runs with Logon Ticket cache.

M MBUF info for hooks: MS component UP

M ThSetEnqName: set enqname by server list

M ThISetEnqname: enq name = >SAPAPP_LT1_00 <

E *************** EnqId_EN_ActionAtMsUpHook ***************

E Hook on upcoming Ms (with EnqSrv), get auth EnqId and check it locally

E Enqueue Info: enque/disable_replication = 2

E Enqueue Info: replication disabled

E *************** ObjShMem_CheckAuthoritativeEnqId ***************

E Checking authoritative EnqId from EnqSrv into ObjShMem

E ObjShMem_CheckAuthoritativeEnqId: ObjShMem ...

E EnqId.EnqTabCreaTime = -999

E EnqId.RandomNumber = -999

E ReqOrd.TimeInSecs = -999

E ReqOrd.ReqNumberThisSec = -999

E ObjShMem_CheckAuthoritativeEnqId: ObjShMem ...

E EnqId.EnqTabCreaTime = -999

E EnqId.RandomNumber = -999

E ReqOrd.TimeInSecs = -999

E ReqOrd.ReqNumberThisSec = -999

E ObjShMem_CheckAuthoritativeEnqId: EnqId is initial in ShMem

E ObjShMem_CheckAuthoritativeEnqId: Overwrite incoming auth EnqId, continue

E EnqId inscribed into initial ObjShMem: (ObjShMem_CheckAuthoritativeEnqId)

E ~~-SHMEM~~--

E EnqId: EnqTabCreaTime/RandomNumber = 30.10.2007 19:14:02 1193789

642 / 12950

E ReqOrd at Srv: TimeInSecs/ReqNumberThisSec = 30.10.2007 19:14:02 1193789

642 / 2

E ReqOrd at Cli: TimeInSecs/ReqNumberThisSec = 30.10.2007 19:14:02 1193789

642 / 1

E Status: STATUS_OK

E -

M ThActivateServer: state = STARTING

M Tue Oct 30 19:14:03 2007

M ThReschedAfterCommit: th_force_sched_after_commit = 1

S server @>SSRV:SAPAPP_LT1_00@< appears or changes (state 1)

I Tue Oct 30 19:14:04 2007

I MPI<4>1#23 Peak buffer usage: 3 (@ 64 KB)

S Tue Oct 30 19:18:16 2007

S found spool memory service RSPO-ACTIONS at fffffffe655d9278

=======================================================

dev_disp

============================

SAPAPP:lt1adm 15% tail dev_disp

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 941]

DpMsgAdmin: Set patchno for this platform to 1027

Release check o.K.

If you change a kernel, you need to run the script "saproot.sh" in the kernel directory to set the s-uid bit for certain programs.

Get the newest 6.40 kernel, execute .

/saproot.sh <SID>

as user root in /usr/sap/<SID>/exe and start your instance.

Then check the logfiles again.

Markus

As you Ok i will do this mean while after copy exe folder from a similar SAP machine I got some error of permissions and now i m getting

===========================================

SAPAPP:lt1adm 5% startsap

Checking SD1 Database

ABAP Database is not available via R3trans

Checking SD1 Database

Starting SAP-Collector Daemon

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

This is Saposcol Version COLL 20.88 640 - V3.70 64Bit
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 16574) is already running .....

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

saposcol already running

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

Trying to start SD1 database ...

Log file: /home/lt1adm/startdb.log

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

DB startup failed

============================

R3trans -d also giving error.

error 12

Regards

Waqas

SAPAPP:lt1adm 1% R3trans -d

This is R3trans version 6.13 (release 640 - 20.04.05 - 14:00:00).

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

ra_tnsname = 'SD1'"

R3trans finished (0012).

provide file trans.log

perhaps you forgot to start the Oracle listener or it is not configured properly.

listnener is running fine

here is trans.log

==============================================

SAPAPP:lt1adm 3% more trans.log

4 ETW000 R3trans version 6.13 (release 640 - 20.04.05 - 14:00:00).

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

4 ETW000

4 ETW000 date&time : 30.10.2007 - 20:02:27

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] Tue Oct 30 20:02:27 2007

239 0.000239

4 ETW000 [dev trc ,00000] db_con_init called

27 0.000266

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

169 0.000435

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

raslib.so' ...

4 ETW000

69 0.000504

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

oraslib.so), hdl 0

4 ETW000

44957 0.045461

4 ETW000 [dev trc ,00000] Library '/usr/sap/LT1/SYS/exe/run/dboraslib.so'

loaded

4 ETW000

135 0.045596

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

p/LT1/SYS/exe/run/dboraslib.so

4 ETW000

60 0.045656

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

o' is "640.00", patchlevel (0.55)

4 ETW000

347 0.046003

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

ap/LT1/SYS/exe/run/dboraslib.so

4 ETW000

40 0.046043

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

sap/LT1/SYS/exe/run/dboraslib.so

4 ETW000

82 0.046125

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

49 0.046174

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

67 0.046241

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

58 0.046299

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

for reuse:

4 ETW000

33 0.046332

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCON

NECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ

= NO

4 ETW000

33 0.046365

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/SD1/920_64 from environm

ent

4 ETW000

879 0.047244

4 ETW000 [dev trc ,00000] -->oci_init1

69 0.047313

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0)

35 0.047348

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII

4687 0.052035

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPLT1's password

47 0.052082

4 ETW000 [dev trc ,00000] Connecting as /@SD1 on connection 0 (nls_hdl 0)

...

4 ETW000

33 0.052115

4 ETW000 [dev trc ,00000] Nls Characterset Natcharacterset

C EnvHp ErrHp ErrHpBatch

4 ETW000

41 0.052156

4 ETW000 [dev trc ,00000] 0

1 100effb70 100f07378 100f06d88

4 ETW000

31 0.052187

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0

105 0.052292

4 ETW000 [dev trc ,00000] Allocating server context handle

30 0.052322

4 ETW000 [dev trc ,00000] Attaching to DB Server SD1 (con_hdl=0,svchp=100f

06cb8,svrhp=100f079c8)

4 ETW000

143 0.052465

4 ETW000 [dev trc ,00000] Assigning server context 100f079c8 to service co

ntext 100f06cb8

4 ETW000

50759 0.103224

4 ETW000 [dev trc ,00000] Allocating user session handle

83 0.103307

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=100f06cb8

,srvhp=100f079c8,usrhp=100f113a8)

4 ETW000

49 0.103356

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

rc = 12705

4 ETW000

5469 0.108825

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

4 ETW000

38 0.108863

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=100f06

cb8,srvhp=100f079c8)

4 ETW000

30 0.108893

4 ETW000 [dev trc ,00000] Deallocating server context handle 100f079c8

655 0.109548

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

4 ETW000

76 0.109624

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

54 0.109678

4 ETW000 [dev trc ,00000] Connecting as SAPLT1/<pwd>@SD1 on connection 0 (

nls_hdl 0) ...

4 ETW000

34 0.109712

4 ETW000 [dev trc ,00000] Nls Characterset Natcharacterset

C EnvHp ErrHp ErrHpBatch

4 ETW000

66 0.109778

4 ETW000 [dev trc ,00000] 0

1 100effb70 100f07378 100f06d88

4 ETW000

32 0.109810

4 ETW000 [dev trc ,00000] Allocating server context handle

19 0.109829

4 ETW000 [dev trc ,00000] Attaching to DB Server SD1 (con_hdl=0,svchp=100f

06cb8,svrhp=100f079c8)

4 ETW000

50 0.109879

4 ETW000 [dev trc ,00000] Assigning server context 100f079c8 to service co

ntext 100f06cb8

4 ETW000

42342 0.152221

4 ETW000 [dev trc ,00000] Assigning username to user session 100f113a8

69 0.152290

4 ETW000 [dev trc ,00000] Assigning password to user session 100f113a8

51 0.152341

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=100f06cb8

,srvhp=100f079c8,usrhp=100f113a8)

4 ETW000

36 0.152377

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

rc = 12705

4 ETW000

12800 0.165177

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

4 ETW000

33 0.165210

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=100f06

cb8,srvhp=100f079c8)

4 ETW000

29 0.165239

4 ETW000 [dev trc ,00000] Deallocating server context handle 100f079c8

360 0.165599

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

4 ETW000

122 0.165721

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

ink#2 @ 419]

4 ETW000

208 0.165929

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12705: invalid or unknown NLS pa

rameter value specified [dblink#2 @ 419]

4 ETW000

33 0.165962

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

ra_tnsname = 'SD1'"

=======================================================

getting this while running script

./saproot.sh LT1 SD1

./saproot.sh: whoami: not found

./saproot.sh: test: argument expected

where to find whoami

does it mean i have to upgrade oracle to higher patch

as R3trans -d was workign fine with old SAP kernel, now kernel is 640 and oralce is old.

> # ./saproot.sh LT1 SD1

> ./saproot.sh: whoami: not found

> ./saproot.sh: test: argument expected

execute

bash saproot.sh LT1

(do not use two instance names, only the actual instance)

"whoami" is under /usr/ucb but you can ignore that error, the system just checks in that script, whether you're root or not.

Markus

bash saproot.sh LT1 SD1

saproot.sh: whoami: command not found

saproot.sh: [: !=: unary operator expected

Preparing /usr/sap/LT1/SYS/exe/run/brbackup ...

Preparing /usr/sap/LT1/SYS/exe/run/brarchive ...

Preparing /usr/sap/LT1/SYS/exe/run/brconnect ...

Preparing /usr/sap/LT1/SYS/exe/run/brtools ...

Preparing saposcol ...

Preparing icmbnd ...

done

SD1 is my DBSID

so it is important to give

R3trnas -d still giving error

SAPAPP:lt1adm 2% R3trans -d

This is R3trans version 6.13 (release 640 - 20.04.05 - 14:00:00).

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

ra_tnsname = 'SD1'"

R3trans finished (0012).

Execute saproot.sh will put the right permissions/users/s-uid-bits on the executables mentioned.

The fact that R3trans can't connect has nothing to do with that.

What do you see in trans.log?

Markus

Hi Wagas,

At your trans.log appears the error:

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12705: invalid or unknown NLS parameter value specified [dblink#2 @ 419]

You can find a solution at Note 592657 (probably at point 10 "UNIX, Oracle 9.2 or higher: Oracle instances with a different patch set on a machine", because of your Oracle patch versions changes).

Best Regards,

JC Llanes.

now should I copy 920_64 folder of a similar machine having 0racle 9.2.0.5 to my target machine.. I have already taken backup of 920_64 folder in my target (test ) machine

Juan,

to solve this error I also read

SAP Note No. 407314

I found that "

======================

===========================================

Operating System: SOLARIS/SPARC

==============================================

R/3 Kernel-Version

DB-Version OS-Version Restrictions

SAP KERNEL 6.10 64-BIT:

ORACLE 8.1.7 64-BIT SOLARIS/SPARC 8 1,2

SAP KERNEL 6.20 64-BIT:

ORACLE 8.1.7 64-BIT SOLARIS/SPARC 8 1,2,3

ORACLE 8.1.7 64-BIT SOLARIS/SPARC 9 1,2,3,4

ORACLE 9.2 64-BIT SOLARIS/SPARC 8 1,5,6,7

ORACLE 9.2 64-BIT SOLARIS/SPARC 9 1,4,5,6,7

SAP KERNEL 6.20 64-BIT UNICODE:

ORACLE 9.2 64-BIT SOLARIS/SPARC 8 1,5,6,7

ORACLE 9.2 64-BIT SOLARIS/SPARC 9 1,4,5,6,7

SAP KERNEL 6.40 64-BIT:

ORACLE 9.2 64-BIT SOLARIS/SPARC 8 1,5,6,7,8

ORACLE 9.2 64-BIT SOLARIS/SPARC 9 1,4,5,6,7

SAP KERNEL 6.40 64-BIT UNICODE:

ORACLE 9.2 64-BIT SOLARIS/SPARC 8 1,5,6,7

ORACLE 9.2 64-BIT SOLARIS/SPARC 9 1,4,5,6,7

1. lt, et and lv locales: check note 39739

2. Oracle 8.1.7 Enterprise Edition only

3. Only certified for BW 30B, EBP 3.x, CRM 3.x, WEB AS 6.20 Stand alone

4. See note 550585 for a list of mandatory Solaris 9 patches

5. At least Oracle Patchset 9.2.0.2 required. For WEB AS 6.40 based

components at least Patchset 9.2.0.4 required. See OSS note 540021.

6. Only relevant for SAP releases 31I - WEB 6.20 based components: See

note 557255 or 580772 for installation instructions depending on

kernel/SAP Web AS release.

7. Oracle 9.2 Enterprise Edition only

8. Required Sun OS patches: 108434, 108435

================================================

My be i should upgrade my oracle at 9.2.0.4

I have similar machines having 9.2.0.5 can I copy some folders from there to my test machine. also i have clearly seen environment variable difference

on machine having 640 kernel and 9205

ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

NLS_LANG=AMERICAN_AMERICA.WE8DEC

on my test machine having kernel 640 and oracle 9.2

ORA_NLS33=/oracle/client/81x_64/ocommon/nls/admin/data

NLS_LANG=AMERICAN_AMERICA.WE8DEC

If Oracle server on a machine has already patched upto 9205 can I transfer folders to taget machine having oracle 9201 to upgrade it to to 9205 or it is must to properly install 9205 on target machine

Please, please, do NOT do it.

Copying software from a machine to another one is not supported.

If your current version is 9201, then

- you are in a very buggy release ( and out of support )

- there are known problems of NLS compatibility between this version and later ones.

Perhaps, the problem you are getting is that the oracle client is being read from /oracle/client/92x_64 and the NLS from $ORACLE_HOME being both not compatible.

The first thing you should do is to install a newer paych set following the correct procedure

As oracle has ended its customer care support for 9i, you should install the latest patchset 9.2.0.8

You should think on installing also the latest oracle client patch and review the environment variables.

Answers (1)

any clue guys

is that due to patch indifference.

I am getting blue login screen of SAP but getting DB error. although Database has been started successfully, I have also solved my license problem.

Please suggest.

Best Regards

Waqas

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Ask a Question

Top Q&A Solution Author

User

Count

Login problem after SAP system copy

Accepted Solutions (1)

Accepted Solutions (1)

Answers (1)

Answers (1)

Re: SAP Build Apps - How to do Data Refresh for Ma...

Re: DRC e-Cockpit Add a New Button

Re: BTP Build Apps- Error while integration of BTP...

SAP MAXDB : Content Server Administration - Reposi...

Re: "Failed to update setup engine executables. Pr...