linux下完全删除oracle

Linux环境下完全删除Oracle

测试环境：Linux系统　Oracle 10.2.0.1

1.用oracle用户登录

如果要再次安装， 最好先做一些备份工作。包括用户的登录脚本，数据库自动启动关闭的脚本，和Listener自动启动的脚本。要是有可能连创建数据库的脚本也保存下来

2.使用SQL*PLUS停止数据库
[oracle@ora1020 oracle]$ sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown immediate

SQL> exit

3.停止Listener

[oracle@ora1020 oracle]$ lsnrctl stop

4.停止HTTP服务

[oracle@ora1020 oracle]$ $ORACLE_HOME/Apache/Apache/bin/apachectl stop

5.用su或者重新登录到root(如想重新安装可以保留oracle用户，省得输入环境变量了)

6.将安装目录删除

[root@ora1020 /root]# rm -rf /db/oracle10g/

7.将/usr/local/bin下的文件删除
[root@ora1020 /root]# rm -f /usr/local/bin/dbhome
[root@ora1020 /root]# rm -f /usr/local/bin/oraenv

[root@ora1020 /root]# rm -f /usr/local/bin/coraenv

8.将/etc/oratab删除

[root@ora1020 /root]# rm -f /etc/oratab

9.将/etc/oraInst.loc删除

[root@ora1020 /root]# rm -f /etc/oraInst.loc

10.将oracle用户删除(若要重新安装,可以不删除)

[root@ora1020 /root]# userdel –r oracle

11.将用户组删除(若要重新安装,可以不删除)
[root@ora1020 /root]# groupdel oinstall

[root@ora1020 /root]# groupdel dba

12.将启动服务删除

[root@ora1020 /root]# chkconfig --del dbora

更多参考：

the specified nodes are not clusterable

根据rowid删除表中重复的行

Agent process exited abnormally during initialization

一次字符乱码的解决过程

rman实验（一）

rman实验（二）

ORA-00600: internal error code, arguments: [keltnf

ORA-00600: ORA-12012 ORA-08102解决

linux下完全删除oracle

INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory

centos4.8_64上安装oracle10201建库报ORA-12547

EM乱码解决

ORA-31613 Master process DM00 failed during startup

ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []

ORA-24324 ORA-01041 ORA-03113

centos5.3升级oracle

pdksh-5.2.14-36.el5.i386.rpm

使用rman进行数据库迁移

oracle10.2.0.1升级到10.2.0.4报错

Upgrade Oracle 10g from 10.2.0.1 to 10.2.0.4 (Single Instance)

改oracle的name和dbid

修改oracle实例名

Solaris8上迁移oracle8i---上

Solaris8上迁移oracle8i---下

未备份归档日志导致数据丢失的实验

使用NBU进行数据库迁移

catalog备份数据库

RMAN FORMAT字符串格式化

Error: can not register my instance state - -1

not all alterations performed

The ASM instance configured on the local node is a single-instance ASM

/u01/crs102/bin/crsctl.bin: error while loading shared libraries: libstdc++.so.5: cannot open shared

Initializing the Oracle ASMLib driver: [FAILED]

ORA-00245: control file backup operation failed

WARNING: failed to read mirror side 1 of virtual extent 229 logical extent

模拟恢复参数文件

Interface eth0 checked failed

import server uses ZHS16GBK character set (possible charset conversion)