ITPub博客

http://space.itpub.net/7607759/viewspace-616379[@more@]

ORA-12638: 身份证明检索失败 的解决办法 sqlnet.ora 中SQLNET.AUTHENTICATION_SERVICES= (NTS)注释掉#SQLNET.AUTHENTICATION_SERVICES= (NTS)[@more@]

Oracle常见等待事件介绍 博客分类： oracle性能调优 SQLOracle数据结构SQL ServerCacheOracle的等待事件是衡量Oracle运行状况的重要依据及指标。等待事件的概念是在Oracle7.0.1.2中引入的，大致有100个等待事件。在Oracle 8.0中这个数目增加到了大约150个，在Oracle8i中大约有200个事件,在Oracle9i中大约有360个等待事件。主要有两种类别的等待事件，即空闲(idle)等待事件和非空闲(non-idle)等待事件。 空闲事件指Oracle正等待某种工作,在诊断和优化数据库的时候,我们不用过多注意这部分事件。常见的空闲事件有:• dispatcher timer&

1.数据库上TB级别，如果数据库挂了，怎么让数据库在最短的时间以内恢复应用。2.请解释一些常见的备份策略，以及 这些策略的优缺点3.客户反映慢，你怎么办4.请说说你对SQL调优是怎么做的5.请你说说Oracle相对于其他数据库有什么优势，有什么劣势6.怎么让CBO保证稳定的执行计划7.请说说你对统计信息的理解以及收集策略8.请列举常见的Oracle错误号，以及这些错误产生的原因，解决方法1.数据库上TB级别，如果数据库挂了，怎么让数据库在最短的时间以内恢复应用 挂了? 挂到什么程度? 文件损坏? Server Crash? Site故障? 不同的"挂&quo

sqlserver有个接口到ORACLE,SYBASE,access.http://www.yiwuya.com/post/233.html [@more@]

http://hi.baidu.com/yuyuliangliang/blog/item/f0ef22f4420270e57709d763.html/cmtid/fd897fda1b0cc2d6b7fd4846[@more@]

背景：undo表空间如果属性是自动增长的，从而表空间过大，那么就重新创建一个新的UNDO表空间。思路：1：查看当前UNDO表空间2：查看数据文件创建地方3：创建UNDO表空间4：切换undo表空间5：将原来的UNDO表空间OFFLINE6：drop 原来表空间。SQL> select name from v$datafile;NAME--------------------------------------------------------------------------------E:ORACLEPRODUCT10.2.0ORADATAFOCUSSYSTEM01.DBFE:ORACLEPRODUCT10.2.0ORADATAFOCUSUNDOTBS01.DBFE:ORACLEPRODUCT10.2.0ORADATAFOCUSSYSAUX01.DBFE:ORACLEPRODUCT10.2.0ORA

现象：在本地服务器不能以 conn /as sysdba 登陆数据库报错：ERROR:ORA-01031: insufficient privilegessolve:查看sqlnet.ora:sqlnet.authentication_services=(none)将(none)修改为(nts),保存文件，就可以解决！！[@more@]

http://www.cnblogs.com/chinhr/archive/2009/12/02/1615071.html[@more@]

面向主题的，集成的，时间的，多维的！[@more@]

http://www.itpub.net/thread-1320024-1-1.html[@more@]

Oracle数据库备份失败RMAN-06059: expected archived log not found, lost of archived log compromises recoverability情形在作业日志RMAN输出中看到如下信息错误： RMAN-03002: failure of backup plus archivelog command at <Date> <Time> RMAN-06059: expected archived log not found, lost of archived log compromises recoverability ORA-19625: error identifying file D:ORA90Archive1.ARC ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) The system cannot find the file sp

exp.bat在执行脚本的时候，出现刷屏。后来经调整 原来 exp 命令要指出路径比如 oracleproduct10.2.0.1binexp ..........[@more@]

由于是windows ,先看看系统日期和时间echo %date%thr 05/05/2011如果用这个日期做文件，导出数据库会有问题会报错误：cannot open ......... write去掉这个“/” 变为“-"可以顺利导出文件。set dt=%date:~4,10%set dmpNAME=%dt:/=-%set NLS_LANG=AMERICAN_AMERICA.AL32UTF8exp system/system@focus file=d:backup_focus%dmpNAME%.dmp log=d:backup_focus%dmpNAME%.log full=y feedback=100002：如果系统日期是这样的：C:Documents and Settingslinda>echo %date%2011-04-28 星期四那么脚本可以这样写：exp system/peng1975@fo

OS : windows 2003 serverDB: oracle 10.2.0.1用exp 导出的时候，每导出一个表都会报错：EXP－00091 Exporting questionable statistics解决办法：select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET'选出结果NLS_CHARACTERSET AL32UTF8windows: set NLS_LANG=AMERICAN_AMERICA.AL32UTF8LINUX/UNIX: export NLS_LANG=AMERICAN_AMERICA.AL32UTF8在导出数据库，就一定会报这个错误了。[@more@]

1：process,session设置过小，会报12156错误2：修改参数命令;alter system set processes=.. scope=spfile;3：create pfile from spfile;4；关闭服务器，重启数据库。5：验证参数，session=1.1process+5SQL> show paramete process; NAME TYPE VALUE------------------------------------ ----------- ------------------------------aq_tm_processes integer 1db_writer_processes integer 1job_queue_processes integer

作业命令rman>run {allocate channel d1 type disk;backup format 'd:backup%d_%s.bak' tablespace users;release channel d1;}configure default device type to sbt;configure default device type to disk;recover database until cancelalter database open resetlogsreport schema;报告陈旧备份report obsolete redundancy 2;list backup of tablespace user01;list buackup of controlfile;list backup of archivelog all;delete obsolete;delete noprompt obsolete;delete noprompt backupset 19;delete backup delete noprompt

1,机型# model9000/861/D2702,CPU个数# topLOAD USER NICE SYS IDLE BLOCK SWAIT INTR SSYS0.15 0.4% 0.0% 0.6% 99.0% 0.0% 0.0% 0.0% 0.0%3,硬盘个数# ioscan -funC diskClass I H/W Path Driver S/W State H/W Type Description=====================================================================disk 0 8/16/5.2.0 sdisk CLAIMED DEVICE TOSHIBA CD-ROM XM-5701TA/dev/dsk/c2t2d0 /dev/rdsk/c2t2d0disk 5 8/16/5.5.0 sdisk CLAIMED DEVICE SEAGATE ST34572N /dev/dsk/c2t5d0 /dev/rdsk/c2t5d0disk 1 8/16/5.6.0 sdisk CLAIMED DEV

To create the volume group and activate it, enter commands similar to the following:# /sbin/mknod /dev/vg_name/group c 64 0xnn0000# /sbin/vgcreate /dev/vg_name /dev/dsk/cxtydz . . .# /sbin/vgchange -a y vg_name In this example:vg_name is the name that you want to give to the volume group 0xnn0000 is a minor number that is unused on all nodes in the cluster /dev/dsk/cxtydz... is a list of one or more block device names for the disks that you want to add to the volume group 1,为卷组创建一个目录，比

grep MemTotal /proc/meminfogrep SwapTotal /proc/meminfo/etc/sysctl.conf中编辑kernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 262144net.core.rmem_max = 262144net.core.wmem_default = 262144net.core.wmem_max = 262144/sbin/sysctl –p在/etc/rc.local中加入（数值以具体情况而定，以下是默认值）modprobe hangcheck-timer hangcheck_tick=30 hangcheck_margin=180# /usr/sbin/user