Forum OpenACS Q&A: Oracle question

Collapse
Posted by Luis Garcia on
I want to know in what port my Oracle database is listening. I checked the listener.ora file and it says 1521 and 2481. However when I do:
telnet local 1521
I get a refused connection.
I know that in PostgreSQL first I have to turn on the IP socket connection for the server, and authorize access via the IP Socket for it to work. But I don't know how it is for Oracle... (first timer with Oracle :) )
Any help is appreciated.
Thanks!
Collapse
2: Re: Oracle question (response to 1)
Posted by Bruno Mattarollo on

If you have set up Oracle as per the instructions (look at Andrew Piskorski's one for example, his instructions are excellent!) then you should have configured the listener to start on boot up, right? Make sure the listener is running... in redhat you could do something like (if your startup script is called listener8i for example):

/etc/rc.d/init.d/listener8i start
Another way to see if those ports are being binded is to do something like:
netstat -an
Again I know it works on Linux/MacOS X, don't know about other OS, and look for those ports you mention.

Just my 2 cents

Collapse
3: Re: Oracle question (response to 1)
Posted by Alfred Werner on
As the oracle user you can start the listener from the command line -
% lsnrctl start
and get status
% lsnrctl stat

It should alert you to problems in the config.