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

1. Close an instance

[oracle@rac11g2 ~] $sqlplus / as sysdbaSQL > shutdown immediate

two。 Backing up spfile files

SQL > create pfile='/home/oracle/acct1.pfile' from spfile

3. Modify the pfile file cluster_database to false

* .cluster_database=FALSE

4. Using the pfile file, start the single instance database to the mount state

SQL > startup mount pfile='/home/oracle/acct1.pfile'

5. Execute nid to modify dbname

[oracle@rac11g1] $nid target=sys/oracle dbname=crmdb setname=yDBNEWID: Release 11.2.0.4.0-Production on Tue May 19 09:31:48 2015Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Connected to database ACCT (DBID=3809824099) Connected to server version 11.2.0Control Files in database: + DATA_DG/acct/controlfile/current.261.872692963 + DATA_DG/acct/controlfile/current.260.872692963Change database name of database ACCT to CRMDB? (Y / [N]) = > YProceeding with operationChanging database name from ACCT to CRMDB Control File + DATA_DG/acct/controlfile/current.261.872692963-modified Control File + DATA_DG/acct/controlfile/current.260.872692963-modified Datafile + DATA_DG/acct/datafile/system.256.87269284-wrote new name Datafile + DATA_DG/acct/datafile/sysaux.257.87269284-wrote new name Datafile + DATA_DG/acct/datafile/undotbs1.258.87269284-wrote new name Datafile + DATA_DG/acct/datafile/ Users.259.87269284-wrote new name Datafile + DATA_DG/acct/datafile/example.267.87269300-wrote new name Datafile + DATA_DG/acct/datafile/undotbs2.268.87269351-wrote new name Datafile + DATA_DG/acct/tempfile/temp.266.87269298-wrote new name Control File + DATA_DG/acct/controlfile/current.261.872692963-wrote new name Control File + DATA_DG/acct/controlfile/current.260.872692963-wrote new name Instance shut downDatabase name changed to CRMDB.Modify parameter file and generate A new password file before restarting.Succesfully changed database name.DBNEWID-Completed succesfully.

6. Modify ORACLE_SID information

-Node 1-

6.1 Environment variables

[oracle@rac11g1 ~] $vi .bash _ profileexport ORACLE_SID=crmdb1

6.2 password file

[oracle@rac11g1 ~] $cd $ORACLE_HOME/ DBS [oracle @ rac11g1 dbs] $orapwd file=orapwcrmdb1 password=oracle

6.3 modify the pfile file to start the database

* .cluster_database=TRUE*.db_name='crmdb' replace acct1 with crmdb1:% s/acct1/crmdb1/g replace acct2 with crmdb2:% s/acct2/crmdb2/g

6.4 create a new spfile parameter file

[oracle@rac11g1 ~] $sqlplus / as sysdbaSQL > startup pfile='/home/oracle/acct1.pfile' nomount;SQL > create spfile='+DATA_DG' from pfile='/home/oracle/acct1.pfile'

6.5 create a pfile parameter file

[oracle@rac11g1 ~] $cd $ORACLE_HOME/ DBS [oracle @ rac11g1 dbs] $vi initcrmdb1.oraSPFILE='+DATA_DG/crmdb/PARAMETERFILE/spfile.293.880105913'

-Node 2-

1 environment variable

[oracle@rac11g2 ~] $vi .bash _ profileexport ORACLE_SID=crmdb2

two。 Password file

[oracle@rac11g2 ~] $cd $ORACLE_HOME/ DBS [oracle @ rac11g2 dbs] $orapwd file=orapwcrmdb2 password=oracle

3. Parameter file

[oracle@rac11g2 dbs] $vi initcrmdb2.oraSPFILE='+DATA_DG/crmdb/PARAMETERFILE/spfile.293.880105913'

7. Modify crs resources

7.1 remove the old instance configuration

[oracle@rac11g1] $srvctl remove database-d acct

7.2 add a new instance configuration

[oracle@rac11g1 ~] $srvctl add database-d crmdb-o / oracle/app/oracle/product/11.2.0/db_1/ [Oracle @ rac11g1 ~] $srvctl add instance-d crmdb-I crmdb1-n rac11g1 [oracle@rac11g1 ~] $srvctl add instance-d crmdb-I crmdb2-n rac11g2

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.