LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 09-09-2002, 03:57 AM   #1
doublefailure
Member
 
Registered: Mar 2002
Location: ma
Distribution: slackware
Posts: 747

Rep: Reputation: 30
oracle client installation?


hi..
oracle newbie here..

i'm running mand8.2 and oracle 9i,(installation is straight forward)

me and my friends want a nice gui tool ..
tora looks like one we are looking for
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 'client'?
and then how can i install it? i have to run ./runinstaller again? (meaning i need Disk1/2/3
again --)

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..

well, now my friends ssh to my comp and do sqlplus..
if i have 'tora' installed, they wouldn't need to ssh and directly connect to my oracle db?
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]$
 
Old 09-10-2002, 01:52 AM   #2
KayJay
Member
 
Registered: Mar 2002
Location: dev/null
Distribution: redhat, mandrake
Posts: 218

Rep: Reputation: 30
the only client u have in oracle is SQL> _
that's all u can get. it's not SQL server or something.. so no fancy stuff, just a SQL prompt.
same as in Oracle in windows
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Do I require Oracle 9i Client? wasil Linux - Software 0 04-15-2005 03:23 AM
oracle 8i client parisjackson Linux - Enterprise 0 12-17-2004 02:31 PM
Oracle client on Slack-9.1-10 mago Linux - Software 0 08-01-2004 05:09 PM
Some newbie questions related to Oracle client installation. Please help! deanbrown3d Linux - Newbie 7 06-29-2004 01:23 PM
Oracle 9i client with Oracle 8i server ganninu Programming 1 02-19-2004 05:35 PM


All times are GMT -5. The time now is 07:45 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration