Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    14

    Question Unanswered: encounter ORA-01075 when expand SGA on 32bit system

    hi all,

    Recently, I expand SGA size of Oracle10g(release2) to 3.9G on my 32bit RHEL AS 4 Update 2, It can work fine,but still has an minor flaw. That is When I use script to auto start it while boot system,It throw out ORA-01075

    detail below

    after reboot the system,I connect to Oracle using sqlplus
    $ sqlplus /nolog

    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 24 15:48:30 2007

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    SQL> conn / as sysdba
    ERROR:
    ORA-01075: you are currently logged on


    SQL> conn system/mypasswd
    ERROR:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-27103: internal error
    Linux Error: 22: Invalid argument
    Additional information: 27129
    Additional information: -1

    SQL> GO ON
    GO ON

    SQL> conn / as sysdba
    ERROR:
    ORA-24313: user already authenticated


    SQL> startup
    ORA-01031: insufficient privileges
    SQL> conn / as sysdba
    ERROR:
    ORA-24313: user already authenticated


    SQL> shutdown abort
    ORA-01031: insufficient privileges

    SQL> conn / as sysdba
    ERROR:
    ORA-24313: user already authenticated


    SQL> startup force
    ORA-01031: insufficient privileges

    SQL> prompt I QUIT
    I QUIT

    SQL> exit

    $echo RECONNECT
    RECONNECT
    $ sqlplus /nolog

    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 24 15:51:07 2007

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    SQL> conn / as sysdba
    Connected.
    SQL> prompt SO PUZZAL!
    SO PUZZAL!

    the alter information,so many errot information like these

    < Errors in file /opt/oracle/admin/MesProd/bdump/mesprod_q000_3488.trc:
    < ORA-22303: type "SYS"."AQ$_HISTORY" not found
    < ORA-00604: error occurred at recursive SQL level 1
    < ORA-27103: internal error
    < Linux Error: 22: Invalid argument
    < Additional information: 27129
    < Additional information: -1
    < Wed Aug 1 10:33:48 2007
    < Errors in file /opt/oracle/admin/MesProd/bdump/mesprod_q001_3490.trc:
    < ORA-22303: type "SYS"."AQ$_HISTORY" not found
    < ORA-00604: error occurred at recursive SQL level 1
    < ORA-27103: internal error
    < Linux Error: 22: Invalid argument
    < Additional information: 27129
    < Additional information: -1

    and one of trace file post here

    /opt/oracle/admin/MesProd/bdump/mesprod_q001_3477.trc
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options
    ORACLE_HOME = /opt/oracle/product/ora10g
    System name: Linux
    Node name: RealDB
    Release: 2.6.9-22.ELsmp
    Version: #1 SMP Mon Sep 19 18:32:14 EDT 2005
    Machine: i686
    Instance name: MesProd
    Redo thread mounted by this instance: 1
    Oracle process number: 28
    Unix process pid: 3477, image: oracle@RealDB (q001)

    *** SERVICE NAMESYS$BACKGROUND) 2007-07-25 13:32:36.213
    *** SESSION ID148.31) 2007-07-25 13:32:36.213
    freeing in-flux r/w latch for process state: 582b8d40
    ... in-flux r/w latch 58e80900 Child cache buffers chains level=1 child#=2765
    Location from where latch is held: kcbgtcr: fast path:
    Context saved from call: 4194530
    state=busy(shared) (val=0x1)
    KSV 22303 error in slave process
    *** 2007-07-25 13:32:36.214
    ORA-22303: type "SYS"."AQ$_HISTORY" not found
    ORA-00604: error occurred at recursive SQL level 1
    ORA-27103: internal error
    Linux Error: 22: Invalid argument
    Additional information: 27129
    Additional information: -1
    Additional information: -1073759372
    OPIRIP: Uncaught error 447. Error stack:
    ORA-00447: fatal error in background process
    ORA-22303: type "SYS"."AQ$_HISTORY" not found
    ORA-00604: error occurred at recursive SQL level 1
    ORA-27103: internal error
    Linux Error: 22: Invalid argument
    Additional information: 27129
    Additional information: -1
    Additional information: -1073759372
    /opt/oracle/admin/MesProd/bdump/mesprod_q001_3477.trc
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options
    ORACLE_HOME = /opt/oracle/product/ora10g
    System name: Linux
    Node name: RealDB
    Release: 2.6.9-22.ELsmp
    Version: #1 SMP Mon Sep 19 18:32:14 EDT 2005
    Machine: i686
    Instance name: MesProd
    Redo thread mounted by this instance: 1
    Oracle process number: 22
    Unix process pid: 3477, image: oracle@RealDB (q001)

    *** SERVICE NAMESYS$BACKGROUND) 2007-07-25 13:55:37.541
    *** SESSION ID147.4) 2007-07-25 13:55:37.541
    freeing in-flux r/w latch for process state: 582b6b08
    ... in-flux r/w latch 58e80900 Child cache buffers chains level=1 child#=2765
    Location from where latch is held: kcbgtcr: fast path:
    Context saved from call: 4194530
    state=busy(shared) (val=0x1)
    KSV 22303 error in slave process
    *** 2007-07-25 13:55:37.552
    ORA-22303: type "SYS"."AQ$_HISTORY" not found
    Instance name: MesProd
    Redo thread mounted by this instance: 1
    Oracle process number: 22
    Unix process pid: 3477, image: oracle@RealDB (q001)

    *** SERVICE NAMESYS$BACKGROUND) 2007-07-25 13:55:37.541
    *** SESSION ID147.4) 2007-07-25 13:55:37.541
    freeing in-flux r/w latch for process state: 582b6b08
    ... in-flux r/w latch 58e80900 Child cache buffers chains level=1 child#=2765
    Location from where latch is held: kcbgtcr: fast path:
    Context saved from call: 4194530
    state=busy(shared) (val=0x1)
    KSV 22303 error in slave process
    *** 2007-07-25 13:55:37.552
    ORA-22303: type "SYS"."AQ$_HISTORY" not found
    ORA-00604: error occurred at recursive SQL level 1
    ORA-27103: internal error
    Linux Error: 22: Invalid argument
    Additional information: 27129
    Additional information: -1
    OPIRIP: Uncaught error 447. Error stack:
    ORA-00447: fatal error in background process
    ORA-22303: type "SYS"."AQ$_HISTORY" not found
    ORA-00604: error occurred at recursive SQL level 1
    ORA-27103: internal error
    Linux Error: 22: Invalid argument
    Additional information: 27129
    Additional information: -1
    /opt/oracle/admin/MesProd/bdump/mesprod_q001_3477.trc
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options
    ORACLE_HOME = /opt/oracle/product/ora10g
    System name: Linux
    Node name: RealDB
    Release: 2.6.9-22.ELsmp
    Version: #1 SMP Mon Sep 19 18:32:14 EDT 2005
    Machine: i686
    Instance name: MesProd
    Redo thread mounted by this instance: 1
    Oracle process number: 22
    Unix process pid: 3477, image: oracle@RealDB (q001)

    *** SERVICE NAMESYS$BACKGROUND) 2007-08-01 10:10:19.454
    *** SESSION ID147.4) 2007-08-01 10:10:19.454
    freeing in-flux r/w latch for process state: 582b6b08
    ... in-flux r/w latch 58e80900 Child cache buffers chains level=1 child#=2765
    Location from where latch is held: kcbgtcr: fast path:
    Context saved from call: 4194530
    state=busy(shared) (val=0x1)
    KSV 22303 error in slave process
    *** 2007-08-01 10:10:19.506
    ORA-22303: type "SYS"."AQ$_HISTORY" not found
    ORA-00604: error occurred at recursive SQL level 1
    ORA-27103: internal error
    Linux Error: 22: Invalid argument
    Additional information: 27129
    Additional information: -1
    OPIRIP: Uncaught error 447. Error stack:
    ORA-00447: fatal error in background process
    ORA-22303: type "SYS"."AQ$_HISTORY" not found
    ORA-00604: error occurred at recursive SQL level 1
    ORA-27103: internal error
    Linux Error: 22: Invalid argument
    Additional information: 27129
    Additional information: -1

    why? and how?
    any reply will be a greate favour to me and thanks.

    textlee
    Last edited by text1978; 08-01-07 at 12:49.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    GOOGLE is your friend, but only when you use it.
    Results 1 - 10 of about 202,000 for Oracle Linux Error: 22: Invalid argument.

    increase the value of SHMALL
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2003
    Posts
    14
    Thank you Sir.

Posting Permissions

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