Shulou(Shulou.com)06/01 Report--

Experimental scenario:

Two nodes RAC, hostname is db1, db2, now need to delete db2, this example is deleted in the normal state.

1. The db1,db2 node checks whether the CSS server is normal, as shown below.

[root@db1 ~] # su-grid

[grid@db1] $olsnodes-t-s

Db1 Active Unpinned

Db2 Active Unpinned

[grid@db1 ~] $

If pinned, you need to execute on the db1 node:

[grid@db1] $crsctl unpin css-n db2

two。 Delete db2 instances using dbca

Delete the db2 instance on any reserved node

[root@db1 ~] # su-oracle

[oracle@db1 ~] $dbca

1) verify that the db2 instance has been deleted

View an example of the activity:

$sqlplus / as sysdba

SQL > select thread#,status,instance from v$thread

THREAD# STATUS INSTANCE

1 OPEN orcl1

2) check the configuration of the library:

[oracle@db1] $srvctl config database-d orcl

Database unique name: orcl

Database name: orcl

Oracle home: / u01/app/oracle/product/11.2.0/db_1

Oracle user: oracle

Spfile: + DATA/orcl/spfileorcl.ora

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: orcl

Database instances: orcl1

Disk Groups: DATA,RECOVERY

Mount point paths:

Services:

Type: RAC

Database is administrator managed

3. Stop snooping of db2 nodes

[root@db2 ~] # su-grid

[grid@db2] $srvctl disable listener-l listener-n db2

[grid@db2] $srvctl config listener-a

Name: LISTENER

Network: 1, Owner: grid

Home:

/ u01/app/11.2.0/grid on node (s) db2,db1

End points: TCP:1521

[grid@db2 ~] $

[grid@db2] $srvctl stop listener-l listener-n db2

[grid@db2 ~] $

4. Update the cluster list using oracle users on the db2 node

# su-oracle

$ORACLE_HOME/oui/bin/runInstaller-updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES= {db2}"-local

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB. Actual 4031 MB Passed

The inventory pointer is located at / etc/oraInst.loc

The inventory is located at / u01/app/oraInventory

'UpdateNodeList' was successful.

5. Delete the database software for db2 nodes

Execute on the db2 node:

# su-oracle

$$ORACLE_HOME/deinstall/deinstall-local

Checking for required files and bootstrapping...

Please wait...

Location of logs/ u01/app/oraInventory/logs/

# ORACLE DEINSTALL & DECONFIG TOOL START #

# CHECK OPERATION START #

# # [START] Install check configuration # #

Checking for existence of the Oracle home location / u01/app/oracle/product/11.2.0/db_1

Oracle Home type selected for deinstall is: Oracle Real Application Cluster Database

Oracle Base selected for deinstall is: / u01/app/oracle

Checking for existence of central inventory location / u01/app/oraInventory

Checking for existence of the Oracle Grid Infrastructure home / u01/app/11.2.0/grid

The following nodes are part of this cluster: db2

Checking for sufficient temp space availability on node (s): 'db2'

# # [END] Install check configuration # #

Network Configuration check config START

Network de-configuration trace file location: / u01/app/oraInventory/logs/netdc_check2015-12-29 11-35-16-AM.log

Network Configuration check config END

Database Check Configuration START

Database de-configuration trace file location: / u01/app/oraInventory/logs/databasedc_check2015-12-29 11-35-19-AM.log

Database Check Configuration END

Enterprise Manager Configuration Assistant START

EMCA de-configuration trace file location: / u01/app/oraInventory/logs/emcadc_check2015-12-29 11-35-22-AM.log

Enterprise Manager Configuration Assistant END

Oracle Configuration Manager check START

OCM check log file location: / u01/app/oraInventory/logs//ocm_check7428.log

Oracle Configuration Manager check END

# CHECK OPERATION END #

# CHECK OPERATION SUMMARY #

Oracle Grid Infrastructure Home is: / u01/app/11.2.0/grid

The cluster node (s) on which the Oracle home deinstallation will be performed are:db2

Since-local option has been specified, the Oracle home will be deinstalled only on the local node, 'db2', and the global configuration will be removed.

Oracle Home selected for deinstall is: / u01/app/oracle/product/11.2.0/db_1

Inventory Location where the Oracle home registered is: / u01/app/oraInventory

The option-local will not modify any database configuration for this Oracle home.

No Enterprise Manager configuration to be updated for any database (s)

No Enterprise Manager ASM targets to update

No Enterprise Manager listener targets to migrate

Checking the config status for CCR

Oracle Home exists with CCR directory, but CCR is not configured

CCR check is finished

Do you want to continue (y-yes, n-no)? [n]: y

A log of this session will be written to:'/ u01/app/oraInventory/logs/deinstall_deconfig2015-12-29, 11-35-12, color AM.outout

Any error messages from this session will be written to:'/ u01/app/oraInventory/logs/deinstall_deconfig2015-12-29, 11-35-12 AM.err'

# CLEAN OPERATION START #

Enterprise Manager Configuration Assistant START

EMCA de-configuration trace file location: / u01/app/oraInventory/logs/emcadc_clean2015-12-29 11-35-22-AM.log

Updating Enterprise Manager ASM targets (if any)

Updating Enterprise Manager listener targets (if any)

Enterprise Manager Configuration Assistant END

Database de-configuration trace file location: / u01/app/oraInventory/logs/databasedc_clean2015-12-29 11-47-34-AM.log

Network Configuration clean config START

Network de-configuration trace file location: / u01/app/oraInventory/logs/netdc_clean2015-12-29 11-47-34-AM.log

De-configuring Local Net Service Names configuration file...

Local Net Service Names configuration file de-configured successfully.

De-configuring backup files...

Backup files de-configured successfully.

The network configuration has been cleaned up successfully.

Network Configuration clean config END

Oracle Configuration Manager clean START

OCM clean log file location: / u01/app/oraInventory/logs//ocm_clean7428.log

Oracle Configuration Manager clean END

Setting the force flag to false

Setting the force flag to cleanup the Oracle Base

Oracle Universal Installer clean START

Detach Oracle home'/ u01 from the central inventory on the local node from the central inventory on the local node: Done

Delete directory'/ u01 on the local node on the local node: Done

Failed to delete the directory'/ U01 / U01. The directory is in use.

Delete directory'/ u01OnOnOnAccel'on the local node: Failed

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.