cancel
Showing results for 
Search instead for 
Did you mean: 

upgrade DBMS client library OCI_920_SHARE

Former Member
0 Kudos

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,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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 (> 😎

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)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

0 Kudos

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