«

»

Apr 06 2012

JD Edwards EnterpriseOne 9.1 DEMO Local Oracle Database Access

VN:F [1.9.22_1171]
Rating: 4.8/5 (6 votes cast)

Follow these simple steps to change the password in JD Edwards EnterpriseOne 9.1 DEMO Local Database instance.

1. Edit the file C:\Oracle\E1Local\NETWORK\ADMIN\sqlnet.ora:

fig1

The file will look like this:

# Generated by OEESETUP.EXE

SQLNET.AUTHENTICATION_SERVICES=(NONE)

NAMES.DIRECTORY_PATH=(TNSNAMES)

2. Now, change the bold line to:

# Generated by OEESETUP.EXE

SQLNET.AUTHENTICATION_SERVICES=(NTS)

NAMES.DIRECTORY_PATH=(TNSNAMES)

3. Exit and save the file

4. Log into Oracle with user sys with role sysdba, using the SQL Plus (C:\Oracle\E1Local\BIN\sqlplus.exe):

fig3

5. Just hit Enter in the password field.

Now, we must be logged successfully in Oracle:

fig4

6. Let’s change the sys password. To do that, we must use the following SQL command:

alter user sys identified by ;

changing the word <password> with the new desired password. Use the word password as example. Type the following SQL command and hit Enter:

alter user sys identified by password;

If everything goes fine, the password was changed:

fig5

7. Quit the SQL Plus (type exit and hit Enter)

8. Change the file sqlnet.ora to reflect the old values:

# Generated by OEESETUP.EXE

SQLNET.AUTHENTICATION_SERVICES=(NONE)

NAMES.DIRECTORY_PATH=(TNSNAMES)

9. Exit and save the file

10. Try to login in the E1Local instance using the user sys with role sysdba:

fig8

11. If everything goes fine, now we can run SQL queries with no problem in E1Local database instance:

fig9

12. Don’t forget to use the owner jdedata910 to run queries in normal tables. Some tables are found in another owner context: If you are using PL/SQL, you can check this in the following combo-box:

fig10

13. If you want to use Oracle SQL Developer, use these parameters:

fig12

fig13

14. Let’s check if DEMO is still working:

fig11

Yes! the changes doesn’t affect the DEMO install and now we can run SQL queries in JDE DEMO 9.1 tables.

Please do let know your comments!

Published under the license.

VN:F [1.9.22_1171]
Rating: 4.8/5 (6 votes cast)
JD Edwards EnterpriseOne 9.1 DEMO Local Oracle Database Access, 4.8 out of 5 based on 6 ratings
(Visited 3,025 times, 4 visits today)

About the author

Marcelo Santos

Over 27 years of experience in IT area, working as Oracle JD Edwards Developer with expertise in Windows Server, SQL Server and Microsoft Exchange Server, experience in Linux operating systems (Debian and Redhat), VMWare ESX / ESXi, Novell Netware, relational databases like Oracle 10/11g and backup solutions from Computer Associates. Large experience in high-end servers from Dell and HP, having the following certifications: Microsoft: MCP, MCSE, MCDBA, MCSA and MCT (2008 ~ 2013), Computer Associates: Technical Specialist – Storage and Backup Solutions, Novell: Netware 6 SMB Specialist, Compaq/HP: ASE.

21 comments

1 ping

Skip to comment form

  1. Michael Clark

    Excellent Marcelo! Five stars. We took a different route as we needed ODBC access. We did a temp change to the sys admin password (allowing us full access to the E1Local dataset), then used SQL Developer to add a new user and granted that user read-only rights to the dataset, and then reset the sys admin password back to it’s encrypted value (see Oracle KB 798943.1). So no change to the demo, but end result was a new user with a known ID having all the RO rights we needed them to have.

    VA:F [1.9.22_1171]
    Rating: +4 (from 4 votes)
    1. Marcelo Santos

      Alright! Good to know that we can do that. In the past, I had the same thought: create a new user with the required privileges, but, when I realized that this procedure doesn’t mess with already JDE Demo install, I choose that one. Thank you for the feedback, and stay tuned!

      VN:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
  2. Ross Cation

    Hello Marcelo:

    I was following your guidelines for E1 Standalon on Win 7 x64 and encountered what I consider to be a peculiar issue. At step 15 when I run the InstallManager.exe I get the pop up for the JSE Install Manager but there is no response when I attempt to launch the “E1 Database Engine”. However, I tested and can launch the other link “E910 Standalone Client”!

    I’m wondering if you can suggest a cause and possible resolution to this issue.

    Thanks,
    Ross

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
    1. Marcelo Santos

      Ross,

      The guide was updated, and this error could be related to memory allocation. Are you installing in a VM (Virtual Machine)?

      VN:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
  3. ravi

    please guide me to install 9.1 demo in windows 7 32 bit professional…..

    VN:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
    1. Marcelo Santos

      Ravi, please look at the comments. This version is designed to run only on Windows 64.

      VN:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
  4. Olivier

    Hi Marcelo,
    Thanks for your guide, it works fine …
    Please note that I modified sqlnet.ora with Notepad++, run as administrator.

    Regards,
    Olivier

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  5. Cris

    I just install E1 9.1 in my machine, i worked for two days, then start asking for the “Security Server”. Check for the logs, it says “Login” errors. How can i fixed this issue. I was using Oracle tools to do it, but still having the same problem.

    Also, is any way to use SQL Server or DB2 for the Demo?

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  6. Pawan Deep Singh

    Hello Everyone,

    After changing SQLNET.ORA as mentioned by you, when I tried to login in SQLPLUS.exe as described by you, it shows me, ORA-01031: insufficient privileges

    Please let me know, what I have done wrong or something else is required.

    Thanks & Regards

    Pawan Deep Singh

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
    1. Marcelo Santos

      Hello,

      1. Are you trying to login as SYSDBA?

      2. Did you change auth type in file as described?

      3. Did you have tried to login in Oracle via SQLPLUS only after the file has been saved?

      4. Check if you Windows user is member of Windows Group ‘Oracle DBA Group’

      5. If you are running Vista, Windows 7 or Windows 8 ensure that UAC has been disabled.

      Let we know if one of these steps solve you problem.

      VN:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
      1. Pawan Deep Singh

        Hello,

        Thanks for your reply…

        Yes is the answer for your all questions except Q4.

        Please let me know, how can I check if my windows User is member of windows group ‘Oracle DBA Group’? And if not associated, how can I associate my Windows User with this group…

        Regards

        Pawan Deep Singh

        VA:F [1.9.22_1171]
        Rating: 0 (from 0 votes)
        1. Marcelo Santos

          Pawan,

          Right Click in Computer, and select Manage. Them, look for Local Users and Groups (or something like that… I’m using Windows 8 Pro, and some information could be changed).

          There, you can check these information.

          Regards,

          Marcelo.

          VN:F [1.9.22_1171]
          Rating: +1 (from 1 vote)
  7. rjcrock

    Hi,

    My avast virus protection has deleted my activConsole.exe file even though it was included in the avast list of files not to scan. Wondering if anyone else has ever encountered this before and how did you resolve this issue?

    Thanks for any and all suggestions.

    VN:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  8. rjcrock

    Do I just need a new copy of activConsole.exe? If this is the case could someone send me a copy?

    VN:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  9. kanwal

    I am done with the installation part JD edwards is there ,Local Database is running,
    But now how to see that data in JD Edwards from E1Local.
    When i look for any record,it is empty
    I will really appreciate your help
    Thanks
    Kanwal

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
    1. Deepesh M Divakaran

      Hi Kanwal,
      Where & how are you searching for the data?

      VN:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
  10. Amol

    Hi Marcello,

    Thanks for sharing this. I am stuck at step 10. Could you please assist me to locate E1 Local instance on my machine. I have installed JDE E1 standalone 9.1.

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  11. San

    Hi, thanks for the valuable post. I am having total more than 100 users who are using JDE demo 9.1 version but as per company policy, we want to restrict the users to enable the local admin access of machine. However, JDE Demo 9.1 can not run without admin privileges. Can you please help to execute JDE demo without local admin rights….thnx.

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
    1. Deepesh M Divakaran

      Hi San,

      You could try either of these. I have not tried them myself.
      First, You will have to grant All access to the JDE folders. Then create shortcut to ActiveConsole.exe with Always Run as Administrator ticked (advanced area). You may have to specify the credentials upfront.
      OR
      You could try – http://www.robotronic.de/runasspcEn.html

      VN:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
  12. Andriy

    Very well written!

    It worked for me though I configured the connection using TOAD for Oracle.

    Thank you for the article.

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  13. Djohnson

    Appears to work with 9.2 Installation as well.

    VN:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  1. JD Edwards EnterpriseOne 9.1 DEMO Installation | JDE Source

    […] Cris: I just install E1 9.1 in my machine, i worked for two days, […]

Leave a Reply