首页 > 编程知识 正文

怎么删除数据库实例,linux连接数据库命令

时间:2023-05-04 06:45:22 阅读:47525 作者:581

一、中止服务sql

首先使用命令lsnrctl stop数据库

然后运行oracle

sql conn/as sysdbaflash

配置SQL关闭

二、显示实例流程,删除grep

find $ Oracle _ base/- name $ Oracle _ sid

/mnt/installer/Oracle/flash _ recovery _ area/orcl

/mnt/installer/Oracle/oradata/orcl

/mnt/installer/Oracle/diag/RDBMS/orcl

/mnt/installer/Oracle/diag/RDBMS/orcl/orcl

/mnt/installer/Oracle/admin/orcl

/mnt/installer/Oracle/cfgtoollogs/dbca/orcl top

[ Oracle @ rt1d 20/] $ RM-RF/mnt/installer/Oracle/flash _ recovery _ area/orcl /

[ Oracle @ rt1d 20/] $ RM-RF/mnt/installer/Oracle/oradata/orcl /

[ Oracle @ rt1d 20/] $ RM-RF/mnt/installer/Oracle/diag/RDBMS/orcl /

[ Oracle @ rt1d 20/] $ RM-RF/mnt/installer/Oracle/admin/orcl /

[ Oracle @ rt1d 20/] $ RM-RF/mnt/installer/Oracle/cfgtoollogs/dbca/orcl /

数据库

find $ Oracle _ base/*-name ' * [ bb ] [ TT ] [ ss ] [ bb ]2* '|grep-vadmin|grep-v oradata

如果没有就跳过

$ cd mnt/installer/oracle/

$ ll

dwxr----2Oracle oinstall 4096 Jan 816336050 admin

rwxr-xr-x4 Oracle oinstall 4096 Jan 723:12 cfgtoollogs

rwxr-xr-x2 Oracle oinstall 4096 Jan 723:15检查点

drwxrwxr-x4 Oracle oinstall 4096 Jan 72:12诊断程序

drwxr----3Oracle oinstall 4096 Jan 816:49 flash _ recovery _ area

dwxr----2Oracle oinstall 4096 Jan 816336049 oradata

rwx rwx----5Oracle oinstall 4096 Jan 721:06 ora inventory

dwxr-xr-x3Oracle oinstall 4096 Jan 721:03 product

[ Oracle @ rt1d 20 Oracle ] $ RM-RF admin /

[ Oracle @ rt1d 20 Oracle ] $ RM-RF flash _ recovery _ area /

[ Oracle @ rt1d 20 Oracle ] $ RM-RF oradata /

三.删除旧实例配置项目

vi etc/oratab

删除最后一行: orcl :/mnt/installer/Oracle/product/11.2.0/db _ 13360 n

最后,新静默安装数据库实例

版权声明:该文观点仅代表作者本人。处理文章:请发送邮件至 三1五14八八95#扣扣.com 举报,一经查实,本站将立刻删除。