JohnDanter2
VIP Member
Hi all
We have recently upgraded from 9.0 to 9.2 and I have noticed we have made out sever names too long to correctly stamp JOBN.
We have 2 Ent servers and they have now been called ABCDEFGHI1 and ABCDEFGHI2 for example.
The issue is any time one of these ENT servers stamps the audit field JOBN of any DB table (which is 10 long) it says ABCDEFGHI and we dont' know if the code ran on server 1 or 2. (this can be critical to fault diagnosis)
There is Oracle docs saying if you are going to name your servers up to 15 long (MKEY) then thats fine but make the 1st 10 chars uniqiue. For JOBN to work
So my question is, how easy to change these names and what it required? Is it something we can slide into out next planned outage for example?
Thanks
John
We have recently upgraded from 9.0 to 9.2 and I have noticed we have made out sever names too long to correctly stamp JOBN.
We have 2 Ent servers and they have now been called ABCDEFGHI1 and ABCDEFGHI2 for example.
The issue is any time one of these ENT servers stamps the audit field JOBN of any DB table (which is 10 long) it says ABCDEFGHI and we dont' know if the code ran on server 1 or 2. (this can be critical to fault diagnosis)
There is Oracle docs saying if you are going to name your servers up to 15 long (MKEY) then thats fine but make the 1st 10 chars uniqiue. For JOBN to work
So my question is, how easy to change these names and what it required? Is it something we can slide into out next planned outage for example?
Thanks
John