34,837
社区成员
发帖
与我相关
我的任务
分享Oracle菜鸟问题，请大侠们帮助。
Oracle数据库的的内置帐号Manager口令System和另外一个内置帐号Scott口令Tiger有什么区别，他们是同一个级别的吗？
另外，我安装Oracle8.16（使用Ebizser的Setup目录中的Oracle安装
盘）的过程中每次创建数据库的时候都报错“数据通道出错”，然后就数据
库总是没有创建完成，不知道是怎么回事？
多谢各位。
另外，我安装Oracle8.16（使用Ebizser的Setup目录中的Oracle安装
盘）的过程中每次创建数据库的时候都报错“数据通道出错”，然后就数据
库总是没有创建完成，不知道是怎么回事？
多谢各位。
...全文
请发表友善的回复…
发表回复
zlps 2002-03-29
- 打赏
- 举报
多谢各位鼎力相助！
//bow
//bow
zlps 2002-03-28
- 打赏
- 举报
老衲兄，能说得详细点吗？
我看到一本Oracle的书上说两个帐号都是Oracle内部的通用帐号，
还有一个Internal帐号又有什么权限呢？
多谢了。
我看到一本Oracle的书上说两个帐号都是Oracle内部的通用帐号，
还有一个Internal帐号又有什么权限呢？
多谢了。
蓝天 2002-03-28
- 打赏
- 举报
权限不同
netcreator 2002-03-28
- 打赏
- 举报
1.oracle数据库创建后，基本上会有12个帐号可用，主要是internal,system,sys和scott这四个帐号区别如下：
internal/oracle处理数据库的Administrator工作，启动关闭数据库等，其实，这个帐号不是一个真正的用户，而是sys帐号的别名。
system/manager处理数据库的Administrator工作，拥有AQ_Administator_role和dba的role权限。
sys/change_on_install处理数据库的Administrator工作，是权限最大的帐号。
scott/tiger拥有connect 和resource的role权限，一般来说，这个帐号足够进行数据库应用和开发的了，用数据库的话，就这个帐号最稳妥
2.oracle的安装及使用过程中会启动一个java虚拟机，目前来看，这个虚拟机会产生一些兼容性问题，如跟 pentium 4的兼容性问题，及跟其他一些操作系统的问题，而且创建数据库的过程就是狂吃内存的过程，内存少了不行，安装或打开的应用程序多了也不行，会使创建过程遇到各种各样的问题，建议你检查一个机器的内存使用情况，创建之前将所有无关的东东全关掉
internal/oracle处理数据库的Administrator工作，启动关闭数据库等，其实，这个帐号不是一个真正的用户，而是sys帐号的别名。
system/manager处理数据库的Administrator工作，拥有AQ_Administator_role和dba的role权限。
sys/change_on_install处理数据库的Administrator工作，是权限最大的帐号。
scott/tiger拥有connect 和resource的role权限，一般来说，这个帐号足够进行数据库应用和开发的了，用数据库的话，就这个帐号最稳妥
2.oracle的安装及使用过程中会启动一个java虚拟机，目前来看，这个虚拟机会产生一些兼容性问题，如跟 pentium 4的兼容性问题，及跟其他一些操作系统的问题，而且创建数据库的过程就是狂吃内存的过程，内存少了不行，安装或打开的应用程序多了也不行，会使创建过程遇到各种各样的问题，建议你检查一个机器的内存使用情况，创建之前将所有无关的东东全关掉
chfhy 2002-03-28
- 打赏
- 举报
Scott口令Tiger并不是真正的内置账号
蓝天 2002-03-28
- 打赏
- 举报
SYS
When any database is created, the user SYS, identified by the password CHANGE_ON_INSTALL, is automatically created and granted the DBA role.
All of the base tables and views for the database's data dictionary are stored in the schema SYS. These base tables and views are critical for the operation of Oracle. To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by Oracle; they should never be modified by any user or database administrator, and no one should create any tables in the schema of the user SYS. (However, you can change the storage parameters of the data dictionary settings if necessary.)
Most database users should never be able to connect using the SYS account. You can connect to the database using this account but should do so only when instructed by Oracle personnel or documentation.
SYSTEM
When a database is created, the user SYSTEM, identified by the password MANAGER, is also automatically created and granted all system privileges for the database.
The SYSTEM username creates additional tables and views that display administrative information, and internal tables and views used by Oracle tools. Never create tables of interest to individual users in the SYSTEM schema.
The DBA Role
A predefined role, named "DBA", is automatically created with every Oracle database. This role contains all database system privileges. Therefore, it is very powerful and should only be granted to fully functional database administrators.
When any database is created, the user SYS, identified by the password CHANGE_ON_INSTALL, is automatically created and granted the DBA role.
All of the base tables and views for the database's data dictionary are stored in the schema SYS. These base tables and views are critical for the operation of Oracle. To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by Oracle; they should never be modified by any user or database administrator, and no one should create any tables in the schema of the user SYS. (However, you can change the storage parameters of the data dictionary settings if necessary.)
Most database users should never be able to connect using the SYS account. You can connect to the database using this account but should do so only when instructed by Oracle personnel or documentation.
SYSTEM
When a database is created, the user SYSTEM, identified by the password MANAGER, is also automatically created and granted all system privileges for the database.
The SYSTEM username creates additional tables and views that display administrative information, and internal tables and views used by Oracle tools. Never create tables of interest to individual users in the SYSTEM schema.
The DBA Role
A predefined role, named "DBA", is automatically created with every Oracle database. This role contains all database system privileges. Therefore, it is very powerful and should only be granted to fully functional database administrators.
