cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

ORA-01017: invalid username/password; logon denied

Go to solution
Former Member

on ‎01-06-2011 3:20 AM

0 Kudos

I have just finished upgrading database from 10G to 11G with AIX/ ECC6, I have started the database after

the upgrade, but whe i run R3trans -d i get following error.

I can connect via $sqlplus SAPSR3/********@IDU

I am using orcle Instant Client 10.2.0.4.0 V3

Please help

4 ETW000 R3trans version 6.14 (release 701 - 19.11.10 - 18:10:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 05.01.2011 - 21:25:36

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] Wed Jan 5 21:25:36 2011 189 0.000189

4 ETW000 [dev trc ,00000] db_con_init called 43 0.000232

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

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/IDU/SYS/exe/run/dboraslib.o' ... 66 0.000371

4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/IDU/SYS/exe/run/dboraslib.o"), hdl 0

4 ETW000 10642 0.011013

4 ETW000 [dev trc ,00000] Library '/usr/sap/IDU/SYS/exe/run/dboraslib.o' loaded 52 0.011065

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

4 ETW000 75 0.011140

4 ETW000 [dev trc ,00000] Version of '/usr/sap/IDU/SYS/exe/run/dboraslib.o' is "700.08", patchlevel (0.110)

4 ETW000 465 0.011605

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

4 ETW000 68 0.011673

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

4 ETW000 125 0.011798

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

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

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 109 0.011983

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

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

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

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 103 0.012196

4 ETW000 [dev trc ,00000] Got LIBPATH=/usr/lib:/lib:/usr/sap/IDU/SYS/exe/run:/oracle/client/10x_64/instantclient from environment

4 ETW000 694 0.012890

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

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.4.0', (dbsl 701 140910) 253 0.013194

4 ETW000 [dev trc ,00000] Default connection: tnsname ='IDU' 49 0.013243

4 ETW000 [dev trc ,00000] -->oci_initialize(con_hdl=0, char='', nchar='') 60 0.013303

4 ETW000 [dev trc ,00000] application info callback registered 46 0.013349

4 ETW000 [dev trc ,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000 2582 0.015931

4 ETW000 [dev trc ,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrHp=0x11100ce38) 75 0.016006

4 ETW000 [dev trc ,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrBt=0x11100c6e8) 53 0.016059

4 ETW000 [dev trc ,00000] NLS env. settings: lang=0041004D00450052004900430041004E00000000000000000000000000000000

4 ETW000 296 0.016355

4 ETW000 [dev trc ,00000] terr=0041004D00450052004900430041000000000000000000000000000000000000

4 ETW000 100 0.016455

4 ETW000 [dev trc ,00000] char=0055005400460031003600000000000000000000000000000000000000000000

4 ETW000 99 0.016554

4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 45 0.016599

4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'

4 ETW000 83 0.016682

4 ETW000 [dev trc ,00000] charset='', chset='UTF8', UNI_ASC=FALSE/FALSE 46 0.016728

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

4 ETW000 [dev trc ,00000] Connecting as /@IDU on connection 0 (nls_hdl 0) ... (dbsl 701 140910)

4 ETW000 70 0.016848

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

4 ETW000 75 0.016923

4 ETW000 [dev trc ,00000] 0 UTF8 0x110ff4740 0x11100ce38 0x11100c6e8

4 ETW000 75 0.016998

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

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

4 ETW000 [dev trc ,00000] Attaching to DB Server IDU (con_hdl=0,svchp=0x111010418,srvhp=0x111011fb8)

4 ETW000 137 0.017245

4 ETW000 [dev trc ,00000] Wed Jan 5 21:25:37 2011 273206 0.290451

4 ETW000 [dev trc ,00000] Assigning server context 0x111011fb8 to service context 0x111010418 68 0.290519

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

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0x111010418, srvhp=0x111011fb8, usrhp=0x111089340)

4 ETW000 115 0.290719

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 40498 0.331217

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 245 0.331462

4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 80 0.331542

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

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1017 85 0.331687

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1017) 47 0.331734

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1017 145 0.331879

4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 75 0.331954

4 ETW000 [dev trc ,00000] Info: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password.

4 ETW000 74 0.332028

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@IDU on connection 0 (nls_hdl 0) ... (dbsl 701 140910)

4 ETW000 73 0.332101

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

4 ETW000 77 0.332178

4 ETW000 [dev trc ,00000] 0 UTF8 0x110ff4740 0x11100ce38 0x11100c6e8

4 ETW000 77 0.332255

4 ETW000 [dev trc ,00000] Assigning username to user session: con_hdl=0, usrhp=0x111089340 50 0.332305

4 ETW000 [dev trc ,00000] Assigning password to user session: con_hdl=0, usrhp=0x111089340 61 0.332366

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=0x111010418, srvhp=0x111011fb8, usrhp=0x111089340)

4 ETW000 355 0.332721

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 18664 0.351385

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 202 0.351587

4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 78 0.351665

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

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1017 47 0.351769

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1017) 46 0.351815

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1017 142 0.351957

4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied

4 ETW000 75 0.352032

4 ETW000 [dblink ,00433] ***LOG BY2=>sql error 1017 performing CON [dblink#4 @ 433] 171 0.352203

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

4 ETW000 73 0.352276

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

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

volker_borowski2
Active Contributor
‎01-12-2011 6:00 PM
0 Kudos 
> 
> I can connect via $sqlplus SAPSR3/********@IDU
> I am using orcle  Instant Client 10.2.0.4.0 V3
> 
> 4 ETW000 R3trans version 6.14 (release 701 - 19.11.10 - 18:10:00).
>
> 4 ETW000  [dev trc     ,00000]  Version of '/usr/sap/IDU/SYS/exe/run/dboraslib.o' is "700.08", patchlevel (0.110)
>
> 4 ETW000  [dev trc     ,00000]  Oracle Client Version: '10.2.0.4.0', (dbsl 701 140910)                   253  0.013194

Hi,

not absolutely sure, but can there be a library missmatch somewhere?

R3trans is 7.01

dboraslib.o is 700

and the client is 701 again....

Did you run slibclean when the SAP had been stopped?

Can you do as sidadm:

sqlplus /

select * from sapuser;

exit

Check sidadm environment LIBPATH , PATH , all ORA* variables, TNS_ADMIN and the target location of TNS_ADMIN.

No idea if this is helpfull

Volker

Show replies
Show replies

Answers (2)

Answers (2)

Former Member
‎01-06-2011 6:18 AM
0 Kudos

Change the password of DB owner from BRTOOLS and try to connect.

Take a look at 400241 as mentioned in above reply.

Regards,

Nick Loy

Show replies
Show replies
audunlea_hansen
Active Participant
‎01-12-2011 10:16 AM
0 Kudos

Hi!

Be aware of change of security when upgrading from 10gR2 to 11gR2.

In 11gR2 Oracle use case sensitive passwords. In <10gR2 Oracle handle all usernames and passwords in uppercase mode.

(And password life time are default 180 days in 11gR2..)

After upgrade of database, it's a good idea to change the password to enable the new password algoritm.

Regards

Audun

Former Member
‎01-06-2011 5:34 AM
0 Kudos

Did you check SAP note 400241? This should help solve the problem.

Kind regards,

Show replies
Show replies
Ask a Question