1. 安装时选择的自动安装，由于时间久远忘记用户名、密码了，导致现在试了几个默认的用户名密码後（表格中附带默认用户名及密码），都提示无效的用户名、密码，终于在试了下dbsnmp/dbsnmp，提示被锁；
2. 在CMD中启动SQLPLUS；用sqlplus/as sysdba登录，提示
连接到:
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
|
oracle 数据库的进程结构:
oracle进程主要有两类:用户进程和服务器进程
一..服务器端的后台进程
1.数据库写入进程(DBWR) 2.日志写入进程(LGWR) 3. 归档进程(ARCH) 4.检查点进程(CKPT) 5.系统监控进程(SMON) 6. 进程监控进程(PMON) 7.锁进程(LCKn) 8.恢复进程 9.调度进程10.作业队列进程 11.队列监控进程
二.oracle特定进程结构
1.专用服务器 2.线程服务器 3.单任务服务进程结构
oracle的内存结构
1.系统全局区域--------->共享池(库高速缓存,数据字典高速缓存),数据库缓冲区调整缓存 重做日志缓冲区
程序全局区域(PGA)
oracle数据库的逻辑存储结构
表空间 段 区间 数据库块
数据库的模式对象
