What username & password should be entered when connecting to SQL*Plus after installing Oracle 11g?

Question

I have installed Oracle 11g on Windows 7

When I start sqlplus, it ask me for a username and password

Can anybody tell me what username needs to be inserted and when I try to type in any password, it doesn't allow me to type a single letter. Is there a reason why?

Solution 1

If you've forgotten the password for any user then you can reset by logging in as SYS:

sqlplus / as sysdba

And then:

alter user <username> identified by <password>;

If you've forgotten which users you have then you can run:

select username from all_users;

If you have only recently created the database it would be worthwhile restricting on CREATED, as the default database install comes with dozens of its own schemas. For instance, to find users added in the last week run this:

select * from all_users
where created > trunc(sysdate)-7;

Solution 2

Enter SYSTEM as user-name and the password entered during installing 11g works well for me!

Comments

[William Kinaan]

i tried to use sqlplus / as sysdba as username what is its password please?

[John Doyle]

There is no password for this. It works if you're logged in as the oracle user or as a member of the dba group. For Windows it works if your user is an Administrator.