Re: Connecting to Oracle 10g on Linux

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Sun, 30 May 2004 19:38:11 GMT
Message-ID: <DKquc.1819$yX6.1653_at_newssvr24.news.prodigy.com>


Eraser wrote:

>>
>>make sure the oracle listener was properly configured and and started...
>> find the listener.ora under $ORACLE_HOME/network/admin and make the
>>appropriate edits.
>>
>>ps -ef |grep lsnr
>>or
>>netstat -a |grep 1521
>>should tell you whether or not it started
>>
>>a simple google search for "oracle 10g lsnrtcl" yields:
>>
>> From << http://www.togaware.com/linux/survivor/Starting_Stopping.shtml
>> >> for TOGA on Debian... "(You may need to change the listener.ora to
>>have the IP of the box, as opposed to the hostname, otherwise clients
>>machines may not be able to connect.)"
>>
>>Michael Austin

> 
> 
> Thanks for the information, based on your pointers I was able to 
> get SquirrelSQL to connect to Oracle.
> 
> In case you hadn't noticed, I'm nowhere near been a DBA,
> I had never installed Oracle before and didn't even know about
> lsnrtcl.  I'm just trying to get up to speed on PL/SQL and no
> better way than to have my own Oracle instance running at home
> to be able to practice.
> 
> Thanks for the pointers.
> 
> Eraser
> 

glad to help...

Michael Austin Received on Sun May 30 2004 - 21:38:11 CEST

Original text of this message