-
Sam,
I happened to check my initPROD.ora file
#shared_pool_size=300000000
shared_pool_reserved_size=300000000
I think i have to comment out shared_pool_reserved_size and then uncomment shared_pool_size
RIght?
then i will bounce the database and again run the catalog.sql
correct me
-
Thanx
Sam
Life is a journey, not a destination!
-
Thanks Sam,
So, do i have to recreate the database and run sql.bsq,followd by catalog.sql
or just correct the shared_pool_size and then run catalog.sql again ?
-
First just fix the shared_pool and try to open the database. Then try running the catalog.sql script and see the results. If that succeds procced with the rest.
Else start from square one. But doubt that you got to run the sql.bsq
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Sam,
fixing shared_pool_size did not have any effect. the problem still exists.
Dont know what to do.
-
Could you please post your init.ora file? May I know why you were trying to create the database through the scripts? Is there any reason behind it? Did you try the database configuration assistant "dbassist" and try?
Looking forward to hear from you.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Sam,
Thanks for responding. I will post the init.ora tomorrow. I am doing an upgrade of oracle applications 10.7SC to 11.5.5
so after installing the 11.5.5, 8.1.7 database wont be there,we have to create it,so, I manually created it.
I have to check if 'dbassist' utility is available.
thanks
-
run sql.bsq
Hi, never heard who need to manually run sql.bsq. it's called by oracle automatically during creation of db. This script creates actural objects while catalog.sql create views/synonms of these objects. Your script look ok, pls try re-create db by running your script and login as sys to run catalog.sql and catproc.sql. Hope this can help.
-
Most of the oracle installations would have the dbassist installed on the server. Make sure that you have that. Next confirm that your ORACLE_HOME, LD_LIBRARY_PATH, TNS_ADMIN, and PATH and ORACLE_SID set correctly before you start the db creation.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Sam, here it is
###########################################################################
#
# Oracle Applications 11i - init.ora
#
# This file contains a listing of init.ora parameters for 8.1.6
#
# This is a reference file and contains the major initialisation
# parameters used in Oracle Applications. It is intended to provide
# a guide to the required parameters, but the actual values chosen
# will be specific to each customer site, depending on the number
# of OLTP users. This is in contrast to the CBO parameters
# (ifilecbo.ora ), which are mandatory.
#
###########################################################################
db_name = PROD
control_files = /u03/oracle/proddata/cntrl01.dbf,
/u04/oracle/proddata/cntrl02.dbf,
/u05/oracle/proddata/cntrl03.dbf
db_block_size = 8192
compatible = 8.1.7
_system_trig_enabled = TRUE
row_locking = always
nls_date_format = DD-MON-RR # Is this still true with 11.5 ?
nls_numeric_characters = ".,"
nls_sort = binary
nls_language = american
nls_territory = america
#audit_trail = true # if you want auditing
max_enabled_roles = 40 # Some modules depend on
# this feature.
ifile = ?/dbs/ifilecbo.ora
user_dump_dest = /u02/oracle/proddb/8.1.7/admin/udump
background_dump_dest = /u02/oracle/proddb/8.1.7/admin/bdump
core_dump_dest = /u02/oracle/proddb/8.1.7/admin/cdump
max_dump_file_size = 10240 # trace file size
timed_statistics = true
# _trace_files_public
_trace_files_public = TRUE
processes = 75 # Max. no. of users x 2
db_files = 500 # Max. no. of database files
dml_locks = 500
open_cursors = 500 # Consumes process memory, unless
# using MTS.
session_cached_cursors = 100
enqueue_resources = 5000 # Max. no of concurrent database locks.
db_block_buffers = 5000
log_checkpoint_timeout = 72000 # Checkpoint at least every 20 mins.
log_checkpoint_interval = 100000
log_buffer = 1048576
log_checkpoints_to_alert = TRUE
rollback_segments = (rb1,rb2,rb3,rb4,rb5,rb6,rb7,rb8,rb9,rb10,rb11,rb12,rb13,rb14,rb15,rb16)
#rollback_segments = (rbs1,rbs2)
sort_area_size = 256000
hash_area_size= 6000000
#shared_pool_size = 300000000
shared_pool_reserved_size = 30000000
_shared_pool_reserved_min_alloc = 4100
shared_pool_size = 300000000
#java_pool_size = 50000000
utl_file_dir = /usr/tmp
aq_tm_processes = 1
# log_archive_start = true # if you want automatic archiving
parallel_max_servers = 8
parallel_min_servers = 0
optimizer_mode= choose
_sqlexec_progression_cost= 0
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|