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
Old 03-30-2005
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

 

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... (1 Reply)
Discussion started by: boss
1 Replies

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... (2 Replies)
Discussion started by: Sachin Vaidya
2 Replies

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:... (6 Replies)
Discussion started by: bernard12
6 Replies

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... (0 Replies)
Discussion started by: solaris_user
0 Replies

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... (0 Replies)
Discussion started by: Agupte
0 Replies

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... (2 Replies)
Discussion started by: alexcol
2 Replies
getusershell(3C)					   Standard C Library Functions 					  getusershell(3C)

NAME
getusershell, setusershell, endusershell - get legal user shells SYNOPSIS
#include <unistd.h> char *getusershell(void); void setusershell(void); void endusershell(void); DESCRIPTION
The getusershell() function returns a pointer to a legal user shell as defined by the system manager in the file /etc/shells. If /etc/shells does not exist, the following locations of the standard system shells are used in its place: /bin/bash /bin/csh /bin/jsh /bin/ksh /bin/ksh93 /bin/pfcsh /bin/pfksh /bin/pfsh /bin/sh /bin/tcsh /bin/zsh /sbin/jsh /sbin/pfsh /sbin/sh /usr/bin/bash /usr/bin/csh /usr/bin/jsh /usr/bin/ksh /usr/bin/ksh93 /usr/bin/pfcsh /usr/bin/pfksh /usr/bin/pfsh /usr/bin/sh /usr/bin/tcsh /usr/bin/zsh /usr/sfw/bin/zsh /usr/xpg4/bin/sh The getusershell() function opens the file /etc/shells, if it exists, and returns the next entry in the list of shells. The setusershell() function rewinds the file or the list. The endusershell() function closes the file, frees any memory used by getusershell() and setusershell(), and rewinds the file /etc/shells. RETURN VALUES
The getusershell() function returns a null pointer on EOF. BUGS
All information is contained in memory that may be freed with a call to endusershell(), so it must be copied if it is to be saved. NOTES
Restricted shells should not be listed in /etc/shells. SunOS 5.11 1 Nov 2007 getusershell(3C)
All times are GMT -4. The time now is 02:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy