8 Replies Latest reply: Feb 4, 2014 10:37 PM by slrcst RSS

    Hello Members Please Help Error Installing Sample Schemas (HR)

    jlsampedro

      Hi members, and thank you for your help.

      After much mulling I have installed Oracle 12c (64b) on my Windows 7 64b SP.

      Apparently everything is working fine, I can access both from the web (EM Express) an SQL Plus as SYS for example.


      -----------------------------------------------------------------------------------------------------------------------------------------------------------------------

      he probelma is:

      I downloaded and unzipped winx64_12c_examples and have installed correctly.

      I have verified that you have added the files in the respective folders.

      For example, in C: \ Oracle12c \ product \ 12.1.0 \ dbhome_1 \ demo \ schema \ human_resources I have the 10 files.

      12/10/2002 19:27 1,173 hr_analz.sql
      29/08/2002 14:29 2,825 hr_code.sql
      29/08/2002 14:29 7,387 hr_comnt.sql
      29/08/2002 14:29 9,718 hr_cre.sql
      29/08/2002 14:29 16,439 hr_dn_c.sql
      Hr_dn_d.sql 934 29/08/2002 14:29
      29/08/2002 14:29 1,196 hr_drop.sql
      29/08/2002 14:29 1,410 hr_idx.sql
      27/05/2011 11:25 3,368 hr_main.sql
      15/08/2008 18:12 46,647 hr_popul.sql
                     10 files 91 097 bytes


      -------------------------------------------------------------------------------------------------------------------------------------------------------------------------


      Now I come to install the samples as indicated in the link:

      http://docs.oracle.com/cd/E16655_01/server.121/e15979/installation.htm


      The inputs...

      SQL * Plus: Release 12.1.0.1.0 Production on Tue Sep 6 1:21:36 2013

      Copyright (c) 1982, 2013, Oracle. All rights reserved.

      Enter the user name: sys as sysdba
      Enter the password ± to:

      Connected to:
      12c Oracle Database Enterprise Edition Release 12.1.0.1.0 - 64bit Production
      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt
      ions

      SQL> @? / Demo / schema / human_resources / hr_main.sql

      specify password for HR as parameter 1:
      Enter a value for 1: passw

      specify default tablespeace for HR as parameter 2:
      Enter a value for 2: users

      specify temporary tablespace for HR as parameter 3:
      Enter value for 3: temp

      specify password for SYS as parameter 4:
      Enter value for 4: passw

      specify log path as parameter 5:
      Enter a value for 5: C: \ Oracle12c \ product \ 12.1.0 \ dbhome_1 \ demo \ schema \ log\


      -----------------------------------------------------------------------------------------------------------------------------------------


      The output is full of errors and seems not to have done anything ... ?

      However, if I have created the LOG in the right direction.

      Below I put the full LOG output.


      ===============================================================================

      C:\Oracle12c\product\12.1.0\dbhome_1\demo\schema\log\hr_main.log

      ===============================================================================

       

      DROP USER hr CASCADE
               
      *
      ERROR at line 1:
      ORA- 01918 : user ' HR ' does not exist


      CREATE USER hr IDENTIFIED BY passw
                 
      *
      ERROR at line 1:
      ORA- 65096 : user or role name shared Invalid


      ALTER USER hr DEFAULT TABLESPACE users
                
      *
      ERROR at line 1:
      ORA- 01918 : user ' HR ' does not exist


      ALTER USER hr TEMPORARY TABLESPACE temp
                
      *
      ERROR at line 1:
      ORA- 01918 : user ' HR ' does not exist


      GRANT CREATE SESSION , CREATE VIEW, ALTER SESSION , CREATE SEQUENCE TO hr
                                                                          
      *
      ERROR at line 1:
      ORA- 01917 : user or role ' HR ' does not exist


      GRANT CREATE SYNONYM , CREATE DATABASE LINK , RESOURCE, UNLIMITED TABLESPACE TO hr
                                                                                    
      *
      ERROR at line 1:
      ORA- 01917 : user or role ' HR ' does not exist


      Online .
      GRANT execute ON TO hr sys.dbms_stats
                                        
      *
      ERROR at line 1:
      ORA- 01917 : user or role ' HR ' does not exist


      ERROR :
      ORA- 01017 : invalid username / password , logon denied


      Warning :no longer connected to ORACLE !
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      Creating ****** REGIONS table ....
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      Creating table COUNTRIES ****** ....
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      Creating ****** LOCATIONS table ....
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      Creating ****** DEPARTMENTS table ....
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      Creating ****** JOBS table ....
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      Creating ****** EMPLOYEES table ....
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      Creating ****** JOB_HISTORY table ....
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      Creating ****** EMP_DETAILS_VIEW view ...
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      Populating ****** REGIONS table ....
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      Populating ****** countires table ....
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      Populating ****** LOCATIONS table ....
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      Populating ****** DEPARTMENTS table ....
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      JOBS ****** Populating table ....
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      Populating ****** EMPLOYEES table ....
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      JOB_HISTORY ****** Populating table ....
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0640 : Not connected
      SP2 -0641 : " EXECUTE " requires connection to the server


      ------------------------------------------------------------------------------------------------------------------------------------------------------------------ END


      Thats is all, I think ....


      So here I come, continued searching google and forums but can not find a solution to this problem.

      Please appreciate any help with this, I need the sample database running.

      Thank you very much in advance and good luck.


        • 1. Re: Hello Members Please Help Error Installing Sample Schemas (HR)
          DK2010

          Hi,

           

          seems you are connected with CDB, can you try this after connect with PDB. by default in CDB users name should be prefix  with c#

          • 2. Re: Hello Members Please Help Error Installing Sample Schemas (HR)
            sybrand_b

            Apart of the remark by DK2010, a password of 'passw' may be considered invalid by the default password checking function.

            *All* of your errors are the result of the CREATE USER statement failing!

             

            -------------

            Sybrand Bakker

            Senior Oracle DBA

            • 3. Re: Hello Members Please Help Error Installing Sample Schemas (HR)
              jlsampedro

              Sorry, I forgot to clarify that replaced the actual password for the word "passw" to put it in the forum.

              The password that I use is something like Oracle79 ...

              That meets the basic criteria of the system.

              ---------------------------

              Following the track that gave me DK2010


              I'm reading the documentation on CBD and PDB like and working with SQLPlus commands related, but still have not resolved the problem...


              If someone can give me some clue but I appreciate it, as it resolved I'll post to the forum.

              Thank you very much and greetings to all.

              • 4. Re: Hello Members Please Help Error Installing Sample Schemas (HR)
                jlsampedro

                I add the output of this command if you can help, I'm researching this line ...

                 

                SQL> SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;

                 

                 

                NAME         CON_ID       DBID    CON_UID GUID

                -------- ---------- ---------- ---------- --------------------------------

                CDB$ROOT          1 1698430481          1 615F41223B2E4E08A704DD1EBBD46056

                PDB$SEED          2 4067944769 4067944769 E160D5A464A14A0886B5732108E7C19C

                PDBORCL           3 2272477227 2272477227 93E00FF969854EA0927EA52E0417009A

                 

                SQL>

                 

                Thanks

                • 5. Re: Hello Members Please Help Error Installing Sample Schemas (HR)
                  jlsampedro

                  More info, thanks.

                   

                  SQL> COLUMN PDB_NAME FORMAT A15

                  SQL>

                  SQL> SELECT PDB_ID, PDB_NAME, STATUS FROM DBA_PDBS ORDER BY PDB_ID;

                   

                      PDB_ID PDB_NAME        STATUS

                  ---------- --------------- -------------

                           2 PDB$SEED        NORMAL

                           3 PDBORCL         NORMAL

                   

                  SQL> COLUMN NAME FORMAT A15

                  SQL> COLUMN RESTRICTED FORMAT A10

                  SQL> COLUMN OPEN_TIME FORMAT A30

                  SQL>

                  SQL> SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDBS;

                   

                  NAME            OPEN_MODE  RESTRICTED OPEN_TIME

                  --------------- ---------- ---------- ------------------------------

                  PDB$SEED        READ ONLY  NO         06/09/13 00:21:59,498

                  PDBORCL         MOUNTED

                   

                  SQL>

                  • 6. Re: Hello Members Please Help Error Installing Sample Schemas (HR)
                    jlsampedro

                    NEW ... LAST CHANGES !!

                     

                    I changed the PDB, which appeared as mounted pdborcl been open with the command:

                     

                    ---


                    alter pluggable database pdborcl open;

                     

                    ---

                     

                    SQL> connect system/oracle@localhost:1521/pdborcl as sysdba
                    Conectado.
                    SQL> SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDBS;

                     

                    NAME                           OPEN_MODE  RES
                    ------------------------------ ---------- ---
                    OPEN_TIME
                    ---------------------------------------------------------------------------
                    PDBORCL                        READ WRITE NO
                    06/09/13 20:54:33,875

                     

                    And now I repeat the process ...

                     

                    SQL> @? / Demo / schema / human_resources / hr_main.sql

                    specify password for HR as parameter 1:
                    Enter a value for 1: passw

                    specify default tablespeace for HR as parameter 2:
                    Enter a value for 2: users

                    specify temporary tablespace for HR as parameter 3:
                    Enter value for 3: temp

                    specify password for SYS as parameter 4:
                    Enter value for 4: passw

                    specify log path as parameter 5:
                    Enter a value for 5: C: \ Oracle12c \ product \ 12.1.0 \ dbhome_1 \ demo \ schema \ log\

                     

                    And The output  of the log has been changed !!!!

                     

                    ===============================================================================

                    C:\Oracle12c\product\12.1.0\dbhome_1\demo\schema\log\hr_main.log

                    ===============================================================================

                     

                    User deletion.

                    User created .

                    User changed.

                    User changed.

                    Grant finished properly.

                    Grant finished properly.

                    Online .
                    GRANT execute ON TO hr sys.dbms_stats
                                                      
                    *
                    ERROR at line 1:
                    ORA- 01917 : user or role ' HR ' does not exist

                    ERROR :
                    ORA- 01017 : invalid username / password , logon denied

                    Warning :no longer connected to ORACLE !
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    Creating ****** REGIONS table ....
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    Creating table COUNTRIES ****** ....
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    Creating ****** LOCATIONS table ....
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    Creating ****** DEPARTMENTS table ....
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    Creating ****** JOBS table ....
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    Creating ****** EMPLOYEES table ....
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    Creating ****** JOB_HISTORY table ....
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    Creating ****** EMP_DETAILS_VIEW view ...
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    Populating ****** REGIONS table ....
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    Populating ****** countires table ....
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    Populating ****** LOCATIONS table ....
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    Populating ****** DEPARTMENTS table ....
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    JOBS ****** Populating table ....
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    Populating ****** EMPLOYEES table ....
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    JOB_HISTORY ****** Populating table ....
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0640 : Not connected
                    SP2 -0641 : " EXECUTE " requires connection to the server

                     

                    ------------------------------------------------------------------------------------------------------------------------------------------------

                     

                    we move forward

                    Comments are welcome


                    Thanks again !


                    • 7. Re: Hello Members Please Help Error Installing Sample Schemas (HR)
                      Dude!

                      A bit late, but anyone else who runs into the problem - you might want to check the following:

                       

                      Re: ORA-65096 installing Oracle 12cR1 Example Schemas

                      • 8. Re: Hello Members Please Help Error Installing Sample Schemas (HR)
                        slrcst

                        I hope it's okay to do this, but after google brought me here for the same issue (trying to install the example schemas after having installed 12c, and Dude!'s fix worked for me.

                         

                        As a side note for Solaris 11.1 users doing this fix, since Solaris can't sed -i (it's a GNU thing apparently), the hr_main.sql is edited so that:

                         

                        sys/&pass_sys -> sys/&pass_sys@pdborcl

                        hr/&pass -> hr/&pass@pdborcl

                         

                        I'd note that in the linked thread, but that has been locked. But I followed the directions in that thread and the thing ran without a problem.

                         

                        Thanks again Dude! for the fix, and for being kind enough to answer via email.