Friday, September 20, 2013

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

Wednesday, September 18, 2013

Can't load AMD 64-bit .dll on a IA 32-bit platform


While trying to start node manager on a 64 bit machine you are getting the following error message

Caused by: java.lang.UnsatisfiedLinkError: C:\Oracle\SOA\wlserver_10.3\server\na
tive\win\x64\nodemanager.dll: Can't load AMD 64-bit .dll on a IA 32-bit platform




In order to resolve this issue

Create a file nodemanager.properties in %WL_HOME%\common\nodemanager location

Add following lines in the property file

NativeVersionEnabled=false

this command will force node manager not to use .DLL files

Start up now