Command

常用命令
Oracle_Database SQL Reference，SQL的语法:http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm
PL SQL Packages and Types，PL/SQL参考:http://st-doc.us.oracle.com/10/102/appdev.102/b14258/toc.htm
Oracle Database Reference，数据字典使用语法:http://st-doc.us.oracle.com/10/102/server.102/b14237/toc.htm
============================常用命令================================su - userchown -R oracle:dba sw-jinnichmod -R +x *ls -auname -rrpm -qdu -sm *ps -ef grepssh-agent $SHELLssh-addsar -u 1 10topiostatsqlplus / as sysdba!sqlhistoryscp rac1pub:/etc/hosts ./hcat /etc/hostscat /proc/cpuinfocat /etc/initiatorname.iscsicat /etc/fstabmount -amount /dev/sdb1fsck.reiserfs /dev/sda3mkfs.reiserfs /dev/sdb1fdisk -ln新建 w保存 p主分区============================常用软件================================mozillaSUSE:KDEYASTREDHAT:/usr/bin/redhat-config-network============================网络设置================================/sbin/ifconfig改IP：vi /etc/sysconfig/networkvi /etc/hostsvi /etc/sysconfig/network-scripts/ifcfg-eth0/sbin/service network restart改DNS：vi /etc/resolv.conf=========================RAC数据库相关==============================emctl start stop status setpasswd dbconsolelsnrctl servlsnrctl status LISTENER_RAC2PUBsrvctl status database -d nagf
env grep SIDexport ORACLE_SID=+ASM1asmcmdASMCMD> lsdgASMCMD> lslvASMCMD> lsctASMCMD> exit/etc/init.d/oracleasm listdisksSQL> select name from v$asm_disk;SQL> alter diskgroup netapp_dg dismount;
find /dev -name *scsi* morevi /etc/iscsi.conf/etc/init.d/iscsi start/etc/init.d/iscsi restartchkconfig iscsi onchkconfig iscsi offchkconfig iscsi -l
SQL> select tablespace_name from dba_tablespaces;SQL> desc dba_datafiles;SQL> select file_name,file_id,tablespace_name from dba_data_files;SQL> select name from v$datafileunionselect member from v$logfileunionselect name from v$controlfileunionselect name from v$tempfile;SQL> select index_name from dba_indexes where index_name like 'CALL_%'SQL> show parameter ****SQL> alter system set xxx=xxxSQL> select * from v$session;SQL> select * from v$process p, v$session s where p.serial#=s.serial# and p.spid=12615;
输出htm格式的报表:SQL> SET MARKUP HTML ONSQL> spool select * from ALL_RULE_SET_RULES.htmSQL> select * from select * from ALL_RULE_SET_RULES;SQL> spool offSQL> SET MARKUP HTML OFFSQL> startup restrict mount;SQL> drop database;
注册到listener：SQL> alter system registerSQL> purge recyclebin;