-
编辑 删除
redhat cluster的oracle script
The Oracle service example uses three scripts that must be placed in /users/oracle and ownedby the Oracle administration account. The oracle script is used to start and stop the Oracle service.Specify this script when you add the service. This script calls the other Oracle example scripts.The startdb and stopdb scripts start and stop the database. Note that there are many ways for anapplication to interact with an Oracle database.The following is an example of the oracle script, which is used to
-
编辑 删除
在redhat as 4上安裝oracle 9204，並升級到9206
1。所需的Package：rpm -q compat-db compat-gcc-32 compat-gcc-32-c++ compat-oracle-rhel4 compat-libcwait compat-libgcc-296 compat-libstdc++-296 compat-libstdc++-33 gcc gcc-c++ gnome-libs gnome-libs-devel libaio-devel libaio make openmotif21 xorg-x11-deprecated-libs-devel xorg-x11-deprecated-libs2。KERNEL調整：[root@hostname]#vi /etc/sysctl.conf#添加入下文字：kernel.shmall=2097152kernel.shmmax=2147483648kernel.shmmni=4096kernel.sem=250 32000 100 128:wq![root@hostname]#sysctl -p3。升級到9206：由於92
-
编辑 删除
DBA学习笔记
1.当在Primary DB上新增datafile之后,如果Standby DB没有同步过来,则可以用下面指令新增:alter database create datafile '/data/pcba/sn_detail4.dbf' as '/data/pcba/sn_detail4.dbf' size 2000m;2. rman恢复某段时间的archive log的scriptrun { allocate channel t1 type 'SBT_TAPE'; restore archivelog from logseq=xxx until logseq=xxx thread 1; release channel t1; }3.SLES9下的oracle使用Veritas NetBackup备份：安装完Veritas Client&Agent之后，还要在$ORACLE_HOME/lib底下建一link(name:libobk.so)到：/usr/openv/netba
