程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle數據庫基礎 >> 詳解Oracle如何解鎖用戶的方法

詳解Oracle如何解鎖用戶的方法

編輯:Oracle數據庫基礎

在這裡我們要介紹的是Oracle如何解鎖用戶的方法,對於Oracle如何解鎖用戶,一般我們都是試用默認密碼來進行。希望本文對大家有所幫助。

1. 安裝時選擇的自動安裝,由於時間久遠忘記用戶名、密碼了,導致現在試了幾個默認的用戶名密碼後(表格中附帶默認用戶名及密碼),都提示無效的用戶名、密碼,終於在試了下dbsnmp/dbsnmp,提示被鎖;

2. 在CMD中啟動SQLPLUS;用sqlplus/as sysdba登錄,Oracle如何解鎖用戶提示

連接到:

Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

3. 執行ALTER USER DBSNMP ACCOUNT UNLOCK;

4. 從新用SQL/PLUS登錄,設置用戶名、密碼;

注:由於剛才解鎖的用戶名是DBSNMP,所以這裡設置的用戶名也是DBSNMP
Oracle 10g 默認安裝帶來的用戶名/密碼

Username

PassWord

Description

See Also

CTXSYS

CTXSYS

The Oracle Text account

Oracle Text Reference

DBSNMP

DBSNMP

The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database

Oracle Enterprise Manager Grid Control Installation and Basic Configuration

LBACSYS

LBACSYS

The Oracle Label Security administrator account

Oracle Label Security Administrator's Guide

MDDATA

MDDATA

The schema used by Oracle Spatial for storing Geocoder and router data

Oracle Spatial User's Guide and Reference

MDSYS

MDSYS

The Oracle Spatial and Oracle interMedia Locator administrator account

Oracle Spatial User's Guide and Reference

DMSYS

DMSYS

The Oracle Data Mining account.

Oracle Data Mining Administrator's Guide

Oracle Data Mining Concepts

OLAPSYS

MANAGER

The account used to create OLAP metadata structures. It owns the OLAP Catalog (CWMLite).

Oracle OLAP Application Developer's Guide

ORDPLUGINS

ORDPLUGINS

The Oracle interMedia user. Plug-ins supplIEd by Oracle and third party format plug-ins are installed in this schema.

Oracle interMedia User's Guide

ORDSYS

ORDSYS

The Oracle interMedia administrator account

Oracle interMedia User's Guide

OUTLN

OUTLN

The account that supports plan stability. Plan stability enables you to maintain the same execution plans for the same SQL statements. OUTLN acts as a role to centrally manage metadata associated with stored outlines.

Oracle Database Performance Tuning Guide

SI_INFORMTN_SCHEMA

SI_INFORMTN_SCHEMA

The account that stores the information vIEws for the SQL/MM Still Image Standard

Oracle interMedia User's Guide

SYS

CHANGE_ON_INSTALL

The account used to perform database administration tasks

Oracle Database Administrator's Guide

SYSMAN

CHANGE_ON_INSTALL

The account used to perform Oracle Enterprise Manager database administration tasks. Note that SYS and SYSTEM can also perform these tasks.

Oracle Enterprise Manager Grid Control Installation and Basic Configuration

SYSTEM

MANAGER

Another account used to perform database administration tasks.

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved