ITPub博客

....[@more@]To access the Oracle Enterprise Manager Console from a client browser, the dbconsole process needs to be running on the server. The dbconsole process is automatically started after installation.However, in the event of a system restart, you can start it manually at the command line or start it as a service in Windows.To start the dbconsole process from the command line:Navigate into your ORACLE_HOME/bin directory.Run the following statement:./emctl start dbconsole Additionally, yo

....[@more@]环境:AIX5.3+Oracle 10g R2问题:alert.logWARNING: inbound connection timed out (ORA-3136)SQLNET.LOG error Fatal NI connect error 12637, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production Time: 25-JAN-2007 13:39:03 Tracing not turned on.

......................[@more@]As an Oracle DBA, you can expect to be involved in the following tasks:- 安装Oracle Software- Creating Oracle Databases- Performing Upgrades of the database and software to new release levels- Starting up and shutting down the database-Managing the database's storage stuctures- Managing users and security- Managing schema objects,such as tables,index,and views- Making database backups and performing recovery when necessary- Proactively monitoring the database's hea

dd命令[@more@]dd命令功能很强大的，对于一些比较底层的问题，使用dd命令往往可以得到出人意料的效果。用的比较多的还是用dd来备份裸设备。但是不推荐，如果需要备份oracle裸设备，可以使用rman备份，或使用第三方软件备份，使用dd的话，管理起来不太方便。 建议 在有需要的时候使用dd 对物理磁盘操作，如果是文件系统的话还是使用tar backup cpio等其他命令更加方便。 另外，使用dd对磁盘操作时，最好使用块设备文件。 Description The dd command reads the InFile parameter or standard input, does the specified con

/...[@more@]OS: AIX5.3CLUSTER:HACMP5.3DB:9.2.0.8 + RACEXP 导出时: EXP-00091: Exporting questionable statistics.解决:SQL> select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET' 2 ;PARAMETER------------------------------VALUE--------------------------------------------------------------------------------NLS_CHARACTERSETAL32UTF8ORACLE 用户 .profile 中增加:export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

...[@more@][TEST:oradev] /devTESTarch1/flash_back/TEST/onlinelog> as sysdba" <SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 5 16:28:55 2007Copyright (c) 1982, 2005, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> alter system set db_recovery_file_dest='/devTESTarch1/flash_back' scope=both;System altered.SQL> alter system set db_recovery_fil

...[@more@]UNDO表空间用于存放UNDO数据,当执行DML操作(INSERT,UPDATE和DELETE)时,oracle会将这些操作的旧数据写入到UNDO段,在oracle9i之前,管理UNDO数据时使用(Rollback Segment)完成的.从oracle9i开始,管理UNDO数据不仅可以使用回滚段,还可以使用UNDO表空间.因为规划和管理回滚段比较复杂,所有oracle database 10g已经完全丢弃用回滚段.并且使用UNDO表空间来管理UNDO数据.UNDO数据也称为回滚(ROLLBACK)数据,它用于确保数据的一致性.当执行DML操作时,事务操作前的数据被称为UNDO记录.UNDO段用于保存事务所修改数据的旧值,其中存储着被修改