From: "Vladimir M. Zakharychev" Newsgroups: comp.databases.oracle.server Subject: Re: gui tool for oracle.. what is client when installation? Date: Mon, 9 Sep 2002 14:55:22 +0400 Organization: N-Networks Lines: 86 Message-ID: References: NNTP-Posting-Host: 212.233.81.44 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Trace: babylon.agtel.net 1031568940 28229 212.233.81.44 (9 Sep 2002 10:55:40 GMT) X-Complaints-To: usenet@babylon.agtel.net NNTP-Posting-Date: 9 Sep 2002 10:55:40 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 1. When you installed server, client was automatically installed, too. 2. 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" wrote in message news:alhjof$udm$1@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@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@beautifulmind oracle]$