| Error Starting Database. [message #54376] |
Wed, 13 November 2002 23:29  |
Mustafa Motiwala
Messages: 3
Registered: November 2002
|
Junior Member |
|
|
Hi,
I installed Oracle 8.1.6 on red hat 7.3 (after much pain and hassle). After the install, I tried creating a database, but the problem is after the startup nomount pfile=xxx command is issued, svrmgr seems to hang, then it responds with ora-03113. I just cant seem to figure out whats wrong. any help in this regard would be highly appreciated. I have 256 Megs of Ram
I checked the alert logs and well it seems that the database isntance starts just fine heres the output:
----------------------------
Thu Nov 14 10:39:23 2002
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.6.1.0.
System parameters with non-default values:
processes = 50
shared_pool_size = 4194304
large_pool_size = 614400
java_pool_size = 32768
control_files= /opt/oracle/oradata/cmp/control01.ctl, /opt/oracle/oradata/cmp/control02.ctl, /opt/oracle/oradat/cmp/control03.ctl
db_block_buffers = 2048
db_block_size = 8192
compatible = 8.1.0
log_buffer = 163840
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
db_domain = precience.pk
distributed_transactions = 10
instance_name = cmp
service_names = cmp.precience.pk
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = cmp
open_cursors = 100
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 60
background_dump_dest =/opt/oracle/admin/cmp/bdump
user_dump_dest = /opt/oracle/admin/cmp/udump
core_dump_dest = /opt/oracle/admin/cmp/cdump
|
|
|
|
|
|
|
|
| Re: Error Starting Database. [message #54390 is a reply to message #54376] |
Thu, 14 November 2002 14:46  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
You have to change or check your kernel settings for the shared memory. Also did you backward to glibc 2.1? The ORA-03113 usually reflects insufficient values for these parameters.
Check your values with:
# cat /proc/sys/kernel/shmmax
33554432
# cat /proc/sys/kernel/shmmni
4096
and refer to the installation guides Here , Here , Here and Here
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
| Re: Error Starting Database. [message #54404 is a reply to message #54390] |
Fri, 15 November 2002 04:09 |
Mustafa Motiwala
Messages: 3
Registered: November 2002
|
Junior Member |
|
|
|
Yes, I did install the glibc21 package with redhat. without that the installation wouldnt start. my values in proc correspond with the ones you gave, so i dont think thats the problem either. I just spent the last couple of minutes modifying the makefiles and relinking oracle libs. but that didnt help either! :( this is getting frustrating... please... i am desprate... any suggestions???
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
