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.
PLZ PROVIDE BACKLINK(TO MY POST) IN YOUR WEBSITE RATHER THAN ONLY COPYING...IT WILL BE A GIFT FOR OUR HARD WORK :)
This is onethingtoknow.blogspot.com
Thanks for reading :).
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 :
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 :).
5 comments
commentsHow to Retrieve Forgot Username and Password of Oracle? Contact to Remote DBA Services for Quick Access
ReplyWell! If unfortunately you are not able to recover your forget username and password of Oracle database then no issue, with Cognegic’s Database Administration for Oracle or Online Oracle DB Support you can easily retrieve your password without confronting any issue. Our all technical experts know very-well how to recover your username and password of Oracle. With our Oracle Database Solution you can easily solve your problem.
For More Info: https://cognegicsystems.com/
Contact Number: 1-800-450-8670
Email Address- info@cognegicsystems.com
Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801
Thanks for sharing this valuable info. I just check that on my computer for myself. And i just learned new work today by you man. You did a good job in here. But one problem, that i am facing. i can't verified that yet. Thanks man.
ReplyHere is another resourceful post about Oracle. Every single people will get help from this one. I appreciate this kind of works. Just follow this and verify if you know this. Thanks
Replywb neet cut off 2019
Replycg neet cut off 2019
aakash neet cut off 2019
ncert solutions for class 12 english
At step 4 it is showing error saying that the database not open
Reply