Operating System - HP-UX
1748151 Members
3664 Online
108758 Solutions
New Discussion юеВ

Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE

 
SOLVED
Go to solution
Deanna Tran
Frequent Advisor

ERROR MESSAGE WHEN TRY TO START UP DATABASE

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.
7 REPLIES 7
Steven Sim Kok Leong
Honored Contributor
Solution

Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE

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
Deanna Tran
Frequent Advisor

Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE

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...
Sanjay_6
Honored Contributor

Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE

Hi Deanna,

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

Hope this helps.

Regds
Steven Sim Kok Leong
Honored Contributor

Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE

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.
Steven Sim Kok Leong
Honored Contributor

Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE

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
Deanna Tran
Frequent Advisor

Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE

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..
Steven Sim Kok Leong
Honored Contributor

Re: ERROR MESSAGE WHEN TRY TO START UP DATABASE

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