ITPub博客

环境连个节点的Linux5.5 + Orale10g RAC ,存储采用裸设备。 重启具体过程如下： 1、关闭RAC节点1-bash-3.2$ iduid=500(oracle) gid=300(dba) groups=300(dba)-bash-3.2$ service init.crs stop-bash: service: command not found-bash-3.2$ su -Password: [root@erpdb1 ~]# service init.crs stopShutting down Oracle Cluster Ready Services (CRS):May 16 13:05:11.009 | INF | daemon shutting downStopping resources. This could take several minutes.Successfully stopped CRS resources.Stopping CSSD.Shutting down CSS daemon.S

在linux系统下安装VNC Server,大多数linux发行版都带了VNC Server的发行包.只要选择安装就可以了.在Windows下安装VNC 客户端 [root@localhost ~]# cd /root [root@localhost ~]# cd .vnc -bash: cd: .vnc: No such file or directory[@more@][root@localhost ~]# cd /media/ .hal-mtab .hal-mtab-lock RHEL_5.4 x86_64 DVD/ [root@localhost ~]# cd /media/RHEL_5.4 x86_64 DVD/ [root@localhost RHEL_5.4 x86_64 DVD]# cd Server/ [root@localhost Server]# ls -alh |grep vnc

环境：RedHat Enterprice Linux 5.4 、Oracle 10g，必须提前安装好Oracle数据库软件。 1. 设置环境变量ORACLE_SID 假设要求创建的数据库的SID是test export ORACLE_SID=test export ORALE_BASE=/var/oracle 2．手工创建如下目录： mkdir -p $ORACLE_BASE/admin/test/cdump mkdir -p $ORACLE_BASE/admin/test/bdump mkdir -p $ORACLE_BASE/admin/test/udump mkdir -p $ORACLE_BASE/admin/test/adump mkdir -p $ORACLE_BASE/oradata/test [@more@]3. 创建最简单的initTEST.ora文

purge DBA_RECYCLEBIN用于删除Oracle数据库回收站的所有数据，需要sys登录执行。[@more@]-bash-3.00# su - oracle[oracle@rpt]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 29 12:00:25 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options sys@rpt> SELECT count(*) FROM dba_recyclebin; COUNT(*)---------- 13545 sys@rpt> purge

之前经常用如下方式进行查询：