安装数据库起图形化
[root@san ~]# xhost + access control disabled, clients can connect from any host[root@san ~]# [root@san ~]# [root@san ~]# xclock[root@san ~]#
expdp
ORA-39001: invalid argument valueORA-39035: Data filter SUBQUERY has already been specified.说明query参数值写法有误,应该给双引号加上转义字符"\"query=/"'where deptno=30'";
awr报告生成
SQL> @?/rdbms/admin/awrrpt.sqlCurrent Instance~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance----------- ------------ -------- ------------ 249066282 ORA11GR2 1 ORA11GR2Specify the Report...
更改重做日志的名称或位置
在重做日志文件创建之后。有时候可能需要更改它们的名称或位置1:查看日志路径SQL> select group#,member from v$logfile; GROUP# MEMBER---------- -------------------------------------------------- 3 /u01/app/oracle/oradata/ORA11GR2/redo03.log &n...
Oracle RAC dbca 图形化建库出现 ASM密码错误
1;alter user asm identified by oracle ;