Skip to Content
author's profile photo Former Member
Former Member

upgrade DBMS client library OCI_920_SHARE

Hi Guys,

I am perform the oracle upgrade, from 9.0.2 to 10.0.2, and I need to know how I can upgrade the client library??

I am copy the OCL into the sap executables, but when I check into the sap system, the system show me that I have the client library OCI_920_share.

Thank you,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 07:50 AM

    Hi ,

    Take a backup of your initSID.ora and spfileSID.ora.

    change the parameter as per the note.after that login to sqplu. and create a spfile from pfile.

    startsap this will change the parameter. After starting the SAP. login to SAP and run the t-code db03 andb check the same parameter changes.

    Reward points...

    Rgards

    CS

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 10:03 AM

    Hi gurus,

    I have windows 2003 32bits + sap 4.7.

    After the migration to oracle, I have a bad performance. I follow the SAP Note 830576, regardind the parameters for oracle 10.

    When I check the database I have the following results:

    BR0978W Database profile alert - level: WARNING, parameter: DB_FILE_MULTIBLOCK_READ_COUNT, value: 128 (> 8)

    BR0978W Database profile alert - level: ERROR, parameter: LOG_ARCHIVE_START, value: FALSE (<> TRUE)

    BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 6984704 (>< 2048,512 KB)

    BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_FEATURES_ENABLE, value: 10.2.0.2 (<> 9.2.0)

    BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_INDEX_COST_ADJ, value: 20 (<> 10)

    BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_MODE, value: ALL_ROWS (<> CHOOSE)

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      HI,

      did you upgrade oracle to 10g?

      if yes then check the following parameter

      DB_FILE_MULTIBLOCK_READ_COUNT

      -> Do not set this parameter

      BR0978W Database profile alert - level: ERROR, parameter: LOG_ARCHIVE_START, value: FALSE ( TRUE)

      -> check sap note Note 900522 - Incorrect alerts/warnings in database check for Oracle 10g

      LOG_BUFFER

      -> Minimum size of the Oracle redo buffer (in bytes) set the values between 1MB and 16MB

      OPTIMIZER_FEATURES_ENABLE

      -> Do not set this parameter

      OPTIMIZER_INDEX_COST_ADJ

      -> Do not set this parameter

      OPTIMIZER_MODE

      -> Do not set this parameter

      regards,

      kaushal

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 04:07 AM

    Hi,

    which OS you are using?

    if you perform windows based installation

    check Note 998004 - Update the Oracle Instant Client on Windows

    if you perform unix based installation

    check Note 819829 - Oracle Database 10g: Instant Client 10.x on Unix

    regards,

    kaushal

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Kaushal,

      One correction/clarification.

      If the OP is only upgrading Oracle (as he mentions) then, in UNIX, the oracle client version does NOT have to be changed.

      The oracle client version depends on the kernel in use.

      For example, if the kernel is 6.40, the oracle client used is 9i regardless of the database version.

      The upgrade manual and upgrade relevant notes indicate so.

      It is important to know (also mentioned on the upgrade manual and relevant notes) that you must install the oracle client 9.2.0.7 or 9.2.0.8 as previous versions will cause errors when connecting to oracle 10g

      Here is a list of the notes you must read:

      521230 FAQ: Client software 9i or earlier on UNIX

      539922 Installing the ORACLE client software 9.2.X for UNIX

      1017418 Installing Oracle 9208 Client software on UNIX

      948305 Oracle Upgrade to 10g Release 2 (10.2) on Windows

      819830 Oracle Database 10g: Additional Information on upgrade:UNIX

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 01:22 PM

    Some parameters are set by default, I am set the parameter according to sap note 830576.

    This is my ini.ora.

    1. @(#)initSID.ora 20.4.6.1 SAP 98/03/30

    ###########################################################

    1. (c)Copyright SAP AG, Walldorf #

    ###########################################################

    #INIT.SID Template for R/3 on Oracle 8.1.5 on NT

    #Update this file according to note 180605

    #

    bitmap_merge_area_size = 33554432

    control_file_record_keep_time = 30

    cursor_space_for_time = false

    db_block_size = 8192

    db_files = 254

    log_checkpoint_interval = 0

    max_dump_file_size = 20000

    open_cursors = 800

    parallel_execution_message_size = 8192

    parallel_max_servers = 4

    processes = 138

    sessions = 165

    sort_area_retained_size = 0

    JOB_QUEUE_PROCESSES = 1

    db_writer_processes= 1

    DB_CACHE_SIZE = 950M

    shared_pool_size = 950M

    WORKAREA_SIZE_POLICY = AUTO

    PGA_AGGREGATE_TARGET = 400M

    1. CONTROL-FILES

    control_files = ( J:\oracle\DOP\sapdata1\cntrl\cntrlDOP.dbf,J:\oracle\DOP\sapdata2\cntrl\cntrlDOP.dbf,J:\oracle\DOP\sapdata3\cntrl\cntrlDOP.dbf )

    1. DB-NAME

    db_name = DOP

    1. PATHS / DESTINATIONS / TRACES

    background_dump_dest = E:\oracle\DOP\saptrace\background

    user_dump_dest = E:\oracle\DOP\saptrace\usertrace

    log_archive_dest = H:\oracle\DOP\saparch

    log_archive_format = DOParchARC%r_%t_%s.001

    compatible = 10.2.0

    remote_os_authent=TRUE

    eliminatecommon_subexpr= FALSE

    undo_tablespace=PSAPUNDO

    undo_retention=21600

    undo_management=AUTO

    sortelimination_cost_ratio = 10

    optimizerjoin_sel_sanity_check = TRUE

    #Update Mssassi Hayat accroding to SAP recmmendation : change 130770

    btree_bitmap_plans = FALSE

    pushjoin_predicate = FALSE

    db_block_checksum = FALSE

    log_checkpoints_to_alert = TRUE

    optimpeek_user_binds = FALSE

    1. Added during application of May CPU

    ALWAYSSEMI_JOIN = OFF

    OPTIMIZEROR_EXPANSION = DEPTH

    event = "10183 trace name context forever, level 1"

    event = "10191 trace name context forever, level 1"

    event = "10028 trace name context forever, level 1"

    event = "38060 trace name context forever, level 1"

    event = "38068 trace name context forever, level 100"

    #new Parameter

    log_buffer = 1048576

    optimizer_index_caching = 50

    optimizer_index_cost_adj = 20

    parallel_execution_message_size=16384

    parallel_max_servers=40

    parallel_threads_per_cpu=1

    recyclebin=off

    replication_dependency_tracking=FALSE

    star_transformation_enabled=TRUE

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.