转:测试中常用的oracle命令和操作
上一篇 /
下一篇 2011-04-01 11:17:52
1.登陆和服务:
su -oracle
ps -ef|grep oracle
lsnrctl status 查看oracle监听
lsnrctl start 启动监听
sqlplus / as sysdba
conn user/password
startup启动数据库
shutdown 关闭数据库
shutdown immediate 立即关闭(pl/sql工具用system登陆,在tool,session里可以kill各个进程然后再关闭)
2.数据导入导出:
exp base/123456 file=base.dmp wner=base 导出到当前目录
imp basenew/123456 file=base.dmp fromuser=base touser=basenew
3.语法执行:
@/test/test.sql
4.创建表空间和账号赋权:
conn / as sysdba;
create tablespace tbs_base datafile '/u02/oradata/center/base/base01.dbf' size 1024M autoextend on next 512M maxsize unlimited;
create tablespace tbs_base_idx datafile '/u02/oradata/center/base/base_idx01.dbf' size 1024M autoextend on next 512M maxsize unlimited;
create user base identified by 12345678 default tablespace tbs_base;创建账号
grant connect,resource,create table,create view,execute any procedure to base;赋权
/
5.修改用户密码:
select username,password from dba_users;
alter user system identified by manager ;
alter user system identified by values '2779B958878D04FA';
6.修改进程和会话最大链接数(要重启):
show parameter processes;
show parameter session;
alter system set processes 500 scope=spfile;
alter system set session 500 scope=spfile;
7.查看日志:
select * from v$logfile;查看日志路径
LogMiner;查看日志情况,用这个,但是我还没用过,后面实践
收藏
举报
TAG: