RE: oracle-l Digest V13 #15

From: Sherrie Kubis <Sherrie.Kubis_at_swfwmd.state.fl.us>
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

Original text of this message