Link to home
Start Free TrialLog in
Avatar of croitc
croitc

asked on

Dynamics V3 to V4 Upgrade AOS won't start

We run Axapta (Dynamics AX) on Oracle 9.2.0.5 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."

and then

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
Thanks
SOLUTION
Avatar of Francis Omoruto
Francis Omoruto
Flag of Uganda image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of croitc
croitc

ASKER

Thanks for the pointer - useful document

On advice, we upgraded the AX V4 Oracle database to 10.2.0.5.0, created the 'external' user required to connect from the AOS, set all init.ora and sqlnet.ora parameters to the same as they were when we encountered the problem described above

However, we cannot now even connect to the database from the AOS server via SQL Plus using the 'external' user i.e. the one with the same name as the one that the AX AOS will log in to Windows with. Using a standar Oracle user, we can connect but if we just use '/', no password and enter the relevant Host String, we get 'ORA-0107: invalid username/password; logon denied

Prior to upgrading to 10G we were able to do this so we can't even get as far as the problem described in the original question

Any assistance with this would be most appreciated
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of croitc

ASKER

We managed to get the Oracle external user working, thanks in part to the first of the two links identified above

We have also now overcome the original problem, which we now believe to be due to the fact that we were on Oracle 9 and not 10 (badly advised from the outset)

The AX4 upgrade is now progressing