listener.ora, tnsnames.ora and starting listener on Linux
556172Dec 17 2007 — edited Jan 2 2008Hi there,
I've installed Oracle 10 db and client on SuSE Linux for the first time. But I'm having trouble connecting to my database instance. I've posted some simple files below. Please tell me if everything looks alright. When I try to connect from client, I get message: ORA-12541: TNS: no listener
I haven't figured out how to start the listener. It was easy in Windows, but I don't see the listener service in YaST's System Services module. I've tried
ps -ef | grep ora
but it didn't produce anything that looks like a listener service. I also tried:
myserver:~ # lsnrctl start
-bash: lsnrctl: command not found
Here are the files. Please tell me what you think. Thank you!
-----------------
# tnsnames.ora Network Configuration File: /opt/oracle/product/10.2/client_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
MYDB_MYSERVER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = mydb)
(SERVER = DEDICATED)
)
)
----------------
----------------
listener.ora
/opt/oracle/product/10.2/db_1/network/admin/listener.ora
LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
# SID_LIST_<lsnr>
# List of services the listener knows about and can connect
# clients to. There is no default. See the Net8 Administrator's
# Guide for more information.
#
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
#BEQUEATH CONFIG
(GLOBAL_DBNAME=mydb.mydomain)
(SID_NAME=mydb)
(ORACLE_HOME=/opt/oracle/product/10.2)
#PRESPAWN CONFIG
(PRESPAWN_MAX=20)
(PRESPAWN_LIST=
(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
)
)
)
----------------------