directory manage oracle_oracle directory - CSDN
精华内容
参与话题
  • oracle全托管驱动Oracle.ManagedDataAccess

    千次阅读 2016-12-23 09:24:08
    Download ODP.NET, Managed Driver .zip file to a directory for staging the install.Unzip the download to expand its contents into the target directory.Run configure.bat to GAC and configure machine.con
    1. Download ODP.NET, Managed Driver .zip file to a directory for staging the install.
    2. Unzip the download to expand its contents into the target directory.
    3. Run configure.bat to GAC and configure machine.config for ODP.NET, Managed Driver.
    4. Create a new Visual Studio 2010 console application project for C#.
    5. Add Oracle.ManagedDataAccess.dll as a reference to the project.
    6. Replace the contents of Program.cs with the following C# code. Notice that the namespace of ODP.NET, Managed Driver (Oracle.ManagedDataAccess.*) is different from the namespace of ODP.NET, Unmanaged Driver (Oracle.DataAccess.*).
      复制代码
      // C#
      using System;
      using Oracle.ManagedDataAccess.Client;
      using Oracle.ManagedDataAccess.Types;
      
      namespace Connect
      {
        class Program
        {
          static void Main(string[] args)
          {
            try
            {
              // Please replace the connection string attribute settings
              string constr = "user id=scott;password=tiger;data source=oracle";
      
              OracleConnection con = new OracleConnection(constr);
              con.Open();
              Console.WriteLine("Connected to Oracle Database {0}", con.ServerVersion);
              con.Dispose();
      
              Console.WriteLine("Press RETURN to exit.");
              Console.ReadLine();
            }
            catch (Exception ex)
            {
              Console.WriteLine("Error : {0}", ex);
            }
          }
        }
      }
      复制代码

       

    展开全文
  • 采用Oracle Net Manager配置数据库 telnet ip port没用问题,用户名和密码也没问题,但是

    采用Oracle Net Manager配置数据库

    telnet ip port没用问题,用户名和密码也没问题,但是还是测试连接失败。

    可以尝试“用管理员身份运行”Oracle Net Manager“试一试!

    展开全文
  • ORACLE数据库备份与还原命令

    千次阅读 2013-05-30 13:49:38
    10g开始引入了最新的数据泵(Data Dump)技术,使DBA或开发人员可以将数据库元数据(对象定义)和数据快速移动到另一个oracle数据库中. 数据泵导出导入(EXPDP和IMPDP)的作用 1,实现逻辑备份和逻辑恢复. 2,在数据库用户...

    简介:

    数据泵使用指南
    10g开始引入了最新的数据泵(Data Dump)技术,使DBA或开发人员可以将数据库元数据(对象定义)和数据快速移动到另一个oracle数据库中.
    数据泵导出导入(EXPDP和IMPDP)的作用
    1,实现逻辑备份和逻辑恢复.
    2,在数据库用户之间移动对象.
    3,在数据库之间移动对象
    4,实现表空间搬移.


    数据泵导出导入与传统导出导入的区别
    在10g之前,传统的导出和导入分别使用EXP工具和IMP工具,从10g开始,不仅保留了原有的EXP和IMP工具,还提供了数据泵导出导入工具EXPDP和IMPDP.使用EXPDP和IMPDP时应该注意的事项;
    EXP和IMP是客户段工具程序,它们既可以在可以客户端使用,也可以在服务端使用.
    EXPDP和IMPDP是服务端的工具程序,他们只能在ORACLE服务端使用,不能在客户端使用
    IMP只适用于EXP导出文件,不适用于EXPDP导出文件;IMPDP只适用于EXPDP导出文件,而不适用于EXP导出文件.
    数据泵导出包括导出表,导出方案,导出表空间,导出数据库4种方式.


    导出功能
    使用EXPDP工具时,其转储文件只能被存放在DIRECTORY对象对应的OS目录中,而不能直接指定转储文件所在的OS目录.
    因此,使用EXPDP工具时,必须首先建立DIRECTORY对象.并且需要为数据库用户授予使用DIRECTORY对象权限.
    CREATE DIRECTORY dump dir AS '/home/oracle/dump_dir';
    GRANT READ, WIRTE ON DIRECTORY dump_dir TO public;
    注意:这个目录赋权限给oracle用户
    1,导出表
    Expdp scott/tiger DIRECTORY=dump_dir DUMPFILE=tab.dmp logfile=tab.log TABLES=dept,emp
    2,导出方案
    Expdp scott/tiger DIRECTORY=dump_dir DUMPFILE=schema.dmp SCHEMAS=system,scott
    3.导出表空间
    Expdp system/manager DIRECTORY=dump_dir DUMPFILE=tablespace.dmp TABLESPACES=user01,user02
    4,导出数据库
    Expdp system/manager DIRECTORY=dump_dir DUMPFILE=full.dmp FULL=Y


    我们经常用到的是第二种
    expdp system/**** directory=dump_dir dumpfile=ngboss_yueyang20130514.dmp logfile=expyueyang20130514.log schemas=ngboss_yueyang
    对参数功能不了解请expdp -help查看


    导入功能
    和导出一样,先要建立DIRECTORY对象.并且需要为数据库用户授予使用DIRECTORY对象权限.
    CREATE DIRECTORY dump dir AS '/home/oracle/dump_dir';
    GRANT READ, WIRTE ON DIRECTORY dump_dir TO public;
    注意:这个目录赋权限给oracle用户
    将dmp文件copy到对应的目录
    同样有四种情况
    1, 导入表
    Impdp scott/tiger DIRECTORY=dump_dir DUMPFILE=tab.dmp TABLES=dept,emp
    Impdp system/manage DIRECTORY=dump_dir DUMPFILE=tab.dmp TABLES=scott.dept,scott.emp REMAP_SCHEMA=SCOTT:SYSTEM
    第一种方法表示将DEPT和EMP表导入到SCOTT方案中,第二种方法表示将DEPT和EMP表导入的SYSTEM方案中.
    注意,如果要将表导入到其他方案中,必须指定REMAP SCHEMA选项.
    2,导入方案
    Impdp scott/tiger DIRECTORY=dump_dir DUMPFILE=schema.dmp SCHEMAS=scott
    Impdp system/manager DIRECTORY=dump_dir DUMPFILE=schema.dmp SCHEMAS=scott REMAP_SCHEMA=scott:system
    3,导入表空间
    Impdp system/manager DIRECTORY=dump_dir DUMPFILE=tablespace.dmp TABLESPACES=user01
    4,导入数据库
    Impdp system/manager DIRECTORY=dump_dir DUMPFILE=full.dmp FULL=y


    针对我们系统的特点有两种情况
    1.导入库的用户名和表空间跟导出的库一致,例如从201上的ngboss_yueyang导入到196上的ngboss_yueyang用户上,两边的表空间名也一样
    impdp system/**** directory=dump_dir dumpfile=ngboss_yueyang20130514.dmp logfile=impngboss_yueyang20130514.log schemas=ngboss_yueyang


    2.导入库的用户名和表空间跟导出的库不一致
    例如:从岳阳的生产库上导出的库导入到公司201上ngboss_yueyang用户上
    用户名和表空间名都不一样
    impdp system/****  directory=dump_dir dumpfile=ngboss20130513.dmp logfile=impyueyang20130514.log remap_schema=ngboss:ngboss_yueyang remap_tablespace=ngboss_data:ngboss_yy_data,NGBOSS_DATA_CRM1:NGBOSS_YY_DATA_CRM1,NGBOSS_DATA_CRM2:NGBOSS_YY_DATA_CRM2,NGBOSS_DATA_HIST:NGBOSS_YY_DATA_HIST,NGBOSS_DATA_HIST_CRM:NGBOSS_YY_DATA_HIST_CRM,NGBOSS_INDX:NGBOSS_YY_INDX,NGBOSS_INDX_CRM:NGBOSS_YY_INDX_CRM,NGBOSS_WORK:NGBOSS_YY_WORK 
    对参数功能不了解请impdp -help查看


    注意事项:用dba账户导出的dmp文件必须要用dba账户导入。

    推荐文章:

    展开全文
  • exp、imp是ORACLE幸存的最古老的两个操作系统命令行工具,导入(IMP)/导出(EXP),昨天在Oracle用exp、imp导入导出报EXP-0006:出现内部不一致的错误。  以前用exp、imp导库命令成功的实现了Oracle数据库的导出、...

    exp、imp是ORACLE幸存的最古老的两个操作系统命令行工具,导入(IMP)/导出(EXP),昨天在Oracle用exp、imp导入导出报EXP-0006:出现内部不一致的错误。

      以前用exp、imp导库命令成功的实现了Oracle数据库的导出、导入,对此,昨天再对服务器新安装的Oracle数据库用exp、imp导库,一直报“EXP-0006:出现内部不一致的错误”,于是在网上百度,尝试其他导库方式,发现采用expdp、impdp数据泵同样可以完成数据库的导出、导入,而且数据泵与传统导出导入有如下区别:

      1.EXP和IMP是客户段工具程序, EXPDP和IMPDP是服务端的工具程序;

      2.EXP和IMP效率比较低. EXPDP和IMPDP效率高;

      3.数据泵功能强大并行、过滤、转换、压缩、加密、交互等等;

      4.数据泵不支持9i以前版本, EXP/IMP短期内还是比较适用;

      5.同exp/imp数据泵导出包括导出表,导出方案,导出表空间,导出数据库4种方式。

      有了理论支持,下面开始实战。

      expdp导出Oracle数据库

      1.在sqlplus下创建Directory, 优点在于让我们可以在Oracle数据库中灵活的对文件进行读写操作,极大的提高了Oracle的易用性和可扩展性。

      命令:createdirectory oracleDB as 'D:OracleDB';

      2.把读写权限授予特定用户

      命令:Grantread,write on directory oracleDB to radpcs;

      3.在dos窗口执行expdp导出命令

      命令:expdp radpcs/ictradpcs@rdpcs directory=oracleDB dumpfile =20150226.dmp logfile=20150226.logFULL=y;

      到此导出工作完成,下面讲解如何用impdp导入Oracle数据库。

      impdp导入Oracle数据库

      
    1.以sysdba级别登录Oracle数据库

      命令:--sqlplus /nolog

      --conn system/system@radpcs as sysdba

      2.创建数据表空间

      命令:

      --创建数据表空间

      CREATE TABLESPACE RADPCS_DATA

      LOGGING

      DATAFILE 'D:OracleDBradpcs_DATA.DBF' SIZE 200M REUSE AUTOEXTEND

      ON NEXT 10M MAXSIZE 16383M EXTENT MANAGEMENT LOCAL UNIFORM

      SIZE 1024K;

      --创建索引表空间

      CREATE TABLESPACE RADPCS_INDX

      LOGGING

      DATAFILE 'D:OracleDBradpcs_INDX.DBF' SIZE 200M REUSE AUTOEXTEND

      ON NEXT 10M MAXSIZE 16383M EXTENT MANAGEMENT LOCAL UNIFORM

      SIZE 1024K;

      这步很关键,创建的表空间需要和原Oracle表空间名称、个数相同,否则会导入失败。如果不知道原表空间名称、个数,就先创建一个临时的表空间进行导入,导入过程中根据错误提示,比如“RADPCS1_DATA表空间不存在”提示,缺哪个创建哪个。

      3.创建用户、对用户授权

      --创建用户

      create user radpcs identified by ictradpcs

      default tablespace radpcs_data

      quota unlimited on radpcs_data

      quota unlimited on radpcs_indx;

      --授权

      grant aq_administrator_role to radpcs;

      grant aq_user_role to radpcs;

      grant authenticateduser to radpcs;

      grant connect to radpcs;

      grant ctxapp to radpcs;

      grant dba to radpcs;

      grant delete_catalog_role to radpcs;

      grant ejbclient to radpcs;

      grant execute_catalog_role to radpcs;

      grant exp_full_database to radpcs;

      grant gather_system_statistics to radpcs;

      grant hs_admin_role to radpcs;

      grant imp_full_database to radpcs;

      grant javadebugpriv to radpcs;

      grant javaidpriv to radpcs;

      grant javasyspriv to radpcs;

      grant javauserpriv to radpcs;

      grant java_admin to radpcs;

      grant java_deploy to radpcs;

      grant logstdby_administrator to radpcs;

      grant oem_monitor to radpcs;

      grant olap_dba to radpcs;

      grant recovery_catalog_owner to radpcs;

      grant resource to radpcs;

      grant select_catalog_role to radpcs;

      grant xdbadmin to radpcs;

      -- Grant/Revoke system privileges

      grant administer database trigger to radpcs;

      grant alter any cluster to radpcs;

      grant alter any dimension to radpcs;

      grant alter any index to radpcs;

      grant alter any indextype to radpcs;

      grant alter any library to radpcs;

      grant alter any outline to radpcs;

      grant alter any procedure to radpcs;

      grant alter any role to radpcs;

      grant alter any sequence to radpcs;

      grant alter any snapshot to radpcs;

      grant alter any table to radpcs;

      grant alter any trigger to radpcs;

      grant alter any type to radpcs;

      grant alter database to radpcs;

      grant alter profile to radpcs;

      grant alter resource cost to radpcs;

      grant alter rollback segment to radpcs;

      grant alter session to radpcs;

      grant alter system to radpcs;

      grant alter tablespace to radpcs;

      grant alter user to radpcs;

      grant analyze any to radpcs;

      grant audit any to radpcs;

      grant audit system to radpcs;

      grant backup any table to radpcs;

      grant become user to radpcs;

      grant comment any table to radpcs;

      grant create any cluster to radpcs;

      grant create any context to radpcs;

      grant create any dimension to radpcs;

      grant create any directory to radpcs;

      grant create any index to radpcs;

      grant create any indextype to radpcs;

      grant create any library to radpcs;

      grant create any operator to radpcs;

      grant create any outline to radpcs;

      grant create any procedure to radpcs;

      grant create any sequence to radpcs;

      grant create any snapshot to radpcs;

      grant create any synonym to radpcs;

      grant create any table to radpcs;

      grant create any trigger to radpcs;

      grant create any type to radpcs;

      grant create any view to radpcs;

      grant create cluster to radpcs;

      grant create database link to radpcs;

      grant create dimension to radpcs;

      grant create indextype to radpcs;

      grant create library to radpcs;

      grant create operator to radpcs;

      grant create procedure to radpcs;

      grant create profile to radpcs;

      grant create public database link to radpcs;

      grant create public synonym to radpcs;

      grant create role to radpcs;

      grant create rollback segment to radpcs;

      grant create sequence to radpcs;

      grant create session to radpcs;

      grant create snapshot to radpcs;

      grant create synonym to radpcs;

      grant create table to radpcs;

      grant create tablespace to radpcs;

      grant create trigger to radpcs;

      grant create type to radpcs;

      grant create user to radpcs;

      grant create view to radpcs;

      grant debug any procedure to radpcs;

      grant debug connect session to radpcs;

      grant delete any table to radpcs;

      grant drop any cluster to radpcs;

      grant drop any context to radpcs;

      grant drop any dimension to radpcs;

      grant drop any directory to radpcs;

      grant drop any index to radpcs;

      grant drop any indextype to radpcs;

      grant drop any library to radpcs;

      grant drop any operator to radpcs;

      grant drop any outline to radpcs;

      grant drop any procedure to radpcs;

      grant drop any role to radpcs;

      grant drop any sequence to radpcs;

      grant drop any snapshot to radpcs;

      grant drop any synonym to radpcs;

      grant drop any table to radpcs;

      grant drop any trigger to radpcs;

      grant drop any type to radpcs;

      grant drop any view to radpcs;

      grant drop profile to radpcs;

      grant drop public database link to radpcs;

      grant drop public synonym to radpcs;

      grant drop rollback segment to radpcs;

      grant drop tablespace to radpcs;

      grant drop user to radpcs;

      grant execute any indextype to radpcs;

      grant execute any library to radpcs;

      grant execute any operator to radpcs;

      grant execute any procedure to radpcs;

      grant execute any type to radpcs;

      grant flashback any table to radpcs;

      grant force any transaction to radpcs;

      grant force transaction to radpcs;

      grant global query rewrite to radpcs;

      grant grant any object privilege to radpcs;

      grant grant any privilege to radpcs;

      grant grant any role to radpcs;

      grant insert any table to radpcs;

      grant lock any table to radpcs;

      grant manage tablespace to radpcs;

      grant on commit refresh to radpcs;

      grant query rewrite to radpcs;

      grant restricted session to radpcs;

      grant resumable to radpcs;

      grant select any sequence to radpcs;

      grant select any table to radpcs;

      grant under any table to radpcs;

      grant under any type to radpcs;

      grant under any view to radpcs;

      grant unlimited tablespace to radpcs;

      grant update any table to radpcs;

      grant select on dba_free_space to radpcs;

      grant select on dba_data_files to radpcs;

      4.在sqlplus下创建Directory

      命令:createdirectory oracleDB as 'D:OracleDB';

      
    5.把读写权限授予特定用户

      命令:Grantread,write on directory oracleDB to radpcs;

      6.在dos窗口执行impdp导入命令

      命令:impdp radpcs/ictradpcs@rdpcs directory=oracleDB dumpfile=20150226.dmp logfile=20150226.log;

      漫长的等待后,dos窗口会提示导出完成。如果导入过程出错,会提示错误信息(只要数据完整,一些错误可以忽略)。

    展开全文
  • Oracle wallet 配置 说明

    万次阅读 2017-12-01 15:07:07
    一.官网对Wallet的说明... Security administratorsuse Oracle Wallet Manager to manage public key security credentials on Oracleclients and server
  • Oracle Database Products > Exadata > Database Machine Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.3 [Release 11.1 to 11.2] Information in this document applies to
  • Oracle 11gR2 RAC 新特性说明

    万次阅读 2017-12-01 13:24:17
      最近接触了一下Oracle 11g R2 的RAC,发现变化很大。所以在自己动手做实验之前还是先研究下它的新特性比较好。   一. 官网介绍   先看一下Oracle 的官网文档里对RAC 新特性的...
  • Mac下使用jenv管理多个版本的JDK

    千次阅读 2015-05-06 21:05:21
    转载地址:http://www.jenv.be/ Github:https://github.com/gcuisinier/jenv ...Manage your Java environment http://www.jenv.behttps://github.com/gcuisinier/jenv@gcuisinier What's j
  • Oracle 用户及角色 介绍

    万次阅读 2017-12-06 09:37:39
    一. 用户管理1.1 建立用户(数据库验证) CREATE USER DAVE IDENTIFIED BY pwd DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp QUOTA 5m ON users; 1.2 修改用户ALTER USER DAVE QUOTA 0 ON ...
  • Oracle-数据泵expdp/impdp实操

    千次阅读 2018-06-01 03:00:00
    概述数据泵的作用: 1.实现逻辑备份和逻辑恢复 2.在数据库用户之间移动对象 3.在数据库之间移动对象 4.实现表空间转移 数据泵的特点与传统导出导入的区别 1.EXP和IMP是客户段工具程序, EXPDP和IMPDP是服务端的工具...
  • 数据泵IMPDP 导入工具的使用

    万次阅读 2013-07-01 17:32:45
    --=================================--数据泵IMPDP 导入工具的使用--================================= 数据的导入导出时数据库经常处理的作业之一,Oracle 提供了IMP和IMPDP以及SQL*Loader等工具来完成数据的...
  • ORACLE EXPDP/IMPDP 参数详解

    万次阅读 2011-05-17 15:58:00
    Oracle Database 10g引入了最新的数据泵(Data Dump)技术,使DBA或开发人员可以将数据库元数据(对象定义)和数据快速移动到另一个oracle数据库中.数据泵导出导入(EXPDP和IMPDP)的作用1,实现逻辑备份和逻辑恢复.2,在...
  • Oracle 10g Data Pump Expdp/Impdp 详解

    万次阅读 2017-12-05 17:08:17
    一. 官网说明1. Oracle 10g文档如下:... Data Pump ComponentsOracle Data Pump is made up of three distinct parts:(1)The command
  • Enabling SSL or TLS in Oracle E-Business Suite Release 12 In This Document Section 1: IntroductionSection 2: Concepts and TerminologySection 3: Application Tier SetupSection 4: Database Tier Set
  • expdp 导出sys用户下的表报错ORA-39165 和ORA-39166
  • In this Document   Symptoms   Changes   Cause   Solution   References ...Oracle Applications Technology Stack -
  • Oracle默认用户名与密码速查表

    万次阅读 2014-03-15 20:57:35
    Oracle 10g 默认安装带来的... (2012-05-27 23:10:41) 转载▼ ...oracle数据库 ...ORACLE数据库创建的时候,创建了一系列默认的用户和表空间 Oracle 10g 默认安装带来的用户名/密码 Username Password
  • Oracle Fusion Middleware provides two types of components: A Java component, which is an Oracle Fusion Middleware component that is deployed as one or more Java EE applications and a se
  • 一、Oracle Access Manager 11g安装指南

    千次阅读 2011-01-14 14:38:00
    环境:Oracle Access manager 11.1.1.3 on RHEL5.4 64bitOracle Internet Directory 11.1.1.3 on RHEL5.4 64bitWeblogic Server 10.3.3 on RHEL5.4 64bitOracle Jrockit JDK 1.6.0_20Oracle Database 10.2.0.4...
  • Oracle Database Development (4). Example Makefile for Pro*CVert MelonJun 8,2007It is a pity that there is a few aritcle written in Chinese which talking about the material method of Makefile f
1 2 3 4 5 ... 20
收藏数 4,391
精华内容 1,756
关键字:

directory manage oracle