Encountered problem with Homogenous system copy...

[Former Member]

Hi Team,

I have encountered a problem while performing system copy. Sourse system and target system is running on same kind of setup like OS ,database ,patches etc with different SID 's.

I have sucessfully Restored Offline Backup of Source System onto Target System and after restoration of offline backup and i have created a control file and altered it to use in target system with out any errors and placed in target system.

However,when i'm trying to open the data base in target system we are encountering the below message

alter database open

*

ERROR at line 1:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: 'D:\ORACLE\HYD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

SQL> alter database recover automatic using backup controlfile until cancel;

alter database recover automatic using backup controlfile until cancel

*

ERROR at line 1:

ORA-00279: change 3384907 generated at 01/07/2012 15:11:50 needed for thread 1

ORA-00289: suggestion : D:\ORACLE\HYD\ORAARCH\HYDARCHARC00001.001

ORA-00280: change 3384907 for thread 1 is in sequence #1

ORA-00278: log file 'D:\ORACLE\HYD\ORAARCH\HYDARCHARC00001.001' no longer

needed for this recovery

ORA-00308: cannot open archived log 'D:\ORACLE\HYD\ORAARCH\HYDARCHARC00001.001'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

Please note that both my SRC & TGT systems and runnig in archive mode and we have used the offline backup for system copy.

My system setup is :

OS: Windows 2003

Database : Oracle 9.2.0.4.0

SAP 4.7 EE

Seek your suggessions to fix this issue and kindly let me know if you need further information.

Thanks & Regards,

Vinod

[fidel_vales · Accepted solution]

Hi,

> I have sucessfully Restored Offline Backup of

The error clearly indicate that your offline backup procedure is not correct.

The database was not properly closed when the backup was done and oracle it is indicating this inconsistency:

> ORA-01113: file 1 needs media recovery

> ORA-01110: data file 1: 'D:\ORACLE\HYD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

How do you perform offline backups?

[Former Member · Accepted solution]

Hi Vales,

thanks for your prompt response,I accept wht u said and now i have perfomred the offline backup / restore again using the below command.

How do you perform offline backup:

1)Stopped the database services.

2) Exceute the below command for offlien backup.

brbackup -c -m all -t offline -c ;

brrestore -c -m full -b logxx.aft -c; (For restore)

Now i'm getting an error while creating control file in target machine by using the sourse system trace file using below command

SQL> alter database backup controlfile to trace;

Getting below error message below

CREATE CONTROLFILE SET DATABASE "HYD" RESETLOGS ARCHIVELOG

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-00200: controlfile could not be created

ORA-00202: controlfile: 'D:\oracle\HYD\origlogA
cntrl\cntrlHYD.dbf'

ORA-27040: skgfrcre: create error, unable to create file

OSD-04002: unable to open file

O/S-Error: (OS 3) The system cannot find the path specified.

Any help you can give would be appreciated.

Thanks & Regards,

Vinod

[fidel_vales · Accepted solution]

Hi,

The error you get is:

> ERROR at line 1:

> ORA-01503: CREATE CONTROLFILE failed

> ORA-00200: controlfile could not be created

> ORA-00202: controlfile: 'D:\oracle\HYD\origlogA
cntrl\cntrlHYD.dbf'

> ORA-27040: skgfrcre: create error, unable to create file

> OSD-04002: unable to open file

> O/S-Error: (OS 3) The system cannot find the path specified.

so,

• do you have a D drive?

• do the directory oracle\HYD\origlogA
  cntrl exist in the D drive?

• do the user executing the command has authorizations to write on the mentioned directory?

You only have to apply a little common sense after reading the error

[former_member204746 · Accepted solution]

directory D:\oracle\HYD\origlogA
cntrl\ must exist

also check initHYD.ora

you should not use double backslash:

D:\oracle\HYD\origlogA *

* cntrl\

[Former Member · Accepted solution]

Hi Vales / Eric,

Thanks for your help guys.Finally i made the system copy and database is open and available to use But when i start the sap instance,i see message server getting connected fine and dispatcher starts fine and became yellow in few mins and the work processes were going ended and finally i found the dispatcher to be died.

I found these below errors in dev_WP logs and also please refer the dev_disp log below and please suggest me if u find any fix.

DEV_Disp log say that possible network problems detected but i couldn't find any problems with my system as such.

ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

ERROR => CONNECT failed with sql error '1017

DEv_Disp Log:

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

-

---

trc file: "dev_disp", trc level: 1, release: "620"

-

---

Mon Jan 30 15:25:29 2012

kernel runs with dp version 3(ext=1) (@(#) DPLIB-INT-VERSION-3)

length of sys_adm_ext is 304 bytes

systemid 560 (PC with Windows NT)

relno 6200

patchlevel 0

patchno 674

intno 20020600

pid 2208

***LOG Q00=> DpSapEnvInit, DPStart (00 2208) [dpxxdisp.c 978]

shared lib "dw_xml.dll" version 674 successfully loaded

shared lib "dw_xtc.dll" version 674 successfully loaded

shared lib "dw_stl.dll" version 674 successfully loaded

Mon Jan 30 15:25:34 2012

• WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 4 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 3212]

MtxInit: -2 0 0

DpShMCreate: sizeof(wp_adm) 11280 (752)

DpShMCreate: sizeof(tm_adm) 1690816 (8412)

DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

DpShMCreate: sizeof(comm_adm) 192000 (384)

DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)

DpShMCreate: SHM_DP_ADM_KEY (addr: 032F0040, size: 1976320)

DpShMCreate: allocated sys_adm at 032F0040

DpShMCreate: allocated wp_adm at 032F0560

DpShMCreate: allocated tm_adm_list at 032F3170

DpShMCreate: allocated tm_adm at 032F3198

DpShMCreate: allocated wp_ca_adm at 0348FE58

DpShMCreate: allocated appc_ca_adm at 034944A8

DpShMCreate: allocated comm_adm_list at 03495C18

DpShMCreate: allocated comm_adm at 03495C30

DpShMCreate: allocated ca_info at 034C4A30

DpShMCreate: allocated wall_adm at 034C4A38

Mon Jan 30 15:25:35 2012

MBUF state OFF

EmInit: MmSetImplementation( 2 ).

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation std

<EsNT> Memory Reset enabled as NT default

<EsNT> EsIUnamFileMapInit: Initialize the memory 608 MB

<ES> 607 blocks reserved for free list.

ES initialized.

***LOG Q0K=> DpMsAttach, mscon ( sapkalam) [dpxxdisp.c 9115]

CCMS: Initalizing shared memory of size 20000000 for monitoring segment.

CCMS: start to initalize 3.X shared alert area (first segment).

DpMsgAdmin: Set release to 6200, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

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

DpMsgAdmin: Set patchno for this platform to 674

Release check o.K.

Mon Jan 30 15:26:15 2012

• ERROR => W3 (pid 2892) died [dpxxdisp.c 11523]*

force unlock of wp_adm mutex W3

• ERROR => W4 (pid 3272) died [dpxxdisp.c 11523]*

force unlock of wp_adm mutex W4

• ERROR => W8 (pid 3752) died [dpxxdisp.c 11523]*

force unlock of wp_adm mutex W8

• ERROR => W9 (pid 3572) died [dpxxdisp.c 11523]*

force unlock of wp_adm mutex W9

my types changed after wp death/restart 0xbf --> 0xbb

Mon Jan 30 15:26:35 2012

• ERROR => W0 (pid 664) died [dpxxdisp.c 11523]*

force unlock of wp_adm mutex W0

• ERROR => W5 (pid 3824) died [dpxxdisp.c 11523]*

force unlock of wp_adm mutex W5

• ERROR => W7 (pid 2924) died [dpxxdisp.c 11523]*

force unlock of wp_adm mutex W7

• ERROR => W10 (pid 2996) died [dpxxdisp.c 11523]*

force unlock of wp_adm mutex W10

• ERROR => W11 (pid 3168) died [dpxxdisp.c 11523]*

force unlock of wp_adm mutex W11

• ERROR => W12 (pid 3664) died [dpxxdisp.c 11523]*

force unlock of wp_adm mutex W12

my types changed after wp death/restart 0xbb --> 0xa3

Mon Jan 30 15:26:55 2012

• ERROR => W1 (pid 2768) died [dpxxdisp.c 11523]*

force unlock of wp_adm mutex W1

• ERROR => W2 (pid 3552) died [dpxxdisp.c 11523]*

force unlock of wp_adm mutex W2

• ERROR => W6 (pid 2964) died [dpxxdisp.c 11523]*

force unlock of wp_adm mutex W6

• ERROR => W13 (pid 448) died [dpxxdisp.c 11523]*

force unlock of wp_adm mutex W13

• ERROR => W14 (pid 4024) died [dpxxdisp.c 11523]*

force unlock of wp_adm mutex W14

my types changed after wp death/restart 0xa3 --> 0x80

• DP_FATAL_ERROR => DpEnvCheck: no more work processes*

• DISPATCHER EMERGENCY SHUTDOWN ****

DpModState: change server state from STARTING to SHUTDOWN

Mon Jan 30 15:27:00 2012

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 9341]

MBUF state OFF

MBUF component DOWN

***LOG Q05=> DpHalt, DPStop ( 2208) [dpxxdisp.c 7883]

DEV_Wp :

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

-

---

trc file: "dev_w0", trc level: 1, release: "620"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Mon Jan 30 15:25:48 2012

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\HYD\SYS\exe\run\dboraslib.dll' ...

B Library 'D:\usr\sap\HYD\SYS\exe\run\dboraslib.dll' loaded

B Version of 'D:\usr\sap\HYD\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.549)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 674

M intno 20020600

M pid 664

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 664) [dpxxdisp.c 1028]

I MtxInit: -2 0 0

M

M Mon Jan 30 15:25:53 2012

M DpShMCreate: sizeof(wp_adm) 11280 (752)

M DpShMCreate: sizeof(tm_adm) 1690816 (8412)

M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M DpShMCreate: sizeof(comm_adm) 192000 (384)

M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 032F0040, size: 1976320)

M DpShMCreate: allocated sys_adm at 032F0040

M DpShMCreate: allocated wp_adm at 032F0560

M DpShMCreate: allocated tm_adm_list at 032F3170

M DpShMCreate: allocated tm_adm at 032F3198

M DpShMCreate: allocated wp_ca_adm at 0348FE58

M DpShMCreate: allocated appc_ca_adm at 034944A8

M DpShMCreate: allocated comm_adm_list at 03495C18

M DpShMCreate: allocated comm_adm at 03495C30

M DpShMCreate: allocated ca_info at 034C4A30

M DpShMCreate: allocated wall_adm at 034C4A38

X

X Mon Jan 30 15:25:56 2012

X EmInit: MmSetImplementation( 2 ).

X

X Mon Jan 30 15:25:57 2012

X <ES> client 0 initializing ....

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M

M Mon Jan 30 15:26:00 2012

M calling db_connect ...

C Got ORACLE_HOME=D:\oracle\ora92 from environment

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

C Connecting as /@HYD on connection 0 ...

C Attaching to DB Server HYD (con_hdl=0,svchp=0711029C,svrhp=071124F4)

C

C Mon Jan 30 15:26:34 2012

C Starting user session (con_hdl=0,svchp=0711029C,srvhp=071124F4,usrhp=0711ACCC)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 3718]

C *** ERROR => CONNECT failed with sql error '1017'

[dboci.c 9601]

C Try to connect with default password

C Connecting as SAPHYD/<pwd>@HYD on connection 0 ...

C Starting user session (con_hdl=0,svchp=0711029C,srvhp=071124F4,usrhp=0711ACCC)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 3718]

C *** ERROR => CONNECT failed with sql error '1017'

[dboci.c 9601]

B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 962] [dbsh 0962 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 962] [dbsh 0962 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink 0419 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

M rq_source = 255

M last_tid = 0

M last_mode = 0

M rfc_req = 0

M report = > <

M action = 0

M tab_name = > <

M

M *****************************************************************************

M *

M * LOCATION SAP-Server sapkalam_HYD_00 on host sapkalam (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Mon Jan 30 15:26:34 2012

M * RELEASE 620

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 8569

M * COUNTER 1

M *

M *****************************************************************************

M

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 664) [dpnttool.c 346]

We would be appriciated your help...

Many Thanks,

Vinod

[former_member204746 · Accepted solution]

try this:

brconnect -c -p initHYD.sap -l E -f chpass -o SAPR3 -password ZZZZ

brconnect -c -p initHYD.sap -l E -f chpass -o SYSTEM -password ZZZZ

brconnect -c -p initHYD.sap -l E -f chpass -o SYS -password ZZZZ

sqlplus /nolog @D:\usr\sap\HYD\sys\exe\run\sapdba_role.sql HYD NT

good luck.

[Former Member · Accepted solution]

Hi Vinod,

After system copy we need to correct the OPS$ mechanism.

Please create OPS$ users using ORADBUSR.sql file.

then you will have to set the password for SAPR3 / SAP<SID> (Schema owner)

Regards,

Sachin Rane.

[Former Member · Accepted solution]

Hi Eric & All,

Sorry for my late reply, As i was bit busy with other priorities i didn't replied you.

I have created the OPS$ user as per the below notes

Note 400241 Problems with OPs$ user

Note 50088 creating OPS$ user on winnt/oracle

However, when i say r3trns -d i'm getting return code-0012 error and error as mentioned below.

4 ETW000 r3trans version 6.08 (release 620 - 04.02.03 - 14:54:00).

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

4 ETW000

4 ETW000 date&time : 02.02.2012 - 19:24:22

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] Thu Feb 02 19:24:26 2012 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0.000000

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

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ...

4 ETW000 0.000000

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0

4 ETW000 5864 0.005864

4 ETW000 [dev trc ,00000] using "D:\usr\sap\HYD\SYS\exe\run\dboraslib.dll"

4 ETW000 20 0.005884

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded

4 ETW000 15 0.005899

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 18 0.005917

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "620.02", patchlevel (0.549)

4 ETW000 76 0.005993

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 19 0.006012

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 27 0.006039

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

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO

4 ETW000 20 0.006080

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

4 ETW000 16 0.006096

4 ETW000 [dev trc ,00000] find_con found the following connection for reuse:

4 ETW000 14 0.006110

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO

4 ETW000 16 0.006126

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=D:\oracle\ora92 from environment

4 ETW000 180 0.006306

4 ETW000 [dev trc ,00000] -->oci_initialize 14 0.006320

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

4 ETW000 16753 0.023073

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

4 ETW000 45 0.023118

4 ETW000 [dev trc ,00000] Connecting as /@HYD on connection 0 ...

4 ETW000 14 0.023132

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

4 ETW000 21 0.023153

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

4 ETW000 22 0.023175

4 ETW000 [dev trc ,00000] Attaching to DB Server HYD (con_hdl=0,svchp=0022DC4C,svrhp=01F6307C)

4 ETW000 39 0.023214

4 ETW000 [dev trc ,00000] Thu Feb 02 19:24:33 2012 6818919 6.842133

4 ETW000 [dev trc ,00000] Assigning server context 01F6307C to service context 0022DC4C

4 ETW000 25 6.842158

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

4 ETW000 92 6.842250

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0022DC4C,srvhp=01F6307C,usrhp=01F6B814)

4 ETW000 28 6.842278

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

4 ETW000 12168 6.854446

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

4 ETW000 21 6.854467

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

4 ETW000 22 6.854489

4 ETW000 [dev trc ,00000] Connecting as SAPHYD/<pwd>@HYD on connection 0 ...

4 ETW000 17 6.854506

4 ETW000 [dev trc ,00000] Assigning username to user session 01F6B814

4 ETW000 16 6.854522

4 ETW000 [dev trc ,00000] Assigning password to user session 01F6B814

4 ETW000 23 6.854545

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0022DC4C,srvhp=01F6307C,usrhp=01F6B814)

4 ETW000 21 6.854566

4 ETW000 [dev trc ,00000] Assigning user session 01F6B814 to service context 0022DC4C

4 ETW000 2464 6.857030

4 ETW000 [dev trc ,00000] Now I'm connected to ORACLE

4 ETW000 500 6.857530

4 ETW000 [dev trc ,00000] Database NLS settings: AMERICAN_AMERICA.WE8DEC

4 ETW000 346 6.857876

4 ETW000 [dev trc ,00000] Couldn't read V$INSTANCE: sqlcode=942

4 ETW000 1361 6.859237

4 ETW000 [dev trc ,00000] Couldn't get creation timestamp from V$DATABASE: sqlcode=942

4 ETW000 1664 6.860901

4 ETW000 [dev trc ,00000] Connection 0 opened 16 6.860917

4 ETW000 [dblink ,01292] ***LOG BZA=>table SVERS does not exist on database [dblink#1 @ 1292]

4 ETW000 66993 6.927910

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT FROM DDNTT FAILED

4 ETW000 539 6.928449

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM DDNTT FAILED

4 ETW000 402 6.928851

4 *ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT FAILED*4 ETW000 400 6.929251

4 ETW000 [dbntab ,01237] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#9 @ 12379]

Please let me know what might be wrong. Howver i have tried to reset the passwords of SAP<SID>,SYS,SYSTEM using BRConnect command to default one 'sap' but couldn't help any more.

While executing sapdba_role.sql i'm getting error as shown below

ERROR:ORA-01017: invalid username/password; logon denied*

Warning: You are no longer connected to ORACLE.

SP2-0640: Not connected

Connected.

select username into V_User from sys.dba_users where username = :Owner;

*

ERROR at line 14:

ORA-06550: line 14, column 39:

PL/SQL: ORA-00942: table or view does not exist

ORA-06550: line 14, column 2:

PL/SQL: SQL Statement ignored

ORA-06550: line 22, column 39:

PL/SQL: ORA-00942: table or view does not exist

ORA-06550: line 22, column 2:

PL/SQL: SQL Statement ignored

I could see the owner name as below

SQL> select owner from dba_tables where table_name='SAPUSER';

OWNER

-

---

OPS$HYDADM

I would highly appreciate for any assitance.

Thanks & Regards,

Vinod

[former_member204746 · Accepted solution]

Have you installed SAP on a domain or not?

what is the date on the script sapdba_role.sql? is it the latest as per SAP note 400241?

[former_member603052 · Accepted solution]

Hi Vinod,

I recently got this error and solved it.Here is what i had done.

My Scenerio:

Source System:RP1

Target System :RQ1

after restoring the database, i am able to connect DB directly using SQLPLUS

When running R3trans -d....got Return Code <0012>

Now login to sql and execute the script Oradbusr.sql

The following script creates OPS$ users in DB.

SQL>@oradbusr.sql SAPRP1 NT Domain_name RQ1 (i.e. If u dont have domain name give HostName )

(SAPRP1 is my PRD system DB schema Owner, RQ1 is my target SID)

Now create SAPUSER table in both OPS$ Users created newly above.

SQL>CREATE TABLE " OPS$DOMAIN OR HOST_NAME\RQ1ADM ".SAPUSER

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

SQL>CREATE TABLE " OPS$DOMAIN OR HOST_NAME\SAPServiceRQ1 ".SAPUSER

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

Now insert values into SAPUSER tables.

SQL>insert into "OPS$DOMAIN OR HOST_NAME\RQ1ADM".SAPUSER VALUES ('SAPRP1-CRYPT','V01/0014ZctvSB67Wv3+vJLLnC8=');

SQL>insert into "OPS$DOMAIN OR HOST_NAME\SAPServiceRQ1".SAPUSER VALUES ('SAPRP1-CRYPT','V01/0014ZctvSB67Wv3+vJLLnC8=');

(Get these information from target system(RP1) executing the SQL Command)

SQL> select * from "OPS$DOMAIN OR HOST_NAME\RP1ADM".SAPUSER;(Copy this details and insert in above 2 tables)

SQL>Commit;

Now Goto BRTools

CMD>BRTools

>select 8(Additional Functions) and click change password for database user.

>Select 2 and give ur System as user name and his password

>select 3 and give User as SAPRP1(in my case)

> now click c and again c

>it asks u to enter password

>asks to re-enter password again

This finishes.

Now start ur Instance

Regards,

Kalyan

[Former Member · Accepted solution]

Hi Kalyan,

Appreciated your brief response, When i'm trying to execute Oradbusr.sql getting the error as below

System Details as below:

Target SID: HYD Sourse SID: SEC

Hostname : SAPKALAM Hostname: CPPC1WY2C1S

Target Schema owner: SAPHYD sourse Schema Owner: SAPSEC

SQL> @D:\oracle\HYD\sapbackup\oradbusr.sql SAPHYD NT SAPKALAM HYD;

Connected.

old 6: if length('&&1') = 5 then

new 6: if length('SAPHYD') = 5 then

old 7: if substr(upper('&&1'),1,5) = 'SAPR3' then

new 7: if substr(upper('SAPHYD'),1,5) = 'SAPR3' then

old 10: if upper('&&2') = 'NT' then

new 10: if upper('NT') = 'NT' then

old 17: :sDomain := upper('&&3');

new 17: :sDomain := upper('SAPKALAM');

old 18: :sSapSid := upper('&&4');

new 18: :sSapSid := upper('HYD');

old 20: :sSapSid := upper('&&3');

new 20: :sSapSid := upper('SAPKALAM');

old 36: :sSchema := upper('&&1');

new 36: :sSchema := upper('SAPHYD');

old 37: if upper('&&2') = 'NT' then

new 37: if upper('NT') = 'NT' then

old 44: :sDomain := upper('&&3');

new 44: :sDomain := upper('SAPKALAM');

old 45: :sSapSid := upper('&&4');

new 45: :sSapSid := upper('HYD');

old 47: :sSapSid := upper('&&3');

new 47: :sSapSid := upper('SAPKALAM');

using following Parameters:

.

. Oracle Version: 9.2.0.4.0

. Parametervalue os_authent_prefix: OPS$

. Schema Id: HYD

. Database User (Schema): SAPHYD

. SAP R/3 Administrator: OPS$SAPKALAM\HYDADM

. SAP R/3 Serviceuser: OPS$SAPKALAM\SAPSERVICEHYD

unable to assign default tablespace to user: SAPHYD

begin

***

ERROR at line 1:

ORA-00959: tablespace 'PSAPHYDUSR' does not exist

ORA-06512: at line 90

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production.

Please see the below information which might give some clew to identify the error

SQL> select owner from dba_tables where table_name='SAPUSER';

OWNER

-

---

OPS$CPPC1WY2C1S\SECADM

After partial execution of Oradbuser.sql script, I could see the OPS$ users as below

SQL> select username from dba_users;

USERNAME

-

---

SYS

SYSTEM

OUTLN

DBSNMP

OPS$CPPC1WY2C1S\SECADM

SAPSEC

OPS$CPPC1WY2C1S\SAPSERVICESEC

OPS$ADM

OPS$SAPKALAM\HYDADM

SAPHYD

10 rows selected.

Now please suggest me the possible solution. Do you want me to drop the drop / recreate the SAPUSER table and insert the possible entries.

I would greatly appriciate any suugession with possible solution.

Thanks & Regards,

Vinod

[Former Member · Accepted solution]

ERIC,

My Sap system in not in domain..it is a test server which in under workgroup standalone system.

and i was tried with the latest oradbusr.sql only and getting the error shown below

unable to assign default tablespace to user: SAPHYD

begin

*

ERROR at line 1:

ORA-00959: tablespace 'PSAPHYDUSR' does not exist

ORA-06512: at line 90

Many Thanks,

Vinod

[former_member603052 · Accepted solution]

Hi Vinod,

>

>  System Details as below:
>   *****************************************************                  
> Target SID: HYD                               Sourse SID: SEC
> Hostname : SAPKALAM                   Hostname: CPPC1WY2C1S
> Target Schema owner: SAPHYD        sourse Schema Owner: SAPSEC
> 
> 
> SQL> @D:\oracle\HYD\sapbackup\oradbusr.sql SAPHYD NT SAPKALAM HYD;
> Connected.

U need to Run like this in Target System (as per ur scenerio)

SQL>@D:\oracle\HYD\sapbackup\oradbusr.sql SAPSEC NT SAPKALAM HYD

So this script creates OPS$SAPKALAM\SAPSERVICEHYD and OPS$SAPKALAM\HYDADM users

Regards,

Kalyan

[Former Member · Accepted solution]

Hi kalyan,

I have executed the oradbusr.sql script sucessfully, However i could able to see the OPS$users created and granted all permissions .Here is the output

SQL> select username from dba_users;

USERNAME

-

---

SYS

SYSTEM

OUTLN

DBSNMP

SAPSEC

OPS$ADM

OPS$SAPKALAM\HYDADM

SAPHYD

OPS$SAPKALAM\SAPSERVICEHYD

9 rows selected.

and owner from SAPUSER table is as shown below

SQL> select owner from dba_tables where table_name='SAPUSER';

OWNER

-

---

OPS$SAPKALAM\HYDADM

I have tried to reset the password using SAPDBA and intiated sapconnect option but still i could not succeed and i'm getting error when i execute r3trans -d RC:0012...as shown below

4 ETW000 r3trans version 6.08 (release 620 - 04.02.03 - 14:54:00).

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

4 ETW000

4 ETW000 date&time : 06.02.2012 - 17:00:23

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] Mon Feb 06 17:00:28 2012 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0.000000

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

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ...

4 ETW000 0.000000

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0

4 ETW000 5953 0.005953

4 ETW000 [dev trc ,00000] using "D:\usr\sap\HYD\SYS\exe\run\dboraslib.dll"

4 ETW000 21 0.005974

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded

4 ETW000 15 0.005989

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 18 0.006007

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "620.02", patchlevel (0.549)

4 ETW000 75 0.006082

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 18 0.006100

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 27 0.006127

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

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO

4 ETW000 20 0.006169

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

4 ETW000 16 0.006185

4 ETW000 [dev trc ,00000] find_con found the following connection for reuse:

4 ETW000 13 0.006198

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO

4 ETW000 17 0.006215

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=D:\oracle\ora92 from environment

4 ETW000 173 0.006388

4 ETW000 [dev trc ,00000] -->oci_initialize 15 0.006403

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

4 ETW000 15781 0.022184

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

4 ETW000 45 0.022229

4 ETW000 [dev trc ,00000] Connecting as /@HYD on connection 0 ...

4 ETW000 16 0.022245

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

4 ETW000 20 0.022265

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

4 ETW000 23 0.022288

4 ETW000 [dev trc ,00000] Attaching to DB Server HYD (con_hdl=0,svchp=01F6343C,svrhp=01F63FCC)

4 ETW000 39 0.022327

4 ETW000 [dev trc ,00000] Mon Feb 06 17:00:35 2012 6790820 6.813147

4 ETW000 [dev trc ,00000] Assigning server context 01F63FCC to service context 01F6343C

4 ETW000 25 6.813172

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

4 ETW000 92 6.813264

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=01F6343C,srvhp=01F63FCC,usrhp=01F6C764)

4 ETW000 28 6.813292

4 ETW000 [dev trc ,00000] Assigning user session 01F6C764 to service context 01F6343C

4 ETW000 3564 6.816856

4 ETW000 [dev trc ,00000] Now I'm connected to ORACLE

4 ETW000 586 6.817442

4 ETW000 [dev trc ,00000] Got SAPHYD's password from table SAPUSER

4 ETW000 569 6.818011

4 ETW000 [dev trc ,00000] Got SAPHYD's password from OPS$-user

4 ETW000 16 6.818027

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

4 ETW000 14 6.818041

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

4 ETW000 20 6.818061

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=01F6343C,usrhp=01F6C764)

4 ETW000 138 6.818199

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

4 ETW000 232 6.818431

4 ETW000 [dev trc ,00000] Connecting as SAPHYD/<pwd>@HYD on connection 0 ...

4 ETW000 18 6.818449

4 ETW000 [dev trc ,00000] Assigning username to user session 01F6C764

4 ETW000 16 6.818465

4 ETW000 [dev trc ,00000] Assigning password to user session 01F6C764

4 ETW000 21 6.818486

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=01F6343C,srvhp=01F63FCC,usrhp=01F6C764)

4 ETW000 21 6.818507

4 ETW000 [dev trc ,00000] Assigning user session 01F6C764 to service context 01F6343C

4 ETW000 2974 6.821481

4 ETW000 [dev trc ,00000] Now I'm connected to ORACLE

4 ETW000 443 6.821924

4 ETW000 [dev trc ,00000] Database NLS settings: AMERICAN_AMERICA.WE8DEC

4 ETW000 317 6.822241

4 ETW000 [dev trc ,00000] Couldn't read V$INSTANCE: sqlcode=942

4 ETW000 1565 6.823806

4 ETW000 [dev trc ,00000] Couldn't get creation timestamp from V$DATABASE: sqlcode=942

4 ETW000 1707 6.825513

4 ETW000 [dev trc ,00000] Connection 0 opened 15 6.825528

4 ETW000 [dblink ,01292] ***LOG BZA=>table SVERS does not exist on database [dblink#1 @ 1292]

4 ETW000 50338 6.875866

4 ETW000 [dev trc ,00000] NTAB: SELECT COMPCNT FROM DDNTT FAILED

4 ETW000 71270 6.947136

4 ETW000 [dev trc ,00000] NTAB: SELECT VERSION FROM DDNTT FAILED

4 ETW000

466 6.947602

*_4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT FAILED_*

4 ETW000 434 6.9480364 ETW000 [dbntab ,01237] ***LOG BZY=>unexpected return code 103 calling NTAB [dbntab#9 @ 12379]

4 ETW000 23 6.948059

4 ETW000 [dev trc ,00000] NTAB: standalone processing

4 ETW000 15762 6.963821

4 ETW000 [dev trc ,00000] NTAB: read profile 13 6.963834

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/entrycount 400

4 ETW000 94 6.963928

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/ftabsize 200

4 ETW000 13 6.963941

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/irbdsize 100

Help me to fix this issue and please let me know if you need further information.

Many Thanks,

Vinod

[former_member603052 · Accepted solution]

Hi

Which user password have u changed.

You have to change SAPSEC user password using BRTools.

cmd > BRTools

>select 8(additional Functions)

>select 4 (change password.....)

>select 2 and enter ur system/password(password of system user)

>select 3 and enter SAPSEC(in ur case)

now press c

again press c

now type the new password

re-enter new password

press c

and now u exit

and start instance

Regards,

Kalyan

[markus_doehr2 · Accepted solution]

> 4 ETW000 r3trans version 6.08 (release 620 - 04.02.03 - 14:54:00).

..and just to add: you are using unsupported kernel version, see

Note 803429 - Desupport 6.20 kernel

6.20 is LONG out of support, your R3trans is over 6 years old!

Markus

[Former Member · Accepted solution]

Hi Kalyan,

Since i'm using 4.7 EE i have only SAPDBA tool available and i have changed the passowrd "SAPSEC" to default password 'sap' using SAPDBA . still i'm getting the below error while database trying to connect to SAP. and R3trans error as shown below

Translog Error:

*4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT FAILED*

4 ETW000

405 6.832509

In my scenario SEC is the sourse system SID [( Ex- like i have made a system copy from PRD to QAS, PRD(SEC) and QAS(HYD) in my scenario ] , what does make scense to change the passoword of SAPSEC user id however i could see SAPHYD user is acting as a owner of the 'SAPUSER' table in my system.

Hope it's clear...

Many Thanks,

Vinod

[Former Member · Accepted solution]

Hello,

can you please post the complete trans.log? This error usually means that something more serious than just a wrong username/password combination is going on here...

Best Regards,

Michael

[former_member603052 · Accepted solution]

Hi,

>

> 
> In my scenario SEC is the sourse system SID [( Ex- like i have made a system copy from PRD to QAS, PRD(SEC) and QAS(HYD) in my scenario ] , what does make scense to change the passoword of SAPSEC user id however i could see SAPHYD user is acting as a owner of the 'SAPUSER'  table in my system.

Since in ur PRD system the DB Schema Owner is SAPSEC and the same database is restored to ur Quality (QAS) ..the database tables also will be under DB schema Owner SAPSEC only

Which using Oradbusr.sql script we r creating OPS$Users and SAPUSER tables under this newly created OPS$users.

We need to insert the USERID and password of SAPSEC DB Schema Owner(get from the actual PRD System) and the change password for this SAPSEC DB Schema User using BRTools(SAPDBA in ur case)

Hope u got it.

Regards,

Kalyan

[Former Member · Accepted solution]

Hi Kalyan,

Thanks for your patience and prompt respose but unfortunately i couldn't find any luck on my issue. As suggested by you i have inserted the user SAPSEC and changed the passowrd through SAPDBA to default password 'sap' with out any errors.

I dont know where i'm doing wrong in that process.sorry to bother you guys as i'm trying this system copy in first time and since i'm bit new to basis , I dont know i might be messing up the things

Please see the below output's for your referece.

SQL> select userid from "OPS$SAPKALAM\HYDADM".SAPUSER;

USERID

-

---

SAPHYD-CRYPT

SAPSEC

SQL> select owner from dba_tables where table_name='SAPUSER';

OWNER

-

---

OPS$SAPKALAM\HYDADM

Many Thanks,

Vinod

[former_member603052 · Accepted solution]

Hi Vinod,

>

> USERID
> -
> SAPHYD-CRYPT
> SAPSEC

Where is the -CRYPT beside SAPSEC.You run the below command in your PRD DB

(On PRD) SQL> select userid,passwd from OPS$<PRD_Hostname>\SECADM".SAPUSER;

Save the output and the insert the same into table OPS$SAPKALAM\HYDADM".SAPUSER as below

(On QAS) SQL> insert into OPS$SAPKALAM\HYDADM".SAPUSER values('SAPSEC-CRYPT','V0....................................');

SQL>Commit;

Now change the password of SAPSEC User using SAPDBA Tool.

Regards,

Kalyan

[former_member603052 · Accepted solution]

Hi Vinod,

>

> USERID
> -
> SAPHYD-CRYPT
> SAPSEC

Where is the -CRYPT beside SAPSEC.You run the below command in your PRD DB

(On PRD) SQL> select userid,passwd from OPS$<PRD_Hostname>\SECADM".SAPUSER;

Save the output and the insert the same into table OPS$SAPKALAM\HYDADM".SAPUSER as below

(On QAS) SQL> insert into OPS$SAPKALAM\HYDADM".SAPUSER values('SAPSEC-CRYPT','V0....................................');

SQL>Commit;

Now change the password of SAPSEC User using SAPDBA Tool.

Regards,

Kalyan

[former_member603052 · Accepted solution]

Hi Vinod,

No updates from u....Is the problem Solved??

Regards,

Kalyan

[Former Member · Accepted solution]

Hi Kalyan ,Nick ,Eric and All,

Thanks for all your time and appreciated your patience, finally i made with system copy successfully.

sorry for delay in getting back you guys sice i was busy with some other activities ...but i could see some delay while start / shutdown the database.any guesses .??.

and i'm getting some error while applying temp license like no valid license found and couldn't delete old license aswell..

Any way I'm working on it...Again thanks for your support.

Many Thanks,

Vinod

[former_member603052 · Accepted solution]

Hi Vinod,

I too done upto here and came to know that we cant install the same temp license again ....u need to get a new license i hope.....!

Regards,

Kalyan

[Former Member]

Hi Vinod,

Again you are saying that facing same error? But here in your dev_w0 log that issue was not there.

If you are getting the same at R3trans -d, Just correct all errors as shown in dev_w0.

Means here i am able to see the first error as couldn't read V$INSTANCE sql error 942.

This is related to correct schema owner, now you are using the owner which in not exactly the same as your database. You need to set the same with correct one. You can correct these errors with SAPNOTE 400241.

And after that upgrade your kernel with correct one.

Regards

Nick Loy

[Former Member]

Hi Vinod,

According to your scenario, you are saying that user ids are correct and as well as schema owner.

Can you do one thing, just delete all log files from work directory (dev_w*) and try to start sap application. and send us the log file dev_w0. In this file we can easily identiry the exact error.

And you are getting the error NTAB/DD mismatch means have anybody changed and standard database settings means like charactersets etc? If not please make sure you are using correct kernel or not?

Before send us the log file dev_w0.

Regards

Nick Loy

[Former Member]

Hi Nick,

Sorry for the delay in getting back you, i have done with all the things which you have suggested like cleared out all entires of DEV_W* in work directory and tried to start the instance but no luck, however getting the same error as shown below.

I have not made any major changes at DB level like charachter set change etc and kernal release is 620.

R3trans -d output point out some error as below:

*4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT FAILED*

4 ETW000 379 6.832457

Please see the attached DEV_W* trace which might helps to investigate further

-

---

trc file: "dev_w0", trc level: 1, release: "620"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Sat Feb 11 14:46:36 2012

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\HYD\SYS\exe\run\dboraslib.dll' ...

B Library 'D:\usr\sap\HYD\SYS\exe\run\dboraslib.dll' loaded

B Version of 'D:\usr\sap\HYD\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.549)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 674

M intno 20020600

M pid 3020

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3020) [dpxxdisp.c 1028]

I MtxInit: -2 0 0

M DpShMCreate: sizeof(wp_adm) 11280 (752)

M DpShMCreate: sizeof(tm_adm) 1690816 (8412)

M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M DpShMCreate: sizeof(comm_adm) 192000 (384)

M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 032F0040, size: 1976320)

M DpShMCreate: allocated sys_adm at 032F0040

M DpShMCreate: allocated wp_adm at 032F0560

M DpShMCreate: allocated tm_adm_list at 032F3170

M DpShMCreate: allocated tm_adm at 032F3198

M DpShMCreate: allocated wp_ca_adm at 0348FE58

M DpShMCreate: allocated appc_ca_adm at 034944A8

M DpShMCreate: allocated comm_adm_list at 03495C18

M DpShMCreate: allocated comm_adm at 03495C30

M DpShMCreate: allocated ca_info at 034C4A30

M DpShMCreate: allocated wall_adm at 034C4A38

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X

X Sat Feb 11 14:46:37 2012

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M calling db_connect ...

C Got ORACLE_HOME=D:\oracle\ora92 from environment

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

C Connecting as /@HYD on connection 0 ...

C Attaching to DB Server HYD (con_hdl=0,svchp=06270FCC,svrhp=06273224)

C

C Sat Feb 11 14:46:50 2012

C Starting user session (con_hdl=0,svchp=06270FCC,srvhp=06273224,usrhp=0627B9FC)

C Now I'm connected to ORACLE

C Got SAPHYD's password from table SAPUSER

C Got SAPHYD's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=06270FCC,usrhp=0627B9FC)

C Now I'm disconnected from ORACLE

C Connecting as SAPHYD/<pwd>@HYD on connection 0 ...

C Starting user session (con_hdl=0,svchp=06270FCC,srvhp=06273224,usrhp=0627B9FC)

C Now I'm connected to ORACLE

C Database NLS settings: AMERICAN_AMERICA.WE8DEC

C Couldn't read V$INSTANCE: sqlcode=942

C Couldn't get creation timestamp from V$DATABASE: sqlcode=942

B Connection 0 opened

B Wp Hdl ConName ConId ConState TX PRM RCT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 20120211 144637

B ***LOG BZA=> table SVERS does not exist on database [dblink#1 @ 1292] [dblink 1292 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 004096) [thxxhead.c 1102]

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

M rq_source = 255

M last_tid = 0

M last_mode = 0

M rfc_req = 0

M report = > <

M action = 0

M tab_name = > <

M

M *****************************************************************************

M *

M * LOCATION SAP-Server sapkalam_HYD_00 on host sapkalam (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Sat Feb 11 14:46:50 2012

M * RELEASE 620

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 8569

M * COUNTER 1

M *

M *****************************************************************************

M

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3020) [dpnttool.c 346]

Please suggest me if you find any fix. Any help would be appriciated.

Many Thanks,

Vinod

[Former Member]

Hi Vinod,

Why you are merging all the solutions, first you got only OPS$ user issue you corrected with note 400241. in this scenario you need to find the actual user with which one database is getting connected.

Here you need to see the SAPUSER entries. In this table the user should be as your achema owner.

just change the env vatiable accordingly.

And last you have created as SAPSID which is not the exact one, thats why you are getting the error unable to find from V$INSTANCE. To avoid this error please drop SAPUSER table and recreate with entries user name SAPR3 and password as sap. Change your env variable of dbs_ora_schema as SAPR3, delete all old logs (dev_w*) retry.

Regards

Nick Loy

[Former Member]

Hi Nick,

Thanks for your response, Let me clear you about my system configuration.

I'm using 4.7 EE and oracle 9.2.0.4, I believe for 4.7 EE schema user is SAP<SID> i suppose sapsr3 for ecc 6.0 ,Correct me if i'm wrong and i could see the same user available in SAPUSER table as a owner.

so i have changed the password of schema user id "SAPHYD" to 'sap' and using SAPDBA since it is 4.7 EE version as per my scenario. However i'm getting the r3trans report :0012 as shown below

SQL> select owner,tablespace_name from dba_tables where table_name='SAPUSER';

OWNER TABLESPACE_NAME

-

---

-

---

OPS$SAPKALAM\HYDADM SYSTEM

Translog Error:

*4 ETW000 [dbntab.c ,00000] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT FAILED*

4 ETW000

405 6.832509

Please correct me, If i'm wrong.

Many Thanks,

Vinod