Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Command not found

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Command not found
# 1  
Old 01-08-2008
Command not found
I ran the following script and it saying that sqlplus command not found. Please give me suggestions.

echo `date +%c` >> $LOG_FILE
echo "Database BACKUP starting." >> $LOG_FILE
ORACLE_HOME=/u01/app/oracle/product/10.2; export ORACLE_HOME
ORACLE_SID=SEED; export ORACLE_SID
PATH="$PATH:$ORACLE_HOME/bin"
sqlplus '/as sysdba' << EOF
shutdown immediate
exit EOF
if [ $? -eq 0 ]
then
echo "Database shut down." >> $LOG_FILE
echo "Previous Backup is being removed." >> $LOG_FILE
touch /u03/backups/abu/junk/ rm /u03/backups/abu/*

echo "Cold backup being performed." >> $LOG_FILE
cp -p -f -v /u01/oracle/admin/SEED/* /u03/backups/abu/nightly_backup/
cp -p -f -v /u02/oradata/SEED/* /u03/backups/abu/nightly_backup/
cp -p -f -v /u03/oradata/SEED/* /u03/backups/abu/nightly_backup/

echo "Cold backup of archive logs being performed." >> $LOG_FILE
mv -f -v /u01/app/oracle/product/10.2/dbs/arch/* /u03/backups/abu/nightly_backup/

echo "Restarting Database" >> $LOG_FILE
ORACLE_SID=SEED; export ORACLE_SID
$ORACLE_HOME/bin/sqlplus '/as sysdba' << EOF
startup
exit
EOF

if [ $? -eq 0 ]
then
echo "Database started up." >> $LOG_FILE
else
echo "Database will NOT start up." >> $LOG_FILE
fi

echo `date +%c` >> $LOG_FILE
echo "Database BACKUP has completed." >> $LOG_FILE
# 2  
Old 01-08-2008
Use code tags for code, it is in your own interest. Many poeple will not even read your post if you do not.
# 3  
Old 01-08-2008
echo `date +%c` >> $LOG_FILE
echo "Database BACKUP starting." >> $LOG_FILE
ORACLE_HOME=/u01/app/oracle/product/10.2; export ORACLE_HOME
ORACLE_SID=SEED; export ORACLE_SID
PATH="$PATH:$ORACLE_HOME/bin"
sqlplus '/as sysdba' << EOF
shutdown immediate
exit EOF
if [ $? -eq 0 ]
then
echo "Database shut down." >> $LOG_FILE
echo "Previous Backup is being removed." >> $LOG_FILE
touch /u03/backups/abu/junk/ rm /u03/backups/abu/*

echo "Cold backup being performed." >> $LOG_FILE
cp -p -f -v /u01/oracle/admin/SEED/* /u03/backups/abu/nightly_backup/
cp -p -f -v /u02/oradata/SEED/* /u03/backups/abu/nightly_backup/
cp -p -f -v /u03/oradata/SEED/* /u03/backups/abu/nightly_backup/

echo "Cold backup of archive logs being performed." >> $LOG_FILE
mv -f -v /u01/app/oracle/product/10.2/dbs/arch/* /u03/backups/abu/nightly_backup/

echo "Restarting Database" >> $LOG_FILE
ORACLE_SID=SEED; export ORACLE_SID
$ORACLE_HOME/bin/sqlplus '/as sysdba' << EOF
startup
exit
EOF

if [ $? -eq 0 ]
then
echo "Database started up." >> $LOG_FILE
else
echo "Database will NOT start up." >> $LOG_FILE
fi

echo `date +%c` >> $LOG_FILE
echo "Database BACKUP has completed." >> $LOG_FILE
Quote:
Originally Posted by manna
I ran the following script and it saying that sqlplus command not found. Please give me suggestions.

echo `date +%c` >> $LOG_FILE
echo "Database BACKUP starting." >> $LOG_FILE
OORACLE_HOME=/u01/app/oracle/product/10.2; export ORACLE_HOME
ORACLE_SID=SEED; export ORACLE_SID
PATH="$PATH:$ORACLE_HOME/bin"
sqlplus '/as sysdba' << EOF
startup
exit EOF
if [ $? -eq 0 ]
then
echo "Database shut down." >> $LOG_FILE
echo "Previous Backup is being removed." >> $LOG_FILE
touch /u03/backups/abu/junk/ rm /u03/backups/abu/*

echo "Cold backup being performed." >> $LOG_FILE
cp -p -f -v /u01/oracle/admin/SEED/* /u03/backups/abu/nightly_backup/
cp -p -f -v /u02/oradata/SEED/* /u03/backups/abu/nightly_backup/
cp -p -f -v /u03/oradata/SEED/* /u03/backups/abu/nightly_backup/

echo "Cold backup of archive logs being performed." >> $LOG_FILE
mv -f -v /u01/app/oracle/product/10.2/dbs/arch/* /u03/backups/abu/nightly_backup/

echo "Restarting Database" >> $LOG_FILE
ORACLE_SID=SEED; export ORACLE_SID
$ORACLE_HOME/bin/sqlplus '/as sysdba' << EOF
startup
exit
EOF

if [ $? -eq 0 ]
then
echo "Database started up." >> $LOG_FILE
else
echo "Database will NOT start up." >> $LOG_FILE
fi

echo `date +%c` >> $LOG_FILE
echo "Database BACKUP has completed." >> $LOG_FILE
# 4  
Old 01-08-2008
You need to export that PATH variable for it to be used.
As reborg says, use CODE tags - it makes it much easier to read scripts etc as it protects formatting and prevents linewrapping etc.

[
Code:
]

your script

[

]

(but only one set or brackets instead of the two I've shown above)
# 5  
Old 01-08-2008
Quote:
Originally Posted by manna
echo `date +%c` >> $LOG_FILE
You don't need the echo command here either BTW, just run:
date +%c >> $LOG_FILE

Saves time when executing.
# 6  
Old 01-08-2008
Hi all experts,

I used rman=/ but still it says that not file and directory.
echo `date +%c` >> $LOG_FILE
echo "Database BACKUP starting." >> $LOG_FILE
ORACLE_HOME=/u01/app/oracle/product/10.2; export ORACLE_HOME
ORACLE_SID=SEED; export ORACLE_SID
PATH="$PATH:$ORACLE_HOME/bin"
rman target=/ << EOF
shutdown immediate
exit EOF
if [ $? -eq 0 ]
then
echo "Database shut down." >> $LOG_FILE
echo "Previous Backup is being removed." >> $LOG_FILE
touch /u03/backups/abu/junk/ rm /u03/backups/abu/*

echo "Cold backup being performed." >> $LOG_FILE
cp -p -f -v /u01/oracle/admin/SEED/* /u03/backups/abu/nightly_backup/
cp -p -f -v /u02/oradata/SEED/* /u03/backups/abu/nightly_backup/
cp -p -f -v /u03/oradata/SEED/* /u03/backups/abu/nightly_backup/

echo "Cold backup of archive logs being performed." >> $LOG_FILE
mv -f -v /u01/app/oracle/product/10.2/dbs/arch/* /u03/backups/abu/nightly_backup/

echo "Restarting Database" >> $LOG_FILE
ORACLE_HOME=/u01/app/oracle/product/10.2; export ORACLE_HOME
ORACLE_SID=SEED; export ORACLE_SID
PATH="$PATH:$ORACLE_HOME/bin"
rman target=/ << EOF
startup
exit
EOF

if [ $? -eq 0 ]
then
echo "Database started up." >> $LOG_FILE
else
echo "Database will NOT start up." >> $LOG_FILE
fi

echo `date +%c` >> $LOG_FILE
echo "Database BACKUP has completed." >> $LOG_FILE


Quote:
Originally Posted by manna
echo `date +%c` >> $LOG_FILE
echo "Database BACKUP starting." >> $LOG_FILE
ORACLE_HOME=/u01/app/oracle/product/10.2; export ORACLE_HOME
ORACLE_SID=SEED; export ORACLE_SID
PATH="$PATH:$ORACLE_HOME/bin"
sqlplus '/as sysdba' << EOF
shutdown immediate
exit EOF
if [ $? -eq 0 ]
then
echo "Database shut down." >> $LOG_FILE
echo "Previous Backup is being removed." >> $LOG_FILE
touch /u03/backups/abu/junk/ rm /u03/backups/abu/*

echo "Cold backup being performed." >> $LOG_FILE
cp -p -f -v /u01/oracle/admin/SEED/* /u03/backups/abu/nightly_backup/
cp -p -f -v /u02/oradata/SEED/* /u03/backups/abu/nightly_backup/
cp -p -f -v /u03/oradata/SEED/* /u03/backups/abu/nightly_backup/

echo "Cold backup of archive logs being performed." >> $LOG_FILE
mv -f -v /u01/app/oracle/product/10.2/dbs/arch/* /u03/backups/abu/nightly_backup/

echo "Restarting Database" >> $LOG_FILE
ORACLE_SID=SEED; export ORACLE_SID
$ORACLE_HOME/bin/sqlplus '/as sysdba' << EOF
startup
exit
EOF

if [ $? -eq 0 ]
then
echo "Database started up." >> $LOG_FILE
else
echo "Database will NOT start up." >> $LOG_FILE
fi

echo `date +%c` >> $LOG_FILE
echo "Database BACKUP has completed." >> $LOG_FILE
# 7  
Old 01-08-2008
Quote:
Originally Posted by Smiling Dragon
You need to export that PATH variable for it to be used.
Have you tried this yet?
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

Ar command not found

Hi all, ar command not found on Solaris 10 version. We can execute under ./ar command /usr/ccs/bin directory. However, we want to execute ar command anywhere. We add to /usr/ccs/bin entry under /etc/profile file shown as below. umask 002 trap 2 3 ... (2 Replies)
Discussion started by: ziosnim
2 Replies

2. Shell Programming and Scripting

Want to terminate command execution when string found in the command output

Hi Experts, I am very much new to linux scripting, I am currently working on reducing my manual work and hence writing a script to automate few task. I am running below command to snmpwalk the router.. snmpwalk -v 3 -u WANDL_SU -a MD5 -A vfipmpls -x DES -X VfIpMpLs -l authPriv... (19 Replies)
Discussion started by: Hanumant.madane
19 Replies

3. Shell Programming and Scripting

When i am trying to execute export command within a shell script it is saying command not found.

I am running the export command within a view to use that value inside my build script. But while executing it it is saying "export command not found" My code is as follows: -------------------------- #!/bin/sh user="test" DIR="/bldtmp/"$user VIEW="test.view1" echo "TMPDIR before export... (4 Replies)
Discussion started by: dchoudhury
4 Replies

4. Homework & Coursework Questions

Command not found

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: Trying to run script but everytime I do I get teh following error message line 4: I have attempted... (5 Replies)
Discussion started by: tbear808
5 Replies

5. Shell Programming and Scripting

bash: <command nm> command not found

I created a script that I need to run from time to time, but get this error message. To get it working again I run this command from time to time: export PATH="$PATH:~/scripts" I put all my automated scripts in the /scripts directory and would like to run my scripts from any directory... (5 Replies)
Discussion started by: catalinawinemxr
5 Replies

6. Solaris

for: command not found

I have installed Solaris recently. I was doing "for file in *.c; ...." at the command prompt, it says for: command not found. I tried changing shells, but still wouldn't work. Any ideas? (7 Replies)
Discussion started by: software2007
7 Replies

7. Shell Programming and Scripting

Always getting command not found

I'm using Terminal in MAC OS X, and new to this. I don't know what happened to the path. I always get "command not found". For example, this is some of what I get: -bash: ls: command not found -bash: touch: command not found What should I do to return the terminal to normal? ... (0 Replies)
Discussion started by: Abder-Rahman
0 Replies

8. UNIX for Dummies Questions & Answers

Command not found

Hi guys, I do apologise if this question has been asked before. I am currently running Solaris 10 on a x86 architecture. Now, the problem I am having relates to the issuing of commands, for example if I am trying to find out the ipaddress of the machine I would issue the command 'ipconfig -a |... (2 Replies)
Discussion started by: BigTool4u2
2 Replies

9. UNIX for Dummies Questions & Answers

cc command not found

i installed x windows redhat linux 9.0 in my pc. but the problem is when i run cc command for c programme .....bash:cc: command not found printed ...........i set the path for bash ............with the help of PATH=$PATH....................still it is not working .........please guide me. (4 Replies)
Discussion started by: mishra_sk_in
4 Replies

10. Shell Programming and Scripting

how can i check in csh if command found or not found ?

hello all im trying to use in sun Solaris the information received from the top command now i several machines that dont have install the top program so when im running the script im geting error saying after im running this code : set MemoryInfo = `top | grep Memory` if (... (2 Replies)
Discussion started by: umen
2 Replies
Login or Register to Ask a Question