ora-06553, PLS-213 package STANDARD not accessible

[dba_usa]

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

[sambavan]

OH YES!!!

Sam

[dba_usa]

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 ?

[sambavan]

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

[dba_usa]

Sam,
fixing shared_pool_size did not have any effect. the problem still exists.

Dont know what to do.

[sambavan]

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

[dba_usa]

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

[xiaomao]

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.

[sambavan]

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

[dba_usa]

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