cancel
Showing results for 
Search instead for 
Did you mean: 

Database: > ORA-01017: invalid username/password; logon denied

former_member186190
Participant
0 Kudos

Hi Basis team

I have Installed separate instance server for MY production system . Installed IN MY PI system. But when starting instance i am getting below message. in event logs.

Database: > ORA-01017: invalid username/password; logon denied

I created same Production sid adm user to new instance server.and try to start instance with this user but not starting dispatcher.

1-Both are same Database.

2-Production is Ecc6 and newly instance installed system is netviwer system.

3- Production same user id created in PI system

4-Both system are in Domain level

5- production system in MS cluster .

6- ECC production SID adm is Domain level user.

7- I installed new instance with Administrator Powr.

Newly created user getting R3trans -d error as follows.

=========================

C:\Users\gepadm.GEEPASPIQUA>r3trans -d

This is r3trans version 6.14 (release 701 - 23.07.10 - 09:23:00).

unicode enabled version

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

E_SID = 'GEP'"

r3trans finished (0012).

=======================================================================

Advance thanks By Engli

Accepted Solutions (1)

Accepted Solutions (1)

former_member189725
Active Contributor
0 Kudos

Please change the password of schema user using brtools. Should resolve your problem.

former_member186190
Participant
0 Kudos

Hi

this not helped,

former_member186190
Participant
0 Kudos

Hi Ratnajit Dey

I have changed password but not helped, and i reverted back but after that i am facing problem with java engin dispatcher is not connceting. ill paste the message pls clear me.

sys Log = Operation trace: Event handler: Event SAP_SYSTEM_START_VMC is not defined

developer Trace it showing:

==================================

Sun Dec 04 10:12:07 2011

J2EE server info

start = TRUE

state = STARTED

pid = 5236

argv[0] = D:\usr\sap\GPQ\DVEBMGS00\exe\jstart.EXE

argv[1] = D:\usr\sap\GPQ\DVEBMGS00\exe\jstart.EXE

argv[2] = pf=D:\usr\sap\GPQ\SYS\profile\GPQ_DVEBMGS00_GEEPASPIQUA

argv[3] = -DSAPSTART=1

argv[4] = -DCONNECT_PORT=64949

argv[5] = -DSAPSYSTEM=00

argv[6] = -DSAPSYSTEMNAME=GPQ

argv[7] = -DSAPMYNAME=GEEPASPIQUA_GPQ_00

argv[8] = -DSAPPROFILE=D:\usr\sap\GPQ\SYS\profile\GPQ_DVEBMGS00_GEEPASPIQUA

argv[9] = -DFRFC_FALLBACK=ON

argv[10] = -DFRFC_FALLBACK_HOST=localhost

start_lazy = 0

start_control = SAP J2EE startup framework

DpJ2eeStart: j2ee state = STARTED

DpJ2eeLogin: j2ee state = CONNECTED

Sun Dec 04 10:12:13 2011

***LOG Q0I=> NiIRead: P=127.0.0.1:54689; L=???: recv (10054: WSAECONNRESET: Connection reset by peer) [nixxi.cpp 4939]

      • ERROR => NiIRead: SiRecv failed for hdl 57/sock 1148

(SI_ECONN_BROKEN/10054; I4; ST; P=127.0.0.1:54689; L=???) [nixxi.cpp 4939]

DpJ2eeMsgProcess: j2ee state = CONNECTED (NIECONN_BROKEN)

DpIJ2eeShutdown: send SIGINT to SAP J2EE startup framework (pid=5236)

      • ERROR => DpProcKill: kill failed [dpntdisp.c 396]

DpIJ2eeShutdown: j2ee state = SHUTDOWN

Thanks Reg

engli

former_member188883
Active Contributor
0 Kudos

Hi,

Could you share the ouput of R3trans -d as well as R3trans -x

Regards,

Deepak Kori

former_member186190
Participant
0 Kudos

Hi deepakkori

C:\Users\gpqadm>r3trans -d

This is r3trans version 6.19 (release 711 - 19.01.11 - 11:44:00).

unicode enabled version

r3trans finished (0000).

C:\Users\gpqadm>r3trans -x

This is r3trans version 6.19 (release 711 - 19.01.11 - 11:44:00).

unicode enabled version

r3trans finished (0000).

this is the R3 trans output. still my Java engin not connection, its not synchronous abap

Former Member
0 Kudos

Make sure you have SAPUSER table , if not create it and incert the password in the table

Command :

create table SAPUSER ( USERID VARCHAR(256), PASSWD VARCHAR2(256) );

and then insert the schema name and password.

once you do that get into sqlplus/brtools and change the schema(SAPSR3/SAPR3) password to the one that you inserted in the table.

Try a R3trans -d after that.

former_member186190
Participant
0 Kudos

|Dear GerardChristopher

Please Understand what is My problem 1st. these problem with MY XI quality system. it was working system Until yesterday. i had in stalled additional instance server for ECC production to this system. after that i have changed the password of existing XI quality database through brtools. and i reverted back. after that my XI quality system java engine is not synchronizing with abap library it means there is some password maintenance issue in java which is not matching with abap. so i want to know when i can change the password of java engine.

THanks

Engli

Former Member
0 Kudos

Hello

Have you checked whether database user locked or expired. Please check the following from sql prompt.

select username, account_status from dba_users;

Did you change the password witht he following command

brconnect u2013c u2013f chpass u2013u <user_name> u2013p <new_password>.

Regards,

Rajan

former_member186190
Participant
0 Kudos

Dear Rajan Narayanan

Thanks you so much the reason was Account Locked SAPSR3DB user.

Once again thanks to everybody who is supported with me.

Thanks Reg

Engli

http://www.facebook.com/yoonuschangoth

Answers (1)

Answers (1)

former_member188883
Active Contributor
0 Kudos

Hi,

Please change the environment variable dbs_ora_schema=SAP<SID>

Where <SID> is your new system SID.

Hope this helps.

Regards,

Deepak Kori