Dynamics V3 to V4 Upgrade AOS won't start

Posted on 2011-10-06
Last Modified: 2012-05-12
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
Question by:croitc
    LVL 6

    Assisted Solution

    by:Francis Omoruto
    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...

    Author Comment

    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
    LVL 6

    Accepted Solution

    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.

    Author Closing Comment

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now