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

    HR Schema

    prog
      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
          Mahmoud_Rabie
          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 11.2.0.1.0 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 11.2.0.1.0 - 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
          Mahmoud
          • 2. Re: HR Schema
            prog
            using window 7 ?
            • 3. Re: HR Schema
              Mahmoud_Rabie
              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;