Video Screencast Help

Issue with Oracle 11G

Created: 27 Apr 2011 • Updated: 27 Apr 2011 | 3 comments
This issue has been solved. See solution.

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.

Discussion Filed Under:

Comments 3 CommentsJump to latest comment

Keith Reynolds - ExchangeTek's picture

Any chance your using any special characters within the password you're specifying for the PROTECT user?  Depending on the character you use in there, that could cause the ORA-00922 error your seeing.  For instance, if you use a comma, it will cause this error.

The first error is fine:

ORA-01918: user 'PROTECT' does not exist

It's trying to drop the PROTECT user, which isn't in there yet...that's expected.

The second error:

ORA-00922: missing or invalid option

...causes the PROTECT user to not get created.  Then all the subsequent errors are because of that one.

 

I'm guessing it's due to special characters in the password.  Oracle doesn't allow a bunch of characters because they're reserved for other uses in Oracle (i.e. the @ symbol, commas, etc).

 

~Keith

SOLUTION
A. De Monaco's picture

Thanks for the help on this Keith.  Much appreciated.

ethlang's picture

You awesome, Keith!  I have been troubleshooting for my 10g for several hours or day and found your comment very helpful.