Re: Newbie has TNS listener problem

"IKerr." <i.b.kerr.n.o-spam_at_leeds.ac.uk> wrote in message news:<OgNda.4060$Gk6.25313_at_newsfep4-glfd.server.ntli.net>...

I see no service of the form "OracleService%ORACLE_SID%" started.

you need to :
1. re-create the service that starts the instance.

C:\> oradim -new -sid <mysid> -intpwd <mypwd> -startmode a -pfile d:\oracle\admin\<mydb>\pfile\init<mysid>.ora -timeout 300

or set the existing service to start the instance automatically

C:\> oradim -edit -sid <mysid> -startmode a (type oradim at at command prompt to see the help page).

2. use an explicit ip address in the listener.ora, as with 2 nics with 2 ips, the listener will listen on both IPs (a netstat -n will confirm this).

hth.

Paul

> Hi,
>
> thanks for the responses. Could this be something to do with the network
> setup of this machine ? I have 2 NIC's one with a hardcoded IP for a lan
> and one with dhcp assigned IP to which a cable modem is connected - it is
> this IP that is showing up in the logs - I don't understand why. if I use
> the host name of this PC that resolves to the IP of the nic connected to the
> cable modem. Oracle is installed on this machine and acts as client &
> server - it is just used for development & testing - it is not a production
> machine.
>
> As to the various suggestions:
>
> I have changed the (NTS) to () - no joy.
>
> Net manager has the SID field greyed out and there is no entry there. In
> the advanced tab there are no entries for Instance Name etc - in fact the
> only field which has anything is Global Database Name - which has the
> correct entry.
>
> I get this when I set "trace 2" in lsnrctl (in listener.trc):
> ntt2err: soc 392 error - operation=5, ntresnt[0]=517, ntresnt[1]=54,
> ntresnt[2]=0
> nserror: nsres: id=2, op=68, ns=12537, ns2=12560; nt[0]=507, nt[1]=0,
> nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
>
> >How are you starting up the instance's service ( the one ORADIM built)
> ...Manually or as an automatic service...
> >After the service starts ( does it actually start? ), do you set your
> ORACLE_SID before connecting to run the startup
> >commands?
> >When are the errors generated?
>
> I don't really understand these questions: I am a newbie ;-)
>
> what service are you referring to - the lsnrctl which I think is the TNS
> listener ? I am manually starting this prior to trying to start the db
> through the enterprise manager console (standalone). I am trying to start
> the db up with the enterprise manager console (standalone) and trying to log
> on as sysdba
>
> The services in the windows control panel are listed:
> OracleDEFAULT_HOME services:
> Agent Automatic (A) Started
> ClientCache Manual (M)
> HTTPServer A
> PagingServer M
> SNMPPeerEncapsulator M
> SNMPPeerMasterAgent M
> TNSListener A Started
> MTSRecoveryService A Started
>
> OracleNew_Home services
> Agent A
> ClientCache M
>
> iain
Received on Tue Mar 18 2003 - 20:24:20 CST