ITPub博客

今天项目里需要导入一个dmp文件，可是导入的时候报：[@more@]连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options经由常规路径由 EXPORT:V10.02.01 创建的导出文件IMP-00013: 只有 DBA 才能导入由其他 DBA 导出的文件IMP-00000: 未成功终止导入后来将源数据库的用户的DBA权限收回，重新导出，再重新导入：连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options经由常规

在node1节点上可以执行完root.sh脚本，可是在node2上执行的时候居然是：[root@node2 ~]# /opt/ora10g/product/10.2.0/crs_1/root.sh WARNING: directory '/opt/ora10g/product/10.2.0' is not owned by rootWARNING: directory '/opt/ora10g/product' is not owned by rootWARNING: directory '/opt/ora10g' is not owned by rootChecking to see if Oracle CRS stack is already configuredOracle CRS stack is already configured and will be running under init(1M)解决：mv /etc/oracle/scls_scr/node2/oracle/cssfatal /etc/oracle/

1、执行rootdelete.sh 、rootdeinstall.sh script文件在$ORA_CRS_HOME/install 目录下2、Stop the Nodeapps on all nodes:srvctl stop nodeapps -n 3、以root执行以下删除：[@more@]Sun:rm /etc/init.d/init.cssd rm /etc/init.d/init.crs rm /etc/init.d/init.crsd rm /etc/init.d/init.evmd rm /etc/rc3.d/K96init.crsrm /etc/rc3.d/S96init.crsrm -Rf /var/opt/oracle/scls_scr rm -Rf /var/opt/oracle/oprocdrm /etc/inittab.crs cp /etc/inittab.orig /etc/inittabLinux:rm /etc/oracle/*rm -f /etc/init.d/init.cssd rm -f /etc/ini

今天再安装OracleRAC的时候在执行root.sh脚本的时候遇到了以下错误：WARNING: directory '/opt/ora10g/product/10.2.0' is not owned by rootWARNING: directory '/opt/ora10g/product' is not owned by rootWARNING: directory '/opt/ora10g' is not owned by rootChecking to see if Oracle CRS stack is already configured Setting the permissions on OCR backup directorySetting up NS directories/opt/ora10g/product/10.2.0/db_1/install/rootconfig: line 815: 10338 Segmentation fault $CH/bin/ocrconfig -upgrade $CRS_

今天一个朋友在删除某个表的数据时，遇到了600错误：ksedmp: internal or fatal errorORA-00600: internal error code, arguments: [ktspScanInit-d], [46206537], [], [], [], [], [], []Current SQL statement for this session:delete table_tests Product (Component)Oracle Server (Rdbms)Range of versions believed to be affectedVersions < 10.1.0.2 Versions confirmed as being affected9.2.0.4 Platforms affectedGeneric (all / most platforms affected 在以下版本中存在该问题：9.2.05、10.1.0.2问题描述：ORA-600 [

在linux系统上，当启动oracle11g的时候会提示：ORA-845: MEMORY_TARGET not supported on this system[@more@]在这alter log文件里你也会发现以下提示：ORA-04031 errors ORStarting ORACLE instance (normal)WARNING: You are trying to use the MEMORY_TARGET feature.This feature requires the /dev/shm file system to be mounted for atLeast <size> bytes.The /dev/shm is either not mounted or is mountedWith available space less than this size.Please fix this so that MEMORY_TARGET can work as expected.Current a

OS:REDHAT5.3 64bitkernel:2.6.18ORACLE11G 64BIT FOR LINUX在安装oracle11g的时候copy完文件，进行link的时候报了许多Error in invoking target 类错误，说明是找不到lib包或者是编译器错误，检查gcc等编译器都是OK的，1、将/usr/bin下的gcc和gcc++替换为gcc34和gcc++342、在bash_profile内加入LD_LIBRARY_PATH=$ORACLE_HOME/lib3、重装OK[@more@]

环境:REDHAT 5.3 64BITORACLE11G RAM 2G在安装到最后执行root.sh脚本的时候遇到以下错误：./root.sh: line 4: /oracle/app/oracle/product/11.2.0/grid/install/unix/rootadd.sh: Permission denied./root.sh: line 9: /oracle/app/oracle/product/11.2.0/grid/network/install/sqlnet/setowner.sh: Permission denied./root.sh: line 14: /oracle/app/oracle/product/11.2.0/grid/rdbms/install/rootadd_rdbms.sh: Permission denied./root.sh: line 16: /oracle/app/oracle/product/11.2.0/grid/rdbms/install/rootadd_filemap.sh: Perm

ORACLE10GMAN:16GOS:linux5.1安装的时候SGA+PGA一共分配了12G的内存，可是当创建数据库的时候确报ORA-27102,free内存后发现存在有7G的内存是处于缓存阶段，于是先执行:echo 1>/proc/sys/vm/drop_cached 释放缓存，重新安装还是不行，检查配置文件发现：kernel.shmmax这个参数居然后两个值，一个是60G一个是我最后配置的那个值，第一感觉就是分配共享段内存引起的为难题，于是将先前60G的配置删除，sysctl -p后重新安装，这次就可以正常进行。按理来说系统应该取最后一个值也就是我们新增的那个小的值，可见确不是那么绝对。PS: 参数检

[@more@]以下为:spcusr.sql修改后的脚本：RemRem $Header: spcusr.sql 31-may-2005.14:34:29 cdgreen Exp $RemRem spcusr.sqlRemRem Copyright (c) 1999, 2005, Oracle. All rights reserved. RemRem NAMERem spcusr.sqlRemRem DESCRIPTIONRem SQL*Plus command file to create user which will contain theRem STATSPACK database objects.RemRem NOTESRem Must be run from connected to SYS (or internal)RemRem MODIFIED (MM/DD/YY)Rem cdgreen 05/24/05 - 4246955Rem cdgreen 04/18/05 - 4228432Rem cdgreen 10/29/04 - 10gR2_sqlsta

版本 ：9i、10g今天突然想到用sqlldr导入到sys用户下是否可以实现，因为登陆sys用户要使用sysdba的权限[oracle@localhost data]$ sqlldr  /  control=SYS_TEST.ctl  SQL*Loader: Release 10.2.0.4....

今天闲来用用BBED工具，谁知道由于操作不当导致数据文件损坏，启动数据库报：SQL> alter database open;alter database open*ERROR at line 1:ORA-01122: database file 7 failed verification checkORA-01110: d...

最早从 Yong Huang 那里看到关于比较详细的X$表的介绍，后来陆续从其他Oracle专家那里得到了不少信息。在Steve Adams 的书中对X$表多有提及，而且他的站点也是个资源比较丰富的地方。不过在中文Oracle技术社区很少能...

今天需要删除某些没用的表，但是在删除的时候确报一下错误：SQL> drop table test;drop table test*ERROR at line 1:ORA-00604: error occurred at recursive SQL level 1ORA-01422: exact fetch returns more than...

今天需要实现一个随机取出表里的数据一部分数据，发现通过sample来实现即方便效率又高，在此记录一下： select * from emp4 sample(1)  where rownum <10;【0.06s】  select * from (select * from emp4&n...

今天想在Linux配置下oracle到mysql的异构实现，做笔记以记之。首先安装odbc（引用自网络）：方法一：先下载最新的unixODBC源码包（http://www.unixodbc.org/unixODBC-2.2.1.tar.gz）放到/usr/local下，然后运行下...

今天需要将运行的JOB停掉，在后台已经kill掉了session和process，但是发现job的totaltime还在增，没有停止的迹象，感觉是不是没有停掉，于是自己在本机做了个测试，测试步骤如下：1、先建立一个job:begin  sy...

SQL> startupORACLE instance started. Total System Global Area  213909504 bytesFixed Size                 ...

今天启动oracle监听发现报：TNSLSNR for Linux: Version 10.2.0.4.0 - ProductionSystem parameter file is /u01/app/oracle/network/admin/listener.oraLog messages written to /u01/app/oracle/network/log/list...

续oracle10g simpe AQ step by step(一)-------------------session db1 sys赋予权限GRANT DBA, SELECT_CATALOG_ROLE    TO strmadmin; GRANT EXECUTE ON DBMS_APPLY_ADM   TO strmadmi...