topic Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE in Operating System - HP-UX

ERROR MESSAGE WHEN TRY TO START UP DATABASE

Deanna Tran — Wed, 27 Feb 2002 02:38:31 GMT

HERE IS THE SCRIPT THAT i CREATED IN THE
/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.

Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE

Steven Sim Kok Leong — Wed, 27 Feb 2002 02:47:22 GMT

Hi,

In 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

Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE

Deanna Tran — Wed, 27 Feb 2002 03:23:39 GMT

okay....I saw what i did ...
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...

Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE

Sanjay_6 — Wed, 27 Feb 2002 03:27:05 GMT

Hi Deanna,

Try su with the absolute path. Use /usr/bin/su in place of su.

Hope this helps.

Regds

Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE

Steven Sim Kok Leong — Wed, 27 Feb 2002 03:30:13 GMT

Hi,

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.

Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE

Steven Sim Kok Leong — Wed, 27 Feb 2002 03:34:14 GMT

Hi,

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

Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE

Deanna Tran — Wed, 27 Feb 2002 03:49:51 GMT

I think the listener might be running
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..

Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE

Steven Sim Kok Leong — Wed, 27 Feb 2002 03:56:08 GMT

Hi,

With regard to your question on svrmgrl, on the server, do this

# find / -name svrmgrl -print

Hope this helps. Regards.

Steven Sim Kok Leong