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]$ |
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 |
All times are GMT -5. The time now is 09:39 AM. |