Can not login to server from workstation

[Quan Zongliang]

Hi, guys.

Three server had been installed(Windows 2003):
JDEDS - Management Console
JDEES - Enterprise Server
JDEOAS - Oracle Application Server & EnterpriseOne HTML Server

Solution explorer in JDEDS works fine.
But when I install a workstation to another computer(Windows-XP), it can not connect to server. Always prompt me "Database Password Entry" dialog.

jde.log
420/3000 MAIN_THREAD Tue Sep 14 17:39:54.062000 Jdb_ctl.c4065
Starting OneWorld

420/3000 MAIN_THREAD Tue Sep 14 17:39:59.218000 dbinitcn.c899
OCI0000065 - Unable to create user session to database server

420/3000 MAIN_THREAD Tue Sep 14 17:39:59.218001 dbinitcn.c904
OCI0000141 - Error - ORA-01017: invalid username/password; logon denied

420/3000 MAIN_THREAD Tue Sep 14 17:40:56.953000 dbinitcn.c899
OCI0000065 - Unable to create user session to database server

420/3000 MAIN_THREAD Tue Sep 14 17:40:56.953001 dbinitcn.c904
OCI0000141 - Error - ORA-01017: invalid username/password; logon denied

420/3000 MAIN_THREAD Tue Sep 14 17:41:00.062000 dbinitcn.c899
OCI0000065 - Unable to create user session to database server

420/3000 MAIN_THREAD Tue Sep 14 17:41:00.078000 dbinitcn.c904
OCI0000141 - Error - ORA-01017: invalid username/password; logon denied

jdbj.ini
[JDBj-BOOTSTRAP SESSION]
user=JDE
password=
environment=DV900
role=*ALL

[JDBj-BOOTSTRAP DATA SOURCE]
name=System - 900
databaseType=O
server=JDEES
serverPort=1521
database=JDE
physicalDatabase=
owner=SY900
lob=true
unicode=true
databaseInstance=

tnsnames.ora
E1LOCAL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = JDEDS)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = E1Local)
)
)

ODBC only has "OneWorld ODA" in system DSN

Any suggestion is welcome. Thank you.

 

[AlexRO]

Hello,

First, I have to ask you, is this the tnsnames from the client or the DS. If this is the client correct the entry in your E1Local connection. See that the machine is not JDEDS but your local machine name, and add the connection to the enterprise server.

Second: I got the error mentioned after i have decrypted the password from my local database and did not re encrypt before login

.

Cheers,
Alex.

 

[Quan Zongliang]

full tnsnames.ora file:
# tnsnames.ora Network Configuration File: D:\oracle\E1Local\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

JDE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jdees)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jde)
)
)

E1LOCAL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = JDEDS)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = E1Local)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

never modify it and local database after installation.
same file locate in C:\Oracle\E1Local\NETWORK\admin
and I never decrypt local database password

Just now, I try to decrypt passwrod with ReconfigureMSDE.exe(jde.log):
2200/3384 MAIN_THREAD Tue Sep 21 14:00:29.765000 oradbapi.c327
ORADB0051 - oradbChangeUserPwd failed for user SYSTEM

2200/3384 MAIN_THREAD Tue Sep 21 14:00:29.812000 oradbapi.c329
ERROR:
ORA-01017: invalid username/password; logon denied

SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus

try to encrypt(jde.log):
2200/3384 MAIN_THREAD Tue Sep 21 14:03:09.750000 oradbapi.c327
ORADB0051 - oradbChangeUserPwd failed for user SYSTEM

2200/3384 MAIN_THREAD Tue Sep 21 14:03:09.765000 oradbapi.c329
ERROR:
ORA-01017: invalid username/password; logon denied

SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus

 

[AlexRO]

Hello again,

I still don't understand if this is your client or deployment server. You said you can start solution explorer from the deployment server, and you can't connect from your client. I'm still seeing that the E1Local is connecting to the deployment server:

[ QUOTE ]
E1LOCAL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(<font color="red"> HOST = JDEDS </font>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = E1Local)
)
)

[/ QUOTE ]

Change the JDEDS with 127.0.01 and try it again.

Regards.
Alex.

 

[eSky]

[ QUOTE ]
full tnsnames.ora file:
# tnsnames.ora Network Configuration File: D:\oracle\E1Local\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

JDE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jdees)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jde)
)
)

E1LOCAL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = JDEDS)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = E1Local)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

never modify it and local database after installation.
same file locate in C:\Oracle\E1Local\NETWORK\admin
and I never decrypt local database password




Your Tnsnames.ora shows path as - D:\oracle\E1Local\network\admin\tnsnames.ora
and below you have mentioned path as C:\Oracle\E1Local\NETWORK\admin

you have to re-check tnsnames.ora file