- When you installed server, client was automatically installed, too.
- Listener is the component that services connections to the database.
Unless you have a listener running, you will be unable to connect
to the db. To correct this, you put a script in your /etc/rc3.d
that sets up Oracle environment (ORACLE_HOME and ORACLE_SID
are usually sufficient) and then invokes lsnrctl start, and another one
into rc1.d or rc2.d, that invokes lsnrctl stop. To find out more about
init/shutdown process and scripts, read man pages on init.
hth.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"eugene kim" <eugene1977_at_hotmail.com> wrote in message news:alhjof$udm$1_at_newsreader.mailgate.org...
> hi..
> i'm running linux and oracle 9i,
>
> me and my friends want a nice gui tool ..
> i found tora is such a tool ..
> however it says i need to have oracle client installation..
>
> i remember i installed 'database' not client in install time.
>
> do i have to install this?
> and then how? i have to run ./runinstaller again? (meaning i need Disk1/2/3
> agian --)
>
> also i have related question or doubt about options that i gave during
> installation.
>
> listner doesn't run automatically when i startup oracle database?
> as u can see HOST=beautifulmind.something.org ( changed to something) and
> Service "mydb.beautifulmind.org"
> which doesn't look right..
> will this be a problem sometime? (well i don't know what listener is for)
> if so, how can i correct this..
>
> thank you very much
>
> [oracle_at_beautifulmind oracle]$ lsnrctl start
> LSNRCTL for Linux: Version 9.2.0.1.0 - Production on 09-SEP-2002 14:38:57
>
> Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
>
> Starting /usr/local/oracle/product/9.2.0/bin/tnslsnr: please wait...
>
> TNSLSNR for Linux: Version 9.2.0.1.0 - Production
> System parameter file is
> /usr/local/oracle/product/9.2.0/network/admin/listener.ora
> Log messages written to
> /usr/local/oracle/product/9.2.0/network/log/listener.log
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
> Listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=beautifulmind.something.org)(PORT=1521)))
>
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for Linux: Version 9.2.0.1.0 - Production
> Start Date 09-SEP-2002 14:38:58
> Uptime 0 days 0 hr. 0 min. 0 sec
> Trace Level off
> Security OFF
> SNMP OFF
> Listener Parameter File
> /usr/local/oracle/product/9.2.0/network/admin/listener.ora
> Listener Log File
> /usr/local/oracle/product/9.2.0/network/log/listener.log
> Listening Endpoints Summary...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
>
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=beautifulmind.something.org)(PORT=1521)))
> Services Summary...
> Service "PLSExtProc" has 1 instance(s).
> Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
> service...
> Service "mydb.beautifulmind.org" has 1 instance(s).
> Instance "test", status UNKNOWN, has 1 handler(s) for this service...
> The command completed successfully
> [oracle_at_beautifulmind oracle]$
Received on Mon Sep 09 2002 - 05:55:22 CDT
