AIDConfigurationLibraryTasks.xml:298: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

WHile installing AIA 11.1.1.7 i was facing this issue in the deploy application.


[exec] Connecting to t3://localhost:7001 with userid weblogic ...
[exec] Successfully connected to Admin Server 'AdminServer' that belongs to domain 'soa_domain'.
[exec]
[exec] Warning: An insecure protocol was used to connect to the
[exec] server. To ensure on-the-wire security, the SSL port or
[exec] Admin port should be used instead.
[exec]
[exec]
[exec] Location changed to domainRuntime tree. This is a read-only tree with DomainMBean as the root.
[exec] For more help, use help(domainRuntime)
[exec]
[exec] No stack trace available.
[exec] Disconnected from weblogic server: AdminServer
[delete] Deleting: C:\FPack\aia_instances\FPack\tmp\keyFile
[delete] Deleting: C:\FPack\aia_instances\FPack\tmp\propFile
[echo] Begin Validating schema

BUILD FAILED
C:\FPack\Infrastructure\Install\AID\AIAExecuteDriver.xml:223: The following error occurred while executing this line:
C:\FPack\Infrastructure\Install\AID\AIAExecuteDriver.xml:65: The following error occurred while executing this line:
C:\FPack\aia_instances\FPack\tmp\AIDExecuteDP_temp_876603822.xml:11: The following error occurred while executing this line:
C:\FPack\Infrastructure\Install\AID\lib\AIDConfigurationLibraryTasks.xml:298: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

this happened because the AIA schema i have specified user name as sys and it was not having all the privileges

I logged to database manually

Logged in using system as user and grant all privileges to sys