Tuesday, July 3, 2012

Oracle AIA installation error : java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection


BUILD FAILED
C:\Oracle\AIAHOME\Infrastructure\Install\AID\AIAExecuteDriver.xml:222: The following error occurred while executing this line:
C:\Oracle\AIAHOME\Infrastructure\Install\AID\AIAExecuteDriver.xml:65: The following error occurred while executing this line:
C:\Oracle\AIAHOME\aia_instances\AIAINST\tmp\AIDExecuteDP_temp_1008901005.xml:50: The following error occurred while executing this line:
C:\Oracle\AIAHOME\Infrastructure\Install\AID\lib\AIDConfigurationLibraryTasks.xml:298: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

Total time: 1 minute 27 seconds
'choice' is not recognized as an internal or external command,
operable program or batch file.


This happens due to less number of DB processes defined on the database. You can run following command to verify number of db processes on the DB.

SQL> show parameter process


NAME                                 TYPE        VALUE
------------------------------------ ----------- -----
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     0
job_queue_processes                 integer     4
log_archive_max_processes        integer     2
processes                                       integer    45

Increase this value to 200 by running following command

SQL> alter system set processes = 200 scope=spfile;

Now again rerun AIA installer.This time you will not get this issue.

No comments:

Post a Comment