-
编辑 删除
ORA-15071: ASM disk "VOL_DATA2" is already being dropped
SQL> alter diskgroup PQAWEB_DATA1 drop disk 'VOL_DATA1' FORCE ; alter diskgroup PQAWEB_DATA1 drop disk 'VOL_DATA1' FORCE*ERROR at line 1:ORA-15032: not all alterations performedORA-15071: ASM disk "VO...
-
编辑 删除
创建永久性本地SCSI设备名称
Normal 0 7.8 pt 0 2 false false false EN-US ZH-CN X-NONE</w:LidThemeComplexScript. ...
-
编辑 删除
mysql backup and restore
mysqldump --single-transaction --flush-logs --all-databases > backup_sunday_1_PM.sql
-
编辑 删除
Enalbe mail feature for oracle DB.(oracle10G)
a. This step is used to config the email server to send alert email. 1. Run script. "@?/rdbms/admin/utlmail.sql" at sqlplus prompt. 2. Run script. "@?/rdbms/admin/p...
-
编辑 删除
Change the port from 3306 to 8008 for mysql.
The mysql default port is 3306. I want to change the port to 8008. After /etc/my.cnf changed, the mysql can't be started any more. The error message as following.101210 03:47:43 mysqld_safe mysqld fro...
-
编辑 删除
ERROR 1045 (28000): Access denied for user 'root'@'localhost'
错误提示:# mysql -uroot -pEnter password:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)解决方法：1方法一：# /etc/init.d/mysql stop# mysqld_safe --user=mysql --skip...
-
编辑 删除
ORA-00600: internal error
Normal 0 7.8 pt 0 2 false false false EN-US ZH-CN X-NONE</w:LidThemeComplexScript. ...
-
编辑 删除
TNS-12520 连接错误处理(转)
TNS-12520 TNS-12519 连接错误处理今天巡检客户数据库时，发现有个taf自动offline,手工启动后，再过一段时间又自动offlineITPUB个人空间%jcu n3Cd*L$ crs_stat -tITPUB个人空间V_Qf^ Y...
-
编辑 删除
物业管理费2010-7-1 --- 2010-12-31 公摊水费止2010-8月
-
编辑 删除
关于ORA-00376错误的恢复案例(转)
今天开始磁盘空间100%，删完数据后，查询表遇到ORA-00376错误：SQL> select count(*) from tab_test;ORA0-00376: "file '/data1/oradata/e_data1.dbf' cannot be read at this time"重启数据库没有问题，数据...
-
编辑 删除
My sql 远程访问 授权
1、改表法 可能是你的帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入mysql后，更改 "mysql" 数据库里的 "user" 表里的 "host" 项，从"localhost"改称"%" mysql -u root -pm...
-
编辑 删除
(转)ORA-01502 state unusable错误成因和解决方法(二)
SQL> create table t(a number);Table created.现在，我们建立一个唯一索引来看看：SQL> create unique index idx_t on t(a);Index created.SQL> select index_name,index_type,tablespace_name,table_type,stat...
-
编辑 删除
How to check site certification.
root # openssl s_client -connect xxx.xxxx.com:443For more details please refer to http://confluence.atlassian.com/display/JIRA/Connecting+to+SSL+services
-
编辑 删除
restore account
tar cvf account.tar /etc/passwd /etc/shadow /etc/group /etc/sudoers chmod 644 account.tar scp -P 333 xxxxx@xxxxxx:/account.tar /tmp cd /tmp tar xvf account.tar cd etc mv * /etc/
