oracle 小技艺

一.起步和封闭数据库





到 /opt/oracle/product/10.2.0.1/bin 索引下





a. lsnrctl start

b. dbstart



封锁数据库





a. lsnrctl stop

b.dbstop



2. 表的解锁



a.查看被锁的表

Sql代码
一.select p.spid,
2. c.object_name,
3. b.session_id,
4. b.oracle_username,
5. b.os_user_name
6. from v$process p, v$session a, v$locked_object b, all_objects c
7. where p.addr = a.paddr
8. and a.process = b.process
9. and c.object_id = b.object_id
select p.spid,
c.object_name,
b.session_id,
b.oracle_username,
b.os_user_name
from v$process p, v$session a, v$locked_object b, all_objects c
where p.addr = a.paddr
and a.process = b.process
and c.object_id = b.object_id b.解锁：
alter system kill session '146';(此中146为锁住的过程号

本文来源：
我的异常网
Java Exception
Dotnet Exception
Oracle Exception

1675 - java中如何能声明一个方法使其不能被继承类里的方法重写(override)？

1676 - HTTP 1.1 500 intrnal server error

1677 - Automation服务器无法创建对象

1678 - 该错误可能是因为执行该操作的访问权限不足

1679 - tag contains an invalid value for the

1680 - 调用对象出现异常

1681 - System.IO.FileNotFoundException: 找不到文件或程序集名称iqipmb7s.dll，或找不到它的一个依赖项

1682 - 错误：拒绝访问.JIT调试由用户LUCKY(服务器命)ASPNET启动

1683 - Visual Studio.NET已检测到指定的WEB服务器运行的不是ASP.NET 1.1版.您将无法运行ASP.NET Web应用程序或服务

1684 - org.apache.jasper.JasperException: File WEB-INF c.tld not found

1685 - the error message string of this Throwable object if it was created with an error message string

1686 - An error occurred during the compilation of a resource required to service this request

1687 - CS0234: 类型或命名空间名称ADO在类或命名空间System.Data中不存在

1688 - 未能加载类型

1689 - 未能访问CDO.Message对象

1690 - 缺少根元素

1691 - 对象已锁定

1692 - 错误1935

1693 - 安装汇编组件{xxxxxx-xxx-xxx-xxx}时出错

1694 - the account is locked