3 Replies Latest reply on Feb 10, 2013 9:30 AM by Mahmoud_Rabie

    HR Schema

      Hi everybody
      I have installed Oracle Database 11g Express Edition which comes with Application Express 4.0.2.
      I want to test the HR schema..is it coming with it or I have to install it
      how can I change the HR password because I want to test the Jaspersoft (ireport)
        • 1. Re: HR Schema
          Dear BeenaIT,

          Let's assume the following:
          1)you are using Linux
          2)and your hostname is myhost
          3)and your sys password is mysyspassword
          4)the new hr password is hr

          From the command line write the following
          [oracle@myhost ~]$ sqlplus sys/mysyspassword as sysdba
          SQL*Plus: Release Production on Sun Feb 10 09:50:04 2013
          Copyright (c) 1982, 2009, Oracle.  All rights reserved.
          Connected to:
          Oracle Database 11g Enterprise Edition Release - Production
          With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,
          Data Mining, Oracle Database Vault and Real Application Testing options
          SQL> alter user hr identified by hr;
          User altered. 
          If the question is answered, please close it as answered and give the points where earned ...

          Best Regards
          • 2. Re: HR Schema
            using window 7 ?
            • 3. Re: HR Schema
              No difference, just use SQLPlus of the installed instance
              and use connect
              connect sys/mysyspassword as sysdba
              then write
              SQL> alter user hr identified by hr;
              1 person found this helpful