ITPub博客

ksvcreate: Process(m000) creation failed10. 7. 2009, 12.09 Alert.log:==========Fri Jul 10 09:24:19 2009WARNING: inbound connection timed out (ORA-3136)Fri Jul 10 09:30:11 2009Process m000 died, see its trace fileFri Jul 10 09:30:11 2009ksvcreate: Process(m000) creation failedFri Jul 10 09:31:12 2009Process m000 died, see its trace fileTrace file:===========*** SERVICE NAME:(SYS$BACKGROUND) 2009-07-09 20:35:37.278*** SESSION ID:(3295.1) 2009-07-09 20:35:37.278ktsmgtur(): TUR was not tuned for 164

SQLNET.AUTHENTICATION_SERVICESPurposeUse the parameter SQLNET.AUTHENTICATION_SERVICES to enable one or more authentication services. If authentication has been installed, it is recommended that this parameter be set to either none or to one of the authentication methods.DefaultNone ValuesAuthentication Methods Available with Oracle Net Services: * none for no authentication methods. A valid username and password can be used to access the database.* all for all authentication methods* nts fo

echo "" > /etc/ld.so.preload orabug 解决方案ERROR: ld.so: object '/lib/libcwait.so'[@more@]

今天再安装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 configuredSetting 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_ORACLE

关于监听的操作注册（register)就是将数据库作为一个服务注册到监听（listener）.客户端不需要知道数据库名字和实例名字，只需要知道数据库对外提供的服务名（service_name)就可以申请连接到数据库.这个服务名字可以设置成和实例名字一样，也可以根据业务需求设计。在数据库启动过程。oracle会向监听程序注册相应的服务，任意的一个数据库都会有两条信息注册到监听器中：oracle对应的instance_name和service_name。客户端是通过监听程序连接到数据库服务器的，监听中记录着相应的oracle service，而客户端只需要在tnsnames中提供正确的服务

Oracle的内存分配会为'Fixed SGA Size'和'Redo Buffers'共享整数倍个Granule。SQL> startupORA-32004: obsolete and/or deprecated parameter(s) specifiedORACLE instance started.Total System Global Area 1048576000 bytesFixed Size 2089376 bytesVariable Size 801115744 bytesDatabase Buffers 239075328 bytesRedo Buffers 6295552 bytesDatabase mounted.Database opened.SQL> set timing onSQL> select * from v$version;BANNER------------------------------

CREATE OR REPLACE FORCE VIEW SYS.dba_tables (owner, table_name, tablespace_name, cluster_name, iot_name, status, pct_free, pct_used, ini_trans,

Oracle需要把数据恢复到比当前controlfile所纪录的SCN还要靠后的位置（比如说，control file是backup controlfile , 或者 controlfile是根据trace create的。）,这时候，就需要用using backup controlfile. 恢复就不会受“当前controlfile所纪录的SCN”的限制。这时候的限制就来自于你的语句(until time , until scn)，或者可用的archive log(until cancel)我这里理解为使用using backup controlfile只是 取消以当前控制文件scn为基准的限制，但是通常使用using backup controlfile的情况是startup scn 大于 system checkpoint scn的情况

确认这个错误我一共分三个步骤：1：oracle正确安装了，但是建库时候dbca无法打开，提示没有这个命令。那么就可以确认这个是环境变量的问题，env | PATH没有发现$ORACLE_HOMEcd $ORACLE_HOME | pwd提示为： /home/oracle我的oracle_home目录为：/oracle/product/10.2.0/db_1-------------------------------------------------很显然问题出在这里，vi .profile修改 export PATH=$ORACLE_HOME/bin:.:$PATH:/usr/local/bin:/usr/ccs/bin为 export PATH=$PATH:$ORACLE_HOME/bin:.:$PATH:/usr/local/bin:/usr/ccs/bin经过发现这个错误一般在aix

当启动数据库时，如下提示：SQL> startupORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=oldhostname)(PORT=1521))'那么，一个可能的原因就是因为更改了主机名，导致实例无法注册，解决办法是修改初始化参数以及相应的网络配置文件（listener.ora、tnsnames.ora）。如果数据库启动是使用的spfile，那么首先使用spfile创建字符文件pfile，修改pfile，再使用pfile创建spfile。通常情况下，pfile和spfile的默认路径是：$ORACLE_HOME/dbs。SQL&

ora 10201 bug3:TNS-12542: TNS:address already in useTNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Solaris Error: 125: Address already in use无法重建监听。netstat -a |grep 1521发现应用连着，lsnrctl stop报错TNS-12542: TNS:address already in useTNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Solaris Error: 125: Address already in use没办法 关闭应用服务器，重启小机，问题解决。metalink解释：Step 1. Identify the faulty listening endpoint (the one

ora 10201 bug监听配置全部正确，无法监听到实例告警无报错，重建监听解决。[@more@]

ora 10g 10201BUG1：shutdown immediate 时系统hung住，经metalink查询：Verify that temporary segments are decreasing---------------------------------------------To verify that the temporary segments are decreasing have an active session available in Server Manager or SQLPLUS during the SHUTDOWN IMMEDIATE. Issue the following query to ensure the database is not hanging, but is actually perform extent cleanup:SVRMGR/SQL> select count(block#) from fet$;COUNT(BLOC----------7SVRMGR/SQL> select cou

11.1.0.X.011.1.0.X.0 TO 11.1.0.6.0The BASE release of Oracle 11g Release 1 is 11.1.0.6.11.1.0.X.0 TO 11.1.0.7.01. Install the 11.1.0.7.0 patchset on top of the 11.1.0.6.0 ORACLE_HOMEPatchset number is : 6890831Patch 68908312. Finish the post installation steps as per the patchset README (patch_note.htm).REFERENCE:Availability and Known issues for 11.1.0.7 Note 738538.111.1.0.X.0 TO 11.2.0.1.01. Install 11.2.0.1.0 softwareThe software can be downloaded from the following link :http://www.oracle.c

10.1.0.X.010.1.0.X.0 TO 10.1.0.3.01. Install the 10.1.0.3.0 patchset on top of the existing 10.1.0.X.0 ORACLE_HOMEPatchset number is : 3761843Patch 37618432. Finish the post installation steps as per the patchset README (patch_note.htm).REFERENCE: Known issues and alerts affecting 10.1.0.3 Note 280554.1 List of fixes added in 10.1.0.3 Note 280552.110.1.0.X.0 TO 10.1.0.4.01. Install the 10.1.0.4.0 patchset on top of the existing 10.1.0.X.0 ORACLE_HOMEPatchset number is : 4163362Patch 41633622. Fi

9.2.0.X.X 9.2.0.X.0 TO 9.2.0.3.01. Install the 9.2.0.3.0 patchset on top of the existing 9.2.0.X.0 ORACLE_HOMEPatchset number is : 2761332Patch 27613322. Finish the post installation steps as per the patchset README (patch_note.htm).REFERENCE:Known issues and alerts affecting 9.2.0.3Note 246001.1List of fixes added in 9.2.0.3 Note 245939.19.2.0.X.0 TO 9.2.0.4.01. Install the 9.2.0.4.0 patchset on top of the existing 9.2.0.X.0 ORACLE_HOMEPatchset number is : 3095277Patch 30952772. Finish the post

Applies to:Oracle Server - Standard Edition - Version: 8.1.7.0 to 11.2.0.2 - Release: 8.1.7 to 11.2Oracle Server - Enterprise Edition - Version: 8.1.7.0 to 11.2.0.2 [Release: 8.1.7 to 11.2]Information in this document applies to any platform.GoalThis article provides an upgrade reference list for most available Oracle Database versions, including download information, patch numbers, and links to Metalink articles with detailed information.Solution NOTE : Downloading Patchsets requires a My Or

There are two possible methods for adding in Enterprise Manager. You can use the dbca, or you can use a command line tool called emca. I will be using emca, but before I do, I will show you some common errors you will want to avoid as seen through dbca. The first error to look at is here:You would think that with a GUI tool like dbca, Oracle would check for that condition before running the scripts to add in the repository, and either fail first or make the necessary change for you. Rather than

TNS-12542: TNS:address already in useTNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 125: Address already in use系统是suse linux , oracle 10.2.0.1监听无法查看状态，无法停止，无法删除。查看端口 lsof -l | grep 1521发现后台有监听在跑，kill -9 杀掉进程后还是无法操作监听。nestat -a |grep 1521发现不少客户端占用端口1521.metakink 查询为bug。重启生产库系统，监听就能启动，解决办法 升级。[@more@]

默认情况下oracle的sga都是自动的，其中涉及的为sga_target这个参数---------------------------------------------------------那么你有时候要设置sga_target这个参数的时候，你必须注意一个参数首先在sqlplus中show parameter sga确定sga_max_size的大小比你要设置的sga_target还要大，否则就需要在$ORACLE_HOME/dbs中修改init_SID.ora，在里面添加sga_max_size=*******最好是设置为字节~~~当然也许你会以M为单位，但是这里建议以字节为单位。字节计算的麻烦，你可以在sqlplus下计算比如你要设置800M的sga_max_size，那么这800m的字节数