OPS@ user password (homogenous system copy)

[Former Member]

I have successfully restored the Production data to the QA system . the database is ON .

Now when i try to start the application i get the following error.

The OPS@GAQADM is available in the SAPUSER table.

there is something abt the password . I have gone through the SNOTE :400241

Here its says to change the password using the follwing command

brconnect -u system/<syst_pwd> -f chpass -o SAP<SID> -p <new_sap_pwd>

but i dont know what is the "system" user and what is its default password.

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

gaqscm:gaqadm 2%

gaqscm:gaqadm 2% more trans.log

4 ETW000 R3trans version 6.13 (release 640 - 21.06.06 - 08:38:00).

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

4 ETW000

4 ETW000 date&time : 20.05.2008 - 11:30: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] Tue May 20 11:30:23 2008 235 0.000235

4 ETW000 [dev trc ,00000] db_con_init called 51 0.000286

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

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/GAQ/SYS/exe/run/dboraslib.so' ...

4 ETW000 180 0.000614

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/GAQ/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 65241 0.065855

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

4 ETW000 10617 0.076472

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/GAQ/SYS/exe/run/dboraslib.so

4 ETW000 128 0.076600

4 ETW000 [dev trc ,00000] Version of '/usr/sap/GAQ/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.125)

4 ETW000 801 0.077401

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/GAQ/SYS/exe/run/dboraslib.so

4 ETW000 108 0.077509

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/GAQ/SYS/exe/run/dboraslib.so

4 ETW000 110 0.077619

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

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

, con_max = 255, con_opt = 255, occ = NO

4 ETW000 125 0.077803

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

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

4 ETW000 82 0.077939

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

con_max = 255, con_opt = 255, occ = NO

4 ETW000 89 0.078028

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

4 ETW000 397 0.078425

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

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

4 ETW000 89 0.078695

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

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

4 ETW000 [dev trc ,00000] Connecting as /@GAQ on connection 0 (nls_hdl 0) ... (dbsl 640 310306)

4 ETW000 86 0.086251

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBat

ch

4 ETW000 90 0.086341

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 10124ce20 1012560b0 101255a

48

4 ETW000 106 0.086447

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

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

4 ETW000 [dev trc ,00000] Attaching to DB Server GAQ (con_hdl=0,svchp=101255978,svrhp=101257e18)

4 ETW000 155 0.086712

4 ETW000 [dev trc ,00000] Assigning server context 101257e18 to service context 101255978

4 ETW000 65351 0.152063

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

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=101255978,srvhp=101257e18,usrhp=101261870)

4 ETW000 126 0.152277

4 ETW000 [dev trc ,00000] Assigning user session 101261870 to service context 101255978

4 ETW000 12674 0.164951

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;

4 ETW000 187 0.165138

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;

4 ETW000 293 0.165431

4 ETW000 [dev trc ,00000] Now '/@GAQ' is connected (con_hdl 0, nls_hdl 0).

4 ETW000 1709 0.167140

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 130 0.167270

4 ETW000 [dev trc ,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)

4 ETW000 861 0.168131

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

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

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

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=101255978,usrhp=101261870)

4 ETW000 411 0.170077

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

4 ETW000 [dev trc ,00000] Connecting as SAPGAQ/<pwd>@GAQ on connection 0 (nls_hdl 0) ... (dbsl 640 310306)

4 ETW000 113 0.170978

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBat

ch

4 ETW000 87 0.171065

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 10124ce20 1012560b0 101255a

48

4 ETW000 85 0.171150

4 ETW000 [dev trc ,00000] Assigning username to user session 101261870 54 0.171204

4 ETW000 [dev trc ,00000] Assigning password to user session 101261870 56 0.171260

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=101255978,srvhp=101257e18,usrhp=101261870)

4 ETW000 88 0.171348

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

4 ETW000 1792 0.173140

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

4 ETW000 104 0.173244

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 1017 performing CON [dblink#2 @ 419]

4 ETW000 143 0.173387

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#2 @ 419]

4 ETW000 80 0.173467

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'GAQ'"

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

Regasrds

Akif

[Former Member]

update the table sapuser

modfify the passwords of <sid>adm, and sapservice<sid>

hope this will be helpful

with regards

bhaskar

[andreas_herzog]

i recall having the same problem and even after having changed the password through brconnect i still wasn't able to login using sqlplus and connect / (as an example)...so:

you could also go for the ORADBUSR.SQL skript which is attached to sapnote 50088...download and append it:

> sqlplus /nolog @oradbusr.sql <schemaowner> NT <userdomain>

or on unix

> sqlplus /nolog @oradbusr.sql <Schema-Owner-ID> UNIX <SAP-ID> X

schema id environment (dbs_ora_schema) is set for the target db?

GreetZ, AH

[Former Member]

Hi,

Try changing the password of the owner SAPGAQ thru BRTOOLS.

Reset the password and try R3trans -d thru <sid>adm.

It should return 000 code to proceed further.

Regards,

Nilesh

[Former Member]

Dear Akif,

you have to change the password using brtools:

logon as ora<sid>

brtools -u /

8 - Additional functions

4 - Change password of database user

c (continue)

c (continue)

now you get

BR0263I Enter password for database user '<dbuser>' (maximum 8 characters)

--> choose a password 2 times

if this completes with succes, continue and close BRTOOLS

Try the R3trans again and let me know what is the status.

kind regards

Davy

[Former Member]

The user name is "system" default password are "manager". Regards.