Re: How do I recreate the NT Oracle Services ?

Rock,

Try reinstalling your Oracle software again. It has worked for me when errors of this type occur.

Mark

Radian Intl

In article <83m24f$djc$1_at_nnrp1.deja.com>,   rock_cogar_at_my-deja.com wrote:
> Well, I discovered the command line parameters that were needed to
> recreate the Oracle 8.1.5 service on my NT 4.0 sp5 server. That was
the
> easy part, although I am not sure that the database is "good".
>
> Now I cannot create a listener service or even start the listener from
> the LSNRCTL command line because of an apparent TCP/IP protocol error.
> I get the following errors from LSNRCTL:
>
> ORA-1058
> ORA-12560
> ORA-530
>
> I think it is the ORA-12560 that is the real error. Here is the text
> for it:
>
> "ORA-12560: TNS:protocol adapter error
> Cause: A generic protocol adapter error occurred.
>
> Action: Check addresses used for proper protocol specification. Before
> reporting this error, look at the error stack and check for lower
level
> transport errors. For further details, turn on tracing and reexecute
> the operation. Turn off tracing when the operation is complete."
>
> Now, I have no clue what I am supposed to do now. After all, how could
> I turn on tracing without a listener service?
>
> So, I tried to to do use EXP to export the only schema on the "lost"
> database that is not mirrored on different instances on different
> machines. At least then I would be able to reinstall Ora 8.1.5 and
> import the schema of interest. But, the same ORA-12560 keeps EXP from
> accessing the database !
>
> QUESTION: Does anyone out there have an idea how I can:
>
> 1. Access my database without a listener or,
> 2. Know some way that I can start my listener ?
>
> Thanks,
> Rock Cogar.
> Radian International LLC.
> Oak Ridge, TN. USA.
>
> In article <83lnk9$5h0$1_at_nnrp1.deja.com>,
> rock_cogar_at_my-deja.com wrote:
> > Hi,
> >
> > One of our main production NT servers got really screwed up while I
> was
> > doing work for another office. What I have is that all the Oracle
> > services are pointed to the wrong (zipped up!) version of Oracle
> server
> > & listener. So my question is:
> >
> > What is the (magic) command line syntax to recreate the oracle
> services
> > (one instance + listener) on my NT server ?
> >
> > Thanks,
> > Rock Cogar.
> > Radian International, Oak Ridge, TN. USA.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Mark

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 20 1999 - 14:23:54 CST