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

使用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

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@]

在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

查找RAC环境中实例间资源分配情况select * from gv$resource_limit order by RESOURCE_NAME[@more@]1* select * from gv$resource_limit order by RESOURCE_NAME INST_ID RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE---------- ------------------------------ ------------------- --------------- -------------------- -------------------- 1 branches 0 0 1820 UNLIMITED 2 b

一个简单查询语句给出RAC环境中的包含的后台进程[@more@]SQL> select name,description from v$bgprocess where paddr<>'00';NAME DESCRIPTION----- ----------------------------------------------------------------PMON process cleanupDIAG diagnosibility processPSP0 process spawner 0LMON global enqueue service monitorLMD0 global enqueue service daemon 0LMS0 global cache service process 0LMS1 global cache service process 1MMAN Memory ManagerDBW0 db writer process 0ARC0 Archival Process 0ARC1 Archiva

自动数据库诊断临近器( Automatic Database Diagnostic Monitor ,ADDM) ADDM使用的这些数据和来自活动历史会话(ASH)的数据自动地分析该信息，对系统调整及性能问题提出预期的建议．[@more@]ADDM本质上存在两种模式－－预期模式和反应模式；在命令行模式下，可运行DBMS_ADVISOR来获取select dbms_advisor.get_task_report(task_name) as ADDM_report from dba_advisor_tasks where task_id = ( select max(t.task_id) from dba_advisor_tasks t, dba_advisor_log l where t.task_id=l.task_id and t.advisor_name ='ADDM' and l.status = '

(Automatic Workload Repository,AWR)工作负载仓库每隔热60分钟会自动地更新统计数据[@more@]如果用Oracle 9i 和 Oracle 8i StatsPack文本式报表,可以使用DBMS_WORKLOAD_REPOSITORY 命令行API 的AWR_REPORT_TEXT 函数生成文本式报表