Oracle forgot user name password

Source: Internet
Author: User

First, Oracle 11g login service opens

After successfully installing Oracle 11g, a total of 7 services
The meanings of these seven services are:
1. Oracle ORCL VSS Writer Service:
Oracle Volume Mapping copy write service, VSS (Volume Shadow Copy service) enables the creation of high-fidelity point-in-time images (Shadow copy) of storage infrastructure devices such as disks, arrays, and so on. It can create a mapped copy on multiple volumes or on a single volume without affecting the system's system performance. (must not be started)
2. Oracledbconsoleorcl:oracle Database Console service, ORCL is the instance identity of Oracle, and the default instance is ORCL. You need to start this service when you run Enterprise Manager (Enterprise Management Manager OEM). (must not be started)
3. ORACLEJOBSCHEDULERORCL:
Oracle Job scheduling (timer) service, ORCL is an Oracle instance identity. (must not be started)
4. Oraclemtsrecoveryservice:
Service-side control. The service allows the database to act as a resource manager for transactions in a Microsoft Transaction Server MTS, com/com+ object, and distributed environment. (must not be started)
5. Oracleoradb11g_home1clragent:
Oracle Database
. NET extension services. (must not be started)
6. Oracleoradb11g_home1tnslistener:
Listener service, the service is only required if the database requires remote access. (not required to start, detailed below).
7. ORACLESERVICEORCL:
The database service (DB instance), which is the Oracle Core service, is the basis for database startup, and the Oracle database starts normally only if the service is started. (Must Start)
For beginners:

A. If you only use Sql*plus with Oracle, just start ORACLESERVICEORCL.

B. With third-party tools such as PL/SQL developer, the Oracleoradb11g_home1tnslistener service will also be opened. ORACLEDBCONSOLEORCL is a web-based EM must be turned on, and the rest of the service is seldom used.
Note: ORCL is the database instance name, the default database is ORCL, you can create other, that is, the oracleservice+ database name.

Second, Oracle 11g forgot password processing

Turn on the ORACLESERVICEORCL service, run Sql*plus, according to the following mapping operation:

Complete the above operation and log in again:

The above from the network query and self-organizing!

Oracle forgot user name password

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.