RE: oracle-l Digest V13 #15
Date: Fri, 22 Jan 2016 14:30:06 +0000
Message-ID: <DM2PR09MB05440BE0DA578C9F791F47F189C40_at_DM2PR09MB0544.namprd09.prod.outlook.com>
Hello all. I've been on this listserver for years and have learned much from the expertise here. I'm a quiet member, mostly reading and learning. Today I have a question that I'm merely gathering information on for my management.
For budget reasons they are considering dropping Oracle Maintenance at renewal time. As this means also dropping Oracle Support, I'm directed to investigate third-party Oracle Support providers, such as Rimini Street. This comes with the realization that MOS, patches, security updates ... all those things are no longer accessible. I'm still not sure how the third-party support value works into what I'll need, but in the end I can provide the facts and this is a business decision. I have many reasons to maintain MOS and its benefits, but the overriding (and overwhelming) factor of budget is the driving force.
Does anyone have experience with third-party support vendors, or additional information on what will no longer be accessible without maintenance?
Sherrie Kubis
Sr. Oracle DBA
Information Technology Bureau
Southwest Florida Water Management District 2379 Broad Street
Brooksville, FL 34604-6899
352.796.7211 x4033
sherrie.kubis_at_swfwmd.state.fl.us
Please take a moment to answer a few questions and let us how we’re doing.
IMPORTANT NOTICE
E-mails made or received in conjunction with the official business of the District are public records. All e-mails sent to and from this address are automatically archived. For more information regarding the State of Florida public records laws, please visit www.myflorida.com.
-----Original Message-----
From: FreeLists Mailing List Manager [mailto:ecartis_at_freelists.org]
Sent: Thursday, January 21, 2016 1:05 AM
To: oracle-l digest users <oracle-l_at_freelists.org>
Subject: oracle-l Digest V13 #15
oracle-l Digest Wed, 20 Jan 2016 Volume: 13 Issue: 015
In This Issue:
RE: SQL Developer connections greyed out RE: SQL Developer connections greyed out Jan 2016 CPU ORA-01483 + ORA-03106 + SQL*Net more data from client Partition split Oracle environment privileges Upgrading Oracle cluster 11gR2 on Solaris ----------------------------------------------------------------------
From: John Hallas <John.Hallas_at_morrisonsplc.co.uk>
Date: Wed, 20 Jan 2016 07:50:38 +0000
Subject: RE: SQL Developer connections greyed out
N¬ŠÇ^~)âµérjx¬²çš²Ê‰«^w…©î¦
Úuæ¬Áæ«zº%–)à¢ëZãýÿÛý´¶‹¬z»Ûa{&«z·©¢»bžjwHq©ìyè›+•ÿÀ–Z›'(žwœ¶*'²ØZ¶ÈhÁ«•§$jwg¢¹š–¯zØ^r‰hººk¢—«·*ž‡(–‹«ý8^}ì-…«Zè+{'¢ëly颯zÇ¥yË^vØ^‚·²¢›b¢Ó…«ajÉèµ·žÚ'y¼¦zŠè¶«ºÇ«³ò!j÷«zǶ ìžv‹¢w¬¶‰èr‰hº¶§vØ^ɪÞm§$jÉè®f¥þÈhÂ)ànVœ’WµêâžÈ¶+'¢Ö›Š¬²ç›ºØŠÇ^~)âµéri÷š¶êÞ&ˆgº&ü—Ÿ})¢¶æj)m£øÞ}ÿÝþÉ¢¶è§%{÷(›ôžžßõô–§¹ªòÛMzÛùé:ÿk ëjjm¢à™¨¥ýÊ&üš!œv¥•«sú+iÉ^þ_ß祊ËlþŠàJæãyËÿDOÒ@°Þ½éh¥êÜ¢yÞrبžÈ+{'¢ëQŠmüÿþf¬²é¢ž
az·ÿÿûž+,¹è^æ§vz-iöýø§êé…éè™éèŸ^ë(™ê'z¬Šv½êíz{eÊǶœ¢yÞrبÊ%¢»hjø¬‰¹^‚·²Š{ayÊ'ç-Š‰é®Š^®Øž³ó«‰ú'º˜+i×ÿ¶Â‹¥u·°z*Ýÿÿۺاµê޲اƒð j)ÿjË.š)à‰ûajßÿþËayƬ{*.‹¥u·¬k(§‚Ø^r‰çyËb¢w(–ŠÈJǶˆ+{/Ó…éðyƧ~(.ê.¶Ø^†Œ?¢¶
-¶«{ñk¢oÀÜ–y»-z¿æj)m£ö°~¶¦¦Ú'þ šŠ_Ü¢oÒz{ÿNç¬u¬ÿ%©îj¼µ÷ý´×®ÿãÓÌNÉ¢ÿ©ejÏ梺ⲉì¦Wÿrî“ùšŠ[hüš!ŸñÚ–V¬þj+®+(žÊes÷(þéÿ ÏÉy÷Òš+aþŠÚrWÿ—÷ëyéb²Ûÿ¢¸ÿ™¨¥¶è§%{ùÿ~·ž–+-³ú+ƒô®n7œ·ô^ý$
ëÞ–Š^Ê'ç-Š‰ì‚·²yÚ.´‹ÂØb±«ªí‰öœ¶‡Úžê`§^¢wŠgÿ"جŽë-¶œ¢Z+~Ší…ç(žwœ¶*'ýŠ.q©Ü…©àz+ÿF(!·÷%‰Éÿþšè¥êí‰ë(žØ^r‰çyËb¢v§vØ^ÉbrKazX¶W›ºÛhžw±¶Úÿ
‰çyËb¢p¨–ŠÿüéÓ¹ïÉj}}ÿm5é«|ÿm5ëÏ÷ä£ú+iÉ^þ_ß祊ËlþŠàþf¢–Úÿ¢¶œ•ïåýúÞzX¬¶Ïè®Ò¹¸ÞrßÒ@°Þ½éh¥êÜ¢yÞrبžÈ+{'¢ëBjv§ÉºÊ¥¦g®×«²Ö§wrr‰çyËb¢{"$
ëÞ–Š^ªiyªàìžv‹nëZçî–\Ÿºw-Š‰âž!j÷¬yéÜ¢ižžÛajØŠËhvŒ"¶ayÊ%¢êÛz)à±ëÿ
‰çyË>º)z»bzÏÛºÛajØZ²z-m观IèÂ)à—+µ©ÝÉël¢g£ºËZ¦—š« ìžv‹nëf¢ËZéèµgšëz)àjZ-¡û¬z»0ŠØm†+)®†åzièÁ©ÝŠØ¬j«ž²Ø¨œŒ(ºWeŠG¡·šnW¡©ìÁêÿ‰ú'—'è®l¨Â{¶+iËb¢É¢ðÃã…ÖÚÿ
+všÞ²ÏÜ¢oá¶Úÿÿü0Ãøáu¶ÿŠݦ·¬³÷(›ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿZc(®¸¬¢t®¥êæj¹¶Ãår++z¬µêÞv)Äž ZÜ"¶î™·«ßŸ=ãßÓ…êÞ‚+-z·¡÷âq궜¢jZŸ(¬²+nj×jÑšŠrÚïÁ§_¢·ÿYë-bŠä²«x÷ì2ÿN¬zf¢•©Ýj|š¶Öœ†g§¶Æ«z)ízw^uú+¶šuÚ޲ǞþÏèž\šÙšÉ·œ¢wâué퉩ÿ!ü¨¹ªÞž‹m…觵éÝyÚÞr*bz{ÿ¦Wš±è§~Šæ¶¬zw^¼«z™rŠx-¢Ø^zf¢–ØZ·*.…«ÞçŠ÷Šw«®ŠÚÛazw^²ÚèÊØ^zf¢—òÊ‹šéè¶Ø^Š{^×ç"¦'§·ü¨ºk¬¶z-ºÇÿv+–‹ýÊ)ÊŠëz\¨žØ^zf¢–Šâ¶Æµ§!™éí²)ÚŸ,ËôáŠÇ¦j)]¡ë'¢×(žËb¶ë^iÊ'¶¶œ¶)ð®+bž è®Ø^¦êé¢Ç¬¡ûax¶°¡ó뢗«·/ÌŠÇ–V§z‹¬>º/ŠÈ¨žÏÀrÝ}óßκ´jwZÔÞ®kШ؊‰ì¡óîÈZ±ïÚ²f²mæ¦zw^uúèšØ¦zÚ-ŠgÿjšeÊÚŸ'(žÚÚrÛajÜz{^®)í£ôáyË«éí½ê슉è~‹«JÖ§uªÝMê汩Ý
‰ÝŠØ¨žÊ>êÜ…«ŠÆ¯j)ZnWš·øm¶Ÿÿÿ
0þj+®+(žÏÜ£û¤þ
¢%¶.‚…«Þµ©žË^¦Ëhz{.ëay隊V§v+ljÛZržžÛëâ®ëÿ~·žÿ œjyè¶ š©íyëaŠÊ+iǦ֧ʷ¬¦‰ì‰¸¥ŠÜÿjwb¶+-…êÞ²š'²&â–+r¡úÞr*bz{l¶‡®¼¨ºÛaz*èÂ{â®ë…ç$³ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿõ¦2ŠëŠÊ'Jê^®f«‘ël>W"²· ŠË^çbœIà•©ÝÂ+ažé›z½ùóÞ=ý8^è"²×«yÚ~'¡ûayÊ&¥©òŠË"¶æyÖ¨§-©ÞüÚuú+wõž²Ö(®K!Š·~Ã/ôáŠÇ¦j)Z֧ɫmiÈfz{lj·¢ž×§uç_¢»ay§]ë,yïìþ‰åÉ©Ý™¬›yÊ'~'^žØš—òÊ‹šéè¶Ø^Š{^×ç"¦'§·úey«Šwè®kazǧuêÛÊ·©—(§‚Ú-…ç¦j)m…«r¢èZ½êÞqè¯yاzºè©Ý¶§uë-®Œ…ç¦j)ÿ!ü¨¹ªÞž‹m…觵éÝyÚÞr*bz{ÿÊ‹¦ºËg¢Û¬{÷b±Éh±ïÜ¢œ¨®·¥Ê‰í…ç¦j)h®+ljÛZržžÛ"©òÁ¬ÿN¬zf¢•Ú²z-r‰ì¶+nµæœ¢{kiËbŸ
â¶)à~Ší…ên®š,zʶ‹k
>º)z»rüȬqéejw¨ºÃë¢ø¬Š‰ìü -×ß=üë«JÖ§uªÝMê汩Ý
‰ÝŠØ¨žÊ>êÜ…«ý«&k&Þjg§uç_®‰Šg¢Ø¦{ö©¦\¡©òr‰í§-¶Á秵êâžÚÿNœººÞžÛޮȨž‡èº´jwZÔÞ®kШ؊‰ì¡óîÈZ±è¬jö¢•¦åy«ÿ†ÛiÿÿðÃ梺ⲉìýÊÿºOà±Ê)[a¢è!ÁèZ½ëZ‘éìµêl¶‡§²êÞ¶ž™¨¥jwb¶Æµ§!™éí±ªÞ¾*î³÷ëyïðyƧž‹`¹ªÚž×ž¶¬¢¶œqêmj|«zÊhžÈ›ŠXËö§v+b²Ø^ë)¢{"n)b·*ç"¦'§¶ËhqªëÊ‹¶¢®Œ'¾*î±È^rKÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿZc(®¸¬¢t®¥êæj¹¶Ãår++z¬µêÞv)Äž ZÜ"¶î™·«ßŸ=ãßÓ…êÞ‚+-z·¡÷âq궜¢jZŸ(¬²+nj×jÑšŠrÚïÁ§_¢·ÿYë-bŠä²«x÷ì2ÿN¬zf¢•©Ýj|š¶Öœ†g§¶Æ«z)ízw^uú+¶šuÚ޲ǞþÏèž\šÙšÉ·œ¢wâué퉩ÿ!ü¨¹ªÞž‹m…觵éÝyÚÞr*bz{ÿ¦Wš±è§~Šæ¶¬zw^¼«z™rŠx-¢Ø^zf¢–ØZ·*.…«ÞçŠ÷Šw«®ŠÚÛazw^²ÚèÊØ^zf¢—òÊ‹šéè¶Ø^Š{^×ç"¦'§·ü¨ºk¬¶z-ºÇÿv+–‹ýÊ)ÊŠëz\¨žØ^zf¢–Šâ¶Æµ§!™éí²)ÚŸ,ËôáŠÇ¦j)]¡ë'¢×(žËb¶ë^iÊ'¶¶œ¶)ð®+bž è®Ø^¦êé¢Ç¬¡ûax¶°¡ó뢗«·/ÌŠÇ–V§z‹¬>º/ŠÈ¨žÏÀrÝ}óßκ´jwZÔÞ®kШ؊‰ì¡óîÈZ±ïÚ²f²mæ¦zw^uúèšØ¦zÚ-ŠgÿjšeÊÚŸ'(žÚÚrÛajÜz{^®)í£ôáyË«éí½ê슉è~‹«JÖ§uªÝMê汩Ý
‰ÝŠØ¨žÊ>êÜ…«ŠÆ¯j)ZnWš·øm¶Ÿÿÿ
0þj+®+(žÏÜ£û¤þ
¢%¶.‚…«Þµ©žË^¦Ëhz{.ëay隊V§v+ljÛZržžÛëâ®ëÿ~·žÿ œjyè¶ š©íyëaŠÊ+iǦ֧ʷ¬¦‰ì‰¸¥ŠÜÿjwb¶+-…êÞ²š'²&â–+r¡úÞr*bz{l¶‡®¼¨ºÛaz*èÂ{â®ë…ç$³ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿõ¦2ŠëŠÊ'Jê^®f«‘ël>W"²· ŠË^çbœIà•©ÝÂ+ažé›z½ùóÞ=ý8^è"²×«yÚ~'¡ûayÊ&¥©òŠË"¶æyÖ¨§-©ÞüÚuú+wõž²Ö(®K!Š·~Ã/ôáŠÇ¦j)Z֧ɫmiÈfz{lj·¢ž×§uç_¢»ay§]ë,yïìþ‰åÉ©Ý™¬›yÊ'~'^žØš—òÊ‹šéè¶Ø^Š{^×ç"¦'§·úey«Šwè®kazǧuêÛÊ·©—(§‚Ú-…ç¦j)m…«r¢èZ½êÞqè¯yاzºè©Ý¶§uë-®Œ…ç¦j)ÿ!ü¨¹ªÞž‹m…觵éÝyÚÞr*bz{ÿÊ‹¦ºËg¢Û¬{÷b±Éh±ïÜ¢œ¨®·¥Ê‰í…ç¦j)h®+ljÛZržžÛ"©òÁ¬ÿN¬zf¢•Ú²z-r‰ì¶+nµæœ¢{kiËbŸ
â¶)à~Ší…ên®š,zʶ‹k
>º)z»rüȬqéejw¨ºÃë¢ø¬Š‰ìü -×ß=üë«JÖ§uªÝMêæ±©Ý ‰ÝŠØ¨žÊ>êÜ…«ý«&k&Þjg§uç_®‰Šg¢Ø¦{ö©¦\¡©òr‰í§-¶Á秵êâžÚÿNœººÞžÛޮȨž‡èº´jwZÔÞ®kШ؊‰ì¡óîÈZ±è¬jö¢•¦åy«ÿ†ÛiÿÿðÃ梺ⲉìýÊÿºOà±Ê)[a¢è!ÁèZ½ëZ‘éìµêl¶‡§²êÞ¶ž™¨¥jwb¶Æµ§!™éí±ªÞ¾*î³÷ëyïðyƧž‹`¹ªÚž×ž¶¬¢¶œqêmj|«zÊhžÈ›ŠXËö§v+b²Ø^ë)¢{"n)b·*ç"¦'§¶ËhqªëÊ‹¶¢®Œ'¾*î±È^rKÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ
Date: Wed, 20 Jan 2016 02:44:06 -0800 (PST) From: Jeff Smith <jeff.d.smith_at_oracle.com> Subject: RE: SQL Developer connections greyed out
What version did you upgrade from?
Â
From: John Hallas [mailto:John.Hallas_at_morrisonsplc.co.uk]
Sent: Wednesday, January 20, 2016 2:51 AM
To: Jeff Smith; awframpton_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: RE: SQL Developer connections greyed out
Â
This is definitely an issue associated with an upgrade as we are rolling out a 4.1.2.20 to users and they are reporting it and I can see it myself.
All of my connections that show as black and normal have the colour property of no colour. The few that are greyed out seem to have selected the grey option. That has not been done by me or other users.
I have reset the greyed out ones to no colour and they are back as normal, showing black lettering.
Â
It is not a big issue but it is definitely a feature
Â
John
Â
Â
From: Jeff Smith [mailto:jeff.d.smith_at_oracle.com]
Sent: 19 January 2016 23:56
To: HYPERLINK "mailto:awframpton_at_gmail.com"awframpton_at_gmail.com; John Hallas
Cc: HYPERLINK "mailto:oracle-l_at_freelists.org"oracle-l_at_freelists.org
Subject: RE: SQL Developer connections greyed out
Â
Right, I’m assuming there’s an issue here and not a fat-finger phenomenon where someone has inadvertently set the connection color to a visible grey in the connection properties.
Â
Or if on upgrade, that would be weird…but interesting. Again, assuming if that’s the case you would be saying the connection color IS set to grey. Then we can figure out the how/why it got there.
Â
From: Andy Webster [mailto:awframpton_at_gmail.com] Sent: Tuesday, January 19, 2016 6:49 PM To: HYPERLINK "mailto:John.Hallas_at_morrisonsplc.co.uk"John.Hallas_at_morrisonsplc.co.uk Cc: Jeff Smith; HYPERLINK "mailto:oracle-l_at_freelists.org"oracle-l_at_freelists.org Subject: Re: SQL Developer connections greyed out
Â
I saw this as an artifact of an upgrade one time. It is just the color for the connection. You can change it. Right-click->properties on the connection and then click the little button next to "Connection Color."
Â
On Tue, Jan 19, 2016 at 8:50 AM, John Hallas <HYPERLINK "mailto:John.Hallas_at_morrisonsplc.co.uk" \nJohn.Hallas_at_morrisonsplc.co.uk> wrote:
Yes, I can change properties to the greyed-out ones as well as the ‘available’ ones.
There seems to be no obvious difference between the two types or reason why some are greyed-out and others are not
Â
John
Â
From: Jeff Smith [mailto:HYPERLINK "mailto:jeff.d.smith_at_oracle.com" \njeff.d.smith_at_oracle.com] Sent: 19 January 2016 13:59
To: John Hallas; HYPERLINK "mailto:oracle-l_at_freelists.org" \noracle-l_at_freelists.org Subject: RE: SQL Developer connections greyed out
Â
Ok, but you didn’t answer my first question. They appear “greyed out†->  If you right click and select properties – are you able to view/change the properties of the connection?
Â
From: John Hallas [mailto:John.Hallas_at_morrisonsplc.co.uk] Sent: Tuesday, January 19, 2016 8:57 AM To: Jeff Smith; HYPERLINK "mailto:oracle-l_at_freelists.org" \noracle-l_at_freelists.org Subject: RE: SQL Developer connections greyed out
Â
Yes fully functioning in that I can connect to a database and run a query – which is about all I ever do. We have many people reporting this though
Version 4.1.2.20
Â
John
Â
Â
Â
From: Jeff Smith [mailto:jeff.d.smith_at_oracle.com]
Sent: 19 January 2016 13:51
To: John Hallas; HYPERLINK "mailto:oracle-l_at_freelists.org" \noracle-l_at_freelists.org
Subject: RE: SQL Developer connections greyed out
Â
Fully functioning – can they also edit the connection properties?
Â
What version of SQL Developer are you and your users using?
Â
From: John Hallas [mailto:John.Hallas_at_morrisonsplc.co.uk] Sent: Tuesday, January 19, 2016 8:35 AM To: HYPERLINK "mailto:oracle-l_at_freelists.org" \noracle-l_at_freelists.org Subject: SQL Developer connections greyed out
Â
Can anybody help me understand why connections in SQL Developer appear greyed out but are fully functioning
I have seen comment that it is to do with the colour being set -   Connect/Properties  - but that has not being knowingly set and yet some just appear as greyed out but most are not
Â
We are seeing a lot of users with this problem now and it is a question I would like to be able to answer, if only for my own satisfaction.
Â
Â
Â
John
Â
HYPERLINK "http://www.jhdba.wordpress.com" \nwww.jhdba.wordpress.com
Â
Â
Â
Wm Morrison Supermarkets Plc is registered in England with number 358949. The registered office of the company is situated at Gain Lane, Bradford, West Yorkshire BD3 7DL. This email and any attachments are intended for the addressee(s) only and may be confidential.
If you are not the intended recipient, please inform the sender by replying to the email that you have received in error and then destroy the email. If you are not the intended recipient, you must not use, disclose, copy or rely on the email or its attachments in any way.
This email does not constitute a contract in writing for the purposes of the Law of Property (Miscellaneous Provisions) Act 1989.
Our Standard Terms and Conditions of Purchase, as may be amended from time to time, apply to any contract that we enter into. The current version of our Standard Terms and Conditions of Purchase is available at: http://www.morrisons.co.uk/gscop
Although we have taken steps to ensure the email and its attachments are virus-free, we cannot guarantee this or accept any responsibility, and it is the responsibility of recipients to carry out their own virus checks.
Wm Morrison Supermarkets Plc is registered in England with number 358949. The registered office of the company is situated at Gain Lane, Bradford, West Yorkshire BD3 7DL. This email and any attachments are intended for the addressee(s) only and may be confidential.
If you are not the intended recipient, please inform the sender by replying to the email that you have received in error and then destroy the email. If you are not the intended recipient, you must not use, disclose, copy or rely on the email or its attachments in any way.
This email does not constitute a contract in writing for the purposes of the Law of Property (Miscellaneous Provisions) Act 1989.
Our Standard Terms and Conditions of Purchase, as may be amended from time to time, apply to any contract that we enter into. The current version of our Standard Terms and Conditions of Purchase is available at: http://www.morrisons.co.uk/gscop
Although we have taken steps to ensure the email and its attachments are virus-free, we cannot guarantee this or accept any responsibility, and it is the responsibility of recipients to carry out their own virus checks.
Wm Morrison Supermarkets Plc is registered in England with number 358949. The registered office of the company is situated at Gain Lane, Bradford, West Yorkshire BD3 7DL. This email and any attachments are intended for the addressee(s) only and may be confidential.
If you are not the intended recipient, please inform the sender by replying to the email that you have received in error and then destroy the email. If you are not the intended recipient, you must not use, disclose, copy or rely on the email or its attachments in any way.
This email does not constitute a contract in writing for the purposes of the Law of Property (Miscellaneous Provisions) Act 1989.
Our Standard Terms and Conditions of Purchase, as may be amended from time to time, apply to any contract that we enter into. The current version of our Standard Terms and Conditions of Purchase is available at: http://www.morrisons.co.uk/gscop
Although we have taken steps to ensure the email and its attachments are virus-free, we cannot guarantee this or accept any responsibility, and it is the responsibility of recipients to carry out their own virus checks.
Â
Wm Morrison Supermarkets Plc is registered in England with number 358949. The registered office of the company is situated at Gain Lane, Bradford, West Yorkshire BD3 7DL. This email and any attachments are intended for the addressee(s) only and may be confidential.
If you are not the intended recipient, please inform the sender by replying to the email that you have received in error and then destroy the email. If you are not the intended recipient, you must not use, disclose, copy or rely on the email or its attachments in any way.
This email does not constitute a contract in writing for the purposes of the Law of Property (Miscellaneous Provisions) Act 1989.
Our Standard Terms and Conditions of Purchase, as may be amended from time to time, apply to any contract that we enter into. The current version of our Standard Terms and Conditions of Purchase is available at: http://www.morrisons.co.uk/gscop
Although we have taken steps to ensure the email and its attachments are virus-free, we cannot guarantee this or accept any responsibility, and it is the responsibility of recipients to carry out their own virus checks.
Date: Wed, 20 Jan 2016 06:16:52 -0600
Subject: Jan 2016 CPU
From: MJ Chicago <emjay.mody_at_gmail.com>
Oracle Critical Patch Update Advisory - January 2016 http://www.oracle.com/technetwork/topics/security/cpujan2016-2367955.html
Date: Wed, 20 Jan 2016 13:52:12 -0600
Subject: ORA-01483 + ORA-03106 + SQL*Net more data from client
From: Chris Stephens <cstephens16_at_gmail.com>
We have a process loading data into an 11.2.0.4 database running on X5-2 via an Oracle application called DRM that consistently fails with ORA-03106. I was showed a demo and an ORA-01483 accompanied the ORA-03106 though I've been told that isn't always present. I ran snapper during the demo and the session of concern was waiting on "SQL*Net more data from client" for the vast majority of the time.
Does anyone have any suggestions on how to troubleshoot this? We are thinking it is a networking issue but unsure how to troubleshoot.
Thanks for any help.
Chris
Date: Wed, 20 Jan 2016 16:29:15 -0500
Subject: Partition split
From: Michael Calisi <oracle455_at_gmail.com>
steps I used to split the partition. The mistake I made was on CH2016Q4, you can see the output from the attach.. My question how can I change that lat partition with the correct date range.
STEPS Taken
ALTER TABLE CORRESPONDENCE_HISTORY
SPLIT PARTITION CHUNSENT at (TO_DATE('2016-04-01 00:00:00','YYYY-MM-DD
HH24:MI:SS'))
INTO
(
partition CH2016Q1,
PARTITION CHUNSENT
);
ALTER TABLE CORRESPONDENCE_HISTORY
SPLIT PARTITION CHUNSENT at (TO_DATE('2016-07-01 00:00:00','YYYY-MM-DD
HH24:MI:SS'))
INTO
(
partition CH2016Q2,
PARTITION CHUNSENT
);
ALTER TABLE CORRESPONDENCE_HISTORY
SPLIT PARTITION CHUNSENT at (TO_DATE('2016-10-01 00:00:00','YYYY-MM-DD
HH24:MI:SS'))
INTO
(
partition CH2016Q3,
PARTITION CHUNSENT
);
ALTER TABLE CORRESPONDENCE_HISTORY
SPLIT PARTITION CHUNSENT at (TO_DATE('2016-11-01 00:00:00','YYYY-MM-DD
HH24:MI:SS'))
INTO
(
partition CH2016Q4,
PARTITION CHUNSENT
);
CH2016Q4 should of been
ALTER TABLE correspondence_history
SPLIT PARTITION CHUNSENT at (TO_DATE('2017-01-01 00:00:00','YYYY-MM-DD
HH24:MI:SS'))
INTO
(
partition ch2016q4,
PARTITION CHUNSENT
);
My question how can I make this change?
From: MJ Mody <emjay.mody_at_gmail.com>
Subject: Oracle environment privileges
Date: Wed, 20 Jan 2016 15:35:30 -0600
Oracle SMEs
My team and I are faced with a unique challenge/opportunity on how to best implement privileges appropriate for DEV, TEST, QA and PROD environments (e.g. Dev = Sandbox, Test = somewhat tightened, QA/Prod = same, etc.).
Reaching out to see if a Best Practice reference or STIG is available for the same.
Thank you in advance.
Best
MJ
Date: Wed, 20 Jan 2016 14:12:23 -0800
Subject: Upgrading Oracle cluster 11gR2 on Solaris
From: Ali Alizadeh <rali.alizadeh_at_gmail.com>
Hello
We are planning to upgrade our oracle cluster 11.2.0.3 using raw device (no
ASM) to oracle GI 12c/ASM.
What will be the best approached to minimize the downtime?
Regards,
Ali
End of oracle-l Digest V13 #15
i0zX+n{+i^ Received on Fri Jan 22 2016 - 15:30:06 CET