RE: Auto start up of databases

RE: Auto start up of databases

 

  

oratab is a Unix File, which contains comments and datalines consisting
entries
in this format
ZAK2:/oradatazak2/oracle/920:Y
the Y tells the OS that the database should automatically startup at the
boot time

this is a script i used to use to automatically start my database



ORACLE_SID=ZAK2
export ORACLE_SID
sqlplus /nolog <<EOF
conn sys/sys as sysdba
startup pfile = '/oradatazak2/oracle/920/dbs/initZAK2.ora'
exit
EOF

and i had a script in the /etc/rc3.d to execute the startup file

ora9i -c "//oradatazak2/dbstartup"

cheers
> i think thos are set up with oracle install.
>
> you need to edit your oratab file
> /var/opt/oracle/oratab
> or
> /etc/oratab
> could be somewhere else
>
>
>
> -----Original Message-----
> From: nitin
> [mailto:oracledba-ezmlmshield-x59638714.[Email address protected]
> Sent: Monday, February 27, 2006 7:36 AM
> To: LazyDBA Discussion
> Subject: Auto start up of databases
>
> Hi gurus,
> do I need to make any changes to any of the file (like inittab or any
> other file in init.d) when i configure dbstart and dbshut on Solaris? I
> am using 9.2.0.1.
>
>
> Nitin
>
>
> Notice: The information contained in this e-mail message and/or
> attachments to it may contain confidential or privileged information. If
> you are not the intended recipient, any dissemination, use, review,
> distribution, printing or copying of the information contained in this
> e-mail message and/or attachments to it are strictly prohibited. If you
> have received this communication in error, please notify us by reply
> e-mail or telephone and immediately and permanently delete the message
> and any attachments. Thank you
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
> see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com By using this list you agree
> to these terms:http://www.lazydba.com/legal.html
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>





Oracle LazyDBA home page