服务器相关命令

1、 登陆root用户,再通过root用户登陆oracle用户，#su – oracle
2、 开启数据库监听，$lsnrctl start
3、 连接数据库，$sqlplus / as sysdba
4、 启动数据库，SQL>startup;
5、 返回root用户，$su - root
6、 进入jboss5路径，#cd /OA-YIYONG/jboss5/bin

1、 登陆root用户,再通过root用户登陆oracle用户，#su – oracle
2、 关闭数据库监听，$lsnrctl stop
3、 连接数据库，$sqlplus / as sysdba
4、 关闭数据库，SQL>shutdown immediate;
5、 返回root用户，$su - root

两个Jboss重启
nohup ./run.sh -b 0.0.0.0 -Djboss.service.binding.set=ports-01 &
创建用户
sqlplus System/123456@orcl
create user yzoa  identified  by  yzoa;

create tablespace yzoa  datafile 'D:\beifeng\anzhuang\Oracle_data\yzoa.dbf' size 2048M;

create tablespace  yzoa_temp  datafile 'D:\beifeng\anzhuang\Oracle_data\yzoa_temp.dbf' size 500M;

alter user yzoa quota unlimited on yzoa;

grant connect,resource,dba to yzoa;

DROP TABLESPACE matechs INCLUDING CONTENTS AND DATAFILES;

查看锁表
select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b
where b.object_id = a.object_id
查看锁表的sql
SELECT L.SESSION_ID SID,S.SERIAL#,L.LOCKED_MODE,L.ORACLE_USERNAME,L.OS_USER_NAME,S.MACHINE,S.TERMINAL,O.OBJECT_NAME,S.LOGON_TIME FROM V$LOCKED_OBJECT L, ALL_OBJECTS O, V$SESSION S WHERE L.OBJECT_ID = O.OBJECT_ID AND L.SESSION_ID = S.SID ORDER BY SID, S.SERIAL#;

解锁
select b.username,b.sid,b.serial#,logon_time from  v$locked_object a,v$session b where a.session_id = b.sid order by b.logon_time

alter system kill session'135,397'

最大连接数
select value from v$parameter where name = 'processes'

select count(*) from v$process