LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 04-20-2014, 12:06 PM   #1
thiyagusham
Member
 
Registered: Apr 2012
Posts: 213

Rep: Reputation: Disabled
Shell script cannot startup my instance ..


Hi All;

I tried to write shell scripts.
It's for local use.
whenever i execute my 10g database env file , automatically my db should be up.

PHP Code:
export ORACLE_BASE=/u01/app/oracle;
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export ORACLE_HOME
export ORACLE_SID
=orcl;
export PATH=/usr/sbin:$PATH;
export PATH=$ORACLE_HOME/bin:$PATH;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export LD_LIBRARY_PATH
export CLASSPATH
=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
export EDITOR=vi
sqlplus 
/ as sysdba
sqlplus startup 
$ . ./ora10.env

PHP Code:
SQL*PlusRelease 10.2.0.5.0 Production on Sun Apr 20 21:34:55 2014

Copyright 
(c19822010Oracle.  All Rights Reserved.

Connected to an idle instance
but i cannot startup my instance . why ?
 
Old 04-20-2014, 05:38 PM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,926

Rep: Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690
Quote:
Originally Posted by thiyagusham View Post
Hi All;
I tried to write shell scripts. It's for local use. whenever i execute my 10g database env file , automatically my db should be up.
PHP Code:
export ORACLE_BASE=/u01/app/oracle;
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export ORACLE_HOME
export ORACLE_SID
=orcl;
export PATH=/usr/sbin:$PATH;
export PATH=$ORACLE_HOME/bin:$PATH;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export LD_LIBRARY_PATH
export CLASSPATH
=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
export EDITOR=vi
sqlplus 
/ as sysdba
sqlplus startup 
$ . ./ora10.env
PHP Code:
SQL*PlusRelease 10.2.0.5.0 Production on Sun Apr 20 21:34:55 2014
Copyright 
(c19822010Oracle.  All Rights Reserved.
Connected to an idle instance
but i cannot startup my instance . why ?
You've said previously that you're an Oracle DBA, with years of experience, and have been posting Oracle related questions for at least two years now. You've been told in that time:
  • Oracle 10g is OLD
  • You need to first do research on your own...like reading the Oracle documentation
  • Contact Oracle support, since Oracle is a commercial, pay-for product.
Given these things, there are MANY hints that can help you. This problem can have one of several solutions, depending on the error code. As an 'experienced DBA', this should be obvious. Also, a DBA with several years of experience with Oracle, and someone who is also TRAINING OTHERS, should be able to see the 'error'.

Hint: you are CONNECTED to Oracle...but you have not yet bothered to open a database. Please read the SQLPlus basics documents:
http://docs.oracle.com/cd/B19306_01/...b14357/toc.htm
http://docs.oracle.com/cd/B19306_01/...4231/start.htm

Last edited by TB0ne; 04-21-2014 at 03:37 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
in bash shell how to run shell script during startup rammohan04 Red Hat 2 07-31-2009 03:07 AM
Adding a shell script to startup Dakkar SUSE / openSUSE 3 10-15-2005 09:00 AM
Exectuing Shell Script on Gnome Startup lloracle_dba Linux - Software 4 05-03-2005 04:32 PM
auto execute shell script on startup slackwbas Slackware 9 02-27-2005 11:26 AM
what shell script runs only at bootup/startup pwhitey86 Mandriva 2 12-22-2004 11:13 PM


All times are GMT -5. The time now is 04:48 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration