Dynamics V3 to V4 Upgrade AOS won't start

We run Axapta (Dynamics AX) on Oracle 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
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Francis OmorutoInfrastructure and Database Design ConsultantCommented:
I believe the missing mandatory parameter is the UserName that showed up blank in your connect information trace.

I haven't used AX 4, so I'll need some time to check the settings, but this older article might help you troubleshoot too.

More later...
croitcAuthor Commented:
Thanks for the pointer - useful document

On advice, we upgraded the AX V4 Oracle database to, 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
Francis OmorutoInfrastructure and Database Design ConsultantCommented:
I hope this article can help:




My search was: "Oracle 10g Windows Authentication" on both Google and Bing.

The first article give a little more than the second.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
croitcAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.