- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- ERROR MESSAGE WHEN TRY TO START UP DATABASE
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
тАО02-26-2002 06:38 PM
тАО02-26-2002 06:38 PM
/SBIN/INIT.D/ORACLE DIRECTORY
#!/sbin/sh
#Match ORACLE_HOME with whatever is in oracle/.profile
ORACLE_HOME=/u01/product/9.0.1
ORACLE_OWNER=oracle
case $1 in
start)
su - oracle -c $ORACLE_HOME/bin/dbstart
su - oracle -c "$ORACLE_HOME/bin/lsnrctl start"
exit 0
;;
stop)
su - oracle -c "$ORACLE_HOME/bin/lsnrctl stop"
su - oracle -c $ORACLE_HOME/bin/dbshut
;;
esac
hERE IS WHAT I DID
LOGIN AS ROOT
SU - ORACLE
/SBIN/INIT.D/ORACLE START
AND I GOT THIS ERROR MESSAGE
su: /u01/product/9.0.1/bin/lsnrctl: not found.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2002 06:47 PM
тАО02-26-2002 06:47 PM
SolutionIn the first place, "/sbin/init.d/oracle start" should be executed as root because the "su - oracle" commands are already residing in the startup script.
# id -un
root
# /sbin/init.d/oracle start
If that still fails, check that the pathname specified is correct:
# ll /u01/product/9.0.1/bin/lsnrtcl
To find the binary,
# find /u01 -name lsnrctl -print
Hope this helps. Regards.
Steven Sim Kok Leong
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2002 07:23 PM
тАО02-26-2002 07:23 PM
Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE
I fix the script by doing the following
echo $ORACLE_HOMe
/u01
so i fix it ORACLE_HOME ...
now when i run /sbin/init.d/oracle start
it gives me this error
Starting /u01/bin/tnslsnr: please wait...
TNSLSNR for HPUX: Version 9.0.1.0.0 - Production
System parameter file is /u01/network/admin/listener.ora
Log messages written to /u01/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
HPUX Error: 226: Address already in use
Listener failed to start. See the error message(s) above...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2002 07:27 PM
тАО02-26-2002 07:27 PM
Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE
Try su with the absolute path. Use /usr/bin/su in place of su.
Hope this helps.
Regds
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2002 07:30 PM
тАО02-26-2002 07:30 PM
Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE
Your listener seems to have already been started. Stop your listener before restarting it:
oracle> $ORACLE_HOME/bin/lsnrctl stop LISTENER_NAME
oracle> $ORACLE_HOME/bin/lsnrctl start
To verify whether it has been started, try either connecting via sqlnet or just telnet to the Oracle port (default is 1521) to see if the port has already been bound:
# telnet localhost 1521
Trying...
Connected to localhost.
...
You should see "Connected".
Also, you can use tnsping to verify the health of your listener over the network.
# $ORACLE_HOME/bin/tnsping $ORACLE_SID
Hope this helps. Regards.
Steven Sim Kok Leong.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2002 07:34 PM
тАО02-26-2002 07:34 PM
Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE
Since you have not indicated a specific listener to start, you can omit LISTENER_NAME ie.
oracle> $ORACLE_HOME/bin/lsnrctl stop
oracle> $ORACLE_HOME/bin/lsnrctl start
You need to ensure that the oracle listener has already been stopped before attempting to start it via your startup script.
Also, the following will give indication of whether the the listener process is running:
# ps -fae|grep tnslsnr
Hope this helps. Regards.
Steven Sim Kok Leong
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2002 07:49 PM
тАО02-26-2002 07:49 PM
Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE
so i did this
/sbin/init.d/oracle stop
ps -ef | grep ora
no processor
so i start up again
/sbin/init.d/oracle start
and it returns by saying the command is successful ...
Thank you all very much for your help...
***MY NEXT QUESTION IS
i LOST THE PASSWORD AND ADMINT FOR DATABASE I CAN'T SEEM TO CONNECT TO SQLPLUS WITHOUT THE PASSWORD...AND I CAN'T FIND SVRMGRL EITHER..EVEN USING THE ABSOLUTE PATH...??? I NEED HELP..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2002 07:56 PM
тАО02-26-2002 07:56 PM
Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE
With regard to your question on svrmgrl, on the server, do this
# find / -name svrmgrl -print
Hope this helps. Regards.
Steven Sim Kok Leong