Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Dynamics V3 to V4 Upgrade AOS won't start

Posted on 2011-10-06
4
Medium Priority
?
411 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:croitc
  • 2
  • 2
4 Comments
 
LVL 6

Assisted Solution

by:Francis Omoruto
Francis Omoruto earned 1500 total points
ID: 36945840
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.
http://www.scribd.com/doc/6557901/Oracle-9i-Security-Network-Integration


More later...
0
 

Author Comment

by:croitc
ID: 36978424
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
0
 
LVL 6

Accepted Solution

by:
Francis Omoruto earned 1500 total points
ID: 36979003
I hope this article can help:

http://www.oracle-base.com/articles/misc/OsAuthentication.php

Also

http://www.dba-oracle.com/t_windows_external_user_authentication.htm

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

The first article give a little more than the second.
0
 

Author Closing Comment

by:croitc
ID: 36984963
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
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to recover a database from a user managed backup
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

564 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