Odd disconnection after 9.2.0.1 upgrade - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: Odd disconnection after 9.2.0.1 upgrade

  1. #11
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Hi Jim,

    I could reproduce it at my place. A possible candidate for BUG i suppose.

    Cheers
    Amar

    Code:
    SQL*Plus: Release 9.2.0.2.0 - Production on Mon Mar 17 16:59:14 2003
    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    
    Enter user-name: sys as sysdba
    Enter password:
    
    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production
    With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.2.0 - Production
    
    SQL> show sga
    
    Total System Global Area  101784268 bytes
    Fixed Size                   453324 bytes
    Variable Size              75497472 bytes
    Database Buffers           25165824 bytes
    Redo Buffers                 667648 bytes
    SQL> set lines 200
    SQL> show parameter shared_pool_size
    
    NAME                                 TYPE                              VALUE
    ------------------------------------ --------------------------------- ------------------------------
    shared_pool_size                     big integer                       50331648
    SQL> alter system set shared_pool_size=40331648 scope = both;
    
    System altered.
    
    SQL> show parameter shared_pool_size
    
    NAME                                 TYPE                              VALUE
    ------------------------------------ --------------------------------- ------------------------------
    shared_pool_size                     big integer                       41943040
    SQL> SELECT
      2  REQUEST_FAILURES,
      3  LAST_FAILURE_SIZE,
      4  MAX_FREE_SIZE,
      5  FREE_SPACE,
      6  REQUEST_MISSES
      7  FROM
      8  V$SHARED_POOL_RESERVED;
    SELECT
    *
    ERROR at line 1:
    ORA-03113: end-of-file on communication channel
    
    
    SQL>
    
    SQL> conn sys as sysdba
    Enter password:
    Connected.
    SQL> alter system set shared_pool_size=50331648 scope = both;
    
    System altered.
    
    SQL> show parameter shared_pool_size
    
    NAME                                 TYPE                              VALUE
    ------------------------------------ --------------------------------- ------------------------------
    shared_pool_size                     big integer                       50331648
    SQL> SELECT
      2  REQUEST_FAILURES,
      3  LAST_FAILURE_SIZE,
      4  MAX_FREE_SIZE,
      5  FREE_SPACE,
      6  REQUEST_MISSES
      7  FROM
      8  V$SHARED_POOL_RESERVED;
    The last step hangs the system...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  2. #12
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    It's interesting that you can reproduce the error because I have attempted the same thing on 2 different test instances and still can't get it to reproduce

    I wondered if it had anything to do with the contents of the shared poll when it is resized.

    The details from Oracle seem to imply that they are working on a backport for a previous bug to be released in 9.2.0.3

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #13
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by jovery
    I wondered if it had anything to do with the contents of the shared poll when it is resized.
    Well, i tried on a test database, and had just started it, so there was nothing in the shared pool

    Atleast now if they tell you to upgrade then you can tell them that it happens in 9.2.0.2.0 also

    Regards
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #14
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Thanks for your help Amar
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #15
    Join Date
    Nov 1999
    Location
    Kuwait
    Posts
    122

    Angry

    I tried to reproduce the problem on Tru64 5.1A with 9.2.0.1.0, I reduced the shared pool about 100 MB and got the followin results

    SQL> CONN SYS/ORACLE@ALPHA AS SYSDBA
    Connected.
    SQL> SHOW SGA

    Total System Global Area 370642376 bytes Fixed Size 732616 bytes
    Variable Size 251658240 bytes Database Buffers 117440512 bytes
    Redo Buffers 811008 bytes
    SQL> SHOW PARAMETER SHARED_POOL_SIZE

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------ shared_pool_size big integer 218103808

    SQL> ALTER SYSTEM SET SHARED_POOL_SIZE = 113246208;

    System altered.

    SQL> SHOW PARAMETER SHARED_POOL_SIZE

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------ shared_pool_size big integer 117440512

    SQL> SELECT
    2 REQUEST_FAILURES,
    3 LAST_FAILURE_SIZE,
    4 MAX_FREE_SIZE,
    5 FREE_SPACE,
    6 REQUEST_MISSES
    7 FROM
    8 V$SHARED_POOL_RESERVED
    9 ;
    V$SHARED_POOL_RESERVED
    *
    ERROR at line 8:
    ORA-04030: out of process memory when trying to allocate 88 bytes (cursor work he,x$ksmsp)


    (This error took alot of time to come up so i tried again)

    SQL> SHOW PARAMETER SHARED_POOL_SIZE
    NAME TYPE VALUE ------------------------------------ ----------- ------------------------------shared_pool_size big integer 117440512

    SQL> L
    1 SELECT
    2 REQUEST_FAILURES,
    3 LAST_FAILURE_SIZE,
    4 MAX_FREE_SIZE,
    5 FREE_SPACE,
    6 REQUEST_MISSES
    7 FROM
    8 V$SHARED_POOL_RESERVED
    9*
    SQL> /
    V$SHARED_POOL_RESERVED
    *
    ERROR at line 8:
    ORA-04030: out of process memory when trying to allocate 88 bytes (cursor work he,x$ksmsp)

    SQL> spool off

    I think i have to try more to get the error u got Jim
    NK
    ====================================================
    Stand up for your principles even if you stand alone!
    ====================================================

  6. #16
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by nabeel
    SQL> CONN SYS/ORACLE@ALPHA AS SYSDBA
    Please change your password, you should never give out your passwords(and that too of sys), and never on the web . BTW that's a very lousy password for sys.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #17
    Join Date
    Nov 1999
    Location
    Kuwait
    Posts
    122

    Talking Very Smart Sir,

    My dear Sir, that was a fake pwd Do u think that someone would give out there sys pwd so openly on net and thats also on a form?

    adewri, grow up and thing mature!
    NK
    ====================================================
    Stand up for your principles even if you stand alone!
    ====================================================

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width