How to start Oracle database automatically Post: 68064

Sponsored Content

Operating Systems Solaris How to start Oracle database automatically Post 68064 by encrypted on Wednesday 30th of March 2005 04:46:06 PM

03-30-2005

Registered User

Tested on Sun Solaris:

Code:

#!/bin/sh

  if [ -d /export/home/oracle/OracleStartScripts ] ; then
        :
  else
        mkdir /export/home/oracle/OracleStartScripts
        chown oracle:oinstall /export/home/oracle/OracleStartScripts
  fi

  echo "\
        ORACLE_BASE=/u01/app/oracle
        ORACLE_HOME=\$ORACLE_BASE/product/8.1.7
        ORACLE_SID=test
        ORA_NLS33=\$ORACLE_HOME/ocommon/nls/admin/data
        PATH=.:\$ORACLE_HOME/bin:opt/bin:/bin:/usr/bin:/usr/ccs/bin:/usr/ucb:/etc/usr/sbin

        export ORACLE_BASE
        export ORACLE_HOME
        export ORACLE_SID
        export NLS_LANG
        export ORA_NLS33
        export PATH

        svrmgrl /nolog <<EOF
        connect internal
        startup
        EOF

        echo starting listner...
        lsnrctl start
        " > /export/home/oracle/OracleStartScripts/StartOra.sh

# 
  echo "\
        ORACLE_BASE=/u01/app/oracle
        ORACLE_HOME=\$ORACLE_BASE/product/8.1.7
        ORACLE_SID=test
        ORA_NLS33=\$ORACLE_HOME/ocommon/nls/admin/data
        PATH=.:\$ORACLE_HOME/bin:opt/bin:/bin:/usr/bin:/usr/ccs/bin:/usr/ucb:/etc/usr/sbin

        export ORACLE_BASE
        export ORACLE_HOME
        export ORACLE_SID
        export NLS_LANG
        export ORA_NLS33
        export PATH

        svrmgrl /nolog <<EOF
        connect internal
        shutdown immediate
        EOF

        echo starting listner...
        lsnrctl stop
        " > /export/home/oracle/OracleStartScripts/StopOra.sh
	
	chown oracle:oinstall /export/home/oracle/OracleStartScripts/StopOra.sh
	chown oracle:oinstall /export/home/oracle/OracleStartScripts/StartOra.sh
	
	chmod +x /export/home/oracle/OracleStartScripts/StopOra.sh
	chmod +x /export/home/oracle/OracleStartScripts/StartOra.sh 

 echo "\
   #!/bin/sh
   # start/Stop oracle Database
   
  case \"\$1\" in
   	'start')
   	# start the database
   	if [ -f /export/home/oracle/OracleStartScripts/StartOra.sh ] ; then
   		echo \"Start Oracle database.\"
   		su -l oracle -c /export/home/oracle/OracleStartScripts/StartOra.sh
   	else
   		echo \"Error! Can't find: /export/home/oracle/OracleStartScripts/StartOra.sh\"
   		echo \"          Oracle could not be Started!\"
   	fi
   	;;
   
  	'stop')
          # Stop the database
          if [ -f /export/home/oracle/OracleStartScripts/StopOra.sh ] ; then
                    echo \"stopping oracle Database.\"
                    su -l oracle -c /export/home/oracle/OracleStartScripts/StopOra.sh
           else
                        echo \"Error! Can't find:/export/home/oracle/OracleStartScripts/StopOra.sh\"
                        echo \"          Oracle could not be Stopped!\"
           fi
           ;;
   esac
                " > /etc/init.d/MYoracle

        chmod +x /etc/init.d/MYoracle

        ln -s /etc/init.d/MYoracle /etc/rc3.d/S99oracle
        ln -s /etc/init.d/MYoracle /etc/rc2.d/K99oracle
        ln -s /etc/init.d/MYoracle /etc/rc1.d/K99oracle
        ln -s /etc/init.d/MYoracle /etc/rc0.d/K99oracle
        ln -s /etc/init.d/MYoracle /etc/rcS.d/K99oracle

encrypted

View Public Profile for encrypted

Find all posts by encrypted

6 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Howto capture data from rs232port andpull data into oracle database-9i automatically

Hi, i willbe very much grateful to u if u help me out.. if i simply connect pbx machine to printer by serial port RS232 then we find this view: But i want to capture this data into database automatically when the pbx is running.The table in database will contain similar to this view inthe...

2. Solaris

Database can't start automatically on solaris

Hi, I have installed oracle 9i on solaris 10 sucessfully. I have configured listener & tnsname.ora file sucessfuly. Even i can start database manully by starting listener first and from sqlplus promt data base sucessfully. Now i want to start the database automatically after system reboots. I...

3. UNIX for Advanced & Expert Users

start some services automatically

Hello All i have a question related to some services,i want to start some services with server linux centos. i make "chkconfig httpd on" and "chkconfig asterisk on",but when i verify with chkconfig --list i found httpd 0: off 1: off 2: on 3: on 4: on 5: on 6:...

4. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General...

5. Shell Programming and Scripting

Running script automatically when threshold limit met in one of the field in oracle database

Hi Guys, Need you help in one point! I am working on one shell script which takes following steps : 1. Taking one query result from oracle database 2. Exporting that result to Xls file 3. Mailing that file to my own mail ID Now, I want to give a threshold limit to one of the column...

6. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL...

LEARN ABOUT OPENSOLARIS

root_archive

root_archive(1M)					  System Administration Commands					  root_archive(1M)

NAME

       root_archive - manage bootable miniroot archives

SYNOPSIS

       /boot/solaris/bin/root_archive  pack archive root

       /boot/solaris/bin/root_archive  unpack archive root

       /boot/solaris/bin/root_archive  packmedia solaris_image root

       /boot/solaris/bin/root_archive  unpackmedia solaris_image root

DESCRIPTION

       The  root_archive  utility  is  used to manage bootable miniroot archives and is currently only available on x86 platforms. The utility can
       pack and unpack boot/root archives in both ufs and hsfs (iso9660) format. It will always generate ufs archives.

       root_archive also uses the lofi file driver to export a file as a block device (see lofi(7D)) and mount to mount or  unmount  file  systems
       and remote resources (see mount(1M)). root_archive requires the same privileges that are needed to run these commands.

SUBCOMMANDS

       The root_archive command has the following subcommands:

       pack archive root    Pack from the image found under the root directory to the archive.

       unpack archive root

	   Unpack from the archive to an unpacked image under the root directory.

       packmedia solaris_image root

	   Pack the solaris image to the root directory.

       unpackmedia solaris_image root

	   Unpack the solaris image from the root directory.

       For  packmedia  and  unpackmedia,  other items that do not go into the ramdisk image are copied or uncopied (see cpio(1)) as well. Specifi-
       cally, this includes all the packaging databases needed for pkgadd and the other packaging utilities to succeed which are not used  in  the
       running and hence pruned to conserve memory.

EXAMPLES

       Example 1 Unpacking the Solaris x86 install image

       The following command unpacks the current Solaris image from the root directory:

	 # root_archive unpackmedia 
	 /export/nv/solarisdvd.nvx_dvd/latest /export/Boot

       Where  /export/nv/solarisdvd.nvx_dvd/latest  represents	a path to a Solaris x86 install image and /export/Boot is a directory that will be
       purged or created, as necessary.

       Example 2 Packing the Solaris x86 install image

       The following command packs the current Solaris image to the root directory:

	 # root_archive packmedia 
	 /export/nv/solarisdvd.nvx_dvd/latest /export/Boot

EXIT STATUS

       The following exit values are returned:

       0    The command completed successfully.

       1    The command exited due to an error.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Stable			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       cpio(1), bootadm(1M), mount(1M), attributes(5), lofi(7D)

SunOS 5.11							    26 Sep 2005 						  root_archive(1M)