Oracle 11g Sys,system,scott Password not set up a workaround

Source: Internet
Author: User
Tags sqlplus

Starting today with Oracle's powerful database, it has not yet experienced its powerful capabilities. Before I heard that the Oracle installation is very complex, and I just really installed a time later only to know, in fact, the default can be, of course, the speed will be very slow, my I3 processor also compared to the force, 20 minutes less than the fix, my version is 11g 11.12.0. Of course, all the way to the default is not wise, installed to run up to find, password settings that a jump past, but also did not save the default password document, found on the internet a lot of solutions are not done, in a senior inadvertently reminded, found the solution, as follows:

You can use Sql>sqlplus/as when you log in SYSDBA

will prompt you to output the password, the direct return, you find unexpectedly can log in, as for this sqlplus level younger brother temporarily still do not know, next sql>alter user sys identified by admin (this you arbitrarily set); After execution you find the hint: the user has changed

This means that your sys password has been changed to admin, you can sql>conn sys/admin as sysdba after you know the password of sys, you are the boss, you can change the password of system and Scott, In fact, Scott's default password is Tiger, can be used directly, but the first login will prompt you to modify, if you are turned into a test with this is also very good.

The summary process is as follows:


Sql*plus:release 11.2.0.1.0 Production on Monday January 10 22:25:16 2011

Copyright (c) 1982, Oracle. All rights reserved.

Please enter user name: Sqlplus/as sysdba
Enter Password:

Connect to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-production
With the partitioning, OLAP, Data Mining and Real application testing options

sql> alter user SYS identified by admin;

The user has changed.

Sql> Conn Sys/admin as SYSDBA;
is connected.

sql> alter user system identified by admin;

The user has changed.

Sql> alter user Scott identified by Tiger;

The user has changed.

Transfer from http://blog.sina.com.cn/s/blog_6402bae90100v01p.html

Oracle 11g Sys,system,scott password is not set up for resolution

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.