kramer

摘要： 首先，可以通过下面的sql statement来查看表空间的使用情况。注意，该语句是在10g下测试过。SELECT FREE.TABLESPACE_NAME, FREE.FREE_SPACE/TOTAL.TOTAL_SPACE FROM (select TABLESPACE_NAME,sum(bytes)/1024/1024 AS FREE_SPACE from dba_free_space group by TABLESPACE_NAME) FREE, (select TABLESPACE_NAME,sum(BYTES)/1024/1024 AS TOTAL_SPACE from dba_. 阅读全文

摘要： oracle rac 11gr2中提供了多种 failover方式，这里只测试 server side TAF. 也就是说在server端配置的failover。这种配置方式的好处就是，如果有什么改动可以在server端改动，不必去多个client端改。OK 实验步骤如下：首先，创建service[oracle@racnode1 ~]$ srvctl add service -d orcl -s my_service -r "orcl1" -a "orcl2" -P basic然后，启动service并查看状态。 可以看到service启动在了orcl1 阅读全文

摘要： 1. Do you have virtual environment as lab？ Labs with free access of vm can be very convince 阅读全文

摘要： Recently, I installed a new RAC database on a local enviroment. The oracle version is 11.0.2.3. Operating system is OEL 6. When I install, I put all the database files into only one ASM disk group called data. The redundency level is normal which means only about 1/2 of the total space can be used. 阅读全文

摘要： LU CREATEThis step is to create a new boot enviroment. It contains the following steps.detach mirrormodified detached root mirror so it can be a boot device if error happensprepare exclusive listhousekeep var, determine zone infor, shutdown zone if you canlucreatedetach mirrorUse metastat -a , metas 阅读全文

摘要： Configuring Shared StorageConfiguring Files on an NAS Device for Use with Oracle ASMUsing ASMLib to Mark the Shared Disks as Candidate Disks 阅读全文

摘要： LINUX初学者经常分不清楚linux和X之间，X和Xfree86之间，X和KDE，GNOME等之间是什么关系。常常混淆概念，本文以比较易于理解的方式来解释X，X11，XFREE，WM，KDE，GNOME等之间的关系。一、linux本身没有图形界面，linux现在的图形界面的实现只是linux下的应用程序实现的。图形界面并不是linux的一部分，linux只是一个基于命令行的操作系统，linux和Xfree的关系就相当于当年的DOS和 WINDOWS3.0一样，windows3.0不是独立的操作系统，它只是DOS的扩充，是DOS下的应用程序级别的系统，不是独立的操作系统，同样 XFree只是l 阅读全文

摘要： Hit a error while trying to connect one oracle database. Normally this should because the tnsname.ora not configured right. Firstly I can sure that the database and listener is working fine. Because there is client connecting to database. So it definitely the local tnsname configuration. So I check 阅读全文

摘要： One oracle database crushed due to NFS issue. The database binary was mounted from another server A. So once the NFS was disconnected, the database was crushed. I tried to start it up today but hit below issue.SQL> startupORACLE instance started.Total System Global Area 2138521600 bytesFixed Size 阅读全文

摘要： Configuration Insatallation Direcotries and Shared Storage.Oracle Inventory DirectoryDocuments(rac 2 day) says the oraInventory directory is created by OUI during installation. But based on what I remember, we need to create this directory beore run OUI. So need to test. ???????????????1. Run the fo 阅读全文