-
编辑 删除
ORA-15186: ASMLIB error function = [asm_open], error = [1]
ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]参考 Metalink Note:398622.1Subject:ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted] Doc ID:Note:398622.1Type:PROBLEM Last Revision Date:06-MAY-2008Status:PUBLISHEDIn this Document Symptoms Cause Solution ReferencesApplies to:Oracle Server - Enterprise Edition - Version: 10.1.0This problem can occur on any platform.Oracle Database ASM (Automatic Storage Man
-
编辑 删除
RAC先关后启过程与在虚拟机上更换IP过程
rac1-> emctl stop dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://rac1:1158/em/console/aboutApplicationStopping Oracle Enterprise Manager 10g Database Control ... ... Stopped. rac1-> srvctl stop service -d snowdb -s portdbrac1-> srvctl stop database -d snowdbrac1-> srvctl stop instance -d snowdb -i snowdb1rac1-> srvctl stop instance -d snowdb -i snowdb2rac1-> srv
-
编辑 删除
ORA-12520错误
2009年10月5日服务器上表现为rac1-> sqlplus ctms/ctms@snowdb2SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 2 16:41:40 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR:ORA-12520: TNS:listener could not find available handler for requested type ofserverEnter user-name: ctmsEnter password: Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining optionsSQL> 客户端表现为 SQL>
-
编辑 删除
RAC的学习(一)---测试RAC1、2切换(1)
前提条件：1.服务器、客户端通讯是否正常rac2-> crs_stat -tName Type Target State Host ------------------------------------------------------------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 ONLINE rac2 ora....C2.lsnr application ONLINE ONLINE rac2 ora.rac2.gsd application ONLINE ONLIN
-
编辑 删除
一主一物一逻备库
经过一定时间的学习与测试，现已完成一主带一逻一物库。顺序为：主---->逻---->物配置为：主：SERVICE_NAMES=SNOWDBDB_UNIQUE_NAME='uqn_node1'LOG_ARCHIVE_CONFIG='DG_CONFIG=(uqn_node2,uqn_node1)'LOG_ARCHIVE_DEST_2= 'SERVICE=fastrise02 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=uqn_node2'LOG_ARCHIVE_DEST_3= 'SERVICE=fastrise03 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=uqn_node2'LOG_ARCHIVE_DEST_STATE_1=ENABLELOG_ARCHIVE_DEST_STATE_2=ENABLELOG_ARCHIVE_DES
-
编辑 删除
Dataguard 物理安装
一 : 环境配置1.查看linux版本号[oracle@fastrise02 /]$ lsb_release -aLSB Version: :core-3.0-ia32:core-3.0-noarch:graphics-3.0-ia32:graphics-3.0-noarchDistributor ID: CentOSDescription: CentOS release 4.7 (Final)Release: 4.7Codename: Final2.查看oracle版本号SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProdPL/SQL Release 10.2.0.1.0 - ProductionCORE 10.2.0.1.0
-
编辑 删除
逻辑备库上有指定表不应用
因有要求要在逻辑备库上有指定表不应用，现做测试如下：涉及到计费的表有：charge_dtlcharge_groupcharge_instrcharge_refcfs_tariffliner_tarifftrk_tariff一．前提条件，正常通讯的两台主备库查询逻辑备库上正在执行归档量select sequence#,first_change#,next_change#,timestamp,applied from dba_logstdby_log order by sequence# ;查看主库的归档量Archive log list;检测是否备库与主库相同的归档量。二．对于逻辑备库上:1.停止正在应用的进程SQL> alter database stop logical standby apply;Database altered.2.执行要在备库上应
-
编辑 删除
OC4J Configuration issue. /u01/oracle/oc4j/j2ee/OC4J_DBConsole_localhost.localdomain_snowdb not foun
[oracle@oracleasm u01]$ emctl status dbconsoleTZ set to PRCOC4J Configuration issue. /u01/oracle/oc4j/j2ee/OC4J_DBConsole_localhost.localdomain_snowdb not found. [oracle@oracleasm u01]$ emca -repos recreateSTARTED EMCA at Sep 20, 2009 11:20:48 PMEM Configuration Assistant, Version 10.2.0.1.0 ProductionCopyright (c) 2003, 2005, Oracle. All rights reserved.Enter the following information:Database SID: snowdbListener port number: 1521Password for SYS user: Password for SYSMAN user: Do you wish to c
-
编辑 删除
快速安装CentOS4.7+Oracle 11g
一、安装虚拟机二、安装CentOS============================编辑主机名vi /etc/hosts172.16.99.195 oracleasm=============================设置开机用文本形式vi /etc/inittab3=============================查看安装软件包 CenOS4.7============================binutils-2.15.92.0.2-18compat-libstdc++-33.2.3-47.3elfutils-libelf-0.97-5elfutils-libelf-devel-0.97-5glibc-2.3.4-2.19 glibc-common-2.3.4-2.19glibc-devel-2.3.4-2.19glibc-headers-2.3.4-2.19gcc-3.4.5-2gcc-c++-3.4.5-2libaio-devel-0.3.105-2libaio-0.3.105-2libg
