SniGoal

摘要：CREATE OR REPLACE TRIGGER [trigger_name]BEFORE insert ON [table_name]FOR EACH ROW declare next_auto_no number;begin select [Sequence_name].nextval into next_auto_no from dual; :new.[column_name]:=next_auto_no;end; 阅读全文

摘要：rhel u3(Red Hat Enterprise Linux AS release 4 (Nahant Update 3))http://218.6.142.227/soft-dist/redhat/RHEL4U3-i386/RHEL4-U3-i386-AS-disc1.isohttp://218.6.142.227/soft-dist/redhat/RHEL4U3-i386/RHEL4-U3-i386-AS-disc2.isohttp://218.6.142.227/soft-dist/redhat/RHEL4U3-i386/RHEL4-U3-i386-AS-disc3.isohttp: 阅读全文

摘要：$>sqlplus /nologSQL>connect /as sysdba SQL>alter user sys identified by 新密碼; SQL>alter user system identified by 新密碼; 阅读全文

摘要：1.修改组策略将/etc/selinux/config中的SELINUX=[permissive|enforcing|disabled]改为SELINUX=[permissive|enforcing|disabled]2.修改oratab将/etc/oratab中的[oracle_sid]:[$oracle_home]:N改为[oracle_sid]:[$oracle_home]:Y3.复制init[oracle_sid].ora文件将[$oracle_base]/admin/[oracle_sid]/pfile下的以init[oracle_sid].ora开头的文件复制到[$oracle_h 阅读全文

摘要：在RH Linux AS4 x86-64 安装Oracle9.2.0.4前打补丁Patch 4198954中的compat-libcwait-2.1-1.i386.rpm 报如下的错误：[root@oracle8 oracle]# rpm -ivh compat-oracle-rhel4-1.0-5.i386.rpmERROR: ld.so: object '/lib/libcwait.so' from /etc/ld.so.preload cannot be preloaded: ignoreGoogle了半天找到解决办法：# echo "" > / 阅读全文

摘要：Download SoftwareRedHat Enterprise Linux 4 Update 3 (RHEL4-U3):http://218.6.142.227/soft-dist/redhat/RHEL4U3-i386/RHEL4-U3-i386-AS-disc1.isohttp://218.6.142.227/soft-dist/redhat/RHEL4U3-i386/RHEL4-U3-i386-AS-disc2.isohttp://218.6.142.227/soft-dist/redhat/RHEL4U3-i386/RHEL4-U3-i386-AS-disc3.isohttp:/ 阅读全文