- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - Linux
- >
- Re: Problem with haoracle_sql.sh
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2005 08:12 AM
тАО10-27-2005 08:12 AM
We have 2 SLES 9 SP2 server running HP SG/LX A.11.16. We also have installed Oracle Toolkit A.02.10
We try to test the set up to ensure Oracle can be properly brought up following instruction in teh README but we have problem running haoracle_sql.sh
./haoracle_sql.sh: line 133: return: can only `return' from a function or sourced script
Also according to the README we need to log on as oracle but if we run the script when logged on as oracle the script ask for password...
Any idea what go wrong with the script?
Regars,
Eric Bellavance
Ministere des Finances
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2005 08:22 AM
тАО10-27-2005 08:22 AM
Re: Problem with haoracle_sql.sh
echo "Good morning"
return 1
Should be something like:
function(){
echo "Good morning"
return 1
}
Test these scripts and you will see the same error on the first.
I think that if you post the script, more help will be available.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2005 08:26 AM
тАО10-27-2005 08:26 AM
Re: Problem with haoracle_sql.sh
Eric Bellavance
Ministere des Finances
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2005 08:45 AM
тАО10-27-2005 08:45 AM
Solutionstart)
start_oracle
check_status=$?
exit $check_status
;;
abort)
shutdown_oracl
e abort
check_status=$?
exit $check_status
;;
immediate)
shutdown_oracl
e immediate
check_status=$?
exit $check_status
PD: Don't forget to assign points to people that help you in every topic that you made.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2005 09:02 AM
тАО10-27-2005 09:02 AM
Re: Problem with haoracle_sql.sh
Have you been able to run haoracle_sql.sh?
Eric Bellavance
Ministere des Finances
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2005 09:19 AM
тАО10-27-2005 09:19 AM
Re: Problem with haoracle_sql.sh
haoracle_sql.sh start
Other thing, I think that the script should be run as root, because in the script there is a su - oracle, that's why you are prompted for a password.
If you run as root, as service guard should do, the script will then su to oracle and run the commands.
There are a lot of environment variables in this script, I think that you will need to modify further the script.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2005 09:34 AM
тАО10-27-2005 09:34 AM
Re: Problem with haoracle_sql.sh
./haoracle_sql.sh start ${ORACLE_HOME} ${ORACLE_SID}
Effectively the script won't start if we are not the root. The doc say we have to log on as oracle before running the script but we see we cannot do that...
If have move this two lines
command="pfile=$PFILE";
exit_status=1;
just before the line
su - ${ORACLE_ADMIN} <
...and now our oracle db start...
Do you know the meaning of <
Why just moving the 2 lines correct the script?
Regards,
Eric Bellavance
Ministere des Finances
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2005 09:46 AM
тАО10-27-2005 09:46 AM
Re: Problem with haoracle_sql.sh
<< EOF
run this
and this
and this
and this
stop here
EOF
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2005 09:54 AM
тАО10-27-2005 09:54 AM
Re: Problem with haoracle_sql.sh
We understand a little more what the script do...
Eric Bellavance
Ministere des Finances
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2005 07:39 PM
тАО10-27-2005 07:39 PM
Re: Problem with haoracle_sql.sh
I assume this is from the command line, and not from the control script.
I have installed this toolkit at a number of sites, and have had no problems with it.
There is a good README with the toolkit that explains the useage, as well as the manuals at docs.hp.com