ITPub博客

用于检查自动扩展的表空间何时需要增加数据文件。#!/usr/bin/bash## Nagios plugin to check Oracle tablespace free blocks.## $Id: check_tablespace.sh,v 1.0 2010/11/12 $## Copyright (C) 2010-2011  Yu j...

用于nagios监控Oracle ASM DiskGroup空间使用情况。#!/usr/bin/bash## Nagios plugin to check Oracle ASM DiskGroup usage.## $Id: check_asmdg_usage.sh,v 1.0 2010/11/10 $## Copyright (C) 2010-2011  Yu j...

功能：在归档日志备份完成且被DataGuard备库应用完成后，从主库删除。################################################################################## Copyright 2010 BII-ERG Limited, All rights reserved#...

Oracle Block change Tracking improves the incremental Backup performance and is used to record changed blocks in each datafile in a change tracking file. If change Tracking is enabled, RMAN uses blo...

1. 检查SP及状态root@trs00mlcprc02:~ #> /opt/Navisphere/bin/naviseccli -user monitor -password monitor -scope 0 -h 10.99.8.30 getspSP ACabinet:         &nbs...

使用commvault进行Oracle表级恢复失败，经检查发现是commvault自动创建的auxiliary实例无法启动。手工启动此实例时报错提示shared pool size太小。查看auxiliary实例的init文件,发现以下初始化参数：db_files=5000sh...

1、安装包SUNWaccr和SUNWaccu2、# ln /etc/init.d/acct /etc/rc2.d/S22acct   # ln /etc/init.d/acct /etc/rc0.d/K22acct或   # ln -s /etc/init.d/acct /etc/rc2.d/S22acct   # ln -...

1. 光纤交换机设置NTP Server检查当前NTP配置:fcs00mlcprc01:FID128:admin> tsclockserverActive NTP Server               LOCLConfigured...

1. In the File menu, click Set Up Domain > NTP.2. In the NTP Configuration dialog box, enter the IP address, and optionally the Key ID and Key Value for the NTP server you are adding.3. To enable NTP ...

http://www.oracle-home.ro/Oracle_Database/Architecture/Oracle-service-name.htmlLook at these cases and see how an Oracle service is named function of the pfile/ spfile parameters.Listener.ora...

http://www.orafaq.com/node/2033How to Identify OS or Oracle 64 bit or 32 bit on Unix---------------------------------------------------------------It is very common question which version of oracle ...

在non-global zone用lofiadm加载ISO文件时报错：# lofiadm -a /mq/WMQ_600_solarisx86.isolofiadm: /dev/lofictl: No such file or directory如果要在non-global zone中使用lofiadm,需要把lofi expose给non-global z...

今天遇到一个奇怪问题，发现srvctl和crs_start命令无法启动Oracle RAC实例，但用sqlplus却可以正常启动。最终发现原因是在OCR中数据库的状态变成了disable，将此状态更改为enable后恢复正常。以下是一个模拟示例：or...

DescriptionIn Sun[TM] Cluster 3.0 and 3.1 releases it was only possible to change "did" (device id) manually as it was automatically generated. In 3.2 it is still generated automatically however no...

Solaris系统定义的错误代码存储在/usr/include/sys/errno.h文件中。有了这个错误代码就能知道系统日志中错误代号的具体含义了。以下是该文件内容：/* * Copyright (c) 2000 by Sun Microsystems, Inc. * A...

http://eryin.blog.**.com/320220/244308环境描述：本机：Windows Server 2003（localhost）中转机：CentOS 5.3（192.168.1.83）服务器：Windows Server 2003（192.168.1.84）一、在PUTTY中程序界面添加加密隧道...

报错原因是ssh错误地使用了库文件/opt/csw/lib/libcrypto.so.0.9.7所致。root用户执行ssh时报错：root@mlctest01:~ #> sshld.so.1: ssh: fatal: relocation error: file /usr/bin/ssh: symbol SUNWcry_installed: re...

utlrp.sql用来编译数据库内无效的对象，但有时可能会遇到utlrp.sql执行时间很长的情况。utlrp.sql执行时间长的可能原因之一是数据库并行度过高。以下是在2节点的RAC环境下的测试情况。环境：主机:：2台 ...

http://www.madboa.com/geek/dig/Introduction dig is a command-line tool for querying DNS name servers for information about host addresses, mail exchanges, name ...

http://arjudba.bot.clogspom/2010/07/troubleshoot-ora-12547-tns-lost-contact.htmlProblem DescriptionWhenever you connect to database as sysdba it fails with ORA-12517 like below.$ sqlplus / as sysdba...