i have this problem with one of my oracle database server. this server previously only had one database and so start|stop-ing the database at system startup|shutdown was no problem since a single script in init.d and some changes in rc.local and rc.S would solve the problem. but now this server has 3 different databases running over it and all of them are fully operational. the problem is now only the default database gets started up in the system startup and i have to start the other 2 manually using the 'startup' command after login in to each of the databases. as you can understand this becomes a real pain in the a** for me as i have to come and do the same thing everyday. i did a little research and came to know that the default database is loaded up after checking the ORACLE_SID from .bash_profile of oracle user (yes we have this user in our system). so here's what i did i thought would solve the problem only it doesn't:
(i hope the script is self explanatory)
----------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------

these lines in /etc/rc.d/rc.local i thought would startup all databases at system startup
it doesn't! searching google with the keywords as in the subject line turned up one promising search but alas they ask money to show me the solution
hxxp://www.experts-exchange.com/Databases/Oracle/Q_21114417.html"

i would greatly appericiate if you guys could help me out with this problem. i am not suggesting using only the above way to solve the problem. any way is good enough if it solves the problem.

are u guys even giving it some thought or am i just been neglected or impatient?

i have solved the problem and since nobody bothered to answer my question i am answering it for myself (thinking about future) and to anybody for whom it might be useful:

the example i take here involves three databases say (db1,db2 & db3) all in one oracle database server (i have 9i, yours maybe different).

first find the oratab file oracle is using (mine is /etc/oratab, yours maybe different)
here's a sample:
you see the last 5 lines, these are the important lines. it tells oracle what to start and what not to. the script is pretty much self explanatory. the first field is ORACLE_SID and the dbstart script uses it to fire up databases. an * means all (but i am not confident so i am not using it). i have three separate lines for my three databases (2nd, 4th & 5th lines). the middle part says about the ORACLE_HOME and the third field (after colon) specifies whether to auto start the database or not. since i want to fire up all three databases at system startup, i have put them as 'Y' (yes).

next go find init.ora files. it must be in your dbs directory under your $ORACLE_HOME (mine is there your's may be elsewhere). there is one init file per database and the filename convention is init($ORACLE_SID).ora
so my three databases have three init files initdb1.ora,initdb2.ora and initdb3.ora respectively. if only one is present and the other's are not (as in my case) simply copy the existing one to other two and name it respectively. from now on i have three database init files (since i made two copies of the existing one). now open the newly copied files and edit it to suit your needs. i only had to change all the occurences of db1 to db2 and db3 (in initdb2.ora & initdb3.ora) at several places and it worked for me since my $ORACLE_HOME is same for all three databases. save the file.
with root priv, fire up 'lsnrctl start' then 'dbstart' you should see all your db's starting up one after another. mine did. that's it. its pretty simple isn't it.

NOTE:
the script in the FIRST post is a WASTE OF TIME. DONOT use it. you donot have to run dbstart for each of the databases if you followed the above method. one dbstart with do for all. i will post another script shortly.

ok here's the script:
hope this post helps somebody who's in stress (like i was )

1 members found this post helpful.

Dear prozac,

Hope You r fine.

Thanks for such a wonderfull guidence of creating 2 or more db on Linux plateform.

Currently I am working on installing Oracle 10g AS, and 10g forms and reports services on RHEL 4.

Would u pls recommend me how to autostart Oracle 10g AS, and 10g forms and reports services on RHEL 4.

Thanks.

Aamer Javaid

first install everything you need. oracle will put proper script files in /etc/init.d, you will then need to add their paths in your /etc/rc.local file for them to start automatically on each boot.

Dear prozac,

Hope You r fine.

Thanks again but when I did the same.

I installed Oracle10gDB on RHEL 4. It created oratab, oraenv and one more file on Linux.

Then I installed Oracle10gAS FRServices on the same machine.
It asked me to override these files.

My Question is that what should I do to auto start both these softwares. should I override previous files or should I rename previous files or what to do?

One more thing is that How to auto start Oracle EM service that is in 10g. b-coz Management Server is not in Oracle 10g.

I am waiting for a detailed response.

Thanks.

Aamer Javaid

you have to create separate ORACLE_HOME for oracleDB and oracleAS if you intend to run both in the same machine.
I am not SOA in oracle matters and there are lots of guide in web which attempts to cover most of the FAQ's with the installations. We can not expect to cover all of them here, so i would suggest going throught them first and try as much to do as said there. Then if you are still unable to figure out somethings we can talk.

I see the EM in oracle10g is web based. Here's a nice script to do that I found on the web:
I have tested it and it works.