Oracle 11g服务器与客户端卸载、安装
Oracle 11g服务器与客户端的完全卸载方式与前些版本有了改变: 一、卸载前准备: 开始-设置-控制面板-管理工具-服务 停止所有Oracle服务。 二、批处理卸载: 运行H:\app\Administrator\product\11.2.0\dbhome_1\deinstall的deinstall.bat批处理文件卸载
Oracle 11g服务器与客户端的完全卸载方式与前些版本有了改变:
一、卸载前准备:
开始->设置->控制面板->管理工具->服务
停止所有Oracle服务。
二、批处理卸载:
运行H:\app\Administrator\product\11.2.0\dbhome_1\deinstall的deinstall.bat批处理文件卸载,全程代码如下:
(客户端卸载与此类似,屏幕过程中都会有询问,一路回车或y选择默认即可。)
Please wait ...
复制了 14 个文件
复制了 611 个文件
已复制 1 个文件。
已复制 1 个文件。
Location of logs C:\Users\ADMINI~1\AppData\Local\Temp\OraDeinstall周六-09-04_12-
13-55\logs\
############ ORACLE DEINSTALL & DECONFIG TOOL START ############
######################## CHECK OPERATION START ########################
安装检查配置开始
检查 Oracle 主目录位置是否存在 H:\app\Administrator\product\11.2.0\dbhome_1
选择进行卸载的 Oracle 主目录类型为: SIDB
选择进行卸载的 Oracle 基目录为: H:\app\Administrator
检查主产品清单位置是否存在 C:\Program Files\Oracle\Inventory
安装检查配置结束
检查 Windows 和 .NET 产品配置开始
以下 Windows 和 .NET 产品将从 Oracle 主目录取消配置:asp.net,ode.net,odp.net,ntoledb,oramts
检查 Windows 和 .NET 产品配置结束
网络配置检查配置开始
网络取消配置跟踪文件位置: C:\Users\ADMINI~1\AppData\Local\Temp\OraDeinstall周六-09-04_12-13-55\logs\netdc_check9099948279725757430.log网络配置检查配置结束
数据库检查配置开始
数据库取消配置跟踪文件位置: C:\Users\ADMINI~1\AppData\Local\Temp\OraDeinstall周
六-09-04_12-13-55\logs\databasedc_check1621612446029651947.log
指定值列表作为输入时使用逗号作为分隔符
指定在此 Oracle 主目录中配置的数据库名的列表 [ORCL]:
###### 对于数据库 'ORCL' ######
单实例数据库
数据库的诊断目标位置: H:\APP\ADMINISTRATOR\diag\rdbms\orcl
数据库使用的存储类型: FS
数据库文件位置: H:\APP\ADMINISTRATOR\ORADATA\ORCL,H:\APP\ADMINISTRATOR\FLASH_REC
OVERY_AREA\ORCL
快速恢复区位置: H:\app\Administrator\flash_recovery_area\ORCL
数据库 spfile 位置: H:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILE
ORCL.ORA
已自动搜索到数据库 ORCL 的详细资料。是否仍要修改 ORCL 数据库的详细资料? [n]: y
###### 对于数据库 'ORCL' ######
指定此数据库 (1. 单实例数据库|2. 启用 Oracle Restart 的数据库) 的类型 [1]:
指定数据库的诊断目标位置 [H:\APP\ADMINISTRATOR\diag\rdbms\orcl]:
指定数据库 ASM|FS 使用的存储类型 [FS]:
如果有任何数据库文件存在于共享文件系统上, 请指定目录的列表。如果找到了 'ORCL' 子
目录, 则将删除该子目录。否则将删除指定的目录。此外, 可以指定带有完整路径的数据库
文件的列表 [H:\APP\ADMINISTRATOR\ORADATA\ORCL,H:\APP\ADMINISTRATOR\FLASH_RECOVER
Y_AREA\ORCL]:
如果在文件系统上配置了快速恢复区, 请指定其位置。如果找到了 'ORCL' 子目录, 则将删
除该子目录。 [H:\app\Administrator\flash_recovery_area\ORCL]:
指定数据库 spfile 位置 [H:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SP
FILEORCL.ORA]:
数据库检查配置结束
Enterprise Manager Configuration Assistant START
EMCA 取消配置跟踪文件位置: C:\Users\ADMINI~1\AppData\Local\Temp\OraDeinstall周六
-09-04_12-13-55\logs\emcadc_check.log
检查数据库 ORCL 的配置
Enterprise Manager Configuration Assistant END
Oracle Configuration Manager check START
OCM check log file location : C:\Users\ADMINI~1\AppData\Local\Temp\OraDeinstall
周六-09-04_12-13-55\logs\\ocm_check7346.log
Oracle Configuration Manager check END
######################### CHECK OPERATION END #########################
####################### CHECK OPERATION SUMMARY #######################
选择进行卸载的 Oracle 主目录为: H:\app\Administrator\product\11.2.0\dbhome_1
Oracle 主目录注册到的产品清单位置为: C:\Program Files\Oracle\Inventory
以下 Windows 和 .NET 产品将从 Oracle 主目录取消配置:asp.net,ode.net,odp.net,ntol
edb,oramts
已选中以下数据库来取消配置: ORCL
数据库唯一名称: ORCL
已用存储: FS
将为以下数据库更新 Enterprise Manager 配置: ORCL
没有要更新的 Enterprise Manager ASM 目标
没有要移植的 Enterprise Manager 监听程序目标
Checking the config status for CCR
Oracle Home exists with CCR directory, but CCR is not configured
CCR check is finished
是否继续 (y - 是, n - 否)? [n]: y
此会话的日志将写入: 'C:\Users\ADMINI~1\AppData\Local\Temp\OraDeinstall周六-09-04
_12-13-55\logs\deinstall_deconfig2010-09-04_12-14-52-PM.out'
此会话的任何错误消息都将写入: 'C:\Users\ADMINI~1\AppData\Local\Temp\OraDeinstall
周六-09-04_12-13-55\logs\deinstall_deconfig2010-09-04_12-14-52-PM.err'
######################## CLEAN OPERATION START ########################
Enterprise Manager Configuration Assistant START
EMCA 取消配置跟踪文件位置: C:\Users\ADMINI~1\AppData\Local\Temp\OraDeinstall周六
-09-04_12-13-55\logs\emcadc_clean.log
更新数据库 ORCL 的 Enterprise Manager Database Control 配置
更新 Enterprise Manager ASM 目标 (如果有)
更新 Enterprise Manager 监听程序目标 (如果有)
Enterprise Manager Configuration Assistant END
数据库取消配置跟踪文件位置: C:\Users\ADMINI~1\AppData\Local\Temp\OraDeinstall周
六-09-04_12-13-55\logs\databasedc_clean4524227538174628415.log
数据库清除配置开始 ORCL
此操作可能需要持续几分钟。
DOS提示卸载完毕自动退出后,到这里卸载就差不多成功了,重启后删除安装目录即可,不用删除注册表之类的了。
如果重启后注册表内未清理干净,按照以下完全卸载的方法清理下就好了。
三、删除注册表及其他
1,运行regedit
选择HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE,按del键删除这个入口。
选择HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services,滚动 这个列表,删除所有Oracle入口。
选择HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application, 删除所有Oracle入口。
删除环境变量CLASSPATH和PATH中有关Oracle的设定
3,从桌面上、STARTUP(启动)组、程序菜单中,删除所有有关Oracle的组和图标。
4,删除\Program Files\Oracle目录
四、重新安装即可,注意设置服务器字符集。
安装比较简单,一直下一步就可。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



To query the Oracle tablespace size, follow the following steps: Determine the tablespace name by running the query: SELECT tablespace_name FROM dba_tablespaces; Query the tablespace size by running the query: SELECT sum(bytes) AS total_size, sum(bytes_free) AS available_space, sum(bytes) - sum(bytes_free) AS used_space FROM dba_data_files WHERE tablespace_

Oracle View Encryption allows you to encrypt data in the view, thereby enhancing the security of sensitive information. The steps include: 1) creating the master encryption key (MEk); 2) creating an encrypted view, specifying the view and MEk to be encrypted; 3) authorizing users to access the encrypted view. How encrypted views work: When a user querys for an encrypted view, Oracle uses MEk to decrypt data, ensuring that only authorized users can access readable data.

Creating an Oracle table involves the following steps: Use the CREATE TABLE syntax to specify table names, column names, data types, constraints, and default values. The table name should be concise and descriptive, and should not exceed 30 characters. The column name should be descriptive, and the data type specifies the data type stored in the column. The NOT NULL constraint ensures that null values are not allowed in the column, and the DEFAULT clause specifies the default values for the column. PRIMARY KEY Constraints to identify the unique record of the table. FOREIGN KEY constraint specifies that the column in the table refers to the primary key in another table. See the creation of the sample table students, which contains primary keys, unique constraints, and default values.

Data import method: 1. Use the SQLLoader utility: prepare data files, create control files, and run SQLLoader; 2. Use the IMP/EXP tool: export data, import data. Tip: 1. Recommended SQL*Loader for big data sets; 2. The target table should exist and the column definition matches; 3. After importing, data integrity needs to be verified.

There are three ways to view instance names in Oracle: use the "sqlplus" and "select instance_name from v$instance;" commands on the command line. Use the "show instance_name;" command in SQL*Plus. Check environment variables (ORACLE_SID on Linux) through the operating system's Task Manager, Oracle Enterprise Manager, or through the operating system.

Uninstall method for Oracle installation failure: Close Oracle service, delete Oracle program files and registry keys, uninstall Oracle environment variables, and restart the computer. If the uninstall fails, you can uninstall manually using the Oracle Universal Uninstall Tool.

There are the following methods to get time in Oracle: CURRENT_TIMESTAMP: Returns the current system time, accurate to seconds. SYSTIMESTAMP: More accurate than CURRENT_TIMESTAMP, to nanoseconds. SYSDATE: Returns the current system date, excluding the time part. TO_CHAR(SYSDATE, 'YYY-MM-DD HH24:MI:SS'): Converts the current system date and time to a specific format. EXTRACT: Extracts a specific part from a time value, such as a year, month, or hour.

An AWR report is a report that displays database performance and activity snapshots. The interpretation steps include: identifying the date and time of the activity snapshot. View an overview of activities and resource consumption. Analyze session activities to find session types, resource consumption, and waiting events. Find potential performance bottlenecks such as slow SQL statements, resource contention, and I/O issues. View waiting events, identify and resolve them for performance. Analyze latch and memory usage patterns to identify memory issues that are causing performance issues.
