ITPub博客

exp 错误：Errors when doing an export.Export log:. exporting cluster definitionsEXP-00056: ORACLE error 4045 encounteredORA-04045: errors during recompilation/revalidation of SYS.KU$_XMLSCHEMA_VIEWORA-22973: size of object identifier exceeds maximum size allowedEXP-00000: Export terminated unsuccessfully[@more@]解决：SolutionWorkaround:1. SQL>show parameter lengthIf the parameter nls_length_semantics=char > complete the next steps2. SQL>connect as sysdbaSQL> alter session set nls_len

在安装过程中会遇见2个报错：1是，运行runInstall报错；2是，运行dbca报错；[@more@]安装报错处理1：1) 在运行CD-Rom 里面的 runInstall,却发现以下错误信息：Error occurred during initialization of VMUnable to load native library: /tmp/OraInstall2003-10-25_03-14-57PM/jre/lib/i386/libjava.so:symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference需要打一个补丁：download the p3006854_9204 patch p3006854_9204_LINUX.zip from http://metalink.oracle.com. See bug 3006854 for

数据库session连接报错：ORA-12537： TNS连接错误操作系统报错：cdksh: 0403-030 The fork function failed. Too many processes already exist.[@more@]错误原因：查看操作系统允许最大连接数：#lsattr -El sys0|grep maxuproc参数默认128。错误解决：把此参数允许最大连接数改大：#chdev -l sys0 -a maxuproc=1024数据库问题立马解决。附调整数据库参数：在sqlnet.ora中将tcp.validnode_checking的值设为no；重启数据库和listener服务。

使用 VMware Server 在 Linux 上安装 Oracle RAC 10g 笔记：[@more@]1. ocfs和asm安装包# cat /etc/redhat-releaseEnterprise Linux Enterprise Linux AS release 4 (October Update 5)# uname -r2.6.9-67.0.4.0.2.ELsmp# uname -pi686ASM包的下载地址:http://www.oracle.com/technology/software/tech/linux/asmlib/rhel4.htmlOCFS2包的下载地址: :http://oss.oracle.com/projects/ocfs2/files/RedHat/RHEL4/i386/1.2.9-1/2.6.9-42.EL/OCFS2 Tools包的下载地址: :http://oss.oracle.com/projects/ocfs2-tools/files/RedHat/RHEL4/i386/1.

故障信息：exec(): 0509-036 Cannot load program crsctl.bin because of the following errors: 0509-130 Symbol resolution failed for crsctl.bin because: 0509-136 Symbol __ct__Q2_3std8_LocinfoFPCci (number 176) is not exported from dependent module /usr/lib/libC.a[ansi_64.o]. 0509-192 Examine .loader section symbols with the 'dump -Tv' command.[@more@]故障原因：xlC.rte 版本低解决方法:升级xlC.rte 版本到9.0.0.1

错误信息：root.sh错误：Failure at final check of Oracle CRS stack.10/oracrs/crs/log/rcy01/client/css.log错误：[ CSSCLNT][1]clsssInitNative: connect failed, rc 9...[@more@]故障原因：网络通信问题；tcp_recvspace和tcp_sendspace故障解决：修改网卡的该参数值；ifconfig en0 down ifconfig en0 detachchdev –l en0 –a tcp_recvspace=65536chdev –l en0 –a tcp_sendspace=131072chdev –l en0 –a rfc1323=1ifconfig en0 up

Oracle RAC 的一个负责故障切换处理的主要组件是透明应用程序故障切换 (TAF) 选件。下面列举通过JDBC实现的透明应用程序故障切换的代码：[@more@]//Tele.zhou Class.forName("oracle.jdbc.driver.OracleDriver"); String url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST =(LOAD_BALANCE = yes)(ADDRESS=(PROTO =TCP)(HOST=node1)(PORT=1521))(ADDRESS=(PROTO =TCP)(HOST=node2)(PORT=1521))(CONNECT_DATA =(SERVICE_NAME = oracleServerName)(failover_mode = (type = select)(method = basic)(retries = 20)(delay =

在对asmlib进行configure时提示：# /etc/init.d/oracleasm configureConfiguring the Oracle ASM library driver. This will configure the on-boot properties of the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets ('[]'). Hitting <ENTER> without typing ananswer will keep that current value. Ctrl-C will abort. Default user to own the driver interface [oracle]: oracleDef

查询v$shared_pool_reserved视图可以判断共享池问题的引发原因： [@more@]SQL>select FREE_SPACE,AVG_FREE_SIZE,USED_SPACE,AVG_USED_SIZE,REQUEST_FAILURES,LAST_FAILURE_SIZE from v$shared_pool_reserved;FREE_SPACE AVG_FREE_SIZE USED_SPACE AVG_USED_SIZE REQUEST_FAILURES LAST_FAILURE_SIZE---------- ------------- ---------- ------------- ---------------- ----------------- 2685760 167860 0 0 0 0如果request_failures>0且LAST_FA

实施步骤：1. 更改init参数resource_limit为TRUE;重新启动数据库；2. 更改用户概要文件profile的“空闲连接时间”；3. 在数据库中查询session状态是“SNIPE”的，通过操作系统orakill命令清除；4.定义windows执行计划，执行kill_session_sql.bat脚本。[@more@]脚本：kill_session_sql.bat内容：set ORACLE_SID=ora9 /**数据库instance SID**/sqlplus system/oracle@ora9 @c:kill_session.sqlc:kill_session.batkill_session.sql内容：spool c:kill_session.batset head offset feedback offset pagesize 1000set term offSelect 'orakill

Oracle数据库对象无效,通过PLSQLDev.exe程序进行包编译;报ORA-03114:连接数据库失败错误.[@more@]Oracle DB版本:9.2.0.1故障原因：PLSQLDev.exe程序和Oracle数据库的CDC功能产生冲突；使用TOAD，OEM等其他客户端工具则不会有以上情况。故障解决：DROP TRIGGER sys.cdc_alter_ctable_before;DROP TRIGGER sys.cdc_create_ctable_after;DROP TRIGGER sys.cdc_create_ctable_before ;DROP TRIGGER sys.cdc_drop_ctable_before;CALL sys.dbms_java.dropjava('-s rdbms/jlib/CDC.jar');Oracle CDC简介 CDC(Change Data Capture)是oracle在数据库

ORA-12154：无法处理服务名[@more@]将sqlnet.ora文件中NAMES.DIRECTORY_PATH= (HOSTNAME)械腍OSTNAME改为TNSNAMES就可以了

环境：Oracle10.2 RAC 到10.2单机环境运行；[@more@]1.准备好相应的目录结构 $cd /home/oracle/admin$mkdir test$cd test$mkdir adump bdump cdump dpdump pfile udump2.使用initoraT.ora创建参数文件inittest.ora$cd dbs$cp initoraT.ora inittest.ora修改inittest2.oratest.__db_cache_size=8388608test.__java_pool_size=4194304test.__large_pool_size=4194304test.__shared_pool_size=67108864test.__streams_pool_size=4194304*.audit_file_dest='/home/oracle/admin/test/adump'*.background_dump_dest='/home/oracle/admin/test/b

在同一个操作系统OS下同时安装DB10g和DB9i:[@more@]配置DB10g的listener为默认；监听名称：LISTENER,端口：1521配置DB9i的listener名称为LISTENER_9,端口：1529修该9i的初始化参数文件项：local_listener参数项上加入'LISTENER_9'值；修改listener.ora文件的(PORT = 1521)为1529；修改tnsnames.ora文件中端口（PORT = 1529)；并加入以下参数项：LISTENER_9 =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1529))重启数据库和监听；