dear oracle specialists i installed oracle 11g r2 under RedHat 6.3 linux after successfull installation and automating db start
cannot automate listener start up however able to start it mannually since i am new bi as well to oracle so as to
linux scripting may help me to find the mistake
----------------------------
| oracle | 2918 0.0 0.4 1984168 18440 ? | Ss 06:33 0:00 ora_pmon_ice |
| oracle | 2920 0.3 0.3 1982056 15308 ? | Ss 06:33 0:00 ora_vktm_ice |
| oracle | 2924 0.0 0.3 1982056 15392 ? | Ss 06:33 0:00 ora_gen0_ice |
| oracle | 2926 0.0 0.3 1982056 15248 ? | Ss 06:33 0:00 ora_diag_ice |
| oracle | 2928 0.0 0.5 1982080 23492 ? | Ss 06:33 0:00 ora_dbrm_ice |
| oracle | 2930 0.0 0.3 1982056 15464 ? | Ss 06:33 0:00 ora_psp0_ice |
| oracle | 2932 0.0 0.4 1982568 19000 ? | Ss 06:33 0:00 ora_dia0_ice |
| oracle | 2934 1.6 0.9 1982056 39228 ? | Ss 06:33 0:03 ora_mman_ice |
| oracle | 2936 0.0 0.5 1987812 22012 ? | Ss 06:33 0:00 ora_dbw0_ice |
| oracle | 2938 0.0 0.5 1997608 23436 ? | Ss 06:33 0:00 ora_lgwr_ice |
| oracle | 2940 0.0 0.4 1982568 18356 ? | Ss 06:33 0:00 ora_ckpt_ice |
| oracle | 2942 0.0 0.7 1982616 34412 ? | Ss 06:33 0:00 ora_smon_ice |
| oracle | 2944 0.0 0.5 1982576 22268 ? | Ss 06:33 0:00 ora_reco_ice |
| oracle | 2946 0.2 1.4 1987896 64636 ? | Ss 06:33 0:00 ora_mmon_ice |
| oracle | 2948 0.0 0.4 1982056 20340 ? | Ss 06:33 0:00 ora_mmnl_ice |
| oracle | 2950 0.0 0.3 1983956 15356 ? | Ss 06:33 0:00 ora_d000_ice |
| oracle | 2952 0.0 0.3 1983120 14520 ? | Ss 06:33 0:00 ora_s000_ice |
| oracle | 2994 0.0 0.3 1982056 17344 ? | Ss 06:33 0:00 ora_qmnc_ice |
| oracle | 3205 0.1 1.2 1988764 54972 ? | Ss 06:33 0:00 ora_cjq0_ice |
| oracle | 3207 0.0 0.7 1983640 31268 ? | Ss 06:33 0:00 ora_q000_ice |
| oracle | 3209 0.0 0.7 1985556 32068 ? | Ss 06:33 0:00 ora_q001_ice |
| oracle | 3269 1.0 0.6 1983632 27092 ? | Ss 06:36 0:00 ora_j000_ice |
| oracle | 3271 0.0 0.3 1982052 15032 ? | Ss 06:36 0:00 ora_j001_ice |
here is my database looks like after automatic loads of an operating system after issuing
ps aux command
and here is my listener after issuing ./lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2013 06:42:43
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ICELANDLOCAL.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
---------------------------------------------------
enviroment variables .bash_profile
export PATH
umask 022
export TMPDIR=/tmp
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.1/dbhome_1
export ORACLE_HOME_LISTNER=$ORACLE_BASE/product/11.2.1/dbhome_1
export ORACLE_HOME_LISTNER=$ORACLE_HOME
export TNS_ADMIN=ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=ice
and my startup script dbora from oracle
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.
ORA_HOME=/u01/app/oracle/product/11.2.1/dbhome_1
ORA_OWNER=oracle
if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"
exit
fi
case "$1" in
'start')
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start LISTENER"
su $ORA_OWNER -c $ORA_HOME/bin/dbstart $ORA_HOME
touch /var/lock/subsys/dbora
;;
'stop')
# Stop the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su $ORA_OWNER -c $ORA_HOME/bin/dbshut $ORA_HOME
su $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop LISTENER"
rm -f /var/lock/subsys/dbora
;;
esac
any suggestions or help would be appricieated
thanks in advance