Oracle数据库登录的身证验证
[oracle@liwei admin]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 1 15:55:18 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> quit
Disconnected
[oracle@liwei admin]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 1 15:55:24 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> quit
Disconnected
二、Oracle登录认证方式
《Oracle管理与维护.手工创建数据库以及脚本》一文中提到如下一个错误：
[oracle@liwei oracle]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 1 14:51:59 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
这个便是登录认证方式的问题了。
Oracle登录认证有两种方式：基于操作系统的登录认证和基于Oracle密码文件的登录认证。
具体方式记录在服务端$ORACLE_HOME/network/admin/sqlnet.ora文件中，不过Windows与
Unix/Linux具体设置是不同的。
(一)<Windows>
sqlnet.ora文件为空时采用Oracle密码文件验证
SQLNET.AUTHENTICATION_SERVICES= (NTS) 基于操作系统验证；
SQLNET.AUTHENTICATION_SERVICES= (NONE) 基于Oracle密码文件验证
SQLNET.AUTHENTICATION_SERVICES= (NONE,NTS) 二者并存，注意是半角，否则不识别
sqlnet.ora示例一：
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
#SQLNET.AUTHENTICATION_SERVICES = (NTS)
C:\Documents and Settings\Administrator>sqlplus " / as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on Mon May 5 17:54:32 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
sqlnet.ora示例二：
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without
相关文档：
1.回退事务
最好设置一个保存点，例savepoint a,或者执行 exec dbms_transaction.savepoint('a')(执行前需要执行set serveroutput on语句)；取消部分事务就可以使用rollback to a,或者执行exec dbms_transaction.rollback_savepoint('a');取消全部事务可以执行rollback,或者exec dbms_transaction.rollback;
2.只读事务
......
crsctl stop crs
killall init.crsd
cd /etc/init.d
rm -rf init.crs init.crsd init.cssd init.evmd
rm -rf /tmp/.oracle/
rm -rf /var/tmp/
rm -rf /var/tmp/.oracle/
cd /etc
rm -rf oraInst.loc oracle/ oratab
rm -rf $ORACLE_BASE
dd if=/dev/zero of=/dev/raw/raw_voting_disks bs=1024k
dd if=/dev/zero ......
众所周知的几个结果集集合操作命令，今天详细地测试了一下，发现一些问题，记录备考。 假设我们有一个表Student，包括以下字段与数据： drop table student;
create table student
(
id int primary key,
name nvarchar2(50) not null,
score number not null
);
insert into student values(1,'Aaron',78);
inse ......
oracle中sql语句中select * from t_Test t where t.Id in(1,2,3......)/*数量不能大于1000个*/
解决方法 分割成多次in 然后再或上 如 select * from t_Test t where t.Id in(1,2,3......800) or t.Id in(801,802,803......1300)
在使用中最好能不使用其他条件来代替in
......
利用os审核
登录oracle时在Win中实现对os的审核有如下几步：
1、 create os user id
2、 create os group ora_dba(这个组中用户具有管理所有oracle database 的权限),
ora_sid_dba（只能对应到相应sid� ......
