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