-
dbstart and dbshut using oratab
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.
What's next after 10g?
-
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?
If I have to choose between two evils, I always like to choose the one I haven't tried yet.
-
I have found out that we need to press on 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?
If I have to choose between two evils, I always like to choose the one I haven't tried yet.
-
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.
"High Salaries = Happiness = Project Success."
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|