Sponsored Content
Operating Systems Solaris How to start Oracle database automatically Post 67606 by RTM on Thursday 24th of March 2005 11:55:41 AM
Old 03-24-2005
This works on one of the servers running Oracle - you may have to change it to suit your needs.

Code:
#!/bin/sh
ORA_HOME=/u01/app/oracle/product/8.0.5
if [ ! -f $ORA_HOME/bin/dbstart -o ! -d $ORA_HOME ]
then
echo "Oracle startup: annot start"
exit
fi
case "$1" in
  'start')
# start Oracle databases
su - oracle -c $ORA_HOME/bin/dbstart
su - oracle -c "$ORA_HOME/bin/lsnrctl start "
;;
'stop')
# stop Oracle databases
su - oracle -c "$ORA_HOME/bin/lsnrctl stop "
su - oracle -c $ORA_HOME/bin/dbshut
;;
esac

 

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
MAKE-SQLDEVELOPER-PACKAGE(1)			    Oracle SQL Developer Debian package builder 		      MAKE-SQLDEVELOPER-PACKAGE(1)

NAME
make-sqldeveloper-package - Oracle SQL Developer Debian package builder SYNOPSIS
make-sqldeveloper-package [options] <file> DESCRIPTION
make-sqldeveloper-package is a utility that builds a Debian package for Oracle SQL Developer. The Oracle SQL Developer program is governed by the copyright holder (Oracle USA, Inc.), so you may be limited as to what you can do with the resulting package (i.e. no redistribution, etc). This utility will simply help you create the Debian package, it is your responsibility to use the resulting package acordingly with the OTN license, a copy of which is included in the created package, that you must agree on when downloading the source. This utility will require you to download the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technet- work/developer-tools/sql-developer/> to create the Debian package from. OPTIONS
-b|--build-dir <dir> base directory to build package (autogenerated) -e|--email <email> local maintainer email (use DEBEMAIL or auto-generate) -i|--install install the generated package - needs root privilege (no) -k|--keep-dir keep the build directory (no) -l|--revision <number> local revision to append to package version (1) -m|--maintainer <name> local maintainer name (use DEBFULLNAME or leave empty) -r|--root-command <command> command to gain root privilege for package build (fakeroot) -u|--upstream-version <version> force the upstream version (autodetected) -h|--help display the help screen -v|--version show the program version <file> the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technetwork/developer-tools/sql-developer/> AUTHOR
make-sqldeveloper-package was written by Lazarus Long <lazarus.long@bigfoot.com>. This manual page was written by Lazarus Long <lazarus.long@bigfoot.com>, for the Debian project (but may be used by others). GNU
2012-11-13 MAKE-SQLDEVELOPER-PACKAGE(1)
All times are GMT -4. The time now is 12:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy