Skip Headers

Oracle Application Server 10g Administrator's Guide
10g (9.0.4)

Part Number B10376-01
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

8
Changing Infrastructure Services

This chapter provides procedures for changing the Infrastructure Services used by a middle-tier instance.

It contains the following topics:

8.1 Overview of Procedures for Changing Infrastructure Services

Most middle-tier instances use Infrastructure Services, such as Identity Management Services and the Metadata Repository. These services are usually assigned during installation.

After installation, you may want to change the Infrastructure Services used by a middle-tier instance. For example, you may want to use an Identity Management Service on a different host. Or, you may want to use a different Metadata Repository.

You can change Infrastructure services using the Infrastructure Page on Oracle Enterprise Manager Application Server Control, shown in figure Figure 8-1. Notice that the page allows you to change the Identity Management or the Metadata Repository used by a middle-tier instance.

Figure 8-1 Application Server Control Infrastructure Page

Text description of infpage2.gif follows.

Text description of the illustration infpage2.gif

You must change Infrastructure Services when you change any of the following:

You cannot simply use the wizard to change from one Infrastructure service to another. You must first perform manual tasks in order to create and prepare the new Infrastructure service. This chapter provides the following supported procedures for changing Infrastructure services:

8.2 Changing the OID or HTTP (SSO) Ports on Identity Management

If you would like to change the Oracle Internet Directory non-SSL or SSL port on an Identity Management installation, refer to Section 5.6.2, "Changing Oracle Internet Directory Ports".

If you would like to change the Oracle HTTP Server non-SSL or SSL listen port on an Identity Management installation, which effectively changes the SSO port, refer to Section 5.6.3, "Changing the HTTP Server (SSO) Port on Identity Management".

8.3 Changing Oracle Internet Directory from Dual Mode to SSL Mode

When you install Identity Management, you are asked to choose a mode for Oracle Internet Directory. The default mode is dual mode, which allows some components to access Oracle Internet Directory using non-SSL connections. During the installation, you can choose SSL mode, which specifies that all components must use SSL when connecting to the directory.

If you did not choose SSL mode during the installation, and would like to change to SSL mode after installation, you can follow the procedure in this section. It includes changing the mode of the Oracle Internet Directory, and updating middle-tier instances to use the new mode.

Task 1: Change the Oracle Internet Directory Mode

Perform this task on the Infrastructure that contains Oracle Internet Directory.

  1. Create a file named mod.ldif that contains the following lines:

    dn:cn=configset0,cn=osdldapd,cn=subconfigsubentry
    changetype:modify
    replace:orclsslenable
    orclsslenable:1
    
    
  2. Run the following command:

    ORACLE_HOME/bin/ldapmodify -D cn=orcladmin -w orcladmin_passwd -p oid_port 
    -v -f mod.ldif
    
    

    oid_port is the non-SSL OID port. This is listed as OIDport in ORACLE_HOME/config/ias.properties.

  3. Edit the following file:

    ORACLE_HOME/network/admin/ldap.ora
    
    
    1. Modify the following line to remove the non-SSL port number:

      DIRECTORY_SERVERS=(myhost.myco.com::sslport)
      
      
    2. Save and close the file.

  4. Edit the following file:

    ORACLE_HOME/config/ias.properties
    
    
    1. Change the SSLOnly parameter as follows:

      SSLOnly=true
      
      
    2. Save and close the file.

  5. Reconfigure SSO to communicate to OID in SSL mode:

    1. Obtain the ORASSO schema password:

      ORACLE_HOME/bin/ldapsearch -p oid_port -h hostname -D "cn=orcladmin" -w 
      orcladmin_password -b "orclresourcename=orasso, 
      orclreferencename=global_db_name, cn=ias infrastructure databases, 
      cn=ias, cn=products, cn=oraclecontext" -s base "objectclass=*" 
      orclpasswordattribute
      
      

      oid_port is the non-SSL OID port. This is listed as OIDport in ORACLE_HOME/config/ias.properties.

      global_db_name is the name of the entry for the Metadata Repository in ORACLE_HOME/network/admin/tnsnames.ora. For example: asdb.myco.com.

      This command prints the ORASSO password in a line like the following:

      orclpasswordattribute=LAetjdQ5
      
      
    2. Change to the following directory:

      cd ORACLE_HOME/sso/admin/plsql/sso
      
      
    3. Run the following command:

      sqlplus orasso/orasso_password @ssooconf.sql
      
      

      Where orasso_password is the ORASSO schema password you obtained in the previous step.

      The following prompts appear:

      • Enter value for new_oid_host:

        Press return to move through this and similar attributes you do not need to change, and enter the new value for the attributes that have changed. When you reach the following prompt:

      • Enter value for new_ldapusessl:

        Enter Y in this field, then press return. A message appears indicating that the value new_ldapusessl has been updated.

  6. Restart the instance that contains Oracle Internet Directory.

    ORACLE_HOME/opmn/bin/opmnctl stopall
    ORACLE_HOME/opmn/bin/opmnctl startall
    
Task 2: Change Middle-Tier Instances to Use SSL Mode

In each middle-tier instance, run the Change Identity Management wizard and restart the instance:

  1. On Application Server Control, navigate to the Instance Home Page for the middle-tier instance.

  2. Click Infrastructure.

  3. On the Infrastructure Page, in the Identity Management section, click Change.

  4. On the Internet Directory page:

    • Host: Enter the fully-qualified name of the OID host.

    • Port: Enter the SSL OID port number.

    • Use only SSL connections with Internet Directory: Check this box.

    Click Next.

  5. On the Login page:

    • User Name: Enter cn=orcladmin, or the distinguished name of a user in the iASAdmins group.

    • Password: Enter the password for the user.

    Click Next.

  6. On the Validation page, you will receive informational messages regarding the validation of this operation. If you receive any error message, follow the instructions for investigating them. Otherwise, if the operation is valid, click Finish.

  7. When the operation is finished, you must restart the components in the middle-tier instance.

    1. Click Home to navigate back to the Instance Home Page.

    2. Click Start All.

8.4 Moving Identity Management to a New Host

This section provides a procedure for moving Identity Management to a new host. This procedure involves creating a replica (or copy) of the original Identity Management on a different host, along with its own new Metadata Repository, and then changing the middle-tier instance to use the new Identity Management.


Note:

You cannot simply change a middle-tier instance from one Identity Management to another. The new Identity Management must be a replica of the original, created using the instructions in this procedure.


8.4.1 Sample Uses for this Procedure

The following are sample uses for this procedure:

8.4.2 Assumptions and Restrictions

8.4.3 Overview

An overview of the procedure is as follows:

  1. You have an original Identity Management (also called the Master) used by one or more middle-tier instances. The Identity Management has a Metadata Repository. You install and setup a new Identity Management (also called the Replica). This Identity Management has its own Metadata Repository. The Oracle Internet Directory in the new Identity Management is an LDAP-based Replica of the original OID. Replication takes place constantly from the original OID to the new OID.

    Figure 8-2 shows a sample of this setup.

    Figure 8-2 Original Host (Master) and New Host (Replica)

    Text description of asadm009.gif follows

    Text description of the illustration asadm009.gif

  2. You perform the following steps to change to the new Identity Management. The steps are shown in Figure 8-3.

    • Step 1: Migrate SSO and DIP data from the original Metadata Repository (Master) to the new Metadata Repository (Replica)

    • Step 2: Change the middle-tier instances to use the new Metadata Repository.

    • Step 3: Stop the LDAP-based replication.

    Figure 8-3 Changing from Original to New Identity Management

    Text description of asadm010.gif follows

    Text description of the illustration asadm010.gif

8.4.4 Procedure

This procedure contains the following tasks:

Task 1: Install and Set Up the New Identity Management and Metadata Repository

In this task, you install and set up the new Identity Management and its associated Metadata Repository. The new Identity Management is an LDAP-based replica of the original Identity Management.

  1. Read Section F.1, "About LDAP-based Replicas" to learn about LDAP-based Replicas and how they are used for this procedure.

  2. Follow the procedure in Section F.2, "Installing and Setting Up an LDAP-based Replica" to install and set up the new Identity Management and Metadata Repository.

Task 2: Migrate SSO and DIP Data

In this task, you migrate the SSO and DIP data from the original Metadata Repository to the new Metadata Repository.

Follow the procedure in Section F.3, "Migrating SSO and DIP Data". The source for the migration is the original Metadata Repository (Master) and the target for the migration is the new Metadata Repository (Replica).

Task 3: Change Middle-Tier Instances to the New Identity Management

In each middle-tier instance, run the Change Identity Management wizard and restart the instance:

  1. On Application Server Control, navigate to the Instance Home Page for the middle-tier instance.

  2. Click Infrastructure.

  3. On the Infrastructure Page, in the Identity Management section, click Change.

  4. Follow the steps in the wizard for supplying the new Identity Management information.

  5. When the wizard is finished, navigate to the Instance Home Page and start your instance by clicking Start All.

If you have a problem changing the middle-tier instances to the new host, check to make sure replication is running and try again.

Task 4: Stop Replication

Stop the replication between the original Identity Management and the new Identity Management (replica) by running the following command in the new Identity Management Oracle home:

ORACLE_HOME/bin/oidctl connect=global_db_name server=oidrepld instance=1 
flags='-p oid_port' stop

global_db_name is the global db name of the new Identity Management. (This is referred to as replica_db_name in Section F.2.)

oid_port is the non-SSL OID port in the new Identity Management. (This is referred to as replica_oid_port in Section F.2.)

8.4.5 Strategy for Performing Failover with this Procedure

As mentioned in Section 8.4.1, "Sample Uses for this Procedure", you can modify this procedure to perform failover for Identity Management. This enables you to move your middle-tier instances to the new Identity Management in case the original is lost.

To perform failover:

  1. Install and set up the new Identity Management as described in Task 1: Install and Set Up the New Identity Management and Metadata Repository.

  2. Export SSO and DIP data on a regular basis from the original Metadata Repository. You do not need to import the data into the new Metadata Repository. You only need to export the data and copy the files to the new Metadata Repository Host. Refer to Section F.3, "Migrating SSO and DIP Data".

  3. If you lose the original Identity Management:

    1. Stop replication. Refer to Task 4: Stop Replication.

    2. Import your most recent copy of the SSO and DIP data into the new Identity Management repository. Refer to Section F.3, "Migrating SSO and DIP Data".

    3. Change the middle-tier instances to use the new Identity Management. Refer to Task 3: Change Middle-Tier Instances to the New Identity Management.

8.5 Changing from a Test to a Production Environment

This section provides a procedure for changing from a test to production environment. This allows you to have a test environment for your applications, and then move your test applications and, optionally, test data into your production environment.

8.5.1 Sample Uses for this Procedure

The following are sample uses for this procedure:

8.5.2 Overview

An overview of the procedure is as follows:

  1. You have an existing production environment that includes middle-tier instances, an Identity Management installation with a Metadata Repository, and one or more Metadata Repositories used for product metadata.

    You create a test environment by installing and setting up a replica (or copy) of the production Identity Management. This Identity Management has its own Metadata Repository. The Oracle Internet Directory in the test Identity Management is an LDAP-based Replica of the production OID. Replication takes place constantly from the production OID to the test OID.This replica has its own Metadata Repository. You then install test middle-tier instances to use the test Identity Management. These middle-tier instances use a separate Metadata Repository for their product metadata. You can develop and test your applications in the test environment.

    Figure 8-4 shows a sample production and test environment.

    Figure 8-4 Production and Test Environment

    Text description of asadm011.gif follows

    Text description of the illustration asadm011.gif

  2. When you are ready to roll out your test applications to your production environment, you perform the following steps. The steps are shown in Figure 8-5.

    • Step 1: Migrate data from the test environment to the production environment

    • Step 2: Change the test middle-tier instances to use the production environment.

    Figure 8-5 Moving from Test to Production

    Text description of asadm012.gif follows

    Text description of the illustration asadm012.gif

  3. You have several options for the test Metadata Repository used for product metadata:

8.5.3 Procedure

This procedure contains the following tasks:

Task 1: Install and Set Up the Test Identity Management and Metadata Repository

In this task, you install and set up the test Identity Management and its associated Metadata Repository. The test Identity Management is an LDAP-based replica of the original Identity Management.

  1. Read Section F.1, "About LDAP-based Replicas" to learn about LDAP-based Replicas and how they are used for this procedure.

  2. Follow the procedure in Section F.2, "Installing and Setting Up an LDAP-based Replica" to install and set up the test Identity Management and Metadata Repository.

Task 2: Identify the Replica as a Pilot Replica

Perform this task in the Oracle home of the test (replica) Oracle Internet Directory:

  1. Create a file called mod.ldif that contains the following lines:

    dn:orclreplicaid=replica_replicaid,cn=replication configuration
    changetype:modify
    replace:orclreplicatype
    orclreplicatype:2
    
    

    Where replica_replicaid is the test (replica) replica ID you obtained in Section F.2, "Installing and Setting Up an LDAP-based Replica".

  2. Run the following command:

    ORACLE_HOME/bin/ldapmodify -D cn=orcladmin -w replica_orcladmin_passwd -p 
    replica_oid_port -v -f mod.ldif
    
    

    Where replica_orcladmin_passwd is the test (replica) orcladmin password and replica_oid_port is the test (replica) non-SSL OID port you obtained in Section F.2, "Installing and Setting Up an LDAP-based Replica".

Task 3: Start the Test Oracle Internet Directory in Pilot Mode

Perform this task in the Oracle home of the test (replica) Oracle Internet Directory:

  1. Create a file called mod.ldif that contains the following lines:

    dn:orclreplicaid=replica_replicaid,cn=replication configuration
    changetype:modify
    replace:orclpilotmode
    orclpilotmode:1
    
    

    Where replica_replicaid is the test (replica) replica ID you obtained in Section F.2, "Installing and Setting Up an LDAP-based Replica".

  2. Run the following command:

    ORACLE_HOME/bin/ldapmodify -D cn=orcladmin -w replica_orcladmin_passwd -p 
    replica_oid_port -v -f mod.ldif
    
    

    Where replica_orcladmin_passwd is the test (replica) orcladmin password and replica_oid_port is the test (replica) non-SSL OID port you obtained in Section F.2, "Installing and Setting Up an LDAP-based Replica".

  3. Restart OID on the test (replica) node:

    ORACLE_HOME/opmn/bin/opmnctl stopproc ias-component=OID
    ORACLE_HOME/opmn/bin/opmnctl startproc ias-component=OID
    
Task 4: Install Test Middle-Tier Instances

Install your test middle-tier instances and configure them to use the test Identity Management. You should use a separate Metadata Repository for the product metadata.

Task 5: Develop and Test Your Applications

Develop and test application in your test environment.

Task 6: Migrate Data from the Test to Production Environment

When you are ready to move your applications from your test to production environment, you must migrate data.

Follow the procedure in Section F.4, "Migrating Oracle Internet Directory Data".

Task 7: Change Middle-Tier Instances to the Production Identity Management

In each middle-tier instance, run the Change Identity Management wizard and restart the instance:

  1. On Application Server Control, navigate to the Instance Home Page for the middle-tier instance.

  2. Click Infrastructure.

  3. On the Infrastructure Page, in the Identity Management section, click Change.

  4. Follow the steps in the wizard for supplying the production Identity Management information.

  5. When the wizard is finished, navigate to the Instance Home Page and start your instance by clicking Start All.

Task 8: Move the Test Product Metadata Repository to Production

You have several options for moving your test product Metadata Repository to your production environment:

Task 9: (Optional) Continue to Use Your Test Environment

You can continue to use your test environment by installing new middle-tier instances against the test Identity Management.

8.6 Changing the Metadata Repository Used by a Middle-Tier Instance

This section provides a procedure for changing the Metadata Repository used by a middle-tier instance. This procedure involves making a copy of the original Metadata Repository on a different host, and then changing the middle-tier instance to use the new Metadata Repository.


Note:

You cannot simply change a middle-tier instance from one Metadata Repository to another. The new Metadata Repository must be a copy of the original, created using the instructions in this procedure.


8.6.1 Sample Uses for this Procedure

The following are sample uses for this procedure:

8.6.2 Assumptions and Restrictions

8.6.3 Overview

An overview of the procedure is as follows:

  1. You have an original Metadata Repository. It is used by one or more middle-tier instances for product metadata. The middle-tier instances use Identity Management, and the Metadata Repository is registered with Oracle Internet Directory in that Identity Management.

    Figure 8-6 shows a sample original Metadata Repository (asdb1.myco.com).

    Figure 8-6 Original Metadata Repository

    Text description of asadm013.gif follows

    Text description of the illustration asadm013.gif

    The following table shows sample attributes for the original Metadata Repository:

    Attribute Original Metadata Repository New Metadata Repository

    Oracle home

    /private/oraHome

    N/A

    Datafile location

    /private/oraHome/oradata

    N/A

    SID

    asdb1

    N/A

    Global db name

    asdb1.myco.com

    N/A

    Registered with OID?

    Yes

    N/A

  2. You create a copy of the original Metadata Repository by installing a new Metadata Repository, backing up the original Metadata Repository, and restoring to the new Metadata Repository.

    Figure 8-7 shows sample original and new Metadata Repositories.

    Figure 8-7 Original Metadata Repository and New Metadata Repository

    Text description of asadm014.gif follows

    Text description of the illustration asadm014.gif

    The following table shows sample attributes for the original and new Metadata Repositories:

    Attribute Original Metadata Repository New Metadata Repository

    Oracle home

    /private/oraHome

    /private/oraHome

    Datafile location

    /private/oraHome/oradata

    /private/oraHome/oradata

    SID

    asdb1

    asdb1

    Global db name

    asdb1.myco.com

    asdb1.myco.com

    Registered with OID?

    Yes

    No

  3. You perform the following steps to change to the new Metadata Repository. The steps are shown in Figure 8-8.

    • Step 1: Change the global db name of the new Metadata Repository to a unique name (in this sample, asdb2.myco.com).

    • Step 2: Register the new Metadata Repository with the same Oracle Internet Directory as the old Metadata Repository.

    • Step 3: Change the middle-tier instances to use the new Metadata Repository.

    Figure 8-8 Changing from the Original to the New Metadata Repository

    Text description of asadm015.gif follows

    Text description of the illustration asadm015.gif

    The following table shows sample attributes for the original and new Metadata Repositories after performing the change:

    Attribute Original Metadata Repository New Metadata Repository

    Oracle home

    /private/oraHome

    /private/oraHome

    Datafile location

    /private/oraHome/oradata

    /private/oraHome/oradata

    SID

    asdb1

    asdb1

    Global db name

    asdb1.myco.com

    asdb2.myco.com

    Registered with OID?

    Yes

    Yes

  4. If you are using the scenario where you no longer require the original Metadata Repository, you can discard the original Metadata Repository.

8.6.4 Procedure

This procedure contains the following tasks:

Before You Begin

If your middle-tier instances use OracleAS Portal and Oracle Ultra Search, you will need to supply the WKSYS schema password later in this procedure in Task 4: Configure Ultra Search Metadata in the New Metadata Repository. You should obtain this password now from the old Metadata Repository.

Task 1: Install the New Metadata Repository

Install the new Metadata Repository as follows:

  1. Make sure to install the Metadata Repository into an Oracle home that has the same path as the old Metadata Repository Oracle home

  2. Use Oracle Universal Installer to install the Metadata Repository

  3. Choose to install an Infrastructure

  4. Choose to install a Metadata Repository only

  5. Do not register the Metadata Repository with OID

  6. Specify the same SID and global db name as the old Metadata Repository

  7. Specify the same datafile location as the old Metadata Repository

Task 2: Back Up the Original Metadata Repository

In this task, you create a backup of the original Metadata Repository. This task provides the steps for doing this using RMAN, however, if you are an experience DBA, you can back up the Metadata Repository according to your standard practices.

Perform all of the steps in this task on the original Metadata Repository host.

  1. Create directories to store backup files and log files. For example:

    mkdir -p BACKUP_DIR/log_files
    mkdir -p BACKUP_DIR/db_files
    
    
  2. Make sure the original Metadata Repository is up and running.

  3. Make sure you have set the ORACLE_HOME and ORACLE_SID environment variables you run the SQL*Plus command.

  4. Obtain the DBID of the original Metadata Repository using SQL*Plus:

    SQL> SELECT DBID FROM v$database;
    
    

    Make note of this value; you will use it later in the procedure.

  5. Create a file named BACKUP_DIR/cold_backup.rcv that contains the following lines. In the file, substitute the full path for BACKUP_DIR.

    shutdown immediate;
    startup mount;
    configure controlfile autobackup on;
    configure controlfile autobackup format for device type disk to 
    'BACKUP_DIR/db_files/%F';
    
    run {
    allocate channel dev1 device type disk format
    'BACKUP_DIR/db_files/%U';
    backup database plus archivelog;
    release channel dev1;
    }
    
    
  6. Run RMAN to back up the Metadata Repository (the following is a single command; type it all on one line):

    ORACLE_HOME/bin/rman target /
    cmdfile=BACKUP_DIR/cold_backup.rcv > BACKUP_DIR/log_files/backup.log
    
    
  7. Copy the backup directories to the new host. You do not need to use the same path for BACKUP_DIR on the new host.

    BACKUP_DIR/log_files
    BACKUP_DIR/db_files
    
Task 3: Restore the Backup to the New Metadata Repository

In this task you restore the backup to the new Metadata Repository.

Perform all of the steps in this task on the new Metadata Repository host.

  1. Make sure the new Metadata Repository is down:

    sqlplus "sys/SYS_PASSWORD as sysdba"
    SQL> shutdown immediate;
    
    
  2. Regenerate the password file:

    prompt> mv ORACLE_HOME/dbs/orapwORACLE_SID 
    ORACLE_HOME/dbs/orapwORACLE_SID.old
    prompt> ORACLE_HOME/bin/orapwd file=ORACLE_HOME/dbs/orapwORACLE_SID 
    password=new_password
    
    

    new_password is the new SYS password. You can use the old SYS password, or set it to a new password.

  3. Start the new Metadata Repository but do not mount it:

    SQL> startup nomount;
    
    
  4. Create a file named BACKUP_DIR/restore.rcv that contains the following lines. In the file, substitute the full path for BACKUP_DIR and the DBID obtained in the previous task.

    set dbid=DBID;
    connect target /;
    set controlfile autobackup format for device type disk to 
    'BACKUP_DIR/db_files/%F';
    restore controlfile from autobackup;
    startup mount force;
    
    run {
    allocate channel dev1 device type disk format
    'BACKUP_DIR/db_files/%U';
    restore database;
    release channel dev1;
    alter database open resetlogs;
    }
    
    
  5. Run RMAN to restore the Metadata Repository:

    prompt> ORACLE_HOME/bin/rman cmdfile=BACKUP_DIR/restore.rcv > 
    BACKUP_DIR/log_files/restore.log
    
    
  6. After you restore using RMAN, determine if the TEMP tablespace has a datafile by running the following command in SQL*Plus:

    SQL> select file_name from dba_temp_files where tablespace_name like 'TEMP';
    
    

    If the preceding command does not return any files, add a datafile:

    SQL> alter tablespace "TEMP" add tempfile 
    'ORACLE_HOME/oradata/GDB/temp01.dbf' size 5120K autoextend on next 8k 
    maxsize unlimited;
    
    

    GDB is the first part of the global database name.

    Note that the above command creates a file called temp01.dbf and adds it to the TEMP tablespace. If the temp01.dbf file already exists in the directory, add a "reuse" clause to the command:

    SQL> alter tablespace "TEMP" add tempfile 
    'ORACLE_HOME/oradata/GDB/temp01.dbf' size 5120K reuse autoextend on next 8k 
    maxsize unlimited;
    
    

    GDB is the first part of the global database name.

Task 4: Configure Ultra Search Metadata in the New Metadata Repository

Perform this task on the new Metadata Repository.

  1. Make sure the ORACLE_HOME and ORACLE_SID environment variables are set.

  2. Run the following commands:

    cd ORACLE_HOME/ultrasearch/admin
    sqlplus "sys/SYS_PASSWORD as sysdba"
    SQL> @wk0config.sql WKSYSPW JDBC_CONNSTR LAUNCH_ANYWHERE ""
    
    

    Where:

    WKSYSPW is the password of the WKSYS schema that you obtained at the beginning of this procedure.

    JDBC_CONNSTR is the JDBC connection string host:port:SID, for example: myhost:1521:testdb.

    LAUNCH_ANYWHERE is TRUE if the Metadata Repository is in Real Application Cluster mode, otherwise FALSE. For this procedure, you should set it to FALSE.

Task 5: Change the Global DB Name for the New Metadata Repository

In this task, you change the global db name of the new Metadata Repository to a new, unique name so you can register it with OID.

See Also:

You can find more information on changing the global db name in article 137483.1 at http://metalink.oracle.com

Perform all of the steps in this task on the new Metadata Repository host.

  1. Run the following commands to set up the database:

    sqlplus "sys/SYS_PASSWORD as sysdba"
    SQL> alter system switch logfile;
    SQL> alter database backup controlfile to trace resetlogs;
    
    
  2. Check the spfile using SQL*Plus:

    SQL> select value from v$parameter where name='spfile';
    
    
  3. If the previous command returns no rows, you can skip this step.

    If the previous command returns output like the following:

    VALUE
    ----------------------------------
    ?/dbs/spfile@.ora
    
    

    run the following command to create a pfile from the spfile:

    SQL> create pfile='initORACLE_SID.ora' from spfile;
    
    

    Where ORACLE_SID is the SID of the original and new Metadata Repository.

  4. Shut down the new Metadata Repository:

    SQL> shutdown immediate;
    
    

    The database must be shut down with SHUTDOWN NORMAL or SHUTDOWN IMMEDIATE. You should not use SHUTDOWN ABORT.

  5. Rename the spfile so the pfile will be used when the database instance is restarted:

    cd ORACLE_HOME/dbs
    mv spfileORACLE_SID.ora spfileORACLE_SID.ora.save
    
    
  6. Edit the following file:

    ORACLE_HOME/dbs/initORACLE_SID.ora
    
    

    Update the db_name to the new db name (the first portion of the new global db name). For example, if the new global db name is asdb1.myco.com, the value of db_name should be asdb1. Note that this is not necessarily (nor likely) the same value as the SID on the new Metadata Repository.

  7. Rename the controls files so they do not exist later when the new ones are created:

    cd ORACLE_HOME/oradata/GDB
    
    

    Where GDB is the first part of the global database name.

    mv control01.ctl control01.ctl.old
    mv control02.ctl control02.ctl.old
    mv control03.ctl control03.ctl.old
    
    
  8. Change to the trace file directory:

    cd ORACLE_HOME/admin/GDB/udump
    
    

    Note that the above is the default location for the trace file directory. This location can be overridden by the user_dump_dest parameter in initORACLE_SID.ora or spfileORACLE_SID.ora.

  9. Locate the trace file; it has a name of the form ora_NNNN.trc, where NNNN is a number. Choose the trace file with the most recent modification date.

  10. Copy the contents of the trace file, starting from the line with "STARTUP NOMOUNT" down to the end of the file, into a new file named BACKUP_DIR/ccf.sql.

  11. Edit BACKUP_DIR/ccf.sql as follows (an example of ccf.sql after performing the edits in this step is shown in Example 8-1.)

    1. Update the following line with the new global db name and change "REUSE" to "SET":

      Before modification:

      CREATE CONTROLFILE REUSE DATABASE "OLD_GLOBAL_DB_NAME" RESETLOGS ...
      
      

      After modification:

      CREATE CONTROLFILE SET DATABASE "NEW_GLOBAL_DB_NAME" RESETLOGS ...
      
      
    2. Remove the following line:

      # STANDBY LOGFILE
      
      
    3. Comment out the following lines with "REM", as shown:

      REM RECOVER DATABASE USING BACKUP CONTROLFILE
      REM VARIABLE RECNO NUMBER;
      REM EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE
      AUTOBACKUP','ON');
      REM VARIABLE RECNO NUMBER;
      REM EXECUTE :RECNO := 
      SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILEAUTOBACKUP FORMAT FOR 
      DEVICE TYPE','DISK TO BACKUP_DIR/db_files/%F');
      
      
    4. Change all comment symbols (#) to "REM".

    5. Make sure the last uncommented command in the file is:

      ALTER DATABASE OPEN RESETLOGS
      

    Example 8-1 Example ccf.sql File after Edits

    STARTUP NOMOUNT
    CREATE CONTROLFILE set DATABASE "<NEW DATABASE>" RESETLOGS ARCHIVELOG
       MAXLOGFILES 50
       MAXLOGMEMBERS 5
       MAXDATAFILES 100
       MAXINSTANCES 1
       MAXLOGHISTORY 226
    LOGFILE
     GROUP 1 '/private1/inst/oradata/asdb/redo01.log'  SIZE 50M,
     GROUP 2 '/private1/inst/oradata/asdb/redo02.log'  SIZE 50M,
     GROUP 3 '/private1/inst/oradata/asdb/redo03.log'  SIZE 50M
    DATAFILE
     '/private1/inst/oradata/asdb/system01.dbf',
     '/private1/inst/oradata/asdb/undotbs01.dbf',
     '/private1/inst/oradata/asdb/drsys01.dbf',
     '/private1/inst/oradata/asdb/dcm.dbf',
     '/private1/inst/oradata/asdb/portal.dbf',
     '/private1/inst/oradata/asdb/ptldoc.dbf',
     '/private1/inst/oradata/asdb/ptlidx.dbf',
     '/private1/inst/oradata/asdb/ptllog.dbf',
     '/private1/inst/oradata/asdb/oca.dbf',
     '/private1/inst/oradata/asdb/discopltc1.dbf',
     '/private1/inst/oradata/asdb/discopltm1.dbf',
     '/private1/inst/oradata/asdb/oss_sys01.dbf',
     '/private1/inst/oradata/asdb/wcrsys01.dbf',
     '/private1/inst/oradata/asdb/uddisys01.dbf',
     '/private1/inst/oradata/asdb/ip_dt.dbf',
     '/private1/inst/oradata/asdb/ip_rt.dbf',
     '/private1/inst/oradata/asdb/ip_idx.dbf',
     '/private1/inst/oradata/asdb/ip_lob.dbf',
     '/private1/inst/oradata/asdb/attrs1_oid.dbf',
     '/private1/inst/oradata/asdb/battrs1_oid.dbf',
     '/private1/inst/oradata/asdb/gcats1_oid.dbf',
     '/private1/inst/oradata/asdb/gdefault1_oid.dbf',
     '/private1/inst/oradata/asdb/svrmg1_oid.dbf',
     '/private1/inst/oradata/asdb/ias_meta01.dbf'
    CHARACTER SET WE8MSWIN1252
    ;
    REM Configure RMAN configuration record 1
    REM VARIABLE RECNO NUMBER;
    REM EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE
    AUTOBACKUP','ON');
    REM Configure RMAN configuration record 2
    REM VARIABLE RECNO NUMBER;
    REM EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP
    FORMAT FOR DEVICE TYPE','DISK TO /private1/inst/backup_dir/db_files/%F');
    REM Recovery is required if any of the datafiles are restored backups,
    REM or if the last shutdown was not normal or immediate.
    REM RECOVER DATABASE USING BACKUP CONTROLFILE
    REM Database can now be opened zeroing the online logs.
    ALTER DATABASE OPEN RESETLOGS;
    REM No tempfile entries found to add.
    
    
  12. Run the ccf.sql script:

    SQL> @BACKUP_DIR/ccf.sql
    
    
  13. Change the global db name in the database:

    SQL> alter database rename global_name to NEW_GLOBAL_DB_NAME;
    
    
  14. Update the service name and the global db name to the new global db name in the following files:

    ORACLE_HOME/network/admin/tnsnames.ora
    ORACLE_HOME/network/admin/listener.ora
    
    

Note that you should not change the SID.

Task 6: Register the New Metadata Repository with OID

In this task, you register the new Metadata Repository with the same OID used by the original Metadata Repository. To do this, you run Oracle Application Server Repository Creation Assistant (OracleAS RepCA), a wizard that guides you through the registration.


Note:

OracleAS RepCA is available on the "OracleAS RepCA and Utilities" CD-ROM.


To register the new Metadata Repository with Oracle Internet Directory, start up OracleAS RepCA on the host where the new Metadata Repository is installed:

runRepca -OH ORACLE_HOME -REGISTER

Where ORACLE_HOME is the new Metadata Repository Oracle home.

The wizard will guide you through the process.

See Also:

Oracle Application Server 10g Installation Guide for more information on registering the OracleAS Metadata Repository with Oracle Internet Directory

Task 7: Change Middle-Tier Instances to the New Metadata Repository

On each middle-tier instance you want to change to the new Metadata Repository, run the Change Metadata Repository wizard and restart the instance:

  1. On Application Server Control, navigate to the Instance Home Page for the middle-tier instance.

  2. Make sure all components except Management are down. If not, click the Stop All button to stop them. Note that this will not stop Management.

  3. Click Infrastructure.

  4. On the Infrastructure Page, in the Metadata Repository section, click Change.

  5. Follow the steps in the wizard for supplying the new Metadata Repository information.

  6. When the wizard is finished, navigate to the Instance Home Page and start your instance by clicking Start All.


Go to previous page Go to next page
Oracle
Copyright © 2002, 2003 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index