Oracle Listener

[YesEm]

Hi
when trying to connect oracle 6i to 8i on the same machine, i'm getting this error message:

ORA-12224:TNS: no listener

i think i have to turn the listener on.

How can i check the status of the listener?
How can i turn it on?

i'm running Win98.

thank you

[antares686]

Make sure you have a proper connection definition. The way to test is to open a command window and type (depending on client version)

tnsping80 oracleaddress

or

tnsping oracleaddress

if it doesn't return an answer then use NET8 Configuration assisitant to define an item.

[satscom]

Hi


If Oracle 8i and reports 6i if you install in the same machine than no need of Tnsping .. You better check all the instalations is proper if yes then start the listner and then it will connect.

[YesEm]

Originally posted by satscom
then start the listner and then it will connect.

the problem was that i didn't know how to start the listener in win98 manually.

here is what can be done to automate it.
in registery, change the value of HKEY_LOCAL_MACHINE\Software\ORACLE\HOME0\LISTENER_STARTUP from "NOAUTO" to "AUTO".

[YesEm]

i have another question.

in form builder, i'm trying to check if the textbox is empty. how do i do that???
it should be something very easy, but this doesn't work

if (:block.item = '') then
....

[adel_hussam]

U Can Check If The Current Text Item Is Null By The Folowing

If :text_item_name Is Null Then
Alert_message:=show_alert('null_value');
Raise Form_trigger_failure;
.....

[technoroj]

ORA-12224: TNS:no listener

The connection request could not be completed because the listener is not running.

Ensure that the supplied destination address matches one of the addresses used by the listener - compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by way of an Interchange). Start the listener on the remote machine.