I am having an issue with the installation of Oracle 11G on a DEV environment. When Creating the Oracle user account for Symantec Data Loss Prevention (pg20 in Oracle 11g Installation Guide) I am running into an error stating:
SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 27 12:22:31 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> @oracle_create_user.sql
Please enter the password for sys user:
Please enter sid:protect
Please enter required username to be created : protect
Please enter a password for the new username:
Connected.
Profile altered.
DROP USER protect
*
ERROR at line 1:
ORA-01918: user 'PROTECT' does not exist
CREATE USER protect IDENTIFIED BY XXXXXX
*
ERROR at line 1:
ORA-00922: missing or invalid option
ALTER USER protect DEFAULT TABLESPACE users
*
ERROR at line 1:
ORA-01918: user 'PROTECT' does not exist
ALTER USER protect TEMPORARY TABLESPACE temp
*
ERROR at line 1:
ORA-01918: user 'PROTECT' does not exist
TO protect
*
ERROR at line 8:
ORA-01917: user or role 'PROTECT' does not exist
TO protect
*
ERROR at line 10:
ORA-01917: user or role 'PROTECT' does not exist
GRANT create materialized view TO protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
GRANT unlimited tablespace TO protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
grant select on dba_tablespaces to protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
grant select on dba_data_files to protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
grant select on dba_temp_files to protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
grant select on dba_extents to protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
grant select on v_$session to protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
grant select on v_$database to protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
grant select on v_$instance to protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
grant all on dbms_monitor to protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
grant select on v_$parameter to protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
grant select on dba_segments to protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
grant select on v_$sqlarea to protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
grant select on v_$session_longops to protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
GRANT SELECT ON v_$sql TO protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
GRANT SELECT ON v_$sql_plan TO protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
GRANT SELECT ON v_$sql_plan_statistics_all TO protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
GRANT EXECUTE ON dbms_session TO protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
grant execute on dbms_lock to protect
*
ERROR at line 1:
ORA-01917: user or role 'PROTECT' does not exist
Disconnected from Oracle Database 11g Release 11.2.0.1.0 - Production
Does anyone have any ideas on have any ideas as to what may be causing the issues. To this point I have not had any issues with the installation.