We run Axapta (Dynamics AX) on Oracle 184.108.40.206 on IBM AIX 5.3 and are trying to upgrade from AX V3 to AX V4. We have got to the point where we attempt to start the AOS but the service will not start. The event viewer shows the following:
Object Server 05: Fatal SQL condition during login. Error message: "[Microsoft Dynamics] Unknown error situation. The OCI layer returned 1009."
Object Server 05: SQL diagnostics: [Microsoft Dynamics] Unknown error situation. The OCI layer returned 1009., Connect information was: Username = , Service = [AX4.CRONOS.COM]
We have the user which is associated with the AOS service set up as an 'external' user in Oracle and have granted it DBA level permissions. However, we are a bit short of expertise in this area so are not totally convinced we have it right
We can see from a trace on the connection between the AOS and database servers that a connection to Oracle is made. The trace then shows 'alter session set current_schema = "BMSSA". This command works fine when executed in SQL
The next thing the trace shows is 'ORA-01009 missing mandatory parameter', which ties in with the event viewer log. We have no idea what a t the Oracle end is causing this message to be output
Our Dynamics partner has no Oracle expertise and both M/S and Oracle support can't/won't help. We have been stuck at this point for weeks now so would greatly appreciate some help