#删除用户下所有内容
1 2 | DROP USER XXXX cascade; DROP tablespace XXXX INCLUDING CONTENTS; |
#创建表空间
1 2 3 4 5 6 7 | CREATE tablespace test_data logging datafile '/app/u01/oradata/test_data.dbf' SIZE 32m autoextend ON NEXT 32m maxsize 2048m extent management LOCAL; |
11g OCA认证考试途径：（两门考试、无需培训）
途径一：1z0-007 + 1z0-052
途径二：1z0-051 + 1z0-052
途径三：1z0-047 + 1z0-052
11g OCP认证考试途径：（叁门考试 + 一门原厂培训）
途径一：OCA（1z0-007 + 1z0-052） + 1z0-053 + 一门原厂培训
1z0-007 Introduction to Oracle9i: SQL
1z0-052 Oracle Database 11g: Administration I
1z0-053 Oracle Database 11g: Administration II
途径二：OCA（1z0-051 + 1z0-052） + 1z0-053 + 一门原厂培训
继续阅读 »
1,下载mysql和sqlserver驱动包
#mysql 下载时候选择台湾大学的镜像，比较快
http://dev.mysql.com/downloads/connector/j/
#sqlserver 用开源的，比官方的稳定
http://sourceforge.net/projects/jtds/files/
2,配置
解压包中的jar文件到特定目录，自己选择一般放在sqldeveloper下的jdbc中。
打开打开sql developer，依次点击菜单：工具-首选项-数据库-第三方JDBC驱动程序，点击添加条目按钮。
将两个数据库的jar包添加过来。
3,连接
点击新建连接，就可以看到mysql，sqlserver和sybase选项卡，相应连接即可。
这里我测试到mysql一次只能打开一个表的选项卡。
linux 中在没有对init.crs作修改的时候,在开机时总是会自动把的cluster 软件和一起和系统起来.数据库raclinux
另外，也可以通过crs-stat -t查看，把没有启动的服务手工启动
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | [oracle@rac1 ~]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.....CRM.cs application OFFLINE OFFLINE ora....db1.srv application OFFLINE OFFLINE ora.devdb.db application ONLINE ONLINE rac1 ora....b1.inst application ONLINE ONLINE rac1 ora....b2.inst application ONLINE OFFLINE ora....SM1.asm application ONLINE ONLINE rac1 ora....C1.lsnr application ONLINE ONLINE rac1 ora.rac1.gsd application ONLINE ONLINE rac1 ora.rac1.ons application ONLINE ONLINE rac1 ora.rac1.vip application ONLINE ONLINE rac1 ora....SM2.asm application ONLINE OFFLINE ora....C2.lsnr application ONLINE OFFLINE ora.rac2.gsd application ONLINE OFFLINE ora.rac2.ons application ONLINE OFFLINE ora.rac2.vip application ONLINE ONLINE rac1 |
1、得到数据库名和创建日期
SELECT name, created, log_mode, open_mode FROM v$database;
2、ORACLE数据库的计算机的主机名，ORACLE数据库的实例名及ORACLE数据库管理系统的版本信息
SELECT host_name, instance_name, version FROM v$instance;
3、为了知道oracle数据库版本的一些特殊信息
select * from v$version;
4、获取控制文件名字
select * from v$controlfile;
Introduction
This paper takes a look at installing oracle 11g (11.1) on Linux (CentOS-5).You can read about CentOS at www.centos.org and be assured of its’ Enterprise-class quality. This paper will use oracle’s Quick Installation Guide for Linux x86 as its’ guide—noting where additional information may be obtained but getting oracle installed on Linux as fast as possible. We at thecheapdba.com have years of experience installing oracle—starting back with oracle 7. We will point out best practices so that you end up with a reliable database that provides exceptional performance. We will occasionally re-visit, edit, and post additions to this paper as we find further configuration best practices.
This paper will not cover the installation of CentOS-5 as that can be acquired through the CentOS website and additional Linux guides. We will however point out those alterations to the Linux environment that pertains to getting oracle installed.
Our goal is to provide you with the steps to properly install the oracle 11g software without having to read oracle’s installation guide from front to back cover. We will provide you the commands to execute (just cut-n-paste) and the desired outcome of those commands. If you get something other than what is expected it would be time for you to re-visit earlier steps in this process. So hold on, here we go.
It is assumed that the installer of oracle software has access and is running on an X Window System workstation. Please consult X Server documentation if you need help. We at thecheapdba.com typically will use cygwin ( www.cygwin.com ) for all interfacing with our Linux distribution. It has an X Window System that works quite well—and as we always like is free.
继续阅读 »
 |
 |
