MySQL Database

Check where your TNS_ADMIN is pointing if you have set any

echo $TNS_ADMIN

If not set or looking at the wrong place then

TNS_ADMIN=/u01/app/oracle/product/10.1.0/db_1/network/admin
export TNS_ADMIN

Do you have an activated firewall? (Because of this mysterious Linux Error: 111: Connection refused)

Thx for the feedback; however after defining TNS_ADMIN and turning of the firewall I am still getting the message errors. Any other suggestions?

[oracle@emerson ~]$ ls $ORACLE_HOME
admin emerson.clearbean.com_dev1 ldap oraInst.loc sqlj
assistants flash_recovery_area lib ord sqlplus
bin has md oui srvm
cdata hs mesg owm sysman
cfgtoollogs install mgw perl uix
config install.platform network plsql ultrasearch
css inventory nls precomp wwg
ctx javavm oc4j racg xdk
dbs jdbc olap rdbms
demo jdk OPatch relnotes
diagnostics jlib opmn root.sh
dm jre oracore slax
[oracle@emerson ~]$ ls $TNS_ADMIN
listener.ora samples sqlnet.ora tnsnames.ora.orig
listener.ora.orig shrept.lst tnsnames.ora
[oracle@emerson ~]$ lsnrctl stop

LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 07-OCT-2005 22:43:44

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

Message 1053 not found; No message file for product=network, facility=TNSMessage 1052 not found; No message file for product=network, facility=TNS[oracle@emerson ~]$ lsnrctl start

LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 07-OCT-2005 22:43:51

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

Message 1070 not found; No message file for product=network, facility=TNSTNSLSNR for Linux: Version 10.1.0.2.0 - Production
Message 459 not found; No message file for product=network, facility=NL
Message 279 not found; No message file for product=network, facility=NL
Message 1073 not found; No message file for product=network, facility=TNSMessage 1073 not found; No message file for product=network, facility=TNS
Message 1053 not found; No message file for product=network, facility=TNSMessage 1020 not found; No message file for product=network, facility=TNSMessage 1021 not found; No message file for product=network, facility=TNSMessage 1022 not found; No message file for product=network, facility=TNSMessage 1023 not found; No message file for product=network, facility=TNSMessage 1026 not found; No message file for product=network, facility=TNSMessage 1034 not found; No message file for product=network, facility=TNSMessage 1024 not found; No message file for product=network, facility=TNSMessage 1025 not found; No message file for product=network, facility=TNSMessage 1040 not found; No message file for product=network, facility=TNSMessage 1033 not found; No message file for product=network, facility=TNSMessage 1028 not found; No message file for product=network, facility=TNSMessage 1415 not found; No message file for product=network, facility=TNS Message 1050 not found; No message file for product=network, facility=TNS
Message 1050 not found; No message file for product=network, facility=TNS
Message 1029 not found; No message file for product=network, facility=TNSMessage 1411 not found; No message file for product=network, facility=TNS
Message 1408 not found; No message file for product=network, facility=TNS
Message 1052 not found; No message file for product=network, facility=TNS[oracle@emerson ~]$

I deleted my listner log and tried to restart the listener. Here are the log contents:

[oracle@emerson log]$ cat listener.log

TNSLSNR for Linux: Version 10.1.0.2.0 - Production on 07-OCT-2005 22:56:31

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

Message 459 not found; No message file for product=network, facility=NL
Message 279 not found; No message file for product=network, facility=NL
Message 509 not found; No message file for product=network, facility=NL
Message 510 not found; No message file for product=network, facility=NL

Message 1081 not found; No message file for product=network, facility=TNSMessage 1073 not found; No message file for product=network, facility=TNSMessage 1073 not found; No message file for product=network, facility=TNSMessage 1097 not found; No message file for product=network, facility=TNS
Message 1095 not found; No message file for product=network, facility=TNS
[oracle@emerson log]$

Just an additional note.... the database is functional. I can access it locally and use oci calls with PHP. Just do not understand what I keep getting the message errors.

Can you now use the listener? I searched for the message numbers - from your last listener log - in the error messages manual and found these messages are informational messages, not really error messages. For example
TNS-01081: Started with pid=string
Cause: Listener starting message.
Action: None.
or
TNS-01097: TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
Cause: Listener logging message.
Action: None.

It seems the sqlnet message files are missing from your installation for whatever reason.

Are your ORACLE_HOME and PATH environment variables pointing to the same oracle software directory?
what happens when you start the listener after you do this:

$ export PATH=${ORACLE_HOME}/bin:${PATH}
$ lsnrctl start

?

I checked and $ORACLE_HOME/bin is in my PATH. Thx for the suggestion.

It may be that either you had some issues with your installation or that your environment is not setup correctly for the ORACLE_HOME that you are using. Did you check your installer log files to see if there were any errors/warnings?

See below, if for instance, I had my Oracle Home not set correctly, I get similar errors as you are getting:

$ lsnrctl
 
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-OCT-2005 21:32:54
 
Copyright (c) 1991, 2005, Oracle.  All rights reserved.
 
Welcome to LSNRCTL, type "help" for information.
 
LSNRCTL> exit
$
$ unset ORACLE_HOME
$
$ lsnrctl
 
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-OCT-2005 21:33:05
 
Copyright (c) 1991, 2005, Oracle.  All rights reserved.
 
Message 850 not found; No message file for product=network, facility=NL
LSNRCTL>

Dear sir
I found this stupid erro!!
if u r copy a oracle auto-start script below some where like me!
check this two command !!
Here is the demon($ORA_OWNR)

su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl start"
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart

su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl stop"
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut

#!/bin/sh
# oracle
# 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

ORACLE_BASE=/opt/oracle
ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1
ORA_OWNER=oracle

case "$1" in
'start')


# Start the Oracle databases:
# The following command assumes that the oracle login will not prompt the

# user for any values
echo -n "Starting Oracle: "
su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl start"
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
touch /var/lock/subsys/oracle
echo
;;

'stop')

# Stop the Oracle databases:
# The following command assumes that the oracle login will not prompt the

# user for any values
echo -n "Shutting down Oracle: "
su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl stop"
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
rm -f /var/lock/subsys/oracle
echo
;;

'restart')

# Restart the Oracle databases:
echo -n "Retarting Oracle: "
$0 stop
$0 start
echo
;;

*)
echo "Usage: oracle { start | stop | restart }"
exit 1

esac
exit 0

forget the previous script! i made mistake again!
the work one in my server!
#!/bin/sh
# oracle
# 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_BASE=/opt/oracle
ORA_HOME=$ORA_BASE/oracle/product/10.2.0/db_1
ORA_OWNER=oracle

case "$1" in
'start')


# Start the Oracle databases:
# The following command assumes that the oracle login will not prompt the

# user for any values
echo -n "Starting Oracle: "
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
touch /var/lock/subsys/oracle
echo
;;

'stop')

# Stop the Oracle databases:
# The following command assumes that the oracle login will not prompt the

# user for any values
echo -n "Shutting down Oracle: "
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
rm -f /var/lock/subsys/oracle
echo
;;

'restart')

# Restart the Oracle databases:
echo -n "Retarting Oracle: "
$0 stop
$0 start
echo
;;

*)
echo "Usage: oracle { start | stop | restart }"
exit 1

esac
exit 0

If you already set ORACLE_HOME.
Please try to set ORACLE_HOME_LISTNER as following before start listener:

ORACLE_HOME_LISTNER=$ORACLE_HOME
export ORACLE_HOME_LISTNER

Message was edited by:
user614375

Please check my post in

http://kishantha.blogspot.com/2009/02/tns-listener-crashes-with-error.html

the error is simply because the ORACLE_HOME environment variable or registry key got over written by some other application installed or is wrong.

The ORACLE_HOME is not the bin directory. It is the parent of the bin directory.
For instance, ORACLE_HOME=/d01/oracle/VIS/db/tech_st/10.2.0
is the ORACLE_HOME, not ORACLE_HOME=/d01/oracle/VIS/db/tech_st/10.2.0/bin

I added a oracle bin path (/oracle/product/10.2.0/db_1/bin), and worked for me:

export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/product/10.2.0/db_1
export ORACLE_SID=demo
export PATH=/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/oracle/product/10.2.0/db_1/bin

check with:
env | grep ORA
env | grep PATH

Not that there is anything wrong with it, but I am continually amazed at the number of people whose very first post is a reply to a thread that has been dormant for a year or more. What were you doing immediately after joining the forum to even find the thread?

;-)