Forgot how to resolve the user password for the initial installation of the Oracle database

Source: Internet
Author: User

The database has been installed for a long time, but it is not used locally, this is often happening, now how to solve this matter.

First Enter Plus

Cmd-sqlplus command

Then in the linked database will be helpless to find you entered the user name know how to write

can query under General Oracle under the default user name first:

Username/Password Login ID description

Sys/change_on_install SYSDBA or Sysoper cannot log on as NORMAL and can be used as the default system administrator

System/manager SYSDBA or NORMAL cannot log on as Sysoper and can be used as the default system administrator

Sysman/oem_temp Sysman user name for OMS

Scott/tiger Normal Normal User

Aqadm/aqadm SYSDBA or NORMAL Advanced Queue Administrator

Dbsnmp/dbsnmp SYSDBA or NORMAL replication administrator

After selecting a user name:

For example, ordinary users: Scott users (typically locked out).

After the user name input---/as sysdba link is successful, enter: Alter user Ordsys account unlock; (note that the SQL statement in Plus is added; symbol ends)

After the user is prompted to change

Enter the user name and password in the place: Ordsys

Then there will be a command to enter a new password (; symbol)

Forgot how to resolve the user password for the initial installation of the Oracle database

Related Article

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.