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

今天涨工资了，可是我却开心不起来因为出社会来，能聊得那么来值得信任的朋友很少了。他是我同事，今天被辞退了。不开心。他给我留了张纸条，和我道别。唉，天下没有不散的宴席。大学毕业如此，此时今日也是如此。朋友这两个字原来那么沉重[@more@]

郁闷，只是价格count 就不扫描表了SQL> create index idx_luda_zhutou_obna on zhutou(upper(object_name)) online;Index created.SQL> select /*+ INDEX(a IDX_LUDA_ZHUTOU_OBNA)*/ count(a.object_name) 2 from zhutou a 3 where upper(a.object_name) like 'LUDA%';Execution Plan----------------------------------------------------------Plan hash value: 4142235787-----------------------------------------------------------------------------------------------------| Id | Operation | N

SQL> create table t1 (t_id number);Table created.SQL> select index_name from user_indexes where table_name='T1';no rows selectedSQL> insert into t1 values(110);1 row created.SQL> insert into t1 values(120);1 row created.SQL> insert into t1 values(130);1 row created.SQL> insert into t1 values(140);1 row created.SQL> create index idx_t1_id on t1(id) online;create index idx_t1_id on t1(id) online *ERROR at line 1:ORA-00904: "ID": invalid id

关于监听的操作注册（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------------------------------

磁盘备份用的是PGA，一般现在的操作系统都是开启了异步IO的，linux也好还是aix都会在实施系统时候开启，那么在这样的情况下rman备份或者恢复时候在内存中分配的区域是PGA。如果系统不支持一步IO，那么可以在数据库中模拟异步IO，就是对dbwr_io_slaves 设置一个值，那么这时候rman就需要使用共享内存区域，如果没有设置large_pool_size，那么就会直接使用SGA里的内存，为了避免rman和应用对SGA的征用，所以才会设置large_pool.备份到磁带也是会推入到sga中，就是backup_tape_io_slaves=true时候。[@more@]

灾备以及模拟灾备恢复情况4种。怎么查询系统的故障[@more@]

在sqlplus里先创建一个catalog表空间，并创建catalog用户create tablespace catalog datafile '/oracle/catalog.dbf' size 30m;create user luda identified by luda default tablespace luda;grant resource,connect,recovery_catalog_owner,sysdba to luda;------------------------------------------------------------------登陆到恢复目录rman catalog=luda/ludacreate catalog tablespace catalog;--------------------------------------------------------------------登陆到恢复目录和目标数据库rman target=luda/luda catalog=

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

在一次迁移数据库过程中，遭遇如此问题：首先遭遇这个问题处理过程就是看告警，第二show db_recovery查看归档路径和归档目录大小是否正常。这里错误是由于归档目录空间不足SQL> alter database open;alter database open*ERROR at line 1:ORA-16014: log 1 sequence# 47 not archived, no available destinationsORA-00312: online log 1 thread 1:'/oradata/IMSBASE/onlinelog/o1_mf_1_6dnpv5f9_.log'ORA-00312: online log 1 thread 1:'/oracle/flash_recovery_area/IMSBASE/onlinelog/o1_mf_1_6dnpv5rh_.log'SQL> alter system s

当启动数据库时，如下提示：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