1 Oracle Application Server Repository Creation Assistant Overview and Requirements

1.2.1 New Features in 9.0.4.0.2

Table 1-1 lists the features new to the 9.0.4.0.2 release.

1.2.2 New Features in 9.0.4.0.1

Table 1-2 lists the features new to the 9.0.4.0.1 release:

1.4.1 Database Version

You can install the OracleAS Metadata Repository in the following database versions:

To check the release of your database, query the PRODUCT_COMPONENT_VERSION view:

C:\> sqlplus "sys/password as sysdba"
SQL> select version from product_component_version where product like 'Oracle%9i%'
     or product like 'Oracle%Database%';

password specifies the password for the SYS user.

C:\> sqlplus "sys/password as sysdba"
SQL> select version from sys.patch$;

C:\> sqlplus "sys/password as sysdba"
SQL> select comp_name, version, status from dba_registry
 where comp_id = 'CATPROC';

COMP_NAME                     VERSION     STATUS
----------------------------- ----------- --------
Oracle9i Packages and Types   9.2.0.4.0   Valid

1.4.2 Standard Edition Databases: Notes

If you are using the Standard Edition database, Release 1 (9.0.1.x) or Release 2 (9.2.0.x), you will not be able to use Oracle Internet Directory's multimaster replication feature (because this feature relies on ASR, which is available only on the Enterprise Edition database).

As an alternative, you can use the fan-out replication feature. See the Oracle Internet Directory Administrator's Guide for details.

1.4.3 Patch Needed for Registering with Oracle Internet Directory in SSL Mode

If you plan to register the OracleAS Metadata Repository with Oracle Internet Directory in SSL mode, you need to apply patch 3143899 to the database before doing the registration. You can download this patch from OracleMetaLink (http://metalink.oracle.com).

This patch is required for Oracle9i Release 2 (9.2.0.4) databases only. This patch is already included in Oracle9i Release 2 (9.2.0.5) databases, and is not required for Oracle9i Release 1 (9.0.1.5) databases or Oracle Database 10g.

1.4.4 OracleAS Metadata Repository on Windows XP Not Supported

You can load the OracleAS Metadata Repository on existing databases running on Windows XP. However, as with most Oracle Application Server installations on Windows XP, this is not supported.

For the latest certification updates, check OracleMetaLink (http://metalink.oracle.com).

1.4.5 Initialization Parameters

During installation, the database must have its initialization parameters set to the values specified in Table 1-6.

After installation, you can change the values of most of these parameters to optimize performance, if necessary.

Checking Parameter Values

To check the values of the initialization parameters using SQL*Plus, you can use the show parameters command:

C:\> sqlplus "sys/password as sysdba"
SQL> show parameters parameter_name

password specifies the password for the SYS user.

Alternatively, you can check the values by querying the V$PARAMETER view:

C:\> sqlplus "sys/password as sysdba"
SQL> select name,value from v$parameter;

Changing Parameter Values

The method that you use to change a parameter's value depends on whether the parameter is static or dynamic, and on whether your database uses a parameter file or a server parameter file.

See the Oracle Database Administrator's Guide for your database for details on parameter files, server parameter files, and how to change parameter values.

If your database uses a parameter file, you can change the parameter values using two different methods:

• You can edit the parameter file and restart the database. This method works for both static and dynamic parameters.

• To change the values of dynamic parameters, you can use the alter system command, but the new values persist only until the database is shut down. For example:

  C:\> sqlplus "sys/password as sysdba"
  SQL> alter system set aq_tm_processes=9;
  
  

If your database uses a server parameter file, use the alter system command to change the parameter values. For static parameters, set the scope to spfile. You have to restart the database for the new value to take effect. For dynamic parameters, you can set the scope to spfile, memory, or both. For the values to persist, set the scope to spfile or both. For example:

C:\> sqlplus "sys/password as sysdba"
SQL> alter system set aq_tm_processes=9 scope=both;

1.4.6 Database Options

The database must have the following database options enabled:

prompt> sqlplus "sys/password as sysdba"
SQL> select * from v$option;

PARAMETER                VALUE
---------------------    -----------
OLAP Window Functions    TRUE
Parallel load            TRUE

prompt> sqlplus "sys/password as sysdba"
SQL> select count(*) from dba_objects
     where object_type like 'JAVA%' and
           owner = 'SYS' and status = 'VALID';

prompt> sqlplus "sys/password as sysdba"
SQL> select count(name) from sys.props$
 where name = 'EXPORT_VIEWS_VERSION';

prompt> sqlplus "sys/password as sysdba"
SQL> select count(*) from dba_views
 where owner = 'CTXSYS' and
 view_name = 'CTX_VERSION';

1.4.7 PL/SQL Packages

The database must have the following PL/SQL packages installed:

DBMS_DDL

DBMS_LOCK

DBMS_OUTPUT

DBMS_REPUTIL

DBMS_SQL

DBMS_STATS

DBMS_UTILITY

UTL_FILE

UTL_RAW

To check if a package is installed in the database, query the ALL_OBJECTS view. The following example checks for the DBMS_DDL package:

prompt> sqlplus "sys/password as sysdba"
SQL> select count(object_name) from all_objects
     where object_name like 'DBMS_DDL%' and
       status = 'VALID';

Run the query for each package. Replace DBMS_DDL with the name of the package. The count returned should be greater than 0.

1.4.8 DBMS_LDAP Package

Check that your database contains the DBMS_LDAP package, and that the package is valid. You need to reinstall the package if it is not valid.

1. Check that the version of the DBMS_LDAP package is 2. The following SQL command must return 0.

   C:\> sqlplus "sys/password as sysdba"
   SQL> select dbms_ldap_utl.check_interface_version('2') from dual;
   
   DBMS_LDAP_UTL.CHECK_INTERFACE_VERSION('2')
   ------------------------------------------
                                            0
   
   

   If the command returns a different value, or if it returns an error such as:

   The DBMS_LDAP package supplied with this database doesn't support the
   version 2 interface used by 904 components.
   
   

   you need to reload the package. Go to "Reloading the DBMS_LDAP Package" at the end of this section.

2. Check that the DBMS_LDAP package is valid. The following SQL command must return 9.

   1. Create a file containing the following lines. You can name the file anything you like (for example, test_ldap.sql).

      select count(*) from dba_objects where
      ( object_name = 'DBMS_LDAP' and 
      object_type = 'PACKAGE' and 
      status = 'VALID' and owner = 'SYS' 
      ) OR 
      ( object_name = 'DBMS_LDAP' and 
      object_type = 'PACKAGE BODY' and 
      status = 'VALID' and owner = 'SYS' 
      ) OR 
      ( object_name = 'DBMS_LDAP_UTL' and 
      object_type = 'PACKAGE' and 
      status = 'VALID' and owner = 'SYS' 
      ) OR 
      ( object_name = 'DBMS_LDAP_UTL' and 
      object_type = 'PACKAGE BODY' and 
      status = 'VALID' and owner = 'SYS' 
      ) OR 
      ( object_name = 'DBMS_LDAP' and 
      object_type = 'SYNONYM' and 
      status = 'VALID' and owner = 'PUBLIC' 
      ) OR 
      ( object_name = 'DBMS_LDAP_UTL' and 
      object_type = 'SYNONYM' and 
      status = 'VALID' and owner = 'PUBLIC' 
      ) OR 
      ( object_name = 'DBMS_LDAP_API_FFI' and 
      object_type = 'PACKAGE' and 
      status = 'VALID' and owner = 'SYS' 
      ) OR 
      ( object_name = 'DBMS_LDAP_API_FFI' and 
      object_type = 'PACKAGE BODY' and 
      status = 'VALID' and owner = 'SYS' 
      ) OR 
      ( object_name = 'DBMS_LDAP_API_LIB' and 
      object_type = 'LIBRARY' and 
      status = 'VALID' and owner = 'SYS' 
      );
      
      

   2. Run the file in SQL*Plus. For example, if you named the file test_ldap.sql, the command would look like the following:

      C:\> sqlplus "sys/password as sysdba"
      SQL> @test_ldap.sql
      
        COUNT(*)
      ----------
               9
      
      

      If the command returns a value other than 9, you need to reload the package.

Reloading the DBMS_LDAP Package

1. Check that the following files exist in the ORACLE_HOME\rdbms\admin directory:

   • catldap.sql

   • dbmsldap.sql

   • prvtldap.plb

   • prvtldh.plb

2. Using SQL*Plus, run catldap.sql as the SYS user.

   C:\> cd ORACLE_HOME\rdbms\admin
   C:\> sqlplus "sys/password as sysdba"
   SQL> @catldap.sql
   
   

1.4.9 Knowledge Base Required (Oracle Database 10g Only)

If you plan to install the OracleAS Metadata Repository on Oracle Database 10g, you must manually install Knowledge Base on the database. You can install Knowledge Base from the Oracle Database 10g Companion CD-ROM.

1.4.10 Password File Authentication

The database must be set up to use password file authentication. For more information on password file authentication, see the Oracle Database Administrator's Guide.

Password file authentication is required only for running Oracle Application Server Repository Creation Assistant. It is not required once the metadata repository has been installed.

You can check if the database is set up to use password file authentication, in one of two ways.

• Look up the value of the remote_login_passwordfile initialization parameter by running the following command in SQL*Plus:

  C:\> sqlplus "sys/password as sysdba"
  SQL> show parameters remote_login_passwordfile
  NAME                            TYPE       VALUE
  ------------------------------- ---------- ------------
  remote_login_passwordfile       string     EXCLUSIVE
  
  

  The value of the remote_login_passwordfile initialization parameter must be either EXCLUSIVE or SHARED. If the parameter has a different value or if it is not defined, the database is not set up for password file authentication.

• Try connecting to the database as sysdba through a SQL*Net connection.

  C:\> sqlplus "sys/password@sqlnet_dbname as sysdba"
  
  

  sqlnet_dbname denotes the entry for the database in the tnsnames.ora file. If the database is not set up for password authentication, you will not be able to connect.

  If you are sure the database is set up for password file authentication, but you get an ORA-01017 error, "Invalid username/password; logon denied", a possible cause is that you changed the SYS password when setting up the password file (the value specified in the password parameter actually sets the password for the SYS user). If this is the case, you just need to change the SYS password to something that you can remember.

  You can still log in as SYS if you have the sysdba OS privilege. For the password, you can specify anything. The sysdba OS privilege overrides the password.

  C:\> sqlplus "sys/badPassword as sysdba"
  SQL> alter user sys identified by newPassword;
  SQL> exit
  
  

  Now when you connect to the database with "sys/newPassword@sqlnet_dbname as sysdba", it should work.

To set up a database for password file authentication:

1. Create a password file using the orapwd command (all on one line).

   C:\> cd ORACLE_HOME\bin
   C:\> orapwd file=fullpath_to_pwfile password=password entries=maxUsers
   
   

   Values you need to provide:

   fullpath_to_pwfile - Enter the full path to the file where the password information will be written. The filename must be PWDsid.ora. Typically, the password file is stored in the ORACLE_HOME\database directory.

   password - Set the password for the SYS user.

   
   

   Note: The value that you specify for password parameter sets the password for the SYS user. If you specify a different value from the current SYS password, you are changing the SYS password.

   
   

   maxUsers - Specify the maximum number of users that the file can contain.

   The following example sets the password file for a database whose name is "mydb":

   C:\> cd oracle\ora92\bin
   C:\oracle\ora92\bin> orapwd
       file=C:\oracle\ora92\database\PWDmydb.ora
       password=topsecret entries=9
   
   

2. Set the remote_login_passwordfile initialization parameter to EXCLUSIVE. You can set it to SHARED if you want to use the same password file for multiple databases. If you have a Real Application Clusters database, you must set the parameter to EXCLUSIVE.

3. Restart the database.

1.4.11 Schemas and Tablespaces

Oracle Application Server Repository Creation Assistant installs the schemas and tablespaces listed in Table 1-11 in your existing database. Ensure that the database does not contain schemas and tablespaces of the same name.

C:\> sqlplus "sys/password as sysdba"
SQL> select username from all_users;

C:\> sqlplus "sys/password as sysdba"
SQL> select name from v$tablespace;

1.4.12 Registration with Oracle Internet Directory

Ensure that the existing database is not already registered with Oracle Internet Directory. You cannot register a database that is already registered with Oracle Internet Directory.

To check if a database is already registered with Oracle Internet Directory, you have to look in Oracle Internet Directory:

1. Connect to Oracle Internet Directory using Oracle Directory Manager.

   1. Start up Oracle Directory Manager.

      Select Start / Programs / Oracle - OracleHome / Integrated Management Tools / Oracle Directory Manager.

   2. In the Connect screen, enter the connect information. Log in as the Oracle Internet Directory superuser (cn=orcladmin).

2. Check to see if your database is registered with Oracle Internet Directory. Expand these entries:

   Expand "Entry Management".

   Expand "cn=OracleContext".

   If your database is registered with Oracle Internet Directory, you would see an entry called "cn=your_database_name".

   To remove the registration, see step 2 in Section 4.1, "Cleaning Up a Failed Registration or Deregistering a Metadata Repository".

3. Check to see if your database has a metadata repository that is registered with Oracle Internet Directory. Expand these entries:

   Expand "Entry Management".

   Expand "cn=OracleContext".

   Expand "cn=Products".

   Expand "cn=IAS".

   Expand "cn=IAS Infrastructure Databases".

   If your database has a metadata repository that is registered with Oracle Internet Directory, you would see an entry called "orclReferenceName=your_database_name".

   To remove the registration, see step 3 in Section 4.1, "Cleaning Up a Failed Registration or Deregistering a Metadata Repository".