Home » Infrastructure » Linux » Linux auto start database/listener (Oracle 10g, Redhat Linux 5, Fedora Core 6)
Linux auto start database/listener [message #395852] Thu, 02 April 2009 21:40 Go to next message
linuxos
Messages: 31
Registered: April 2009
Member
Which method is common for Oracle database and listener auto startup on Linux?

Add a dbora file and run it by chkconfig
(Ref: http://www.oracle-base.com/articles/linux/AutomatingDatabaseStartupAndShutdownOnLinux.php)

Or

Append a line in /etc/rc.d/rc.local to call the dbstart by oracle OS user
(Ref: https://www.linuxquestions.org/questions/linux-software-2/auto-start-script-for-oracle-92207/)

I don't know which method is reliable and safer. Thanks!

Report message to a moderator

Re: Linux auto start database/listener [message #395854 is a reply to message #395852] Thu, 02 April 2009 22:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I don't know which method is reliable and safer
Both are reliable

Report message to a moderator

Re: Linux auto start database/listener [message #395855 is a reply to message #395852] Thu, 02 April 2009 22:06 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check Script for automatic startup on boot.

Report message to a moderator

Re: Linux auto start database/listener [message #395940 is a reply to message #395852] Fri, 03 April 2009 04:04 Go to previous messageGo to next message
linuxos
Messages: 31
Registered: April 2009
Member
Most websites tell us to create a oratab file and set to runlevel, but I just find adding entries in rc.local easier.

Thank you!

Report message to a moderator

Re: Linux auto start database/listener [message #396037 is a reply to message #395940] Fri, 03 April 2009 10:22 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You do realize what the oratab file does...right ?

Report message to a moderator

Re: Linux auto start database/listener [message #396131 is a reply to message #395852] Sat, 04 April 2009 02:12 Go to previous messageGo to next message
linuxos
Messages: 31
Registered: April 2009
Member
As far as I know, dbora is used to start and stop database/listener by "oracle" user, right?

But I'm not sure the about the run level and Oracle.

Report message to a moderator

Re: Linux auto start database/listener [message #396160 is a reply to message #396131] Sat, 04 April 2009 07:17 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Are you talking about dbora or oratab?

Report message to a moderator

Re: Linux auto start database/listener [message #396176 is a reply to message #395852] Sat, 04 April 2009 11:01 Go to previous messageGo to next message
linuxos
Messages: 31
Registered: April 2009
Member
oratab is a file showing a flag for doing auto db start or not.

dbora is a script file to start the db and listener in certain runlevel, isn't it?

Report message to a moderator

Re: Linux auto start database/listener [message #396178 is a reply to message #396176] Sat, 04 April 2009 11:43 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Correct. oratab is referenced by dbstart, which depending on how you have configured dbora, can be called by dbora.

Since you mentioned "create a oratab file and set to runlevel", I just wanted to ensure the distinction between all those files.

Report message to a moderator

Re: Linux auto start database/listener [message #396253 is a reply to message #395852] Sun, 05 April 2009 21:49 Go to previous messageGo to next message
linuxos
Messages: 31
Registered: April 2009
Member
I found most documents use the method (/etc/init.d/dbora) to start/stop the database.

According to my limited knowledge, I guess the dbora allows the Oracle database to be shut down in a proper procedure when the system runlevel is going into reboot/halt level?

However, setting command in rc.local simply calls the startup. When server is reboot/halt, those Oracle processes will be killed (similar to shutdown abort). This may cause data lose and trigger a recovery process in the next startup.

Am I right?

Report message to a moderator

Re: Linux auto start database/listener [message #396464 is a reply to message #396253] Mon, 06 April 2009 19:20 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Correct, appropriate shutdown is also important. Check Auto start/stop of Oracle on Linux for a script example.

Report message to a moderator

Previous Topic: How to get ip address of host
Next Topic: Installation problem...install/unzip: No such file or directory
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 18:12:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.