admin 管理员组

文章数量: 887021


2023年12月23日发(作者:linux退出并保存命令)

安装时选择的自动安装,由于时间久远忘记用户名、密码了,导致现在试了几个默认的用户名密码後(表格中附带默认用户名及密码),都提示无效的用户名、密码,终于在试了下dbsnmp/dbsnmp,提示被锁;

首先启动sqlplus

输入用户名:sqlplus / as sysdba

密码空缺

如果用户被锁定,记得加上

SQL> alter user dbsnmp account unlock;

User altered.

然后修改密码

SQL> alter user dbsnmp identified by dbsnmp;

User altered.

现在就可以用用户名:dbsnmp 密码:dbsnmp登录了。

Oracle 10g

默认安装带来的用户名/密码

Username

Password

Description

CTXSYS

CTXSYS

The Oracle Text account

The account used by the

Management Agent component of

Oracle Enterprise Manager to

DBSNMP

DBSNMP

monitor and manage the database

LBACSYS

LBACSYS

The Oracle Label Security

See Also

Oracle Text Reference

Oracle Enterprise Manager Grid

Control Installation and Basic

Configuration

Oracle Label Security

administrator account

The schema used by Oracle Spatial

Administrator's Guide

Oracle Spatial User's Guide and

MDDATA

MDDATA

for storing Geocoder and router data

Reference

The Oracle Spatial and Oracle

interMedia Locator administrator

MDSYS

MDSYS

account

Oracle Spatial User's Guide and

Reference

Oracle Data Mining

Administrator's Guide

DMSYS

DMSYS

The Oracle Data Mining account.

The account used to create OLAP

MANAGEmetadata structures. It owns the

OLAPSYS

R

OLAP Catalog (CWMLite).

The Oracle interMedia user. Plug-ins

supplied by Oracle and third party

ORDPLUGORDPLUGformat plug-ins are installed in this

INS

INS

schema.

The Oracle interMedia administrator

ORDSYS

ORDSYS

account

The account that supports plan

stability. Plan stability enables you to

Oracle Database Performance

OUTLN

OUTLN

maintain the same execution plans

Tuning Guide

Oracle interMedia User's Guide

Oracle interMedia User's Guide

Oracle OLAP Application

Developer's Guide

Oracle Data Mining Concepts

for the same SQL statements. OUTLN

acts as a role to centrally manage

metadata associated with stored

outlines.

SI_INFORSI_INFORThe account that stores the

MTN_SCHMTN_SCHinformation views for the SQL/MM

EMA

EMA

CHANGE_ON_INSTAThe account used to perform

SYS

LL

database administration tasks

The account used to perform Oracle

Enterprise Manager database

CHANGE_administration tasks. Note that SYS Oracle Enterprise Manager Grid

ON_INSTAand SYSTEM can also perform these Control Installation and Basic

SYSMAN

LL

tasks.

Configuration

Oracle Database

Administrator's Guide

Oracle Database

Administrator's Guide

Still Image Standard

Oracle interMedia User's Guide

MANAGEAnother account used to perform

SYSTEM

R

database administration tasks.

不知道11g是不是这个。。。。

啊,今天补充一点!一定要注意,尤其是内存小于等于2G的同学。。不用的的时候一定不要开启oracle的服务。。。今天开机居然输入密码后一直黑屏,进不去桌面。。。。有同样遭遇

的同学,参考一下解决办法:

1.开机F8进安全模式(如果安全模式都进不了就不知道了,亲,重装或者回复系统吧)

2.在我的电脑里面找到“服务”(不管你是从任务管理器-服务-服务,还是我的电脑右键管理-服务与应用-服务)。找到以oracle开头的全部服务,所有“自动”或者“自动(延迟启动)”的都设置为“手动”,一般都不会用到。

3.在使用oracle服务器的时候,只需要开启OracleOraDb11g_home1TNSListener和OracleServiceXXX即可(XXX为你配置的服务器名字)。

此贴仅分享给和我一样的菜鸟学习交流,分享经验教训。老鸟请无视,勿喷。


本文标签: 服务 密码 用户名 自动 时候