02-16-2007
script to start DB didn't work, help
I have created a script to strat and shutdown Oracle 10g DB on Solaris automatically when UNIX reboot. In the begining, it worked well. All of sudden, the dbstart part didn't work, other 3 part for lsnrctl, emctl, isqlplusctl all worked fine. I think it was TNS_ADMIN variable got problem. Because dbstart need to go to /var/opt/oracle/ to find oratab file. In that file there is a line: my_oracle_sid:$ORACLE_HOME:Y. This will indicate that DB should start up when UNIX reboot. Then dbstart utility will work.
I am not sure that my observation is right or not. Please help me to solve this problem. If my guess is right, can I set up TNS_ADMIN variable (TNS_ADMIN=/var/opt/oracle export TNS_ADMIN) in .profile or I have to set it up in my script. Following is the sample of script for your reference.
#!/bin/sh
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
ORACLE_OWNER=oracle
if [ ! -f $ORACLE_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"
exit
fi
case "$1" in
'start') # Start the Oracle database and listener
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart"
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl start"
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/emctl start dbconsole"
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/isqlplusctl start"
;;
I set up TNS_ADMIN in my .profile as above and rebooted the server. All other 3 agents started automatically. I did $ORACLE_HOME/bin/dbstart, the server responded as 'VER10LIST=10: is not an identifier'. So where is the problem? I have another UNIX server running the same script, it worked perfectly. No idea. Please advise.
Last edited by duke0001; 02-16-2007 at 03:04 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I am writing a script to monitor some processes existence in the system. It works perfectly by running the script manually in commend line. However, when I put it under cron to run it failed. Everything time when the variable is null in the if statment. it failed and quitted. Here is... (2 Replies)
Discussion started by: stancwong
2 Replies
2. Shell Programming and Scripting
Hi, everyone:
I post a new thread because previous post may sink and I hope the new one can be caught by your eyes.
I created a shell script and the script works fine. However, the mail program part on script didn't send email to my email box and it also didn't provide any traceable... (7 Replies)
Discussion started by: duke0001
7 Replies
3. UNIX for Dummies Questions & Answers
Hello,
I am learning to debug in sgi-Irix6.5, after a core dump, I was adviced to perform a "strace", but I got the following information:
ERROR: tracer already exists
what shall I do now?
Thanks a lot
Daniel (0 Replies)
Discussion started by: lakeat
0 Replies
4. Solaris
Hi...all
database - 10g Rs 2 with ASM
platform - Sun Solaris V890 64bit
This is the step i use to auto start the database n ASM: (auto start can start but need to kill lsvcrun first)
1 dbora---script
2 start_shutdown_asm.ksh---script
3. Dbora file must be put under /etc/init.d directory... (0 Replies)
Discussion started by: adzuanamir
0 Replies
5. Shell Programming and Scripting
Hi
This is what I was trying to do, comment one line and add something different in a new line right next.
This is the command I want to do
more .profile | sed 's,STRING1, #STRING1 NEWLINE STRING2,'
(I´m using ',' because my string is something like this
exec... (3 Replies)
Discussion started by: alcalina
3 Replies
6. Shell Programming and Scripting
I want to filter 2nd column = 2 using awk
$ cat t
1 2
2 4
$ VAR=2
#variable worked in print
$ cat t | awk -v ID=$VAR ' { print ID}'
2
2
# but variable didn't work in awk filter
$ cat t | awk -v ID=$VAR '$2~/ID/ { print $0}' (2 Replies)
Discussion started by: honglus
2 Replies
7. SCO
Continuing saga of working on making a retail store more robust by creating a backup clone of the main server, a 1995 era :eek: PC running SCO OpenServer 5.0.0b and a discontinued Point of Sales (POS) software system.
I have a PC of the same make and model. The CPU runs faster and it has a... (5 Replies)
Discussion started by: jgt10
5 Replies
8. UNIX for Dummies Questions & Answers
how to emulate aix 5.3
i had try pearpc , but it didn't work ...
someone have some solution?
thanks (1 Reply)
Discussion started by: prpkrk
1 Replies
9. Shell Programming and Scripting
Hello,
Here is my crontab
# Reboot one Sunday out of 2 at 02:00
0 2 * * 0/2 /usr/bin/reboot
2017-04-16
2017-04-23
2017-04-30
and so on
I tested my crontab here, it seems to work
Http://cron.schlitt.info/index.php?c...=100&test=Test
However on my distrib linux mageďa
When I register... (4 Replies)
Discussion started by: amazigh42
4 Replies
10. UNIX for Advanced & Expert Users
Hi,
I am trying to bring down the application gracefully before bringing down AIX OS/LPAR using RC directories.
Issue: Application script is not working properly during/before AIX OS/LPAR shutdown. looks like "rc.d" directories doesn't recognize Kill script.
But Startup script (using... (0 Replies)
Discussion started by: System Admin 77
0 Replies
LEARN ABOUT OPENDARWIN
gzexe
GZEXE(1) General Commands Manual GZEXE(1)
NAME
gzexe - compress executable files in place
SYNOPSIS
gzexe [ name ... ]
DESCRIPTION
The gzexe utility allows you to compress executables in place and have them automatically uncompress and execute when you run them (at a
penalty in performance). For example if you execute ``gzexe /bin/cat'' it will create the following two files:
-r-xr-xr-x 1 root bin 9644 Feb 11 11:16 /bin/cat
-r-xr-xr-x 1 bin bin 24576 Nov 23 13:21 /bin/cat~
/bin/cat~ is the original file and /bin/cat is the self-uncompressing executable file. You can remove /bin/cat~ once you are sure that
/bin/cat works properly.
This utility is most useful on systems with very small disks.
OPTIONS
-d Decompress the given executables instead of compressing them.
SEE ALSO
gzip(1), znew(1), zmore(1), zcmp(1), zforce(1)
CAVEATS
The compressed executable is a shell script. This may create some security holes. In particular, the compressed executable relies on the
PATH environment variable to find gzip and some other utilities (tail, chmod, ln, sleep).
BUGS
gzexe attempts to retain the original file attributes on the compressed executable, but you may have to fix them manually in some cases,
using chmod or chown.
GZEXE(1)