Skip to main content

VM Templates

Let's make this page as a discussion mural for JD Edwards VM Templates.

Here you'll find any source of information about the VM Templates.

Feel free to comment and interact. Your experience is important and please share with us!

Here's the slideshow of the presentation I did at JD Edwards Summit'13 and here you'll find all information needed to install, setup, test and use the JD Edwards VM Templates.

- Gustavo Barizon



Comments

  1. Gustavo,
    as usual a very good and clear presenation.
    I can go as far as launching the VM and its console. I can login as oracle/ovsadminE1 but not as root.
    It does not recognize the password I entered while doing the ./config.sh process as per documentation in the OVM express installation guide (E54942-03)

    Any ideas ?
    thanks.
    Alain de Morais

    ReplyDelete
    Replies
    1. Thanks Alain,

      After you start the console, a script runs and the very first option is to set a password. This is the ROOT pwd.

      After you assign the IP's and hostnames, just sign as root using your passowrd.

      I tried to re-run the "config.sh" following some instructions, but it's a little bit cumbersome. I'd rather to delete the VM and re-generate it again. Then you re-enter your root password.

      Please let me know the results.

      - Gustavo

      Delete
  2. To unlock DB users:

    Slide 52
    alter [user] system account unlock

    ReplyDelete
  3. select username, account_status, expiry_date from dba_users;

    ReplyDelete
  4. SELECT DBMS_METADATA.get_ddl ('USER', 'OVR_BIPLATFORM') FROM DUAL;


    ALTER USER "OVR_BIPLATFORM" IDENTIFIED BY VALUES 'S:15142574B2C451DBA2082F0626D8788B84B860A43B98D455D06322DDC310;8EA5E5BS139D2491'




    ReplyDelete
  5. SET LINESIZE 32000;
    SET PAGESIZE 40000;
    SET LONG 50000;

    select username, account_status, expiry_date from dba_users;

    SELECT DBMS_METADATA.get_ddl ('USER', 'JDE') FROM DUAL;

    ALTER USER "JDE" IDENTIFIED BY VALUES 'S:AAFF9632CBD308B67253A2A8CA9E226F1E8F3A595E59D464F3AFD2EAC6DB;H:7166189940525CEF587AE2AA792E289E;7566DC952E73E869'

    alter user jde account unlock



    SELECT DBMS_METADATA.get_ddl ('USER', 'PS910') FROM DUAL;


    select username,account_status,to_char(EXPIRY_DATE, 'yyyy-mm-dd')Expire from dba_users;
    alter user PS910DTA identified by PS910DTA;
    alter user PS910CTL identified by PS910CTL;
    alter user PS910 identified by PS910;
    alter user TESTDTA identified by TESTDTA;
    alter user TESTCTL identified by TESTCTL;
    alter user DV910 identified by DV910;
    alter user CRPDTA identified by CRPDTA;
    alter user CRPCTL identified by CRPCTL;
    alter user PY910 identified by PY910;
    alter user PRODDTA identified by PRODDTA;
    alter user PRODCTL identified by PRODCTL;
    alter user PD910 identified by PD910;
    alter user DD910 identified by DD910;
    alter user OL910 identified by OL910;
    alter user SVM910 identified by SVM910;
    alter user SY910 identified by SY910;
    alter user PRODUSER identified by PRODUSER;
    alter user DEVUSER identified by DEVUSER;
    alter user APPLEAD identified by APPLEAD;
    alter user JDEDBA identified by JDEDBA;
    alter user JDE identified by JDE;
    alter user OVR_BIPLATFORM identified by ovsadminE1;
    alter user OVR_MDS identified by ovsadminE1;
    select username,account_status,to_char(EXPIRY_DATE, 'yyyy-mm-dd')Expire from dba_users;

    ReplyDelete
  6. select profile from DBA_USERS where username = 'JDE';

    alter profile DEFAULT limit password_life_time UNLIMITED;

    ReplyDelete
  7. select * from dba_profiles where profile='DEFAULT' and resource_type='PASSWORD';

    ReplyDelete
  8. alter profile default limit FAILED_LOGIN_ATTEMPTS UNLIMITED;

    ReplyDelete
  9. alter profile default limit PASSWORD_LOCK_TIME UNLIMITED;
    alter profile default limit PASSWORD_GRACE_TIME UNLIMITED;

    ReplyDelete
  10. select username,osuser,terminal from v$session where username is not null order by username, osuser;

    ReplyDelete
  11. SELECT 'ALTER USER '|| name ||' IDENTIFIED BY VALUES '''|| spare4 ||';'|| password ||''';' FROM sys.user$ WHERE name='ADF_IAU_APPEND';

    ReplyDelete
  12. alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;

    ReplyDelete
  13. alter profile default limit PASSWORD_LOCK_TIME UNLIMITED;

    ReplyDelete
  14. SELECT name, pdb FROM v$services ORDER BY name;


    select username, account_status, expiry_date from dba_users;



    alter session set container = JDEORCL;

    ReplyDelete

Post a Comment

Thanks for your comment!

Popular posts from this blog

JD Edwards 9.1 Standalone Installation Tutorial

Hello and welcome to JDEFUSION.com! Here's a video tutorial on how to install the newest JD Edwards 9.1 version! In only six steps and no magic, you will have your JD Edwards up and running, including the Web version! The JD Edwards team did an outstanding job on this new version and I'm proud to be the first to document in video the installation steps and show you the system working after the installation. The tutorial is divided in the following steps: Images download - E-Delivery Directory preparation Oracle 11g 32 bit installation JDE Demo installation Post installation procedures System check By following the video you'll be able to have your own JD Edwards' instance running directly in your PC or you may also install as a Virtual Machine using Oracle Virtual Box. The base OS I'm using for this tutorial is Linux and as you can see, the Virtual Box VM works fast and is also stable. Please let me know if you need some information on how to se

Tools Release 9.2.2.4

A new experience on www.innova9.io!

After almost a year, a new and redesigned web site for Innova9. With this new website, we'll be able to communicate better, educate better, and we launch a new initiative for integrations: We'are now Dell Boomi's Partner and we can build seamless integrations for on-prem, Cloud and hybrid business scenarios using JD Edwards' Orchestrator and the versatility of Dell Boomi. Also, we're launching our Products section, starting small with our JD Edwards' Sandbox installation and hosting as well as our Orchestrator Masterclass. There's more to come! Take a look at our Services: all focused on EnterpriseOne innovations, from UX One Enablement, to our new Online Help Desk, where we'll serve your Business Analysts, Power Users, and End Users with instant messages to help with UX and User Defined Objects activities. All in a super affordable price, available per user / per month on subscription base. Want more? Our articles now have a new place! Started with