How to Configure Oracle in Windows 8

Oracle installation:

• Double click on setup.exe file.
• Oracle installer automatically checks requirements.

First screen to ask for input:
Provide email and password if you need notification and if not just click on next.

From here oracle installization starts:

Choose options

• Create and configure a database
• click on next

Choose option

• laptop
• desktop
• click on next 

Form fillup option:

• Global database name: orcl or change the database name if you dont want to install other oracle product. Better dont change default name.
• Administrative password: Oracle has more than 20 user sys and system.
• system user resize inside a database.
• sys is administrator.
• choose strong password which you could remember.
•  Note read the warning message.
• Click on Next.
• it takes few time as it checks the requirement.
• Click on finish.
• Note after you click finish Here the real installation takes place.

Click on password management

• Change the HR user password here.

SQL Plus is the environment to communicate withe the databae.
It contain sql.exe file

Logging into database:

• Load SQL Plus: Double click on sqlplus or in command prompt write sqlplus.
• Type the username : It may be sys / system / etc.
• Type password: It is case sensitive.
• If your password is correct you will see the SQL environment.

Unlocking account:

• Use the sql command
• ALTER USER <username>
• ACCOUNT UNLOCK
• eg:
1. ALTER USER hr
2. ACCOUNT UNLOCK
3. ;

Changing Password:

• Use Sql command
• ALTER USER <username>
• IDENTIFIED BY <password>
• eg
• Alter user hr identified by hr;

You can unlock account and change the password by same sql command.
 eg: Alert user hr account unlock identified by hr;

Starting oracle:
enter user name: hr
Enter password: ********
Then follow above step to unlock account;

Here error message displays because only admin have authority to unlock accounts.
Again type:
SQL > connect
Enter user-name system
Enter password: **************;

Alternate way,
type connect system
Enter password:**********;
User is logged in;

Alternate way,
Connect user name /password;

Use alter command to chane the password and unlock the user...

show user:
it shows user connected to database.

use of "disconnect" command to logout from database.

Quit or exit disconnect user-name and close the database.