oracleoracle-11g-r2
According to Document 745809.1, Installing Csscan.
While running the "Csminst.sql" we are getting below error
SQL> @$ORACLE_HOME/rdbms/admin/csminst.sql
create user csmig identified by csmig password expire account lock
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
you should create at least one database user that you will use to create database objects. A database user is a type of database object: a user is associated with a database schema, you connect to the database as a database user, and the database user is the owner of any database objects (tables and so on) that you create in the schema associated with the user.
For example, to create a database user named chris(For Example). Follow these steps, using the command line:
Display the SQL command prompt window. For example, on Windows, click Start, then Programs (or All Programs), then Oracle Database 11g Express Edition, and then Run SQL Command Line.
Connect as the SYSTEM user:
Type: connect Enter user-name: system Enter password: Create the user. For example, enter a statement in the following form:
SQL> create user chris identified by <password-for-chris>;
Grant the user the necessary privileges. For example:
SQL> grant CREATE SESSION, ALTER SESSION, CREATE DATABASE LINK, -
CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM, -
CREATE ROLE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, -
CREATE TRIGGER, CREATE TYPE, CREATE VIEW, UNLIMITED TABLESPACE -
to chris;
Optionally, exit SQL*Plus (which also closes the command window):
SQL> exit
SQL Developer as an Alternative for Creating Database Users:
If you have experience with SQL Developer, you can use it instead of the command line to create a database user, as follows:
Create a database connection for the SYSTEM user.
Open that database connection for the SYSTEM user.
Right-click the Other Users node in the Connections navigator under that connection.
Select Create User, and specify the necessary information. (Under System Privileges, grant ALTER SESSION, CREATE SESSION, CREATE DATABASE LINK, CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM, CREATE ROLE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIEW, and UNLIMITED TABLESPACE.)
I am also attaching the screen shot with example , which is given by Oracle BOL for SQL Developer connection.
I will write the solution here for those who might encounter such error in the future.
I solved the error by re-compiling invalid objects.
Best Answer
You can just edit the file
$ORACLE_HOME/rdbms/admin/csminst.sqland changeidentified by csmigfromcsmigto a more complex password; you may have to enclose the password with double quotes if you have characters other than alphanumeric, underscore (_), dollar sign ($) or pound/hash sign (#).Example: