-
编辑 删除
补接_oracle rac_node addition and deletion for clusterware or software
Adding an Oracle Clusterware Home to a New Node Using OUI in Interactive Mode 1. Ensure that you have successfully installed Oracle Clusterware on at least on...
-
编辑 删除
近期oracle upgrade book and rac manual 手记
1,whenever sqlerror exit --表示当在sqlplus中执行命令不正确时，马上退出sqlplus whenever oserror exit --同上2,set numwidth 30 --配置number类型的列显示宽度3,rem(remark) --注解sql ...
-
编辑 删除
Downgrade the Database
Complete the following steps to downgrade your release 10.2 database to the Oracle Database release from which you originally upgraded:Log in to the system as the owner of the release 10.2 Ora...
-
编辑 删除
转载__sqlplus相关tip
小窍门–sqlplus中使用backspace键Thursday, October 11th, 2007在unix下使用sqlplus，backspace默认是不支持删除的而是出现“^H，有时候感觉特别不方便。出现这个问题原因我猜测是因为sqlplus不...
-
编辑 删除
从oracle817升到1201（或之后）必须作的工作
Tasks to Complete Only After Upgrading a Release 8.1.7 DatabaseUpgrade User NCHAR ColumnsTo upgrade user tables with NCHAR columns, perform. the following steps:Log in to the system as the owner of ...
-
编辑 删除
手工升级_manual upgrade_后升级ocr
Upgrade the Oracle Cluster Registry (OCR) ConfigurationIf you are using Oracle Cluster Services, then you must upgrade the Oracle Cluster Registry (OCR) keys for the database.Use one of the followin...
-
编辑 删除
upgrade oracle rman catalog
Upgrading the Recovery CatalogIfyou use a version of the recovery catalog that is older than thatrequired by the RMAN client, then you must upgrade it. For example, youmust upgrade the catalog if ...
-
编辑 删除
oracle_1201_upgrade_第二部
Using the Pre-Upgrade Information ToolThe Pre-Upgrade Information Tool is a SQL script. that ships with the new Oracle Database 10grelease, and must be copied to and run from the environment of ...
-
编辑 删除
测试学习oracle10g_dbca各种数据库类型（普通，事务处理，定制，数据仓库）
Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE</w:LidThemeComplexScript. ...
-
编辑 删除
oracle1201_upgrade manual_第一部
1,先引录如下升级流程图片2,上述各步骤细述Step 1: Prepare to UpgradeBecome familiar with the features of the new Oracle Database 10g release.Determine the upgrade path to the new Oracle Datab...
-
编辑 删除
oracle10g_client_installation_note
1，安装和install server同理2,三大安装类型：administator (可以管理db),  ...
-
编辑 删除
hi,all,only testing
1,learning2,embedding pic
-
编辑 删除
在oracle10g (1201) for x86升级到1204
1,到oracle metalink下载oracle 1204 patch for oracle 1201 x86介质包2,ftp上述包到安装有oracle 1201的节点（注：请以oracle用户上传，之后unzip it)3,在patch节点查看oracle 1201实例是否运行，监听器是否运行，a...
-
编辑 删除
通过oracle dbms_job创建table
1,如何利用dbms_job创建表(table) conn test/system2,创建存储过程（创建表）SQL> create procedure lv 2 is 3 i varchar2(1000); 4 begin 5 i:='create tabl...
-
编辑 删除
配置solaris 10_oracle10g_dbstart_dbshut自动启停库
1,更改配置如下内容：bash-3.00# more /var/opt/oracle/oratab --linux 在/etc/oratab## This file is used by ORACLE utilities. It is created by root.sh# and updated by the Database Configuratio...
-
编辑 删除
oracle10g_rman_cross os_同字节序_convert database
限制: 1,redo and control file不是直接cp,会有一个转变,但在目标库会有open resetlogs操作 2,bfile不能传送,可以手工cp 3,本地管理临时表空间不能传送,当传送脚本运行会自动在...
-
编辑 删除
利用oracle10g_rman_convert_transportable tablespace迁移表空间
前言: 利用rman cross-platform. transfortable databases and tablespaces 跨os平台迁移数据库或表空间不同是指:字节序不同(可在源库rman convert tablespace 或者在目标库convert datafile)1,在源库&n...
-
编辑 删除
续上_在同一节点上利用rman duplicate复制数据库
1,根据target库的spfile创建用于auxiliary instance的pfile 注意相关的dump目录要预先构建好,control_files要和duplicate库配置成一致,其他和上节所述(两机duplicate db)一样-bash-3.00$ more same.ora dup.__d...
-
编辑 删除
solaris10_快速查看哪些目录或文件占用根分区_方法
Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE</w:LidThemeComplexScript. ...
-
编辑 删除
续上_加深学习oracle10g_rman duplicate相关skip选项
测试rman duplicate选项---skip readonly,skip tablespace1,在target上，构建一个测试以上相关选项的表空间-bash-3.00$ hostnamecapitek1-bash-3.00$ sqlplus '/as sysdba'SQL*Plus: Release 10.2.0.1.0 - Productio...
