xpmwgcwm的博客

1. 创建安装oracle 所需的组和用户 需要的用户是oracle,组是dba,oinstall 相关命令： groupadd oinstall groupadd dba useradd –g oinstall –G dba oracle passwd oracle 2. 创建安装安装所需的目录 Oracle Base 目录/u/app...

1. update .bash_profile export ORACLE_BASE=/u/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.2/db_1 export ORACLE_SID=********** 　　 export PATH=$ORACLE_HOME/bin:$PATH ...

create temporary tablespace IDX_TEMP tempfile '/u/app/oracle/oradata/ELM/IDX_TEMP01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; create tablespace IDX lo...

1. su oracle 2. sqlplus '/ as sysdba ' 3. 监视执行的sql SELECT osuser, username, sql_text from v$session a, v$sqltext b where a.sql_address =b.address order by address, piece;