Unlock Scott/Tiger Account In Oracle| Step By step Guide

Installing Oracle is simple task But how to work on Oracle database with Default Username and password is quite difficult.
Generally Oracle users Knew that Default USERNAME/ Password is SCOTT/TIGER. But after installing the Oracle a error is raised that the account is locked. Even We have to Unlock the Default account.[ At the end of downloading the software ,there will be a tab or button called Password Management .when we click that button ,then it will show all the users that we can run on Oracle..SCOTT username will be also there ,you just have to untick the USERNAME scott in that table.]

For this we have to run certain Commands.


Let us SEE how to do this :

Step 1: Open the Command Prompt From Start Icon and type "sqlplus" in it.Now you will be entered Into a DataBase Section.

Step 2 : Now There will be command like 
Enter User name.Here Enter "sys as sysdba"  and Press Enter
again a command will be prompted like 
Enter Password leave it and press ENTER . 
Check the given figure.
                        
                                

Step 3 : Now Its will Indicate " connected Oracle Database".

and "SQL>" sign will given to write a query.

Step 4 : Now Enter after 

"SQL> alter User scott account unlock;" and press ENTER. 

It will say USER altered.

Step 5 : Now write after 

"SQL>conn Scott/tiger" and press ENTER.

Check the given figure.

                   

Step 6 : After Pressing Enter it will show a error like Password has expired and it will give option to type the new password .

Here you can type NEW password as TIGER again.

After typing password it will say password changed and Connected. Check the given figure.

                   

                          

That's it Now you can successfully run Your Queries and Complete your programs.

Also check :  

                                   1. How to install Oracle In Windows PC

                        2.How to Uninstall Oracle from PC.

Last words :

                 Scott/Tiger account is locked when we install Oracle in our system's.Thus for unlocking it we have to type certain commands in order to unlock default scott/tiger account.This post tells step by step guide how to unlock Scott/tiger account.

  IF YOU LIKE OUR POST AND WANNA SHARE ...

PLZ PROVIDE BACKLINK(TO MY POST) IN YOUR WEBSITE RATHER THAN ONLY COPYING...IT WILL BE A GIFT FOR OUR HARD WORK :) 

That's it for today's post.

Hope you also enjoy this one.

This is onethingtoknow.blogspot.com
Thanks for reading :).

How to Install Oracle Step By Step Guide | Tutorial for Windows

For Beginner's Installing Oracle on Windows is not a easy task In my opinion.Even I have faced Lots of problem While installing it on my windows based PC.So i searched a lot came up with a simple solution.
[ Its your choice to install either Basic  or Enterprise
edition,But if you are learning Oracle its better to go for basic ,because it is enough to execute all our programs.]


So Let us see how to Install it step by step :


Step 1 : Initially click on SETUP icon , and you will get a window Opened 
Now select Basic Installation and Tick the Create starter Database Option and 
Give the Database name and Password as you like  and click On Next Button as shown in the Given figure.

Step 2 : After doing this , it will take you to a another window, there if you are using windows 7 (which is a higher version ) You might get an error . 

There Just click the white Boxes, where the error is shown,then the status will change to USER verified and 

click on NEXT button as Shown in figure.

Step 3 : Another window will open and now you have to Click on NEXT ,here as shown in figure below.

        

Step 4 : That's it Now it will Start Installing all its components as shown in below figure.

                      

 That's It Your ORACLE engine will be successfully Installed in Your WINDOWS PC.

Also Check : 

                                     1.Unlock SCOTT/TIGER account.

                                     2. How to Uninstall Oracle from PC.

LAST WORDS : 

                   Installation Of oracle and Launching Oracle engine in a windows based PC is quite tricky task.This Post is about Step by step guide to install Oracle in your windows PC.

 IF YOU LIKE OUR POST AND WANNA SHARE ...

PLZ PROVIDE BACKLINK(TO MY POST) IN YOUR WEBSITE RATHER THAN ONLY COPYING...IT WILL BE A GIFT FOR OUR HARD WORK :) 

That's it for today's post.

Hope you also enjoy this one.

This is onethingtoknow.blogspot.com
Thanks for reading :).

How to Uninstall Oracle from System

This Post is about Uninstalling Oracle from your system.Many people are asking how to remove Oracle ,so i thought to write a post about it.Actually Uninstalling Oracle from system is a very Easy task.Here the main problem is that the uninstaller is not given given directly.

Let us see how to uninstall it :

Step 1 : Click on Start select Oracle option. Under it select
Oracle Installation products < Universal Installer as shown in given figure.
                                                               

Step 2: Now A window will open , and click on DEINSTALL products option As shown in given figure.

      

Step 3 : Now select your present ORACLE database option and click on REMOVE button , as shown in given figure .

Step 4 : Another window will open and click on YES.

            

Thats it , you Successfully Uninstalled ORACLE from your system.

Also Check : 

                       1. How to Install Oracle In Windows Based PC.

                       2. Unlock Scott/Tiger Account.

LAST WORDS : 

                       Uninstalling Oracle is not a big task,but some feel as it is a big task.You just have to go to Universal Installer and deinstall the products. Thats it you successfully uninstalled your product.

 IF YOU LIKE OUR POST AND WANNA SHARE ...

PLZ PROVIDE BACKLINK(TO MY POST) IN YOUR WEBSITE RATHER THAN ONLY COPYING...IT WILL BE A GIFT FOR OUR HARD WORK :) 

That's it for today's post.

Hope you also enjoy this one.

This is onethingtoknow.blogspot.com
Thanks for reading :).