Gestion de bases de données

Rc-50004: Fatal: erreur lors de l'exécution d'Adcfgclone.pl DBTier pour RDBMS 64 bits

S'applique à

Oracle Applications Manager - versions 11.5.10.0 à 11.5.10.2 - version 11.5.10 à 11.5.10
Les informations de ce document s'appliquent à toutes les plateformes.
Le problème ne se produit qu'avec un RDBMS 64 bits
Les correctifs 4347152, 4175764 et 4104924 sont déjà appliqués.
***Pertinence vérifiée le 28 mars 2011***

Symptômes

Erreur lors de l'exécution de perl adcfgclone.pl dbTier

---------------------------------------------------------------
                       ADX Database Utility
    ---------------------------------------------------------------
    
    getConnectionUsingAppsJDBCConnector() -->
        APPS_JDBC_URL='null'
        Trying to get connection using SID based connect descriptor
    getConnection() -->
        sDbHost    : <host>
        sDbDomain  : <domain>
        sDbPort    : <port>
        sDbSid     : <sid>
        sDbUser    : <APPS_user>
        Trying to connect using SID...
    getConnectionUsingSID() -->
        JDBC URL: jdbc:oracle:thin:@host:port:sid
        Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    SVR4 Error: 2: No such file or directory
    
        Trying to connect using SID as ServiceName
    getConnectionUsingServiceName() -->      JDBC URL:
    jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx)(PORT=port))(CONNEC_DATA=(SERVICE_NAME=xxx)))
        Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    SVR4 Error: 2: No such file or directory
    
        Trying to connect using SID as ServiceName.DomainName
    getConnectionUsingServiceName() -->        JDBC URL:
    jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx)(PORT=port))(CONNEC_DATA=(SERVICE_NAME=xxx)))
        Exception occurred: java.sql.SQLException: Io exception: Connection
    refused(DESCRIPTION=(TMP=)(VSNNUM=xxx)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
        Connection could not be obtained; returning null
    
    -------------------ADX Database Utility Finished---------------
    
    adcrdb.sh started at date()
    
    The environment settings are as follows ...
    
           ORACLE_HOME : 
            ORACLE_SID : 
              TWO_TASK :
                  PATH :
           LD_LIBRARY_PATH :
       
    Executable : <RDBMS ORACLE_HOME>/bin/sqlplus
    
    The log information will be written to
      <RDBMS ORACLE_HOME>/appsutil/log/CONTEXT_NAME/adcrdb_SID.txt    
    
    Creating the control file for SID_hostname database ...    
    
    SQL*Plus: Release 9.2.0.6.0 - Production on date()
    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    
    ERROR:
    ORA-03113: end-of-file on communication channel     
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ERROR:
    ORA-03113: end-of-file on communication channel       
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    SP2-0640: Not connected
    SP2-0640: Not connected
    SP2-0640: Not connected
    SP2-0640: Not connected
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ERROR:
    ORA-03113: end-of-file on communication channel       
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    SP2-0640: Not connected
    SP2-0641: "EXECUTE" requires connection to server
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ERROR:
    ORA-03113: end-of-file on communication channel       
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    SP2-0640: Not connected
    SP2-0640: Not connected
    SP2-0640: Not connected
    SP2-0640: Not connected
    SP2-0640: Not connected
    exit_code=0    
    Checking for errors ...    
    ORA-03113: end-of-file on communication channel
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ORA-03113: end-of-file on communication channel
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ORA-03113: end-of-file on communication channel
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    ORA-03113: end-of-file on communication channel
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist
    The database has not been successfully created. Shutting down the instance ...
    
    SQL*Plus: Release 9.2.0.6.0 - Production on date()    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.    
    ERROR:
    ORA-03113: end-of-file on communication channel        
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist    
    .end std out.    
    .end err out......
-------------------ADX Database Utility Finished---------------
RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase
StackTrace: 
java.lang.Exception: Control file creation failed
 at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:469)
 at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:314)
 at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:290)
 at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:131)
 at java.lang.reflect.Constructor.newInstance(Native Method)
 at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
 at java.lang.Thread.run(Thread.java:484)

Cause

Dans le fichier de contexte, le paramètre est :
<config_option type="database" oa_var="s_bits">32</config_option>
Il devrait être réglé à <config_option type="database" oa_var="s_bits">64</config_option>

Avec la valeur 32, adlnkoh.sh, appelé par adcfgclone.pl, utilise le fichier config_sol.s. Il devrait utiliser config_sol_64.s

Solution

Pour mettre en œuvre la solution, effectuez l'une des opérations suivantes :

1. Solution à long terme :

Dans le fichier de contexte, le paramètre est :
<config_option type="database" oa_var="s_bits">32</config_option>
Réglez-le à <config_option type="database" oa_var="s_bits">64</config_option>
Refaites le processus de clonage.

2. Contournement :

Sauvegardez config_sol_64.s et config_sol.s
Copiez config_sol_64.s vers config_sol.s
Relancez adcfgclone.pl