on 07-23-2008 2:55 AM
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Some parameters are set by default, I am set the parameter according to sap note 830576.
This is my ini.ora.
@(#)initSID.ora 20.4.6.1 SAP 98/03/30
###########################################################
(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
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 )
DB-NAME
db_name = DOP
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.