On Jun 20, 4:30 pm, sybra..._at_hccnet.nl wrote:
> On Wed, 20 Jun 2007 20:34:34 -0000,cptkirkh<k..._at_scic.com> wrote:
> >On Jun 20, 3:28 pm, DA Morgan <damor..._at_psoug.org> wrote:
> >> cptkirkhwrote:
> >> > On Jun 20, 2:09 pm, sybra..._at_hccnet.nl wrote:
> >> >> On Wed, 20 Jun 2007 18:14:47 -0000,cptkirkh<k..._at_scic.com> wrote:
> >> >>> I did but it gives me the error that "Could not create listener"
> >> >> Usually such message signify there is further information in an
> >> >> associated log file, in this case -obviously- listener.log. Did you
> >> >> look into it? If you didn't please do, and post the results.
>
> >> >> --
> >> >> Sybrand Bakker
> >> >> Senior Oracle DBA
>
> >> > I managed to get the service to start. I deleted the service from
> >> > windows and then deleted the listener.ora and then recreated the
> >> > listener. Now when i try to connect this is what i get in the
> >> > listener log file.
> >> > 20-JUN-2007 14:55:15 * (CONNECT_DATA=(SERVICE_NAME=porky)
> >> > (CID=(PROGRAM=F:\oracle\product\10.1.0\Db_1\jdk\jre\bin\java.exe)
> >> > (HOST=DAFFY)(USER=servop))) * (ADDRESS=(PROTOCOL=tcp)
> >> > (HOST=192.168.1.55)(PORT=1390)) * establish * porky * 12500
> >> > TNS-12500: TNS:listener failed to start a dedicated server process
> >> > TNS-12560: TNS:protocol adapter error
> >> > TNS-00530: Protocol adapter error
>
> >> Define "deleted the service from windows" ... what did you do?
>
> >> Define "recreated the listener" ... what did you do?
> >> --
> >> Daniel A. Morgan
> >> University of Washington
> >> damor..._at_x.washington.edu (replace x with u to respond)
> >> Puget Sound Oracle Users Groupwww.psoug.org-Hide quoted text -
>
> >> - Show quoted text -
>
> >I removed the service for the listener from the windows registry.
> >Then I user the net config asst. to create a new listener.
>
> Which was clearly not what I advised and also utterly stupid.
> But I agree it is the common Mickeysoft troubleshoot method: first
> ruin everything and then start from 0.
> Just because reading manuals is asked too much.
>
> --
> Sybrand Bakker
> Senior Oracle DBA- Hide quoted text -
>
> - Show quoted text -
Sybrand I looked up the problem in the groups and found a similar
problem where the person had to remove the listener file and create
the listener again. that is why i did what i did. I didn't just
mickeysoft it I actually realized the problem was that the listener
was associated with a previous install. That problem was fixed. I
did read the manuals and
I did look up the problem on metalink. I also ask question in this
forum. I was taught to get as many viewpoints to a problem before i
decide what to do. If you don't want to answer or help then don't.
Yes i am learning and i learn by reading and then doing to get a
better understanding. Sometimes mistakes happen along the way and
that is how you learn.
Received on Wed Jun 20 2007 - 16:50:36 CDT
