![[Google]]( http://www.jdesource.com/wp-content/plugins/easy-adsense-lite/google-light.gif)
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:
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):
5. Just hit Enter in the password field.
Now, we must be logged successfully in Oracle:
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:
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:
11. If everything goes fine, now we can run SQL queries with no problem in E1Local database instance:
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:
13. If you want to use Oracle SQL Developer, use these parameters:
14. Let’s check if DEMO is still working:
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!
Related Articles:
- EnterpriseOne 9.0 Standalone – Oracle Local Database Login Credentials
- Change Database values using MS Access (JDE E1 Oracle)
- Access JD Edwards EnterpriseOne 9.0 Standalone Webclient from anywhere.
- Why Choose the Oracle Technology Stack for JD Edwards EnterpriseOne Customers
- Introducing Oracle JD Edwards EnterpriseOne Mobile Expense Management
Author : Marcelo Santos
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.
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!
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
Ross,
The guide was updated, and this error could be related to memory allocation. Are you installing in a VM (Virtual Machine)?
please guide me to install 9.1 demo in windows 7 32 bit professional…..
Ravi, please look at the comments. This version is designed to run only on Windows 64.
Hi Marcelo,
Thanks for your guide, it works fine …
Please note that I modified sqlnet.ora with Notepad++, run as administrator.
Regards,
Olivier
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?
[...] Cris: I just install E1 9.1 in my machine, i worked for two days, [...]
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
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.
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
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.