Fundamental I 02 Getting started with Oracle Server
来源:互联网 发布:.手机域名在哪注册 编辑:程序博客网 时间:2024/06/01 10:37
DBA常用工具, SQL*Plus 最常用
OEM在11g之后名字变了 还有其他
Database Configuration Assistant
Database Upgrade Assistant
Oracle Net Manager
Recovery Manager
Oracle Secure Backup
Data Pump
SQL*Loader
OUI: 安装Oracle Server
$ ./runInstaller 启动安装程序 (需要在图形界面操作,交互性操作 )
$ ./runInstaller -responsefile myrespfile -silent 命令行操作, 非交互性安装, 需要准备myrespfile文档, 示例在response目录中
DBCA: 管理Oracle实例,实际上是脚本, 启动图形界面
$ dbca
在创建Instance之后, 会新建两个用户, SYS: 超级用户, 数据字典的owner, 缺省密码change_on_install ; SYSTEM: Oracle内部表和试图的owner, 缺省密码: manager
SQL*Plus: 和db交互, 可以做数据库操作, 数据操作
$ sqlplus /nolog 以不登陆方式连接
SQL> conn /as sysdba以sysdba方式连接
SQL> startup启动数据库
SQL> lsnrctl start启动Listener, 可以允许客户端访问
OEM: 一个集中化管理数据库的工具,比较麻烦,以后用到再看,架构如下,主要是引用一个代理向OEM发送信息
- Fundamental I 02 Getting started with Oracle Server
- Oracle Tips2( Getting Started with orcale server)
- 第05讲:Chapter 02--Getting Started with the Oracle Server
- Getting started with windbg - part I
- Getting Started with Smartphone
- Getting Started With JasperReports
- Getting started with OpenCV
- Getting Started with DWR
- Getting Started With JasperReports
- Getting Started with MASM
- Getting started with BlazeDS
- Getting Started with RMAN
- Getting started with LAM
- Getting started with Davinci
- Getting Started with Monkey
- Getting Started with Boost
- Getting started with windbg
- Getting started with IUNIVERS
- android进入Activity阻止键盘自动弹出
- 项目Scrum历程随手记 - 第一次Scrum Sprint Meeting
- 常见网络词汇
- Linux Qt应用程序的守护精灵
- Android之UI组件TextView的属性大集合
- Fundamental I 02 Getting started with Oracle Server
- Android开发——UI组件详解及注册提交表单实现
- C++ strlen 与 sizeof 的深度认识
- [Delphi]ListView基本用法大全
- SDK编程笔记 — 计时器篇
- GDI制作验证码cs代码
- 中序遍历的非递归版本
- js取消超链接
- 撇下的终究要回来捡