Re: Connecting to Oracle 10g on Linux

>
> [Quoted]
> 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 Received on Sat May 29 2004 - 19:41:38 CEST