- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 10g Not starting automatically
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
тАО12-08-2005 10:56 PM
тАО12-08-2005 10:56 PM
Oracle 10g Not starting automatically
* System is HPUX 11.23 with Oracle 10g
I am unable to make the Oracle autostart during system boot. It was working before ..I dont how Oracle instance got suddenly stopped starting, automatically. But the listener starts automatically.
I am able to start oracle and listener manually but not during automatically during system boot.
startup & shutdown scripts are there in the system. Startup script is /sbin/rc2.d/S990oracle.
Any idea where I need to look at..
Many thanks in advance.
Regards,
Syam
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2005 10:58 PM
тАО12-08-2005 10:58 PM
Re: Oracle 10g Not starting automatically
-Arun
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2005 11:04 PM
тАО12-08-2005 11:04 PM
Re: Oracle 10g Not starting automatically
If so, is it set to autostart in there?
What does the /etc/rc.log say for this script at system boot time?
What do the Oracle logs say?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2005 11:05 PM
тАО12-08-2005 11:05 PM
Re: Oracle 10g Not starting automatically
I have checked all log files mentioned in the startup scripts..Main problem is that I am neither getting any errors during system startup nor in the log files.
Can any one tell me which all the log files I need to look apart from the user defined log files.
Regards
Syam
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2005 11:19 PM
тАО12-08-2005 11:19 PM
Re: Oracle 10g Not starting automatically
In oracle 9 there used to be a file "oratab" in which you have make the control variable from N to Y in the corresponding database instance.
Could you find for this file and try.
I Hope it will be problem
With Regards,
Siva.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2005 11:25 PM
тАО12-08-2005 11:25 PM
Re: Oracle 10g Not starting automatically
Kill soff linke
/sbin/init.d/rc2.d
Starting the database at run level 3 is not neeeded.
The soft link should point to a start script in /sbin/init.d/
This script must have a start and stop section in the same syntax as /etc/init.d/template
Back in my Oracle 9 days I always had to do this myself on HP-UX. I was surprised on Linux to see the oracle install do this stuff all by itself on 10g.
The /etc/oratab stuff is important and will prevent the database from starting even if everything else is okay.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2005 11:43 PM
тАО12-08-2005 11:43 PM
Re: Oracle 10g Not starting automatically
Thaks for all our replies.
Burnard,
My listener is starting from the same script. Only the oracle instance is not starting. that means there is no problem with the awitch file in /etc/rc.config.d. Still I checked the file /etc/rc.confi.d/oracle. The ORACLE_START=1 is present there.
Sivakumar,
Oratab we have already checked and its fine. It is set to Y.
SEP,
I had already tried copying the /sbin/rc2.d/S990oracle to /sbin/rc3.d/S990oracle. It is not working.
I feel that rc.x directories are in /sbin and not in /sbin/init.d
My problem is during the startup it reads the startup script /sbin/rc2.d/S990oracle but only the oracle instance startup part is not working.
If required I can post all the required script file for your reference.
Thanks once agin for your replies.
Thank you
Syam
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-09-2005 03:38 AM
тАО12-09-2005 03:38 AM
Re: Oracle 10g Not starting automatically
could you post the script ?
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-09-2005 05:52 PM
тАО12-09-2005 05:52 PM
Re: Oracle 10g Not starting automatically
can you also post the part from your /etc/rc.log which shows information about the Oracle Startup process?
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-12-2005 03:20 AM
тАО12-12-2005 03:20 AM
Re: Oracle 10g Not starting automatically
I think your problem may be in the /sbin/init.d/dbora script to witch the S990oracle link points. Here is my script:
ORA_HOME=/...
ORA_OWNER=oracle
SCRIPT_PATH=/...
case "$1" in
'start')
echo "Oracle starting..."
/bin/su - $ORA_OWNER -c $SCRIPT_PATH/start_boot.sh
;;
'stop')
echo "Oracle stoping..."
/bin/su - $ORA_OWNER -c $SCRIPT_PATH/stop_boot.sh
;;
And $SCRIPT_PATH/start_boot.sh and $SCRIPT_PATH/stop_boot.sh:
ORA_ENVFILE="/.../
DB_NAME="
ORACLE_SID="
export ORACLE_SID
sqlplus << EOT
connect / as sysdba;
startup; -- for start_boot.sh
shutdown immediate; -- for stop_boot.sh
exit
EOT
Best Regards,
Eric Antunes