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.