From: Carlos Oliveira <carlos.a.oliveiraNOSPAM@vizzavi.pt>
Newsgroups: comp.databases.oracle.server
Subject: Re: gui tool for oracle.. what is client when installation?
Date: Mon, 9 Sep 2002 17:57:11 +0100
Lines: 80
Message-ID: <20020909175711.23ba9b49.carlos.a.oliveiraNOSPAM@vizzavi.pt>
References: <alhjof$udm$1@newsreader.mailgate.org>
NNTP-Posting-Host: kdata3.fis.fc.ul.pt (194.117.40.68)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Trace: fu-berlin.de 1031590591 61369159 194.117.40.68 (16 [154949])
X-Newsreader: Sylpheed version 0.8.1claws (GTK+ 1.2.10; )


Try using phpOracleAdmin http://phporacleadmin.org/
It's a toolr that let's you see and manage your databases from a web browser, made in PHP. 
You must have Apache and PHP4 with oci8 module installed.
That way, your friends can navigate throw your database connecting to your page

Cheers

Carlos oliveira


On Mon, 09 Sep 2002 15:01:42 +0000
eugene kim <eugene1977@hotmail.com> wrote:

> 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]$