第5讲 04
作为DBA手头有哪些工具:
1、Oracle Universal Installer(安装数据库时使用)
2、Database Configuration Assistant
3、Database Upgrade Assistant
4、Oracle Net Manager
5、Oracle Enterprise Manager(了解)
6、SQL*Plus(最常用)
7、Recovery Manager
8、Oracle Secure Backup
9、Data pump
10、SQL*Loader
Oracle Universal Installer(OUI):
1、统一跨平台用于安装、升级或者删除oracle,创建数据库
2、基于java引擎
3、交互式安装方式,直接运行命令./runInstaller,必须要有图形界面
4、无人值守安装,需要应答文件(response file),命令:
./runInstaller -responsefile 自定义文件名 -silent
Oracle Database Configuration Assistant(DBCA):
1、用于创建数据库
2、直接运行命令:./dbca
创建完数据库后默认有两个用户被创建:SYSTEM和SYS
SYS用户是数据字典(database data dictionary)的拥有者,初始密码是:change_on_install
SYSTEM用户小于SYS,一人之下万人之上,
附加内部表(additional inter tables)和使用Oracle工具视图的拥有者(views used by Oracle tools),初始密码是:manager
创建完数据库后要立即更改这两个用户的密码,平时操作一般用SYSTEM用户。
SQL*Plus
使用命令
sqlplus /nolog
connect / as sysdba
Oracle Enterprise Manager(OEM,11g后使用web界面):
分享到:
相关推荐
Oracle Enterprise Manager Getting Started with the Oracle Management Pack for Oracle Applications Release 9.0.1
Oracle Enterprise Manager Getting Started with the Oracle Diagnostics Pack Release 9.0.1
Oracle Enterprise Manager Getting Started with the Oracle Standard Management Pack Release 9.0.1
《getting start with storm》中译电子书
Storm 入门书, 讲述如何构建以及各个组件的介绍
Getting start with guava
Getting start with SOA
VirtualBox很好的入门书籍,介绍很详细。
SAP ABAP Getting start with BOPF PDF ,Getting Started with Business Object Processing Framework.
https://www.packtpub.com/application-development/getting-started-oracle-hyperion-planning-11 This book follows a tutorial-based approach that will provide you with step-by-step instructions to ...
Oracle Enterprise Manager Getting Started with Oracle Change Management Pack Release 9.2.0
Packtpub.Getting.Started.with.Oracle.BPM.Suite.11gR1.Sep.2010.rar
Getting Started with the MSP430 LaunchPad Workshop - Part 5 (High - Large).part06
labview的入门读物
Deploy Nano Server with SCVMM Manage Nano Server using PowerShell and Remote Server Management Tools Manage Nano Server with third-party tools Run Server Containers and Hyper-V Containers on Nano ...
ORACLE SOA SUITE 不错的书籍
labview使用DSP Module的教程
GETTING STARTED WITH RASPBERRY PI
Getting Started with the OutputDelivery System