Oracle Database Discussions

Hi all folks, we have just upgrade our database from 9.2.0.6.0 to 11.2.0. using manual upgrade guide. Passing as gateway by 10.2.0.3.0
Our operating system is HP-UX sinnal01 B.11.31 U ia64 1080415008 unlimited-user license
In prove environment we have no problems but in production we have many problems reports in alert file:


Parameters

System parameters with non-default values:
processes = 2000
sessions = 3024
timed_statistics = TRUE
sga_max_size = 48000M
lock_sga = TRUE
shared_pool_size = 10112M
large_pool_size = 384M
java_pool_size = 384M
streams_pool_size = 128M
shared_pool_reserved_size= 100M
disk_asynch_io = FALSE
dbwr_io_slaves = 0
resource_manager_plan = "OPERACION_DIA"
control_files = "/u02/oradata/sin/control01.ctl"
control_files = "/u03/oradata/sin/control02.ctl"
control_files = "/u04/oradata/sin/control03.ctl"
control_files = "/u05/oradata/sin/control04.ctl"
db_block_checksum = "FALSE"
db_block_size = 8192
db_cache_size = 15104M
db_keep_cache_size = 8064M
db_recycle_cache_size = 0
db_writer_processes = 8
dbblock_hash_latches = 65536
compatible = "11.2.0"
log_archive_dest_1 = "LOCATION=/u99/app/oracle/admin/sin/arch MANDATORY REOPEN=60"
log_archive_format = "SIN_%R_%T_%S.ARC"
log_buffer = 5242880
log_checkpoint_interval = 0
log_checkpoint_timeout = 0
db_files = 400
db_file_multiblock_read_count= 32
db_file_multiblock_read_count= 32
fast_start_mttr_target = 0
log_checkpoints_to_alert = TRUE
undo_management = "AUTO"
undo_tablespace = "UNDOTBS1"
undo_retention = 43200
sec_case_sensitive_logon = FALSE
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
instance_name = "sin"
dispatchers = "(PROTOCOL=TCP) (SERVICE=sin)"
dispatchers = "(PROTOCOL=TCP) (DISPATCHERS=30)"
shared_servers = 30
max_shared_servers = 200
max_dispatchers = 70
session_cached_cursors = 1000
utl_file_dir = "/tmp"
utl_file_dir = "/valswt"
utl_file_dir = "/valres"
utl_file_dir = "/sitdat"
utl_file_dir = "/u06/app/oracle/admin/sin/"
utl_file_dir = "/u06/tmpapp"
utl_file_dir = "/u01/app/oracle/product/9.2.0.5.0/ccr/state"
plsql_code_type = "NATIVE"
plsql_optimize_level = 3
job_queue_processes = 32
cursor_sharing = "SIMILAR"
parallel_max_servers = 0
session_max_open_files = 20
audit_trail = "DB"
sort_area_size = 524288
sort_area_retained_size = 524288
db_name = "sin"
open_cursors = 5000
star_transformation_enabled= "FALSE"
eliminatecommon_subexpr= FALSE
parallel_adaptive_multi_user= FALSE
query_rewrite_enabled = "TRUE"
pga_aggregate_target = 4869M
workarea_size_policy = "AUTO"
aq_tm_processes = 1
diagnostic_dest = "/u06/app/oracle"

this is one of our problem

***********************************************************************

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for HPUX: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for HPUX: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for HPUX: Version 11.2.0.1.0 - Production
Time: 09-AUG-2010 14:32:16
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.10.110)(PORT=1388))
WARNING: inbound connection timed out (ORA-3136)
Mon Aug 09 14:34:53 2010


***********************************************************************

this is other critic problem

Mon Aug 09 16:46:44 2010
Errors in file /u06/app/oracle/diag/rdbms/sin/sin/trace/sin_ora_17302.trc:
ORA-27103: internal error
HPUX-ia64 Error: 28: No space left on device
Additional information: 108
Additional information: 1835008
Additional information: 32769
Mon Aug 09 16:46:46 2010
Errors in file /u06/app/oracle/diag/rdbms/sin/sin/trace/sin_ora_1936.trc (incident=363128
):
ORA-04030: out of process memory when trying to allocate 32880 bytes (PLS PGA hp,PL/SQL ST
ACK)
Incident details in: /u06/app/oracle/diag/rdbms/sin/sin/incident/incdir_363128/sin_ora_193
6_i363128.trc
Mon Aug 09 16:46:47 2010
Errors in file /u06/app/oracle/diag/rdbms/sin/sin/trace/sin_ora_29977.trc (incident=36192
8):
ORA-04030: out of process memory when trying to allocate 1049112 bytes (pga heap,kllcqgf:k
llsltba)

ORA-04030: out of process memory when trying to allocate 824504 bytes (pga heap,kco buffer
)
ORA-27103: internal error
HPUX-ia64 Error: 28: No space left on device
Additional information: 108
Additional information: 1835008
Additional information: 32769
Incident details in: /u06/app/oracle/diag/rdbms/sin/sin/incident/incdir_364033/sin_ora_173
02_i364033.trc
Errors in file /u06/app/oracle/diag/rdbms/sin/sin/trace/sin_ora_17302.trc:
ORA-04030: out of process memory when trying to allocate 824504 bytes (pga heap,kco buffer
)
ORA-27103: internal error
HPUX-ia64 Error: 28: No space left on device
Additional information: 108


These problems make hung our applications


Pls help. Thank's