StandAlone 9.0 w/oracle

[knoxjr]

First thing, I looked up all the prior posts I could find for Standalone 9.0 - thanks to all. Then downloaded and installed the product. New getting the infamous 'waiting for security server' messge. JDE debug seems to show that thing go ok until it trys to access the DB (below).

Found Oracle database version info:
SQL*Plus: Release 10.2.0.3.0 - Production
Database driver name is 'jdboci101.DLL'
Exited CreateCriticalSections_oracle with ref cnt 1
ORACLE DBInitDrv envr=05AFBAF8
ORACLE DBInitCon - Database server version is 'Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production'
ORACLE DBInitCon envr=05AFBAF8 conn=05BAEB38 localhost A (SYSTEM@E1Local) V102 Unicode=Y (srvrusers=1) 1
Exiting JDB_OpenTable(Table = F986101) with Success
Entering JDB_SetSelectionX
Exiting JDB_SetSelectionX With Success
Entering JDB_SelectKeyed
ORACLE DBInitReq conn=05BAEB38 requ=05C44908 localhost (E1Local) new [ 1]
SELECT OMENHV, OMAPPLID, OMOBNM, OMDATP, OMDATS, OMUGRP, OMOAPP, OMDATM,
OMOVRE, OMSY, OMSTSO, OMFUNO, OMOCM2, OMOCMDSC FROM JDESY900.F986101
WHERE ( OMENHV = 'DEMO900' AND OMSTSO = 'AV' AND OMFUNO = 'TBLE' AND OMOBNM = 'F95921' AND OMUGRP = 'DEMO' )
ORDER BY OMSTSO ASC,OMAPPLID ASC
OCI0000178 - Unable to execute - SELECT OMENHV, OMAPPLID, OMOBNM,
OMDATP, OMDATS, OMUGRP, OMOAPP, OMDATM, OMOVRE, OMSY, OMSTSO, OMFUNO, OMOCM2, OMOCMDSC
FROM JDESY900.F986101 WHERE ( OMENHV = :KEY1 AND OMSTSO = :KEY2 AND OMFUNO = :KEY3 AND OMOBNM = :KEY4 AND OMUGRP = :KEY5 ) ORDER BY OMSTSO ASC,OMAPPLID ASC
OCI0000179 - Error - ORA-00942: table or view does not exist
JDB9900170 - Failed to execute db request

So now I'm stumped, assume the password is same as id, if not then what is it? Tired to get at db through SQL*PLUS but keeps getting hung up needing a userid/password. also tried useing the oracle database configuration assistant, but again don't know any user id and passwords. Are SYS and SYSTEM still valid? if so what are the passwords.

Is there another check, or way to determine if the db is in fact installed?

thanks in advance
jerry

 

[astroie]

Hi,

Have you found out the sys or system password for the E1local Oracle database?

I have jdedata900, jdesy900 and jdectl900 (with same password) but not on them are admin...

Thanks and regards,
Adrian

 

[astroie]

Found a post in the JDE list which solved my issue.



Re: JD Edwards E9.0 Standalone Oracle Database Access
#145880 05/14/09 03:03 AM
Edit post Edit Reply to this post Reply Reply to this post Quote


You can also use user:JDEDATA900 PASSWORD:JDEDATA900 to access, or JDEDD900@JDEDD900 JDECTL900@JDECTL900 etc. except JDE@JDE.

I have no the default password for sys, but can revise the password for sys,
1. replace the first line in sqlnet.ora (d:\Oracle\E1Local\NETWORK\ADMIN):
SQLNET.AUTHENTICATION_SERVICES=(NTS)

2. restart Oracle Services

3. Start -->Run --> CMD

sqlplus /nolog

connect / as sysdba

alter user sys identified by oracle --This "oracle" is password for sys

 

[JohnnyCNC]

Thanks very much for posting this procedure. We've been strugling with this problem for days and your proc worked great. We can now build packages again.