Shulou(Shulou.com)05/31 Report--

How to delete Oracle library, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

Today I will teach you how to delete Oracle library!

DBCA starts the graphical interface

Select the DB you want to delete and click the finish button.

Half a cup of tea, delete the library to complete! Much more than installing EZ.

Attachment 1. The manually created database is registered with DBCA (added to the last line):

[oracle@db01 ~] $vi / etc/oratab

#

# This file is used by ORACLE utilities. It is created by root.sh

# and updated by either Database Configuration Assistant while creating

# a database or ASM Configuration Assistant while creating ASM instance.

# A colon,':', is used as the field terminator. A new line terminates

# the entry. Lines beginning with a pound sign,'#, are comments.

#

# Entries are of the form:

# $ORACLE_SID:$ORACLE_HOME::

#

# The first and second fields are the system identifier and home

# directory of the database respectively. The third filed indicates

# to the dbstart utility that the database should, "Y", or should not

# "N", be brought up at system boot time.

#

# Multiple entries with the same $ORACLE_SID are not allowed.

#

#

ORCL:/u01/app/oracle/product/11.2.0/db_1:N

PROD:/u01/app/oracle/product/11.2.0/db_1:N

Attachment 2. Example of silent installation of DBCA:

Click (here) to collapse or open

[oracle@db01] $dbca-silent-createDatabase-templateName $ORACLE_HOME/assistants/dbca/templates/General_Purpose.dbc-gdbname PROD-sid PROD-characterSet ZHS16GBK

Enter SYS user password:

Enter SYSTEM user password:

Copying database files

1% complete

3% complete

37% complete

Creating and starting Oracle instance

40% complete

45% complete

50% complete

55% complete

56% complete

60% complete

62% complete

Completing Database Creation

66% complete

70% complete

73% complete

85% complete

96% complete

100% complete

Look at the log file "/ u01/app/oracle/cfgtoollogs/dbca/PROD/PROD.log" for further details.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.