Transport control program tp ended with error code 0232

[Former Member]

Dear all

I've change password for user SAPSR3 by mistake

the result from brtools is "password changed successfully in table OPS$CAPADM.SAPUSER for user SAPSR3"

after that i can not transport to my production client

with error : TP_REPORTED_ERROR

Transport control program tp ended with error code 0232

Can anybody help me please

thanks & rgds,

Della

[JPReyes]

I think the default password for it is "sap"...

You can try changing it back using SQL command...

alter user SAPSR3 identified by sap;

or using BRTOOLS

Regards

Juan

[Former Member]

Hi Juan

thanks for your reply

but I forgot the previous password

what password should I input?

thanks

[JPReyes]

As said before I think the default password is "sap"

Regards

Juan

[Former Member]

I've changed my SAPSR3 password to sap but still error

this is the error log from Check Transport Tool

DB Connect Link to database failed

This is tp version 372.04.70 (release 700, unicode enabled)

Warning: Parameter DBLIBPATH is no longer used.

ERROR: Connect to CAP failed (20091217174435, probably wrong environmen

TRACE-INFO: 1: [dev trc ,00000] Thu Dec 17 17:44:35 2009

0.007435

TRACE-INFO: 2: [dev trc ,00000] DlLoadLib() success: dlopen("/usr

0.007448

TRACE-INFO: 3: [dev trc ,00000] Got

LIBPATH=/usr/sap/CAP/DVEBMGS32/exe:/usr/sap/CAP/DVEBMGS32/exe:/usr/lib

lient from environment

TRACE-INFO: 4:

0.008053

TRACE-INFO: 5: [dev trc ,00000] Oracle Client Version: '10.2.0.2.

0.008140

TRACE-INFO: 6: [dev trc ,00000] >oci_initialize(con_hdl=0, char

0.008158

TRACE-INFO: 7: [dev trc ,00000] application info callback registe

0.008173

TRACE-INFO: 8: [dev trc ,00000] OCIEnvCreate(mode=16384=OCI_UTF16

0.010330

TRACE-INFO: 9: [dev trc ,00000] Client character set UTF16 -> UTF

0.010421

TRACE-INFO: 10: [dev trc ,00000] Client NLS setting (OCINlsGetInf

[JPReyes]

try updating the password directly into the SAPUSER table using,

insert into "OPS$<SID>ADM".SAPUSER values ('SAPSR3','sap');

Can you post aditional logs...?

Also take a look at Note 400241

Regards

Juan

[Former Member]

Hi Juan

I've change SAPSR3 password to sap and I've try to connect using "connect sapsr3/sap@<sid>" and it's connected

but the notes said to try connect using SAPR3 not SAPSR3

I don't know the SAPR3 password, I've try connect using "sap" password but it failed

which one is used to transport mechanism??

thanks

[JPReyes]

SAPSR3 and SAPR3 are pretty much the same.... up to 4.7 use to be SAPR3 and then onwards changes to SAPSR3 (As far as I remember)

Regards

Juan

[JPReyes]

Maybe try running sapconn_role.sql and sapdba_role.sql

Regards

Juan

[Former Member]

ok

so for my transport problem, is there any issue ?

what should I do to fixed my problem??

why DB Connect Link to database failed ??

thanks a lot

[Former Member]

Hi Juan

when I execute sqlplus /nolog @sapconn_role

return with error "SP2-0310: unable to open file "sapconn_role.sql"

[Former Member]

Hello Della,

You need to change to the directory having the scripts before executing the commands.

Regards.

Ruchit.

[Former Member]

hi Ruchit

May I know which directory is it because I ran it from SQL command

with this command :

sqlplus /nolog

connect / as sysdba

SQL>sqlplus /nolog @sapconn_role

[Former Member]

Hello Della,

Both these scripts are present in /sapmnt/<SID>/exe. So please change to /sapmnt/<SID>/exe as ora<sid> and then run

sqlplus /nolog @sapconn_role

sqlplus /nolog @sapdba_role

Both these scripts normally have ora<sid> as the owner.

No need of doing

sqlplus /nolog

connect / as sysdba

[Former Member]

Hi all

My problem was solved now by doing :

brconnect -u / -f chpass -o sapsr3 -p <password>

Thanks all

rgds,

Della

[Former Member]

Hi,

I have same problem and when I'm changing the password like you said I'm getting this error: Missing name for redirect.

Please help me.