Oracle – Linux – Network

1. create script status listener
[oracle@mkt ~]$ cd $ORACLE_HOME/bin
[oracle@mkt bin]$ vi statuslsnr
#!/bin/sh
# Start the oracle listener
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1
export ORACLE_SID=mkt
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export ORACLE_SID=ubs
export ORACLE_TERM=xterm
$ORACLE_HOME/bin/lsnrctl status
exit 0

[oracle@mkt ~]$ chmod u+x statuslsnr

2. create script start listener
[oracle@mkt ~]$ cd $ORACLE_HOME/bin
[oracle@mkt bin]$ vi startlsnr
#!/bin/sh
# Start the oracle listener
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1
export ORACLE_SID=mkt
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export ORACLE_SID=ubs
export ORACLE_TERM=xterm
$ORACLE_HOME/bin/lsnrctl start
exit 0

[oracle@mkt bin]$ chmod u+x startlsnr

3. create script stop listener
[oracle@mkt ~]$ cd $ORACLE_HOME/bin
[oracle@mkt bin]$ vi stoplsnr
#!/bin/sh
# Start the oracle listener
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1
export ORACLE_SID=mkt
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export ORACLE_SID=ubs
export ORACLE_TERM=xterm
$ORACLE_HOME/bin/lsnrctl stop
exit 0

[oracle@mkt bin]$ chmod u+x stoplsnr

4. create script status,start dan stop listener
[oracle@mkt ~]$ cd $ORACLE_HOME/bin
[oracle@mkt bin]$ vi listener11g
#!/bin/sh
#
# chkconfig: 345 51 49
# description: startup and shutdown the Oracle 11g listener
#
echo “Oracle 11g listener start/stop/status”
ORA_OWNER=oracle
ORA_BASE=/u01/app/oracle
ORA_HOME=$ORA_BASE/product/11.1.0/db_1

case “$1″ in
’start’)
# Start the listener
echo -n “Starting the Listener for 11g: “
su – $ORA_OWNER -c $ORA_HOME/bin/startlsnr
echo
;;

’stop’)
# Stop the listener
echo -n “Shutting down Listener for 11g: “
su – $ORA_OWNER -c $ORA_HOME/bin/stoplsnr
echo
;;

’status’)
# Status the listener
echo -n “Status Listener for 11g: “
su – $ORA_OWNER -c $ORA_HOME/bin/statuslsnr
echo
;;

‘restart’)
# Restart the Oracle databases:
echo -n “Restarting Listener for 11g:”
$0 stop
$0 start
echo
;;
*)

echo “Usage: listener11g [ status | start | stop | restart }"
exit 1
esac
exit 0

[oracle@ubs bin]$ chmod u+x listener11g

4. copy script listener11g to /etc/rc.d/init.d/
[oracle@mkt bin]$ su – root
Password:
[root@mkt ~]# cp /u01/app/oracle/product/11.1.0/db_1/bin/listener11g /etc/rc.d/init.d/
[root@mkt ~]# chmod 700 /etc/rc.d/init.d/listener11g

5. test script listener11g login as root
[root@mkt ~]# cd /etc/rc.d/init.d
[root@mkt init.d]# ./listener11g
Oracle 11g listener start/stop/status
Usage: listener11g [ status | start | stop | restart }

[root@mkt init.d]# ./listener11g status
Oracle 11g listener start/stop/status
Status Listener for 11g:
LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 09-DEC-2008 14:41:00
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mkt.localdomain)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 – Production
Start Date 09-DEC-2008 07:55:38
Uptime 0 days 6 hr. 45 min. 22 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/mkt/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mkt.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary…
Service “mkt” has 1 instance(s).
Instance “mkt”, status READY, has 1 handler(s) for this service…
Service “mktXDB” has 1 instance(s).
Instance “mkt”, status READY, has 1 handler(s) for this service…
Service “mkt_XPT” has 1 instance(s).
Instance “mkt”, status READY, has 1 handler(s) for this service…
The command completed successfully

[root@mkt init.d]# ./listener11g restart
Oracle 11g listener start/stop/status
Restarting Listener for 11g:Oracle 11g listener start/stop/status
Shutting down Listener for 11g:
LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 09-DEC-2008 14:42:02

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mkt.localdomain)(PORT=1521)))
The command completed successfully

Oracle 11g listener start/stop/status
Starting the Listener for 11g:
LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 09-DEC-2008 14:42:07

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 11.1.0.6.0 – Production
System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/mkt/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mkt.localdomain)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mkt.localdomain)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 – Production
Start Date 09-DEC-2008 14:42:07
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/mkt/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mkt.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

6. chkconfig script listener11g
[root@mkt init.d]# /sbin/chkconfig –add listener11g
[root@mkt init.d]# /sbin/chkconfig –list listener11g
listener11g 0:off 1:off 2:off 3:on 4:on 5:on 6:off
[root@mkt init.d]# /sbin/chkconfig listener11g on