cancel
Showing results for 
Search instead for 
Did you mean: 

After system refresh system is not getting up.

mohsin_m3
Participant
0 Kudos

Hello All,

After system refresh system is not getting up.

OS : Red hat 5.3

Database : Oracle 10g

database is open ...but R3trans -d ---> shows return code 12

Below is trans.log

4 ETW000

25 0.078035

4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE

USERID IN (:A0, :A1)

4 ETW000

401 0.078436

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

ER

4 ETW000

748 0.079184

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1403

14 0.079198

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

72 0.079270

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

20 0.079290

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x3eaf878,

usrhp=0x3e9fa68)

4 ETW000

323 0.079613

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

760 0.080373

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

21 0.080394

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

nls_hdl 0) ... (dbsl 700 250407)

4 ETW000

23 0.080417

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet

C EnvHp ErrHp ErrHpBatch

4 ETW000

22 0.080439

4 ETW000 [dev trc ,00000] 0 UTF8

1 0x3e97800 0x3e9f250 0x3eaf948

4 ETW000

18 0.080457

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

11 0.080468

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

25 0.080493

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

,srvhp=0x3eb1b58,usrhp=0x3e9fa68)

4 ETW000

38 0.080531

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

ith rc=1017

4 ETW000

4978 0.085509

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

'

4 ETW000

22 0.085531

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017

11 0.085542

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

ink#5 @ 431]

4 ETW000

115 0.085657

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password

; logon denied [dblink#5 @ 431]

4 ETW000

16 0.085673

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

ra_tnsname = 'DEV'"

server:devadm 73>

Regards

Mohsin

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member213250
Active Participant
0 Kudos

Hello Mr. Moshin

Regards to your issue it sounds like there is some problew with <SID>

When system is copied and the SID of the database is changed to <NEWSID>,

the owner is not touched. The SAP system and the database have

the SID <NEWSID> but the tables in the database still have the owner

SAP<OLDSID> and have to be accessed as user SAP<OLDSID>.

The ora-1403 is risen when the SAPUSER table of the ops$user is there

but does not contain a row with the schema set in the environment in

theuserid-column. Inorder to check this ORA error

Check the environment variable dbs_ora_schema=SAP<SID> where SAP<SID> is

the owner of the tables in the database.

Hope it helps

BR

Venkat

former_member213250
Active Participant
0 Kudos

Hello Mr. Moshin

Regards to your issue it sounds like there is some problew with <SID>

When system is copied and the SID of the database is changed to <NEWSID>,

the owner is not touched. The SAP system and the database have

the SID <NEWSID> but the tables in the database still have the owner

SAP<OLDSID> and have to be accessed as user SAP<OLDSID>.

The ora-1403 is risen when the SAPUSER table of the ops$user is there

but does not contain a row with the schema set in the environment in

theuserid-column. Inorder to check this ORA error

Check the environment variable dbs_ora_schema=SAP<SID> where SAP<SID> is

the owner of the tables in the database.

Hope it helps

BR

Venkat

Former Member
0 Kudos

In your system copy guide there should be a few sentences about creating OPS$-users and sapuser table.

Did you follow that?

Former Member
0 Kudos
ORA-01017: invalid username/password

Try to change your schema password via BRtools. Once password has changed for Schems your problem will be resolved.

Also which procedure did you follow for refresh.If you have done it with backup restore then you may need to run ORADBUSR.sql script.You can take it via note 50088. (in case you have not done this step)

Thanks..

Mohit

Edited by: mohit gupta on Apr 7, 2011 7:12 AM