ITPub博客

 begin   dbms_redefinition.can_redef_table(uname       => 'CT10000UAM',              ...

Applies to: Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]Information in this document applies to any platform.***Checked for relevance on 24-May-2012***Sym...

故障发生时，主机oracle用户不能登录，数据库登陆异常，并且oracle帐号执行命令很慢，其他帐号正常。登录Oracle用户时提示错误ksh: 0403-030 The fork function failed. Too many processes already exist。 &...

FAILED_LOGIN_ATTEMPTS SQL> conn / as sysdba;Connected.SQL> alter user JTITSM account unlock;User altered.SQL> conn JTITSM/JTITSMERROR:ORA-28000: the account is lockedWarning: You are no longer conne...

USER is "SYS"SQL> conn gggggggg/gggggggg1127Error accessing PRODUCT_USER_PROFILEWarning:  Product user profile information not loaded!You may need to run PUPBLD.SQL as SYSTEMConnected.SQL> show u...

SQL> startup;　　ORA-00119: invalid specification for system parameter LOCAL_LISTENER　　ORA-00132: syntax error or unresolved network name ’LSNR2’ 1   create pfile from spfile=&n...

1SELECT GRANTEE,PRIVILEGE,RANK()  OVER (PARTITION BY GRANTEE  ORDER BY COUNT(PRIVILEGE) DESC)FROM DBA_TAB_PRIVS WHERE GRANTEE  IN('SYSTEM',       &nbs...

RMAN-00571RMAN-00569RMAN-00571 RMAN-03002 RMAN-06091CONFIGURE CONTROLFILE AUTOBACKUP ON;run {allocate channel ch1 type 'sbt_tape'PARMS="BLKSIZE=262144";setlimit channel ch1 maxopenfiles 8;PARMS="SBT...

RAC ON1. Login as the Oracle software owner and shutdown all database instances on all nodes in the cluster.2. cd $ORACLE_HOME/rdbms/lib3. make -f ins_rdbms.mk rac_onIf this step did not fail wit...

 Select b.SID,b.SERIAL#  From dba_ddl_locks a, v$session b Where a.session_id= b.SID   And a.name ='PKG_CA_PURP_BUS_EXT' DBA_DDL_LOCKSDBA_DDL_LOCKSlists all DDL l...

Applies to: Oracle Server - Enterprise Edition -Version: 9.2.0.1 to 11.2.0.2 - Release: 9.2 to 11.2Information in this document applies to any platform.GoalStarting with Oracle 9.2, ...

Applies to: Oracle Server - Enterprise Edition -Version: 9.2.0.5This problem can occur on any platform.SymptomsSevere database performance slowdown.Statspack report shows Wait Even...

Applies to: Oracle Server - Enterprise Edition -Version 9.2.0.1 and laterInformation in this document applies to any platform.PurposeAssist in correcting performance issuesrelated to "enq: ...

[oracle@gc44 ora_backup]$ORACLE_SID=xxxxxxx[oracle@gc44 ora_backup]$ rman target / Recovery Manager: Release 10.2.0.4.0 -Production on Fri Jul 27 09:21:53 2012 Copyrigh...

Applies to: Oracle Server - Enterprise EditionInformation in this document applies to any platform.Checked for relevance on 30-Dec-2011 SymptomsRevoking either RESOURCE or DBA rolesrevokes ...

me too!. . exported "ZNJL"."S_WL_STD_FACTOR" 0 KB 0 rowsORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA whilecalling DBMS_METADATA.FETCH_XML_CLOB [TABLE_DATA:"...

[root@db-gwyx-4 archivelog]# pwd/oradata/archivelog [oracle@db-gwyx-4~]$ sqlplus /nologSQL*Plus: Release 10.2.0.5.0 - Productionon Mon Jul 16 11:17:58 2012Copyright (c) 1982, 2010,...

迁移库1.在/etc/oratab里写入注册信息2.sftp 登录3.tar -czvf znjl.tar.gz znjl4.spfile和passwd拷贝过去  get /oracle/product/10.2.0/db_1/dbs/orapweptsdb  /oracle/product/10.2.0/db_1/d...

1. 设置环境变量ORACLE_SID假设要求创建的数据库的SID是ecmskfexport ORACLE_SID=ecmskfexport ORALE_BASE=/oracle 2．手工创建如下目录：mkdir -p $ORACLE_BASE/admin/ecmskf/cdumpmkdir -p $ORACLE_BASE/a...

PURPOSE-------The purpose of this document is to help DBA's and support analysts understandhowto clean up a failed CRS (Cluster Ready Services) install for 10g RAC.SCOPE & APPLICATION------...