-
The following commands I give after logging in as root
su -c user1
lsnrctl
start listener1
exit
svrmgrl
connect internal
startup
exit
lsnrctl
start listener2
exit
cd /home/app/oracle/admin/xxx/scripts
./ap.sh start all
exit
su -c user2
cd /home/app/oracle/1103/admin/xxx/scripts
./apcm.sh start
./apfrm.sh start
Now the question is whether I can automate this? The OS is Sun Sparc Solaris 2.6, Oracle 8.0.5 and Oracle Applications 11.0.3.
I tried but failed. Can u help please?
Thanks.
With regards.
-
Type in command line 'crontab -e'
and insert line like that:
00 8-20 * * * su -l oracle --command="/home/oracle/shell/recync.sh"
where 00 - minutes, 8-20 - hours, ...
Read that:
http://www.nvision.com/support/unix/...x/crontab.html
Best wishes!
-
Hi
You can surely automate these tasks to come up when the system comes up.You will need to write a shell script and put all the commands and test it to doulbe check weather it is performing the task.After performing the above task you will have to copy the above file to the following directory
/etc/init.d
Name the file as
S100nameofthefile
The letters S is used to execute the file during startup and the no 100 is the sequence in which the files should be executed
Hope this helped
Regards
Santosh
-
Thanks for the response.
The problem is in writing a script for these tasks.
When the first line "su -c user1" is executed then is goes in and stands still. How to make it use the next line in the script? i.e., LSNRCTL
-
Hi
Why are you Invoking the listener twice beacause whatever no of listener services you create they are all in listener.ora file so thru one command you should be able to start all the services in the listener.ora file and that is
lsnrctl start
Why dont you try the following code
su -c user1
lsnrctl start
svrmgrl @first.sql
cd /home/app/oracle/admin/xxx/scripts
./ap.sh start all
exit
su -c user2
cd /home/app/oracle/1103/admin/xxx/scripts
./apcm.sh start
./apfrm.sh start
Create the following file and remember to input the exact path in ur script file
first.sql
connect internal
startup;
exit
Hope this helps
Regards
Santosh
-
Thanks for the effort!
Thanks for the help.
After logging in as root...
# pwd
/
I ran the script
# ./home/app/oracle/admin/xxx/scripts/back/ssstart.sh
Sun Microsystems Inc. SunOS 5.6 Generic August 1997
$
It comes to the prompt as above and stop there, how to make it continue the execution of the script?
When I type exit at the prompt the result is as follows...
$ exit
./home/app/oracle/admin/xxx/scripts/back/ssstart.sh: lsnrctl: not found
./home1/app/oracle/admin/VIS/scripts/back/ssstart.sh: svrmgrl: not found
Any more ideas? Thanks.
With regards.
-
check your oracle environment, e.g. path, it should point $OH/bin, oracle_home, sid...
-
Yeah you'll need to make sure the script sets up all the required environment variables, if you run it yourself your environment might already be set up, but when crontab runs it, nothing is.
-
The actual problem is ...
Thanks for the info.
But, the problem I'm facing is that after loggging in as dba user(user1) the script does not continue to execute! How to make the script continue to execute after logging in?
The reason the errors svrmgrl, lsnrctl not found comes is, as nothing happens after logging in as dba user(user1), I type exit at the prompt and so it comes to root n continues to execute the script and gives these error.
THE PROBLEM NOW IS 'HOW TO MAKE THE SCRIPT CONTINUE TO EXECUTE AFTER LOGGING IN'
Thanks.
With regards.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|