Skip to main content

what if one of DBWn fails

SQL> select bgp.name,p.spid,s.sid
2 from v$bgprocess bgp,v$process p,v$session s
3 where bgp.paddr=p.addr
4 and p.addr=s.paddr;

NAME SPID SID
----- ------------ ----------
PMON 29891 1
DBW0 29893 2
DBW1 29895 3
DBW2 29897 4
LGWR 29899 5
CKPT 29901 6
SMON 29903 7
RECO 29905 8
CJQ0 29907 9
QMN0 29909 10

10 rows selected.

SQL> !ps -ef|grep 29893
orclhcc 29893 1 0 13:49 ? 00:00:00 ora_dbw0_HCC
orclhcc 30347 14908 0 13:52 pts/5 00:00:00 /bin/bash -c ps -ef|grep 29893
orclhcc 30349 30347 0 13:52 pts/5 00:00:00 grep 29893

SQL> !kill -9 29893

SQL> !ps -ef|grep 29893
orclhcc 30378 14908 0 13:52 pts/5 00:00:00 /bin/bash -c ps -ef|grep 29893
orclhcc 30380 30378 0 13:52 pts/5 00:00:00 grep 29893

SQL> select 1 from dual;
select 1 from dual
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

Conclusion:Instance crashes

Comments

Post a Comment

Popular posts from this blog

Reaname Database

Mount the database whose name is to be changed SQL> startup pfile=inithcc.ora nomount ORACLE instance started. Total System Global Area 100663296 bytes Fixed Size 1217884 bytes Variable Size 88083108 bytes Database Buffers 8388608 bytes Redo Buffers 2973696 bytes SQL> alter database mount; Database altered. SQL> select name,open_mode from v$database; NAME OPEN_MODE --------- ---------- HCC MOUNTED Use nid Utility to change the Database Name(from 9i or higher) $ nid target=sys/as sysdba dbname=test This may give the following Output DBNEWID: Release 10.2.0.1.0 - Production on Thu May 19 19:33:31 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Password: Connected to database HCC (DBID=1702020770) Connected to server version 10.2.0 Control Files in database: /home/hcctest/oracle/oradata/test/control/control01.ctl /home/hcctest/oracle/oradata/test/control/cont...
Post a Comment
Read more

ORA-01501: CREATE DATABASE failed

Problem: ======== During the creation of a new database the CREATE DATABASE command fails with the following errors: ORA-01501: CREATE DATABASE failed ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 406 ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable to allocate 2192 bytes of shared memory ("shared pool", "unknown object","KQLS heap","KQLS MEM BLOCK") Solution: ========= 1. Increase the shared_pool_size parameter in the init .ora file. 2. Shutdown abort your database. 3. Startup nomount your database. 4. Execute the CREATE DATABASE command again. Explanation: ============ If your shared_pool_size is too small, the CREATE DATABASE command cannot finish successfully. This happens typically on small test instances when you just want to test anything on an empty instance and do not want to waste too much memory on a server. In this case you often edit in...
Post a Comment
Read more

utlrp scipts

utlrp script + What is UTLRP.SQL? This script recompiles invalid PLSQL modules. + What this script does? This script recompiles all existing invalid PL/SQL modules in a database. This is a fairly general script that can be used at any time to recompile all existing invalid PL/SQL modules in a database If run as one of the last steps during migration/upgrade/downgrade this script will validate all PL/SQL modules (i.e. procedures, functions, packages, triggers, types, views, libraries) during the migration step itself. + Any other script called within UTLRP.SQL? Yes. It invokes utlrcmp.sql Where are these SCRIPTS located? ============================ The scripts are found in the standard admin directory of the Oracle Home. $ORACLE_HOME/rdbms/admin Which script is better? ================= -> UTLRP.SQL - Validates all invalid objects and can be run anytime. (this in-turn is called by utlirp.sql) What is invalid ? you can find out by doing this In sqlplus : 15:03...
Post a Comment
Read more