In my oratab file have listed 4 DB and when i issue dbstart and dbshut, why is it only the first 3 DB listed in oratab will be shutdown or re-start and it will ignore the 4th DB listed in the oratab ?
My DB is 8i in unix env.
Printable View
In my oratab file have listed 4 DB and when i issue dbstart and dbshut, why is it only the first 3 DB listed in oratab will be shutdown or re-start and it will ignore the 4th DB listed in the oratab ?
My DB is 8i in unix env.
show the contents of your oratab, is the last column set to N for the database that wont start?
it is also set as "Y" for the last listing. Please advise.
Are all 4 DBs using the same Oracle Home?
Have you tried startup and shutdown the 4th DB manually?
Better to show the oratab content, if not everyone here will be just guessing your problem.
Yes all 4 DBs are in the same ora home.
Yes i am able to shut and start all 4 DBs manually.
Attached below is my oratab file :-
#
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME::
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
*:/oracle/app/oracle/product/8.1.7:N
whl2:/oracle/app/oracle/product/8.1.7:Y
whlr:/oracle/app/oracle/product/8.1.7:Y
ialdb2:/oracle/app/oracle/product/8.1.7:Y
whlp:/oracle/app/oracle/product/8.1.7:Y
TQ.
I wonder whether there's a hidden character in the fourth line (introduced as a typo perhaps). Have you tried deleting and re-typing the line?
I have found out that we need to presson the last DB list in the oratab file and create a empty new line in the oratab file in order for dbstart and dbshut to read all DB in oratab file.
Have you guys notice this ?
Sorry, how do you mean 'press on the last DB'? Delete it then reinsert it? Or add a new empty line below it?
Sorry, what i meant what press enter-key on the last DB list in the oratab file and create a empty new line in the oratab file after the last entry in the oratab file. When i issue dbstart and dbshut again, it will able to shut and start all DB in oratab file.
try re-running root.sh to re-create oratab.