ITPub博客

IBM P650 OS:AIX5.3 ORACLE10.2.0.3 RAC RAWORA-19502: write error on file blockno 257 (blocksize=8192)ORA-27063: number of bytes read/written is incorrectORA-19625: error identifying file /opt/oracle/archive/oa_arch/1_2483_631301302.dbfORA-27037: unable to obtain file status[@more@]allocated channel: c1channel c1: sid=1480 instance=oa2 devtype=DISKsql statement: alter system archive log currentexecuting command: SET COMMAND IDStarting backup at 23-MAY-08channel c1: starting incremental level 0 dat

在ORACLE中对在线重做日志文件进行调整[@more@]1.增加在线归档日志alter database add logfile group 4 ('/home/oracle/oracle/product/10.2.0/oradata/gdimp/redo04.log') size 50M;alter database add logfile group 5 ('/home/oracle/oracle/product/10.2.0/oradata/gdimp/redo05.log','/home/oracle/oracle/product/10.2.0/oradata/gdimp/redo05.log') size 50M;alter database add logfile member '/home/oracle/oracle/product/10.2.0/oradata/gdimp/redo042.log' to group 4; 2.检查在线重做日志文件状态select * from v$log;3.转换

在alert_sid.log 发现如下ORA-00600:ORA-04030问题[@more@]Errors in file /opt/oracle/admin/oa/bdump/oa1_mmon_446656.trc:ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [kksCallPopCallback]ORA-04030: Message 4030 not found; No message file for product=RDBMS, facility=ORA; arguments: [88] [kxs-heap-c] [kxscomp]Thu May 15 14:00:43 2008Errors in file /opt/oracle/admin/oa/bdump/oa1_mmon_446656.trc:ORA-00600: Message 600 not found; No message file for product

异常状态下在ORACLE下进行temporary tablespace的切换[@more@]1.查找用户分配临时表空间情况SQL> select default_tablespace ,temporary_tablespace,username from dba_users;DEFAULT_TABLESPACE TEMPORARY_TABLESPACE USERNAME------------------------------ ------------------------------ ------------------------------SYSTEM TEMP SYSSYSTEM TEMP SYSTEMSYSTEM TEMP DBSNMPTOOLS TEMP TONGZFJ_SYSTEM TEMP CES#SYSTEMWANG SDGOV_TEMP WANGTOOLS TEMP RMANUSERS TEMP HNZX_HQSYSTEM TEMP OUTLNSYSTEM TEMP WMSYS15 rows selecte

首在在root 用户下 vi /etc/oratab 将如下字样修改成drs01:/u01/app/oracle/product/10.2:Y然后 vi /etc/rc.d/rc.local 增加如下字符su - oracle -c "/u01/app/oracle/product/10.2/bin/lsnrctl start"su - oracle -c "/u01/app/oracle/product/10.2/bin/dbstart start" 可以在root用户下测试一下配置路径是否正确:su - oracle -c "/u01/app/oracle/product/10.2/bin/lsnrctl status"Services Summary...Service "sdrs01" has 1 instance(s).等信息为配置正常[@more@]

重建控制文件后,对临时表空间(temporary tablespace)进行重建;有时日常管理中需要对临时表空间进行维护[@more@]查找修改前用户的属性SQL> select username,temporary_tablespace from dba_users;USERNAME TEMPORARY_TABLESPACE------------------------------ ------------------------------MGMT_VIEW TEMPSYS TEMPSYSTEM TEMPDBSNMP TEMPSYSMAN TEMPRMAN TEMPOUTLN TEMPMDSYS TEMPORDSYS TEMPCTXSYS TEMPANONYMOUS TEMP查找临时表空间的位置SQL> select name from v$tempfile;NAME----------------------------------------------

ORA-00202: control file: ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryalter system set control_files='/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g01.ctl','/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g02.ctl','/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g03.ctl' scope=spfile;[@more@]当database 处于open status 时可以用alter system set control_files='/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g01.ctl','/opt/ora10g/oradata/ORA10G/c

在所有节点配置SSH的对等性在安装Oracle Real Application clusters之前,必须先配置所有节点的SSH对等性。因为在安装过程种Oracle Universal Installer使用ssh和scp命令执行远程命令执行及copy的工作,还可以用来传送错位的归档日志文件。[@more@]下面是具体的步骤：以下步骤在所有节点上执行以oracle用户登陆# su – oracle==========================================================在两个节点的oracle主目录分别创建.ssh目录，并赋予权限。==========================================================# mkdir /opt/oracle/.ssh# chmo

计算机系统的性能优化是一个综合性较强的话题，它涉及对系统资源以及应用环境（如应用程序及网络环境）的分析。本文将就如何检测RS/6000系统性能，找出引起性能降低的资源瓶颈做一个简单介绍所谓系统资源包括内存、CPU和输入/输出设备。通过使用以下命令，可以对RS/6000系统资源的负载情况有一个清楚的了解:[@more@]vmstat svmon ps tprof iostat netpmon filemon 注: 使用命令vmstat、iostat和sar之前需安装软件包 bos.acct 使用命令ps需安装软件包 bos.rte.control 使用命令tprof、svmon、netpmon和filemon之前，需要安装软

使用SQL_TRACE进行数据库诊断作者：eygle | English Version 【转载时请务必以超链接形式标明文章原始出处和作者信息及本声明】链接：http://www.eygle.com/archives/2004/10/use_sql_trace_to_diagnose_database.html [@more@]

一次数据库的简单性能优化:增加INDEX表空间,增大在线归档日志组文件,增大在物理内存允许范围内sag_target,增大log_buffer[@more@]=========================================================1、建立专用Index表空间=========================================================CREATE TABLESPACE INDX DATAFILE '/home/oracle/oracle/product/10.2.0/oradata/gdimp/INDEX.dbf' SIZE 5120M AUTOEXTEND OFFLOGGINGONLINEPERMANENTEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8KSEGMENT SPACE MANAGEMENT AUTO==========================

HA:OCR集群注册表的维护[@more@]==========================================================检查OCR的物理备份==========================================================$ ocrconfig -showbackupdb02 2008/04/08 07:38:49 /opt/oracle/crs/cdata/crsdb02 2008/04/08 03:38:48 /opt/oracle/crs/cdata/crsdb02 2008/04/07 23:38:46 /opt/oracle/crs/cdata/crsdb02 2008/04/06 15:38:36 /opt/oracle/crs/cdata/crsdb02 2008/03/25 11:37:07 /opt/oracle/crs/cdata/crs$ ls -lt /opt/oracle/crs

检查linux GD环境是否有相关包[@more@][root@app conf.d]# rpm -qa |grep zlibzlib-devel-1.2.1.2-1zlib-1.2.1.2-1[root@app conf.d]# rpm -qa |grep libpnglibpng10-1.0.16-1libpng-devel-1.2.7-1libpng10-devel-1.0.16-1libpng-1.2.7-1[root@app conf.d]# rpm -qa |grep freetypefreetype-2.1.9-1freetype-demos-2.1.9-1freetype-devel-2.1.9-1freetype-utils-2.1.9-1[root@app conf.d]# rpm -qa |grep jpeglibjpeg-devel-6b-33libjpeg-6b-33[root@app conf.d]# rpm -qa |grep gdgdbm-1.8.0-24gdb-6.1post-1.20040607.62gd-devel-2.0.28

ORA-32700,ORA-00221,ORA-00206等错误出现在数据库恢复过程中[@more@]Linux ractest 2.4.21-32.ELsmp #1 SMP Fri Apr 15 21:17:59 EDT 2005 i686 i686 i386 GNU/Linux###################alert_sid.ora中日志记录################2008年3月20号09:04:50 ractest所在服务器重启后进行数据库的重启Wed Mar 12 11:51:58 2008Creating archive destination LOG_ARCHIVE_DEST_1: '/opt/***/**gov/archive/1_463.dbf'Wed Mar 12 11:51:58 2008Log actively being archived by another processWed Mar 12 11:52:00 2008ARCH: Completed archiving

sqlnet.ora中的NAMES.DIRECTORY_PATH设置[@more@]sqlplus sys/oracle@orcl　　　　假如我的sqlnet.ora是下面这个样子D:oracleproduct10.2.0db_1NETWORKADMIN>type sqlnet.ora# This file is actually generated by netca. But if customers choose to# install "Software Only", this file wont exist and without the native# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES = (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES,HOSTNAME)那么，客户端就会首先在tnsnames.or

无论何时启动一个数据库，默认的都有两条信息注册到监听器中：实例和服务  [@more@]init.ora中设定instance_name,service_names，db_domain,db_name的值 alter database register命令手工地在监听器中注册服务值 connect_data= (service_name=mydb.dbcool.com)  

修改sys ,system用户密码[@more@]SQL> alter user sys identified by syspwd; User altered.SQL> alter user system identified by systempwd;User altered.=============================针对raw 的密码文件如何修改!orapwoa2 -> /dev/roa_pwdfile_100m

转载至http://218.94.123.17/viewthread.php?tid=80137[@more@]

查看OS版本及Patch列表可以使用 showrev 命令[@more@]root@svr1.sd.gov.cn # man showrevReformatting page. Please Wait... doneMaintenance Commands showrev(1M)NAME showrev - show machine and software revision informationSYNOPSIS /usr/bin/showrev [ -a ] [ -p ] [ -w ] [ -c command ] [ -s hostname ]root@svr1.sd.gov.cn # showrev Hostname: svr1.sd.gov.cnHostid: 80e63ae6Release: 5.8Kernel architecture: sun4uApplication architecture: sparcHardware provider:

在oracle用户下进入/opt/oracle/product/10.2.0/db_1/OPatch/目录,执行$ ./opatch lsinventory检查升级情况[@more@]$ ./opatch lsinventoryInvoking OPatch 10.2.0.3.0Oracle interim Patch Installer version 10.2.0.3.0Copyright (c) 2005, Oracle Corporation. All rights reserved..Oracle Home : /opt/oracle/product/10.2.0/db_1Central Inventory : /opt/oracle/oraInventory from : /etc/oraInst.locOPatch version : 10.2.0.3.0OUI version : 10.2.0.3.0OUI location : /opt/oracle/product/10